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
APPLICABLE_GROSS_AMOUNT	Applicable Gross Amount	Total gross compensation toward which deduction is applicable. The applicable gross is calculated by taking the gross pay and reducing it by the pre-tax deductions and by adding to the gross pay taxable benefits.	NUMBER		PHRDEDN	PHRDEDN_APPLICABLE_GROSS
ARREARAGE_RECOVERED_AMOUNT	Arrearage Recovered Amount	The amount of arrearage recovered this pay period.	NUMBER		PHRDEDN	PHRDEDN_ARREAR_RECOVERED
ARREARAGE_TAKEN_AMOUNT	Arrearage Taken Amount	The amount of arrearage generated during this pay period.	NUMBER		PHRDEDN	PHRDEDN_ARREAR_TAKEN
CALENDAR_YEAR	Calendar Year	The Calendar Year associated with the Payroll Identifier	VARCHAR2(63)		PHRDEDN	PHRDEDN_YEAR
DEDUCTION	Deduction	Identifies the specific Benefit/deduction.	VARCHAR2(63)		PHRDEDN	PHRDEDN_BDCA_CODE
DEDUCTION_LONG_DESC	Deduction Long Description	Benefit/deduction long description.	VARCHAR2(255)		PTRBDCA	PTRBDCA_LONG_DESC
EFFECTIVE_DATE	Effective Date	The effective date associated with the deduction for this pay period.	DATE		PHRDEDN	PHRDEDN_EFFECTIVE_DATE
EMPLOYEE_DEDUCTION_AMOUNT	Employee Deduction Amount	Employee deduction amount.	NUMBER		PHRDEDN	PHRDEDN_EMPLOYEE_AMT
EMPLOYER	Employer	User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas.	VARCHAR2(63)		PHRDEDN	PHRDEDN_EMPR_CODE
EMPLOYER_DEDUCTION_AMOUNT	Employer Deduction Amount	Employer deduction amount.	NUMBER		PHRDEDN	PHRDEDN_EMPLOYER_AMT
EMPLOYER_DESC	Employer Description	Employer_Code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
EVENT_SEQUENCE_NUMBER	Event Sequence Number	Sequence of the pay event.	NUMBER		PHRDEDN	PHRDEDN_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)		PHRDEDN	PHRDEDN_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		PHRDEDN	PHRDEDN_PAYNO
PERSON_UID	Person UID	System generated unique internal identification number assigned to this person.	NUMBER		PHRDEDN	PHRDEDN_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
STATUS	Status	Status of the deduction.	VARCHAR2(63)		PHRDEDN	PHRDEDN_STATUS
STATUS_DESC	Status Description	Status description.	VARCHAR2(255)		PHRDEDN	PHRDEDN_STATUS
TAX_DEDUCTION_IND	Tax Deduction Indicator	Indicates if the deduction is a tax deduction.	VARCHAR2(63)		CALCULATION	DECODE(PTRBDCA_CALC_RULE)

Ver: 9.0