ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADDITIONAL_APPROVER_IND	Determines if the approver was added as an additional approver to the workflow approval circulation.			CALCULATION	DECODE(FORCIRR_DATA_ORIGIN)
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
APPROVER_DATA_ORIGIN	Source system that created or updated the approver data.			FORCIRR	FORCIRR_DATA_ORIGIN
APPROVER_ID	User-defined or system generated one-up number of the workflow approver.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
APPROVER_NAME	Combination of the workflow approver's last, first, and middle initial into one value.			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			FORCIRS	FORCIRS_TYPE
APPROVER_UID	Personal identification number of the approver.			FORCIRR	FORCIRR_RECIPIENT_PIDM
APPROVER_WORKFLOW_ID	Unique identifier for the workflow ID of the person added to the approval workflow of the reimbursement.			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.			FTRBAUTH	DOC_CODE
AUTHORIZATION_DESC	Authorization request description.			FTRBAUTH	DESCRIPTION
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.			FTRRACIR	FTRBAUTH_ID
CIRCULATION_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.			FOBCIRH	FOBCIRH_ACTIVITY_DATE
CIRCULATION_BEGIN_DATE	Date and time that the circulation was started.			FOBCIRH	FOBCIRH_START_DATE
CIRCULATION_COMPLETE_DATE	Date and time that the circulation was completed.			FOBCIRH	FOBCIRH_COMPLETION_DATE
CIRCULATION_KEY	Unique internal identification number of the approval circulation record.			FTRRACIR	FOBCIRH_ID
CIRCULATION_NOTIFICATION_KEY	Unique internal identification number of the approval circulation notification record.			FORCIRN	ID
CIRCULATION_ORDER	Order of this step in the overall circulation.			FORCIRS	FORCIRS_ORDER
CIRCULATION_RECIPIENT_KEY	Unique internal identification number of the approval circulation recipient record.			FORCIRR	ID
CIRCULATION_STATUS	Current status of the circulation. Statuses are IN PROCESS, COMPLETED, and AVAILABLE.			FOBCIRH	FOBCIRH_STATUS
CIRCULATION_STEP_KEY	Unique internal identification number of the approval circulation step record.			FORCIRS	ID
CIRCULATION_USER_ID	Unique identification code of the user who entered or last touched the transaction.			FOBCIRH	FOBCIRH_USER_ID
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			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.			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.			FUNCTION	MEKFUNC.F_NOTIFICATION_CHANGE_HOURS
NOTIFICATION_COMMENT	Free-form approver comment.			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.			FORCIRN	FORCIRN_STATUS
NOTIFICATION_STATUS_DATE	Date the status of the notification was created from system activity.			FORCIRN	FORCIRN_STATUS_DATE
OWNER_ENTITY_IND	Indicates whether the expense owner is a person or an organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_ID	User-defined or system generated one-up number of the expense owner.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_NAME	Combination of the person's last, first, and middle initial into one value.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OWNER_UID	Unique identification of the person who owns expenses in the authorization.			FTRBAUTH	FTRBAUTH_OWNER_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			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.			FORCIRS	FORCIRS_COMPLETE_IND

Ver: 8.3