| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|
|
|
APPLICABLE_GROSS_QTR1
|
Applicable Gross Quarter 1
|
|
NUMBER
|
|
|
|
|
APPLICABLE_GROSS_QTR2
|
Applicable Gross Quarter 2
|
|
NUMBER
|
|
|
|
|
APPLICABLE_GROSS_QTR3
|
Applicable Gross Quarter 3
|
|
NUMBER
|
|
|
|
|
APPLICABLE_GROSS_QTR4
|
Applicable Gross Quarter 4
|
|
NUMBER
|
|
|
|
|
CARRIER
|
Carrier
|
The code which identifies the benefit/deduction.
|
VARCHAR2(3)
|
|
|
|
|
CARRIER_DESC
|
Carrier Description
|
Benefit / Deduction long description.
|
VARCHAR2(30)
|
|
|
|
|
CURRENT_DATE
|
Current Date
|
This is the system current date (sysdate)
|
DATE
|
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR1
|
Employee Contribution Quarter 1
|
|
NUMBER
|
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR2
|
Employee Contribution Quarter 2
|
|
NUMBER
|
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR3
|
Employee Contribution Quarter 3
|
|
NUMBER
|
|
|
|
|
EMPLOYEE_CONTRIBUTION_QTR4
|
Employee Contribution Quarter 4
|
|
NUMBER
|
|
|
|
|
EMPLOYEE_CONTRIBUTION_YTD
|
Employee Contribution Year to Date
|
|
NUMBER
|
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR1
|
Employer Contribution Quarter 1
|
|
NUMBER
|
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR2
|
Employer Contribution Quarter 2
|
|
NUMBER
|
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR3
|
Employer Contribution Quarter 3
|
|
NUMBER
|
|
|
|
|
EMPLOYER_CONTRIBUTION_QTR4
|
Employer Contribution Quarter 4
|
|
NUMBER
|
|
|
|
|
EMPLOYER_CONTRIBUTION_YTD
|
Employer Contribution Year to Date
|
|
NUMBER
|
|
|
|
|
GROSS_COMPENSATION_YTD
|
Gross Compensation Year to Date
|
|
NUMBER
|
|
|
|
|
MULTI_SOURCE
|
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
|
Multi Source Description
|
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
|
Payroll Deduction Year
|
Deduction Year.
|
NUMBER(4)
|
|
|
|
|
PERSON_UID
|
Person UID
|
System generated number that is internally generated to uniquely identify the person.
|
NUMBER(8)
|
|
|
|
|
PROCESS_GROUP
|
Process Group
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|
|