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.