COMPANY_ID 
ColumnName  COMPANY_ID 
Definition 
Name: Record Key. Description: The Company ID for this configuration record.
 

DFLT_TS_SCHEDULE_CD 
ColumnName  DFLT_TS_SCHEDULE_CD 
Definition 
Name: Default Timesheet Schedule. Description: Default timesheet schedule for new employees.
 

DFLT_WORK_SCHEDULE_CD 
ColumnName  DFLT_WORK_SCHEDULE_CD 
Definition 
Name: Default Work Schedule. Description: Default work schedule for new employees.
 

DFLT_CLASS_CD 
ColumnName  DFLT_CLASS_CD 
Definition 
Name: Default Timesheet Class. Description: Default employee class for new employees.
 

S_TRACK_LEAVE_CD 
ColumnName  S_TRACK_LEAVE_CD 
Definition 
Name: Leave UDT Track Option. Description: The UDT by which leave is identified and tracked by. The valid values are UDT01, UDT02, and UDT10.
 

DFLT_TIMESHEET_NO 
ColumnName  DFLT_TIMESHEET_NO 
Definition 
Name: Default Number of Timesheets. Description: The default employee preference value when employee records are added.
 

DFLT_LOAD_FAVORITES_FL 
ColumnName  DFLT_LOAD_FAVORITES_FL 
Definition 
Name: Default Load Favorites Flag. Description: The default employee preference value when employee records are added. The field is logical.
 

MIN_TIMESHEET_ROW_NO 
ColumnName  MIN_TIMESHEET_ROW_NO 
Definition 
Name: Minimum Timesheet Rows. Description: The minimum number of timesheet rows displayed for user entry. Please note that employee may have less rows filled out or more rows filled out.
 

CHARGE_DESC_SIZE_NO 
ColumnName  CHARGE_DESC_SIZE_NO 
Definition 
Name: Charge Desciption Column Size. Description: The size of the Charge Description in characters. This controls the size of the Charge Description on Timesheet and Charge Lookup.
 

CHARGE_DESC_SEQ_NO 
ColumnName  CHARGE_DESC_SEQ_NO 
Definition 
Name: Charge Description Column Sequence. Description: Default sequence number for Charge Description. This controls the order of the Charge Description on Timesheet and Charge Lookup.
 

S_LINE_APPROVE_CD 
ColumnName  S_LINE_APPROVE_CD 
Definition 
Name: Charge Approval Option. Description: The type of line level approval configured for the Deltek Time and Expense system. The valid options are as follows: DISABLED – Disabled. REQUIRED – Required. OPTIONAL – Optional
 

CALC_RATE1_FL 
ColumnName  CALC_RATE1_FL 
Definition 
Name: Calculate Rate 1 Flag. Description: Logical as to whether User-Defined Rate 1 is calculated.
 

CALC_RATE2_FL 
ColumnName  CALC_RATE2_FL 
Definition 
Name: Calculate Rate 2 Flag. Description: Logical as to whether User-Defined Rate 2 is calculated.
 

S_PRORATE_CD 
ColumnName  S_PRORATE_CD 
Definition 
Name: Hour Proration Option. Description: The method of calculation for Hour Proration. The valid options are as follows: “DISABLED” – Disabled. “HOURS” – Prorate to Hours Increment. “DECIMAL2” – Prorate to 2 positions to right of dec. pt. 
 

ALLOW_UNAUTH_CHARGE_FL 
ColumnName  ALLOW_UNAUTH_CHARGE_FL 
Definition 
Name: Allow Unauthorized Charges Flag. Description: This indicates whether employees are allowed to charge to unauthorized charges.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

DISABLE_LINE_COMMENTS_FL 
ColumnName  DISABLE_LINE_COMMENTS_FL 
Definition 
Name: Disable Line Comments Flag. Description: Logical as to whether line comments can be entered.
 

DISABLE_CELL_COMMENTS_FL 
ColumnName  DISABLE_CELL_COMMENTS_FL 
Definition 
Name: Disable Cell Comments Flag. Description: Logical as to whether cell comments can be entered.
 

