CREATE TABLE SZSCAPD ( SZSCAPD_CLIENT_ID VARCHAR2(9 CHAR), SZSCAPD_CREATION_DATE VARCHAR2(15 CHAR), SZSCAPD_SUBMITTED_DATE VARCHAR2(14 CHAR), SZSCAPD_PRINTED_DATE VARCHAR2(12 CHAR), SZSCAPD_EXPORTED_DATE VARCHAR2(16 CHAR), SZSCAPD_APPLICANT_ID VARCHAR2(20 CHAR), SZSCAPD_PROSPECT_ID VARCHAR2(20 CHAR), SZSCAPD_APPL_PROF_DEC_TYPE VARCHAR2(20 CHAR), SZSCAPD_NEED_FIN_AID VARCHAR2(24 CHAR), SZSCAPD_FIRST_NAME VARCHAR2(25 CHAR), SZSCAPD_MIDDLE_NAME VARCHAR2(25 CHAR), SZSCAPD_LAST_NAME VARCHAR2(25 CHAR), SZSCAPD_SUFFIX VARCHAR2(25 CHAR), SZSCAPD_DOB VARCHAR2(15 CHAR), SZSCAPD_MON VARCHAR2(2 CHAR), SZSCAPD_DAY VARCHAR2(2 CHAR), SZSCAPD_YEAR VARCHAR2(4 CHAR), SZSCAPD_SEX VARCHAR2(1 CHAR), SZSCAPD_PREF_NAME VARCHAR2(25 CHAR), SZSCAPD_SSN VARCHAR2(9 CHAR), SZSCAPD_MAJOR VARCHAR2(90 CHAR), SZSCAPD_MAJOR2 VARCHAR2(90 CHAR), SZSCAPD_MAJOR3 VARCHAR2(90 CHAR), SZSCAPD_PROFILE_EMAIL VARCHAR2(128 CHAR), SZSCAPD_PERM_ADDRESS1 VARCHAR2(75 CHAR), SZSCAPD_PERM_ADDRESS2 VARCHAR2(75 CHAR), SZSCAPD_PERM_STATE VARCHAR2(2 CHAR), SZSCAPD_PERM_CITY VARCHAR2(30 CHAR), SZSCAPD_PERM_ZIP_CODE VARCHAR2(10 CHAR), SZSCAPD_PERM_COUNTRY VARCHAR2(90 CHAR), SZSCAPD_DIFF_CURR_ADDR_IND VARCHAR2(1 CHAR), SZSCAPD_CURR_ADRESS_FROM_DATE VARCHAR2(10 CHAR), SZSCAPD_CURR_ADRESS_TO_DATE VARCHAR2(10 CHAR), SZSCAPD_CURR_ADDRESS1 VARCHAR2(30 CHAR), SZSCAPD_CURR_ADDRESS2 VARCHAR2(30 CHAR), SZSCAPD_BOARD_SCHOOL_NAME VARCHAR2(50 CHAR), SZSCAPD_CURR_CITY VARCHAR2(20 CHAR), SZSCAPD_CURR_STATE VARCHAR2(2 CHAR), SZSCAPD_CURR_ZIP VARCHAR2(10 CHAR), SZSCAPD_CURR_COUNTRY VARCHAR2(90 CHAR), SZSCAPD_PREFERRED_PHONE_IND VARCHAR2(10 CHAR), SZSCAPD_HOME_AREA_CODE VARCHAR2(6 CHAR), SZSCAPD_HOME_PHONE VARCHAR2(20 CHAR), SZSCAPD_CELL_AREA_CODE VARCHAR2(6 CHAR), SZSCAPD_CELL_PHONE VARCHAR2(20 CHAR), SZSCAPD_VISA_TYPE VARCHAR2(3 CHAR), SZSCAPD_BIRTH_STATE VARCHAR2(2 CHAR), SZSCAPD_BIRTH_COUNTRY VARCHAR2(30 CHAR), SZSCAPD_BIRTH_CITY VARCHAR2(40 CHAR), SZSCAPD_FIRST_LANGUAGE VARCHAR2(3 CHAR), SZSCAPD_CITIZ_STATUS VARCHAR2(1 CHAR), SZSCAPD_MARITAL_STATUS VARCHAR2(1 CHAR), SZSCAPD_US_VETERAN VARCHAR2(3 CHAR), SZSCAPD_HISPANIC_OR_LATINO_IND VARCHAR2(3 CHAR), SZSCAPD_HISP_OR_LATINO_OPT VARCHAR2(37 CHAR), SZSCAPD_AMER_INDIAN_ALASKA_OPT VARCHAR2(30 CHAR), SZSCAPD_ARE_YOU_ENROLLED VARCHAR2(1 CHAR), SZSCAPD_NUMBER VARCHAR2(50 CHAR), SZSCAPD_ASIAN_OPTIONS VARCHAR2(39 CHAR), SZSCAPD_OTHER_EAST_ASIAN VARCHAR2(100 CHAR), SZSCAPD_OTHER_SOUTHEAST_ASIA VARCHAR2(100 CHAR), SZSCAPD_OTHER_IND_SUBCONTINENT VARCHAR2(100 CHAR), SZSCAPD_BLACK_AFR_AMER_OPT VARCHAR2(15 CHAR), SZSCAPD_NATIVE_HAWAIIAN_OPT VARCHAR2(15 CHAR), SZSCAPD_WHITE_OPTIONS VARCHAR2(15 CHAR), SZSCAPD_YEARS_IN_COUNTRY VARCHAR2(8 CHAR), SZSCAPD_DUAL_CITZ_CNTRY1 VARCHAR2(90 CHAR), SZSCAPD_DUAL_CITZ_CNTRY2 VARCHAR2(90 CHAR), SZSCAPD_DUAL_CITZ_CNTRY3 VARCHAR2(90 CHAR), SZSCAPD_USPERM_CITZ_CNTRY1 NUMBER, SZSCAPD_USPERM_CITZ_CNTRY2 VARCHAR2(90 CHAR), SZSCAPD_USPERM_CITZ_CNTRY3 VARCHAR2(90 CHAR), SZSCAPD_OTHER_CITZ_CNTRY1 VARCHAR2(90 CHAR), SZSCAPD_OTHER_CITZ_CNTRY2 VARCHAR2(90 CHAR), SZSCAPD_OTHER_CITZ_CNTRY3 VARCHAR2(90 CHAR), SZSCAPD_PAR_MARITAL_STATUS VARCHAR2(13 CHAR), SZSCAPD_PERMANENT_HOME VARCHAR2(23 CHAR), SZSCAPD_PARENT1_TYPE VARCHAR2(14 CHAR), SZSCAPD_PARENT1_TITLE VARCHAR2(8 CHAR), SZSCAPD_PARENT1_FIRST_NAME VARCHAR2(24 CHAR), SZSCAPD_PARENT1_LAST_NAME VARCHAR2(24 CHAR), SZSCAPD_PARENT1_ALIVE_IND VARCHAR2(1 CHAR), SZSCAPD_PARENT1_SAME_ADDR_IND VARCHAR2(1 CHAR), SZSCAPD_PARENT1_ADDRESS_1 VARCHAR2(30 CHAR), SZSCAPD_PARENT1_ADDRESS_2 VARCHAR2(30 CHAR), SZSCAPD_PARENT1_CITY VARCHAR2(26 CHAR), SZSCAPD_PARENT1_STATE VARCHAR2(20 CHAR), SZSCAPD_PARENT1_COUNTRY VARCHAR2(30 CHAR), SZSCAPD_PARENT1_ZIPCODE VARCHAR2(10 CHAR), SZSCAPD_PARENT1_PHONE_TYPE VARCHAR2(4 CHAR), SZSCAPD_PARENT1_AREA_CODE VARCHAR2(4 CHAR), SZSCAPD_PARENT1_PHONE VARCHAR2(25 CHAR), SZSCAPD_PARENT1_EMAIL VARCHAR2(50 CHAR), SZSCAPD_PARENT1_OCCUPATION VARCHAR2(110 CHAR), SZSCAPD_PARENT1_OCCUP_CODE VARCHAR2(20 CHAR), SZSCAPD_PARENT1_POSITION_TITLE VARCHAR2(40 CHAR), SZSCAPD_PARENT1_CNTRY_OF_BIRTH VARCHAR2(40 CHAR), SZSCAPD_PARENT1_EMPLOYER VARCHAR2(45 CHAR), SZSCAPD_PARENT1_COLLEGE VARCHAR2(50 CHAR), SZSCAPD_PARENT1_DEGREE VARCHAR2(20 CHAR), SZSCAPD_PARENT1_CEEB_CODES VARCHAR2(6 CHAR), SZSCAPD_PARENT2_TYPE VARCHAR2(14 CHAR), SZSCAPD_PARENT2_TITLE VARCHAR2(8 CHAR), SZSCAPD_PARENT2_FIRST_NAME VARCHAR2(24 CHAR), SZSCAPD_PARENT2_LAST_NAME VARCHAR2(24 CHAR), SZSCAPD_PARENT2_ALIVE_IND VARCHAR2(1 CHAR), SZSCAPD_PARENT2_SAME_ADDR_IND VARCHAR2(1 CHAR), SZSCAPD_PARENT2_ADDRESS_1 VARCHAR2(30 CHAR), SZSCAPD_PARENT2_ADDRESS_2 VARCHAR2(30 CHAR), SZSCAPD_PARENT2_CITY VARCHAR2(26 CHAR), SZSCAPD_PARENT2_STATE VARCHAR2(20 CHAR), SZSCAPD_PARENT2_COUNTRY VARCHAR2(30 CHAR), SZSCAPD_PARENT2_ZIPCODE VARCHAR2(10 CHAR), SZSCAPD_PARENT2_PHONE_TYPE VARCHAR2(4 CHAR), SZSCAPD_PARENT2_AREA_CODE VARCHAR2(4 CHAR), SZSCAPD_PARENT2_PHONE VARCHAR2(25 CHAR), SZSCAPD_PARENT2_EMAIL VARCHAR2(50 CHAR), SZSCAPD_PARENT2_OCCUPATION VARCHAR2(110 CHAR), SZSCAPD_PARENT2_OCCUP_CODE VARCHAR2(20 CHAR), SZSCAPD_PARENT2_POSITION_TITLE VARCHAR2(40 CHAR), SZSCAPD_PARENT2_CNTRY_OF_BIRTH VARCHAR2(40 CHAR), SZSCAPD_PARENT2_EMPLOYER VARCHAR2(45 CHAR), SZSCAPD_PARENT2_COLLEGE VARCHAR2(50 CHAR), SZSCAPD_PARENT2_CEEB_CODES VARCHAR2(9 CHAR), SZSCAPD_PARENT2_DEGREE VARCHAR2(20 CHAR), SZSCAPD_LEGAL_GUARD_TITLE VARCHAR2(4 CHAR), SZSCAPD_LEGAL_GUARD_LAST_NAME VARCHAR2(24 CHAR), SZSCAPD_LEGAL_GUARD_FIRST_NAME VARCHAR2(24 CHAR), SZSCAPD_LEGAL_GUARD_MI_NAME VARCHAR2(2 CHAR), SZSCAPD_LEGAL_GUARD_POSITION VARCHAR2(40 CHAR), SZSCAPD_LEGAL_SAME_ADRESS_IND VARCHAR2(27 CHAR), SZSCAPD_LEGAL_GUARD_RELATION VARCHAR2(50 CHAR), SZSCAPD_LEGAL_GUARD_ADDR_1 VARCHAR2(30 CHAR), SZSCAPD_LEGAL_GUARD_ADDR_2 VARCHAR2(30 CHAR), SZSCAPD_LEGAL_GUARD_CITY VARCHAR2(20 CHAR), SZSCAPD_LEGAL_GUARD_STATE VARCHAR2(2 CHAR), SZSCAPD_LEGAL_GUARD_POSTCODE VARCHAR2(10 CHAR), SZSCAPD_LEGAL_GUARD_COUNTRY VARCHAR2(90 CHAR), SZSCAPD_LEGAL_GUARD_PHONE_TYPE VARCHAR2(4 CHAR), SZSCAPD_LEGAL_GUARD_AREA_CODE VARCHAR2(10 CHAR), SZSCAPD_LEGAL_GUARD_PHONE VARCHAR2(25 CHAR), SZSCAPD_LEGAL_GUARD_EMAIL VARCHAR2(50 CHAR), SZSCAPD_LEGAL_GUARD_OCUP_CODE VARCHAR2(20 CHAR), SZSCAPD_LEGAL_GUARD_EMPLOYEER VARCHAR2(45 CHAR), SZSCAPD_LEGAL_GUAR_CEEB VARCHAR2(6 CHAR), SZSCAPD_LEGAL_GUARD_COLLEGE VARCHAR2(50 CHAR), SZSCAPD_LEGAL_GUARD_DEGREE VARCHAR2(20 CHAR), SZSCAPD_LEGAL_GUARD_YEAR VARCHAR2(4 CHAR), SZSCAPD_PREV_ADM_CANDIDATE_IND VARCHAR2(1 CHAR), SZSCAPD_PREV_ADM_YEAR VARCHAR2(4 CHAR), SZSCAPD_EARLY_ADM_SUB_DATE VARCHAR2(10 CHAR), SZSCAPD_SEC_SCHOOL_NAME VARCHAR2(50 CHAR), SZSCAPD_SEC_SCHOOL_CEEB VARCHAR2(6 CHAR), SZSCAPD_SEC_SCHOOL_ADDRESS1 VARCHAR2(30 CHAR), SZSCAPD_SEC_SCHOOL_ADDRESS2 VARCHAR2(30 CHAR), SZSCAPD_SEC_SCHOOL_CITY VARCHAR2(50 CHAR), SZSCAPD_SEC_SCHOOL_STATE VARCHAR2(30 CHAR), SZSCAPD_SEC_SCHOOL_ZIP VARCHAR2(10 CHAR), SZSCAPD_SEC_SCHOOL_COUNTRY VARCHAR2(90 CHAR), SZSCAPD_SEC_SCHOOL_ENTRY_DATE VARCHAR2(10 CHAR), SZSCAPD_SEC_SCHOOL_GRAD_DATE VARCHAR2(10 CHAR), SZSCAPD_SEC_SCHOOL_TYPE VARCHAR2(13 CHAR), SZSCAPD_OTHER_SCHOOL_CEEB VARCHAR2(6 CHAR), SZSCAPD_OTHER_SCHOOL_NAME VARCHAR2(50 CHAR), SZSCAPD_OTHER_SCHOOL_LOCATION VARCHAR2(50 CHAR), SZSCAPD_OTHER_SCHOOL_FROM_DATE VARCHAR2(50 CHAR), SZSCAPD_OTHER_SCHOOL_TO_DATE VARCHAR2(50 CHAR), SZSCAPD_GRADUATED_IND VARCHAR2(1 CHAR), SZSCAPD_GRADUATED_EARLY_IND VARCHAR2(1 CHAR), SZSCAPD_WILL_RECEIVE_GED_IND VARCHAR2(1 CHAR), SZSCAPD_GRADUATED_LATE_IND VARCHAR2(1 CHAR), SZSCAPD_DISC_ACTION_IND VARCHAR2(1 CHAR), SZSCAPD_CONVITED_FELONY VARCHAR2(1 CHAR), SZSCAPD_AP_TEST1_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST1_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST1_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST1_SCORE NUMBER, SZSCAPD_AP_TEST2_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST2_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST2_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST2_SCORE NUMBER, SZSCAPD_AP_TEST3_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST3_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST3_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST3_SCORE NUMBER, SZSCAPD_AP_TEST4_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST4_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST4_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST4_SCORE NUMBER, SZSCAPD_AP_TEST5_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST5_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST5_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST5_SCORE NUMBER, SZSCAPD_AP_TEST6_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST6_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST6_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST6_SCORE NUMBER, SZSCAPD_AP_TEST7_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST7_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST7_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST7_SCORE NUMBER, SZSCAPD_AP_TEST8_DATE VARCHAR2(7 CHAR), SZSCAPD_AP_TEST8_TYPE VARCHAR2(11 CHAR), SZSCAPD_AP_TEST8_SUBJ VARCHAR2(36 CHAR), SZSCAPD_AP_TEST8_SCORE NUMBER, SZSCAPD_ACTIVITY_ACT1 VARCHAR2(34 CHAR), SZSCAPD_POSITION_ACT1 VARCHAR2(100 CHAR), SZSCAPD_GRADE_LEVL_ACT1 VARCHAR2(35 CHAR), SZSCAPD_GRADE_HOURS_ACT1 VARCHAR2(30 CHAR), SZSCAPD_GRADE_WEEKS_ACT1 VARCHAR2(2 CHAR), SZSCAPD_PARTICIPATE_ACT1 VARCHAR2(45 CHAR), SZSCAPD_CONTINUE_ACT1 VARCHAR2(40 CHAR), SZSCAPD_DESCRIPTION_ACT1 VARCHAR2(100 CHAR), SZSCAPD_ACTIVITY_ACT2 VARCHAR2(34 CHAR), SZSCAPD_POSITION_ACT2 VARCHAR2(100 CHAR), SZSCAPD_GRADE_LEVL_ACT2 VARCHAR2(35 CHAR), SZSCAPD_GRADE_HOURS_ACT2 VARCHAR2(40 CHAR), SZSCAPD_GRADE_WEEKS_ACT2 VARCHAR2(2 CHAR), SZSCAPD_PARTICIPATE_ACT2 VARCHAR2(45 CHAR), SZSCAPD_CONTINUE_ACT2 VARCHAR2(40 CHAR), SZSCAPD_DESCRIPTION_ACT2 VARCHAR2(100 CHAR), SZSCAPD_ACTIVITY_ACT3 VARCHAR2(34 CHAR), SZSCAPD_POSITION_ACT3 VARCHAR2(100 CHAR), SZSCAPD_GRADE_LEVL_ACT3 VARCHAR2(35 CHAR), SZSCAPD_GRADE_HOURS_ACT3 VARCHAR2(40 CHAR), SZSCAPD_GRADE_WEEKS_ACT3 VARCHAR2(2 CHAR), SZSCAPD_PARTICIPATE_ACT3 VARCHAR2(45 CHAR), SZSCAPD_CONTINUE_ACT3 VARCHAR2(40 CHAR), SZSCAPD_DESCRIPTION_ACT3 VARCHAR2(100 CHAR), SZSCAPD_ED_SIGN_DATE VARCHAR2(50 CHAR), SZSCAPD_APPL_SIGNATURE VARCHAR2(50 CHAR), SZSCAPD_EARLY_DEC_SUB_DATE VARCHAR2(24 CHAR), SZSCAPD_ACTIVITY_DATE VARCHAR2(11 CHAR) )