WORK_SCHEDULE_DATE 
Default Table Name  WORK_SCHEDULE_DATE 
Definition 
 Name: Work Schedule Dates.     Description: This table contains the detailed schedule for each work schedule code.
 

WORK_SCHEDULE_DATE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
WORK_SCHEDULE_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Work Schedule. Description: Work schedule code.
 
S_DAY_OF_WEEK_CD(PK)    VARCHAR(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(PK)    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(PK)    VARCHAR(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    VARCHAR(1)  NO 
Name: Non-Work Day Flag. Description: Logical as to whether the selected date is a non-workday.
 
HOLIDAY_FL    VARCHAR(1)  NO 
Name: Holiday Flag. Description: Logical as to whether the selected date is a holiday.
 
FLEXIBLE_FL    VARCHAR(1)  NO 
Name: Flexible Flag. Description: Logical as to whether charging hours on the selected date is flexible.
 
STANDARD_HRS    NUMERIC(8, 2)  NO 
Name: Standard Hours. Description: The standard hours for the selected date.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(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    VARCHAR(5)  YES 
Name: Default Time In. Description: Default time in for the selected date in HH:MM format.
 
DFLT_OUT_TM    VARCHAR(5)  YES 
Name: Default Time Out. Description: Default time out for the selected date in HH:MM format.
 
DFLT_NON_HRS    NUMERIC(8, 2)  NO 
Name: Default Non-Work Hours. Description: Default non-working hours for the selected date.
 
VACATION_FL    VARCHAR(1)  NO 
Name: Vacation Flag. Description: Logical as to whether the selected date is considered a vacation day.
 
PENDING_APPROVAL_FL    VARCHAR(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    NUMERIC(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    NUMERIC(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    VARCHAR(254)  YES 
Name: Notes. Description: Notes related to schedule record.
 

WORK_SCHEDULE_DATE Keys 
Key Name  Key Type  Keys 
SI_0044  Inversion Entry  WORK_SCHEDULE_CD, SCHEDULE_DT, EMPL_ID 
RI_F00011  Inversion Entry  WORK_SCHEDULE_CD 
PI_0023  PrimaryKey  WORK_SCHEDULE_CD, S_DAY_OF_WEEK_CD, SCHEDULE_DT, EMPL_ID 

WORK_SCHEDULE_DATE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
WORK_SCHEDULE  Identifying  One To Zero or More        WORK_SCHEDULE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype