SECTION 3.1‐ FIELDS FOR ALPHABETS A‐F 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. AAP_RESPONSIBLE_ID Default Label Person Responsible Length 11 Type Character Format Uppercase Record Reference(s) AAP_TBL AASSIGN_CMPNT1 Default Label Alternate Name Length 18 Type Character Format Uppercase Record Reference(s) ST_ESPP_PRC_AET AA_ENABLED_JPN Default Label Additional Appointment Enabled Length 1 Type Character Format Uppercase Record Reference(s) INSTALLATION AA_PLAN_YR Default Label Aff Action Plan Year Length 4 Type Number Format Uppercase Record Reference(s) UPG_E3XW_TAO EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 1 ABLE_TO_ANSWER_SW Default Label Able To Answer Questions Length 1 Type Character Format Uppercase Record Reference(s) INCIDENT_PEOPLE ABORIGINAL Default Label Aboriginal Length 1 Type Character Format Uppercase Record Reference(s) CAN_OEE_SURVEY ABORT_PROCESS_FLAG Default Label Abort Processing Flag Length 1 Type Character Format Uppercase Record Reference(s) TREE_MAINT_AET ABOVE_SAL_LMT_BEL Default Label Above sal.limit Length 1 Type Character Format Uppercase Record Reference(s) RUN_CNTL_HR_BEL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 2 ABSENCE_CLASS Default Label Absence Class Length 4 Type Character Format Uppercase Record Reference(s) ABS_CLASS_TBL ABS_CL_TBL_LANG ABS_TYPE_TBL ABSENCE_CODE Default Label Absence Code Length 3 Type Character Format Uppercase Record Reference(s) ABSENCE_HIST ABS_CD_TBL_LANG ABS_CODE_TBL HR_NSZ_AET HR_VIAPRIS_AET ABSENCE_DATE Default Label Absence Date Length 10 Type Date Format Uppercase Record Reference(s) GPFR_DA_AET GPIT_ABS_INAIL GP_RSLT_ABS UPG_GP3_AET ABSENCE_IMAGE_REF Default Label Absence Type Image Length 30 Type Image Reference Format Uppercase Record Reference(s) ABS_TYPE_TBL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 3 ABSENCE_REASON Default Label Absence Reason Length 3 Type Character Format Uppercase Record Reference(s) GPBR_MASVAC_AET GPBR_RC_MASSVAC GPMX_MASABS_AET GPMX_RC_MASSABS GPMX_RC_WKRSK_C GP_ABS_EVENT GP_ABS_REASON GP_ABS_RSN_LANG GP_RSLT_ABS ABSENCE_TYPE Default Label Absence Type Length 3 Type Character Format Uppercase Record Reference(s) ABSENCE_HIST ABSHCOMUK_LNG ABSV_REQUEST ABS_CD_TBL_LANG ABS_CODE_TBL ABS_HIST_CERT ABS_HIST_COM_UK ABS_HIST_DET ABS_HIST_LANG ABS_H_DET_LANG ABS_STAT_NLD ABS_TYPE_TBL ABS_TY_TBL_LANG GPBR_MASVAC_AET GPBR_RC_MASSVAC GPMX_RC_MASSABS GPMX_RC_WKRSK_C HR_NSZ_AET HR_VIAPRIS_AET WAO_DATA_NLD EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 4 WCB_IWJA_EC WCB_IWJA_WD Z_MIIS_EMPOW_IN ABSV_ACCRUAL_DT Default Label Accrual Process Date Length 10 Type Date Format Uppercase Record Reference(s) ABSV_ACCRUAL ABSV_REQUEST Z_HR_PIVOT_REF ABSV_ACCRUAL_FREQ Default Label Accrual Frequency Length 1 Type Character Format Uppercase Record Reference(s) ABSV_PLAN_TBL Translate Values M Monthly Y Yearly ABSV_APPROVED_BY Default Label Request Approved By Length 11 Type Character Format Uppercase Record Reference(s) ABSV_REQUEST EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 5 ABSV_APPROVED_DT Default Label Date Approved Length 10 Type Date Format Uppercase Record Reference(s) ABSV_REQUEST ABSV_APPROVED_FLG Default Label Approved Length 1 Type Character Format Uppercase Record Reference(s) ABSV_REQUEST ABSV_BONUS_DAYS Default Label Bonus Days Length 8 Type Number Format Uppercase Record Reference(s) ABSV_ADDL_TBL ABSV_CURR_END_DT Default Label Current Period End Date Length 10 Type Date Format Uppercase Record Reference(s) ABSV_PERIOD ABSV_RUNCTL ABSV_DAYS_EARNED Default Label Days Earned Length 8 Type Number Format Uppercase Record Reference(s) ABSV_RATE_TBL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 6 ABSV_DYS_CARRYOVER Default Label Days Carried Over Length 9 Type Signed Number Format Uppercase Record Reference(s) ABSV_ACCRUAL ABSV_DYS_EARN_YTD Default Label Days Earned YTD Length 9 Type Signed Number Format Uppercase Record Reference(s) ABSV_ACCRUAL ABSV_DYS_TAKE_YTD Default Label Days Taken YTD Length 9 Type Signed Number Format Uppercase Record Reference(s) ABSV_ACCRUAL ABSV_FUTURE_END_DT Default Label Future Period End Date Length 10 Type Date Format Uppercase Record Reference(s) ABSV_PERIOD ABSV_RUNCTL ABSV_MAX_BALANCE Default Label Maximum Leave Balance Length 9 Type Number Format Uppercase Record Reference(s) ABSV_PLAN_TBL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 7 ABSV_MAX_CARRYOVER Default Label Maximum Leave Carryover Length 9 Type Number Format Uppercase Record Reference(s) ABSV_PLAN_TBL ABSV_RATE_FLG Default Label Entitlement Flag Length 1 Type Character Format Uppercase Record Reference(s) ABSV_PLAN_TBL Translate Values A Age S Service ABSV_REQUEST_DT Default Label Request Date Length 10 Type Date Format Uppercase Record Reference(s) ABSV_REQUEST ABSV_REVERSE_FLG Default Label Move back one period Length 1 Type Character Format Uppercase Record Reference(s) ABSV_RUNCTL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 8 ABSV_SERVICE_INT Default Label Service Intervals Length 5 Type Number Format Uppercase Record Reference(s) ABSV_ADDL_TBL ABSV_RATE_TBL ABSW_DAY_NO Default Label Day Number Length 2 Type Number Format Uppercase Record Reference(s) ABSW_TMPL_DET ABSW_T_DET_LANG ABSW_SCHD_ID Default Label Work Schedule Length 10 Type Character Format Uppercase Record Reference(s) ABSW_SCHD_DET ABSW_SCHD_TBL ABSW_SCHEDULE ABSW_S_TBL_LANG ABSW_SEQ_NO Default Label Sequence Number Length 2 Type Number Format Uppercase Record Reference(s) ABSW_SCHD_DET EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 9 ABSW_TMPL_ID Default Label Work Template Length 10 Type Character Format Uppercase Record Reference(s) ABSW_SCHD_DET ABSW_TMPL_DET ABSW_TMPL_TBL ABSW_T_DET_LANG ABSW_T_TBL_LANG ABS_APPROVED_DT Default Label Date Approved Length 10 Type Date Format Uppercase Record Reference(s) ABSENCE_HIST ABS_BEGIN_TM Default Label Begin Time Length 15 Type Time Format Uppercase Record Reference(s) ABSENCE_HIST HR_NSZ_AET HR_VIAPRIS_AET EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 10/2/2008 Section 3.1 Fields Alphabets A‐F.doc P a g e | 10
Description: