DW_WS_SCHEDULE_SHIFTS_EF

Shedule shift enriched fact

Details

Module: Global Human Resources

Key Columns

SCHEDULE_SHIFT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SCHEDULE_SHIFT_ID NUMBER 38 0 True Unique Identifier for the Schedule Shift assignmnet    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. unique key    
SCHEDULE_ID NUMBER 38 0   Schedule identifier DW_WS_SCHEDULE_D SCHEDULE_ID
SCHEDULE_GEN_PROFILE_ID NUMBER 38 0   Identifier for a schedule profile Managers DW_WS_SCHEDULE_PROFILE_MANAGER_D SCHED_PROFILE_MGR_ID
SCHEDULE_START_DATE DATE       Start date of the schedule period    
SCHEDULE_END_DATE DATE       End date of the schedule period    
SCHEDULE_UNIT_ID NUMBER 38 0   Schedule unit identifier DW_WS_SCHEDULE_UNIT_D SCHEDULE_UNIT_ID
SCHEDULE_DEPARTMENT_ID NUMBER 38 0   Schedule Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID
SCHEDULE_LOCATION_ID NUMBER 38 0   Schedule Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
SHIFT_ID NUMBER 38 0   Shift identifier DW_WS_SHIFT_D SHIFT_ID
SHIFT_TYPE_ID NUMBER 38 0   Shift type identifier DW_WS_SHIFT_TYPE_D EXTENDED_LOOKUP_CODE_ID
START_DATE_TIME TIMESTAMP       Start date time of the shift    
END_DATE_TIME TIMESTAMP       End date time of the shift.    
START_TIME_TZ_OFFSET NUMBER       Timezone offset of shift's start time. Unit of time is minute    
END_TIME_TZ_OFFSET NUMBER       Timezone offset of shift's end time. Unit of time is minute    
SOURCE VARCHAR2 32     Origin of the shift indicating if it was imported or edited in the UI or computed.    
REF_DATE DATE       Actual date of the shift.    
PERSON_ID NUMBER 38 0   Person Identifier DW_PERSON_D PERSON_ID
ASSIGNMENT_ID NUMBER 38 0   Assignmnet Identifier    
WORK_PATTERN_ID NUMBER 38 0   Work pattern identifier DW_WS_WORK_PATTERN_D WORK_PATTERN_ID
SKILL_ID NUMBER 38 0   Skill Identifier DW_WS_SKILL_D SKILL_ID
SCHEDULE_SHIFT_JOB_ID NUMBER 38 0   schedule shift Job identifier DW_JOB_D JOB_ID
SCHEDULE_SHIFT_POSITION_ID NUMBER 38 0   schedule shift Position identifier DW_POSITION_D POSITION_ID
SCHEDULE_SHIFT_JOB_FAMILY_ID NUMBER 38 0   schedule shift Job Family identifier DW_JOB_FAMILY_D JOB_FAMILY_ID
SCHEDULE_SHIFT_COMPETENCY_ID NUMBER 38 0   schedule shift content item identifier DW_CONTENT_ITEM_D CONTENT_ITEM_ID
COMPETENCY_ENTERPRISE_ID NUMBER 38 0   Stores Enterprise identifier for competency    
WORK_DURATION NUMBER       Duration of the Work in minutes    
BREAK_DURATION NUMBER       Break time in minutes    
SHIFT_LIB_BREAK_DURATION NUMBER       Shift setup break duration in minutes    
PAID_BREAK_DURATION NUMBER       Paid break duration in minutes    
MANUAL_PAID_BREAK_DURATION NUMBER       Paid break duration in minutes from manual input    
ALLOW_CLAIM_PARTIAL_SHIFT_FLAG VARCHAR2 16     Flag indicating whether the shift can be partially claimed    
OPPORTUNITY_ROTATION_FLAG VARCHAR2 16     Flag indicating if the oportunity shift is available for rotation    
ASSIGNMENT_MODE VARCHAR2 32     Indicate how the resource was assigned to the shift    
APPROVAL_REQ_TO_CLAIM_FLAG VARCHAR2 16     Indicates if an approval is needed when the shift is claimed    
ASSIGNED_BY NUMBER 38 0   Person ID of the user who assigned the scheduled shift to a worker DW_PERSON_D PERSON_ID
ASSIGNMENT_DATE TIMESTAMP       Indicates the date and time the shift was assigned to a person    
PREMIUM_SHIFT_CODE VARCHAR2 32     code added to the shift that qualifies the type of scheduled hours as premium    
AVAIL_TO_OTHER_DEPT_FLAG VARCHAR2 16     For a opportunity shift indicates if it is available to assignments from the departments not in the current schedule.    
SHIFT_INCENTIVE NUMBER       Incentive provided if shift is assigned    
ALLOW_OVERTIME_FLAG VARCHAR2 16     Flag denoting whether worker can exceed FTE with this shift    
ENTERPRISE_ID NUMBER 38 0   Enterprise identifier    
COMMENTS VARCHAR2 999     Comments    
ANCHOR_DATE DATE       Start date of the shift    
DEPARTMENT_ID NUMBER 38 0   Workers Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID
REPORTING_ESTABLISHMENT_ID NUMBER 38 0   Workers Reporting Establishment Identifier DW_REPORTING_EST_D REPORTING_EST_ID
JOB_ID NUMBER 38 0   Workers Job Identifier DW_JOB_D JOB_ID
LOCATION_ID NUMBER 38 0   Workers Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
POSITION_ID NUMBER 38 0   Workers Position Identifier DW_POSITION_D POSITION_ID
GRADE_ID NUMBER 38 0   Workers Grade Identifier DW_PAY_GRADE_D GRADE_ID
LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Employer Identifier DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID NUMBER 38 0   Workers Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PERIOD_OF_SERVICE_ID NUMBER 38 0   Workers Period of Service Identifier DW_SERVICE_PERIOD_D PERIOD_OF_SERVICE_ID
PERSON_TYPE_ID NUMBER 38 0   Workers Person Type Identifier DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0   Workers Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
ASSIGNMENT_NUMBER VARCHAR2 32     Workers Assignment Number    
ASSIGNMENT_NAME VARCHAR2 128     Workers Assignment Name    
WORKER_TYPE VARCHAR2 32     Indicates type of records for worker like assignment or employment terms DW_WORKER_TYPE_D_TL WORKER_TYPE
WORKER_CATEGORY VARCHAR2 32     Workers category like Blue collar or Civil Servant etc DW_WORKER_CATEGORY_D_TL WORKER_CATEGORY
ASSIGNMENT_CATEGORY VARCHAR2 32     Workers assignment defined category. For example Full-Time Permanent or Part-Time Permanent DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
LEGISLATION_CODE VARCHAR2 256     Workers Legislation    
SEX VARCHAR2 32     Worker Sex    
ETHNICITY VARCHAR2 32     Worker Ethnicity    
PRIMARY_FLAG VARCHAR2 32     Represents workers overall Primary assignment    
PRIMARY_ASSIGNMENT_FLAG VARCHAR2 32     Workers Primary assignment Flag    
SYSTEM_PERSON_TYPE VARCHAR2 32     Workers Person Type in System    
PAY_SYSTEM_STATUS VARCHAR2 32     Workers Payroll status indicating whether the assignment is processed in payroll runs.    
PER_SYSTEM_STATUS VARCHAR2 32     Workers HR status used to determine how the assignment is processed    
FULL_PART_TIME_FLAG VARCHAR2 32     Workers Full Part Time Flag    
PERMANENT_TEMPORARY_FLAG VARCHAR2 32     Workers Permanent Temporary Flag    
MANAGER_ASSIGNMENT_ID NUMBER 38 0   Workers Line Manager Assignment Identifier DW_PERSON_D PERSON_ID
MANAGER_ID NUMBER 38 0   Workers Line Manager Person Identifier DW_PERSON_D PERSON_ID
PERFORMANCE_RATING_LEVEL_ID NUMBER 38 0   Performance rating level identifier DW_RATING_LEVEL_D RATING_LEVEL_ID
POTENTIAL_RATING_LEVEL_ID NUMBER 38 0   Potential rating level identifier DW_RATING_LEVEL_D RATING_LEVEL_ID
BARGAINING_UNIT_CODE VARCHAR2 32     Bargaining Unit Code    
PROBATION_PERIOD NUMBER       Duration of probation period    
PROBATION_UNIT VARCHAR2 32     Units of probation period duration    
FREQUENCY VARCHAR2 32     Frequency of normal working hours:week,month,year    
NORMAL_HOURS NUMBER       Normal working hours    
HEADCOUNT NUMBER       Workers Headcount Value    
FTE NUMBER       Workers FTE Value    
AGE_IN_YEARS NUMBER 38 0   Workers Age as of doc end Date in Years    
AGE_IN_MONTHS NUMBER 38 0   Workers Age as of doc end Date in months    
TENURE_IN_YEARS NUMBER 38 0   Workers Tenure as of doc end Date in years    
TENURE_IN_MONTHS NUMBER 38 0   Workers Tenure as of doc end Date in Months    
CAL_MONTH_ID NUMBER 38 0   Month identifier in YYYYQMM format. For example, 1979412.    
CAL_QUARTER_ID NUMBER 38 0   Quarter identifier in YYYYQ format. For example, 19794.    
CAL_YEAR_ID NUMBER 38 0   Year identifier in YYYY format. For example, 1979.    
AGE_IN_YEARS_ID NUMBER 38 0   Age in Years of the Worker associated with the Assignment. Null stamped with default    
TENURE_IN_YEARS_ID NUMBER 38 0   Tenure in Years of the Worker associated with the Assignment. Null stamped with default    
PRIMARY_WORK_RELATIONSHIP_FLAG VARCHAR2 32     Primary Work Relationship Flag    
WORK_AT_HOME VARCHAR2 32     Work At Home Flag    
JOB_FAMILY_ID NUMBER 38 0   Job Family Identifier#2 DW_JOB_FAMILY_D JOB_FAMILY_ID
HOURLY_SALARIED_CODE VARCHAR2 32     Paid hourly or salaried code    

Copyright © 2019, 2026, Oracle and/or its affiliates.