CREATE TABLE ben_bill_charge_details_ (
    BILL_CHARGE_DTL_ID        NUMBER(18, 0) ,
    BENEFIT_RELATION_ID       NUMBER(18, 0) ,
    LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    BILL_CHARGE_ID            NUMBER(18, 0) ,
    PRTT_ENRT_RSLT_ID         NUMBER(18, 0) ,
    PRTT_RT_VAL_ID            NUMBER(18, 0) ,
    PL_ID                     NUMBER(18, 0) ,
    PGM_ID                    NUMBER(18, 0) ,
    OIPL_ID                   NUMBER(18, 0) ,
    OPT_ID                    NUMBER(18, 0) ,
    PTIP_ID                   NUMBER(18, 0) ,
    ANN_RT_VAL                NUMBER        ,
    CMCD_RT_VAL               NUMBER        ,
    DFND_RT_VAL               NUMBER        ,
    DFND_RT_FREQ              VARCHAR2(120) ,
    CMCD_RT_FREQ              VARCHAR2(120) ,
    BILL_AMT                  NUMBER        ,
    ORIGINAL_BILL_AMT         NUMBER        ,
    STATUS                    VARCHAR2(120) ,
    ADJ_PERCENT               NUMBER        ,
    ADD_FLAT_AMT              NUMBER        ,
    PL_TYP_ID                 NUMBER(18, 0) ,
    CURRENCY_CD               VARCHAR2(120) ,
    AMT_PAID                  NUMBER        ,
    ALLOC_SEQ_NUM             NUMBER(18, 0) ,
    AMT_DUE                   NUMBER        ,
    ADJ_AMT                   NUMBER        ,
    ADJ_DATE                  DATE          ,
    OVERRIDE_REASON           VARCHAR2(4000),
    OVERRIDE_DATE             DATE          ,
    RATE_START_DT             DATE          ,
    RATE_END_DT               DATE          ,
    DAILY_PROTN_FLAG          VARCHAR2(120) ,
    HOLD_FLAG                 VARCHAR2(120) ,
    TAX_PERCENT               NUMBER        ,
    TAX_AMT                   NUMBER        ,
    TAX_TYPE                  VARCHAR2(120) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    LAST_UPDATED_BY           VARCHAR2(256) ,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CREATED_BY                VARCHAR2(256) ,
    CREATION_DATE             TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)  ,
    BUSINESS_GROUP_ID         NUMBER(18, 0) ,
    CONFIG_NUM_1              NUMBER        ,
    CONFIG_NUM_2              NUMBER        ,
    CONFIG_NUM_3              NUMBER        ,
    CONFIG_NUM_4              NUMBER        ,
    CONFIG_NUM_5              NUMBER        ,
    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_DATE_1             DATE          ,
    CONFIG_DATE_2             DATE          ,
    CONFIG_DATE_3             DATE          ,
    CONFIG_DATE_4             DATE          ,
    CONFIG_DATE_5             DATE          ,
    BCD_ATTRIBUTE_CATEGORY    VARCHAR2(120) ,
    BCD_ATTRIBUTE1            VARCHAR2(600) ,
    BCD_ATTRIBUTE2            VARCHAR2(600) ,
    BCD_ATTRIBUTE3            VARCHAR2(600) ,
    BCD_ATTRIBUTE4            VARCHAR2(600) ,
    BCD_ATTRIBUTE5            VARCHAR2(600) ,
    BCD_ATTRIBUTE6            VARCHAR2(600) ,
    BCD_ATTRIBUTE7            VARCHAR2(600) ,
    BCD_ATTRIBUTE8            VARCHAR2(600) ,
    BCD_ATTRIBUTE9            VARCHAR2(600) ,
    BCD_ATTRIBUTE10           VARCHAR2(600) ,
    BCD_ATTRIBUTE_DATE1       DATE          ,
    BCD_ATTRIBUTE_DATE2       DATE          ,
    BCD_ATTRIBUTE_DATE3       DATE          ,
    BCD_ATTRIBUTE_DATE4       DATE          ,
    BCD_ATTRIBUTE_DATE5       DATE          ,
    BCD_ATTRIBUTE_NUMBER1     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER2     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER3     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER4     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER5     NUMBER        ,
    AUDIT_ACTION_TYPE_        VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_     VARCHAR2(4000),
    AUDIT_IMPERSONATOR_       VARCHAR2(256) ,
    BILL_CHARGE_DTL_ID        NUMBER(18, 0) ,
    BENEFIT_RELATION_ID       NUMBER(18, 0) ,
    LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    BILL_CHARGE_ID            NUMBER(18, 0) ,
    PRTT_ENRT_RSLT_ID         NUMBER(18, 0) ,
    PRTT_RT_VAL_ID            NUMBER(18, 0) ,
    PL_ID                     NUMBER(18, 0) ,
    PGM_ID                    NUMBER(18, 0) ,
    OIPL_ID                   NUMBER(18, 0) ,
    OPT_ID                    NUMBER(18, 0) ,
    PTIP_ID                   NUMBER(18, 0) ,
    ANN_RT_VAL                NUMBER        ,
    CMCD_RT_VAL               NUMBER        ,
    DFND_RT_VAL               NUMBER        ,
    DFND_RT_FREQ              VARCHAR2(120) ,
    CMCD_RT_FREQ              VARCHAR2(120) ,
    BILL_AMT                  NUMBER        ,
    ORIGINAL_BILL_AMT         NUMBER        ,
    STATUS                    VARCHAR2(120) ,
    ADJ_PERCENT               NUMBER        ,
    ADD_FLAT_AMT              NUMBER        ,
    PL_TYP_ID                 NUMBER(18, 0) ,
    CURRENCY_CD               VARCHAR2(120) ,
    AMT_PAID                  NUMBER        ,
    ALLOC_SEQ_NUM             NUMBER(18, 0) ,
    AMT_DUE                   NUMBER        ,
    ADJ_AMT                   NUMBER        ,
    ADJ_DATE                  DATE          ,
    OVERRIDE_REASON           VARCHAR2(4000),
    OVERRIDE_DATE             DATE          ,
    RATE_START_DT             DATE          ,
    RATE_END_DT               DATE          ,
    DAILY_PROTN_FLAG          VARCHAR2(120) ,
    HOLD_FLAG                 VARCHAR2(120) ,
    TAX_PERCENT               NUMBER        ,
    TAX_AMT                   NUMBER        ,
    TAX_TYPE                  VARCHAR2(120) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    LAST_UPDATED_BY           VARCHAR2(256) ,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CREATED_BY                VARCHAR2(256) ,
    CREATION_DATE             TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)  ,
    BUSINESS_GROUP_ID         NUMBER(18, 0) ,
    CONFIG_NUM_1              NUMBER        ,
    CONFIG_NUM_2              NUMBER        ,
    CONFIG_NUM_3              NUMBER        ,
    CONFIG_NUM_4              NUMBER        ,
    CONFIG_NUM_5              NUMBER        ,
    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_DATE_1             DATE          ,
    CONFIG_DATE_2             DATE          ,
    CONFIG_DATE_3             DATE          ,
    CONFIG_DATE_4             DATE          ,
    CONFIG_DATE_5             DATE          ,
    BCD_ATTRIBUTE_CATEGORY    VARCHAR2(120) ,
    BCD_ATTRIBUTE1            VARCHAR2(600) ,
    BCD_ATTRIBUTE2            VARCHAR2(600) ,
    BCD_ATTRIBUTE3            VARCHAR2(600) ,
    BCD_ATTRIBUTE4            VARCHAR2(600) ,
    BCD_ATTRIBUTE5            VARCHAR2(600) ,
    BCD_ATTRIBUTE6            VARCHAR2(600) ,
    BCD_ATTRIBUTE7            VARCHAR2(600) ,
    BCD_ATTRIBUTE8            VARCHAR2(600) ,
    BCD_ATTRIBUTE9            VARCHAR2(600) ,
    BCD_ATTRIBUTE10           VARCHAR2(600) ,
    BCD_ATTRIBUTE_DATE1       DATE          ,
    BCD_ATTRIBUTE_DATE2       DATE          ,
    BCD_ATTRIBUTE_DATE3       DATE          ,
    BCD_ATTRIBUTE_DATE4       DATE          ,
    BCD_ATTRIBUTE_DATE5       DATE          ,
    BCD_ATTRIBUTE_NUMBER1     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER2     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER3     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER4     NUMBER        ,
    BCD_ATTRIBUTE_NUMBER5     NUMBER        ,
    AUDIT_ACTION_TYPE_        VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_     VARCHAR2(4000),
    AUDIT_IMPERSONATOR_       VARCHAR2(256) ,
    CONSTRAINT pk_ben_bill_charge_details_ PRIMARY KEY (BILL_CHARGE_DTL_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, BILL_CHARGE_DTL_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY)
);
