Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
CREATE_ASSIGNMENT_USER_UID
|
Personal identification number of the person who created the delegate assignment.
|
NUMBER(8)
|
FTORDLAS
|
USER_PIDM
|
CURRENT_DATE
|
This is a the system current date (sysdate).
|
DATE
|
NA
|
SYSDATE
|
DELEGATE_ASSIGN_ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
TIMESTAMP(6)
|
FTORDLAS
|
ACTIVITY_DATE
|
DELEGATE_ASSIGN_DATA_ORIGIN
|
Source system that created or updated the data.
|
VARCHAR2(30)
|
FTORDLAS
|
DATA_ORIGIN
|
DELEGATE_ASSIGN_KEY
|
Unique internal identification number of the delegate assignment record.
|
NUMBER(19)
|
FTORDLAS
|
ID
|
DELEGATE_ASSIGN_USER_ID
|
Unique identification code of the user who entered or last touched the record.
|
VARCHAR2(30)
|
FTORDLAS
|
USER_ID
|
DELEGATE_KEY
|
Unique internal identification number of the delegate record.
|
NUMBER(19)
|
FTORDLAS
|
FTOBDLGT_ID
|
DELEGATE_TRAVELER_REVIEW_IND
|
Indicates delegate profile setup requires traveler to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N).
|
CHAR(1)
|
FTOBDLGT
|
BYPASS_TRAVELER_REVIEW_IND
|
DELEGATE_UID
|
Personal identification number of the delegate.
|
NUMBER(8)
|
FTOBDLGT
|
DELEGATE_PIDM
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
PERSON_UID
|
Personal identification number of the assigned expense report user.
|
NUMBER(8)
|
FTOBPROF
|
OWNER_PIDM
|
PROFILE_KEY
|
Unique internal identification number of the expense profile record for the assigned traveler.
|
NUMBER(19)
|
FTORDLAS
|
FTOBPROF_ID
|
TRAVELER_REVIEW_IND
|
Inidcates whether traveler does not need to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N). This might be the same as the delegate_traveler_review_ind or it may be an override.
|
CHAR(1)
|
FTORDLAS
|
BYPASS_TRAVELER_REVIEW_IND
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|