ColumnName |
Domain |
Datatype |
NULL |
Definition |
COMPANY_ID |
|
VARCHAR2(10) |
NO |
Name: Record Key. Description: The Company ID for this configuration record. |
DFLT_TS_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Default Timesheet Schedule. Description: Default timesheet schedule for new employees. |
DFLT_WORK_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Default Work Schedule. Description: Default work schedule for new employees. |
DFLT_CLASS_CD |
|
VARCHAR2(20) |
NO |
Name: Default Timesheet Class. Description: Default employee class for new employees. |
S_TRACK_LEAVE_CD |
|
VARCHAR2(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 |
|
NUMBER(10, 0) |
NO |
Name: Default Number of Timesheets. Description: The default employee preference value when employee records are added. |
DFLT_LOAD_FAVORITES_FL |
|
VARCHAR2(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 |
|
NUMBER(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 |
|
NUMBER(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 |
|
NUMBER(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 |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Calculate Rate 1 Flag. Description: Logical as to whether User-Defined Rate 1 is calculated. |
CALC_RATE2_FL |
|
VARCHAR2(1) |
NO |
Name: Calculate Rate 2 Flag. Description: Logical as to whether User-Defined Rate 2 is calculated. |
S_PRORATE_CD |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Allow Unauthorized Charges Flag. Description: This indicates whether employees are allowed to charge to unauthorized charges. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(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 |
|
VARCHAR2(1) |
NO |
Name: Disable Line Comments Flag. Description: Logical as to whether line comments can be entered. |
DISABLE_CELL_COMMENTS_FL |
|
VARCHAR2(1) |
NO |
Name: Disable Cell Comments Flag. Description: Logical as to whether cell comments can be entered. |
TS_HEADER_VALUE |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(20) |
NO |
Name: Payroll Export Layout. Description: Indicates the type of labor export. The valid values are ADP. ADPRATE. NONE |
EXPORT_LABOR_AMT_FL |
|
VARCHAR2(1) |
NO |
Name: Export Labor Amounts Flag. Description: Logical as to whether labor amounts are exported. |
SUMMARY_FL |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Prorate Hours Upward Flag. Description: Logical that determines whether proration will prorate hours upwards. |
S_WAGE_DETERMINATION_CD |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Timesheet Period Text Flag. Description: Logical as to whether timesheet period text feature is enabled. |
EXPORT_MULTIPLE_TS_PERIODS_FL |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Costpoint Salary Proration flag. Description: Indicator that turns on/off support for Costpoint's salary proration feature |
LD_RECAST_CUSTOM_FL |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Payroll Recast Custom Description: Determines whether or not custom procedures are to be used when exporting payroll information. |