TS_HEADER_VALUE 
ColumnName  TS_HEADER_VALUE 
Definition 
Name: Timesheet Header User Defined Option. Description: This value determines whether an additional field will display in the Timesheet header. The valid options are: NONE – No extra field in header.. UDT01 – UDT01 value from Employee History will display in timesheet header.. UDT02 – UDT02 value from Employee History will display in timesheet header.. UDT03 – UDT03 value from Employee History will display in timesheet header.. UDT04 – UDT04 value from Employee History will display in timesheet header.. UDT05 – UDT05 value from Employee History will display in timesheet header.. UDT06 – UDT06 value from Employee History will display in timesheet header.. UDT07 – UDT07 value from Employee History will display in timesheet header.. UDT08 – UDT08 value from Employee History will display in timesheet header.. UDT09 – UDT09 value from Employee History will display in timesheet header.. UDT10 – UDT10 value from Employee History will display in timesheet header.. UDT10 – UDT10 value from Employee History will display in timesheet header.. UDT11 – UDT11 value from Employee History will display in timesheet header.. UDT12 – UDT12 value from Employee History will display in timesheet header.. UDT13 – UDT13 value from Employee History will display in timesheet header.. UDT14 – UDT14 value from Employee History will display in timesheet header.. UDT15 – UDT15 value from Employee History will display in timesheet header.. EMCD1 – Employee User-defined Code 1 will display in timesheet header.. EMCD2 – Employee User-defined Code 2 will display in timesheet header.. EMCD3 – Employee User-defined Code 3 will display in timesheet header.
 

S_ENHANCED_LEAVE_EDIT_CD 
ColumnName  S_ENHANCED_LEAVE_EDIT_CD 
Definition 
Name: Leave Edit Option. Description: The type of leave edit configured for Deltek Time. The valid options are: A – As Of. B – Both. C – Cumulative
 

TRACK_LUNCH_FL 
ColumnName  TRACK_LUNCH_FL 
Definition 
Name: Track Time In/Out Lunch Flag. Description: Logical as to whether lunch start and end date/times are tracked in time in/out information.
 

S_LABOR_CD 
ColumnName  S_LABOR_CD 
Definition 
Name: Labor Export Layout. Description: Indicates the type of labor export. The valid values are,COSTPOINT4X,COSTPOINT51,COSTPOINT61,COSTPOINT62,GCS,GENERIC_DETAIL,GENERIC_SUMMARY,NONE.
 

S_PAYROLL_CD 
ColumnName  S_PAYROLL_CD 
Definition 
Name: Payroll Export Layout. Description: Indicates the type of labor export. The valid values are ADP. ADPRATE. NONE
 

EXPORT_LABOR_AMT_FL 
ColumnName  EXPORT_LABOR_AMT_FL 
Definition 
Name: Export Labor Amounts Flag. Description: Logical as to whether labor amounts are exported.
 

SUMMARY_FL 
ColumnName  SUMMARY_FL 
Definition 
Name: Summary Export Flag. Description: If labor export is Costpoint, this logical determines if the export is summarized by timesheet line.
 

S_WBS_CD 
ColumnName  S_WBS_CD 
Definition 
Name: GCS WBS Option. Description: Indicates whether WBS (UDT02 if labor export is GCS) should also be copied to other UDT field. The valid values are REF1 – UDT04. REF2 – UDT05. NONE 
 

S_ADP_BATCH_ID_CD 
ColumnName  S_ADP_BATCH_ID_CD 
Definition 
Name: ADP Batch ID Option. Description: Controls how batch IDs are built for ADP exports. The valid values are BATCH_ID. CODE1_CD. CODE2_CD. CODE3_CD
 

PRORATE_UP_FL 
ColumnName  PRORATE_UP_FL 
Definition 
Name: Prorate Hours Upward Flag. Description: Logical that determines whether proration will prorate hours upwards.
 

S_WAGE_DETERMINATION_CD 
ColumnName  S_WAGE_DETERMINATION_CD 
Definition 
Name: Wage Determination Option. Description: Indicates whether wage determination is enabled and whether it is standard or advanced. The valid values are: D- Disabled. S – Standard. E - Enhanced
 

