_SvIncludePlusContent-_DP_Schema_Approvals_Jira

All data relating to connections between issues will be exported to approvals_<job_id>_<schema_version>_<timestamp>.csv CSV file. 

Field

Description

issue_id

Type: Number

Description: Unique ID of the issue. (foreign key)

Example: 10002

Schema: Version 2 and later

approval_name

Type: String

Description: Workflow stage where approval is required.

Example: Waiting for approval

Schema: Version 2 and later

approval_decision

Type: String

Description: Current state of the approval. Can be APPROVED, REJECTED, or empty.

Example: APPROVED

Schema: Version 2 and later

created_date

Type: Date

Description: UTC timezone date that this issue required approval (ISO string)

Example: 2020-11-05T14:44:57Z

Schema: Version 2 and later

completed_date

Type: Date

Description: UTC timezone date that the approval step was completed (ISO string)

Example: 2020-11-05T14:44:57Z

Schema: Version 2 and later

system_decided

Type: Boolean

Description: Indicates whether the approval decision was made by the system automatically (TRUE), or a user (FALSE).

Example: FALSE

Schema: Version 2 and later

approved_by_user_ids

Type: JSON array

Description: Unique identifiers of the users who approved the request.

Example: [11101, 10283]

Schema: Version 2 and later

rejected_by_user_ids

Type: JSON array

Description: Unique identifiers of the users who rejected the request.

Example: [11100, 10234]

Schema: Version 2 and later

other_approvers_user_ids

Type: JSON array

Description: Unique identifiers of the users who were listed as approvers but who did not approve or reject the request.

Example: [10000, 10001, 10023]

Schema: Version 2 and later

Last modified on Jan 31, 2025

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.