empowhr data dictionary - section 2.4- records for … · 2020. 8. 28. · empowhr data dictionary...
TRANSCRIPT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 1
SECTION 2.4- RECORDS FOR ALPHABETS T-Z
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
T4_REPTNG_TBL T4 Reporting Table COMPANY KEY(1)
EFFDT KEY(2)
YOUTH_HIRE_PGM_IND
*TARIFF_AREA_GER GER - Tariff Area Table DESCR50
DESCRSHORT
EFFDT KEY(3)
EFF_STATUS
TARIFF_AREA_GER KEY(2)
TARIFF_GER KEY(1)
TARIF_ARTBL_LNG GER - Tariff Area Table DESCR50
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(4)
TARIFF_AREA_GER KEY(2)
TARIFF_GER KEY(1)
TAU_PGM_LIST Program List Tbl Access Util OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TAU_APPNAME KEY(3)
TAX1042_BALANCE EE U.S. Tax Balances for 1042 BALANCE_ID KEY(3)
BALANCE_PERIOD KEY(6)
BALANCE_QTR KEY(5)
BALANCE_YEAR KEY(4)
COMPANY KEY(2)
COUNTRY KEY(8)
EMPLID KEY(1)
EXEMPT_CD_1042
INCOME_CD_1042 KEY(9)
STATE KEY(7)
TAX1042_REFUND
TAX_1042_MTD
TAX_1042_QTD
TAX_1042_YTD
TAX_RT KEY(10)
TXGRS_1042_MTD
TXGRS_1042_QTD
TXGRS_1042_YTD
WH_ALLOW_MTD
WH_ALLOW_QTD
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 2
WH_ALLOW_YTD
TAX960_PARM MMREF Process Run Control CONTACT_FAX
CONTACT_NAME_SSA
DISKETTE_TYPE
EMAIL_ADDR_MMREF
EMPLR_PIN
NOTIFY_METHOD
PHONE_EXTN
REPORTING_MEDIUM
RESUB_INDICATOR
RESUB_TLCN
TELEPHONE_NBR
TAXFORM_BOX Taxform Box Definition BOX KEY(3)
DESCR
DESCRSHORT
EFFDT KEY(2)
TAXFORM_ID KEY(1)
TAXFORM_BX_LANG Related Lang for TAXFORM_BOX BOX KEY(3)
DESCR
DESCRSHORT
EFFDT KEY(2)
LANGUAGE_CD KEY(4)
TAXFORM_ID KEY(1)
TAXFORM_DED Taxform Deductions BOX KEY(3)
DEDCD KEY(5)
DED_CLASS KEY(6)
DED_SLSTX_CLASS KEY(7)
EFFDT KEY(2)
PLAN_TYPE KEY(4)
TAXFORM_ID KEY(1)
TAXFORM_ERN Taxform Earnings BOX KEY(3)
EFFDT KEY(2)
ERNCD KEY(4)
TAXFORM_ID KEY(1)
TAXFORM_FORM Tax Form Form Parameters BOTTOM_SPLIT
CENTER_SPLIT
EFFDT KEY(2)
FORM_ID KEY(3)
LAST_PRINT_LINE
LAYOUT_STYLE
LOCALS_PER_FORM
TAXFORM_ID KEY(1)
TOP_MARGIN
TOP_SPLIT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 3
TAXFORM_NOTES Tax Form Footnotes Table BOX KEY(3)
BOX_NOTE_CD
BOX_NOTE_COMMENT
BOX_NOTE_SEQ
BOX_NOTE_TEXT
EFFDT KEY(2)
TAXFORM_ID KEY(1)
TAXFORM_NT_LANG Tax Form Footnotes Lang Table BOX KEY(3)
BOX_NOTE_COMMENT
BOX_NOTE_TEXT
EFFDT KEY(2)
LANGUAGE_CD KEY(4)
TAXFORM_ID KEY(1)
TAXFORM_PRT Tax Form Print Definition BOX KEY(4)
EFFDT KEY(2)
FORM_ID KEY(3)
PRINT_COL
PRINT_FORMAT
PRINT_LINE
PRINT_TEXT
TAXFORM_ID KEY(1)
TAXFORM_TAX Taxform Tax Definition AMOUNT_TYPE
BOX KEY(3)
EFFDT KEY(2)
JURISDICTION_TYPE KEY(4)
LOCALITY KEY(6)
STATE KEY(5)
TAXFORM_ID KEY(1)
TAX_CLASS KEY(7)
TAXFORM_TBL Taxform Definition EFFDT KEY(2)
TAXFORM_ID KEY(1)
TAXGR_BASE_TBL Taxable Gross Base Table EFFDT KEY(3)
LOCALITY KEY(2)
STATE KEY(1)
TAX_GRS_BASE
TAX_GRS_TYPE KEY(4)
TAXGR_CMPNT_TBL Taxable Gross Component Table DEDCD KEY(7)
EFFDT KEY(3)
LOCALITY KEY(2)
PLAN_TYPE KEY(6)
STATE KEY(1)
TAX_GRS_COMPNT KEY(5)
TAX_GRS_EFFECT
TAX_GRS_TYPE KEY(4)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 4
WH_FOLLOWS_FED_SW
TAXGR_DEFN_TBL Taxable Gross ID Table EFFDT KEY(3)
EFF_STATUS
LOCALITY KEY(2)
STATE KEY(1)
TAXRPT_RUNCTL Tax Report Run Control ALIGN_COUNT
BALANCE_ID
BALANCE_QTR
BALANCE_YEAR
BLOCKING_FACTOR
COMPANY
COMPUTER_MFR
EMPLOYEES_PER_PAGE
EMPLOYMENT_TYPE
FORM_ID
ORG_TYPE
RECORDING_CD
REPRINT_NBR
TAPE_DENSITY
TAPE_LABEL
XMITTER_IS_ER
*TAX_BALANCE Employee U.S. Tax Balance BALANCE_ID KEY(3)
BALANCE_PERIOD KEY(6)
BALANCE_QTR KEY(5)
BALANCE_YEAR KEY(4)
COMPANY KEY(2)
EMPLID KEY(1)
LOCALITY KEY(8)
NLGRS_MTD
NLGRS_QTD
NLGRS_YTD
STATE KEY(7)
TAX_CLASS KEY(9)
TAX_MTD
TAX_QTD
TAX_YTD
TIPS_MTD
TXGRS_MTD
TXGRS_QTD
TXGRS_YTD
TAX_DATA_NLD Employee Tax Data - NDL EFFDT KEY(2)
EMPLID KEY(1)
NL_ANONYMOUS_RT
NL_SPCL_RT_OT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 5
NL_SPCL_RT_TAX
NL_TAX_CAT
NL_TAX_EXCEPTION
NL_TAX_TABLE
NL_TAX_TRAVEL_DATA
NL_TAX_YR_EARNINGS
RULE_30_PERC_NLD
TAX_CREDITS_NLD
*TAX_DISTRIB Employee Tax Distribution DIST_PCT
EFFDT KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
LOCALITY KEY(5)
STATE KEY(4)
*TAX_DIST_EFFDT Tax Distribution Eff Dt COUNTRY
EFFDT KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
INSERT_PRE_FILLED
UNIQUE_DIST
TAX_INSPECT_NLD Decision Inspection - NDL EFFDT KEY(2)
EMPLID KEY(1)
NL_DECIS_INSP_AMT
NL_DECIS_INSP_DT
NL_DECIS_INSP_END
NL_DECIS_INSP_NBR
NL_DECIS_INSP_TYPE KEY(3)
TAX_LOCAT1_LANG Related Lang - TAX_LOCATION1 DESCR
DESCRSHORT
LANGUAGE_CD KEY(2)
TAX_LOCATION_CD KEY(1)
*TAX_LOCATION1 Tax Location Codes ADDRESS_SBR
AK_AREA_CD
DESCR
DESCRSHORT
EFF_STATUS
TAX_LOCATION_CD KEY(1)
*TAX_LOCATION2 Tax Location states/localities LOCALITY KEY(3)
LOCALITY_LINK
STATE KEY(2)
TAX_LOCATION_CD KEY(1)
*TAX_TYPE_TBL DESCR
EFFDT KEY(2)
EFF_STATUS
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 6
TAX_GRP_TYPE KEY(1)
TAX_UPDATE DT_ENTERED
TAX_UPDT KEY(1)
TCOMPBN_RUNCTL TComp Benefits Extract RunCtl BENEFIT_PROGRAM
CHKPT_INTERVAL
EFFDT
EMPLID
EMPL_RCD
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TC_PLAN_ID
THRU_DATE
TC_AET Generic cache rec for Tot Comp AMOUNT
ASOFDATE
BASE_CURRENCY
CAL_TARWARD_FLG
COMPANY
COMPENSATION_ID
COMP_FREQUENCY
COMP_RATECD
CONTINUE_AE_FLAG
CUR_EFFDT
CUR_EFFDT_FLAG
CUR_EFFDT_RUN
EMPLID
EMPL_RCD
EXTRACT_PROGRAM
FROM_DATE
FROM_DT_RUN
FTE
GB_GROUP_ID
IF_FLAG
JOB_EFFDT
JOB_EFFSEQ
LMS_MCOP_AMT
LMS_MCOP_FREQUENCY
LMS_MCOP_FTE_IND
LMS_MCOP_PCT
LMS_MCOP_RATECDGRP
LMS_MCOP_RATE_PTS
MCOP_CURR_CD
OPRID
PAID_FTE
PAID_HOURS
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 7
PAID_HRS_FREQUENCY
PROCESS_INSTANCE KEY(1)
PROGRAM_STATUS
RATE_CODE_CLASS
REG_REGION
RT_TYPE
RUN_CNTL_ID
RUN_DTTM
SEQNUM
STD_HOURS
STD_HRS_FREQUENCY
TC_COMP_SOURCE_ID
TC_FREQ
TC_FREQ_FACTOR
TC_FROZEN
TC_PLAN_EFFDT
TC_PLAN_ID
TC_RUN_TYPE
THRU_DATE
THRU_DT_RUN
TREE_EFFDT
TREE_NAME
VERSIONGBQDM
YYYYMMDD
TC_BENEFITS_AET Generic cache rec for Tot Comp BASE_CURRENCY
CAL_TARWARD_FLG
COMPENSATION_ID
CONTINUE_AE_FLAG
CUR_EFFDT
CUR_EFFDT_FLAG
CUR_EFFDT_RUN
EXTRACT_PROGRAM
FROM_DATE
FROM_DT_RUN
GB_GROUP_ID
OPRID
PROCESS_INSTANCE KEY(1)
RT_TYPE
RUN_CNTL_ID
RUN_DTTM
TC_COMP_SOURCE_ID
TC_FREQ
TC_FREQ_FACTOR
TC_FROZEN
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 8
TC_PLAN_EFFDT
TC_PLAN_ID
TC_RUN_TYPE
THRU_DATE
THRU_DT_RUN
TC_BEN_GRP TC Run control, Benefit Stmt GB_GROUP_ID KEY(5)
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TC_PLAN_EFFDT KEY(4)
TC_PLAN_ID KEY(3)
TC_BEN_RUN_CNTL TC Run control, Benefit Stmt FROM_DATE
LANGUAGE_CD
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TC_MEASURE
TC_PLAN_EFFDT KEY(4)
TC_PLAN_ID KEY(3)
TC_SORT_BY
THRU_DATE
TC_CATEGORY Total Compensation Categories CATEGORY KEY(1)
COMMENTS
DESCR
TC_CATEGORY_WRK Benefit Statement temp table COMPENSATION_ID KEY(1)
TC_CATEGORY1
TC_CATEGORY10
TC_CATEGORY11
TC_CATEGORY12
TC_CATEGORY13
TC_CATEGORY14
TC_CATEGORY2
TC_CATEGORY3
TC_CATEGORY4
TC_CATEGORY5
TC_CATEGORY6
TC_CATEGORY7
TC_CATEGORY8
TC_CATEGORY9
TC_CATEG_LNG Rellang Total Comp Categories CATEGORY KEY(1)
COMMENTS
DESCR
LANGUAGE_CD KEY(2)
TC_CNTL_BEN_TAO Total Comp Benefit AE Temp Tbl COMPENSATION_ID KEY(3)
GB_GROUP_ID KEY(2)
PROCESS_INSTANCE KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 9
TC_COMP_SOURCE_ID
TC_EXTRACT_STATUS
TC_CNTL_PAY_TAO Total Comp Pay Extract Cntl BUSINESS_UNIT KEY(5)
CHECK_DT
COMPANY KEY(6)
COUNTRY
CURRENCY_CD
GB_GROUP_ID
OPRID KEY(1)
PAYGROUP KEY(7)
PAY_BEGIN_DT KEY(8)
PAY_END_DT KEY(9)
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
TC_EXTRACT_STATUS
TC_COMPDEF_LNG Rellang Total Comp Definition COMMENTS
COMPENSATION_ID KEY(1)
DESCR50
LANGUAGE_CD KEY(2)
TC_COMPHIST_TAO Compensation History EFFDT KEY(2)
EXTRACT_PROGRAM KEY(3)
FROM_DATE KEY(4)
OPRID
PROGRAM_STATUS
RUN_DTTM KEY(6)
TC_PLAN_ID KEY(1)
TC_RUN_TYPE KEY(7)
THRU_DATE KEY(5)
TC_COMPID_MAPS Compensation Mappings COMPENSATION_ID KEY(1)
MAP_BASED KEY(2)
TC_COMPSRC_LNG Rellang Total Comp Source Tbl COMMENTS
DESCR50
LANGUAGE_CD KEY(2)
TC_COMP_SOURCE_ID KEY(1)
TC_COMP_DEFN Total Compensation Definition COMMENTS
COMPENSATION_ID KEY(1)
DESCR50
EE_COMP_TOTAL
ORG_COST
TC_TYPE
TC_COMP_HISTORY Compensation History EFFDT KEY(2)
EXTRACT_PROGRAM KEY(3)
FROM_DATE KEY(4)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 10
OPRID
PROGRAM_STATUS
RUN_DTTM KEY(7)
TC_PLAN_ID KEY(1)
TC_RUN_TYPE KEY(6)
THRU_DATE KEY(5)
TC_COMP_SOURCE TC Compensation Source Table COMMENTS
DATA_SOURCE
DESCR50
EXTRACT_PROGRAM
MAP_BASED
TC_COMP_SOURCE_ID KEY(1)
TC_MEASURE
TC_COMP_TMP Total Compensation Temp Tbl CHANGE_AMT
CHANGE_PCT
CHANGE_PTS
COMPRATE
COMP_EFFSEQ KEY(3)
COMP_FREQUENCY
COMP_PCT
COMP_RATECD KEY(4)
COMP_RATE_POINTS
DEPTID
DESCR50
EFFDT
EFFSEQ
EMPLID KEY(1)
EMPL_RCD KEY(2)
FTE
FTE_INDICATOR
NAME
PRD_BGN_DT
PRD_END_DT
RATE_CODE_CLASS
RATE_CODE_GROUP
VC_AWARD_VALUE
VC_PAYOUT_PRD_ID KEY(6)
VC_PLAN_ID KEY(5)
VC_TARGET_PAYOUT
VC_TARGET_VALUE
TC_DEPT_DIM_WRK TC Work Record ASOFDATE
TC_EE_COMP TC EE Compensation EMPLID KEY(1)
EMPL_RCD KEY(2)
FROM_DATE
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 11
TC_MEASURE
TC_PLAN_EFFDT
TC_PLAN_ID
TC_REFRESH_BTN
THRU_DATE
TC_EE_DETAIL Transaction Rec for Total Comp BUSINESS_UNIT
COMPANY
COMPENSATION_ID KEY(3)
DEPTID
EFFDT KEY(2)
EMPLID KEY(7)
EMPL_CTG
EMPL_RCD KEY(8)
FROM_COMP_AMT
FROM_CURR_CD KEY(9)
FROM_DATE
FROM_PAYROLL_AMT
GB_GROUP_ID KEY(6)
GRADE
JOBCODE
LABOR_AGREEMENT
LOCATION
POSITION_NBR
SAL_ADMIN_PLAN
SEQNUM
SETID_DEPT
SETID_JOBCODE
SETID_LBR_AGRMNT
SETID_LOCATION
SETID_SALARY
STEP
TC_COMP_SOURCE_ID KEY(4)
TC_PLAN_ID KEY(1)
THRU_DATE KEY(5)
TO_COMP_AMT
TO_PAYROLL_AMT
VCOMP_FLAG
TC_EE_DET_TAO Temp. Record for Total Comp COMPENSATION_ID KEY(4)
EFFDT KEY(3)
EMPLID KEY(8)
EMPL_RCD KEY(9)
FROM_COMP_AMT
FROM_CURR_CD KEY(10)
FROM_PAYROLL_AMT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 12
GB_GROUP_ID KEY(7)
GB_GROUP_ID2 KEY(11)
PROCESS_INSTANCE KEY(1)
TC_COMP_SOURCE_ID KEY(5)
TC_PLAN_ID KEY(2)
THRU_DATE KEY(6)
TO_COMP_AMT
TO_PAYROLL_AMT
TC_EMPL_LST_TAO Employee list for Total Comp BUSINESS_UNIT
COMPANY KEY(5)
DEPTID
EFFDT KEY(9)
EMPLID KEY(7)
EMPL_RCD KEY(8)
EMPL_TYPE
GRADE
JOBCODE
LOCATION
OPRID KEY(1)
PAYGROUP KEY(6)
POSITION_NBR
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
SAL_ADMIN_PLAN
STEP
TC_EXCEL_CNTL TC EE Group Build Id - Runctl DEPTID
EMPLID KEY(4)
EMPL_RCD KEY(5)
FROM_DATE KEY(1)
FTE
GB_GROUP_ID KEY(3)
JOB_EFFDT
JOB_EFFSEQ
NAME
THRU_DATE KEY(2)
TC_EXCEL_EE TC EE From-Thru Dte - Runctl EMPLID KEY(3)
FROM_DATE KEY(1)
THRU_DATE KEY(2)
TC_EXCEL_GRP TC GroupId From-Thru - Runctl FROM_DATE KEY(1)
GB_GROUP_ID KEY(3)
THRU_DATE KEY(2)
TC_EXCEL_GRP_TM TC Excel Variable Comp FROM_DATE KEY(1)
GB_GROUP_ID KEY(5)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 13
PRD_BGN_DT
PRD_END_DT
THRU_DATE KEY(2)
TREE_EFFDT
TREE_NAME
VC_EFFDT
VC_PAYOUT_PRD_ID KEY(4)
VC_PLAN_ID KEY(3)
VC_PLAN_MEM_CRIT
TC_EXCEL_RUNCTL TC Excel Run Control CURRENCY_CD
CUR_EFFDT
CUR_RT_TYPE
FROM_DATE KEY(1)
TC_EXCEL_BTN
TC_POP_FLAG
THRU_DATE KEY(2)
TC_EXCEL_SUBGRP TC Excel Sub Group FROM_DATE KEY(1)
GB_GROUP_ID KEY(3)
SUB_GROUP_ID KEY(4)
THRU_DATE KEY(2)
TREE_EFFDT
TREE_NAME
TC_EX_RT1_TAO TC Exchange Rate COUNTRY_CD
CURRENCY_CD KEY(2)
RATE
YYYYMMDD KEY(1)
TC_EX_RT_TAO TC Plan Exchange Rate COUNTRY_CD
CURRENCY_CD KEY(4)
RATE
TC_PLAN_EFFDT KEY(2)
TC_PLAN_ID KEY(1)
YYYYMMDD KEY(3)
TC_GROUP_RUNCTL TC Plan Runctl OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TC_PLAN_EFFDT
TC_PLAN_ID
TC_RUN_TYPE
TC_MAP_BENEFIT Comp Mapping for Benefits BENEFIT_PLAN KEY(4)
COMPENSATION_ID KEY(1)
COST_TYPE KEY(8)
DEDCD KEY(7)
DED_CLASS KEY(5)
DED_SLSTX_CLASS KEY(6)
MAP_BASED KEY(2)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 14
PLAN_TYPE KEY(3)
TC_MAP_BEN_TAO Comp Mapping for Benefits BENEFIT_PLAN KEY(8)
COMPENSATION_ID KEY(5)
COST_TYPE KEY(12)
DEDCD KEY(11)
DED_CLASS KEY(9)
DED_SLSTX_CLASS KEY(10)
OPRID KEY(1)
PLAN_TYPE KEY(7)
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
TC_COMP_SOURCE_ID KEY(6)
TC_MAP_EARN Comp Mapping for Earnings COMPENSATION_ID KEY(1)
ERNCD KEY(3)
MAP_BASED KEY(2)
TC_MAP_ERN_TAO Total Comp Map Values COMPENSATION_ID KEY(5)
ERNCD KEY(7)
OPRID KEY(1)
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
TC_COMP_SOURCE_ID KEY(6)
TC_MAP_MCOMP TC Multiple Componment Mapping COMPENSATION_ID KEY(1)
COMP_BASE_PAY_SW KEY(3)
COMP_RATECD KEY(5)
MAP_BASED KEY(2)
RATE_CODE_CLASS KEY(4)
TC_MAP_TAX Comp Mapping for Taxes COMPENSATION_ID KEY(1)
GROSSUP KEY(4)
MAP_BASED KEY(2)
TAX_CLASS KEY(3)
TC_MAP_TAXC_TAO Comp Mapping for Benefits COMPENSATION_ID KEY(5)
GROSSUP KEY(8)
OPRID KEY(1)
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
TAX_CLASS_CAN KEY(7)
TC_COMP_SOURCE_ID KEY(6)
TC_MAP_TAX_CAN Comp Mapping for Taxes COMPENSATION_ID KEY(1)
GROSSUP KEY(4)
MAP_BASED KEY(2)
TAX_CLASS_CAN KEY(3)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 15
TC_MAP_TAX_TAO Comp Mapping for Benefits COMPENSATION_ID KEY(5)
GROSSUP KEY(8)
OPRID KEY(1)
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
TAX_CLASS KEY(7)
TC_COMP_SOURCE_ID KEY(6)
TC_MAP_VCOMP TC Variable Compens. Mapping COMPENSATION_ID KEY(1)
MAP_BASED KEY(2)
VC_PLAN_ID KEY(3)
TC_MCOP_TAO Transaction Rec for Total Comp AMOUNT
COMPENSATION_ID KEY(4)
COMP_RATECD KEY(11)
CURRENCY_CD
EMPLID KEY(8)
EMPL_RCD KEY(9)
FTE
GB_GROUP_ID KEY(6)
LMS_MCOP_AMT
LMS_MCOP_FREQUENCY
LMS_MCOP_FTE_IND
LMS_MCOP_PCT
LMS_MCOP_RATECDGRP
LMS_MCOP_RATE_PTS
MCOP_CURR_CD
PROCESS_INSTANCE KEY(1)
RATE_CODE_CLASS
SEQNUM KEY(10)
TC_COMP_SOURCE_ID KEY(5)
TC_PLAN_EFFDT KEY(3)
TC_PLAN_ID KEY(2)
THRU_DATE KEY(7)
TC_OLAP_TIME TC Olap Time DESCR
TC_THRU_YYYYMM KEY(1)
TC_PAYEXT_AET Cache record for Payroll Ext BASE_CURRENCY
BLD_CNTL_SW
BUSINESS_UNIT
CHECK_DT
COMPANY
CONTINUE_AE_FLAG
COUNTRY
CURRENCY_CD
CUR_EFFDT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 16
CUR_EFFDT_FLAG
CUR_EFFDT_RUN
DLT_DETL_SW
DO_EXTRACT_SW
EFFDT
EXTRACT_PROGRAM
EXTRACT_PROGRAMWRK
FROM_DATE
FROM_DT_WRK
GB_GROUP_ID
IF_FLAG
OPRID
PAYGROUP
PAY_BEGIN_DT
PAY_END_DT
PROCESS_INSTANCE KEY(1)
REQUEST_NBR
RT_TYPE
RUN_CNTL_ID
RUN_DTTM
TC_FREQ
TC_FREQ_FACTOR
TC_FROZEN
TC_PLAN_ID
TC_RUN_TYPE
THRU_DATE
THRU_DT_WRK
TC_PLAN Total Comp Plan Definition BASE_CURRENCY
COMMENTS
CUR_EFFDT
CUR_EFFDT_FLAG
DESCR50
EFFDT KEY(2)
FROM_DATE
RT_TYPE
TC_FREQ
TC_FROZEN
TC_PLAN_ID KEY(1)
THRU_DATE
TREE_NAME
TC_PLAN_GRP Total Comp Plan Business Units EFFDT KEY(2)
GB_GROUP_ID KEY(3)
TC_PLAN_ID KEY(1)
TC_PLAN_LNG Total Comp Plan Definition COMMENTS
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 17
DESCR50
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TC_PLAN_ID KEY(1)
TC_POPULATION TC Plan Population BUSINESS_UNIT
COMPANY
DEPTID
EMPLID KEY(4)
EMPL_CTG
EMPL_RCD KEY(5)
FROM_DATE
GB_GROUP_ID KEY(3)
GRADE
JOBCODE
JOB_EFFDT
JOB_EFFSEQ
LABOR_AGREEMENT
LOCATION
PAYGROUP
POSITION_NBR
PRIMARY_INDICATOR
SAL_ADMIN_PLAN
SETID_DEPT
SETID_JOBCODE
SETID_LBR_AGRMNT
SETID_LOCATION
SETID_SALARY
STEP
TC_FTE
TC_HEAD_COUNT
TC_PLAN_EFFDT KEY(2)
TC_PLAN_ID KEY(1)
THRU_DATE KEY(6)
TC_RUNCNTL_CUBE Total Comp Runcontrol Cube ANALYSIS_DB_ID
ANL_DB_DATA_ACTION
ANL_DB_MD_ACTION
AS_OF_DATE
BUSINESS_UNIT
OPRID KEY(1)
POST_BUILD_SCRIPT
RUN_CNTL_ID KEY(2)
TC_DRILL_THR_CUBE
TC_PLAN_ID
TC_TIME_ROLLUP
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 18
TC_RUNCTL_ADHOC Total Comp Adhoc Org Run Cntl AMOUNT
ASOFDATE
COMPENSATION_ID
CURRENCY_CD
EFFDT
FROM_DATE
GB_GROUP_ID
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TC_COMP_SOURCE_ID
TC_PLAN_ID
THRU_DATE
TC_RUN_CNTL Run Control for Total Comp CAL_TARWARD_FLG
EFFDT
FROM_DATE
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TC_PLAN_ID
TC_RUN_TYPE
THRU_DATE
TC_RUN_CNTL_TAO TC Run Control COMPENSATION_ID KEY(4)
GB_GROUP_ID KEY(2)
PROCESS_INSTANCE KEY(1)
TC_COMP_SOURCE_ID KEY(3)
TC_EXTRACT_STATUS
TC_SETID_REC TC Setid / Recname RECNAME KEY(4)
SETID KEY(3)
TC_PLAN_EFFDT KEY(2)
TC_PLAN_ID KEY(1)
TC_SRC_COMPIDS Comp Sources valid for CompID COMPENSATION_ID KEY(1)
MAP_BASED KEY(2)
TC_COMP_SOURCE_ID KEY(3)
TC_TEMP_JOB_TAO Temp Job table for App Engine ACTIVE_FLAG
BUSINESS_UNIT
COMPANY
DEPTID
EMPLID KEY(2)
EMPL_RCD KEY(3)
GRADE
JOBCODE
LOCATION
PAYGROUP
POSITION_NBR
PROCESS_INSTANCE KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 19
SAL_ADMIN_PLAN
STEP
TC_TIME TC Plan Date/Time FROM_DATE
TC_PLAN_EFFDT KEY(2)
TC_PLAN_ID KEY(1)
THRU_DATE KEY(3)
TC_TMP_DTL_TAO Transaction Rec for Total Comp BUSINESS_UNIT
CHECK_DT
COMPANY
COMPENSATION_ID KEY(7)
CURRENCY_CD KEY(14)
DEPTID
EFFDT KEY(6)
EMPLID KEY(11)
EMPL_RCD KEY(12)
FROM_DATE KEY(9)
GRADE
JOBCODE
LOCATION
OPRID KEY(1)
POSITION_NBR
PROCESS_INSTANCE KEY(4)
REQUEST_NBR KEY(3)
RUN_CNTL_ID KEY(2)
SAL_ADMIN_PLAN
SEQNUM KEY(13)
STEP
TC_ACTUAL_AMT
TC_COMP_SOURCE_ID KEY(8)
TC_PLAN_ID KEY(5)
THRU_DATE KEY(10)
TC_TREE_NODE TC Tree Node DESCR
EFFDT KEY(2)
EFF_STATUS
TREE_NODE KEY(1)
TC_TREE_NODE_LN Rellang TC Tree Node DESCR
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TREE_NODE KEY(1)
TC_TREE_RUNCNTL TC Tree RunCtl ASOFDATE
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
TREE_NAME KEY(3)
TC_VARCMP_TAO TC Variable Comp Temp table COMPENSATION_ID KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 20
CURRENCY_CD KEY(6)
EMPLID KEY(4)
EMPL_RCD KEY(5)
TC_COMP_SOURCE_ID KEY(2)
TC_FORECASTED_AMT
THRU_DATE KEY(3)
TC_VCRUNCTL_TAO TC VC Runctl CAL_TARWARD_FLG
COMPENSATION_ID KEY(4)
GB_GROUP_ID KEY(2)
PRD_BGN_DT
PRD_END_DT
PROCESS_INSTANCE KEY(1)
TC_COMP_SOURCE_ID KEY(3)
TC_EXTRACT_STATUS
TREE_EFFDT
TREE_NAME
VC_PAYOUT_PRD_ID KEY(6)
VC_PLAN_ID KEY(5)
VC_PLAN_MEM_CRIT
TC_VCSUBGRP_TAO TC VC Sub Group GB_GROUP_ID KEY(2)
PROCESS_INSTANCE KEY(1)
SUB_GROUP_ID KEY(4)
TREE_NAME KEY(3)
TC_VC_AWARDS TC VC Awards EMPLID
EMPL_RCD
GB_GROUP_ID
PROCESS_INSTANCE
T_A_FLAG
VC_AWARD_VALUE
VC_PAYOUT_PRD_ID
VC_PLAN_ID
TC_VC_PARMS TC VC Parameters GB_GROUP_ID KEY(3)
PROCESS_INSTANCE
VC_PAYOUT_PRD_ID KEY(2)
VC_PLAN_ID KEY(1)
TEMP_DUTIES_LNG Temp Duties - Related Lang DUTIES_TYPE KEY(2)
EFFDT KEY(4)
LANGUAGE_CD KEY(3)
SETID KEY(1)
TMPDUTY_DESCR
TMPDUTY_DESCRSHORT
TEMP_DUTIES_TBL Temporary Duties Table DATA_TYPE_CD
DUTIES_TYPE KEY(2)
EFFDT KEY(3)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 21
EFF_STATUS
SETID KEY(1)
TMPDUTY_DESCR
TMPDUTY_DESCRSHORT
TEMP_JOB_TAO EMPLID KEY(3)
EMPL_RCD KEY(4)
OPRID KEY(2)
ORG_UNIT_AUS KEY(6)
PROCESS_INSTANCE KEY(1)
WORK_SECTOR_AUS KEY(5)
TEMP_TBL_ASGNM IN_USE_SW
PROCESS_INSTANCE
TEMP_TBL_NAME KEY(1)
TEMP_TBL_NUM KEY(2)
*TERM_ACTN_RSN Final Check Action/Reason Tbl ACTION KEY(1)
ACTION_REASON KEY(2)
TERM_EXT_WRK Final Check Extract Work Tbl ADDL_NBR KEY(7)
ADDL_SEQ KEY(9)
BENEFIT_PLAN KEY(11)
COMPANY KEY(1)
DEDCD KEY(12)
DED_ADDL_AMT
DED_CALC
DED_CLASS KEY(13)
DED_SLSTX_CLASS KEY(14)
EFFDT
EMPLID
EMPL_RCD
ENTITLED_PRORATED
ERNCD KEY(8)
LINE_NUM KEY(6)
OFF_CYCLE KEY(4)
ONE_TIME_CD KEY(15)
OTH_HRS
OTH_PAY
PAGE_NUM KEY(5)
PAYGROUP KEY(2)
PAY_END_DT KEY(3)
PLAN_TYPE KEY(10)
TERMINATION_DT
TERM_PROC_STATUS
TERM_PGM_DEFDED Final Check Deduction Defn Tbl AMT_OVRD_LIMIT
DEDCD KEY(4)
EFFDT KEY(2)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 22
PLAN_TYPE KEY(3)
TERM_PGM_ID KEY(1)
TERM_PROC_RULE
TERM_PGM_DEFERN Final Check Earnings Defn Tbl AMT_OVRD_LIMIT
EFFDT KEY(2)
ERNCD KEY(3)
PAYOUT_OPTION
TERM_PGM_ID KEY(1)
TERM_PGM_DEFLVE Final Check Lve Accr Defn Tbl BENEFIT_PLAN KEY(4)
EFFDT KEY(2)
ERNCD_TO_PAY_ACCR
ERNCD_TO_PAY_PRORT
HRS_OVRD_LIMIT
PLAN_TYPE KEY(3)
PRCS_ON_NEGATIVE
PRORATE_ACCRUALS
SERVICE_ACCRUAL
TERM_PGM_ID KEY(1)
TERM_PGM_LNG Final Check Program Tbl DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TERM_PGM_ID KEY(1)
TERM_PGM_TBL Final Check Program Tbl DESCR
DESCRSHORT
EFFDT KEY(2)
EFF_STATUS
INCL_PYBL_TM
TERM_PGM_ID KEY(1)
TERM_PRORT_ACCR Final Checks Lve Accr Prt Tbl BENEFIT_PLAN KEY(4)
EFFDT KEY(2)
HRS_TO_PAY
PLAN_TYPE KEY(3)
SERVICE_HRS KEY(6)
SERVICE_LENGTH KEY(5)
TERM_PGM_ID KEY(1)
TERM_RQST Final Checks Request Tbl COMPANY
CREATED_FROM_JOB
DESCRLONG
EFFDT KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
INCL_PYBL_TM
LINE_NUM
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 23
OFF_CYCLE
PAGE_NUM
PAYGROUP
PAY_END_DT
REPROCESS
TERMINATION_DT
TERM_PGM_ID
TERM_PROC_STATUS
TERM_RQST_LNG Final Checks Request Tbl DESCRLONG
EFFDT KEY(4)
EMPLID KEY(1)
EMPL_RCD KEY(2)
LANGUAGE_CD KEY(3)
TERM_RQST_WL Final Check Request Worklist ACTIVITYNAME KEY(2)
BUSPROCNAME KEY(1)
EMPLID KEY(7)
EMPL_RCD KEY(8)
EVENTNAME KEY(3)
INSTANCEID KEY(5)
NAME
TRANSACTIONID KEY(6)
WORKLISTNAME KEY(4)
*TERM_RUNCTL Final Checks Runctl Tbl COMPANY
OFF_CYCLE
OPRID KEY(1)
PAYGROUP
PAY_END_DT
RUN_CNTL_ID KEY(2)
RUN_ID
TER_CARRYOV_ITA Termination Carryover EFFDT KEY(3)
EFFSEQ KEY(4)
EMPLID KEY(1)
EMPL_RCD KEY(2)
TER_CARRYOVER_ITA KEY(5)
TER_PAYMENT_ITA Termination Payment EFFDT KEY(3)
EFFSEQ KEY(4)
EMPLID KEY(1)
EMPL_RCD KEY(2)
TER_PAYMENT_ITA KEY(5)
TIMERPT_LOC_ACT Future use ACCT_CD KEY(4)
COMPANY KEY(1)
EFFDT KEY(3)
TIME_RPT_LOC KEY(2)
TIMERPT_LOC_ERN Time Reporting/Earning Codes COMPANY KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 24
EFFDT KEY(3)
ERNCD KEY(4)
TIME_RPT_LOC KEY(2)
TIMERPT_LOC_FAM Time Reporting/Acct Family Cd ACCT_FAMILY_CD KEY(4)
COMPANY KEY(1)
EFFDT KEY(3)
TIME_RPT_LOC KEY(2)
TIMERPT_LOC_HOL Time Reporting/Holidays COMPANY KEY(1)
EFFDT KEY(3)
HOLIDAY_SCHEDULE KEY(4)
TIME_RPT_LOC KEY(2)
TIMERPT_LOC_TBL Time Reporting ID COMPANY KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(3)
EFF_STATUS
TIME_RPT_LOC KEY(2)
TIMLOC_TBL_LNG Time Reporting ID COMPANY KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(4)
TIME_RPT_LOC KEY(2)
TIPS_ALLOC_EMPL Establishment Empl Period Data BUSINESS_UNIT KEY(2)
COMPANY KEY(1)
CUR_ALLOCATION
EMPLID KEY(5)
EMPL_RCD KEY(6)
EMPL_SHARE
EMPL_SHORTFALL
GRS_RCPTS
GRS_TIPS
GRS_TIP_HRS
POST_DT KEY(4)
PREV_ALLOCATION
RCPT_HRS_RATIO
SHORTFALL_RATIO
TIPS_ESTAB KEY(3)
TOT_ALLOCATION
TIPS_ALLOC_PD Tips Allocation Period Table ADDL_PAY_LD_RUN
ALLOC_COMPLETE
COMPANY KEY(1)
POST_DT KEY(2)
TIPS_CALC_RUN
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 25
TIPS_ALL_RUNCTL Tips Allocation Run Control COMPANY
LOAD_EARNS
OPRID KEY(1)
POST_DT
RUN_CNTL_ID KEY(2)
START_DATE
TIPS_APPR_INP
TIPS_CALC_INP
TIPS_BU_TBL Tips Business Unit Table BUSINESS_UNIT KEY(2)
COMPANY KEY(1)
EFFDT KEY(3)
EFF_STATUS
TIPS_EMPL_INPUT Tips Recording Input BUSINESS_UNIT KEY(2)
CHG_RCPTS
CHG_TIPS
COMPANY KEY(1)
EMPLID KEY(5)
EMPL_RCD KEY(6)
GRS_RCPTS
GRS_TIPS
INPUT_DT KEY(4)
TIPS_ESTAB KEY(3)
TIPS_ESTAB_PD Establishment Period Data ALLOCATION_BSE
BUSINESS_UNIT KEY(2)
COMPANY KEY(1)
DT_ALLOC_BSE
EMPL_CNT
GRS_IND_TIPS
GRS_RCPTS
GRS_TIPS
GRS_TIP_HRS
POST_DT KEY(4)
TIPS_ESTAB KEY(3)
TOT_ALLOCATION
TOT_SHORTFALL
TIPS_ESTAB_TBL Tips Establishment Setup BUSINESS_UNIT KEY(2)
COMPANY KEY(1)
DESCRLONG
EFFDT KEY(3)
MIN_TIPS_PCT
TIPS_ALLOC_METH
TIPS_ESTAB KEY(4)
TITLE_TBL Title Table DESCR
EFFDT KEY(2)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 26
EFF_STATUS
TITLE KEY(1)
TITLE_TBL_LNG Rellang Title Table DESCR
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TITLE KEY(1)
TLSINST1_AET TLSINST1 State Record DECIMALPOS
FIELDNAME
FIELDTYPE
FLDSIZE_INTERNAT
LENGTH
PROCESS_INSTANCE KEY(1)
TL_ACTIONS Time Admin Action Definitions ACTION_ID KEY(1)
CORE_COMPONENT
DESCR
DESCRLONG
DESCRSHORT
INSERT_SRC_IND
SRC_RECNAME
TGT_RECNAME
TL_ACTION_TYPE
TL_ACTIONS_LANG Time Admin Action Definitions ACTION_ID KEY(1)
DESCR
DESCRLONG
DESCRSHORT
LANGUAGE_CD KEY(2)
TL_ACTION_DTL Time Admin Action Detail ACTION_ID KEY(1)
CONSTANT
EXPRESSION_TXT
META_SQL
META_SQL_PARM1
META_SQL_PARM2
META_SQL_PARM3
META_SQL_PARM4
META_SQL_PARM5
META_SQL_PARM6
META_SQL_PARM7
SRC_FIELDNAME
SRC_FIELD_IND
STATEVAR
TGT_FIELDNAME KEY(2)
TL_ACTIVITY T&L Activity ACTIVITY_ID KEY(1)
DESCR
DESCRSHORT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 27
EFFDT KEY(2)
EFF_STATUS
TL_ACTIVITY_LNG T&L Activity ACTIVITY_ID KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TL_AE_SECTION Define AE SECTIONs for T&L use AE_APPLID KEY(1)
AE_SECTION KEY(2)
COMMENTS
DESCR
DESCRSHORT
PROCESS_TYPE
TL_AE_SECTN_LNG Define AE SECTIONs for T&L use AE_APPLID KEY(1)
AE_SECTION KEY(2)
DESCR
DESCRSHORT
LANGUAGE_CD KEY(3)
TL_AGG_MAIN_AET Agg Update State Record AE_APPLID
AE_SECTION
AGG_UPDATE_RUNTYPE
ALL_DAYS_AFT
ALL_DAYS_BFR
BGN_DT_AFT
BGN_DT_BFR
BGN_HALF_AFT
BGN_HALF_BFR
BGN_HRS_AFT
BGN_HRS_BFR
CALL_TA
CREWRPTG_FLAG
EMPLID
EMPL_RCD
END_DT_AFT
END_DT_BFR
END_HALF_AFT
END_HALF_BFR
END_HRS_AFT
END_HRS_BFR
EVT_ACTION
GP_ABSENCE_FLAG
GP_INSTANCE
LUMP_SUM_FLAG
OPRID
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 28
PATTERN_RPTG_FLAG
PIN_TAKE_NUM_AFT
PIN_TAKE_NUM_BFR
PLAN_TYPE
PROCESS_INSTANCE KEY(1)
RANGE_OF_DT_FLAG
RTIME_TYPE
RUN_CNTL_ID
SCHEDULER_FLAG
SEQ_NUM5
ST_INSTANCE
ST_RTNCD
ST_RTNCD_RSN
TASKGROUP
TASK_PROFILE_ID
TL_QUANTITY
TRC
TL_AGG_RCTRL TL Agg Update Run Control Data DESCR50
DTTM_STAMP
GP_ABSENCE_FLAG
OPRID KEY(2)
RUN_CNTL_ID KEY(1)
ST_INSTANCE
TL_APPRV_AET Approvals AE State Record APPROVE_DATE
CURRENT_DT
DTTM_STAMP
EXIST
PROCESS_INSTANCE KEY(1)
TL_APPSTEDTLLNG APPLICATION_SUITE KEY(2)
ITEMNAME_STRING
LANGUAGE_CD KEY(1)
TL_APP_ITEM TL Application Items BARNAME
DESCR50
ITEMNAME
ITEMNAME_STRING KEY(1)
MENUNAME
PNLITEMNAME
TL_APP_ITEM_LNG DESCR50
ITEMNAME_STRING KEY(1)
LANGUAGE_CD KEY(2)
TL_APP_SUITE APPLICATION_SUITE KEY(1)
DESCR
DESCRSHORT
TL_APP_SUITEDTL APPLICATION_SUITE KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 29
ITEMNAME_STRING KEY(2)
TL_APP_SUITELNG APPLICATION_SUITE KEY(1)
DESCR
DESCRSHORT
LANGUAGE_CD KEY(2)
TL_ATTENDANCE Attendance Record ACTION_RQRD
ACTION_TAKEN
DATE_CLEAR
DESCR
DESCR100
DUR KEY(2)
EMPLID KEY(1)
EXCEPTION_ID KEY(4)
PUNCH_BEGIN KEY(3)
TL_ATTEND_ACT Attendance Actions ACTION_NBR KEY(3)
ATTENDANCE_ACTION
ATTENDANCE_PGM_ID KEY(1)
ATTEND_POINTS
COMMENTSHORT
DAYS
EFFDT KEY(2)
TL_ATTEND_AET Attendance State Record ACTION_NBR
ACTION_RQRD
AE_APPLID
AE_SECTION
ATTENDANCE_ACTION
ATTENDANCE_PGM_ID
ATTEND_POINTS
COMMENTSHORT
DATE_CLEAR
DAYS
DUR
EMPLID
END_DT
GRACE_PERIOD
KEEP_GOING
MINUTES
PERIOD_ID
PROCESS_INSTANCE
PUNCH_BEGIN
START_DT
TRACKING_METHOD
TL_ATTEND_HIST Attendance History ATTEND_POINTS
ATTEND_TOTAL
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 30
DUR KEY(2)
EMPLID KEY(1)
EXCEPTION_ID KEY(4)
IN_PERIOD
PUNCH_BEGIN KEY(3)
TL_ATTEND_PGM Attendance Program ATTENDANCE_PGM_ID KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(2)
GRACE_BREAK
GRACE_IN
GRACE_MEAL
GRACE_OUT
MINUTES_BREAK
MINUTES_MEAL
PERIOD_ID
POINTS_BREAK
POINTS_IN
POINTS_MEAL
POINTS_OUT
TRACKING_METHOD
TRACK_BREAK
TRACK_IN
TRACK_MEAL
TRACK_OUT
TL_ATTND_PG_LNG Attendance Program ATTENDANCE_PGM_ID KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TL_CALENDAR Calendar Table END_DT
PERIOD_ID KEY(1)
PERIOD_SEQUENCE
PERIOD_TYPE
START_DT KEY(2)
TL_CALL_TA_AET Agg Update State Record ALT_RUN_CTRL_ID
EARLIEST_CHGDT
EMPLID
EMPL_RCD
END_DT
OPRID
PROCESS_INSTANCE KEY(1)
RUN_CNTL_ID
START_DT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 31
TL_CREATE_RUNCTL
TL_CAL_CTRL_TBL Time Run Control Table DESCR50
END_DT
OPRID KEY(1)
RUN_CNTL_ID KEY(2)
START_DT
TL_CAL_VAL_COMB BREAK_IDX
BREAK_UNIT
COMB_ID KEY(1)
START_IDX
START_UNIT
TL_CDVAL_TAO Work Table for TCD Tsk Elem Cd AUDIT_ACTN
IN_PROCESS_FLG
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
TASK_ELEMENT_CD KEY(4)
TASK_ELEMENT_VAL KEY(5)
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
VALUE_SOURCE KEY(6)
TL_CD_VALS_MSG Task Elmnt Code Values Msg Rec AUDIT_ACTN
IN_PROCESS_FLG
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
TASK_ELEMENT_CD KEY(4)
TASK_ELEMENT_VAL KEY(5)
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
VALUE_SOURCE
TL_COMPLEAV_TBL Comp and Leave Time repository COMP_LEAV_IND KEY(5)
COMP_TIME_PLAN KEY(6)
DUR KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
END_BAL
EXP_DT
TL_QUANTITY
TRC KEY(4)
TL_COMPTIME_AET Comp Time App engine State Rec ACTION
ACTION_FLAG
AMOUNT
COMP_TIME_PLAN
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 32
DATE_FROM
DUR
EMPLID
EMPL_RCD
HRS_GO_NEGATIVE
HRS_GO_POSITIVE
PROCESS_INSTANCE
TAKEN_TOTAL
TL_QUANTITY
TL_QUANTITY1
TL_QUANTITY2
TL_QUANTITY3
TL_QUANTITY4
TOTAL_TL_QUANTITY
TL_COMP_DAY_BAL Comp and Leave Time repository ACTION KEY(6)
COMP_TIME_PLAN KEY(5)
DATE_DUE
DUR KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
END_BAL
TAKEN_TOTAL
TL_QUANTITY
TOTAL_PAID
TRC KEY(4)
TL_COMP_TIME Compensatory Time Off Table COMP_TIME_PLAN KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(2)
EFF_STATUS
EXPIRE_NUM
EXPIRE_PER
HRS_GO_NEGATIVE
HRS_GO_POSITIVE
MAX_NEG_HRS
MAX_POS_HRS
TL_COMP_TIME_LG Comp Time Ralted Lang COMP_TIME_PLAN KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TL_COMP_TRC Valid TRC for Comp Plan COMP_TIME_PLAN KEY(1)
EFFDT KEY(2)
EFF_STATUS
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 33
TRC KEY(3)
TL_CONDITIONS Time Admin Conditions CONDITION_ID KEY(1)
COND_OPERATOR
CORE_COMPONENT
DESCR
DESCRLONG
DESCRSHORT
LEFT_AGGR_FUNC
LEFT_CONSTANT
LEFT_FIELDNAME
LEFT_RECNAME
LEFT_SQL_ID
LEFT_STATEVAR
L_COND_EXPRESSION
L_EXPRESSION_TXT
L_META_SQL
L_META_SQL_PARM1
L_META_SQL_PARM2
L_META_SQL_PARM3
L_META_SQL_PARM4
L_META_SQL_PARM5
L_META_SQL_PARM6
L_META_SQL_PARM7
RIGHT_AGGR_FUNC
RIGHT_CONSTANT
RIGHT_FIELDNAME
RIGHT_RECNAME
RIGHT_SQL_ID
RIGHT_STATEVAR
R_COND_EXPRESSION
R_EXPRESSION_TXT
R_META_SQL
R_META_SQL_PARM1
R_META_SQL_PARM2
R_META_SQL_PARM3
R_META_SQL_PARM4
R_META_SQL_PARM5
R_META_SQL_PARM6
R_META_SQL_PARM7
TL_CONDS_LANG CONDITION_ID KEY(1)
DESCR
DESCRLONG
DESCRSHORT
LANGUAGE_CD KEY(2)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 34
TL_CT_DOSELECT VALID_INST_ID KEY(1)
TL_CUSTOMER T & L Customer Table CUSTOMER KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(2)
EFF_STATUS
TL_CUSTOMER_LNG T & L Customer Table CUSTOMER KEY(1)
DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
TL_DATES_TBL Date Attributes Table CALENDAR_YEAR
DAYOFMONTH
DAYOFWEEK
JULIAN_DATE
MONTHOFYEAR
THE_DATE KEY(1)
WEEKOFMONTH
WEEKOFYEAR
TL_DELETES TL_DELETES DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
ST_INSTANCE KEY(1)
TL_DIST_DIL_AET Dist/Dilution State Record ACCOUNTING_DT
COMMIT_ACCTG_FLG
CURRENCY_CD
DIST_AMOUNT1
DIST_AMOUNT2
DIST_AMOUNT3
DUR
EMPLID
EMPL_RCD
EXIST
ITEMCOUNT
LDILU_FLAG
OPRID
PAY_BEGIN_DT
PAY_SYSTEM
PROCESS_INSTANCE KEY(1)
PROCESS_NAME
RUN_CNTL_ID
SEQ_NBR
TRC
USE_CURRENT_DATE
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 35
XREF_NUM
TL_DSTOFFSET Daylight Savings Offsets DSTDTTM KEY(2)
DSTOFFSET
TIMEZONE KEY(1)
TL_EARNED_TAKEN Used in View Comp Time Page CT_BALANCE
EXPIRE_DT
EXPIRE_HRS
TL_EE_EXPND_NUM NUM1 KEY(1)
TL_EE_EXPND_PRE EMPLID KEY(1)
TL_PREFIX KEY(2)
TL_EE_EXPND_TBL COUNTER_GLOB
RECNAME KEY(1)
TL_ELPTSK_ERR Elapsed Time Itfc Error Data SUBSCRIBE_DTTM KEY(1)
TASK_ELEMENT_CD
TASK_ELEMENT_VAL
TRANSACTIONID KEY(2)
TRANSACTIONID2 KEY(3)
TL_ELPTSK_INTFC Elapsed Task Interface AUDIT_ACTN
BADGE_ID KEY(1)
DELETE_DATE KEY(6)
DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
SEQNUM KEY(5)
TASK_ELEMENT_CD KEY(7)
TASK_ELEMENT_VAL
TL_ELP_ERR Elapsed Time Interface ACTION_DTTM
ADD_DELETE_IND
BADGE_ID
BILLABLE_IND
COMP_RATECD
COUNTRY
CURRENCY_CD
DELETE_DATE
DUR
EMPLID
EMPL_RCD
LOCALITY
OPRID
OVERRIDE_RATE
OVERRIDE_RSN_CD
SEQNUM
STATE
SUBSCRIBE_DTTM KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 36
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TL_COMMENTS
TL_QUANTITY
TRANSACTIONID KEY(2)
TRC
TL_ELP_INTFC Elapsed Time Interface ACTION_DTTM
ADD_DELETE_IND
AUDIT_ACTN
BADGE_ID KEY(1)
BILLABLE_IND
COMP_RATECD
COUNTRY
CURRENCY_CD
DELETE_DATE KEY(6)
DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
LOCALITY
OPRID
OVERRIDE_RATE
OVERRIDE_RSN_CD
SEQNUM KEY(5)
STATE
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TL_COMMENTS
TL_QUANTITY
TRC
TL_ELP_MSG_ERR Elapsed Time Message Errors FIELDNAME KEY(4)
MESSAGE_NBR
MESSAGE_SET_NBR
SUBSCRIBE_DTTM KEY(1)
TASK_ELEMENT_CD
TRANSACTIONID KEY(2)
TRANSACTIONID2 KEY(3)
TL_ELP_TMP Reported Elapsed Time ACT_EXP_DT
CALC_EXP_DT
COMP_TIME_PLAN
CT_BALANCE
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 37
DUR KEY(4)
EFFDT_USED
EMPLID KEY(2)
EMPL_RCD KEY(3)
PROCESS_INSTANCE KEY(1)
SEQ_NBR KEY(5)
TL_QUANTITY
TRC
TL_EMPLCOMP TR Compensatory Time Off Plan EFFDT KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
TL_EMPL_COMP TR Compensatory Time Off Plan COMP_TIME_PLAN KEY(4)
EFFDT KEY(3)
EFF_STATUS
EMPLID KEY(1)
EMPL_RCD KEY(2)
TL_EMPL_DATA Time Employee Time Profile EFFDT KEY(3)
ELP_TR_TMPLT_ID
EMPLID KEY(1)
EMPL_RCD KEY(2)
PCH_TR_TMPLT_ID
PERIOD_ID
RESTRICTION_PRF_ID
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
TASKGROUP
TASK_PROFILE_ID
TCD_GROUP_ID
TIMEZONE
TIME_RPTG_STATUS
TIME_RPTR_IND
TL_TIME_TO_PAY
WORKGROUP
TL_EMPL_DTA_MSG Time Rprtr Attributes Msg Rec AUDIT_ACTN
BADGE_ID
BIRTHDATE
EMPLID KEY(4)
EMPL_RCD KEY(5)
FIRST_NAME
HIRE_DT
IN_PROCESS_FLG
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 38
LAST_NAME
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
RESTRICTION_PRF_ID
SERVICE_DT
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
TIME_RPTG_STATUS
TL_EMPL_TAO Work Table for TCD Empl Attrib AUDIT_ACTN
BADGE_ID
BIRTHDATE
EMPLID KEY(4)
EMPL_RCD KEY(5)
FIRST_NAME
HIRE_DT
IN_PROCESS_FLG
LAST_NAME
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
RESTRICTION_PRF_ID
SERVICE_DT
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
TIME_RPTG_STATUS
TL_ERNCD_TBL Earning Code Table EFFDT KEY(2)
EFF_STATUS
PAY_SYSTEM KEY(3)
TL_COPY_FROM
TL_ERNCD
TL_TAKECD
TRC KEY(1)
TL_EXCEPTION T&L Exception ACTION_DTTM
COMMENTS
DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
END_DT
EXCEPTION_ID KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 39
EXCEPTION_SOURCE
EXCEPTION_STATUS
MSG_DATA1
MSG_DATA2
MSG_DATA3
MSG_DATA4
MSG_DATA5
RESOLVED_BY
START_DT
TL_EXCEPT_DEFN T&L Exception Definition ALLOWABLE_IND
DESCR
DESCRSHORT
EFFDT KEY(2)
EXCEPTION_ID KEY(1)
MESSAGE_NBR
MESSAGE_SET_NBR
PS_DELIVERED
SAVE_IND
SEVERITY
TL_EXCEPT_LANG T&L Exception Related Language COMMENTS
DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
EXCEPTION_ID KEY(1)
LANGUAGE_CD KEY(5)
MSG_DATA1
MSG_DATA2
MSG_DATA3
MSG_DATA4
MSG_DATA5
TL_EXCP_DFN_LNG T&L Exception Defn Rel Lang DESCR
DESCRSHORT
EFFDT KEY(3)
EXCEPTION_ID KEY(1)
LANGUAGE_CD KEY(2)
TL_EXC_RULE_AET DESCR
PROCESS_INSTANCE KEY(1)
TL_RULE_ID
TL_FRCS_PYBL_TM Forecasted Payable Time TL_FRCS_TM_SBR
*TL_GROUP_DTL Group Detail EMPLID KEY(2)
EMPL_RCD KEY(3)
GROUP_ID KEY(1)
GROUP_TYPE_IND
TL_GROUP_LANG Group Related Language DESCR
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 40
DESCRSHORT
GROUP_ID KEY(1)
LANGUAGE_CD KEY(2)
TL_COMMENTS
*TL_GROUP_TBL Time Employees Group Table ASOFDATE
DESCR
DESCRSHORT
GROUP_ID KEY(1)
GROUP_SEL_1
GROUP_SEL_2
GROUP_TYPE_IND
GRP_CONCAT_1
GRP_WHERE_CLS
LAST_REFRESH_DTTM
TASKGROUP
TL_COMMENTS
*TL_GRP_FLD_SEC Group Field Security Record ACCESSIBLE
FIELDNAME KEY(3)
RECNAME KEY(2)
ROWSECCLASS KEY(1)
*TL_GRP_PARM_TBL TL Group Parameters Table FIELDNAME
GROUP_BOOLEAN
GROUP_ID KEY(1)
GROUP_LEFT_PAREN
GROUP_OPERATOR
GROUP_RIGHT_PAREN
GROUP_VALUE
RECNAME
SEQNUM KEY(2)
SETID
TL_GRP_REF_AET Group Refresh AE State Record APPROVE_DATE
CALL_APPENGINE_FLG
EXIST
GROUP_ID
OPRID
PROCESS_INSTANCE KEY(1)
REFRESH_SW
RUN_CNTL_ID
TL_GRP_SECURITY T & L Group Security Table GROUP_ID KEY(2)
ROWSECCLASS KEY(1)
TL_INSTALLATION Installation Time & Labor Tbl CALC_EST_GROSS
CALL_TA
FILE_ARCHIVE_DIR
FILE_OUTPUT_DIR
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 41
IDENTITY_COL_USED
INTRFC_PERF_MEAS
INTRFC_PROJ_COST
LAST_SEQ_PAY_TIME
LAST_ST_INSTANCE
LEAVE_VAL_ASOF
MAX_ONLINE_RULES
NO_PAY_ROWS
PAYROLL_REQ_NUM
PERIOD_MONTH
RUN_ONLINE_RULES
TA_BATCH_SIZE
TA_LAST_ALIAS
TA_LAST_SECTION
TA_LAST_SQL_ID
TEST_COMP_BAL
TEST_LV_BAL
TL_IN_PROD
USE_DFLT_WORKGROUP
VALID_INST_ID
VALID_SET_ID
VALID_STREAM_ID
TL_IPT1_CNT Time Admin AccumulatorsTable PROCESS_INSTANCE KEY(1)
TL_IPT_SBR
TL_IPTCTVAL_AET Compensatory Time Off Table CALC_EXP_DT
COMP_TIME_PLAN
DUMMY_FIELD
DUR
EFFDT_USED
EMPLID
EMPL_RCD
ERN_EFFDT_USED
EXCEPTION_ID
EXPIRE_NUM
EXPIRE_PER
HRS_GO_NEGATIVE
HRS_GO_POSITIVE
MAX_DT
MAX_NEG_HRS
MAX_POS_HRS
PROCESS_INSTANCE KEY(1)
RECNAME
SAVE_IND
SEQNUM
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 42
TABLE_NAME
TABLE_NAME1
TKN_EFFDT_USED
TRC
VALID_INST_ID
TL_LBDST_RUNCTL Labor Distribution Run Control OPRID KEY(1)
PROCESS_ON_OFF
RUN_CNTL_ID KEY(2)
RUN_ID
TL_LPAD_DISPLAY OPRID KEY(1)
TL_DISPLAY_OPTIONS
TL_MONTHCD
YEARCD
TL_MASS_SESSION T&L Mass Time Session APPLY_OFFDAY_IND
END_DATE
GROUP_ID
MASS_UPDATE_STATUS
MASS_USER_ACTION
OPRID
START_DATE
ST_INSTANCE KEY(1)
TASKGROUP
TL_ADDREP_IND
TL_MASS_TM_AET Mass Time State Record EXISTS_FLAG
MASS_USER_ACTION
PROCESS_INSTANCE KEY(1)
ST_INSTANCE
TL_MASS_TR T&L Mass Time Reported EMPLID KEY(2)
EMPL_RCD KEY(3)
MEMBER_STATUS
ST_INSTANCE KEY(1)
TL_MASS_TRANS T&L Time Transaction BILLABLE_IND
COMP_RATECD
COUNTRY
CURRENCY_CD
LOCALITY
OVERRIDE_RATE
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
SEQNUM KEY(2)
STATE
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 43
ST_INSTANCE KEY(1)
TL_QUANTITY
TL_TASK_SBR
TRC
USE_PROFILE_IND
TL_MBLE_TRCDT TRC date for Mobile Device EMPLID KEY(2)
EMPL_RCD KEY(3)
SEQNUM KEY(6)
START_DT KEY(1)
STATUS_FLAG KEY(5)
TRC KEY(4)
TL_METASQL_LANG Time Admin Meta SQL Table DESCR
DESCRLONG
DESCRSHORT
LANGUAGE_CD KEY(2)
META_SQL KEY(1)
TL_METASQL_TBL Time Admin Meta SQL Table DESCR
DESCRLONG
DESCRSHORT
FIELD_DATA_TYPE
MAX_PARAMETERS
META_SQL KEY(1)
META_SQL_PARM1
META_SQL_PARM2
META_SQL_PARM3
META_SQL_PARM4
META_SQL_PARM5
META_SQL_PARM6
META_SQL_PARM7
META_SQL_TYPE
TL_MNG_CHECK CHECK_BOX
TL_MNG_FIELD FIELD_NAME
FIELD_NAME1
FIELD_NAME3
FIELD_NAME4
TL_OPR_SECURITY T&L Operator Security Tbl PPA_ACCESS
PPA_ALLOW
PPA_NOTIFY
ROWSECCLASS KEY(1)
TL_SYSTEM_DT
USE_TL_SYSDATE
TL_OT_DATA Overtime Request Data EMPLID KEY(1)
EMPL_RCD KEY(2)
OPRID
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 44
TL_OT_DATE
TL_OT_HOURS
TL_OT_STATUS
TL_SEQ_NUM KEY(3)
TL_SUBMIT_DT
TL_OT_MONTH_TBL Overtime Limit ID - Month EFFDT KEY(2)
TL_MONTH_LIMIT KEY(3)
TL_OT_HOURS_LIMIT
TL_OT_ID KEY(1)
TL_OT_SETUP_LNG Overtime Limit ID - Language DESCR
DESCRSHORT
EFFDT KEY(2)
LANGUAGE_CD KEY(3)
TL_OT_ID KEY(1)
TL_OT_SETUP_TBL Overtime Limit Setup DESCR
DESCRSHORT
EFFDT KEY(2)
EFF_STATUS
LIST_ID
PERIOD_ID
TL_OT_ID KEY(1)
TL_OT_STATUS Workflow for Overtime APPR_PATH KEY(5)
APPR_STEP KEY(4)
COMMENTS
CURRENT_STEP
EMPLID KEY(1)
EMPLID_TO
EMPL_RCD KEY(2)
ROLENAME
ROLEUSER
SEQNO KEY(6)
TL_SEQ_NUM KEY(3)
TL_WF_ACTION
TRANS_DT
TL_OT_SUB_WL Overtime Worklist Rec ACTIVITYNAME KEY(2)
BUSPROCNAME KEY(1)
EMPLID KEY(7)
EMPL_RCD KEY(8)
EVENTNAME KEY(3)
INSTANCEID KEY(5)
TL_NAME
TL_SEQ_NUM KEY(9)
TRANSACTIONID KEY(6)
WORKLISTNAME KEY(4)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 45
TL_OUTTCD_AET AE State Rec for TL_OUTTCD ACCTCD_FLAG
ACTIVITY_FLAG
BUS_UNIT_FLAG
BUS_UNIT_HR_FLAG
BUS_UNIT_PF_FLAG
COMPANY_FLAG
CUSTOMER_FLAG
DEPTID_FLAG
DESCR
EFFDT KEY(2)
EMPLID
EMPL_RCD
EXIST
JOBCODE_FLAG
JOBINSTANCE
LANGUAGE_CD
LOCATION_FLAG
MSGNODENAME
OPRID
OPT1
OPT10
OPT11
OPT12
OPT13
OPT14
OPT15
OPT16
OPT17
OPT18
OPT19
OPT2
OPT20
OPT21
OPT22
OPT23
OPT3
OPT4
OPT5
OPT6
OPT7
OPT8
POSITION_NBR_FLAG
PRCSINSTANCE
PROCESS_INSTANCE KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 46
PROCESS_NAME
PRODUCT_FLAG
PROJECT_FLAG
RECNAME
REQUIRED_LBL
RESOURCE_CAT_FLAG
RESOURCE_TYPE_FLAG
RESRCE_SUBCAT_FLAG
RUNCNTLID
RUN_CNTL_ID
SEND_COUNTRY
SEND_CURRENCY_CODE
SEND_HOURS
SEND_LOCALITY
SEND_OVRD_RSN_CODE
SEND_RATE_CODE
SEND_RULE_ELMNT1
SEND_RULE_ELMNT2
SEND_RULE_ELMNT3
SEND_RULE_ELMNT4
SEND_RULE_ELMNT5
SEND_SCHED
SEND_STATE
SEND_TASK_VALUES
SEND_TRCS
SEND_TSK_PRF
SEND_TSK_TEMPLT
STATE
TASK_ELEMENT_CD
TASK_FLAG
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID
TL_QUANTITY
TRC
USER_FIELD_1_FLAG
USER_FIELD_2_FLAG
USER_FIELD_3_FLAG
USER_FIELD_4_FLAG
USER_FIELD_5_FLAG
TL_OVRD_RSN_LNG Related Lang for TL Ovrd Rsn DESCR
DESCRSHORT
LANGUAGE_CD KEY(2)
OVERRIDE_RSN_CD KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 47
TL_OVRD_RSN_TBL Override Reason Codes DESCR
DESCRSHORT
OVERRIDE_RSN_CD KEY(1)
TL_PAYABLE_HIST Payable History PROCESS_INSTANCE KEY(1)
TL_PYBL_TM_SBR
TL_PAYABLE_TAO Payable Time Temp DATE_UNDER_RPT KEY(3)
DLYTASK_SEQNUM KEY(5)
EMPLID KEY(1)
EMPL_RCD KEY(2)
SEQNUM KEY(4)
SEQ_NBR KEY(6)
TL_PAYABLE_TIME Payable Time TL_PYBL_TM_SBR
TL_PAYABLE_TMP Payable Time Temp ACCT_CD
ACTIVITY_ID
APPROVAL_FLAG
BORROW_TSKGRP
BUSINESS_UNIT_PC
COMPANY
COMP_RATECD
CUSTOMER
DATE_UNDER_RPT KEY(3)
DEPTID
DLYTASK_SEQNUM KEY(5)
EMPLID KEY(1)
EMPL_RCD KEY(2)
EST_GROSS
LABOR_DIST_FLAG
LBR_DIST_AMT
LOCALITY
OPRID
ORIG_SEQ_NBR
ORIG_TASKGROUP
ORIG_TL_QTY
ORIG_TRC
OVERRIDE_RATE
PC_DISTRIB_STATUS
PERIOD_PRCS_DT
PROCESS_STATE_IND
PRODUCT
PROJECT_COST_FLAG
PROJECT_ID
QUANTITY_TMP
REPORTED_AMT
REPORTED_FLAG
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 48
REPORTED_HRS
REPORTED_UNITS
RESOURCE_CATEGORY
RESOURCE_SUB_CAT
RESOURCE_TYPE
RULE_FLAG
RULE_ID_ER
SCHEDULE_FLAG
SEQNUM KEY(4)
SEQ_NBR KEY(6)
SETID
SHIFT_ID
SOURCE_IND
STATE
TASK
TRC
TRC_TYPE
TSKGRP_OVRD_FLAG
UPDT_PAYROLL_FLAG
USER_FIELD_1
USER_FIELD_2
USER_FIELD_3
USER_FIELD_4
USER_FIELD_5
TL_PAYCALC_EDIT Time and Labor Recalc table COMPANY KEY(1)
EMPLID
EMPL_RCD
LINE_NUM KEY(6)
OFF_CYCLE KEY(4)
PAGE_NUM KEY(5)
PAYGROUP KEY(2)
PAY_END_DT KEY(3)
TL_PAYLABR_XREF Time PayUpdt/LaborDist Xref ADDL_NBR KEY(7)
ADJ_TYPE_IND
COMPANY KEY(1)
DATE_UNDER_RPT KEY(12)
EMPLID KEY(9)
EMPL_RCD KEY(10)
ERNCD KEY(11)
LINE_NUM KEY(6)
OFF_CYCLE KEY(4)
PAGE_NUM KEY(5)
PAYGROUP KEY(2)
PERIOD_PRCS_DT KEY(3)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 49
SEQNUM KEY(14)
TIME_RPTG_CD KEY(13)
WORKGROUP KEY(8)
TL_PAYREQ_AET ACTERR_CNT
COMPANY
DATE_COUNT
DUR
EMPLID
EMPL_RCD
EXCEPTION_ID
EXIST
EXTRACT_DATA
IMAGE_NUM
LD_FLAG
OPRID
PAYGROUP
PAYROLL_REQ_NUM
PAYSND_CNT
PAY_END_DT
PAY_SYSTEM
PRCSINSTANCE
PROCESS_INSTANCE KEY(1)
PROCESS_ON_OFF
PUBNODE
REPEAT_REQ_CD
REPEAT_REQ_FROM_DT
REPEAT_REQ_NUM
REPEAT_REQ_TO_DT
REQUEST_NBR
RUN_CNTL_ID
RUN_ID
SEQ_NBR
TOTERR_CNT
XREF_NUM
TL_PAYREQ_E EMPLID KEY(5)
EMPL_RCD KEY(6)
FROM_DATE
NO_OFFSETS
PAYROLL_REQ_NUM KEY(2)
PAY_SYSTEM KEY(1)
REPEAT_REQ_CD
REQ_VALUE_1 KEY(3)
REQ_VALUE_2 KEY(4)
TL_ERNCD
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 50
TO_DATE KEY(7)
TL_PAYROLL_REQ Payroll Interface Record EMPLID KEY(5)
EMPL_RCD KEY(6)
FROM_DATE
NO_OFFSETS
PAYROLL_REQ_NUM KEY(2)
PAY_SYSTEM KEY(1)
REPEAT_REQ_CD
REPEAT_REQ_FROM_DT
REPEAT_REQ_NUM
REPEAT_REQ_TO_DT
REQ_VALUE_1 KEY(3)
REQ_VALUE_2 KEY(4)
TL_ERNCD
TO_DATE KEY(7)
TL_PAYROLL_SENT Updated information on sent FROM_DATE
PAYROLL_REQ_NUM KEY(3)
PAY_SYSTEM KEY(2)
REPEAT_REQ_CD
REQ_VALUE_1
REQ_VALUE_2
SEQ_NBR KEY(1)
TO_DATE
TL_PAYSYS_LANG TL Pay System Related Language DESCR
LANGUAGE_CD KEY(2)
PAY_SYSTEM KEY(1)
TL_PAYSYS_TBL Time & Labor Pay System Tbl DESCR
DESCRSHORT
LDILU_FLAG
LD_FLAG
PAY_SYSTEM KEY(1)
TL_PAYTIME_ERR DUR KEY(5)
EMPLID KEY(1)
EMPL_RCD KEY(2)
PAY_SYSTEM KEY(4)
REASON
TRC KEY(3)
TL_PAYTIME_ERRF DUR KEY(5)
EMPLID KEY(1)
EMPL_RCD KEY(2)
PAY_SYSTEM KEY(4)
REASON
TRC KEY(3)
TL_PAYTIME_SENT Payroll Interface Record PROCESS_INSTANCE
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 51
REQ_VALUE_1
REQ_VALUE_2
TL_PYBL_TM_SBR
TRC_TYPE
UNIT_OF_MEASURE
TL_PCHTSK_ERR Punched Time Intfc Error Data SUBSCRIBE_DTTM KEY(1)
TASK_ELEMENT_CD
TASK_ELEMENT_VAL
TRANSACTIONID KEY(2)
TRANSACTIONID2 KEY(3)
TL_PCHTSK_INTFC Punched Task Interface AUDIT_ACTN
BADGE_ID KEY(1)
DELETE_DATE KEY(5)
EMPLID KEY(2)
EMPL_RCD KEY(3)
PUNCH_DTTM KEY(4)
TASK_ELEMENT_CD KEY(6)
TASK_ELEMENT_VAL
TL_PCH_DUR_WRK Reported Punch Time BADGE_ID
COUNTRY
DUR
EMPLID KEY(1)
EMPL_RCD KEY(2)
LOCALITY
OPRID
OVERRIDE_RSN_CD
PUNCH_DTTM KEY(3)
PUNCH_TYPE
RT_SOURCE
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
STATE
TASKGROUP
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TIMEZONE
TL_COMMENTS
TL_TASK_SBR
TL_PCH_MSG_ERR Punched Time Message Errors FIELDNAME KEY(4)
MESSAGE_NBR
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 52
MESSAGE_SET_NBR
SUBSCRIBE_DTTM KEY(1)
TASK_ELEMENT_CD
TRANSACTIONID KEY(2)
TRANSACTIONID2 KEY(3)
TL_PE_OPR_MGRTM Time Mgmt Settings OPRID KEY(1)
USER_FIELD_1_FLAG
USER_FIELD_2_FLAG
USER_FIELD_3_FLAG
USER_FIELD_4_FLAG
USER_FIELD_5_FLAG
TL_PE_OPR_MGRWA Wrkfrc Availability Settings OPRID KEY(1)
USER_FIELD_1_FLAG
USER_FIELD_2_FLAG
USER_FIELD_3_FLAG
USER_FIELD_4_FLAG
USER_FIELD_5_FLAG
TL_PRCS_QUEUE DESCR50
TL_PRCS_END_DTTM
TL_PRCS_INSTANCE KEY(1)
TL_PRCS_START_DTTM
TL_PROCESS_TYPE
TL_PRODUCT_LNG Time and Labor Products DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
PRODUCT KEY(1)
TL_PRODUCT_TBL Time and Labor Products DESCR
DESCRSHORT
EFFDT KEY(2)
EFF_STATUS
PRODUCT KEY(1)
TL_PROFILE_AET TR Profile State record EMPLID
END_DATE
PROCESS_INSTANCE KEY(1)
START_DATE
TL_PROJECT T & L Project Table DESCR
DESCRSHORT
EFFDT KEY(2)
EFF_STATUS
PROJECT_ID KEY(1)
TL_PROJECT_LNG T & L Project Table DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 53
PROJECT_ID KEY(1)
TL_PROJ_AET ACT_EST_SCHED_FLAG
APPROVE_DATE
EMPLID
EMPL_RCD
EXIST
LDILU_FLAG
MSGNODENAME
OPRID
PROCESS_INSTANCE KEY(1)
RUN_CNTL_ID
TL_PT_CTVAL_AET Compensatory Time Off Table CALC_EXP_DT
COMP_TIME_PLAN
DUMMY_FIELD
DUR
EFFDT_USED
EMPLID
EMPL_RCD
ERN_EFFDT_USED
EXPIRE_NUM
EXPIRE_PER
HRS_GO_NEGATIVE
HRS_GO_POSITIVE
MAX_DT
MAX_NEG_HRS
MAX_POS_HRS
PROCESS_INSTANCE KEY(1)
RECNAME
SEQNUM
TABLE_NAME
TABLE_NAME1
TKN_EFFDT_USED
TRC
VALID_INST_ID
TL_PUBDT_WRK TL Accounting Dt Rec ACCOUNTING_DT KEY(6)
COMMIT_ACCTG_FLG KEY(5)
COMPANY KEY(2)
END_DT
PAYGROUP KEY(3)
PAY_BEGIN_DT
PAY_END_DT KEY(4)
PROCESS_INSTANCE KEY(1)
TL_PUNCH_ERR Punch Time Interface ACTION_DTTM
ADD_DELETE_IND
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 54
BADGE_ID
COUNTRY
DELETE_DATE
EMPLID
EMPL_RCD
LOCALITY
OPRID
OVERRIDE_RSN_CD
PUNCH_DTTM
PUNCH_TYPE
STATE
SUBSCRIBE_DTTM KEY(1)
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TIMEZONE
TL_COMMENTS
TRANSACTIONID KEY(2)
TL_PUNCH_INTFC Punch Time Interface ACTION_DTTM
ADD_DELETE_IND
AUDIT_ACTN
BADGE_ID
COUNTRY
DELETE_DATE
EMPLID
EMPL_RCD
LOCALITY
OPRID
OVERRIDE_RSN_CD
PUNCH_DTTM
PUNCH_TYPE
STATE
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TIMEZONE
TL_COMMENTS
TL_PYPUB_TM_AET CALL_SECTION_FLAG
EXIST
OPRID
PAY_SYSTEM
PROCESS_INSTANCE KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 55
RUN_CNTL_ID
*TL_RAPID_HEADER Time Rapid Entry Header DESCR
DTTM_STAMP
OPRID
RAPID_TMPLT_ID
RAPID_UPDATE_FLAG
ST_INSTANCE KEY(1)
TL_ADDREP_IND
TL_RAPID_H_LANG T&L Rapid Entry Header DESCR
LANGUAGE_CD KEY(2)
RAPID_TMPLT_ID
ST_INSTANCE KEY(1)
TL_RAPID_PTIME Rapid Time Table COUNTRY
DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
LOCALITY
OVERRIDE_RSN_CD
PUNCH_DTTM
PUNCH_TIME KEY(5)
PUNCH_TYPE
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
STATE
ST_INSTANCE KEY(1)
TASKGROUP
TASK_PROFILE_ID
TIMEZONE
TL_COMMENTS
TL_TASK_NPR_SBR
TL_RAPID_RCTRL Rapid Update RunCtrl DESCR50
DTTM_STAMP
OPRID KEY(2)
RUN_CNTL_ID KEY(1)
TL_RAPID_TIME Rapid Time Table BILLABLE_IND
COMP_RATECD
COUNTRY
CURRENCY_CD
DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 56
LOCALITY
OVERRIDE_RATE
OVERRIDE_RSN_CD
PUNCH_DTTM
PUNCH_TIME
PUNCH_TYPE
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
SEQNUM KEY(5)
SHIFT
STATE
ST_INSTANCE KEY(1)
TASKGROUP
TASK_PROFILE_ID
TIMEZONE
TL_COMMENTS
TL_QUANTITY
TL_TASK_NPR_SBR
TRC
TL_RAPID_T_LANG Rapid Time Table DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
LANGUAGE_CD KEY(6)
SEQNUM KEY(5)
ST_INSTANCE KEY(1)
TL_COMMENTS
TL_RECFIELD_TBL Fields From All TL Work Tbls FIELDNAME KEY(2)
FIELDNUM
RECNAME KEY(1)
USEEDIT
TL_RECFLD_AET Time Admin RecFld State Record PROCESS_INSTANCE KEY(1)
SEQUENCENO
TL_RECNAME1_TAO Temp Table For TL_RECFIELD FIELDNAME KEY(2)
RECNAME KEY(1)
TL_RECNAME2_TAO Temp Table For TL_RECFIELD FIELDNAME KEY(2)
RECNAME KEY(1)
TL_REC_ONLY_ADJ Last Seq # for Rec Adjustments LAST_SEQ_REC_ADJ
TL_REPORTS_AET T&L Reports AE State Record END_DATE
OPRID
PROCESS_INSTANCE KEY(1)
RUN_CNTL_ID
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 57
START_DATE
TL_OUT_RECORD_NM
TL_REPSEQ1_WRK Submit Sequence Numbers DUR KEY(4)
EMPLID KEY(2)
EMPL_RCD KEY(3)
SEQNUM
TL_SUBMIT_ID KEY(1)
TL_RESPF_TAO Work Table for TCD Restr Profs AUDIT_ACTN
EARLY_BREAK
EARLY_IN_PUNCH
EARLY_MEAL
EARLY_OUT_PUNCH
IN_PROCESS_FLG
LATE_BREAK
LATE_IN_PUNCH
LATE_MEAL
LATE_OUT_PUNCH
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
RESTRICTION_PRF_ID KEY(4)
RES_EARLY_BREAK
RES_EARLY_IN
RES_EARLY_MEAL
RES_EARLY_OUT
RES_LATE_BREAK
RES_LATE_IN
RES_LATE_MEAL
RES_LATE_OUT
RES_UNSCHED_MEAL
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RESPRF_LNG Related Language for TL Resprf DESCR
DESCRSHORT
EFFDT KEY(3)
LANGUAGE_CD KEY(2)
RESTRICTION_PRF_ID KEY(1)
TL_RESPRF_TBL Restriction Profiles DESCR
DESCRSHORT
EARLY_BREAK
EARLY_IN_PUNCH
EARLY_MEAL
EARLY_OUT_PUNCH
EFFDT KEY(2)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 58
EFF_STATUS
LATE_BREAK
LATE_IN_PUNCH
LATE_MEAL
LATE_OUT_PUNCH
RESTRICTION_PRF_ID KEY(1)
RES_EARLY_BREAK
RES_EARLY_IN
RES_EARLY_MEAL
RES_EARLY_OUT
RES_LATE_BREAK
RES_LATE_IN
RES_LATE_MEAL
RES_LATE_OUT
RES_UNSCHED_MEAL
TL_RESTRICT_MSG TCD Restrictn Profile Msg Rec AUDIT_ACTN
EARLY_BREAK
EARLY_IN_PUNCH
EARLY_MEAL
EARLY_OUT_PUNCH
IN_PROCESS_FLG
LATE_BREAK
LATE_IN_PUNCH
LATE_MEAL
LATE_OUT_PUNCH
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
RESTRICTION_PRF_ID KEY(4)
RES_EARLY_BREAK
RES_EARLY_IN
RES_EARLY_MEAL
RES_EARLY_OUT
RES_LATE_BREAK
RES_LATE_IN
RES_LATE_MEAL
RES_LATE_OUT
RES_UNSCHED_MEAL
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RI_CNTRL_TBL T&L Referential Integrity COLUMN_NM KEY(5)
COLUMN_VALUE_CHAR KEY(6)
COLUMN_VALUE_NUM
EFFDT KEY(8)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 59
END_DATE KEY(9)
PRIMARY_KEY_NAME1 KEY(2)
PRIMARY_KEY_NAME2 KEY(4)
PRIMARY_KEY_VALUE1 KEY(3)
PRIMARY_KEY_VALUE2
SEQNUM KEY(7)
VALID_DEFN_ID KEY(1)
TL_RI_RUN Used in Time Admin IN_PROCESS_FLG
TL_RI_TEST_AET T&L RI State Record COLUMN_NM
COLUMN_VALUE_CHAR
COLUMN_VALUE_NUM
EFFDT
EMPLID
EMPL_RCD
END_DATE
OPERATOR_SIGN
PRIMARY_KEY_NAME1
PRIMARY_KEY_NAME2
PRIMARY_KEY_VALUE1
PRIMARY_KEY_VALUE2
PROCESS_INSTANCE KEY(1)
SEQNUM
SEQUENCENO
STRING_DATE
STRING_DTTM
TABLE_NAME
VALID_DEFN_ID
VALID_INST_ID
VALID_STREAM_ID
TL_RLTNSHP_DEFN T&L Relationship Definition LEFT_RECNAME KEY(1)
R1F1
R1F2
R1F3
R1F4
R1F5
R2F1
R2F2
R2F3
R2F4
R2F5
RIGHT_RECNAME KEY(2)
TL_RPDTME_LANG DESCR
LANGUAGE_CD KEY(2)
RAPID_TMPLT_ID KEY(1)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 60
TL_RPDTME_TMPLT Setup Flags for Rapid Time ACCOUNT_FLAG
ACCTCD_FLAG
ACTIVITY_FLAG
BILLIND_FLAG
BUSINESS_UNIT_FLAG
BUS_UNIT_PC_FLAG
BUS_UNIT_PF_FLAG
COMMENTS_FLAG
COMPANY_FLAG
COMP_RTCD_FLAG
COUNTRY_FLAG
CURRCD_FLAG
CUSTOMER_FLAG
DEPTID_FLAG
DESCR
DUR_FLAG
EMPLID_FLAG
EMPL_NAME_FLAG
EMPL_RCDN_FLAG
JOBCODE_FLAG
LOCALITY_FLAG
LOCATION_FLAG
OVERD_RSN_FLAG
OVRD_RT_FLAG
POSITION_NBR_FLAG
PRODUCT_FLAG
PROJECT_ID_FLAG
PUNCH_TIME_FLAG
PUNCH_TYPE_FLAG
RAPID_TMPLT_ID KEY(1)
RESRC_CAT_FLAG
RESRC_SCAT_FLAG
RESRC_TYPE_FLAG
RULE_ELE1_FLAG
RULE_ELE2_FLAG
RULE_ELE3_FLAG
RULE_ELE4_FLAG
RULE_ELE5_FLAG
STATE_FLAG
TASKGROUP_FLAG
TASK_ID_FLAG
TASK_PRFID_FLAG
TIME_RPTR_IND
TIME_ZONE_FLAG
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 61
TL_QUANTITY_FLAG
TRC_FLAG
USER_FLD1_FLAG
USER_FLD2_FLAG
USER_FLD3_FLAG
USER_FLD4_FLAG
USER_FLD5_FLAG
TL_RPTD_ELPTIME Reported Elapsed Time BADGE_ID
DUR KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
LASTUPDDTTM
OPRID
OVERRIDE_RSN_CD
RT_SOURCE
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
SEQNUM KEY(4)
SYNCID
TASKGROUP
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TL_COMMENTS
TL_TASK_NPC_SBR
TL_TR_SBR
TL_RPTD_PCHTIME Reported Punch Time BADGE_ID
COUNTRY
EMPLID KEY(1)
EMPL_RCD KEY(2)
LOCALITY
OPRID
OVERRIDE_RSN_CD
PUNCH_DTTM KEY(3)
PUNCH_TYPE
RT_SOURCE
RULE_ELEMENT_1
RULE_ELEMENT_2
RULE_ELEMENT_3
RULE_ELEMENT_4
RULE_ELEMENT_5
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 62
STATE
TASKGROUP
TASK_PROFILE_ID
TCD_ID
TCD_SUPERVISR_ID
TIMEZONE
TL_COMMENTS
TL_TASK_SBR
TL_RPTD_TMPLT Time Reporting Template BADGE_ID_FLAG
BADGE_ID_OPT
BILL_IND_FLAG
BILL_IND_OPT
COMMENTS_FLAG
COMMENTS_OPT
COMP_RTCD_FLAG
COMP_RTCD_OPT
COUNTRY_FLAG
COUNTRY_OPT
CURRCD_FLAG
CURRCD_OPT
DESCR
DESCRSHORT
LOCALITY_FLAG
LOCALITY_OPT
OVRD_RSN_FLAG
OVRD_RSN_OPT
OVRD_RT_FLAG
OVRD_RT_OPT
OVRD_RULES_FLAG
OVRD_RULES_OPT
RULE_ELE1_FLAG
RULE_ELE1_OPT
RULE_ELE2_FLAG
RULE_ELE2_OPT
RULE_ELE3_FLAG
RULE_ELE3_OPT
RULE_ELE4_FLAG
RULE_ELE4_OPT
RULE_ELE5_FLAG
RULE_ELE5_OPT
STATE_FLAG
STATE_OPT
TASK_PRFL_FLAG
TASK_PRFL_OPT
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 63
TASK_TMPLT_FLAG
TASK_TMPLT_OPT
TCD_FLAG
TCD_OPT
TIMEZONE_FLAG
TIMEZONE_OPT
TIME_RPTG_TMPLT KEY(1)
TIME_RPTR_IND
TL_DAYOFWEEK_FLAG
TL_DAYOFWEEK_OPT
TRC_FLAG
TRC_OPT
TRC_TYPE_FLAG
TRC_TYPE_OPT
UOM_FLAG
UOM_OPT
TL_RPTEL_TAO Work Table for TCD Rpt Element AUDIT_ACTN
COUNTRY KEY(5)
DESCR
IN_PROCESS_FLG
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
RPTG_ELE_CODE KEY(6)
RPTG_ELE_IND KEY(4)
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RPTG_ELE_MSG TCD Reporting Elements Msg Rec AUDIT_ACTN
COUNTRY KEY(5)
DESCR
IN_PROCESS_FLG
MSGNODENAME KEY(2)
PROCESS_INSTANCE KEY(1)
RPTG_ELE_CODE KEY(6)
RPTG_ELE_IND KEY(4)
TCD_ID KEY(3)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RPTMPLT_LANG Time Reporting Template DESCR
DESCRSHORT
LANGUAGE_CD KEY(2)
TIME_RPTG_TMPLT KEY(1)
TL_RPTS_RNCTL T&L Reports Run Control END_DATE
LANGUAGE_CD
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 64
OPRID KEY(1)
PROCESS_INSTANCE
RUN_CNTL_ID KEY(2)
START_DATE
TL_RPT_CDVAL Reporting - TCD Task Elem Cd AUDIT_ACTN
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
TASK_ELEMENT_CD KEY(2)
TASK_ELEMENT_VAL KEY(3)
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
VALUE_SOURCE
TL_RPT_EMPL Report Table for TCD Empl Info AUDIT_ACTN
BADGE_NBR KEY(4)
BIRTHDATE
EMPLID KEY(2)
EMPL_RCD KEY(3)
FIRST_NAME_SRCH
HIRE_DT
IN_PROCESS_FLG
LAST_NAME_SRCH
MSGNODENAME
PROCESS_INSTANCE
RESTRICTION_PRF_ID
SERVICE_DT
TASK_PRFL_TMPLT_ID
TASK_PROFILE_ID
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TCD_SUPERVISR_ID
TIME_RPTG_STATUS
TL_RPT_SCHED Report Table for TCD Schedules AUDIT_ACTN
BADGE_NBR KEY(2)
EMPLID KEY(3)
EMPL_RCD KEY(4)
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
PUNCH_DTTM KEY(5)
PUNCH_TYPE
SEQNUM KEY(6)
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 65
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RPT_SUPVR Reporting for TCD Supervisors AUDIT_ACTN
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
SUPERVISR_PIN_NUM
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TCD_SUPERVISR_ID KEY(2)
TL_RPT_TKPRF Report Table for TCD Tsk Profs AUDIT_ACTN
DESCR
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
TASK_PROFILE_ID KEY(2)
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RPT_TKTMP Report Tbl for TCD Tsk Templts AUDIT_ACTN
DESCR
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
TASK_PRFL_TMPLT_ID KEY(2)
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RPT_TMPDL Reports for TCD Templt Detail AUDIT_ACTN
DESCR
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
REQUIRED_LBL
TASK_ELEMENT_CD KEY(3)
TASK_PRFL_TMPLT_ID KEY(2)
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TL_RPT_TRC Reports Table for TCD TRCs AUDIT_ACTN
DESCR
IN_PROCESS_FLG
-
EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008
Section 2.4 Records Alphabets T-Z.doc P a g e | 66
MSGNODENAME
PROCESS_INSTANCE
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TRC KEY(2)
TL_RPT_TTHRS Report Tbe for TCD Total Hours AUDIT_ACTN
BADGE_NBR KEY(2)
EMPLID KEY(3)
EMPL_RCD KEY(4)
IN_PROCESS_FLG
MSGNODENAME
PROCESS_INSTANCE
TCD_ID KEY(1)
TCD_NETWORK_ID
TCD_NODE_ID
TL_QUANTITY
TRC KEY(5)
TL_RULES_OVRD Override Rules Process DUR KEY(3)
EMPLID KEY(1)
EMPL_RCD KEY(2)
TL_RULE_CONDS Time Admin Rule Conditions BOOLEAN_OPERATOR
CONDITION_ID
LEFT_PAREN
RIGHT_PAREN
SEQ_NUM KEY(3)
TL_RULE_ID KEY(1)
TL_RULE_STEP KEY(2)
TL_RULE_DEFN T&L Rule Definition AE_SECTION
AE_SECTION_UD
CHANGED
COMPILE_DTTM
COMPILE_FLAG
CORE_COMPONENT