/* Created 9/4/2006 Modified 7/23/2008 Project UNIVDB Submission Model Full Model Company BOG Author IRM Version Release 1.1 Database Oracle 10g */ /* Drop table UNIVDB1.Uploaded_Data CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Person_ID_Chgs CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Univ_Dept_Master CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.PrePartition CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Campus CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Full_Cost CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Expenditure_Analysis_Extract CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Edit_Report_Summary_Preprod CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Edit_Report_Detail_Preprod CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Upload_History CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Operating_Budget CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Employee_Vacants CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Employee_Data CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Employee_Demo CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Workload_Activities CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Workload_Activity_Summary CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Workload_Person_Funding CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Bldg_Plnt_Oper_Maint CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Rooms CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Buildings CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Sites CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Course_Meetings CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Instructional_Activity CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Financial_Aid_Awards CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Financial_Aid_Demo CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Courses_to_Degree CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Hours_to_Degree CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Degrees_Awarded CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Fee_Waivers CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Stipends CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Fellowships CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Test_Credits CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Courses_Taken CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Enrollments CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.College_Prep CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.DOE_Pgm_Info CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Tests_Reqs CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Admission_Exceptions CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Applicants_Admits CASCADE CONSTRAINTS PURGE ; Drop table UNIVDB1.Person_Demo CASCADE CONSTRAINTS PURGE ; */ -- Create Tables section Create table UNIVDB1.Person_Demo ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), SYSID Number(12,0), SYSID_SEQ Number(1,0) Default 1 ) ; Create table UNIVDB1.Applicants_Admits ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Admission_Exceptions ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Tests_Reqs ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.DOE_Pgm_Info ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.College_Prep ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Enrollments ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), IPEDS_GRADSTU_FLG Varchar2 (1), WAIVER_HR_GRAD_STU Number(1,0), GPA_TERM Number(5,2), GPA_CUM Number(5,2) ) ; Create table UNIVDB1.Courses_Taken ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), CRS_LEVEL_CLASS Varchar2 (1), ST_FUND_CRED_HRS Number(3,1) ) ; Create table UNIVDB1.Test_Credits ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Fellowships ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Stipends ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Fee_Waivers ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Degrees_Awarded ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Hours_to_Degree ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), DEG_LEVEL_GRANT Varchar2 (1) NOT NULL , HRS_USED Number(7,2), EXCESS_HRS_SUS Number(7,2), EXCESS_HRS_NATIVE Number(7,2) ) ; Create table UNIVDB1.Courses_to_Degree ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Financial_Aid_Demo ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), NEED_BASED_AID_IND Varchar2 (1) ) ; Create table UNIVDB1.Financial_Aid_Awards ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Instructional_Activity ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Course_Meetings ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Sites ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), OWN_BLDG_CNT Number(4,0), OWN_BLDG_AREA Number(8,0) ) ; Create table UNIVDB1.Buildings ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Rooms ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Bldg_Plnt_Oper_Maint ( PRIKEY Number NOT NULL , 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 , BE_CD_POM Varchar2 (1) NOT NULL , POM_BUD_FACTOR Number(3,2) ) ; Create table UNIVDB1.Workload_Person_Funding ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Workload_Activity_Summary ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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) ) ; Create table UNIVDB1.Workload_Activities ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Employee_Demo ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Employee_Data ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), PAY_GRADE Varchar2 (3), STEP_NBR Varchar2 (3), PERYRS Number(10,4) ) ; Create table UNIVDB1.Employee_Vacants ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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), PAY_GRADE Varchar2 (3), PERYRS Number(10,4), COMMIT_TYP Varchar2 (2) ) ; Create table UNIVDB1.Operating_Budget ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Expenditure_Analysis_Extract ( PRIKEY Number NOT NULL , 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 table UNIVDB1.Full_Cost ( PRIKEY Number NOT NULL , REPT_INST Varchar2 (4) NOT NULL , FISCAL_YR Varchar2 (8) NOT NULL , COLLEGE Varchar2 (2), BE_CD8 Varchar2 (8) NOT NULL , COST_ACT Varchar2 (2) NOT NULL , CIP_EXPENDITURE Varchar2 (6) NOT NULL , PROG_DISCIPLINE Varchar2 (2), CRED_HRS Number(7,0), EXP_PER_ACTIVITIES Number(10,0), DIRECT_EXP Number(10,0), INDIRECT_EXP Number(10,0), TOT_FULL_EXP Number(10,0), DIRECT_EXP_PER_FSCH Number(10,2), INDIRECT_EXP_PER_FSCH Number(10,2), TOT_EXP_PER_FSCH Number(10,2) ) ; Create table UNIVDB1.Campus ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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) ) ; Create table UNIVDB1.PrePartition ( PRIKEY Number NOT NULL , REPT_INST Varchar2 (4) NOT NULL , FISCAL_YR Varchar2 (4) NOT NULL , BE_CD8 Varchar2 (8) NOT NULL , COLLEGE_ACT Varchar2 (2) NOT NULL , COST_ACT Varchar2 (2) NOT NULL , CIP_EXPENDITURE Varchar2 (6) NOT NULL , LOWER_FSCH Number(10,0) NOT NULL , UPPER_FSCH Number(10,0) NOT NULL , GRAD1_FSCH Number(10,0) NOT NULL , GRAD2_FSCH Number(10,0) NOT NULL , GRAD3_FSCH Number(10,0) NOT NULL , CLIN_FSCH Number(10,0) NOT NULL , LOWER_FACPERYRS Number(10,4) NOT NULL , UPPER_FACPERYR Number(10,4) NOT NULL , GRAD1_FACPERYRS Number(10,4) NOT NULL , GRAD2_FACPERYRS Number(10,4) NOT NULL , GRAD3_FACPERYRS Number(10,4) NOT NULL , CLIN_FACPERYRS Number(10,4) Default 0 NOT NULL , RSRCH_FACPERYRS Number(10,4) Default 0 NOT NULL , PUBSVC_FACPERYRS Number(10,4) Default 0 NOT NULL , ACDADV_FACPERYRS Number(10,4) Default 0 NOT NULL , ADMIN_FACPERYRS Number(10,4) Default 0 NOT NULL , TBPALL_FACPERYR Number(10,4) Default 0 NOT NULL , TBPINSTR_FACPERYR Number(10,4) Default 0 NOT NULL , LOWER_FACSALBEN Number(10,0) Default 0 NOT NULL , UPPER_FACSALBEN Number(10,0) Default 0 NOT NULL , GRAD1_FACSALBEN Number(10,0) Default 0 NOT NULL , GRAD2_FACSALBEN Number(10,0) Default 0 NOT NULL , GRAD3_FACSALBEN Number(10,0) Default 0 NOT NULL , CLIN_FACSALBEN Number(10,0) Default 0 NOT NULL , RSRCH_FACSALBEN Number(10,0) Default 0 NOT NULL , PUBSVC_FACSALBEN Number(10,0) Default 0 NOT NULL , ACDADV_FACSALBEN Number(10,0) Default 0 NOT NULL , ADMIN_FACSALBEN Number(10,0) Default 0 NOT NULL , TBPALL_FACSALBEN Number(10,0) Default 0 NOT NULL , TBPINSTR_FACSALBEN Number(10,0) Default 0 NOT NULL , LOWER_SSPERYRS Number(10,4) Default 0 NOT NULL , UPPER_SSPERYR Number(10,4) Default 0 NOT NULL , GRAD1_SSPERYRS Number(10,4) Default 0 NOT NULL , GRAD2_SSPERYRS Number(10,4) Default 0 NOT NULL , GRAD3_SSPERYRS Number(10,4) Default 0 NOT NULL , CLIN_SSPERYRS Number(10,4) Default 0 NOT NULL , RSRCH_SSPERYRS Number(10,4) Default 0 NOT NULL , PUBSVC_SSPERYRS Number(10,4) Default 0 NOT NULL , ACDADV_SSPERYRS Number(10,4) Default 0 NOT NULL , ADMIN_SSPERYRS Number(10,4) Default 0 NOT NULL , TBPALL_SSPERYR Number(10,4) Default 0 NOT NULL , LOWER_SSSALBEN Number(10,0) Default 0 NOT NULL , TBPINSTR_SSPERYR Number(10,4) Default 0 NOT NULL , UPPER_SSSALBEN Number(10,0) Default 0 NOT NULL , GRAD1_SSSALBEN Number(10,0) Default 0 NOT NULL , GRAD2_SSSALBEN Number(10,0) Default 0 NOT NULL , GRAD3_SSSALBEN Number(10,0) Default 0 NOT NULL , CLIN_SSSALBEN Number(10,0) Default 0 NOT NULL , RSRCH_SSSALBEN Number(10,0) Default 0 NOT NULL , PUBSVC_SSSALBEN Number(10,0) Default 0 NOT NULL , ACDADV_SSSALBEN Number(10,0) Default 0 NOT NULL , ADMIN_SSSALBEN Number(10,0) Default 0 NOT NULL , TBPALL_SSSALBEN Number(10,0) Default 0 NOT NULL , TBPINSTR_SSSALBEN Number(10,0) Default 0 NOT NULL , TBPALL_RESPERYR Number(10,4) Default 0 NOT NULL , TBPINSTR_RESPERYR Number(10,4) Default 0 NOT NULL , ADMIN_RESSALBEN Number(10,4) Default 0 NOT NULL , TBPALL_RESSALBEN Number(10,4) Default 0 NOT NULL , TBPINSTR_RESSALBEN Number(10,4) Default 0 NOT NULL , LOWER_FADJPERYRS Number(10,4) Default 0 NOT NULL , UPPER_FADJPERYR Number(10,4) Default 0 NOT NULL , GRAD1_FADJPERYRS Number(10,4) Default 0 NOT NULL , GRAD2_FADJPERYRS Number(10,4) Default 0 NOT NULL , GRAD3_FADJPERYRS Number(10,4) Default 0 NOT NULL , CLIN_FADJPERYRS Number(10,4) Default 0 NOT NULL , RSRCH_FADJPERYRS Number(10,4) Default 0 NOT NULL , PUBSVC_FADJPERYRS Number(10,4) Default 0 NOT NULL , ACDADV_FADJPERYRS Number(10,4) Default 0 NOT NULL , ADMIN_FADJPERYRS Number(10,4) Default 0 NOT NULL , TBPINSTR_FADJPERYR Number(10,4) Default 0 NOT NULL , LOWER_FADJSALBEN Number(10,0) Default 0 NOT NULL , UPPER_FADJSALBEN Number(10,0) Default 0 NOT NULL , GRAD1_FADJSALBEN Number(10,0) Default 0 NOT NULL , GRAD2_FADJSALBEN Number(10,0) Default 0 NOT NULL , GRAD3_FADJSALBEN Number(10,0) Default 0 NOT NULL , CLIN_FADJSALBEN Number(10,0) Default 0 NOT NULL , RSRCH_FADJSALBEN Number(10,0) Default 0 NOT NULL , PUBSVC_FADJSALBEN Number(10,0) Default 0 NOT NULL , ACDADV_FADJSALBEN Number(10,0) Default 0 NOT NULL , ADMIN_FADJSALBEN Number(10,0) Default 0 NOT NULL , TBPINSTR_FADJSALBEN Number(10,0) Default 0 NOT NULL , LOWER_GAPERYRS Number(10,4) Default 0 NOT NULL , UPPER_GAPERYR Number(10,4) Default 0 NOT NULL , GRAD1_GAPERYRS Number(10,4) Default 0 NOT NULL , GRAD2_GAPERYRS Number(10,4) Default 0 NOT NULL , GRAD3_GAPERYRS Number(10,4) Default 0 NOT NULL , CLIN_GAPERYRS Number(10,4) Default 0 NOT NULL , RSRCH_GAPERYRS Number(10,4) Default 0 NOT NULL , PUBSVC_GAPERYRS Number(10,4) Default 0 NOT NULL , ACDADV_GAPERYRS Number(10,4) Default 0 NOT NULL , ADMIN_GAPERYRS Number(10,4) Default 0 NOT NULL , TBPALL_GAPERYR Number(10,4) Default 0 NOT NULL , TBPINSTR_GAPERYR Number(10,4) Default 0 NOT NULL , LOWER_GASALBEN Number(10,0) Default 0 NOT NULL , UPPER_GASALBEN Number(10,0) Default 0 NOT NULL , GRAD1_GASALBEN Number(10,0) Default 0 NOT NULL , GRAD2_GASALBEN Number(10,0) Default 0 NOT NULL , GRAD3_GASALBEN Number(10,0) Default 0 NOT NULL , CLIN_GASALBEN Number(10,0) Default 0 NOT NULL , RSRCH_GASALBEN Number(10,0) Default 0 NOT NULL , PUBSVC_GASALBEN Number(10,0) Default 0 NOT NULL , ACDADV_GASALBEN Number(10,0) Default 0 NOT NULL , ADMIN_GASALBEN Number(10,0) Default 0 NOT NULL , TBPALL_GASALBEN Number(10,0) Default 0 NOT NULL , TBPINSTR_GASALBEN Number(10,0) Default 0 NOT NULL , LOWER_OOPSPERYRS Number(10,4) Default 0 NOT NULL , UPPER_OOPSPERYR Number(10,4) Default 0 NOT NULL , GRAD1_OOPSPERYRS Number(10,4) Default 0 NOT NULL , GRAD2_OOPSPERYRS Number(10,4) Default 0 NOT NULL , GRAD3_OOPSPERYRS Number(10,4) Default 0 NOT NULL , CLIN_OOPSPERYRS Number(10,4) Default 0 NOT NULL , RSRCH_OOPSPERYRS Number(10,4) Default 0 NOT NULL , PUBSVC_OOPSPERYRS Number(10,4) Default 0 NOT NULL , ACDADV_OOPSPERYRS Number(10,4) Default 0 NOT NULL , ADMIN_OOPSPERYRS Number(10,4) Default 0 NOT NULL , TBPALL_OOPSPERYR Number(10,4) Default 0 NOT NULL , TBPINSTR_OOPSPERYR Number(10,4) Default 0 NOT NULL , LOWER_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , UPPER_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , GRAD1_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , GRAD2_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , GRAD3_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , CLIN_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , RSRCH_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , PUBSVC_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , ACDADV_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , ADMIN_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , TBPALL_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , TBPINSTR_OOPSDOLLAR Number(10,0) Default 0 NOT NULL , ADMIN_ROPSDOLLAR Number(10,0) Default 0 NOT NULL , TBPALL_ROPSDOLLAR Number(10,0) Default 0 NOT NULL , ADMIN_OTHEXPENSE Number(10,0) Default 0 NOT NULL , TBPALL_OTHEXPENSE Number(10,0) Default 0 NOT NULL , ADMIN_UTILEXPENSE Number(10,0) Default 0 NOT NULL , TBPALL_UTILEXPENSE Number(10,0) Default 0 NOT NULL , ADMIN_OCOEXPENSE Number(10,0) Default 0 NOT NULL , TBPALL_OCOEXPENSE Number(10,0) Default 0 NOT NULL , ADMIN_BOOKOCO Number(10,0) Default 0 NOT NULL , TBPALL_BOOKOCO Number(10,0) Default 0 NOT NULL , ADMIN_EDPEXPENSE Number(10,0) Default 0 NOT NULL , TBPALL_EDPEXPENSE Number(10,0) Default 0 NOT NULL , ADMIN_SPECCAT Number(10,0) Default 0 NOT NULL , TBPALL_SPECCAT Number(10,0) Default 0 NOT NULL ) ; Create table UNIVDB1.Univ_Dept_Master ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 UNIVDB1.Person_ID_Chgs ( PRIKEY Number NOT NULL , ROWSEQ_NBR Number NOT NULL , 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 (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 UNIVDB1.Upload_History ( UPLOAD_HISTORY Number NOT NULL , SUBMIT_DTM Timestamp(6) NOT NULL , REPT_INST Varchar2 (4) NOT NULL , REPT_TIME_FRAME Varchar2 (8) NOT NULL , SUBMISSION Varchar2 (8) NOT NULL , TARGET_TABLE Varchar2 (30) NOT NULL , AUDIT_ID Varchar2 (30) NOT NULL , LOCAL_FILE_NAME Varchar2 (400) NOT NULL , ROWS_RECEIVED NUMBER, FILE_SIZE NUMBER, ROWS_W_EXCEPTIONS NUMBER, INVALID_FILE_FLG VARCHAR2(1) ) ; Create table UNIVDB1.Uploaded_Data ( UPLOAD_HISTORY Number NOT NULL , FILE_CONTENTS Clob ) ; Create table UNIVDB1.Edit_Report_Summary_Preprod ( REPT_INST Varchar2 (4) NOT NULL , REPT_TIME_FRAME Varchar2 (8) NOT NULL , FILE_ID Varchar2 (8) NOT NULL , FILE_LOADED_DTM Timestamp(6) NOT NULL , TABLE_NAME Varchar2 (30) NOT NULL , REPORT_ID Varchar2 (50) NOT NULL , COLUMN_NAME Varchar2 (30) NOT NULL , DIAGNOSTIC_MSG_CD Varchar2 (30) NOT NULL , MESSAGE_TEXT Varchar2 (4000), ERROR_LEVEL Number(2,0), FREQUENCY Integer, TOLERANCE Integer, EXPLANATION Varchar2 (4000), REJECT_REASON Varchar2 (4000), REJECTED_DTM Timestamp(6) ) ; Create table UNIVDB1.Edit_Report_Detail_Preprod ( REPT_INST Varchar2 (4) NOT NULL , REPT_TIME_FRAME Varchar2 (8) NOT NULL , FILE_ID Varchar2 (8) NOT NULL , FILE_LOADED_DTM Timestamp(6) NOT NULL , TABLE_NAME Varchar2 (30) NOT NULL , REPORT_ID Varchar2 (50) NOT NULL , COLUMN_NAME Varchar2 (30) NOT NULL , DIAGNOSTIC_MSG_CD Varchar2 (4) NOT NULL , TABLE_SEQNO Number, BAD_DATA_CONTENTS Varchar2 (4000) ) ; -- Create section for PKs, AKs and Unique constraints, which have to be generated after Indexes Create UNIQUE Index UNIVDB1.PERSON_DEMO_PKEY ON UNIVDB1.Person_Demo (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.APPLICANTS_ADMITS_PKEY ON UNIVDB1.Applicants_Admits (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.ADMISSION_EXCEPTIONS_PKEY ON UNIVDB1.Admission_Exceptions (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.TESTS_REQS_PKEY ON UNIVDB1.Tests_Reqs (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.DOE_PGM_INFO_PKEY ON UNIVDB1.DOE_Pgm_Info (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.COLLEGE_PREP_PKEY ON UNIVDB1.College_Prep (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.ENROLLMENTS_PKEY ON UNIVDB1.Enrollments (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.COURSES_TAKEN_PKEY ON UNIVDB1.Courses_Taken (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.TEST_CREDITS_PKEY ON UNIVDB1.Test_Credits (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.FELLOWSHIPS_PKEY ON UNIVDB1.Fellowships (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.STIPENDS_PKEY ON UNIVDB1.Stipends (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.FEE_WAIVERS_PKEY ON UNIVDB1.Fee_Waivers (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.DEGREES_AWARDED_PKEY ON UNIVDB1.Degrees_Awarded (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.HOURS_TO_DEGREE_PKEY ON UNIVDB1.Hours_to_Degree (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.COURSES_TO_DEGREE_PKEY ON UNIVDB1.Courses_to_Degree (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.FINANCIAL_AID_DEMO_PKEY ON UNIVDB1.Financial_Aid_Demo (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.FINANCIAL_AID_AWARDS_PKEY ON UNIVDB1.Financial_Aid_Awards (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.INSTRUCTIONAL_ACTIVITY_PKEY ON UNIVDB1.Instructional_Activity (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.COURSE_MEETINGS_PKEY ON UNIVDB1.Course_Meetings (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.SITES_PKEY ON UNIVDB1.Sites (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.BUILDINGS_PKEY ON UNIVDB1.Buildings (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.ROOMS_PKEY ON UNIVDB1.Rooms (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.BLDG_PLNT_OPER_MAINT_PKEY ON UNIVDB1.Bldg_Plnt_Oper_Maint (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.WORKLOAD_PERSON_FUNDING_PKEY ON UNIVDB1.Workload_Person_Funding (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.WORKLOAD_ACTIVITY_SUMMARY_PKEY ON UNIVDB1.Workload_Activity_Summary (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.WORKLOAD_ACTIVITIES_PKEY ON UNIVDB1.Workload_Activities (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.EMPLOYEE_DEMO_PKEY ON UNIVDB1.Employee_Demo (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.EMPLOYEE_DATA_PKEY ON UNIVDB1.Employee_Data (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.EMPLOYEE_VACANTS_PKEY ON UNIVDB1.Employee_Vacants (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.OPERATING_BUDGET_PKEY ON UNIVDB1.Operating_Budget (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.EA_EXTRACT_PKEY ON UNIVDB1.Expenditure_Analysis_Extract (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.FULL_COST_PKEY ON UNIVDB1.Full_Cost (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.CAMPUS_PKEY ON UNIVDB1.Campus (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.PREPARTITION_PKEY ON UNIVDB1.PrePartition (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.UNIV_DEPT_MASTER_PKEY ON UNIVDB1.Univ_Dept_Master (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.PERSON_ID_CHGS_PKEY ON UNIVDB1.Person_ID_Chgs (PRIKEY, REPT_INST); Create UNIQUE Index UNIVDB1.Person_Demo_LUK ON UNIVDB1.Person_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create UNIQUE Index UNIVDB1.Applicants_Admits_LUK ON UNIVDB1.Applicants_Admits (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,PERSON_ID,CIP_APP_ADM,STU_TYP); Create UNIQUE Index UNIVDB1.Admission_Exceptions_LUK ON UNIVDB1.Admission_Exceptions (REPT_TIME_FRAME,REPT_INST,PERSON_ID,EXCEPTION_SOURCE,CIP_APP_ADM,STU_TYP,EXCEPTION_TYP,EXCEPTION_CAT); Create UNIQUE Index UNIVDB1.Tests_Reqs_LUK ON UNIVDB1.Tests_Reqs (DEMO_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,PERSON_ID,CIP_APP_ADM,STU_TYP,TCHR_PREP_DOE_CD,TEST_REQ_CD,TEST_SCORE_TYP); Create UNIQUE Index UNIVDB1.DOE_Pgm_Info_LUK ON UNIVDB1.DOE_Pgm_Info (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,PERSON_ID,CIP_APP_ADM,STU_TYP,TCHR_PREP_DOE_CD,TCHR_PREP_DOE_LEVEL,TCHR_TERM_ADMIT); Create UNIQUE Index UNIVDB1.College_Prep_LUK ON UNIVDB1.College_Prep (REPT_TIME_FRAME,CP_SOURCE,REPT_INST,PERSON_ID,REMEDIATION_AREA); Create UNIQUE Index UNIVDB1.Enrollments_LUK ON UNIVDB1.Enrollments (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND); Create UNIQUE Index UNIVDB1.Courses_Taken_LUK ON UNIVDB1.Courses_Taken (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR); Create UNIQUE Index UNIVDB1.Test_Credits_LUK ON UNIVDB1.Test_Credits (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,TEST_TYP); Create UNIQUE Index UNIVDB1.Fellowships_LUK ON UNIVDB1.Fellowships (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ); Create UNIQUE Index UNIVDB1.Stipends_LUK ON UNIVDB1.Stipends (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ); Create UNIQUE Index UNIVDB1.Fee_Waivers_LUK ON UNIVDB1.Fee_Waivers (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ); Create UNIQUE Index UNIVDB1.Degrees_Awarded_LUK ON UNIVDB1.Degrees_Awarded (REPT_TIME_FRAME,REPT_INST,PERSON_ID,FEE_CLASS_KIND,TERM_DEG_GRANT,DEG_LEVEL_GRANT,CIP_DEGREE,MAJOR_IND,TCHR_PREP_DOE_CD,TCHR_PREP_DOE_LEVEL); Create UNIQUE Index UNIVDB1.Hours_to_Degree_LUK ON UNIVDB1.Hours_to_Degree (REPT_TIME_FRAME,REPT_INST,PERSON_ID,TERM_DEG_GRANT,DEG_LEVEL_GRANT); Create UNIQUE Index UNIVDB1.Courses_to_Degree_LUK ON UNIVDB1.Courses_to_Degree (REPT_TIME_FRAME,REPT_INST,PERSON_ID,TERM_DEG_GRANT,DEG_LEVEL_GRANT,TERM_TAKEN,CRS_INST_CD,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR,SEGMENT_SEQ); Create UNIQUE Index UNIVDB1.Financial_Aid_Demo_LUK ON UNIVDB1.Financial_Aid_Demo (REPT_TIME_FRAME,REPT_INST,PERSON_ID); Create UNIQUE Index UNIVDB1.Financial_Aid_Awards_LUK ON UNIVDB1.Financial_Aid_Awards (REPT_TIME_FRAME,REPT_INST,PERSON_ID,AWARD_PAYMENT_TERM,AWARD_PROG_ID,AWARD_COND_ID); Create UNIQUE Index UNIVDB1.Instructional_Activity_LUK ON UNIVDB1.Instructional_Activity (REPT_INST,REPT_TIME_FRAME,SESSION_ID,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR); Create UNIQUE Index UNIVDB1.Course_Meetings_LUK ON UNIVDB1.Course_Meetings (REPT_INST,REPT_TIME_FRAME,SESSION_ID,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR,CRS_SECTN_BEG_TIME,CRS_SECTN_END_TIME,SUNDAY,MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,BLDG_NBR,ROOM_NBR_PREFIX,ROOM_NBR_DIGITS,ROOM_NBR_SUFFIX); Create UNIQUE Index UNIVDB1.Bldg_Plnt_Oper_Maint_LUK ON UNIVDB1.Bldg_Plnt_Oper_Maint (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR,BE_CD_POM); Create UNIQUE Index UNIVDB1.Workload_Person_Funding_LUK ON UNIVDB1.Workload_Person_Funding (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID); Create UNIQUE Index UNIVDB1.Workload_Activity_Summary_LUK ON UNIVDB1.Workload_Activity_Summary (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID_ACT,BE_CD_ACT,CIP_CRS,CRS_SECTN_TYP_PRI,COLLEGE,PROG_COMP_ACT,INSTR_RESRCH_ACT); Create UNIQUE Index UNIVDB1.Workload_Activities_LUK ON UNIVDB1.Workload_Activities (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID,BE_CD_ACT,COLLEGE,PROG_COMP_ACT,INSTR_RESRCH_ACT,CRS_SECTN_TYP_PRI,CIP_CRS,DEPT_ID_ACT,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR); Create UNIQUE Index UNIVDB1.Employee_Demo_LUK ON UNIVDB1.Employee_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP); Create UNIQUE Index UNIVDB1._LUK ON UNIVDB1.Employee_Data (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP,BE_CD,ST_FUND_TYP,FUND_ID_EMPL_RES,BE_CD8,IBI,APPROP_CAT,DEPT_ID,UNIV_BUD_ID,PAY_PLAN_NBR,OPS_SEQ,UNIV_POSITION,PCS_DEPT_ID,COMMIT_TYP); Create UNIQUE Index UNIVDB1.Full_Cost_LUK ON UNIVDB1.Full_Cost (REPT_INST,BE_CD8,COST_ACT,CIP_EXPENDITURE); Create UNIQUE Index UNIVDB1.PrePartition_LUK ON UNIVDB1.PrePartition (REPT_INST,FISCAL_YR,BE_CD8,COLLEGE_ACT,COST_ACT,CIP_EXPENDITURE); Create UNIQUE Index UNIVDB1.Univ_Dept_Master_LUK ON UNIVDB1.Univ_Dept_Master (REPT_INST,REPT_TIME_FRAME,DEPT_ID,UNIV_BUD_ID); Create UNIQUE Index UNIVDB1.Campus_LUK ON UNIVDB1.CAMPUS (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME); Create UNIQUE Index UNIVDB1.Sites_LUK ON UNIVDB1.SITES (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR); Create UNIQUE Index UNIVDB1.Buildings_LUK ON UNIVDB1.BUILDINGS (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR); Create UNIQUE Index UNIVDB1.Rooms_LUK ON UNIVDB1.ROOMS (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR,ROOM_NBR_PREFIX,ROOM_NBR_DIGITS,ROOM_NBR_SUFFIX,FLOOR_LEVEL,PRORATION); Create UNIQUE Index UNIVDB1.PERSON_ID_CHGS_LUK ON UNIVDB1.Person_ID_Chgs (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID_NEW); Create Index UNIVDB1.APPLICANTS_ADMITS_FK01 ON UNIVDB1.Applicants_Admits (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.ADMISSION_EXCEPTIONS_FK01 ON UNIVDB1.Admission_Exceptions (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.TESTS_REQS_FK01 ON UNIVDB1.Tests_Reqs (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.TESTS_REQS_FK02 ON UNIVDB1.Tests_Reqs (REPT_TIME_FRAME, APP_ADM_SOURCE, REPT_INST, PERSON_ID, CIP_APP_ADM, STU_TYP); --Create Index UNIVDB1.DOE_PGM_INFO_FK01 ON UNIVDB1.DOE_Pgm_Info (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.DOE_PGM_INFO_FK02 ON UNIVDB1.DOE_Pgm_Info (REPT_TIME_FRAME, APP_ADM_SOURCE, REPT_INST, PERSON_ID, CIP_APP_ADM, STU_TYP); --Create Index UNIVDB1.COLLEGE_PREP_FK01 ON UNIVDB1.College_Prep (DEMO_TIME_FRAME,CP_SOURCE,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.ENROLLMENTS_FK01 ON UNIVDB1.Enrollments (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.COURSES_TAKEN_FK01 ON UNIVDB1.Courses_Taken (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.COURSES_TAKEN_FK02 ON UNIVDB1.Courses_Taken (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND); --Create Index UNIVDB1.TEST_CREDITS_FK01 ON UNIVDB1.Test_Credits (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.TEST_CREDITS_FK02 ON UNIVDB1.Test_Credits (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND); --Create Index UNIVDB1.FELLOWSHIPS_FK01 ON UNIVDB1.Fellowships (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.FELLOWSHIPS_FK02 ON UNIVDB1.Fellowships (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND); --Create Index UNIVDB1.STIPENDS_FK01 ON UNIVDB1.Stipends (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.STIPENDS_FK02 ON UNIVDB1.Stipends (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND); --Create Index UNIVDB1.FEE_WAIVERS_FK01 ON UNIVDB1.Fee_Waivers (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.FEE_WAIVERS_FK02 ON UNIVDB1.Fee_Waivers (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND); --Create Index UNIVDB1.DEGREES_AWARDED_FK01 ON UNIVDB1.Degrees_Awarded (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.HOURS_TO_DEGREE_FK01 ON UNIVDB1.Hours_to_Degree (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.COURSES_TO_DEGREE_FK01 ON UNIVDB1.Courses_to_Degree (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.COURSES_TO_DEGREE_FK02 ON UNIVDB1.Courses_to_Degree (REPT_TIME_FRAME, REPT_INST, PERSON_ID, TERM_DEG_GRANT, DEG_LEVEL_GRANT); --Create Index UNIVDB1.FINANCIAL_AID_DEMO_FK01 ON UNIVDB1.Financial_Aid_Demo (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.FINANCIAL_AID_AWARDS_FK01 ON UNIVDB1.Financial_Aid_Awards (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.FINANCIAL_AID_AWARDS_FK02 ON UNIVDB1.Financial_Aid_Awards (REPT_TIME_FRAME, REPT_INST, PERSON_ID); --Create Index UNIVDB1.COURSE_MEETINGS_FK01 ON UNIVDB1.Course_Meetings (REPT_INST, REPT_TIME_FRAME, SESSION_ID, CRS_PREFIX, CRS_NBR, CRS_IND, CRS_SECTN_NBR); --Create Index UNIVDB1.BLDG_PLNT_OPER_MAINT_FK01 ON UNIVDB1.Bldg_Plnt_Oper_Maint (REPT_INST,CAMPUS_CD,BASE_YR,SITE_NBR); Create Index UNIVDB1.BLDG_PLNT_OPER_MAINT_FK02 ON UNIVDB1.Bldg_Plnt_Oper_Maint (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR); Create Index UNIVDB1.BLDG_PLNT_OPER_MAINT_FK03 ON UNIVDB1.Bldg_Plnt_Oper_Maint (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME); --Create Index UNIVDB1.WORKLOAD_PERSON_FUNDING_FK01 ON UNIVDB1.Workload_Person_Funding (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.WORKLOAD_ACTIVITY_SUMMARY_FK01 ON UNIVDB1.Workload_Activity_Summary (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.WORKLOAD_ACTIVITY_SUMMARY_FK02 ON UNIVDB1.Workload_Activity_Summary (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID_ACT); --Create Index UNIVDB1.WORKLOAD_ACTIVITIES_FK01 ON UNIVDB1.Workload_Activities (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.WORKLOAD_ACTIVITIES_FK02 ON UNIVDB1.Workload_Activities (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID); Create Index UNIVDB1.WORKLOAD_ACTIVITIES_FK03 ON UNIVDB1.Workload_Activities (demo_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID_ACT, BE_CD_ACT, CIP_CRS, CRS_SECTN_TYP_PRI, COLLEGE, PROG_COMP_ACT, INSTR_RESRCH_ACT); --Create Index UNIVDB1.EMPLOYEE_DEMO_FK01 ON UNIVDB1.Employee_Demo (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); --Create Index UNIVDB1.EMPLOYEE_DATA_FK01 ON UNIVDB1.Employee_Data (REPT_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID); Create Index UNIVDB1.EMPLOYEE_DATA_FK02 ON UNIVDB1.Employee_Data (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP); Create Index UNIVDB1.ROOMS_LUK_FK01 ON UNIVDB1.Rooms (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR); Create Index UNIVDB1.BUILDINGS_LUK_FK01 ON UNIVDB1.Buildings (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR); Create Index UNIVDB1.BUILDINGS_LUK_FK02 ON UNIVDB1.Buildings (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME); Create Index UNIVDB1.SITES_LUK_FK01 ON UNIVDB1.Sites (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME); Create Index UNIVDB1.ROOMS_LUK_FK02 ON UNIVDB1.Rooms (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR); Create Index UNIVDB1.ROOMS_LUK_FK03 ON UNIVDB1.Rooms (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME); Alter table UNIVDB1.PERSON_DEMO add Constraint Person_Demo_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.APPLICANTS_ADMITS add Constraint Applicants_Admits_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.ADMISSION_EXCEPTIONS add Constraint Admission_Exceptions_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.TESTS_REQS add Constraint Tests_Reqs_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.DOE_PGM_INFO add Constraint DOE_Pgm_Info_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.COLLEGE_PREP add Constraint College_Prep_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.ENROLLMENTS add Constraint Enrollments_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.COURSES_TAKEN add Constraint Courses_Taken_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.TEST_CREDITS add Constraint Test_Credits_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.FELLOWSHIPS add Constraint Fellowships_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.STIPENDS add Constraint Stipends_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.FEE_WAIVERS add Constraint Fee_Waivers_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.DEGREES_AWARDED add Constraint Degrees_Awarded_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.HOURS_TO_DEGREE add Constraint Hours_to_Degree_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.COURSES_TO_DEGREE add Constraint Courses_to_Degree_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.FINANCIAL_AID_DEMO add Constraint Financial_Aid_Demo_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.FINANCIAL_AID_AWARDS add Constraint Financial_Aid_Awards_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.INSTRUCTIONAL_ACTIVITY add Constraint Instructional_Activity_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.COURSE_MEETINGS add Constraint Course_Meetings_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.SITES add Constraint Sites_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.BUILDINGS add Constraint Buildings_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.ROOMS add Constraint Rooms_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.BLDG_PLNT_OPER_MAINT add Constraint Bldg_Plnt_Oper_Maint_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.WORKLOAD_PERSON_FUNDING add Constraint Workload_Person_Funding_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.WORKLOAD_ACTIVITY_SUMMARY add Constraint Workload_Activity_Summary_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.WORKLOAD_ACTIVITIES add Constraint Workload_Activities_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.EMPLOYEE_DEMO add Constraint Employee_Demo_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.EMPLOYEE_DATA add Constraint Employee_Data_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.EMPLOYEE_VACANTS add Constraint Employee_Vacants_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.OPERATING_BUDGET add Constraint Operating_Budget_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.FULL_COST add Constraint Full_Cost_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.CAMPUS add Constraint Campus_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.PREPARTITION add Constraint PrePartition_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.UNIV_DEPT_MASTER add Constraint Univ_Dept_Master_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.PERSON_ID_CHGS add Constraint Person_ID_Chgs_PKEY unique (PRIKEY, REPT_INST); Alter table UNIVDB1.PERSON_ID_CHGS add constraint PERSON_ID_CHGS_LUK unique (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID_NEW) ; Alter table UNIVDB1.Applicants_Admits add Constraint Applicants_Admits_LUK unique (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,PERSON_ID,CIP_APP_ADM,STU_TYP) ; Alter table UNIVDB1.Admission_Exceptions add Constraint Admission_Exceptions_LUK unique (REPT_TIME_FRAME,REPT_INST,PERSON_ID,EXCEPTION_SOURCE,CIP_APP_ADM,STU_TYP,EXCEPTION_TYP,EXCEPTION_CAT) ; Alter table UNIVDB1.Tests_Reqs add Constraint Tests_Reqs_LUK unique (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,PERSON_ID,CIP_APP_ADM,STU_TYP,TCHR_PREP_DOE_CD,TEST_REQ_CD,TEST_SCORE_TYP) ; Alter table UNIVDB1.DOE_Pgm_Info add Constraint DOE_Pgm_Info_LUK unique (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,PERSON_ID,CIP_APP_ADM,STU_TYP,TCHR_PREP_DOE_CD,TCHR_PREP_DOE_LEVEL,TCHR_TERM_ADMIT) ; Alter table UNIVDB1.College_Prep add Constraint College_Prep_LUK unique (REPT_TIME_FRAME,CP_SOURCE,REPT_INST,PERSON_ID,REMEDIATION_AREA) ; Alter table UNIVDB1.Enrollments add Constraint Enrollments_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND) ; Alter table UNIVDB1.Courses_Taken add Constraint Courses_Taken_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR) ; Alter table UNIVDB1.Test_Credits add Constraint Test_Credits_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,TEST_TYP) ; Alter table UNIVDB1.Fellowships add Constraint Fellowships_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ) ; Alter table UNIVDB1.Stipends add Constraint Stipends_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ) ; Alter table UNIVDB1.Fee_Waivers add Constraint Fee_Waivers_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,FEE_CLASS_KIND,SEGMENT_SEQ) ; Alter table UNIVDB1.Degrees_Awarded add Constraint Degrees_Awarded_LUK unique (REPT_TIME_FRAME,REPT_INST,PERSON_ID,FEE_CLASS_KIND,TERM_DEG_GRANT,DEG_LEVEL_GRANT,CIP_DEGREE,MAJOR_IND,TCHR_PREP_DOE_CD,TCHR_PREP_DOE_LEVEL) ; Alter table UNIVDB1.Hours_to_Degree add Constraint Hours_to_Degree_LUK unique (REPT_TIME_FRAME,REPT_INST,PERSON_ID,TERM_DEG_GRANT,DEG_LEVEL_GRANT) ; Alter table UNIVDB1.Courses_to_Degree add Constraint Courses_to_Degree_LUK unique (REPT_TIME_FRAME,REPT_INST,PERSON_ID,TERM_DEG_GRANT,DEG_LEVEL_GRANT,TERM_TAKEN,CRS_INST_CD,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR,SEGMENT_SEQ) ; Alter table UNIVDB1.Financial_Aid_Demo add Constraint Financial_Aid_Demo_LUK unique (REPT_TIME_FRAME,REPT_INST,PERSON_ID) ; Alter table UNIVDB1.Financial_Aid_Awards add Constraint Financial_Aid_Awards_LUK unique (REPT_TIME_FRAME,REPT_INST,PERSON_ID,AWARD_PAYMENT_TERM,AWARD_PROG_ID,AWARD_COND_ID) ; Alter table UNIVDB1.Instructional_Activity add Constraint Instructional_Activity_LUK unique (REPT_INST,REPT_TIME_FRAME,SESSION_ID,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR) ; Alter table UNIVDB1.Course_Meetings add Constraint Course_Meetings_LUK unique (REPT_INST,REPT_TIME_FRAME,SESSION_ID,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR,CRS_SECTN_BEG_TIME,CRS_SECTN_END_TIME,SUNDAY,MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,BLDG_NBR,ROOM_NBR_PREFIX,ROOM_NBR_DIGITS,ROOM_NBR_SUFFIX) ; Alter table UNIVDB1.Bldg_Plnt_Oper_Maint add Constraint Bldg_Plnt_Oper_Maint_LUK unique (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR,BE_CD_POM) ; Alter table UNIVDB1.Workload_Person_Funding add Constraint Workload_Person_Funding_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID) ; Alter table UNIVDB1.Workload_Activity_Summary add Constraint Workload_Activity_Summary_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID_ACT,BE_CD_ACT,CIP_CRS,CRS_SECTN_TYP_PRI,COLLEGE,PROG_COMP_ACT,INSTR_RESRCH_ACT) ; Alter table UNIVDB1.Workload_Activities add Constraint Workload_Activities_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID,BE_CD_ACT,COLLEGE,PROG_COMP_ACT,INSTR_RESRCH_ACT,CRS_SECTN_TYP_PRI,CIP_CRS,DEPT_ID_ACT,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR) ; Alter table UNIVDB1.Employee_Demo add Constraint Employee_Demo_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP) ; Alter table UNIVDB1.Employee_Data add Constraint Employee_Data_LUK unique (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP,BE_CD,ST_FUND_TYP,FUND_ID_EMPL_RES,BE_CD8,IBI,APPROP_CAT,DEPT_ID,UNIV_BUD_ID,PAY_PLAN_NBR,OPS_SEQ,UNIV_POSITION,PCS_DEPT_ID,COMMIT_TYP) ; Alter table UNIVDB1.Full_Cost add Constraint Full_Cost_LUK unique (REPT_INST,BE_CD8,COST_ACT,CIP_EXPENDITURE) ; Alter table UNIVDB1.PrePartition add Constraint PrePartition_LUK unique (REPT_INST,FISCAL_YR,BE_CD8,COLLEGE_ACT,COST_ACT,CIP_EXPENDITURE) ; Alter table UNIVDB1.Univ_Dept_Master add Constraint Univ_Dept_Master_LUK unique (REPT_INST,REPT_TIME_FRAME,DEPT_ID,UNIV_BUD_ID) ; Alter table UNIVDB1.Campus add constraint CAMPUS_LUK unique (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) ; Alter table UNIVDB1.Sites add constraint SITES_LUK unique (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME, SITE_NBR) ; Alter table UNIVDB1.Buildings add constraint BUILDINGS_LUK unique (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR) ; Alter table UNIVDB1.Rooms add constraint ROOMS_LUK unique (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR,ROOM_NBR_PREFIX,ROOM_NBR_DIGITS,ROOM_NBR_SUFFIX,FLOOR_LEVEL,PRORATION) ; Alter table UNIVDB1.Tests_Reqs add Constraint fk_AP_TESTS_REQS foreign key (REPT_TIME_FRAME, APP_ADM_SOURCE, REPT_INST, PERSON_ID, CIP_APP_ADM, STU_TYP) references UNIVDB1.Applicants_Admits (REPT_TIME_FRAME, APP_ADM_SOURCE, REPT_INST, PERSON_ID, CIP_APP_ADM, STU_TYP) on delete cascade; Alter table UNIVDB1.DOE_Pgm_Info add Constraint fk_AP_ADM_TEF foreign key (REPT_TIME_FRAME, APP_ADM_SOURCE, REPT_INST, PERSON_ID, CIP_APP_ADM, STU_TYP) references UNIVDB1.Applicants_Admits (REPT_TIME_FRAME, APP_ADM_SOURCE, REPT_INST, PERSON_ID, CIP_APP_ADM, STU_TYP) on delete cascade; Alter table UNIVDB1.Courses_Taken add Constraint fk_ENRL_COURSES foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) references UNIVDB1.Enrollments (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) on delete cascade; Alter table UNIVDB1.Fellowships add Constraint fk_ENRL_FELLOWSHIPS foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) references UNIVDB1.Enrollments (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) on delete cascade; Alter table UNIVDB1.Stipends add Constraint fk_ENRL_STIPENDS foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) references UNIVDB1.Enrollments (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) on delete cascade; Alter table UNIVDB1.Fee_Waivers add Constraint fk_ENRL_FEE_WAIVERS foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) references UNIVDB1.Enrollments (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) on delete cascade; Alter table UNIVDB1.Test_Credits add Constraint fk_ENRL_TEST_CREDS foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) references UNIVDB1.Enrollments (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, FEE_CLASS_KIND) on delete cascade; Alter table UNIVDB1.Courses_to_Degree add Constraint fk_HTD_COURSES foreign key (REPT_TIME_FRAME, REPT_INST, PERSON_ID, TERM_DEG_GRANT, DEG_LEVEL_GRANT) references UNIVDB1.Hours_to_Degree (REPT_TIME_FRAME, REPT_INST, PERSON_ID, TERM_DEG_GRANT, DEG_LEVEL_GRANT) on delete cascade; Alter table UNIVDB1.Financial_Aid_Awards add Constraint fk_FINAID_FINAID_AWDS foreign key (REPT_TIME_FRAME, REPT_INST, PERSON_ID) references UNIVDB1.Financial_Aid_Demo (REPT_TIME_FRAME, REPT_INST, PERSON_ID) on delete cascade; Alter table UNIVDB1.Course_Meetings add Constraint fk_IAF_CRS_MTGS foreign key (REPT_INST, REPT_TIME_FRAME, SESSION_ID, CRS_PREFIX, CRS_NBR, CRS_IND, CRS_SECTN_NBR) references UNIVDB1.Instructional_Activity (REPT_INST, REPT_TIME_FRAME, SESSION_ID, CRS_PREFIX, CRS_NBR, CRS_IND, CRS_SECTN_NBR) on delete cascade; Alter table UNIVDB1.Workload_Activities add Constraint WKLD_ACT_SUMMS foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID_ACT, BE_CD_ACT, CIP_CRS, CRS_SECTN_TYP_PRI, COLLEGE, PROG_COMP_ACT, INSTR_RESRCH_ACT) references UNIVDB1.Workload_Activity_Summary (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID_ACT, BE_CD_ACT, CIP_CRS, CRS_SECTN_TYP_PRI, COLLEGE, PROG_COMP_ACT, INSTR_RESRCH_ACT) on delete cascade; Alter table UNIVDB1.Workload_Activities add Constraint WKLD_PF_ACTIVITY_DETAILS foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID) references UNIVDB1.Workload_Person_Funding (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID) on delete cascade; Alter table UNIVDB1.Workload_Activity_Summary add Constraint WKLD_PF_SUMMARIES foreign key (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID_ACT) references UNIVDB1.Workload_Person_Funding (DEMO_TIME_FRAME, REPT_INST, DEMO_DATA_SOURCE, PERSON_ID, BE_CD_EMPL, PAY_PLAN_NBR, UNIV_POSITION, DEPT_ID, UNIV_BUD_ID) on delete cascade; Alter table UNIVDB1.Employee_Data add Constraint EMPL_DEMO_EMPL_DATA foreign key (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP) references UNIVDB1.Employee_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,PERSON_ID,SUB_TYP) on delete cascade; Alter table UNIVDB1.Bldg_Plnt_Oper_Maint add Constraint fk_BLDG_POM foreign key (REPT_INST, CAMPUS_CD, BASE_YR, REPT_TIME_FRAME, SITE_NBR, BLDG_NBR) references UNIVDB1.Buildings (REPT_INST, CAMPUS_CD, BASE_YR, REPT_TIME_FRAME, SITE_NBR, BLDG_NBR) on delete cascade; Alter table UNIVDB1.Bldg_Plnt_Oper_Maint add Constraint fk_CAMPUS_POM foreign key (REPT_INST, CAMPUS_CD, BASE_YR,REPT_TIME_FRAME) references UNIVDB1.Campus (REPT_INST, CAMPUS_CD, BASE_YR,REPT_TIME_FRAME) on delete cascade; Alter table UNIVDB1.Rooms add Constraint fk_BLDG_LUK_ROOM foreign key (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR) references UNIVDB1.Buildings (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR) ; Alter table UNIVDB1.Rooms add Constraint fk_CAMPUS_LUK_ROOMS foreign key (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) references UNIVDB1.Campus (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) ; Alter table UNIVDB1.Sites add Constraint fk_CAMPUS_LUK_SITES foreign key (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) references UNIVDB1.Campus (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) ; Alter table UNIVDB1.Buildings add Constraint fk_CAMPUS_LUK_BLDGS foreign key (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) references UNIVDB1.Campus (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME) ; Alter table UNIVDB1.Bldg_Plnt_Oper_Maint add Constraint fk_SITES_POM foreign key (REPT_INST, CAMPUS_CD, BASE_YR, REPT_TIME_FRAME, SITE_NBR) references UNIVDB1.Sites (REPT_INST, CAMPUS_CD, BASE_YR, REPT_TIME_FRAME, SITE_NBR) on delete cascade; Alter table UNIVDB1.Rooms add Constraint fk_SITES_LUK_ROOMS foreign key (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR) references UNIVDB1.Sites (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR) ; Alter table UNIVDB1.Buildings add Constraint fk_SITES_LUK_BLDGS foreign key (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR) references UNIVDB1.Sites (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR) ; -- Create Table comments section Comment on table UNIVDB1.Applicants_Admits is 'By Year: Limited Access Program By Term: Admissions (prelim and final) Initial Educator Preparation' ; Comment on table UNIVDB1.Admission_Exceptions is 'Data Sources: ADM, STU, IEP 01354 - Profile Assessment Flag (ADM) 01355 - Profile Assessment Category (ADM, STU) 01200 - Exception Status (ADM) 01204 - Admissions Criteria Waiver (IEP)' ; Comment on table UNIVDB1.Tests_Reqs is 'Data Sources: ADM, LAP, IEP' ; Comment on table UNIVDB1.DOE_Pgm_Info is 'By Term: Initial Educator Preparation' ; Comment on table UNIVDB1.College_Prep is 'By Year or Term: College Prep Find matching SDCF in the year by first matching Date of Most Recent Admission. If no match found then select the first term record. At least one SDCF record in the year is required.' ; Comment on table UNIVDB1.Enrollments is 'By Term: Student (prelim and final)' ; Comment on table UNIVDB1.Courses_Taken is 'By Term: Student (prelim and final)' ; Comment on table UNIVDB1.Test_Credits is 'By Term: Student (Prelim and Final) International Baccalaureate CLEP Subject Exams English, Math, Natural Science, Humanities, Social Science, Other Advanced Placement Exam AICE Exam Department Exams Other Test Method' ; Comment on table UNIVDB1.Fellowships is 'By Term: Student (final)' ; Comment on table UNIVDB1.Stipends is 'By Term: Student (final)' ; Comment on table UNIVDB1.Fee_Waivers is 'By Term: Student (final)' ; Comment on table UNIVDB1.Degrees_Awarded is 'By Term: Student (prelim and final) Initial Educator Preparation' ; Comment on table UNIVDB1.Hours_to_Degree is 'By Year (change to by Term ????): Hours to Degree' ; Comment on table UNIVDB1.Courses_to_Degree is 'By Year (change to by Term ????): Hours to Degree' ; Comment on table UNIVDB1.Financial_Aid_Demo is 'By Fiscal Year: Student Financial Aid' ; Comment on table UNIVDB1.Financial_Aid_Awards is 'By Term: Student Financial Aid' ; Comment on table UNIVDB1.Instructional_Activity is 'By Term: Instructional Activity File' ; Comment on table UNIVDB1.Workload_Activities is 'By Term: Details of workload, effort, and credit for Instruction and Research related activities.' ; Comment on table UNIVDB1.Employee_Demo is 'SCD-type submissions are 3X annual: With Operating Budget, in January (as of December 31), July 7th (as of June 30). EMPL-type submissions are 2X annual: Mid-November (as of mid-October) and Mid-April (as of mid-March). OPS come with EMPL-type submissions.' ; Comment on table UNIVDB1.Upload_History is 'The SUBMISSION_STATUS table contains a record of when a submission was moved from the pre-production database to the production database.' ; Comment on table UNIVDB1.Uploaded_Data is 'This table contains the uploaded data. Records are deleted when a new file is uploaded or when the file is officially submitted to the BOG.' ; -- Create Attribute comments section Comment on column UNIVDB1.Person_Demo.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Person_Demo.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Person_Demo.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Person_Demo.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) in which the demographic data is reported.' ; Comment on column UNIVDB1.Person_Demo.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Person_Demo.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Person_Demo.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Person_Demo.PID_VALID_SSN is 'A code indicating whether or not Person_ID_Enc is a valid SSN (Y=yes, N=No)' ; Comment on column UNIVDB1.Person_Demo.DT_BIRTH_YYYYMMDD is '01024 - Date of Birth YYYY-MM-DD' ; Comment on column UNIVDB1.Person_Demo.NAME_LAST is '01033 - Person Name - Last' ; Comment on column UNIVDB1.Person_Demo.NAME_FIRST is '01091 - Person Name - First' ; Comment on column UNIVDB1.Person_Demo.NAME_MI is '01092 - Person Name - Middle Initial' ; Comment on column UNIVDB1.Person_Demo.SUFFIX is 'New field. Ex: JR, SR, III, MD, FAC, CRNA' ; Comment on column UNIVDB1.Person_Demo.GENDER is '01048 - Gender' ; Comment on column UNIVDB1.Person_Demo.RACE_ETHNICITY is '01044 - Racial/Ethnic Group' ; Comment on column UNIVDB1.Person_Demo.HISPANIC_FLG is '01491 - Ethnicity (Hispanic or Latino)' ; Comment on column UNIVDB1.Person_Demo.AM_IND_ALASKAN_FLG is '01492 - American Indian or Alaskan Native' ; Comment on column UNIVDB1.Person_Demo.ASIAN_FLG is '01493 - Asian' ; Comment on column UNIVDB1.Person_Demo.BLACK_AFRICAN_AM_FLG is '01494 - Black or African American' ; Comment on column UNIVDB1.Person_Demo.NAT_HAWAII_PAC_IS_FLG is '01495 - Native Hawaiian or Other Pacific Islander' ; Comment on column UNIVDB1.Person_Demo.WHITE_FLG is '01496 - White' ; Comment on column UNIVDB1.Person_Demo.NON_RES_ALIEN_FLG is 'New field' ; Comment on column UNIVDB1.Person_Demo.NO_RACE_REPORT_FLG is '01497 - No Race Reported' ; Comment on column UNIVDB1.Person_Demo.U_RESV_1 is 'New Univ Reserved Area' ; Comment on column UNIVDB1.Person_Demo.SYSID is 'Randomly assigned unique identifier for an individual' ; Comment on column UNIVDB1.Person_Demo.SYSID_SEQ is 'Importing of legacy data requires that we allow an individual to be reported on a single file multiple times. For new data we will reject duplicate records. This sequence number also allows us to handle duplicate records that are a result of a change in SSN.' ; Comment on column UNIVDB1.Applicants_Admits.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Applicants_Admits.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Applicants_Admits.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Applicants_Admits.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Applicants_Admits.APP_ADM_SOURCE is 'Source of the application/admission information contained in the current record: ADM, LAP, IEP' ; Comment on column UNIVDB1.Applicants_Admits.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Applicants_Admits.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Applicants_Admits.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (TEF,LAP)' ; Comment on column UNIVDB1.Applicants_Admits.STU_TYP is '01117 - Type of Student at Time of Application (ADM), 01413 - Type of Student at Time of Most Recent Admission (TEF) and 01142 - Limited Access Category (LAP)' ; Comment on column UNIVDB1.Applicants_Admits.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Applicants_Admits.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Applicants_Admits.FINAL_ADM_ACTION is '01135 - Final Admission Action (ADM) and 01143 - Limited Access Action (LAP)' ; Comment on column UNIVDB1.Applicants_Admits.REGISTERED_CD is '01136 - Registered Code (ADM, LAP)' ; Comment on column UNIVDB1.Applicants_Admits.COUNTY_OF_RES is '01055 - County of Residence, SUS' ; Comment on column UNIVDB1.Applicants_Admits.FEE_CLASS_RES is '01106 - Fee Classification - Residency' ; Comment on column UNIVDB1.Applicants_Admits.ADM_DEPOSIT_IND is '01151 - Admissions Deposit Indicator' ; Comment on column UNIVDB1.Applicants_Admits.STU_CLASS_LEVEL is '01060 - Student Classification Level' ; Comment on column UNIVDB1.Applicants_Admits.DISPLACED_STU_IND is '01809 - Displaced Student Indicator ' ; Comment on column UNIVDB1.Applicants_Admits.LAST_INST_CD is '01067 - Last Institution Code' ; Comment on column UNIVDB1.Applicants_Admits.INST_GRNT_HIDEG_CD is '01411 - Institution Granting Highest Degree (built from old 5-digit code by prefixing one zero and suffixing two zeroes)' ; Comment on column UNIVDB1.Applicants_Admits.DEG_HIGHEST_HELD is '01112 - Degree - Highest Level Held' ; Comment on column UNIVDB1.Applicants_Admits.LAST_POSTSEC_DT is '01169 - Date of Last Attendance YYYYMM' ; Comment on column UNIVDB1.Applicants_Admits.GPA_COLLEGE is '01270 - College GPA' ; Comment on column UNIVDB1.Applicants_Admits.HS_ETS_CD is '01069 - High School Code' ; Comment on column UNIVDB1.Applicants_Admits.LAST_SECONDARY_DT is '01169 - Date of Last Attendance YYYYMM' ; Comment on column UNIVDB1.Applicants_Admits.GPA_HIGH_SCHOOL is '01139 - High School GPA' ; Comment on column UNIVDB1.Applicants_Admits.GPA_GED_COMPONENT is '01275 - GPA - General Education Component = (IEP)' ; Comment on column UNIVDB1.Applicants_Admits.GPA_BACHELORS is '01241 - GPA - Completed Bachelors Degree Pgm = (IEP)' ; Comment on column UNIVDB1.Applicants_Admits.ESOL_UNITS is '01438 - English As A Second Language Units' ; Comment on column UNIVDB1.Applicants_Admits.DEPOSIT_AMT is '01152 - Admissions Deposit Amount' ; Comment on column UNIVDB1.Applicants_Admits.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Applicants_Admits.U_RESV_2 is 'Originally a 5-byte field' ; Comment on column UNIVDB1.Applicants_Admits.U_RESV_3 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Admission_Exceptions.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Admission_Exceptions.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Admission_Exceptions.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Admission_Exceptions.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Admission_Exceptions.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Admission_Exceptions.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Admission_Exceptions.EXCEPTION_SOURCE is 'Values: ADM, STU, STUP, TEF' ; Comment on column UNIVDB1.Admission_Exceptions.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (STU,LAP,TEF)' ; Comment on column UNIVDB1.Admission_Exceptions.STU_TYP is '01117 - Type of Student at Time of Application (ADM), 01068 - Student Data Course File (STU), 01142 - Limited Access Category (LAP)' ; Comment on column UNIVDB1.Admission_Exceptions.EXCEPTION_TYP is '01200 - Exception Status, 01354 - Profile Assessment Flag' ; Comment on column UNIVDB1.Admission_Exceptions.EXCEPTION_CAT is '01355 - Profile Assessment Category' ; Comment on column UNIVDB1.Admission_Exceptions.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Admission_Exceptions.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Admission_Exceptions.U_RESV_1 is 'New Univ Reserved Area' ; Comment on column UNIVDB1.Tests_Reqs.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Tests_Reqs.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Tests_Reqs.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Tests_Reqs.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Tests_Reqs.APP_ADM_SOURCE is 'Source of the application/admission information contained in the current record: ADM, LAP, IEP' ; Comment on column UNIVDB1.Tests_Reqs.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Tests_Reqs.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Tests_Reqs.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (LAP)' ; Comment on column UNIVDB1.Tests_Reqs.STU_TYP is '01117 - Type of Student at Time of Application (ADM) and 01142 - Limited Access Category (LAP)' ; Comment on column UNIVDB1.Tests_Reqs.TCHR_PREP_DOE_CD is '01425 - State-Approved Teacher Prep Pgm - DOE Code' ; Comment on column UNIVDB1.Tests_Reqs.TEST_REQ_CD is 'Test or Requirement Code' ; Comment on column UNIVDB1.Tests_Reqs.TEST_SCORE_TYP is 'Type of score reported' ; Comment on column UNIVDB1.Tests_Reqs.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported.' ; Comment on column UNIVDB1.Tests_Reqs.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Tests_Reqs.TEST_SCORE_N is '01168 - Verbal/Other Score' ; Comment on column UNIVDB1.Tests_Reqs.TEST_SCORE_A is 'P/F/K (Pass or Fail or Presumed Pass with valid educator certification [Educator Prep only])' ; Comment on column UNIVDB1.Tests_Reqs.REQ_MET is 'Was the requirement met ? Y/N/I ( I=Incomplete)' ; Comment on column UNIVDB1.Tests_Reqs.U_RESV_1 is 'New Univ Reserved Area' ; Comment on column UNIVDB1.DOE_Pgm_Info.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.DOE_Pgm_Info.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.DOE_Pgm_Info.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.DOE_Pgm_Info.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.DOE_Pgm_Info.APP_ADM_SOURCE is 'Source of the application/admission information contained in the current record: ADM, LAP, IEP' ; Comment on column UNIVDB1.DOE_Pgm_Info.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.DOE_Pgm_Info.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.DOE_Pgm_Info.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (LAP)' ; Comment on column UNIVDB1.DOE_Pgm_Info.STU_TYP is '01117 - Type of Student at Time of Application (ADM) and 01142 - Limited Access Category (LAP)' ; Comment on column UNIVDB1.DOE_Pgm_Info.TCHR_PREP_DOE_CD is '01425 - State-Approved Teacher Prep Pgm - DOE Code' ; Comment on column UNIVDB1.DOE_Pgm_Info.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.DOE_Pgm_Info.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.DOE_Pgm_Info.TCHR_PREP_DOE_LEVEL is '01423 - State-Approved Teacher Prep Pgm - DOE Level' ; Comment on column UNIVDB1.DOE_Pgm_Info.TCHR_REG_CD is '01260 - State-Approved Teacher Prep Pgm-Registered Code' ; Comment on column UNIVDB1.DOE_Pgm_Info.TCHR_TERM_ADMIT is '01428 - State-Approved Teacher Prep Pgm-Admission Term' ; Comment on column UNIVDB1.DOE_Pgm_Info.TCHR_EDU_PGM_METHOD is '01436 - Teacher Education Program Method' ; Comment on column UNIVDB1.DOE_Pgm_Info.CIP_DEGREE is '01082 - Degree Program Category' ; Comment on column UNIVDB1.DOE_Pgm_Info.SEC_SITE is '01150 - State Approved Teacher Prep Pgm - SECONDARY SITE' ; Comment on column UNIVDB1.DOE_Pgm_Info.U_RESV_1 is 'Originally a 5-byte field' ; Comment on column UNIVDB1.College_Prep.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.College_Prep.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.College_Prep.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.College_Prep.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.College_Prep.CP_SOURCE is 'Source of the college prep information contained in the current record: ADM, CP' ; Comment on column UNIVDB1.College_Prep.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.College_Prep.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.College_Prep.REMEDIATION_AREA is '01144 - Remediation Area' ; Comment on column UNIVDB1.College_Prep.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.College_Prep.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.College_Prep.REMEDIATION_TEST is '01145 - Test Determining Remediation' ; Comment on column UNIVDB1.College_Prep.TERM_RESULT_RPTD is 'This will be REPT_TIME_FRAME from the SDCF term in which the completion result was reported (was 01522 - Year - Academic)' ; Comment on column UNIVDB1.College_Prep.REMEDIATION_COMP is '01146 - Remediation Completion Method' ; Comment on column UNIVDB1.College_Prep.COMM_COLL_CD is '01147 - Community College Code (built from old 5-digit code by prefixing one zero and suffixing two zeroes)' ; Comment on column UNIVDB1.College_Prep.CRS_PREFIX is '01195 - Common Course Prefix' ; Comment on column UNIVDB1.College_Prep.CRS_NBR is '01196 - Common Course Number' ; Comment on column UNIVDB1.College_Prep.CRS_IND is '01003 - Common Course Outside Indicator' ; Comment on column UNIVDB1.College_Prep.REMEDIATION_INCOMP is '01148 - Remediation Incompletion Code' ; Comment on column UNIVDB1.College_Prep.U_RESV_1 is 'Originally a 5-byte field' ; Comment on column UNIVDB1.Enrollments.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Enrollments.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Enrollments.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Enrollments.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Enrollments.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Enrollments.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Enrollments.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Enrollments.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Enrollments.NATION_CITIZ is '01110 - Nation of Citizenship' ; Comment on column UNIVDB1.Enrollments.STATE_ADM is '01111 - State Code at Time of Admission' ; Comment on column UNIVDB1.Enrollments.COUNTY_OF_RES is '01055 - County of Residence, SUS' ; Comment on column UNIVDB1.Enrollments.NAT_MERIT_SCH_IND is '01407 - National Merit Scholar Indicator' ; Comment on column UNIVDB1.Enrollments.DISPLACED_STU_IND is '01809 - Displaced Student Indicator ' ; Comment on column UNIVDB1.Enrollments.INST_DISPLACED_FROM is '01810 - Institution Displaced From (built from old 5-digit code by prefixing one zero and suffixing two zeroes)' ; Comment on column UNIVDB1.Enrollments.HS_ETS_CD is '01069 - High School Code' ; Comment on column UNIVDB1.Enrollments.LAST_SECONDARY_DT is '01169 - Date of Last Attendance YYYYMM' ; Comment on column UNIVDB1.Enrollments.DUAL_ENROLL_IND is '01070 - Dual Enrollment Identification' ; Comment on column UNIVDB1.Enrollments.LAST_INST_CD is '01067 - Last Institution Code (built from old 5-digit code by prefixing one zero and suffixing two zeroes)' ; Comment on column UNIVDB1.Enrollments.LAST_POSTSEC_DT is '01169 - Date of Last Attendance YYYYMM' ; Comment on column UNIVDB1.Enrollments.STU_ENTRY_TYP is '01068 - Type of Student at Date of Entry' ; Comment on column UNIVDB1.Enrollments.STU_ENTRY_DT is '01064 - Student Date of Entry' ; Comment on column UNIVDB1.Enrollments.STU_RECENT_ADM_TYP is '01413 - Type of Student at Time of Most Recent Admission' ; Comment on column UNIVDB1.Enrollments.STU_RECENT_ADM_DT is '01420 - Date of Most Recent Admission' ; Comment on column UNIVDB1.Enrollments.FIRST_GEN_IND is '01812 - First Generation Indicator' ; Comment on column UNIVDB1.Enrollments.FEE_CLASS_RES is '01106 - Fee Classification - Residency' ; Comment on column UNIVDB1.Enrollments.CLAST_IND is '01244 - College Level Academic Skills Test Flag' ; Comment on column UNIVDB1.Enrollments.MAX_CRED_TEACH_FLG is '01057 - Maximum Credit in Supervised Teaching' ; Comment on column UNIVDB1.Enrollments.MAX_CRED_RESEARCH_FLG is '01058 - Maximum Credit in Supervised Research' ; Comment on column UNIVDB1.Enrollments.DOC_CANDIDACY_FLG is '01059 - Doctoral Candidacy Flag' ; Comment on column UNIVDB1.Enrollments.STU_CLASS_LEVEL is '01060 - Student Classification Level' ; Comment on column UNIVDB1.Enrollments.CIP_STUDENT is '01062 - Student Program Category' ; Comment on column UNIVDB1.Enrollments.DEG_HIGHEST_HELD is '01112 - Degree - Highest Level Held' ; Comment on column UNIVDB1.Enrollments.INST_GRNT_HIDEG_CD is '01411 - Institution Granting Highest Degree (built from old 5-digit code by prefixing one zero and suffixing two zeroes)' ; Comment on column UNIVDB1.Enrollments.DEG_LEVEL_SOUGHT is '01053 - Degree - Level Sought' ; Comment on column UNIVDB1.Enrollments.DOC_CLASS is 'IPEDS Reclassificaiton of First-Professional Degree Level Sought' ; Comment on column UNIVDB1.Enrollments.BE_CD is '01065 - Student Budget Entity' ; Comment on column UNIVDB1.Enrollments.FIRSTYR_FIRSTPROF_FLG is '01269 - First Year First Professional Flag' ; Comment on column UNIVDB1.Enrollments.TERMINATION_CD is '01071 - Termination Code' ; Comment on column UNIVDB1.Enrollments.EXT_PGM_FLG is '01408 - Extended Program Flag' ; Comment on column UNIVDB1.Enrollments.VISA_TYP is '01816 - Current Visa Type' ; Comment on column UNIVDB1.Enrollments.INST_CLASS_LVL_STU is '01267 - Institutional Classification Level of Student' ; Comment on column UNIVDB1.Enrollments.FULL_PART_TIME_IND is '01458 - FTIC Full-Time Indicator-Entering Term' ; Comment on column UNIVDB1.Enrollments.CURR_TERM_CRS_LOAD is '01063 - Current Term Course Load' ; Comment on column UNIVDB1.Enrollments.CUM_HRS_ACCEPT_TRN is '01061 - Cumulative Hours Accepted (Transfer)' ; Comment on column UNIVDB1.Enrollments.GPA_INST_HRS is '01085 - Institutional Hours for GPA' ; Comment on column UNIVDB1.Enrollments.GPA_INST_GRD_PTS is '01086 - Total Institutional Grade Points' ; Comment on column UNIVDB1.Enrollments.TOT_HRS_DEG_LVL is '01087 - Total Hours Earned at Current Student Degree Level' ; Comment on column UNIVDB1.Enrollments.GPA_TERM_CRED_HRS is '01088 - Term Credit Hours for GPA' ; Comment on column UNIVDB1.Enrollments.GPA_TERM_HRS is '01089 - Term Credit Hours Earned' ; Comment on column UNIVDB1.Enrollments.GPA_TERM_GRD_PTS is '01090 - Term Grade Points Earned' ; Comment on column UNIVDB1.Enrollments.U_RESV_1 is 'Originally a 20-byte field' ; Comment on column UNIVDB1.Enrollments.U_RESV_2 is 'Originally a 20-byte field' ; Comment on column UNIVDB1.Enrollments.IPEDS_GRADSTU_FLG is '01220 - IPEDS Unclassified Student Flag' ; Comment on column UNIVDB1.Enrollments.WAIVER_HR_GRAD_STU is '01410 - Waiver Hours Generated By Graduate Students' ; Comment on column UNIVDB1.Enrollments.GPA_TERM is 'TERM_GRD_PNTS_EARN / TERM_CRD_HRS_GPA' ; Comment on column UNIVDB1.Enrollments.GPA_CUM is '(TOT_INST_GRD_PTS + TERM_GRD_PNTS_EARN) / (INST_HRS_GPA + TERM_CRD_HRS_GPA)' ; Comment on column UNIVDB1.Courses_Taken.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Courses_Taken.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Courses_Taken.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Courses_Taken.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Courses_Taken.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Courses_Taken.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Courses_Taken.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Courses_Taken.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Courses_Taken.SEGMENT_SEQ is 'Segment Counter' ; Comment on column UNIVDB1.Courses_Taken.CRS_PREFIX is '01195 - Common Course Prefix' ; Comment on column UNIVDB1.Courses_Taken.CRS_NBR is '01196 - Common Course Number' ; Comment on column UNIVDB1.Courses_Taken.CRS_IND is '01003 - Common Course Outside Indicator' ; Comment on column UNIVDB1.Courses_Taken.CRS_SECTN_NBR is '01096 - Course Section Number' ; Comment on column UNIVDB1.Courses_Taken.STU_SECTN_CRED is '01097 - Student Section Credit' ; Comment on column UNIVDB1.Courses_Taken.CIP_CRS is '01098 - Course Program Category' ; Comment on column UNIVDB1.Courses_Taken.CAMPUS_CD is '01099 - Course Section Location - Campus' ; Comment on column UNIVDB1.Courses_Taken.CRS_SECTN_LOC_CNTY is '01127 - Course Section Location - County' ; Comment on column UNIVDB1.Courses_Taken.BE_CD is '01100 - Course Budget Entity Code' ; Comment on column UNIVDB1.Courses_Taken.CONT_COOP_ED_IND is '01101 - Continuing and Cooperative Education Flag' ; Comment on column UNIVDB1.Courses_Taken.GRADE_AWARDED is '01102 - Grade Awarded' ; Comment on column UNIVDB1.Courses_Taken.STU_SECTN_FUND_CD is '01103 - Student Section Funding Flag' ; Comment on column UNIVDB1.Courses_Taken.COLLEGE is '01507 - College (Subcomponent)' ; Comment on column UNIVDB1.Courses_Taken.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type' ; Comment on column UNIVDB1.Courses_Taken.PRELIM_FILE_FLG is '01105 - Preliminary File Flag' ; Comment on column UNIVDB1.Courses_Taken.INST_OUTSIDE_IND is '01010 - Institutional Outside Indicator' ; Comment on column UNIVDB1.Courses_Taken.DEPT_ID_CRS is '01198 - Account/Department Number - Course' ; Comment on column UNIVDB1.Courses_Taken.DIFF_TUITION_FLG is '01359 - Differential Tuition Flag' ; Comment on column UNIVDB1.Courses_Taken.U_RESV_1 is 'Originally a 2-byte field' ; Comment on column UNIVDB1.Courses_Taken.U_RESV_2 is 'Originally a 4-byte field' ; Comment on column UNIVDB1.Courses_Taken.CRS_LEVEL_CLASS is '01285 - Course Level Classification' ; Comment on column UNIVDB1.Courses_Taken.ST_FUND_CRED_HRS is '01286 - State Fundable Credit Hours' ; Comment on column UNIVDB1.Test_Credits.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Test_Credits.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Test_Credits.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Test_Credits.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Test_Credits.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Test_Credits.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Test_Credits.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Test_Credits.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Test_Credits.TEST_TYP is 'Type of advanced placement credit' ; Comment on column UNIVDB1.Test_Credits.TEST_CREDS is 'Number of advanced placement credits earned this term.' ; Comment on column UNIVDB1.Test_Credits.U_RESV_1 is 'New Univ Reserved Area' ; Comment on column UNIVDB1.Fellowships.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Fellowships.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Fellowships.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Fellowships.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported.' ; Comment on column UNIVDB1.Fellowships.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Fellowships.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Fellowships.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Fellowships.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Fellowships.SEGMENT_SEQ is 'Segment Counter' ; Comment on column UNIVDB1.Fellowships.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Fellowships.TERM_AMOUNT is '01401 - Term Amount' ; Comment on column UNIVDB1.Fellowships.UNIV_FUND_ID is '01400 - University Fund Identifier' ; Comment on column UNIVDB1.Fellowships.U_RESV_1 is 'Originally a 7-byte field' ; Comment on column UNIVDB1.Stipends.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Stipends.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Stipends.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Stipends.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Stipends.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Stipends.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Stipends.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Stipends.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Stipends.SEGMENT_SEQ is 'Segment Counter' ; Comment on column UNIVDB1.Stipends.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Stipends.TERM_AMOUNT is '01401 - Term Amount' ; Comment on column UNIVDB1.Stipends.UNIV_FUND_ID is '01400 - University Fund Identifier' ; Comment on column UNIVDB1.Stipends.FTE_TERM_PORTION is '01404 - Term Portion of Effort' ; Comment on column UNIVDB1.Stipends.HRLY_PAY_RATE is '01402 - Hourly Rate of Pay' ; Comment on column UNIVDB1.Stipends.SESSION_ID is '01405 - Session Flag' ; Comment on column UNIVDB1.Stipends.CLASS_CD is '01014 - Classification Code' ; Comment on column UNIVDB1.Stipends.CIP_ACCT_DEPT is '01013 - Account/Department CIP' ; Comment on column UNIVDB1.Stipends.NBR_HRS_WRK_TERM is '01406 - Number of Hours Worked in Reported Term' ; Comment on column UNIVDB1.Stipends.U_RESV_1 is 'Originally a 7-byte field' ; Comment on column UNIVDB1.Fee_Waivers.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Fee_Waivers.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Fee_Waivers.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Fee_Waivers.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Fee_Waivers.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Fee_Waivers.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Fee_Waivers.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Fee_Waivers.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Fee_Waivers.SEGMENT_SEQ is 'Segment Counter' ; Comment on column UNIVDB1.Fee_Waivers.FEE_WAIVER_IND is '01463 - Waiver Indicator/3rd Party Indicator' ; Comment on column UNIVDB1.Fee_Waivers.FEE_WAIVER_KIND is '01108 - Fee Waiver Kind/3rd Party Kind' ; Comment on column UNIVDB1.Fee_Waivers.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Fee_Waivers.TERM_AMOUNT is '01401 - Term Amount' ; Comment on column UNIVDB1.Fee_Waivers.UNIV_FUND_ID is '01400 - University Fund Identifier' ; Comment on column UNIVDB1.Fee_Waivers.LINK_INST is '01815 - Linkage Institute' ; Comment on column UNIVDB1.Fee_Waivers.U_RESV_1 is 'Originally a 6-byte field' ; Comment on column UNIVDB1.Degrees_Awarded.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Degrees_Awarded.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Degrees_Awarded.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Degrees_Awarded.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Degrees_Awarded.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Degrees_Awarded.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Degrees_Awarded.FEE_CLASS_KIND is '01107 - Fee Classification - Kind' ; Comment on column UNIVDB1.Degrees_Awarded.TERM_DEG_GRANT is '01412 - Term Degree Granted' ; Comment on column UNIVDB1.Degrees_Awarded.DEG_LEVEL_GRANT is '01081 - Degree - Level Granted' ; Comment on column UNIVDB1.Degrees_Awarded.CIP_DEGREE is '01082 - Degree Program Category' ; Comment on column UNIVDB1.Degrees_Awarded.MAJOR_IND is 'Major Indicator (1=First, 2=Second, 3=Third, etc.)' ; Comment on column UNIVDB1.Degrees_Awarded.TCHR_PREP_DOE_CD is '01425 - State-Approved Teacher Prep Pgm - DOE Code (Default to ''999'')' ; Comment on column UNIVDB1.Degrees_Awarded.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Degrees_Awarded.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Degrees_Awarded.AWARD_SOURCE is 'Source of the award contained in the current record: SIF, HTD, TEF, DEG' ; Comment on column UNIVDB1.Degrees_Awarded.TCHR_PREP_DOE_LEVEL is '01423 - State-Approved Teacher Prep Pgm - DOE Level' ; Comment on column UNIVDB1.Degrees_Awarded.TCHR_EDU_PGM_METHOD is '01436 - Teacher Education Program Method' ; Comment on column UNIVDB1.Degrees_Awarded.CIP_FRAC_DEG is '01083 - Degree Program Fraction of Degree Granted' ; Comment on column UNIVDB1.Degrees_Awarded.DOC_CLASS is 'IPEDS Reclassificaiton of First-Professional Degree Level Granted' ; Comment on column UNIVDB1.Degrees_Awarded.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Degrees_Awarded.U_RESV_1 is 'New Univ Reserved Area' ; Comment on column UNIVDB1.Hours_to_Degree.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Hours_to_Degree.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Hours_to_Degree.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Hours_to_Degree.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Hours_to_Degree.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Hours_to_Degree.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Hours_to_Degree.TERM_DEG_GRANT is '01412 - Term Degree Granted' ; Comment on column UNIVDB1.Hours_to_Degree.DEG_LEVEL_GRANT is '01081 - Degree - Level Granted' ; Comment on column UNIVDB1.Hours_to_Degree.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported.' ; Comment on column UNIVDB1.Hours_to_Degree.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Hours_to_Degree.CIP_DEGREE is '01082 - Degree Program Category' ; Comment on column UNIVDB1.Hours_to_Degree.HS_GRAD_DT is '01471 - High School Graduation Date' ; Comment on column UNIVDB1.Hours_to_Degree.CATALOG_TERM is '01476 - Catalog - Term for Degree YYYYMM' ; Comment on column UNIVDB1.Hours_to_Degree.CATALOG_HRS is '01477 - Catalog - Hours to Degree' ; Comment on column UNIVDB1.Hours_to_Degree.NBR_CIP_CHGS is '01435 - Number of Degree Program Changes' ; Comment on column UNIVDB1.Hours_to_Degree.TERM_UPPER is '01481 - Term - Upper Level YYYYMM' ; Comment on column UNIVDB1.Hours_to_Degree.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Hours_to_Degree.U_RESV_2 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Hours_to_Degree.U_RESV_3 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Hours_to_Degree.U_RESV_4 is 'Originally a 15-byte field' ; Comment on column UNIVDB1.Hours_to_Degree.HRS_USED is '01478 - Hours Used to Degree' ; Comment on column UNIVDB1.Hours_to_Degree.EXCESS_HRS_SUS is '01480 - Excess Hours - SUS ' ; Comment on column UNIVDB1.Hours_to_Degree.EXCESS_HRS_NATIVE is '01479 - Excess Hours - Native ' ; Comment on column UNIVDB1.Courses_to_Degree.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Courses_to_Degree.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Courses_to_Degree.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Courses_to_Degree.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Courses_to_Degree.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Courses_to_Degree.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Courses_to_Degree.TERM_DEG_GRANT is '01412 - Term Degree Granted' ; Comment on column UNIVDB1.Courses_to_Degree.DEG_LEVEL_GRANT is '01081 - Degree - Level Granted' ; Comment on column UNIVDB1.Courses_to_Degree.TERM_TAKEN is '01051 - Term Identifier of the term when the course was taken' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_INST_CD is '01482 - Institution Code - Course' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_PREFIX is '01195 - Common Course Prefix' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_NBR is '01196 - Common Course Number' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_IND is '01003 - Common Course Outside Indicator' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_SECTN_NBR is '01096 - Course Section Number' ; Comment on column UNIVDB1.Courses_to_Degree.SEGMENT_SEQ is 'Segment Counter' ; Comment on column UNIVDB1.Courses_to_Degree.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Courses_to_Degree.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Courses_to_Degree.STU_CLASS_LEVEL is '01483 - Course - Student Classification Level' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_SYSTEM is '01484 - Course System Code' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_GROUP is '01485 - Course Grouping Code' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_RESULT is '01486 - Course Result Code' ; Comment on column UNIVDB1.Courses_to_Degree.REPEAT_IND is '01487 - Repeat Indicator' ; Comment on column UNIVDB1.Courses_to_Degree.CIP_CRS is '01098 - Course Program Category' ; Comment on column UNIVDB1.Courses_to_Degree.CRS_SECTN_TYP is '01104 - Course Section Type' ; Comment on column UNIVDB1.Courses_to_Degree.TEST_METHOD is '01488 - Credit Hour Testing Method' ; Comment on column UNIVDB1.Courses_to_Degree.GRADE_AWARDED is '01102 - Grade Awarded' ; Comment on column UNIVDB1.Courses_to_Degree.USAGE_IND is '01489 - Credit Hour Usage Indicator' ; Comment on column UNIVDB1.Courses_to_Degree.SECTN_CRED is '01459 - Section Credit' ; Comment on column UNIVDB1.Courses_to_Degree.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Courses_to_Degree.U_RESV_2 is 'Originally a 25-byte field' ; Comment on column UNIVDB1.Financial_Aid_Demo.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Financial_Aid_Demo.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Financial_Aid_Demo.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Financial_Aid_Demo.REPT_TIME_FRAME is 'Financial aid year (YYYYYYYY) to which the reported data applies.' ; Comment on column UNIVDB1.Financial_Aid_Demo.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Financial_Aid_Demo.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Financial_Aid_Demo.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Financial_Aid_Demo.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Financial_Aid_Demo.CURR_DEPEND_STAT is '01248 - Student Current Dependency Status' ; Comment on column UNIVDB1.Financial_Aid_Demo.FAMILY_INCOME is '01249 - Family Income' ; Comment on column UNIVDB1.Financial_Aid_Demo.FAMILY_CONTRIB is '01250 - Expected Family Contribution' ; Comment on column UNIVDB1.Financial_Aid_Demo.FEE_CLASS_RES is '01106 - Fee Classification - Residency' ; Comment on column UNIVDB1.Financial_Aid_Demo.STU_ENTRY_TYP is '01068 - Type of Student at Date of Entry' ; Comment on column UNIVDB1.Financial_Aid_Demo.STU_CLASS_LEVEL is '01060 - Student Classification Level' ; Comment on column UNIVDB1.Financial_Aid_Demo.CIP_STUDENT is '01062 - Student Program Category' ; Comment on column UNIVDB1.Financial_Aid_Demo.FINAID_NEED is '01251 - Financial Aid Need' ; Comment on column UNIVDB1.Financial_Aid_Demo.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Financial_Aid_Demo.U_RESV_2 is 'Originally a 20-byte field' ; Comment on column UNIVDB1.Financial_Aid_Demo.NEED_BASED_AID_IND is '01446 - Need Based Aid Flag' ; Comment on column UNIVDB1.Financial_Aid_Awards.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Financial_Aid_Awards.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Financial_Aid_Awards.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Financial_Aid_Awards.REPT_TIME_FRAME is 'Financial aid year (YYYYYYYY) to which the reported data applies.' ; Comment on column UNIVDB1.Financial_Aid_Awards.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Financial_Aid_Awards.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Financial_Aid_Awards.AWARD_PAYMENT_TERM is 'Term of the award' ; Comment on column UNIVDB1.Financial_Aid_Awards.AWARD_PROG_ID is '01253 - Financial Aid Award Program Identifier' ; Comment on column UNIVDB1.Financial_Aid_Awards.AWARD_COND_ID is '01254 - Financial Aid Award Condition I.D.' ; Comment on column UNIVDB1.Financial_Aid_Awards.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Financial_Aid_Awards.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Financial_Aid_Awards.SOURCE_FUNDS is '01255 - Source of Funds' ; Comment on column UNIVDB1.Financial_Aid_Awards.TERM_AMOUNT is '01256 thru 01259 - Summer1/Fall/Spring/Summer2 Paid Amount' ; Comment on column UNIVDB1.Financial_Aid_Awards.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Instructional_Activity.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Instructional_Activity.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Instructional_Activity.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Instructional_Activity.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Instructional_Activity.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies' ; Comment on column UNIVDB1.Instructional_Activity.SESSION_ID is '01405 - Session Flag' ; Comment on column UNIVDB1.Instructional_Activity.CRS_PREFIX is '01195 - Common Course Prefix' ; Comment on column UNIVDB1.Instructional_Activity.CRS_NBR is '01196 - Common Course Number' ; Comment on column UNIVDB1.Instructional_Activity.CRS_IND is '01003 - Common Course Outside Indicator' ; Comment on column UNIVDB1.Instructional_Activity.CRS_SECTN_NBR is '01096 - Course Section Number' ; Comment on column UNIVDB1.Instructional_Activity.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type' ; Comment on column UNIVDB1.Instructional_Activity.VAR_CRED_FLG is '01114 - Variable Credit Flag' ; Comment on column UNIVDB1.Instructional_Activity.CIP_CRS is '01098 - Course Program Category' ; Comment on column UNIVDB1.Instructional_Activity.BE_CD_CRS is '01100 - Course Budget Entity Code' ; Comment on column UNIVDB1.Instructional_Activity.DEPT_ID_CRS is '01198 - Account/Department Number - Course' ; Comment on column UNIVDB1.Instructional_Activity.SECTN_ENROLL_CRED is '01124 - Section Enrollment for Credit' ; Comment on column UNIVDB1.Instructional_Activity.CRS_CRED_HRS is '01128 - Course Credit Hours' ; Comment on column UNIVDB1.Instructional_Activity.ACT_SECTN_INSTR_HRS is '01113 - Actual Section Instruction Hours' ; Comment on column UNIVDB1.Instructional_Activity.DELIVERY_IND is '01417 - Instructional Delivery Indicator (sunsetted 8/1/2008)' ; Comment on column UNIVDB1.Instructional_Activity.TECH_IND_PRIMARY is '01418 - Technology Delivery Indicator' ; Comment on column UNIVDB1.Instructional_Activity.TECH_IND_SECONDARY is '01418 - Technology Delivery Indicator' ; Comment on column UNIVDB1.Instructional_Activity.TECH_IND_TERTIARY is '01418 - Technology Delivery Indicator' ; Comment on column UNIVDB1.Instructional_Activity.COUNTRY_CD is '011703 - Country Code' ; Comment on column UNIVDB1.Instructional_Activity.U_RESV_1 is 'Originally a 20-byte field' ; Comment on column UNIVDB1.Instructional_Activity.U_RESV_2 is 'Originally a 20-byte field' ; Comment on column UNIVDB1.Instructional_Activity.DLF_CHARGED is '01416 - Distance Learning Fee Charged (effective 8/5/2008)' ; Comment on column UNIVDB1.Course_Meetings.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Course_Meetings.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Course_Meetings.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Course_Meetings.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Course_Meetings.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies' ; Comment on column UNIVDB1.Course_Meetings.SESSION_ID is '01405 - Session Flag' ; Comment on column UNIVDB1.Course_Meetings.CRS_PREFIX is '01195 - Common Course Prefix' ; Comment on column UNIVDB1.Course_Meetings.CRS_NBR is '01196 - Common Course Number' ; Comment on column UNIVDB1.Course_Meetings.CRS_IND is '01003 - Common Course Outside Indicator' ; Comment on column UNIVDB1.Course_Meetings.CRS_SECTN_NBR is '01096 - Course Section Number' ; Comment on column UNIVDB1.Course_Meetings.CRS_SECTN_BEG_TIME is '01120 - Beginning Time of Course Section' ; Comment on column UNIVDB1.Course_Meetings.CRS_SECTN_END_TIME is '01121 - Ending Time of Course Section' ; Comment on column UNIVDB1.Course_Meetings.SUNDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.MONDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.TUESDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.WEDNESDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.THURSDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.FRIDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.SATURDAY is '01123 - Days of Class Meeting' ; Comment on column UNIVDB1.Course_Meetings.BLDG_NBR is '01130 - Building Number' ; Comment on column UNIVDB1.Course_Meetings.ROOM_NBR_PREFIX is '01132 - Room Number Prefix' ; Comment on column UNIVDB1.Course_Meetings.ROOM_NBR_DIGITS is '01133 - Room Number Digits' ; Comment on column UNIVDB1.Course_Meetings.ROOM_NBR_SUFFIX is '01134 - Room Number Suffix' ; Comment on column UNIVDB1.Course_Meetings.UNSCHED_MTG_IND is '01197 - Unscheduled Meeting Time Flag' ; Comment on column UNIVDB1.Course_Meetings.CRS_SECTN_TYP is '01104 - Course Section Type' ; Comment on column UNIVDB1.Course_Meetings.CAMPUS_CD is '01099 - Course Section Location - Campus; Legacy 2-character Campus Code is right-justified, zero-filled' ; Comment on column UNIVDB1.Course_Meetings.CRS_SECTN_LOC_CNTY is '01127 - Course Section Location - County' ; Comment on column UNIVDB1.Course_Meetings.ZIP is '10048 - Site Zone Identification Postal' ; Comment on column UNIVDB1.Course_Meetings.NBR_WKS_MET is 'The number of weeks in the term that this course meets. Partial weeks should be rounded up.' ; Comment on column UNIVDB1.Course_Meetings.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Sites.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Sites.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Sites.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Sites.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Sites.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Sites.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)' ; Comment on column UNIVDB1.Sites.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies' ; Comment on column UNIVDB1.Sites.SITE_NBR is '10062 - Site Number' ; Comment on column UNIVDB1.Sites.NAME is '10042 - Site Name' ; Comment on column UNIVDB1.Sites.STREET_ADDR is '10043 - Site Street Address' ; Comment on column UNIVDB1.Sites.CITY_LOC is '10044 - Site City Location' ; Comment on column UNIVDB1.Sites.ZIP is '10048 - Site Zone Identification Postal' ; Comment on column UNIVDB1.Sites.ACRES is '10045 - Site Area' ; Comment on column UNIVDB1.Sites.OWNERSHIP is '10056 - Site Ownership' ; Comment on column UNIVDB1.Sites.USAGE is '10057 - Site Type' ; Comment on column UNIVDB1.Sites.ACQUIS_YR is '10024 - Site Year of Acquisition' ; Comment on column UNIVDB1.Sites.PARKING is '10049 - Site Parking' ; Comment on column UNIVDB1.Sites.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Sites.U_RESV_2 is 'Originally a 14-byte field' ; Comment on column UNIVDB1.Sites.OWN_BLDG_CNT is '10046 - Site Number of Owned Buildings' ; Comment on column UNIVDB1.Sites.OWN_BLDG_AREA is '10047 - Site Owned Building Area' ; Comment on column UNIVDB1.Buildings.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Buildings.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Buildings.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Buildings.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Buildings.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Buildings.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)' ; Comment on column UNIVDB1.Buildings.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies' ; Comment on column UNIVDB1.Buildings.SITE_NBR is '10062 - Site Number' ; Comment on column UNIVDB1.Buildings.BLDG_NBR is '01130 - Building Number' ; Comment on column UNIVDB1.Buildings.NAME is '10011 - Building Name' ; Comment on column UNIVDB1.Buildings.OWNERSHIP is '10021 - Building Ownership' ; Comment on column UNIVDB1.Buildings.STATUS is '10012 - Building Status' ; Comment on column UNIVDB1.Buildings.STRUCTURE is '10017 - Building Structure' ; Comment on column UNIVDB1.Buildings.EXTERIOR is '10018 - Building Exterior' ; Comment on column UNIVDB1.Buildings.CONDITION_BLDG is '10035 - Building Condition' ; Comment on column UNIVDB1.Buildings.STU_RES_HOUS_FLG is '10013 - Student Residential Housing Flag' ; Comment on column UNIVDB1.Buildings.JOINT_USE_IND is '10015 - Building Joint-Use Indicator' ; Comment on column UNIVDB1.Buildings.CONSTRUCT_YR is '10019 - Building Construction Year' ; Comment on column UNIVDB1.Buildings.OCCUPY_DT is '10020 - Building Occupancy Date YYYYMM' ; Comment on column UNIVDB1.Buildings.ALTER_YR is '10022 - Building Structural Alteration Year' ; Comment on column UNIVDB1.Buildings.SURVEY_YR is '10066 - Building Survey Year' ; Comment on column UNIVDB1.Buildings.GSF is '10025 - Building Gross Square Feet' ; Comment on column UNIVDB1.Buildings.BE_CD_BLDG is '10055 - Building Budget Entity Code' ; Comment on column UNIVDB1.Buildings.ENV_COND is '10067 - Building Envelope Condition' ; Comment on column UNIVDB1.Buildings.ROOF_COND is '10068 - Building Roof System Condition' ; Comment on column UNIVDB1.Buildings.MECH_COND is '10069 - Building Mechanical System Condition' ; Comment on column UNIVDB1.Buildings.ELEC_COND is '10070 - Building Electrical System Condition' ; Comment on column UNIVDB1.Buildings.PLMB_COND is '10071 - Building Plumbing System Condition' ; Comment on column UNIVDB1.Buildings.U_RESV_1 is 'Originally a 20-byte field' ; Comment on column UNIVDB1.Rooms.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Rooms.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Rooms.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Rooms.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Rooms.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Rooms.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)' ; Comment on column UNIVDB1.Rooms.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies' ; Comment on column UNIVDB1.Rooms.SITE_NBR is '10062 - Site Number' ; Comment on column UNIVDB1.Rooms.BLDG_NBR is '01130 - Building Number' ; Comment on column UNIVDB1.Rooms.ROOM_NBR_PREFIX is '01132 - Room Number Prefix' ; Comment on column UNIVDB1.Rooms.ROOM_NBR_DIGITS is '01133 - Room Number Digits' ; Comment on column UNIVDB1.Rooms.ROOM_NBR_SUFFIX is '01134 - Room Number Suffix' ; Comment on column UNIVDB1.Rooms.FLOOR_LEVEL is '10007 - Room Floor Level' ; Comment on column UNIVDB1.Rooms.PRORATION is '10001 - Room Proration' ; Comment on column UNIVDB1.Rooms.NAME is '10037 - Room Name' ; Comment on column UNIVDB1.Rooms.USE_CD is '10002 - Room Use Code' ; Comment on column UNIVDB1.Rooms.CATEGORY is '10003 - Room Category' ; Comment on column UNIVDB1.Rooms.CAPACITY_ACTUAL is '10010 - Room Capacity - Actual' ; Comment on column UNIVDB1.Rooms.CAPACITY_DESIGN is '10009 - Room Capacity - Design' ; Comment on column UNIVDB1.Rooms.CONDITION_ROOM is '10040 - Room Condition' ; Comment on column UNIVDB1.Rooms.PCS_PROG is '10005 - Room Program (PCS)' ; Comment on column UNIVDB1.Rooms.SHARED_USE is '10039 - Room Joint-Use Indicator' ; Comment on column UNIVDB1.Rooms.NEEDS_GEN_ELIG is '10029 - Room Fixed Capital Outlay Exemption Code (Needs Generation Formula Eligible)' ; Comment on column UNIVDB1.Rooms.NET_AREA is '10008 - Room Area' ; Comment on column UNIVDB1.Rooms.BE_CD_POM is '10004 - Room Budget Entity - POM' ; Comment on column UNIVDB1.Rooms.BE_CD_USER is '10063 - Room Budget Entity - User' ; Comment on column UNIVDB1.Rooms.U_RESV_1 is 'Originally a 24-byte field' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.SITE_NBR is '10062 - Site Number' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.BLDG_NBR is '01130 - Building Number' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.BE_CD_POM is '10052 - Building POM Budget Detail Code' ; Comment on column UNIVDB1.Bldg_Plnt_Oper_Maint.POM_BUD_FACTOR is '10053 - Building POM Budget Detail Factor' ; Comment on column UNIVDB1.Workload_Person_Funding.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Workload_Person_Funding.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Workload_Person_Funding.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Workload_Person_Funding.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.' ; Comment on column UNIVDB1.Workload_Person_Funding.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Workload_Person_Funding.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Workload_Person_Funding.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Workload_Person_Funding.BE_CD_EMPL is '01517 - Employee Budget Entity Code' ; Comment on column UNIVDB1.Workload_Person_Funding.PAY_PLAN_NBR is '01037 - Pay Plan, SUS' ; Comment on column UNIVDB1.Workload_Person_Funding.UNIV_POSITION is '01039 - University Position' ; Comment on column UNIVDB1.Workload_Person_Funding.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Workload_Person_Funding.UNIV_BUD_ID is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Workload_Person_Funding.CLASS_CD is '01730 - Classification Code, SUS/01014 - Classification Code' ; Comment on column UNIVDB1.Workload_Person_Funding.RANK_FAC is '01028 - Rank, Faculty' ; Comment on column UNIVDB1.Workload_Person_Funding.ADMIN_CD_PRI is '01409 - Administrative Code - Faculty and other' ; Comment on column UNIVDB1.Workload_Person_Funding.INSTRCT_RESRCH_FTE is '01501 - Term Instruction and Research FTE' ; Comment on column UNIVDB1.Workload_Person_Funding.BUD_WKS_TERM is '01502 - Budgeted Weeks of Activity, Term' ; Comment on column UNIVDB1.Workload_Person_Funding.PERYRS_TERM is '01503 - Person Year, I and R Equivalent Effort - Term' ; Comment on column UNIVDB1.Workload_Person_Funding.TERM_AMT_REQ_BENE is '01504 - Term Amount Required With Benefits' ; Comment on column UNIVDB1.Workload_Person_Funding.DEPT_EMP_PROG_COMP is '01518 - Program Component-Employee/Department' ; Comment on column UNIVDB1.Workload_Person_Funding.EMPL_CONTACT_HRS is '01527 - Employee Contact Hours' ; Comment on column UNIVDB1.Workload_Person_Funding.CIP_EMP is '01528 - Employee Program Category' ; Comment on column UNIVDB1.Workload_Person_Funding.OCC_ACT_CAT_EEO6 is '01617 - Occupational Activity Category' ; Comment on column UNIVDB1.Workload_Person_Funding.TENURE_STAT is '01671 - Tenure Status' ; Comment on column UNIVDB1.Workload_Person_Funding.U_RESV_1 is 'Originally a 50-byte field' ; Comment on column UNIVDB1.Workload_Activity_Summary.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Workload_Activity_Summary.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Workload_Activity_Summary.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Workload_Activity_Summary.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Workload_Activity_Summary.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Workload_Activity_Summary.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Workload_Activity_Summary.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Workload_Activity_Summary.BE_CD_EMPL is '01517 - Employee Budget Entity Code' ; Comment on column UNIVDB1.Workload_Activity_Summary.PAY_PLAN_NBR is '01037 - Pay Plan, SUS' ; Comment on column UNIVDB1.Workload_Activity_Summary.UNIV_POSITION is '01039 - University Position' ; Comment on column UNIVDB1.Workload_Activity_Summary.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Workload_Activity_Summary.UNIV_BUD_ID_ACT is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Workload_Activity_Summary.BE_CD_ACT is '01505 - Activity Budget Entity' ; Comment on column UNIVDB1.Workload_Activity_Summary.CIP_CRS is '01098 - Course Program Category' ; Comment on column UNIVDB1.Workload_Activity_Summary.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type' ; Comment on column UNIVDB1.Workload_Activity_Summary.COLLEGE is '01507 - College (Subcomponent)' ; Comment on column UNIVDB1.Workload_Activity_Summary.PROG_COMP_ACT is '01508 - Program Component - Activity' ; Comment on column UNIVDB1.Workload_Activity_Summary.INSTR_RESRCH_ACT is '01509 - Instruction and Research Activities' ; Comment on column UNIVDB1.Workload_Activity_Summary.PERYRS_ACT_PORT is '01526 - Activity Portion of Person Years' ; Comment on column UNIVDB1.Workload_Activity_Summary.FTE_ACT_PORTION is '01512 - Activity Portion of Effort' ; Comment on column UNIVDB1.Workload_Activity_Summary.U_RESV_1 is 'Originally a 50-byte field' ; Comment on column UNIVDB1.Workload_Activities.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Workload_Activities.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Workload_Activities.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Workload_Activities.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Workload_Activities.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Workload_Activities.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.' ; Comment on column UNIVDB1.Workload_Activities.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Workload_Activities.BE_CD_EMPL is '01517 - Employee Budget Entity Code' ; Comment on column UNIVDB1.Workload_Activities.PAY_PLAN_NBR is '01037 - Pay Plan, SUS' ; Comment on column UNIVDB1.Workload_Activities.UNIV_POSITION is '01039 - University Position' ; Comment on column UNIVDB1.Workload_Activities.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Workload_Activities.UNIV_BUD_ID is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Workload_Activities.BE_CD_ACT is '01505 - Activity Budget Entity' ; Comment on column UNIVDB1.Workload_Activities.COLLEGE is '01507 - College (Subcomponent)' ; Comment on column UNIVDB1.Workload_Activities.PROG_COMP_ACT is '01508 - Program Component - Activity' ; Comment on column UNIVDB1.Workload_Activities.INSTR_RESRCH_ACT is '01509 - Instruction and Research Activities' ; Comment on column UNIVDB1.Workload_Activities.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type' ; Comment on column UNIVDB1.Workload_Activities.CIP_CRS is '01098 - Course Program Category' ; Comment on column UNIVDB1.Workload_Activities.DEPT_ID_ACT is '01506 - Account/Department Number, Activity' ; Comment on column UNIVDB1.Workload_Activities.UNIV_BUD_ID_ACT is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Workload_Activities.CRS_PREFIX is '01195 - Common Course Prefix' ; Comment on column UNIVDB1.Workload_Activities.CRS_NBR is '01196 - Common Course Number' ; Comment on column UNIVDB1.Workload_Activities.CRS_IND is '01003 - Common Course Outside Indicator' ; Comment on column UNIVDB1.Workload_Activities.CRS_SECTN_NBR is '01096 - Course Section Number' ; Comment on column UNIVDB1.Workload_Activities.SESSION_ID is '01405 - Session Flag' ; Comment on column UNIVDB1.Workload_Activities.VAR_CRED_FLG is '01114 - Variable Credit Flag' ; Comment on column UNIVDB1.Workload_Activities.CRS_CRED_HRS is '01128 - Course Credit Hours' ; Comment on column UNIVDB1.Workload_Activities.INSTR_TOT_SCH is '01515 - Instructor Portion of Total SCHs for the Course Section' ; Comment on column UNIVDB1.Workload_Activities.INSTR_FND_SCH is '01516 - Instructor Portion of Fundable SCHs for the Course Section' ; Comment on column UNIVDB1.Workload_Activities.PORT_SECTN_WKLD is '01129 - Portion of Section Workload' ; Comment on column UNIVDB1.Workload_Activities.PERYRS_ACT_PORT is '01526 - Activity Portion of Person Years' ; Comment on column UNIVDB1.Workload_Activities.FTE_ACT_PORTION is '01512 - Activity Portion of Effort' ; Comment on column UNIVDB1.Workload_Activities.CONTACT_HRS is '01513 - Instructor Portion Contact Hours/Equivalencies' ; Comment on column UNIVDB1.Workload_Activities.CONTACT_HRS_MOD is '01514 - Contact Hour Modifier' ; Comment on column UNIVDB1.Workload_Activities.U_RESV_1 is 'Originally a 50-byte field' ; Comment on column UNIVDB1.Workload_Activities.U_RESV_2 is 'Originally a 12-byte field' ; Comment on column UNIVDB1.Employee_Demo.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Employee_Demo.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Employee_Demo.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Employee_Demo.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Employee_Demo.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Employee_Demo.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Employee_Demo.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Employee_Demo.SUB_TYP is '01726 - Submission Type' ; Comment on column UNIVDB1.Employee_Demo.HLTH_INS_OPT_CD is '01668 - Health Insurance Option Code, State' ; Comment on column UNIVDB1.Employee_Demo.HLTH_INS_PROV_CD is '01669 - Health Insurance Provider Code, State' ; Comment on column UNIVDB1.Employee_Demo.LIFE_INS_PART_CD is '01635 - Life Insurance Participation Code, State' ; Comment on column UNIVDB1.Employee_Demo.RETIRE_CD_EMP is '01047 - Retirement Code, Employment Resource' ; Comment on column UNIVDB1.Employee_Demo.CONT_ST_SVC_DT is '01612 - Continuous State Service Date' ; Comment on column UNIVDB1.Employee_Demo.AGENCY_HIRE_DT is '01019 - University Hire Date' ; Comment on column UNIVDB1.Employee_Demo.RANK_FAC is '01028 - Rank, Faculty' ; Comment on column UNIVDB1.Employee_Demo.RANK_FAC_DT is '01182 - Date of Rank, Faculty' ; Comment on column UNIVDB1.Employee_Demo.DEG_HIGHEST_HELD is '01112 - Degree - Highest Level Held' ; Comment on column UNIVDB1.Employee_Demo.DEG_YR_OF_HIGHEST is '01194 - Degree - Year of Highest YYYY' ; Comment on column UNIVDB1.Employee_Demo.TENURE_STAT is '01671 - Tenure Status' ; Comment on column UNIVDB1.Employee_Demo.TENURE_STAT_DT is '01238 - Tenure Status - Date Granted' ; Comment on column UNIVDB1.Employee_Demo.CIP_TENURE is '01738 - Tenure CIP' ; Comment on column UNIVDB1.Employee_Demo.OCC_ACT_CAT_EEO6 is '01617 - Occupational Activity Category' ; Comment on column UNIVDB1.Employee_Demo.COUNTY_OF_RES is '01055 - County of Residence, SUS' ; Comment on column UNIVDB1.Employee_Demo.RESTRICT_ACC_FLG is '01611 - Restricted Access Indicator' ; Comment on column UNIVDB1.Employee_Demo.SR_MGMT_BFT_FLG is '01020 - Senior Management Benefit Switch' ; Comment on column UNIVDB1.Employee_Demo.ANP_FLG is '01038 - A and P Indicator' ; Comment on column UNIVDB1.Employee_Demo.DROP_ENROLL_DT is '01690 - Date of Enrollment - DROP' ; Comment on column UNIVDB1.Employee_Demo.DROP_TERMT_DT is '01691 - Date of Termination - DROP' ; Comment on column UNIVDB1.Employee_Demo.EMPR_TYP_CD is '01181 - Employment Resource Type Code, SUS' ; Comment on column UNIVDB1.Employee_Demo.CITIZEN is '01619 - Citizenship' ; Comment on column UNIVDB1.Employee_Demo.U_RESV_1 is 'Originally a 10-byte field' ; Comment on column UNIVDB1.Employee_Data.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Employee_Data.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Employee_Data.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Employee_Data.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Employee_Data.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Employee_Data.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Employee_Data.PERSON_ID is '01029 - Person Identification Number' ; Comment on column UNIVDB1.Employee_Data.SUB_TYP is '01726 - Submission Type' ; Comment on column UNIVDB1.Employee_Data.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Employee_Data.ST_FUND_TYP is '01314 - State Fund Type' ; Comment on column UNIVDB1.Employee_Data.FUND_ID_EMPL_RES is '01742 - University Fund Identifier - Employment Resourse' ; Comment on column UNIVDB1.Employee_Data.BE_CD8 is '01297 - Budget Entity Code' ; Comment on column UNIVDB1.Employee_Data.IBI is '01724 - Internal Budget Indicator' ; Comment on column UNIVDB1.Employee_Data.APPROP_CAT is '01301 - Appropriation Category' ; Comment on column UNIVDB1.Employee_Data.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Employee_Data.UNIV_BUD_ID is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Employee_Data.PAY_PLAN_NBR is '01037 - Pay Plan, SUS' ; Comment on column UNIVDB1.Employee_Data.OPS_SEQ is '01797 - Sequence' ; Comment on column UNIVDB1.Employee_Data.UNIV_POSITION is '01039 - University Position' ; Comment on column UNIVDB1.Employee_Data.COUNTY_OF_EMP is '01016 - County of Employment' ; Comment on column UNIVDB1.Employee_Data.CLASS_CD is '01014 - Classification Code' ; Comment on column UNIVDB1.Employee_Data.EMPLOYED_CUR_CL_DT is '01018 - Date Employed in Current Classification' ; Comment on column UNIVDB1.Employee_Data.COLL_BARG_UNIT_CD is '01041 - Collective Bargaining Unit Code' ; Comment on column UNIVDB1.Employee_Data.COLL_BARG_UNIT_ELG is '01049 - Collective Bargaining Unit Eligibility, SUS' ; Comment on column UNIVDB1.Employee_Data.ADMIN_CD_PRI is '01409 - Administrative Code - Faculty and other' ; Comment on column UNIVDB1.Employee_Data.PAY_GRADE is '01035 - Pay Grade' ; Comment on column UNIVDB1.Employee_Data.STEP_NBR is '01281 - Step Number - USPS' ; Comment on column UNIVDB1.Employee_Data.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Employee_Data.APPT_STAT_CLASS is '01696 - Appointment Status - Class' ; Comment on column UNIVDB1.Employee_Data.CIP_ACCT_DEPT is '01013 - Account/Department CIP' ; Comment on column UNIVDB1.Employee_Data.ST_PRO_COMP_CD is '01639 - State Program Component Code' ; Comment on column UNIVDB1.Employee_Data.PROG_COMP is '01315 - Program Component, SUS' ; Comment on column UNIVDB1.Employee_Data.PCS_DEPT_ID is '01245 - Account/Department Program (PCS)' ; Comment on column UNIVDB1.Employee_Data.SALARY_DOLLARS is '01034 - Salary Dollars' ; Comment on column UNIVDB1.Employee_Data.CURR_YR_RATE is '01017 - Current Year Rate, SUS' ; Comment on column UNIVDB1.Employee_Data.FTE is '01004 - Full Time Equivalent (FTE) Effort' ; Comment on column UNIVDB1.Employee_Data.BUD_WKS_POS is '01236 - Budgeted Weeks of Activity, Employment Resource' ; Comment on column UNIVDB1.Employee_Data.PERYRS is '01176 - Person Years' ; Comment on column UNIVDB1.Employee_Data.COMMIT_TYP is '01747 - Commitment Type' ; Comment on column UNIVDB1.Employee_Data.RATE_TYP is '01625 - Rate Type' ; Comment on column UNIVDB1.Employee_Data.UT_WORKED is '01624 - Units Worked' ; Comment on column UNIVDB1.Employee_Data.CLASS_TITLE is '01807 - Classification Title' ; Comment on column UNIVDB1.Employee_Data.U_RESV_1 is 'Originally a 50-byte field' ; Comment on column UNIVDB1.Employee_Vacants.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Employee_Vacants.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Employee_Vacants.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Employee_Vacants.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. ' ; Comment on column UNIVDB1.Employee_Vacants.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Employee_Vacants.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related.' ; Comment on column UNIVDB1.Employee_Vacants.SUB_TYP is '01726 - Submission Type' ; Comment on column UNIVDB1.Employee_Vacants.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Employee_Vacants.ST_FUND_TYP is '01314 - State Fund Type' ; Comment on column UNIVDB1.Employee_Vacants.FUND_ID_EMPL_RES is '01742 - University Fund Identifier - Employment Resourse' ; Comment on column UNIVDB1.Employee_Vacants.BE_CD8 is '01297 - Budget Entity Code' ; Comment on column UNIVDB1.Employee_Vacants.IBI is '01724 - Internal Budget Indicator' ; Comment on column UNIVDB1.Employee_Vacants.APPROP_CAT is '01301 - Appropriation Category' ; Comment on column UNIVDB1.Employee_Vacants.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Employee_Vacants.UNIV_BUD_ID is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Employee_Vacants.PAY_PLAN_NBR is '01037 - Pay Plan, SUS' ; Comment on column UNIVDB1.Employee_Vacants.UNIV_POSITION is '01039 - University Position' ; Comment on column UNIVDB1.Employee_Vacants.HLTH_INS_OPT_CD is '01668 - Health Insurance Option Code, State' ; Comment on column UNIVDB1.Employee_Vacants.LIFE_INS_PART_CD is '01635 - Life Insurance Participation Code, State' ; Comment on column UNIVDB1.Employee_Vacants.RETIRE_CD_EMP is '01047 - Retirement Code, Employment Resource' ; Comment on column UNIVDB1.Employee_Vacants.COUNTY_OF_EMP is '01016 - County of Employment' ; Comment on column UNIVDB1.Employee_Vacants.CLASS_CD is '01014 - Classification Code' ; Comment on column UNIVDB1.Employee_Vacants.ADMIN_CD_PRI is '01409 - Administrative Code - Faculty and other' ; Comment on column UNIVDB1.Employee_Vacants.PAY_GRADE is '01035 - Pay Grade' ; Comment on column UNIVDB1.Employee_Vacants.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Employee_Vacants.CIP_ACCT_DEPT is '01013 - Account/Department CIP' ; Comment on column UNIVDB1.Employee_Vacants.ST_PRO_COMP_CD is '01639 - State Program Component Code' ; Comment on column UNIVDB1.Employee_Vacants.PROG_COMP is '01315 - Program Component, SUS' ; Comment on column UNIVDB1.Employee_Vacants.PCS_DEPT_ID is '01245 - Account/Department Program (PCS)' ; Comment on column UNIVDB1.Employee_Vacants.SALARY_DOLLARS is '01034 - Salary Dollars' ; Comment on column UNIVDB1.Employee_Vacants.CURR_YR_RATE is '01017 - Current Year Rate, SUS' ; Comment on column UNIVDB1.Employee_Vacants.FTE is '01004 - Full Time Equivalent (FTE) Effort' ; Comment on column UNIVDB1.Employee_Vacants.BUD_WKS_POS is '01236 - Budgeted Weeks of Activity, Employment Resource' ; Comment on column UNIVDB1.Employee_Vacants.PERYRS is '01176 - Person Years' ; Comment on column UNIVDB1.Employee_Vacants.SR_MGMT_BFT_FLG is '01020 - Senior Management Benefit Switch' ; Comment on column UNIVDB1.Employee_Vacants.ANP_FLG is '01038 - A and P Indicator' ; Comment on column UNIVDB1.Employee_Vacants.EMPR_TYP_CD is '01181 - Employment Resource Type Code, SUS' ; Comment on column UNIVDB1.Employee_Vacants.CLASS_TITLE is '01807 - Classification Title' ; Comment on column UNIVDB1.Employee_Vacants.U_RESV_1 is 'Originally a 50-byte field' ; Comment on column UNIVDB1.Employee_Vacants.COMMIT_TYP is '01747 - Commitment Type' ; Comment on column UNIVDB1.Operating_Budget.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Operating_Budget.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Operating_Budget.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Operating_Budget.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Operating_Budget.FISCAL_YR is '01629 - Year - Fiscal' ; Comment on column UNIVDB1.Operating_Budget.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Operating_Budget.UNIV_BUD_ID is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Operating_Budget.BE_CD8 is '01297 - Budget Entity Code' ; Comment on column UNIVDB1.Operating_Budget.IBI is '01724 - Internal Budget Indicator' ; Comment on column UNIVDB1.Operating_Budget.ST_PRO_COMP_CD is '01639 - State Program Component Code' ; Comment on column UNIVDB1.Operating_Budget.PROG_COMP is '01315 - Program Component, SUS' ; Comment on column UNIVDB1.Operating_Budget.ST_FUND_TYP is '01314 - State Fund Type' ; Comment on column UNIVDB1.Operating_Budget.UNIV_FUND_ID is '01400 - University Fund Identifier' ; Comment on column UNIVDB1.Operating_Budget.APPROP_CAT is '01301 - Appropriation Category' ; Comment on column UNIVDB1.Operating_Budget.OBJECT_CD is '01302 - Object Code' ; Comment on column UNIVDB1.Operating_Budget.PCS_DEPT_ID is '01245 - Account/Department Program (PCS)' ; Comment on column UNIVDB1.Operating_Budget.GEN_LEDGER_CD is '01309 - General Ledger Code' ; Comment on column UNIVDB1.Operating_Budget.REVENUE_TYP is '01318 - Revenue Type' ; Comment on column UNIVDB1.Operating_Budget.BE_CD is '01007 - Budget Entity Code, SUS' ; Comment on column UNIVDB1.Operating_Budget.EXPENDITURES is '01307 - Expenditures' ; Comment on column UNIVDB1.Operating_Budget.PERYRS is '01176 - Person Years' ; Comment on column UNIVDB1.Operating_Budget.CURR_YR_RATE is '01017 - Current Year Rate, SUS' ; Comment on column UNIVDB1.Operating_Budget.BUD_YR_ID is '01308 - Budget Year Identifier' ; Comment on column UNIVDB1.Operating_Budget.U_RESV_1 is 'Originally a 7-byte field' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.EA_DATA_SOURCE is 'GENERATED - Source' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.YR_FISCAL is '01629 - Year - Fiscal' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.BE_CD8 is '01297 - Budget Entity Code' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.COST_ACT is '01303 - Cost Activity' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.COLLEGE is '01507 - College (Subcomponent)' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.DEPT_ID_ACT is '01506 - Account/Department Number, Activity' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.INSTR_RESRCH_ACT is '01509 - Instruction and Research Activities' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.APPROP_CAT is '01301 - Appropriation Category' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.OBJECT_CD is '01302 - Object Code' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.INSTR_FND_SCH is '01516 - Instructor Portion of Fundable SCHs for the Course Section' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.PERYRS is '01176 - Person Years' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.EXPENDITURES is '01307 - Actual/Estimated Expenditures' ; Comment on column UNIVDB1.Expenditure_Analysis_Extract.CIP_EXPENDITURE is '01043 - Classification of Instructional Programs (CIP)' ; Comment on column UNIVDB1.Full_Cost.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Full_Cost.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Full_Cost.FISCAL_YR is 'Fiscal Year (YYYYYYYY) to which the reported data applies' ; Comment on column UNIVDB1.Full_Cost.COLLEGE is 'Code used by the universities to group Account Numbers or records. Identify the Medical/Health colleges for UF, USF and FSU, among other uses.' ; Comment on column UNIVDB1.Full_Cost.BE_CD8 is '01297 - Budget Entity Code' ; Comment on column UNIVDB1.Full_Cost.COST_ACT is '01303 - Cost Activity' ; Comment on column UNIVDB1.Full_Cost.CIP_EXPENDITURE is '01043 - Classification of Instructional Programs (CIP)' ; Comment on column UNIVDB1.Full_Cost.PROG_DISCIPLINE is '01520 - Program Discipline' ; Comment on column UNIVDB1.Full_Cost.CRED_HRS is 'Subtotal of Fundable Credit Hours for Grouping' ; Comment on column UNIVDB1.Full_Cost.EXP_PER_ACTIVITIES is 'FCMAST AMT1' ; Comment on column UNIVDB1.Full_Cost.DIRECT_EXP is 'FCMAST AMT2' ; Comment on column UNIVDB1.Full_Cost.INDIRECT_EXP is 'FCMAST AMT3' ; Comment on column UNIVDB1.Full_Cost.TOT_FULL_EXP is 'FCMAST AMT4' ; Comment on column UNIVDB1.Full_Cost.DIRECT_EXP_PER_FSCH is 'FCMAST AMT5' ; Comment on column UNIVDB1.Full_Cost.INDIRECT_EXP_PER_FSCH is 'FCMAST AMT6' ; Comment on column UNIVDB1.Full_Cost.TOT_EXP_PER_FSCH is 'FCMAST AMT7' ; Comment on column UNIVDB1.Campus.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Campus.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Campus.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Campus.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Campus.CAMPUS_CD is '10060 - Campus Code - Site' ; Comment on column UNIVDB1.Campus.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)' ; Comment on column UNIVDB1.Campus.CAMPUS_NAME is 'Campus name' ; Comment on column UNIVDB1.Campus.ZIP is '10048 - Zone Identification Postal' ; Comment on column UNIVDB1.PrePartition.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.PrePartition.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.PrePartition.FISCAL_YR is '01629 - Year - Fiscal' ; Comment on column UNIVDB1.PrePartition.BE_CD8 is '01297 - Budget Entity Code' ; Comment on column UNIVDB1.PrePartition.COLLEGE_ACT is '01507 - College (Subcomponent)' ; Comment on column UNIVDB1.PrePartition.COST_ACT is '01303 - Cost Activity' ; Comment on column UNIVDB1.PrePartition.CIP_EXPENDITURE is '01043 - Classification of Instructional Programs (CIP)' ; Comment on column UNIVDB1.PrePartition.LOWER_FSCH is 'MTX R01C01' ; Comment on column UNIVDB1.PrePartition.UPPER_FSCH is 'MTX R01C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_FSCH is 'MTX R01C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_FSCH is 'MTX R01C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_FSCH is 'MTX R01C05' ; Comment on column UNIVDB1.PrePartition.CLIN_FSCH is 'MTX R01C06' ; Comment on column UNIVDB1.PrePartition.LOWER_FACPERYRS is 'MTX R02C01' ; Comment on column UNIVDB1.PrePartition.UPPER_FACPERYR is 'MTX R02C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_FACPERYRS is 'MTX R02C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_FACPERYRS is 'MTX R02C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_FACPERYRS is 'MTX R02C05' ; Comment on column UNIVDB1.PrePartition.CLIN_FACPERYRS is 'MTX R02C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_FACPERYRS is 'MTX R02C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_FACPERYRS is 'MTX R02C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_FACPERYRS is 'MTX R02C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_FACPERYRS is 'MTX R02C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_FACPERYR is 'MTX R02C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_FACPERYR is 'MTX R02C12' ; Comment on column UNIVDB1.PrePartition.LOWER_FACSALBEN is 'MTX R03C01' ; Comment on column UNIVDB1.PrePartition.UPPER_FACSALBEN is 'MTX R03C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_FACSALBEN is 'MTX R03C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_FACSALBEN is 'MTX R03C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_FACSALBEN is 'MTX R03C05' ; Comment on column UNIVDB1.PrePartition.CLIN_FACSALBEN is 'MTX R03C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_FACSALBEN is 'MTX R03C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_FACSALBEN is 'MTX R03C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_FACSALBEN is 'MTX R03C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_FACSALBEN is 'MTX R03C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_FACSALBEN is 'MTX R03C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_FACSALBEN is 'MTX R03C12' ; Comment on column UNIVDB1.PrePartition.LOWER_SSPERYRS is 'MTX R04C01' ; Comment on column UNIVDB1.PrePartition.UPPER_SSPERYR is 'MTX R04C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_SSPERYRS is 'MTX R04C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_SSPERYRS is 'MTX R04C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_SSPERYRS is 'MTX R04C05' ; Comment on column UNIVDB1.PrePartition.CLIN_SSPERYRS is 'MTX R04C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_SSPERYRS is 'MTX R04C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_SSPERYRS is 'MTX R04C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_SSPERYRS is 'MTX R04C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_SSPERYRS is 'MTX R04C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_SSPERYR is 'MTX R04C11' ; Comment on column UNIVDB1.PrePartition.LOWER_SSSALBEN is 'MTX R05C01' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_SSPERYR is 'MTX R04C12' ; Comment on column UNIVDB1.PrePartition.UPPER_SSSALBEN is 'MTX R05C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_SSSALBEN is 'MTX R05C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_SSSALBEN is 'MTX R05C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_SSSALBEN is 'MTX R05C05' ; Comment on column UNIVDB1.PrePartition.CLIN_SSSALBEN is 'MTX R05C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_SSSALBEN is 'MTX R05C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_SSSALBEN is 'MTX R05C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_SSSALBEN is 'MTX R05C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_SSSALBEN is 'MTX R05C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_SSSALBEN is 'MTX R05C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_SSSALBEN is 'MTX R05C12' ; Comment on column UNIVDB1.PrePartition.TBPALL_RESPERYR is 'MTX R06C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_RESPERYR is 'MTX R06C12' ; Comment on column UNIVDB1.PrePartition.ADMIN_RESSALBEN is 'MTX R06C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_RESSALBEN is 'MTX R06C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_RESSALBEN is 'MTX R06C12' ; Comment on column UNIVDB1.PrePartition.LOWER_FADJPERYRS is 'MTX R10C01' ; Comment on column UNIVDB1.PrePartition.UPPER_FADJPERYR is 'MTX R10C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_FADJPERYRS is 'MTX R10C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_FADJPERYRS is 'MTX R10C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_FADJPERYRS is 'MTX R10C05' ; Comment on column UNIVDB1.PrePartition.CLIN_FADJPERYRS is 'MTX R10C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_FADJPERYRS is 'MTX R10C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_FADJPERYRS is 'MTX R10C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_FADJPERYRS is 'MTX R10C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_FADJPERYRS is 'MTX R10C10' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_FADJPERYR is 'MTX R10C12' ; Comment on column UNIVDB1.PrePartition.LOWER_FADJSALBEN is 'MTX R11C01' ; Comment on column UNIVDB1.PrePartition.UPPER_FADJSALBEN is 'MTX R11C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_FADJSALBEN is 'MTX R11C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_FADJSALBEN is 'MTX R11C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_FADJSALBEN is 'MTX R11C05' ; Comment on column UNIVDB1.PrePartition.CLIN_FADJSALBEN is 'MTX R11C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_FADJSALBEN is 'MTX R11C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_FADJSALBEN is 'MTX R11C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_FADJSALBEN is 'MTX R11C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_FADJSALBEN is 'MTX R11C10' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_FADJSALBEN is 'MTX R11C12' ; Comment on column UNIVDB1.PrePartition.LOWER_GAPERYRS is 'MTX R12C01' ; Comment on column UNIVDB1.PrePartition.UPPER_GAPERYR is 'MTX R12C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_GAPERYRS is 'MTX R12C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_GAPERYRS is 'MTX R12C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_GAPERYRS is 'MTX R12C05' ; Comment on column UNIVDB1.PrePartition.CLIN_GAPERYRS is 'MTX R12C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_GAPERYRS is 'MTX C12R07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_GAPERYRS is 'MTX R12C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_GAPERYRS is 'MTX R12C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_GAPERYRS is 'MTX R12C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_GAPERYR is 'MTX R12C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_GAPERYR is 'MTX R12C12' ; Comment on column UNIVDB1.PrePartition.LOWER_GASALBEN is 'MTX R13C01' ; Comment on column UNIVDB1.PrePartition.UPPER_GASALBEN is 'MTX R13C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_GASALBEN is 'MTX R13C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_GASALBEN is 'MTX R13C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_GASALBEN is 'MTX R13C05' ; Comment on column UNIVDB1.PrePartition.CLIN_GASALBEN is 'MTX R13C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_GASALBEN is 'MTX R13C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_GASALBEN is 'MTX R13C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_GASALBEN is 'MTX R13C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_GASALBEN is 'MTX R13C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_GASALBEN is 'MTX R13C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_GASALBEN is 'MTX R13C12' ; Comment on column UNIVDB1.PrePartition.LOWER_OOPSPERYRS is 'MTX R14C01' ; Comment on column UNIVDB1.PrePartition.UPPER_OOPSPERYR is 'MTX R14C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_OOPSPERYRS is 'MTX R14C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_OOPSPERYRS is 'MTX R14C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_OOPSPERYRS is 'MTX R14C05' ; Comment on column UNIVDB1.PrePartition.CLIN_OOPSPERYRS is 'MTX R14C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_OOPSPERYRS is 'MTX R14C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_OOPSPERYRS is 'MTX R14C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_OOPSPERYRS is 'MTX R14C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_OOPSPERYRS is 'MTX R14C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_OOPSPERYR is 'MTX R14C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_OOPSPERYR is 'MTX R14C12' ; Comment on column UNIVDB1.PrePartition.LOWER_OOPSDOLLAR is 'MTX R15C01' ; Comment on column UNIVDB1.PrePartition.UPPER_OOPSDOLLAR is 'MTX R15C02' ; Comment on column UNIVDB1.PrePartition.GRAD1_OOPSDOLLAR is 'MTX R15C03' ; Comment on column UNIVDB1.PrePartition.GRAD2_OOPSDOLLAR is 'MTX R15C04' ; Comment on column UNIVDB1.PrePartition.GRAD3_OOPSDOLLAR is 'MTX R15C05' ; Comment on column UNIVDB1.PrePartition.CLIN_OOPSDOLLAR is 'MTX R15C06' ; Comment on column UNIVDB1.PrePartition.RSRCH_OOPSDOLLAR is 'MTX R15C07' ; Comment on column UNIVDB1.PrePartition.PUBSVC_OOPSDOLLAR is 'MTX R15C08' ; Comment on column UNIVDB1.PrePartition.ACDADV_OOPSDOLLAR is 'MTX R15C09' ; Comment on column UNIVDB1.PrePartition.ADMIN_OOPSDOLLAR is 'MTX R15C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_OOPSDOLLAR is 'MTX R15C11' ; Comment on column UNIVDB1.PrePartition.TBPINSTR_OOPSDOLLAR is 'MTX R15C12' ; Comment on column UNIVDB1.PrePartition.ADMIN_ROPSDOLLAR is 'MTX R18C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_ROPSDOLLAR is 'MTX R18C11' ; Comment on column UNIVDB1.PrePartition.ADMIN_OTHEXPENSE is 'MTX R21C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_OTHEXPENSE is 'MTX R21C11' ; Comment on column UNIVDB1.PrePartition.ADMIN_UTILEXPENSE is 'MTX R22C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_UTILEXPENSE is 'MTX R22C11' ; Comment on column UNIVDB1.PrePartition.ADMIN_OCOEXPENSE is 'MTX R23C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_OCOEXPENSE is 'MTX R23C11' ; Comment on column UNIVDB1.PrePartition.ADMIN_BOOKOCO is 'MTX R24C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_BOOKOCO is 'MTX R24C11' ; Comment on column UNIVDB1.PrePartition.ADMIN_EDPEXPENSE is 'MTX R25C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_EDPEXPENSE is 'MTX R25C11' ; Comment on column UNIVDB1.PrePartition.ADMIN_SPECCAT is 'MTX R26C10' ; Comment on column UNIVDB1.PrePartition.TBPALL_SPECCAT is 'MTX R26C11' ; Comment on column UNIVDB1.Univ_Dept_Master.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Univ_Dept_Master.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Univ_Dept_Master.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Univ_Dept_Master.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Univ_Dept_Master.REPT_TIME_FRAME is 'Years (YYYYYYYY) to which the reported data applies. ' ; Comment on column UNIVDB1.Univ_Dept_Master.DEPT_ID is '01796 - Department Identifier' ; Comment on column UNIVDB1.Univ_Dept_Master.UNIV_BUD_ID is '01798 - University Budget Identifier' ; Comment on column UNIVDB1.Univ_Dept_Master.DEPT_ID_TITLE is 'Title for the University Department Identifier + University Budget Identifier' ; Comment on column UNIVDB1.Person_ID_Chgs.PRIKEY is 'Table Primary Key generated from sequence number' ; Comment on column UNIVDB1.Person_ID_Chgs.ROWSEQ_NBR is 'Row sequence number at time of input' ; Comment on column UNIVDB1.Person_ID_Chgs.UNIV_ROW_ID is 'University assigned ID for this row in this table. The value will be displayed as part of row identification on detailed error lists.' ; Comment on column UNIVDB1.Person_ID_Chgs.DEMO_TIME_FRAME is 'YYYYMM when person id was submitted' ; Comment on column UNIVDB1.Person_ID_Chgs.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Person_ID_Chgs.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related' ; Comment on column UNIVDB1.Person_ID_Chgs.PERSON_ID_NEW is '01029 - Person Identification Number (new)' ; Comment on column UNIVDB1.Person_ID_Chgs.PID_VALID_SSN is 'A code indicating whether or not Person_ID_NEW is a valid SSN (Y=yes, N=No)' ; Comment on column UNIVDB1.Person_ID_Chgs.PERSON_ID_PRV is '01427 - Person Identificaiton Number Previous' ; Comment on column UNIVDB1.Person_ID_Chgs.NAME_LAST is '01033 - Person Name - Last' ; Comment on column UNIVDB1.Person_ID_Chgs.NAME_FIRST is '01091 - Person Name - First' ; Comment on column UNIVDB1.Person_ID_Chgs.NAME_MI is '01092 - Person Name - Middle Initial' ; Comment on column UNIVDB1.Person_ID_Chgs.DT_BIRTH_YYYYMMDD is '01024 - Date of Birth YYYY-MM-DD' ; Comment on column UNIVDB1.Person_ID_Chgs.SUFFIX is 'New field. Ex: JR, SR, III, MD, FAC, CRNA' ; Comment on column UNIVDB1.Person_ID_Chgs.GENDER is '01048 - Gender' ; Comment on column UNIVDB1.Person_ID_Chgs.RACE_ETHNICITY is '01044 - Racial/Ethnic Group' ; Comment on column UNIVDB1.Person_ID_Chgs.HISPANIC_FLG is '01491 - Ethnicity (Hispanic or Latino)' ; Comment on column UNIVDB1.Person_ID_Chgs.AM_IND_ALASKAN_FLG is '01492 - American Indian or Alaskan Native' ; Comment on column UNIVDB1.Person_ID_Chgs.ASIAN_FLG is '01493 - Asian' ; Comment on column UNIVDB1.Person_ID_Chgs.BLACK_AFRICAN_AM_FLG is '01494 - Black or African American' ; Comment on column UNIVDB1.Person_ID_Chgs.NAT_HAWAII_PAC_IS_FLG is '01495 - Native Hawaiian or Other Pacific Islander' ; Comment on column UNIVDB1.Person_ID_Chgs.WHITE_FLG is '01496 - White' ; Comment on column UNIVDB1.Person_ID_Chgs.NON_RES_ALIEN_FLG is 'New field' ; Comment on column UNIVDB1.Person_ID_Chgs.NO_RACE_REPORT_FLG is '01497 - No Race Reported' ; Comment on column UNIVDB1.Person_ID_Chgs.U_RESV_1 is 'New Univ Reserved Area' ; Comment on column UNIVDB1.Uploaded_Data.UPLOAD_HISTORY is 'Primary Key of the Upload_History table populated using sequence number' ; Comment on column UNIVDB1.Uploaded_Data.FILE_CONTENTS is 'File Contents - should be variable length, pipe-delimited data.' ; Comment on column UNIVDB1.Upload_History.UPLOAD_HISTORY is 'Primary Key of the Upload_History table populated using sequence number' ; Comment on column UNIVDB1.Upload_History.SUBMIT_DTM is 'Insertion Time Stamp' ; Comment on column UNIVDB1.Upload_History.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Upload_History.REPT_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.' ; Comment on column UNIVDB1.Upload_History.SUBMISSION is 'Submission Identifier: STU, STUP, ADM, TEF, EA, etc.' ; Comment on column UNIVDB1.Upload_History.TARGET_TABLE is 'Name of the Table to be Loaded' ; Comment on column UNIVDB1.Upload_History.AUDIT_ID is 'User ID or Program ID causing the insert of the current row' ; Comment on column UNIVDB1.Upload_History.LOCAL_FILE_NAME is 'The name of the file uploaded as entered by the user' ; Comment on column UNIVDB1.Upload_History.ROWS_RECEIVED is 'Number of rows received in the uploaded data file' ; Comment on column UNIVDB1.Upload_History.FILE_SIZE is 'Size of the file received in Kilobytes' ; Comment on column UNIVDB1.Upload_History.ROWS_W_EXCEPTIONS is 'Number of rows with parsing exceptions' ; Comment on column UNIVDB1.Upload_History.INVALID_FILE_FLG is 'Was the uploaded file useable according to input specifications?' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.REPT_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.FILE_ID is 'Master File Submitted' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.FILE_LOADED_DTM is 'Timestamp of load' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.TABLE_NAME is 'Name of the table that was modified' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.REPORT_ID is 'ID of the program that created this row' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.COLUMN_NAME is 'Name of the column that was modified' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.DIAGNOSTIC_MSG_CD is 'Diagnostic Message Code' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.MESSAGE_TEXT is 'Text of the message displayed in the report' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.ERROR_LEVEL is '0=frequency, 1=generated, 5=warning, 8=tolerance, 9=fatal' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.FREQUENCY is 'Total number of occurrences of this diagnostic message in the current file submission.' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.TOLERANCE is 'The percentage at which a level 8 warning message turns into a level 9 fatal error message' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.EXPLANATION is 'University''s explanation for Level 9 error or other unusual anomolies such as high percentage delta counts' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.REJECT_REASON is 'IRM Reason for rejecting this explanation' ; Comment on column UNIVDB1.Edit_Report_Summary_Preprod.REJECTED_DTM is 'Timestamp of when the explanation was rejected' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.REPT_INST is '01045 - Reporting Institution' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.REPT_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.FILE_ID is 'Master File Submitted' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.FILE_LOADED_DTM is 'Timestamp of load' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.TABLE_NAME is 'Name of the table that was modified' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.REPORT_ID is 'ID of the program that created this row' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.COLUMN_NAME is 'Name of the column that was modified' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.DIAGNOSTIC_MSG_CD is 'Diagnostic Message Code' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.TABLE_SEQNO is 'Foreign Key of the specific row within the edited table to which this diagnostic message refers.' ; Comment on column UNIVDB1.Edit_Report_Detail_Preprod.BAD_DATA_CONTENTS is 'Contents of the column that was nulled due to violation of basic input criteria' ;