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_AMOUNT
|
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
|
Benefit group.
|
VARCHAR2(63)
|
PTRBDCA
|
PTRBDCA_BDTY_CODE
|
CARRIER
|
Carrier
|
Identifies the specific benefit/deduction provider.
|
VARCHAR2(63)
|
PERDTOT
|
PERDTOT_BDCA_CODE
|
CARRIER_LONG_DESC
|
Carrier Long Description
|
Benefit/deduction long description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CARRIER_SHORT_DESC
|
Carrier Short Description
|
Benefit/deduction short description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COVERAGE_OPTION
|
Coverage Option
|
Coverage option associated with this benefit.
|
VARCHAR2(63)
|
NA
|
NA
|
COVERAGE_OPTION_DESC
|
Coverage Option Description
|
Coverage option description.
|
VARCHAR2(255)
|
NA
|
NA
|
EMPLOYEE_CONTRIBUTION_AMOUNT
|
Employee Contribution Amount
|
Employee contribution amount toward the deduction.
|
NUMBER
|
PERDTOT
|
PERDTOT_EMPL_AMT
|
EMPLOYEE_CONTRIBUTION_FYTD
|
Employee Contribution Fiscal Year to Date
|
Fiscal year to date employee contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
POKODSF.F_CALC_DEDUCTIONS_FYTD
|
EMPLOYER
|
Employer
|
Employer identification code.
|
VARCHAR2(63)
|
PERDTOT
|
PERDTOT_EMPR_CODE
|
EMPLOYER_CONTRIBUTION_AMOUNT
|
Employer Contribution Amount
|
Employer contribution amount toward the deduction.
|
NUMBER
|
PERDTOT
|
PERDTOT_EMPR_AMT
|
EMPLOYER_CONTRIBUTION_FYTD
|
Employer Contribution Fiscal Year to Date
|
Fiscal year to date employer contribution for a specific deduction.
|
NUMBER
|
FUNCTION
|
POKODSF.F_CALC_DEDUCTIONS_FYTD
|
GROSS_COMPENSATION_FYTD
|
Gross Compensation Fiscal Year to Date
|
Fiscal year to date gross contribution.
|
NUMBER
|
FUNCTION
|
POKODSF.F_CALC_DEDUCTIONS_FYTD
|
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_MONTH
|
Payroll Deduction Month
|
Calendar month in which the payroll deduction took place.
|
NUMBER
|
PERDTOT
|
PERDTOT_MONTH
|
PAYROLL_DEDUCTION_YEAR
|
Payroll Deduction Year
|
Payroll deduction year; calendar year in which the payroll deduction took place for this record.
|
NUMBER
|
PERDTOT
|
PERDTOT_YEAR
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PERDTOT
|
PERDTOT_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
|