CREATE TABLE IBM3
(
  LAST_NAME VARCHAR2(50)
, FIRST_NAME VARCHAR2(50)
, MIDDLE_IN VARCHAR2(50)
, PREFERRED_NAME VARCHAR2(50)
, SERIAL_NUMBER VARCHAR2(50)
, RECRUITER VARCHAR2(50)
, ONBOARDING_STATUS VARCHAR2(50)
, RECRUITMENT_COORDINATOR VARCHAR2(50)
, HIRE_DATE DATE
, ONBOARDING_CLASS_START_DATE VARCHAR2(50)
, FIELD_START VARCHAR2(50)
, HIRE_TYPE VARCHAR2(50)
, ONBOARD_CONTRACTOR VARCHAR2(50)
, CONTRACTOR_SERIAL VARCHAR2(50)
, REHIRE VARCHAR2(50)
, SEPARATION_DATE VARCHAR2(50)
, ONBOARD_SUPPLEMENTAL VARCHAR2(50)
, INTERNATIONAL_ASIGNEE VARCHAR2(50)
, DIVISION VARCHAR2(50)
, DEPARTMENT VARCHAR2(50)
, SECTOR VARCHAR2(50)
, SERVICE_LINE VARCHAR2(50)
, SERVICE_AREA VARCHAR2(50)
, ERP_OR_PRODUCTS VARCHAR2(50)
, ERP_SPECIALTY VARCHAR2(50)
, POSITION_CODE VARCHAR2(50)
, BAND VARCHAR2(50)
, REQUISITION_NUMBER VARCHAR2(50)
, STADIUM_HIRE VARCHAR2(50)
, ONBOARDING_CLASS_LOCATION VARCHAR2(50)
, PUBLIC_SECTOR_ORIENTATION VARCHAR2(50)
, ITS_NEW_HIRE_CLASS VARCHAR2(50)
, INTRO_TO_GBS_CLASS VARCHAR2(50)
, INTRO_TO_GBS_CMNTS VARCHAR2(50)
, CONSULTING_BY_DEGREE VARCHAR2(50)
, CONSULTING_BY_DEGREE_COMMENTS VARCHAR2(50)
, CONSULTING_BY_DEGREE_NUMBER VARCHAR2(50)
, MANAGER_NOTES_ID VARCHAR2(50)
, PA_NOTES_ID VARCHAR2(50)
, SUPPLY_ANALYST_NOTES VARCHAR2(50)
, RDM_NOTES_ID VARCHAR2(50)
, PST_ONBOARDING_CONTACT_NOTESID VARCHAR2(50)
, PST_ONBRDING_CLASS_CMNTS VARCHAR2(50)
, PERSONAL_EMAIL_ADDRESS VARCHAR2(50)
, WORK_LOCATION_CODE VARCHAR2(50)
, WORK_LOCATION_CITY VARCHAR2(50)
, WORK_LOCATION_STATE VARCHAR2(50)
, WPI VARCHAR2(50)
, WPI_MOVE_REQUEST_CMNTS VARCHAR2(50)
, LAPTOP_REQUIRED VARCHAR2(50)
, LAPTOP_COMMENTS VARCHAR2(50)
, IBM_EMAIL_ADDRESS VARCHAR2(50)
, LOTUS_NOTES_ID VARCHAR2(50)
, JOB_ROLE_SKILL_SET VARCHAR2(50)
, COMMENTS VARCHAR2(50)
, MALE_OR_FEMALE VARCHAR2(50)
, ISC_BAND VARCHAR2(50)
, EL_VS_EXPRO VARCHAR2(50)
, JOB_FAMILY VARCHAR2(50)
, LISTED_IN_GBS_RESC VARCHAR2(50)
, INCLD_HEADCOUNT_S VARCHAR2(50)
, IS_A_MANAGER VARCHAR2(50)
, TITLE_OR_MANAGER VARCHAR2(50)
, CEN_HIRE_TRANS_L VARCHAR2(50)
, NOTES_RE_CEN_TRANS_L VARCHAR2(50)
, UNIVERSITY VARCHAR2(50)
, CATEGORY_UNIV VARCHAR2(50)
, UNIV_STATE VARCHAR2(50)
, NORTHERN_LA_UNIV VARCHAR2(50)
, HIGEST_DEGREE VARCHAR2(50)
, MAJOR_OF_STUDY VARCHAR2(50)
, CATEGORY_MAJOR VARCHAR2(50)
, GRADUATION_DATE DATE
, FOCUS_OR_CONCENTRATION VARCHAR2(50)
, DUAL_DEGREE VARCHAR2(50)
, FIRST_ROLE_CHANGE_TO VARCHAR2(50)
, FIRST_ROLE_BAND VARCHAR2(50)
, FIRST_ROLE_LEVEL VARCHAR2(50)
, PROMOTION_Y_N VARCHAR2(50)
, DATE_1ST_ROLE_CHANGE VARCHAR2(50)
, TRANSFERRED_OUT VARCHAR2(50)
, TRANSFFERED_DATE VARCHAR2(50)
, TRANSFERRED_TO VARCHAR2(50)
, ATTRI VARCHAR2(50)
, ATTRI_DATE DATE
, ATTRI_TYPE VARCHAR2(50)
, ELIGIBLE_FOR_REHIRE VARCHAR2(50)
, PREFORMANCE_LOW_MED_HIGH VARCHAR2(50)
, ATTRI_REASON_1 VARCHAR2(50)
, ATTRI_REASON_2 VARCHAR2(50)
, ATTRI_REASON_3 VARCHAR2(50)
, BRSC_TRAINING VARCHAR2(50)
, SERVICE_LINE_AT_ATTRI VARCHAR2(50)
, ATTRI_NOTES VARCHAR2(50)
, JRSS_AT_ATTRI VARCHAR2(50)
, CELL_PHONE_NUMBER VARCHAR2(50)
, OFFICE_PHONE_NUMBER VARCHAR2(50)
);