Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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_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_UID	Approver UID	Personal identification number of the workflow approver who approves documents for this expense owner.	NUMBER		FTOBPROF	APPROVER_PIDM
DELEGATE_IND	Delegate Indicator	Indicates whether this profile is a delegate.	VARCHAR2(1)		FUNCTION	CASE WHEN EXISTS FTOBDLGT
DELEGATE_TRAVELER_REVIEW_IND	Delegate Traveler Review Indicator	Indicates 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).	VARCHAR2(1)		FTOBDLGT	BYPASS_TRAVELER_REVIEW_IND
DIRECT_DEPOSIT_IND	Direct Deposit Indicator	Determines if the address used indicates direct deposit. (Y)es, use direct deposit, (N)o, create check.	VARCHAR2(1)		FUNCTION	GOKODSF.F_DIRECT_DEPOSIT_IND
EMAIL_ADDRESS	Email Address	Email address of the expense owner as contact information for workflow approvals.	VARCHAR2(255)		FTOBPROF	DEFAULT_EMAIL_ADDRESS
LIFE_TOTAL_REIMBURSE_PAID	Lifetime Total Reimburse Paid	Total amount of all reimbursement expense requests that have been (P)aid to this expense owner.	NUMBER		FUNCTION	MEKFUNC.F_LIFE_TOTAL_REIMBURSE_PAID
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
PERSON_ENTITY_IND	Person Entity Indicator	Indicates whether the profile owner is a person or an organization.	VARCHAR2(1)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_ID	Person ID	User-defined or system generated one-up number of the person who owns this profile.	VARCHAR2(63)		SPRIDEN	SPRIDEN_ID
PERSON_NAME	Person Name	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	Personal identification number of the person who owns this profile.	NUMBER		FTOBPROF	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
PROFILE_ACTIVITY_DATE	Profile Activity Date	Date information for this record in the table was entered or last updated.	DATE		FTOBPROF	ACTIVITY_DATE
PROFILE_DATA_ORIGIN	Profile Data Origin	Source system that created or updated the data.	VARCHAR2(63)		FTOBPROF	DATA_ORIGIN
PROFILE_KEY	Profile KEY	Unique internal identification number of the expense profile record.	NUMBER		FTOBPROF	ID
PROFILE_USER_ID	Profile User ID	Unique identification code of the user who entered or last touched the record.	VARCHAR2(63)		FTOBPROF	USER_ID
REMIT_ADDRESS_NUMBER	Remit Address Number	Sequence number used to identify different addresses within the same address type for the expense owner.	NUMBER		FTOBPROF	DEFAULT_ATYP_SEQ_NUM
REMIT_ADDRESS_TYPE	Remit Address Type	Type of address used as the default for payment to the expense owner.	VARCHAR2(63)		FTOBPROF	DEFAULT_ATYP_CODE
WORKFLOW_USER_LOGON	Workflow User Logon	Common login identification used to signon into Workflow. This is used to map the profile to a workflow signon in order to pass the document information to workflow for approvals.	VARCHAR2(255)		FTOBPROF	WORKFLOW_USER_LOGON

Ver: 9.0