Table Information for the Import Timesheets from Deltek Time and Expense Screen

Changes to the Import Timesheets from Deltek Time and Expense screen update several tables.

Updated tables include:

  • ACCT
  • ACCT_ENTRY_RULES
  • ACCTING_PD
  • BILL_LAB_CAT
  • EMPL
  • EMPL_ACCT_GRP_DFLT
  • FY
  • GENL_LAB_CAT
  • LAB_ACCT_GRP_DFLT
  • LAB_LOCATION
  • LV_TYPE
  • ORG
  • ORG_ACCT
  • OT_RULES_BY_STATE
  • OT_SETTINGS
  • PAY_TYPE
  • PAY_TYPE_RESTRICT
  • PROJ
  • PROJ_CNTL
  • PROJ_EMPL_LAB_CAT
  • PROJ_LAB_CAT
  • PROJ_LAB_CAT_MAP
  • PROJ_ORG_ACCT
  • PROJ_TS_DFLT
  • REF_STRUC
  • EMPL_LAB_INFO
  • SUB_PD
  • TS_HDR_HS
  • TS_PD_SCH
  • DFLT_REG_TS
  • WAGE_DETERM
  • WORK_COMP
  • Input File: (User Named)

Tables Read and Written

  • FUNC_PARMS_CATLG
  • POST_SEMAPHORE
  • SEQ_GENERATOR
  • TS_HDR
  • (TS_LN)
  • (T_PARMS_AOPUTLTS)

Output

  • Error File: (Input file name + .ERR)
  • Edit Report
  • Error Report