CLASS_CD 
ColumnName  CLASS_CD 
Definition 
Name: Timesheet Class. Description: User-specified unique identifier for this table.
 

CLASS_DESC 
ColumnName  CLASS_DESC 
Definition 
Name: Timesheet Class Description. Description: Unique description of employee class.
 

S_HRS_INCREMENT_CD 
ColumnName  S_HRS_INCREMENT_CD 
Definition 
Name: Hours Increment. Description: The increment of hours that can be entered by employees assigned to this employee class. The valid options are as follows:WHOLE. HALF. QUARTER. TENTH. HUNDREDTH. 
 

S_REVISION_CD 
ColumnName  S_REVISION_CD 
Definition 
Name: Revision Explanation. Description: The revision explanation options that are valid for employees assigned to this employee class. The valid options are as follows:DISABLED. OPTIONAL. REQUIRED. . 
 

PAYROLL_EXPORT_FL 
ColumnName  PAYROLL_EXPORT_FL 
Definition 
Name: Payroll Export Flag. Description: Logical as to whether payroll records are created for this employee class during timesheet export.
 

LABOR_EXPORT_FL 
ColumnName  LABOR_EXPORT_FL 
Definition 
Name: Labor Distribution Flag. Description: Logical as to whether labor distribution records are created for this employee class during timesheet export.
 

S_START_DOW_CD 
ColumnName  S_START_DOW_CD 
Definition 
Name: Starting Day of Week. Description: Indicates the day of the week in which the workweek starts. The valid values are as follows:MON. TUE. WED. THU. FRI. SAT. SUN. 
 

MIN_DAILY_REG_HRS 
ColumnName  MIN_DAILY_REG_HRS 
Definition 
Name: Min Daily Regular Hours. Description: The minimum number of regular hours that must be entered on a workday.
 

MAX_DAILY_REG_HRS 
ColumnName  MAX_DAILY_REG_HRS 
Definition 
Name: Max Daily Regular Hours. Description: The maximum number of regular hours that must be entered on a workday.
 

MIN_WEEKLY_REG_HRS 
ColumnName  MIN_WEEKLY_REG_HRS 
Definition 
Name: Min Weekly Regular Hours. Description: The minimum number of regular hours that must be entered on a workweek.
 

MAX_WEEKLY_REG_HRS 
ColumnName  MAX_WEEKLY_REG_HRS 
Definition 
Name: Max Weekly Regular Hours. Description: The maximum number of regular hours that must be entered on a workweek.
 

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.
 

S_DAILY_REG_HRS_EDIT_CD 
ColumnName  S_DAILY_REG_HRS_EDIT_CD 
Definition 
Name: Daily Regular Hours Edit Type. Description: Type of edit that occurs on daily regular hours. Valid values:N = no edit. S = soft edit. H = hard edit. . 
 

S_WEEKLY_REG_HRS_EDIT_CD 
ColumnName  S_WEEKLY_REG_HRS_EDIT_CD 
Definition 
Name: Weekly Regular Hours Edit Type. Description: Type of edit that occurs on weekly regular hours. Valid values:N = no edit. S = soft edit. H = hard edit. . 
 

S_UNDER_PERIOD_REG_HRS_EDIT_CD 
ColumnName  S_UNDER_PERIOD_REG_HRS_EDIT_CD 
Definition 
Name: Under Period Regular Hours Edit Type. Description: Type of edit that occurs when the hours are less than the time sheet period standard hours. Valid values:N = no edit. S = soft edit. H = hard edit. . 
 

S_OVER_PERIOD_REG_HRS_EDIT_CD 
ColumnName  S_OVER_PERIOD_REG_HRS_EDIT_CD 
Definition 
Name: Over Period Regular Hours Edit Type. Description: Type of edit that occurs when the hours are greater than the time sheet period standard hours. Valid values:N = no edit. S = soft edit. H = hard edit. . 
 

