CREATE TABLE gtg_ts_personassignment (
    ETL_SEQUENCE_ID             NUMBER(19, 0),
    ETL_VERSION_NUMBER          NUMBER(18, 0),
    DELETE_VERSION_NUMBER       NUMBER(18, 0),
    LAST_UPDATED_BY             VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128),
    CREATED_BY                  VARCHAR2(256)    NOT NULL,
    CREATION_DATE               TIMESTAMP(6)     NOT NULL,
    ACTION_CODE                 VARCHAR2(120),
    ACTUAL_TERMINATION_DATE     DATE         ,
    ASSIGNMENT_ID               NUMBER(18, 0),
    ASSIGNMENT_NAME             VARCHAR2(320),
    ASSIGNMENT_NUMBER           VARCHAR2(200),
    ASSIGNMENT_STATUS_TYPE      VARCHAR2(120),
    ASSIGNMENT_TYPE             VARCHAR2(120),
    BARGAINING_UNIT_CODE        VARCHAR2(120),
    BUSINESS_GROUP_ID           NUMBER(18, 0),
    BUSINESS_UNIT_ID            NUMBER(18, 0),
    CONTRACT_ID                 NUMBER(18, 0),
    DATE_START                  DATE         ,
    EFFEDDT                     DATE         ,
    EFFLTCHG                    VARCHAR2(120),
    EMPLOYEE_CATEGORY           VARCHAR2(120),
    EMPLOYMENT_CATEGORY         VARCHAR2(120),
    ESTABLISHMENT_ID            NUMBER(18, 0),
    FREQUENCY                   VARCHAR2(120),
    GRADE_ID                    NUMBER(18, 0),
    GRADE_LADDER_PGM_ID         NUMBER(18, 0),
    HOURLY_SALARIED_CODE        VARCHAR2(120),
    JOB_ID                      NUMBER(18, 0),
    LEGALENTITYID               NUMBER(18, 0),
    LEGISLATION_CODE            VARCHAR2(600),
    LGLENTITYID                 NUMBER(18, 0),
    LOCATION_ID                 NUMBER(18, 0),
    MANAGER_FLAG                VARCHAR2(120),
    NORMAL_HOURS                NUMBER(22, 3),
    ORGANIZATION_ID             NUMBER(18, 0),
    PEOPLE_GROUP_ID             NUMBER(18, 0),
    PERALLASSIGNMENTSM_CB       VARCHAR2(256),
    PERALLASSIGNMENTSM_CD       TIMESTAMP(6) ,
    PERALLASSIGNMENTSM_LUB      VARCHAR2(256),
    PERALLASSIGNMENTSM_LUD      TIMESTAMP(6) ,
    PERASSGPERID                NUMBER(18, 0),
    PERIOD_OF_SERVICE_ID        NUMBER(18, 0),
    PERIOD_TYPE                 VARCHAR2(120),
    PERPERIODSOFSERVICE_CB      VARCHAR2(256),
    PERPERIODSOFSERVICE_CD      TIMESTAMP(6) ,
    PERPERIODSOFSERVICE_LUB     VARCHAR2(256),
    PERPERIODSOFSERVICE_LUD     TIMESTAMP(6) ,
    PERSON_ID                   NUMBER(18, 0),
    POSITION_ID                 NUMBER(18, 0),
    PRIMARYFLAG                 VARCHAR2(120),
    PRIMARYFLG                  VARCHAR2(120),
    PROJECTED_ASSIGNMENT_END    DATE         ,
    REASON_CODE                 VARCHAR2(120),
    SEQ                         NUMBER(4, 0) ,
    STARTDATE                   DATE         ,
    SYSTEM_PERSON_TYPE          VARCHAR2(120),
    WORK_AT_HOME                VARCHAR2(120),
    ETL_SEQUENCE_ID             NUMBER(19, 0),
    ETL_VERSION_NUMBER          NUMBER(18, 0),
    DELETE_VERSION_NUMBER       NUMBER(18, 0),
    LAST_UPDATED_BY             VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128),
    CREATED_BY                  VARCHAR2(256)    NOT NULL,
    CREATION_DATE               TIMESTAMP(6)     NOT NULL,
    ACTION_CODE                 VARCHAR2(120),
    ACTUAL_TERMINATION_DATE     DATE         ,
    ASSIGNMENT_ID               NUMBER(18, 0),
    ASSIGNMENT_NAME             VARCHAR2(320),
    ASSIGNMENT_NUMBER           VARCHAR2(200),
    ASSIGNMENT_STATUS_TYPE      VARCHAR2(120),
    ASSIGNMENT_TYPE             VARCHAR2(120),
    BARGAINING_UNIT_CODE        VARCHAR2(120),
    BUSINESS_GROUP_ID           NUMBER(18, 0),
    BUSINESS_UNIT_ID            NUMBER(18, 0),
    CONTRACT_ID                 NUMBER(18, 0),
    DATE_START                  DATE         ,
    EFFEDDT                     DATE         ,
    EFFLTCHG                    VARCHAR2(120),
    EMPLOYEE_CATEGORY           VARCHAR2(120),
    EMPLOYMENT_CATEGORY         VARCHAR2(120),
    ESTABLISHMENT_ID            NUMBER(18, 0),
    FREQUENCY                   VARCHAR2(120),
    GRADE_ID                    NUMBER(18, 0),
    GRADE_LADDER_PGM_ID         NUMBER(18, 0),
    HOURLY_SALARIED_CODE        VARCHAR2(120),
    JOB_ID                      NUMBER(18, 0),
    LEGALENTITYID               NUMBER(18, 0),
    LEGISLATION_CODE            VARCHAR2(600),
    LGLENTITYID                 NUMBER(18, 0),
    LOCATION_ID                 NUMBER(18, 0),
    MANAGER_FLAG                VARCHAR2(120),
    NORMAL_HOURS                NUMBER(22, 3),
    ORGANIZATION_ID             NUMBER(18, 0),
    PEOPLE_GROUP_ID             NUMBER(18, 0),
    PERALLASSIGNMENTSM_CB       VARCHAR2(256),
    PERALLASSIGNMENTSM_CD       TIMESTAMP(6) ,
    PERALLASSIGNMENTSM_LUB      VARCHAR2(256),
    PERALLASSIGNMENTSM_LUD      TIMESTAMP(6) ,
    PERASSGPERID                NUMBER(18, 0),
    PERIOD_OF_SERVICE_ID        NUMBER(18, 0),
    PERIOD_TYPE                 VARCHAR2(120),
    PERPERIODSOFSERVICE_CB      VARCHAR2(256),
    PERPERIODSOFSERVICE_CD      TIMESTAMP(6) ,
    PERPERIODSOFSERVICE_LUB     VARCHAR2(256),
    PERPERIODSOFSERVICE_LUD     TIMESTAMP(6) ,
    PERSON_ID                   NUMBER(18, 0),
    POSITION_ID                 NUMBER(18, 0),
    PRIMARYFLAG                 VARCHAR2(120),
    PRIMARYFLG                  VARCHAR2(120),
    PROJECTED_ASSIGNMENT_END    DATE         ,
    REASON_CODE                 VARCHAR2(120),
    SEQ                         NUMBER(4, 0) ,
    STARTDATE                   DATE         ,
    SYSTEM_PERSON_TYPE          VARCHAR2(120),
    WORK_AT_HOME                VARCHAR2(120),
    CONSTRAINT pk_gtg_ts_personassignment PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
