CREATE TABLE cmp_cwb_simple_components (
    PERSON_EVENT_ID              NUMBER(18, 0),
    PLAN_ID                      NUMBER(18, 0)    NOT NULL,
    PERIOD_ID                    NUMBER(18, 0)    NOT NULL,
    SIMPLE_SALARY_COMPNT_ID      NUMBER(18, 0),
    PERSON_ID                    NUMBER(18, 0),
    ASSIGNMENT_ID                NUMBER(18, 0),
    SALARY_ID                    NUMBER(18, 0)    NOT NULL,
    SALARY_BASIS_ID              NUMBER(18, 0),
    SALARY_DATE_FROM             DATE         ,
    SALARY_DATE_TO               DATE         ,
    BASIS_SIMPLE_COMPONENT_ID    NUMBER(18, 0)    NOT NULL,
    DISPLAY_SEQUENCE             NUMBER(3, 0) ,
    PROCESSING_SEQUENCE          NUMBER(3, 0) ,
    COMPONENT_TYPE               VARCHAR2(120),
    COMPONENT_CODE               VARCHAR2(120),
    BASED_ON_COMPONENT_CODE      VARCHAR2(120),
    OVERALL_SALARY_AFFECT        VARCHAR2(120),
    INPUT_VALUE_ID               NUMBER(18, 0),
    USER_SELECTED_COMPONENT      VARCHAR2(120),
    DEFAULT_AMOUNT               NUMBER       ,
    PREV_AMOUNT                  NUMBER       ,
    PREV_ADJUSTMENT_AMOUNT       NUMBER       ,
    PREV_ADJUSTMENT_PERCENT      NUMBER       ,
    AMOUNT                       NUMBER           NOT NULL,
    CURRENCY_CODE                VARCHAR2(120),
    FREQUENCY_CODE               VARCHAR2(120),
    SCALE                        NUMBER(3, 0) ,
    ROUNDING_CODE                VARCHAR2(80) ,
    ADJUSTMENT_AMOUNT            NUMBER       ,
    ADJUSTMENT_PERCENT           NUMBER       ,
    PERCENTAGE                   NUMBER       ,
    ANNUAL_FACTOR                NUMBER       ,
    ANNUAL_AMOUNT                NUMBER       ,
    ANNUAL_FT_AMOUNT             NUMBER       ,
    MINIMUM_AMOUNT               NUMBER       ,
    MAXIMUM_AMOUNT               NUMBER       ,
    OVERRIDE_GSP_RATE            VARCHAR2(120),
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    PERSON_RUN_ID                NUMBER(18, 0),
    PERSON_EVENT_ID              NUMBER(18, 0),
    PLAN_ID                      NUMBER(18, 0)    NOT NULL,
    PERIOD_ID                    NUMBER(18, 0)    NOT NULL,
    SIMPLE_SALARY_COMPNT_ID      NUMBER(18, 0),
    PERSON_ID                    NUMBER(18, 0),
    ASSIGNMENT_ID                NUMBER(18, 0),
    SALARY_ID                    NUMBER(18, 0)    NOT NULL,
    SALARY_BASIS_ID              NUMBER(18, 0),
    SALARY_DATE_FROM             DATE         ,
    SALARY_DATE_TO               DATE         ,
    BASIS_SIMPLE_COMPONENT_ID    NUMBER(18, 0)    NOT NULL,
    DISPLAY_SEQUENCE             NUMBER(3, 0) ,
    PROCESSING_SEQUENCE          NUMBER(3, 0) ,
    COMPONENT_TYPE               VARCHAR2(120),
    COMPONENT_CODE               VARCHAR2(120),
    BASED_ON_COMPONENT_CODE      VARCHAR2(120),
    OVERALL_SALARY_AFFECT        VARCHAR2(120),
    INPUT_VALUE_ID               NUMBER(18, 0),
    USER_SELECTED_COMPONENT      VARCHAR2(120),
    DEFAULT_AMOUNT               NUMBER       ,
    PREV_AMOUNT                  NUMBER       ,
    PREV_ADJUSTMENT_AMOUNT       NUMBER       ,
    PREV_ADJUSTMENT_PERCENT      NUMBER       ,
    AMOUNT                       NUMBER           NOT NULL,
    CURRENCY_CODE                VARCHAR2(120),
    FREQUENCY_CODE               VARCHAR2(120),
    SCALE                        NUMBER(3, 0) ,
    ROUNDING_CODE                VARCHAR2(80) ,
    ADJUSTMENT_AMOUNT            NUMBER       ,
    ADJUSTMENT_PERCENT           NUMBER       ,
    PERCENTAGE                   NUMBER       ,
    ANNUAL_FACTOR                NUMBER       ,
    ANNUAL_AMOUNT                NUMBER       ,
    ANNUAL_FT_AMOUNT             NUMBER       ,
    MINIMUM_AMOUNT               NUMBER       ,
    MAXIMUM_AMOUNT               NUMBER       ,
    OVERRIDE_GSP_RATE            VARCHAR2(120),
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    PERSON_RUN_ID                NUMBER(18, 0),
    CONSTRAINT pk_cmp_cwb_simple_components PRIMARY KEY (PERSON_EVENT_ID, SIMPLE_SALARY_COMPNT_ID, PERSON_EVENT_ID, SIMPLE_SALARY_COMPNT_ID)
);
