/*
Created		9/4/2006
Modified		1/2/2008
Project		SUDS Production
Model		Full Model
Company		BOG
Author		IRM
Version		DRAFT 3.1
Database		Oracle 10g 
*/


Drop table Submitted_Data CASCADE CONSTRAINTS PURGE
;
Drop table Submission_Template CASCADE CONSTRAINTS PURGE
;
Drop table Person_ID_Chgs CASCADE CONSTRAINTS PURGE
;
Drop table Univ_Dept_Master CASCADE CONSTRAINTS PURGE
;
Drop table PrePartition CASCADE CONSTRAINTS PURGE
;
Drop table Campus CASCADE CONSTRAINTS PURGE
;
Drop table Full_Cost CASCADE CONSTRAINTS PURGE
;
Drop table Expenditure_Analysis_Extract CASCADE CONSTRAINTS PURGE
;
Drop table Person_Best_IDs CASCADE CONSTRAINTS PURGE
;
Drop table Edit_Report_Summary CASCADE CONSTRAINTS PURGE
;
Drop table Approval_Status CASCADE CONSTRAINTS PURGE
;
Drop table Audit_Trail CASCADE CONSTRAINTS PURGE
;
Drop table Military_Participants CASCADE CONSTRAINTS PURGE
;
Drop table College_Prepaid CASCADE CONSTRAINTS PURGE
;
Drop table Talented_20 CASCADE CONSTRAINTS PURGE
;
Drop table Operating_Budget CASCADE CONSTRAINTS PURGE
;
Drop table Employee_Vacants CASCADE CONSTRAINTS PURGE
;
Drop table Employee_Data CASCADE CONSTRAINTS PURGE
;
Drop table Employee_Demo CASCADE CONSTRAINTS PURGE
;
Drop table Workload_Activities CASCADE CONSTRAINTS PURGE
;
Drop table Workload_Activity_Summary CASCADE CONSTRAINTS PURGE
;
Drop table Workload_Person_Funding CASCADE CONSTRAINTS PURGE
;
Drop table Bldg_Plnt_Oper_Maint CASCADE CONSTRAINTS PURGE
;
Drop table Rooms CASCADE CONSTRAINTS PURGE
;
Drop table Buildings CASCADE CONSTRAINTS PURGE
;
Drop table Sites CASCADE CONSTRAINTS PURGE
;
Drop table Course_Meetings CASCADE CONSTRAINTS PURGE
;
Drop table Instructional_Activity CASCADE CONSTRAINTS PURGE
;
Drop table Retention_Cohorts CASCADE CONSTRAINTS PURGE
;
Drop table Financial_Aid_Awards CASCADE CONSTRAINTS PURGE
;
Drop table Financial_Aid_Demo CASCADE CONSTRAINTS PURGE
;
Drop table Courses_to_Degree CASCADE CONSTRAINTS PURGE
;
Drop table Hours_to_Degree CASCADE CONSTRAINTS PURGE
;
Drop table Degrees_Awarded CASCADE CONSTRAINTS PURGE
;
Drop table Fee_Waivers CASCADE CONSTRAINTS PURGE
;
Drop table Stipends CASCADE CONSTRAINTS PURGE
;
Drop table Fellowships CASCADE CONSTRAINTS PURGE
;
Drop table Test_Credits CASCADE CONSTRAINTS PURGE
;
Drop table Courses_Taken CASCADE CONSTRAINTS PURGE
;
Drop table Enrollments CASCADE CONSTRAINTS PURGE
;
Drop table College_Prep CASCADE CONSTRAINTS PURGE
;
Drop table DOE_Pgm_Info CASCADE CONSTRAINTS PURGE
;
Drop table Tests_Reqs CASCADE CONSTRAINTS PURGE
;
Drop table Admission_Exceptions CASCADE CONSTRAINTS PURGE
;
Drop table Applicants_Admits CASCADE CONSTRAINTS PURGE
;
Drop table Person_IDs CASCADE CONSTRAINTS PURGE
;
Drop table Person_Demo CASCADE CONSTRAINTS PURGE
;


-- Create Tables section


Create table Person_Demo (
	PERSON_DEMO Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 NOT NULL ,
	BIRTH_YYYYMM_DT Date,
	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),
	RACE_ETHNICITY_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE PERSON_DEMO
;

