CREATE TABLE hr_all_positions_f (
    POSITION_ID                      NUMBER(18, 0) ,
    CATEGORY_CODE                    VARCHAR2(320)     NOT NULL,
    EFFECTIVE_START_DATE             DATE          ,
    EFFECTIVE_END_DATE               DATE          ,
    BUSINESS_UNIT_ID                 NUMBER(18, 0)     NOT NULL,
    POSITION_CODE                    VARCHAR2(120)     NOT NULL,
    BUSINESS_GROUP_ID                NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID                  NUMBER(18, 0)     NOT NULL,
    UNION_ID                         NUMBER(18, 0) ,
    COLLECTIVE_AGREEMENT_ID          NUMBER(18, 0) ,
    JOB_ID                           NUMBER(18, 0)     NOT NULL,
    LOCATION_ID                      NUMBER(18, 0) ,
    ENTRY_GRADE_ID                   NUMBER(18, 0) ,
    ENTRY_STEP_ID                    NUMBER(18, 0) ,
    SUPERVISOR_ID                    NUMBER(18, 0) ,
    SUPERVISOR_ASSIGNMENT_ID         NUMBER(18, 0) ,
    GRADE_LADDER_ID                  NUMBER(18, 0) ,
    ACTION_OCCURRENCE_ID             NUMBER(18, 0)     NOT NULL,
    ACTIVE_STATUS                    VARCHAR2(120)     NOT NULL,
    HIRING_STATUS                    VARCHAR2(120)     NOT NULL,
    POSITION_TYPE                    VARCHAR2(120) ,
    PERMANENT_TEMPORARY_FLAG         VARCHAR2(120) ,
    FULL_PART_TIME                   VARCHAR2(120) ,
    FTE                              NUMBER(30, 10),
    CALCULATE_FTE                    VARCHAR2(4)   ,
    MAX_PERSONS                      NUMBER(4, 0)  ,
    STANDARD_WORKING_HOURS           NUMBER(22, 3) ,
    STANDARD_WORKING_FREQUENCY       VARCHAR2(120) ,
    WORKING_HOURS                    NUMBER(22, 3) ,
    FREQUENCY                        VARCHAR2(120) ,
    STD_ANNUAL_WORKING_DURATION      NUMBER(8, 4)  ,
    ANNUAL_WORKING_DURATION_UNITS    VARCHAR2(40)  ,
    ANNUAL_WORKING_DURATION          NUMBER(8, 4)  ,
    TIME_NORMAL_START                VARCHAR2(20)  ,
    TIME_NORMAL_FINISH               VARCHAR2(20)  ,
    PROBATION_PERIOD                 NUMBER(22, 2) ,
    PROBATION_PERIOD_UNIT_CD         VARCHAR2(120) ,
    BARGAINING_UNIT_CD               VARCHAR2(120) ,
    POSITION_SYNCHRONIZATION_FLAG    VARCHAR2(120)     NOT NULL,
    SECURITY_CLEARANCE               VARCHAR2(120) ,
    OVERLAP_ALLOWED                  VARCHAR2(120) ,
    SEASONAL_FLAG                    VARCHAR2(120) ,
    SEASONAL_START_DATE              DATE          ,
    SEASONAL_END_DATE                DATE          ,
    ATTRIBUTE_CATEGORY               VARCHAR2(120) ,
    ATTRIBUTE1                       VARCHAR2(600) ,
    ATTRIBUTE2                       VARCHAR2(600) ,
    ATTRIBUTE3                       VARCHAR2(600) ,
    ATTRIBUTE4                       VARCHAR2(600) ,
    ATTRIBUTE5                       VARCHAR2(600) ,
    ATTRIBUTE6                       VARCHAR2(600) ,
    ATTRIBUTE7                       VARCHAR2(600) ,
    ATTRIBUTE8                       VARCHAR2(600) ,
    ATTRIBUTE9                       VARCHAR2(600) ,
    ATTRIBUTE10                      VARCHAR2(600) ,
    ATTRIBUTE11                      VARCHAR2(600) ,
    ATTRIBUTE12                      VARCHAR2(600) ,
    ATTRIBUTE13                      VARCHAR2(600) ,
    ATTRIBUTE14                      VARCHAR2(600) ,
    ATTRIBUTE15                      VARCHAR2(600) ,
    ATTRIBUTE16                      VARCHAR2(600) ,
    ATTRIBUTE17                      VARCHAR2(600) ,
    ATTRIBUTE18                      VARCHAR2(600) ,
    ATTRIBUTE19                      VARCHAR2(600) ,
    ATTRIBUTE20                      VARCHAR2(600) ,
    ATTRIBUTE21                      VARCHAR2(600) ,
    ATTRIBUTE22                      VARCHAR2(600) ,
    ATTRIBUTE23                      VARCHAR2(600) ,
    ATTRIBUTE24                      VARCHAR2(600) ,
    ATTRIBUTE25                      VARCHAR2(600) ,
    ATTRIBUTE26                      VARCHAR2(600) ,
    ATTRIBUTE27                      VARCHAR2(600) ,
    ATTRIBUTE28                      VARCHAR2(600) ,
    ATTRIBUTE29                      VARCHAR2(600) ,
    ATTRIBUTE30                      VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                NUMBER        ,
    ATTRIBUTE_NUMBER2                NUMBER        ,
    ATTRIBUTE_NUMBER3                NUMBER        ,
    ATTRIBUTE_NUMBER4                NUMBER        ,
    ATTRIBUTE_NUMBER5                NUMBER        ,
    ATTRIBUTE_NUMBER6                NUMBER        ,
    ATTRIBUTE_NUMBER7                NUMBER        ,
    ATTRIBUTE_NUMBER8                NUMBER        ,
    ATTRIBUTE_NUMBER9                NUMBER        ,
    ATTRIBUTE_NUMBER10               NUMBER        ,
    ATTRIBUTE_NUMBER11               NUMBER        ,
    ATTRIBUTE_NUMBER12               NUMBER        ,
    ATTRIBUTE_NUMBER13               NUMBER        ,
    ATTRIBUTE_NUMBER14               NUMBER        ,
    ATTRIBUTE_NUMBER15               NUMBER        ,
    ATTRIBUTE_NUMBER16               NUMBER        ,
    ATTRIBUTE_NUMBER17               NUMBER        ,
    ATTRIBUTE_NUMBER18               NUMBER        ,
    ATTRIBUTE_NUMBER19               NUMBER        ,
    ATTRIBUTE_NUMBER20               NUMBER        ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    ATTRIBUTE_DATE6                  DATE          ,
    ATTRIBUTE_DATE7                  DATE          ,
    ATTRIBUTE_DATE8                  DATE          ,
    ATTRIBUTE_DATE9                  DATE          ,
    ATTRIBUTE_DATE10                 DATE          ,
    ATTRIBUTE_DATE11                 DATE          ,
    ATTRIBUTE_DATE12                 DATE          ,
    ATTRIBUTE_DATE13                 DATE          ,
    ATTRIBUTE_DATE14                 DATE          ,
    ATTRIBUTE_DATE15                 DATE          ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    CREATED_BY                       VARCHAR2(256)     NOT NULL,
    CREATION_DATE                    TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    ASSIGNMENT_CATEGORY              VARCHAR2(120) ,
    COST_CENTER                      VARCHAR2(120) ,
    DELEGATE_POSITION_ID             NUMBER(18, 0) ,
    BUDGETED_POSITION_FLAG           VARCHAR2(4)   ,
    BUDGET_AMOUNT                    NUMBER        ,
    BUDGET_AMOUNT_CURRENCY           VARCHAR2(80)  ,
    FUNDED_BY_EXISTING_POSITION      VARCHAR2(4)   ,
    REQUISITION_TEMPLATE_ID          NUMBER(18, 0) ,
    POSITION_ID                      NUMBER(18, 0) ,
    CATEGORY_CODE                    VARCHAR2(320)     NOT NULL,
    EFFECTIVE_START_DATE             DATE          ,
    EFFECTIVE_END_DATE               DATE          ,
    BUSINESS_UNIT_ID                 NUMBER(18, 0)     NOT NULL,
    POSITION_CODE                    VARCHAR2(120)     NOT NULL,
    BUSINESS_GROUP_ID                NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID                  NUMBER(18, 0)     NOT NULL,
    JOB_ID                           NUMBER(18, 0)     NOT NULL,
    LOCATION_ID                      NUMBER(18, 0) ,
    ENTRY_GRADE_ID                   NUMBER(18, 0) ,
    ENTRY_STEP_ID                    NUMBER(18, 0) ,
    SUPERVISOR_ID                    NUMBER(18, 0) ,
    SUPERVISOR_ASSIGNMENT_ID         NUMBER(18, 0) ,
    ACTION_OCCURRENCE_ID             NUMBER(18, 0)     NOT NULL,
    ACTIVE_STATUS                    VARCHAR2(120)     NOT NULL,
    HIRING_STATUS                    VARCHAR2(120)     NOT NULL,
    POSITION_TYPE                    VARCHAR2(120) ,
    PERMANENT_TEMPORARY_FLAG         VARCHAR2(120) ,
    FULL_PART_TIME                   VARCHAR2(120) ,
    FTE                              NUMBER(30, 10),
    MAX_PERSONS                      NUMBER(4, 0)  ,
    WORKING_HOURS                    NUMBER(22, 3) ,
    FREQUENCY                        VARCHAR2(120) ,
    TIME_NORMAL_START                VARCHAR2(20)  ,
    TIME_NORMAL_FINISH               VARCHAR2(20)  ,
    PROBATION_PERIOD                 NUMBER(22, 2) ,
    PROBATION_PERIOD_UNIT_CD         VARCHAR2(120) ,
    BARGAINING_UNIT_CD               VARCHAR2(120) ,
    POSITION_SYNCHRONIZATION_FLAG    VARCHAR2(120)     NOT NULL,
    SECURITY_CLEARANCE               VARCHAR2(120) ,
    OVERLAP_ALLOWED                  VARCHAR2(120) ,
    SEASONAL_FLAG                    VARCHAR2(120) ,
    SEASONAL_START_DATE              DATE          ,
    SEASONAL_END_DATE                DATE          ,
    ATTRIBUTE_CATEGORY               VARCHAR2(120) ,
    ATTRIBUTE1                       VARCHAR2(600) ,
    ATTRIBUTE2                       VARCHAR2(600) ,
    ATTRIBUTE3                       VARCHAR2(600) ,
    ATTRIBUTE4                       VARCHAR2(600) ,
    ATTRIBUTE5                       VARCHAR2(600) ,
    ATTRIBUTE6                       VARCHAR2(600) ,
    ATTRIBUTE7                       VARCHAR2(600) ,
    ATTRIBUTE8                       VARCHAR2(600) ,
    ATTRIBUTE9                       VARCHAR2(600) ,
    ATTRIBUTE10                      VARCHAR2(600) ,
    ATTRIBUTE11                      VARCHAR2(600) ,
    ATTRIBUTE12                      VARCHAR2(600) ,
    ATTRIBUTE13                      VARCHAR2(600) ,
    ATTRIBUTE14                      VARCHAR2(600) ,
    ATTRIBUTE15                      VARCHAR2(600) ,
    ATTRIBUTE16                      VARCHAR2(600) ,
    ATTRIBUTE17                      VARCHAR2(600) ,
    ATTRIBUTE18                      VARCHAR2(600) ,
    ATTRIBUTE19                      VARCHAR2(600) ,
    ATTRIBUTE20                      VARCHAR2(600) ,
    ATTRIBUTE21                      VARCHAR2(600) ,
    ATTRIBUTE22                      VARCHAR2(600) ,
    ATTRIBUTE23                      VARCHAR2(600) ,
    ATTRIBUTE24                      VARCHAR2(600) ,
    ATTRIBUTE25                      VARCHAR2(600) ,
    ATTRIBUTE26                      VARCHAR2(600) ,
    ATTRIBUTE27                      VARCHAR2(600) ,
    ATTRIBUTE28                      VARCHAR2(600) ,
    ATTRIBUTE29                      VARCHAR2(600) ,
    ATTRIBUTE30                      VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                NUMBER        ,
    ATTRIBUTE_NUMBER2                NUMBER        ,
    ATTRIBUTE_NUMBER3                NUMBER        ,
    ATTRIBUTE_NUMBER4                NUMBER        ,
    ATTRIBUTE_NUMBER5                NUMBER        ,
    ATTRIBUTE_NUMBER6                NUMBER        ,
    ATTRIBUTE_NUMBER7                NUMBER        ,
    ATTRIBUTE_NUMBER8                NUMBER        ,
    ATTRIBUTE_NUMBER9                NUMBER        ,
    ATTRIBUTE_NUMBER10               NUMBER        ,
    ATTRIBUTE_NUMBER11               NUMBER        ,
    ATTRIBUTE_NUMBER12               NUMBER        ,
    ATTRIBUTE_NUMBER13               NUMBER        ,
    ATTRIBUTE_NUMBER14               NUMBER        ,
    ATTRIBUTE_NUMBER15               NUMBER        ,
    ATTRIBUTE_NUMBER16               NUMBER        ,
    ATTRIBUTE_NUMBER17               NUMBER        ,
    ATTRIBUTE_NUMBER18               NUMBER        ,
    ATTRIBUTE_NUMBER19               NUMBER        ,
    ATTRIBUTE_NUMBER20               NUMBER        ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    ATTRIBUTE_DATE6                  DATE          ,
    ATTRIBUTE_DATE7                  DATE          ,
    ATTRIBUTE_DATE8                  DATE          ,
    ATTRIBUTE_DATE9                  DATE          ,
    ATTRIBUTE_DATE10                 DATE          ,
    ATTRIBUTE_DATE11                 DATE          ,
    ATTRIBUTE_DATE12                 DATE          ,
    ATTRIBUTE_DATE13                 DATE          ,
    ATTRIBUTE_DATE14                 DATE          ,
    ATTRIBUTE_DATE15                 DATE          ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    CREATED_BY                       VARCHAR2(256)     NOT NULL,
    CREATION_DATE                    TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    GRADE_LADDER_ID                  NUMBER(18, 0) ,
    STANDARD_WORKING_HOURS           NUMBER(22, 3) ,
    STANDARD_WORKING_FREQUENCY       VARCHAR2(120) ,
    UNION_ID                         NUMBER(18, 0) ,
    COLLECTIVE_AGREEMENT_ID          NUMBER(18, 0) ,
    ASSIGNMENT_CATEGORY              VARCHAR2(120) ,
    COST_CENTER                      VARCHAR2(120) ,
    DELEGATE_POSITION_ID             NUMBER(18, 0) ,
    BUDGETED_POSITION_FLAG           VARCHAR2(4)   ,
    BUDGET_AMOUNT                    NUMBER        ,
    BUDGET_AMOUNT_CURRENCY           VARCHAR2(80)  ,
    FUNDED_BY_EXISTING_POSITION      VARCHAR2(4)   ,
    REQUISITION_TEMPLATE_ID          NUMBER(18, 0) ,
    CALCULATE_FTE                    VARCHAR2(4)   ,
    STD_ANNUAL_WORKING_DURATION      NUMBER(8, 4)  ,
    ANNUAL_WORKING_DURATION_UNITS    VARCHAR2(40)  ,
    ANNUAL_WORKING_DURATION          NUMBER(8, 4)  ,
    CONSTRAINT pk_hr_all_positions_f PRIMARY KEY (POSITION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, POSITION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE)
);
