CREATE TABLE ben_asgn_ptnl_ler_ (
    ASGN_PTNL_LER_ID         NUMBER(18, 0) ,
    PERSON_ID                NUMBER(18, 0) ,
    LER_ID                   NUMBER(18, 0) ,
    OCCURRED_DATE            DATE          ,
    BENEFIT_RELATION_ID      NUMBER(18, 0) ,
    SUBMITTED_DATE           DATE          ,
    STATUS_CD                VARCHAR2(120) ,
    RESUBMITTED_DATE         DATE          ,
    APPROVED_DATE            DATE          ,
    REJECTED_DATE            DATE          ,
    INFO_REQD_DATE           DATE          ,
    USER_COMMENTS            VARCHAR2(4000),
    ADMIN_COMMENTS           VARCHAR2(4000),
    ACTIONED_BY              VARCHAR2(4000),
    DOCUMENT_TYPE_ID         NUMBER(18, 0) ,
    SYSTEM_DOCUMENT_TYPE     VARCHAR2(480) ,
    DOR_ID                   NUMBER(18, 0) ,
    PTNL_LER_FOR_PER_ID      NUMBER(18, 0) ,
    SOURCE                   VARCHAR2(120) ,
    BUSINESS_GROUP_ID        NUMBER(18, 0) ,
    CREATED_BY               VARCHAR2(256) ,
    CREATION_DATE            TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)  ,
    LAST_UPDATE_DATE         TIMESTAMP(6)  ,
    LAST_UPDATED_BY          VARCHAR2(256) ,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    CONFIG_CHAR_1            VARCHAR2(960) ,
    CONFIG_CHAR_2            VARCHAR2(960) ,
    CONFIG_CHAR_3            VARCHAR2(960) ,
    CONFIG_CHAR_4            VARCHAR2(960) ,
    CONFIG_CHAR_5            VARCHAR2(960) ,
    CONFIG_CHAR_6            VARCHAR2(960) ,
    CONFIG_CHAR_7            VARCHAR2(960) ,
    CONFIG_CHAR_8            VARCHAR2(960) ,
    CONFIG_CHAR_9            VARCHAR2(960) ,
    CONFIG_CHAR_10           VARCHAR2(960) ,
    CONFIG_DATE_1            DATE          ,
    CONFIG_DATE_2            DATE          ,
    CONFIG_DATE_3            DATE          ,
    CONFIG_DATE_4            DATE          ,
    CONFIG_DATE_5            DATE          ,
    CONFIG_ID_1              NUMBER(18, 0) ,
    CONFIG_ID_2              NUMBER(18, 0) ,
    CONFIG_ID_3              NUMBER(18, 0) ,
    CONFIG_ID_4              NUMBER(18, 0) ,
    CONFIG_ID_5              NUMBER(18, 0) ,
    CONFIG_NUM_1             NUMBER        ,
    CONFIG_NUM_2             NUMBER        ,
    CONFIG_NUM_3             NUMBER        ,
    CONFIG_NUM_4             NUMBER        ,
    CONFIG_NUM_5             NUMBER        ,
    AUDIT_ACTION_TYPE_       VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_    VARCHAR2(4000),
    AUDIT_IMPERSONATOR_      VARCHAR2(256) ,
    ASGN_PTNL_LER_ID         NUMBER(18, 0) ,
    PERSON_ID                NUMBER(18, 0) ,
    LER_ID                   NUMBER(18, 0) ,
    OCCURRED_DATE            DATE          ,
    BENEFIT_RELATION_ID      NUMBER(18, 0) ,
    SUBMITTED_DATE           DATE          ,
    STATUS_CD                VARCHAR2(120) ,
    RESUBMITTED_DATE         DATE          ,
    APPROVED_DATE            DATE          ,
    REJECTED_DATE            DATE          ,
    INFO_REQD_DATE           DATE          ,
    USER_COMMENTS            VARCHAR2(4000),
    ADMIN_COMMENTS           VARCHAR2(4000),
    ACTIONED_BY              VARCHAR2(4000),
    DOCUMENT_TYPE_ID         NUMBER(18, 0) ,
    SYSTEM_DOCUMENT_TYPE     VARCHAR2(480) ,
    DOR_ID                   NUMBER(18, 0) ,
    PTNL_LER_FOR_PER_ID      NUMBER(18, 0) ,
    SOURCE                   VARCHAR2(120) ,
    BUSINESS_GROUP_ID        NUMBER(18, 0) ,
    CREATED_BY               VARCHAR2(256) ,
    CREATION_DATE            TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)  ,
    LAST_UPDATE_DATE         TIMESTAMP(6)  ,
    LAST_UPDATED_BY          VARCHAR2(256) ,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    CONFIG_CHAR_1            VARCHAR2(960) ,
    CONFIG_CHAR_2            VARCHAR2(960) ,
    CONFIG_CHAR_3            VARCHAR2(960) ,
    CONFIG_CHAR_4            VARCHAR2(960) ,
    CONFIG_CHAR_5            VARCHAR2(960) ,
    CONFIG_CHAR_6            VARCHAR2(960) ,
    CONFIG_CHAR_7            VARCHAR2(960) ,
    CONFIG_CHAR_8            VARCHAR2(960) ,
    CONFIG_CHAR_9            VARCHAR2(960) ,
    CONFIG_CHAR_10           VARCHAR2(960) ,
    CONFIG_DATE_1            DATE          ,
    CONFIG_DATE_2            DATE          ,
    CONFIG_DATE_3            DATE          ,
    CONFIG_DATE_4            DATE          ,
    CONFIG_DATE_5            DATE          ,
    CONFIG_ID_1              NUMBER(18, 0) ,
    CONFIG_ID_2              NUMBER(18, 0) ,
    CONFIG_ID_3              NUMBER(18, 0) ,
    CONFIG_ID_4              NUMBER(18, 0) ,
    CONFIG_ID_5              NUMBER(18, 0) ,
    CONFIG_NUM_1             NUMBER        ,
    CONFIG_NUM_2             NUMBER        ,
    CONFIG_NUM_3             NUMBER        ,
    CONFIG_NUM_4             NUMBER        ,
    CONFIG_NUM_5             NUMBER        ,
    AUDIT_ACTION_TYPE_       VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_    VARCHAR2(4000),
    AUDIT_IMPERSONATOR_      VARCHAR2(256) ,
    CONSTRAINT pk_ben_asgn_ptnl_ler_ PRIMARY KEY (ASGN_PTNL_LER_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, ASGN_PTNL_LER_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY)
);