S_UDT01_REG_HRS_EDIT_CD 
ColumnName  S_UDT01_REG_HRS_EDIT_CD 
Definition 
Name: UDT01 Regular Hours Edit Type. Description: Type of edit that occurs on the hours charged to UDT01 types. Valid values:N = no edit. S = soft edit. H = hard edit. . 
 

S_TIME_IN_OUT_CD 
ColumnName  S_TIME_IN_OUT_CD 
Definition 
Name: Time In/Out Edit Type. Description: Which of the time in/out options is valid for employees assigned to the employee class. The valid options are as follows:DISABLED - Disabled. REQ_HARD - Required/Hard Edit. REQ_SOFT - Required/Soft Edit. REQ_NO_EDIT - Required/No Edit. OPT_HARD - Optional/Hard Edit. OPT_SOFT - Optional/Soft Edit. OPT_NO_EDIT - Optional/No Edit. 
 

VIEW_RATE1_FL 
ColumnName  VIEW_RATE1_FL 
Definition 
Name: View Rate 1 Flag. Description: Logical as to whether employees of this class can view the first user-defined rate/amount fields.
 

VIEW_RATE2_FL 
ColumnName  VIEW_RATE2_FL 
Definition 
Name: View Rate 2 Flag. Description: Logical as to whether employees of this class can view the second user-defined rate/amount fields.
 

MODIFY_RATE1_FL 
ColumnName  MODIFY_RATE1_FL 
Definition 
Name: Modify Rate 1 Flag. Description: Logical as to whether employees of this class can modify the first user-defined rate/amount fields.
 

MODIFY_RATE2_FL 
ColumnName  MODIFY_RATE2_FL 
Definition 
Name: Modify Rate 2 Flag. Description: Logical as to whether employees of this class can modify the second user-defined rate/amount fields.
 

REVERSE_TS_FL 
ColumnName  REVERSE_TS_FL 
Definition 
Name: Reverse Timesheet Flag. Description: Logical as to whether employees of this class must reverse timesheet before correcting.
 

PRORATE_TS_FL 
ColumnName  PRORATE_TS_FL 
Definition 
Name: Prorate Timesheet Flag. Description: Logical as to whether timesheets for employees of this class are prorated when signed.
 

REQUEST_LEAVE_FL 
ColumnName  REQUEST_LEAVE_FL 
Definition 
Name: Request Leave Flag. Description: Logical as to whether employee must request leave. (Vacation)
 

GENERATE_TS_FL 
ColumnName  GENERATE_TS_FL 
Definition 
Name: Generate Timesheet Flag. Description: Logical as to whether timesheets can be automatically generated for employees of this class.
 

ALLOW_OFFLINE_TS_FL 
ColumnName  ALLOW_OFFLINE_TS_FL 
Definition 
Name: Offline Timesheet Flag. Description: Logical as to whether employees belonging to this class can use off-line timesheet functionality.
 

OT_DIALOG_FL 
ColumnName  OT_DIALOG_FL 
Definition 
Name: Overtime Dialog Flag. Description: Logical as to whether custom dialog appears when timesheet is approved with hours over standard.
 

MODIFY_SCHED_PROPERTIES_FL 
ColumnName  MODIFY_SCHED_PROPERTIES_FL 
Definition 
Name: Modify Schedule Flag. Description: Logical as to whether employees in this timesheet class can modify the properties for specific date or day of week schedule records.
 

MODIFY_SCHED_STANDARD_HRS_FL 
ColumnName  MODIFY_SCHED_STANDARD_HRS_FL 
Definition 
Name: Modify Schedule Standard Hours Flag. Description: Logical as to whether employees in this timesheet class can modify their standard hours for specific date or day of week schedule records.
 

MODIFY_SCHED_LUNCH_HRS_TIME_FL 
ColumnName  MODIFY_SCHED_LUNCH_HRS_TIME_FL 
Definition 
Name: Modify Schedule Default Lunch Times Flag. Description: Logical as to whether employees in this timesheet class can modify their default lunch time in/out for specific date or day of week schedule records.
 

