/*
Created	9/4/2006
Modified	7/23/2008
Project	univdb2 Submission
Model		Input File Layout
Company	BOG
Author	IRM
Version	Release 1.1
Database	Oracle 10g 
*/

/* Owner of univdb2  */

Drop table univdb2.Person_ID_Chgs CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Univ_Dept_Master CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Campus CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Operating_Budget CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Employee_Vacants CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Employee_Data CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Employee_Demo CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Workload_Activities CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Workload_Activity_Summary CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Workload_Person_Funding CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Rooms CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Buildings CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Sites CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Course_Meetings CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Instructional_Activity CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Financial_Aid_Awards CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Financial_Aid_Demo CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Courses_to_Degree CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Hours_to_Degree CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Degrees_Awarded CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Fee_Waivers CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Stipends CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Fellowships CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Test_Credits CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Courses_Taken CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Enrollments CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.College_Prep CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.DOE_Pgm_Info CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Tests_Reqs CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Admission_Exceptions CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Applicants_Admits CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Person_Demo CASCADE CONSTRAINTS PURGE
;
Drop table univdb2.Expenditure_Analysis_Extract CASCADE CONSTRAINTS PURGE
;
*/

-- Create Tables section


Create table univdb2.Person_Demo (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
      PID_VALID_SSN Varchar2 (1) NOT NULL ,
	DT_BIRTH_YYYYMMDD Varchar2 (10),
	NAME_LAST Varchar2 (22),
	NAME_FIRST Varchar2 (14),
	NAME_MI Varchar2 (1),
	SUFFIX Varchar2 (10),
	GENDER Varchar2 (1),
	RACE_ETHNICITY Varchar2 (1),
	HISPANIC_FLG Varchar2 (1),
	AM_IND_ALASKAN_FLG Varchar2 (1),
	ASIAN_FLG Varchar2 (1),
	BLACK_AFRICAN_AM_FLG Varchar2 (1),
	NAT_HAWAII_PAC_IS_FLG Varchar2 (1),
	WHITE_FLG Varchar2 (1),
	NON_RES_ALIEN_FLG Varchar2 (1),
	NO_RACE_REPORT_FLG Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;
Create table univdb2.Applicants_Admits (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	APP_ADM_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	CIP_APP_ADM Varchar2 (6) NOT NULL ,
	STU_TYP Varchar2 (1) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	FINAL_ADM_ACTION Varchar2 (1),
	REGISTERED_CD Varchar2 (1),
	COUNTY_OF_RES Varchar2 (4),
	FEE_CLASS_RES Varchar2 (1),
	ADM_DEPOSIT_IND Varchar2 (1),
	STU_CLASS_LEVEL Varchar2 (1),
	DISPLACED_STU_IND Varchar2 (1),
	LAST_INST_CD Varchar2 (8),
	INST_GRNT_HIDEG_CD Varchar2 (8),
	DEG_HIGHEST_HELD Varchar2 (1),
	LAST_POSTSEC_DT Varchar2 (6),
	GPA_COLLEGE Number(3,2),
	HS_ETS_CD Varchar2 (6),
	LAST_SECONDARY_DT Varchar2 (6),
	GPA_HIGH_SCHOOL Number(3,2),
	GPA_GED_COMPONENT Number(3,2),
	GPA_BACHELORS Number(3,2),
	ESOL_UNITS Number(2,1),
	DEPOSIT_AMT Number(4,0),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50),
	U_RESV_3 Varchar2 (50)
) 
;

