SECTION 3.2 ‐ FIELDS FOR ALPHABETS G This section includes the field name, default label on page, length, type, format, record reference, translate values, legacy system, and legacy name. Note: The default label name identifies the most commonly defined use of the fields as they appear on a page. The default label information was used as documentation although a field can have more than one label. Also, some of the default label descriptions are blank or misspelled. The goal was to document the default label descriptions as closely as possible to what is currently in the system. G11_2483_AMOUNT Default Label Indicator 11 Length 19 Type Number Format Uppercase Record Reference(s) DEC2483_FRA_AET TRN_2483_PARM G12_2483_AMOUNT Default Label Indicator 12 Length 19 Type Number Format Uppercase Record Reference(s) DEC2483_FRA_AET TRN_2483_PARM GARNID Default Label Garnish ID Length 6 Type Character Format Uppercase Record Reference(s) AP_EXTRACT_LINE BAL_ADJ_GRN GARN_BALANCE GARN_EMPL_DED GARN_RULE GARN_SCHED EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 1 GARN_SPEC GVT_GARN_SPEC PAY_GARNISH PAY_GARN_OVRD PYAP_LINE_TAO PYAP_UNXTRC_TAO PYAP_XDEDN_AET PYAP_XGARN_TAO WRK_GARNISH WRK_GARN_OVRD GARNISH_STS_FRA Default Label Garnishment Length 1 Type Character Format Uppercase Record Reference(s) DEP_BENEF_FRA GARN_ALLOW_CNT Default Label Garnish Allowance Count Length 3 Type Number Format Uppercase Record Reference(s) GARN_RULE GARN_AMOUNT1 Default Label Amount Length 10 Type Signed Number Format Uppercase Record Reference(s) GARN_OPERANDS UPG_CAN1_AET EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 2 GARN_AMOUNT2 Default Label Amount Length 10 Type Signed Number Format Uppercase Record Reference(s) GARN_OPERANDS UPG_CAN1_AET GARN_CALC_TYPE Default Label Calculation Type Length 1 Type Character Format Uppercase Record Reference(s) GARN_OPERANDS UPG_CAN1_AET Translate Values A Amt Available for Garnishment D DE for Rule E Exemption GARN_CONDITION Default Label Condition Length 1 Type Character Format Uppercase Record Reference(s) GARN_OPERANDS UPG_CAN1_AET L Less of Element 1 and 2 M Min/Max Check N None Z If negative, set to zero. EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 3 GARN_DED_AMT Default Label Garnish Flat Deduction Amount Length 9 Type Number Format Uppercase Record Reference(s) GARN_SCHED GARN_SPEC GVT_GARN_SPEC PAY_GARN_OVRD WRK_GARN_OVRD GARN_DED_CALC Default Label Garnish Deduction Calc Routine Length 1 Type Character Format Uppercase Record Reference(s) GARN_SCHED GARN_SPEC GVT_GARN_SPEC PAY_GARN_OVRD WRK_GARN_OVRD G Greater of %DE or Amount H Greater of %Gross or Amount M Maximum Allowed P % DE + Amount R % Gross + Amount S No exempt; %DE + Amt T No exempt; % of Gross GARN_DED_LIM_AMT Default Label Garn Deduction Limited Amount Length 11 Type Number Format Uppercase Record Reference(s) PAY_GARNISH WRK_GARNISH EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 4 GARN_DED_LIM_TYPE Default Label Garn Deduction Limited Type Length 1 Type Character Format Uppercase Record Reference(s) PAY_GARNISH WRK_GARNISH A Deduct Limited by Total Amount C Deduct Limited by Calculation M Deduct Limited by Monthly Amt N Deduct Not Limited P Deduct Limited by Net Amount R Deduct Limited by Proration GARN_DED_MAX_AMT Default Label Garn Deduction Maximum Amount Length 11 Type Number Format Uppercase Record Reference(s) PAY_GARNISH WRK_GARNISH GARN_DED_OTH_AMT Default Label Garn Deduction Other Grn Amt Length 11 Type Number Format Uppercase Record Reference(s) PAY_GARNISH WRK_GARNISH EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 5 GARN_DED_PCT Default Label Garnish Deduct DE Percent Length 6 Type Number Format Uppercase Record Reference(s) GARN_SCHED GARN_SPEC GVT_GARN_SPEC PAY_GARN_OVRD WRK_GARN_OVRD GARN_DED_SCHED Default Label Garnish Deduction Schedule Length 1 Type Character Format Uppercase Record Reference(s) GARN_SPEC GVT_GARN_SPEC A Deduct on All Payrolls S Deduct by Schedule GARN_DED_SW Default Label Garnishment Deduction SW Length 1 Type Character Format Uppercase Record Reference(s) GARN_RULE GARN_DEP_EX_CNT Default Label Garnish Dependent/Exempt Count Length 3 Type Number Format Uppercase Record Reference(s) GARN_RULE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 6 GARN_DE_AMT Default Label Garn Disposable Earnings Amt Length 11 Type Number Format Uppercase Record Reference(s) PAY_GARNISH WRK_GARNISH GARN_DE_DEFNID Default Label Garnishment DE Definition ID Length 10 Type Character Format Uppercase Record Reference(s) GARN_DE_DED GARN_DE_DEFN GARN_DE_DEF_LNG GARN_RULE_TBL UPG_CAN1_AET GARN_DE_TAXES Default Label DE Taxes Length 12 Type Signed Number Format Uppercase Record Reference(s) PAY_GARNISH WRK_GARNISH GARN_ELEMENT1 Default Label Element 1 Length 1 Type Character Format Uppercase Record Reference(s) GARN_OPERANDS UPG_CAN1_AET EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 7 A # of Allowances B Allowance Amount C # of Dependent D Dependent Amount E Exempt Amount F Exempt Percent G Earnings Subj to Garnishment H Minimum Exemption I Maximum Exemption J Threshold N None P Percentage Q Amount S Result of Step T Statutory Deductions U Selected Deductions GARN_ELEMENT2 Default Label Element 2 Length 1 Type Character Format Uppercase Record Reference(s) GARN_OPERANDS UPG_CAN1_AET A # of Allowances B Allowance Amount C # of Dependent D Dependent Amount E Exempt Amount F Exempt Percent G Earnings Subj to Garnishment H Minimum Exemption I Maximum Exemption J Threshold N None P Percentage Q Amount S Result of Step T Statutory Deductions EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 8 U Selected Deductions GARN_EX_ALW_AMT Default Label Exempt Amount Per Allowance Length 9 Type Number Format Uppercase Record Reference(s) GARN_EXEMPT_TBL GARN_EX_AMT Default Label Garnish Exempt Amount Length 9 Type Number Format Uppercase Record Reference(s) GARN_EXEMPT_TBL GARN_RULE PAY_GARNISH WRK_GARNISH GARN_EX_CALC Default Label Garnish Exempt Calc Routine Length 1 Type Character Format Uppercase Record Reference(s) GARN_EXEMPT_TBL PAY_GARNISH UPG_CAN1_AET WRK_GARNISH C General Calculation D Based on Standard Deduction E General Calc with Entered Amt H Based on Minimum Hourly Wage R Garnish Exempt Calc Routine EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 9 GARN_EX_DEP_AMT Default Label Exempt Amount Per Dependent Length 9 Type Number Format Uppercase Record Reference(s) GARN_EXEMPT_TBL GARN_EX_DEP_EXCL Default Label Dependents Excluded Length 3 Type Number Format Uppercase Record Reference(s) GARN_EXEMPT_TBL GARN_EX_HRS Default Label Garnish Exempt Hours Length 6 Type Number Format Uppercase Record Reference(s) GARN_EXEMPT_TBL GARN_EX_MAX Default Label Maximum Exemption Length 9 Type Number Format Uppercase Record Reference(s) GARN_EXEMPT_TBL GARN_RULE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. 10/2/2008 Section 3.2 Fields Alphabet G.docx Page | 10
Description: