| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADDITIONAL_APPROVER_IND
 | 
Additional Approver Indicator 
 | 
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 Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
APPROVER_DATA_ORIGIN
 | 
Approver Data Origin 
 | 
Source system that created or updated the approver data.
 | 
VARCHAR2(63)
 | 
 
 | 
 FORCIRR
 
 | 
 FORCIRR_DATA_ORIGIN
 
 | 
| 
APPROVER_ID
 | 
Approver ID 
 | 
User-defined or system generated one-up number of the workflow approver.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
APPROVER_NAME
 | 
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
 | 
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
 | 
Approver UID 
 | 
Personal identification number of the approver.
 | 
NUMBER
 | 
 
 | 
 FORCIRR
 
 | 
 FORCIRR_RECIPIENT_PIDM
 
 | 
| 
APPROVER_WORKFLOW_ID
 | 
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
 | 
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 Description 
 | 
Authorization request description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTRBAUTH
 
 | 
 DESCRIPTION
 
 | 
| 
AUTHORIZATION_KEY
 | 
Authorization KEY 
 | 
Unique internal identification number of the authorization record.
 | 
NUMBER
 | 
 
 | 
 FTRRACIR
 
 | 
 FTRBAUTH_ID
 
 | 
| 
CIRCULATION_ACTIVITY_DATE
 | 
Circulation Activity Date 
 | 
Date information for this record in the table was entered or last updated.
 | 
DATE
 | 
 
 | 
 FOBCIRH
 
 | 
 FOBCIRH_ACTIVITY_DATE
 
 | 
| 
CIRCULATION_BEGIN_DATE
 | 
Circulation Begin Date 
 | 
Date and time that the circulation was started.
 | 
DATE
 | 
 
 | 
 FOBCIRH
 
 | 
 FOBCIRH_START_DATE
 
 | 
| 
CIRCULATION_COMPLETE_DATE
 | 
Circulation Completion Date 
 | 
Date and time that the circulation was completed.
 | 
DATE
 | 
 
 | 
 FOBCIRH
 
 | 
 FOBCIRH_COMPLETION_DATE
 
 | 
| 
CIRCULATION_KEY
 | 
Circulation KEY 
 | 
Unique internal identification number of the approval circulation record.
 | 
NUMBER
 | 
 
 | 
 FTRRACIR
 
 | 
 FOBCIRH_ID
 
 | 
| 
CIRCULATION_NOTIFICATION_KEY
 | 
Circulation Notification KEY 
 | 
Unique internal identification number of the approval circulation notification record.
 | 
NUMBER
 | 
 
 | 
 FORCIRN
 
 | 
 ID
 
 | 
| 
CIRCULATION_ORDER
 | 
Circulation Order 
 | 
Order of this step in the overall circulation.
 | 
NUMBER
 | 
 
 | 
 FORCIRS
 
 | 
 FORCIRS_ORDER
 
 | 
| 
CIRCULATION_RECIPIENT_KEY
 | 
Circulation Recipient KEY 
 | 
Unique internal identification number of the approval circulation recipient record.
 | 
NUMBER
 | 
 
 | 
 FORCIRR
 
 | 
 ID
 
 | 
| 
CIRCULATION_STATUS
 | 
Circulation Status 
 | 
Current status of the circulation.  Statuses are IN PROCESS, COMPLETED, and AVAILABLE.
 | 
VARCHAR2(63)
 | 
 
 | 
 FOBCIRH
 
 | 
 FOBCIRH_STATUS
 
 | 
| 
CIRCULATION_STEP_KEY
 | 
Circulation Step KEY 
 | 
Unique internal identification number of the approval circulation step record.
 | 
NUMBER
 | 
 
 | 
 FORCIRS
 
 | 
 ID
 
 | 
| 
CIRCULATION_USER_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
 | 
Multi Source 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
NOTIFICATION_CHANGE_HOURS
 | 
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
 | 
Notification Change Hours Total 
 | 
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
 | 
Notification Comment 
 | 
Free-form approver comment.
 | 
VARCHAR2(4000)
 | 
 
 | 
 FORCIRN
 
 | 
 FORCIRN_COMMENT
 
 | 
| 
NOTIFICATION_STATUS
 | 
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
 | 
Notification Status Date 
 | 
Date the status of the notification was created from system activity.
 | 
DATE
 | 
 
 | 
 FORCIRN
 
 | 
 FORCIRN_STATUS_DATE
 
 | 
| 
OWNER_ENTITY_IND
 | 
Owner Entity Indicator 
 | 
Indicates whether the expense owner is a person or an organization.
 | 
VARCHAR2(1)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
OWNER_ID
 | 
Owner ID 
 | 
User-defined or system generated one-up number of the expense owner.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
OWNER_NAME
 | 
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
 | 
Owner UID 
 | 
Unique identification of the person who owns expenses in the authorization.
 | 
NUMBER
 | 
 
 | 
 FTRBAUTH
 
 | 
 FTRBAUTH_OWNER_PIDM
 
 | 
| 
PROCESS_GROUP
 | 
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
 | 
Step Completion Indicator 
 | 
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
 
 |