MODIFY_SCHED_WORK_HRS_TIME_FL 
ColumnName  MODIFY_SCHED_WORK_HRS_TIME_FL 
Definition 
Name: Modify Schedule Work Hours Flag. Description: Logical as to whether employees in this timesheet class can modify their onsite and offsite hours and in/out for specific date or day of week schedule records.
 

POPULATE_LEAVE_ON_OPEN_FL 
ColumnName  POPULATE_LEAVE_ON_OPEN_FL 
Definition 
Name: Populate Leave Flag. Description: Logical that indicates whether employees vacation and holiday are auto-populated when new timesheet is opened.
 

INTERIM_FL 
ColumnName  INTERIM_FL 
Definition 
 

S_INTERIM_EDIT_CD 
ColumnName  S_INTERIM_EDIT_CD 
Definition 
Name: Interim Charge Edit Type. Description: Type of edit that occurs if interim charges are on timesheet at sign. Valid values:N = no edit. S = soft edit. H = hard edit. . 
 

S_OT_DAILY_EDIT_CD 
ColumnName  S_OT_DAILY_EDIT_CD 
Definition 
Name: Daily Overtime Edit Type. Description: Indicates the type of edit performed for the daily overtime hour rules. The valid values:H – Hard Edit. S – Soft Edit. N – No Edit. . 
 

DAILY_OT_LEVEL1_HRS 
ColumnName  DAILY_OT_LEVEL1_HRS 
Definition 
Name: Daily Overtime Threshold #1 Hours. Description: The first daily threshold for overtime.
 

DAILY_OT_LEVEL2_HRS 
ColumnName  DAILY_OT_LEVEL2_HRS 
Definition 
Name: Daily Overtime Threshold #2 Hours. Description: The second daily threshold for overtime.
 

DAILY_OT_LEVEL1_FACTOR_AMT 
ColumnName  DAILY_OT_LEVEL1_FACTOR_AMT 
Definition 
Name: Daily Overtime Factor #1. Description: The multiplier for the daily hours greater than first threshold and less than 2nd threshold
 

DAILY_OT_LEVEL2_FACTOR_AMT 
ColumnName  DAILY_OT_LEVEL2_FACTOR_AMT 
Definition 
Name: Daily Overtime Factor #2. Description: The multiplier for the daily hours greater than first threshold and less than 2nd threshold
 

S_OT_WEEKLY_EDIT_CD 
ColumnName  S_OT_WEEKLY_EDIT_CD 
Definition 
Name: Weekly Overtime Edit Type. Description: Indicates the type of edit performed for the daily overtime hour rules. The valid values:H – Hard Edit. S – Soft Edit. N – No Edit. . 
 

WEEKLY_OT_LEVEL1_HRS 
ColumnName  WEEKLY_OT_LEVEL1_HRS 
Definition 
Name: Weekly Overtime Threshold #1 Hours. Description: The first weekly threshold for overtime.
 

WEEKLY_OT_LEVEL2_HRS 
ColumnName  WEEKLY_OT_LEVEL2_HRS 
Definition 
Name: Weekly Overtime Threshold #2 Hours. Description: The second weekly threshold for overtime.
 

WEEKLY_OT_LEVEL1_FACTOR_AMT 
ColumnName  WEEKLY_OT_LEVEL1_FACTOR_AMT 
Definition 
Name: Weekly Overtime Factor #1. Description: The multiplier for the weekly hours greater than first threshold and less than 2nd threshold
 

WEEKLY_OT_LEVEL2_FACTOR_AMT 
ColumnName  WEEKLY_OT_LEVEL2_FACTOR_AMT 
Definition 
Name: Weekly Overtime Factor #2. Description: The multiplier for the weekly hours greater than first threshold and less than 2nd threshold
 

S_OT_DAY_7TH_EDIT_CD 
ColumnName  S_OT_DAY_7TH_EDIT_CD 
Definition 
Name: 7th Day Overtime Edit Type. Description: Indicates the type of edit performed for the daily overtime hour rules. The valid values:H – Hard Edit. S – Soft Edit. N – No Edit. . 
 

