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. |