WORK_SCHEDULE_CD |
ColumnName | WORK_SCHEDULE_CD |
Definition | Name: Work Schedule. Description: Work schedule code. |
S_DAY_OF_WEEK_CD |
ColumnName | S_DAY_OF_WEEK_CD |
Definition | 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 |
ColumnName | SCHEDULE_DT |
Definition | 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 |
ColumnName | EMPL_ID |
Definition | 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 |
ColumnName | NON_WORKDAY_FL |
Definition | Name: Non-Work Day Flag. Description: Logical as to whether the selected date is a non-workday. |
HOLIDAY_FL |
ColumnName | HOLIDAY_FL |
Definition | Name: Holiday Flag. Description: Logical as to whether the selected date is a holiday. |
FLEXIBLE_FL |
ColumnName | FLEXIBLE_FL |
Definition | Name: Flexible Flag. Description: Logical as to whether charging hours on the selected date is flexible. |
STANDARD_HRS |
ColumnName | STANDARD_HRS |
Definition | Name: Standard Hours. Description: The standard hours for the selected date. |
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. |
DFLT_IN_TM |
ColumnName | DFLT_IN_TM |
Definition | Name: Default Time In. Description: Default time in for the selected date in HH:MM format. |
DFLT_OUT_TM |
ColumnName | DFLT_OUT_TM |
Definition | Name: Default Time Out. Description: Default time out for the selected date in HH:MM format. |
DFLT_NON_HRS |
ColumnName | DFLT_NON_HRS |
Definition | Name: Default Non-Work Hours. Description: Default non-working hours for the selected date. |
VACATION_FL |
ColumnName | VACATION_FL |
Definition | Name: Vacation Flag. Description: Logical as to whether the selected date is considered a vacation day. |
PENDING_APPROVAL_FL |
ColumnName | PENDING_APPROVAL_FL |
Definition | 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 |
ColumnName | DFLT_LUNCH_START_TIME_DTT |
Definition | Name: Default Lunch Start Date/Time. Description: The default start time for lunch. |
DFLT_LUNCH_END_TIME_DTT |
ColumnName | DFLT_LUNCH_END_TIME_DTT |
Definition | Name: Default Lunch End Date/Time. Description: The default end time for lunch. |
LEAVE_HRS |
ColumnName | LEAVE_HRS |
Definition | Name: Leave Hours. Description: The number of leave hours scheduled or requested for the selected date. |
LEAVE_START_TIME_DTT |
ColumnName | LEAVE_START_TIME_DTT |
Definition | Name: Leave Start Date/Time. Description: The start date/time for the leave for the selected date. |
LEAVE_END_TIME_DTT |
ColumnName | LEAVE_END_TIME_DTT |
Definition | Name: Leave End Date/Time. Description: The end date/time for the leave for the selected date. |
OFF_SITE_HRS |
ColumnName | OFF_SITE_HRS |
Definition | Name: Offsite Hours. Description: The number of work hours that are off site. |
OFF_SITE_START_TIME_DTT |
ColumnName | OFF_SITE_START_TIME_DTT |
Definition | Name: Offsite Start Date/Time. Description: The start date/time for the offsite hours for the selected date. |
OFF_SITE_END_TIME_DTT |
ColumnName | OFF_SITE_END_TIME_DTT |
Definition | Name: Offsite End Date/Time. Description: The end date/time for the offsite hours for the selected date. |
SCHEDULE_TEXT |
ColumnName | SCHEDULE_TEXT |
Definition | Name: Notes. Description: Notes related to schedule record. |