ColumnName |
Domain |
Datatype |
NULL |
Definition |
CLASS_CD |
|
VARCHAR2(20) |
NO |
|
CLASS_DESC |
|
VARCHAR2(30) |
NO |
|
S_HRS_INCREMENT_CD |
|
VARCHAR2(20) |
NO |
|
S_REVISION_CD |
|
VARCHAR2(20) |
NO |
|
PAYROLL_EXPORT_FL |
|
VARCHAR2(1) |
NO |
|
LABOR_EXPORT_FL |
|
VARCHAR2(1) |
NO |
|
S_START_DOW_CD |
|
VARCHAR2(3) |
NO |
|
MIN_DAILY_REG_HRS |
|
NUMBER(8, 2) |
NO |
|
MAX_DAILY_REG_HRS |
|
NUMBER(8, 2) |
NO |
|
MIN_WEEKLY_REG_HRS |
|
NUMBER(8, 2) |
NO |
|
MAX_WEEKLY_REG_HRS |
|
NUMBER(8, 2) |
NO |
|
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
|
ROWVERSION |
|
NUMBER(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
S_DAILY_REG_HRS_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_WEEKLY_REG_HRS_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_UNDER_PERIOD_REG_HRS_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_OVER_PERIOD_REG_HRS_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_UDT01_REG_HRS_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_TIME_IN_OUT_CD |
|
VARCHAR2(15) |
NO |
|
VIEW_RATE1_FL |
|
VARCHAR2(1) |
YES |
|
VIEW_RATE2_FL |
|
VARCHAR2(1) |
YES |
|
MODIFY_RATE1_FL |
|
VARCHAR2(1) |
YES |
|
MODIFY_RATE2_FL |
|
VARCHAR2(1) |
YES |
|
REVERSE_TS_FL |
|
VARCHAR2(1) |
NO |
|
PRORATE_TS_FL |
|
VARCHAR2(1) |
NO |
|
REQUEST_LEAVE_FL |
|
VARCHAR2(1) |
NO |
|
GENERATE_TS_FL |
|
VARCHAR2(1) |
NO |
|
ALLOW_OFFLINE_TS_FL |
|
VARCHAR2(1) |
NO |
|
OT_DIALOG_FL |
|
VARCHAR2(1) |
YES |
|
MODIFY_SCHED_PROPERTIES_FL |
|
VARCHAR2(1) |
NO |
|
MODIFY_SCHED_STANDARD_HRS_FL |
|
VARCHAR2(1) |
NO |
|
MODIFY_SCHED_LUNCH_HRS_TIME_FL |
|
VARCHAR2(1) |
NO |
|
MODIFY_SCHED_WORK_HRS_TIME_FL |
|
VARCHAR2(1) |
NO |
|
POPULATE_LEAVE_ON_OPEN_FL |
|
VARCHAR2(1) |
NO |
|
INTERIM_FL |
|
VARCHAR2(1) |
NO |
|
S_INTERIM_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_OT_DAILY_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
DAILY_OT_LEVEL1_HRS |
|
NUMBER(8, 2) |
NO |
|
DAILY_OT_LEVEL2_HRS |
|
NUMBER(8, 2) |
NO |
|
DAILY_OT_LEVEL1_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
|
DAILY_OT_LEVEL2_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
|
S_OT_WEEKLY_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
WEEKLY_OT_LEVEL1_HRS |
|
NUMBER(8, 2) |
NO |
|
WEEKLY_OT_LEVEL2_HRS |
|
NUMBER(8, 2) |
NO |
|
WEEKLY_OT_LEVEL1_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
|
WEEKLY_OT_LEVEL2_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
|
S_OT_DAY_7TH_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
DAY_7TH_OT_LEVEL1_HRS |
|
NUMBER(8, 2) |
NO |
|
DAY_7TH_OT_LEVEL2_HRS |
|
NUMBER(8, 2) |
NO |
|
DAY_7TH_OT_LEVEL1_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
|
DAY_7TH_OT_LEVEL2_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
|
S_START_STOP_TIME_MODE_CD |
|
VARCHAR2(10) |
NO |
|
S_START_STOP_TIME_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_START_STOP_TIME_ROUNDING_CD |
|
VARCHAR2(1) |
NO |
|
IN_PROCESS_TS_FL |
|
VARCHAR2(1) |
NO |
|
CP_PROJECT_LOOKUP_FL |
|
VARCHAR2(1) |
NO |
|
CP_MO_LOOKUP_FL |
|
VARCHAR2(1) |
NO |
|
CP_ACCOUNT_LOOKUP_FL |
|
VARCHAR2(1) |
NO |
|
INCLUDE_OT_HRS_FL |
|
VARCHAR2(1) |
NO |
|
S_OT_WEEKLY_CALC_METHOD |
|
VARCHAR2(1) |
NO |
|
NOTES |
|
VARCHAR2(1024) |
YES |
|
ACCOUNTS_EXPORT_FL |
|
VARCHAR2(1) |
NO |
|
ALLOW_MOBILE_TMFL |
|
VARCHAR2(1) |
NO |
|
REVIEW_FL |
|
VARCHAR2(1) |
NO |
|
MAX_HOURS_NO_BREAK |
|
NUMBER(8, 2) |
YES |
|
ENTRY_MODE |
|
VARCHAR2(15) |
NO |
|
ENTRY_VAL |
|
VARCHAR2(1) |
NO |
|
TOT_TIME_PRORATE |
|
VARCHAR2(1) |
NO |
|
OT_HANDLE |
|
VARCHAR2(1) |
NO |
|
OT_DISTRIBUTION |
|
VARCHAR2(1) |
NO |
|
PAY_TYPE_RULE |
|
VARCHAR2(1) |
NO |
|
S_OT_HOLIDAY_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
HOLIDAY_OT_LEVEL1_HRS |
|
NUMBER(8, 2) |
NO |
|
HOLIDAY_OT_LEVEL2_HRS |
|
NUMBER(8, 2) |
NO |
|
S_OT_SATURDAY_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
SATURDAY_OT_LEVEL1_HRS |
|
NUMBER(8, 2) |
NO |
|
SATURDAY_OT_LEVEL2_HRS |
|
NUMBER(8, 2) |
NO |
|
S_OT_SUNDAY_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
SUNDAY_OT_LEVEL1_HRS |
|
NUMBER(8, 2) |
NO |
|
SUNDAY_OT_LEVEL2_HRS |
|
NUMBER(8, 2) |
NO |
|