DAY_7TH_OT_LEVEL1_HRS 
ColumnName  DAY_7TH_OT_LEVEL1_HRS 
Definition 
Name: 7th Day Overtime Threshold #1 Hours. Description: The first 7th consecutive workday threshold for overtime.
 

DAY_7TH_OT_LEVEL2_HRS 
ColumnName  DAY_7TH_OT_LEVEL2_HRS 
Definition 
Name: 7th Day Overtime Threshold #2 Hours. Description: The second 7th consecutive workday threshold for overtime.
 

DAY_7TH_OT_LEVEL1_FACTOR_AMT 
ColumnName  DAY_7TH_OT_LEVEL1_FACTOR_AMT 
Definition 
Name: 7th Day Overtime Factor #1. Description: The multiplier for the 7th consecutive workday hours greater than first threshold and less than 2nd threshold
 

DAY_7TH_OT_LEVEL2_FACTOR_AMT 
ColumnName  DAY_7TH_OT_LEVEL2_FACTOR_AMT 
Definition 
Name: 7th Day Overtime Factor #2. Description: The multiplier for the 7th consecutive workday hours greater than first threshold and less than 2nd threshold
 

S_START_STOP_TIME_MODE_CD 
ColumnName  S_START_STOP_TIME_MODE_CD 
Definition 
Name: Start/Stop Mode. Description: Indicates which start/stop time options is valid for employees assigned to the employee class. The valid options are as follows:DISABLED - Disabled. BREAK – Breaks Only. SUMMARY – Breaks/Summary Work. DETAIL – Breaks/Detail Work. 
 

S_START_STOP_TIME_EDIT_CD 
ColumnName  S_START_STOP_TIME_EDIT_CD 
Definition 
Name: Start/Stop Time Edit Type. Description: Indicates which what type of edit is performed during timesheet save routine. The valid options are as follows:N – No Edit. S – Soft Edit. H – Hard Edit. . 
 

S_START_STOP_TIME_ROUNDING_CD 
ColumnName  S_START_STOP_TIME_ROUNDING_CD 
Definition 
Start/Stop Rounding Type. Indicates how the calculated charge hours based on start/stop times should be rounded to the hour increment. The valid options are as follows:U – Round Up. D – Round Down. 
 

IN_PROCESS_TS_FL 
ColumnName  IN_PROCESS_TS_FL 
Definition 
Name: In-Process Timesheet Flag. Description: Logical as to whether this class shall have in-process timesheets exported. 
 

CP_PROJECT_LOOKUP_FL 
ColumnName  CP_PROJECT_LOOKUP_FL 
Definition 
Name: CP Charge Lookup Project Flag. Description: Logical as to whether Costpoint Charge Lookup should have a Project Tab.
 

CP_MO_LOOKUP_FL 
ColumnName  CP_MO_LOOKUP_FL 
Definition 
Name: CP Charge Lookup MO Flag. Description: Logical as to whether Costpoint Charge Lookup should have a MO Tab
 

CP_ACCOUNT_LOOKUP_FL 
ColumnName  CP_ACCOUNT_LOOKUP_FL 
Definition 
Name: CP Charge Lookup Account Flag. Description: Logical as to whether Costpoint Charge Lookup should have an Account Tab.
 

INCLUDE_OT_HRS_FL 
ColumnName  INCLUDE_OT_HRS_FL 
Definition 
Name: Include Previous Day(s) OT Hours flag. Description: Determines whether previous day(s) overtime should be included in the calculation of overtime hours.
 

S_OT_WEEKLY_CALC_METHOD 
ColumnName  S_OT_WEEKLY_CALC_METHOD 
Definition 
Name: Weekly overtime calculation Method. Description: Determines whether weekly overtime is calculated daily or based on the entir week.
 

NOTES 
ColumnName  NOTES 
Definition 
Name: Notes  Description: Notes pertaining to a ts class.