Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPLICABLE_GROSS_AMOUNT	Monthly applicable gross amount for each deduction is the sum of applicable gross amounts for all the payrolls processed within the month. The applicable gross amount for each deduction is calculated by the payroll process taking the gross pay and reducing it by the deductions that are considered to be pre-tax and by adding to the gross pay those benefits that are considered to be taxable.	NUMBER	PERDTOT	PERDTOT_APPL_GRS
BENEFIT_GROUP	Benefit group.	VARCHAR2(63)	PTRBDCA	PTRBDCA_BDTY_CODE
CARRIER	Identifies the specific benefit/deduction provider.	VARCHAR2(63)	PERDTOT	PERDTOT_BDCA_CODE
CARRIER_LONG_DESC	Benefit/deduction long description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CARRIER_SHORT_DESC	Benefit/deduction short description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COVERAGE_OPTION	Coverage option associated with this benefit.	VARCHAR2(63)	NA	NA
COVERAGE_OPTION_DESC	Coverage option description.	VARCHAR2(255)	NA	NA
EMPLOYEE_CONTRIBUTION_AMOUNT	Employee contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPL_AMT
EMPLOYEE_CONTRIBUTION_FYTD	Fiscal year to date employee contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD
EMPLOYER	Employer identification code.	VARCHAR2(63)	PERDTOT	PERDTOT_EMPR_CODE
EMPLOYER_CONTRIBUTION_AMOUNT	Employer contribution amount toward the deduction.	NUMBER	PERDTOT	PERDTOT_EMPR_AMT
EMPLOYER_CONTRIBUTION_FYTD	Fiscal year to date employer contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD
GROSS_COMPENSATION_FYTD	Fiscal year to date gross contribution.	NUMBER	FUNCTION	POKODSF.F_CALC_DEDUCTIONS_FYTD
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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAYROLL_DEDUCTION_MONTH	Calendar month in which the payroll deduction took place.	NUMBER	PERDTOT	PERDTOT_MONTH
PAYROLL_DEDUCTION_YEAR	Payroll deduction year; calendar year in which the payroll deduction took place for this record.	NUMBER	PERDTOT	PERDTOT_YEAR
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERDTOT	PERDTOT_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA

Ver: 9.1