CREATE TABLE fa_bonus_rules_ (
    BONUS_RULE_ID              NUMBER(18, 0) ,
    BONUS_RULE                 VARCHAR2(120) ,
    DESCRIPTION                VARCHAR2(320) ,
    ONE_TIME_FLAG              VARCHAR2(12)  ,
    SET_ID                     NUMBER(18, 0) ,
    CREATION_DATE              TIMESTAMP(6)  ,
    CREATED_BY                 VARCHAR2(256) ,
    LAST_UPDATE_DATE           TIMESTAMP(6)  ,
    LAST_UPDATED_BY            VARCHAR2(256) ,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)  ,
    ATTRIBUTE1                 VARCHAR2(600) ,
    ATTRIBUTE2                 VARCHAR2(600) ,
    ATTRIBUTE3                 VARCHAR2(600) ,
    ATTRIBUTE4                 VARCHAR2(600) ,
    ATTRIBUTE5                 VARCHAR2(600) ,
    ATTRIBUTE6                 VARCHAR2(600) ,
    ATTRIBUTE7                 VARCHAR2(600) ,
    ATTRIBUTE8                 VARCHAR2(600) ,
    ATTRIBUTE9                 VARCHAR2(600) ,
    ATTRIBUTE10                VARCHAR2(600) ,
    ATTRIBUTE11                VARCHAR2(600) ,
    ATTRIBUTE12                VARCHAR2(600) ,
    ATTRIBUTE13                VARCHAR2(600) ,
    ATTRIBUTE14                VARCHAR2(600) ,
    ATTRIBUTE15                VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY_CODE    VARCHAR2(120) ,
    CALCULATION_BASIS_CODE     VARCHAR2(120) ,
    RATE_TYPE_CODE             VARCHAR2(120) ,
    CALENDAR_TYPE              VARCHAR2(60)  ,
    UNPLANNED_RULE_FLAG        VARCHAR2(4)   ,
    TRACKING_TYPE_CODE         VARCHAR2(120) ,
    BONUS_CLASS_CODE           VARCHAR2(120) ,
    COUNTRY                    VARCHAR2(120) ,
    ROUNDING_RULE_CODE         VARCHAR2(120) ,
    DEPRN_SUBJECT_CODE         VARCHAR2(120) ,
    RECAPTURE_YEAR             NUMBER(4, 0)  ,
    AUDIT_ACTION_TYPE_         VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_      VARCHAR2(4000),
    AUDIT_IMPERSONATOR_        VARCHAR2(256) ,
    BONUS_RULE_ID              NUMBER(18, 0) ,
    BONUS_RULE                 VARCHAR2(120) ,
    DESCRIPTION                VARCHAR2(320) ,
    ONE_TIME_FLAG              VARCHAR2(12)  ,
    SET_ID                     NUMBER(18, 0) ,
    CREATION_DATE              TIMESTAMP(6)  ,
    CREATED_BY                 VARCHAR2(256) ,
    LAST_UPDATE_DATE           TIMESTAMP(6)  ,
    LAST_UPDATED_BY            VARCHAR2(256) ,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)  ,
    ATTRIBUTE1                 VARCHAR2(600) ,
    ATTRIBUTE2                 VARCHAR2(600) ,
    ATTRIBUTE3                 VARCHAR2(600) ,
    ATTRIBUTE4                 VARCHAR2(600) ,
    ATTRIBUTE5                 VARCHAR2(600) ,
    ATTRIBUTE6                 VARCHAR2(600) ,
    ATTRIBUTE7                 VARCHAR2(600) ,
    ATTRIBUTE8                 VARCHAR2(600) ,
    ATTRIBUTE9                 VARCHAR2(600) ,
    ATTRIBUTE10                VARCHAR2(600) ,
    ATTRIBUTE11                VARCHAR2(600) ,
    ATTRIBUTE12                VARCHAR2(600) ,
    ATTRIBUTE13                VARCHAR2(600) ,
    ATTRIBUTE14                VARCHAR2(600) ,
    ATTRIBUTE15                VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY_CODE    VARCHAR2(120) ,
    CALCULATION_BASIS_CODE     VARCHAR2(120) ,
    RATE_TYPE_CODE             VARCHAR2(120) ,
    CALENDAR_TYPE              VARCHAR2(60)  ,
    UNPLANNED_RULE_FLAG        VARCHAR2(4)   ,
    TRACKING_TYPE_CODE         VARCHAR2(120) ,
    BONUS_CLASS_CODE           VARCHAR2(120) ,
    COUNTRY                    VARCHAR2(120) ,
    ROUNDING_RULE_CODE         VARCHAR2(120) ,
    DEPRN_SUBJECT_CODE         VARCHAR2(120) ,
    AUDIT_ACTION_TYPE_         VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_      VARCHAR2(4000),
    AUDIT_IMPERSONATOR_        VARCHAR2(256) ,
    RECAPTURE_YEAR             NUMBER(4, 0)  ,
    CONSTRAINT pk_fa_bonus_rules_ PRIMARY KEY (BONUS_RULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, BONUS_RULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY)
);
