SECTION 3.4‐ FIELDS FOR ALPHABETS T‐Z 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. T4A_COPY_TYPE Default Label T4A Copy Type Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Government Copy 2 Employee Copy 4 Company Copy T4A_EFFECT Default Label Effect on T4A Gross Length 1 Type Character Format Uppercase Record Reference(s) DEDUCTION_CLASS A Adds To N No Effect S Subtracts From T4A_FINAL_PRINT Default Label T4A Final Print Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 1 T4A_FORM_TYPE Default Label T4A Form type Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE L Laser S Standard Tractor Feed T4A_PRIMARY_SORT Default Label T4A Primary Sort Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Standard Gov't Sort Sequence 2 Business Number 3 Company T4A_PROCESSING_FLG Default Label T4A Processing Type Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE A Print All Amended C Print All Cancelled E Reprint Amend/Cancel/Reissue N Print All Reissued R Print All Originals S Reprint Selected Original(s) T4A_SEC_SORT Default Label T4A Second Sort Length 1 Type Character EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 2 Format Uppercase Record Reference(s) RC_CAN_YE 1 Location Code 2 Department Code 3 Mail Drop 4 Postal Code 5 None of the above T4A_SUMM_OR_SGMT Default Label T4A Summary or Segment Ind Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE S Summary X Summary and Segment T4A_THIRD_SORT Default Label T4A Third Sort Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Employee Name 2 Employee ID 3 Employee SIN T4_COPY_TYPE Default Label T4 Copy Type Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Government Copy 2 Employee Copy 4 Company Copy EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 3 T4_FINAL_PRINT Default Label T4 Final Print Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE T4_FORM_TYPE Default Label T4 Form Type Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE L Laser M Self‐Mailer S Standard Tractor Feed T4_PRIMARY_SORT Default Label T4 Primary Sort Sequence Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Standard Govt Sort Sequence 2 Business Number 3 Company T4_PROCESSING_FLG Default Label T4 Processing Type Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 4 A Print All Amended C Print All Cancelled E Reprint Amend/Cancel/Reissue N Print All Reissued R Print All Originals S Reprint Selected Original(s) T4_SEC_SORT Default Label T4 Secondary Sort Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Location Code 2 Department Code 3 Mail Drop 4 Postal Code 5 None of the above T4_SUMM_OR_SGMT Default Label T4 Summary or Segment Ind Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE S Summary X Summary and Segment T4_THIRD_SORT Default Label T4 Third Sort Length 1 Type Character Format Uppercase Record Reference(s) RC_CAN_YE 1 Employee Name 2 Employee ID EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 5 3 Employee SIN TABENABLE Default Label Enable Tab Key in ActiveX Length 3 Type Number Format Uppercase Record Reference(s) PSPNLFIELD TABLABEL Default Label Tab Label Length 30 Type Character Format Uppercase Record Reference(s) PSMPCONTDEVLANG TABLENAME Default Label Length 32 Type Character Format Uppercase Record Reference(s) PTGRANTTBL TABLE_CAT Default Label Table Catalog Length 30 Type Character Format Uppercase Record Reference(s) PSRMT_TABLEN TABLE_DESC Default Label Table Description Length 254 EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 6 Type Character Format Uppercase Record Reference(s) PSRMT_TABLE TABLE_NAME Default Label Table Name Length 30 Type Character Format Uppercase Record Reference(s) TL_TR_CTVAL_AET TABLE_NAME1 Default Label Table Name Length 30 Type Character Format Uppercase Record Reference(s) TL_TR_CTVAL_AET TABLE_NAME_EXCEPTN Default Label Exception Table Length 30 Type Character Format Uppercase Record Reference(s) SS_TRANS_CI_DTL TABLE_SCHEM Default Label Table Schema Length 30 Type Character Format Uppercase Record Reference(s) PSRMT_TABLEN TABLE_TYPE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 7 Default Label Table Type Length 20 Type Character Format Uppercase Record Reference(s) PSRMT_TABLE O One Way T Two Way TABLE_USE_NAME Default Label Table Use Name Length 10 Type Character Format Uppercase Record Reference(s) PA_TBL_USETSCHD TABLE_USE_NAMET Default Label Table Use Type Length 2 Type Character Format Uppercase Record Reference(s) PA_CONS_HRS TAKEACTION Default Label Take Action Length 1 Type Number Format Uppercase Record Reference(s) PSPROJECTITEM TAKEN_TOTAL Default Label Time Taken Length 9 Type Signed Number Format Uppercase EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 8 Record Reference(s) TL_COMP_DAY_BAL TAKE_ACM_SFX Default Label Take Accumulator Suffix Length 5 Type Character Format Uppercase Record Reference(s) GP_SUFFIX TAKE_CONFIG1 Default Label Config 1 Length 10 Type Character Format Uppercase Record Reference(s) GP_RSLT_ABSMP_C TAKE_CONFIG2 Default Label Config 2 Length 10 Type Character Format Uppercase Record Reference(s) GP_RSLT_ABSMP_D TAKE_CONFIG3 Default Label Config 3 Length 10 Type Character Format Uppercase Record Reference(s) GP_RSLT_ABS TAKE_CONFIG4 Default Label Config 4 EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 9 Length 10 Type Character Format Uppercase Record Reference(s) GP_RSLT_ABS TAKE_UNIT_IND Default Label Taken Unit Paid Ind. ‐Entl Length 1 Type Character Format Uppercase Record Reference(s) GP_AUTOGEN_DFLT TAPE_AUTH_NUMBER Default Label Tape Authorization Number Length 4 Type Number Format Uppercase Record Reference(s) RC_QTR_UI TAPE_DENSITY Default Label Tape Density Length 2 Type Character Format Uppercase Record Reference(s) TAXRPT_RUNCTL 08 800 CPI 16 1600 CPI 18 Code 18 34 Code 34 38 3480 Cartridge 62 6250 CPI 77 3490E Cartridge NA Not Applicable TAPE_LABEL EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc P a g e | 10
Description: