CREATE TABLE hrc_person_b (
    PERSON_ID                 NUMBER(18, 0)     PRIMARY KEY,
    URI                       VARCHAR2(4000),
    IS_INTERNAL               VARCHAR2(16)      NOT NULL,
    FIRST_NAME                VARCHAR2(320)     NOT NULL,
    MIDDLE_NAME               VARCHAR2(320) ,
    LAST_NAME                 VARCHAR2(320)     NOT NULL,
    FULL_NAME                 VARCHAR2(512) ,
    WILLING_TO_TRAVEL         VARCHAR2(16)  ,
    JOB_LEVEL                 VARCHAR2(2048),
    JOB_SCHEDULE              VARCHAR2(2048),
    EMPLOYEE_STATUS           VARCHAR2(512) ,
    LOCATION_GEOGRAPHY_ID     VARCHAR2(320) ,
    LOCATION_COUNTRY_ID       VARCHAR2(320) ,
    LOCATION_STATE_ID         VARCHAR2(320) ,
    LOCATION_CITY_ID          VARCHAR2(320) ,
    LOCATION_POSTAL_CODE      VARCHAR2(320) ,
    LOCATION_LEAF_NAME        VARCHAR2(4000),
    LOCATION_FQN              VARCHAR2(4000),
    LOCATION_LATITUDE         NUMBER        ,
    LOCATION_LONGITUDE        NUMBER        ,
    LOCATION_ADDRESS_LINE1    VARCHAR2(512) ,
    LOCATION_ADDRESS_LINE2    VARCHAR2(512) ,
    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) ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL
);
