CREATE TABLE fa_mc_deprn_summary (
    ASSET_ID                         NUMBER(18, 0),
    BOOK_TYPE_CODE                   VARCHAR2(120),
    PERIOD_COUNTER                   NUMBER(18, 0),
    SET_OF_BOOKS_ID                  NUMBER(18, 0),
    DEPRN_RUN_DATE                   DATE             NOT NULL,
    DEPRN_AMOUNT                     NUMBER           NOT NULL,
    YTD_DEPRN                        NUMBER           NOT NULL,
    DEPRN_RESERVE                    NUMBER           NOT NULL,
    DEPRN_SOURCE_CODE                VARCHAR2(60)     NOT NULL,
    ADJUSTED_COST                    NUMBER           NOT NULL,
    BONUS_RATE                       NUMBER       ,
    LTD_PRODUCTION                   NUMBER       ,
    PRODUCTION                       NUMBER       ,
    REVAL_AMORTIZATION               NUMBER       ,
    REVAL_AMORTIZATION_BASIS         NUMBER       ,
    REVAL_DEPRN_EXPENSE              NUMBER       ,
    REVAL_RESERVE                    NUMBER       ,
    YTD_PRODUCTION                   NUMBER       ,
    YTD_REVAL_DEPRN_EXPENSE          NUMBER       ,
    PRIOR_FY_EXPENSE                 NUMBER       ,
    CONVERTED_FLAG                   VARCHAR2(4)      NOT NULL,
    BONUS_DEPRN_AMOUNT               NUMBER       ,
    BONUS_YTD_DEPRN                  NUMBER       ,
    BONUS_DEPRN_RESERVE              NUMBER       ,
    PRIOR_FY_BONUS_EXPENSE           NUMBER       ,
    DEPRN_OVERRIDE_FLAG              VARCHAR2(4)  ,
    SYSTEM_DEPRN_AMOUNT              NUMBER       ,
    SYSTEM_BONUS_DEPRN_AMOUNT        NUMBER       ,
    EVENT_ID                         NUMBER(18, 0),
    DEPRN_RUN_ID                     NUMBER(18, 0),
    DEPRN_ADJUSTMENT_AMOUNT          NUMBER       ,
    BONUS_DEPRN_ADJUSTMENT_AMOUNT    NUMBER       ,
    CAPITAL_ADJUSTMENT               NUMBER       ,
    GENERAL_FUND                     NUMBER       ,
    IMPAIRMENT_AMOUNT                NUMBER       ,
    IMPAIRMENT_RESERVE               NUMBER       ,
    YTD_IMPAIRMENT                   NUMBER       ,
    CREATION_DATE                    TIMESTAMP(6)     NOT NULL,
    CREATED_BY                       VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    IMPAIR_LOSS_BALANCE              NUMBER       ,
    REVAL_LOSS_BALANCE               NUMBER       ,
    REVAL_AMORT_BALANCE              NUMBER       ,
    ACCELERATED_ADJUSTED_COST        NUMBER       ,
    BONUS_ADJUSTED_COST              NUMBER       ,
    ACCELERATED_DEPRN_AMOUNT         NUMBER       ,
    ACCELERATED_DEPRN_RESERVE        NUMBER       ,
    ACCELERATED_YTD_DEPRN            NUMBER       ,
    ACC_DEPRN_ADJUSTMENT_AMOUNT      NUMBER       ,
    DEPRN_ADJUSTMENT_FACTOR          NUMBER       ,
    YTD_REVAL_AMORTIZATION           NUMBER       ,
    REVAL_AMORTIZATION_ADJUSTMENT    NUMBER       ,
    BACKLOG_DEPRN_RESERVE            NUMBER       ,
    YTD_BACKLOG_DEPRN                NUMBER       ,
    ANNUITY_INTEREST_AMOUNT          NUMBER       ,
    YTD_ANNUITY_INTEREST             NUMBER       ,
    LTD_ANNUITY_INTEREST             NUMBER       ,
    ANNUITY_INTEREST_ADJ_AMOUNT      NUMBER       ,
    ASSET_ID                         NUMBER(18, 0),
    BOOK_TYPE_CODE                   VARCHAR2(120),
    PERIOD_COUNTER                   NUMBER(18, 0),
    SET_OF_BOOKS_ID                  NUMBER(18, 0),
    DEPRN_RUN_DATE                   DATE             NOT NULL,
    DEPRN_AMOUNT                     NUMBER           NOT NULL,
    YTD_DEPRN                        NUMBER           NOT NULL,
    DEPRN_RESERVE                    NUMBER           NOT NULL,
    DEPRN_SOURCE_CODE                VARCHAR2(60)     NOT NULL,
    ADJUSTED_COST                    NUMBER           NOT NULL,
    BONUS_RATE                       NUMBER       ,
    LTD_PRODUCTION                   NUMBER       ,
    PRODUCTION                       NUMBER       ,
    REVAL_AMORTIZATION               NUMBER       ,
    REVAL_AMORTIZATION_BASIS         NUMBER       ,
    REVAL_DEPRN_EXPENSE              NUMBER       ,
    REVAL_RESERVE                    NUMBER       ,
    YTD_PRODUCTION                   NUMBER       ,
    YTD_REVAL_DEPRN_EXPENSE          NUMBER       ,
    PRIOR_FY_EXPENSE                 NUMBER       ,
    CONVERTED_FLAG                   VARCHAR2(4)      NOT NULL,
    BONUS_DEPRN_AMOUNT               NUMBER       ,
    BONUS_YTD_DEPRN                  NUMBER       ,
    BONUS_DEPRN_RESERVE              NUMBER       ,
    PRIOR_FY_BONUS_EXPENSE           NUMBER       ,
    DEPRN_OVERRIDE_FLAG              VARCHAR2(4)  ,
    SYSTEM_DEPRN_AMOUNT              NUMBER       ,
    SYSTEM_BONUS_DEPRN_AMOUNT        NUMBER       ,
    EVENT_ID                         NUMBER(18, 0),
    DEPRN_RUN_ID                     NUMBER(18, 0),
    DEPRN_ADJUSTMENT_AMOUNT          NUMBER       ,
    BONUS_DEPRN_ADJUSTMENT_AMOUNT    NUMBER       ,
    CAPITAL_ADJUSTMENT               NUMBER       ,
    GENERAL_FUND                     NUMBER       ,
    IMPAIRMENT_AMOUNT                NUMBER       ,
    IMPAIRMENT_RESERVE               NUMBER       ,
    YTD_IMPAIRMENT                   NUMBER       ,
    CREATION_DATE                    TIMESTAMP(6)     NOT NULL,
    CREATED_BY                       VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    IMPAIR_LOSS_BALANCE              NUMBER       ,
    REVAL_LOSS_BALANCE               NUMBER       ,
    REVAL_AMORT_BALANCE              NUMBER       ,
    ACCELERATED_ADJUSTED_COST        NUMBER       ,
    BONUS_ADJUSTED_COST              NUMBER       ,
    ACCELERATED_DEPRN_AMOUNT         NUMBER       ,
    ACCELERATED_DEPRN_RESERVE        NUMBER       ,
    ACCELERATED_YTD_DEPRN            NUMBER       ,
    ACC_DEPRN_ADJUSTMENT_AMOUNT      NUMBER       ,
    DEPRN_ADJUSTMENT_FACTOR          NUMBER       ,
    YTD_REVAL_AMORTIZATION           NUMBER       ,
    REVAL_AMORTIZATION_ADJUSTMENT    NUMBER       ,
    BACKLOG_DEPRN_RESERVE            NUMBER       ,
    YTD_BACKLOG_DEPRN                NUMBER       ,
    ANNUITY_INTEREST_AMOUNT          NUMBER       ,
    YTD_ANNUITY_INTEREST             NUMBER       ,
    LTD_ANNUITY_INTEREST             NUMBER       ,
    ANNUITY_INTEREST_ADJ_AMOUNT      NUMBER       ,
    CONSTRAINT pk_fa_mc_deprn_summary PRIMARY KEY (ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, SET_OF_BOOKS_ID)
);