Create table Person_IDs (
	PERSON_DEMO Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 NOT NULL ,
	PERSON_ID_ENC Varchar2 (9),
	PID_VALID_SSN Varchar2 (1),
	PERSON_ID_PRV_ENC Varchar2 (9),
	PID_PRV_VALID_SSN Varchar2 (1),
	SYSID_PREVIOUS Number(12,0),
	BIRTH_DT Date,
	NAME_LAST_SOUNDEX Varchar2 (30),
	NAME_FIRST_SOUNDEX Varchar2 (30),
	ALT_ID Varchar2 (8),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE PERSON_IDS
;

Create table Applicants_Admits (
	APPLICANTS_ADMITS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	APP_ADM_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	FLA_PUBLIC_HS_FLG Varchar2 (1),
	CIP_APP_ADM_LBL Varchar2 (50),
	STU_TYP_LBL Varchar2 (50),
	STU_TYP_GRP Varchar2 (50),
	FINAL_ADM_ACTION_LBL Varchar2 (50),
	REGISTERED_CD_LBL Varchar2 (50),
	FEE_CLASS_RES_LBL Varchar2 (50),
	FEE_CLASS_RES_GRP Varchar2 (50),
	ADM_DEPOSIT_IND_LBL Varchar2 (50),
	STU_CLASS_LEVEL_LBL Varchar2 (50),
	LAST_INST_CD_LBL Varchar2 (50),
	LAST_INST_CD_GRP Varchar2 (4),
	INST_GRNT_HIDEG_CD_LBL Varchar2 (50),
	INST_GRNT_HIDEG_CD_GRP Varchar2 (4),
	DEG_HIGHEST_HELD_LBL Varchar2 (50),
	DEG_HIGHEST_HELD_GRP Varchar2 (50),
	HS_ETS_CD_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE APPLICANTS_ADMITS
;

Create table Admission_Exceptions (
	ADMISSION_EXCEPTIONS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	STU_TYP_LBL Varchar2 (50),
	STU_TYP_GRP Varchar2 (50),
	EXCEPTION_TYP_LBL Varchar2 (50),
	EXCEPTION_CAT_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE ADMISSION_EXCEPTIONS
;

Create table Tests_Reqs (
	TESTS_REQS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	APPLICANTS_ADMITS Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	APP_ADM_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	STU_TYP_LBL Varchar2 (50),
	STU_TYP_GRP Varchar2 (50),
	TEST_REQ_LBL Varchar2 (50),
	TEST_SCORE_TYP_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE TESTS_REQS
;

Create table DOE_Pgm_Info (
	DOE_PGM_INFO Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	APPLICANTS_ADMITS Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	APP_ADM_SOURCE Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	STU_TYP_LBL Varchar2 (50),
	STU_TYP_GRP Varchar2 (50),
	TCHR_PREP_DOE_CD_LBL Varchar2 (50),
	TCHR_PREP_DOE_LEVEL_LBL Varchar2 (50),
	TCHR_REG_CD_LBL Varchar2 (50),
	TCHR_EDU_PGM_METHOD_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE DOE_PGM_INFO
;

Create table College_Prep (
	COLLEGE_PREP Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 NOT NULL ,
	REMEDIATION_AREA Varchar2 (1) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	STU_RECENT_ADM_DT Varchar2 (6),
	HS_ETS_CD Varchar2 (6),
	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),
	REMEDIATION_AREA_LBL Varchar2 (50),
	REMEDIATION_TEST_LBL Varchar2 (50),
	REMEDIATION_COMP_LBL Varchar2 (50),
	COMM_COLL_CD_LBL Varchar2 (50),
	COMM_COLL_CD_GRP Varchar2 (4),
	CRS_IND_LBL Varchar2 (50),
	REMEDIATION_INCOMP_LBL Varchar2 (50),
	HS_ETS_CD_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE COLLEGE_PREP
;

Create table Enrollments (
	ENROLLMENTS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	FLA_PUBLIC_HS_FLG Varchar2 (1),
	IPEDS_GRADSTU_FLG Varchar2 (1),
	WAIVER_HR_GRAD_STU Number(1,0),
	GPA_TERM Number(5,2),
	GPA_CUM Number(5,2),
	IPEDS_FALLENRL_ROWNUM Number(3,0),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	NATION_CITIZ_LBL Varchar2 (50),
	NAT_MERIT_SCH_IND_LBL Varchar2 (50),
	DISPLACED_STU_IND_LBL Varchar2 (50),
	INST_DISPLACED_FROM_LBL Varchar2 (50),
	HS_ETS_CD_LBL Varchar2 (50),
	DUAL_ENROLL_IND_LBL Varchar2 (50),
	LAST_INST_CD_LBL Varchar2 (50),
	LAST_INST_CD_GRP Varchar2 (4),
	STU_ENTRY_TYP_LBL Varchar2 (50),
	STU_ENTRY_TYP_GRP Varchar2 (50),
	STU_RECENT_ADM_TYP_LBL Varchar2 (50),
	STU_RECENT_ADM_TYP_GRP Varchar2 (50),
	FIRST_GEN_IND_LBL Varchar2 (50),
	FEE_CLASS_RES_LBL Varchar2 (50),
	FEE_CLASS_RES_GRP Varchar2 (50),
	CLAST_IND_LBL Varchar2 (50),
	STU_CLASS_LEVEL_LBL Varchar2 (50),
	DEG_HIGHEST_HELD_LBL Varchar2 (50),
	DEG_HIGHEST_HELD_GRP Varchar2 (50),
	INST_GRNT_HIDEG_CD_LBL Varchar2 (50),
	INST_GRNT_HIDEG_GRP Varchar2 (4),
	DEG_LEVEL_SOUGHT_LBL Varchar2 (50),
	DEG_LEVEL_SOUGHT_GRP Varchar2 (50),
	DOC_CLASS_LBL Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	TERMINATION_CD_LBL Varchar2 (50),
	VISA_TYP_LBL Varchar2 (50),
	INST_CLASS_LVL_STU_LBL Varchar2 (50),
	FULL_PART_TIME_IND_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE ENROLLMENTS
;

Create table Courses_Taken (
	COURSES_TAKEN Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	ENROLLMENTS Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	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),
	HRS_SURCHARGE Number(3,1),
	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),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	CONT_COOP_ED_IND_LBL Varchar2 (50),
	STU_SECTN_FUND_CD_LBL Varchar2 (50),
	CRS_SECTN_TYP_PRI_LBL Varchar2 (50),
	CRS_LEVEL_CLASS_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE COURSES_TAKEN
;

Create table Test_Credits (
	TEST_CREDITS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	ENROLLMENTS Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	TEST_TYP_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE TEST_CREDITS
;

Create table Fellowships (
	FELLOWSHIPS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	ENROLLMENTS Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE FELLOWSHIPS
;

Create table Stipends (
	STIPENDS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	ENROLLMENTS Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	CLASS_CD_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE STIPENDS
;

Create table Fee_Waivers (
	FEE_WAIVERS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	ENROLLMENTS Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	FEE_WAIVER_IND_LBL Varchar2 (50),
	FEE_WAIVER_KIND_LBL Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	LINK_INST_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE FEE_WAIVERS
;

Create table Degrees_Awarded (
	DEGREES_AWARDED Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	IPEDS_RPTD_FLG Varchar2 (1),
	FEE_CLASS_KIND_LBL Varchar2 (50),
	DEG_LEVEL_GRANT_LBL Varchar2 (50),
	DEG_LEVEL_GRANT_GRP Varchar2 (50),
	TCHR_PREP_DOE_CD_LBL Varchar2 (50),
	TCHR_PREP_DOE_LEVEL_LBL Varchar2 (50),
	TCHR_EDU_PGM_METHOD_LBL Varchar2 (50),
	DOC_CLASS_LBL Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE DEGREES_AWARDED
;

Create table Hours_to_Degree (
	HOURS_TO_DEGREE Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 NOT NULL ,
	TERM_DEG_GRANT Varchar2 (6) NOT NULL ,
	DEG_LEVEL_GRANT Varchar2 (1) 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),
	HRS_USED Number(7,2),
	EXCESS_HRS_SUS Number(7,2),
	EXCESS_HRS_NATIVE Number(7,2),
	DEG_LEVEL_GRANT_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE HOURS_TO_DEGREE
;

Create table Courses_to_Degree (
	COURSES_TO_DEGREE Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	HOURS_TO_DEGREE Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	DEG_LEVEL_GRANT_LBL Varchar2 (50),
	CRS_IND_LBL Varchar2 (50),
	STU_CLASS_LEVEL_LBL Varchar2 (50),
	CRS_SYSTEM_LBL Varchar2 (50),
	CRS_GROUP_LBL Varchar2 (50),
	CRS_RESULT_LBL Varchar2 (50),
	REPEAT_IND_LBL Varchar2 (50),
	CRS_SECTN_TYP_LBL Varchar2 (50),
	TEST_METHOD_LBL Varchar2 (50),
	USAGE_IND_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE COURSES_TO_DEGREE
;

Create table Financial_Aid_Demo (
	FINANCIAL_AID_DEMO Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	CURR_DEPEND_STAT_LBL Varchar2 (50),
	FEE_CLASS_RES_LBL Varchar2 (50),
	FEE_CLASS_RES_GRP Varchar2 (50),
	STU_ENTRY_TYP_LBL Varchar2 (50),
	STU_ENTRY_TYP_GRP Varchar2 (50),
	STU_CLASS_LEVEL_LBL Varchar2 (50),
	NEED_BASED_AID_IND_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE FINANCIAL_AID_DEMO
;

Create table Financial_Aid_Awards (
	FINANCIAL_AID_AWARDS Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	FINANCIAL_AID_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	AWARD_PROG_ID_LBL Varchar2 (50),
	AWARD_PROG_ID_GRP Varchar2 (50),
	AWARD_COND_ID_LBL Varchar2 (50),
	AWARD_COND_ID_GRP Varchar2 (50),
	SOURCE_FUNDS_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE FINANCIAL_AID_AWARDS
;

Create table Retention_Cohorts (
	RETENTION Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 NOT NULL ,
	COHORT_TYP Varchar2 (1) NOT NULL ,
	STU_RIGHT_KNOW_FLG Varchar2 (1) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	COHORT_TYP_NEW Varchar2 (1),
	SRK_FLG_NEW Varchar2 (1),
	COHORT_ADJUST_IND Varchar2 (1),
	FULL_PART_ADJUST_IND Varchar2 (1),
	GENDER_NEW Varchar2 (1),
	RACE_ETHNICITY_NEW Varchar2 (1),
	COHORT_TYP_LBL Varchar2 (50),
	COHORT_TYP_NEW_LBL Varchar2 (50),
	COHORT_ADJUST_IND_LBL Varchar2 (50),
	FULL_PART_ADJUST_IND_LBL Varchar2 (50),
	RACE_ETHNICITY_NEW_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE RETENTION_COHORTS
;

Create table Instructional_Activity (
	INSTRUCTIONAL_ACTIVITY Number NOT NULL ,
	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),
	SECTN_HEADCNT_ENROL Number(4,0),
	TOTAL_CRS_CRED_HRS Number(6,1),
	FNDBL_CRS_CRED_HRS Number(6,1),
	FNDBL_GRAD_DOC_HRS Number(6,1),
	DOC_STU_GRAD_HRS Number(6,1),
	CRS_SECTN_TYP_PRI_LBL Varchar2 (50),
	VAR_CRED_FLG_LBL Varchar2 (50),
	BE_CD_CRS_LBL Varchar2 (50),
	DELIVERY_IND_LBL Varchar2 (50),
	TECH_IND_PRIMARY_LBL Varchar2 (50),
	TECH_IND_SECONDARY_LBL Varchar2 (50),
	TECH_IND_TERTIARY_LBL Varchar2 (50),
	COUNTRY_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE INSTRUCTIONAL_ACTIVITY
;

Create table Course_Meetings (
	COURSE_MEETINGS Number NOT NULL ,
	INSTRUCTIONAL_ACTIVITY Number NOT NULL ,
	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),
	CRS_SECTN_LOC_CNTY Varchar2 (4),
	ZIP Varchar2 (9),
	NBR_WKS_MET Number(2,0),
	U_RESV_1 Varchar2 (50),
	UNSCHED_MTG_IND_LBL Varchar2 (50),
	CRS_SECTN_TYP_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE COURSE_MEETINGS
;

Create table Sites (
	SITES Number NOT NULL ,
	CAMPUS Number NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	CAMPUS_CD Varchar2 (4) NOT NULL ,
	BASE_YR Varchar2 (8) NOT NULL ,
	SITE_NBR Varchar2 (4) NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) 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),
	OWNERSHIP_LBL Varchar2 (50),
	ST_OWNED_FLG Varchar2 (1),
	USAGE_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE SITES
;

Create table Buildings (
	BUILDINGS Number NOT NULL ,
	CAMPUS Number NOT NULL ,
	SITES 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 ,
	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),
	OWNERSHIP_LBL Varchar2 (50),
	ST_OWNED_FLG Varchar2 (1),
	STATUS_LBL Varchar2 (50),
	STRUCTURE_LBL Varchar2 (50),
	EXTERIOR_LBL Varchar2 (50),
	CONDITION_BLDG_LBL Varchar2 (50),
	JOINT_USE_IND_LBL Varchar2 (50),
	BE_CD_BLDG_LBL Varchar2 (50),
	ENV_COND_LBL Varchar2 (50),
	ROOF_COND_LBL Varchar2 (50),
	MECH_COND_LBL Varchar2 (50),
	ELEC_COND_LBL Varchar2 (50),
	PLMB_COND_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE BUILDINGS
;

Create table Rooms (
	ROOMS Number NOT NULL ,
	CAMPUS Number NOT NULL ,
	SITES Number NOT NULL ,
	BUILDINGS 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 ,
	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),
	USE_CD_LBL Varchar2 (50),
	CATEGORY_LBL Varchar2 (50),
	CONDITION_ROOM_LBL Varchar2 (50),
	PCS_PROG_LBL Varchar2 (50),
	SHARED_USE_LBL Varchar2 (50),
	NEEDS_GEN_ELIG_LBL Varchar2 (50),
	BE_CD_POM_LBL Varchar2 (50),
	BE_CD_USER_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE ROOMS
;

Create table Bldg_Plnt_Oper_Maint (
	BLDG_PLANT_OPER_MAINT Number NOT NULL ,
	CAMPUS Number NOT NULL ,
	SITES Number NOT NULL ,
	BUILDINGS 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),
	BE_CD_POM_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE BLDG_PLNT_OPER_MAINT
;

Create table Workload_Person_Funding (
	WKLD_PERSON_FUNDING Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	CLASS_LBL Varchar2 (50),
	RANK_LBL Varchar2 (50),
	TENURE_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE WORKLOAD_PERSON_FUNDING
;

Create table Workload_Activity_Summary (
	WKLD_ACT_SUMM Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	WKLD_PERSON_FUNDING Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE WORKLOAD_ACTIVITY_SUMMARY
;

Create table Workload_Activities (
	WKLD_ACTIVITIES Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	WKLD_ACT_SUMM Number NOT NULL ,
	WKLD_PERSON_FUNDING Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE WORKLOAD_ACTIVITIES
;

Create table Employee_Demo (
	EMPLOYEE_DEMO Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	HLTH_INS_OPT_LBL Varchar2 (50),
	HLTH_INS_PROVIDER_LBL Varchar2 (60),
	TENURE_STAT_LBL Varchar2 (50),
	LIFE_INS_PART_LBL Varchar2 (50),
	RETIRE_LBL Varchar2 (50),
	RANK_FAC_LBL Varchar2 (50),
	DEG_HIGHEST_HELD_LBL Varchar2 (50),
	OCC_ACT_CAT_LBL Varchar2 (50),
	EMPR_TYP_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE EMPLOYEE_DEMO
;

Create table Employee_Data (
	EMPLOYEE_DATA Number NOT NULL ,
	PERSON_DEMO Number NOT NULL ,
	EMPLOYEE_DEMO Number NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_DATA_SOURCE Varchar2 (8) NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	SYSID_SEQ Number(1,0) Default 1 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),
	PAY_GRADE Varchar2 (3),
	STEP_NBR Varchar2 (3),
	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(4,2),
	BUD_WKS_POS Number(4,2),
	PERYRS Number(10,4),
	COMMIT_TYP Varchar2 (2),
	RATE_TYP Varchar2 (1),
	UT_WORKED Number(5,2),
	CLASS_TITLE Varchar2 (40),
	U_RESV_1 Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	ST_FUND_TYP_GRP Varchar2 (50),
	BE_CD8_LBL Varchar2 (50),
	IBI_LBL Varchar2 (30),
	ADMIN_CD_PRI_LBL Varchar2 (50),
	APPT_STAT_CLASS_LBL Varchar2 (50),
	PROG_COMP_LBL Varchar2 (60),
	PCS_LBL Varchar2 (50),
	COMMIT_TYP_LBL Varchar2 (70),
	RATE_TYP_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE EMPLOYEE_DATA
;

Create table Employee_Vacants (
	EMPLOYEE_VACANTS Number NOT NULL ,
	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),
	PAY_GRADE Varchar2 (3),
	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(4,2),
	BUD_WKS_POS Number(4,2),
	PERYRS Number(10,4),
	SR_MGMT_BFT_FLG Varchar2 (1),
	ANP_FLG Varchar2 (1),
	EMPR_TYP_CD Varchar2 (1),
	CLASS_TITLE Varchar2 (40),
	U_RESV_1 Varchar2 (50),
	BE_CD_LBL Varchar2 (50),
	ST_FUND_TYP_GRP Varchar2 (50),
	BE_CD8_LBL Varchar2 (50),
	IBI_LBL Varchar2 (50),
	HLTH_INS_OPT_LBL Varchar2 (50),
	LIFE_INS_PART_LBL Varchar2 (50),
	RETIRE_LBL Varchar2 (50),
	PROG_COMP_LBL Varchar2 (60),
	PCS_LBL Varchar2 (50),
	EMPR_TYP_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE EMPLOYEE_VACANTS
;

Create table Operating_Budget (
	OPER_BUDGET Number NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	FISCAL_YR Varchar2 (8) NOT NULL ,
	BUD_SCHED1 Varchar2 (1) 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),
	BE_CD_LBL Varchar2 (50),
	IBI_LBL Varchar2 (50),
	SF_FUND_ID_GRP Varchar2 (50),
	APPROP_CAT_LBL Varchar2 (50),
	PCS_LBL Varchar2 (50),
	BUD_YR_ID_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE OPERATING_BUDGET
;

Create table Talented_20 (
	TALENTED_20_YR Number(4,0) NOT NULL ,
	DISTRICT Varchar2 (2) NOT NULL ,
	SCHOOL Varchar2 (4) NOT NULL ,
	HS_PERSON_ID Varchar2 (9) NOT NULL ,
	HS_PERSON_ID_X Varchar2 (1) NOT NULL ,
	HASH_CD Varchar2 (50),
	SYSID Number(12,0),
	ALT_ID Varchar2 (8),
	NAME_LAST Varchar2 (18),
	SUFFIX Varchar2 (12),
	NAME_FIRST Varchar2 (13),
	NAME_MI Varchar2 (1),
	GENDER Varchar2 (1),
	RACIAL_ETHNIC_GRP Varchar2 (1),
	BIRTH_DT Date,
	ADDRESS_STREET Varchar2 (35),
	ADDRESS_CITY Varchar2 (22),
	ADDRESS_STATE Varchar2 (2),
	ADDRESS_ZIP Varchar2 (9),
	HS_ETS_CD Varchar2 (6),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE TALENTED_20
;

Create table College_Prepaid (
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	PERSON_ID_NBR Varchar2 (9) NOT NULL ,
	SYSID Number(12,0),
	ALT_ID Varchar2 (8),
	NAME_LAST Varchar2 (18),
	NAME_FIRST Varchar2 (13),
	MATRICULATION_YR Varchar2 (4),
	TUITION_PLAN_TYP Varchar2 (2),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE COLLEGE_PREPAID
;

Create table Military_Participants (
	EXTRACT_YR Varchar2 (4) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	UNIV_PERSON_ID Varchar2 (9) NOT NULL ,
	SYSID Number(12,0),
	ALT_ID Varchar2 (8),
	SERVICE_6 Varchar2 (1),
	SERVICE_8 Varchar2 (1),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE MILIATRY_PARTICIPANTS
;

Create table Audit_Trail (
	TABLE_NAME Varchar2 (30) NOT NULL ,
	SEQNO Number NOT NULL ,
	COLUMN_NAME Varchar2 (30) NOT NULL ,
	MODIFIED_DTM Timestamp(6) NOT NULL ,
	MODIFIED_BY Varchar2 (10),
	OLD_VALUE Varchar2 (500),
	REMARK Varchar2 (500)
) 
TABLESPACE USERS
;

Create table Approval_Status (
	APPROVAL_STATUS Number NOT NULL ,
	ACT_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 ,
	STATUS Varchar2 (30) NOT NULL ,
	DUE_DT Date NOT NULL ,
	REQUIRED_FLG Varchar2 (1) NOT NULL 
) 
TABLESPACE APPROVAL_STATUS
;

Create table Edit_Report_Summary (
	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 ,
	COLUMN_NAME Varchar2 (30) NOT NULL ,
	DIAGNOSTIC_MSG_CD Varchar2 (30) NOT NULL ,
	EXPLANATION Varchar2 (4000)
) 
TABLESPACE USERS
;

Create table Person_Best_IDs (
	PERSON_BEST_IDS Number NOT NULL ,
	SYSID Number(12,0) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	DEMO_TIME_FRAME Varchar2 (8),
	DEMO_DATA_SOURCE Varchar2 (8),
	PERSON_ID_BEST_ENC Varchar2 (9),
	PID_BEST_VALID_SSN Varchar2 (1),
	BIRTH_DT Date,
	NAME_LAST Varchar2 (22),
	NAME_LAST_SOUNDEX Varchar2 (30),
	NAME_FIRST Varchar2 (14),
	NAME_FIRST_SOUNDEX Varchar2 (30),
	NAME_MI Varchar2 (1),
	SUFFIX Varchar2 (10),
	GENDER Varchar2 (1),
	RACE_ETHNICITY Varchar2 (1),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE PERSON_BEST_IDS
;

Create table Expenditure_Analysis_Extract (
	EA_EXTRACT 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),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE EA_EXTRACT
;

Create table Full_Cost (
	FULL_COST 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),
	COLLEGE_LBL Varchar2 (50),
	COST_ACT_LBL Varchar2 (50),
	PROG_DISCIPLINE_LBL Varchar2 (50),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE FULL_COST
;

Create table Campus (
	CAMPUS 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 ,
	CAMPUS_NAME Varchar2 (50) NOT NULL ,
	ZIP Varchar2 (9),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE CAMPUS
;

Create table PrePartition (
	EA_PRE_PARTITION 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 ,
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE PREPARTITION
;

Create table Univ_Dept_Master (
	UNIV_DEPT_MASTER Number NOT NULL ,
	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 ,
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE UNIV_DEPT_MASTER
;

Create table Person_ID_Chgs (
	PERSON_ID_CHGS Number NOT NULL ,
	REPT_TIME_FRAME Varchar2 (8) NOT NULL ,
	REPT_INST Varchar2 (4) NOT NULL ,
	PERSON_ID_NEW Varchar2 (9) NOT NULL ,
	PERSON_ID_PRV Varchar2 (9) NOT NULL ,
	BIRTH_DT Date,
	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),
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE PERSON_ID_CHGS
;

Create table Submission_Template (
	SUBMISSION Varchar2 (8) NOT NULL ,
	TARGET_TABLE Varchar2 (30) NOT NULL ,
	REQUIRED_FLG Varchar2 (1) NOT NULL ,
	DEFAULT_DUE_DT Date NOT NULL ,
	LAST_CHANGE_BY Varchar2 (32) NOT NULL ,
	LAST_CHANGE_DT Date NOT NULL 
) 
TABLESPACE USERS
;

Create table Submitted_Data (
	APPROVAL_STATUS Number NOT NULL ,
	FILE_CONTENTS Clob
) 
TABLESPACE USERS
;


-- Create Indexes section

Create UNIQUE Index PERSON_DEMOGRAPHICS_LUK ON Person_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE PERSON_DEMO_NDX
;
Create UNIQUE Index PERSON_DEMO_PKEY ON Person_Demo (PERSON_DEMO) 
TABLESPACE PERSON_DEMO_NDX
;
Create UNIQUE Index PERSON_IDS_LUK ON Person_IDs (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE PERSON_IDS_NDX
;
Create UNIQUE Index PERSON_IDS_PKEY ON Person_IDs (PERSON_DEMO) 
TABLESPACE PERSON_IDS_NDX
;
Create UNIQUE Index APPLICANTS_ADMITS_LUK ON Applicants_Admits (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,SYSID,SYSID_SEQ,CIP_APP_ADM,STU_TYP) 
TABLESPACE APPLICANTS_ADMITS_NDX
;
Create Index PD_APP_ADM_LK ON Applicants_Admits (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE APPLICANTS_ADMITS_NDX
;
Create UNIQUE Index APPLICANTS_ADMITS_PKEY ON Applicants_Admits (APPLICANTS_ADMITS) 
TABLESPACE APPLICANTS_ADMITS_NDX
;
Create Index APPLICANTS_ADMITS_FK01 ON Applicants_Admits (PERSON_DEMO) 
TABLESPACE APPLICANTS_ADMITS_NDX
;
Create UNIQUE Index ADMISSION_EXCEPTIONS_LUK ON Admission_Exceptions (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,EXCEPTION_SOURCE,CIP_APP_ADM,STU_TYP,EXCEPTION_TYP,EXCEPTION_CAT) 
TABLESPACE ADMISSION_EXCEPTIONS_NDX
;
Create Index PD_ADM_EXCEP_LK ON Admission_Exceptions (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE ADMISSION_EXCEPTIONS_NDX
;
Create UNIQUE Index ADMISSION_EXCEPTIONS_PKEY ON Admission_Exceptions (ADMISSION_EXCEPTIONS) 
TABLESPACE ADMISSION_EXCEPTIONS_NDX
;
Create Index ADMISSION_EXCEPTIONS_FK01 ON Admission_Exceptions (PERSON_DEMO) 
TABLESPACE ADMISSION_EXCEPTIONS_NDX
;
Create UNIQUE Index TESTS_REQS_LUK ON Tests_Reqs (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,SYSID,SYSID_SEQ,CIP_APP_ADM,STU_TYP,TCHR_PREP_DOE_CD,TEST_REQ_CD,TEST_SCORE_TYP) 
TABLESPACE TESTS_REQS_NDX
;
Create Index PD_TESTS_REQS_LK ON Tests_Reqs (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE TESTS_REQS_NDX
;
Create UNIQUE Index TESTS_REQS_PKEY ON Tests_Reqs (TESTS_REQS) 
TABLESPACE TESTS_REQS_NDX
;
Create Index TESTS_REQS_FK01 ON Tests_Reqs (PERSON_DEMO) 
TABLESPACE TESTS_REQS_NDX
;
Create Index TESTS_REQS_FK02 ON Tests_Reqs (APPLICANTS_ADMITS) 
TABLESPACE TESTS_REQS_NDX
;
Create UNIQUE Index DOE_PGM_INFO_LUK ON DOE_Pgm_Info (REPT_TIME_FRAME,APP_ADM_SOURCE,REPT_INST,SYSID,SYSID_SEQ,CIP_APP_ADM,STU_TYP,TCHR_PREP_DOE_CD,TCHR_PREP_DOE_LEVEL,TCHR_TERM_ADMIT) 
TABLESPACE DOE_PGM_INFO_NDX
;
Create Index DOE_PRM_INFO_LK ON DOE_Pgm_Info (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE DOE_PGM_INFO_NDX
;
Create UNIQUE Index DOE_PGM_INFO_PKEY ON DOE_Pgm_Info (DOE_PGM_INFO) 
TABLESPACE DOE_PGM_INFO_NDX
;
Create Index DOE_PGM_INFO_FK01 ON DOE_Pgm_Info (PERSON_DEMO) 
TABLESPACE DOE_PGM_INFO_NDX
;
Create Index DOE_PGM_INFO_FK02 ON DOE_Pgm_Info (APPLICANTS_ADMITS) 
TABLESPACE DOE_PGM_INFO_NDX
;
Create UNIQUE Index COLLEGE_PREP_LUK ON College_Prep (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,REMEDIATION_AREA) 
TABLESPACE COLLEGE_PREP_NDX
;
Create Index PD_COLLEGE_PREP_LK ON College_Prep (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE COLLEGE_PREP_NDX
;
Create UNIQUE Index COLLEGE_PREP_PKEY ON College_Prep (COLLEGE_PREP) 
TABLESPACE COLLEGE_PREP_NDX
;
Create Index COLLEGE_PREP_FK01 ON College_Prep (PERSON_DEMO) 
TABLESPACE COLLEGE_PREP_NDX
;
Create UNIQUE Index ENROLLMENTS_LUK ON Enrollments (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,FEE_CLASS_KIND) 
TABLESPACE ENROLLMENTS_NDX
;
Create UNIQUE Index ENROLLMENTS_PKEY ON Enrollments (ENROLLMENTS) 
TABLESPACE ENROLLMENTS_NDX
;
Create Index ENROLLMENTS_FK01 ON Enrollments (PERSON_DEMO) 
TABLESPACE ENROLLMENTS_NDX
;
Create UNIQUE Index COURSES_TAKEN_LUK ON Courses_Taken (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,FEE_CLASS_KIND,SEGMENT_SEQ,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR) 
TABLESPACE COURSES_TAKEN_NDX
;
Create UNIQUE Index COURSES_TAKEN_PKEY ON Courses_Taken (COURSES_TAKEN) 
TABLESPACE COURSES_TAKEN_NDX
;
Create Index COURSES_TAKEN_FK01 ON Courses_Taken (PERSON_DEMO) 
TABLESPACE COURSES_TAKEN_NDX
;
Create Index COURSES_TAKEN_FK02 ON Courses_Taken (ENROLLMENTS) 
TABLESPACE COURSES_TAKEN_NDX
;
Create UNIQUE Index TEST_CREDITS_LUK ON Test_Credits (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,FEE_CLASS_KIND,TEST_TYP) 
TABLESPACE TEST_CREDITS_NDX
;
Create UNIQUE Index TEST_CREDITS_PKEY ON Test_Credits (TEST_CREDITS) 
TABLESPACE TEST_CREDITS_NDX
;
Create Index TEST_CREDITS_FK01 ON Test_Credits (PERSON_DEMO) 
TABLESPACE TEST_CREDITS_NDX
;
Create Index TEST_CREDITS_FK02 ON Test_Credits (ENROLLMENTS) 
TABLESPACE TEST_CREDITS_NDX
;
Create UNIQUE Index FELLOWSHIPS_LUK ON Fellowships (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,FEE_CLASS_KIND,SEGMENT_SEQ) 
TABLESPACE FELLOWSHIPS_NDX
;
Create UNIQUE Index FELLOWSHIPS_PKEY ON Fellowships (FELLOWSHIPS) 
TABLESPACE FELLOWSHIPS_NDX
;
Create Index FELLOWSHIPS_FK01 ON Fellowships (PERSON_DEMO) 
TABLESPACE FELLOWSHIPS_NDX
;
Create Index FELLOWSHIPS_FK02 ON Fellowships (ENROLLMENTS) 
TABLESPACE FELLOWSHIPS_NDX
;
Create UNIQUE Index STIPENDS_LUK ON Stipends (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,FEE_CLASS_KIND,SEGMENT_SEQ) 
TABLESPACE STIPENDS_NDX
;
Create UNIQUE Index STIPENDS_PKEY ON Stipends (STIPENDS) 
TABLESPACE STIPENDS_NDX
;
Create Index STIPENDS_FK01 ON Stipends (PERSON_DEMO) 
TABLESPACE STIPENDS_NDX
;
Create Index STIPENDS_FK02 ON Stipends (ENROLLMENTS) 
TABLESPACE STIPENDS_NDX
;
Create UNIQUE Index FEE_WAIVERS_LUK ON Fee_Waivers (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,FEE_CLASS_KIND,SEGMENT_SEQ) 
TABLESPACE FEE_WAIVERS_NDX
;
Create UNIQUE Index FEE_WAIVERS_PKEY ON Fee_Waivers (FEE_WAIVERS) 
TABLESPACE FEE_WAIVERS_NDX
;
Create Index FEE_WAIVERS_FK01 ON Fee_Waivers (PERSON_DEMO) 
TABLESPACE FEE_WAIVERS_NDX
;
Create Index FEE_WAIVERS_FK02 ON Fee_Waivers (ENROLLMENTS) 
TABLESPACE FEE_WAIVERS_NDX
;
Create UNIQUE Index DEGREES_AWARDED_LUK ON Degrees_Awarded (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,FEE_CLASS_KIND,TERM_DEG_GRANT,DEG_LEVEL_GRANT,CIP_DEGREE,MAJOR_IND,TCHR_PREP_DOE_CD,TCHR_PREP_DOE_LEVEL) 
TABLESPACE DEGREES_AWARDED_NDX
;
Create Index PD_DEGREES_LK ON Degrees_Awarded (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE DEGREES_AWARDED_NDX
;
Create UNIQUE Index DEGREES_AWARDED_PKEY ON Degrees_Awarded (DEGREES_AWARDED) 
TABLESPACE DEGREES_AWARDED_NDX
;
Create Index DEGREES_AWARDED_FK01 ON Degrees_Awarded (PERSON_DEMO) 
TABLESPACE DEGREES_AWARDED_NDX
;
Create UNIQUE Index HTD_LUK ON Hours_to_Degree (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,TERM_DEG_GRANT,DEG_LEVEL_GRANT) 
TABLESPACE HOURS_TO_DEGREE_NDX
;
Create Index PD_HTD_LK ON Hours_to_Degree (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE HOURS_TO_DEGREE_NDX
;
Create UNIQUE Index HOURS_TO_DEGREE_PKEY ON Hours_to_Degree (HOURS_TO_DEGREE) 
TABLESPACE HOURS_TO_DEGREE_NDX
;
Create Index HOURS_TO_DEGREE_FK01 ON Hours_to_Degree (PERSON_DEMO) 
TABLESPACE HOURS_TO_DEGREE_NDX
;
Create UNIQUE Index COURSES_TO_DEGREE_LUK ON Courses_to_Degree (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,TERM_DEG_GRANT,DEG_LEVEL_GRANT,TERM_TAKEN,CRS_INST_CD,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR,SEGMENT_SEQ) 
TABLESPACE COURSES_TO_DEGREE_NDX
;
Create Index PD_HTD_COURSES_LK ON Courses_to_Degree (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE COURSES_TO_DEGREE_NDX
;
Create UNIQUE Index COURSES_TO_DEGREE_PKEY ON Courses_to_Degree (COURSES_TO_DEGREE) 
TABLESPACE COURSES_TO_DEGREE_NDX
;
Create Index COURSES_TO_DEGREE_FK01 ON Courses_to_Degree (PERSON_DEMO) 
TABLESPACE COURSES_TO_DEGREE_NDX
;
Create Index COURSES_TO_DEGREE_FK02 ON Courses_to_Degree (HOURS_TO_DEGREE) 
TABLESPACE COURSES_TO_DEGREE_NDX
;
Create UNIQUE Index FINANCIAL_AID_DEMO_LUK ON Financial_Aid_Demo (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ) 
TABLESPACE FINANCIAL_AID_DEMO_NDX
;
Create Index PD_FINAID_LK ON Financial_Aid_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE FINANCIAL_AID_DEMO_NDX
;
Create UNIQUE Index FINANCIAL_AID_DEMO_PKEY ON Financial_Aid_Demo (FINANCIAL_AID_DEMO) 
TABLESPACE FINANCIAL_AID_DEMO_NDX
;
Create Index FINANCIAL_AID_DEMO_FK01 ON Financial_Aid_Demo (PERSON_DEMO) 
TABLESPACE FINANCIAL_AID_DEMO_NDX
;
Create UNIQUE Index FINANCIAL_AID_AWARDS_LUK ON Financial_Aid_Awards (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,AWARD_PAYMENT_TERM,AWARD_PROG_ID,AWARD_COND_ID) 
TABLESPACE FINANCIAL_AID_AWARDS_NDX
;
Create Index PD_FINAID_AWDS_LK ON Financial_Aid_Awards (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE FINANCIAL_AID_AWARDS_NDX
;
Create UNIQUE Index FINANCIAL_AID_AWARDS_PKEY ON Financial_Aid_Awards (FINANCIAL_AID_AWARDS) 
TABLESPACE FINANCIAL_AID_AWARDS_NDX
;
Create Index FINANCIAL_AID_AWARDS_FK01 ON Financial_Aid_Awards (PERSON_DEMO) 
TABLESPACE FINANCIAL_AID_AWARDS_NDX
;
Create Index FINANCIAL_AID_AWARDS_FK02 ON Financial_Aid_Awards (FINANCIAL_AID_DEMO) 
TABLESPACE FINANCIAL_AID_AWARDS_NDX
;
Create UNIQUE Index RETENTION_LUK ON Retention_Cohorts (REPT_TIME_FRAME,REPT_INST,SYSID,SYSID_SEQ,COHORT_TYP,STU_RIGHT_KNOW_FLG) 
TABLESPACE RETENTION_COHORTS_NDX
;
Create Index PD_RETENTION_LK ON Retention_Cohorts (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE RETENTION_COHORTS_NDX
;
Create UNIQUE Index RETENTION_COHORTS_PKEY ON Retention_Cohorts (RETENTION) 
TABLESPACE RETENTION_COHORTS_NDX
;
Create Index RETENTION_COHORTS_FK01 ON Retention_Cohorts (PERSON_DEMO) 
TABLESPACE RETENTION_COHORTS_NDX
;
Create UNIQUE Index INSTRUCTIONAL_ACTIVITY_LUK ON Instructional_Activity (REPT_INST,REPT_TIME_FRAME,SESSION_ID,CRS_PREFIX,CRS_NBR,CRS_IND,CRS_SECTN_NBR) 
TABLESPACE INSTRUCTIONAL_ACTIVITY_NDX
;
Create UNIQUE Index INSTRUCTIONAL_ACTIVITY_PKEY ON Instructional_Activity (INSTRUCTIONAL_ACTIVITY) 
TABLESPACE INSTRUCTIONAL_ACTIVITY_NDX
;
Create UNIQUE Index COURSE_MEETINGS_LUK ON 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) 
TABLESPACE COURSE_MEETINGS_NDX
;
Create UNIQUE Index COURSE_MEETINGS_PKEY ON Course_Meetings (COURSE_MEETINGS) 
TABLESPACE COURSE_MEETINGS_NDX
;
Create Index COURSE_MEETINGS_FK01 ON Course_Meetings (INSTRUCTIONAL_ACTIVITY) 
TABLESPACE COURSE_MEETINGS_NDX
;
Create UNIQUE Index SITES_LUK ON Sites (REPT_INST,CAMPUS_CD,BASE_YR,SITE_NBR) 
TABLESPACE SITES_NDX
;
Create UNIQUE Index SITES_PKEY ON Sites (SITES) 
TABLESPACE SITES_NDX
;
Create Index SITES_FK01 ON Sites (CAMPUS) 
TABLESPACE SITES_NDX
;
Create UNIQUE Index BUILDINGS_LUK ON Buildings (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR) 
TABLESPACE BUILDINGS_NDX
;
Create UNIQUE Index BUILDINGS_PKEY ON Buildings (BUILDINGS) 
TABLESPACE BUILDINGS_NDX
;
Create Index BUILDINGS_FK01 ON Buildings (SITES) 
TABLESPACE BUILDINGS_NDX
;
Create Index BUILDINGS_FK02 ON Buildings (CAMPUS) 
TABLESPACE BUILDINGS_NDX
;
Create UNIQUE Index ROOMS_LUK ON 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) 
TABLESPACE ROOMS_NDX
;
Create UNIQUE Index ROOMS_PKEY ON Rooms (ROOMS) 
TABLESPACE ROOMS_NDX
;
Create Index ROOMS_FK01 ON Rooms (SITES) 
TABLESPACE ROOMS_NDX
;
Create Index ROOMS_FK02 ON Rooms (BUILDINGS) 
TABLESPACE ROOMS_NDX
;
Create Index ROOMS_FK03 ON Rooms (CAMPUS) 
TABLESPACE ROOMS_NDX
;
Create UNIQUE Index BLDG_POM_LUK ON Bldg_Plnt_Oper_Maint (REPT_INST,CAMPUS_CD,BASE_YR,REPT_TIME_FRAME,SITE_NBR,BLDG_NBR,BE_CD_POM) 
TABLESPACE BLDG_PLNT_OPER_MAINT_NDX
;
Create UNIQUE Index BLDG_PLNT_OPER_MAINT_PKEY ON Bldg_Plnt_Oper_Maint (BLDG_PLANT_OPER_MAINT) 
TABLESPACE BLDG_PLNT_OPER_MAINT_NDX
;
Create Index BLDG_PLNT_OPER_MAINT_FK01 ON Bldg_Plnt_Oper_Maint (SITES) 
TABLESPACE BLDG_PLNT_OPER_MAINT_NDX
;
Create Index BLDG_PLNT_OPER_MAINT_FK02 ON Bldg_Plnt_Oper_Maint (BUILDINGS) 
TABLESPACE BLDG_PLNT_OPER_MAINT_NDX
;
Create Index BLDG_PLNT_OPER_MAINT_FK03 ON Bldg_Plnt_Oper_Maint (CAMPUS) 
TABLESPACE BLDG_PLNT_OPER_MAINT_NDX
;
Create UNIQUE Index WKLD_PERSON_FUNDING_LUK ON Workload_Person_Funding (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID) 
TABLESPACE WORKLOAD_PERSON_FUNDING_NDX
;
Create Index PD_WKLD_PERSON_FUNDING_LK ON Workload_Person_Funding (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE WORKLOAD_PERSON_FUNDING_NDX
;
Create UNIQUE Index WORKLOAD_PERSON_FUNDING_PKEY ON Workload_Person_Funding (WKLD_PERSON_FUNDING) 
TABLESPACE WORKLOAD_PERSON_FUNDING_NDX
;
Create Index WORKLOAD_PERSON_FUNDING_FK01 ON Workload_Person_Funding (PERSON_DEMO) 
TABLESPACE WORKLOAD_PERSON_FUNDING_NDX
;
Create UNIQUE Index WKLD_ACT_SUMMARY_LUK ON Workload_Activity_Summary (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,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) 
TABLESPACE WORKLOAD_ACTIVITY_SUMMARY_NDX
;
Create Index PD_WKLD_ACT_SUMMMARY_LK ON Workload_Activity_Summary (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE WORKLOAD_ACTIVITY_SUMMARY_NDX
;
Create UNIQUE Index WORKLOAD_ACTIVITY_SUMMARY_PKEY ON Workload_Activity_Summary (WKLD_ACT_SUMM) 
TABLESPACE WORKLOAD_ACTIVITY_SUMMARY_NDX
;
Create Index WORKLOAD_ACTIVITY_SUMMARY_FK01 ON Workload_Activity_Summary (PERSON_DEMO) 
TABLESPACE WORKLOAD_ACTIVITY_SUMMARY_NDX
;
Create Index WORKLOAD_ACTIVITY_SUMMARY_FK02 ON Workload_Activity_Summary (WKLD_PERSON_FUNDING) 
;
Create UNIQUE Index WKLD_ACTIVITIES_LUK ON Workload_Activities (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,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) 
TABLESPACE WORKLOAD_ACTIVITIES_NDX
;
Create Index WKLDPF_WKLD_ACTIVITIES_LK ON Workload_Activities (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,BE_CD_EMPL,PAY_PLAN_NBR,UNIV_POSITION,DEPT_ID,UNIV_BUD_ID) 
TABLESPACE WORKLOAD_ACTIVITIES_NDX
;
Create UNIQUE Index WORKLOAD_ACTIVITIES_PKEY ON Workload_Activities (WKLD_ACTIVITIES) 
TABLESPACE WORKLOAD_ACTIVITIES_NDX
;
Create Index WORKLOAD_ACTIVITIES_FK01 ON Workload_Activities (PERSON_DEMO) 
TABLESPACE WORKLOAD_ACTIVITIES_NDX
;
Create Index WORKLOAD_ACTIVITIES_FK02 ON Workload_Activities (WKLD_PERSON_FUNDING) 
TABLESPACE WORKLOAD_ACTIVITIES_NDX
;
Create Index WORKLOAD_ACTIVITIES_FK03 ON Workload_Activities (WKLD_ACT_SUMM) 
TABLESPACE WORKLOAD_ACTIVITIES_NDX
;
Create UNIQUE Index EMPL_DEMO_LUK ON Employee_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,SUB_TYP) 
TABLESPACE EMPLOYEE_DEMO_NDX
;
Create Index PD_EMPL_DEMO_LK ON Employee_Demo (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE EMPLOYEE_DEMO_NDX
;
Create UNIQUE Index EMPLOYEE_DEMO_PKEY ON Employee_Demo (EMPLOYEE_DEMO) 
TABLESPACE EMPLOYEE_DEMO_NDX
;
Create Index EMPLOYEE_DEMO_FK01 ON Employee_Demo (PERSON_DEMO) 
TABLESPACE EMPLOYEE_DEMO_NDX
;
Create Index PD_EMPL_DATA_LK01 ON Employee_Data (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ) 
TABLESPACE EMPLOYEE_DATA_NDX
;
Create Index EMPL_DATA_LK02 ON Employee_Data (DEMO_TIME_FRAME,REPT_INST,DEMO_DATA_SOURCE,SYSID,SYSID_SEQ,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) 
TABLESPACE EMPLOYEE_DATA_NDX
;
Create UNIQUE Index EMPLOYEE_DATA_PKEY ON Employee_Data (EMPLOYEE_DATA) 
TABLESPACE EMPLOYEE_DATA_NDX
;
Create Index EMPLOYEE_DATA_FK01 ON Employee_Data (PERSON_DEMO) 
TABLESPACE EMPLOYEE_DATA_NDX
;
Create Index EMPLOYEE_DATA_FK02 ON Employee_Data (EMPLOYEE_DEMO) 
TABLESPACE EMPLOYEE_DATA_NDX
;
Create UNIQUE Index EMPLOYEE_VACANTS_PKEY ON Employee_Vacants (EMPLOYEE_VACANTS) 
TABLESPACE EMPLOYEE_VACANTS_NDX
;
Create UNIQUE Index OPERATING_BUDGET_PKEY ON Operating_Budget (OPER_BUDGET) 
TABLESPACE OPERATING_BUDGET_NDX
;
Create UNIQUE Index TALENTED_20_PKEY ON Talented_20 (TALENTED_20_YR,DISTRICT,SCHOOL,HS_PERSON_ID,HS_PERSON_ID_X) 
TABLESPACE TALENTED_20_NDX
;
Create UNIQUE Index COLLEGE_PREPAID_PKEY ON College_Prepaid (REPT_TIME_FRAME,PERSON_ID_NBR) 
TABLESPACE COLLEGE_PREPAID_NDX
;
Create UNIQUE Index MILIATRY_PARTICIPANTS_PKEY ON Military_Participants (EXTRACT_YR,REPT_INST,UNIV_PERSON_ID) 
TABLESPACE MILIATRY_PARTICIPANTS_NDX
;
Create UNIQUE Index AUDIT_TRAIL_PKEY ON Audit_Trail (TABLE_NAME,SEQNO,COLUMN_NAME,MODIFIED_DTM) 
TABLESPACE USERS
;
Create UNIQUE Index APPROVAL_STATUS_PKEY ON Approval_Status (APPROVAL_STATUS) 
TABLESPACE APPROVAL_STATUS_NDX
;
Create UNIQUE Index Edit_Report_Summary_PKEY ON Edit_Report_Summary (REPT_INST,REPT_TIME_FRAME,FILE_ID,FILE_LOADED_DTM,TABLE_NAME,COLUMN_NAME,DIAGNOSTIC_MSG_CD) 
TABLESPACE USERS
;
Create UNIQUE Index PERSON_BEST_IDS_LUK ON Person_Best_IDs (SYSID,REPT_INST) 
TABLESPACE PERSON_BEST_IDS_NDX
;
Create UNIQUE Index PERSON_BEST_IDS_PKEY ON Person_Best_IDs (PERSON_BEST_IDS) 
TABLESPACE PERSON_BEST_IDS_NDX
;
Create UNIQUE Index EA_EXTRACT_PKEY ON Expenditure_Analysis_Extract (EA_EXTRACT) 
TABLESPACE EA_EXTRACT_NDX
;
Create Index FULL_COST_LUK ON Full_Cost (REPT_INST,BE_CD8,COST_ACT,CIP_EXPENDITURE) 
TABLESPACE FULL_COST_NDX
;
Create UNIQUE Index FULL_COST_PKEY ON Full_Cost (FULL_COST) 
TABLESPACE FULL_COST_NDX
;
Create Index CAMPUS_LUK ON Campus (REPT_INST,CAMPUS_CD,BASE_YR) 
TABLESPACE CAMPUS_NDX
;
Create UNIQUE Index CAMPUS_PKEY ON Campus (CAMPUS) 
TABLESPACE CAMPUS_NDX
;
Create UNIQUE Index EA_PRE_PARTITION_LUK ON PrePartition (REPT_INST,FISCAL_YR,BE_CD8,COLLEGE_ACT,COST_ACT,CIP_EXPENDITURE) 
TABLESPACE PREPARTITION_NDX
;
Create UNIQUE Index PREPARTITION_PKEY ON PrePartition (EA_PRE_PARTITION) 
TABLESPACE PREPARTITION_NDX
;
Create UNIQUE Index UNIV_DEPT_MASTER_LUK ON Univ_Dept_Master (REPT_INST,REPT_TIME_FRAME,DEPT_ID,UNIV_BUD_ID) 
TABLESPACE UNIV_DEPT_MASTER_NDX
;
Create UNIQUE Index UNIV_DEPT_MASTER_PKEY ON Univ_Dept_Master (UNIV_DEPT_MASTER) 
TABLESPACE UNIV_DEPT_MASTER_NDX
;
Create UNIQUE Index PERSON_ID_CHGS_PKEY ON Person_ID_Chgs (PERSON_ID_CHGS) 
TABLESPACE PERSON_ID_CHGS_NDX
;
Create UNIQUE Index Submitted_Data_PKEY ON Submitted_Data (APPROVAL_STATUS) 
TABLESPACE USERS
;


-- Create section for PKs, AKs and Unique constraints, which have to be generated after Indexes
Alter table Person_Demo add Constraint Person_Demo_pk primary key (PERSON_DEMO) 
	USING INDEX PERSON_DEMO_PKEY
;
Alter table Person_IDs add Constraint Person_IDs_pk primary key (PERSON_DEMO) 
	USING INDEX PERSON_IDS_PKEY
;
Alter table Applicants_Admits add Constraint Applicants_Admits_PK primary key (APPLICANTS_ADMITS) 
	USING INDEX APPLICANTS_ADMITS_PKEY
;
Alter table Admission_Exceptions add Constraint Admission_Exceptions_pk primary key (ADMISSION_EXCEPTIONS) 
	USING INDEX ADMISSION_EXCEPTIONS_PKEY
;
Alter table Tests_Reqs add Constraint Tests_Reqs_pk primary key (TESTS_REQS) 
	USING INDEX TESTS_REQS_PKEY
;
Alter table DOE_Pgm_Info add Constraint DOE_Pgm_Info_pk primary key (DOE_PGM_INFO) 
	USING INDEX DOE_PGM_INFO_PKEY
;
Alter table College_Prep add Constraint College_Prep_PK primary key (COLLEGE_PREP) 
	USING INDEX COLLEGE_PREP_PKEY
;
Alter table Enrollments add Constraint Enrollments_pk primary key (ENROLLMENTS) 
	USING INDEX ENROLLMENTS_PKEY
;
Alter table Courses_Taken add Constraint Courses_Taken_pk primary key (COURSES_TAKEN) 
	USING INDEX COURSES_TAKEN_PKEY
;
Alter table Test_Credits add Constraint Test_Credits_pk primary key (TEST_CREDITS) 
	USING INDEX TEST_CREDITS_PKEY
;
Alter table Fellowships add Constraint Fellowships_pk primary key (FELLOWSHIPS) 
	USING INDEX FELLOWSHIPS_PKEY
;
Alter table Stipends add Constraint Stipends_pk primary key (STIPENDS) 
	USING INDEX STIPENDS_PKEY
;
Alter table Fee_Waivers add Constraint Fee_Waivers_pk primary key (FEE_WAIVERS) 
	USING INDEX FEE_WAIVERS_PKEY
;
Alter table Degrees_Awarded add Constraint Degrees_Awarded_pk primary key (DEGREES_AWARDED) 
	USING INDEX DEGREES_AWARDED_PKEY
;
Alter table Hours_to_Degree add Constraint Hours_to_Degree_pk primary key (HOURS_TO_DEGREE) 
	USING INDEX HOURS_TO_DEGREE_PKEY
;
Alter table Courses_to_Degree add Constraint Courses_to_Degree_pk primary key (COURSES_TO_DEGREE) 
	USING INDEX COURSES_TO_DEGREE_PKEY
;
Alter table Financial_Aid_Demo add Constraint Financial_Aid_Demo_pk primary key (FINANCIAL_AID_DEMO) 
	USING INDEX FINANCIAL_AID_DEMO_PKEY
;
Alter table Financial_Aid_Awards add Constraint Financial_Aid_Awards_pk primary key (FINANCIAL_AID_AWARDS) 
	USING INDEX FINANCIAL_AID_AWARDS_PKEY
;
Alter table Retention_Cohorts add Constraint Retention_Cohorts_pk primary key (RETENTION) 
	USING INDEX RETENTION_COHORTS_PKEY
;
Alter table Instructional_Activity add Constraint Instructional_Activity_pk primary key (INSTRUCTIONAL_ACTIVITY) 
	USING INDEX INSTRUCTIONAL_ACTIVITY_PKEY
;
Alter table Course_Meetings add Constraint Course_Meetings_pk primary key (COURSE_MEETINGS) 
	USING INDEX COURSE_MEETINGS_PKEY
;
Alter table Sites add Constraint Sites_pk primary key (SITES) 
	USING INDEX SITES_PKEY
;
Alter table Buildings add Constraint Buildings_pk primary key (BUILDINGS) 
	USING INDEX BUILDINGS_PKEY
;
Alter table Rooms add Constraint Rooms_pk primary key (ROOMS) 
	USING INDEX ROOMS_PKEY
;
Alter table Bldg_Plnt_Oper_Maint add Constraint Bldg_Plnt_Oper_Maint_pk primary key (BLDG_PLANT_OPER_MAINT) 
	USING INDEX BLDG_PLNT_OPER_MAINT_PKEY
;
Alter table Workload_Person_Funding add Constraint Workload_Person_Funding_pk primary key (WKLD_PERSON_FUNDING) 
	USING INDEX WORKLOAD_PERSON_FUNDING_PKEY
;
Alter table Workload_Activity_Summary add Constraint Workload_Activity_Summary_pk primary key (WKLD_ACT_SUMM) 
	USING INDEX WORKLOAD_ACTIVITY_SUMMARY_PKEY
;
Alter table Workload_Activities add Constraint Workload_Activities_pk primary key (WKLD_ACTIVITIES) 
	USING INDEX WORKLOAD_ACTIVITIES_PKEY
;
Alter table Employee_Demo add Constraint Employee_Demo_pk primary key (EMPLOYEE_DEMO) 
	USING INDEX EMPLOYEE_DEMO_PKEY
;
Alter table Employee_Data add Constraint Employee_Data_pk primary key (EMPLOYEE_DATA) 
	USING INDEX EMPLOYEE_DATA_PKEY
;
Alter table Employee_Vacants add Constraint Employee_Vacants_pk primary key (EMPLOYEE_VACANTS) 
	USING INDEX EMPLOYEE_VACANTS_PKEY
;
Alter table Operating_Budget add Constraint Operating_Budget_pk primary key (OPER_BUDGET) 
	USING INDEX OPERATING_BUDGET_PKEY
;
Alter table Talented_20 add Constraint Talented_20_pk primary key (TALENTED_20_YR,DISTRICT,SCHOOL,HS_PERSON_ID,HS_PERSON_ID_X) 
	USING INDEX TALENTED_20_PKEY
;
Alter table College_Prepaid add Constraint College_Prepaid_pk primary key (REPT_TIME_FRAME,PERSON_ID_NBR) 
	USING INDEX COLLEGE_PREPAID_PKEY
;
Alter table Military_Participants add Constraint Military_Participants_pk primary key (EXTRACT_YR,REPT_INST,UNIV_PERSON_ID) 
	USING INDEX MILIATRY_PARTICIPANTS_PKEY
;
Alter table Audit_Trail add Constraint Audit_Trail_pk primary key (TABLE_NAME,SEQNO,COLUMN_NAME,MODIFIED_DTM) 
	USING INDEX AUDIT_TRAIL_PKEY
;
Alter table Approval_Status add Constraint Approval_Status_pk primary key (APPROVAL_STATUS) 
	USING INDEX APPROVAL_STATUS_PKEY
;
Alter table Edit_Report_Summary add Constraint Edit_Report_Summary_pk primary key (REPT_INST,REPT_TIME_FRAME,FILE_ID,FILE_LOADED_DTM,TABLE_NAME,COLUMN_NAME,DIAGNOSTIC_MSG_CD) 
	USING INDEX Edit_Report_Summary_PKEY
;
Alter table Person_Best_IDs add Constraint Person_Best_IDs_pk primary key (PERSON_BEST_IDS) 
	USING INDEX PERSON_BEST_IDS_PKEY
;
Alter table Expenditure_Analysis_Extract add Constraint Expenditure_Analysis_Extract_p primary key (EA_EXTRACT) 
	USING INDEX EA_EXTRACT_PKEY
;
Alter table Full_Cost add Constraint Full_Cost_pk primary key (FULL_COST) 
	USING INDEX FULL_COST_PKEY
;
Alter table Campus add Constraint Campus_pk primary key (CAMPUS) 
	USING INDEX CAMPUS_PKEY
;
Alter table PrePartition add Constraint PrePartition_pk primary key (EA_PRE_PARTITION) 
	USING INDEX PREPARTITION_PKEY
;
Alter table Univ_Dept_Master add Constraint Univ_Dept_Master_pk primary key (UNIV_DEPT_MASTER) 
	USING INDEX UNIV_DEPT_MASTER_PKEY
;
Alter table Person_ID_Chgs add Constraint Person_ID_Chgs_pk primary key (PERSON_ID_CHGS) 
	USING INDEX PERSON_ID_CHGS_PKEY
;
Alter table Submitted_Data add Constraint Submitted_Data_pk primary key (APPROVAL_STATUS) 
	USING INDEX Submitted_Data_PKEY
;


-- Create Foreign keys section

Alter table Enrollments add Constraint fk_PD_ENRL foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Applicants_Admits add Constraint fk_PD_APP_ADM foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Retention_Cohorts add Constraint fk_PD_RETENTION foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table College_Prep add Constraint fk_PD_CP foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Admission_Exceptions add Constraint fk_PD_ADM_EXC foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Degrees_Awarded add Constraint fk_PD_DEGAWD foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Hours_to_Degree add Constraint fk_PD_HTD foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Courses_Taken add Constraint fk_PD_COURSES foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Test_Credits add Constraint fk_PD_TEST_CREDS foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Fee_Waivers add Constraint fk_PD_FEE_WAIVERS foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Fellowships add Constraint fk_PD_FELLOWSHIPS foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Stipends add Constraint fk_PD_STIPENDS foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Person_IDs add  foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Financial_Aid_Awards add Constraint fk_PD_FINAID_AWDS foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Financial_Aid_Demo add Constraint fk_PD_FINAID foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Courses_to_Degree add Constraint fk_PD_HTD_COURSES foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Tests_Reqs add Constraint fk_PD_ADM_TESTS foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table DOE_Pgm_Info add Constraint fk_PD_TEF foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Workload_Person_Funding add Constraint fk_PD_WKLD_PF foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Employee_Demo add Constraint fk_PD_EMPL_DEMO foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Workload_Activity_Summary add Constraint fk_PD_WKLD_ACT_SUMMARY foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Workload_Activities add Constraint fk_PD_WKLD_ACTIVITIES foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Employee_Data add Constraint fk_PD_EMPL_DATA foreign key (PERSON_DEMO) references Person_Demo (PERSON_DEMO) 
;

Alter table Tests_Reqs add Constraint fk_AP_TESTS_REQS foreign key (APPLICANTS_ADMITS) references Applicants_Admits (APPLICANTS_ADMITS) 
;

Alter table DOE_Pgm_Info add Constraint fk_AP_ADM_TEF foreign key (APPLICANTS_ADMITS) references Applicants_Admits (APPLICANTS_ADMITS) 
;

Alter table Courses_Taken add Constraint fk_ENRL_COURSES foreign key (ENROLLMENTS) references Enrollments (ENROLLMENTS) 
;

Alter table Fellowships add Constraint fk_ENRL_FELLOWSHIPS foreign key (ENROLLMENTS) references Enrollments (ENROLLMENTS) 
;

Alter table Stipends add Constraint fk_ENRL_STIPENDS foreign key (ENROLLMENTS) references Enrollments (ENROLLMENTS) 
;

Alter table Fee_Waivers add Constraint fk_ENRL_FEE_WAIVERS foreign key (ENROLLMENTS) references Enrollments (ENROLLMENTS) 
;

Alter table Test_Credits add Constraint fk_ENRL_TEST_CREDS foreign key (ENROLLMENTS) references Enrollments (ENROLLMENTS) 
;

Alter table Courses_to_Degree add Constraint fk_HTD_COURSES foreign key (HOURS_TO_DEGREE) references Hours_to_Degree (HOURS_TO_DEGREE)  DEFERRABLE
;

Alter table Financial_Aid_Awards add Constraint fk_FINAID_FINAID_AWDS foreign key (FINANCIAL_AID_DEMO) references Financial_Aid_Demo (FINANCIAL_AID_DEMO)  DEFERRABLE
;

Alter table Course_Meetings add Constraint fk_IAF_CRS_MTGS foreign key (INSTRUCTIONAL_ACTIVITY) references Instructional_Activity (INSTRUCTIONAL_ACTIVITY) 
;

Alter table Buildings add Constraint fk_SITES_BLDGS foreign key (SITES) references Sites (SITES) 
;

Alter table Rooms add Constraint fk_SITES_ROOMS foreign key (SITES) references Sites (SITES) 
;

Alter table Bldg_Plnt_Oper_Maint add Constraint fk_SITES_POM foreign key (SITES) references Sites (SITES) 
;

Alter table Bldg_Plnt_Oper_Maint add Constraint fk_BLDG_POM foreign key (BUILDINGS) references Buildings (BUILDINGS) 
;

Alter table Rooms add Constraint fk_BLDG_ROOM foreign key (BUILDINGS) references Buildings (BUILDINGS) 
;

Alter table Workload_Activities add Constraint WKLD_PF_ACTIVITY_DETAILS foreign key (WKLD_PERSON_FUNDING) references Workload_Person_Funding (WKLD_PERSON_FUNDING) 
;

Alter table Workload_Activity_Summary add Constraint WKLD_PF_SUMMARIES foreign key (WKLD_PERSON_FUNDING) references Workload_Person_Funding (WKLD_PERSON_FUNDING) 
;

Alter table Workload_Activities add Constraint WKLD_ACT_SUMMS foreign key (WKLD_ACT_SUMM) references Workload_Activity_Summary (WKLD_ACT_SUMM) 
;

Alter table Employee_Data add Constraint EMPL_DEMO_EMPL_DATA foreign key (EMPLOYEE_DEMO) references Employee_Demo (EMPLOYEE_DEMO) 
;

Alter table Submitted_Data add Constraint fk_Submit_Data foreign key (APPROVAL_STATUS) references Approval_Status (APPROVAL_STATUS) 
;

Alter table Sites add Constraint fk_CAMPUS_SITES foreign key (CAMPUS) references Campus (CAMPUS) 
;

Alter table Buildings add Constraint fk_CAMPUS_BLDGS foreign key (CAMPUS) references Campus (CAMPUS) 
;

Alter table Rooms add Constraint fk_CAMPUS_ROOMS foreign key (CAMPUS) references Campus (CAMPUS) 
;

Alter table Bldg_Plnt_Oper_Maint add Constraint fk_CAMPUS_POM foreign key (CAMPUS) references Campus (CAMPUS) 
;


-- Create Table comments section

Comment on table Applicants_Admits is 'By Year:  
   Limited Access Program
By Term:
   Admissions (prelim and final)
   Initial Educator Preparation'
;
Comment on table 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 Tests_Reqs is 'Data Sources: ADM, LAP, IEP'
;
Comment on table DOE_Pgm_Info is 'By Term:
   Initial Educator Preparation'
;
Comment on table College_Prep is 'By Year (change to by 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 Enrollments is 'By Term:
   Student (prelim and final)'
;
Comment on table Courses_Taken is 'By Term:
   Student (prelim and final)'
;
Comment on table 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 Fellowships is 'By Term:
   Student (final)'
;
Comment on table Stipends is 'By Term:
   Student (final)'
;
Comment on table Fee_Waivers is 'By Term:
   Student (final)'
;
Comment on table Degrees_Awarded is 'By Term:
   Student (prelim and final)
   Initial Educator Preparation'
;
Comment on table Hours_to_Degree is 'By Year (change to by Term ????):
   Hours to Degree'
;
Comment on table Courses_to_Degree is 'By Year (change to by Term ????):
   Hours to Degree'
;
Comment on table Financial_Aid_Demo is 'By Fiscal Year:
   Student Financial Aid'
;
Comment on table Financial_Aid_Awards is 'By Term:
   Student Financial Aid'
;
Comment on table Instructional_Activity is 'By Term:
   Instructional Activity File'
;
Comment on table Workload_Activities is 'By Term:
     Details of workload, effort, and credit for Instruction and Research related activities.'
;
Comment on table 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 Talented_20 is 'By Year: data provided by DOE Applications
   Talented 20 Data from Public Schools
   NOTE:  Viewable only as join to
                 Person Demographics'
;
Comment on table College_Prepaid is 'By Term: FPC.MATRIC generation data set at NWRDC
   College Prepaid Tuition Eligibility
   NOTE:  Viewable only as join to
                 Person Demographics'
;
Comment on table Military_Participants is 'By Year: data retrieved from Dept of Defense by FETPIP
   Military participants to be excluded
   from Graduation Retention Survey
   NOTE:  Viewable only as join to
                 Retention Demographics'
;
Comment on table Approval_Status 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 Person_Best_IDs is 'PERSON_BEST_IDS contains a set of persond identifiers a unique SYSID within an institution.  It represents the last demographic information received from the institution.'
;
Comment on table Submitted_Data is 'This table contains the raw data officially submitted to the BOG.'
;

-- Create Attribute comments section

Comment on column Person_Demo.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) in which the demographic data is reported.'
;
Comment on column Person_Demo.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Person_Demo.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Person_Demo.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column 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 Person_Demo.BIRTH_YYYYMM_DT is '01024 - Date of Birth YYYYMM'
;
Comment on column Person_Demo.NAME_LAST is '01033 - Person Name - Last'
;
Comment on column Person_Demo.NAME_FIRST is '01091 - Person Name - First'
;
Comment on column Person_Demo.NAME_MI is '01092 - Person Name - Middle Initial'
;
Comment on column Person_Demo.SUFFIX is 'New field.  Ex: JR, SR, III, MD, FAC, CRNA'
;
Comment on column Person_Demo.GENDER is '01048 - Gender'
;
Comment on column Person_Demo.RACE_ETHNICITY is '01044 - Racial/Ethnic Group'
;
Comment on column Person_Demo.HISPANIC_FLG is '01491 - Ethnicity (Hispanic or Latino)'
;
Comment on column Person_Demo.AM_IND_ALASKAN_FLG is '01492 - American Indian or Alaskan Native'
;
Comment on column Person_Demo.ASIAN_FLG is '01493 - Asian'
;
Comment on column Person_Demo.BLACK_AFRICAN_AM_FLG is '01494 - Black or African American'
;
Comment on column Person_Demo.NAT_HAWAII_PAC_IS_FLG is '01495 - Native Hawaiian or Other Pacific Islander'
;
Comment on column Person_Demo.WHITE_FLG is '01496 - White'
;
Comment on column Person_Demo.NON_RES_ALIEN_FLG is 'New field'
;
Comment on column Person_Demo.NO_RACE_REPORT_FLG is '01497 - No Race Reported'
;
Comment on column Person_Demo.U_RESV_1 is 'New Univ Reserved Area'
;
Comment on column Person_Demo.RACE_ETHNICITY_LBL is 'Value Label for RACE_ETHNICITY'
;
Comment on column Person_Demo.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Person_Demo.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Person_IDs.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.'
;
Comment on column Person_IDs.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Person_IDs.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Person_IDs.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Person_IDs.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 Person_IDs.PERSON_ID_ENC is '01029 - Person Identification Number (encrypted)'
;
Comment on column Person_IDs.PID_VALID_SSN is 'A code indicating whether or not Person_ID_Enc is a valid SSN (Y=yes, N=No)'
;
Comment on column Person_IDs.PERSON_ID_PRV_ENC is '01427 - Person Identificaiton Number Previous (encrypted)'
;
Comment on column Person_IDs.PID_PRV_VALID_SSN is 'A code indicating whether or not Person_ID_Prv_Enc is a valid SSN (Y=yes, N=No)'
;
Comment on column Person_IDs.BIRTH_DT is '01024 - Date of Birth YYYY-MM-DD'
;
Comment on column Person_IDs.NAME_LAST_SOUNDEX is '01033 - Person Name - Last (Upper cased, no special characters and soundex applied)'
;
Comment on column Person_IDs.NAME_FIRST_SOUNDEX is '01091 - Person Name - First (Upper cased, no special characters, phrase manipulated and soundex applied)'
;
Comment on column Person_IDs.ALT_ID is 'Alternate ID - provided by the EDW upon match to existing or creation of new individual.'
;
Comment on column Person_IDs.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Person_IDs.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Applicants_Admits.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Applicants_Admits.APP_ADM_SOURCE is 'Source of the application/admission information contained in the current record:  ADM, LAP, IEP'
;
Comment on column Applicants_Admits.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Applicants_Admits.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Applicants_Admits.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 Applicants_Admits.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (TEF,LAP)'
;
Comment on column 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 Applicants_Admits.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Applicants_Admits.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Applicants_Admits.FINAL_ADM_ACTION is '01135 - Final Admission Action (ADM) and 01143 - Limited Access Action (LAP)'
;
Comment on column Applicants_Admits.REGISTERED_CD is '01136 - Registered Code (ADM, LAP)'
;
Comment on column Applicants_Admits.COUNTY_OF_RES is '01055 - County of Residence, SUS'
;
Comment on column Applicants_Admits.FEE_CLASS_RES is '01106 - Fee Classification - Residency'
;
Comment on column Applicants_Admits.ADM_DEPOSIT_IND is '01151 - Admissions Deposit Indicator'
;
Comment on column Applicants_Admits.STU_CLASS_LEVEL is '01060 - Student Classification Level'
;
Comment on column Applicants_Admits.DISPLACED_STU_IND is '01809 - Displaced Student Indicator         '
;
Comment on column Applicants_Admits.LAST_INST_CD is '01067 - Last Institution Code'
;
Comment on column 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 Applicants_Admits.DEG_HIGHEST_HELD is '01112 - Degree - Highest Level Held'
;
Comment on column Applicants_Admits.LAST_POSTSEC_DT is '01169 - Date of Last Attendance YYYYMM'
;
Comment on column Applicants_Admits.GPA_COLLEGE is '01270 - College GPA'
;
Comment on column Applicants_Admits.HS_ETS_CD is '01069 - High School Code'
;
Comment on column Applicants_Admits.LAST_SECONDARY_DT is '01169 - Date of Last Attendance YYYYMM'
;
Comment on column Applicants_Admits.GPA_HIGH_SCHOOL is '01139 - High School GPA'
;
Comment on column Applicants_Admits.GPA_GED_COMPONENT is '01275 - GPA - General Education Component = (IEP)'
;
Comment on column Applicants_Admits.GPA_BACHELORS is '01241 - GPA - Completed Bachelors Degree Pgm = (IEP)'
;
Comment on column Applicants_Admits.ESOL_UNITS is '01438 - English As A Second Language Units'
;
Comment on column Applicants_Admits.DEPOSIT_AMT is '01152 - Admissions Deposit Amount'
;
Comment on column Applicants_Admits.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Applicants_Admits.U_RESV_2 is 'Originally a 5-byte field'
;
Comment on column Applicants_Admits.U_RESV_3 is 'Originally a 10-byte field'
;
Comment on column Applicants_Admits.FLA_PUBLIC_HS_FLG is '01356 - Florida Public High School Flag'
;
Comment on column Applicants_Admits.CIP_APP_ADM_LBL is 'Value Label for CIP_APP_ADM'
;
Comment on column Applicants_Admits.STU_TYP_LBL is 'Value Label for STU_TYP'
;
Comment on column Applicants_Admits.STU_TYP_GRP is 'Group Value Label for STU_TYP grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column Applicants_Admits.FINAL_ADM_ACTION_LBL is 'Value Label for FINAL_ADM_ACTION'
;
Comment on column Applicants_Admits.REGISTERED_CD_LBL is 'Value Label for REGISTERED_CD'
;
Comment on column Applicants_Admits.FEE_CLASS_RES_LBL is 'Value Label for FEE_CLASS_RES'
;
Comment on column Applicants_Admits.FEE_CLASS_RES_GRP is 'Value Label for FEE_CLASS_RES grouped by in-/out-of state (FLA=F/R/T; NON-FLA=E/A/N)'
;
Comment on column Applicants_Admits.ADM_DEPOSIT_IND_LBL is 'Value Label for ADM_DEPOSIT_IND'
;
Comment on column Applicants_Admits.STU_CLASS_LEVEL_LBL is 'Value Label for STU_CLASS_LEVEL'
;
Comment on column Applicants_Admits.LAST_INST_CD_LBL is 'Value Label for LAST_INST_CD'
;
Comment on column Applicants_Admits.LAST_INST_CD_GRP is 'Short Value Label for LAST_INST_CD in-state public institutions (eg. FGCU, BREV, etc.)'
;
Comment on column Applicants_Admits.INST_GRNT_HIDEG_CD_LBL is 'Value Label for INST_GRNT_HIDEG_CD'
;
Comment on column Applicants_Admits.INST_GRNT_HIDEG_CD_GRP is 'Short Value Label for INST_GRNT_HIDEG_CD in-state public institutions (eg. FGCU, BREV, etc.)'
;
Comment on column Applicants_Admits.DEG_HIGHEST_HELD_LBL is 'Value Label for DEG_HIGHEST_HELD'
;
Comment on column Applicants_Admits.DEG_HIGHEST_HELD_GRP is 'Group Value Label for DEG_HIGHEST_HELD grouped by Undergraduate, Bachelor, Master (including specialiests and Advanced Masters), Doctorate, First Professional'
;
Comment on column Applicants_Admits.HS_ETS_CD_LBL is 'Value Label for HS_ETS_CD'
;
Comment on column Applicants_Admits.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Applicants_Admits.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Admission_Exceptions.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Admission_Exceptions.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Admission_Exceptions.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Admission_Exceptions.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 Admission_Exceptions.EXCEPTION_SOURCE is 'Values: ADM,  STU, STUP, TEF'
;
Comment on column Admission_Exceptions.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (STU,LAP,TEF)'
;
Comment on column 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), 01413 - Type of Student at Time of Most Recent Admission (TEF)'
;
Comment on column Admission_Exceptions.EXCEPTION_TYP is '01200 - Exception Status, 01354 - Profile Assessment Flag'
;
Comment on column Admission_Exceptions.EXCEPTION_CAT is '01355 - Profile Assessment Category'
;
Comment on column Admission_Exceptions.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Admission_Exceptions.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Admission_Exceptions.U_RESV_1 is 'New Univ Reserved Area'
;
Comment on column Admission_Exceptions.STU_TYP_LBL is 'Value Label for STU_TYP'
;
Comment on column Admission_Exceptions.STU_TYP_GRP is 'Group Value Label for STU_TYP grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column Admission_Exceptions.EXCEPTION_TYP_LBL is 'Value Label for EXCEPTION_TYP'
;
Comment on column Admission_Exceptions.EXCEPTION_CAT_LBL is 'Value Label for EXCEPTION_CAT'
;
Comment on column Admission_Exceptions.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Admission_Exceptions.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Tests_Reqs.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Tests_Reqs.APP_ADM_SOURCE is 'Source of the application/admission information contained in the current record:  ADM, LAP, IEP'
;
Comment on column Tests_Reqs.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Tests_Reqs.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Tests_Reqs.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 Tests_Reqs.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (LAP)'
;
Comment on column Tests_Reqs.STU_TYP is '01117 - Type of Student at Time of Application (ADM) and 01142 - Limited Access Category (LAP)'
;
Comment on column Tests_Reqs.TCHR_PREP_DOE_CD is '01425 - State-Approved Teacher Prep Pgm - DOE Code'
;
Comment on column Tests_Reqs.TEST_REQ_CD is 'Test or Requirement Code'
;
Comment on column Tests_Reqs.TEST_SCORE_TYP is 'Type of score reported'
;
Comment on column Tests_Reqs.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported.'
;
Comment on column Tests_Reqs.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Tests_Reqs.TEST_SCORE_N is '01168 - Verbal/Other Score'
;
Comment on column 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 Tests_Reqs.REQ_MET is 'Was the requirement met ?  Y/N/I ( I=Incomplete)'
;
Comment on column Tests_Reqs.U_RESV_1 is 'New Univ Reserved Area'
;
Comment on column Tests_Reqs.STU_TYP_LBL is 'Value Label for STU_TYP'
;
Comment on column Tests_Reqs.STU_TYP_GRP is 'Group Value Label for STU_TYP grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column Tests_Reqs.TEST_REQ_LBL is 'Value Label for TEST_REQ_CD'
;
Comment on column Tests_Reqs.TEST_SCORE_TYP_LBL is 'Value Label for TEST_SCORE_TYP'
;
Comment on column Tests_Reqs.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Tests_Reqs.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column DOE_Pgm_Info.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column DOE_Pgm_Info.APP_ADM_SOURCE is 'Source of the application/admission information contained in the current record:  ADM, LAP, IEP'
;
Comment on column DOE_Pgm_Info.REPT_INST is '01045 - Reporting Institution'
;
Comment on column DOE_Pgm_Info.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column DOE_Pgm_Info.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 DOE_Pgm_Info.CIP_APP_ADM is '01242 - Admissions Application Program Category (ADM) and 01062 - Student Program Category (LAP)'
;
Comment on column DOE_Pgm_Info.STU_TYP is '01117 - Type of Student at Time of Application (ADM) and 01142 - Limited Access Category (LAP)'
;
Comment on column DOE_Pgm_Info.TCHR_PREP_DOE_CD is '01425 - State-Approved Teacher Prep Pgm - DOE Code'
;
Comment on column DOE_Pgm_Info.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column DOE_Pgm_Info.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column DOE_Pgm_Info.TCHR_PREP_DOE_LEVEL is '01423 - State-Approved Teacher Prep Pgm - DOE Level'
;
Comment on column DOE_Pgm_Info.TCHR_REG_CD is '01260 - State-Approved Teacher Prep Pgm-Registered Code'
;
Comment on column DOE_Pgm_Info.TCHR_TERM_ADMIT is '01428 - State-Approved Teacher Prep Pgm-Admission Term'
;
Comment on column DOE_Pgm_Info.TCHR_EDU_PGM_METHOD is '01436 - Teacher Education Program Method'
;
Comment on column DOE_Pgm_Info.CIP_DEGREE is '01082 - Degree Program Category'
;
Comment on column DOE_Pgm_Info.SEC_SITE is '01150 - State Approved Teacher Prep Pgm - SECONDARY SITE'
;
Comment on column DOE_Pgm_Info.U_RESV_1 is 'Originally a 5-byte field'
;
Comment on column DOE_Pgm_Info.STU_TYP_LBL is 'Value Label for STU_TYP'
;
Comment on column DOE_Pgm_Info.STU_TYP_GRP is 'Group Value Label for STU_TYP grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column DOE_Pgm_Info.TCHR_PREP_DOE_CD_LBL is 'Value Label for TCHR_PREP_DOE_CD'
;
Comment on column DOE_Pgm_Info.TCHR_PREP_DOE_LEVEL_LBL is 'Value Label for TCHR_PREP_DOE_LEVEL'
;
Comment on column DOE_Pgm_Info.TCHR_REG_CD_LBL is 'Value Label for TCHR_REG_CD'
;
Comment on column DOE_Pgm_Info.TCHR_EDU_PGM_METHOD_LBL is 'Value Label for TCHR_EDU_PGM_METHOD'
;
Comment on column DOE_Pgm_Info.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column DOE_Pgm_Info.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column College_Prep.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column College_Prep.REPT_INST is '01045 - Reporting Institution'
;
Comment on column College_Prep.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column College_Prep.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 College_Prep.REMEDIATION_AREA is '01144 - Remediation Area'
;
Comment on column College_Prep.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column College_Prep.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column College_Prep.STU_RECENT_ADM_DT is '01420 - Date of Most Recent Admission'
;
Comment on column College_Prep.HS_ETS_CD is '01069 - High School Code'
;
Comment on column College_Prep.REMEDIATION_TEST is '01145 - Test Determining Remediation'
;
Comment on column 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 College_Prep.REMEDIATION_COMP is '01146 - Remediation Completion Method'
;
Comment on column 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 College_Prep.CRS_PREFIX is '01195 - Common Course Prefix'
;
Comment on column College_Prep.CRS_NBR is '01196 - Common Course Number'
;
Comment on column College_Prep.CRS_IND is '01003 - Common Course Outside Indicator'
;
Comment on column College_Prep.REMEDIATION_INCOMP is '01148 - Remediation Incompletion Code'
;
Comment on column College_Prep.U_RESV_1 is 'Originally a 5-byte field'
;
Comment on column College_Prep.REMEDIATION_AREA_LBL is 'Value Label for REMEDIATION_AREA'
;
Comment on column College_Prep.REMEDIATION_TEST_LBL is 'Value Label for REMEDIATION_TEST'
;
Comment on column College_Prep.REMEDIATION_COMP_LBL is 'Value Label for REMEDIATION_COMP'
;
Comment on column College_Prep.COMM_COLL_CD_LBL is 'Value Label for COMM_COLL_CD'
;
Comment on column College_Prep.COMM_COLL_CD_GRP is 'Short Value Label for COMM_COLL_CD in-state public institutions (eg. FGCU, BREV, etc.)'
;
Comment on column College_Prep.CRS_IND_LBL is 'Value Label for CRS_IND'
;
Comment on column College_Prep.REMEDIATION_INCOMP_LBL is 'Value Label for REMEDIATION_INCOMP'
;
Comment on column College_Prep.HS_ETS_CD_LBL is 'Value Label for HS_ETS_CD'
;
Comment on column College_Prep.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column College_Prep.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Enrollments.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Enrollments.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Enrollments.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Enrollments.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Enrollments.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 Enrollments.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Enrollments.NATION_CITIZ is '01110 - Nation of Citizenship'
;
Comment on column Enrollments.STATE_ADM is '01111 - State Code at Time of Admission'
;
Comment on column Enrollments.COUNTY_OF_RES is '01055 - County of Residence, SUS'
;
Comment on column Enrollments.NAT_MERIT_SCH_IND is '01407 - National Merit Scholar Indicator'
;
Comment on column Enrollments.DISPLACED_STU_IND is '01809 - Displaced Student Indicator         '
;
Comment on column 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 Enrollments.HS_ETS_CD is '01069 - High School Code'
;
Comment on column Enrollments.LAST_SECONDARY_DT is '01169 - Date of Last Attendance YYYYMM'
;
Comment on column Enrollments.DUAL_ENROLL_IND is '01070 - Dual Enrollment Identification'
;
Comment on column 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 Enrollments.LAST_POSTSEC_DT is '01169 - Date of Last Attendance YYYYMM'
;
Comment on column Enrollments.STU_ENTRY_TYP is '01068 - Type of Student at Date of Entry'
;
Comment on column Enrollments.STU_ENTRY_DT is '01064 - Student Date of Entry'
;
Comment on column Enrollments.STU_RECENT_ADM_TYP is '01413 - Type of Student at Time of Most Recent Admission'
;
Comment on column Enrollments.STU_RECENT_ADM_DT is '01420 - Date of Most Recent Admission'
;
Comment on column Enrollments.FIRST_GEN_IND is '01812 - First Generation Indicator'
;
Comment on column Enrollments.FEE_CLASS_RES is '01106 - Fee Classification - Residency'
;
Comment on column Enrollments.CLAST_IND is '01244 - College Level Academic Skills Test Flag'
;
Comment on column Enrollments.MAX_CRED_TEACH_FLG is '01057 - Maximum Credit in Supervised Teaching'
;
Comment on column Enrollments.MAX_CRED_RESEARCH_FLG is '01058 - Maximum Credit in Supervised Research'
;
Comment on column Enrollments.DOC_CANDIDACY_FLG is '01059 - Doctoral Candidacy Flag'
;
Comment on column Enrollments.STU_CLASS_LEVEL is '01060 - Student Classification Level'
;
Comment on column Enrollments.CIP_STUDENT is '01062 - Student Program Category'
;
Comment on column Enrollments.DEG_HIGHEST_HELD is '01112 - Degree - Highest Level Held'
;
Comment on column 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 Enrollments.DEG_LEVEL_SOUGHT is '01053 - Degree - Level Sought'
;
Comment on column Enrollments.DOC_CLASS is 'IPEDS Reclassificaiton of First-Professional Degree Level Sought'
;
Comment on column Enrollments.BE_CD is '01065 - Student Budget Entity'
;
Comment on column Enrollments.FIRSTYR_FIRSTPROF_FLG is '01269 - First Year First Professional Flag'
;
Comment on column Enrollments.TERMINATION_CD is '01071 - Termination Code'
;
Comment on column Enrollments.EXT_PGM_FLG is '01408 - Extended Program Flag'
;
Comment on column Enrollments.VISA_TYP is '01816 - Current Visa Type'
;
Comment on column Enrollments.INST_CLASS_LVL_STU is '01267 - Institutional Classification Level of Student'
;
Comment on column Enrollments.FULL_PART_TIME_IND is '01458 - FTIC Full-Time Indicator-Entering Term'
;
Comment on column Enrollments.CURR_TERM_CRS_LOAD is '01063 - Current Term Course Load'
;
Comment on column Enrollments.CUM_HRS_ACCEPT_TRN is '01061 - Cumulative Hours Accepted (Transfer)'
;
Comment on column Enrollments.GPA_INST_HRS is '01085 - Institutional Hours for GPA'
;
Comment on column Enrollments.GPA_INST_GRD_PTS is '01086 - Total Institutional Grade Points'
;
Comment on column Enrollments.TOT_HRS_DEG_LVL is '01087 - Total Hours Earned at Current Student Degree Level'
;
Comment on column Enrollments.GPA_TERM_CRED_HRS is '01088 - Term Credit Hours for GPA'
;
Comment on column Enrollments.GPA_TERM_HRS is '01089 - Term Credit Hours Earned'
;
Comment on column Enrollments.GPA_TERM_GRD_PTS is '01090 - Term Grade Points Earned'
;
Comment on column Enrollments.U_RESV_1 is 'Originally a 20-byte field'
;
Comment on column Enrollments.U_RESV_2 is 'Originally a 20-byte field'
;
Comment on column Enrollments.FLA_PUBLIC_HS_FLG is '01356 - Florida Public High School Flag'
;
Comment on column Enrollments.IPEDS_GRADSTU_FLG is '01220 - IPEDS Unclassified Student Flag'
;
Comment on column Enrollments.WAIVER_HR_GRAD_STU is '01410 - Waiver Hours Generated By Graduate Students'
;
Comment on column Enrollments.GPA_TERM is 'TERM_GRD_PNTS_EARN / TERM_CRD_HRS_GPA'
;
Comment on column Enrollments.GPA_CUM is '(TOT_INST_GRD_PTS + TERM_GRD_PNTS_EARN) / (INST_HRS_GPA + TERM_CRD_HRS_GPA)'
;
Comment on column Enrollments.IPEDS_FALLENRL_ROWNUM is 'Row Number in which this student was reported on the IPEDS Fall Enrollment Report'
;
Comment on column Enrollments.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Enrollments.NATION_CITIZ_LBL is 'Value Label for NATION_CITIZ'
;
Comment on column Enrollments.NAT_MERIT_SCH_IND_LBL is 'Value Label for NAT_MERIT_SCH_IND'
;
Comment on column Enrollments.DISPLACED_STU_IND_LBL is 'Value Label for DISPLACED_STU_IND'
;
Comment on column Enrollments.INST_DISPLACED_FROM_LBL is 'Value Label for INST_DISPLACED_FROM'
;
Comment on column Enrollments.HS_ETS_CD_LBL is 'Value Label for HS_ETS_CD'
;
Comment on column Enrollments.DUAL_ENROLL_IND_LBL is 'Value Label for DUAL_ENROLL_IND'
;
Comment on column Enrollments.LAST_INST_CD_LBL is 'Value Label for LAST_INST_CD'
;
Comment on column Enrollments.LAST_INST_CD_GRP is 'Short Value Label for LAST_INST_CD in-state public institutions (eg. FGCU, BREV, etc.)'
;
Comment on column Enrollments.STU_ENTRY_TYP_LBL is 'Value Label for STU_TYP_ENTRY'
;
Comment on column Enrollments.STU_ENTRY_TYP_GRP is 'Group Value Label for STU_TYP_ENTRY grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column Enrollments.STU_RECENT_ADM_TYP_LBL is 'Value Label for TYP_RECENT_ADM'
;
Comment on column Enrollments.STU_RECENT_ADM_TYP_GRP is 'Group Value Label for TYP_RECENT_ADM grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column Enrollments.FIRST_GEN_IND_LBL is 'Value Label for FIRST_GEN_IND'
;
Comment on column Enrollments.FEE_CLASS_RES_LBL is 'Value Label for FEE_CLASS_RES'
;
Comment on column Enrollments.FEE_CLASS_RES_GRP is 'Value Label for FEE_CLASS_RES grouped by in-/out-of state (FLA=F/R/T; NON-FLA=E/A/N)'
;
Comment on column Enrollments.CLAST_IND_LBL is 'Value Label for CLAST_IND'
;
Comment on column Enrollments.STU_CLASS_LEVEL_LBL is 'Value Label for STU_CLASS_LEVEL'
;
Comment on column Enrollments.DEG_HIGHEST_HELD_LBL is 'Value Label for DEG_HIGHEST_HELD'
;
Comment on column Enrollments.DEG_HIGHEST_HELD_GRP is 'Group Value Label for DEG_HIGHEST_HELD grouped by Undergraduate, Bachelor, Master (including specialiests and Advanced Masters), Doctorate, First Professional'
;
Comment on column Enrollments.INST_GRNT_HIDEG_CD_LBL is 'Value Label for INST_GRNT_HIDEG_CD'
;
Comment on column Enrollments.INST_GRNT_HIDEG_GRP is 'Short Value Label for INST_GRNT_HIDEG in-state public institutions (eg. FGCU, BREV, etc.)'
;
Comment on column Enrollments.DEG_LEVEL_SOUGHT_LBL is 'Value Label for DEG_LEVEL_SOUGHT'
;
Comment on column Enrollments.DEG_LEVEL_SOUGHT_GRP is 'Group Value Label for DEG_LEVEL_SOUGHT grouped by Bachelor, Master (including specialiests and Advanced Masters), Doctorate, First Professional'
;
Comment on column Enrollments.DOC_CLASS_LBL is 'Value Label for DOC_CLASSIFICATION'
;
Comment on column Enrollments.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Enrollments.TERMINATION_CD_LBL is 'Value Label for TERMINATION_CD'
;
Comment on column Enrollments.VISA_TYP_LBL is 'Value Label for VISA_TYP'
;
Comment on column Enrollments.INST_CLASS_LVL_STU_LBL is 'Value Label for INST_CLASS_LVL_STU'
;
Comment on column Enrollments.FULL_PART_TIME_IND_LBL is 'Value Label for FULL_PART_TIME_IND'
;
Comment on column Enrollments.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Enrollments.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Courses_Taken.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Courses_Taken.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Courses_Taken.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Courses_Taken.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Courses_Taken.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 Courses_Taken.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Courses_Taken.SEGMENT_SEQ is 'Segment Counter'
;
Comment on column Courses_Taken.CRS_PREFIX is '01195 - Common Course Prefix'
;
Comment on column Courses_Taken.CRS_NBR is '01196 - Common Course Number'
;
Comment on column Courses_Taken.CRS_IND is '01003 - Common Course Outside Indicator'
;
Comment on column Courses_Taken.CRS_SECTN_NBR is '01096 - Course Section Number'
;
Comment on column Courses_Taken.STU_SECTN_CRED is '01097 - Student Section Credit'
;
Comment on column Courses_Taken.CIP_CRS is '01098 - Course Program Category'
;
Comment on column Courses_Taken.CAMPUS_CD is '01099 - Course Section Location - Campus'
;
Comment on column Courses_Taken.CRS_SECTN_LOC_CNTY is '01127 - Course Section Location - County'
;
Comment on column Courses_Taken.BE_CD is '01100 - Course Budget Entity Code'
;
Comment on column Courses_Taken.CONT_COOP_ED_IND is '01101 - Continuing and Cooperative Education Flag'
;
Comment on column Courses_Taken.GRADE_AWARDED is '01102 - Grade Awarded'
;
Comment on column Courses_Taken.STU_SECTN_FUND_CD is '01103 - Student Section Funding Flag'
;
Comment on column Courses_Taken.COLLEGE is '01507 - College (Subcomponent)'
;
Comment on column Courses_Taken.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type'
;
Comment on column Courses_Taken.PRELIM_FILE_FLG is '01105 - Preliminary File Flag'
;
Comment on column Courses_Taken.INST_OUTSIDE_IND is '01010 - Institutional Outside Indicator'
;
Comment on column Courses_Taken.DEPT_ID_CRS is '01198 - Account/Department Number - Course'
;
Comment on column Courses_Taken.HRS_SURCHARGE is '01422 - Hours - Surcharge'
;
Comment on column Courses_Taken.DIFF_TUITION_FLG is '01359 - Differential Tuition Flag'
;
Comment on column Courses_Taken.U_RESV_1 is 'Originally a 2-byte field'
;
Comment on column Courses_Taken.U_RESV_2 is 'Originally a 4-byte field'
;
Comment on column Courses_Taken.CRS_LEVEL_CLASS is '01285 - Course Level Classification'
;
Comment on column Courses_Taken.ST_FUND_CRED_HRS is '01286 - State Fundable Credit Hours'
;
Comment on column Courses_Taken.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Courses_Taken.BE_CD_LBL is 'Value Label for BUD_ENT_CD'
;
Comment on column Courses_Taken.CONT_COOP_ED_IND_LBL is 'Value Label for CONT_COOP_ED_IND'
;
Comment on column Courses_Taken.STU_SECTN_FUND_CD_LBL is 'Value Label for STU_SECTN_FUND_CD'
;
Comment on column Courses_Taken.CRS_SECTN_TYP_PRI_LBL is 'Value Label for CRS_SECTN_TYP_PRI'
;
Comment on column Courses_Taken.CRS_LEVEL_CLASS_LBL is 'Value Label for CRS_LEVEL_CLASS'
;
Comment on column Courses_Taken.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Courses_Taken.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Test_Credits.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Test_Credits.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Test_Credits.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Test_Credits.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Test_Credits.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 Test_Credits.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Test_Credits.TEST_TYP is 'Type of advanced placement credit'
;
Comment on column Test_Credits.TEST_CREDS is 'Number of advanced placement credits earned this term.'
;
Comment on column Test_Credits.U_RESV_1 is 'New Univ Reserved Area'
;
Comment on column Test_Credits.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Test_Credits.TEST_TYP_LBL is 'Value Label for TEST_TYP'
;
Comment on column Test_Credits.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Test_Credits.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Fellowships.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported.'
;
Comment on column Fellowships.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Fellowships.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Fellowships.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Fellowships.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 Fellowships.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Fellowships.SEGMENT_SEQ is 'Segment Counter'
;
Comment on column Fellowships.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Fellowships.TERM_AMOUNT is '01401 - Term Amount'
;
Comment on column Fellowships.UNIV_FUND_ID is '01400 - University Fund Identifier'
;
Comment on column Fellowships.U_RESV_1 is 'Originally a 7-byte field'
;
Comment on column Fellowships.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Fellowships.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Fellowships.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Fellowships.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Stipends.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Stipends.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Stipends.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Stipends.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Stipends.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 Stipends.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Stipends.SEGMENT_SEQ is 'Segment Counter'
;
Comment on column Stipends.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Stipends.TERM_AMOUNT is '01401 - Term Amount'
;
Comment on column Stipends.UNIV_FUND_ID is '01400 - University Fund Identifier'
;
Comment on column Stipends.FTE_TERM_PORTION is '01404 - Term Portion of Effort'
;
Comment on column Stipends.HRLY_PAY_RATE is '01402 - Hourly Rate of Pay'
;
Comment on column Stipends.SESSION_ID is '01405 - Session Flag'
;
Comment on column Stipends.CLASS_CD is '01014 - Classification Code'
;
Comment on column Stipends.CIP_ACCT_DEPT is '01013 - Account/Department CIP'
;
Comment on column Stipends.NBR_HRS_WRK_TERM is '01406 - Number of Hours Worked in Reported Term'
;
Comment on column Stipends.U_RESV_1 is 'Originally a 7-byte field'
;
Comment on column Stipends.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Stipends.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Stipends.CLASS_CD_LBL is 'Value Label for CLASS_CD'
;
Comment on column Stipends.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Stipends.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Fee_Waivers.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Fee_Waivers.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Fee_Waivers.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Fee_Waivers.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Fee_Waivers.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 Fee_Waivers.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Fee_Waivers.SEGMENT_SEQ is 'Segment Counter'
;
Comment on column Fee_Waivers.FEE_WAIVER_IND is '01463 - Waiver Indicator/3rd Party Indicator'
;
Comment on column Fee_Waivers.FEE_WAIVER_KIND is '01108 - Fee Waiver Kind/3rd Party Kind'
;
Comment on column Fee_Waivers.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Fee_Waivers.TERM_AMOUNT is '01401 - Term Amount'
;
Comment on column Fee_Waivers.UNIV_FUND_ID is '01400 - University Fund Identifier'
;
Comment on column Fee_Waivers.LINK_INST is '01815 - Linkage Institute'
;
Comment on column Fee_Waivers.U_RESV_1 is 'Originally a 6-byte field'
;
Comment on column Fee_Waivers.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Fee_Waivers.FEE_WAIVER_IND_LBL is 'Value Label for FEE_WAIVER_IND'
;
Comment on column Fee_Waivers.FEE_WAIVER_KIND_LBL is 'Value Label for FEE_WAIVER_KIND'
;
Comment on column Fee_Waivers.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Fee_Waivers.LINK_INST_LBL is 'Value Label for LINK_INST'
;
Comment on column Fee_Waivers.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Fee_Waivers.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Degrees_Awarded.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Degrees_Awarded.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Degrees_Awarded.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Degrees_Awarded.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 Degrees_Awarded.FEE_CLASS_KIND is '01107 - Fee Classification - Kind'
;
Comment on column Degrees_Awarded.TERM_DEG_GRANT is '01412 - Term Degree Granted'
;
Comment on column Degrees_Awarded.DEG_LEVEL_GRANT is '01081 - Degree - Level Granted'
;
Comment on column Degrees_Awarded.CIP_DEGREE is '01082 - Degree Program Category'
;
Comment on column Degrees_Awarded.MAJOR_IND is 'Major Indicator (1=First, 2=Second, 3=Third, etc.)'
;
Comment on column Degrees_Awarded.TCHR_PREP_DOE_CD is '01425 - State-Approved Teacher Prep Pgm - DOE Code (Default to ''999'')'
;
Comment on column Degrees_Awarded.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) in which the demographic data is reported. '
;
Comment on column Degrees_Awarded.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Degrees_Awarded.AWARD_SOURCE is 'Source of the award contained in the current record:  SIF, HTD, TEF, DEG'
;
Comment on column Degrees_Awarded.TCHR_PREP_DOE_LEVEL is '01423 - State-Approved Teacher Prep Pgm - DOE Level'
;
Comment on column Degrees_Awarded.TCHR_EDU_PGM_METHOD is '01436 - Teacher Education Program Method'
;
Comment on column Degrees_Awarded.CIP_FRAC_DEG is '01083 - Degree Program Fraction of Degree Granted'
;
Comment on column Degrees_Awarded.DOC_CLASS is 'IPEDS Reclassificaiton of First-Professional Degree Level Granted'
;
Comment on column Degrees_Awarded.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Degrees_Awarded.U_RESV_1 is 'New Univ Reserved Area'
;
Comment on column Degrees_Awarded.IPEDS_RPTD_FLG is 'Has this degree been reported to IPEDS ? '
;
Comment on column Degrees_Awarded.FEE_CLASS_KIND_LBL is 'Value Label for FEE_CLASS_KIND'
;
Comment on column Degrees_Awarded.DEG_LEVEL_GRANT_LBL is 'Value Label for DEG_LEVEL_GRANT'
;
Comment on column Degrees_Awarded.DEG_LEVEL_GRANT_GRP is 'Group Value Label for DEG_LEVEL_GRANT grouped by Undergraduate, Bachelor, Master (including specialiests and Advanced Masters), Doctorate, First Professional'
;
Comment on column Degrees_Awarded.TCHR_PREP_DOE_CD_LBL is 'Value Label for TCHR_PREP_DOE_CD'
;
Comment on column Degrees_Awarded.TCHR_PREP_DOE_LEVEL_LBL is 'Value Label for TCHR_PREP_DOE_LEVEL'
;
Comment on column Degrees_Awarded.TCHR_EDU_PGM_METHOD_LBL is 'Value Label for TCHR_EDU_PGM_METHOD'
;
Comment on column Degrees_Awarded.DOC_CLASS_LBL is 'Value Label for DOC_CLASSIFICATION'
;
Comment on column Degrees_Awarded.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Degrees_Awarded.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Degrees_Awarded.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Hours_to_Degree.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Hours_to_Degree.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Hours_to_Degree.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Hours_to_Degree.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 Hours_to_Degree.TERM_DEG_GRANT is '01412 - Term Degree Granted'
;
Comment on column Hours_to_Degree.DEG_LEVEL_GRANT is '01081 - Degree - Level Granted'
;
Comment on column Hours_to_Degree.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported.'
;
Comment on column Hours_to_Degree.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Hours_to_Degree.CIP_DEGREE is '01082 - Degree Program Category'
;
Comment on column Hours_to_Degree.HS_GRAD_DT is '01471 - High School Graduation Date'
;
Comment on column Hours_to_Degree.CATALOG_TERM is '01476 - Catalog - Term for Degree YYYYMM'
;
Comment on column Hours_to_Degree.CATALOG_HRS is '01477 - Catalog - Hours to Degree'
;
Comment on column Hours_to_Degree.NBR_CIP_CHGS is '01435 - Number of Degree Program Changes'
;
Comment on column Hours_to_Degree.TERM_UPPER is '01481 - Term - Upper Level YYYYMM'
;
Comment on column Hours_to_Degree.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Hours_to_Degree.U_RESV_2 is 'Originally a 10-byte field'
;
Comment on column Hours_to_Degree.U_RESV_3 is 'Originally a 10-byte field'
;
Comment on column Hours_to_Degree.U_RESV_4 is 'Originally a 15-byte field'
;
Comment on column Hours_to_Degree.HRS_USED is '01478 - Hours Used to Degree'
;
Comment on column Hours_to_Degree.EXCESS_HRS_SUS is '01480 - Excess Hours - SUS            '
;
Comment on column Hours_to_Degree.EXCESS_HRS_NATIVE is '01479 - Excess Hours - Native     '
;
Comment on column Hours_to_Degree.DEG_LEVEL_GRANT_LBL is 'Value Label for DEG_LEVEL_GRANT'
;
Comment on column Hours_to_Degree.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Hours_to_Degree.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Courses_to_Degree.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Courses_to_Degree.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Courses_to_Degree.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Courses_to_Degree.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 Courses_to_Degree.TERM_DEG_GRANT is '01412 - Term Degree Granted'
;
Comment on column Courses_to_Degree.DEG_LEVEL_GRANT is '01081 - Degree - Level Granted'
;
Comment on column Courses_to_Degree.TERM_TAKEN is '01051 - Term Identifier of the term when the course was taken'
;
Comment on column Courses_to_Degree.CRS_INST_CD is '01482 - Institution Code - Course'
;
Comment on column Courses_to_Degree.CRS_PREFIX is '01195 - Common Course Prefix'
;
Comment on column Courses_to_Degree.CRS_NBR is '01196 - Common Course Number'
;
Comment on column Courses_to_Degree.CRS_IND is '01003 - Common Course Outside Indicator'
;
Comment on column Courses_to_Degree.CRS_SECTN_NBR is '01096 - Course Section Number'
;
Comment on column Courses_to_Degree.SEGMENT_SEQ is 'Segment Counter'
;
Comment on column Courses_to_Degree.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Courses_to_Degree.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Courses_to_Degree.STU_CLASS_LEVEL is '01483 - Course - Student Classification Level'
;
Comment on column Courses_to_Degree.CRS_SYSTEM is '01484 - Course System Code'
;
Comment on column Courses_to_Degree.CRS_GROUP is '01485 - Course Grouping Code'
;
Comment on column Courses_to_Degree.CRS_RESULT is '01486 - Course Result Code'
;
Comment on column Courses_to_Degree.REPEAT_IND is '01487 - Repeat Indicator'
;
Comment on column Courses_to_Degree.CIP_CRS is '01098 - Course Program Category'
;
Comment on column Courses_to_Degree.CRS_SECTN_TYP is '01104 - Course Section Type'
;
Comment on column Courses_to_Degree.TEST_METHOD is '01488 - Credit Hour Testing Method'
;
Comment on column Courses_to_Degree.GRADE_AWARDED is '01102 - Grade Awarded'
;
Comment on column Courses_to_Degree.USAGE_IND is '01489 - Credit Hour Usage Indicator'
;
Comment on column Courses_to_Degree.SECTN_CRED is '01459 - Section Credit'
;
Comment on column Courses_to_Degree.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Courses_to_Degree.U_RESV_2 is 'Originally a 25-byte field'
;
Comment on column Courses_to_Degree.DEG_LEVEL_GRANT_LBL is 'Value Label for DEG_LEVEL_GRANT'
;
Comment on column Courses_to_Degree.CRS_IND_LBL is 'Value Label for CRS_IND'
;
Comment on column Courses_to_Degree.STU_CLASS_LEVEL_LBL is 'Value Label for STU_CLASS_LEVEL'
;
Comment on column Courses_to_Degree.CRS_SYSTEM_LBL is 'Value Label for CRS_SYSTEM'
;
Comment on column Courses_to_Degree.CRS_GROUP_LBL is 'Value Label for CRS_GROUP'
;
Comment on column Courses_to_Degree.CRS_RESULT_LBL is 'Value Label for CRS_RESULT'
;
Comment on column Courses_to_Degree.REPEAT_IND_LBL is 'Value Label for REPEAT_IND'
;
Comment on column Courses_to_Degree.CRS_SECTN_TYP_LBL is 'Value Label for CRS_SECTN_TYP'
;
Comment on column Courses_to_Degree.TEST_METHOD_LBL is 'Value Label for TEST_METHOD'
;
Comment on column Courses_to_Degree.USAGE_IND_LBL is 'Value Label for USAGE_IND'
;
Comment on column Courses_to_Degree.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Courses_to_Degree.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Financial_Aid_Demo.REPT_TIME_FRAME is 'Financial aid year (YYYYYYYY) to which the reported data applies.'
;
Comment on column Financial_Aid_Demo.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Financial_Aid_Demo.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Financial_Aid_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 Financial_Aid_Demo.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Financial_Aid_Demo.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Financial_Aid_Demo.CURR_DEPEND_STAT is '01248 - Student Current Dependency Status'
;
Comment on column Financial_Aid_Demo.FAMILY_INCOME is '01249 - Family Income'
;
Comment on column Financial_Aid_Demo.FAMILY_CONTRIB is '01250 - Expected Family Contribution'
;
Comment on column Financial_Aid_Demo.FEE_CLASS_RES is '01106 - Fee Classification - Residency'
;
Comment on column Financial_Aid_Demo.STU_ENTRY_TYP is '01068 - Type of Student at Date of Entry'
;
Comment on column Financial_Aid_Demo.STU_CLASS_LEVEL is '01060 - Student Classification Level'
;
Comment on column Financial_Aid_Demo.CIP_STUDENT is '01062 - Student Program Category'
;
Comment on column Financial_Aid_Demo.FINAID_NEED is '01251 - Financial Aid Need'
;
Comment on column Financial_Aid_Demo.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Financial_Aid_Demo.U_RESV_2 is 'Originally a 20-byte field'
;
Comment on column Financial_Aid_Demo.NEED_BASED_AID_IND is '01446 - Need Based Aid Flag'
;
Comment on column Financial_Aid_Demo.CURR_DEPEND_STAT_LBL is 'Value Label for CURR_DEPEND_STAT'
;
Comment on column Financial_Aid_Demo.FEE_CLASS_RES_LBL is 'Value Label for FEE_CLASS_RES'
;
Comment on column Financial_Aid_Demo.FEE_CLASS_RES_GRP is 'Value Label for FEE_CLASS_RES grouped by in-/out-of state (FLA=F/R/T; NON-FLA=E/A/N)'
;
Comment on column Financial_Aid_Demo.STU_ENTRY_TYP_LBL is 'Value Label for STU_ENTRY_TYP'
;
Comment on column Financial_Aid_Demo.STU_ENTRY_TYP_GRP is 'Group Value Label for STU_ENTRY_TYP grouped by First Prof (Law, Medicine Dentistry, Vet Med, PharmD), Graduate, Undergraduate, Unclassified '
;
Comment on column Financial_Aid_Demo.STU_CLASS_LEVEL_LBL is 'Value Label for STU_CLASS_LEVEL'
;
Comment on column Financial_Aid_Demo.NEED_BASED_AID_IND_LBL is 'Value Label for NEED_BASED_AID_IND'
;
Comment on column Financial_Aid_Demo.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Financial_Aid_Demo.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Financial_Aid_Awards.REPT_TIME_FRAME is 'Financial aid year (YYYYYYYY) to which the reported data applies.'
;
Comment on column Financial_Aid_Awards.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Financial_Aid_Awards.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Financial_Aid_Awards.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 Financial_Aid_Awards.AWARD_PAYMENT_TERM is 'Term of the award'
;
Comment on column Financial_Aid_Awards.AWARD_PROG_ID is '01253 - Financial Aid Award Program Identifier'
;
Comment on column Financial_Aid_Awards.AWARD_COND_ID is '01254 - Financial Aid Award Condition I.D.'
;
Comment on column Financial_Aid_Awards.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Financial_Aid_Awards.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Financial_Aid_Awards.SOURCE_FUNDS is '01255 - Source of Funds'
;
Comment on column Financial_Aid_Awards.TERM_AMOUNT is '01256 thru 01259 - Summer1/Fall/Spring/Summer2 Paid Amount'
;
Comment on column Financial_Aid_Awards.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Financial_Aid_Awards.AWARD_PROG_ID_LBL is 'Value Label for AWARD_PROG_ID'
;
Comment on column Financial_Aid_Awards.AWARD_PROG_ID_GRP is 'Value Label for AWARD_PROG_ID grouped by Grant (000-099), Loan (100-199),Scholarship (200-299), Employment (300-399)'
;
Comment on column Financial_Aid_Awards.AWARD_COND_ID_LBL is 'Value Label for AWARD_COND_ID'
;
Comment on column Financial_Aid_Awards.AWARD_COND_ID_GRP is 'Value Label for AWARD_COND_ID grouped by Need Based (1-4) and Non-Need Based (5-8)'
;
Comment on column Financial_Aid_Awards.SOURCE_FUNDS_LBL is 'Value Label for SOURCE_FUNDS'
;
Comment on column Financial_Aid_Awards.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Financial_Aid_Awards.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Retention_Cohorts.REPT_TIME_FRAME is '01430 - Cohort Year (YYYYYYYY)'
;
Comment on column Retention_Cohorts.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Retention_Cohorts.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Retention_Cohorts.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 Retention_Cohorts.COHORT_TYP is '01429 - Cohort Type'
;
Comment on column Retention_Cohorts.STU_RIGHT_KNOW_FLG is '01437 - Student-Right-to-Know (SRK) Flag'
;
Comment on column Retention_Cohorts.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Retention_Cohorts.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Retention_Cohorts.COHORT_TYP_NEW is '01429 - Cohort Type (Revised)'
;
Comment on column Retention_Cohorts.SRK_FLG_NEW is '01437 - Student-Right-to-Know (SRK) Flag'
;
Comment on column Retention_Cohorts.COHORT_ADJUST_IND is '01442 - Cohort Adjustment Flag'
;
Comment on column Retention_Cohorts.FULL_PART_ADJUST_IND is '01458 - FTIC Full-Time Indicator-Entering Term'
;
Comment on column Retention_Cohorts.GENDER_NEW is '01048 - Gender'
;
Comment on column Retention_Cohorts.RACE_ETHNICITY_NEW is '01044 - Racial/Ethnic Group'
;
Comment on column Retention_Cohorts.COHORT_TYP_LBL is 'Value Label for COHORT_TYP'
;
Comment on column Retention_Cohorts.COHORT_TYP_NEW_LBL is 'Value Label for COHORT_TYP_NEW'
;
Comment on column Retention_Cohorts.COHORT_ADJUST_IND_LBL is 'Value Label for COHORT_ADJUST_IND'
;
Comment on column Retention_Cohorts.FULL_PART_ADJUST_IND_LBL is 'Value Label for FULL_PART_ADJUST_IND'
;
Comment on column Retention_Cohorts.RACE_ETHNICITY_NEW_LBL is 'Value Label for RACIAL_ETHNIC_NEW'
;
Comment on column Retention_Cohorts.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Retention_Cohorts.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Instructional_Activity.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Instructional_Activity.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Instructional_Activity.SESSION_ID is '01405 - Session Flag'
;
Comment on column Instructional_Activity.CRS_PREFIX is '01195 - Common Course Prefix'
;
Comment on column Instructional_Activity.CRS_NBR is '01196 - Common Course Number'
;
Comment on column Instructional_Activity.CRS_IND is '01003 - Common Course Outside Indicator'
;
Comment on column Instructional_Activity.CRS_SECTN_NBR is '01096 - Course Section Number'
;
Comment on column Instructional_Activity.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type'
;
Comment on column Instructional_Activity.VAR_CRED_FLG is '01114 - Variable Credit Flag'
;
Comment on column Instructional_Activity.CIP_CRS is '01098 - Course Program Category'
;
Comment on column Instructional_Activity.BE_CD_CRS is '01100 - Course Budget Entity Code'
;
Comment on column Instructional_Activity.DEPT_ID_CRS is '01198 - Account/Department Number - Course'
;
Comment on column Instructional_Activity.SECTN_ENROLL_CRED is '01124 - Section Enrollment for Credit'
;
Comment on column Instructional_Activity.CRS_CRED_HRS is '01128 - Course Credit Hours'
;
Comment on column Instructional_Activity.ACT_SECTN_INSTR_HRS is '01113 - Actual Section Instruction Hours'
;
Comment on column Instructional_Activity.DELIVERY_IND is '01417 - Instructional Delivery Indicator '
;
Comment on column Instructional_Activity.TECH_IND_PRIMARY is '01418 - Technology Delivery Indicator'
;
Comment on column Instructional_Activity.TECH_IND_SECONDARY is '01418 - Technology Delivery Indicator'
;
Comment on column Instructional_Activity.TECH_IND_TERTIARY is '01418 - Technology Delivery Indicator'
;
Comment on column Instructional_Activity.COUNTRY_CD is '011703 - Country Code'
;
Comment on column Instructional_Activity.U_RESV_1 is 'Originally a 20-byte field'
;
Comment on column Instructional_Activity.U_RESV_2 is 'Originally a 20-byte field'
;
Comment on column Instructional_Activity.SECTN_HEADCNT_ENROL is '01287 - Section Headcount Enrollment'
;
Comment on column Instructional_Activity.TOTAL_CRS_CRED_HRS is '01510 - Total Student Credit Hours for Course Section'
;
Comment on column Instructional_Activity.FNDBL_CRS_CRED_HRS is '01511 - Total Fundable Student Credit Hours (SCHs)for Course Section'
;
Comment on column Instructional_Activity.FNDBL_GRAD_DOC_HRS is '01529 - Fundable Grad Level SCHs Generated by Doctoral Students'
;
Comment on column Instructional_Activity.DOC_STU_GRAD_HRS is '01288 - Graduate Level SCHs Generated by Doctoral Students'
;
Comment on column Instructional_Activity.CRS_SECTN_TYP_PRI_LBL is 'Value Label for CRS_SECTN_TYP_PRI'
;
Comment on column Instructional_Activity.VAR_CRED_FLG_LBL is 'Value Label for Course VAR_CRED_FLG'
;
Comment on column Instructional_Activity.BE_CD_CRS_LBL is 'Value Label for BE_CD_CRS'
;
Comment on column Instructional_Activity.DELIVERY_IND_LBL is 'Value Label for DELIVERY_IND'
;
Comment on column Instructional_Activity.TECH_IND_PRIMARY_LBL is 'Value Label for TECH_IND_PRIMARY'
;
Comment on column Instructional_Activity.TECH_IND_SECONDARY_LBL is 'Value Label for TECH_IND_SECONDARY'
;
Comment on column Instructional_Activity.TECH_IND_TERTIARY_LBL is 'Value Label for TECH_IND_TERTIARY'
;
Comment on column Instructional_Activity.COUNTRY_LBL is 'Value Label for COUNTRY_CD'
;
Comment on column Instructional_Activity.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Instructional_Activity.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Course_Meetings.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Course_Meetings.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Course_Meetings.SESSION_ID is '01405 - Session Flag'
;
Comment on column Course_Meetings.CRS_PREFIX is '01195 - Common Course Prefix'
;
Comment on column Course_Meetings.CRS_NBR is '01196 - Common Course Number'
;
Comment on column Course_Meetings.CRS_IND is '01003 - Common Course Outside Indicator'
;
Comment on column Course_Meetings.CRS_SECTN_NBR is '01096 - Course Section Number'
;
Comment on column Course_Meetings.CRS_SECTN_BEG_TIME is '01120 - Beginning Time of Course Section HHMM (24 hour clock)'
;
Comment on column Course_Meetings.CRS_SECTN_END_TIME is '01121 - Ending Time of Course Section HHMM (24 hour clock)'
;
Comment on column Course_Meetings.SUNDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.MONDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.TUESDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.WEDNESDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.THURSDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.FRIDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.SATURDAY is '01123 - Days of Class Meeting'
;
Comment on column Course_Meetings.BLDG_NBR is '01130 - Building Number'
;
Comment on column Course_Meetings.ROOM_NBR_PREFIX is '01132 - Room Number Prefix'
;
Comment on column Course_Meetings.ROOM_NBR_DIGITS is '01133 - Room Number Digits'
;
Comment on column Course_Meetings.ROOM_NBR_SUFFIX is '01134 - Room Number Suffix'
;
Comment on column Course_Meetings.UNSCHED_MTG_IND is '01197 - Unscheduled Meeting Time Flag'
;
Comment on column Course_Meetings.CRS_SECTN_TYP is '01104 - Course Section Type'
;
Comment on column Course_Meetings.CAMPUS_CD is '01099 - Course Section Location - Campus; Legacy 2-character Campus Code is right-justified, zero-filled'
;
Comment on column Course_Meetings.CRS_SECTN_LOC_CNTY is '01127 - Course Section Location - County'
;
Comment on column Course_Meetings.ZIP is '10048 - Site Zone Identification Postal'
;
Comment on column 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 Course_Meetings.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Course_Meetings.UNSCHED_MTG_IND_LBL is 'Value Label for UNSCHED_MTG_IND'
;
Comment on column Course_Meetings.CRS_SECTN_TYP_LBL is 'Value Label for CRS_SECTN_TYP'
;
Comment on column Course_Meetings.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Course_Meetings.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Sites.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Sites.CAMPUS_CD is '10060 - Campus Code - Site; Legacy 2-character Campus Code is right-justified, zero-filled'
;
Comment on column Sites.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)'
;
Comment on column Sites.SITE_NBR is '10062 - Site Number'
;
Comment on column Sites.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Sites.NAME is '10042 - Site Name'
;
Comment on column Sites.STREET_ADDR is '10043 - Site Street Address'
;
Comment on column Sites.CITY_LOC is '10044 - Site City Location'
;
Comment on column Sites.ZIP is '10048 - Site Zone Identification Postal'
;
Comment on column Sites.ACRES is '10045 - Site Area'
;
Comment on column Sites.OWNERSHIP is '10056 - Site Ownership'
;
Comment on column Sites.USAGE is '10057 - Site Type'
;
Comment on column Sites.ACQUIS_YR is '10024 - Site Year of Acquisition'
;
Comment on column Sites.PARKING is '10049 - Site Parking'
;
Comment on column Sites.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Sites.U_RESV_2 is 'Originally a 14-byte field'
;
Comment on column Sites.OWN_BLDG_CNT is '10046 - Site Number of Owned Buildings'
;
Comment on column Sites.OWN_BLDG_AREA is '10047 - Site Owned Building Area'
;
Comment on column Sites.OWNERSHIP_LBL is 'Value Label for SITE_OWNERSHIP'
;
Comment on column Sites.ST_OWNED_FLG is 'Program generated from SITE_OWNERSHIP'
;
Comment on column Sites.USAGE_LBL is 'Value Label for USAGE'
;
Comment on column Sites.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Sites.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Buildings.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Buildings.CAMPUS_CD is '10060 - Campus Code - Site; Legacy 2-character Campus Code is right-justified, zero-filled'
;
Comment on column Buildings.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)'
;
Comment on column Buildings.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Buildings.SITE_NBR is '10062 - Site Number'
;
Comment on column Buildings.BLDG_NBR is '01130 - Building Number'
;
Comment on column Buildings.NAME is '10011 - Building Name'
;
Comment on column Buildings.OWNERSHIP is '10021 - Building Ownership'
;
Comment on column Buildings.STATUS is '10012 - Building Status'
;
Comment on column Buildings.STRUCTURE is '10017 - Building Structure'
;
Comment on column Buildings.EXTERIOR is '10018 - Building Exterior'
;
Comment on column Buildings.CONDITION_BLDG is '10035 - Building Condition'
;
Comment on column Buildings.STU_RES_HOUS_FLG is '10013 - Student Residential Housing Flag'
;
Comment on column Buildings.JOINT_USE_IND is '10015 - Building Joint-Use Indicator'
;
Comment on column Buildings.CONSTRUCT_YR is '10019 - Building Construction Year'
;
Comment on column Buildings.OCCUPY_DT is '10020 - Building Occupancy Date YYYYMM'
;
Comment on column Buildings.ALTER_YR is '10022 - Building Structural Alteration Year'
;
Comment on column Buildings.SURVEY_YR is '10066 - Building Survey Year'
;
Comment on column Buildings.GSF is '10025 - Building Gross Square Feet'
;
Comment on column Buildings.BE_CD_BLDG is '10055 - Building Budget Entity Code'
;
Comment on column Buildings.ENV_COND is '10067 - Building Envelope Condition'
;
Comment on column Buildings.ROOF_COND is '10068 - Building Roof System Condition'
;
Comment on column Buildings.MECH_COND is '10069 - Building Mechanical System Condition'
;
Comment on column Buildings.ELEC_COND is '10070 - Building Electrical System Condition'
;
Comment on column Buildings.PLMB_COND is '10071 - Building Plumbing System Condition'
;
Comment on column Buildings.U_RESV_1 is 'Originally a 20-byte field'
;
Comment on column Buildings.OWNERSHIP_LBL is 'Value Label for OWNERSHIP'
;
Comment on column Buildings.ST_OWNED_FLG is 'Program generated from OWNERSHIP'
;
Comment on column Buildings.STATUS_LBL is 'Value Label for LONGEVITY'
;
Comment on column Buildings.STRUCTURE_LBL is 'Value Label for STRUCTURE'
;
Comment on column Buildings.EXTERIOR_LBL is 'Value Label for EXTERIOR'
;
Comment on column Buildings.CONDITION_BLDG_LBL is 'Value Label for CONDITION_BLDG'
;
Comment on column Buildings.JOINT_USE_IND_LBL is 'Value Label for JOINT_USE_IND'
;
Comment on column Buildings.BE_CD_BLDG_LBL is 'Value Label for BE_CD'
;
Comment on column Buildings.ENV_COND_LBL is 'Value Label for ENV_COND'
;
Comment on column Buildings.ROOF_COND_LBL is 'Value Label for ROOF_COND'
;
Comment on column Buildings.MECH_COND_LBL is 'Value Label for MECH_COND'
;
Comment on column Buildings.ELEC_COND_LBL is 'Value Label for ELEC_COND'
;
Comment on column Buildings.PLMB_COND_LBL is 'Value Label for PLMB_COND'
;
Comment on column Buildings.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Buildings.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Rooms.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Rooms.CAMPUS_CD is '10060 - Campus Code - Site; Legacy 2-character Campus Code is right-justified, zero-filled'
;
Comment on column Rooms.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)'
;
Comment on column Rooms.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Rooms.SITE_NBR is '10062 - Site Number'
;
Comment on column Rooms.BLDG_NBR is '01130 - Building Number'
;
Comment on column Rooms.ROOM_NBR_PREFIX is '01132 - Room Number Prefix'
;
Comment on column Rooms.ROOM_NBR_DIGITS is '01133 - Room Number Digits'
;
Comment on column Rooms.ROOM_NBR_SUFFIX is '01134 - Room Number Suffix'
;
Comment on column Rooms.FLOOR_LEVEL is '10007 - Room Floor Level'
;
Comment on column Rooms.PRORATION is '10001 - Room Proration'
;
Comment on column Rooms.NAME is '10037 - Room Name'
;
Comment on column Rooms.USE_CD is '10002 - Room Use Code'
;
Comment on column Rooms.CATEGORY is '10003 - Room Category'
;
Comment on column Rooms.CAPACITY_ACTUAL is '10010 - Room Capacity - Actual'
;
Comment on column Rooms.CAPACITY_DESIGN is '10009 - Room Capacity - Design'
;
Comment on column Rooms.CONDITION_ROOM is '10040 - Room Condition'
;
Comment on column Rooms.PCS_PROG is '10005 - Room Program (PCS)'
;
Comment on column Rooms.SHARED_USE is '10039 - Room Joint-Use Indicator'
;
Comment on column Rooms.NEEDS_GEN_ELIG is '10029 - Room Fixed Capital Outlay Exemption Code (Needs Generation Formula Eligible)'
;
Comment on column Rooms.NET_AREA is '10008 - Room Area'
;
Comment on column Rooms.BE_CD_POM is '10004 - Room Budget Entity - POM'
;
Comment on column Rooms.BE_CD_USER is '10063 - Room Budget Entity - User'
;
Comment on column Rooms.U_RESV_1 is 'Originally a 24-byte field'
;
Comment on column Rooms.USE_CD_LBL is 'Value Label for USE_CD'
;
Comment on column Rooms.CATEGORY_LBL is 'Value Label for CATEGORY'
;
Comment on column Rooms.CONDITION_ROOM_LBL is 'Value Label for CONDITION_ROOM'
;
Comment on column Rooms.PCS_PROG_LBL is 'Value Label for PCS_PROG'
;
Comment on column Rooms.SHARED_USE_LBL is 'Value Label for SHARED_USE'
;
Comment on column Rooms.NEEDS_GEN_ELIG_LBL is 'Value Label for NEEDS_GEN_ELIG'
;
Comment on column Rooms.BE_CD_POM_LBL is 'Value Label for BE_CD_POM'
;
Comment on column Rooms.BE_CD_USER_LBL is 'Value Label for BE_CD_USER'
;
Comment on column Rooms.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Rooms.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Bldg_Plnt_Oper_Maint.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Bldg_Plnt_Oper_Maint.CAMPUS_CD is '10060 - Campus Code - Site; Legacy 2-character Campus Code is right-justified, zero-filled'
;
Comment on column Bldg_Plnt_Oper_Maint.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)'
;
Comment on column Bldg_Plnt_Oper_Maint.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Bldg_Plnt_Oper_Maint.SITE_NBR is '10062 - Site Number'
;
Comment on column Bldg_Plnt_Oper_Maint.BLDG_NBR is '01130 - Building Number'
;
Comment on column Bldg_Plnt_Oper_Maint.BE_CD_POM is '10052 - Building POM Budget Detail Code'
;
Comment on column Bldg_Plnt_Oper_Maint.POM_BUD_FACTOR is '10053 - Building POM Budget Detail Factor'
;
Comment on column Bldg_Plnt_Oper_Maint.BE_CD_POM_LBL is 'Value Label for BE_CD_POM'
;
Comment on column Bldg_Plnt_Oper_Maint.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Bldg_Plnt_Oper_Maint.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Workload_Person_Funding.DEMO_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies.'
;
Comment on column Workload_Person_Funding.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Workload_Person_Funding.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Workload_Person_Funding.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Workload_Person_Funding.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 Workload_Person_Funding.BE_CD_EMPL is '01517 - Employee Budget Entity Code'
;
Comment on column Workload_Person_Funding.PAY_PLAN_NBR is '01037 - Pay Plan, SUS'
;
Comment on column Workload_Person_Funding.UNIV_POSITION is '01039 - University Position'
;
Comment on column Workload_Person_Funding.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Workload_Person_Funding.UNIV_BUD_ID is '01798 - University Budget Identifier'
;
Comment on column Workload_Person_Funding.CLASS_CD is '01730 - Classification Code, SUS/01014 - Classification Code'
;
Comment on column Workload_Person_Funding.RANK_FAC is '01028 - Rank, Faculty'
;
Comment on column Workload_Person_Funding.ADMIN_CD_PRI is '01409 - Administrative Code - Faculty and other'
;
Comment on column Workload_Person_Funding.INSTRCT_RESRCH_FTE is '01501 - Term Instruction and Research FTE'
;
Comment on column Workload_Person_Funding.BUD_WKS_TERM is '01502 - Budgeted Weeks of Activity, Term'
;
Comment on column Workload_Person_Funding.PERYRS_TERM is '01503 - Person Year, I and R Equivalent Effort - Term'
;
Comment on column Workload_Person_Funding.TERM_AMT_REQ_BENE is '01504 - Term Amount Required With Benefits'
;
Comment on column Workload_Person_Funding.DEPT_EMP_PROG_COMP is '01518 - Program Component-Employee/Department'
;
Comment on column Workload_Person_Funding.EMPL_CONTACT_HRS is '01527 - Employee Contact Hours'
;
Comment on column Workload_Person_Funding.CIP_EMP is '01528 - Employee Program Category'
;
Comment on column Workload_Person_Funding.OCC_ACT_CAT_EEO6 is '01617 - Occupational Activity Category'
;
Comment on column Workload_Person_Funding.TENURE_STAT is '01671 - Tenure Status'
;
Comment on column Workload_Person_Funding.U_RESV_1 is 'Originally a 50-byte field'
;
Comment on column Workload_Person_Funding.CLASS_LBL is 'Value label for CLASS_CD'
;
Comment on column Workload_Person_Funding.RANK_LBL is 'Value label for RANK_FAC'
;
Comment on column Workload_Person_Funding.TENURE_LBL is 'Value label for TENURE_STAT'
;
Comment on column Workload_Person_Funding.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Workload_Person_Funding.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Workload_Activity_Summary.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Workload_Activity_Summary.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Workload_Activity_Summary.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Workload_Activity_Summary.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Workload_Activity_Summary.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 Workload_Activity_Summary.BE_CD_EMPL is '01517 - Employee Budget Entity Code'
;
Comment on column Workload_Activity_Summary.PAY_PLAN_NBR is '01037 - Pay Plan, SUS'
;
Comment on column Workload_Activity_Summary.UNIV_POSITION is '01039 - University Position'
;
Comment on column Workload_Activity_Summary.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Workload_Activity_Summary.UNIV_BUD_ID_ACT is '01798 - University Budget Identifier'
;
Comment on column Workload_Activity_Summary.BE_CD_ACT is '01505 - Activity Budget Entity'
;
Comment on column Workload_Activity_Summary.CIP_CRS is '01098 - Course Program Category'
;
Comment on column Workload_Activity_Summary.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type'
;
Comment on column Workload_Activity_Summary.COLLEGE is '01507 - College (Subcomponent)'
;
Comment on column Workload_Activity_Summary.PROG_COMP_ACT is '01508 - Program Component - Activity'
;
Comment on column Workload_Activity_Summary.INSTR_RESRCH_ACT is '01509 - Instruction and Research Activities'
;
Comment on column Workload_Activity_Summary.PERYRS_ACT_PORT is '01526 - Activity Portion of Person Years'
;
Comment on column Workload_Activity_Summary.FTE_ACT_PORTION is '01512 - Activity Portion of Effort'
;
Comment on column Workload_Activity_Summary.U_RESV_1 is 'Originally a 50-byte field'
;
Comment on column Workload_Activity_Summary.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Workload_Activity_Summary.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Workload_Activities.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Workload_Activities.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Workload_Activities.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Workload_Activities.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Workload_Activities.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 Workload_Activities.BE_CD_EMPL is '01517 - Employee Budget Entity Code'
;
Comment on column Workload_Activities.PAY_PLAN_NBR is '01037 - Pay Plan, SUS'
;
Comment on column Workload_Activities.UNIV_POSITION is '01039 - University Position'
;
Comment on column Workload_Activities.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Workload_Activities.UNIV_BUD_ID is '01798 - University Budget Identifier'
;
Comment on column Workload_Activities.BE_CD_ACT is '01505 - Activity Budget Entity'
;
Comment on column Workload_Activities.COLLEGE is '01507 - College (Subcomponent)'
;
Comment on column Workload_Activities.PROG_COMP_ACT is '01508 - Program Component - Activity'
;
Comment on column Workload_Activities.INSTR_RESRCH_ACT is '01509 - Instruction and Research Activities'
;
Comment on column Workload_Activities.CRS_SECTN_TYP_PRI is '01289 - Primary Course Section Type'
;
Comment on column Workload_Activities.CIP_CRS is '01098 - Course Program Category'
;
Comment on column Workload_Activities.DEPT_ID_ACT is '01506 - Account/Department Number, Activity'
;
Comment on column Workload_Activities.UNIV_BUD_ID_ACT is '01798 - University Budget Identifier'
;
Comment on column Workload_Activities.CRS_PREFIX is '01195 - Common Course Prefix'
;
Comment on column Workload_Activities.CRS_NBR is '01196 - Common Course Number'
;
Comment on column Workload_Activities.CRS_IND is '01003 - Common Course Outside Indicator'
;
Comment on column Workload_Activities.CRS_SECTN_NBR is '01096 - Course Section Number'
;
Comment on column Workload_Activities.SESSION_ID is '01405 - Session Flag'
;
Comment on column Workload_Activities.VAR_CRED_FLG is '01114 - Variable Credit Flag'
;
Comment on column Workload_Activities.CRS_CRED_HRS is '01128 - Course Credit Hours'
;
Comment on column Workload_Activities.INSTR_TOT_SCH is '01515 - Instructor Portion of Total SCHs for the Course Section'
;
Comment on column Workload_Activities.INSTR_FND_SCH is '01516 - Instructor Portion of Fundable SCHs for the Course Section'
;
Comment on column Workload_Activities.PORT_SECTN_WKLD is '01129 - Portion of Section Workload'
;
Comment on column Workload_Activities.PERYRS_ACT_PORT is '01526 - Activity Portion of Person Years'
;
Comment on column Workload_Activities.FTE_ACT_PORTION is '01512 - Activity Portion of Effort'
;
Comment on column Workload_Activities.CONTACT_HRS is '01513 - Instructor Portion Contact Hours/Equivalencies'
;
Comment on column Workload_Activities.CONTACT_HRS_MOD is '01514 - Contact Hour Modifier'
;
Comment on column Workload_Activities.U_RESV_1 is 'Originally a 50-byte field'
;
Comment on column Workload_Activities.U_RESV_2 is 'Originally a 12-byte field'
;
Comment on column Workload_Activities.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Workload_Activities.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Employee_Demo.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) in which the demographic data is reported. '
;
Comment on column Employee_Demo.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Employee_Demo.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Employee_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 Employee_Demo.SUB_TYP is '01726 - Submission Type'
;
Comment on column Employee_Demo.HLTH_INS_OPT_CD is '01668 - Health Insurance Option Code, State'
;
Comment on column Employee_Demo.HLTH_INS_PROV_CD is '01669 - Health Insurance Provider Code, State'
;
Comment on column Employee_Demo.LIFE_INS_PART_CD is '01635 - Life Insurance Participation Code, State'
;
Comment on column Employee_Demo.RETIRE_CD_EMP is '01047 - Retirement Code, Employment Resource'
;
Comment on column Employee_Demo.CONT_ST_SVC_DT is '01612 - Continuous State Service Date'
;
Comment on column Employee_Demo.AGENCY_HIRE_DT is '01019 - University Hire Date'
;
Comment on column Employee_Demo.RANK_FAC is '01028 - Rank, Faculty'
;
Comment on column Employee_Demo.RANK_FAC_DT is '01182 - Date of Rank, Faculty'
;
Comment on column Employee_Demo.DEG_HIGHEST_HELD is '01112 - Degree - Highest Level Held'
;
Comment on column Employee_Demo.DEG_YR_OF_HIGHEST is '01194 - Degree - Year of Highest YYYY'
;
Comment on column Employee_Demo.TENURE_STAT is '01671 - Tenure Status'
;
Comment on column Employee_Demo.TENURE_STAT_DT is '01238 - Tenure Status - Date Granted'
;
Comment on column Employee_Demo.CIP_TENURE is '01738 - Tenure CIP'
;
Comment on column Employee_Demo.OCC_ACT_CAT_EEO6 is '01617 - Occupational Activity Category'
;
Comment on column Employee_Demo.COUNTY_OF_RES is '01055 - County of Residence, SUS'
;
Comment on column Employee_Demo.RESTRICT_ACC_FLG is '01611 - Restricted Access Indicator'
;
Comment on column Employee_Demo.SR_MGMT_BFT_FLG is '01020 - Senior Management Benefit Switch'
;
Comment on column Employee_Demo.ANP_FLG is '01038 - A and P Indicator'
;
Comment on column Employee_Demo.DROP_ENROLL_DT is '01690 - Date of Enrollment - DROP'
;
Comment on column Employee_Demo.DROP_TERMT_DT is '01691 - Date of Termination - DROP'
;
Comment on column Employee_Demo.EMPR_TYP_CD is '01181 - Employment Resource Type Code, SUS'
;
Comment on column Employee_Demo.CITIZEN is '01619 - Citizenship'
;
Comment on column Employee_Demo.U_RESV_1 is 'Originally a 10-byte field'
;
Comment on column Employee_Demo.HLTH_INS_OPT_LBL is 'Value label for HLTH_INS_OPT_CD'
;
Comment on column Employee_Demo.HLTH_INS_PROVIDER_LBL is 'Value label for HLTH_INS_PROV_CD'
;
Comment on column Employee_Demo.TENURE_STAT_LBL is 'Value label for TENURE_STAT'
;
Comment on column Employee_Demo.LIFE_INS_PART_LBL is 'Value label for LIFE_INS_PART_CD'
;
Comment on column Employee_Demo.RETIRE_LBL is 'Value label for RETIRE_CD_EMP'
;
Comment on column Employee_Demo.RANK_FAC_LBL is 'Value label for RANK_FAC'
;
Comment on column Employee_Demo.DEG_HIGHEST_HELD_LBL is 'Value Label for DEG_HIGHEST_HELD'
;
Comment on column Employee_Demo.OCC_ACT_CAT_LBL is 'Value label for OCC_ACT_CAT_EEO6'
;
Comment on column Employee_Demo.EMPR_TYP_LBL is 'Value label for EMPR_TYP_CD'
;
Comment on column Employee_Demo.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Employee_Demo.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Employee_Data.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Employee_Data.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Employee_Data.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related'
;
Comment on column Employee_Data.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 Employee_Data.SUB_TYP is '01726 - Submission Type'
;
Comment on column Employee_Data.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Employee_Data.ST_FUND_TYP is '01314 - State Fund Type'
;
Comment on column Employee_Data.FUND_ID_EMPL_RES is '01742 - University Fund Identifier - Employment Resourse'
;
Comment on column Employee_Data.BE_CD8 is '01297 - Budget Entity Code'
;
Comment on column Employee_Data.IBI is '01724 - Internal Budget Indicator'
;
Comment on column Employee_Data.APPROP_CAT is '01301 - Appropriation Category'
;
Comment on column Employee_Data.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Employee_Data.UNIV_BUD_ID is '01798 - University Budget Identifier'
;
Comment on column Employee_Data.PAY_PLAN_NBR is '01037 - Pay Plan, SUS'
;
Comment on column Employee_Data.OPS_SEQ is '01797 - Sequence'
;
Comment on column Employee_Data.UNIV_POSITION is '01039 - University Position'
;
Comment on column Employee_Data.COUNTY_OF_EMP is '01016 - County of Employment'
;
Comment on column Employee_Data.CLASS_CD is '01014 - Classification Code'
;
Comment on column Employee_Data.EMPLOYED_CUR_CL_DT is '01018 - Date Employed in Current Classification'
;
Comment on column Employee_Data.COLL_BARG_UNIT_CD is '01041 - Collective Bargaining Unit Code'
;
Comment on column Employee_Data.COLL_BARG_UNIT_ELG is '01049 - Collective Bargaining Unit Eligibility, SUS'
;
Comment on column Employee_Data.ADMIN_CD_PRI is '01409 - Administrative Code - Faculty and other'
;
Comment on column Employee_Data.PAY_GRADE is '01035 - Pay Grade'
;
Comment on column Employee_Data.STEP_NBR is '01281 - Step Number - USPS'
;
Comment on column Employee_Data.CAMPUS_CD is '10060 - Campus Code - Site'
;
Comment on column Employee_Data.APPT_STAT_CLASS is '01696 - Appointment Status - Class'
;
Comment on column Employee_Data.CIP_ACCT_DEPT is '01013 - Account/Department CIP'
;
Comment on column Employee_Data.ST_PRO_COMP_CD is '01639 - State Program Component Code'
;
Comment on column Employee_Data.PROG_COMP is '01315 - Program Component, SUS'
;
Comment on column Employee_Data.PCS_DEPT_ID is '01245 - Account/Department Program (PCS)'
;
Comment on column Employee_Data.SALARY_DOLLARS is '01034 - Salary Dollars'
;
Comment on column Employee_Data.CURR_YR_RATE is '01017 - Current Year Rate, SUS'
;
Comment on column Employee_Data.FTE is '01004 - Full Time Equivalent (FTE) Effort'
;
Comment on column Employee_Data.BUD_WKS_POS is '01236 - Budgeted Weeks of Activity, Employment Resource'
;
Comment on column Employee_Data.PERYRS is '01176 - Person Years'
;
Comment on column Employee_Data.COMMIT_TYP is '01747 - Commitment Type'
;
Comment on column Employee_Data.RATE_TYP is '01625 - Rate Type'
;
Comment on column Employee_Data.UT_WORKED is '01624 - Units Worked'
;
Comment on column Employee_Data.CLASS_TITLE is '01807 - Classification Title'
;
Comment on column Employee_Data.U_RESV_1 is 'Originally a 50-byte field'
;
Comment on column Employee_Data.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Employee_Data.ST_FUND_TYP_GRP is 'Group label for combination STATE_FUND_TYP and FUND_ID_EMPL_RES '
;
Comment on column Employee_Data.BE_CD8_LBL is 'Value label for BE_CD8'
;
Comment on column Employee_Data.IBI_LBL is 'Value label for IBI'
;
Comment on column Employee_Data.ADMIN_CD_PRI_LBL is 'Value label for ADMIN_CD_PRI'
;
Comment on column Employee_Data.APPT_STAT_CLASS_LBL is 'Value label for APPT_STAT_CLASS'
;
Comment on column Employee_Data.PROG_COMP_LBL is 'Value labels for PROG_COMP'
;
Comment on column Employee_Data.PCS_LBL is 'Value label for PCS_DEPT_ID'
;
Comment on column Employee_Data.COMMIT_TYP_LBL is 'Value label for COMMIT_TYP'
;
Comment on column Employee_Data.RATE_TYP_LBL is 'Value label for RATE_TYP'
;
Comment on column Employee_Data.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Employee_Data.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Employee_Vacants.DEMO_TIME_FRAME is 'Academic term (YYYYMM) in which the demographic data is reported. '
;
Comment on column Employee_Vacants.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Employee_Vacants.DEMO_DATA_SOURCE is 'Source of the demographic data to which the current record is related.'
;
Comment on column Employee_Vacants.SUB_TYP is '01726 - Submission Type'
;
Comment on column Employee_Vacants.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Employee_Vacants.ST_FUND_TYP is '01314 - State Fund Type'
;
Comment on column Employee_Vacants.FUND_ID_EMPL_RES is '01742 - University Fund Identifier - Employment Resourse'
;
Comment on column Employee_Vacants.BE_CD8 is '01297 - Budget Entity Code'
;
Comment on column Employee_Vacants.IBI is '01724 - Internal Budget Indicator'
;
Comment on column Employee_Vacants.APPROP_CAT is '01301 - Appropriation Category'
;
Comment on column Employee_Vacants.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Employee_Vacants.UNIV_BUD_ID is '01798 - University Budget Identifier'
;
Comment on column Employee_Vacants.PAY_PLAN_NBR is '01037 - Pay Plan, SUS'
;
Comment on column Employee_Vacants.UNIV_POSITION is '01039 - University Position'
;
Comment on column Employee_Vacants.HLTH_INS_OPT_CD is '01668 - Health Insurance Option Code, State'
;
Comment on column Employee_Vacants.LIFE_INS_PART_CD is '01635 - Life Insurance Participation Code, State'
;
Comment on column Employee_Vacants.RETIRE_CD_EMP is '01047 - Retirement Code, Employment Resource'
;
Comment on column Employee_Vacants.COUNTY_OF_EMP is '01016 - County of Employment'
;
Comment on column Employee_Vacants.CLASS_CD is '01014 - Classification Code'
;
Comment on column Employee_Vacants.ADMIN_CD_PRI is '01409 - Administrative Code - Faculty and other'
;
Comment on column Employee_Vacants.PAY_GRADE is '01035 - Pay Grade'
;
Comment on column Employee_Vacants.CAMPUS_CD is '10060 - Campus Code - Site'
;
Comment on column Employee_Vacants.CIP_ACCT_DEPT is '01013 - Account/Department CIP'
;
Comment on column Employee_Vacants.ST_PRO_COMP_CD is '01639 - State Program Component Code'
;
Comment on column Employee_Vacants.PROG_COMP is '01315 - Program Component, SUS'
;
Comment on column Employee_Vacants.PCS_DEPT_ID is '01245 - Account/Department Program (PCS)'
;
Comment on column Employee_Vacants.SALARY_DOLLARS is '01034 - Salary Dollars'
;
Comment on column Employee_Vacants.CURR_YR_RATE is '01017 - Current Year Rate, SUS'
;
Comment on column Employee_Vacants.FTE is '01004 - Full Time Equivalent (FTE) Effort'
;
Comment on column Employee_Vacants.BUD_WKS_POS is '01236 - Budgeted Weeks of Activity, Employment Resource'
;
Comment on column Employee_Vacants.PERYRS is '01176 - Person Years'
;
Comment on column Employee_Vacants.SR_MGMT_BFT_FLG is '01020 - Senior Management Benefit Switch'
;
Comment on column Employee_Vacants.ANP_FLG is '01038 - A and P Indicator'
;
Comment on column Employee_Vacants.EMPR_TYP_CD is '01181 - Employment Resource Type Code, SUS'
;
Comment on column Employee_Vacants.CLASS_TITLE is '01807 - Classification Title'
;
Comment on column Employee_Vacants.U_RESV_1 is 'Originally a 50-byte field'
;
Comment on column Employee_Vacants.BE_CD_LBL is 'Value Label for BE_CD'
;
Comment on column Employee_Vacants.ST_FUND_TYP_GRP is 'Group label for combination ST_FUND_TYP and FUND_ID_EMPL_RES '
;
Comment on column Employee_Vacants.BE_CD8_LBL is 'Value label for BE_CD8'
;
Comment on column Employee_Vacants.IBI_LBL is 'Value label for IBI'
;
Comment on column Employee_Vacants.HLTH_INS_OPT_LBL is 'Value label for HLTH_INS_OPT_CD'
;
Comment on column Employee_Vacants.LIFE_INS_PART_LBL is 'Value label for LIFE_INS_PART_CD'
;
Comment on column Employee_Vacants.RETIRE_LBL is 'Value label for RETIRE_CD_EMP'
;
Comment on column Employee_Vacants.PROG_COMP_LBL is 'Value labels for PROG_COMP'
;
Comment on column Employee_Vacants.PCS_LBL is 'Value label for PCS_DEPT_ID'
;
Comment on column Employee_Vacants.EMPR_TYP_LBL is 'Value label for EMPR_TYP_CD'
;
Comment on column Employee_Vacants.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Employee_Vacants.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Operating_Budget.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Operating_Budget.FISCAL_YR is '01629 - Year - Fiscal'
;
Comment on column Operating_Budget.BUD_SCHED1 is '01319 - Budget Schedule I Record Type'
;
Comment on column Operating_Budget.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Operating_Budget.UNIV_BUD_ID is '01798 - University Budget Identifier'
;
Comment on column Operating_Budget.BE_CD8 is '01297 - Budget Entity Code'
;
Comment on column Operating_Budget.IBI is '01724 - Internal Budget Indicator'
;
Comment on column Operating_Budget.ST_PRO_COMP_CD is '01639 - State Program Component Code'
;
Comment on column Operating_Budget.PROG_COMP is '01315 - Program Component, SUS'
;
Comment on column Operating_Budget.ST_FUND_TYP is '01314 - State Fund Type'
;
Comment on column Operating_Budget.UNIV_FUND_ID is '01400 - University Fund Identifier'
;
Comment on column Operating_Budget.APPROP_CAT is '01301 - Appropriation Category'
;
Comment on column Operating_Budget.OBJECT_CD is '01302 - Object Code'
;
Comment on column Operating_Budget.PCS_DEPT_ID is '01245 - Account/Department Program (PCS)'
;
Comment on column Operating_Budget.GEN_LEDGER_CD is '01309 - General Ledger Code'
;
Comment on column Operating_Budget.REVENUE_TYP is '01318 - Revenue Type'
;
Comment on column Operating_Budget.BE_CD is '01007 - Budget Entity Code, SUS'
;
Comment on column Operating_Budget.EXPENDITURES is '01307 - Expenditures'
;
Comment on column Operating_Budget.PERYRS is '01176 - Person Years'
;
Comment on column Operating_Budget.CURR_YR_RATE is '01017 - Current Year Rate, SUS'
;
Comment on column Operating_Budget.BUD_YR_ID is '01308 - Budget Year Identifier'
;
Comment on column Operating_Budget.U_RESV_1 is 'Originally a 7-byte field'
;
Comment on column Operating_Budget.BE_CD_LBL is 'Value label for BE_CD'
;
Comment on column Operating_Budget.IBI_LBL is 'Value label for IBI'
;
Comment on column Operating_Budget.SF_FUND_ID_GRP is 'Group label for combined STATE_FUND_TYPE || UNIV_FUND_ID'
;
Comment on column Operating_Budget.APPROP_CAT_LBL is 'Value label for APPROP_CAT'
;
Comment on column Operating_Budget.PCS_LBL is 'Value label for PCS_DEPT_ID'
;
Comment on column Operating_Budget.BUD_YR_ID_LBL is 'Value label for BUD_YR_ID'
;
Comment on column Operating_Budget.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Operating_Budget.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Talented_20.TALENTED_20_YR is '01352 - Talented 20 Year'
;
Comment on column Talented_20.DISTRICT is 'Florida High School District Number (01-67 +)'
;
Comment on column Talented_20.SCHOOL is 'Florida High School Number within District'
;
Comment on column Talented_20.HS_PERSON_ID is 'First 9 digits of High School Person Identification Number'
;
Comment on column Talented_20.HS_PERSON_ID_X is '10th digit of High School Person ID (X if number is an SSN/digit if number is not an SSN)'
;
Comment on column Talented_20.HASH_CD is 'String created using BOG hash technique on person identifiers such as name and birthdate.'
;
Comment on column Talented_20.SYSID is 'Populate this field based on match to Person Demographics'
;
Comment on column Talented_20.ALT_ID is 'Alternate ID - provided by the EDW upon match to existing or creation of new individual.'
;
Comment on column Talented_20.NAME_LAST is '01033 - Person Name - Last'
;
Comment on column Talented_20.SUFFIX is 'Person - Suffix'
;
Comment on column Talented_20.NAME_FIRST is '01091 - Person Name - First'
;
Comment on column Talented_20.NAME_MI is '01092 - Person Name - Middle Initial'
;
Comment on column Talented_20.GENDER is '01048 - Gender'
;
Comment on column Talented_20.RACIAL_ETHNIC_GRP is '01044 - Racial/Ethnic Group'
;
Comment on column Talented_20.BIRTH_DT is '01024 - Birth Date YYYY-MM-DD'
;
Comment on column Talented_20.ADDRESS_STREET is 'Student Address - Street'
;
Comment on column Talented_20.ADDRESS_CITY is 'Student Address - City'
;
Comment on column Talented_20.ADDRESS_STATE is 'Student Address - State'
;
Comment on column Talented_20.ADDRESS_ZIP is 'Student Address - Zip Code'
;
Comment on column Talented_20.HS_ETS_CD is '01069 - High School Code'
;
Comment on column Talented_20.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Talented_20.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column College_Prepaid.PERSON_ID_NBR is '01029 - Person Identification Number'
;
Comment on column College_Prepaid.SYSID is 'Populate this field based on match to Person Demographics'
;
Comment on column College_Prepaid.ALT_ID is 'Alternate ID - provided by the EDW upon match to existing or creation of new individual.'
;
Comment on column College_Prepaid.NAME_LAST is '01033 - Person Name - Last'
;
Comment on column College_Prepaid.NAME_FIRST is '01091 - Person Name - First'
;
Comment on column College_Prepaid.MATRICULATION_YR is 'Year of High School Graduation'
;
Comment on column College_Prepaid.TUITION_PLAN_TYP is '01 = 4-year university plan, 02 = 2-year community college plan, 03 = 2+2 plan, 04 = 4-year community college plan'
;
Comment on column College_Prepaid.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column College_Prepaid.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Military_Participants.EXTRACT_YR is 'The Year this data was extracted.  The affected cohorts are Year-5 and Year-7.  Example:  the 2004 year extraction is applicable to the 1999 6-yr retention reportingand the 1997 8-yr retention reporting'
;
Comment on column Military_Participants.SYSID is 'Populate this field based on match to Person Demographics'
;
Comment on column Military_Participants.ALT_ID is 'Alternate ID - provided by the EDW upon match to existing or creation of new individual.'
;
Comment on column Military_Participants.SERVICE_6 is 'Student was called up for military service within 6 years of cohort year'
;
Comment on column Military_Participants.SERVICE_8 is 'Student was called up for military service within 8 years of cohort year'
;
Comment on column Military_Participants.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Military_Participants.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Audit_Trail.TABLE_NAME is 'Name of the table that was modified'
;
Comment on column Audit_Trail.SEQNO is 'The primary key sequence id of the table row modified'
;
Comment on column Audit_Trail.COLUMN_NAME is 'Name of the column that was modified'
;
Comment on column Audit_Trail.MODIFIED_DTM is 'Timestamp of the modification'
;
Comment on column Audit_Trail.MODIFIED_BY is 'Userid or process that modified the record'
;
Comment on column Audit_Trail.OLD_VALUE is 'The original value found in the column prior to change'
;
Comment on column Audit_Trail.REMARK is 'Explanation of what was changed'
;
Comment on column Approval_Status.APPROVAL_STATUS is 'Primary Key of Approval_Status table auto-populated using sequence number'
;
Comment on column Approval_Status.ACT_DTM is 'Insertion Time Stamp'
;
Comment on column Approval_Status.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Approval_Status.REPT_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.'
;
Comment on column Approval_Status.SUBMISSION is 'Submission Identifier: STU, STUP, ADM, TEF, EA, etc.'
;
Comment on column Approval_Status.TARGET_TABLE is 'Name of the Table to be Loaded'
;
Comment on column Approval_Status.AUDIT_ID is 'User ID or Program ID causing the insert of the current row'
;
Comment on column Approval_Status.STATUS is 'Status of the submission as of this entry (Expected, Submitted, Rejected, Applied, Resub Requested, Resub Denied, Resub Authorized)'
;
Comment on column Approval_Status.DUE_DT is 'Due Date'
;
Comment on column Approval_Status.REQUIRED_FLG is 'Data for the target table is required for this submission (Y/N)'
;
Comment on column Edit_Report_Summary.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Edit_Report_Summary.REPT_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.'
;
Comment on column Edit_Report_Summary.FILE_ID is 'Master File Submitted'
;
Comment on column Edit_Report_Summary.FILE_LOADED_DTM is 'Timestamp of load'
;
Comment on column Edit_Report_Summary.TABLE_NAME is 'Name of the table that was modified'
;
Comment on column Edit_Report_Summary.COLUMN_NAME is 'Name of the column that was modified'
;
Comment on column Edit_Report_Summary.DIAGNOSTIC_MSG_CD is 'Diagnostic Message Code'
;
Comment on column Edit_Report_Summary.EXPLANATION is 'University''s explanation for Level 9 error or other unusual anomolies such as high percentage delta counts'
;
Comment on column Person_Best_IDs.SYSID is 'Randomly assigned unique identifier for an individual'
;
Comment on column Person_Best_IDs.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Person_Best_IDs.DEMO_TIME_FRAME is 'Academic term (YYYYMM) or academic year (YYYYYYYY) to which the reported data applies.'
;
Comment on column Person_Best_IDs.DEMO_DATA_SOURCE is 'Source of the data stored in the current record.'
;
Comment on column Person_Best_IDs.PERSON_ID_BEST_ENC is '01029 - Person Identificaiton Number (encrypted and after applying SSNCHG logic)'
;
Comment on column Person_Best_IDs.PID_BEST_VALID_SSN is 'A code indicating whether or not Person_ID_Best_Enc is a valid SSN (Y=yes, N=No)'
;
Comment on column Person_Best_IDs.BIRTH_DT is '01024 - Date of Birth YYYY-MM-DD'
;
Comment on column Person_Best_IDs.NAME_LAST is '01033 - Person Name - Last'
;
Comment on column Person_Best_IDs.NAME_LAST_SOUNDEX is '01033 - Person Name - Last (Upper cased, no special characters and soundex applied)'
;
Comment on column Person_Best_IDs.NAME_FIRST is '01091 - Person Name - First'
;
Comment on column Person_Best_IDs.NAME_FIRST_SOUNDEX is '01091 - Person Name - First (Upper cased, no special characters, phrase manipulated and soundex applied)'
;
Comment on column Person_Best_IDs.NAME_MI is '01092 - Person Name - Middle Initial'
;
Comment on column Person_Best_IDs.GENDER is '01048 - Gender'
;
Comment on column Person_Best_IDs.RACE_ETHNICITY is '01044 - Racial/Ethnic Group'
;
Comment on column Person_Best_IDs.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Person_Best_IDs.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Expenditure_Analysis_Extract.EA_DATA_SOURCE is 'GENERATED - Source'
;
Comment on column Expenditure_Analysis_Extract.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Expenditure_Analysis_Extract.YR_FISCAL is '01629 - Year - Fiscal'
;
Comment on column Expenditure_Analysis_Extract.BE_CD8 is '01297 - Budget Entity Code'
;
Comment on column Expenditure_Analysis_Extract.COST_ACT is '01303 - Cost Activity'
;
Comment on column Expenditure_Analysis_Extract.COLLEGE is '01507 - College (Subcomponent)'
;
Comment on column Expenditure_Analysis_Extract.DEPT_ID_ACT is '01506 - Account/Department Number, Activity'
;
Comment on column Expenditure_Analysis_Extract.INSTR_RESRCH_ACT is '01509 - Instruction and Research Activities'
;
Comment on column Expenditure_Analysis_Extract.APPROP_CAT is '01301 - Appropriation Category'
;
Comment on column Expenditure_Analysis_Extract.OBJECT_CD is '01302 - Object Code'
;
Comment on column Expenditure_Analysis_Extract.INSTR_FND_SCH is '01516 - Instructor Portion of Fundable SCHs for the Course Section'
;
Comment on column Expenditure_Analysis_Extract.PERYRS is '01176 - Person Years'
;
Comment on column Expenditure_Analysis_Extract.EXPENDITURES is '01307 - Actual/Estimated Expenditures'
;
Comment on column Expenditure_Analysis_Extract.CIP_EXPENDITURE is '01043 - Classification of Instructional Programs (CIP)'
;
Comment on column Expenditure_Analysis_Extract.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Expenditure_Analysis_Extract.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Full_Cost.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Full_Cost.FISCAL_YR is 'Fiscal Year (YYYYYYYY) to which the reported data applies'
;
Comment on column 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 Full_Cost.BE_CD8 is '01297 - Budget Entity Code'
;
Comment on column Full_Cost.COST_ACT is '01303 - Cost Activity'
;
Comment on column Full_Cost.CIP_EXPENDITURE is '01043 - Classification of Instructional Programs (CIP)'
;
Comment on column Full_Cost.PROG_DISCIPLINE is '01520 - Program Discipline'
;
Comment on column Full_Cost.CRED_HRS is 'Subtotal of Fundable Credit Hours for Grouping'
;
Comment on column Full_Cost.EXP_PER_ACTIVITIES is 'FCMAST AMT1'
;
Comment on column Full_Cost.DIRECT_EXP is 'FCMAST AMT2'
;
Comment on column Full_Cost.INDIRECT_EXP is 'FCMAST AMT3'
;
Comment on column Full_Cost.TOT_FULL_EXP is 'FCMAST AMT4'
;
Comment on column Full_Cost.DIRECT_EXP_PER_FSCH is 'FCMAST AMT5'
;
Comment on column Full_Cost.INDIRECT_EXP_PER_FSCH is 'FCMAST AMT6'
;
Comment on column Full_Cost.TOT_EXP_PER_FSCH is 'FCMAST AMT7'
;
Comment on column Full_Cost.COLLEGE_LBL is 'Value Label for COLLEGE'
;
Comment on column Full_Cost.COST_ACT_LBL is 'Value Label for COST_ACT'
;
Comment on column Full_Cost.PROG_DISCIPLINE_LBL is 'Value Label for PROG_DISCIPLINE'
;
Comment on column Full_Cost.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Full_Cost.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Campus.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Campus.CAMPUS_CD is '10060 - Campus Code - Site; Legacy 2-character Campus Code is right-justified, zero-filled'
;
Comment on column Campus.BASE_YR is '01629 - Year - Fiscal (SPA-fmt=YYYY00); 01051 - Term Identifier (IAF-fmt=YYYYMM)'
;
Comment on column Campus.REPT_TIME_FRAME is 'Academic term (YYYYMM) to which the reported data applies'
;
Comment on column Campus.CAMPUS_NAME is 'Campus name'
;
Comment on column Campus.ZIP is '10048 - Zone Identification Postal'
;
Comment on column Campus.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Campus.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column PrePartition.REPT_INST is '01045 - Reporting Institution'
;
Comment on column PrePartition.FISCAL_YR is '01629 - Year - Fiscal'
;
Comment on column PrePartition.BE_CD8 is '01297 - Budget Entity Code'
;
Comment on column PrePartition.COLLEGE_ACT is '01507 - College (Subcomponent)'
;
Comment on column PrePartition.COST_ACT is '01303 - Cost Activity'
;
Comment on column PrePartition.CIP_EXPENDITURE is '01043 - Classification of Instructional Programs (CIP)'
;
Comment on column PrePartition.LOWER_FSCH is 'MTX R01C01'
;
Comment on column PrePartition.UPPER_FSCH is 'MTX R01C02'
;
Comment on column PrePartition.GRAD1_FSCH is 'MTX R01C03'
;
Comment on column PrePartition.GRAD2_FSCH is 'MTX R01C04'
;
Comment on column PrePartition.GRAD3_FSCH is 'MTX R01C05'
;
Comment on column PrePartition.CLIN_FSCH is 'MTX R01C06'
;
Comment on column PrePartition.LOWER_FACPERYRS is 'MTX R02C01'
;
Comment on column PrePartition.UPPER_FACPERYR is 'MTX R02C02'
;
Comment on column PrePartition.GRAD1_FACPERYRS is 'MTX R02C03'
;
Comment on column PrePartition.GRAD2_FACPERYRS is 'MTX R02C04'
;
Comment on column PrePartition.GRAD3_FACPERYRS is 'MTX R02C05'
;
Comment on column PrePartition.CLIN_FACPERYRS is 'MTX R02C06'
;
Comment on column PrePartition.RSRCH_FACPERYRS is 'MTX R02C07'
;
Comment on column PrePartition.PUBSVC_FACPERYRS is 'MTX R02C08'
;
Comment on column PrePartition.ACDADV_FACPERYRS is 'MTX R02C09'
;
Comment on column PrePartition.ADMIN_FACPERYRS is 'MTX R02C10'
;
Comment on column PrePartition.TBPALL_FACPERYR is 'MTX R02C11'
;
Comment on column PrePartition.TBPINSTR_FACPERYR is 'MTX R02C12'
;
Comment on column PrePartition.LOWER_FACSALBEN is 'MTX R03C01'
;
Comment on column PrePartition.UPPER_FACSALBEN is 'MTX R03C02'
;
Comment on column PrePartition.GRAD1_FACSALBEN is 'MTX R03C03'
;
Comment on column PrePartition.GRAD2_FACSALBEN is 'MTX R03C04'
;
Comment on column PrePartition.GRAD3_FACSALBEN is 'MTX R03C05'
;
Comment on column PrePartition.CLIN_FACSALBEN is 'MTX R03C06'
;
Comment on column PrePartition.RSRCH_FACSALBEN is 'MTX R03C07'
;
Comment on column PrePartition.PUBSVC_FACSALBEN is 'MTX R03C08'
;
Comment on column PrePartition.ACDADV_FACSALBEN is 'MTX R03C09'
;
Comment on column PrePartition.ADMIN_FACSALBEN is 'MTX R03C10'
;
Comment on column PrePartition.TBPALL_FACSALBEN is 'MTX R03C11'
;
Comment on column PrePartition.TBPINSTR_FACSALBEN is 'MTX R03C12'
;
Comment on column PrePartition.LOWER_SSPERYRS is 'MTX R04C01'
;
Comment on column PrePartition.UPPER_SSPERYR is 'MTX R04C02'
;
Comment on column PrePartition.GRAD1_SSPERYRS is 'MTX R04C03'
;
Comment on column PrePartition.GRAD2_SSPERYRS is 'MTX R04C04'
;
Comment on column PrePartition.GRAD3_SSPERYRS is 'MTX R04C05'
;
Comment on column PrePartition.CLIN_SSPERYRS is 'MTX R04C06'
;
Comment on column PrePartition.RSRCH_SSPERYRS is 'MTX R04C07'
;
Comment on column PrePartition.PUBSVC_SSPERYRS is 'MTX R04C08'
;
Comment on column PrePartition.ACDADV_SSPERYRS is 'MTX R04C09'
;
Comment on column PrePartition.ADMIN_SSPERYRS is 'MTX R04C10'
;
Comment on column PrePartition.TBPALL_SSPERYR is 'MTX R04C11'
;
Comment on column PrePartition.LOWER_SSSALBEN is 'MTX R05C01'
;
Comment on column PrePartition.TBPINSTR_SSPERYR is 'MTX R04C12'
;
Comment on column PrePartition.UPPER_SSSALBEN is 'MTX R05C02'
;
Comment on column PrePartition.GRAD1_SSSALBEN is 'MTX R05C03'
;
Comment on column PrePartition.GRAD2_SSSALBEN is 'MTX R05C04'
;
Comment on column PrePartition.GRAD3_SSSALBEN is 'MTX R05C05'
;
Comment on column PrePartition.CLIN_SSSALBEN is 'MTX R05C06'
;
Comment on column PrePartition.RSRCH_SSSALBEN is 'MTX R05C07'
;
Comment on column PrePartition.PUBSVC_SSSALBEN is 'MTX R05C08'
;
Comment on column PrePartition.ACDADV_SSSALBEN is 'MTX R05C09'
;
Comment on column PrePartition.ADMIN_SSSALBEN is 'MTX R05C10'
;
Comment on column PrePartition.TBPALL_SSSALBEN is 'MTX R05C11'
;
Comment on column PrePartition.TBPINSTR_SSSALBEN is 'MTX R05C12'
;
Comment on column PrePartition.TBPALL_RESPERYR is 'MTX R06C11'
;
Comment on column PrePartition.TBPINSTR_RESPERYR is 'MTX R06C12'
;
Comment on column PrePartition.ADMIN_RESSALBEN is 'MTX R06C10'
;
Comment on column PrePartition.TBPALL_RESSALBEN is 'MTX R06C11'
;
Comment on column PrePartition.TBPINSTR_RESSALBEN is 'MTX R06C12'
;
Comment on column PrePartition.LOWER_FADJPERYRS is 'MTX R10C01'
;
Comment on column PrePartition.UPPER_FADJPERYR is 'MTX R10C02'
;
Comment on column PrePartition.GRAD1_FADJPERYRS is 'MTX R10C03'
;
Comment on column PrePartition.GRAD2_FADJPERYRS is 'MTX R10C04'
;
Comment on column PrePartition.GRAD3_FADJPERYRS is 'MTX R10C05'
;
Comment on column PrePartition.CLIN_FADJPERYRS is 'MTX R10C06'
;
Comment on column PrePartition.RSRCH_FADJPERYRS is 'MTX R10C07'
;
Comment on column PrePartition.PUBSVC_FADJPERYRS is 'MTX R10C08'
;
Comment on column PrePartition.ACDADV_FADJPERYRS is 'MTX R10C09'
;
Comment on column PrePartition.ADMIN_FADJPERYRS is 'MTX R10C10'
;
Comment on column PrePartition.TBPINSTR_FADJPERYR is 'MTX R10C12'
;
Comment on column PrePartition.LOWER_FADJSALBEN is 'MTX R11C01'
;
Comment on column PrePartition.UPPER_FADJSALBEN is 'MTX R11C02'
;
Comment on column PrePartition.GRAD1_FADJSALBEN is 'MTX R11C03'
;
Comment on column PrePartition.GRAD2_FADJSALBEN is 'MTX R11C04'
;
Comment on column PrePartition.GRAD3_FADJSALBEN is 'MTX R11C05'
;
Comment on column PrePartition.CLIN_FADJSALBEN is 'MTX R11C06'
;
Comment on column PrePartition.RSRCH_FADJSALBEN is 'MTX R11C07'
;
Comment on column PrePartition.PUBSVC_FADJSALBEN is 'MTX R11C08'
;
Comment on column PrePartition.ACDADV_FADJSALBEN is 'MTX R11C09'
;
Comment on column PrePartition.ADMIN_FADJSALBEN is 'MTX R11C10'
;
Comment on column PrePartition.TBPINSTR_FADJSALBEN is 'MTX R11C12'
;
Comment on column PrePartition.LOWER_GAPERYRS is 'MTX R12C01'
;
Comment on column PrePartition.UPPER_GAPERYR is 'MTX R12C02'
;
Comment on column PrePartition.GRAD1_GAPERYRS is 'MTX R12C03'
;
Comment on column PrePartition.GRAD2_GAPERYRS is 'MTX R12C04'
;
Comment on column PrePartition.GRAD3_GAPERYRS is 'MTX R12C05'
;
Comment on column PrePartition.CLIN_GAPERYRS is 'MTX R12C06'
;
Comment on column PrePartition.RSRCH_GAPERYRS is 'MTX C12R07'
;
Comment on column PrePartition.PUBSVC_GAPERYRS is 'MTX R12C08'
;
Comment on column PrePartition.ACDADV_GAPERYRS is 'MTX R12C09'
;
Comment on column PrePartition.ADMIN_GAPERYRS is 'MTX R12C10'
;
Comment on column PrePartition.TBPALL_GAPERYR is 'MTX R12C11'
;
Comment on column PrePartition.TBPINSTR_GAPERYR is 'MTX R12C12'
;
Comment on column PrePartition.LOWER_GASALBEN is 'MTX R13C01'
;
Comment on column PrePartition.UPPER_GASALBEN is 'MTX R13C02'
;
Comment on column PrePartition.GRAD1_GASALBEN is 'MTX R13C03'
;
Comment on column PrePartition.GRAD2_GASALBEN is 'MTX R13C04'
;
Comment on column PrePartition.GRAD3_GASALBEN is 'MTX R13C05'
;
Comment on column PrePartition.CLIN_GASALBEN is 'MTX R13C06'
;
Comment on column PrePartition.RSRCH_GASALBEN is 'MTX R13C07'
;
Comment on column PrePartition.PUBSVC_GASALBEN is 'MTX R13C08'
;
Comment on column PrePartition.ACDADV_GASALBEN is 'MTX R13C09'
;
Comment on column PrePartition.ADMIN_GASALBEN is 'MTX R13C10'
;
Comment on column PrePartition.TBPALL_GASALBEN is 'MTX R13C11'
;
Comment on column PrePartition.TBPINSTR_GASALBEN is 'MTX R13C12'
;
Comment on column PrePartition.LOWER_OOPSPERYRS is 'MTX R14C01'
;
Comment on column PrePartition.UPPER_OOPSPERYR is 'MTX R14C02'
;
Comment on column PrePartition.GRAD1_OOPSPERYRS is 'MTX R14C03'
;
Comment on column PrePartition.GRAD2_OOPSPERYRS is 'MTX R14C04'
;
Comment on column PrePartition.GRAD3_OOPSPERYRS is 'MTX R14C05'
;
Comment on column PrePartition.CLIN_OOPSPERYRS is 'MTX R14C06'
;
Comment on column PrePartition.RSRCH_OOPSPERYRS is 'MTX R14C07'
;
Comment on column PrePartition.PUBSVC_OOPSPERYRS is 'MTX R14C08'
;
Comment on column PrePartition.ACDADV_OOPSPERYRS is 'MTX R14C09'
;
Comment on column PrePartition.ADMIN_OOPSPERYRS is 'MTX R14C10'
;
Comment on column PrePartition.TBPALL_OOPSPERYR is 'MTX R14C11'
;
Comment on column PrePartition.TBPINSTR_OOPSPERYR is 'MTX R14C12'
;
Comment on column PrePartition.LOWER_OOPSDOLLAR is 'MTX R15C01'
;
Comment on column PrePartition.UPPER_OOPSDOLLAR is 'MTX R15C02'
;
Comment on column PrePartition.GRAD1_OOPSDOLLAR is 'MTX R15C03'
;
Comment on column PrePartition.GRAD2_OOPSDOLLAR is 'MTX R15C04'
;
Comment on column PrePartition.GRAD3_OOPSDOLLAR is 'MTX R15C05'
;
Comment on column PrePartition.CLIN_OOPSDOLLAR is 'MTX R15C06'
;
Comment on column PrePartition.RSRCH_OOPSDOLLAR is 'MTX R15C07'
;
Comment on column PrePartition.PUBSVC_OOPSDOLLAR is 'MTX R15C08'
;
Comment on column PrePartition.ACDADV_OOPSDOLLAR is 'MTX R15C09'
;
Comment on column PrePartition.ADMIN_OOPSDOLLAR is 'MTX R15C10'
;
Comment on column PrePartition.TBPALL_OOPSDOLLAR is 'MTX R15C11'
;
Comment on column PrePartition.TBPINSTR_OOPSDOLLAR is 'MTX R15C12'
;
Comment on column PrePartition.ADMIN_ROPSDOLLAR is 'MTX R18C10'
;
Comment on column PrePartition.TBPALL_ROPSDOLLAR is 'MTX R18C11'
;
Comment on column PrePartition.ADMIN_OTHEXPENSE is 'MTX R21C10'
;
Comment on column PrePartition.TBPALL_OTHEXPENSE is 'MTX R21C11'
;
Comment on column PrePartition.ADMIN_UTILEXPENSE is 'MTX R22C10'
;
Comment on column PrePartition.TBPALL_UTILEXPENSE is 'MTX R22C11'
;
Comment on column PrePartition.ADMIN_OCOEXPENSE is 'MTX R23C10'
;
Comment on column PrePartition.TBPALL_OCOEXPENSE is 'MTX R23C11'
;
Comment on column PrePartition.ADMIN_BOOKOCO is 'MTX R24C10'
;
Comment on column PrePartition.TBPALL_BOOKOCO is 'MTX R24C11'
;
Comment on column PrePartition.ADMIN_EDPEXPENSE is 'MTX R25C10'
;
Comment on column PrePartition.TBPALL_EDPEXPENSE is 'MTX R25C11'
;
Comment on column PrePartition.ADMIN_SPECCAT is 'MTX R26C10'
;
Comment on column PrePartition.TBPALL_SPECCAT is 'MTX R26C11'
;
Comment on column PrePartition.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column PrePartition.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Univ_Dept_Master.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Univ_Dept_Master.REPT_TIME_FRAME is 'Years (YYYYYYYY) to which the reported data applies. '
;
Comment on column Univ_Dept_Master.DEPT_ID is '01796 - Department Identifier'
;
Comment on column Univ_Dept_Master.UNIV_BUD_ID is '01798 - University Budget Identifier'
;
Comment on column Univ_Dept_Master.DEPT_ID_TITLE is 'Title for the University Department Identifier + University Budget Identifier'
;
Comment on column Univ_Dept_Master.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Univ_Dept_Master.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Person_ID_Chgs.REPT_TIME_FRAME is 'YYYYMM when person id was submitted'
;
Comment on column Person_ID_Chgs.REPT_INST is '01045 - Reporting Institution'
;
Comment on column Person_ID_Chgs.PERSON_ID_NEW is '01029 - Person Identification Number (new)'
;
Comment on column Person_ID_Chgs.PERSON_ID_PRV is '01427 - Person Identificaiton Number Previous'
;
Comment on column Person_ID_Chgs.BIRTH_DT is '01024 - Date of Birth YYYY-MM-DD'
;
Comment on column Person_ID_Chgs.NAME_LAST is '01033 - Person Name - Last'
;
Comment on column Person_ID_Chgs.NAME_FIRST is '01091 - Person Name - First'
;
Comment on column Person_ID_Chgs.NAME_MI is '01092 - Person Name - Middle Initial'
;
Comment on column Person_ID_Chgs.SUFFIX is 'New field.  Ex: JR, SR, III, MD, FAC, CRNA'
;
Comment on column Person_ID_Chgs.GENDER is '01048 - Gender'
;
Comment on column Person_ID_Chgs.RACE_ETHNICITY is '01044 - Racial/Ethnic Group'
;
Comment on column Person_ID_Chgs.HISPANIC_FLG is '01491 - Ethnicity (Hispanic or Latino)'
;
Comment on column Person_ID_Chgs.AM_IND_ALASKAN_FLG is '01492 - American Indian or Alaskan Native'
;
Comment on column Person_ID_Chgs.ASIAN_FLG is '01493 - Asian'
;
Comment on column Person_ID_Chgs.BLACK_AFRICAN_AM_FLG is '01494 - Black or African American'
;
Comment on column Person_ID_Chgs.NAT_HAWAII_PAC_IS_FLG is '01495 - Native Hawaiian or Other Pacific Islander'
;
Comment on column Person_ID_Chgs.WHITE_FLG is '01496 - White'
;
Comment on column Person_ID_Chgs.NON_RES_ALIEN_FLG is 'New field'
;
Comment on column Person_ID_Chgs.NO_RACE_REPORT_FLG is '01497 - No Race Reported'
;
Comment on column Person_ID_Chgs.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Person_ID_Chgs.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Submission_Template.SUBMISSION is 'Submission Identifier: STU, STUP, ADM, TEF, EA, etc.'
;
Comment on column Submission_Template.TARGET_TABLE is 'Name of the Table to be Loaded'
;
Comment on column Submission_Template.REQUIRED_FLG is 'Data for the target table is required for this submission (Y/N)'
;
Comment on column Submission_Template.DEFAULT_DUE_DT is 'Default Due Date (over-ride provided at time of build into Approval Status table)'
;
Comment on column Submission_Template.LAST_CHANGE_BY is 'USER_ID that created or last changed the row'
;
Comment on column Submission_Template.LAST_CHANGE_DT is 'Date row was last changed'
;
Comment on column Submitted_Data.APPROVAL_STATUS is 'Primary Key of Approval_Status table auto-populated using sequence number'
;
Comment on column Submitted_Data.FILE_CONTENTS is 'File Contents - should be variable length, pipe-delimited data.'
;