CREATE TABLE hwm_tm_rec_grp_sum (
    TM_REC_GRP_ID            NUMBER(18, 0),
    TM_REC_GRP_VERSION       NUMBER(9, 0) ,
    ENTERPRISE_ID            NUMBER(18, 0)    NOT NULL,
    GRP_TYPE_ID              NUMBER(18, 0),
    STATUS                   VARCHAR2(120),
    START_TIME               TIMESTAMP(6) ,
    STOP_TIME                TIMESTAMP(6) ,
    RESOURCE_ID              NUMBER(18, 0),
    RECORDED_HOURS           NUMBER       ,
    HAS_REASONS              VARCHAR2(120),
    SUBMISSION_DATE          TIMESTAMP(6) ,
    ABSENCE_HOURS            NUMBER       ,
    ABSENCE_DAYS             NUMBER       ,
    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),
    ERROR_SEVERITY           VARCHAR2(120),
    PROCESS_REQUEST_ID       NUMBER(18, 0),
    OFF_CYCLE                VARCHAR2(600),
    PAYROLL_TRANSFER         VARCHAR2(120),
    PAYROLL_PROCESSING       VARCHAR2(120),
    PROJECT_TRANSFER         VARCHAR2(120),
    SUBRESOURCE_ID           VARCHAR2(72) ,
    SCHEDULED_HOURS          NUMBER       ,
    TM_REC_GRP_ID            NUMBER(18, 0),
    TM_REC_GRP_VERSION       NUMBER(9, 0) ,
    ENTERPRISE_ID            NUMBER(18, 0)    NOT NULL,
    GRP_TYPE_ID              NUMBER(18, 0),
    STATUS                   VARCHAR2(120),
    START_TIME               TIMESTAMP(6) ,
    STOP_TIME                TIMESTAMP(6) ,
    RESOURCE_ID              NUMBER(18, 0),
    RECORDED_HOURS           NUMBER       ,
    HAS_REASONS              VARCHAR2(120),
    SUBMISSION_DATE          TIMESTAMP(6) ,
    ABSENCE_HOURS            NUMBER       ,
    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),
    ERROR_SEVERITY           VARCHAR2(120),
    PROCESS_REQUEST_ID       NUMBER(18, 0),
    OFF_CYCLE                VARCHAR2(600),
    PAYROLL_TRANSFER         VARCHAR2(120),
    PAYROLL_PROCESSING       VARCHAR2(120),
    PROJECT_TRANSFER         VARCHAR2(120),
    SUBRESOURCE_ID           VARCHAR2(72) ,
    SCHEDULED_HOURS          NUMBER       ,
    ABSENCE_DAYS             NUMBER       ,
    CONSTRAINT pk_hwm_tm_rec_grp_sum PRIMARY KEY (TM_REC_GRP_ID, TM_REC_GRP_VERSION, TM_REC_GRP_ID, TM_REC_GRP_VERSION)
);
