CREATE TABLE hts_custom_shift_types_b (
    SHIFT_TYPE_ID            NUMBER        ,
    START_TIME_MS_NUM        NUMBER(18, 0) ,
    END_TIME_MS_NUM          NUMBER(18, 0) ,
    DURATION_MS_NUM          NUMBER(18, 0) ,
    DURATION_UOM_CODE        VARCHAR2(120) ,
    SHIFT_TYPE_CODE          VARCHAR2(120)     NOT NULL,
    SHORT_TXT                VARCHAR2(12)  ,
    CATEGORY_CODE            VARCHAR2(120) ,
    GLOBAL_FLAG              VARCHAR2(4)   ,
    AVAILABILITY_CODE        VARCHAR2(120) ,
    SHIFT_DTL_TYPE_CODE      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_CATEGORY       VARCHAR2(120) ,
    ENTERPRISE_ID            NUMBER(18, 0)     NOT NULL,
    DELETED_FLAG             VARCHAR2(4)   ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    SHIFT_SHORT_NAME         VARCHAR2(20)  ,
    SHIFT_COLOUR             VARCHAR2(80)  ,
    START_EARLY_GRACE        NUMBER(18, 0) ,
    START_LATE_GRACE         NUMBER(18, 0) ,
    END_EARLY_GRACE          NUMBER(18, 0) ,
    END_LATE_GRACE           NUMBER(18, 0) ,
    TOLERANCE                NUMBER(9, 0)  ,
    START_EARLY_VIOLATION    VARCHAR2(40)  ,
    START_LATE_VIOLATION     VARCHAR2(40)  ,
    END_EARLY_VIOLATION      VARCHAR2(40)  ,
    END_LATE_VIOLATION       VARCHAR2(40)  ,
    TIME_NOT_WORKED          NUMBER(18, 0) ,
    DAY_INDICATOR            VARCHAR2(128) ,
    SHIFT_CODE               VARCHAR2(256) ,
    MODULE_ID                VARCHAR2(128) ,
    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) ,
    SGUID                    VARCHAR2(128) ,
    SEED_DATA_SOURCE         VARCHAR2(2048),
    ORA_SEED_SET1            VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2            VARCHAR2(4)       NOT NULL,
    SHIFT_TYPE_ID            NUMBER        ,
    START_TIME_MS_NUM        NUMBER(18, 0) ,
    END_TIME_MS_NUM          NUMBER(18, 0) ,
    DURATION_MS_NUM          NUMBER(18, 0) ,
    DURATION_UOM_CODE        VARCHAR2(120) ,
    SHIFT_TYPE_CODE          VARCHAR2(120)     NOT NULL,
    SHORT_TXT                VARCHAR2(12)  ,
    CATEGORY_CODE            VARCHAR2(120) ,
    GLOBAL_FLAG              VARCHAR2(4)   ,
    AVAILABILITY_CODE        VARCHAR2(120) ,
    SHIFT_DTL_TYPE_CODE      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_CATEGORY       VARCHAR2(120) ,
    ENTERPRISE_ID            NUMBER(18, 0)     NOT NULL,
    DELETED_FLAG             VARCHAR2(4)   ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    SHIFT_SHORT_NAME         VARCHAR2(20)  ,
    SHIFT_COLOUR             VARCHAR2(80)  ,
    START_EARLY_GRACE        NUMBER(18, 0) ,
    START_LATE_GRACE         NUMBER(18, 0) ,
    END_EARLY_GRACE          NUMBER(18, 0) ,
    END_LATE_GRACE           NUMBER(18, 0) ,
    TOLERANCE                NUMBER(9, 0)  ,
    START_EARLY_VIOLATION    VARCHAR2(40)  ,
    START_LATE_VIOLATION     VARCHAR2(40)  ,
    END_EARLY_VIOLATION      VARCHAR2(40)  ,
    END_LATE_VIOLATION       VARCHAR2(40)  ,
    TIME_NOT_WORKED          NUMBER(18, 0) ,
    DAY_INDICATOR            VARCHAR2(128) ,
    SHIFT_CODE               VARCHAR2(256) ,
    MODULE_ID                VARCHAR2(128) ,
    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) ,
    SGUID                    VARCHAR2(128) ,
    SEED_DATA_SOURCE         VARCHAR2(2048),
    ORA_SEED_SET1            VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2            VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_hts_custom_shift_types_b PRIMARY KEY (SHIFT_TYPE_ID, SHIFT_TYPE_ID)
);
