CREATE TABLE fa_itf_impairments (
    REQUEST_ID                       NUMBER(18, 0),
    IMPAIRMENT_ID                    NUMBER(18, 0),
    BOOK_TYPE_CODE                   VARCHAR2(120)    NOT NULL,
    ASSET_ID                         NUMBER       ,
    CASH_GENERATING_UNIT_ID          NUMBER(18, 0),
    NET_BOOK_VALUE                   NUMBER       ,
    NET_SELLING_PRICE                NUMBER       ,
    VALUE_IN_USE                     NUMBER       ,
    IMPAIRMENT_AMOUNT                NUMBER       ,
    YTD_IMPAIRMENT                   NUMBER       ,
    GOODWILL_ASSET_FLAG              VARCHAR2(4)  ,
    DEPRN_RUN_DATE                   DATE         ,
    DEPRN_AMOUNT                     NUMBER       ,
    YTD_DEPRN                        NUMBER       ,
    DEPRN_RESERVE                    NUMBER       ,
    ADJUSTED_COST                    NUMBER       ,
    BONUS_RATE                       NUMBER       ,
    LTD_PRODUCTION                   NUMBER       ,
    PERIOD_COUNTER                   NUMBER(18, 0),
    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       ,
    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       ,
    DEPRN_ADJUSTMENT_AMOUNT          NUMBER       ,
    BONUS_DEPRN_ADJUSTMENT_AMOUNT    NUMBER       ,
    REVAL_RESERVE_ADJ_AMOUNT         NUMBER       ,
    COST                             NUMBER       ,
    PERIOD_OF_ADDITION_FLAG          VARCHAR2(4)  ,
    CURRENT_UNITS                    NUMBER       ,
    CATEGORY_ID                      NUMBER(18, 0),
    IMPAIRMENT_DATE                  DATE         ,
    WORKER_ID                        NUMBER(18, 0),
    PROCESS_ORDER                    NUMBER(18, 0),
    RATE_ADJUSTMENT_FACTOR           NUMBER       ,
    FORMULA_FACTOR                   NUMBER       ,
    EOFY_RESERVE                     NUMBER       ,
    IMPAIR_CLASS                     VARCHAR2(12) ,
    REASON                           VARCHAR2(400),
    SPLIT_IMPAIR_FLAG                VARCHAR2(4)  ,
    SPLIT1_IMPAIR_CLASS              VARCHAR2(12) ,
    SPLIT1_REASON                    VARCHAR2(400),
    SPLIT1_LOSS_AMOUNT               NUMBER       ,
    SPLIT1_REVAL_RESERVE             NUMBER       ,
    SPLIT1_PERCENT                   NUMBER(3, 0) ,
    SPLIT1_PROCESS_ORDER             NUMBER       ,
    SPLIT2_IMPAIR_CLASS              VARCHAR2(12) ,
    SPLIT2_REASON                    VARCHAR2(400),
    SPLIT2_LOSS_AMOUNT               NUMBER       ,
    SPLIT2_REVAL_RESERVE             NUMBER       ,
    SPLIT2_PERCENT                   NUMBER(3, 0) ,
    SPLIT2_PROCESS_ORDER             NUMBER       ,
    SPLIT3_IMPAIR_CLASS              VARCHAR2(12) ,
    SPLIT3_REASON                    VARCHAR2(400),
    SPLIT3_LOSS_AMOUNT               NUMBER       ,
    SPLIT3_REVAL_RESERVE             NUMBER       ,
    SPLIT3_PERCENT                   NUMBER(3, 0) ,
    SPLIT3_PROCESS_ORDER             NUMBER       ,
    CAPITAL_ADJUSTMENT               NUMBER       ,
    GENERAL_FUND                     NUMBER       ,
    REVERSED_IMP_AMT                 NUMBER       ,
    REVERSED_IMP_AMT_S1              NUMBER       ,
    REVERSED_IMP_AMT_S2              NUMBER       ,
    REVERSED_IMP_AMT_S3              NUMBER       ,
    REVERSED_DEPRN_IMPACT            NUMBER       ,
    REVERSED_DEPRN_IMPACT_S1         NUMBER       ,
    REVERSED_DEPRN_IMPACT_S2         NUMBER       ,
    REVERSED_DEPRN_IMPACT_S3         NUMBER       ,
    REVERSED_REVAL_AMT               NUMBER       ,
    REVERSED_REVAL_AMT_S1            NUMBER       ,
    REVERSED_REVAL_AMT_S2            NUMBER       ,
    REVERSED_REVAL_AMT_S3            NUMBER       ,
    REVERSED_REVAL_IMPACT            NUMBER       ,
    REVERSED_REVAL_IMPACT_S1         NUMBER       ,
    REVERSED_REVAL_IMPACT_S2         NUMBER       ,
    REVERSED_REVAL_IMPACT_S3         NUMBER       ,
    IMPAIRMENT_RESERVE               NUMBER       ,
    ALLOWED_DEPRN_LIMIT_AMOUNT       NUMBER       ,
    HISTORICAL_NET_BOOK_VALUE        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       ,
    ANNUITY_INTEREST_AMOUNT          NUMBER       ,
    YTD_ANNUITY_INTEREST             NUMBER       ,
    LTD_ANNUITY_INTEREST             NUMBER       ,
    ANNUITY_INTEREST_ADJ_AMOUNT      NUMBER       ,
    AUTO_POST_TRANSACTION_FLAG       VARCHAR2(4)  ,
    APPROVAL_STATUS_CODE             VARCHAR2(120),
    REQUEST_ID                       NUMBER(18, 0),
    IMPAIRMENT_ID                    NUMBER(18, 0),
    BOOK_TYPE_CODE                   VARCHAR2(120)    NOT NULL,
    ASSET_ID                         NUMBER       ,
    CASH_GENERATING_UNIT_ID          NUMBER(18, 0),
    NET_BOOK_VALUE                   NUMBER       ,
    NET_SELLING_PRICE                NUMBER       ,
    VALUE_IN_USE                     NUMBER       ,
    IMPAIRMENT_AMOUNT                NUMBER       ,
    YTD_IMPAIRMENT                   NUMBER       ,
    GOODWILL_ASSET_FLAG              VARCHAR2(4)  ,
    DEPRN_RUN_DATE                   DATE         ,
    DEPRN_AMOUNT                     NUMBER       ,
    YTD_DEPRN                        NUMBER       ,
    DEPRN_RESERVE                    NUMBER       ,
    ADJUSTED_COST                    NUMBER       ,
    BONUS_RATE                       NUMBER       ,
    LTD_PRODUCTION                   NUMBER       ,
    PERIOD_COUNTER                   NUMBER(18, 0),
    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       ,
    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       ,
    DEPRN_ADJUSTMENT_AMOUNT          NUMBER       ,
    BONUS_DEPRN_ADJUSTMENT_AMOUNT    NUMBER       ,
    REVAL_RESERVE_ADJ_AMOUNT         NUMBER       ,
    COST                             NUMBER       ,
    PERIOD_OF_ADDITION_FLAG          VARCHAR2(4)  ,
    CURRENT_UNITS                    NUMBER       ,
    CATEGORY_ID                      NUMBER(18, 0),
    IMPAIRMENT_DATE                  DATE         ,
    WORKER_ID                        NUMBER(18, 0),
    PROCESS_ORDER                    NUMBER(18, 0),
    RATE_ADJUSTMENT_FACTOR           NUMBER       ,
    FORMULA_FACTOR                   NUMBER       ,
    EOFY_RESERVE                     NUMBER       ,
    IMPAIR_CLASS                     VARCHAR2(12) ,
    REASON                           VARCHAR2(400),
    SPLIT_IMPAIR_FLAG                VARCHAR2(4)  ,
    SPLIT1_IMPAIR_CLASS              VARCHAR2(12) ,
    SPLIT1_REASON                    VARCHAR2(400),
    SPLIT1_LOSS_AMOUNT               NUMBER       ,
    SPLIT1_REVAL_RESERVE             NUMBER       ,
    SPLIT1_PERCENT                   NUMBER(3, 0) ,
    SPLIT1_PROCESS_ORDER             NUMBER       ,
    SPLIT2_IMPAIR_CLASS              VARCHAR2(12) ,
    SPLIT2_REASON                    VARCHAR2(400),
    SPLIT2_LOSS_AMOUNT               NUMBER       ,
    SPLIT2_REVAL_RESERVE             NUMBER       ,
    SPLIT2_PERCENT                   NUMBER(3, 0) ,
    SPLIT2_PROCESS_ORDER             NUMBER       ,
    SPLIT3_IMPAIR_CLASS              VARCHAR2(12) ,
    SPLIT3_REASON                    VARCHAR2(400),
    SPLIT3_LOSS_AMOUNT               NUMBER       ,
    SPLIT3_REVAL_RESERVE             NUMBER       ,
    SPLIT3_PERCENT                   NUMBER(3, 0) ,
    SPLIT3_PROCESS_ORDER             NUMBER       ,
    CAPITAL_ADJUSTMENT               NUMBER       ,
    GENERAL_FUND                     NUMBER       ,
    REVERSED_IMP_AMT                 NUMBER       ,
    REVERSED_IMP_AMT_S1              NUMBER       ,
    REVERSED_IMP_AMT_S2              NUMBER       ,
    REVERSED_IMP_AMT_S3              NUMBER       ,
    REVERSED_DEPRN_IMPACT            NUMBER       ,
    REVERSED_DEPRN_IMPACT_S1         NUMBER       ,
    REVERSED_DEPRN_IMPACT_S2         NUMBER       ,
    REVERSED_DEPRN_IMPACT_S3         NUMBER       ,
    REVERSED_REVAL_AMT               NUMBER       ,
    REVERSED_REVAL_AMT_S1            NUMBER       ,
    REVERSED_REVAL_AMT_S2            NUMBER       ,
    REVERSED_REVAL_AMT_S3            NUMBER       ,
    REVERSED_REVAL_IMPACT            NUMBER       ,
    REVERSED_REVAL_IMPACT_S1         NUMBER       ,
    REVERSED_REVAL_IMPACT_S2         NUMBER       ,
    REVERSED_REVAL_IMPACT_S3         NUMBER       ,
    IMPAIRMENT_RESERVE               NUMBER       ,
    ALLOWED_DEPRN_LIMIT_AMOUNT       NUMBER       ,
    HISTORICAL_NET_BOOK_VALUE        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       ,
    ANNUITY_INTEREST_AMOUNT          NUMBER       ,
    YTD_ANNUITY_INTEREST             NUMBER       ,
    LTD_ANNUITY_INTEREST             NUMBER       ,
    ANNUITY_INTEREST_ADJ_AMOUNT      NUMBER       ,
    AUTO_POST_TRANSACTION_FLAG       VARCHAR2(4)  ,
    APPROVAL_STATUS_CODE             VARCHAR2(120),
    CONSTRAINT pk_fa_itf_impairments PRIMARY KEY (IMPAIRMENT_ID, ASSET_ID, IMPAIRMENT_ID, ASSET_ID)
);
