CREATE TABLE ben_entitlement (
    ENTITLEMENT_ID                  NUMBER(18, 0),
    LEGISLATIVE_DATA_GROUP_ID       NUMBER(18, 0)    NOT NULL,
    ENTITLEMENT_NAME                VARCHAR2(120)    NOT NULL,
    DEFAULT_ENTITLEMENT             VARCHAR2(4)  ,
    PL_ID                           NUMBER(18, 0)    NOT NULL,
    BAND_ENTITLEMENT_ID             NUMBER(18, 0)    NOT NULL,
    SCHEME_TYP_CODE                 VARCHAR2(120)    NOT NULL,
    SCHEME_START_DATE               DATE             NOT NULL,
    SCHEME_END_DATE                 DATE         ,
    SCHEME_DEFINITION_TYP_CODE      VARCHAR2(120),
    SCHEME_PERIOD_TYP_CODE          VARCHAR2(120),
    EMPLOYMENT_EVENT_TYPE           VARCHAR2(120),
    PERIOD_QUALIFYING_DATE_TYPE     VARCHAR2(120),
    SCHEME_PERIOD_UOM               VARCHAR2(120),
    SCHEME_PERIOD_DURATION          NUMBER(18, 0),
    OVERLAP_RULE                    VARCHAR2(120),
    SECONDARY_PERIOD_DURATION       NUMBER(18, 0),
    SECONDARY_PERIOD_UOM            VARCHAR2(120),
    FIXED_YEAR_START_DATE           DATE         ,
    ENABLE_ENTITLEMENT_PRORATION    VARCHAR2(4)  ,
    FT_ROUNDING_CODE                VARCHAR2(40) ,
    PT_ROUNDING_CODE                VARCHAR2(40) ,
    DAILY_RATE_CALC_UOM             VARCHAR2(40)     NOT NULL,
    DAILY_RATE_CALC_PERIOD          VARCHAR2(40)     NOT NULL,
    SCHEDULE_ID                     NUMBER(18, 0)    NOT NULL,
    EARNING_PERIOD_PRORATION        VARCHAR2(4)  ,
    WORK_PATTERN_ID                 NUMBER(18, 0),
    ABS_SCHED_WORK_PATTERN_ID       NUMBER(18, 0),
    CALENDAR_ID                     NUMBER(18, 0),
    PAY_COMPONENT_RATE_TYPE         VARCHAR2(120),
    AVG_EARNINGS_DURATION           NUMBER       ,
    AVG_EARNINGS_UOM                VARCHAR2(40) ,
    AVG_EARNINGS_BALANCE            VARCHAR2(120),
    PROCESS_TYP_CODE                VARCHAR2(120),
    BUSINESS_GROUP_ID               NUMBER(18, 0)    NOT NULL,
    ENT_ATTRIBUTE_CATEGORY          VARCHAR2(120),
    ENT_ATTRIBUTE1                  VARCHAR2(600),
    ENT_ATTRIBUTE2                  VARCHAR2(600),
    ENT_ATTRIBUTE3                  VARCHAR2(600),
    ENT_ATTRIBUTE4                  VARCHAR2(600),
    ENT_ATTRIBUTE5                  VARCHAR2(600),
    ENT_ATTRIBUTE6                  VARCHAR2(600),
    ENT_ATTRIBUTE7                  VARCHAR2(600),
    ENT_ATTRIBUTE8                  VARCHAR2(600),
    ENT_ATTRIBUTE9                  VARCHAR2(600),
    ENT_ATTRIBUTE10                 VARCHAR2(600),
    ENT_ATTRIBUTE11                 VARCHAR2(600),
    ENT_ATTRIBUTE12                 VARCHAR2(600),
    ENT_ATTRIBUTE13                 VARCHAR2(600),
    ENT_ATTRIBUTE14                 VARCHAR2(600),
    ENT_ATTRIBUTE15                 VARCHAR2(600),
    ENT_ATTRIBUTE16                 VARCHAR2(600),
    ENT_ATTRIBUTE17                 VARCHAR2(600),
    ENT_ATTRIBUTE18                 VARCHAR2(600),
    ENT_ATTRIBUTE19                 VARCHAR2(600),
    ENT_ATTRIBUTE20                 VARCHAR2(600),
    ENT_ATTRIBUTE21                 VARCHAR2(600),
    ENT_ATTRIBUTE22                 VARCHAR2(600),
    ENT_ATTRIBUTE23                 VARCHAR2(600),
    ENT_ATTRIBUTE24                 VARCHAR2(600),
    ENT_ATTRIBUTE25                 VARCHAR2(600),
    ENT_ATTRIBUTE26                 VARCHAR2(600),
    ENT_ATTRIBUTE27                 VARCHAR2(600),
    ENT_ATTRIBUTE28                 VARCHAR2(600),
    ENT_ATTRIBUTE29                 VARCHAR2(600),
    ENT_ATTRIBUTE30                 VARCHAR2(600),
    ENT_ATTRIBUTE_NUMBER1           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER2           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER3           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER4           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER5           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER6           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER7           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER8           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER9           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER10          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER11          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER12          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER13          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER14          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER15          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER16          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER17          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER18          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER19          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER20          NUMBER       ,
    ENT_ATTRIBUTE_DATE1             DATE         ,
    ENT_ATTRIBUTE_DATE2             DATE         ,
    ENT_ATTRIBUTE_DATE3             DATE         ,
    ENT_ATTRIBUTE_DATE4             DATE         ,
    ENT_ATTRIBUTE_DATE5             DATE         ,
    ENT_ATTRIBUTE_DATE6             DATE         ,
    ENT_ATTRIBUTE_DATE7             DATE         ,
    ENT_ATTRIBUTE_DATE8             DATE         ,
    ENT_ATTRIBUTE_DATE9             DATE         ,
    ENT_ATTRIBUTE_DATE10            DATE         ,
    ENT_ATTRIBUTE_DATE11            DATE         ,
    ENT_ATTRIBUTE_DATE12            DATE         ,
    ENT_ATTRIBUTE_DATE13            DATE         ,
    ENT_ATTRIBUTE_DATE14            DATE         ,
    ENT_ATTRIBUTE_DATE15            DATE         ,
    LAST_UPDATE_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128),
    CREATED_BY                      VARCHAR2(256)    NOT NULL,
    CREATION_DATE                   TIMESTAMP(6)     NOT NULL,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)     NOT NULL,
    INTENDS_TO_RETURN               VARCHAR2(4)  ,
    ITR_BAND_ENTITLEMENT_ID         NUMBER(18, 0),
    ENTITLEMENT_ID                  NUMBER(18, 0),
    LEGISLATIVE_DATA_GROUP_ID       NUMBER(18, 0)    NOT NULL,
    ENTITLEMENT_NAME                VARCHAR2(120)    NOT NULL,
    DEFAULT_ENTITLEMENT             VARCHAR2(4)  ,
    PL_ID                           NUMBER(18, 0)    NOT NULL,
    BAND_ENTITLEMENT_ID             NUMBER(18, 0)    NOT NULL,
    SCHEME_TYP_CODE                 VARCHAR2(120)    NOT NULL,
    SCHEME_START_DATE               DATE             NOT NULL,
    SCHEME_END_DATE                 DATE         ,
    SCHEME_DEFINITION_TYP_CODE      VARCHAR2(120),
    SCHEME_PERIOD_TYP_CODE          VARCHAR2(120),
    EMPLOYMENT_EVENT_TYPE           VARCHAR2(120),
    PERIOD_QUALIFYING_DATE_TYPE     VARCHAR2(120),
    SCHEME_PERIOD_UOM               VARCHAR2(120),
    SCHEME_PERIOD_DURATION          NUMBER(18, 0),
    OVERLAP_RULE                    VARCHAR2(120),
    SECONDARY_PERIOD_DURATION       NUMBER(18, 0),
    SECONDARY_PERIOD_UOM            VARCHAR2(120),
    FIXED_YEAR_START_DATE           DATE         ,
    ENABLE_ENTITLEMENT_PRORATION    VARCHAR2(4)  ,
    FT_ROUNDING_CODE                VARCHAR2(40) ,
    PT_ROUNDING_CODE                VARCHAR2(40) ,
    DAILY_RATE_CALC_UOM             VARCHAR2(40)     NOT NULL,
    DAILY_RATE_CALC_PERIOD          VARCHAR2(40)     NOT NULL,
    SCHEDULE_ID                     NUMBER(18, 0)    NOT NULL,
    EARNING_PERIOD_PRORATION        VARCHAR2(4)  ,
    WORK_PATTERN_ID                 NUMBER(18, 0),
    ABS_SCHED_WORK_PATTERN_ID       NUMBER(18, 0),
    CALENDAR_ID                     NUMBER(18, 0),
    PAY_COMPONENT_RATE_TYPE         VARCHAR2(120),
    AVG_EARNINGS_DURATION           NUMBER       ,
    AVG_EARNINGS_UOM                VARCHAR2(40) ,
    AVG_EARNINGS_BALANCE            VARCHAR2(120),
    PROCESS_TYP_CODE                VARCHAR2(120),
    BUSINESS_GROUP_ID               NUMBER(18, 0)    NOT NULL,
    ENT_ATTRIBUTE_CATEGORY          VARCHAR2(120),
    ENT_ATTRIBUTE1                  VARCHAR2(600),
    ENT_ATTRIBUTE2                  VARCHAR2(600),
    ENT_ATTRIBUTE3                  VARCHAR2(600),
    ENT_ATTRIBUTE4                  VARCHAR2(600),
    ENT_ATTRIBUTE5                  VARCHAR2(600),
    ENT_ATTRIBUTE6                  VARCHAR2(600),
    ENT_ATTRIBUTE7                  VARCHAR2(600),
    ENT_ATTRIBUTE8                  VARCHAR2(600),
    ENT_ATTRIBUTE9                  VARCHAR2(600),
    ENT_ATTRIBUTE10                 VARCHAR2(600),
    ENT_ATTRIBUTE11                 VARCHAR2(600),
    ENT_ATTRIBUTE12                 VARCHAR2(600),
    ENT_ATTRIBUTE13                 VARCHAR2(600),
    ENT_ATTRIBUTE14                 VARCHAR2(600),
    ENT_ATTRIBUTE15                 VARCHAR2(600),
    ENT_ATTRIBUTE16                 VARCHAR2(600),
    ENT_ATTRIBUTE17                 VARCHAR2(600),
    ENT_ATTRIBUTE18                 VARCHAR2(600),
    ENT_ATTRIBUTE19                 VARCHAR2(600),
    ENT_ATTRIBUTE20                 VARCHAR2(600),
    ENT_ATTRIBUTE21                 VARCHAR2(600),
    ENT_ATTRIBUTE22                 VARCHAR2(600),
    ENT_ATTRIBUTE23                 VARCHAR2(600),
    ENT_ATTRIBUTE24                 VARCHAR2(600),
    ENT_ATTRIBUTE25                 VARCHAR2(600),
    ENT_ATTRIBUTE26                 VARCHAR2(600),
    ENT_ATTRIBUTE27                 VARCHAR2(600),
    ENT_ATTRIBUTE28                 VARCHAR2(600),
    ENT_ATTRIBUTE29                 VARCHAR2(600),
    ENT_ATTRIBUTE30                 VARCHAR2(600),
    ENT_ATTRIBUTE_NUMBER1           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER2           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER3           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER4           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER5           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER6           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER7           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER8           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER9           NUMBER       ,
    ENT_ATTRIBUTE_NUMBER10          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER11          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER12          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER13          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER14          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER15          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER16          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER17          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER18          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER19          NUMBER       ,
    ENT_ATTRIBUTE_NUMBER20          NUMBER       ,
    ENT_ATTRIBUTE_DATE1             DATE         ,
    ENT_ATTRIBUTE_DATE2             DATE         ,
    ENT_ATTRIBUTE_DATE3             DATE         ,
    ENT_ATTRIBUTE_DATE4             DATE         ,
    ENT_ATTRIBUTE_DATE5             DATE         ,
    ENT_ATTRIBUTE_DATE6             DATE         ,
    ENT_ATTRIBUTE_DATE7             DATE         ,
    ENT_ATTRIBUTE_DATE8             DATE         ,
    ENT_ATTRIBUTE_DATE9             DATE         ,
    ENT_ATTRIBUTE_DATE10            DATE         ,
    ENT_ATTRIBUTE_DATE11            DATE         ,
    ENT_ATTRIBUTE_DATE12            DATE         ,
    ENT_ATTRIBUTE_DATE13            DATE         ,
    ENT_ATTRIBUTE_DATE14            DATE         ,
    ENT_ATTRIBUTE_DATE15            DATE         ,
    LAST_UPDATE_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128),
    CREATED_BY                      VARCHAR2(256)    NOT NULL,
    CREATION_DATE                   TIMESTAMP(6)     NOT NULL,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)     NOT NULL,
    INTENDS_TO_RETURN               VARCHAR2(4)  ,
    ITR_BAND_ENTITLEMENT_ID         NUMBER(18, 0),
    CONSTRAINT pk_ben_entitlement PRIMARY KEY (ENTITLEMENT_ID, ENTITLEMENT_ID)
);
