Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDITIONAL_APPROVER_IND	Determines if the approver was added as an additional approver to the workflow approval circulation.	VARCHAR2(1)	CALCULATION	DECODE(FORCIRR_DATA_ORIGIN)
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPROVER_DATA_ORIGIN	Source system that created or updated the approver data.	VARCHAR2(63)	FORCIRR	FORCIRR_DATA_ORIGIN
APPROVER_ID	User-defined or system generated one-up number of the workflow approver.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
APPROVER_NAME	Combination of the workflow approver's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
APPROVER_TYPE	Indicates if the step record represents a (P)erson or a (G)roup of recipients or (C)ompany.	VARCHAR2(63)	FORCIRS	FORCIRS_TYPE
APPROVER_UID	Personal identification number of the approver.	NUMBER	FORCIRR	FORCIRR_RECIPIENT_PIDM
APPROVER_WORKFLOW_ID	Unique identifier for the workflow ID of the person added to the approval workflow of the reimbursement.	VARCHAR2(255)	FORCIRR	FORCIRR_WORKFLOW_ID
AUTHORIZATION	System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq.	VARCHAR2(63)	FTRBAUTH	DOC_CODE
AUTHORIZATION_DESC	Authorization request description.	VARCHAR2(255)	FTRBAUTH	DESCRIPTION
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.	NUMBER	FTRRACIR	FTRBAUTH_ID
CIRCULATION_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FOBCIRH	FOBCIRH_ACTIVITY_DATE
CIRCULATION_BEGIN_DATE	Date and time that the circulation was started.	DATE	FOBCIRH	FOBCIRH_START_DATE
CIRCULATION_COMPLETE_DATE	Date and time that the circulation was completed.	DATE	FOBCIRH	FOBCIRH_COMPLETION_DATE
CIRCULATION_KEY	Unique internal identification number of the approval circulation record.	NUMBER	FTRRACIR	FOBCIRH_ID
CIRCULATION_NOTIFICATION_KEY	Unique internal identification number of the approval circulation notification record.	NUMBER	FORCIRN	ID
CIRCULATION_ORDER	Order of this step in the overall circulation.	NUMBER	FORCIRS	FORCIRS_ORDER
CIRCULATION_RECIPIENT_KEY	Unique internal identification number of the approval circulation recipient record.	NUMBER	FORCIRR	ID
CIRCULATION_STATUS	Current status of the circulation. Statuses are IN PROCESS, COMPLETED, and AVAILABLE.	VARCHAR2(63)	FOBCIRH	FOBCIRH_STATUS
CIRCULATION_STEP_KEY	Unique internal identification number of the approval circulation step record.	NUMBER	FORCIRS	ID
CIRCULATION_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FOBCIRH	FOBCIRH_USER_ID
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NOTIFICATION_CHANGE_HOURS	Amount of time in hours between the prior notification status date and this notification status date for the approval cycle.	NUMBER	FUNCTION	MEKFUNC.F_NOTIFICATION_CHANGE_HOURS
NOTIFICATION_CHANGE_HOURS_TOT	Amount of time in hours between the first established notification status date and this notification status date for the approval cycle.	NUMBER	FUNCTION	MEKFUNC.F_NOTIFICATION_CHANGE_HOURS
NOTIFICATION_COMMENT	Free-form approver comment.	VARCHAR2(4000)	FORCIRN	FORCIRN_COMMENT
NOTIFICATION_STATUS	Indicates what the notification represents. For example, NOTIFY = an email message was sent to the approver to approve this document. RETURN = the document was returned for correction. DENIED = the document request was denied and no further action is to be taken. APPROVED = the document was approved.	VARCHAR2(63)	FORCIRN	FORCIRN_STATUS
NOTIFICATION_STATUS_DATE	Date the status of the notification was created from system activity.	DATE	FORCIRN	FORCIRN_STATUS_DATE
OWNER_ENTITY_IND	Indicates whether the expense owner is a person or an organization.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_ID	User-defined or system generated one-up number of the expense owner.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_UID	Unique identification of the person who owns expenses in the authorization.	NUMBER	FTRBAUTH	FTRBAUTH_OWNER_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
STEP_COMPLETE_IND	Indicates if the routing step is complete or not. (Y)es the routing step is complete. (N)o, the routing step is not complete.	VARCHAR2(1)	FORCIRS	FORCIRS_COMPLETE_IND

Ver: 8.5