Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BANK_ACCOUNT_NUMBER	Bank Account Number	The bank account number for the direct deposit.	VARCHAR2(63)	PHRDOCM	PHRDOCM_BANK_ACCT_NO
BANK_ACCOUNT_TYPE	Bank Account Type	The type of account for direct deposit.	VARCHAR2(63)	PHRDOCM	PHRDOCM_ACCT_TYPE
BANK_ACCOUNT_TYPE_DESC	Bank Account Type Description	Bank account type description.	VARCHAR2(255)	PHRDOCM	PHRDOCM_ACCT_TYPE
BANK_ROUTING_NUMBER	Bank Routing Number	Specifies the bank routing number where the money is to be deposited.	VARCHAR2(63)	PHRDOCM	PHRDOCM_BANK_CODE
BANK_ROUTING_NUMBER_DESC	Bank Routing Number Description	Bank name.	VARCHAR2(255)	GXVDIRD	GXVDIRD_DESC
CALENDAR_YEAR	Calendar Year	The Calendar Year associated with the Payroll Identifier.	VARCHAR2(63)	PHRDOCM	PHRDOCM_YEAR
DIRECT_DEPOSIT_IND	Direct Deposit Indicator	Indicates if the payroll event is a direct deposit.	VARCHAR2(63)	CALCULATION	DECODE(PHRDOCM_DOC_TYPE)
DOCUMENT_DATE	Document Date	Date of the check or direct deposit notification.	DATE	PHRDOCM	PHRDOCM_DOC_DATE
DOCUMENT_NET_AMOUNT	Document Net Amount	The amount of the check or direct deposit.	NUMBER	PHRDOCM	PHRDOCM_NET
DOCUMENT_NUMBER	Document Number	The check or direct deposit notice number.	VARCHAR2(63)	PHRDOCM	PHRDOCM_DOC_NO
EVENT_SEQUENCE_NUMBER	Event Sequence Number	Sequence of the pay event.	NUMBER	PHRDOCM	PHRDOCM_SEQ_NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
NAME	Name	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAYROLL_IDENTIFIER	Payroll Identifier	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)	PHRDOCM	PHRDOCM_PICT_CODE
PAYROLL_IDENTIFIER_DESC	Payroll Identifier Description	Payroll code description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAYROLL_NUMBER	Payroll Number	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER	PHRDOCM	PHRDOCM_PAYNO
PERSON_UID	Person UID	System generated unique internal identification number assigned to this person.	NUMBER	PHRDOCM	PHRDOCM_PIDM
PRIORITY	Priority	The sequence in which the documents are generated.	NUMBER	PHRDOCM	PHRDOCM_PRIORITY
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RECONCILIATION	Reconciliation	Reconciliation status of the document.	VARCHAR2(63)	PHRDOCM	PHRDOCM_RECON_IND
RECONCILIATION_DATE	Reconciliation Date	Bank statement reconciliation date.	DATE	PHRDOCM	PHRDOCM_RECON_DATE
RECONCILIATION_DESC	Reconciliation Description	Reconciliation code description.	VARCHAR2(255)	PHRDOCM	PHRDOCM_RECON_IND
REISSUED_IND	Reissued Indicator	Indicates if this document has been reissued.	VARCHAR2(63)	PHRDOCM	PHRDOCM_REISSUE_IND

Ver: 9.2