| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
APPLICABLE_GROSS_QTR1
|
Applicable Gross Quarter 1
|
Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
APPLICABLE_GROSS_QTR2
|
Applicable Gross Quarter 2
|
Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
APPLICABLE_GROSS_QTR3
|
Applicable Gross Quarter 3
|
Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
APPLICABLE_GROSS_QTR4
|
Applicable Gross Quarter 4
|
Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
CARRIER
|
Carrier
|
Identifies the specific benefit/deduction provider.
|
VARCHAR2(63)
|
PERDTOT
|
PERDTOT_BDCA_CODE
|
|
CARRIER_DESC
|
Carrier Description
|
Benefit/deduction description.
|
VARCHAR2(255)
|
PTRBDCA
|
PTRBDCA_LONG_DESC
|
|
EMPLOYEE_CONTRIBUTION_QTR1
|
Employee Contribution Quarter 1
|
Quarter 1 employee contribution.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYEE_CONTRIBUTION_QTR2
|
Employee Contribution Quarter 2
|
Quarter 2 employee contribution.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYEE_CONTRIBUTION_QTR3
|
Employee Contribution Quarter 3
|
Quarter 3 employee contribution.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYEE_CONTRIBUTION_QTR4
|
Employee Contribution Quarter 4
|
Quarter 4 employee contribution.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYEE_CONTRIBUTION_YTD
|
Employee Contribution Year to Date
|
Year to date employee contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
F_YEARLY_DEDUCTION_TOTAL
|
|
EMPLOYER_CONTRIBUTION_QTR1
|
Employer Contribution Quarter 1
|
Quarter 1 employer total contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYER_CONTRIBUTION_QTR2
|
Employer Contribution Quarter 2
|
Quarter 2 employer total contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYER_CONTRIBUTION_QTR3
|
Employer Contribution Quarter 3
|
Quarter 3 employer total contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYER_CONTRIBUTION_QTR4
|
Employer Contribution Quarter 4
|
Quarter 4 employer total contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
|
|
EMPLOYER_CONTRIBUTION_YTD
|
Employer Contribution Year to Date
|
Year to date employer contribution for a specific deduction.
|
NUMBER
|
CALCULATION
|
DECODE(PAYROLL_DEDUCTION)
|
|
GROSS_COMPENSATION_YTD
|
Gross Compensation Year to Date
|
Year to date gross contribution.
|
NUMBER
|
CALCULATION
|
DECODE(PAYROLL_DEDUCTION)
|
|
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
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PAYROLL_DEDUCTION_YEAR
|
Payroll Deduction Year
|
Calendar year in which the payroll deduction occurred.
|
NUMBER
|
PERDTOT
|
PERDTOT_YEAR
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PDRDEDN
|
PDRDEDN_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
|