SECTION 3.3 ‐ FIELDS FOR ALPHABETS H‐S 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. H17_2483_AMOUNT Default Label Indicator 17 Length 19 Type Number Format Uppercase Record Reference(s) DEC2483_FRA_AET TRN_2483_PARM H18_2483_AMOUNT Default Label Indicator 18 Length 19 Type Number Format Uppercase Record Reference(s) DEC2483_FRA_AET TRN_2483_PARM HANDBOOK_URL_ID Default Label Handbook URL ID Length 30 Type Character Format Uppercase Record Reference(s) BEN_DEFN_PGM BEN_DEFN_PLAN EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 1 HANDICAP_PCNT_ESP Default Label Handicap Percent Length 3 Type Number Format Uppercase Record Reference(s) APP_DISABL_ESP DISABILITY_ESP GPES_PAYEE_DATA GPES_PAYEE_DEPN HANDICAP_PERCENT Default Label Handicap Percent Length 3 Type Number Format Uppercase Record Reference(s) APP_DISABL_CHE APP_DISABL_GER DISABILITY_CHE DISABILITY_GER HARDSHIP_WTHD_DT Default Label Hardship Withdrawal Date Length 10 Type Date Format Uppercase Record Reference(s) SAVINGS_403B_EE SAVINGS_MGT_EE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 2 HASH_SIGNATURE Default Label Hash Signature Length 28 Type Character Format Uppercase Record Reference(s) PSBATCHAUTH HAVECRTCOUNT Default Label Having Criteria Count Length 3 Type Number Format Uppercase Record Reference(s) AE_GB_AET PSQRYSELECT HAZARD Default Label Hazard Length 4 Type Character Format Uppercase Record Reference(s) ACCDT_INS_HAZ ACCDT_INS_HAZ_L COOP_SOC_GER DEPT_TBL GPDE_SI_COOP_D GPDE_SI_EE OHS001GER_TMP2 R_PER507 EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 3 HAZARD_CLASS Default Label Hazardous Class Length 1 Type Character Format Uppercase Record Reference(s) HAZ_CON_MAT_TBL A Compressed Gases B Flammable and Combustible C Oxidizing Material D Poisonous and Infectious E Corrosive Material F Dangerously Reactive HAZARD_DIVISION Default Label Hazardous Division Length 1 Type Character Format Uppercase Record Reference(s) HAZ_CON_MAT_TBL 1 Immediate and Seriously Toxic 2 Other Toxic Affects 3 Biohazardous Infectious HAZARD_ID Default Label Hazard ID Length 5 Type Character Format Uppercase Record Reference(s) HAZ_CON_MAT_LNG HAZ_CON_MAT_TBL ILL_ACTION_GER ILL_CAUSE_GER INCDNT_ACTN_TYP INCIDENT_ACTION INCIDENT_CAUSE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 4 INC_ACTION_LNG JOBCODE_HAZ_TBL LOCATN_HAZ_TBL OHS001GER_TMP2 WCB_ERCA_EC WCB_ERCA_WD HAZARD_TYPE Default Label Hazard Type Length 1 Type Character Format Uppercase Record Reference(s) HAZ_CON_MAT_TBL C Condition M Material HCE_COMP_METHOD Default Label Compensation Method to be Used Length 1 Type Character Format Uppercase Record Reference(s) NDT_HCE_TBL 1 Compensation Only 2 Compensation in Top Percent HCE_LIMIT_PCT Default Label Employee Investment Limit Pct Length 7 Type Number Format Uppercase Record Reference(s) SAVINGS_PLN_TBL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 5 HCE_PCT_ATAX Default Label High Comp Empl After‐Tax Limit Length 7 Type Number Format Uppercase Record Reference(s) SAVINGS_PLN_TBL HCE_PCT_BTAX Default Label High Cmp Empl Before‐Tax Limit Length 7 Type Number Format Uppercase Record Reference(s) SAVINGS_PLN_TBL HCE_RED_ATAX Default Label High Comp Empl A‐Tax Reduction Length 7 Type Number Format Uppercase Record Reference(s) SAVINGS_PLN_TBL HCE_RED_BTAX Default Label High Comp Empl B‐Tax Reduction Length 7 Type Number Format Uppercase Record Reference(s) SAVINGS_PLN_TBL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 6 HCE_TYPE Default Label Highly/Lowly Compensated Length 1 Type Character Format Uppercase Record Reference(s) R_NDT_EMPL_ADP R_NDT_EMPL_YTD H Highly Compensated L Non Highly Compensated HC_PORTAL_FLAG Default Label Process Result Length 1 Type Character Format Uppercase Record Reference(s) RUN_CNTL_PORTAL 1 Portal Navigation Hardcopy 2 Portal/Menu Path HC_PORTAL_NOHIDDEN Default Label Suppress Hidden Objects Length 1 Type Character Format Uppercase Record Reference(s) RUN_CNTL_PORTAL HC_PORTAL_SHOWMENU Default Label Show Menu.Component.Market Length 1 Type Character Format Uppercase Record Reference(s) RUN_CNTL_PORTAL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 7 HC_PORTAL_SHOWOBJ Default Label Show Object Names Length 1 Type Character Format Uppercase Record Reference(s) RUN_CNTL_PORTAL HC_SECURITY_FLAG Default Label Apply Security Based On Length 1 Type Character Format Uppercase Record Reference(s) RUN_CNTL_PORTAL P Permission List R Role U UserId HDGTYPE Default Label Heading Type Length 1 Type Number Format Uppercase Record Reference(s) PSQRYBIND PSQRYFIELD HEADCOUNT Default Label Headcount Length 6 Type Number Format Uppercase EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 8 Record Reference(s) BD_POSITION_TBL GPFR_DA_AET HEADING Default Label Field Heading Length 30 Type Character Format Mixedcase Record Reference(s) PSMAPROLEBIND PSQRYBIND PSQRYBINDLANG PSQRYFIELD PSQRYFIELDLANG QRY_DUP_HD_AET HEALTH_CARE_NBR Default Label Health Care Number Length 12 Type Character Format Uppercase Record Reference(s) WCB_INWO_EC HEALTH_CERTIFICATE Default Label Health Certificate Length 1 Type Character Format Uppercase Record Reference(s) POSITION_DATA 1 Full Health Check 2 Eye Check 3 Ear Check 4 Radiation Check EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 9 HEALTH_INS_RT Default Label Health Insurance Rate Length 8 Type Number Format Uppercase Record Reference(s) CAN_TAX_PROV CAN_USR_TAX_PRV HEALTH_PLAN Default Label Health Plan Length 3 Type Character Format Uppercase Record Reference(s) GVT_CPDF_STATUS HEARING_CLASS Default Label Hearing Classification Length 2 Type Character Format Uppercase Record Reference(s) AUDIOMETRIC_TST AB Abnormal AS Abnormal Shift EL Early Loss Indication NM Normal HEARTBEAT Default Label Heartbeat Length 4 Type Number Format Uppercase Record Reference(s) SERVERDEFN EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.3 Fields Alphabet H‐S.docx Page | 10
Description: