REM START MY_APPS UPDATE_GB_EMP_ASG

  CREATE TABLE "MY_APPS"."UPDATE_GB_EMP_ASG" 
   (	"P_VALIDATE" VARCHAR2(30 BYTE), 
	"EFFECTIVE_DATE" DATE, 
	"DATETRACK_UPDATE_MODE" VARCHAR2(150 BYTE), 
	"OBJECT_VERSION_NUMBER" NUMBER(10,0), 
	"ASSIGNMENT_ID" NUMBER(10,0), 
	"EFFECTIVE_START_DATE" DATE, 
	"EFFECTIVE_END_DATE" DATE, 
	"BUSINESS_GROUP_ID" NUMBER(15,0), 
	"RECRUITER_ID" NUMBER(10,0), 
	"GRADE_ID" NUMBER(15,0), 
	"POSITION_ID" NUMBER(15,0), 
	"JOB_ID" NUMBER(15,0), 
	"ASSIGNMENT_STATUS_TYPE_ID" NUMBER(9,0), 
	"PAYROLL_ID" NUMBER(9,0), 
	"LOCATION_ID" NUMBER(15,0), 
	"PERSON_REFERRED_BY_ID" NUMBER(10,0), 
	"SUPERVISOR_ID" NUMBER(10,0), 
	"SPECIAL_CEILING_STEP_ID" NUMBER(15,0), 
	"PERSON_ID" NUMBER(10,0), 
	"ORGANIZATION_ID" NUMBER(15,0), 
	"PEOPLE_GROUP_ID" NUMBER(15,0), 
	"PAY_BASIS_ID" NUMBER(9,0), 
	"ASSIGNMENT_SEQUENCE" NUMBER(15,0), 
	"ASSIGNMENT_TYPE" VARCHAR2(1 BYTE), 
	"PRIMARY_FLAG" VARCHAR2(30 BYTE), 
	"APPLICATION_ID" NUMBER(15,0), 
	"ASSIGNMENT_NUMBER" VARCHAR2(50 BYTE), 
	"CHANGE_REASON" VARCHAR2(240 BYTE), 
	"COMMENT_ID" NUMBER(15,0), 
	"DATE_PROBATION_END" DATE, 
	"DEFAULT_CODE_COMB_ID" NUMBER(15,0), 
	"EMPLOYMENT_CATEGORY" VARCHAR2(30 BYTE), 
	"FREQUENCY" VARCHAR2(30 BYTE), 
	"MANAGER_FLAG" VARCHAR2(30 BYTE), 
	"NORMAL_HOURS" NUMBER(22,3), 
	"PERF_REVIEW_PERIOD" NUMBER(15,0), 
	"PERF_REVIEW_PERIOD_FREQUENCY" VARCHAR2(30 BYTE), 
	"PERIOD_OF_SERVICE_ID" NUMBER(15,0), 
	"PROBATION_PERIOD" NUMBER(22,2), 
	"PROBATION_UNIT" VARCHAR2(30 BYTE), 
	"SAL_REVIEW_PERIOD" NUMBER(15,0), 
	"SAL_REVIEW_PERIOD_FREQUENCY" VARCHAR2(30 BYTE), 
	"TIME_NORMAL_FINISH" VARCHAR2(5 BYTE), 
	"TIME_NORMAL_START" VARCHAR2(5 BYTE), 
	"BARGAINING_UNIT_CODE" VARCHAR2(30 BYTE), 
	"HOURLY_SALARIED_CODE" VARCHAR2(30 BYTE), 
	"CONTRACT_ID" NUMBER(9,0), 
	"COLLECTIVE_AGREEMENT_ID" NUMBER(9,0), 
	"CAGR_ID_FLEX_NUM" NUMBER(15,0), 
	"CAGR_GRADE_DEF_ID" NUMBER(15,0), 
	"ESTABLISHMENT_ID" NUMBER(15,0), 
	"REQUEST_ID" NUMBER(15,0), 
	"PROGRAM_APPLICATION_ID" NUMBER(15,0), 
	"PROGRAM_ID" NUMBER(15,0), 
	"PROGRAM_UPDATE_DATE" DATE, 
	"ASS_ATTRIBUTE_CATEGORY" VARCHAR2(30 BYTE), 
	"ASS_ATTRIBUTE1" VARCHAR2(150 BYTE), 
	"ASS_ATTRIBUTE3" VARCHAR2(150 BYTE), 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" NUMBER(15,0), 
	"LAST_UPDATE_LOGIN" NUMBER(15,0), 
	"CREATED_BY" NUMBER(15,0), 
	"CREATION_DATE" DATE, 
	"TITLE" VARCHAR2(30 BYTE), 
	"NOTICE_PERIOD" NUMBER(10,0), 
	"NOTICE_PERIOD_UOM" VARCHAR2(30 BYTE), 
	"EMPLOYEE_CATEGORY" VARCHAR2(30 BYTE), 
	"WORK_AT_HOME" VARCHAR2(30 BYTE), 
	"JOB_POST_SOURCE_NAME" VARCHAR2(240 BYTE), 
	"POSTING_CONTENT_ID" NUMBER(15,0), 
	"PERIOD_OF_PLACEMENT_DATE_START" DATE, 
	"VENDOR_ASSIGNMENT_NUMBER" VARCHAR2(30 BYTE), 
	"ASSIGNMENT_CATEGORY" VARCHAR2(30 BYTE), 
	"PROJECT_TITLE" VARCHAR2(30 BYTE), 
	"APPLICANT_RANK" NUMBER, 
	"PO_HEADER_ID" NUMBER(15,0), 
	"PO_LINE_ID" NUMBER(15,0), 
	"PROJECTED_ASSIGNMENT_END" DATE, 
	"GRADE_LADDER_PGM_ID" NUMBER(15,0), 
	"SUPERVISOR_ASSIGNMENT_ID" NUMBER(15,0), 
	"DATA_TRANSFERRED" VARCHAR2(1 BYTE), 
	"ERROR_MESSAGE" VARCHAR2(200 BYTE), 
	"CONTRACT_EXPIRY_DATE" DATE, 
	"ASS_ATTRIBUTE4" VARCHAR2(150 BYTE)
   );
 
REM END MY_APPS UPDATE_GB_EMP_ASG