Table Of Content

SECTION 2.3- RECORDS FOR ALPHABETS H-S This section includes the record names, record descriptions, fields, and key of all records. The records that are used by the National Finance Center have an asterisk included. Records Description Fields Key HAZ_CON_MAT_LNG Related Lang-Hazardous Mtl Tbl DESCR DESCRSHORT EFFDT KEY(4) HAZARD_ID KEY(2) LANGUAGE_CD KEY(3) SETID KEY(1) HAZ_CON_MAT_TBL Hazardous Conditn/Matrl Codes DESCR DESCRSHORT EFFDT KEY(3) EFF_STATUS HAZARD_CLASS HAZARD_DIVISION HAZARD_ID KEY(2) HAZARD_TYPE SETID KEY(1) HEALTH_BENEFIT EE Health Benefit Elections BENEFIT_NBR KEY(5) BENEFIT_PLAN COBRA_EVENT_ID KEY(3) COVERAGE_BEGIN_DT COVERAGE_ELECT COVERAGE_ELECT_DT COVERAGE_END_DT COVRG_CD DEDUCTION_END_DT EFFDT KEY(6) EMPLID KEY(1) EMPL_RCD KEY(2) HIPAA_DEP_RPT_DT HIPAA_REPORT_DT HLTH_PROVIDER_ID MED_PREM_PRETAX OTH_INSURANCE_IND OTH_INSURANCE_NAME PLAN_TYPE KEY(4) PRETAX_CD PREVIOUSLY_SEEN HEALTH_DEPENDNT EE Health Benefit Dependents BENEFIT_NBR KEY(5) COBRA_EVENT_ID KEY(3) DEPENDENT_BENEF KEY(7) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 1 EFFDT KEY(6) EMPLID KEY(1) EMPL_RCD KEY(2) HLTH_PROVIDER_ID OTH_INSURANCE_IND OTH_INSURANCE_NAME PLAN_TYPE KEY(4) PREVIOUSLY_SEEN HEALTH_PLAN_TBL Health Plan Parameters BENEFIT_PLAN KEY(2) EFFDT KEY(3) HLTH_PROVIDER_REQD PLAN_TYPE KEY(1) WAIT_PERIOD_DD HIER_CTRL_TBL DIMENSION_KEY DW_KEY KEY(1) LANGUAGE_CD ROLLUP_NAME SEQ_NBR TABLE_NAME HIER_MAP_TBL COLUMN_ID COLUMN_TYPE DESCR DIM_LEVEL_NAME DW_KEY KEY(1) HIERARCHY_KEY LEVELS HIRING_CTR_ESP Hiring Center DESCR DESCRSHORT EFFDT KEY(2) EFF_STATUS HIRE_CTR_CD_ESP KEY(1) RESPONSIBLE_ID RESPONSIBLE_ROLE SIGNATURE_CITY UNEMPLOYMNT_OFFICE HOLDEXPKEYS_TAO Qry Upgrd Tmp Activity Object EXPNUM KEY(3) OPRID KEY(1) QRYNAME KEY(2) HOLIDAY_DATE Holiday Dates DESCR HOLIDAY KEY(2) HOLIDAY_HRS HOLIDAY_SCHEDULE KEY(1) HOLIDAY_TYPE HOL_TIME_END HOL_TIME_START EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 2 HOLIDAY_DTE_LNG Holiday Dates RelLang DESCR HOLIDAY KEY(2) HOLIDAY_SCHEDULE KEY(1) LANGUAGE_CD KEY(3) HOLIDAY_LANG Holiday Table ID RelLang DESCR DESCRSHORT HOLIDAY_SCHEDULE KEY(1) LANGUAGE_CD KEY(2) HOLIDAY_TBL Holiday Table ID DESCR DESCRSHORT HOLIDAY_SCHEDULE KEY(1) HOURS_FRA_LANG Hours Type Tbl Rellang - FRA DESCR DESCRSHORT HOURLY_RT_FRA KEY(1) LANGUAGE_CD KEY(2) *HOURS_TYPE_FRA Hours Type Table - FRA DESCR DESCRSHORT HOURLY_RT_FRA KEY(1) HOUR_TYP_FP_SBR HPDBRETDIST_AET Distribution State Record ACCOUNT ACCOUNTING_PERIOD ACCT_CD BENEFIT_PLAN BUDGET_DATA BUDGET_LEVEL_INDC BUDGET_SEQ COMPANY DEDCD DED_CLASS DED_CUR DED_SLSTX_CLASS DEPTID EARNINGS EFFDT KEY(4) EFFSEQ EFF_STATUS EMPLID EMPL_RCD ERNCD FISCAL_YEAR HP_IGNOREOFFCYCLE HP_NEXT_EFFDT HP_PREVRDIST_SUB_X HP_PREVRDIST_TRANS HP_PREV_EFFDT EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 3 HP_PREV_EFFSEQ HP_PRIORDAYS HP_PRIOR_ACCT_CD HP_RDIST_SUB_TRANS HP_RDIST_TRANS_NO HP_RETDIST_PAY_DT HP_RETDIST_SEQ_NO JOBCODE LINE_NUM LOCALITY OFF_CYCLE OPRID KEY(2) PAGE_NUM PAYGROUP PAY_DT PAY_END_DT PLAN_TYPE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS PROCESS_INSTANCE KEY(1) PROVINCE RUN_CNTL_ID KEY(3) SEPCHK SETID SETID_JOBCODE STATE TAX_CLASS TAX_CLASS_CAN TAX_CUR HP_1042S_PARAM 1042 Withholding Agent Info COMPANY KEY(1) CONTACT_PHONE CONTACT_PHONE_EXT HP_CONTACT_NM_1042 HP_BDGT_CTXCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BUDGET_LEVEL_INDC BUDGET_SEQ DEPTID EFFDT EFFSEQ EFF_STATUS EMPLID EMPL_RCD FISCAL_YEAR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 4 HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS PROVINCE SETID SETID_JOBCODE TAX_CLASS_CAN HP_BDGT_DEDCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BENEFIT_PLAN BUDGET_LEVEL_INDC BUDGET_SEQ DEDCD DED_CLASS DEPTID EFFDT EFFSEQ EFF_STATUS EMPLID EMPL_RCD FISCAL_YEAR HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE PLAN_TYPE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS SETID SETID_JOBCODE HP_BDGT_ERNCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BUDGET_LEVEL_INDC BUDGET_SEQ DEPTID EFFDT EFFSEQ EFF_STATUS EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 5 EMPLID EMPL_RCD ERNCD FISCAL_YEAR HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS SETID SETID_JOBCODE HP_BDGT_TAXCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BUDGET_LEVEL_INDC BUDGET_SEQ DEPTID EFFDT EFFSEQ EFF_STATUS EMPLID EMPL_RCD FISCAL_YEAR HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE LOCALITY POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS SETID SETID_JOBCODE STATE TAX_CLASS HP_BGTACTUAL_WK Budget Actuals ACCOUNT KEY(10) ACCT_CD KEY(9) ANNUAL_ENCUMB_AMT DEPTID KEY(2) EMPLID KEY(7) EMPL_RCD KEY(8) ENCUMB_PROC_TYPE KEY(11) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 6 FISCAL_YEAR KEY(12) JOBCODE KEY(5) POSITION_NBR KEY(6) POSITION_POOL_ID KEY(3) POSTED_ACTUAL_AMT POSTED_ENCUMB_AMT SETID KEY(1) SETID_JOBCODE KEY(4) WORK_ACTUAL_AMT WORK_ENCUMB_AMT HP_CNTPAY04_AET State Record for HP_CNTPAY04 COMPANY CONTRACT_BEGIN_DT CONTRACT_END_DT EFFDT EFFSEQ EMPLID EMPL_RCD HOLIDAY_SCHEDULE HP_TRACK_ACTUALS HP_USE_HOL_SCHD HP_WORKDAYS PAYGROUP PAYMENT_BEGIN_DT PAYMENT_END_DT PROCESS_INSTANCE KEY(1) WORK_SCHEDULE HP_COL_DEFN_COL User Defined Report Columns HP_COLUMN_ID KEY(2) HP_COL_HEADING1 HP_COL_HEADING2 HP_GROSS HP_RPT_COLDEFN_CD KEY(1) HP_COL_DEFN_DTL User defined report col detail BENEFIT_PLAN KEY(5) DEDCD KEY(6) DED_CLASS KEY(7) DED_SLSTX_CLASS KEY(8) ERNCD KEY(3) HP_COLUMN_ID KEY(2) HP_RPT_COLDEFN_CD KEY(1) LOCALITY KEY(10) PLAN_TYPE KEY(4) PROVINCE KEY(12) STATE KEY(9) TAX_CLASS KEY(11) TAX_CLASS_CAN KEY(13) *HP_COL_DEFN_TBL User Defined Report Column DESCR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 7 HP_RPT_COLDEFN_CD KEY(1) HP_CTXDIST_WRK Canadian Payroll Tax Dist ACCOUNT ACCOUNTING_PERIOD KEY(11) ACCT_CD KEY(12) BUDGET_DATA KEY(13) COMPANY KEY(1) CURRENCY_CD DEFAULT_FUND_OPTN DEPTID EARNS_END_DT EMPL_RCD FISCAL_YEAR KEY(10) HP_DISTRIB_OVRRIDE HP_RDIST_GL_INFACE HP_RDIST_REV_SEQ HP_RETDIST_PAY_DT HP_RETDIST_SEQ_NO HP_RETDIST_STATUS JOBCODE LINE_NUM KEY(6) OFF_CYCLE KEY(4) PAGE_NUM KEY(5) PAYGROUP KEY(2) PAY_END_DT KEY(3) POSITION_NBR POSITION_POOL_ID PROVINCE KEY(8) REVERSED SEPCHK KEY(7) TAX_CLASS_CAN KEY(9) TAX_CUR HP_CTX_ACCT Canadian Tax Account COMPANY KEY(1) EFFDT KEY(3) WAGE_LOSS_PLAN KEY(2) HP_CTX_ACCT_DTL Canadian Tax Account Detail ACCOUNT COMPANY KEY(1) EFFDT KEY(3) SETID TAX_CLASS_CAN KEY(4) WAGE_LOSS_PLAN KEY(2) HP_DEDDIST_WRK Payroll Deduction Fund Dist ACCOUNT ACCOUNTING_PERIOD KEY(14) ACCT_CD KEY(15) BENEFIT_PLAN KEY(9) BUDGET_DATA EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 8 COMPANY KEY(1) CURRENCY_CD DEDCD KEY(10) DED_CLASS KEY(11) DED_CUR DED_SLSTX_CLASS KEY(12) DEFAULT_FUND_OPTN DEPTID EARNS_END_DT EMPL_RCD FISCAL_YEAR KEY(13) HP_DISTRIB_OVRRIDE HP_RDIST_GL_INFACE HP_RDIST_REV_SEQ HP_RETDIST_PAY_DT HP_RETDIST_SEQ_NO HP_RETDIST_STATUS JOBCODE LINE_NUM KEY(6) OFF_CYCLE KEY(4) PAGE_NUM KEY(5) PAYGROUP KEY(2) PAY_END_DT KEY(3) PLAN_TYPE KEY(8) POSITION_NBR POSITION_POOL_ID REVERSED SEPCHK KEY(7) HP_DED_ACCT Deductions Account ACCOUNT KEY(2) EFFDT KEY(3) EFF_STATUS SETID KEY(1) HP_DED_ACCT_MAP Deductions Account Detail ACCOUNT KEY(2) BENEFIT_PLAN KEY(5) DEDCD KEY(6) DED_CLASS KEY(7) EFFDT KEY(3) PLAN_TYPE KEY(4) SETID KEY(1) HP_DED_ACC_RULE Deduction Account Mapping Rule EFFDT KEY(1) HP_FLDDESCR HP_FLDNAME KEY(2) HP_FLDPRIORITY HP_FLDREQ HP_FLDUSED EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 9 HP_DED_ACC_TMPL Deductions Account Template ACCOUNT EFFDT KEY(1) SETID HP_DISTBDGT_AET State Record for Direct Retro ACCOUNT ACCOUNTING_PERIOD ACCT_CD BENEFIT_PLAN BUDGET_AMT BUDGET_DATA BUDGET_LEVEL_INDC COMPANY CREATION_DT CURRENCY_CD DEDCD DED_CLASS DED_CUR DED_SLSTX_CLASS DEFAULT_FUND_OPTN DEPTID EARNINGS EARNS_END_DT EFFDT KEY(4) EFFSEQ EFF_STATUS EMPLID EMPL_RCD ERNCD FISCAL_YEAR FROM_DATE HP_BUDGET_DATATYPE HP_DEPTID HP_DISTRIB_OVRRIDE HP_EXIST HP_FISCAL_YEAR HP_MARKET HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD HP_RDIST_SUB_TRANS KEY(5) HP_RDIST_TRANS_NO HP_TRANSACTION_SRC JOBCODE LINE_NUM LOCALITY EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 10