Create table univdb2.Admission_Exceptions (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	EXCEPTION_SOURCE Varchar2 (8) NOT NULL ,
	CIP_APP_ADM Varchar2 (6) NOT NULL ,
	STU_TYP Varchar2 (1) NOT NULL ,
	EXCEPTION_TYP Varchar2 (1) NOT NULL ,
	EXCEPTION_CAT Varchar2 (1) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Tests_Reqs (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	APP_ADM_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	CIP_APP_ADM Varchar2 (6) NOT NULL ,
	STU_TYP Varchar2 (1) NOT NULL ,
	TCHR_PREP_DOE_CD Varchar2 (3) NOT NULL ,
	TEST_REQ_CD Varchar2 (2) NOT NULL ,
	TEST_SCORE_TYP Varchar2 (2) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	TEST_SCORE_N Number(6,2),
	TEST_SCORE_A Varchar2 (4),
	REQ_MET Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.DOE_Pgm_Info (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	APP_ADM_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	CIP_APP_ADM Varchar2 (6) NOT NULL ,
	STU_TYP Varchar2 (1) NOT NULL ,
	TCHR_PREP_DOE_CD Varchar2 (3) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	TCHR_PREP_DOE_LEVEL Varchar2 (1),
	TCHR_REG_CD Varchar2 (1),
	TCHR_TERM_ADMIT Varchar2 (6),
	TCHR_EDU_PGM_METHOD Varchar2 (1),
	CIP_DEGREE Varchar2 (6),
	SEC_SITE Number(1,0),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.College_Prep (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	CP_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	REMEDIATION_AREA Varchar2 (1) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	REMEDIATION_TEST Varchar2 (1),
	TERM_RESULT_RPTD Varchar2 (8),
	REMEDIATION_COMP Varchar2 (1),
	COMM_COLL_CD Varchar2 (8),
	CRS_PREFIX Varchar2 (3),
	CRS_NBR Varchar2 (4),
	CRS_IND Varchar2 (1),
	REMEDIATION_INCOMP Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Enrollments (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	NATION_CITIZ Varchar2 (2),
	STATE_ADM Varchar2 (2),
	COUNTY_OF_RES Varchar2 (4),
	NAT_MERIT_SCH_IND Varchar2 (1),
	DISPLACED_STU_IND Varchar2 (1),
	INST_DISPLACED_FROM Varchar2 (8),
	HS_ETS_CD Varchar2 (6),
	LAST_SECONDARY_DT Varchar2 (6),
	DUAL_ENROLL_IND Varchar2 (1),
	LAST_INST_CD Varchar2 (8),
	LAST_POSTSEC_DT Varchar2 (6),
	STU_ENTRY_TYP Varchar2 (1),
	STU_ENTRY_DT Varchar2 (6),
	STU_RECENT_ADM_TYP Varchar2 (1),
	STU_RECENT_ADM_DT Varchar2 (6),
	FIRST_GEN_IND Varchar2 (1),
	FEE_CLASS_RES Varchar2 (1),
	CLAST_IND Varchar2 (1),
	MAX_CRED_TEACH_FLG Varchar2 (1),
	MAX_CRED_RESEARCH_FLG Varchar2 (1),
	DOC_CANDIDACY_FLG Varchar2 (1),
	STU_CLASS_LEVEL Varchar2 (1),
	CIP_STUDENT Varchar2 (6),
	DEG_HIGHEST_HELD Varchar2 (1),
	INST_GRNT_HIDEG_CD Varchar2 (8),
	DEG_LEVEL_SOUGHT Varchar2 (1),
	DOC_CLASS Varchar2 (1),
	BE_CD Varchar2 (1),
	FIRSTYR_FIRSTPROF_FLG Varchar2 (1),
	TERMINATION_CD Varchar2 (1),
	EXT_PGM_FLG Varchar2 (1),
	VISA_TYP Varchar2 (3),
	INST_CLASS_LVL_STU Varchar2 (1),
	FULL_PART_TIME_IND Varchar2 (1),
	CURR_TERM_CRS_LOAD Number(3,1),
	CUM_HRS_ACCEPT_TRN Number(4,1),
	GPA_INST_HRS Number(4,1),
	GPA_INST_GRD_PTS Number(5,1),
	TOT_HRS_DEG_LVL Number(4,1),
	GPA_TERM_CRED_HRS Number(3,1),
	GPA_TERM_HRS Number(3,1),
	GPA_TERM_GRD_PTS Number(4,1),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50)
) 
;

Create table univdb2.Courses_Taken (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	SEGMENT_SEQ Number(2,0) NOT NULL ,
	CRS_PREFIX Varchar2 (3) NOT NULL ,
	CRS_NBR Varchar2 (4) NOT NULL ,
	CRS_IND Varchar2 (1) Default ' ' NOT NULL ,
	CRS_SECTN_NBR Varchar2 (6) NOT NULL ,
	STU_SECTN_CRED Number(3,1),
	CIP_CRS Varchar2 (6),
	CAMPUS_CD Varchar2 (4),
	SITE_NBR Varchar2 (4),
	CRS_SECTN_LOC_CNTY Varchar2 (4),
	BE_CD Varchar2 (1),
	CONT_COOP_ED_IND Varchar2 (1),
	GRADE_AWARDED Varchar2 (2),
	STU_SECTN_FUND_CD Varchar2 (1),
	COLLEGE Varchar2 (2),
	CRS_SECTN_TYP_PRI Varchar2 (1),
	PRELIM_FILE_FLG Varchar2 (1),
	INST_OUTSIDE_IND Varchar2 (2),
	DEPT_ID_CRS Varchar2 (9),
	DIFF_TUITION_FLG Varchar2 (1),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50),
  	ST_FUND_CRED_HRS Number(3,1)
) 
;

Create table univdb2.Test_Credits (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	TEST_TYP Varchar2 (20) NOT NULL ,
	TEST_CREDS Number(3,1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Fellowships (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	SEGMENT_SEQ Number(2,0) NOT NULL ,
	BE_CD Varchar2 (1),
	TERM_AMOUNT Number(6,0),
	UNIV_FUND_ID Varchar2 (6),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Stipends (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	SEGMENT_SEQ Number(2,0) NOT NULL ,
	BE_CD Varchar2 (1),
	TERM_AMOUNT Number(6,0),
	UNIV_FUND_ID Varchar2 (6),
	FTE_TERM_PORTION Number(3,2),
	HRLY_PAY_RATE Number(4,2),
	SESSION_ID Varchar2 (1),
	CLASS_CD Varchar2 (4),
	CIP_ACCT_DEPT Varchar2 (6),
	NBR_HRS_WRK_TERM Number(3,0),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Fee_Waivers (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	SEGMENT_SEQ Number(2,0) NOT NULL ,
	FEE_WAIVER_IND Varchar2 (1),
	FEE_WAIVER_KIND Varchar2 (2),
	BE_CD Varchar2 (1),
	TERM_AMOUNT Number(6,0),
	UNIV_FUND_ID Varchar2 (6),
	LINK_INST Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Degrees_Awarded (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	FEE_CLASS_KIND Varchar2 (1) NOT NULL ,
	TERM_DEG_GRANT Varchar2 (6) NOT NULL ,
	DEG_LEVEL_GRANT Varchar2 (1) NOT NULL ,
	CIP_DEGREE Varchar2 (6) NOT NULL ,
	MAJOR_IND Number(1,0) NOT NULL ,
	TCHR_PREP_DOE_CD Varchar2 (3) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	AWARD_SOURCE Varchar2 (4) NOT NULL ,
	TCHR_PREP_DOE_LEVEL Varchar2 (1),
	TCHR_EDU_PGM_METHOD Varchar2 (1),
	CIP_FRAC_DEG Number(3,2),
	DOC_CLASS Varchar2 (1),
	BE_CD Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Hours_to_Degree (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	TERM_DEG_GRANT Varchar2 (6) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	CIP_DEGREE Varchar2 (6),
	HS_GRAD_DT Date,
	CATALOG_TERM Varchar2 (6),
	CATALOG_HRS Varchar2 (3),
	NBR_CIP_CHGS Number(2,0),
	TERM_UPPER Varchar2 (6),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50),
	U_RESV_3 Varchar2 (50),
	U_RESV_4 Varchar2 (50)
) 
;

Create table univdb2.Courses_to_Degree (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	TERM_DEG_GRANT Varchar2 (6) NOT NULL ,
	DEG_LEVEL_GRANT Varchar2 (1) NOT NULL ,
	TERM_TAKEN Varchar2 (6) NOT NULL ,
	CRS_INST_CD Varchar2 (8) NOT NULL ,
	CRS_PREFIX Varchar2 (3) NOT NULL ,
	CRS_NBR Varchar2 (4) NOT NULL ,
	CRS_IND Varchar2 (1) NOT NULL ,
	CRS_SECTN_NBR Varchar2 (6) NOT NULL ,
	SEGMENT_SEQ Number(2,0) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	STU_CLASS_LEVEL Varchar2 (1),
	CRS_SYSTEM Varchar2 (1),
	CRS_GROUP Varchar2 (1),
	CRS_RESULT Varchar2 (1),
	REPEAT_IND Varchar2 (1),
	CIP_CRS Varchar2 (6),
	CRS_SECTN_TYP Varchar2 (1),
	TEST_METHOD Varchar2 (2),
	GRADE_AWARDED Varchar2 (2),
	USAGE_IND Varchar2 (1),
	SECTN_CRED Number(4,2),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50)
) 
;

Create table univdb2.Financial_Aid_Demo (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	CURR_DEPEND_STAT Varchar2 (1),
	FAMILY_INCOME Number(7,0),
	FAMILY_CONTRIB Number(7,0),
	FEE_CLASS_RES Varchar2 (1),
	STU_ENTRY_TYP Varchar2 (1),
	STU_CLASS_LEVEL Varchar2 (1),
	CIP_STUDENT Varchar2 (6),
	FINAID_NEED Number(7,0),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50)
) 
;

Create table univdb2.Financial_Aid_Awards (
	UNIV_ROW_ID Varchar2 (8),
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	AWARD_PAYMENT_TERM Varchar2 (8) NOT NULL ,
	AWARD_PROG_ID Varchar2 (3) NOT NULL ,
	AWARD_COND_ID Varchar2 (1) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SOURCE_FUNDS Varchar2 (1),
	TERM_AMOUNT Number(9,2),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Instructional_Activity (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	SESSION_ID Varchar2 (1) NOT NULL ,
	CRS_PREFIX Varchar2 (3) NOT NULL ,
	CRS_NBR Varchar2 (4) NOT NULL ,
	CRS_IND Varchar2 (1) Default ' ' NOT NULL ,
	CRS_SECTN_NBR Varchar2 (6) NOT NULL ,
	CRS_SECTN_TYP_PRI Varchar2 (1),
	VAR_CRED_FLG Varchar2 (1),
	CIP_CRS Varchar2 (6),
	BE_CD_CRS Varchar2 (1),
	DEPT_ID_CRS Varchar2 (9),
	SECTN_ENROLL_CRED Number(4,0),
	CRS_CRED_HRS Number(3,1),
	ACT_SECTN_INSTR_HRS Number(5,2),
	DELIVERY_IND Varchar2 (1),
	TECH_IND_PRIMARY Varchar2 (1),
	TECH_IND_SECONDARY Varchar2 (1),
	TECH_IND_TERTIARY Varchar2 (1),
	COUNTRY_CD Varchar2 (2),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50),
	DLF_CHARGED Varchar2 (1)
) 
;

Create table univdb2.Course_Meetings (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	SESSION_ID Varchar2 (1) NOT NULL ,
	CRS_PREFIX Varchar2 (3) NOT NULL ,
	CRS_NBR Varchar2 (4) NOT NULL ,
	CRS_IND Varchar2 (1) Default ' ' NOT NULL ,
	CRS_SECTN_NBR Varchar2 (6) NOT NULL ,
	CRS_SECTN_BEG_TIME Varchar2 (4) NOT NULL ,
	CRS_SECTN_END_TIME Varchar2 (4) NOT NULL ,
	SUNDAY Number(1,0) Default 0 NOT NULL ,
	MONDAY Number(1,0) Default 0 NOT NULL ,
	TUESDAY Number(1,0) Default 0 NOT NULL ,
	WEDNESDAY Number(1,0) Default 0 NOT NULL ,
	THURSDAY Number(1,0) Default 0 NOT NULL ,
	FRIDAY Number(1,0) Default 0 NOT NULL ,
	SATURDAY Number(1,0) Default 0 NOT NULL ,
	BLDG_NBR Varchar2 (4) Default ' ' NOT NULL ,
	ROOM_NBR_PREFIX Varchar2 (2) Default ' ' NOT NULL ,
	ROOM_NBR_DIGITS Varchar2 (10) Default ' ' NOT NULL ,
	ROOM_NBR_SUFFIX Varchar2 (1) Default ' ' NOT NULL ,
	UNSCHED_MTG_IND Varchar2 (1),
	CRS_SECTN_TYP Varchar2 (1),
	CAMPUS_CD Varchar2 (4),
	SITE_NBR Varchar2 (4),
	CRS_SECTN_LOC_CNTY Varchar2 (4),
	ZIP Varchar2 (9),
	NBR_WKS_MET Number(2,0),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Sites (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	CAMPUS_CD Varchar2 (4) NOT NULL ,
	BASE_YR Varchar2 (8) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	SITE_NBR Varchar2 (4) NOT NULL ,
	NAME Varchar2 (15),
	STREET_ADDR Varchar2 (20),
	CITY_LOC Varchar2 (15),
	ZIP Varchar2 (9),
	ACRES Number(6,1),
	OWNERSHIP Varchar2 (1),
	USAGE Varchar2 (2),
	ACQUIS_YR Number(4,0),
	PARKING Number(8,0),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50)
) 
;

Create table univdb2.Buildings (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	CAMPUS_CD Varchar2 (4) NOT NULL ,
	BASE_YR Varchar2 (8) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	SITE_NBR Varchar2 (4) NOT NULL ,
	BLDG_NBR Varchar2 (4) NOT NULL ,
	NAME Varchar2 (30),
	OWNERSHIP Varchar2 (1),
	STATUS Varchar2 (1),
	STRUCTURE Varchar2 (1),
	EXTERIOR Varchar2 (1),
	CONDITION_BLDG Varchar2 (1),
	STU_RES_HOUS_FLG Varchar2 (1),
	JOINT_USE_IND Varchar2 (1),
	CONSTRUCT_YR Number(4,0),
	OCCUPY_DT Varchar2 (6),
	ALTER_YR Number(4,0),
	SURVEY_YR Number(4,0),
	GSF Number(7,0),
	BE_CD_BLDG Varchar2 (1),
	ENV_COND Varchar2 (1),
	ROOF_COND Varchar2 (1),
	MECH_COND Varchar2 (1),
	ELEC_COND Varchar2 (1),
	PLMB_COND Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Rooms (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	CAMPUS_CD Varchar2 (4) NOT NULL ,
	BASE_YR Varchar2 (8) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	SITE_NBR Varchar2 (4) NOT NULL ,
	BLDG_NBR Varchar2 (4) NOT NULL ,
	ROOM_NBR_PREFIX Varchar2 (2) NOT NULL ,
	ROOM_NBR_DIGITS Varchar2 (10) NOT NULL ,
	ROOM_NBR_SUFFIX Varchar2 (1) NOT NULL ,
	FLOOR_LEVEL Varchar2 (2) NOT NULL ,
	PRORATION Varchar2 (1) NOT NULL ,
	NAME Varchar2 (50),
	USE_CD Varchar2 (3),
	CATEGORY Varchar2 (6),
	CAPACITY_ACTUAL Number(5,0),
	CAPACITY_DESIGN Number(5,0),
	CONDITION_ROOM Varchar2 (1),
	PCS_PROG Varchar2 (2),
	SHARED_USE Varchar2 (1),
	NEEDS_GEN_ELIG Varchar2 (1),
	NET_AREA Number(7,0),
	BE_CD_POM Varchar2 (1),
	BE_CD_USER Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Workload_Person_Funding (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	BE_CD_EMPL Varchar2 (1) NOT NULL ,
	PAY_PLAN_NBR Varchar2 (2) NOT NULL ,
	UNIV_POSITION Varchar2 (8) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID Varchar2 (10) NOT NULL ,
	CLASS_CD Varchar2 (4),
	RANK_FAC Varchar2 (2),
	ADMIN_CD_PRI Varchar2 (2),
	INSTRCT_RESRCH_FTE Number(5,4),
	BUD_WKS_TERM Number(4,2),
	PERYRS_TERM Number(5,4),
	TERM_AMT_REQ_BENE Number(6,0),
	DEPT_EMP_PROG_COMP Varchar2 (6),
	EMPL_CONTACT_HRS Number(7,4),
	CIP_EMP Varchar2 (6),
	OCC_ACT_CAT_EEO6 Varchar2 (1),
	TENURE_STAT Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Workload_Activity_Summary (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	BE_CD_EMPL Varchar2 (1) NOT NULL ,
	PAY_PLAN_NBR Varchar2 (2) NOT NULL ,
	UNIV_POSITION Varchar2 (8) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID_ACT Varchar2 (10) NOT NULL ,
	BE_CD_ACT Varchar2 (1) NOT NULL ,
	CIP_CRS Varchar2 (6) NOT NULL ,
	CRS_SECTN_TYP_PRI Varchar2 (1) NOT NULL ,
	COLLEGE Varchar2 (2) NOT NULL ,
	PROG_COMP_ACT Varchar2 (6) NOT NULL ,
	INSTR_RESRCH_ACT Varchar2 (2) NOT NULL ,
	PERYRS_ACT_PORT Number(5,4),
	FTE_ACT_PORTION Number(5,4),
	U_RESV_1 Varchar2 (50)
) 
TABLESPACE WORKLOAD_ACTIVITY_SUMMARY
;

Create table univdb2.Workload_Activities (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	BE_CD_EMPL Varchar2 (1) NOT NULL ,
	PAY_PLAN_NBR Varchar2 (2) NOT NULL ,
	UNIV_POSITION Varchar2 (8) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID Varchar2 (10) NOT NULL ,
	BE_CD_ACT Varchar2 (1) NOT NULL ,
	COLLEGE Varchar2 (2) NOT NULL ,
	PROG_COMP_ACT Varchar2 (6) NOT NULL ,
	INSTR_RESRCH_ACT Varchar2 (2) NOT NULL ,
	CRS_SECTN_TYP_PRI Varchar2 (1) NOT NULL ,
	CIP_CRS Varchar2 (6) NOT NULL ,
	DEPT_ID_ACT Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID_ACT Varchar2 (6) NOT NULL ,
	CRS_PREFIX Varchar2 (3) NOT NULL ,
	CRS_NBR Varchar2 (4) NOT NULL ,
	CRS_IND Varchar2 (1) NOT NULL ,
	CRS_SECTN_NBR Varchar2 (6) NOT NULL ,
	SESSION_ID Varchar2 (1),
	VAR_CRED_FLG Varchar2 (1),
	CRS_CRED_HRS Number(3,1),
	INSTR_TOT_SCH Number(6,1),
	INSTR_FND_SCH Number(6,1),
	PORT_SECTN_WKLD Number(4,3),
	PERYRS_ACT_PORT Number(5,4),
	FTE_ACT_PORTION Number(5,4),
	CONTACT_HRS Number(7,4),
	CONTACT_HRS_MOD Number(7,4),
	U_RESV_1 Varchar2 (50),
	U_RESV_2 Varchar2 (50)
) 
;

Create table univdb2.Employee_Demo (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	SUB_TYP Varchar2 (10) NOT NULL ,
	HLTH_INS_OPT_CD Varchar2 (2),
	HLTH_INS_PROV_CD Varchar2 (3),
	LIFE_INS_PART_CD Varchar2 (1),
	RETIRE_CD_EMP Varchar2 (2),
	CONT_ST_SVC_DT Date,
	AGENCY_HIRE_DT Date,
	RANK_FAC Varchar2 (2),
	RANK_FAC_DT Date,
	DEG_HIGHEST_HELD Varchar2 (1),
	DEG_YR_OF_HIGHEST Varchar2 (6),
	TENURE_STAT Varchar2 (1),
	TENURE_STAT_DT Date,
	CIP_TENURE Varchar2 (6),
	OCC_ACT_CAT_EEO6 Varchar2 (1),
	COUNTY_OF_RES Varchar2 (4),
	RESTRICT_ACC_FLG Varchar2 (1),
	SR_MGMT_BFT_FLG Varchar2 (1),
	ANP_FLG Varchar2 (1),
	DROP_ENROLL_DT Date,
	DROP_TERMT_DT Date,
	EMPR_TYP_CD Varchar2 (1),
	CITIZEN Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Employee_Data (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID Varchar2 (9) NOT NULL ,
	SUB_TYP Varchar2 (10) NOT NULL ,
	BE_CD Varchar2 (1) NOT NULL ,
	ST_FUND_TYP Varchar2 (1) NOT NULL ,
	FUND_ID_EMPL_RES Varchar2 (6) NOT NULL ,
	BE_CD8 Varchar2 (8) NOT NULL ,
	IBI Varchar2 (2) NOT NULL ,
	APPROP_CAT Varchar2 (6) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID Varchar2 (10) NOT NULL ,
	PAY_PLAN_NBR Varchar2 (2) NOT NULL ,
	OPS_SEQ Varchar2 (1) NOT NULL ,
	UNIV_POSITION Varchar2 (8) NOT NULL ,
	COUNTY_OF_EMP Varchar2 (4),
	CLASS_CD Varchar2 (4),
	EMPLOYED_CUR_CL_DT Date,
	COLL_BARG_UNIT_CD Varchar2 (4),
	COLL_BARG_UNIT_ELG Varchar2 (1),
	ADMIN_CD_PRI Varchar2 (2),
	CAMPUS_CD Varchar2 (4),
	APPT_STAT_CLASS Varchar2 (1),
	CIP_ACCT_DEPT Varchar2 (6),
	ST_PRO_COMP_CD Varchar2 (10),
	PROG_COMP Varchar2 (6),
	PCS_DEPT_ID Varchar2 (2),
	SALARY_DOLLARS Number(10,2),
	CURR_YR_RATE Number(10,2),
	FTE Number(6,4),
	BUD_WKS_POS Number(4,2),
	COMMIT_TYP Varchar2 (2),
	RATE_TYP Varchar2 (1),
	UT_WORKED Number(5,2),
	CLASS_TITLE Varchar2 (40),
	U_RESV_1 Varchar2 (50)
) 
TABLESPACE EMPLOYEE_DATA
;

Create table univdb2.Employee_Vacants (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SUB_TYP Varchar2 (10) NOT NULL ,
	BE_CD Varchar2 (1) NOT NULL ,
	ST_FUND_TYP Varchar2 (1) NOT NULL ,
	FUND_ID_EMPL_RES Varchar2 (6) NOT NULL ,
	BE_CD8 Varchar2 (8) NOT NULL ,
	IBI Varchar2 (2) NOT NULL ,
	APPROP_CAT Varchar2 (6) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID Varchar2 (10) NOT NULL ,
	PAY_PLAN_NBR Varchar2 (2) NOT NULL ,
	UNIV_POSITION Varchar2 (8) NOT NULL ,
	HLTH_INS_OPT_CD Varchar2 (2),
	LIFE_INS_PART_CD Varchar2 (1),
	RETIRE_CD_EMP Varchar2 (2),
	COUNTY_OF_EMP Varchar2 (4),
	CLASS_CD Varchar2 (4),
	ADMIN_CD_PRI Varchar2 (2),
	CAMPUS_CD Varchar2 (4),
	CIP_ACCT_DEPT Varchar2 (6),
	ST_PRO_COMP_CD Varchar2 (10),
	PROG_COMP Varchar2 (6),
	PCS_DEPT_ID Varchar2 (2),
	SALARY_DOLLARS Number(10,2),
	CURR_YR_RATE Number(10,2),
	FTE Number(6,4),
	BUD_WKS_POS Number(4,2),
	SR_MGMT_BFT_FLG Varchar2 (1),
	ANP_FLG Varchar2 (1),
	EMPR_TYP_CD Varchar2 (1),
	CLASS_TITLE Varchar2 (40),
	U_RESV_1 Varchar2 (50),
	COMMIT_TYP Varchar2 (2)
) 
;

Create table univdb2.Operating_Budget (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	FISCAL_YR Varchar2 (8) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID Varchar2 (10) NOT NULL ,
	BE_CD8 Varchar2 (8) NOT NULL ,
	IBI Varchar2 (2) NOT NULL ,
	ST_PRO_COMP_CD Varchar2 (10) NOT NULL ,
	PROG_COMP Varchar2 (6) NOT NULL ,
	ST_FUND_TYP Varchar2 (1) NOT NULL ,
	UNIV_FUND_ID Varchar2 (6) NOT NULL ,
	APPROP_CAT Varchar2 (6) NOT NULL ,
	OBJECT_CD Varchar2 (6) NOT NULL ,
	PCS_DEPT_ID Varchar2 (2) NOT NULL ,
	GEN_LEDGER_CD Varchar2 (5) NOT NULL ,
	REVENUE_TYP Varchar2 (6) NOT NULL ,
	BE_CD Varchar2 (1),
	EXPENDITURES Number(12,2),
	PERYRS Number(10,4),
	CURR_YR_RATE Number(10,2),
	BUD_YR_ID Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Campus (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	CAMPUS_CD Varchar2 (4) NOT NULL ,
	BASE_YR Varchar2 (8) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	CAMPUS_NAME Varchar2 (50) NOT NULL ,
	ZIP Varchar2 (9)
) 
TABLESPACE CAMPUS
;

Create table univdb2.Univ_Dept_Master (
	UNIV_ROW_ID Varchar2 (8),
	REPT_INST Varchar2 (4) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEPT_ID Varchar2 (9) NOT NULL ,
	UNIV_BUD_ID Varchar2 (10) NOT NULL ,
	DEPT_ID_TITLE Varchar2 (50) NOT NULL 
) 
;

Create table univdb2.Person_ID_Chgs (
	UNIV_ROW_ID Varchar2 (8),
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	PERSON_ID_NEW Varchar2 (9) NOT NULL ,
        PID_VALID_SSN Varchar2 (1) NOT NULL ,
	PERSON_ID_PRV Varchar2 (9) NOT NULL ,
	DT_BIRTH_YYYYMMDD Varchar2 (8),
	NAME_LAST Varchar2 (22),
	NAME_FIRST Varchar2 (14),
	NAME_MI Varchar2 (1),
	SUFFIX Varchar2 (10),
	GENDER Varchar2 (1),
	RACE_ETHNICITY Varchar2 (1),
	HISPANIC_FLG Varchar2 (1),
	AM_IND_ALASKAN_FLG Varchar2 (1),
	ASIAN_FLG Varchar2 (1),
	BLACK_AFRICAN_AM_FLG Varchar2 (1),
	NAT_HAWAII_PAC_IS_FLG Varchar2 (1),
	WHITE_FLG Varchar2 (1),
	NON_RES_ALIEN_FLG Varchar2 (1),
	NO_RACE_REPORT_FLG Varchar2 (1),
	U_RESV_1 Varchar2 (50)
) 
;

Create table univdb2.Expenditure_Analysis_Extract (
	UNIV_ROW_ID Varchar2 (8),
	EA_DATA_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	YR_FISCAL Varchar2 (4) NOT NULL ,
	BE_CD8 Varchar2 (8),
	COST_ACT Varchar2 (2),
	COLLEGE Varchar2 (2),
	DEPT_ID_ACT Varchar2 (9),
	INSTR_RESRCH_ACT Varchar2 (2),
	APPROP_CAT Varchar2 (6),
	OBJECT_CD Varchar2 (6),
	INSTR_FND_SCH Number(6,1),
	PERYRS Number(10,4),
	EXPENDITURES Number(12,2),
	CIP_EXPENDITURE Varchar2 (6) 
) 
;
-- Create Indexes section

Create UNIQUE Index univdb2.PERSON_DEMO_PKEY ON univdb2.Person_Demo (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.APPLICANTS_ADMITS_PKEY ON univdb2.Applicants_Admits (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.ADMISSION_EXCEPTIONS_PKEY ON univdb2.Admission_Exceptions (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.TESTS_REQS_PKEY ON univdb2.Tests_Reqs (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.DOE_PGM_INFO_PKEY ON univdb2.DOE_Pgm_Info (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.COLLEGE_PREP_PKEY ON univdb2.College_Prep (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.ENROLLMENTS_PKEY ON univdb2.Enrollments (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.COURSES_TAKEN_PKEY ON univdb2.Courses_Taken (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.TEST_CREDITS_PKEY ON univdb2.Test_Credits (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.FELLOWSHIPS_PKEY ON univdb2.Fellowships (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.STIPENDS_PKEY ON univdb2.Stipends (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.FEE_WAIVERS_PKEY ON univdb2.Fee_Waivers (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.DEGREES_AWARDED_PKEY ON univdb2.Degrees_Awarded (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.HOURS_TO_DEGREE_PKEY ON univdb2.Hours_to_Degree (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.COURSES_TO_DEGREE_PKEY ON univdb2.Courses_to_Degree (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.FINANCIAL_AID_DEMO_PKEY ON univdb2.Financial_Aid_Demo (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.FINANCIAL_AID_AWARDS_PKEY ON univdb2.Financial_Aid_Awards (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.INSTRUCTIONAL_ACTIVITY_PKEY ON univdb2.Instructional_Activity (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.COURSE_MEETINGS_PKEY ON univdb2.Course_Meetings (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.SITES_PKEY ON univdb2.Sites (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.BUILDINGS_PKEY ON univdb2.Buildings (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.ROOMS_PKEY ON univdb2.Rooms (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.WORKLOAD_PERSON_FUNDING_PKEY ON univdb2.Workload_Person_Funding (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.WORKLOAD_ACTIVITY_SUMMARY_PKEY ON univdb2.Workload_Activity_Summary (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.WORKLOAD_ACTIVITIES_PKEY ON univdb2.Workload_Activities (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.EMPLOYEE_DEMO_PKEY ON univdb2.Employee_Demo (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.EMPLOYEE_DATA_PKEY ON univdb2.Employee_Data (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.EMPLOYEE_VACANTS_PKEY ON univdb2.Employee_Vacants (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.OPERATING_BUDGET_PKEY ON univdb2.Operating_Budget (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.CAMPUS_PKEY ON univdb2.Campus (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.UNIV_DEPT_MASTER_PKEY ON univdb2.Univ_Dept_Master (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.PERSON_ID_CHGS_PKEY ON univdb2.Person_ID_Chgs (UNIV_ROW_ID) 
;
Create UNIQUE Index univdb2.PERSON_ID_CHGS_PKEY ON univdb2.Expenditure_Analysis_Extract (UNIV_ROW_ID) 
;

-- Create section for PKs, AKs and Unique constraints, which have to be generated after Indexes
Alter table univdb2.Person_Demo add Constraint Person_Demo_pk primary key (UNIV_ROW_ID) 
	USING INDEX PERSON_DEMO_PKEY
;
Alter table univdb2.Applicants_Admits add Constraint Applicants_Admits_PK primary key (UNIV_ROW_ID) 
	USING INDEX APPLICANTS_ADMITS_PKEY
;
Alter table univdb2.Admission_Exceptions add Constraint Admission_Exceptions_pk primary key (UNIV_ROW_ID) 
	USING INDEX ADMISSION_EXCEPTIONS_PKEY
;
Alter table univdb2.Tests_Reqs add Constraint Tests_Reqs_pk primary key (UNIV_ROW_ID) 
	USING INDEX TESTS_REQS_PKEY
;
Alter table univdb2.DOE_Pgm_Info add Constraint DOE_Pgm_Info_pk primary key (UNIV_ROW_ID) 
	USING INDEX DOE_PGM_INFO_PKEY
;
Alter table univdb2.College_Prep add Constraint College_Prep_PK primary key (UNIV_ROW_ID) 
	USING INDEX COLLEGE_PREP_PKEY
;
Alter table univdb2.Enrollments add Constraint Enrollments_pk primary key (UNIV_ROW_ID) 
	USING INDEX ENROLLMENTS_PKEY
;
Alter table univdb2.Courses_Taken add Constraint Courses_Taken_pk primary key (UNIV_ROW_ID) 
	USING INDEX COURSES_TAKEN_PKEY
;
Alter table univdb2.Test_Credits add Constraint Test_Credits_pk primary key (UNIV_ROW_ID) 
	USING INDEX TEST_CREDITS_PKEY
;
Alter table univdb2.Fellowships add Constraint Fellowships_pk primary key (UNIV_ROW_ID) 
	USING INDEX FELLOWSHIPS_PKEY
;
Alter table univdb2.Stipends add Constraint Stipends_pk primary key (UNIV_ROW_ID) 
	USING INDEX STIPENDS_PKEY
;
Alter table univdb2.Fee_Waivers add Constraint Fee_Waivers_pk primary key (UNIV_ROW_ID) 
	USING INDEX FEE_WAIVERS_PKEY
;
Alter table univdb2.Degrees_Awarded add Constraint Degrees_Awarded_pk primary key (UNIV_ROW_ID) 
	USING INDEX DEGREES_AWARDED_PKEY
;
Alter table univdb2.Hours_to_Degree add Constraint Hours_to_Degree_pk primary key (UNIV_ROW_ID) 
	USING INDEX HOURS_TO_DEGREE_PKEY
;
Alter table univdb2.Courses_to_Degree add Constraint Courses_to_Degree_pk primary key (UNIV_ROW_ID) 
	USING INDEX COURSES_TO_DEGREE_PKEY
;
Alter table univdb2.Financial_Aid_Demo add Constraint Financial_Aid_Demo_pk primary key (UNIV_ROW_ID) 
	USING INDEX FINANCIAL_AID_DEMO_PKEY
;
Alter table univdb2.Financial_Aid_Awards add Constraint Financial_Aid_Awards_pk primary key (UNIV_ROW_ID) 
	USING INDEX FINANCIAL_AID_AWARDS_PKEY
;
Alter table univdb2.Instructional_Activity add Constraint Instructional_Activity_pk primary key (UNIV_ROW_ID) 
	USING INDEX INSTRUCTIONAL_ACTIVITY_PKEY
;
Alter table univdb2.Course_Meetings add Constraint Course_Meetings_pk primary key (UNIV_ROW_ID) 
	USING INDEX COURSE_MEETINGS_PKEY
;
Alter table univdb2.Sites add Constraint Sites_pk primary key (UNIV_ROW_ID) 
	USING INDEX SITES_PKEY
;
Alter table univdb2.Buildings add Constraint Buildings_pk primary key (UNIV_ROW_ID) 
	USING INDEX BUILDINGS_PKEY
;
Alter table univdb2.Rooms add Constraint Rooms_pk primary key (UNIV_ROW_ID) 
	USING INDEX ROOMS_PKEY
;
Alter table univdb2.Workload_Person_Funding add Constraint Workload_Person_Funding_pk primary key (UNIV_ROW_ID) 
	USING INDEX WORKLOAD_PERSON_FUNDING_PKEY
;
Alter table univdb2.Workload_Activity_Summary add Constraint Workload_Activity_Summary_pk primary key (UNIV_ROW_ID) 
	USING INDEX WORKLOAD_ACTIVITY_SUMMARY_PKEY
;
Alter table univdb2.Workload_Activities add Constraint Workload_Activities_pk primary key (UNIV_ROW_ID) 
	USING INDEX WORKLOAD_ACTIVITIES_PKEY
;
Alter table univdb2.Employee_Demo add Constraint Employee_Demo_pk primary key (UNIV_ROW_ID) 
	USING INDEX EMPLOYEE_DEMO_PKEY
;
Alter table univdb2.Employee_Data add Constraint Employee_Data_pk primary key (UNIV_ROW_ID) 
	USING INDEX EMPLOYEE_DATA_PKEY
;
Alter table univdb2.Employee_Vacants add Constraint Employee_Vacants_pk primary key (UNIV_ROW_ID) 
	USING INDEX EMPLOYEE_VACANTS_PKEY
;
Alter table univdb2.Campus add Constraint Campus_pk primary key (UNIV_ROW_ID) 
	USING INDEX CAMPUS_PKEY
;
Alter table univdb2.Univ_Dept_Master add Constraint Univ_Dept_Master_pk primary key (UNIV_ROW_ID) 
	USING INDEX UNIV_DEPT_MASTER_PKEY
;
Alter table univdb2.Person_ID_Chgs add Constraint Person_ID_Chgs_pk primary key (UNIV_ROW_ID) 
	USING INDEX PERSON_ID_CHGS_PKEY
;
Alter table univdb2.Expenditure_Analysis_Extract add Constraint EA_Extract_pk primary key (UNIV_ROW_ID) 
	USING INDEX EA_EXTRACT_PKEY
;