TIME_CONFIG 
Default Table Name  TIME_CONFIG 
Definition 
 .     Field
 

TIME_CONFIG Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
COMPANY_ID(PK)(FK)    VARCHAR(10)  NO 
Name: Record Key. Description: The Company ID for this configuration record.
 
DFLT_TS_SCHEDULE_CD(FK)    VARCHAR(10)  NO 
Name: Default Timesheet Schedule. Description: Default timesheet schedule for new employees.
 
DFLT_WORK_SCHEDULE_CD(FK)    VARCHAR(10)  NO 
Name: Default Work Schedule. Description: Default work schedule for new employees.
 
DFLT_CLASS_CD(FK)    VARCHAR(20)  NO 
Name: Default Timesheet Class. Description: Default employee class for new employees.
 
S_TRACK_LEAVE_CD    VARCHAR(5)  NO 
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    NUMERIC(10, 0)  NO 
Name: Default Number of Timesheets. Description: The default employee preference value when employee records are added.
 
DFLT_LOAD_FAVORITES_FL    VARCHAR(1)  NO 
Name: Default Load Favorites Flag. Description: The default employee preference value when employee records are added. The field is logical.
 
MIN_TIMESHEET_ROW_NO    NUMERIC(10, 0)  NO 
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    NUMERIC(10, 0)  NO 
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    NUMERIC(10, 0)  NO 
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    VARCHAR(10)  NO 
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    VARCHAR(1)  NO 
Name: Calculate Rate 1 Flag. Description: Logical as to whether User-Defined Rate 1 is calculated.
 
CALC_RATE2_FL    VARCHAR(1)  NO 
Name: Calculate Rate 2 Flag. Description: Logical as to whether User-Defined Rate 2 is calculated.
 
S_PRORATE_CD    VARCHAR(10)  NO 
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    VARCHAR(1)  NO 
Name: Allow Unauthorized Charges Flag. Description: This indicates whether employees are allowed to charge to unauthorized charges.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
DISABLE_LINE_COMMENTS_FL    VARCHAR(1)  NO 
Name: Disable Line Comments Flag. Description: Logical as to whether line comments can be entered.
 
DISABLE_CELL_COMMENTS_FL    VARCHAR(1)  NO 
Name: Disable Cell Comments Flag. Description: Logical as to whether cell comments can be entered.
 
TS_HEADER_VALUE    VARCHAR(5)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(20)  NO 
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    VARCHAR(20)  NO 
Name: Payroll Export Layout. Description: Indicates the type of labor export. The valid values are ADP. ADPRATE. NONE
 
EXPORT_LABOR_AMT_FL    VARCHAR(1)  NO 
Name: Export Labor Amounts Flag. Description: Logical as to whether labor amounts are exported.
 
SUMMARY_FL    VARCHAR(1)  NO 
Name: Summary Export Flag. Description: If labor export is Costpoint, this logical determines if the export is summarized by timesheet line.
 
S_WBS_CD    VARCHAR(4)  NO 
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    VARCHAR(10)  NO 
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    VARCHAR(1)  NO 
Name: Prorate Hours Upward Flag. Description: Logical that determines whether proration will prorate hours upwards.
 
S_WAGE_DETERMINATION_CD    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
Name: Timesheet Period Text Flag. Description: Logical as to whether timesheet period text feature is enabled.
 
EXPORT_MULTIPLE_TS_PERIODS_FL    VARCHAR(1)  NO 
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    VARCHAR(3)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
Name: Recast Payroll UDT10 Flag. Description: Logical that indicates whether recasting of UDT10 occurs in the timesheet PR export.
 
RECAST_LD_UDT10_FL    VARCHAR(1)  NO 
Name: Recast Labor Distribution UDT10 Flag. Description: Logical that indicates whether recasting of UDT10 occurs in the timesheet LD export.
 
S_DFLT_TIMESHEET_VIEW    VARCHAR(1)  NO 
Name: Timesheet View. Description: Indicates the timesheet view for Blackberry time. The valid values are C  -Condensed, E - Expanded.
 
S_DFLT_TS_LINE_SORT    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
Name: Costpoint Salary Proration flag. Description: Indicator that turns on/off support for Costpoint's salary proration feature
 
LD_RECAST_CUSTOM_FL    VARCHAR(1)  NO 
Name: Labor Distribution Recast Custom Description: Determines whether or not custom procedures are to be used when exporting labor information.
 
PR_RECAST_CUSTOM_FL    VARCHAR(1)  NO 
Name: Payroll Recast Custom Description: Determines whether or not custom procedures are to be used when exporting payroll information.
 

TIME_CONFIG Keys 
Key Name  Key Type  Keys 
RI_F00128  Inversion Entry  DFLT_CLASS_CD 
RI_F00127  Inversion Entry  DFLT_WORK_SCHEDULE_CD 
RI_F00126  Inversion Entry  DFLT_TS_SCHEDULE_CD 
PI_0140  PrimaryKey  COMPANY_ID 

TIME_CONFIG Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
COMPANY  Identifying  One To Zero or More        COMPANY_ID  NO 
TS_SCHEDULE  Non-Identifying  One To Zero or More        DFLT_TS_SCHEDULE_CD  NO 
WORK_SCHEDULE  Non-Identifying  One To Zero or More        DFLT_WORK_SCHEDULE_CD  NO 
CLASS  Non-Identifying  One To Zero or More        DFLT_CLASS_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype