CLASS 
Default Table Name  CLASS 
Definition 
 Name: Employee Class .     Description: This table contains the user-defined employee classes. Employee classes are used to define categories of employees and assign business rules to them.
 

CLASS Columns 
ColumnName  Domain  Datatype  NULL  Definition 
CLASS_CD(PK)    VARCHAR2(20)  NO 
Name: Timesheet Class. Description: User-specified unique identifier for this table.
 
CLASS_DESC    VARCHAR2(30)  NO 
Name: Timesheet Class Description. Description: Unique description of employee class.
 
S_HRS_INCREMENT_CD    VARCHAR2(20)  NO 
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    VARCHAR2(20)  NO 
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    VARCHAR2(1)  NO 
Name: Payroll Export Flag. Description: Logical as to whether payroll records are created for this employee class during timesheet export.
 
LABOR_EXPORT_FL    VARCHAR2(1)  NO 
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    VARCHAR2(3)  NO 
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    NUMBER(8, 2)  NO 
Name: Min Daily Regular Hours. Description: The minimum number of regular hours that must be entered on a workday.
 
MAX_DAILY_REG_HRS    NUMBER(8, 2)  NO 
Name: Max Daily Regular Hours. Description: The maximum number of regular hours that must be entered on a workday.
 
MIN_WEEKLY_REG_HRS    NUMBER(8, 2)  NO 
Name: Min Weekly Regular Hours. Description: The minimum number of regular hours that must be entered on a workweek.
 
MAX_WEEKLY_REG_HRS    NUMBER(8, 2)  NO 
Name: Max Weekly Regular Hours. Description: The maximum number of regular hours that must be entered on a workweek.
 
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.
 
S_DAILY_REG_HRS_EDIT_CD    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(15)  NO 
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    VARCHAR2(1)  YES 
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    VARCHAR2(1)  YES 
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    VARCHAR2(1)  YES 
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    VARCHAR2(1)  YES 
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    VARCHAR2(1)  NO 
Name: Reverse Timesheet Flag. Description: Logical as to whether employees of this class must reverse timesheet before correcting.
 
PRORATE_TS_FL    VARCHAR2(1)  NO 
Name: Prorate Timesheet Flag. Description: Logical as to whether timesheets for employees of this class are prorated when signed.
 
REQUEST_LEAVE_FL    VARCHAR2(1)  NO 
Name: Request Leave Flag. Description: Logical as to whether employee must request leave. (Vacation)
 
GENERATE_TS_FL    VARCHAR2(1)  NO 
Name: Generate Timesheet Flag. Description: Logical as to whether timesheets can be automatically generated for employees of this class.
 
ALLOW_OFFLINE_TS_FL    VARCHAR2(1)  NO 
Name: Offline Timesheet Flag. Description: Logical as to whether employees belonging to this class can use off-line timesheet functionality.
 
OT_DIALOG_FL    VARCHAR2(1)  YES 
Name: Overtime Dialog Flag. Description: Logical as to whether custom dialog appears when timesheet is approved with hours over standard.
 
MODIFY_SCHED_PROPERTIES_FL    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
Name: Populate Leave Flag. Description: Logical that indicates whether employees vacation and holiday are auto-populated when new timesheet is opened.
 
INTERIM_FL    VARCHAR2(1)  NO 
 
S_INTERIM_EDIT_CD    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    NUMBER(8, 2)  NO 
Name: Daily Overtime Threshold #1 Hours. Description: The first daily threshold for overtime.
 
DAILY_OT_LEVEL2_HRS    NUMBER(8, 2)  NO 
Name: Daily Overtime Threshold #2 Hours. Description: The second daily threshold for overtime.
 
DAILY_OT_LEVEL1_FACTOR_AMT    NUMBER(15, 5)  NO 
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    NUMBER(15, 5)  NO 
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    VARCHAR2(1)  NO 
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    NUMBER(8, 2)  NO 
Name: Weekly Overtime Threshold #1 Hours. Description: The first weekly threshold for overtime.
 
WEEKLY_OT_LEVEL2_HRS    NUMBER(8, 2)  NO 
Name: Weekly Overtime Threshold #2 Hours. Description: The second weekly threshold for overtime.
 
WEEKLY_OT_LEVEL1_FACTOR_AMT    NUMBER(15, 5)  NO 
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    NUMBER(15, 5)  NO 
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    VARCHAR2(1)  NO 
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    NUMBER(8, 2)  NO 
Name: 7th Day Overtime Threshold #1 Hours. Description: The first 7th consecutive workday threshold for overtime.
 
DAY_7TH_OT_LEVEL2_HRS    NUMBER(8, 2)  NO 
Name: 7th Day Overtime Threshold #2 Hours. Description: The second 7th consecutive workday threshold for overtime.
 
DAY_7TH_OT_LEVEL1_FACTOR_AMT    NUMBER(15, 5)  NO 
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    NUMBER(15, 5)  NO 
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    VARCHAR2(10)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
Name: In-Process Timesheet Flag. Description: Logical as to whether this class shall have in-process timesheets exported. 
 
CP_PROJECT_LOOKUP_FL    VARCHAR2(1)  NO 
Name: CP Charge Lookup Project Flag. Description: Logical as to whether Costpoint Charge Lookup should have a Project Tab.
 
CP_MO_LOOKUP_FL    VARCHAR2(1)  NO 
Name: CP Charge Lookup MO Flag. Description: Logical as to whether Costpoint Charge Lookup should have a MO Tab
 
CP_ACCOUNT_LOOKUP_FL    VARCHAR2(1)  NO 
Name: CP Charge Lookup Account Flag. Description: Logical as to whether Costpoint Charge Lookup should have an Account Tab.
 
INCLUDE_OT_HRS_FL    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
Name: Weekly overtime calculation Method. Description: Determines whether weekly overtime is calculated daily or based on the entir week.
 
NOTES    VARCHAR2(1024)  YES 
Name: Notes  Description: Notes pertaining to a ts class.
 

CLASS Primary and Unique Keys 
Key Name  Key Type  Keys 
SI_0003  Index  CLASS_DESC 
PI_0016  PrimaryKey  CLASS_CD 

CLASS Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
CLASS_UDT10  Identifying  One To Zero or More  F00007        NO  NO 
EMPL_HISTORY  Non-Identifying  One To Zero or More  F00033        NO  NO 
TS  Non-Identifying  One To Zero or More  F00040        NO  NO 
CLASS_LEAVE  Identifying  One To Zero or More  F00076        NO  NO 
CLASS_EVENT  Identifying  One To Zero or More  F00086        NO  NO 
TIME_CONFIG  Non-Identifying  One To Zero or More  F00128        NO  NO 
CLASS_UDT  Identifying  One To Zero or More  F00312        NO  NO