CREATE TABLE cn_srp_participants_all_ (
    PARTICIPANT_ID               NUMBER(18, 0) ,
    ATTRIBUTE_NUMBER1            NUMBER        ,
    ATTRIBUTE_NUMBER2            NUMBER        ,
    ATTRIBUTE_NUMBER3            NUMBER        ,
    ATTRIBUTE_NUMBER4            NUMBER        ,
    ATTRIBUTE_NUMBER5            NUMBER        ,
    ATTRIBUTE_NUMBER6            NUMBER        ,
    ATTRIBUTE_NUMBER7            NUMBER        ,
    ATTRIBUTE_NUMBER8            NUMBER        ,
    ATTRIBUTE_NUMBER9            NUMBER        ,
    ATTRIBUTE_NUMBER10           NUMBER        ,
    ATTRIBUTE_DATE1              DATE          ,
    ATTRIBUTE_DATE2              DATE          ,
    ATTRIBUTE_DATE3              DATE          ,
    ATTRIBUTE_DATE4              DATE          ,
    ATTRIBUTE_DATE5              DATE          ,
    ATTRIBUTE_DATE6              DATE          ,
    ATTRIBUTE_DATE7              DATE          ,
    ATTRIBUTE_DATE8              DATE          ,
    ATTRIBUTE_DATE9              DATE          ,
    ATTRIBUTE_DATE10             DATE          ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)  ,
    PARTICIPANT_NAME             VARCHAR2(1440),
    PARTICIPANT_TYPE             VARCHAR2(240) ,
    PARTY_ID                     NUMBER(18, 0) ,
    PARTY_NUMBER                 VARCHAR2(120) ,
    PARTICIPANT_LAST_NAME        VARCHAR2(600) ,
    PARTICIPANT_FIRST_NAME       VARCHAR2(600) ,
    HR_PERSON_NUMBER             VARCHAR2(120) ,
    HR_PRIMARY_WORKER_NUMBER     VARCHAR2(120) ,
    START_DATE                   DATE          ,
    END_DATE                     DATE          ,
    ACTIVE_FLAG                  VARCHAR2(4)   ,
    ANALYST_ID                   NUMBER(18, 0) ,
    ORG_ID                       NUMBER(18, 0) ,
    COMPENSATION_END_DATE        DATE          ,
    HOLD_PAYMENT_FLAG            VARCHAR2(4)   ,
    HOLD_REASON                  VARCHAR2(120) ,
    PAYEE_ONLY                   VARCHAR2(4)   ,
    DISPLAY_IDENTIFIER           VARCHAR2(240) ,
    SOURCE_SYSTEM                VARCHAR2(240) ,
    SOURCE_SYSTEM_ID             VARCHAR2(240) ,
    ATTRIBUTE_CATEGORY           VARCHAR2(120) ,
    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) ,
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    USER_GUID                    VARCHAR2(256) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CLASSIFY_BATCH_NUMBER        NUMBER(18, 0) ,
    CREDITING_BATCH_NUMBER       NUMBER(18, 0) ,
    ROLLUP_BATCH_NUMBER          NUMBER(18, 0) ,
    CALC_BATCH_NUMBER            NUMBER(18, 0) ,
    AUDIT_ACTION_TYPE_           VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_        VARCHAR2(4000),
    AUDIT_IMPERSONATOR_          VARCHAR2(256) ,
    REHIRE_COUNT                 NUMBER        ,
    REHIRE_DATE                  DATE          ,
    PREVIOUS_TERMINATION_DATE    DATE          ,
    PREVIOUS_COMP_END_DATE       DATE          ,
    PARTICIPANT_ID               NUMBER(18, 0) ,
    ATTRIBUTE_NUMBER1            NUMBER        ,
    ATTRIBUTE_NUMBER2            NUMBER        ,
    ATTRIBUTE_NUMBER3            NUMBER        ,
    ATTRIBUTE_NUMBER4            NUMBER        ,
    ATTRIBUTE_NUMBER5            NUMBER        ,
    ATTRIBUTE_NUMBER6            NUMBER        ,
    ATTRIBUTE_NUMBER7            NUMBER        ,
    ATTRIBUTE_NUMBER8            NUMBER        ,
    ATTRIBUTE_NUMBER9            NUMBER        ,
    ATTRIBUTE_NUMBER10           NUMBER        ,
    ATTRIBUTE_DATE1              DATE          ,
    ATTRIBUTE_DATE2              DATE          ,
    ATTRIBUTE_DATE3              DATE          ,
    ATTRIBUTE_DATE4              DATE          ,
    ATTRIBUTE_DATE5              DATE          ,
    ATTRIBUTE_DATE6              DATE          ,
    ATTRIBUTE_DATE7              DATE          ,
    ATTRIBUTE_DATE8              DATE          ,
    ATTRIBUTE_DATE9              DATE          ,
    ATTRIBUTE_DATE10             DATE          ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)  ,
    PARTICIPANT_NAME             VARCHAR2(1440),
    PARTICIPANT_TYPE             VARCHAR2(240) ,
    PARTY_ID                     NUMBER(18, 0) ,
    PARTY_NUMBER                 VARCHAR2(120) ,
    PARTICIPANT_LAST_NAME        VARCHAR2(600) ,
    PARTICIPANT_FIRST_NAME       VARCHAR2(600) ,
    HR_PERSON_NUMBER             VARCHAR2(120) ,
    HR_PRIMARY_WORKER_NUMBER     VARCHAR2(120) ,
    START_DATE                   DATE          ,
    END_DATE                     DATE          ,
    ACTIVE_FLAG                  VARCHAR2(4)   ,
    ANALYST_ID                   NUMBER(18, 0) ,
    ORG_ID                       NUMBER(18, 0) ,
    COMPENSATION_END_DATE        DATE          ,
    HOLD_PAYMENT_FLAG            VARCHAR2(4)   ,
    HOLD_REASON                  VARCHAR2(120) ,
    PAYEE_ONLY                   VARCHAR2(4)   ,
    DISPLAY_IDENTIFIER           VARCHAR2(240) ,
    SOURCE_SYSTEM                VARCHAR2(240) ,
    SOURCE_SYSTEM_ID             VARCHAR2(240) ,
    ATTRIBUTE_CATEGORY           VARCHAR2(120) ,
    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) ,
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    USER_GUID                    VARCHAR2(256) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CLASSIFY_BATCH_NUMBER        NUMBER(18, 0) ,
    CREDITING_BATCH_NUMBER       NUMBER(18, 0) ,
    ROLLUP_BATCH_NUMBER          NUMBER(18, 0) ,
    CALC_BATCH_NUMBER            NUMBER(18, 0) ,
    AUDIT_ACTION_TYPE_           VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_        VARCHAR2(4000),
    AUDIT_IMPERSONATOR_          VARCHAR2(256) ,
    REHIRE_COUNT                 NUMBER        ,
    REHIRE_DATE                  DATE          ,
    PREVIOUS_TERMINATION_DATE    DATE          ,
    PREVIOUS_COMP_END_DATE       DATE          ,
    CONSTRAINT pk_cn_srp_participants_all_ PRIMARY KEY (PARTICIPANT_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, PARTICIPANT_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE)
);
