BENEFIT_DEDUCTION - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
EMPLOYER_IDENTIFICATION_NUMBER |
EMPLOYER |
|
NBRJOBS |
NBRJOBS_EMPR_CODE |
UNKNOWN |
PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
PDRBDED |
PDRBDED_PIDM |
UNKNOWN |
BENEFIT_GROUP |
IDENTIFIES THE KIND OF BENEFIT IS REPRESENTED IN THIS RECORD. |
|
PDRBDED |
NOT AVAILABLE |
UNKNOWN |
CARRIER |
IDENTIFIES THE BENEFIT PROVIDER FOR THE EMPLOYEE. |
|
PDRBDED |
PDRBDED_BDCA_CODE |
UNKNOWN |
CARRIER_SHORT_DESC |
SHORT NAME OF THE BENEFIT PROVIDER. |
|
PDRBDED |
PDRBDED_BDCA_CODE |
UNKNOWN |
CARRIER_LONG_DESC |
FULL NAME OF THE BENEFIT PROVIDER. |
|
PTRBDCA |
PTRBDCA_SHORT_DESC |
UNKNOWN |
COVERAGE_OPTION |
|
|
PTRBDCA |
PTRBDCA_LONG_DESC |
UNKNOWN |
COVERAGE_OPTION_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
BENEFIT_DEDUCTION_IND |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
PAYROLL_DEDUCTION_YEAR |
DEDUCTION YEAR. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PROFILE_DATE |
INFORMATION IN THIS MODEL WILL BE RETURNED 'AS OF' THE PROFILE DATE |
|
FUNCTION |
F_YEAR |
UNKNOWN |
COVERAGE_BEGIN_DATE |
DATE THE BENEFIT/DEDUCTION BEGAN. |
|
FUNCTION |
F_PROFILE_DATE |
UNKNOWN |
COVERAGE_END_DATE |
DATE THE BENEFIT/DEDUCTION END. |
|
PDRBDED |
PDRBDED_BEGIN_DATE |
UNKNOWN |
BOND_BALANCE |
IF THE DEDUCTION IS FOR SAVINGS BONDS THIS FIELD CONTAINS THE BALANCE AVAILABLE TOWARD THE PURCHASE OF A BOND. |
|
PDRBDED |
PDRBDED_END_DATE |
UNKNOWN |
MAXIMUM_REARS_RECOVERY |
MAXIMUM AMOUNT OF ARREARS ALLOWED TO BE RECOVERED IN A PAY EVENT. |
|
PDRBDED |
PDRBDED_BOND_BALANCE |
UNKNOWN |
REARS_BALANCE |
ARREARS BALANCE DUE THE EMPLOYER. |
|
PDRBDED |
PDRBDED_ARR_RECOVERY_MAX |
UNKNOWN |
EFFECTIVE_DATE |
DATE ON WHICH THE BARGAINING UNIT BECAME EFFECTIVE FOR THIS PERSON. |
|
PDRBDED |
PDRBDED_ARR_BALANCE |
UNKNOWN |
EFFECTIVE_START_DATE |
BEGINNING DATE FOR EFFECTIVE DATE. |
|
PDRDEDN |
PDRBDED_EFFECTIVE_DATE |
UNKNOWN |
EFFECTIVE_END_DATE |
DATE ON WHICH THE BARGAINING UNIT WAS NO LONGER ASSOCIATED WITH THIS PERSON. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
STATUS |
STATUS OF THE ACADEMIC OUTCOME AND IDENTIFIES THOSE OUTCOMES THAT ARE PENDING OR AWARDED. |
|
PDRDEDN |
PDRBDED_STATUS |
UNKNOWN |
STATUS_DESC |
DESCRIPTION FOR THE STATUS CODE . |
|
NA |
NOT AVAILABLE |
UNKNOWN |
EMPLOYEE_DEDUCTION_AMOUNT |
EMPLOYEE COST; PERCENTAGE OF GROSS PAY |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYER_DEDUCTION_AMOUNT |
EMPLOYER COST; FLAT AMOUNT DEDUCTION PER PAY |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_DEDUCTION_PERCENT |
|
|
|
|
|
EMPLOYEE_ANNUAL_DEDN_LIMIT |
MAXIMUM EMPLOYEE COST ON ANNUAL BASIS |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_DEDN_LTD_LIMIT |
MAXIMUM LIFE-TO-DATE EMPLOYEE COST |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_DEDN_MTD_LIMIT |
MAXIMUM MONTH-TO-DATE EMPLOYEE COST |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_MINIMUM_EARNINGS |
MINIMUM AMOUNT THE EMPLOYEE CAN BE PAID PER PAY. USED TO DETERMINE IF DEDUCTION |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_MINIMUM_YTD_GROSS |
MINIMUM AMOUNT THE EMPLOYEE MOST FIRST EARN IN A CALENDAR YEAR BEFORE THE DEDUCTION WILL BE TAKEN |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_BOND_PURCHASE_AMOUNT |
BOND INCREMENT IN WHICH THE EMPLOYEE DESIRES TO PURCHASE U.S. SAVINGS BONDS |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
LIFE_INSURANCE_OVERRIDE_AMOUNT |
MANUALLY ENTERED LIFE INSURANCE COVERAGE AMOUNT FOR EMPLOYEE |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
LIFE_INSURANCE_PREMIUM |
EMPLOYEE OR EMPLOYER COST OF THE LIFE INSURANCE BENEFIT |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
LIFE_INSURANCE_SALARY |
EMPLOYEE SALARY USED TO CALCULATED THE INSURANCE COVERAGE |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
LIFE_INSURANE_COVERAGE_AMOUNT |
COVERAGE AMOUNT OF THE EMPLOYEE'S LIFE INSURANCE WHEN NO OVERRIDE IS ENTERED. |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
LIFE_INSURANCE_TYPE_IND |
INDICATES WHETHER THE LIFE INSURANCE DEDUCTION IS EMPLOYEE OR EMPLOYER PAID |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
AMOUNT1 |
AMOUNT 1 OF THE BENEFIT TO BE DEDUCTED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT1_TITLE |
DESCRIPTION ASSOCIATED WITH THE AMOUNT TITLE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT2 |
AMOUNT 2 OF THE BENEFIT TO BE DEDUCTED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT2_TITLE |
DESCRIPTION ASSOCIATED WITH THE AMOUNT TITLE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT3 |
AMOUNT 3 OF THE BENEFIT TO BE DEDUCTED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT3_TITLE |
DESCRIPTION ASSOCIATED WITH THE AMOUNT TITLE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT4 |
AMOUNT 4 OF THE BENEFIT TO BE DEDUCTED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
AMOUNT4_TITLE |
DESCRIPTION ASSOCIATED WITH THE AMOUNT TITLE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION1 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION1_TITLE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION2 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION2_TITLE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION3 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION3_TITLE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION4 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION4_TITLE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION5 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPTION5_TITLE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
BENEFIT_DEDUCTION_TYPE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
BENEFIT_DEDUCTION_TYPE_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR1 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE FIRST QUARTER. |
|
PDRDEDN |
PDRDEDN_OPT_CODE5 |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR1 |
TOTAL EMPLOYER CONTRIBUTION FOR THE FIRST QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR1 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE FIRST QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR2 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE SECOND QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR2 |
TOTAL EMPLOYER CONTRIBUTION FOR THE SECOND QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR2 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE SECOND QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR3 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE THIRD QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR3 |
TOTAL EMPLOYER CONTRIBUTION FOR THE THIRD QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR3 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE THIRD QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR4 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE FOURTH QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR4 |
TOTAL EMPLOYER CONTRIBUTION FOR THE FOURTH QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR4 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE FOURTH QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_YTD |
TOTAL EMPLOYEE CONTRIBUTION YEAR TO DATE. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_YTD |
TOTAL EMPLOYER CONTRIBUTION YEAR TO DATE. |
|
FUNCTION |
F_YEARLY_DEDUCTION_TOTAL |
UNKNOWN |
GROSS_COMPENSATION_YTD |
TOTAL APPLICABLE GROSS EARNINGS YEAR TO DATE. |
|
FUNCTION |
F_YEARLY_DEDUCTION_TOTAL |
UNKNOWN |
BENEFICIARY_COUNT |
NUMBER OF BENEFICIARIES RECORDED FOR THE PERSON. |
|
MPKFUNC |
F_COUNT_BENEFICIARY |
UNKNOWN |