Description:
EmpowHR Data Dictionary. Prepared by Information MANAGER. SESSION_NBR. KEY(3) . Cache record for Personal Data. ABSENCE_CODE.
ebook img

2.3 Records: Alphabet H-S PDF

1094 Pages·2008·7.58 MB·English
by  
Save to my drive
Quick download
Download
Upgrade Premium
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview 2.3 Records: Alphabet H-S

SECTION 2.3- RECORDS FOR ALPHABETS H-S This section includes the record names, record descriptions, fields, and key of all records. The records that are used by the National Finance Center have an asterisk included. Records Description Fields Key HAZ_CON_MAT_LNG Related Lang-Hazardous Mtl Tbl DESCR DESCRSHORT EFFDT KEY(4) HAZARD_ID KEY(2) LANGUAGE_CD KEY(3) SETID KEY(1) HAZ_CON_MAT_TBL Hazardous Conditn/Matrl Codes DESCR DESCRSHORT EFFDT KEY(3) EFF_STATUS HAZARD_CLASS HAZARD_DIVISION HAZARD_ID KEY(2) HAZARD_TYPE SETID KEY(1) HEALTH_BENEFIT EE Health Benefit Elections BENEFIT_NBR KEY(5) BENEFIT_PLAN COBRA_EVENT_ID KEY(3) COVERAGE_BEGIN_DT COVERAGE_ELECT COVERAGE_ELECT_DT COVERAGE_END_DT COVRG_CD DEDUCTION_END_DT EFFDT KEY(6) EMPLID KEY(1) EMPL_RCD KEY(2) HIPAA_DEP_RPT_DT HIPAA_REPORT_DT HLTH_PROVIDER_ID MED_PREM_PRETAX OTH_INSURANCE_IND OTH_INSURANCE_NAME PLAN_TYPE KEY(4) PRETAX_CD PREVIOUSLY_SEEN HEALTH_DEPENDNT EE Health Benefit Dependents BENEFIT_NBR KEY(5) COBRA_EVENT_ID KEY(3) DEPENDENT_BENEF KEY(7) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 1 EFFDT KEY(6) EMPLID KEY(1) EMPL_RCD KEY(2) HLTH_PROVIDER_ID OTH_INSURANCE_IND OTH_INSURANCE_NAME PLAN_TYPE KEY(4) PREVIOUSLY_SEEN HEALTH_PLAN_TBL Health Plan Parameters BENEFIT_PLAN KEY(2) EFFDT KEY(3) HLTH_PROVIDER_REQD PLAN_TYPE KEY(1) WAIT_PERIOD_DD HIER_CTRL_TBL DIMENSION_KEY DW_KEY KEY(1) LANGUAGE_CD ROLLUP_NAME SEQ_NBR TABLE_NAME HIER_MAP_TBL COLUMN_ID COLUMN_TYPE DESCR DIM_LEVEL_NAME DW_KEY KEY(1) HIERARCHY_KEY LEVELS HIRING_CTR_ESP Hiring Center DESCR DESCRSHORT EFFDT KEY(2) EFF_STATUS HIRE_CTR_CD_ESP KEY(1) RESPONSIBLE_ID RESPONSIBLE_ROLE SIGNATURE_CITY UNEMPLOYMNT_OFFICE HOLDEXPKEYS_TAO Qry Upgrd Tmp Activity Object EXPNUM KEY(3) OPRID KEY(1) QRYNAME KEY(2) HOLIDAY_DATE Holiday Dates DESCR HOLIDAY KEY(2) HOLIDAY_HRS HOLIDAY_SCHEDULE KEY(1) HOLIDAY_TYPE HOL_TIME_END HOL_TIME_START EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 2 HOLIDAY_DTE_LNG Holiday Dates RelLang DESCR HOLIDAY KEY(2) HOLIDAY_SCHEDULE KEY(1) LANGUAGE_CD KEY(3) HOLIDAY_LANG Holiday Table ID RelLang DESCR DESCRSHORT HOLIDAY_SCHEDULE KEY(1) LANGUAGE_CD KEY(2) HOLIDAY_TBL Holiday Table ID DESCR DESCRSHORT HOLIDAY_SCHEDULE KEY(1) HOURS_FRA_LANG Hours Type Tbl Rellang - FRA DESCR DESCRSHORT HOURLY_RT_FRA KEY(1) LANGUAGE_CD KEY(2) *HOURS_TYPE_FRA Hours Type Table - FRA DESCR DESCRSHORT HOURLY_RT_FRA KEY(1) HOUR_TYP_FP_SBR HPDBRETDIST_AET Distribution State Record ACCOUNT ACCOUNTING_PERIOD ACCT_CD BENEFIT_PLAN BUDGET_DATA BUDGET_LEVEL_INDC BUDGET_SEQ COMPANY DEDCD DED_CLASS DED_CUR DED_SLSTX_CLASS DEPTID EARNINGS EFFDT KEY(4) EFFSEQ EFF_STATUS EMPLID EMPL_RCD ERNCD FISCAL_YEAR HP_IGNOREOFFCYCLE HP_NEXT_EFFDT HP_PREVRDIST_SUB_X HP_PREVRDIST_TRANS HP_PREV_EFFDT EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 3 HP_PREV_EFFSEQ HP_PRIORDAYS HP_PRIOR_ACCT_CD HP_RDIST_SUB_TRANS HP_RDIST_TRANS_NO HP_RETDIST_PAY_DT HP_RETDIST_SEQ_NO JOBCODE LINE_NUM LOCALITY OFF_CYCLE OPRID KEY(2) PAGE_NUM PAYGROUP PAY_DT PAY_END_DT PLAN_TYPE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS PROCESS_INSTANCE KEY(1) PROVINCE RUN_CNTL_ID KEY(3) SEPCHK SETID SETID_JOBCODE STATE TAX_CLASS TAX_CLASS_CAN TAX_CUR HP_1042S_PARAM 1042 Withholding Agent Info COMPANY KEY(1) CONTACT_PHONE CONTACT_PHONE_EXT HP_CONTACT_NM_1042 HP_BDGT_CTXCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BUDGET_LEVEL_INDC BUDGET_SEQ DEPTID EFFDT EFFSEQ EFF_STATUS EMPLID EMPL_RCD FISCAL_YEAR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 4 HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS PROVINCE SETID SETID_JOBCODE TAX_CLASS_CAN HP_BDGT_DEDCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BENEFIT_PLAN BUDGET_LEVEL_INDC BUDGET_SEQ DEDCD DED_CLASS DEPTID EFFDT EFFSEQ EFF_STATUS EMPLID EMPL_RCD FISCAL_YEAR HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE PLAN_TYPE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS SETID SETID_JOBCODE HP_BDGT_ERNCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BUDGET_LEVEL_INDC BUDGET_SEQ DEPTID EFFDT EFFSEQ EFF_STATUS EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 5 EMPLID EMPL_RCD ERNCD FISCAL_YEAR HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS SETID SETID_JOBCODE HP_BDGT_TAXCHG Budget Changes ACCT_CD ACTION_DTTM KEY(1) BUDGET_LEVEL_INDC BUDGET_SEQ DEPTID EFFDT EFFSEQ EFF_STATUS EMPLID EMPL_RCD FISCAL_YEAR HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD JOBCODE LOCALITY POSITION_NBR POSITION_POOL_ID PRIOR_EFF_STATUS SETID SETID_JOBCODE STATE TAX_CLASS HP_BGTACTUAL_WK Budget Actuals ACCOUNT KEY(10) ACCT_CD KEY(9) ANNUAL_ENCUMB_AMT DEPTID KEY(2) EMPLID KEY(7) EMPL_RCD KEY(8) ENCUMB_PROC_TYPE KEY(11) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 6 FISCAL_YEAR KEY(12) JOBCODE KEY(5) POSITION_NBR KEY(6) POSITION_POOL_ID KEY(3) POSTED_ACTUAL_AMT POSTED_ENCUMB_AMT SETID KEY(1) SETID_JOBCODE KEY(4) WORK_ACTUAL_AMT WORK_ENCUMB_AMT HP_CNTPAY04_AET State Record for HP_CNTPAY04 COMPANY CONTRACT_BEGIN_DT CONTRACT_END_DT EFFDT EFFSEQ EMPLID EMPL_RCD HOLIDAY_SCHEDULE HP_TRACK_ACTUALS HP_USE_HOL_SCHD HP_WORKDAYS PAYGROUP PAYMENT_BEGIN_DT PAYMENT_END_DT PROCESS_INSTANCE KEY(1) WORK_SCHEDULE HP_COL_DEFN_COL User Defined Report Columns HP_COLUMN_ID KEY(2) HP_COL_HEADING1 HP_COL_HEADING2 HP_GROSS HP_RPT_COLDEFN_CD KEY(1) HP_COL_DEFN_DTL User defined report col detail BENEFIT_PLAN KEY(5) DEDCD KEY(6) DED_CLASS KEY(7) DED_SLSTX_CLASS KEY(8) ERNCD KEY(3) HP_COLUMN_ID KEY(2) HP_RPT_COLDEFN_CD KEY(1) LOCALITY KEY(10) PLAN_TYPE KEY(4) PROVINCE KEY(12) STATE KEY(9) TAX_CLASS KEY(11) TAX_CLASS_CAN KEY(13) *HP_COL_DEFN_TBL User Defined Report Column DESCR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 7 HP_RPT_COLDEFN_CD KEY(1) HP_CTXDIST_WRK Canadian Payroll Tax Dist ACCOUNT ACCOUNTING_PERIOD KEY(11) ACCT_CD KEY(12) BUDGET_DATA KEY(13) COMPANY KEY(1) CURRENCY_CD DEFAULT_FUND_OPTN DEPTID EARNS_END_DT EMPL_RCD FISCAL_YEAR KEY(10) HP_DISTRIB_OVRRIDE HP_RDIST_GL_INFACE HP_RDIST_REV_SEQ HP_RETDIST_PAY_DT HP_RETDIST_SEQ_NO HP_RETDIST_STATUS JOBCODE LINE_NUM KEY(6) OFF_CYCLE KEY(4) PAGE_NUM KEY(5) PAYGROUP KEY(2) PAY_END_DT KEY(3) POSITION_NBR POSITION_POOL_ID PROVINCE KEY(8) REVERSED SEPCHK KEY(7) TAX_CLASS_CAN KEY(9) TAX_CUR HP_CTX_ACCT Canadian Tax Account COMPANY KEY(1) EFFDT KEY(3) WAGE_LOSS_PLAN KEY(2) HP_CTX_ACCT_DTL Canadian Tax Account Detail ACCOUNT COMPANY KEY(1) EFFDT KEY(3) SETID TAX_CLASS_CAN KEY(4) WAGE_LOSS_PLAN KEY(2) HP_DEDDIST_WRK Payroll Deduction Fund Dist ACCOUNT ACCOUNTING_PERIOD KEY(14) ACCT_CD KEY(15) BENEFIT_PLAN KEY(9) BUDGET_DATA EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 8 COMPANY KEY(1) CURRENCY_CD DEDCD KEY(10) DED_CLASS KEY(11) DED_CUR DED_SLSTX_CLASS KEY(12) DEFAULT_FUND_OPTN DEPTID EARNS_END_DT EMPL_RCD FISCAL_YEAR KEY(13) HP_DISTRIB_OVRRIDE HP_RDIST_GL_INFACE HP_RDIST_REV_SEQ HP_RETDIST_PAY_DT HP_RETDIST_SEQ_NO HP_RETDIST_STATUS JOBCODE LINE_NUM KEY(6) OFF_CYCLE KEY(4) PAGE_NUM KEY(5) PAYGROUP KEY(2) PAY_END_DT KEY(3) PLAN_TYPE KEY(8) POSITION_NBR POSITION_POOL_ID REVERSED SEPCHK KEY(7) HP_DED_ACCT Deductions Account ACCOUNT KEY(2) EFFDT KEY(3) EFF_STATUS SETID KEY(1) HP_DED_ACCT_MAP Deductions Account Detail ACCOUNT KEY(2) BENEFIT_PLAN KEY(5) DEDCD KEY(6) DED_CLASS KEY(7) EFFDT KEY(3) PLAN_TYPE KEY(4) SETID KEY(1) HP_DED_ACC_RULE Deduction Account Mapping Rule EFFDT KEY(1) HP_FLDDESCR HP_FLDNAME KEY(2) HP_FLDPRIORITY HP_FLDREQ HP_FLDUSED EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 9 HP_DED_ACC_TMPL Deductions Account Template ACCOUNT EFFDT KEY(1) SETID HP_DISTBDGT_AET State Record for Direct Retro ACCOUNT ACCOUNTING_PERIOD ACCT_CD BENEFIT_PLAN BUDGET_AMT BUDGET_DATA BUDGET_LEVEL_INDC COMPANY CREATION_DT CURRENCY_CD DEDCD DED_CLASS DED_CUR DED_SLSTX_CLASS DEFAULT_FUND_OPTN DEPTID EARNINGS EARNS_END_DT EFFDT KEY(4) EFFSEQ EFF_STATUS EMPLID EMPL_RCD ERNCD FISCAL_YEAR FROM_DATE HP_BUDGET_DATATYPE HP_DEPTID HP_DISTRIB_OVRRIDE HP_EXIST HP_FISCAL_YEAR HP_MARKET HP_NEXT_EFFDT HP_PREV_EFFDT HP_PREV_EFFSEQ HP_PRIOR_ACCT_CD HP_RDIST_SUB_TRANS KEY(5) HP_RDIST_TRANS_NO HP_TRANSACTION_SRC JOBCODE LINE_NUM LOCALITY EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.3 Records Alphabets H-S.doc P a ge | 10

Description:
EmpowHR Data Dictionary. Prepared by Information MANAGER. SESSION_NBR. KEY(3) . Cache record for Personal Data. ABSENCE_CODE.
See more

The list of books you might like

Upgrade Premium
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.
DMCA & Copyright: Dear all, most of the website is community built, users are uploading hundred of books everyday, which makes really hard for us to identify copyrighted material, please contact us if you want any material removed.
Copyright @ PDFdrive.to, 2022 | We love our users