Entity Definition

Logical Name : PositionWorkSchedule
Physical Name : CO_SCH_PST_WRK

A shift schedule for a position

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PositionID (FK)(PK) A unique identifier for a specific Position. This may or may not be controlled by a centralized HR function. ID_PST Identity integer Position(CO_PST)
PositionWorkScheduleWeekDay (PK) The name of the day that this schedule is for. WD_PST_WRK_SCH DateWeekdayISO8061 char(1)
StartTime The beginning time for this schedule. TM_STR Time Time
FinishTime The ending time for this schedule. TM_FNS Time Time
Hours Total hours for this schedule. HH_HR Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
Position is scheduled for PositionWorkSchedule

Logical Views containing PositionWorkSchedule

Logical View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View