Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
|
|
|
NO
|
APPLICABLE_GROSS_QTR1
|
Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
|
|
|
NO
|
APPLICABLE_GROSS_QTR2
|
Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
|
|
|
NO
|
APPLICABLE_GROSS_QTR3
|
Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
|
|
|
NO
|
APPLICABLE_GROSS_QTR4
|
Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
|
|
|
NO
|
CARRIER
|
The code which identifies the benefit/deduction.
|
VARCHAR2(3)
|
|
|
|
NO
|
CARRIER_DESC
|
Benefit / Deduction long description.
|
VARCHAR2(30)
|
|
|
|
NO
|
CURRENT_DATE
|
This is the system current date (sysdate).
|
DATE
|
|
|
|
NO
|
EMPLOYEE_CONTRIBUTION_QTR1
|
Quarter 1 employee contribution.
|
NUMBER
|
|
|
|
NO
|
EMPLOYEE_CONTRIBUTION_QTR2
|
Quarter 2 employee contribution.
|
NUMBER
|
|
|
|
NO
|
EMPLOYEE_CONTRIBUTION_QTR3
|
Quarter 3 employee contribution.
|
NUMBER
|
|
|
|
NO
|
EMPLOYEE_CONTRIBUTION_QTR4
|
Quarter 4 employee contribution.
|
NUMBER
|
|
|
|
NO
|
EMPLOYEE_CONTRIBUTION_YTD
|
Year to date employee contribution for a specific deduction.
|
NUMBER
|
|
|
|
NO
|
EMPLOYER_CONTRIBUTION_QTR1
|
Quarter 1 employer total contribution for a specific deduction.
|
NUMBER
|
|
|
|
NO
|
EMPLOYER_CONTRIBUTION_QTR2
|
Quarter 2 employer total contribution for a specific deduction.
|
NUMBER
|
|
|
|
NO
|
EMPLOYER_CONTRIBUTION_QTR3
|
Quarter 3 employer total contribution for a specific deduction.
|
NUMBER
|
|
|
|
NO
|
EMPLOYER_CONTRIBUTION_QTR4
|
Quarter 4 employer total contribution for a specific deduction.
|
NUMBER
|
|
|
|
NO
|
EMPLOYER_CONTRIBUTION_YTD
|
Year to date employer contribution for a specific deduction.
|
NUMBER
|
|
|
|
NO
|
GROSS_COMPENSATION_YTD
|
Year to date gross contribution.
|
NUMBER
|
|
|
|
NO
|
MULTI_SOURCE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
|
|
|
NO
|
MULTI_SOURCE_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
|
|
|
NO
|
PAYROLL_DEDUCTION_YEAR
|
Deduction Year.
|
NUMBER
|
|
|
|
NO
|
PERSON_UID
|
System generated number that is internally generated to uniquely identify the person.
|
NUMBER
|
|
|
|
NO
|
PROCESS_GROUP
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|
|
NO
|