ColumnName |
Domain |
Datatype |
NULL |
Definition |
WORK_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Work Schedule. Description: Work schedule code. |
S_DAY_OF_WEEK_CD |
|
VARCHAR2(3) |
NO |
Name: Day of Week. Description: The day of the week for the override date. The valid options are as follows: SUN, MON, TUE, WED, THU, FRI, SAT |
SCHEDULE_DT |
|
DATE |
NO |
Name: Schedule Date. Description: The work schedule date. If this is a day of the week record, the date will be 01/01/1900. |
EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Employee ID. Description: The Employee ID for the records that are employee specific. If the record is not for a specific employee, "ALL" will be displayed in this field. |
NON_WORKDAY_FL |
|
VARCHAR2(1) |
NO |
Name: Non-Work Day Flag. Description: Logical as to whether the selected date is a non-workday. |
HOLIDAY_FL |
|
VARCHAR2(1) |
NO |
Name: Holiday Flag. Description: Logical as to whether the selected date is a holiday. |
FLEXIBLE_FL |
|
VARCHAR2(1) |
NO |
Name: Flexible Flag. Description: Logical as to whether charging hours on the selected date is flexible. |
STANDARD_HRS |
|
NUMBER(8, 2) |
NO |
Name: Standard Hours. Description: The standard hours for the selected date. |
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. |
DFLT_IN_TM |
|
VARCHAR2(5) |
YES |
Name: Default Time In. Description: Default time in for the selected date in HH:MM format. |
DFLT_OUT_TM |
|
VARCHAR2(5) |
YES |
Name: Default Time Out. Description: Default time out for the selected date in HH:MM format. |
DFLT_NON_HRS |
|
NUMBER(8, 2) |
NO |
Name: Default Non-Work Hours. Description: Default non-working hours for the selected date. |
VACATION_FL |
|
VARCHAR2(1) |
NO |
Name: Vacation Flag. Description: Logical as to whether the selected date is considered a vacation day. |
PENDING_APPROVAL_FL |
|
VARCHAR2(1) |
NO |
Name: Pending Approval Flag. Description: Identifies the days where the employee has requested vacation but supervisor has not yet given approval. |
DFLT_LUNCH_START_TIME_DTT |
|
DATE |
NO |
Name: Default Lunch Start Date/Time. Description: The default start time for lunch. |
DFLT_LUNCH_END_TIME_DTT |
|
DATE |
NO |
Name: Default Lunch End Date/Time. Description: The default end time for lunch. |
LEAVE_HRS |
|
NUMBER(8, 2) |
NO |
Name: Leave Hours. Description: The number of leave hours scheduled or requested for the selected date. |
LEAVE_START_TIME_DTT |
|
DATE |
YES |
Name: Leave Start Date/Time. Description: The start date/time for the leave for the selected date. |
LEAVE_END_TIME_DTT |
|
DATE |
YES |
Name: Leave End Date/Time. Description: The end date/time for the leave for the selected date. |
OFF_SITE_HRS |
|
NUMBER(8, 2) |
NO |
Name: Offsite Hours. Description: The number of work hours that are off site. |
OFF_SITE_START_TIME_DTT |
|
DATE |
YES |
Name: Offsite Start Date/Time. Description: The start date/time for the offsite hours for the selected date. |
OFF_SITE_END_TIME_DTT |
|
DATE |
YES |
Name: Offsite End Date/Time. Description: The end date/time for the offsite hours for the selected date. |
SCHEDULE_TEXT |
|
VARCHAR2(254) |
YES |
Name: Notes. Description: Notes related to schedule record. |