Upload File

fields section 3.4 alphabets t-z - national finance center · empowhr data dictionary prepared by...

  • Home
  • Documents
  • Fields Section 3.4 Alphabets T-Z - National Finance Center · EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc
862
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/4/2008 Section 3.4 Fields Alphabets T‐Z.doc Page | 1 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

Upload: trankhanh

Post on 03-Apr-2018

230 views

Category:

Documents


8 download

Report

TRANSCRIPT

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |1

    SECTION3.4FIELDSFORALPHABETSTZ

    Thissectionincludesthefieldname,defaultlabelonpage,length,type,format,recordreference,translatevalues,legacysystem,andlegacyname.Note:Thedefaultlabelnameidentifiesthemostcommonlydefineduseofthefieldsastheyappearonapage.Thedefaultlabelinformationwasusedasdocumentationalthoughafieldcanhavemorethanonelabel.Also,someofthedefaultlabeldescriptionsareblankormisspelled.Thegoalwastodocumentthedefaultlabeldescriptionsascloselyaspossibletowhatiscurrentlyinthesystem.T4A_COPY_TYPEDefaultLabel T4ACopyTypeLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1GovernmentCopy 2EmployeeCopy 4CompanyCopyT4A_EFFECTDefaultLabel EffectonT4AGrossLength 1Type CharacterFormat UppercaseRecordReference(s) DEDUCTION_CLASS AAddsTo NNoEffect SSubtractsFromT4A_FINAL_PRINTDefaultLabel T4AFinalPrintLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |2

    T4A_FORM_TYPEDefaultLabel T4AFormtypeLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE LLaser SStandardTractorFeedT4A_PRIMARY_SORTDefaultLabel T4APrimarySortLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1StandardGov'tSortSequence 2BusinessNumber 3CompanyT4A_PROCESSING_FLGDefaultLabel T4AProcessingTypeLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE APrintAllAmended CPrintAllCancelled EReprintAmend/Cancel/Reissue NPrintAllReissued RPrintAllOriginals SReprintSelectedOriginal(s)T4A_SEC_SORTDefaultLabel T4ASecondSortLength 1Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |3

    Format UppercaseRecordReference(s) RC_CAN_YE 1LocationCode 2DepartmentCode 3MailDrop 4PostalCode 5NoneoftheaboveT4A_SUMM_OR_SGMTDefaultLabel T4ASummaryorSegmentIndLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE SSummary XSummaryandSegmentT4A_THIRD_SORTDefaultLabel T4AThirdSortLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1EmployeeName 2EmployeeID 3EmployeeSINT4_COPY_TYPEDefaultLabel T4CopyTypeLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1GovernmentCopy 2EmployeeCopy 4CompanyCopy

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |4

    T4_FINAL_PRINTDefaultLabel T4FinalPrintLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YET4_FORM_TYPEDefaultLabel T4FormTypeLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE LLaser MSelfMailer SStandardTractorFeedT4_PRIMARY_SORTDefaultLabel T4PrimarySortSequenceLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1StandardGovtSortSequence 2BusinessNumber 3CompanyT4_PROCESSING_FLGDefaultLabel T4ProcessingTypeLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |5

    APrintAllAmended CPrintAllCancelled EReprintAmend/Cancel/Reissue NPrintAllReissued RPrintAllOriginals SReprintSelectedOriginal(s)T4_SEC_SORTDefaultLabel T4SecondarySortLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1LocationCode 2DepartmentCode 3MailDrop 4PostalCode 5NoneoftheaboveT4_SUMM_OR_SGMTDefaultLabel T4SummaryorSegmentIndLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE SSummary XSummaryandSegmentT4_THIRD_SORTDefaultLabel T4ThirdSortLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1EmployeeName 2EmployeeID

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |6

    3EmployeeSINTABENABLEDefaultLabel EnableTabKeyinActiveXLength 3Type NumberFormat UppercaseRecordReference(s) PSPNLFIELDTABLABELDefaultLabel TabLabelLength 30Type CharacterFormat UppercaseRecordReference(s) PSMPCONTDEVLANGTABLENAMEDefaultLabel Length 32Type CharacterFormat UppercaseRecordReference(s) PTGRANTTBLTABLE_CATDefaultLabel TableCatalogLength 30Type CharacterFormat UppercaseRecordReference(s) PSRMT_TABLENTABLE_DESCDefaultLabel TableDescriptionLength 254

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |7

    Type CharacterFormat UppercaseRecordReference(s) PSRMT_TABLETABLE_NAMEDefaultLabel TableNameLength 30Type CharacterFormat UppercaseRecordReference(s) TL_TR_CTVAL_AETTABLE_NAME1DefaultLabel TableNameLength 30Type CharacterFormat UppercaseRecordReference(s) TL_TR_CTVAL_AETTABLE_NAME_EXCEPTNDefaultLabel ExceptionTableLength 30Type CharacterFormat UppercaseRecordReference(s) SS_TRANS_CI_DTLTABLE_SCHEMDefaultLabel TableSchemaLength 30Type CharacterFormat UppercaseRecordReference(s) PSRMT_TABLENTABLE_TYPE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |8

    DefaultLabel TableTypeLength 20Type CharacterFormat UppercaseRecordReference(s) PSRMT_TABLE OOneWay TTwoWayTABLE_USE_NAMEDefaultLabel TableUseNameLength 10Type CharacterFormat UppercaseRecordReference(s) PA_TBL_USETSCHDTABLE_USE_NAMETDefaultLabel TableUseTypeLength 2Type CharacterFormat UppercaseRecordReference(s) PA_CONS_HRSTAKEACTIONDefaultLabel TakeActionLength 1Type NumberFormat UppercaseRecordReference(s) PSPROJECTITEMTAKEN_TOTALDefaultLabel TimeTakenLength 9Type SignedNumberFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |9

    RecordReference(s) TL_COMP_DAY_BALTAKE_ACM_SFXDefaultLabel TakeAccumulatorSuffixLength 5Type CharacterFormat UppercaseRecordReference(s) GP_SUFFIXTAKE_CONFIG1DefaultLabel Config1Length 10Type CharacterFormat UppercaseRecordReference(s) GP_RSLT_ABSMP_CTAKE_CONFIG2DefaultLabel Config2Length 10Type CharacterFormat UppercaseRecordReference(s) GP_RSLT_ABSMP_DTAKE_CONFIG3DefaultLabel Config3Length 10Type CharacterFormat UppercaseRecordReference(s) GP_RSLT_ABSTAKE_CONFIG4DefaultLabel Config4

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |10

    Length 10Type CharacterFormat UppercaseRecordReference(s) GP_RSLT_ABSTAKE_UNIT_INDDefaultLabel TakenUnitPaidInd.EntlLength 1Type CharacterFormat UppercaseRecordReference(s) GP_AUTOGEN_DFLTTAPE_AUTH_NUMBERDefaultLabel TapeAuthorizationNumberLength 4Type NumberFormat UppercaseRecordReference(s) RC_QTR_UITAPE_DENSITYDefaultLabel TapeDensityLength 2Type CharacterFormat UppercaseRecordReference(s) TAXRPT_RUNCTL 08800CPI 161600CPI 18Code18 34Code34 383480Cartridge 626250CPI 773490ECartridge NANotApplicableTAPE_LABEL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |11

    DefaultLabel TapeLabelLength 2Type CharacterFormat UppercaseRecordReference(s) TAXRPT_RUNCTL NANotApplicable NLNoLabel NSNonstandardLabel SLStandardLabelTARGETED_READY_DTDefaultLabel TargetDateLength 10Type DateFormat UppercaseRecordReference(s) SUCCESSION_PLANTARGETSTATUSDefaultLabel TargetStatusLength 1Type NumberFormat UppercaseRecordReference(s) PSPROJECTITEMTARGET_ACT_SWDefaultLabel AllowNodetobetargetLength 1Type CharacterFormat UppercaseRecordReference(s) PROJ_ACTIVITYTARGET_APPLIDDefaultLabel ApplicantIDLength 11

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |12

    Type CharacterFormat UppercaseRecordReference(s) ER_DUP_COMMONDTTARGET_DTDefaultLabel TargetEndDateLength 10Type DateFormat UppercaseRecordReference(s) SCH_RUNCTRL_DTLTARGET_LANGUAGEDefaultLabel LanguageLength 8Type CharacterFormat UppercaseRecordReference(s) COURSE_LANGUAGETARGET_PROJ_SWDefaultLabel AllocationTargetLength 1Type CharacterFormat UppercaseRecordReference(s) PROJECT_FSTARIFF_AREA_GERDefaultLabel TariffAreaLength 3Type CharacterFormat UppercaseRecordReference(s) TARIF_ARTBL_LNG

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |13

    TARIFF_GERDefaultLabel TariffLength 2Type CharacterFormat UppercaseRecordReference(s) TARIF_ARTBL_LNG 01MetalProcessing 02Banking 03BuildingandCivilEngineering 04ClothingIndustry 05ChemicalIndustry 06PrintingIndustry 07RetailTrade 08FossilOilandGasExtraction 09GlassIndustry 10WholesaleandForeignTrade 11WoodProcessing 12RubberProcessing 13Ceramics 14Agriculture 15LeatherProcessing 16PublicSector 17PaperIndustry 18PaperProcessing 19SawingIndustry 20GermanSeaports 21HardCoalMining 22TextileIndustry 23Insurance 24HousingIndustry 25PeriodicalPublishers 26NewspaperPublishers 27TobaccoIndustryTASKDefaultLabel TaskLength 5Type CharacterFormat UppercaseRecordReference(s) UPG_TL_TIME1MP

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |14

    TASKGROUPDefaultLabel TaskgroupLength 10Type CharacterFormat UppercaseRecordReference(s) UPG_TL_TSK_XREFTASKGROUP_FLAGDefaultLabel TaskgroupLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPDTME_TMPLTTASK_ELEMENT_CDDefaultLabel TaskElementCodeLength 3Type CharacterFormat UppercaseRecordReference(s) TL_TMPDL_TAOMSGTASK_ELEMENT_VALDefaultLabel TaskElementValueLength 25Type CharacterFormat UppercaseRecordReference(s) TL_RPT_CDVALTFCTASK_FLAGDefaultLabel TaskLength 1Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |15

    Format UppercaseRecordReference(s) TL_TSKPRF_TMPLTTASK_FLD_CDDefaultLabel TaskFieldCodeLength 2Type CharacterFormat UppercaseRecordReference(s) GP_TASK_ELEM 01ACCT_CD 02BUSINESS_UNIT 03COMPANY 04COUNTRY 05DEPTID 06JOBCODE 07LOCATION 08PRODUCT 09RATE_VAL 10STATE 11TASK 12USER_FIELD_1 13USER_FIELD_2 14USER_FIELD_3 15USER_FIELD_4 16USER_FIELD_5TASK_ID_FLAGDefaultLabel TaskLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPDTME_TMPLTTASK_PRFID_FLAGDefaultLabel TaskProfileIDLength 1

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |16

    Type CharacterFormat UppercaseRecordReference(s) TL_RPDTME_TMPLTTASK_PRFL_FLAGDefaultLabel TaskProfileLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLTTASK_PRFL_OPTDefaultLabel TaskProfileOptionLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLT NNotUsed OOptional RRequiredTASK_PRFL_TMPLT_IDDefaultLabel TaskTemplateIDLength 10Type CharacterFormat UppercaseRecordReference(s) UPG_TL_REC009SGTASK_PRF_VERDefaultLabel TaskProfileVersionNumberLength 3Type NumberFormat UppercaseRecordReference(s) UPG_TL_REC009

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |17

    TASK_PROFILE_IDDefaultLabel TaskProfileIDLength 10Type CharacterFormat UppercaseRecordReference(s) UPG_TL_TSK_XREFTASK_TMPLT_FLAGDefaultLabel TaskTemplateLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLTTASK_TMPLT_OPTDefaultLabel TaskTemplateOptionLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLT NNotUsed OOptional RRequiredTAU_APPNAMEDefaultLabel ApplicationNameLength 128Type CharacterFormat UppercaseRecordReference(s) TAU_PGM_LISTTAU_APPTYPE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |18

    DefaultLabel ApplicationTypeLength 3Type CharacterFormat UppercaseRecordReference(s) RUN_CNTL_TAU AEPAppEnginePrograms CBLCOBOLPrograms QRYQueries SQRSQRReportsTAU_INCLUDE_TOOLSDefaultLabel IncludePeopleToolsTablesLength 1Type CharacterFormat UppercaseRecordReference(s) RUN_CNTL_TAUTAU_SOURCEPATHDefaultLabel LocationofSourceCodeLength 254Type CharacterFormat MixedcaseRecordReference(s) RUN_CNTL_TAUTAU_TOOLSPATHDefaultLabel LocationofToolsprogramsLength 254Type CharacterFormat MixedcaseRecordReference(s) RUN_CNTL_TAUTAX1042_REFUNDDefaultLabel Tax(1042)ReimbursedLength 12

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |19

    Type SignedNumberFormat UppercaseRecordReference(s) TAX1042_BALANCETAX1042_REFUND_ADJDefaultLabel Tax(1042)ReimbursedAdjLength 12Type SignedNumberFormat UppercaseRecordReference(s) BAL_ADJ_TAX1042TAX1042_REFUND_NEWDefaultLabel Tax(1042)ReimbursedNewLength 12Type SignedNumberFormat UppercaseRecordReference(s) BAL_ADJ_TAX1042TAXABLE_AMTDefaultLabel BalanceTotalEmploymentCostLength 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_BSE_CMPTAXCODE_UKDefaultLabel TaxCodeLength 15Type CharacterFormat UppercaseRecordReference(s) GPGB_EE_STDTLS

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |20

    TAXESDefaultLabel TaxesLength 11Type SignedNumberFormat UppercaseRecordReference(s) R_TAX960XXTAXFORM_IDDefaultLabel TaxFormIdentificationLength 1Type CharacterFormat UppercaseRecordReference(s) YE_EETANTS_LANG AT4ASlip BBusinessPayrollsSurveyCAN CWCBAssessableEarnings ERecordofEmployment F940AnnualEmployer'sFUTA GGross IW2VI JW2cVI MW2GU NW2cGU PW2PR QW2cPR RRL1Slip SW2AS TT4Slip UW2cAS VRL2Slip WW2 XW2cTAXFORM_OPTDefaultLabel ReportingOptionLength 1Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |21

    RecordReference(s) RC_QTR_UI AAllTaxFormIDs SSelectedTaxFormIDsTAXGR_BASEDefaultLabel TaxGrossBaseLength 1Type CharacterFormat UppercaseRecordReference(s) ST_OTH_TAX_TBL DDisability HWithholding UUnemploymentTAXPAYER_ID_NODefaultLabel TaxpayerIDNumberLength 9Type CharacterFormat UppercaseRecordReference(s) PY_IC_W4_AUDITTAX_1042_ADJDefaultLabel Tax(1042)AdjustmentLength 12Type SignedNumberFormat UppercaseRecordReference(s) BAL_ADJ_TAX1042TAX_1042_CURDefaultLabel CurrentTax(1042)Length 12Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAX_1042

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |22

    TAX_1042_MTDDefaultLabel Tax(1042)MTDLength 12Type SignedNumberFormat UppercaseRecordReference(s) TAX1042_BALANCETAX_1042_MTD_ADJDefaultLabel Tax(1042)MTDAdjustedLength 12Type SignedNumberFormat UppercaseRecordReference(s) BAL_ADJ_TAX1042TAX_1042_QTDDefaultLabel Tax(1042)QTDLength 12Type SignedNumberFormat UppercaseRecordReference(s) TAX1042_BALANCETAX_1042_QTD_ADJDefaultLabel Tax(1042)QTDAdjustedLength 12Type SignedNumberFormat UppercaseRecordReference(s) BAL_ADJ_TAX1042TAX_1042_YTDDefaultLabel Tax(1042)YTDLength 12Type SignedNumber

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |23

    Format UppercaseRecordReference(s) TAX1042_BALANCETAX_1042_YTD_ADJDefaultLabel Tax(1042)YTDAdjustedLength 12Type SignedNumberFormat UppercaseRecordReference(s) BAL_ADJ_TAX1042TAX_ADJDefaultLabel TaxAdjustmentLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOAXTAX_ADJ_AMTDefaultLabel TaxAdjustmentAmount(Annual)Length 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_BSE_CMPTAX_ADJ_PRDDefaultLabel AETAXADJPRDTEMPLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_CAN1_AETTAX_ADJ_QTRDefaultLabel AETAXADJQTRTEMP

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |24

    Length 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_CAN1_AETTAX_AGGDefaultLabel TaxAggregateLength 12Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAXW_TAOKTAX_AMTDefaultLabel OneTimeTaxAmountLength 11Type NumberFormat UppercaseRecordReference(s) WRK_TAX_OVRDTX2TAX_BASIS_UKDefaultLabel TaxBasisLength 1Type CharacterFormat UppercaseRecordReference(s) GPGB_REPLIB_AET 0Cumulative 1Week1/Month1TAX_BDGT_CAPDefaultLabel TaxBudgetCapLength 13Type NumberFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |25

    RecordReference(s) DEPT_BUDGETTAX_BEN_INDDefaultLabel TaxableBenefitsLength 1Type CharacterFormat UppercaseRecordReference(s) GARN_DE_DEFN EExclude IIncludeTAX_CD_SUTDefaultLabel TaxCodeSalesandUseTaxLength 8Type CharacterFormat UppercaseRecordReference(s) VOUCHER_LN_STGTAX_CD_SUT_PCTDefaultLabel Sales/UseTaxCodePercentLength 6Type NumberFormat UppercaseRecordReference(s) DISTRIB_LN_STGTAX_CD_VATDefaultLabel VATCodeLength 8Type CharacterFormat UppercaseRecordReference(s) VOUCHER_STGSTGLTAX_CD_VAT_FLG

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |26

    DefaultLabel VATCodeLength 1Type CharacterFormat UppercaseRecordReference(s) GL_ACCOUNT_TBL DDefaultFromHigherLevel SSpecifyatthisLevelTAX_CD_VAT_PCTDefaultLabel VATTaxCodeAggregatePctLength 9Type SignedNumberFormat UppercaseRecordReference(s) DISTRIB_LN_STGTAX_CLASSDefaultLabel TaxBalanceClassLength 1Type CharacterFormat UppercaseRecordReference(s) WRK_TAX_OVRDOXL ANonresidentalien(1042) BLocalEmployerandEmployee CEarnedIncomeCredit DOASDI/DisabilityEE EOASDI/DisabilityER FFICAMedHospitalIns/EE GOASDI/EEtips HWithholding JOASDI/ERtips KExcise LNJSuplWorkforceAdminFund MNewJerseyWDPF NNewJerseyHCSF POccupationalPrivilegeTax QFICAMedHospitalIns/ER RLocalER SUnemploymentSpecial

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |27

    TFICAMedHospitalIns/EEtips UUnemploymentER VUnemploymentEE WVoluntaryDisabilityPlanEE XVoluntaryDisabilityPlanER ZFICAMedHospitalIns/ERtipsTAX_CLASS_CANDefaultLabel CanadianTaxClassLength 3Type CharacterFormat UppercaseRecordReference(s) WRK_TAX_CANTACC ALLTotalGross CBTCanadianBonusTax CITCanadianIncomeTax(T4) CPAPensionAdjustment CPPCanadaPensionPlanEmployee CPRCanadaPensionPlanEmployer EIEEmploymentInsuranceEmployee EIREmploymentInsuranceEmployer HTXProvincialHealthTax PYTPayrollTax QBTQuebecBonusTax QITQuebecIncomeTax(RL1) QPPQuebecPensionPlanEmployee QPRQuebecPensionPlanEmployer RV2QuebecIncomeTax(RL2) T4ACanadianIncomeTax(T4A) TRVTrueRL TT4TrueT4TAX_CLASS_NLDDefaultLabel TaxClassLength 1Type CharacterFormat UppercaseRecordReference(s) EARNINGS_TBLL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |28

    1WageTaxandSocialSecurity 2WageTax,NoSocialSecurity 3NoWageTax,SocialSecurity 4NoWageTax,NoSocialSecurityTAX_CLASS_NYDefaultLabel TaxClassNYLength 1Type CharacterFormat UppercaseRecordReference(s) R_TAX002NYTAX_CLASS_NY2DefaultLabel TaxClassNY2Length 1Type CharacterFormat UppercaseRecordReference(s) R_TAX002NYTAX_CODE_UKDefaultLabel TaxCodeLength 5Type CharacterFormat UppercaseRecordReference(s) GPGB_REPLIB_AETTAX_CREDITS_NLDDefaultLabel TaxCreditsLength 1Type CharacterFormat UppercaseRecordReference(s) TAX_DATA_NLD

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |29

    TAX_CURDefaultLabel CurrentTaxLength 12Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAX_DISTESSTAX_DEDCDDefaultLabel TaxAlterationDeductionCodeLength 6Type CharacterFormat UppercaseRecordReference(s) CAN_BA_HIER_DTLTAX_EXEMPTDefaultLabel TaxExemptFlagLength 1Type CharacterFormat UppercaseRecordReference(s) VOUCHER_STGTAX_EXEMPT_AMTDefaultLabel TaxExemptionAmount(Annual)Length 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_BSE_CMPTAX_GRPDefaultLabel TaxGroupLength 4Type CharacterFormat UppercaseRecordReference(s) VOUCHER_STG

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |30

    TAX_GRP_TYPEDefaultLabel TaxTypeLength 10Type CharacterFormat UppercaseRecordReference(s) TAX_TYPE_TBLTBLTAX_GRS_BASEDefaultLabel BaseGrossLength 1Type CharacterFormat UppercaseRecordReference(s) TAXGR_BASE_TBL DFICA UFUT WFWTTAX_GRS_COMPNTDefaultLabel TaxableGrossComponentIDLength 5Type CharacterFormat UppercaseRecordReference(s) TAXGR_CMPNT_TBLTAX_GRS_EFFECTDefaultLabel TaxGrossEffectLength 1Type CharacterFormat UppercaseRecordReference(s) TAXGR_CMPNT_TBL AAddsTo NNoEffect SSubtractsFrom

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |31

    TAX_GRS_TYPEDefaultLabel TaxableGrossLength 1Type CharacterFormat UppercaseRecordReference(s) TAXGR_CMPNT_TBL DDisability UUnemployment WWithholdingTAX_LOCATION_CDDefaultLabel TaxLocationCodeLength 10Type CharacterFormat UppercaseRecordReference(s) UPG_PY_JOB_TAOOTAX_METHODDefaultLabel TaxMethodLength 1Type CharacterFormat UppercaseRecordReference(s) WRK_OTH_EARNSBL AAnnualized BBonus CCumulative GAggregate LLumpSum MCommission PSpecifiedonPaysheet SSupplemental XSpecialSupplementalTAX_MONTH

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |32

    DefaultLabel TaxMonthLength 2Type NumberFormat UppercaseRecordReference(s) RC_PAYTAX_MTDDefaultLabel TaxMTDLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAONCETAX_MTD_ADJDefaultLabel TaxMTDAdjustedLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOAXTAX_NOT_TAKENDefaultLabel TaxNotTakenLength 12Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAX_CANOKWKTAX_NUMBERDefaultLabel TaxIDNumberLength 8Type CharacterFormat UppercaseRecordReference(s) RC_US_YE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |33

    TAX_PERCENTAGEDefaultLabel TaxPercentageLength 2Type NumberFormat UppercaseRecordReference(s) P11D_SEC_A_UKUKTAX_PERIODSDefaultLabel TaxPeriodsLength 2Type NumberFormat UppercaseRecordReference(s) WRK_EARNINGSTBLTAX_PYMNT_TYPEDefaultLabel TaxPaymentTypeLength 5Type CharacterFormat UppercaseRecordReference(s) VOUCHER_STGTAX_QTDDefaultLabel TaxQTDLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAONCETAX_QTD_ADJDefaultLabel TaxQTDAdjustedLength 12Type SignedNumberFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |34

    RecordReference(s) UPG_E3XW_TAOAXTAX_QTRDefaultLabel TaxQuarterLength 3Type NumberFormat UppercaseRecordReference(s) RC_PAYTAX_REPORT_TYPEDefaultLabel TaxReportTypeLength 1Type CharacterFormat UppercaseRecordReference(s) COMPANY_TBL 2W2orTerritories NNone PW2PR R1099RTAX_RPT_INTERVALDefaultLabel TaxReportingLength 1Type CharacterFormat UppercaseRecordReference(s) STATE_TAX_TBL2 AAnnual MMonthly QQuarterlyTAX_RTDefaultLabel TaxRate(afterform)Length 8

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |35

    Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAX_1042TBLTAX_RT_NOFORMDefaultLabel TaxRate(beforeformreceived)Length 8Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOTBLTAX_SCALEDefaultLabel TaxScaleLength 3Type CharacterFormat UppercaseRecordReference(s) PKG_TAX_LANGTBLTAX_STATUSDefaultLabel TaxStatusLength 1Type CharacterFormat UppercaseRecordReference(s) STATE_TAXRT_TBL 0NoPersonalExemptions 1Maryland20%Local 2Maryland25%Local 3Maryland30%Local 4Maryland35%Local 5Maryland40%Local 6Maryland45%Local 7Maryland50%Local 8Maryland52%Local 9Maryland54%Local BMarriedBoth

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |36

    CNewJerseyRateTable'C' DNewJerseyRateTable'D' ENewJerseyRateTable'E' FSpecialSuppwith0Exemptions GSpecialSuppwith1Exemption HHeadofHousehold ISpecialSuppwith2Exemptions JMarried,Joint,Claim1/2Exmp KMaryland55%Local LMaryland56%Local MMarried NTaxStatusNotApplicable ONonResident PMaryland58%Local QNonResidentSupplemental RMaryland60%Local SSingle TSingleSpecial UMarriedSpecial VMarriedBothSpecial WMarylandandWorksinDelaware XSpecialSupplementalRates YHeadofHouseholdSpecialTAX_TYPEDefaultLabel TaxCalculationTypeLength 1Type CharacterFormat UppercaseRecordReference(s) ST_OTH_TAX_TBL GPercentofTaxableGross NNotApplicable UUseERWageforEETaxTAX_TYPE_CANDefaultLabel TaxTypeLength 4Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |37

    RecordReference(s) RC_XTAX_TYP_CANTAX_UPDTDefaultLabel TaxUpdateLength 6Type CharacterFormat UppercaseRecordReference(s) TAX_UPDATETAX_USER_CODEDefaultLabel UsercodeforTaxhandlingLength 1Type CharacterFormat UppercaseRecordReference(s) PA_DFN_OPT_SET NNoNontaxableBenCalc SSimplifiedNontaxableBenCalc YUserCodeforNontaxableBen.TAX_YEARDefaultLabel TaxYearLength 5Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAO8TAX_YEARLYDefaultLabel TaxYearlyLength 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |38

    TAX_YEAR_END_UKDefaultLabel TaxYearEndLength 4Type CharacterFormat UppercaseRecordReference(s) RUN_CNTL_CARKUK 1995YearEnding5thofApril1995 1996YearEnding5thofApril1996 1997YearEnding5thofApril1997 1998YearEnding5thofApril1998 1999YearEnding5thofApril1999 2000YearEnding5thofApril2000 2001YearEnding5thofApril2001 2002YearEnding5thofApril2002 2003YearEnding5thofApril2003 2004YearEnding5thofApril2004 2005YearEnding5thofApril2005TAX_YTDDefaultLabel TaxYTDLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOESSTAX_YTD_ADJDefaultLabel TaxYTDAdjustedLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOAXTA_BATCH_SIZEDefaultLabel MaxEmployeesInRulesRunLength 6Type Number

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |39

    Format UppercaseRecordReference(s) TL_TA_MAIN_AETNTA_COUNTERDefaultLabel TACOUNTERLength 15Type NumberFormat UppercaseRecordReference(s) TL_TA_MAIN_AETTA_COUNTER1DefaultLabel TACOUNTERLength 15Type NumberFormat UppercaseRecordReference(s) TL_TA_MAIN_AETTA_COUNTER2DefaultLabel TACOUNTERLength 15Type NumberFormat UppercaseRecordReference(s) TL_TA_MAIN_AETTA_LAST_ALIASDefaultLabel TimeAdminLastAliasLength 5Type CharacterFormat UppercaseRecordReference(s) TL_INSTALLATIONTA_LAST_SECTIONDefaultLabel TimeAdminLastSection

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |40

    Length 9Type NumberFormat UppercaseRecordReference(s) TL_INSTALLATIONTA_LAST_SQL_IDDefaultLabel TimeAdminLastSqlIDLength 9Type NumberFormat UppercaseRecordReference(s) TL_INSTALLATIONTA_PCT_COUNTERDefaultLabel TACOUNTERLength 15Type NumberFormat UppercaseRecordReference(s) TL_TA_MAIN_AETTA_PCT_COUNTER1DefaultLabel TACOUNTERLength 15Type NumberFormat UppercaseRecordReference(s) TL_TA_MAIN_AETTA_PCT_COUNTER2DefaultLabel TACOUNTERLength 15Type NumberFormat UppercaseRecordReference(s) TL_TA_MAIN_AET

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |41

    TA_RUNTIME_TBLDefaultLabel TimeAdminRuntimeTableLength 1Type CharacterFormat UppercaseRecordReference(s) TL_WORK_TABLESTA_STATUSDefaultLabel TimeAdministrationRunNeededLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TR_STATUSTA_TBL_LOOKUP_PCTDefaultLabel TimeAwareTableLookupPercenLength 10Type NumberFormat UppercaseRecordReference(s) PA_DFN_ACCOUNTTA_TBL_OPTIONSDefaultLabel TimeAwareTableOptionsLength 3Type CharacterFormat UppercaseRecordReference(s) PA_DFN_ACCOUNT FPDFirstDayofthePeriod FYCFirstDayoftheCalendarYear FYPFirstDayofthePlanYear LPDLastDayofthePeriodTA_THD_TBL_NM

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |42

    DefaultLabel TimeAwareThresholdTableNamLength 10Type CharacterFormat UppercaseRecordReference(s) PA_DFN_ACCOUNTTBARBTNSDefaultLabel EnabledToolbarButtonsLength 10Type NumberFormat 7RecordReference(s) PSPNLGRPDEFNTBILL_30YR_RATEDefaultLabel Tbill30yearrateLength 16Type NumberFormat UppercaseRecordReference(s) PA_TL_30YR_TBILTBLOCATIONDefaultLabel ToolbarLocationLength 1Type NumberFormat UppercaseRecordReference(s) PSTOOLBARDEFNTBL_EFFDTDefaultLabel UseTableinEffectonLength 10Type DateFormat UppercaseRecordReference(s) PA_DFN_COV_COMP

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |43

    TBL_EFFDT_ALIASDefaultLabel UseTableinEffectonLength 10Type CharacterFormat UppercaseRecordReference(s) PA_DFN_COV_COMPTBL_EFFDT_ALIASTDefaultLabel Length 2Type CharacterFormat UppercaseRecordReference(s) PA_DFN_COV_COMPTBL_LOOKUP_NAMEDefaultLabel TableLookupAliasNameLength 10Type CharacterFormat UppercaseRecordReference(s) PA_401A17_PARMSTBL_LOOKUP_PCTDefaultLabel PercentofTableLookupLength 10Type NumberFormat UppercaseRecordReference(s) PA_DFN_ACCOUNTTBL_STRT_EFF_CDDefaultLabel Start/EffdtuseindicatorLength 1Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |44

    RecordReference(s) PA_ALIAS_USETCD_FLAGDefaultLabel TimeCollectionDeviceIDLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLTTCD_GROUP_IDDefaultLabel TCDGroupIDLength 10Type CharacterFormat UppercaseRecordReference(s) TL_TCDGRP_TBLRVTCD_IDDefaultLabel TimeCollectionDeviceIDLength 10Type CharacterFormat UppercaseRecordReference(s) TL_TTHRS_TAOMSGTCD_MSG_TYPEDefaultLabel TCDMessageTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TCD_EIP_ERR EElapsed PPunched

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |45

    TCD_NETWORK_IDDefaultLabel NetworkIDLength 20Type CharacterFormat UppercaseRecordReference(s) TL_TTHRS_TAOMSGTCD_NODE_IDDefaultLabel TerminalIDLength 20Type CharacterFormat UppercaseRecordReference(s) TL_TTHRS_TAOMSGTCD_OPTDefaultLabel TCDIDOptionLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLT NNotUsed OOptional RRequiredTCD_SUPERVISR_IDDefaultLabel TCDSupervisorIDLength 20Type CharacterFormat UppercaseRecordReference(s) TL_TCD_SUPERVSGTCD_TYPE_IDDefaultLabel TypeofTimeCollectionDeviceLength 10

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |46

    Type CharacterFormat UppercaseRecordReference(s) TL_TCD_TBLTBLTC_ACTUAL_AMTDefaultLabel ActualAmountLength 20Type SignedNumberFormat UppercaseRecordReference(s) TC_TMP_DTL_TAOTC_CATEGORY1DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY10DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY11DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY12

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |47

    DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY13DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY14DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY2DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY3DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRK

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |48

    TC_CATEGORY4DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY5DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY6DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY7DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY8DefaultLabel CategoryNameLength 10Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |49

    Format UppercaseRecordReference(s) TC_CATEGORY_WRKTC_CATEGORY9DefaultLabel CategoryNameLength 10Type CharacterFormat UppercaseRecordReference(s) TC_CATEGORY_WRKTC_COMP_SOURCE_IDDefaultLabel CompensationSourceLength 10Type CharacterFormat UppercaseRecordReference(s) UPG_HR75_AETTAOTC_DRILL_THR_CUBEDefaultLabel DrillThoughCubeLength 254Type CharacterFormat UppercaseRecordReference(s) TC_RUNCNTL_CUBETC_EXCEL_BTNDefaultLabel LaunchExcelLength 1Type CharacterFormat UppercaseRecordReference(s) TC_EXCEL_RUNCTLTC_EXTRACT_STATUSDefaultLabel TotalCompExtractStatus

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |50

    Length 1Type CharacterFormat UppercaseRecordReference(s) TC_VCRUNCTL_TAO CCompleted SStartTC_FORECASTED_AMTDefaultLabel ForecastedAmountLength 20Type SignedNumberFormat UppercaseRecordReference(s) TC_VARCMP_TAOTC_FREQDefaultLabel PeriodFrequencyLength 1Type CharacterFormat UppercaseRecordReference(s) TC_PLANXT_AETET AAnnually MMonthly QQuarterlyTC_FREQ_FACTORDefaultLabel FrequencyAnnualFactorLength 9Type NumberFormat UppercaseRecordReference(s) TC_PAYEXT_AETETTC_FROZENDefaultLabel PlanFrozenLength 1

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |51

    Type CharacterFormat UppercaseRecordReference(s) TC_PLANXT_AETET NNo YYesTC_FTEDefaultLabel FTELength 15Type NumberFormat UppercaseRecordReference(s) TC_POPULATIONTC_HEAD_COUNTDefaultLabel HeadCountLength 6Type NumberFormat UppercaseRecordReference(s) TC_POPULATIONTC_MEASUREDefaultLabel AmountTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TC_EE_COMPURCEL CTransactionAmount PPayrollAmountTC_PLAN_EFFDTDefaultLabel TotalCompPlanEffdtLength 10Type DateFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |52

    RecordReference(s) TOTAL_DEDRECNTLTC_PLAN_IDDefaultLabel TotalCompPlanIDLength 10Type CharacterFormat UppercaseRecordReference(s) UPG_HR75_AETAOCTC_POP_FLAGDefaultLabel PopulationLength 1Type CharacterFormat UppercaseRecordReference(s) TC_EXCEL_RUNCTL EEmployee(s) GGroup(s)TC_REFRESH_BTNDefaultLabel RefreshLength 1Type CharacterFormat UppercaseRecordReference(s) TC_EE_COMPTC_RUN_TYPEDefaultLabel TotalCompExtractRunTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TC_RUN_CNTLETTL DDeleteRun SStandardRun

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |53

    TC_SORT_BYDefaultLabel SortByLength 1Type CharacterFormat UppercaseRecordReference(s) TC_BEN_RUN_CNTL DByDepartment LByLocation NByLastNameTC_THRU_YYYYMMDefaultLabel MonthandYearLength 6Type CharacterFormat UppercaseRecordReference(s) TC_OLAP_TIMETC_TIME_ROLLUPDefaultLabel TimeRollupAttributeLength 1Type CharacterFormat UppercaseRecordReference(s) TC_RUNCNTL_CUBE AAverage FFirstPeriod LLastPeriodTC_TYPEDefaultLabel CompensationTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TC_COMP_DEFN DDirect

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |54

    IIndirectTD1_ADJUSTDefaultLabel TD1AdjustmentLength 10Type NumberFormat UppercaseRecordReference(s) CAN_TAX_PRVDATATD1_BASIC_AMTDefaultLabel TD1BasicAmountLength 8Type NumberFormat UppercaseRecordReference(s) CAN_TAX_TBLTEACHERDefaultLabel AbletoTeachLength 1Type CharacterFormat UppercaseRecordReference(s) UPG_HR75_AETTEACH_WEEKS_AUSDefaultLabel TotalWeeksinTeachingJobLength 2Type NumberFormat UppercaseRecordReference(s) DETYA_PRCS_TMPTEAM_CODEDefaultLabel TeamCodeLength 4

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |55

    Type CharacterFormat UppercaseRecordReference(s) EMPLOY_TEAM_LNGTEAM_MEMBERDefaultLabel TeamMemberLength 11Type CharacterFormat UppercaseRecordReference(s) PROJ_ACT_TEAMTEAM_MEMBER_INDDefaultLabel TeamMemberIndicatorLength 1Type CharacterFormat UppercaseRecordReference(s) PROJ_ACT_TEAM EEmployee JJobCodeTECHNOLOGY_TYPEDefaultLabel TechnologyTypeLength 2Type CharacterFormat UppercaseRecordReference(s) EO_EIP_XML_TBLL 01Message 02ComponentInterface 03BusinessInterlink 04EDI 05MessageAgent 06XMLLinksTECH_CONTACT_ACODEDefaultLabel TechnicalContactAreaCode

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |56

    Length 3Type NumberFormat UppercaseRecordReference(s) CTXPRC_PARAMSTECH_CONTACT_EXTDefaultLabel TechnicalContactExt'nLength 4Type NumberFormat UppercaseRecordReference(s) CTXPRC_PARAMSTECH_CONTACT_NAMEDefaultLabel TechnicalContactNameLength 30Type CharacterFormat MixedcaseRecordReference(s) CTXPRC_PARAMSTECH_CONTACT_PHONEDefaultLabel TechnicalContactPhoneLength 7Type NumberFormat UppercaseRecordReference(s) CTXPRC_PARAMSTEC_BALANCEDefaultLabel BalanceTotalEmploymentCostLength 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |57

    TEC_CURRENTDefaultLabel CurrentTotalEmploymentCostLength 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBLTEC_PER_BALANCEDefaultLabel RemBalanceTEC(CurPeriod)Length 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBLTEC_PER_CURRENTDefaultLabel TotalTEC(CurPeriod)Length 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBLTEC_PER_TARGETDefaultLabel TargetTEC(CurPeriod)Length 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBLTEC_SUFFIXDefaultLabel TECSuffixCodeLength 5Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |58

    RecordReference(s) RC_QTR_UITEC_TARGETDefaultLabel TargetTotalEmploymentCostLength 17Type SignedNumberFormat UppercaseRecordReference(s) PKG_MDL_TBLTELEPHONE_NBRDefaultLabel TelephoneNumberLength 15Type CharacterFormat UppercaseRecordReference(s) TAX960_PARMGLDTEMPDATEDefaultLabel TempDateLength 10Type DateFormat UppercaseRecordReference(s) ST_ESPP_PRC_AETTEMPINSTANCEBATCHDefaultLabel TempTableInstances(Batch)Length 2Type NumberFormat UppercaseRecordReference(s) PSOPTIONSUN_AETTEMPINSTANCEONLINEDefaultLabel TempTableInstances(Online)

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |59

    Length 2Type NumberFormat UppercaseRecordReference(s) PSOPTIONSTEMPLATE_IDDefaultLabel ProjectTemplateLength 15Type CharacterFormat UppercaseRecordReference(s) TL_TMPL_DFN_LNGTEMPLATE_SWDefaultLabel UseProjectasTemplateLength 1Type CharacterFormat UppercaseRecordReference(s) PROJECT_FSTEMPLATE_TYPEDefaultLabel TemplateTypeLength 3Type CharacterFormat UppercaseRecordReference(s) TL_TMPL_DFN_LNG ACCAccumulator APPApprovalRequired ATTAttendance CONConsecutiveDays DFLDefault DTHDailyThreshold EXCException GUAGuaranteedHours HOLHoliday MEAMeal MISMiscellaneous

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |60

    MSPMissingPunch PRMPremiumZone PTRPeriodThreshold SCHScheduleDeviation SHFShiftPremium SPCSpecificDay TSKTaskTEMPTBLINSTDefaultLabel TEMPTBLINSTLength 1Type CharacterFormat UppercaseRecordReference(s) PSRECTBLSPCTEMPTBLINSTANCESDefaultLabel TempTableInstances(Total)Length 2Type NumberFormat UppercaseRecordReference(s) PSOPTIONSEFNTEMP_ASSGN_ID_LASTDefaultLabel LastTempAssignment#UsedLength 8Type NumberFormat UppercaseRecordReference(s) INSTALLATIONTEMP_DOCDefaultLabel TemporaryDocumentLength 1Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |61

    RecordReference(s) PSSUMMARYTBLTEMP_FLDDefaultLabel TemporaryFieldforAppEngineLength 1Type CharacterFormat UppercaseRecordReference(s) VC_PRO_PRDS_AETTEMP_FLD2DefaultLabel tempfield2Length 1Type CharacterFormat UppercaseRecordReference(s) GVT_MASSCHG_AETTEMP_FLD3DefaultLabel tempfieldLength 1Type CharacterFormat UppercaseRecordReference(s) GVT_MASSCHG_AETTEMP_KEY11DefaultLabel TemporaryKey(Char11)Length 11Type CharacterFormat UppercaseRecordReference(s) UPG_BN_GENERICTEMP_KEY2DefaultLabel TemporaryKey(Char2)Length 2

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |62

    Type CharacterFormat UppercaseRecordReference(s) UPG_BN_GENERICSTEMP_KEY4DefaultLabel TemporaryKey(Char4)Length 4Type CharacterFormat UppercaseRecordReference(s) UPG_BN_GENERICTEMP_KEY6DefaultLabel TemporaryKey(Char6)Length 6Type CharacterFormat UppercaseRecordReference(s) UPG_BN_GENERICTEMP_PURCH_DATEDefaultLabel ESPPTempPurchaseDateLength 10Type DateFormat UppercaseRecordReference(s) UPG_TL_AETTEMP_SSN_MASKDefaultLabel 'TemporarySSN'MaskLength 3Type CharacterFormat UppercaseRecordReference(s) INSTALLATIONTEMP_TBL_NAME

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |63

    DefaultLabel TemporaryTablenameLength 12Type CharacterFormat UppercaseRecordReference(s) TEMP_TBL_ASGNMTEMP_TBL_NUMDefaultLabel TemporaryTableNumberLength 3Type CharacterFormat UppercaseRecordReference(s) TEMP_TBL_ASGNMTENURE_ACCR_FLGDefaultLabel AccrueTenureServicesLength 1Type CharacterFormat UppercaseRecordReference(s) GVT_EMPL_TEMPTY NDoNotAccrue YAccrueTenureTENURE_STATUSDefaultLabel TenureStatusLength 3Type CharacterFormat UppercaseRecordReference(s) RUN_CNTL_EGATA DEFTenurebydefacto DENTenureDenied NANotApplicable NOTNonTenureNotOnTrack NTKNonTenureOnTrack OTHOther TENTenure

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |64

    TENYR_PART_SVC_DFNDefaultLabel TenYearPartServiceDefnLength 10Type CharacterFormat UppercaseRecordReference(s) PA_415_LIMITTENYR_PART_USERCDDefaultLabel TenYearParticipationUserCdLength 1Type CharacterFormat UppercaseRecordReference(s) PA_415_LIMITTENYR_RED_SVCDFNDefaultLabel TenYearSvcReductionSvcDfnLength 10Type CharacterFormat UppercaseRecordReference(s) PA_415_LIMITTENYR_RED_USERCDDefaultLabel TenyearreductionusercdLength 1Type CharacterFormat UppercaseRecordReference(s) PA_415_LIMITTEO1_RECNAMEDefaultLabel WorkRecord1NameLength 15Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |65

    Format UppercaseRecordReference(s) EO_CURRENCY_AETTEO2_RECNAMEDefaultLabel WorkRecord2NameLength 15Type CharacterFormat UppercaseRecordReference(s) EO_CURRENCY_AETTEO3_RECNAMEDefaultLabel WorkRecord3NameLength 15Type CharacterFormat UppercaseRecordReference(s) EO_CURRENCY_AETTEOA_RECNAMEDefaultLabel AuditRecordNameLength 15Type CharacterFormat UppercaseRecordReference(s) RUN_CNTL_AUD_EOTERMDefaultLabel TermLength 5Type NumberFormat UppercaseRecordReference(s) RUN_EO_RT_GEN_DTERMEE_PR_STOPDAYSDefaultLabel Term.EEsPRActivityDays

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |66

    Length 2Type NumberFormat UppercaseRecordReference(s) COMPANY_TBLTERMINAL_DEGREEDefaultLabel TerminalDegreeforDisciplineLength 1Type CharacterFormat UppercaseRecordReference(s) UPG_HR75_AETTERMINATIONSDefaultLabel TERMINATIONSLength 3Type NumberFormat UppercaseRecordReference(s) R_ACTION_COUNTSTERMINATION_DTDefaultLabel TerminationDateLength 10Type DateFormat UppercaseRecordReference(s) Z_NON_EMP_DATAETERMINATION_REASONDefaultLabel TerminationReasonCodeLength 3Type CharacterFormat UppercaseRecordReference(s) CO_DPK_EMP_TAON

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |67

    TERMINATION_TYPEDefaultLabel TerminationTypeLength 1Type CharacterFormat UppercaseRecordReference(s) CO_DPK_EMP_TAONTERMS_BASIS_DTDefaultLabel PaymentTermsBasisDateLength 10Type DateFormat UppercaseRecordReference(s) VOUCHER_STGTERM_CORRECT_BELDefaultLabel NumberofMonthstoReduceLength 5Type SignedNumberFormat UppercaseRecordReference(s) RUN_CNTL_HR_BELTERM_EMPL_PRCSDefaultLabel TerminatedEmployeesProcessedLength 1Type CharacterFormat UppercaseRecordReference(s) RETROPAY_EARNSTERM_EXPIRATN_DTDefaultLabel TerminationExpirationDateLength 10Type DateFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |68

    RecordReference(s) ST_TRSR_TAO3BLLTERM_LTD_AUSDefaultLabel AppointmentDurationLength 2Type NumberFormat UppercaseRecordReference(s) DETYA_PRCS_TMPTERM_PGM_IDDefaultLabel FinalCheckProgramIDLength 3Type CharacterFormat UppercaseRecordReference(s) TERM_RQSTT_ACCRTERM_PROC_RULEDefaultLabel FinalCheckProcessingRuleLength 1Type CharacterFormat UppercaseRecordReference(s) TERM_PGM_DEFDED 0RefundESPPBalance 1CollectPayPeriodDeduction 2CollectGoalDifference 3RefundLastDeduction 4RefundYeartoDateBalance 5RefundGoalBalance 6RefundSavBondBalance 7RefundBondBalReadytoDisb 8RefundMonthtoDateBalance 9RefundQuartertoDateBalanceTERM_PROC_STATUSDefaultLabel FinalCheckProcessingStatus

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |69

    Length 1Type CharacterFormat UppercaseRecordReference(s) TERM_RQSTWRK CPaysheetCreated NNotProcessed PLoadedtoPaysheets XExtractedTERM_PROJECTIONDefaultLabel StartProjectionLength 1Type CharacterFormat UppercaseRecordReference(s) PA_DFN_PIA AProjectionMethodAmount CwithActualCurrentYear PwithPriorYearTERM_REGRESSIONDefaultLabel StartRegressionUsingLength 1Type CharacterFormat UppercaseRecordReference(s) PA_DFN_PIA A1stYearAnnualized CActual1stYearAmount R1stYearAnnualPayRateTERM_REQUESTDefaultLabel TerminatedEmployeesLength 1Type CharacterFormat UppercaseRecordReference(s) RTROTERM_RUNCTL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |70

    TERM_TYPE_AUSDefaultLabel TypeofAppointmentLength 2Type CharacterFormat UppercaseRecordReference(s) DETYA_PRCS_TMP 00Limited 81Probationary 82Confirmed 91OtherTermTER_CARRYOVER_ITADefaultLabel TerminationCarryoverItemLength 1Type CharacterFormat UppercaseRecordReference(s) TER_CARRYOV_ITA PPTO RROL SScatti TTFR VVacationTER_PAYMENT_ITADefaultLabel TerminationPaymentItemLength 1Type CharacterFormat UppercaseRecordReference(s) TER_PAYMENT_ITA SLastSalary TTFRTESTDefaultLabel Test

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |71

    Length 1Type CharacterFormat UppercaseRecordReference(s) GPES_RC_SSKTEST_COMP_BALDefaultLabel TestCompBalancesLength 2Type CharacterFormat UppercaseRecordReference(s) TL_INSTALLATION BABatchOnly BOOnlineandBatch NONone ONOnlineOnlyTEST_IDDefaultLabel TestIDLength 5Type CharacterFormat UppercaseRecordReference(s) R_FINAL_RESULTSTEST_IND_FLAGDefaultLabel TestIndicatorFlagLength 1Type CharacterFormat UppercaseRecordReference(s) RC_US_YETEST_LV_BALDefaultLabel TestLeaveBalancesLength 2Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |72

    Format UppercaseRecordReference(s) TL_INSTALLATION BABatchOnly BOOnlineandBatch NONone ONOnlineOnlyTEST_PROD_INDCTRDefaultLabel WCBTestorProdIndicatorLength 1Type CharacterFormat UppercaseRecordReference(s) WCB_MSGHD_WDTEST_SS_ESPDefaultLabel TestLength 1Type CharacterFormat UppercaseRecordReference(s) RC_AFI_ESPTEXT15DefaultLabel Text(15Characters)Length 15Type CharacterFormat UppercaseRecordReference(s) RC_PAYINITTEXT20DefaultLabel Text(20Characters)Length 20Type CharacterFormat UppercaseRecordReference(s) RC_PAYINIT_AET

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |73

    TEXT254DefaultLabel TextLength 254Type CharacterFormat MixedcaseRecordReference(s) Z_SS_LWOP_TXT_QTEXTALIGNDefaultLabel TextAlignLength 2Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTDECORBLINKDefaultLabel TextDecorBlinkLength 3Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTDECORLINETHROUDefaultLabel TextDecorLineThroughLength 3Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTDECORNONEDefaultLabel TextDecorNoneLength 3Type Number

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |74

    Format UppercaseRecordReference(s) PSSTYLECLASSTEXTDECOROVERLINEDefaultLabel TextDecorOverLineLength 3Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTDECORUNDERLINEDefaultLabel TextDecorUnderLineLength 3Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTINDENTDefaultLabel TextIndentLength 2Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTINDENTLENDefaultLabel TextIndentLenLength 10Type NumberFormat 7RecordReference(s) PSSTYLECLASSTEXTINDENTUNITS

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |75

    DefaultLabel TextIndentUnitsLength 2Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXTTRANSFORMDefaultLabel TextTransformLength 2Type NumberFormat UppercaseRecordReference(s) PSSTYLECLASSTEXT_IDDefaultLabel TextIDLength 18Type CharacterFormat UppercaseRecordReference(s) W3EB_TXTMSG_LNGTEXT_W2_REQUESTDefaultLabel RequestforreplacementW2Length 75Type CharacterFormat UppercaseRecordReference(s) PY_IC_W2_WLTFLDADefaultLabel TurboCHARField,ValueALength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AET

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |76

    TFLDBDefaultLabel TurboCHARField,ValueBLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDCDefaultLabel TurboCHARField,ValueCLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDDDefaultLabel TurboCHARField,ValueDLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDEDefaultLabel TurboCHARField,ValueELength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDFDefaultLabel TurboCHARField,ValueFLength 40Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |77

    RecordReference(s) EO_CURRENC2_AETTFLDGDefaultLabel TurboCHARField,ValueGLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDHDefaultLabel TurboCHARField,ValueHLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDIDefaultLabel TurboCHARField,ValueILength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDJDefaultLabel TurboCHARField,ValueJLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDKDefaultLabel TurboCHARField,ValueK

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |78

    Length 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDLDefaultLabel TurboCHARField,ValueLLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDMDefaultLabel TurboCHARField,ValueMLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDNDefaultLabel TurboCHARField,ValueNLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLDODefaultLabel TurboCHARField,ValueOLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AET

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |79

    TFLDPDefaultLabel TurboCHARField,ValuePLength 40Type CharacterFormat MixedcaseRecordReference(s) EO_CURRENC2_AETTFLD_ADefaultLabel TurboDataFieldALength 10Type DateFormat UppercaseRecordReference(s) EO_CURRENC2_AETTFLD_BDefaultLabel TurboDataFieldBLength 10Type DateFormat UppercaseRecordReference(s) EO_CURRENC2_AETTFLD_CDefaultLabel TurboDateFieldCLength 10Type DateFormat UppercaseRecordReference(s) EO_CURRENC2_AETTFLD_DDefaultLabel TurboDateFieldDLength 10Type DateFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |80

    RecordReference(s) EO_CURRENC2_AETTFLD_EDefaultLabel TurboDateFieldELength 10Type DateFormat UppercaseRecordReference(s) EO_CURRENC2_AETTFLD__ADefaultLabel TurboDate/TimeStampALength 26Type DatetimeFormat 12RecordReference(s) EO_CURRENC2_AETTFLD__BDefaultLabel TurboDate/TimeStampBLength 26Type DatetimeFormat 12RecordReference(s) EO_CURRENC2_AETTFLD__CDefaultLabel TurboDate/TimeStampCLength 26Type DatetimeFormat 12RecordReference(s) EO_CURRENC2_AETTFLD__DDefaultLabel TurboDate/TimeStampDLength 26

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |81

    Type DatetimeFormat 12RecordReference(s) EO_CURRENC2_AETTFLD__EDefaultLabel TurboDate/TimeStampELength 26Type DatetimeFormat 12RecordReference(s) EO_CURRENC2_AETTFLD___ADefaultLabel TurboTimeFieldALength 15Type TimeFormat 12RecordReference(s) EO_CURRENC2_AETTFLD___BDefaultLabel TurboTimeFieldBLength 15Type TimeFormat 12RecordReference(s) EO_CURRENC2_AETTGTCOMPRELDTTMDefaultLabel TargetComparisonDtTmLength 26Type DatetimeFormat UppercaseRecordReference(s) PSPROJECTDEFN

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |82

    TGTDBNAMEDefaultLabel TargetDatabaseNameLength 8Type CharacterFormat UppercaseRecordReference(s) PSPROJECTDEFNTGTNODEDefaultLabel ResultNodeLength 30Type CharacterFormat UppercaseRecordReference(s) PSRELATTRXDELTGTOPRACCTDefaultLabel TargetOperatorAccountLength 8Type CharacterFormat UppercaseRecordReference(s) PSPROJECTDEFNTGTOPRIDDefaultLabel TargetUserIDLength 30Type CharacterFormat MixedcaseRecordReference(s) PSPROJECTDEFNTGTORIENTATIONDefaultLabel TargetOrientationLength 5Type NumberFormat 7RecordReference(s) PSPROJECTDEFN

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |83

    TGTRQSTMSGNAMEDefaultLabel RequestMessageNameLength 30Type CharacterFormat UppercaseRecordReference(s) PSRELATTRXDELTGTRQSTMSGVERDefaultLabel TargetRequestMessageVersionLength 30Type CharacterFormat MixedcaseRecordReference(s) PSRELATTRXDELTGTSERVERNAMEDefaultLabel TargetServerNameLength 48Type CharacterFormat UppercaseRecordReference(s) PSPROJECTDEFNTGTTRXTYPEDefaultLabel TransactionTypeLength 4Type CharacterFormat UppercaseRecordReference(s) PSRELATIONTRX IAInboundAsynchronous ISInboundSynchronous OAOutboundAsynchronous OSOutboundSynchronous

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |84

    TGT_ACTION_IDDefaultLabel TargetActionIDLength 12Type CharacterFormat UppercaseRecordReference(s) TL_TA_CPY_AETPYTGT_CONDITION_IDDefaultLabel TargetConditionIDLength 12Type CharacterFormat UppercaseRecordReference(s) TL_TA_CPY_AETPYTGT_FIELDNAMEDefaultLabel FieldNameLength 18Type CharacterFormat UppercaseRecordReference(s) TL_SQL_SEL_FLDSTGT_RECNAMEDefaultLabel TargetRecord(Table)NameLength 15Type CharacterFormat UppercaseRecordReference(s) TL_ACTIONSTGT_TL_RULE_IDDefaultLabel TargetTLRuleIDLength 12Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |85

    RecordReference(s) TL_TA_RULE_COPYTHEORETICAL_DAYSDefaultLabel TheoreticalWorkingDaysLength 8Type NumberFormat UppercaseRecordReference(s) EMSURVEY1_TAOTTHEORY_GRADE_GERDefaultLabel TheoreticalGradeLength 4Type CharacterFormat UppercaseRecordReference(s) UPG_HR75_AETTHERAPY_HOURS_NLDDefaultLabel TherapyHoursLength 4Type NumberFormat UppercaseRecordReference(s) GPNL_ABS_CMTSTHE_DATEDefaultLabel DateLength 10Type DateFormat UppercaseRecordReference(s) TL_ST_DELETESTHIRDPARTY_SICKPAYDefaultLabel ThirdpartysickpayLength 1Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |86

    Format UppercaseRecordReference(s) YE_W2C_DATADITTHIRD_PARTY_CD_BRADefaultLabel ThirdPartyCodeLength 4Type NumberFormat UppercaseRecordReference(s) ESTAB_TBL_BRATHIRD_PARTY_TAXDefaultLabel ThirdPartyTaxAmountLength 15Type NumberFormat UppercaseRecordReference(s) RC_THIRD_PARTYTHIRD_PERIODDefaultLabel CountThirdPeriodLength 1Type CharacterFormat UppercaseRecordReference(s) PA_DURATION_OPT DDays NNoneTHIRD_PTY_PCT_BRADefaultLabel SocialSecurityThirdPartyLength 6Type NumberFormat UppercaseRecordReference(s) ESTAB_TBL_BRA

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |87

    THIRD_ROUND_ELSEDefaultLabel RoundUpifPeriods>Length 3Type NumberFormat UppercaseRecordReference(s) PA_DURATION_OPTTHIRD_ROUND_RULEDefaultLabel RoundtheThirdPeriodLength 1Type CharacterFormat UppercaseRecordReference(s) PA_DURATION_OPT ERoundUpifPeriods> NNoThirdPeriodRoundRule URoundUpifPeriods>THIRD_ROUND_UPDefaultLabel RoundUpifPeriods>Length 3Type NumberFormat UppercaseRecordReference(s) PA_DURATION_OPTTHIRD_SORTDefaultLabel ThirdSortLength 1Type CharacterFormat UppercaseRecordReference(s) RC_CAN_YE 1EmployeeName 2EmplID 3EmplSIN

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |88

    THRESHOLD_DAYS_AUSDefaultLabel ThresholdDaysLength 3Type NumberFormat UppercaseRecordReference(s) CLM_INF_DTL_AUSTHRUDATEDefaultLabel EndDateLength 10Type DateFormat UppercaseRecordReference(s) Z_LG_AWD_RUNCTLTHRUDATE_CRSEDefaultLabel ThruDateLength 10Type DateFormat UppercaseRecordReference(s) TRN001_AETRN001THRUPUTTYPEDefaultLabel ThroughputTypeLength 1Type NumberFormat UppercaseRecordReference(s) PSCHNLDEFNTHRU_DATEDefaultLabel ThruDateLength 10Type DateFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |89

    RecordReference(s) WP_PSHARING_MSGTHRU_DTDefaultLabel ThruDateLength 10Type DateFormat UppercaseRecordReference(s) RUN_CNTL_BIAFTTHRU_DT_RUNDefaultLabel ThruDatefromRunControlLength 10Type DateFormat UppercaseRecordReference(s) TC_BENEFITS_AETTHRU_DT_WRKDefaultLabel ThruDateWorkLength 10Type DateFormat UppercaseRecordReference(s) TC_PAYEXT_AETTHRU_MONTHDefaultLabel ProcessThruMonthLength 2Type NumberFormat UppercaseRecordReference(s) WRK_IMP_EMPLTLTHURSDefaultLabel ThursdayLength 1

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |90

    Type CharacterFormat UppercaseRecordReference(s) APPLICANT_DATATHURS_HRSDefaultLabel ThursdayLength 5Type NumberFormat UppercaseRecordReference(s) POSITION_DATARYTHURS_PAIDDefaultLabel PaidLength 1Type CharacterFormat UppercaseRecordReference(s) FMLA_LV_HISTORYTIMEDOUTDefaultLabel TimedOutLength 5Type NumberFormat 7RecordReference(s) PSWORKLISTTIMEOUTACTIVEDefaultLabel TimeOutActiveLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |91

    TIMEOUTEMAILOPRDefaultLabel TimeOutEmailOprLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTETIMEOUTEMAILSUPRDefaultLabel TimeOutEmailSuprLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTETIMEOUTMAXDAYSDefaultLabel TimeOutMaxDaysLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTETIMEOUTMAXHRSDefaultLabel TimeOutMaxHoursLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTETIMEOUTMAXMINSDefaultLabel TimeOutMaxMinutesLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |92

    TIMEOUTMINUTESDefaultLabel TimeoutMinutesLength 5Type NumberFormat 7RecordReference(s) PSOPTIONSFNTIMEOUTWLOPRDefaultLabel TimeOutWlOprLength 5Type NumberFormat 7RecordReference(s) PSEVENTROUTETIMEOUT_ACTDefaultLabel TimeoutActivityLength 30Type CharacterFormat MixedcaseRecordReference(s) WF_TO_WLTIMEOUT_BPDefaultLabel BusinessProcessLength 30Type CharacterFormat MixedcaseRecordReference(s) WF_TO_WLTIMEOUT_EVENTDefaultLabel TimeoutEventLength 30Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |93

    Format MixedcaseRecordReference(s) WF_TO_WLTIMEOUT_INSTANCEDefaultLabel InstanceIDLength 10Type NumberFormat 7RecordReference(s) WF_TO_WLTIMEOUT_WLDefaultLabel TimeoutWorklistLength 30Type CharacterFormat MixedcaseRecordReference(s) WF_TO_WLTIMESTAMPFIELDNAMEDefaultLabel RowLevelTimeStampFieldNameLength 18Type CharacterFormat UppercaseRecordReference(s) PSRECDEFNTIMES_APPLIEDDefaultLabel TimesAppliedLength 2Type NumberFormat UppercaseRecordReference(s) SCH_DEFN_DTLTIMETOLIVE

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |94

    DefaultLabel TimeToLiveLength 3Type NumberFormat UppercaseRecordReference(s) PSBATCHAUTHTIMEZONEDefaultLabel TimeZoneLength 9Type CharacterFormat UppercaseRecordReference(s) UPG_TL_AETIMEMETIMEZONEDSTLBLDefaultLabel TimeZoneDaylightLabelLength 8Type CharacterFormat UppercaseRecordReference(s) PSTIMEZONELANGTIMEZONEFIELDNAMEDefaultLabel TimeZoneFieldNameLength 18Type CharacterFormat UppercaseRecordReference(s) PSRECFIELDDBCURTIMEZONELABELDefaultLabel TimeZoneLabelLength 8Type CharacterFormat UppercaseRecordReference(s) PSTZOFFSET

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |95

    TIMEZONESTDLBLDefaultLabel TimeZoneStandardLabelLength 8Type CharacterFormat UppercaseRecordReference(s) PSTIMEZONELANGTIMEZONEUSEDefaultLabel TimeZoneUseLength 2Type NumberFormat UppercaseRecordReference(s) PSRECFIELDDBCURTIMEZONE_FLAGDefaultLabel TimeZoneLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLTTIMEZONE_OPTDefaultLabel TimeZoneOptionLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLT NNotUsed OOptional RRequiredTIME_AND_LABORDefaultLabel Time&&LaborChginPayPerd

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |96

    Length 1Type CharacterFormat UppercaseRecordReference(s) RETROPAYPGM_TBLTIME_BEGAN_WKDefaultLabel TimeEmployeeBeganWorkLength 12Type CharacterFormat UppercaseRecordReference(s) OSHA_301_REPORTTIME_BEGIN_DTDefaultLabel TimeSpanBeginDateLength 10Type DateFormat UppercaseRecordReference(s) MC_DEFN_PCTIME_EDITDefaultLabel CumulativeEditTimeLength 15Type TimeFormat 12RecordReference(s) VOUCHER_STGTIME_ELAPSEDDefaultLabel ElapsedTime(inmilliseconds)Length 15Type NumberFormat UppercaseRecordReference(s) BAT_TIMINGS_LOG

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |97

    TIME_END_DTDefaultLabel TimeSpanEndDateLength 10Type DateFormat UppercaseRecordReference(s) MC_DEFN_PCTIME_INPUT_NBRDefaultLabel TIME_INPUT_NBRLength 15Type NumberFormat UppercaseRecordReference(s) GP_TL_PRSLT_WRKTIME_IN_HRDefaultLabel TimeInHourLength 2Type NumberFormat UppercaseRecordReference(s) SHIFT_TBLTIME_IN_MINDefaultLabel TimeInMinuteLength 2Type NumberFormat UppercaseRecordReference(s) SHIFT_TBLTIME_IN_PCDefaultLabel PeopleCodeTime(inmillisecs)Length 15Type NumberFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |98

    RecordReference(s) BAT_TIMINGS_LOGTIME_IN_SQLDefaultLabel SQLTime(inmilliseconds)Length 15Type NumberFormat UppercaseRecordReference(s) BAT_TIMINGS_LOGTIME_MANDDefaultLabel Full/PartimeMandatoryLength 1Type CharacterFormat UppercaseRecordReference(s) JOB_RQMT_TBLTIME_OUT_HRDefaultLabel TimeOutHourLength 2Type NumberFormat UppercaseRecordReference(s) SHIFT_TBLTIME_OUT_MINDefaultLabel TimeOutMinuteLength 2Type NumberFormat UppercaseRecordReference(s) SHIFT_TBLTIME_PERIOD_CDDefaultLabel TimePeriodLength 1

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |99

    Type CharacterFormat UppercaseRecordReference(s) WCB_IWWI_WDCAN BBiweekly DDay HHour MMonth QQuarter SSemimonthly TTenmonthly WWeek YYearTIME_RECORD5DefaultLabel TimeRecordedLength 5Type CharacterFormat UppercaseRecordReference(s) WCB_EDSR_WDTIME_RECORDEDDefaultLabel TimeRecordedLength 15Type TimeFormat UppercaseRecordReference(s) INCIDENT_DATATIME_REPORTEDDefaultLabel TimeReportedLength 15Type TimeFormat UppercaseRecordReference(s) INCIDENT_DATA

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |100

    TIME_REPORTED5DefaultLabel TimeReportedLength 5Type CharacterFormat UppercaseRecordReference(s) WCB_EMDE_WDTIME_RPTG_CDDefaultLabel TimeReportingCodeLength 5Type CharacterFormat UppercaseRecordReference(s) UPG_TL_TRC_XREFTIME_RPTG_CD_TYPEDefaultLabel TimeReportingCodeTypeLength 1Type CharacterFormat UppercaseRecordReference(s) UPG_TL_TRC_XREF AAmountsOnly BBothHoursandAmountsOK EEitherHoursorAmountsOK HHoursOnly UUnitsOnlyTIME_RPTG_STATUSDefaultLabel TimeReporterStatusLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPT_EMPL_MSG AActive IInactive

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |101

    TIME_RPTG_TMPLTDefaultLabel TimeReportingTemplateIDLength 10Type CharacterFormat UppercaseRecordReference(s) TL_RPTMPLT_LANGTIME_RPTG_TYPEDefaultLabel TimeReportingTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TL_WRKGRP_TBLET EExceptionTimeReporting PPositiveTimeReportingTIME_RPTR_INDDefaultLabel TimeReporterIndicatorLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLTLT EElapsedTimeReporter PPunchTimeReporterTIME_RPT_LOCDefaultLabel TimeReportingLocationLength 6Type CharacterFormat UppercaseRecordReference(s) TIMLOC_TBL_LNGLTIME_RQRMT_AMTDefaultLabel Hrs/TimeTimeRequirementAmt

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |102

    Length 3Type NumberFormat UppercaseRecordReference(s) PA_DFN_SVCTIME_RQSTDDefaultLabel TimeRequestedLength 4Type NumberFormat UppercaseRecordReference(s) FMLA_LV_REQUESTTIME_RQSTD_UNITSDefaultLabel TimeRequested(Units)Length 1Type CharacterFormat UppercaseRecordReference(s) FMLA_LV_REQUEST DDays HHours WWeeksTIME_STAMPDefaultLabel TimeStampLength 26Type DatetimeFormat 13RecordReference(s) ENCUMB_TRIGGERTIME_TRANSDefaultLabel TimeTransmittedLength 15Type TimeFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |103

    RecordReference(s) HS_RPT_HIST_CANTIME_TRANSMIT5_CANDefaultLabel TimeTransmittedLength 5Type CharacterFormat UppercaseRecordReference(s) WCB_EDSR_WDTIME_ZONE_FLAGDefaultLabel TimeZoneLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPDTME_TMPLTTIPS_ADJDefaultLabel TipAdjustmentLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOTIPS_ADJUSTDefaultLabel AdjusttoMinimumWageLength 1Type CharacterFormat UppercaseRecordReference(s) UPG_E3XW_TAOTIPS_ALLOC_METHDefaultLabel TipsAllocationMethod

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |104

    Length 1Type CharacterFormat UppercaseRecordReference(s) TIPS_ESTAB_TBL FGoodFaith(Custom) HHoursWorked RGrossReceiptsTIPS_APPR_INPDefaultLabel ApproveAllocatedTipsLength 1Type CharacterFormat UppercaseRecordReference(s) TIPS_ALL_RUNCTLTIPS_CALC_INPDefaultLabel CalculateAllocatedTipsLength 1Type CharacterFormat UppercaseRecordReference(s) TIPS_ALL_RUNCTLTIPS_CALC_RUNDefaultLabel AllocatedTipsCalculatedLength 1Type CharacterFormat UppercaseRecordReference(s) TIPS_ALLOC_PDTIPS_CATEGORYDefaultLabel TipsCategoryLength 1Type CharacterFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |105

    RecordReference(s) UPG_E3XW_TAO ATipAllocation CTipCredit NNotTips RReportedTips SOtherSysCalc'dTipsTIPS_CURDefaultLabel CurrentTipssubjecttotaxLength 12Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAXW_TAOKTIPS_DELAYEDDefaultLabel CurrentTipsDelayedforW/HLength 12Type SignedNumberFormat UppercaseRecordReference(s) WRK_TAXW_TAOKTIPS_DELAY_WTHLDDefaultLabel DelayWithholdingofTaxesLength 1Type CharacterFormat UppercaseRecordReference(s) ST_OTH_TAX_TBLTIPS_ESTABDefaultLabel TipsEstablishmentIDLength 20Type CharacterFormat UppercaseRecordReference(s) WRK_TIPS_ALLOC2

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |106

    TIPS_ESTBLSH_FLDDefaultLabel TipEstablishmentFieldLength 2Type CharacterFormat UppercaseRecordReference(s) COMPANY_TBL JBJobBusinessUnit JCJobCompany JDJobDeptID JLJobLocation PBPayEarningsBusUnit PCPayEarningsCompany PDPayEarningsDeptIDTIPS_MTDDefaultLabel MTDTaxableTipsLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOTIPS_MTD_ADJDefaultLabel MTDTipsAdjustedLength 12Type SignedNumberFormat UppercaseRecordReference(s) UPG_E3XW_TAOTIPS_MTD_THRESHOLDDefaultLabel StateTipsW/HThresholdLength 19Type NumberFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |107

    RecordReference(s) STATE_TAX_TBLTIPS_PROCESSINGDefaultLabel TipsProcessingLength 1Type CharacterFormat UppercaseRecordReference(s) UPG_E3XW_TAOTIPTEXTDefaultLabel tooltipforcustombtnsLength 30Type CharacterFormat MixedcaseRecordReference(s) PSTOOLBARITEMGTITLEDefaultLabel TitleLength 30Type CharacterFormat MixedcaseRecordReference(s) Z_NEDC_USER_TMPTITLE1DefaultLabel Title1Length 50Type CharacterFormat MixedcaseRecordReference(s) Z_NON_EMP_DATATITLE_NBR_FRADefaultLabel TitleNumberLength 12

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |108

    Type CharacterFormat UppercaseRecordReference(s) UPG_ER_AET_FRATKN_EFFDT_USEDDefaultLabel Datedriving'processed'codeLength 10Type DateFormat UppercaseRecordReference(s) TL_TR_CTVAL_AETTLDefaultLabel PS/TimeandLaborProductLength 1Type CharacterFormat UppercaseRecordReference(s) INSTALLATIONTLERN_STATUSDefaultLabel TLERNSTATUSLength 1Type CharacterFormat UppercaseRecordReference(s) GP_TLTRC_WRKTL_ACTION_TYPEDefaultLabel ActionTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TL_ACTIONS 0Delete 1Insert 2Update

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |109

    TL_ADDREP_INDDefaultLabel Add/ReplaceLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TRSUBMIT_AET AAdd RReplaceTL_COMMENTSDefaultLabel CommentsLength 254Type CharacterFormat MixedcaseRecordReference(s) TL_ST_PCHTIMEMETL_COPY_FROMDefaultLabel MapToNAEarningCodeLength 3Type CharacterFormat UppercaseRecordReference(s) TL_TRC_TBLBLTL_CREATE_RUNCTLDefaultLabel CreateRunControlLength 1Type CharacterFormat UppercaseRecordReference(s) TL_CALL_TA_AETTL_DAYOFWEEK_FLAGDefaultLabel DayoftheWeek

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |110

    Length 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLTTL_DAYOFWEEK_OPTDefaultLabel DayofWeekOptionLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPTD_TMPLT NNotUsed OOptional RRequiredTL_DISPLAY_OPTIONSDefaultLabel DisplayOptionsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_LPAD_DISPLAY EReportedElapsedHours FForecastedPayableHours SScheduledHours XNumberofExceptions YPayableHoursTL_DISTRIB_INFODefaultLabel UseTLDistributionLength 1Type CharacterFormat UppercaseRecordReference(s) R_PER507

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |111

    TL_EFFDT_TYPEDefaultLabel EffectiveDateTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TL_SQL_TABLES 0CurrentDate 1ExpressionTL_ERNCDDefaultLabel EarningsCodeLength 22Type CharacterFormat UppercaseRecordReference(s) TL_PAYROLL_REQTL_EXCEPT_CTDefaultLabel ExceptionsRowCountLength 9Type NumberFormat UppercaseRecordReference(s) TL_TA_RSL_MAINTL_EXCEP_STATUSDefaultLabel StatusLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RUNCTL_SQR AAllStatus XUnresolved/ChangedTL_FORECASTED_INDDefaultLabel ForecastPayableTimeLength 1

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |112

    Type CharacterFormat UppercaseRecordReference(s) TL_TA_RUNCTLINTL_FRCT_TIME_CTDefaultLabel ForecastedTimeRowCountLength 9Type NumberFormat UppercaseRecordReference(s) TL_TA_RSL_MAINTL_GROUP_BOXDefaultLabel GroupBoxLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RUNCTL_SQRTL_IN_PRODDefaultLabel ProductionEnvironmentLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_MAIN_AETNTL_IPT_CTDefaultLabel IPTRowCountLength 9Type NumberFormat UppercaseRecordReference(s) TL_TA_RSL_MAIN

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |113

    TL_KEEP_CTDefaultLabel KeepLast(n)TimeAdminRunsLength 2Type NumberFormat UppercaseRecordReference(s) TL_TA_OPTIONSTTL_LKUP1_ALIAS_NMDefaultLabel AliasnameifaliastypeLength 10Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_LKUP1_ALIAS_TYPDefaultLabel AliastypeLength 2Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_LKUP1_TYPE_CDDefaultLabel AliasorInternallinkageLength 1Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUP AUseAlias IProgramGeneratedTL_LKUP2_ALIAS_NMDefaultLabel Aliasnameif'alias'typeLength 10Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |114

    Format UppercaseRecordReference(s) PA_TBL_LOOKUPTL_LKUP2_ALIAS_TYPDefaultLabel AlilastypeLength 2Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_LKUP2_TYPE_CDDefaultLabel AliasorInternalPgmGenerateLength 1Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUP AAliasResolved IInternalProgramGeneration NNotApplicable(OneWayTbl)TL_LOGICAL_OPDefaultLabel LogicalOperatorLength 1Type CharacterFormat UppercaseRecordReference(s) TL_SQL_WHERE 0OR 1AND 2WHERE 3HAVING 9NONETL_MATH_OPRDefaultLabel Math.operatorLength 1

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |115

    Type CharacterFormat UppercaseRecordReference(s) TL_SQL_UPDATE *MultipliedBy +AddedTo SubtractedBy /DividedBy 0NoneTL_MOBILEDefaultLabel PS/MobileTimeManagementLength 1Type CharacterFormat UppercaseRecordReference(s) INSTALLATIONTL_MONTHCDDefaultLabel MonthLength 2Type CharacterFormat UppercaseRecordReference(s) TL_LPAD_DISPLAY 0101January 0202February 0303March 0404April 0505May 0606June 0707July 0808August 0909September 1010October 1111November 1212DecemberTL_MONTH_LIMIT

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |116

    DefaultLabel NumberofMonthsLength 4Type NumberFormat UppercaseRecordReference(s) TL_OT_MONTH_TBLTL_NAMEDefaultLabel NAMELength 50Type CharacterFormat NameRecordReference(s) TL_OT_SUB_WLTL_ONLINE_RULESDefaultLabel T&&LOnlineRulesLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_RUNCTLETTL_OT_DATEDefaultLabel OvertimeDateLength 10Type DateFormat UppercaseRecordReference(s) TL_OT_DATATL_OT_HOURSDefaultLabel OvertimeHoursLength 2Type NumberFormat UppercaseRecordReference(s) TL_OT_DATA

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |117

    TL_OT_HOURS_LIMITDefaultLabel OvertimeHoursLength 4Type NumberFormat UppercaseRecordReference(s) TL_OT_MONTH_TBLTL_OT_IDDefaultLabel OvertimeLimitIDLength 8Type CharacterFormat UppercaseRecordReference(s) TL_WRKGRP_TBLBLTL_OT_STATUSDefaultLabel StatusLength 3Type CharacterFormat UppercaseRecordReference(s) TL_OT_DATA APVApproved DNYDenied ERRError SUBSubmittedTL_OUT_RECORD_NMDefaultLabel OutputrecordnameLength 15Type CharacterFormat UppercaseRecordReference(s) TL_SCHRPT_AETTTL_PAY_TIME_CT

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |118

    DefaultLabel PayableTimeRowCountLength 9Type NumberFormat UppercaseRecordReference(s) TL_TA_RSL_MAINTL_PRCS_END_DTTMDefaultLabel ProcessEndDatetimeLength 26Type DatetimeFormat 13RecordReference(s) TL_PRCS_QUEUETL_PRCS_INSTANCEDefaultLabel ProcessInstanceLength 10Type NumberFormat 7RecordReference(s) TL_ST_PARMS_AETTL_PRCS_START_DTTMDefaultLabel ProcessStartDatetimeLength 26Type DatetimeFormat 13RecordReference(s) TL_PRCS_QUEUETL_PRD_BGN_DTDefaultLabel Time&&LaborPeriodBgnDtLength 10Type DateFormat UppercaseRecordReference(s) GP_TL_TRG_WRKL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |119

    TL_PRD_END_DTDefaultLabel Time&&LabaorPeriodEndDtLength 10Type DateFormat UppercaseRecordReference(s) GP_TL_TRG_WRKLTL_PRD_IDDefaultLabel Time&LaborCalPerIDLength 10Type CharacterFormat UppercaseRecordReference(s) GP_CAL_RUN_DTLTL_PREFIXDefaultLabel PrefixLength 11Type CharacterFormat UppercaseRecordReference(s) TL_EE_EXPND_PRETL_PROCESS_TYPEDefaultLabel Time&&LaborProcessTypeLength 1Type CharacterFormat UppercaseRecordReference(s) TL_PRCS_QUEUE 0SubmitTime 1TimeValidationTL_PT_POI_STDTDefaultLabel PayableTimePOIStartDate

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |120

    Length 10Type DateFormat UppercaseRecordReference(s) TL_TA_MAIN_AETTL_QUANTITYDefaultLabel QuantityLength 20Type SignedNumberFormat UppercaseRecordReference(s) UPG_TL_TIME1CDTTL_QUANTITY1DefaultLabel QuantityLength 20Type SignedNumberFormat UppercaseRecordReference(s) TL_TA000900_AETTL_QUANTITY2DefaultLabel TL_QUANTITY2Length 20Type SignedNumberFormat UppercaseRecordReference(s) TL_COMPTIME_AETTL_QUANTITY3DefaultLabel TL_QUANTITY3Length 20Type SignedNumberFormat UppercaseRecordReference(s) TL_COMPTIME_AET

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |121

    TL_QUANTITY4DefaultLabel TL_QUANTITY4Length 20Type SignedNumberFormat UppercaseRecordReference(s) TL_COMPTIME_AETTL_QUANTITY_FLAGDefaultLabel QuantityLength 1Type CharacterFormat UppercaseRecordReference(s) TL_RPDTME_TMPLTTL_RPTD_TIME_EXISTDefaultLabel ReportedTimeExistLength 1Type CharacterFormat UppercaseRecordReference(s) TL_ST_PARMS_AETTL_RSLT_NUM_RND_CDDefaultLabel NumericResultRoundCodeLength 1Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUP NNone URoundNumericResultUpTL_RSLT_RND_MTHDDefaultLabel TbllookuprsltrndmethodLength 10Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |122

    Format UppercaseRecordReference(s) PA_TBL_LOOKUPTL_RSL_BATCH_INDDefaultLabel StoreBatchStatsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_OPTIONSTTL_RSL_BAT_BTNDefaultLabel ViewBatchStatsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_RSL_MAINTL_RSL_MAIN_INDDefaultLabel StoreMacroTimeAdminStatsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_OPTIONSTTL_RSL_SECT_BTNDefaultLabel AESectionStatsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_RSL_MAINTL_RSL_SECT_IND

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |123

    DefaultLabel StoreSectionStatsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_OPTIONSTTL_RULE_IDDefaultLabel RuleIDLength 12Type CharacterFormat UppercaseRecordReference(s) TL_TMPLT_R_LANGTL_RULE_STEPDefaultLabel RuleStepLength 2Type NumberFormat UppercaseRecordReference(s) TL_TMPLT_STEPSTL_SELFLD_SRCDefaultLabel SourceofSelectFieldLength 1Type CharacterFormat UppercaseRecordReference(s) TL_SQL_SEL_FLDS 0Recfield 1Expression 2Constant 3StateVariable 4TemplateTL_SENT_INDDefaultLabel TLSentIndicator

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |124

    Length 1Type CharacterFormat UppercaseRecordReference(s) GP_CAL_RUNTL_SENT_TSDefaultLabel TLSentTimestampLength 26Type DatetimeFormat UppercaseRecordReference(s) GP_TLCOST_STRMTL_SEQ_NUMDefaultLabel TableLookupSequenceNumberLength 5Type NumberFormat UppercaseRecordReference(s) TL_OT_SUB_WLTBLTL_SOURCEDefaultLabel Time&&LaborSourceFlagLength 1Type CharacterFormat UppercaseRecordReference(s) WRK_OTH_EARNS TTimeandLaborRecord UUserUpdated/CreatedRecordTL_SUBMIT_DTDefaultLabel SubmitDateLength 10Type DateFormat UppercaseRecordReference(s) TL_OT_DATA

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |125

    TL_SUBMIT_IDDefaultLabel SubmitIDLength 34Type CharacterFormat UppercaseRecordReference(s) TL_TRSUBMIT_AETTL_SUBMIT_SRCDefaultLabel Time&&LaborSubmitSourceLength 2Type CharacterFormat UppercaseRecordReference(s) TL_TRSUBMIT_AET ACAggregateCrew ALAggregateLumpSum APAggregatePattern ARAggregateRangeofDates CICollectionInterface RURapidUpdateTL_SYSTEM_DTDefaultLabel TLSystemDateLength 10Type DateFormat UppercaseRecordReference(s) TL_TA_MAIN_AETYTL_TAKECDDefaultLabel GlobalPayrollTakeCodeLength 22Type CharacterFormat UppercaseRecordReference(s) TL_ERNCD_TBL

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |126

    TL_TA_RUNTIMEDefaultLabel RunTimeLength 15Type CharacterFormat UppercaseRecordReference(s) TL_TA_RSL_SECTHTL_TA_STARTEDDefaultLabel StartedFromTARunControlLength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_RUNCTLETTL_TBL_1ST_COL_NMDefaultLabel lookuptable1stcolumnnameLength 18Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_TBL_1ST_COL_PICDefaultLabel lookuptable1stcolpictureLength 10Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_TBL_2ND_COL_NMDefaultLabel lookuptable2ndcolumnnameLength 18Type Character

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |127

    Format UppercaseRecordReference(s) PA_TBL_LOOKUPTL_TBL_2ND_COL_PICDefaultLabel lookuptable2ndcolpictureLength 10Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_TBL_3RD_COL_NMDefaultLabel lookuptable3rdcolumnnameLength 18Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_TBL_3RD_COL_PICDefaultLabel lookuptable3rdcolpictureLength 10Type CharacterFormat UppercaseRecordReference(s) PA_TBL_LOOKUPTL_TIME_TO_PAYDefaultLabel SendTimetoPayrollLength 1Type CharacterFormat UppercaseRecordReference(s) TL_EMPL_DATATL_TR_CTDefaultLabel TimeReporterCount

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |128

    Length 9Type NumberFormat UppercaseRecordReference(s) TL_TA_RSL_BATCHTL_USER_EXITDefaultLabel UserExit?Length 1Type CharacterFormat UppercaseRecordReference(s) TL_TMPLT_DEFNTL_USE_RPTD_TIMEDefaultLabel UseReportedTimeforPOILength 1Type CharacterFormat UppercaseRecordReference(s) TL_TA_RUNCTLETTL_WF_ACTIONDefaultLabel WorkflowActionLength 3Type CharacterFormat UppercaseRecordReference(s) TL_OT_STATUS APVApproved DNYDenied SUBSubmittedTL_WV_CHUNK_MAXDefaultLabel MaximumTimeReportersShownLength 2Type NumberFormat Uppercase

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |129

    RecordReference(s) TL_WV_SYMB_OPTNTL_WV_COLORDefaultLabel ColorLength 3Type CharacterFormat UppercaseRecordReference(s) TL_WV_OPTIONS BGRBlueGreen BLUBlue BRNBrown GRNGreen GRYGray LBLLightBlue LGRLightGreen LGYLightGray LYLLightYellow ORNOrange PNKPink REDRed RVLRedViolet TANTan VLTViolet YELYellowTL_WV_OPTN_USEDefaultLabel DisplayLength 1Type CharacterFormat UppercaseRecordReference(s) TL_WV_OPTIONSTL_WV_PRIORITYDefaultLabel PriorityLength 2Type Number

  • EmpowHRDataDictionary PreparedbyInformationManagementResources,Inc.on8/4/2008Section3.4FieldsAlphabetsTZ.doc P a g e |130

    Format UppercaseRecordReference(s) TL_WV_OPTIONSTL_WV_SHOW_SYMBOLSDefaultLabel DisplaySymbolsLength 1Type CharacterFormat UppercaseRecordReference(s) TL_WV_SYMB_OPTNTL_WV_


Semitic Alphabets - aschmann.net Alphabets Last update: February 4, 2017 1 Rick Aschmann Semitic Alphabets Rick Aschmann Most Semitic alphabets are actually abjads, and only include

Short Story (alphabets)

100 New Alphabets

Spanish alphabets

Zing with alphabets

New Zanerian Alphabets

Eʋe Alphabets

Gujarati Alphabets

Alphabets Book

English Alphabets

Kannada Alphabets

Taha & wAw Alphabets Terminology · {Taha} & {wAw}, The Universal Methods of Writing – Alphabets Terminology 0 Taha & wAw Alphabets Terminology Writing Geometric Method {Taha} {TaYa}

Draw Your Alphabets

Greek alphabets

Semitic Alphabets

This game is titled Dragon Ball Z.doc

Odia Alphabets

Hindi Alphabets Varnamala

Magical Alphabets

Learn Malayalam Alphabets

Burial Alphabets Proofs

Shorthand Alphabets

Human Alphabets 2

Alphabets Flashcard

Modern Alphabets

Russian Alphabets

all alphabets

Human Alphabets 1

3 Alphabets

Unit 3 alphabets

Telugu Alphabets

Jain Alphabets

Alphabets Year 1

Learning Alphabets & Numbers

Animated Alphabets