TIMESHEET_PERIOD_TEXT_FL 
ColumnName  TIMESHEET_PERIOD_TEXT_FL 
Definition 
Name: Timesheet Period Text Flag. Description: Logical as to whether timesheet period text feature is enabled.
 

EXPORT_MULTIPLE_TS_PERIODS_FL 
ColumnName  EXPORT_MULTIPLE_TS_PERIODS_FL 
Definition 
Name: Export Multiple Timesheet Periods Filag. Description: Logical as to whether multiple timesheet periods can be exported at one time.
 

S_PREV_DAY_REV_DEADLINE_CD 
ColumnName  S_PREV_DAY_REV_DEADLINE_CD 
Definition 
Name: Previous Day Revision Deadline Option. Description: Controls whether changes to previous day revisions are tracked. The valid values are: D - Disabled. 1A – 1:00 am. 2A – 2:00 am. 3A – 3:00 am. 4A – 4:00 am. 5A – 5:00 am. 6A – 6:00 am. 7A – 7:00 am. 8A – 8:00 am. 9A – 9:00 am. 10A – 10:00 am. 11A – 11:00 am. 12P – 12:00 pm. 1P – 1:00 pm. 2A – 2:00 pm. 3P – 3:00 pm. 4P – 4:00 pm. 5P – 5:00 pm. 6P – 6:00 pm. 7P – 7:00 pm. 8P – 8:00 pm. 9P – 9:00 pm. 10P – 10:00 pm. 11P – 11:00 pm. 12A – 12:00 am
 

S_EXPORT_IN_PROCESS_TS_CD 
ColumnName  S_EXPORT_IN_PROCESS_TS_CD 
Definition 
Name: Export In-process Timesheet Option. Description: Indicates whether in process timesheet export is enabled and what type of charges can be exported. The valid values are as follows: D – Disabled. M – MO Charges Only. A – All Charges
 

ALLOW_REJECTION_PROCESSED_FL 
ColumnName  ALLOW_REJECTION_PROCESSED_FL 
Definition 
Name: Allow Reject Processed Flag. Description: Logical as to whether a supervisor can reject a timesheet when the timesheet status is Processed
 

RECAST_PR_UDT10_FL 
ColumnName  RECAST_PR_UDT10_FL 
Definition 
Name: Recast Payroll UDT10 Flag. Description: Logical that indicates whether recasting of UDT10 occurs in the timesheet PR export.
 

RECAST_LD_UDT10_FL 
ColumnName  RECAST_LD_UDT10_FL 
Definition 
Name: Recast Labor Distribution UDT10 Flag. Description: Logical that indicates whether recasting of UDT10 occurs in the timesheet LD export.
 

S_DFLT_TIMESHEET_VIEW 
ColumnName  S_DFLT_TIMESHEET_VIEW 
Definition 
Name: Timesheet View. Description: Indicates the timesheet view for Blackberry time. The valid values are C  -Condensed, E - Expanded.
 

S_DFLT_TS_LINE_SORT 
ColumnName  S_DFLT_TS_LINE_SORT 
Definition 
Name: Timesheet Line Sort. Description: Indicates the timesheet line sort for Blackberry time. The valid values are I  - Project ID, N - Project Name, L - Line Number. 
 

INCLUDE_PROJ_MANAGER_NAME_FL 
ColumnName  INCLUDE_PROJ_MANAGER_NAME_FL 
Definition 
Name: Include project manager name in timesheet search. Description: Logical as to whether the project manager should be included in timesheet search.
 

CP_SALARY_PRORATION_FL 
ColumnName  CP_SALARY_PRORATION_FL 
Definition 
Name: Costpoint Salary Proration flag. Description: Indicator that turns on/off support for Costpoint's salary proration feature
 

LD_RECAST_CUSTOM_FL 
ColumnName  LD_RECAST_CUSTOM_FL 
Definition 
Name: Labor Distribution Recast Custom Description: Determines whether or not custom procedures are to be used when exporting labor information.
 

PR_RECAST_CUSTOM_FL 
ColumnName  PR_RECAST_CUSTOM_FL 
Definition 
Name: Payroll Recast Custom Description: Determines whether or not custom procedures are to be used when exporting payroll information.