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
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	FTRRRCIR	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 reimbursement.	NUMBER	FTRBREMB	FTRBREMB_OWNER_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REIMBURSEMENT	System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.	VARCHAR2(63)	FTRBREMB	DOC_CODE
REIMBURSEMENT_DESC	Reimbursement request description.	VARCHAR2(255)	FTRBREMB	DESCRIPTION
REIMBURSEMENT_KEY	Unique internal identification number of the reimbursement record.	NUMBER	FTRRRCIR	FTRBREMB_ID
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: 9.1