| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|
|
APPLICABLE_GROSS_QTR1
|
|
NUMBER
|
|
|
|
APPLICABLE_GROSS_QTR2
|
|
NUMBER
|
|
|
|
APPLICABLE_GROSS_QTR3
|
|
NUMBER
|
|
|
|
APPLICABLE_GROSS_QTR4
|
|
NUMBER
|
|
|
|
CARRIER
|
The code which identifies the benefit/deduction.
|
VARCHAR2(3)
|
|
|
|
CARRIER_DESC
|
Benefit / Deduction long description.
|
VARCHAR2(30)
|
|
|
|
CURRENT_DATE
|
This is the system current date (sysdate)
|
DATE
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR1
|
|
NUMBER
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR2
|
|
NUMBER
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR3
|
|
NUMBER
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR4
|
|
NUMBER
|
|
|
|
EMPLOYEE_CONTRIBUTION_YTD
|
|
NUMBER
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR1
|
|
NUMBER
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR2
|
|
NUMBER
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR3
|
|
NUMBER
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR4
|
|
NUMBER
|
|
|
|
EMPLOYER_CONTRIBUTION_YTD
|
|
NUMBER
|
|
|
|
GROSS_COMPENSATION_YTD
|
|
NUMBER
|
|
|
|
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)
|
|
|
|
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)
|
|
|
|
PAYROLL_DEDUCTION_YEAR
|
Deduction Year.
|
NUMBER(4)
|
|
|
|
PERSON_UID
|
System generated number that is internally generated to uniquely identify the person.
|
NUMBER(8)
|
|
|
|
PROCESS_GROUP
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|