CREATE TABLE ben_le_resolutions_f (
    LE_RESOLUTION_ID          NUMBER(18, 0),
    EFFECTIVE_START_DATE      DATE         ,
    EFFECTIVE_END_DATE        DATE         ,
    LEGAL_ENTITY_ID           NUMBER(18, 0)    NOT NULL,
    BUSINESS_GROUP_ID         NUMBER(18, 0)    NOT NULL,
    MAPPING_TABLE_NAME        VARCHAR2(120)    NOT NULL,
    MAPPING_COLUMN_NAME       VARCHAR2(120)    NOT NULL,
    MAPPING_TABLE_PK_ID       NUMBER(18, 0)    NOT NULL,
    LRS_ATTRIBUTE_CATEGORY    VARCHAR2(120),
    LRS_ATTRIBUTE1            VARCHAR2(600),
    LRS_ATTRIBUTE2            VARCHAR2(600),
    LRS_ATTRIBUTE3            VARCHAR2(600),
    LRS_ATTRIBUTE4            VARCHAR2(600),
    LRS_ATTRIBUTE5            VARCHAR2(600),
    LRS_ATTRIBUTE6            VARCHAR2(600),
    LRS_ATTRIBUTE7            VARCHAR2(600),
    LRS_ATTRIBUTE8            VARCHAR2(600),
    LRS_ATTRIBUTE9            VARCHAR2(600),
    LRS_ATTRIBUTE10           VARCHAR2(600),
    LRS_ATTRIBUTE11           VARCHAR2(600),
    LRS_ATTRIBUTE12           VARCHAR2(600),
    LRS_ATTRIBUTE13           VARCHAR2(600),
    LRS_ATTRIBUTE14           VARCHAR2(600),
    LRS_ATTRIBUTE15           VARCHAR2(600),
    LRS_ATTRIBUTE16           VARCHAR2(600),
    LRS_ATTRIBUTE17           VARCHAR2(600),
    LRS_ATTRIBUTE18           VARCHAR2(600),
    LRS_ATTRIBUTE19           VARCHAR2(600),
    LRS_ATTRIBUTE20           VARCHAR2(600),
    LRS_ATTRIBUTE21           VARCHAR2(600),
    LRS_ATTRIBUTE22           VARCHAR2(600),
    LRS_ATTRIBUTE23           VARCHAR2(600),
    LRS_ATTRIBUTE24           VARCHAR2(600),
    LRS_ATTRIBUTE25           VARCHAR2(600),
    LRS_ATTRIBUTE26           VARCHAR2(600),
    LRS_ATTRIBUTE27           VARCHAR2(600),
    LRS_ATTRIBUTE28           VARCHAR2(600),
    LRS_ATTRIBUTE29           VARCHAR2(600),
    LRS_ATTRIBUTE30           VARCHAR2(600),
    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,
    LE_RESOLUTION_ID          NUMBER(18, 0),
    EFFECTIVE_START_DATE      DATE         ,
    EFFECTIVE_END_DATE        DATE         ,
    LEGAL_ENTITY_ID           NUMBER(18, 0)    NOT NULL,
    BUSINESS_GROUP_ID         NUMBER(18, 0)    NOT NULL,
    MAPPING_TABLE_NAME        VARCHAR2(120)    NOT NULL,
    MAPPING_COLUMN_NAME       VARCHAR2(120)    NOT NULL,
    MAPPING_TABLE_PK_ID       NUMBER(18, 0)    NOT NULL,
    LRS_ATTRIBUTE_CATEGORY    VARCHAR2(120),
    LRS_ATTRIBUTE1            VARCHAR2(600),
    LRS_ATTRIBUTE2            VARCHAR2(600),
    LRS_ATTRIBUTE3            VARCHAR2(600),
    LRS_ATTRIBUTE4            VARCHAR2(600),
    LRS_ATTRIBUTE5            VARCHAR2(600),
    LRS_ATTRIBUTE6            VARCHAR2(600),
    LRS_ATTRIBUTE7            VARCHAR2(600),
    LRS_ATTRIBUTE8            VARCHAR2(600),
    LRS_ATTRIBUTE9            VARCHAR2(600),
    LRS_ATTRIBUTE10           VARCHAR2(600),
    LRS_ATTRIBUTE11           VARCHAR2(600),
    LRS_ATTRIBUTE12           VARCHAR2(600),
    LRS_ATTRIBUTE13           VARCHAR2(600),
    LRS_ATTRIBUTE14           VARCHAR2(600),
    LRS_ATTRIBUTE15           VARCHAR2(600),
    LRS_ATTRIBUTE16           VARCHAR2(600),
    LRS_ATTRIBUTE17           VARCHAR2(600),
    LRS_ATTRIBUTE18           VARCHAR2(600),
    LRS_ATTRIBUTE19           VARCHAR2(600),
    LRS_ATTRIBUTE20           VARCHAR2(600),
    LRS_ATTRIBUTE21           VARCHAR2(600),
    LRS_ATTRIBUTE22           VARCHAR2(600),
    LRS_ATTRIBUTE23           VARCHAR2(600),
    LRS_ATTRIBUTE24           VARCHAR2(600),
    LRS_ATTRIBUTE25           VARCHAR2(600),
    LRS_ATTRIBUTE26           VARCHAR2(600),
    LRS_ATTRIBUTE27           VARCHAR2(600),
    LRS_ATTRIBUTE28           VARCHAR2(600),
    LRS_ATTRIBUTE29           VARCHAR2(600),
    LRS_ATTRIBUTE30           VARCHAR2(600),
    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,
    CONSTRAINT pk_ben_le_resolutions_f PRIMARY KEY (LE_RESOLUTION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, LE_RESOLUTION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE)
);
