Schema UIUCSTUDENT in Database MDTPROD

9.2.0.4

As Of 8/23/2005 9:44:07 AM

 

--------------------- Jump to ---------------------

Tables ---- Views

Tables

Top
Table Name # of Cols # of Indexes Size Tablespace
DUMMY_TABLE 1 0   UIUCSTUDENT
ENCUMBRANCE_TYPE 12 1   UIUCSTUDENT
MARCIA_USERS 2 0   UIUCSTUDENT
PERSON_ID_CARD 16 2   UIUCSTUDENT
PSSN 10 3   UIUCSTUDENT
STUDENT_ADVISING_H 16 2   UIUCSTUDENT
STUDENT_CAD 9 2   UIUCSTUDENT
STUDENT_CAD_DETAIL 12 2   UIUCSTUDENT
STUDENT_COURSE_XM 13 2   UIUCSTUDENT
STUDENT_CURRICULUM 19 2   UIUCSTUDENT
STUDENT_DARS_CODES 17 2   UIUCSTUDENT
STUDENT_DISTINCTIO 15 4   UIUCSTUDENT
STUDENT_ENCUMBRANC 20 3   UIUCSTUDENT
STUDENT_GDOL 22 2   UIUCSTUDENT
STUDENT_GRAD_DATA 8 2   UIUCSTUDENT
STUDENT_GRAD_EXAM 16 2   UIUCSTUDENT
STUDENT_PRO_DROP 21 2   UIUCSTUDENT
STUDENT_SPECIAL_GR 13 3   UIUCSTUDENT
STUDENT_TUITION 21 2   UIUCSTUDENT
STU_ADM 57 2   UIUCSTUDENT
STU_ADM_TST 14 3   UIUCSTUDENT
STU_AWD_DEG 38 3   UIUCSTUDENT
STU_CRS 52 5   UIUCSTUDENT
STU_CRS_SEC 18 1   UIUCSTUDENT
STU_CUR_ADDR 18 3   UIUCSTUDENT
STU_DEMO 83 8   UIUCSTUDENT
STU_EXT_DEG 19 2   UIUCSTUDENT
STU_GAS 18 3   UIUCSTUDENT
STU_GRAD_DATA 8 1   UIUCSTUDENT
STU_HS_ENRL 24 3   UIUCSTUDENT
STU_HS_INST 42 1   UIUCSTUDENT
STU_HS_SUBJ 10 2   UIUCSTUDENT
STU_MIDSEMESTER 11 1   UIUCSTUDENT
STU_PND_DEG 35 4   UIUCSTUDENT
STU_TBC 14 3   UIUCSTUDENT
STU_TERM 94 7   UIUCSTUDENT
STU_TERM_HOLD 4 1   UIUCSTUDENT
STU_TFER_CRS 21 2   UIUCSTUDENT
STU_TFER_INST 20 1   UIUCSTUDENT
TABLE_NAME 6 1   UIUCSTUDENT
TABLE_PRIVS 3 0   UIUCSTUDENT
TABLE_RSLT 9 1   UIUCSTUDENT
TABLE_VALUE 7 1   UIUCSTUDENT
TERM 23 1   UIUCSTUDENT
UIUCWRLOG 16 0   UIUCSTUDENT
VIEW_PRIVS 3 0   UIUCSTUDENT

 

Views

Top
View Name Status # of Columns Text Length # of Dependencies
PREVIOUS_SSN VALID 6 117 1
STU_DEMO_DIST VALID 67 1959 2
STU_DEMO_ENCUMB VALID 73 2136 2
STU_TERM_DIST VALID 87 2444 2
VACE_STU_CAD VALID 6 699 2
VACE_STU_CAD_DTL VALID 10 962 3
VACE_STU_CRS VALID 43 2052 3
VACE_STU_DEMO VALID 63 3092 1
VACE_STU_GDOL VALID 16 1080 2
VACE_STU_GRAD_DATA VALID 5 691 2
VACE_STU_TERM VALID 83 3758 2
VALUM_ASSOC_REG_SENIOR_TERM VALID 4 425 2
VALUM_ASSOC_STU_AWD_DEG VALID 13 592 2
VALUM_ASSOC_STU_CUR_ADDR VALID 12 455 2
VALUM_ASSOC_STU_DEMO VALID 13 486 1
VALUM_ASSOC_STU_PND_DEG VALID 15 709 2
VDEFN_ENC VALID 10 525 1
VDEFN_HS_INST VALID 37 1756 1
VDEFN_TERM VALID 16 625 1
VDEFN_TFER_INST VALID 16 804 1
VPERS_ID_CARD VALID 12 605 1
VPHYCS_ENG_UGRAD_PERS_ID_CARD VALID 12 573 2
VPHYCS_ENG_UGRAD_STU_CRS VALID 43 1665 3
VPHYCS_ENG_UGRAD_STU_CRS_SECT VALID 14 721 4
VPHYCS_ENG_UGRAD_STU_CUR_ADDR VALID 15 592 2
VPHYCS_ENG_UGRAD_STU_DEMO VALID 63 2681 1
VPHYCS_ENG_UGRAD_STU_MIDSEM VALID 7 524 4
VPHYCS_ENG_UGRAD_STU_TERM VALID 83 3271 2
VPHYCS_GRAD_PERS_ID_CARD VALID 12 573 2
VPHYCS_GRAD_STU_CRS VALID 43 1665 3
VPHYCS_GRAD_STU_CRS_SECT VALID 14 722 4
VPHYCS_GRAD_STU_CUR_ADDR VALID 15 590 2
VPHYCS_GRAD_STU_DEMO VALID 63 2681 1
VPHYCS_GRAD_STU_GDOL VALID 16 709 2
VPHYCS_GRAD_STU_TERM VALID 83 3271 2
VPHYCS_LAS_UGRAD_PERS_ID_CARD VALID 12 731 2
VPHYCS_LAS_UGRAD_STU_CRS VALID 43 1803 3
VPHYCS_LAS_UGRAD_STU_CRS_SECT VALID 14 860 4
VPHYCS_LAS_UGRAD_STU_CUR_ADDR VALID 15 737 2
VPHYCS_LAS_UGRAD_STU_DEMO VALID 63 2820 1
VPHYCS_LAS_UGRAD_STU_MIDSEM VALID 7 666 4
VPHYCS_LAS_UGRAD_STU_TERM VALID 83 3416 2
VSTU_ADM VALID 52 2094 1
VSTU_ADM_TEST VALID 11 486 1
VSTU_ADVS_HOLD VALID 12 665 1
VSTU_AWD_DEG VALID 34 1681 1
VSTU_CAD VALID 6 263 1
VSTU_CAD_DTL VALID 10 557 1
VSTU_CRS VALID 43 1721 1
VSTU_CRS_SECT VALID 14 597 1
VSTU_CRS_XM VALID 43 764 1
VSTU_CURR VALID 15 760 1
VSTU_CUR_ADDR VALID 15 627 1
VSTU_DARS_CD VALID 15 847 1
VSTU_DEMO VALID 63 2630 1
VSTU_DIST VALID 11 567 1
VSTU_ENC VALID 15 750 1
VSTU_EXTRNL_DEG VALID 15 739 1
VSTU_GAS VALID 15 634 1
VSTU_GDOL VALID 16 757 1
VSTU_GRAD_DATA VALID 5 286 1
VSTU_GRAD_EXAM VALID 11 596 1
VSTU_HS_ENRL VALID 19 818 1
VSTU_HS_SUBJ VALID 8 351 1
VSTU_MIDSEM VALID 7 361 1
VSTU_PND_DEG VALID 30 1415 1
VSTU_PREV_SSN VALID 6 235 1
VSTU_PRODROP VALID 15 720 1
VSTU_SPCL_GRP VALID 9 494 1
VSTU_TBC VALID 12 476 1
VSTU_TERM VALID 83 3722 1
VSTU_TERM_XM VALID 83 1622 1
VSTU_TFER_CRS VALID 19 895 1
VSTU_TFER_CRS_OLD VALID 19 895 1
VSTU_TUIT VALID 15 728 1
VSTU_XM_CRS VALID 10 524 1
VTBL_NAME VALID 4 195 1
VTBL_RSLT VALID 7 316 1
VTBL_VAL VALID 5 242 1
V_ENCUMBRANCE_TYPE VALID 10 245 1
V_PERSON_ID_CARD VALID 12 256 1
V_PSSN VALID 7 159 1
V_STUDENT_ADVISING_H VALID 12 245 1
V_STUDENT_CAD VALID 6 138 1
V_STUDENT_COURSE_XM VALID 10 234 1
V_STUDENT_CURRICULUM VALID 15 309 1
V_STUDENT_DARS_CODES VALID 15 340 1
V_STUDENT_ENCUMBRANC VALID 15 307 1
V_STUDENT_GDOL VALID 16 360 1
V_STUDENT_GRAD_DATA VALID 5 143 1
V_STUDENT_GRAD_EXAM VALID 11 249 1
V_STUDENT_PRO_DROP VALID 15 287 1
V_STUDENT_SPECIAL_GR VALID 9 220 1
V_STUDENT_TUITION VALID 15 325 1
V_STU_ADM VALID 52 968 1
V_STU_ADM_TST VALID 11 223 1
V_STU_AWD_DEG VALID 34 709 1
V_STU_CRS VALID 43 830 1
V_STU_CRS_SEC VALID 14 272 1
V_STU_CUR_ADDR VALID 15 266 1
V_STU_DEMO VALID 63 1329 1
V_STU_EXT_DEG VALID 15 324 1
V_STU_GAS VALID 15 312 1
V_STU_GRAD_DATA VALID 5 139 1
V_STU_HS_ENRL VALID 19 368 1
V_STU_HS_INST VALID 37 674 1
V_STU_HS_SUBJ VALID 8 173 1
V_STU_MIDSEMESTER VALID 7 167 1
V_STU_PND_DEG VALID 30 617 1
V_STU_TBC VALID 12 244 1
V_STU_TERM VALID 83 1693 1
V_STU_TFER_CRS VALID 19 361 1
V_STU_TFER_INST VALID 16 308 1
V_TABLE_NAME VALID 4 109 1
V_TABLE_RSLT VALID 7 164 1
V_TABLE_VALUE VALID 5 131 1
V_TERM VALID 16 318 1

 

Tables

Top

 

 

Tables

---------- Table DUMMY_TABLE ----------

Col # Column Name Data Type Not Null? Comments
1 DUMMY_ONE VARCHAR2(80 BYTE) Y  

 

 

Tables

---------- Table ENCUMBRANCE_TYPE ----------

Col # Column Name Data Type Not Null? Comments
1 ENCUMBRANC_TYPE_ID VARCHAR2(16 BYTE) Y  
2 CONTACT_TEXT_1 VARCHAR2(25 BYTE)    
3 CONTACT_TEXT_2 VARCHAR2(40 BYTE)    
4 CONTACT_TEXT_3 VARCHAR2(40 BYTE)    
5 CONTACT_TEXT_4 VARCHAR2(40 BYTE)    
6 ENCUMBRANCE_CODE VARCHAR2(8 BYTE)    
7 ENCUMBRANCE_NAME VARCHAR2(30 BYTE)    
8 ENCUMBRANCE_TYPE VARCHAR2(10 BYTE)    
9 EXTRACT_TIME TIMESTAMP(6)    
10 RUN_TIME TIMESTAMP(6)    
11 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
12 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table MARCIA_USERS ----------

Col # Column Name Data Type Not Null? Comments
1 UIUCSTUDENT_USER VARCHAR2(30 BYTE) Y  
2 FULLNAME VARCHAR2(30 BYTE)    

 

 

Tables

---------- Table PERSON_ID_CARD ----------

Col # Column Name Data Type Not Null? Comments
1 PERSON_ID_CARD_ID VARCHAR2(16 BYTE) Y  
2 CREATE_DATE TIMESTAMP(6)    
3 CREATE_TIME VARCHAR2(8 BYTE)    
4 CREATED_BY VARCHAR2(8 BYTE)    
5 EXTRACT_TIME TIMESTAMP(6)    
6 I_CARD_NUMBER VARCHAR2(9 BYTE)    
7 PERSON_ID VARCHAR2(16 BYTE)    
8 PREVIOUS_IND VARCHAR2(1 BYTE)    
9 RUN_TIME TIMESTAMP(6)    
10 UDPATE_TIME VARCHAR2(8 BYTE)    
11 UPDATE_DATE TIMESTAMP(6)    
12 UPDATED_BY VARCHAR2(8 BYTE)    
13 CREATE_DATE_STR VARCHAR2(26 BYTE)    
14 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
15 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
16 UPDATE_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table PSSN ----------

Col # Column Name Data Type Not Null? Comments
1 PREVIOUS_SSN_ID VARCHAR2(16 BYTE) Y  
2 EFFECTIVE_DATE TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 IDENTIFIER VARCHAR2(16 BYTE) Y  
5 PREVIOUS_SSN VARCHAR2(9 BYTE) Y  
6 RUN_TIME TIMESTAMP(6)    
7 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
8 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE) Y  
9 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
10 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_ADVISING_H ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ADVISING_H_ID VARCHAR2(16 BYTE) Y  
2 CAMPUS VARCHAR2(1 BYTE)    
3 CLEARED_BY VARCHAR2(8 BYTE)    
4 COLLEGE VARCHAR2(2 BYTE)    
5 CURRICULUM VARCHAR2(4 BYTE)    
6 DATE_ESTABLISHED TIMESTAMP(6)    
7 END_DATE TIMESTAMP(6)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 RUN_TIME TIMESTAMP(6)    
10 SET_BY VARCHAR2(8 BYTE)    
11 STU_DEMO_ID VARCHAR2(16 BYTE)    
12 TYPE_CODE VARCHAR2(1 BYTE)    
13 DATE_ESTABLISHED_STR VARCHAR2(26 BYTE)    
14 END_DATE_STR VARCHAR2(26 BYTE)    
15 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
16 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_CAD ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CAD_ID VARCHAR2(16 BYTE) Y  
2 CAD_TYPE VARCHAR2(2 BYTE)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 MODIFY_DATE TIMESTAMP(6)    
5 RUN_TIME TIMESTAMP(6)    
6 STU_DEMO_ID VARCHAR2(16 BYTE)    
7 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
8 MODIFY_DATE_STR VARCHAR2(26 BYTE)    
9 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_CAD_DETAIL ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CAD_DETAIL_ID VARCHAR2(16 BYTE) Y  
2 CREDIT_TYPE VARCHAR2(1 BYTE)    
3 DETAIL_TYPE VARCHAR2(2 BYTE)    
4 EARNED_CREDIT NUMBER(9,5)    
5 EXTRACT_TIME TIMESTAMP(6)    
6 GRADED_CREDIT NUMBER(9,5)    
7 GRADED_POINTS NUMBER(9,5)    
8 NOMINAL_CREDIT NUMBER(9,5)    
9 RUN_TIME TIMESTAMP(6)    
10 STU_CAD_ID VARCHAR2(16 BYTE)    
11 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
12 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_COURSE_XM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_COURSE_XM_ID VARCHAR2(16 BYTE) Y  
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 STU_CRS_ID VARCHAR2(16 BYTE)    
5 XM_ENR_STATUS VARCHAR2(1 BYTE)    
6 XM_FEE_AMOUNT NUMBER(7,2)    
7 XM_FEE_REFUND_DATE TIMESTAMP(6)    
8 XM_LOCATION VARCHAR2(20 BYTE)    
9 XM_PAID_CODE VARCHAR2(1 BYTE)    
10 XM_PROJECT_NUMBER VARCHAR2(5 BYTE)    
11 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
12 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
13 XM_FEE_REFUND_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STUDENT_CURRICULUM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CURRICULUM_ID VARCHAR2(16 BYTE) Y  
2 ACTIVE_IND VARCHAR2(1 BYTE)    
3 CAMPUS VARCHAR2(1 BYTE)    
4 COLLEGE VARCHAR2(2 BYTE)    
5 CURRICULUM VARCHAR2(4 BYTE)    
6 END_DATE TIMESTAMP(6)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 JOINT_PROGRAM VARCHAR2(2 BYTE)    
9 RUN_TIME TIMESTAMP(6)    
10 SEQUENCE_NUMBER NUMBER(5)    
11 START_DATE TIMESTAMP(6)    
12 STU_CURRICULUM_TYP VARCHAR2(10 BYTE)    
13 STU_TERM_ID VARCHAR2(16 BYTE)    
14 SUBSPECIALTY VARCHAR2(2 BYTE)    
15 YEAR_TERM VARCHAR2(4 BYTE)    
16 END_DATE_STR VARCHAR2(26 BYTE)    
17 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
18 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
19 START_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STUDENT_DARS_CODES ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DARS_CODES_ID VARCHAR2(16 BYTE) Y  
2 ADVISOR_SSN_1 VARCHAR2(9 BYTE)    
3 ADVISOR_SSN_2 VARCHAR2(9 BYTE)    
4 ANCILLARY_CSWK_1 VARCHAR2(4 BYTE)    
5 ANCILLARY_CSWK_2 VARCHAR2(4 BYTE)    
6 CATALOG_YEAR_1 VARCHAR2(4 BYTE)    
7 CATALOG_YEAR_2 VARCHAR2(4 BYTE)    
8 DARS_OPTION_1 VARCHAR2(2 BYTE)    
9 DARS_PGM_ID_2 VARCHAR2(8 BYTE)    
10 EXTRACT_TIME TIMESTAMP(6)    
11 PREPROF_INTEREST_1 VARCHAR2(3 BYTE)    
12 PREPROF_INTEREST_2 VARCHAR2(3 BYTE)    
13 RUN_TIME TIMESTAMP(6)    
14 STU_TERM_ID VARCHAR2(16 BYTE)    
15 YEAR_TERM VARCHAR2(4 BYTE)    
16 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
17 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_DISTINCTIO ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DISTINCTIO_ID VARCHAR2(16 BYTE) Y  
2 DIST_VALUE VARCHAR2(15 BYTE)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 START_DATE TIMESTAMP(6)    
6 STOP_DATE TIMESTAMP(6)    
7 STU_DEMO_ID VARCHAR2(16 BYTE)    
8 STU_TERM_ID VARCHAR2(16 BYTE)    
9 TRANSCRIPT_PRINT VARCHAR2(1 BYTE)    
10 TYPE_CODE VARCHAR2(15 BYTE)    
11 YEAR_TERM VARCHAR2(4 BYTE)    
12 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
13 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
14 START_DATE_STR VARCHAR2(26 BYTE)    
15 STOP_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STUDENT_ENCUMBRANC ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ENCUMBRANC_ID VARCHAR2(16 BYTE) Y  
2 AMOUNT NUMBER(7,2)    
3 CAMPUS VARCHAR2(1 BYTE)    
4 CLEARED_BY VARCHAR2(8 BYTE)    
5 CLEARED_DATE TIMESTAMP(6)    
6 COLLEGE VARCHAR2(2 BYTE)    
7 DATE_ENTERED TIMESTAMP(6)    
8 DEPARTMENT VARCHAR2(4 BYTE)    
9 DESCRIPTION VARCHAR2(70 BYTE)    
10 EFFECTIVE_DATE TIMESTAMP(6)    
11 ENCUMBRANC_TYPE_ID VARCHAR2(16 BYTE)    
12 EXTRACT_TIME TIMESTAMP(6)    
13 RUN_TIME TIMESTAMP(6)    
14 SET_BY VARCHAR2(8 BYTE)    
15 STU_DEMO_ID VARCHAR2(16 BYTE)    
16 CLEARED_DATE_STR VARCHAR2(26 BYTE)    
17 DATE_ENTERED_STR VARCHAR2(26 BYTE)    
18 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE)    
19 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
20 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_GDOL ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GDOL_ID VARCHAR2(16 BYTE) Y  
2 COLLEGE VARCHAR2(2 BYTE)    
3 CURRICULUM VARCHAR2(4 BYTE)    
4 DEGR_TERM_CHNG_DAT TIMESTAMP(6)    
5 DEGR_TERM_DATE TIMESTAMP(6)    
6 DOCT_EVAL_CODE VARCHAR2(1 BYTE)    
7 EFFECTIVE_DATE TIMESTAMP(6)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 FELLOWSHIP_CUM_SEM NUMBER(5)    
10 LEVEL_CODE VARCHAR2(1 BYTE)    
11 OBJECTIVE_CODE VARCHAR2(1 BYTE)    
12 RUN_TIME TIMESTAMP(6)    
13 STU_DEMO_ID VARCHAR2(16 BYTE)    
14 THESIS_ADVISOR VARCHAR2(20 BYTE)    
15 THESIS_CUM_UNITS NUMBER(5,2)    
16 THESIS_DEPOSIT_DAT TIMESTAMP(6)    
17 DEGR_TERM_CHNG_DAT_STR VARCHAR2(26 BYTE)    
18 DEGR_TERM_DATE_STR VARCHAR2(26 BYTE)    
19 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE)    
20 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
21 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
22 THESIS_DEPOSIT_DAT_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STUDENT_GRAD_DATA ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GRAD_DATA_ID VARCHAR2(16 BYTE) Y  
2 ENTERING_DATE_GRAD TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_DEMO_ID VARCHAR2(16 BYTE)    
6 ENTERING_DATE_GRAD_STR VARCHAR2(26 BYTE)    
7 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
8 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_GRAD_EXAM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GRAD_EXAM_ID VARCHAR2(16 BYTE) Y  
2 APPOINTMENT_DATE TIMESTAMP(6)    
3 COLLEGE VARCHAR2(2 BYTE)    
4 COMM_DISSOLVE_DATE TIMESTAMP(6)    
5 CURRICULUM VARCHAR2(4 BYTE)    
6 EXAM_DATE TIMESTAMP(6)    
7 EXAM_RESULT VARCHAR2(1 BYTE)    
8 EXAM_TYPE VARCHAR2(1 BYTE)    
9 EXTRACT_TIME TIMESTAMP(6)    
10 RUN_TIME TIMESTAMP(6)    
11 STU_DEMO_ID VARCHAR2(16 BYTE)    
12 APPOINTMENT_DATE_STR VARCHAR2(26 BYTE)    
13 COMM_DISSOLVE_DATE_STR VARCHAR2(26 BYTE)    
14 EXAM_DATE_STR VARCHAR2(26 BYTE)    
15 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
16 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_PRO_DROP ----------

Col # Column Name Data Type Not Null? Comments
1 STU_PRO_DROP_ID VARCHAR2(16 BYTE) Y  
2 CAMPUS VARCHAR2(1 BYTE)    
3 CODE VARCHAR2(2 BYTE)    
4 COLLEGE VARCHAR2(2 BYTE)    
5 CREATE_DATE TIMESTAMP(6)    
6 CURRICULUM VARCHAR2(4 BYTE)    
7 EFFECTIVE_DATE TIMESTAMP(6)    
8 END_DATE TIMESTAMP(6)    
9 EXTRACT_TIME TIMESTAMP(6)    
10 MODIFY_DATE TIMESTAMP(6)    
11 PRO_LEVEL NUMBER(5,3)    
12 RUN_TIME TIMESTAMP(6)    
13 SOURCE VARCHAR2(1 BYTE)    
14 STATUS VARCHAR2(1 BYTE)    
15 STU_DEMO_ID VARCHAR2(16 BYTE)    
16 CREATE_DATE_STR VARCHAR2(26 BYTE) Y  
17 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE)    
18 END_DATE_STR VARCHAR2(26 BYTE)    
19 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
20 MODIFY_DATE_STR VARCHAR2(26 BYTE)    
21 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STUDENT_SPECIAL_GR ----------

Col # Column Name Data Type Not Null? Comments
1 STU_SPECIAL_GR_ID VARCHAR2(16 BYTE) Y  
2 END_DATE TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 SPECIAL_GROUP_CODE VARCHAR2(20 BYTE)    
6 SPECIAL_GROUP_TYPE VARCHAR2(30 BYTE)    
7 START_DATE TIMESTAMP(6)    
8 STU_DEMO_ID VARCHAR2(16 BYTE)    
9 STU_TERM_ID VARCHAR2(16 BYTE)    
10 END_DATE_STR VARCHAR2(26 BYTE)    
11 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
12 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
13 START_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STUDENT_TUITION ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TUITION_ID VARCHAR2(16 BYTE) Y  
2 CHANGE_TEXT VARCHAR2(80 BYTE)    
3 CREATE_DATE TIMESTAMP(6)    
4 CREATE_TIME VARCHAR2(8 BYTE)    
5 CREATED_BY VARCHAR2(8 BYTE)    
6 EFFECTIVE_DATE TIMESTAMP(6)    
7 ELIGIBLE_DATE TIMESTAMP(6)    
8 ELIGIBLE_TERM_YEAR VARCHAR2(4 BYTE)    
9 EXTRACT_TIME TIMESTAMP(6)    
10 PREVIOUS_IND VARCHAR2(1 BYTE)    
11 RUN_TIME TIMESTAMP(6)    
12 STU_DEMO_ID VARCHAR2(16 BYTE)    
13 UDPATE_DATE TIMESTAMP(6)    
14 UDPATE_TIME VARCHAR2(8 BYTE)    
15 UPDATED_BY VARCHAR2(8 BYTE)    
16 CREATE_DATE_STR VARCHAR2(26 BYTE)    
17 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE)    
18 ELIGIBLE_DATE_STR VARCHAR2(26 BYTE)    
19 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
20 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
21 UDPATE_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_ADM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ADM_ID VARCHAR2(16 BYTE) Y  
2 ADM_CODE VARCHAR2(2 BYTE)    
3 ADM_DECISION VARCHAR2(2 BYTE)    
4 ADM_DECISION_DATE TIMESTAMP(6)    
5 CAMPUS_SI VARCHAR2(2 BYTE)    
6 CLASS VARCHAR2(1 BYTE)    
7 COLL_REVIEW VARCHAR2(1 BYTE)    
8 COLL_SI VARCHAR2(2 BYTE)    
9 COLLEGE VARCHAR2(2 BYTE)    
10 CURRICULUM VARCHAR2(4 BYTE)    
11 DEG_OBJECTIVE VARCHAR2(1 BYTE)    
12 EDUCATIONAL_MAJOR VARCHAR2(3 BYTE)    
13 ENGL_LANG_COMP VARCHAR2(1 BYTE)    
14 ENGL_LANG_SCORE VARCHAR2(3 BYTE)    
15 EXTRACT_TIME TIMESTAMP(6)    
16 GPA_GRAD NUMBER(3,2)    
17 GPA_UGRAD NUMBER(3,2)    
18 HRS_EARNED_STATUS VARCHAR2(1 BYTE)    
19 HS_GRADES VARCHAR2(4 BYTE)    
20 HS_PCT_COLL_DECILE NUMBER(5)    
21 INTEREST_HONORS VARCHAR2(1 BYTE)    
22 INTEREST_IND_STUDY VARCHAR2(1 BYTE)    
23 LAW_SI NUMBER(3,1)    
24 NOA_ISSUED_DATE TIMESTAMP(6)    
25 NOA_MSG_1 VARCHAR2(1 BYTE)    
26 NOA_MSG_2 VARCHAR2(1 BYTE)    
27 NOA_MSG_3 VARCHAR2(1 BYTE)    
28 NOA_STATUS VARCHAR2(1 BYTE)    
29 PATTERN_1 VARCHAR2(1 BYTE)    
30 PATTERN_2 VARCHAR2(1 BYTE)    
31 PATTERN_3 VARCHAR2(1 BYTE)    
32 PATTERN_4 VARCHAR2(1 BYTE)    
33 PATTERN_5 VARCHAR2(1 BYTE)    
34 RUN_TIME TIMESTAMP(6)    
35 SPECIAL_CATEGORY VARCHAR2(1 BYTE)    
36 SPECIAL_GROUP_1A VARCHAR2(1 BYTE)    
37 SPECIAL_GROUP_2A VARCHAR2(1 BYTE)    
38 SPECIAL_GROUP_3 VARCHAR2(1 BYTE)    
39 SPECIAL_GROUP_4 VARCHAR2(1 BYTE)    
40 SSN VARCHAR2(9 BYTE)    
41 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
42 SUBSPECIALTY VARCHAR2(2 BYTE)    
43 TERM_DATE TIMESTAMP(6)    
44 TFER_GPA NUMBER(5,3)    
45 TFER_HRS_EARNED NUMBER(5,2)    
46 TFER_HRS_GRADED NUMBER(5,2)    
47 TFER_POINTS NUMBER(7,2)    
48 VM_CUM_GPA NUMBER(5,3)    
49 VM_CUM_HRS_GRADED NUMBER(5,2)    
50 VM_SCI_HRS_GRADED NUMBER(5,2)    
51 VM_SCIENCE_GPA NUMBER(5,3)    
52 VM_SUBJECTIVE_EVAL VARCHAR2(3 BYTE)    
53 ADM_DECISION_DATE_STR VARCHAR2(26 BYTE)    
54 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
55 NOA_ISSUED_DATE_STR VARCHAR2(26 BYTE)    
56 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
57 TERM_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_ADM_TST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ADM_TST_ID VARCHAR2(16 BYTE) Y  
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 SSN VARCHAR2(9 BYTE) Y  
5 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
6 TEST_AREA VARCHAR2(2 BYTE)    
7 TEST_DATE TIMESTAMP(6)    
8 TEST_NATL_PCTILE NUMBER(5)    
9 TEST_SCORE NUMBER(5)    
10 TEST_TYPE VARCHAR2(4 BYTE)    
11 TEST_UI_DECILE NUMBER(5)    
12 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
13 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
14 TEST_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_AWD_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 STU_AWD_DEG_ID VARCHAR2(16 BYTE) Y  
2 ABBREVIATION VARCHAR2(5 BYTE)    
3 AWARDED_DATE TIMESTAMP(6)    
4 CIPS_CODE VARCHAR2(8 BYTE)    
5 CIPS_CODE_TEXT VARCHAR2(55 BYTE)    
6 COLL_HONORS_TEXT VARCHAR2(15 BYTE)    
7 COLLEGE VARCHAR2(2 BYTE)    
8 COLLEGE_HONORS VARCHAR2(1 BYTE)    
9 COLLEGE_NAME VARCHAR2(15 BYTE)    
10 CURR_HONORS_TEXT VARCHAR2(25 BYTE)    
11 CURRICULUM VARCHAR2(4 BYTE)    
12 CURRICULUM_HONORS VARCHAR2(1 BYTE)    
13 CURRICULUM_NAME VARCHAR2(45 BYTE)    
14 CURRICULUM2 VARCHAR2(4 BYTE)    
15 CURRICULUM2_HONORS VARCHAR2(1 BYTE)    
16 CURRICULUM2_NAME VARCHAR2(45 BYTE)    
17 CURRICULUM3 VARCHAR2(4 BYTE)    
18 CURRICULUM3_HONORS VARCHAR2(1 BYTE)    
19 CURRICULUM3_NAME VARCHAR2(45 BYTE)    
20 CURR2_HONORS_TEXT VARCHAR2(25 BYTE)    
21 CURR3_HONORS_TEXT VARCHAR2(25 BYTE)    
22 DEGR_STUDENT_NAME VARCHAR2(90 BYTE)    
23 DEGR_TITLE_OPTION VARCHAR2(2 BYTE)    
24 DEGREE_CODE VARCHAR2(2 BYTE)    
25 DEGREE_PERIOD VARCHAR2(5 BYTE)    
26 EXTRACT_TIME TIMESTAMP(6)    
27 LEDGER_TITLE VARCHAR2(120 BYTE)    
28 MODIFY_DATE TIMESTAMP(6)    
29 NAME_SPECIAL_CHAR VARCHAR2(1 BYTE)    
30 RUN_TIME TIMESTAMP(6)    
31 STATUS VARCHAR2(1 BYTE)    
32 STU_AWD_DEG_TYPE VARCHAR2(1 BYTE)    
33 STU_DEMO_ID VARCHAR2(16 BYTE)    
34 TRANSCRIPT_TITLE VARCHAR2(120 BYTE)    
35 AWARDED_DATE_STR VARCHAR2(26 BYTE)    
36 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
37 MODIFY_DATE_STR VARCHAR2(26 BYTE) Y  
38 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CRS_ID VARCHAR2(16 BYTE) Y  
2 CREDIT_NO_CREDIT VARCHAR2(1 BYTE)    
3 CREDIT_TYPE VARCHAR2(1 BYTE)    
4 DEPT_CODE VARCHAR2(5 BYTE)    
5 DROP_DATE TIMESTAMP(6)    
6 DROP_EFFECTIVE_DAT TIMESTAMP(6)    
7 DROP_TYPE VARCHAR2(10 BYTE)    
8 DROPPED_BY VARCHAR2(8 BYTE)    
9 DUPLICATE_CODE VARCHAR2(1 BYTE)    
10 E_BY_RULE VARCHAR2(1 BYTE)    
11 EARNED_CREDIT NUMBER(5,2)    
12 END_DATE TIMESTAMP(6)    
13 ENROLL_DATE TIMESTAMP(6)    
14 EX_EXPIRATION_DATE TIMESTAMP(6)    
15 EXTRACT_TIME TIMESTAMP(6)    
16 GRADE VARCHAR2(2 BYTE)    
17 GRADED_CREDIT NUMBER(5,2)    
18 GRADED_SEC_ITYPE VARCHAR2(10 BYTE) Y  
19 GRADED_SEC_NAME VARCHAR2(3 BYTE) Y  
20 HONORS_CODE VARCHAR2(1 BYTE)    
21 NOMINAL_CREDIT NUMBER(4,2)    
22 NUMBER_STU_CRS VARCHAR2(3 BYTE)    
23 NUMBER_PREFIX VARCHAR2(1 BYTE)    
24 ORIG_GRADED_SEC_NAME VARCHAR2(3 BYTE)    
25 PRE_CR_NC_GRADE VARCHAR2(2 BYTE)    
26 PREVIOUS_GRADE_IND VARCHAR2(1 BYTE)    
27 RELIGIOUS_IND VARCHAR2(1 BYTE)    
28 REMEDIAL_IND VARCHAR2(1 BYTE)    
29 RUBRIC VARCHAR2(5 BYTE) Y  
30 RUN_TIME TIMESTAMP(6)    
31 SPECIAL_ACTION_COL VARCHAR2(2 BYTE)    
32 SSN VARCHAR2(9 BYTE) Y  
33 START_DATE TIMESTAMP(6)    
34 STU_TERM_ID VARCHAR2(16 BYTE) Y  
35 TECHNICAL_IND VARCHAR2(1 BYTE)    
36 TERM_END_DATE TIMESTAMP(6)    
37 TERM_TYPE VARCHAR2(2 BYTE) Y  
38 TERM_YEAR VARCHAR2(4 BYTE) Y  
39 TITLE VARCHAR2(20 BYTE)    
40 TSCR_NO_POST_IND VARCHAR2(1 BYTE)    
41 VISITOR_IND VARCHAR2(1 BYTE)    
42 WITHDRAWN_IND VARCHAR2(1 BYTE)    
43 YEAR_TERM VARCHAR2(4 BYTE) Y  
44 DROP_DATE_STR VARCHAR2(26 BYTE)    
45 DROP_EFFECTIVE_DAT_STR VARCHAR2(26 BYTE)    
46 END_DATE_STR VARCHAR2(26 BYTE)    
47 ENROLL_DATE_STR VARCHAR2(26 BYTE)    
48 EX_EXPIRATION_DATE_STR VARCHAR2(26 BYTE)    
49 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
50 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
51 START_DATE_STR VARCHAR2(26 BYTE)    
52 TERM_END_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_CRS_SEC ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CRS_SEC_ID VARCHAR2(16 BYTE) Y  
2 ITYPE VARCHAR2(10 BYTE) Y  
3 ADDED_BY VARCHAR2(8 BYTE)    
4 DROP_DATE TIMESTAMP(6)    
5 DROP_TYPE VARCHAR2(10 BYTE)    
6 DROPPED_BY VARCHAR2(8 BYTE)    
7 ENROLL_DATE TIMESTAMP(6)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 GRADED_INDICATOR VARCHAR2(1 BYTE) Y  
10 RUN_TIME TIMESTAMP(6)    
11 SEC_NAME VARCHAR2(3 BYTE) Y  
12 STU_CRS_ID VARCHAR2(16 BYTE) Y  
13 TERM_YEAR VARCHAR2(4 BYTE)    
14 WITHDRAWN_IND VARCHAR2(1 BYTE)    
15 DROP_DATE_STR VARCHAR2(26 BYTE)    
16 ENROLL_DATE_STR VARCHAR2(26 BYTE)    
17 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
18 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CUR_ADDR_ID VARCHAR2(16 BYTE) Y  
2 CITY VARCHAR2(15 BYTE)    
3 COUNTRY VARCHAR2(3 BYTE)    
4 EFFECTIVE_DATE TIMESTAMP(6)    
5 EXTRACT_TIME TIMESTAMP(6)    
6 LINE1 VARCHAR2(30 BYTE)    
7 LINE2 VARCHAR2(30 BYTE)    
8 MAIL_CODE VARCHAR2(6 BYTE)    
9 PHONE_NUMBER VARCHAR2(25 BYTE)    
10 RUN_TIME TIMESTAMP(6)    
11 STATE VARCHAR2(2 BYTE) Y  
12 STREET VARCHAR2(30 BYTE)    
13 STU_CUR_ADDR_TYPE VARCHAR2(10 BYTE) Y  
14 STU_DEMO_ID VARCHAR2(16 BYTE)    
15 ZIP VARCHAR2(9 BYTE)    
16 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE) Y  
17 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
18 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
2 ADDRESS_REVIEW_DAT TIMESTAMP(6)    
3 BIRTH_DATE TIMESTAMP(6)    
4 BLOOD_DONOR VARCHAR2(1 BYTE)    
5 BLOOD_DONOR_DATE TIMESTAMP(6)    
6 COLLEGE VARCHAR2(2 BYTE)    
7 CURRENT_FULL_NAME VARCHAR2(40 BYTE) Y  
8 CURRICULUM VARCHAR2(4 BYTE)    
9 DECEASED_DATE TIMESTAMP(6)    
10 EFFECTIVE_DATE TIMESTAMP(6)    
11 EMAIL_ADDR VARCHAR2(17 BYTE) Y  
12 ENROLLMENT_PATTERN VARCHAR2(1 BYTE)    
13 ENROLLMENT_STATUS VARCHAR2(1 BYTE) Y  
14 ENTERING_DATE_UI TIMESTAMP(6)    
15 EXPECTED_DEGREE VARCHAR2(5 BYTE)    
16 EXPECTED_DEGREE_DA TIMESTAMP(6)    
17 EXTRACT_TIME TIMESTAMP(6)    
18 FAT_CHANGE_DATE TIMESTAMP(6)    
19 FAT_CHANGED_BY VARCHAR2(8 BYTE)    
20 FERPA_ED_DATE TIMESTAMP(6)    
21 FERPA_ST_DATE TIMESTAMP(6)    
22 FERPA_TYPE VARCHAR2(20 BYTE)    
23 FIRST_NAME VARCHAR2(30 BYTE) Y  
24 FIRST_TERM_DATE TIMESTAMP(6)    
25 FIRST_TERM_TYPE VARCHAR2(2 BYTE) Y  
26 FIRST_TERM_YEAR VARCHAR2(4 BYTE) Y  
27 FRGN_STUD_SUPPORT VARCHAR2(1 BYTE)    
28 FULL_NAME_UPPER_CA VARCHAR2(40 BYTE)    
29 GED_TEST_IND VARCHAR2(1 BYTE)    
30 I_CARD_NUMBER VARCHAR2(9 BYTE)    
31 JR_COLLEGE_CODE VARCHAR2(2 BYTE)    
32 LAST_AUTH_DATE TIMESTAMP(6)    
33 LAST_AUTH_LOCK VARCHAR2(1 BYTE)    
34 LAST_NAME VARCHAR2(30 BYTE) Y  
35 LAST_TERM_DATE TIMESTAMP(6)    
36 LAST_TERM_TYPE VARCHAR2(2 BYTE) Y  
37 LAST_TERM_YEAR VARCHAR2(4 BYTE) Y  
38 MIDDLE_NAME VARCHAR2(35 BYTE)    
39 NETWORK_ID VARCHAR2(8 BYTE)    
40 PERS_CONTINENT VARCHAR2(2 BYTE)    
41 PERS_COUNTRY VARCHAR2(3 BYTE)    
42 PERS_COUNTY VARCHAR2(3 BYTE)    
43 PERS_STATE VARCHAR2(2 BYTE)    
44 PERSON_ID VARCHAR2(16 BYTE)    
45 PREVIOUS_INDICATOR VARCHAR2(1 BYTE)    
46 RELIGIOUS_FND_DATE TIMESTAMP(6)    
47 RELIGIOUS_FOUNDATI VARCHAR2(3 BYTE)    
48 RESIDENCE VARCHAR2(1 BYTE)    
49 RESIDENCE_CHANGE_D TIMESTAMP(6)    
50 RUN_TIME TIMESTAMP(6)    
51 SEX VARCHAR2(1 BYTE)    
52 SF_CREATE_DATE TIMESTAMP(6)    
53 SPECIAL_CHAR_IND VARCHAR2(1 BYTE)    
54 SSN VARCHAR2(9 BYTE) Y  
55 STUDENT_ACCESS_LOC VARCHAR2(1 BYTE)    
56 STUDENT_CIT_CHANGE TIMESTAMP(6)    
57 STUDENT_CITIZENSHI VARCHAR2(1 BYTE)    
58 STUDENT_ETHNIC VARCHAR2(1 BYTE)    
59 SUFFIX VARCHAR2(10 BYTE)    
60 TERMINATION_TERM VARCHAR2(4 BYTE) Y  
61 VALIDATION_STATUS VARCHAR2(1 BYTE)    
62 VETERAN_DISCHARGE TIMESTAMP(6)    
63 VETERAN_IND VARCHAR2(1 BYTE)    
64 ADDRESS_REVIEW_DAT_STR VARCHAR2(26 BYTE)    
65 BIRTH_DATE_STR VARCHAR2(26 BYTE)    
66 BLOOD_DONOR_DATE_STR VARCHAR2(26 BYTE)    
67 DECEASED_DATE_STR VARCHAR2(26 BYTE)    
68 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE) Y  
69 ENTERING_DATE_UI_STR VARCHAR2(26 BYTE)    
70 EXPECTED_DEGREE_DA_STR VARCHAR2(26 BYTE)    
71 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
72 FAT_CHANGE_DATE_STR VARCHAR2(26 BYTE)    
73 FERPA_ED_DATE_STR VARCHAR2(26 BYTE)    
74 FERPA_ST_DATE_STR VARCHAR2(26 BYTE)    
75 FIRST_TERM_DATE_STR VARCHAR2(26 BYTE)    
76 LAST_AUTH_DATE_STR VARCHAR2(26 BYTE)    
77 LAST_TERM_DATE_STR VARCHAR2(26 BYTE)    
78 RELIGIOUS_FND_DATE_STR VARCHAR2(26 BYTE)    
79 RESIDENCE_CHANGE_D_STR VARCHAR2(26 BYTE)    
80 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
81 SF_CREATE_DATE_STR VARCHAR2(26 BYTE)    
82 STUDENT_CIT_CHANGE_STR VARCHAR2(26 BYTE)    
83 VETERAN_DISCHARGE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_EXT_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 STU_EXT_DEG_ID VARCHAR2(16 BYTE) Y  
2 ACCEPT_DATE TIMESTAMP(6)    
3 DEGREE_DATE TIMESTAMP(6)    
4 DEGREE_LEVEL VARCHAR2(2 BYTE)    
5 DEGREE_NAME VARCHAR2(25 BYTE) Y  
6 DEGREE_YEAR NUMBER(5)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 INSTITUTION_CODE VARCHAR2(6 BYTE)    
9 INSTITUTION_NAME VARCHAR2(30 BYTE)    
10 MISSING_CREDENTIAL VARCHAR2(1 BYTE)    
11 RUN_TIME TIMESTAMP(6)    
12 SEQUENCE_NUMBER NUMBER(5)    
13 SOURCE VARCHAR2(1 BYTE)    
14 STU_DEMO_ID VARCHAR2(16 BYTE)    
15 STU_TFER_INST_ID VARCHAR2(16 BYTE)    
16 ACCEPT_DATE_STR VARCHAR2(26 BYTE)    
17 DEGREE_DATE_STR VARCHAR2(26 BYTE)    
18 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
19 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_GAS ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GAS_ID VARCHAR2(16 BYTE) Y  
2 DEPT_MIN_AVG NUMBER(4,3)    
3 EFFECTIVE_DATE TIMESTAMP(6)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 GAS_CODE VARCHAR2(1 BYTE)    
6 GPA_REVIEW VARCHAR2(1 BYTE)    
7 LTD_DEPT_DEFICIENC VARCHAR2(1 BYTE)    
8 LTD_ENG_COMP VARCHAR2(1 BYTE)    
9 LTD_GPA_BELOW_MIN VARCHAR2(1 BYTE)    
10 LTD_GPA_NOT_AVG VARCHAR2(1 BYTE)    
11 LTD_MISSING_CRED VARCHAR2(1 BYTE)    
12 LTD_NO_US_BACC_EQU VARCHAR2(1 BYTE)    
13 RUN_TIME TIMESTAMP(6)    
14 SSN VARCHAR2(9 BYTE) Y  
15 STU_DEMO_ID VARCHAR2(16 BYTE)    
16 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE)    
17 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
18 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_GRAD_DATA ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GRAD_DATA_ID VARCHAR2(16 BYTE) Y  
2 ENTERING_DATE_GRAD TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_DEMO_ID VARCHAR2(16 BYTE)    
6 ENTERING_DATE_GRAD_STR VARCHAR2(26 BYTE)    
7 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
8 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_HS_ENRL ----------

Col # Column Name Data Type Not Null? Comments
1 STU_HS_ENRL_ID VARCHAR2(16 BYTE) Y  
2 CITY_STATE VARCHAR2(18 BYTE)    
3 CLASS_RANK NUMBER    
4 CLASS_SIZE NUMBER    
5 END_DATE TIMESTAMP(6)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 GRADUATION_DATE TIMESTAMP(6)    
8 HONORS_COURSES VARCHAR2(1 BYTE)    
9 HS_CODE VARCHAR2(6 BYTE)    
10 HS_NAME VARCHAR2(30 BYTE)    
11 PERCENTILE_RANK_UI NUMBER(5)    
12 PERCENTILE_UI_HS NUMBER(5)    
13 RANK_EXCEPTION VARCHAR2(1 BYTE)    
14 RUN_TIME TIMESTAMP(6)    
15 SSN VARCHAR2(9 BYTE) Y  
16 START_DATE TIMESTAMP(6)    
17 STU_DEMO_ID VARCHAR2(16 BYTE)    
18 STU_HS_INST_ID VARCHAR2(16 BYTE)    
19 ZIP VARCHAR2(9 BYTE)    
20 END_DATE_STR VARCHAR2(26 BYTE)    
21 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
22 GRADUATION_DATE_STR VARCHAR2(26 BYTE)    
23 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
24 START_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_HS_INST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_HS_INST_ID VARCHAR2(16 BYTE) Y  
2 ACCREDITATION_TYPE VARCHAR2(1 BYTE)    
3 AP_COURSES VARCHAR2(1 BYTE)    
4 BUILDING_MNEMONIC VARCHAR2(5 BYTE)    
5 BUILDING_ROOM VARCHAR2(10 BYTE)    
6 CHANGE_REASON VARCHAR2(10 BYTE)    
7 CITY VARCHAR2(20 BYTE)    
8 CLASS_SIZE VARCHAR2(4 BYTE)    
9 COMMUNITY_COLLEGE VARCHAR2(10 BYTE)    
10 CONTACT_PERSON VARCHAR2(20 BYTE)    
11 COUNTRY VARCHAR2(3 BYTE)    
12 COUNTY_CODE VARCHAR2(3 BYTE)    
13 COUNTY_NAME VARCHAR2(80 BYTE)    
14 EFFECTIVE_DATE TIMESTAMP(6)    
15 END_DATE TIMESTAMP(6)    
16 EXTRACT_TIME TIMESTAMP(6)    
17 HONORS_COURSES VARCHAR2(1 BYTE)    
18 HS_CODE VARCHAR2(6 BYTE) Y  
19 HS_INST_TYPE VARCHAR2(10 BYTE) Y  
20 HS_NAME VARCHAR2(40 BYTE)    
21 HS_NAME_UPPER_CASE VARCHAR2(40 BYTE)    
22 LINE1 VARCHAR2(30 BYTE)    
23 LINE2 VARCHAR2(30 BYTE)    
24 MAIL_CODE VARCHAR2(6 BYTE)    
25 PHONE VARCHAR2(20 BYTE)    
26 RANK_EXCEPTION VARCHAR2(1 BYTE)    
27 RUN_TIME TIMESTAMP(6)    
28 SEMESTER_BASIS VARCHAR2(1 BYTE)    
29 SIZE_CODE VARCHAR2(1 BYTE)    
30 SPECIAL_REVIEW_IND VARCHAR2(1 BYTE)    
31 START_DATE TIMESTAMP(6)    
32 STATE VARCHAR2(2 BYTE)    
33 STREET VARCHAR2(30 BYTE) Y  
34 TERMINATION_REASON VARCHAR2(20 BYTE)    
35 TYPE_CODE VARCHAR2(1 BYTE)    
36 WEIGHTED_RANK VARCHAR2(1 BYTE)    
37 ZIP VARCHAR2(9 BYTE)    
38 EFFECTIVE_DATE_STR VARCHAR2(26 BYTE) Y  
39 END_DATE_STR VARCHAR2(26 BYTE)    
40 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
41 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
42 START_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_HS_SUBJ ----------

Col # Column Name Data Type Not Null? Comments
1 STU_HS_SUBJ_ID VARCHAR2(16 BYTE) Y  
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 SSN VARCHAR2(9 BYTE) Y  
5 STU_DEMO_ID VARCHAR2(16 BYTE)    
6 STU_HS_ENRL_ID VARCHAR2(16 BYTE)    
7 SUBJECT_NAME VARCHAR2(20 BYTE) Y  
8 SUBJECT_UNITS NUMBER(4,2)    
9 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
10 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_MIDSEMESTER ----------

Col # Column Name Data Type Not Null? Comments
1 STU_MIDSEMESTER_ID VARCHAR2(16 BYTE) Y  
2 CREATE_DATE TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 GRADE VARCHAR2(2 BYTE)    
5 RUN_TIME TIMESTAMP(6)    
6 STU_CRS_ID VARCHAR2(16 BYTE)    
7 UPDATE_DATE TIMESTAMP(6)    
8 CREATE_DATE_STR VARCHAR2(26 BYTE)    
9 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
10 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
11 UPDATE_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_PND_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 STU_PND_DEG_ID VARCHAR2(16 BYTE) Y  
2 COMMENTS VARCHAR2(60 BYTE)    
3 COMMENTS_LINE_2 VARCHAR2(60 BYTE)    
4 CREATE_DATE TIMESTAMP(6)    
5 DEGREE_ABBREVIATIO VARCHAR2(5 BYTE)    
6 DEGREE_COLLEGE VARCHAR2(2 BYTE)    
7 DEGREE_COLLEGE2 VARCHAR2(2 BYTE)    
8 DEGREE_COLLEGE3 VARCHAR2(2 BYTE)    
9 DEGREE_CURRICULUM VARCHAR2(4 BYTE)    
10 DEGREE_CURRICULUM2 VARCHAR2(4 BYTE)    
11 DEGREE_CURRICULUM3 VARCHAR2(4 BYTE)    
12 DEGREE_OPTION VARCHAR2(2 BYTE)    
13 DEGREE_PERIOD TIMESTAMP(6)    
14 DEGREE_STATUS VARCHAR2(1 BYTE)    
15 EXTRACT_TIME TIMESTAMP(6)    
16 HONORS_COLLEGE VARCHAR2(1 BYTE)    
17 HONORS_CURRICULUM VARCHAR2(1 BYTE)    
18 HONORS_CURRICULUM2 VARCHAR2(1 BYTE)    
19 HONORS_CURRICULUM3 VARCHAR2(1 BYTE)    
20 MODIFIED_BY VARCHAR2(8 BYTE)    
21 MODIFY_DATE TIMESTAMP(6)    
22 NAME_DIPLOMA VARCHAR2(90 BYTE)    
23 NAME_FIRST VARCHAR2(30 BYTE)    
24 NAME_FULL VARCHAR2(90 BYTE)    
25 NAME_LAST VARCHAR2(30 BYTE)    
26 NAME_MIDDLE VARCHAR2(35 BYTE)    
27 NAME_SUFFIX VARCHAR2(10 BYTE)    
28 RUN_TIME TIMESTAMP(6)    
29 SSN VARCHAR2(9 BYTE)    
30 STU_DEMO_ID VARCHAR2(16 BYTE)    
31 CREATE_DATE_STR VARCHAR2(26 BYTE)    
32 DEGREE_PERIOD_STR VARCHAR2(26 BYTE)    
33 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
34 MODIFY_DATE_STR VARCHAR2(26 BYTE)    
35 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_TBC ----------

Col # Column Name Data Type Not Null? Comments
1 SSN VARCHAR2(9 BYTE) Y  
2 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
3 STU_PROFNC_CRS_ID VARCHAR2(16 BYTE)    
4 STU_PROFNC_AREA_ID VARCHAR2(16 BYTE)    
5 AREA_SUBJ VARCHAR2(10 BYTE)    
6 CRS_SUBJ VARCHAR2(10 BYTE)    
7 CRS_NUMBER VARCHAR2(4 BYTE)    
8 CRS_CREDIT_TYPE VARCHAR2(1 BYTE)    
9 CRS_NOMINAL_CREDIT NUMBER(5,2)    
10 EXAM_TYPE VARCHAR2(10 BYTE)    
11 RUN_TIME TIMESTAMP(6)    
12 EXTRACT_TIME TIMESTAMP(6)    
13 RUN_TIME_STR VARCHAR2(26 BYTE)    
14 EXTRACT_TIME_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TERM_ID VARCHAR2(16 BYTE) Y  
2 ADVISOR_SSN_1 VARCHAR2(9 BYTE)    
3 ADVISOR_SSN_2 VARCHAR2(9 BYTE)    
4 ANCILLARY_CSWK_1 VARCHAR2(4 BYTE)    
5 ANCILLARY_CSWK_2 VARCHAR2(4 BYTE)    
6 ASSISTANTSHIP_PEND VARCHAR2(1 BYTE)    
7 AUTHORIZATION_CONT VARCHAR2(1 BYTE)    
8 AUTHORIZATION_DATE TIMESTAMP(6)    
9 AUTHORIZATION_SOUR VARCHAR2(1 BYTE)    
10 CAMPUS VARCHAR2(1 BYTE)    
11 CATALOG_YEAR_1 VARCHAR2(4 BYTE)    
12 CATALOG_YEAR_2 VARCHAR2(4 BYTE)    
13 CLASS_CODE VARCHAR2(1 BYTE)    
14 CODE_FIN VARCHAR2(2 BYTE)    
15 CODE_INI VARCHAR2(2 BYTE)    
16 COLL_ENR_CATEGORY VARCHAR2(1 BYTE)    
17 COLLEGE VARCHAR2(2 BYTE)    
18 COLLEGE_FIN VARCHAR2(2 BYTE)    
19 COLLEGE_INI VARCHAR2(2 BYTE)    
20 CR_NC_HOURS NUMBER(5,2)    
21 CR_NC_UNITS NUMBER(5,2)    
22 CURRICULUM VARCHAR2(4 BYTE)    
23 CURRICULUM_FIN VARCHAR2(4 BYTE)    
24 CURRICULUM_INI VARCHAR2(4 BYTE)    
25 DARS_COLL_OPT_2 VARCHAR2(2 BYTE)    
26 DARS_CURR_OPT_2 VARCHAR2(4 BYTE)    
27 DARS_OPTION_ID_2 VARCHAR2(2 BYTE)    
28 DARS_OPTION_1 VARCHAR2(2 BYTE)    
29 DEANS_LIST_IND VARCHAR2(1 BYTE)    
30 EARNED_HOURS NUMBER(5,2)    
31 EARNED_UNITS NUMBER(5,2)    
32 EFFECTIVE_DATE_FIN TIMESTAMP(6)    
33 EFFECTIVE_DATE_INI TIMESTAMP(6)    
34 ENCUMBRANCE_OVERRI VARCHAR2(1 BYTE)    
35 ENROLLMENT_STATUS VARCHAR2(1 BYTE) Y  
36 EXTRACT_TIME TIMESTAMP(6)    
37 GRADED_HOURS NUMBER(5,2)    
38 GRADED_POINTS_HOUR NUMBER(5,2)    
39 GRADED_POINTS_UNIT NUMBER(5,2)    
40 GRADED_UNITS NUMBER(5,2)    
41 INITIAL_ACCESS_DAT TIMESTAMP(6)    
42 INITIAL_ACCESS_TIM VARCHAR2(8 BYTE)    
43 JAMES_SCHOLAR_IND VARCHAR2(1 BYTE)    
44 JOINT_PROGRAM VARCHAR2(2 BYTE)    
45 NEW_STATUS VARCHAR2(1 BYTE)    
46 NOMINAL_HOURS NUMBER(5,2)    
47 NOMINAL_UNITS NUMBER(5,2)    
48 OFF_CAMPUS_ACAD_YE VARCHAR2(1 BYTE)    
49 OFF_CAMPUS_PROGRAM VARCHAR2(2 BYTE)    
50 OVERLOAD_HOURS NUMBER(4,2)    
51 PENDING_HOURS NUMBER(5,2)    
52 PENDING_UNITS NUMBER(5,2)    
53 PREPROF_INTEREST_1 VARCHAR2(3 BYTE)    
54 PREPROF_INTEREST_2 VARCHAR2(3 BYTE)    
55 PREV_CAMPUS VARCHAR2(1 BYTE)    
56 PREV_COLLEGE VARCHAR2(2 BYTE)    
57 PREV_CURRICULUM VARCHAR2(4 BYTE)    
58 PREV_JOINT_PROGRAM VARCHAR2(2 BYTE)    
59 PREV_SEQUENCE_NUMR NUMBER(5)    
60 PREV_SUBSPECIALTY VARCHAR2(2 BYTE)    
61 PRO_LEVEL_FIN NUMBER(5,3)    
62 PRO_LEVEL_INI NUMBER(5,3)    
63 REGISTRATION_DATE TIMESTAMP(6)    
64 REGISTRATION_TERMI TIMESTAMP(6)    
65 RESIDENCE VARCHAR2(1 BYTE)    
66 RUN_TIME TIMESTAMP(6)    
67 SEQUENCE_NUMBER NUMBER(5)    
68 SOURCE_FIN VARCHAR2(1 BYTE)    
69 SOURCE_INI VARCHAR2(1 BYTE)    
70 SSN VARCHAR2(9 BYTE) Y  
71 STATUS_FIN VARCHAR2(1 BYTE)    
72 STATUS_INI VARCHAR2(1 BYTE)    
73 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
74 SUBSPECIALTY VARCHAR2(2 BYTE)    
75 TERM_END_DATE TIMESTAMP(6)    
76 TERM_ID VARCHAR2(16 BYTE) Y  
77 TERM_START_DATE TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2 BYTE) Y  
79 TERM_YEAR VARCHAR2(4 BYTE) Y  
80 UNDERLOAD_HOURS NUMBER(5,2)    
81 VEHICLE_REGISTRATI VARCHAR2(1 BYTE)    
82 VISITOR_IND VARCHAR2(1 BYTE)    
83 WAIVER_RULE_DATE TIMESTAMP(6)    
84 AUTHORIZATION_DATE_STR VARCHAR2(26 BYTE) Y  
85 EFFECTIVE_DATE_FIN_STR VARCHAR2(26 BYTE)    
86 EFFECTIVE_DATE_INI_STR VARCHAR2(26 BYTE)    
87 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
88 INITIAL_ACCESS_DAT_STR VARCHAR2(26 BYTE)    
89 REGISTRATION_DATE_STR VARCHAR2(26 BYTE)    
90 REGISTRATION_TERMI_STR VARCHAR2(26 BYTE)    
91 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
92 TERM_END_DATE_STR VARCHAR2(26 BYTE)    
93 TERM_START_DATE_STR VARCHAR2(26 BYTE)    
94 WAIVER_RULE_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table STU_TERM_HOLD ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TERM_ID VARCHAR2(16 BYTE) Y  
2 COLLEGE VARCHAR2(2 BYTE)    
3 DEANS_LIST_IND VARCHAR2(1 BYTE)    
4 TERM_YEAR VARCHAR2(4 BYTE) Y  

 

 

Tables

---------- Table STU_TFER_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TFER_CRS_ID VARCHAR2(16 BYTE) Y  
2 ACCEPT_CODE VARCHAR2(2 BYTE)    
3 CREDIT_TYPE VARCHAR2(1 BYTE)    
4 DUPLICATE VARCHAR2(1 BYTE)    
5 EXTRACT_TIME TIMESTAMP(6)    
6 GRADE VARCHAR2(2 BYTE)    
7 INSTITUTION_CODE VARCHAR2(6 BYTE) Y  
8 INSTITUTION_NAME VARCHAR2(30 BYTE)    
9 NOMINAL_CREDIT NUMBER(7,5)    
10 NUMBER_STU_TFER_CRS VARCHAR2(5 BYTE)    
11 RUN_TIME TIMESTAMP(6)    
12 SEMESTER_QUARTER VARCHAR2(1 BYTE)    
13 SSN VARCHAR2(9 BYTE) Y  
14 STATE VARCHAR2(2 BYTE)    
15 STU_DEMO_ID VARCHAR2(16 BYTE) Y  
16 STU_TFER_INST_ID VARCHAR2(16 BYTE)    
17 SUBJECT VARCHAR2(5 BYTE)    
18 TERM_YEAR VARCHAR2(10 BYTE)    
19 TITLE VARCHAR2(20 BYTE)    
20 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
21 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table STU_TFER_INST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TFER_INST_ID VARCHAR2(16 BYTE) Y  
2 ACCREDITATION VARCHAR2(1 BYTE)    
3 CALCULATE_GPA VARCHAR2(1 BYTE)    
4 CLOSED_REASON VARCHAR2(1 BYTE)    
5 CODE VARCHAR2(6 BYTE) Y  
6 COUNTRY VARCHAR2(10 BYTE)    
7 END_DATE TIMESTAMP(6)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 INST_NAME_UPPER_CA VARCHAR2(30 BYTE)    
10 LIA_CODE VARCHAR2(2 BYTE)    
11 NAME VARCHAR2(30 BYTE)    
12 NAME_65 VARCHAR2(65 BYTE)    
13 RUN_TIME TIMESTAMP(6)    
14 SEMESTER_OR_QUARTE VARCHAR2(1 BYTE)    
15 START_DATE TIMESTAMP(6)    
16 STATE VARCHAR2(2 BYTE)    
17 END_DATE_STR VARCHAR2(26 BYTE)    
18 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
19 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
20 START_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table TABLE_NAME ----------

Col # Column Name Data Type Not Null? Comments
1 TABLE_NAME_ID VARCHAR2(30 BYTE) Y  
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 TABLE_NAME_DESC VARCHAR2(80 BYTE)    
5 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
6 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table TABLE_PRIVS ----------

Col # Column Name Data Type Not Null? Comments
1 USER_NAME VARCHAR2(30 BYTE) Y  
2 TABLE_NAME VARCHAR2(30 BYTE) Y  
3 FULL_NAME VARCHAR2(30 BYTE)    

 

 

Tables

---------- Table TABLE_RSLT ----------

Col # Column Name Data Type Not Null? Comments
1 TABLE_RSLT_ID VARCHAR2(16 BYTE) Y  
2 EXTRACT_TIME TIMESTAMP(6)    
3 RSLT_VALUE VARCHAR2(30 BYTE) Y  
4 RUN_TIME TIMESTAMP(6)    
5 TABLE_NAME_ID VARCHAR2(30 BYTE)    
6 TABLE_RSLT_DESC VARCHAR2(80 BYTE)    
7 TABLE_VALUE_ID VARCHAR2(30 BYTE)    
8 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
9 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table TABLE_VALUE ----------

Col # Column Name Data Type Not Null? Comments
1 TABLE_VALUE_ID VARCHAR2(30 BYTE) Y  
2 TABLE_NAME_ID VARCHAR2(30 BYTE) Y  
3 EXTRACT_TIME TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 TABLE_VALUE_DESC VARCHAR2(80 BYTE)    
6 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
7 RUN_TIME_STR VARCHAR2(26 BYTE) Y  

 

 

Tables

---------- Table TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_ID VARCHAR2(16 BYTE) Y  
2 CAMPUS VARCHAR2(1 BYTE) Y  
3 END_DATE TIMESTAMP(6)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 LAST_CLASS_DATE TIMESTAMP(6)    
6 MIS_GRADE_DATE TIMESTAMP(6)    
7 MIS_GRADE_DATE_LAW TIMESTAMP(6)    
8 NAME VARCHAR2(10 BYTE)    
9 OK_TO_ADD_DROP VARCHAR2(1 BYTE)    
10 OK_TO_ADVANCE_ENRO VARCHAR2(1 BYTE)    
11 RUN_TIME TIMESTAMP(6)    
12 START_DATE TIMESTAMP(6)    
13 TERM_TYPE VARCHAR2(10 BYTE) Y  
14 TERM_YEAR VARCHAR2(4 BYTE) Y  
15 TRANSCRIPT_TEXT VARCHAR2(20 BYTE)    
16 YEAR NUMBER(5)    
17 END_DATE_STR VARCHAR2(26 BYTE)    
18 EXTRACT_TIME_STR VARCHAR2(26 BYTE) Y  
19 LAST_CLASS_DATE_STR VARCHAR2(26 BYTE)    
20 MIS_GRADE_DATE_STR VARCHAR2(26 BYTE)    
21 MIS_GRADE_DATE_LAW_STR VARCHAR2(26 BYTE)    
22 RUN_TIME_STR VARCHAR2(26 BYTE) Y  
23 START_DATE_STR VARCHAR2(26 BYTE)    

 

 

Tables

---------- Table UIUCWRLOG ----------

Col # Column Name Data Type Not Null? Comments
1 LOG_NETID VARCHAR2(10 BYTE) Y  
2 LOG_CLIENTCOLLDEPT VARCHAR2(10 BYTE)    
3 LOG_DATE VARCHAR2(20 BYTE)    
4 LOG_TIME VARCHAR2(20 BYTE)    
5 LOG_RPTTYPE VARCHAR2(10 BYTE)    
6 LOG_COLLTYPE VARCHAR2(20 BYTE)    
7 LOG_COLL VARCHAR2(10 BYTE)    
8 LOG_CURR VARCHAR2(255 BYTE)    
9 LOG_CLASS VARCHAR2(10 BYTE)    
10 LOG_NEWSTATUS VARCHAR2(10 BYTE)    
11 LOG_ENRLSTATUS VARCHAR2(10 BYTE)    
12 LOG_TERMYEAR VARCHAR2(10 BYTE)    
13 LOG_DEGREEPERIOD VARCHAR2(7 BYTE)    
14 LOG_FERPA VARCHAR2(20 BYTE)    
15 LOG_VIEWEDIN VARCHAR2(50 BYTE)    
16 LOG_RPTNAME VARCHAR2(20 BYTE)    

 

 

Tables

---------- Table VIEW_PRIVS ----------

Col # Column Name Data Type Not Null? Comments
1 USER_NAME VARCHAR2(30 BYTE) Y  
2 VIEW_NAME VARCHAR2(30 BYTE) Y  
3 FULL_NAME VARCHAR2(30 BYTE)    

 

Views

---------- View PREVIOUS_SSN ----------

Col # Column Name Data Type Not Null? Comments
1 PREVIOUS_SSN_ID VARCHAR2(16) Y  
2 EFFECTIVE_DATE TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 PREVIOUS_SSN VARCHAR2(9) Y  
5 RUN_TIME TIMESTAMP(6)    
6 STU_DEMO_ID VARCHAR2(16) Y  

 

 

Views

---------- View STU_DEMO_DIST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DEMO_ID VARCHAR2(16) Y  
2 ADDRESS_REVIEW_DAT TIMESTAMP(6)    
3 BIRTH_DATE TIMESTAMP(6)    
4 BLOOD_DONOR VARCHAR2(1)    
5 BLOOD_DONOR_DATE TIMESTAMP(6)    
6 COLLEGE VARCHAR2(2)    
7 CURRENT_FULL_NAME VARCHAR2(40) Y  
8 CURRICULUM VARCHAR2(4)    
9 DECEASED_DATE TIMESTAMP(6)    
10 EFFECTIVE_DATE TIMESTAMP(6)    
11 EMAIL_ADDR VARCHAR2(17) Y  
12 ENROLLMENT_PATTERN VARCHAR2(1)    
13 ENROLLMENT_STATUS VARCHAR2(1) Y  
14 ENTERING_DATE_UI TIMESTAMP(6)    
15 EXPECTED_DEGREE VARCHAR2(5)    
16 EXPECTED_DEGREE_DA TIMESTAMP(6)    
17 EXTRACT_TIME TIMESTAMP(6)    
18 FAT_CHANGE_DATE TIMESTAMP(6)    
19 FAT_CHANGED_BY VARCHAR2(8)    
20 FERPA_ED_DATE TIMESTAMP(6)    
21 FERPA_ST_DATE TIMESTAMP(6)    
22 FERPA_TYPE VARCHAR2(20)    
23 FIRST_NAME VARCHAR2(30) Y  
24 FIRST_TERM_DATE TIMESTAMP(6)    
25 FIRST_TERM_TYPE VARCHAR2(2) Y  
26 FIRST_TERM_YEAR VARCHAR2(4) Y  
27 FRGN_STUD_SUPPORT VARCHAR2(1)    
28 FULL_NAME_UPPER_CA VARCHAR2(40)    
29 GED_TEST_IND VARCHAR2(1)    
30 I_CARD_NUMBER VARCHAR2(9)    
31 JR_COLLEGE_CODE VARCHAR2(2)    
32 LAST_AUTH_DATE TIMESTAMP(6)    
33 LAST_AUTH_LOCK VARCHAR2(1)    
34 LAST_NAME VARCHAR2(30) Y  
35 LAST_TERM_DATE TIMESTAMP(6)    
36 LAST_TERM_TYPE VARCHAR2(2) Y  
37 LAST_TERM_YEAR VARCHAR2(4) Y  
38 MIDDLE_NAME VARCHAR2(35)    
39 NETWORK_ID VARCHAR2(8)    
40 PERS_CONTINENT VARCHAR2(2)    
41 PERS_COUNTRY VARCHAR2(3)    
42 PERS_COUNTY VARCHAR2(3)    
43 PERS_STATE VARCHAR2(2)    
44 PERSON_ID VARCHAR2(16)    
45 PREVIOUS_INDICATOR VARCHAR2(1)    
46 RELIGIOUS_FND_DATE TIMESTAMP(6)    
47 RELIGIOUS_FOUNDATI VARCHAR2(3)    
48 RESIDENCE VARCHAR2(1)    
49 RESIDENCE_CHANGE_D TIMESTAMP(6)    
50 RUN_TIME TIMESTAMP(6)    
51 SEX VARCHAR2(1)    
52 SF_CREATE_DATE TIMESTAMP(6)    
53 SPECIAL_CHAR_IND VARCHAR2(1)    
54 SSN VARCHAR2(9) Y  
55 STUDENT_ACCESS_LOC VARCHAR2(1)    
56 STUDENT_CIT_CHANGE TIMESTAMP(6)    
57 STUDENT_CITIZENSHI VARCHAR2(1)    
58 STUDENT_ETHNIC VARCHAR2(1)    
59 SUFFIX VARCHAR2(10)    
60 TERMINATION_TERM VARCHAR2(4) Y  
61 VALIDATION_STATUS VARCHAR2(1)    
62 VETERAN_DISCHARGE TIMESTAMP(6)    
63 VETERAN_IND VARCHAR2(1)    
64 TYPE_CODE VARCHAR2(15)    
65 START_DATE TIMESTAMP(6)    
66 STOP_DATE TIMESTAMP(6)    
67 DIST_VALUE VARCHAR2(15)    

 

 

Views

---------- View STU_DEMO_ENCUMB ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DEMO_ID VARCHAR2(16) Y  
2 ADDRESS_REVIEW_DAT TIMESTAMP(6)    
3 BIRTH_DATE TIMESTAMP(6)    
4 BLOOD_DONOR VARCHAR2(1)    
5 BLOOD_DONOR_DATE TIMESTAMP(6)    
6 COLLEGE VARCHAR2(2)    
7 CURRENT_FULL_NAME VARCHAR2(40) Y  
8 CURRICULUM VARCHAR2(4)    
9 DECEASED_DATE TIMESTAMP(6)    
10 EFFECTIVE_DATE TIMESTAMP(6)    
11 EMAIL_ADDR VARCHAR2(17) Y  
12 ENROLLMENT_PATTERN VARCHAR2(1)    
13 ENROLLMENT_STATUS VARCHAR2(1) Y  
14 ENTERING_DATE_UI TIMESTAMP(6)    
15 EXPECTED_DEGREE VARCHAR2(5)    
16 EXPECTED_DEGREE_DA TIMESTAMP(6)    
17 EXTRACT_TIME TIMESTAMP(6)    
18 FAT_CHANGE_DATE TIMESTAMP(6)    
19 FAT_CHANGED_BY VARCHAR2(8)    
20 FERPA_ED_DATE TIMESTAMP(6)    
21 FERPA_ST_DATE TIMESTAMP(6)    
22 FERPA_TYPE VARCHAR2(20)    
23 FIRST_NAME VARCHAR2(30) Y  
24 FIRST_TERM_DATE TIMESTAMP(6)    
25 FIRST_TERM_TYPE VARCHAR2(2) Y  
26 FIRST_TERM_YEAR VARCHAR2(4) Y  
27 FRGN_STUD_SUPPORT VARCHAR2(1)    
28 FULL_NAME_UPPER_CA VARCHAR2(40)    
29 GED_TEST_IND VARCHAR2(1)    
30 I_CARD_NUMBER VARCHAR2(9)    
31 JR_COLLEGE_CODE VARCHAR2(2)    
32 LAST_AUTH_DATE TIMESTAMP(6)    
33 LAST_AUTH_LOCK VARCHAR2(1)    
34 LAST_NAME VARCHAR2(30) Y  
35 LAST_TERM_DATE TIMESTAMP(6)    
36 LAST_TERM_TYPE VARCHAR2(2) Y  
37 LAST_TERM_YEAR VARCHAR2(4) Y  
38 MIDDLE_NAME VARCHAR2(35)    
39 NETWORK_ID VARCHAR2(8)    
40 PERS_CONTINENT VARCHAR2(2)    
41 PERS_COUNTRY VARCHAR2(3)    
42 PERS_COUNTY VARCHAR2(3)    
43 PERS_STATE VARCHAR2(2)    
44 PERSON_ID VARCHAR2(16)    
45 PREVIOUS_INDICATOR VARCHAR2(1)    
46 RELIGIOUS_FND_DATE TIMESTAMP(6)    
47 RELIGIOUS_FOUNDATI VARCHAR2(3)    
48 RESIDENCE VARCHAR2(1)    
49 RESIDENCE_CHANGE_D TIMESTAMP(6)    
50 RUN_TIME TIMESTAMP(6)    
51 SEX VARCHAR2(1)    
52 SF_CREATE_DATE TIMESTAMP(6)    
53 SPECIAL_CHAR_IND VARCHAR2(1)    
54 SSN VARCHAR2(9) Y  
55 STUDENT_ACCESS_LOC VARCHAR2(1)    
56 STUDENT_CIT_CHANGE TIMESTAMP(6)    
57 STUDENT_CITIZENSHI VARCHAR2(1)    
58 STUDENT_ETHNIC VARCHAR2(1)    
59 SUFFIX VARCHAR2(10)    
60 TERMINATION_TERM VARCHAR2(4) Y  
61 VALIDATION_STATUS VARCHAR2(1)    
62 VETERAN_DISCHARGE TIMESTAMP(6)    
63 VETERAN_IND VARCHAR2(1)    
64 ENC_AMOUNT NUMBER(7,2)    
65 ENC_CAMPUS VARCHAR2(1)    
66 ENC_CLEARED_BY VARCHAR2(8)    
67 ENC_CLEARED_DATE TIMESTAMP(6)    
68 ENC_COLLEGE VARCHAR2(2)    
69 ENC_DATE_ENTERED TIMESTAMP(6)    
70 ENC_DEPARTMENT VARCHAR2(4)    
71 ENC_DESCRIPTION VARCHAR2(70)    
72 ENC_EFFECTIVE_DATE TIMESTAMP(6)    
73 ENC_SET_BY VARCHAR2(8)    

 

 

Views

---------- View STU_TERM_DIST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TERM_ID VARCHAR2(16) Y  
2 ADVISOR_SSN_1 VARCHAR2(9)    
3 ADVISOR_SSN_2 VARCHAR2(9)    
4 ANCILLARY_CSWK_1 VARCHAR2(4)    
5 ANCILLARY_CSWK_2 VARCHAR2(4)    
6 ASSISTANTSHIP_PEND VARCHAR2(1)    
7 AUTHORIZATION_CONT VARCHAR2(1)    
8 AUTHORIZATION_DATE TIMESTAMP(6)    
9 AUTHORIZATION_SOUR VARCHAR2(1)    
10 CAMPUS VARCHAR2(1)    
11 CATALOG_YEAR_1 VARCHAR2(4)    
12 CATALOG_YEAR_2 VARCHAR2(4)    
13 CLASS_CODE VARCHAR2(1)    
14 CODE_FIN VARCHAR2(2)    
15 CODE_INI VARCHAR2(2)    
16 COLL_ENR_CATEGORY VARCHAR2(1)    
17 COLLEGE VARCHAR2(2)    
18 COLLEGE_FIN VARCHAR2(2)    
19 COLLEGE_INI VARCHAR2(2)    
20 CR_NC_HOURS NUMBER(5,2)    
21 CR_NC_UNITS NUMBER(5,2)    
22 CURRICULUM VARCHAR2(4)    
23 CURRICULUM_FIN VARCHAR2(4)    
24 CURRICULUM_INI VARCHAR2(4)    
25 DARS_COLL_OPT_2 VARCHAR2(2)    
26 DARS_CURR_OPT_2 VARCHAR2(4)    
27 DARS_OPTION_ID_2 VARCHAR2(2)    
28 DARS_OPTION_1 VARCHAR2(2)    
29 DEANS_LIST_IND VARCHAR2(1)    
30 EARNED_HOURS NUMBER(5,2)    
31 EARNED_UNITS NUMBER(5,2)    
32 EFFECTIVE_DATE_FIN TIMESTAMP(6)    
33 EFFECTIVE_DATE_INI TIMESTAMP(6)    
34 ENCUMBRANCE_OVERRI VARCHAR2(1)    
35 ENROLLMENT_STATUS VARCHAR2(1) Y  
36 EXTRACT_TIME TIMESTAMP(6)    
37 GRADED_HOURS NUMBER(5,2)    
38 GRADED_POINTS_HOUR NUMBER(5,2)    
39 GRADED_POINTS_UNIT NUMBER(5,2)    
40 GRADED_UNITS NUMBER(5,2)    
41 INITIAL_ACCESS_DAT TIMESTAMP(6)    
42 INITIAL_ACCESS_TIM VARCHAR2(8)    
43 JAMES_SCHOLAR_IND VARCHAR2(1)    
44 JOINT_PROGRAM VARCHAR2(2)    
45 NEW_STATUS VARCHAR2(1)    
46 NOMINAL_HOURS NUMBER(5,2)    
47 NOMINAL_UNITS NUMBER(5,2)    
48 OFF_CAMPUS_ACAD_YE VARCHAR2(1)    
49 OFF_CAMPUS_PROGRAM VARCHAR2(2)    
50 OVERLOAD_HOURS NUMBER(4,2)    
51 PENDING_HOURS NUMBER(5,2)    
52 PENDING_UNITS NUMBER(5,2)    
53 PREPROF_INTEREST_1 VARCHAR2(3)    
54 PREPROF_INTEREST_2 VARCHAR2(3)    
55 PREV_CAMPUS VARCHAR2(1)    
56 PREV_COLLEGE VARCHAR2(2)    
57 PREV_CURRICULUM VARCHAR2(4)    
58 PREV_JOINT_PROGRAM VARCHAR2(2)    
59 PREV_SEQUENCE_NUMR NUMBER(5)    
60 PREV_SUBSPECIALTY VARCHAR2(2)    
61 PRO_LEVEL_FIN NUMBER(5,3)    
62 PRO_LEVEL_INI NUMBER(5,3)    
63 REGISTRATION_DATE TIMESTAMP(6)    
64 REGISTRATION_TERMI TIMESTAMP(6)    
65 RESIDENCE VARCHAR2(1)    
66 RUN_TIME TIMESTAMP(6)    
67 SEQUENCE_NUMBER NUMBER(5)    
68 SOURCE_FIN VARCHAR2(1)    
69 SOURCE_INI VARCHAR2(1)    
70 SSN VARCHAR2(9) Y  
71 STATUS_FIN VARCHAR2(1)    
72 STATUS_INI VARCHAR2(1)    
73 STU_DEMO_ID VARCHAR2(16) Y  
74 SUBSPECIALTY VARCHAR2(2)    
75 TERM_END_DATE TIMESTAMP(6)    
76 TERM_ID VARCHAR2(16) Y  
77 TERM_START_DATE TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_YEAR VARCHAR2(4) Y  
80 UNDERLOAD_HOURS NUMBER(5,2)    
81 VEHICLE_REGISTRATI VARCHAR2(1)    
82 VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DATE TIMESTAMP(6)    
84 DIST_VALUE VARCHAR2(15)    
85 START_DATE TIMESTAMP(6)    
86 STOP_DATE TIMESTAMP(6)    
87 TYPE_CODE VARCHAR2(15)    

 

 

Views

---------- View VACE_STU_CAD ----------

Col # Column Name Data Type Not Null? Comments
1 CAD_TYPE VARCHAR2(2)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 CAD_MOD_DT TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_CAD_ID VARCHAR2(16) Y  
6 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View VACE_STU_CAD_DTL ----------

Col # Column Name Data Type Not Null? Comments
1 CAD_DTL_CRDT_TYPE VARCHAR2(1)    
2 CAD_DTL_CRDT_CATGRY VARCHAR2(2)    
3 CAD_DTL_EARN_CRDT NUMBER(9,5)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 CAD_DTL_GRD_CRDT NUMBER(9,5)    
6 CAD_DTL_GRD_PT NUMBER(9,5)    
7 CAD_DTL_NOM_CRDT NUMBER(9,5)    
8 RUN_TIME TIMESTAMP(6)    
9 STU_CAD_DTL_ID VARCHAR2(16) Y  
10 STU_CAD_ID VARCHAR2(16)    

 

 

Views

---------- View VACE_STU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 CRS_CRDT_NOCRDT_IND VARCHAR2(1)    
2 CRS_CRDT_TYPE VARCHAR2(1)    
3 CRS_DEPT_CD VARCHAR2(5)    
4 CRS_DROP_DT TIMESTAMP(6)    
5 CRS_DROP_EFF_DT TIMESTAMP(6)    
6 CRS_DROP_TYPE VARCHAR2(10)    
7 CRS_DROP_SRC VARCHAR2(8)    
8 CRS_DUPL_CD VARCHAR2(1)    
9 GRD_BY_RULE_IND VARCHAR2(1)    
10 CRS_EARN_CRDT NUMBER(5,2)    
11 CRS_END_DT TIMESTAMP(6)    
12 CRS_ENRL_DT TIMESTAMP(6)    
13 EXCUSE_GRD_EXPIR_DT TIMESTAMP(6)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 CRS_GRD VARCHAR2(2)    
16 CRS_GRD_CRDT NUMBER(5,2)    
17 CRS_GRD_SECT_ITYPE VARCHAR2(10) Y  
18 CRS_GRD_SECT_NAME VARCHAR2(3) Y  
19 CRS_HNR_CD VARCHAR2(1)    
20 CRS_NOM_CRDT NUMBER(4,2)    
21 CRS_NBR VARCHAR2(3)    
22 CRS_NBR_XM_PREFIX VARCHAR2(1)    
23 CRS_ORIG_GRD_SECT_NAME VARCHAR2(3)    
24 CRS_CRDT_NOCRDT_GRD VARCHAR2(2)    
25 CRS_PREV_GRD_IND VARCHAR2(1)    
26 CRS_RELIG_FNDTN_IND VARCHAR2(1)    
27 CRS_REMEDIAL_IND VARCHAR2(1)    
28 CRS_RUBRIC VARCHAR2(5) Y  
29 RUN_TIME TIMESTAMP(6)    
30 CRS_SPCL_ACT_COLL_CD VARCHAR2(2)    
31 SSN VARCHAR2(9) Y  
32 CRS_START_DT TIMESTAMP(6)    
33 STU_CRS_ID VARCHAR2(16) Y  
34 STU_TERM_ID VARCHAR2(16) Y  
35 CRS_NON_BACCL_IND VARCHAR2(1)    
36 CRS_TERM_END_DT TIMESTAMP(6)    
37 CRS_TERM_TYPE VARCHAR2(2) Y  
38 CRS_TERMYR VARCHAR2(4) Y  
39 CRS_TITLE VARCHAR2(20)    
40 CRS_TRNSCPT_NOPOST_IND VARCHAR2(1)    
41 CRS_VISITOR_IND VARCHAR2(1)    
42 CRS_WITHDRAW_IND VARCHAR2(1)    
43 CRS_YRTERM VARCHAR2(4) Y  

 

 

Views

---------- View VACE_STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 DEMO_ADDR_REVW_DT TIMESTAMP(6)    
2 BIRTH_DT TIMESTAMP(6)    
3 BLOOD_DONOR_CD VARCHAR2(1)    
4 BLOOD_DONOR_DT TIMESTAMP(6)    
5 LAST_REG_TERM_COLL_CD VARCHAR2(2)    
6 FULL_NAME_LFMS VARCHAR2(40) Y  
7 LAST_REG_TERM_CURR_CD VARCHAR2(4)    
8 DECEASE_DT TIMESTAMP(6)    
9 FULL_NAME_EFF_DT TIMESTAMP(6)    
10 EMAIL_ADDR VARCHAR2(17) Y  
11 ENRL_PATTN VARCHAR2(1)    
12 LAST_REG_TERM_ENRL_STAT VARCHAR2(1) Y  
13 UI_ENTR_DT TIMESTAMP(6)    
14 EXPCT_DEG_CD VARCHAR2(5)    
15 EXPCT_DEG_DT TIMESTAMP(6)    
16 EXTRACT_TIME TIMESTAMP(6)    
17 FAT_CHG_DT TIMESTAMP(6)    
18 FAT_CHG_SRC VARCHAR2(8)    
19 FERPA_UNLIST_END_DT TIMESTAMP(6)    
20 FERPA_UNLIST_START_DT TIMESTAMP(6)    
21 FERPA_TYPE VARCHAR2(20)    
22 FNAME VARCHAR2(30) Y  
23 FIRST_REG_TERM_DT TIMESTAMP(6)    
24 FIRST_REG_TERM_TYPE VARCHAR2(2) Y  
25 FIRST_REG_TERMYR VARCHAR2(4) Y  
26 FRGN_STU_SUPP_CD VARCHAR2(1)    
27 FULL_NAME_LFMS_UPPER VARCHAR2(40)    
28 GED_TEST_IND VARCHAR2(1)    
29 ID_CARD_NBR VARCHAR2(9)    
30 LAST_INST_ATTND_CD VARCHAR2(2)    
31 LAST_TERM_AUTH_DT TIMESTAMP(6)    
32 LAST_TERM_AUTH_LOCK_IND VARCHAR2(1)    
33 LNAME VARCHAR2(30) Y  
34 LAST_REG_TERM_DT TIMESTAMP(6)    
35 LAST_REG_TERM_TYPE VARCHAR2(2) Y  
36 LAST_REG_TERMYR VARCHAR2(4) Y  
37 MNAME VARCHAR2(35)    
38 NTWRK_ID VARCHAR2(8)    
39 CONTINT_ADM_CD VARCHAR2(2)    
40 NBR_CNTRY_ADM_CD VARCHAR2(3)    
41 CNTY_ADM_CD VARCHAR2(3)    
42 ST_ADM_CD VARCHAR2(2)    
43 PERS_ID VARCHAR2(16)    
44 PREV_FULL_NAME_IND VARCHAR2(1)    
45 RELIG_FNDTN_DT TIMESTAMP(6)    
46 RELIG_FNDTN_CD VARCHAR2(3)    
47 RES_IND VARCHAR2(1)    
48 RES_CHG_DT TIMESTAMP(6)    
49 RUN_TIME TIMESTAMP(6)    
50 SEX_CD VARCHAR2(1)    
51 FERPA_CRE_DT TIMESTAMP(6)    
52 FULL_NAME_SPCL_CHAR_IND VARCHAR2(1)    
53 SSN VARCHAR2(9) Y  
54 STU_DEMO_ID VARCHAR2(16) Y  
55 ACS_LOCK_IND VARCHAR2(1)    
56 CITZN_CHG_DT TIMESTAMP(6)    
57 CITZN_CD VARCHAR2(1)    
58 ETHNIC_CD VARCHAR2(1)    
59 SNAME VARCHAR2(10)    
60 FAT_TERMYR VARCHAR2(4) Y  
61 VLD_STAT_CD VARCHAR2(1)    
62 VET_DISCHRG_DT TIMESTAMP(6)    
63 VET_IND VARCHAR2(1)    

 

 

Views

---------- View VACE_STU_GDOL ----------

Col # Column Name Data Type Not Null? Comments
1 GDOL_COLL_CD VARCHAR2(2)    
2 GDOL_CURR_CD VARCHAR2(4)    
3 GDOL_CHG_DT TIMESTAMP(6)    
4 GDOL_TERMN_DT TIMESTAMP(6)    
5 DOCTL_EVAL_CD VARCHAR2(1)    
6 GDOL_EFF_DT TIMESTAMP(6)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 FELWSHP_CUM_SEM_TOT NUMBER(5)    
9 GRAD_DEG_LVL_CD VARCHAR2(1)    
10 GRAD_DEG_OBJ_CD VARCHAR2(1)    
11 RUN_TIME TIMESTAMP(6)    
12 STU_DEMO_ID VARCHAR2(16)    
13 STU_GDOL_ID VARCHAR2(16) Y  
14 THESIS_ADVSR VARCHAR2(20)    
15 THESIS_CUM_UNIT NUMBER(5,2)    
16 THESIS_DEPOSIT_DT TIMESTAMP(6)    

 

 

Views

---------- View VACE_STU_GRAD_DATA ----------

Col # Column Name Data Type Not Null? Comments
1 GRAD_ENTR_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 STU_DEMO_ID VARCHAR2(16)    
5 STU_GRAD_DATA_ID VARCHAR2(16) Y  

 

 

Views

---------- View VACE_STU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_DARS_ADVSR1_SSN VARCHAR2(9)    
2 TERM_DARS_ADVSR2_SSN VARCHAR2(9)    
3 TERM_DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 TERM_DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 PND_ASSTSHP_CD VARCHAR2(1)    
6 AUTH_CNTL_CD VARCHAR2(1)    
7 AUTH_DT TIMESTAMP(6)    
8 AUTH_SRC_CD VARCHAR2(1)    
9 TERM_CAMPUS_CD VARCHAR2(1)    
10 TERM_DARS_CATLG1_TERMYR VARCHAR2(4)    
11 TERM_DARS_CATLG2_TERMYR VARCHAR2(4)    
12 TERM_CLASS_CD VARCHAR2(1)    
13 FNL_PRODROP_CD VARCHAR2(2)    
14 INIT_PRODROP_CD VARCHAR2(2)    
15 COLL_ENRL_CATGRY VARCHAR2(1)    
16 TERM_COLL_CD VARCHAR2(2)    
17 FNL_PRODROP_COLL_CD VARCHAR2(2)    
18 INIT_PRODROP_COLL_CD VARCHAR2(2)    
19 TERM_CRDT_NOCRDT_HOUR NUMBER(5,2)    
20 TERM_CRDT_NOCRDT_UNIT NUMBER(5,2)    
21 TERM_CURR_CD VARCHAR2(4)    
22 FNL_PRODROP_CURR_CD VARCHAR2(4)    
23 INIT_PRODROP_CURR_CD VARCHAR2(4)    
24 TERM_DARS_COLL2_CD VARCHAR2(2)    
25 TERM_DARS_CURR2_CD VARCHAR2(4)    
26 TERM_DARS_SUBSPCL1_CD VARCHAR2(2)    
27 TERM_DARS_SUBSPCL2_CD VARCHAR2(2)    
28 DEANS_LIST_CD VARCHAR2(1)    
29 TERM_EARN_HOUR NUMBER(5,2)    
30 TERM_EARN_UNIT NUMBER(5,2)    
31 FNL_PRODROP_EFF_DT TIMESTAMP(6)    
32 INIT_PRODROP_EFF_DT TIMESTAMP(6)    
33 ENC_OVRIDE_IND VARCHAR2(1)    
34 TERM_ENRL_STAT VARCHAR2(1) Y  
35 EXTRACT_TIME TIMESTAMP(6)    
36 TERM_GRD_HOUR NUMBER(5,2)    
37 TERM_GRD_HOUR_PT NUMBER(5,2)    
38 TERM_GRD_UNIT_PT NUMBER(5,2)    
39 TERM_GRD_UNIT NUMBER(5,2)    
40 INIT_REG_SYS_ACS_DT TIMESTAMP(6)    
41 INIT_REG_SYS_ACS_TIME VARCHAR2(8)    
42 JAMES_SCHLR_IND VARCHAR2(1)    
43 TERM_JOINT_PGM_CD VARCHAR2(2)    
44 NEW_STAT VARCHAR2(1)    
45 TERM_NOM_HOUR NUMBER(5,2)    
46 TERM_NOM_UNIT NUMBER(5,2)    
47 OFF_CAMPUS_WORK_POST_IND VARCHAR2(1)    
48 OFF_CAMPUS_PGM_CD VARCHAR2(2)    
49 TERM_OVRLD_HOUR NUMBER(4,2)    
50 TERM_PND_HOUR NUMBER(5,2)    
51 TERM_PND_UNIT NUMBER(5,2)    
52 TERM_DARS_PPINTRST1_CD VARCHAR2(3)    
53 TERM_DARS_PPINTRST2_CD VARCHAR2(3)    
54 PREV_TERM_CAMPUS_CD VARCHAR2(1)    
55 PREV_TERM_COLL_CD VARCHAR2(2)    
56 PREV_TERM_CURR_CD VARCHAR2(4)    
57 PREV_TERM_JOINT_PGM_CD VARCHAR2(2)    
58 PREV_TERM_SEQ_NBR NUMBER(5)    
59 PREV_TERM_SUBSPCL_CD VARCHAR2(2)    
60 FNL_PRODROP_LVL_GPA NUMBER(5,3)    
61 INIT_PRODROP_LVL_GPA NUMBER(5,3)    
62 TERM_REG_DT TIMESTAMP(6)    
63 TERM_REG_TERMN_DT TIMESTAMP(6)    
64 TERM_RES_IND VARCHAR2(1)    
65 RUN_TIME TIMESTAMP(6)    
66 TERM_SEQ_NBR NUMBER(5)    
67 FNL_PRODROP_SRC_CD VARCHAR2(1)    
68 INIT_PRODROP_SRC_CD VARCHAR2(1)    
69 SSN VARCHAR2(9) Y  
70 FNL_PRODROP_STAT_CD VARCHAR2(1)    
71 INIT_PRODROP_STAT_CD VARCHAR2(1)    
72 STU_DEMO_ID VARCHAR2(16) Y  
73 STU_TERM_ID VARCHAR2(16) Y  
74 TERM_SUBSPCL_CD VARCHAR2(2)    
75 TERM_END_DT TIMESTAMP(6)    
76 DEFN_TERM_ID VARCHAR2(16) Y  
77 TERM_START_DT TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_TERMYR VARCHAR2(4) Y  
80 TERM_UNDLD_HOUR NUMBER(5,2)    
81 VEH_REG_IND VARCHAR2(1)    
82 TERM_VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DT TIMESTAMP(6)    

 

 

Views

---------- View VALUM_ASSOC_REG_SENIOR_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DEMO_ID VARCHAR2(16) Y  
2 TERM_COLL_CD VARCHAR2(2)    
3 TERM_TERMYR VARCHAR2(4) Y  
4 SSN VARCHAR2(9) Y  

 

 

Views

---------- View VALUM_ASSOC_STU_AWD_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 AWD_DEG_TYPE VARCHAR2(1)    
2 AWD_DEG_ABBREV VARCHAR2(5)    
3 AWD_DEG_DT TIMESTAMP(6)    
4 AWD_DEG_COLL1_CD VARCHAR2(2)    
5 AWD_DEG_CURR1_CD VARCHAR2(4)    
6 AWD_DEG_COLL1_HNR_CD VARCHAR2(1)    
7 AWD_DEG_CURR1_HNR_CD VARCHAR2(1)    
8 AWD_DEG_CURR2_CD VARCHAR2(4)    
9 AWD_DEG_CURR2_HNR_CD VARCHAR2(1)    
10 AWD_DEG_CURR3_CD VARCHAR2(4)    
11 AWD_DEG_CURR3_HNR_CD VARCHAR2(1)    
12 STU_DEMO_ID VARCHAR2(16)    
13 SSN VARCHAR2(9) Y  

 

 

Views

---------- View VALUM_ASSOC_STU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 ADDR_STREET1 VARCHAR2(30)    
2 ADDR_STREET2 VARCHAR2(30)    
3 ADDR_CITY VARCHAR2(15)    
4 ADDR_ST_CD VARCHAR2(2) Y  
5 ADDR_ZIP_CD VARCHAR2(9)    
6 ADDR_ALPHA_CNTRY_CD VARCHAR2(3)    
7 ADDR_MC VARCHAR2(6)    
8 ADDR_PHONE_NBR VARCHAR2(25)    
9 ADDR_EFF_DT TIMESTAMP(6)    
10 ADDR_TYPE VARCHAR2(10) Y  
11 STU_DEMO_ID VARCHAR2(16)    
12 SSN VARCHAR2(9) Y  

 

 

Views

---------- View VALUM_ASSOC_STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 ID_CARD_NBR VARCHAR2(9)    
2 FNAME VARCHAR2(30) Y  
3 MNAME VARCHAR2(35)    
4 LNAME VARCHAR2(30) Y  
5 SNAME VARCHAR2(10)    
6 PREV_FULL_NAME_IND VARCHAR2(1)    
7 FERPA_TYPE VARCHAR2(20)    
8 SEX_CD VARCHAR2(1)    
9 EMAIL_ADDR VARCHAR2(17) Y  
10 BIRTH_DT TIMESTAMP(6)    
11 DECEASE_DT TIMESTAMP(6)    
12 STU_DEMO_ID VARCHAR2(16) Y  
13 SSN VARCHAR2(9) Y  

 

 

Views

---------- View VALUM_ASSOC_STU_PND_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 PND_DEG_STAT VARCHAR2(1)    
2 PND_DEG_ABBREV VARCHAR2(5)    
3 PND_DEG_PERD_DT TIMESTAMP(6)    
4 PND_DEG_COLL1_CD VARCHAR2(2)    
5 PND_DEG_CURR1_CD VARCHAR2(4)    
6 PND_DEG_COLL1_HNR_CD VARCHAR2(1)    
7 PND_DEG_CURR1_HNR_CD VARCHAR2(1)    
8 PND_DEG_COLL2_CD VARCHAR2(2)    
9 PND_DEG_CURR2_CD VARCHAR2(4)    
10 PND_DEG_CURR2_HNR_CD VARCHAR2(1)    
11 PND_DEG_COLL3_CD VARCHAR2(2)    
12 PND_DEG_CURR3_CD VARCHAR2(4)    
13 PND_DEG_CURR3_HNR_CD VARCHAR2(1)    
14 STU_DEMO_ID VARCHAR2(16)    
15 SSN VARCHAR2(9) Y  

 

 

Views

---------- View VDEFN_ENC ----------

Col # Column Name Data Type Not Null? Comments
1 ENC_CNTCT1_INFO VARCHAR2(25)    
2 ENC_CNTCT2_INFO VARCHAR2(40)    
3 ENC_CNTCT3_INFO VARCHAR2(40)    
4 ENC_CNTCT4_INFO VARCHAR2(40)    
5 DEFN_ENC_ID VARCHAR2(16) Y  
6 ENC_CD VARCHAR2(8)    
7 ENC_NAME VARCHAR2(30)    
8 ENC_TYPE VARCHAR2(10)    
9 EXTRACT_TIME TIMESTAMP(6)    
10 RUN_TIME TIMESTAMP(6)    

 

 

Views

---------- View VDEFN_HS_INST ----------

Col # Column Name Data Type Not Null? Comments
1 HS_INST_ACCRED_CD VARCHAR2(1)    
2 HS_INST_AP_CD VARCHAR2(1)    
3 HS_INST_BLDG_CD VARCHAR2(5)    
4 HS_INST_BLDG_RM_NBR VARCHAR2(10)    
5 HS_INST_CHG_REAS_CD VARCHAR2(10)    
6 HS_INST_ADDR_CITY VARCHAR2(20)    
7 HS_INST_CLASS_SIZE VARCHAR2(4)    
8 HS_INST_COMNTY_COLL_CD VARCHAR2(10)    
9 HS_INST_CNTCT_NAME VARCHAR2(20)    
10 HS_INST_ADDR_ALPHA_CNTRY_CD VARCHAR2(3)    
11 HS_INST_ADDR_CNTY_CD VARCHAR2(3)    
12 HS_INST_ADDR_CNTY_NAME VARCHAR2(80)    
13 HS_INST_EFF_DT TIMESTAMP(6)    
14 HS_INST_END_DT TIMESTAMP(6)    
15 EXTRACT_TIME TIMESTAMP(6)    
16 HS_INST_HNR_CRS_IND VARCHAR2(1)    
17 HS_INST_CD VARCHAR2(6) Y  
18 HS_INST_ADDR_TYPE VARCHAR2(10) Y  
19 HS_INST_NAME VARCHAR2(40)    
20 HS_INST_NAME_UPPER VARCHAR2(40)    
21 HS_INST_ADDR_STREET2 VARCHAR2(30)    
22 HS_INST_ADDR_STREET3 VARCHAR2(30)    
23 HS_INST_ADDR_MC VARCHAR2(6)    
24 HS_INST_ADDR_PHONE_NBR VARCHAR2(20)    
25 HS_INST_RANK_EXCPT_CD VARCHAR2(1)    
26 RUN_TIME TIMESTAMP(6)    
27 HS_INST_SEM_BASIS_CD VARCHAR2(1)    
28 HS_INST_MAIL_SIZE_CD VARCHAR2(1)    
29 HS_INST_SPCL_REVW_CD VARCHAR2(1)    
30 HS_INST_START_DT TIMESTAMP(6)    
31 HS_INST_ADDR_ST_CD VARCHAR2(2)    
32 HS_INST_ADDR_STREET1 VARCHAR2(30) Y  
33 DEFN_HS_INST_ID VARCHAR2(16) Y  
34 HS_INST_TERMN_REAS_CD VARCHAR2(20)    
35 HS_INST_CLASS_CD VARCHAR2(1)    
36 HS_INST_WGT_RANK_CD VARCHAR2(1)    
37 HS_INST_ADDR_ZIP_CD VARCHAR2(9)    

 

 

Views

---------- View VDEFN_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 DEFN_TERM_CAMPUS_CD VARCHAR2(1) Y  
2 DEFN_TERM_END_DT TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 LAST_CLASS_DT TIMESTAMP(6)    
5 MISSG_GRD_DT TIMESTAMP(6)    
6 MISSG_LAW_GRD_DT TIMESTAMP(6)    
7 DEFN_TERM_NAME_ABBREV VARCHAR2(10)    
8 OK_ADD_DROP_CD VARCHAR2(1)    
9 OK_ADV_ENRL_CD VARCHAR2(1)    
10 RUN_TIME TIMESTAMP(6)    
11 DEFN_TERM_START_DT TIMESTAMP(6)    
12 DEFN_TERM_ID VARCHAR2(16) Y  
13 DEFN_TERM_TERM_TYPE VARCHAR2(10) Y  
14 DEFN_TERM_TERMYR VARCHAR2(4) Y  
15 DEFN_TERM_TRNSCPT_TEXT VARCHAR2(20)    
16 DEFN_TERM_ASSOC_YR NUMBER(5)    

 

 

Views

---------- View VDEFN_TFER_INST ----------

Col # Column Name Data Type Not Null? Comments
1 TFER_INST_ACCRED_CD VARCHAR2(1)    
2 TFER_INST_CALC_GPA_IND VARCHAR2(1)    
3 TFER_INST_CLOSE_REAS_CD VARCHAR2(1)    
4 TFER_INST_FICE_CD VARCHAR2(6) Y  
5 TFER_INST_ALPHA_CNTRY_CD VARCHAR2(10)    
6 TFER_INST_END_DT TIMESTAMP(6)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 TFER_INST_NAME_UPPER VARCHAR2(30)    
9 TFER_INST_LIA_CD VARCHAR2(2)    
10 TFER_INST_NAME VARCHAR2(30)    
11 TFER_INST_NAME_65CHAR VARCHAR2(65)    
12 RUN_TIME TIMESTAMP(6)    
13 TFER_INST_SEM_QTR_CD VARCHAR2(1)    
14 TFER_INST_START_DT TIMESTAMP(6)    
15 TFER_INST_ST_CD VARCHAR2(2)    
16 DEFN_TFER_INST_ID VARCHAR2(16) Y  

 

 

Views

---------- View VPERS_ID_CARD ----------

Col # Column Name Data Type Not Null? Comments
1 ID_CARD_CREATE_DT TIMESTAMP(6)    
2 ID_CARD_CREATE_TIME VARCHAR2(8)    
3 ID_CARD_CREATE_SRC VARCHAR2(8)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ID_CARD_NBR VARCHAR2(9)    
6 PERS_ID VARCHAR2(16)    
7 PERS_ID_CARD_NBR_ID VARCHAR2(16) Y  
8 PREV_ID_CARD_NBR_IND VARCHAR2(1)    
9 RUN_TIME TIMESTAMP(6)    
10 ID_CARD_UPDT_TIME VARCHAR2(8)    
11 ID_CARD_UPDT_DT TIMESTAMP(6)    
12 ID_CARD_UPDT_SRC VARCHAR2(8)    

 

 

Views

---------- View VPHYCS_ENG_UGRAD_PERS_ID_CARD ----------

Col # Column Name Data Type Not Null? Comments
1 ID_CARD_CREATE_DT TIMESTAMP(6)    
2 ID_CARD_CREATE_TIME VARCHAR2(8)    
3 ID_CARD_CREATE_SRC VARCHAR2(8)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ID_CARD_NBR VARCHAR2(9)    
6 PERS_ID VARCHAR2(16)    
7 PERS_ID_CARD_NBR_ID VARCHAR2(16) Y  
8 PREV_ID_CARD_NBR_IND VARCHAR2(1)    
9 RUN_TIME TIMESTAMP(6)    
10 ID_CARD_UPDT_TIME VARCHAR2(8)    
11 ID_CARD_UPDT_DT TIMESTAMP(6)    
12 ID_CARD_UPDT_SRC VARCHAR2(8)    

 

 

Views

---------- View VPHYCS_ENG_UGRAD_STU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 CRS_CRDT_NOCRDT_IND VARCHAR2(1)    
2 CRS_CRDT_TYPE VARCHAR2(1)    
3 CRS_DEPT_CD VARCHAR2(5)    
4 CRS_DROP_DT TIMESTAMP(6)    
5 CRS_DROP_EFF_DT TIMESTAMP(6)    
6 CRS_DROP_TYPE VARCHAR2(10)    
7 CRS_DROP_SRC VARCHAR2(8)    
8 CRS_DUPL_CD VARCHAR2(1)    
9 GRD_BY_RULE_IND VARCHAR2(1)    
10 CRS_EARN_CRDT NUMBER(5,2)    
11 CRS_END_DT TIMESTAMP(6)    
12 CRS_ENRL_DT TIMESTAMP(6)    
13 EXCUSE_GRD_EXPIR_DT TIMESTAMP(6)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 CRS_GRD VARCHAR2(2)    
16 CRS_GRD_CRDT NUMBER(5,2)    
17 CRS_GRD_SECT_ITYPE VARCHAR2(10) Y  
18 CRS_GRD_SECT_NAME VARCHAR2(3) Y  
19 CRS_HNR_CD VARCHAR2(1)    
20 CRS_NOM_CRDT NUMBER(4,2)    
21 CRS_NBR VARCHAR2(3)    
22 CRS_NBR_XM_PREFIX VARCHAR2(1)    
23 CRS_ORIG_GRD_SECT_NAME VARCHAR2(3)    
24 CRS_CRDT_NOCRDT_GRD VARCHAR2(2)    
25 CRS_PREV_GRD_IND VARCHAR2(1)    
26 CRS_RELIG_FNDTN_IND VARCHAR2(1)    
27 CRS_REMEDIAL_IND VARCHAR2(1)    
28 CRS_RUBRIC VARCHAR2(5) Y  
29 RUN_TIME TIMESTAMP(6)    
30 CRS_SPCL_ACT_COLL_CD VARCHAR2(2)    
31 SSN VARCHAR2(9) Y  
32 CRS_START_DT TIMESTAMP(6)    
33 STU_CRS_ID VARCHAR2(16) Y  
34 STU_TERM_ID VARCHAR2(16) Y  
35 CRS_NON_BACCL_IND VARCHAR2(1)    
36 CRS_TERM_END_DT TIMESTAMP(6)    
37 CRS_TERM_TYPE VARCHAR2(2) Y  
38 CRS_TERMYR VARCHAR2(4) Y  
39 CRS_TITLE VARCHAR2(20)    
40 CRS_TRNSCPT_NOPOST_IND VARCHAR2(1)    
41 CRS_VISITOR_IND VARCHAR2(1)    
42 CRS_WITHDRAW_IND VARCHAR2(1)    
43 CRS_YRTERM VARCHAR2(4) Y  

 

 

Views

---------- View VPHYCS_ENG_UGRAD_STU_CRS_SECT ----------

Col # Column Name Data Type Not Null? Comments
1 SECT_ADD_SRC VARCHAR2(8)    
2 SECT_DROP_DT TIMESTAMP(6)    
3 SECT_DROP_TYPE VARCHAR2(10)    
4 SECT_DROP_SRC VARCHAR2(8)    
5 SECT_ENRL_DT TIMESTAMP(6)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 SECT_GRD_IND VARCHAR2(1) Y  
8 SECT_ITYPE VARCHAR2(10) Y  
9 RUN_TIME TIMESTAMP(6)    
10 SECT_NAME VARCHAR2(3) Y  
11 STU_CRS_ID VARCHAR2(16) Y  
12 STU_CRS_SECT_ID VARCHAR2(16) Y  
13 SECT_TERMYR VARCHAR2(4)    
14 SECT_WITHDRAW_IND VARCHAR2(1)    

 

 

Views

---------- View VPHYCS_ENG_UGRAD_STU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 ADDR_CITY VARCHAR2(15)    
2 ADDR_ALPHA_CNTRY_CD VARCHAR2(3)    
3 ADDR_EFF_DT TIMESTAMP(6)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ADDR_STREET2 VARCHAR2(30)    
6 ADDR_STREET3 VARCHAR2(30)    
7 ADDR_MC VARCHAR2(6)    
8 ADDR_PHONE_NBR VARCHAR2(25)    
9 RUN_TIME TIMESTAMP(6)    
10 ADDR_ST_CD VARCHAR2(2) Y  
11 ADDR_STREET1 VARCHAR2(30)    
12 STU_CUR_ADDR_ID VARCHAR2(16) Y  
13 ADDR_TYPE VARCHAR2(10) Y  
14 STU_DEMO_ID VARCHAR2(16)    
15 ADDR_ZIP_CD VARCHAR2(9)    

 

 

Views

---------- View VPHYCS_ENG_UGRAD_STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 DEMO_ADDR_REVW_DT TIMESTAMP(6)    
2 BIRTH_DT TIMESTAMP(6)    
3 BLOOD_DONOR_CD VARCHAR2(1)    
4 BLOOD_DONOR_DT TIMESTAMP(6)    
5 LAST_REG_TERM_COLL_CD VARCHAR2(2)    
6 FULL_NAME_LFMS VARCHAR2(40) Y  
7 LAST_REG_TERM_CURR_CD VARCHAR2(4)    
8 DECEASE_DT TIMESTAMP(6)    
9 FULL_NAME_EFF_DT TIMESTAMP(6)    
10 EMAIL_ADDR VARCHAR2(17) Y  
11 ENRL_PATTN VARCHAR2(1)    
12 LAST_REG_TERM_ENRL_STAT VARCHAR2(1) Y  
13 UI_ENTR_DT TIMESTAMP(6)    
14 EXPCT_DEG_CD VARCHAR2(5)    
15 EXPCT_DEG_DT TIMESTAMP(6)    
16 EXTRACT_TIME TIMESTAMP(6)    
17 FAT_CHG_DT TIMESTAMP(6)    
18 FAT_CHG_SRC VARCHAR2(8)    
19 FERPA_UNLIST_END_DT TIMESTAMP(6)    
20 FERPA_UNLIST_START_DT TIMESTAMP(6)    
21 FERPA_TYPE VARCHAR2(20)    
22 FNAME VARCHAR2(30) Y  
23 FIRST_REG_TERM_DT TIMESTAMP(6)    
24 FIRST_REG_TERM_TYPE VARCHAR2(2) Y  
25 FIRST_REG_TERMYR VARCHAR2(4) Y  
26 FRGN_STU_SUPP_CD VARCHAR2(1)    
27 FULL_NAME_LFMS_UPPER VARCHAR2(40)    
28 GED_TEST_IND VARCHAR2(1)    
29 ID_CARD_NBR VARCHAR2(9)    
30 LAST_INST_ATTND_CD VARCHAR2(2)    
31 LAST_TERM_AUTH_DT TIMESTAMP(6)    
32 LAST_TERM_AUTH_LOCK_IND VARCHAR2(1)    
33 LNAME VARCHAR2(30) Y  
34 LAST_REG_TERM_DT TIMESTAMP(6)    
35 LAST_REG_TERM_TYPE VARCHAR2(2) Y  
36 LAST_REG_TERMYR VARCHAR2(4) Y  
37 MNAME VARCHAR2(35)    
38 NTWRK_ID VARCHAR2(8)    
39 CONTINT_ADM_CD VARCHAR2(2)    
40 NBR_CNTRY_ADM_CD VARCHAR2(3)    
41 CNTY_ADM_CD VARCHAR2(3)    
42 ST_ADM_CD VARCHAR2(2)    
43 PERS_ID VARCHAR2(16)    
44 PREV_FULL_NAME_IND VARCHAR2(1)    
45 RELIG_FNDTN_DT TIMESTAMP(6)    
46 RELIG_FNDTN_CD VARCHAR2(3)    
47 RES_IND VARCHAR2(1)    
48 RES_CHG_DT TIMESTAMP(6)    
49 RUN_TIME TIMESTAMP(6)    
50 SEX_CD VARCHAR2(1)    
51 FERPA_CRE_DT TIMESTAMP(6)    
52 FULL_NAME_SPCL_CHAR_IND VARCHAR2(1)    
53 SSN VARCHAR2(9) Y  
54 STU_DEMO_ID VARCHAR2(16) Y  
55 ACS_LOCK_IND VARCHAR2(1)    
56 CITZN_CHG_DT TIMESTAMP(6)    
57 CITZN_CD VARCHAR2(1)    
58 ETHNIC_CD VARCHAR2(1)    
59 SNAME VARCHAR2(10)    
60 FAT_TERMYR VARCHAR2(4) Y  
61 VLD_STAT_CD VARCHAR2(1)    
62 VET_DISCHRG_DT TIMESTAMP(6)    
63 VET_IND VARCHAR2(1)    

 

 

Views

---------- View VPHYCS_ENG_UGRAD_STU_MIDSEM ----------

Col # Column Name Data Type Not Null? Comments
1 MIDSEM_GRD_CREATE_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 MIDSEM_GRD VARCHAR2(2)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_CRS_ID VARCHAR2(16)    
6 STU_MIDSEM_ID VARCHAR2(16) Y  
7 MIDSEM_GRD_UPDT_DT TIMESTAMP(6)    

 

 

Views

---------- View VPHYCS_ENG_UGRAD_STU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_DARS_ADVSR1_SSN VARCHAR2(9)    
2 TERM_DARS_ADVSR2_SSN VARCHAR2(9)    
3 TERM_DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 TERM_DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 PND_ASSTSHP_CD VARCHAR2(1)    
6 AUTH_CNTL_CD VARCHAR2(1)    
7 AUTH_DT TIMESTAMP(6)    
8 AUTH_SRC_CD VARCHAR2(1)    
9 TERM_CAMPUS_CD VARCHAR2(1)    
10 TERM_DARS_CATLG1_TERMYR VARCHAR2(4)    
11 TERM_DARS_CATLG2_TERMYR VARCHAR2(4)    
12 TERM_CLASS_CD VARCHAR2(1)    
13 FNL_PRODROP_CD VARCHAR2(2)    
14 INIT_PRODROP_CD VARCHAR2(2)    
15 COLL_ENRL_CATGRY VARCHAR2(1)    
16 TERM_COLL_CD VARCHAR2(2)    
17 FNL_PRODROP_COLL_CD VARCHAR2(2)    
18 INIT_PRODROP_COLL_CD VARCHAR2(2)    
19 TERM_CRDT_NOCRDT_HOUR NUMBER(5,2)    
20 TERM_CRDT_NOCRDT_UNIT NUMBER(5,2)    
21 TERM_CURR_CD VARCHAR2(4)    
22 FNL_PRODROP_CURR_CD VARCHAR2(4)    
23 INIT_PRODROP_CURR_CD VARCHAR2(4)    
24 TERM_DARS_COLL2_CD VARCHAR2(2)    
25 TERM_DARS_CURR2_CD VARCHAR2(4)    
26 TERM_DARS_SUBSPCL1_CD VARCHAR2(2)    
27 TERM_DARS_SUBSPCL2_CD VARCHAR2(2)    
28 DEANS_LIST_CD VARCHAR2(1)    
29 TERM_EARN_HOUR NUMBER(5,2)    
30 TERM_EARN_UNIT NUMBER(5,2)    
31 FNL_PRODROP_EFF_DT TIMESTAMP(6)    
32 INIT_PRODROP_EFF_DT TIMESTAMP(6)    
33 ENC_OVRIDE_IND VARCHAR2(1)    
34 TERM_ENRL_STAT VARCHAR2(1) Y  
35 EXTRACT_TIME TIMESTAMP(6)    
36 TERM_GRD_HOUR NUMBER(5,2)    
37 TERM_GRD_HOUR_PT NUMBER(5,2)    
38 TERM_GRD_UNIT_PT NUMBER(5,2)    
39 TERM_GRD_UNIT NUMBER(5,2)    
40 INIT_REG_SYS_ACS_DT TIMESTAMP(6)    
41 INIT_REG_SYS_ACS_TIME VARCHAR2(8)    
42 JAMES_SCHLR_IND VARCHAR2(1)    
43 TERM_JOINT_PGM_CD VARCHAR2(2)    
44 NEW_STAT VARCHAR2(1)    
45 TERM_NOM_HOUR NUMBER(5,2)    
46 TERM_NOM_UNIT NUMBER(5,2)    
47 OFF_CAMPUS_WORK_POST_IND VARCHAR2(1)    
48 OFF_CAMPUS_PGM_CD VARCHAR2(2)    
49 TERM_OVRLD_HOUR NUMBER(4,2)    
50 TERM_PND_HOUR NUMBER(5,2)    
51 TERM_PND_UNIT NUMBER(5,2)    
52 TERM_DARS_PPINTRST1_CD VARCHAR2(3)    
53 TERM_DARS_PPINTRST2_CD VARCHAR2(3)    
54 PREV_TERM_CAMPUS_CD VARCHAR2(1)    
55 PREV_TERM_COLL_CD VARCHAR2(2)    
56 PREV_TERM_CURR_CD VARCHAR2(4)    
57 PREV_TERM_JOINT_PGM_CD VARCHAR2(2)    
58 PREV_TERM_SEQ_NBR NUMBER(5)    
59 PREV_TERM_SUBSPCL_CD VARCHAR2(2)    
60 FNL_PRODROP_LVL_GPA NUMBER(5,3)    
61 INIT_PRODROP_LVL_GPA NUMBER(5,3)    
62 TERM_REG_DT TIMESTAMP(6)    
63 TERM_REG_TERMN_DT TIMESTAMP(6)    
64 TERM_RES_IND VARCHAR2(1)    
65 RUN_TIME TIMESTAMP(6)    
66 TERM_SEQ_NBR NUMBER(5)    
67 FNL_PRODROP_SRC_CD VARCHAR2(1)    
68 INIT_PRODROP_SRC_CD VARCHAR2(1)    
69 SSN VARCHAR2(9) Y  
70 FNL_PRODROP_STAT_CD VARCHAR2(1)    
71 INIT_PRODROP_STAT_CD VARCHAR2(1)    
72 STU_DEMO_ID VARCHAR2(16) Y  
73 STU_TERM_ID VARCHAR2(16) Y  
74 TERM_SUBSPCL_CD VARCHAR2(2)    
75 TERM_END_DT TIMESTAMP(6)    
76 DEFN_TERM_ID VARCHAR2(16) Y  
77 TERM_START_DT TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_TERMYR VARCHAR2(4) Y  
80 TERM_UNDLD_HOUR NUMBER(5,2)    
81 VEH_REG_IND VARCHAR2(1)    
82 TERM_VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DT TIMESTAMP(6)    

 

 

Views

---------- View VPHYCS_GRAD_PERS_ID_CARD ----------

Col # Column Name Data Type Not Null? Comments
1 ID_CARD_CREATE_DT TIMESTAMP(6)    
2 ID_CARD_CREATE_TIME VARCHAR2(8)    
3 ID_CARD_CREATE_SRC VARCHAR2(8)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ID_CARD_NBR VARCHAR2(9)    
6 PERS_ID VARCHAR2(16)    
7 PERS_ID_CARD_NBR_ID VARCHAR2(16) Y  
8 PREV_ID_CARD_NBR_IND VARCHAR2(1)    
9 RUN_TIME TIMESTAMP(6)    
10 ID_CARD_UPDT_TIME VARCHAR2(8)    
11 ID_CARD_UPDT_DT TIMESTAMP(6)    
12 ID_CARD_UPDT_SRC VARCHAR2(8)    

 

 

Views

---------- View VPHYCS_GRAD_STU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 CRS_CRDT_NOCRDT_IND VARCHAR2(1)    
2 CRS_CRDT_TYPE VARCHAR2(1)    
3 CRS_DEPT_CD VARCHAR2(5)    
4 CRS_DROP_DT TIMESTAMP(6)    
5 CRS_DROP_EFF_DT TIMESTAMP(6)    
6 CRS_DROP_TYPE VARCHAR2(10)    
7 CRS_DROP_SRC VARCHAR2(8)    
8 CRS_DUPL_CD VARCHAR2(1)    
9 GRD_BY_RULE_IND VARCHAR2(1)    
10 CRS_EARN_CRDT NUMBER(5,2)    
11 CRS_END_DT TIMESTAMP(6)    
12 CRS_ENRL_DT TIMESTAMP(6)    
13 EXCUSE_GRD_EXPIR_DT TIMESTAMP(6)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 CRS_GRD VARCHAR2(2)    
16 CRS_GRD_CRDT NUMBER(5,2)    
17 CRS_GRD_SECT_ITYPE VARCHAR2(10) Y  
18 CRS_GRD_SECT_NAME VARCHAR2(3) Y  
19 CRS_HNR_CD VARCHAR2(1)    
20 CRS_NOM_CRDT NUMBER(4,2)    
21 CRS_NBR VARCHAR2(3)    
22 CRS_NBR_XM_PREFIX VARCHAR2(1)    
23 CRS_ORIG_GRD_SECT_NAME VARCHAR2(3)    
24 CRS_CRDT_NOCRDT_GRD VARCHAR2(2)    
25 CRS_PREV_GRD_IND VARCHAR2(1)    
26 CRS_RELIG_FNDTN_IND VARCHAR2(1)    
27 CRS_REMEDIAL_IND VARCHAR2(1)    
28 CRS_RUBRIC VARCHAR2(5) Y  
29 RUN_TIME TIMESTAMP(6)    
30 CRS_SPCL_ACT_COLL_CD VARCHAR2(2)    
31 SSN VARCHAR2(9) Y  
32 CRS_START_DT TIMESTAMP(6)    
33 STU_CRS_ID VARCHAR2(16) Y  
34 STU_TERM_ID VARCHAR2(16) Y  
35 CRS_NON_BACCL_IND VARCHAR2(1)    
36 CRS_TERM_END_DT TIMESTAMP(6)    
37 CRS_TERM_TYPE VARCHAR2(2) Y  
38 CRS_TERMYR VARCHAR2(4) Y  
39 CRS_TITLE VARCHAR2(20)    
40 CRS_TRNSCPT_NOPOST_IND VARCHAR2(1)    
41 CRS_VISITOR_IND VARCHAR2(1)    
42 CRS_WITHDRAW_IND VARCHAR2(1)    
43 CRS_YRTERM VARCHAR2(4) Y  

 

 

Views

---------- View VPHYCS_GRAD_STU_CRS_SECT ----------

Col # Column Name Data Type Not Null? Comments
1 SECT_ADD_SRC VARCHAR2(8)    
2 SECT_DROP_DT TIMESTAMP(6)    
3 SECT_DROP_TYPE VARCHAR2(10)    
4 SECT_DROP_SRC VARCHAR2(8)    
5 SECT_ENRL_DT TIMESTAMP(6)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 SECT_GRD_IND VARCHAR2(1) Y  
8 SECT_ITYPE VARCHAR2(10) Y  
9 RUN_TIME TIMESTAMP(6)    
10 SECT_NAME VARCHAR2(3) Y  
11 STU_CRS_ID VARCHAR2(16) Y  
12 STU_CRS_SECT_ID VARCHAR2(16) Y  
13 SECT_TERMYR VARCHAR2(4)    
14 SECT_WITHDRAW_IND VARCHAR2(1)    

 

 

Views

---------- View VPHYCS_GRAD_STU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 ADDR_CITY VARCHAR2(15)    
2 ADDR_ALPHA_CNTRY_CD VARCHAR2(3)    
3 ADDR_EFF_DT TIMESTAMP(6)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ADDR_STREET2 VARCHAR2(30)    
6 ADDR_STREET3 VARCHAR2(30)    
7 ADDR_MC VARCHAR2(6)    
8 ADDR_PHONE_NBR VARCHAR2(25)    
9 RUN_TIME TIMESTAMP(6)    
10 ADDR_ST_CD VARCHAR2(2) Y  
11 ADDR_STREET1 VARCHAR2(30)    
12 STU_CUR_ADDR_ID VARCHAR2(16) Y  
13 ADDR_TYPE VARCHAR2(10) Y  
14 STU_DEMO_ID VARCHAR2(16)    
15 ADDR_ZIP_CD VARCHAR2(9)    

 

 

Views

---------- View VPHYCS_GRAD_STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 DEMO_ADDR_REVW_DT TIMESTAMP(6)    
2 BIRTH_DT TIMESTAMP(6)    
3 BLOOD_DONOR_CD VARCHAR2(1)    
4 BLOOD_DONOR_DT TIMESTAMP(6)    
5 LAST_REG_TERM_COLL_CD VARCHAR2(2)    
6 FULL_NAME_LFMS VARCHAR2(40) Y  
7 LAST_REG_TERM_CURR_CD VARCHAR2(4)    
8 DECEASE_DT TIMESTAMP(6)    
9 FULL_NAME_EFF_DT TIMESTAMP(6)    
10 EMAIL_ADDR VARCHAR2(17) Y  
11 ENRL_PATTN VARCHAR2(1)    
12 LAST_REG_TERM_ENRL_STAT VARCHAR2(1) Y  
13 UI_ENTR_DT TIMESTAMP(6)    
14 EXPCT_DEG_CD VARCHAR2(5)    
15 EXPCT_DEG_DT TIMESTAMP(6)    
16 EXTRACT_TIME TIMESTAMP(6)    
17 FAT_CHG_DT TIMESTAMP(6)    
18 FAT_CHG_SRC VARCHAR2(8)    
19 FERPA_UNLIST_END_DT TIMESTAMP(6)    
20 FERPA_UNLIST_START_DT TIMESTAMP(6)    
21 FERPA_TYPE VARCHAR2(20)    
22 FNAME VARCHAR2(30) Y  
23 FIRST_REG_TERM_DT TIMESTAMP(6)    
24 FIRST_REG_TERM_TYPE VARCHAR2(2) Y  
25 FIRST_REG_TERMYR VARCHAR2(4) Y  
26 FRGN_STU_SUPP_CD VARCHAR2(1)    
27 FULL_NAME_LFMS_UPPER VARCHAR2(40)    
28 GED_TEST_IND VARCHAR2(1)    
29 ID_CARD_NBR VARCHAR2(9)    
30 LAST_INST_ATTND_CD VARCHAR2(2)    
31 LAST_TERM_AUTH_DT TIMESTAMP(6)    
32 LAST_TERM_AUTH_LOCK_IND VARCHAR2(1)    
33 LNAME VARCHAR2(30) Y  
34 LAST_REG_TERM_DT TIMESTAMP(6)    
35 LAST_REG_TERM_TYPE VARCHAR2(2) Y  
36 LAST_REG_TERMYR VARCHAR2(4) Y  
37 MNAME VARCHAR2(35)    
38 NTWRK_ID VARCHAR2(8)    
39 CONTINT_ADM_CD VARCHAR2(2)    
40 NBR_CNTRY_ADM_CD VARCHAR2(3)    
41 CNTY_ADM_CD VARCHAR2(3)    
42 ST_ADM_CD VARCHAR2(2)    
43 PERS_ID VARCHAR2(16)    
44 PREV_FULL_NAME_IND VARCHAR2(1)    
45 RELIG_FNDTN_DT TIMESTAMP(6)    
46 RELIG_FNDTN_CD VARCHAR2(3)    
47 RES_IND VARCHAR2(1)    
48 RES_CHG_DT TIMESTAMP(6)    
49 RUN_TIME TIMESTAMP(6)    
50 SEX_CD VARCHAR2(1)    
51 FERPA_CRE_DT TIMESTAMP(6)    
52 FULL_NAME_SPCL_CHAR_IND VARCHAR2(1)    
53 SSN VARCHAR2(9) Y  
54 STU_DEMO_ID VARCHAR2(16) Y  
55 ACS_LOCK_IND VARCHAR2(1)    
56 CITZN_CHG_DT TIMESTAMP(6)    
57 CITZN_CD VARCHAR2(1)    
58 ETHNIC_CD VARCHAR2(1)    
59 SNAME VARCHAR2(10)    
60 FAT_TERMYR VARCHAR2(4) Y  
61 VLD_STAT_CD VARCHAR2(1)    
62 VET_DISCHRG_DT TIMESTAMP(6)    
63 VET_IND VARCHAR2(1)    

 

 

Views

---------- View VPHYCS_GRAD_STU_GDOL ----------

Col # Column Name Data Type Not Null? Comments
1 GDOL_COLL_CD VARCHAR2(2)    
2 GDOL_CURR_CD VARCHAR2(4)    
3 GDOL_CHG_DT TIMESTAMP(6)    
4 GDOL_TERMN_DT TIMESTAMP(6)    
5 DOCTL_EVAL_CD VARCHAR2(1)    
6 GDOL_EFF_DT TIMESTAMP(6)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 FELWSHP_CUM_SEM_TOT NUMBER(5)    
9 GRAD_DEG_LVL_CD VARCHAR2(1)    
10 GRAD_DEG_OBJ_CD VARCHAR2(1)    
11 RUN_TIME TIMESTAMP(6)    
12 STU_DEMO_ID VARCHAR2(16)    
13 STU_GDOL_ID VARCHAR2(16) Y  
14 THESIS_ADVSR VARCHAR2(20)    
15 THESIS_CUM_UNIT NUMBER(5,2)    
16 THESIS_DEPOSIT_DT TIMESTAMP(6)    

 

 

Views

---------- View VPHYCS_GRAD_STU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_DARS_ADVSR1_SSN VARCHAR2(9)    
2 TERM_DARS_ADVSR2_SSN VARCHAR2(9)    
3 TERM_DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 TERM_DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 PND_ASSTSHP_CD VARCHAR2(1)    
6 AUTH_CNTL_CD VARCHAR2(1)    
7 AUTH_DT TIMESTAMP(6)    
8 AUTH_SRC_CD VARCHAR2(1)    
9 TERM_CAMPUS_CD VARCHAR2(1)    
10 TERM_DARS_CATLG1_TERMYR VARCHAR2(4)    
11 TERM_DARS_CATLG2_TERMYR VARCHAR2(4)    
12 TERM_CLASS_CD VARCHAR2(1)    
13 FNL_PRODROP_CD VARCHAR2(2)    
14 INIT_PRODROP_CD VARCHAR2(2)    
15 COLL_ENRL_CATGRY VARCHAR2(1)    
16 TERM_COLL_CD VARCHAR2(2)    
17 FNL_PRODROP_COLL_CD VARCHAR2(2)    
18 INIT_PRODROP_COLL_CD VARCHAR2(2)    
19 TERM_CRDT_NOCRDT_HOUR NUMBER(5,2)    
20 TERM_CRDT_NOCRDT_UNIT NUMBER(5,2)    
21 TERM_CURR_CD VARCHAR2(4)    
22 FNL_PRODROP_CURR_CD VARCHAR2(4)    
23 INIT_PRODROP_CURR_CD VARCHAR2(4)    
24 TERM_DARS_COLL2_CD VARCHAR2(2)    
25 TERM_DARS_CURR2_CD VARCHAR2(4)    
26 TERM_DARS_SUBSPCL1_CD VARCHAR2(2)    
27 TERM_DARS_SUBSPCL2_CD VARCHAR2(2)    
28 DEANS_LIST_CD VARCHAR2(1)    
29 TERM_EARN_HOUR NUMBER(5,2)    
30 TERM_EARN_UNIT NUMBER(5,2)    
31 FNL_PRODROP_EFF_DT TIMESTAMP(6)    
32 INIT_PRODROP_EFF_DT TIMESTAMP(6)    
33 ENC_OVRIDE_IND VARCHAR2(1)    
34 TERM_ENRL_STAT VARCHAR2(1) Y  
35 EXTRACT_TIME TIMESTAMP(6)    
36 TERM_GRD_HOUR NUMBER(5,2)    
37 TERM_GRD_HOUR_PT NUMBER(5,2)    
38 TERM_GRD_UNIT_PT NUMBER(5,2)    
39 TERM_GRD_UNIT NUMBER(5,2)    
40 INIT_REG_SYS_ACS_DT TIMESTAMP(6)    
41 INIT_REG_SYS_ACS_TIME VARCHAR2(8)    
42 JAMES_SCHLR_IND VARCHAR2(1)    
43 TERM_JOINT_PGM_CD VARCHAR2(2)    
44 NEW_STAT VARCHAR2(1)    
45 TERM_NOM_HOUR NUMBER(5,2)    
46 TERM_NOM_UNIT NUMBER(5,2)    
47 OFF_CAMPUS_WORK_POST_IND VARCHAR2(1)    
48 OFF_CAMPUS_PGM_CD VARCHAR2(2)    
49 TERM_OVRLD_HOUR NUMBER(4,2)    
50 TERM_PND_HOUR NUMBER(5,2)    
51 TERM_PND_UNIT NUMBER(5,2)    
52 TERM_DARS_PPINTRST1_CD VARCHAR2(3)    
53 TERM_DARS_PPINTRST2_CD VARCHAR2(3)    
54 PREV_TERM_CAMPUS_CD VARCHAR2(1)    
55 PREV_TERM_COLL_CD VARCHAR2(2)    
56 PREV_TERM_CURR_CD VARCHAR2(4)    
57 PREV_TERM_JOINT_PGM_CD VARCHAR2(2)    
58 PREV_TERM_SEQ_NBR NUMBER(5)    
59 PREV_TERM_SUBSPCL_CD VARCHAR2(2)    
60 FNL_PRODROP_LVL_GPA NUMBER(5,3)    
61 INIT_PRODROP_LVL_GPA NUMBER(5,3)    
62 TERM_REG_DT TIMESTAMP(6)    
63 TERM_REG_TERMN_DT TIMESTAMP(6)    
64 TERM_RES_IND VARCHAR2(1)    
65 RUN_TIME TIMESTAMP(6)    
66 TERM_SEQ_NBR NUMBER(5)    
67 FNL_PRODROP_SRC_CD VARCHAR2(1)    
68 INIT_PRODROP_SRC_CD VARCHAR2(1)    
69 SSN VARCHAR2(9) Y  
70 FNL_PRODROP_STAT_CD VARCHAR2(1)    
71 INIT_PRODROP_STAT_CD VARCHAR2(1)    
72 STU_DEMO_ID VARCHAR2(16) Y  
73 STU_TERM_ID VARCHAR2(16) Y  
74 TERM_SUBSPCL_CD VARCHAR2(2)    
75 TERM_END_DT TIMESTAMP(6)    
76 DEFN_TERM_ID VARCHAR2(16) Y  
77 TERM_START_DT TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_TERMYR VARCHAR2(4) Y  
80 TERM_UNDLD_HOUR NUMBER(5,2)    
81 VEH_REG_IND VARCHAR2(1)    
82 TERM_VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DT TIMESTAMP(6)    

 

 

Views

---------- View VPHYCS_LAS_UGRAD_PERS_ID_CARD ----------

Col # Column Name Data Type Not Null? Comments
1 ID_CARD_CREATE_DT TIMESTAMP(6)    
2 ID_CARD_CREATE_TIME VARCHAR2(8)    
3 ID_CARD_CREATE_SRC VARCHAR2(8)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ID_CARD_NBR VARCHAR2(9)    
6 PERS_ID VARCHAR2(16)    
7 PERS_ID_CARD_NBR_ID VARCHAR2(16) Y  
8 PREV_ID_CARD_NBR_IND VARCHAR2(1)    
9 RUN_TIME TIMESTAMP(6)    
10 ID_CARD_UPDT_TIME VARCHAR2(8)    
11 ID_CARD_UPDT_DT TIMESTAMP(6)    
12 ID_CARD_UPDT_SRC VARCHAR2(8)    

 

 

Views

---------- View VPHYCS_LAS_UGRAD_STU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 CRS_CRDT_NOCRDT_IND VARCHAR2(1)    
2 CRS_CRDT_TYPE VARCHAR2(1)    
3 CRS_DEPT_CD VARCHAR2(5)    
4 CRS_DROP_DT TIMESTAMP(6)    
5 CRS_DROP_EFF_DT TIMESTAMP(6)    
6 CRS_DROP_TYPE VARCHAR2(10)    
7 CRS_DROP_SRC VARCHAR2(8)    
8 CRS_DUPL_CD VARCHAR2(1)    
9 GRD_BY_RULE_IND VARCHAR2(1)    
10 CRS_EARN_CRDT NUMBER(5,2)    
11 CRS_END_DT TIMESTAMP(6)    
12 CRS_ENRL_DT TIMESTAMP(6)    
13 EXCUSE_GRD_EXPIR_DT TIMESTAMP(6)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 CRS_GRD VARCHAR2(2)    
16 CRS_GRD_CRDT NUMBER(5,2)    
17 CRS_GRD_SECT_ITYPE VARCHAR2(10) Y  
18 CRS_GRD_SECT_NAME VARCHAR2(3) Y  
19 CRS_HNR_CD VARCHAR2(1)    
20 CRS_NOM_CRDT NUMBER(4,2)    
21 CRS_NBR VARCHAR2(3)    
22 CRS_NBR_XM_PREFIX VARCHAR2(1)    
23 CRS_ORIG_GRD_SECT_NAME VARCHAR2(3)    
24 CRS_CRDT_NOCRDT_GRD VARCHAR2(2)    
25 CRS_PREV_GRD_IND VARCHAR2(1)    
26 CRS_RELIG_FNDTN_IND VARCHAR2(1)    
27 CRS_REMEDIAL_IND VARCHAR2(1)    
28 CRS_RUBRIC VARCHAR2(5) Y  
29 RUN_TIME TIMESTAMP(6)    
30 CRS_SPCL_ACT_COLL_CD VARCHAR2(2)    
31 SSN VARCHAR2(9) Y  
32 CRS_START_DT TIMESTAMP(6)    
33 STU_CRS_ID VARCHAR2(16) Y  
34 STU_TERM_ID VARCHAR2(16) Y  
35 CRS_NON_BACCL_IND VARCHAR2(1)    
36 CRS_TERM_END_DT TIMESTAMP(6)    
37 CRS_TERM_TYPE VARCHAR2(2) Y  
38 CRS_TERMYR VARCHAR2(4) Y  
39 CRS_TITLE VARCHAR2(20)    
40 CRS_TRNSCPT_NOPOST_IND VARCHAR2(1)    
41 CRS_VISITOR_IND VARCHAR2(1)    
42 CRS_WITHDRAW_IND VARCHAR2(1)    
43 CRS_YRTERM VARCHAR2(4) Y  

 

 

Views

---------- View VPHYCS_LAS_UGRAD_STU_CRS_SECT ----------

Col # Column Name Data Type Not Null? Comments
1 SECT_ADD_SRC VARCHAR2(8)    
2 SECT_DROP_DT TIMESTAMP(6)    
3 SECT_DROP_TYPE VARCHAR2(10)    
4 SECT_DROP_SRC VARCHAR2(8)    
5 SECT_ENRL_DT TIMESTAMP(6)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 SECT_GRD_IND VARCHAR2(1) Y  
8 SECT_ITYPE VARCHAR2(10) Y  
9 RUN_TIME TIMESTAMP(6)    
10 SECT_NAME VARCHAR2(3) Y  
11 STU_CRS_ID VARCHAR2(16) Y  
12 STU_CRS_SECT_ID VARCHAR2(16) Y  
13 SECT_TERMYR VARCHAR2(4)    
14 SECT_WITHDRAW_IND VARCHAR2(1)    

 

 

Views

---------- View VPHYCS_LAS_UGRAD_STU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 ADDR_CITY VARCHAR2(15)    
2 ADDR_ALPHA_CNTRY_CD VARCHAR2(3)    
3 ADDR_EFF_DT TIMESTAMP(6)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ADDR_STREET2 VARCHAR2(30)    
6 ADDR_STREET3 VARCHAR2(30)    
7 ADDR_MC VARCHAR2(6)    
8 ADDR_PHONE_NBR VARCHAR2(25)    
9 RUN_TIME TIMESTAMP(6)    
10 ADDR_ST_CD VARCHAR2(2) Y  
11 ADDR_STREET1 VARCHAR2(30)    
12 STU_CUR_ADDR_ID VARCHAR2(16) Y  
13 ADDR_TYPE VARCHAR2(10) Y  
14 STU_DEMO_ID VARCHAR2(16)    
15 ADDR_ZIP_CD VARCHAR2(9)    

 

 

Views

---------- View VPHYCS_LAS_UGRAD_STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 DEMO_ADDR_REVW_DT TIMESTAMP(6)    
2 BIRTH_DT TIMESTAMP(6)    
3 BLOOD_DONOR_CD VARCHAR2(1)    
4 BLOOD_DONOR_DT TIMESTAMP(6)    
5 LAST_REG_TERM_COLL_CD VARCHAR2(2)    
6 FULL_NAME_LFMS VARCHAR2(40) Y  
7 LAST_REG_TERM_CURR_CD VARCHAR2(4)    
8 DECEASE_DT TIMESTAMP(6)    
9 FULL_NAME_EFF_DT TIMESTAMP(6)    
10 EMAIL_ADDR VARCHAR2(17) Y  
11 ENRL_PATTN VARCHAR2(1)    
12 LAST_REG_TERM_ENRL_STAT VARCHAR2(1) Y  
13 UI_ENTR_DT TIMESTAMP(6)    
14 EXPCT_DEG_CD VARCHAR2(5)    
15 EXPCT_DEG_DT TIMESTAMP(6)    
16 EXTRACT_TIME TIMESTAMP(6)    
17 FAT_CHG_DT TIMESTAMP(6)    
18 FAT_CHG_SRC VARCHAR2(8)    
19 FERPA_UNLIST_END_DT TIMESTAMP(6)    
20 FERPA_UNLIST_START_DT TIMESTAMP(6)    
21 FERPA_TYPE VARCHAR2(20)    
22 FNAME VARCHAR2(30) Y  
23 FIRST_REG_TERM_DT TIMESTAMP(6)    
24 FIRST_REG_TERM_TYPE VARCHAR2(2) Y  
25 FIRST_REG_TERMYR VARCHAR2(4) Y  
26 FRGN_STU_SUPP_CD VARCHAR2(1)    
27 FULL_NAME_LFMS_UPPER VARCHAR2(40)    
28 GED_TEST_IND VARCHAR2(1)    
29 ID_CARD_NBR VARCHAR2(9)    
30 LAST_INST_ATTND_CD VARCHAR2(2)    
31 LAST_TERM_AUTH_DT TIMESTAMP(6)    
32 LAST_TERM_AUTH_LOCK_IND VARCHAR2(1)    
33 LNAME VARCHAR2(30) Y  
34 LAST_REG_TERM_DT TIMESTAMP(6)    
35 LAST_REG_TERM_TYPE VARCHAR2(2) Y  
36 LAST_REG_TERMYR VARCHAR2(4) Y  
37 MNAME VARCHAR2(35)    
38 NTWRK_ID VARCHAR2(8)    
39 CONTINT_ADM_CD VARCHAR2(2)    
40 NBR_CNTRY_ADM_CD VARCHAR2(3)    
41 CNTY_ADM_CD VARCHAR2(3)    
42 ST_ADM_CD VARCHAR2(2)    
43 PERS_ID VARCHAR2(16)    
44 PREV_FULL_NAME_IND VARCHAR2(1)    
45 RELIG_FNDTN_DT TIMESTAMP(6)    
46 RELIG_FNDTN_CD VARCHAR2(3)    
47 RES_IND VARCHAR2(1)    
48 RES_CHG_DT TIMESTAMP(6)    
49 RUN_TIME TIMESTAMP(6)    
50 SEX_CD VARCHAR2(1)    
51 FERPA_CRE_DT TIMESTAMP(6)    
52 FULL_NAME_SPCL_CHAR_IND VARCHAR2(1)    
53 SSN VARCHAR2(9) Y  
54 STU_DEMO_ID VARCHAR2(16) Y  
55 ACS_LOCK_IND VARCHAR2(1)    
56 CITZN_CHG_DT TIMESTAMP(6)    
57 CITZN_CD VARCHAR2(1)    
58 ETHNIC_CD VARCHAR2(1)    
59 SNAME VARCHAR2(10)    
60 FAT_TERMYR VARCHAR2(4) Y  
61 VLD_STAT_CD VARCHAR2(1)    
62 VET_DISCHRG_DT TIMESTAMP(6)    
63 VET_IND VARCHAR2(1)    

 

 

Views

---------- View VPHYCS_LAS_UGRAD_STU_MIDSEM ----------

Col # Column Name Data Type Not Null? Comments
1 MIDSEM_GRD_CREATE_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 MIDSEM_GRD VARCHAR2(2)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_CRS_ID VARCHAR2(16)    
6 STU_MIDSEM_ID VARCHAR2(16) Y  
7 MIDSEM_GRD_UPDT_DT TIMESTAMP(6)    

 

 

Views

---------- View VPHYCS_LAS_UGRAD_STU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_DARS_ADVSR1_SSN VARCHAR2(9)    
2 TERM_DARS_ADVSR2_SSN VARCHAR2(9)    
3 TERM_DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 TERM_DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 PND_ASSTSHP_CD VARCHAR2(1)    
6 AUTH_CNTL_CD VARCHAR2(1)    
7 AUTH_DT TIMESTAMP(6)    
8 AUTH_SRC_CD VARCHAR2(1)    
9 TERM_CAMPUS_CD VARCHAR2(1)    
10 TERM_DARS_CATLG1_TERMYR VARCHAR2(4)    
11 TERM_DARS_CATLG2_TERMYR VARCHAR2(4)    
12 TERM_CLASS_CD VARCHAR2(1)    
13 FNL_PRODROP_CD VARCHAR2(2)    
14 INIT_PRODROP_CD VARCHAR2(2)    
15 COLL_ENRL_CATGRY VARCHAR2(1)    
16 TERM_COLL_CD VARCHAR2(2)    
17 FNL_PRODROP_COLL_CD VARCHAR2(2)    
18 INIT_PRODROP_COLL_CD VARCHAR2(2)    
19 TERM_CRDT_NOCRDT_HOUR NUMBER(5,2)    
20 TERM_CRDT_NOCRDT_UNIT NUMBER(5,2)    
21 TERM_CURR_CD VARCHAR2(4)    
22 FNL_PRODROP_CURR_CD VARCHAR2(4)    
23 INIT_PRODROP_CURR_CD VARCHAR2(4)    
24 TERM_DARS_COLL2_CD VARCHAR2(2)    
25 TERM_DARS_CURR2_CD VARCHAR2(4)    
26 TERM_DARS_SUBSPCL1_CD VARCHAR2(2)    
27 TERM_DARS_SUBSPCL2_CD VARCHAR2(2)    
28 DEANS_LIST_CD VARCHAR2(1)    
29 TERM_EARN_HOUR NUMBER(5,2)    
30 TERM_EARN_UNIT NUMBER(5,2)    
31 FNL_PRODROP_EFF_DT TIMESTAMP(6)    
32 INIT_PRODROP_EFF_DT TIMESTAMP(6)    
33 ENC_OVRIDE_IND VARCHAR2(1)    
34 TERM_ENRL_STAT VARCHAR2(1) Y  
35 EXTRACT_TIME TIMESTAMP(6)    
36 TERM_GRD_HOUR NUMBER(5,2)    
37 TERM_GRD_HOUR_PT NUMBER(5,2)    
38 TERM_GRD_UNIT_PT NUMBER(5,2)    
39 TERM_GRD_UNIT NUMBER(5,2)    
40 INIT_REG_SYS_ACS_DT TIMESTAMP(6)    
41 INIT_REG_SYS_ACS_TIME VARCHAR2(8)    
42 JAMES_SCHLR_IND VARCHAR2(1)    
43 TERM_JOINT_PGM_CD VARCHAR2(2)    
44 NEW_STAT VARCHAR2(1)    
45 TERM_NOM_HOUR NUMBER(5,2)    
46 TERM_NOM_UNIT NUMBER(5,2)    
47 OFF_CAMPUS_WORK_POST_IND VARCHAR2(1)    
48 OFF_CAMPUS_PGM_CD VARCHAR2(2)    
49 TERM_OVRLD_HOUR NUMBER(4,2)    
50 TERM_PND_HOUR NUMBER(5,2)    
51 TERM_PND_UNIT NUMBER(5,2)    
52 TERM_DARS_PPINTRST1_CD VARCHAR2(3)    
53 TERM_DARS_PPINTRST2_CD VARCHAR2(3)    
54 PREV_TERM_CAMPUS_CD VARCHAR2(1)    
55 PREV_TERM_COLL_CD VARCHAR2(2)    
56 PREV_TERM_CURR_CD VARCHAR2(4)    
57 PREV_TERM_JOINT_PGM_CD VARCHAR2(2)    
58 PREV_TERM_SEQ_NBR NUMBER(5)    
59 PREV_TERM_SUBSPCL_CD VARCHAR2(2)    
60 FNL_PRODROP_LVL_GPA NUMBER(5,3)    
61 INIT_PRODROP_LVL_GPA NUMBER(5,3)    
62 TERM_REG_DT TIMESTAMP(6)    
63 TERM_REG_TERMN_DT TIMESTAMP(6)    
64 TERM_RES_IND VARCHAR2(1)    
65 RUN_TIME TIMESTAMP(6)    
66 TERM_SEQ_NBR NUMBER(5)    
67 FNL_PRODROP_SRC_CD VARCHAR2(1)    
68 INIT_PRODROP_SRC_CD VARCHAR2(1)    
69 SSN VARCHAR2(9) Y  
70 FNL_PRODROP_STAT_CD VARCHAR2(1)    
71 INIT_PRODROP_STAT_CD VARCHAR2(1)    
72 STU_DEMO_ID VARCHAR2(16) Y  
73 STU_TERM_ID VARCHAR2(16) Y  
74 TERM_SUBSPCL_CD VARCHAR2(2)    
75 TERM_END_DT TIMESTAMP(6)    
76 DEFN_TERM_ID VARCHAR2(16) Y  
77 TERM_START_DT TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_TERMYR VARCHAR2(4) Y  
80 TERM_UNDLD_HOUR NUMBER(5,2)    
81 VEH_REG_IND VARCHAR2(1)    
82 TERM_VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DT TIMESTAMP(6)    

 

 

Views

---------- View VSTU_ADM ----------

Col # Column Name Data Type Not Null? Comments
1 ADM_CATGRY_CD VARCHAR2(2)    
2 ADM_DECN_CD VARCHAR2(2)    
3 ADM_DECN_DT TIMESTAMP(6)    
4 ADM_CAMPUS_SI VARCHAR2(2)    
5 ADM_CLASS_CD VARCHAR2(1)    
6 ADM_COLL_REVW_CD VARCHAR2(1)    
7 ADM_COLL_SI VARCHAR2(2)    
8 ADM_COLL_CD VARCHAR2(2)    
9 ADM_CURR_CD VARCHAR2(4)    
10 ADM_DEG_OBJ_CD VARCHAR2(1)    
11 ADM_MAJOR_CD VARCHAR2(3)    
12 ADM_ENGL_LANG_CMPTNC_SCORE VARCHAR2(1)    
13 ADM_ENGL_LANG_TEST_SCORE VARCHAR2(3)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 ADM_GRAD_GPA NUMBER(3,2)    
16 ADM_UGRAD_GPA NUMBER(3,2)    
17 ADM_HOUR_EARN_STAT VARCHAR2(1)    
18 ADM_HS_GRD VARCHAR2(4)    
19 ADM_HS_PCT_COLL_DECILE NUMBER(5)    
20 ADM_HNR_INTRST_CD VARCHAR2(1)    
21 ADM_INDEP_STUDY_INTRST_IND VARCHAR2(1)    
22 ADM_LAW_SI NUMBER(3,1)    
23 NOA_ISSUE_DT TIMESTAMP(6)    
24 NOA_MSG1_CD VARCHAR2(1)    
25 NOA_MSG2_CD VARCHAR2(1)    
26 NOA_MSG3_CD VARCHAR2(1)    
27 NOA_STAT VARCHAR2(1)    
28 ADM_PATTN1_CD VARCHAR2(1)    
29 ADM_PATTN2_CD VARCHAR2(1)    
30 ADM_PATTN3_CD VARCHAR2(1)    
31 ADM_PATTN4_CD VARCHAR2(1)    
32 ADM_PATTN5_CD VARCHAR2(1)    
33 RUN_TIME TIMESTAMP(6)    
34 ADM_SPCL_CATGRY_CD VARCHAR2(1)    
35 ADM_SPCL_GRP1_CD VARCHAR2(1)    
36 ADM_SPCL_GRP2_CD VARCHAR2(1)    
37 ADM_SPCL_GRP3_CD VARCHAR2(1)    
38 ADM_SPCL_GRP4_CD VARCHAR2(1)    
39 SSN VARCHAR2(9)    
40 STU_ADM_ID VARCHAR2(16) Y  
41 STU_DEMO_ID VARCHAR2(16) Y  
42 ADM_SUBSPCL_CD VARCHAR2(2)    
43 ADM_TERM_DT TIMESTAMP(6)    
44 ADM_TFER_GPA NUMBER(5,3)    
45 ADM_TFER_HOUR_EARN NUMBER(5,2)    
46 ADM_TFER_HOUR_GRD NUMBER(5,2)    
47 ADM_TFER_PT NUMBER(7,2)    
48 ADM_VM_CUM_GPA NUMBER(5,3)    
49 ADM_VM_CUM_GRD_HOUR NUMBER(5,2)    
50 ADM_VM_SCI_GRD_HOUR NUMBER(5,2)    
51 ADM_VM_SCI_GPA NUMBER(5,3)    
52 ADM_VM_SUBJ_EVAL_PT VARCHAR2(3)    

 

 

Views

---------- View VSTU_ADM_TEST ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRACT_TIME TIMESTAMP(6)    
2 RUN_TIME TIMESTAMP(6)    
3 SSN VARCHAR2(9) Y  
4 STU_ADM_TEST_ID VARCHAR2(16) Y  
5 STU_DEMO_ID VARCHAR2(16) Y  
6 ADM_TEST_AREA_CD VARCHAR2(2)    
7 ADM_TEST_DT TIMESTAMP(6)    
8 ADM_TEST_NATL_PCT NUMBER(5)    
9 ADM_TEST_SCORE NUMBER(5)    
10 ADM_TEST_TYPE VARCHAR2(4)    
11 ADM_TEST_UI_DECILE NUMBER(5)    

 

 

Views

---------- View VSTU_ADVS_HOLD ----------

Col # Column Name Data Type Not Null? Comments
1 ADVS_HOLD_SET_CAMPUS_CD VARCHAR2(1)    
2 ADVS_HOLD_CLEAR_SRC VARCHAR2(8)    
3 ADVS_HOLD_SET_COLL_CD VARCHAR2(2)    
4 ADVS_HOLD_SET_CURR_CD VARCHAR2(4)    
5 ADVS_HOLD_SET_DT TIMESTAMP(6)    
6 ADVS_HOLD_CLEAR_DT TIMESTAMP(6)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 RUN_TIME TIMESTAMP(6)    
9 ADVS_HOLD_SET_SRC VARCHAR2(8)    
10 STU_ADVS_HOLD_ID VARCHAR2(16) Y  
11 STU_DEMO_ID VARCHAR2(16)    
12 ADVS_HOLD_METH_SET_CD VARCHAR2(1)    

 

 

Views

---------- View VSTU_AWD_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 AWD_DEG_ABBREV VARCHAR2(5)    
2 AWD_DEG_DT TIMESTAMP(6)    
3 AWD_DEG_CIPS_CD VARCHAR2(8)    
4 AWD_DEG_CIPS_CD_TEXT VARCHAR2(55)    
5 AWD_DEG_COLL1_HNR_TEXT VARCHAR2(15)    
6 AWD_DEG_COLL1_CD VARCHAR2(2)    
7 AWD_DEG_COLL1_HNR_CD VARCHAR2(1)    
8 AWD_DEG_COLL1_NAME VARCHAR2(15)    
9 AWD_DEG_CURR1_HNR_TEXT VARCHAR2(25)    
10 AWD_DEG_CURR2_HNR_TEXT VARCHAR2(25)    
11 AWD_DEG_CURR3_HNR_TEXT VARCHAR2(25)    
12 AWD_DEG_CURR1_CD VARCHAR2(4)    
13 AWD_DEG_CURR1_HNR_CD VARCHAR2(1)    
14 AWD_DEG_CURR1_NAME VARCHAR2(45)    
15 AWD_DEG_CURR2_CD VARCHAR2(4)    
16 AWD_DEG_CURR2_HNR_CD VARCHAR2(1)    
17 AWD_DEG_CURR2_NAME VARCHAR2(45)    
18 AWD_DEG_CURR3_CD VARCHAR2(4)    
19 AWD_DEG_CURR3_HNR_CD VARCHAR2(1)    
20 AWD_DEG_CURR3_NAME VARCHAR2(45)    
21 AWD_DEG_FULL_NAME_FMLS VARCHAR2(90)    
22 AWD_DEG_TITLE_OPT_CD VARCHAR2(2)    
23 AWD_DEG_CD VARCHAR2(2)    
24 AWD_DEG_PERD VARCHAR2(5)    
25 EXTRACT_TIME TIMESTAMP(6)    
26 AWD_DEG_TRNSCPT_TITLE VARCHAR2(120)    
27 AWD_DEG_MOD_DT TIMESTAMP(6)    
28 AWD_DEG_NAME_SPCL_CHAR_IND VARCHAR2(1)    
29 RUN_TIME TIMESTAMP(6)    
30 AWD_DEG_STAT VARCHAR2(1)    
31 STU_AWD_DEG_ID VARCHAR2(16) Y  
32 AWD_DEG_TYPE VARCHAR2(1)    
33 STU_DEMO_ID VARCHAR2(16)    
34 AWD_DEG_DIPL_TITLE VARCHAR2(120)    

 

 

Views

---------- View VSTU_CAD ----------

Col # Column Name Data Type Not Null? Comments
1 CAD_TYPE VARCHAR2(2)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 CAD_MOD_DT TIMESTAMP(6)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_CAD_ID VARCHAR2(16) Y  
6 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View VSTU_CAD_DTL ----------

Col # Column Name Data Type Not Null? Comments
1 CAD_DTL_CRDT_TYPE VARCHAR2(1)    
2 CAD_DTL_CRDT_CATGRY VARCHAR2(2)    
3 CAD_DTL_EARN_CRDT NUMBER(9,5)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 CAD_DTL_GRD_CRDT NUMBER(9,5)    
6 CAD_DTL_GRD_PT NUMBER(9,5)    
7 CAD_DTL_NOM_CRDT NUMBER(9,5)    
8 RUN_TIME TIMESTAMP(6)    
9 STU_CAD_DTL_ID VARCHAR2(16) Y  
10 STU_CAD_ID VARCHAR2(16)    

 

 

Views

---------- View VSTU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 CRS_CRDT_NOCRDT_IND VARCHAR2(1)    
2 CRS_CRDT_TYPE VARCHAR2(1)    
3 CRS_DEPT_CD VARCHAR2(5)    
4 CRS_DROP_DT TIMESTAMP(6)    
5 CRS_DROP_EFF_DT TIMESTAMP(6)    
6 CRS_DROP_TYPE VARCHAR2(10)    
7 CRS_DROP_SRC VARCHAR2(8)    
8 CRS_DUPL_CD VARCHAR2(1)    
9 GRD_BY_RULE_IND VARCHAR2(1)    
10 CRS_EARN_CRDT NUMBER(5,2)    
11 CRS_END_DT TIMESTAMP(6)    
12 CRS_ENRL_DT TIMESTAMP(6)    
13 EXCUSE_GRD_EXPIR_DT TIMESTAMP(6)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 CRS_GRD VARCHAR2(2)    
16 CRS_GRD_CRDT NUMBER(5,2)    
17 CRS_GRD_SECT_ITYPE VARCHAR2(10) Y  
18 CRS_GRD_SECT_NAME VARCHAR2(3) Y  
19 CRS_HNR_CD VARCHAR2(1)    
20 CRS_NOM_CRDT NUMBER(4,2)    
21 CRS_NBR VARCHAR2(3)    
22 CRS_NBR_XM_PREFIX VARCHAR2(1)    
23 CRS_ORIG_GRD_SECT_NAME VARCHAR2(3)    
24 CRS_CRDT_NOCRDT_GRD VARCHAR2(2)    
25 CRS_PREV_GRD_IND VARCHAR2(1)    
26 CRS_RELIG_FNDTN_IND VARCHAR2(1)    
27 CRS_REMEDIAL_IND VARCHAR2(1)    
28 CRS_RUBRIC VARCHAR2(5) Y  
29 RUN_TIME TIMESTAMP(6)    
30 CRS_SPCL_ACT_COLL_CD VARCHAR2(2)    
31 SSN VARCHAR2(9) Y  
32 CRS_START_DT TIMESTAMP(6)    
33 STU_CRS_ID VARCHAR2(16) Y  
34 STU_TERM_ID VARCHAR2(16) Y  
35 CRS_NON_BACCL_IND VARCHAR2(1)    
36 CRS_TERM_END_DT TIMESTAMP(6)    
37 CRS_TERM_TYPE VARCHAR2(2) Y  
38 CRS_TERMYR VARCHAR2(4) Y  
39 CRS_TITLE VARCHAR2(20)    
40 CRS_TRNSCPT_NOPOST_IND VARCHAR2(1)    
41 CRS_VISITOR_IND VARCHAR2(1)    
42 CRS_WITHDRAW_IND VARCHAR2(1)    
43 CRS_YRTERM VARCHAR2(4) Y  

 

 

Views

---------- View VSTU_CRS_SECT ----------

Col # Column Name Data Type Not Null? Comments
1 SECT_ADD_SRC VARCHAR2(8)    
2 SECT_DROP_DT TIMESTAMP(6)    
3 SECT_DROP_TYPE VARCHAR2(10)    
4 SECT_DROP_SRC VARCHAR2(8)    
5 SECT_ENRL_DT TIMESTAMP(6)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 SECT_GRD_IND VARCHAR2(1) Y  
8 SECT_ITYPE VARCHAR2(10) Y  
9 RUN_TIME TIMESTAMP(6)    
10 SECT_NAME VARCHAR2(3) Y  
11 STU_CRS_ID VARCHAR2(16) Y  
12 STU_CRS_SECT_ID VARCHAR2(16) Y  
13 SECT_TERMYR VARCHAR2(4)    
14 SECT_WITHDRAW_IND VARCHAR2(1)    

 

 

Views

---------- View VSTU_CRS_XM ----------

Col # Column Name Data Type Not Null? Comments
1 CRS_CRDT_NOCRDT_IND VARCHAR2(1)    
2 CRS_CRDT_TYPE VARCHAR2(1)    
3 CRS_DEPT_CD VARCHAR2(5)    
4 CRS_DROP_DT TIMESTAMP(6)    
5 CRS_DROP_EFF_DT TIMESTAMP(6)    
6 CRS_DROP_TYPE VARCHAR2(10)    
7 CRS_DROP_SRC VARCHAR2(8)    
8 CRS_DUPL_CD VARCHAR2(1)    
9 GRD_BY_RULE_IND VARCHAR2(1)    
10 CRS_EARN_CRDT NUMBER(5,2)    
11 CRS_END_DT TIMESTAMP(6)    
12 CRS_ENRL_DT TIMESTAMP(6)    
13 EXCUSE_GRD_EXPIR_DT TIMESTAMP(6)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 CRS_GRD VARCHAR2(2)    
16 CRS_GRD_CRDT NUMBER(5,2)    
17 CRS_GRD_SECT_ITYPE VARCHAR2(10) Y  
18 CRS_GRD_SECT_NAME VARCHAR2(3) Y  
19 CRS_HNR_CD VARCHAR2(1)    
20 CRS_NOM_CRDT NUMBER(4,2)    
21 CRS_NBR VARCHAR2(3)    
22 CRS_NBR_XM_PREFIX VARCHAR2(1)    
23 CRS_ORIG_GRD_SECT_NAME VARCHAR2(3)    
24 CRS_CRDT_NOCRDT_GRD VARCHAR2(2)    
25 CRS_PREV_GRD_IND VARCHAR2(1)    
26 CRS_RELIG_FNDTN_IND VARCHAR2(1)    
27 CRS_REMEDIAL_IND VARCHAR2(1)    
28 CRS_RUBRIC VARCHAR2(5) Y  
29 RUN_TIME TIMESTAMP(6)    
30 CRS_SPCL_ACT_COLL_CD VARCHAR2(2)    
31 SSN VARCHAR2(9) Y  
32 CRS_START_DT TIMESTAMP(6)    
33 STU_CRS_ID VARCHAR2(16) Y  
34 STU_TERM_ID VARCHAR2(16) Y  
35 CRS_NON_BACCL_IND VARCHAR2(1)    
36 CRS_TERM_END_DT TIMESTAMP(6)    
37 CRS_TERM_TYPE VARCHAR2(2) Y  
38 CRS_TERMYR VARCHAR2(4) Y  
39 CRS_TITLE VARCHAR2(20)    
40 CRS_TRNSCPT_NOPOST_IND VARCHAR2(1)    
41 CRS_VISITOR_IND VARCHAR2(1)    
42 CRS_WITHDRAW_IND VARCHAR2(1)    
43 CRS_YRTERM VARCHAR2(4) Y  

 

 

Views

---------- View VSTU_CURR ----------

Col # Column Name Data Type Not Null? Comments
1 CURR_ACTIV_IND VARCHAR2(1)    
2 CURR_CAMPUS_CD VARCHAR2(1)    
3 CURR_COLL_CD VARCHAR2(2)    
4 CURR_CD VARCHAR2(4)    
5 CURR_END_DT TIMESTAMP(6)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 CURR_JOINT_PGM_CD VARCHAR2(2)    
8 RUN_TIME TIMESTAMP(6)    
9 CUR_SEQ_NBR NUMBER(5)    
10 CURR_START_DT TIMESTAMP(6)    
11 STU_CURR_ID VARCHAR2(16) Y  
12 CURR_TYPE VARCHAR2(10)    
13 STU_TERM_ID VARCHAR2(16)    
14 CURR_SUBSPCL_CD VARCHAR2(2)    
15 CURR_YRTERM VARCHAR2(4)    

 

 

Views

---------- View VSTU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 ADDR_CITY VARCHAR2(15)    
2 ADDR_ALPHA_CNTRY_CD VARCHAR2(3)    
3 ADDR_EFF_DT TIMESTAMP(6)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 ADDR_STREET2 VARCHAR2(30)    
6 ADDR_STREET3 VARCHAR2(30)    
7 ADDR_MC VARCHAR2(6)    
8 ADDR_PHONE_NBR VARCHAR2(25)    
9 RUN_TIME TIMESTAMP(6)    
10 ADDR_ST_CD VARCHAR2(2) Y  
11 ADDR_STREET1 VARCHAR2(30)    
12 STU_CUR_ADDR_ID VARCHAR2(16) Y  
13 ADDR_TYPE VARCHAR2(10) Y  
14 STU_DEMO_ID VARCHAR2(16)    
15 ADDR_ZIP_CD VARCHAR2(9)    

 

 

Views

---------- View VSTU_DARS_CD ----------

Col # Column Name Data Type Not Null? Comments
1 DARS_ADVSR1_SSN VARCHAR2(9)    
2 DARS_ADVSR2_SSN VARCHAR2(9)    
3 DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 DARS_CATLG1_TERMYR VARCHAR2(4)    
6 DARS_CATLG2_TERMYR VARCHAR2(4)    
7 DARS_SUBSPCL1_CD VARCHAR2(2)    
8 DARS_PGM2_INFO VARCHAR2(8)    
9 EXTRACT_TIME TIMESTAMP(6)    
10 DARS_PPINTRST1_CD VARCHAR2(3)    
11 DARS_PPINTRST2_CD VARCHAR2(3)    
12 RUN_TIME TIMESTAMP(6)    
13 STU_DARS_CD_ID VARCHAR2(16) Y  
14 STU_TERM_ID VARCHAR2(16)    
15 DARS_YRTERM VARCHAR2(4)    

 

 

Views

---------- View VSTU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 DEMO_ADDR_REVW_DT TIMESTAMP(6)    
2 BIRTH_DT TIMESTAMP(6)    
3 BLOOD_DONOR_CD VARCHAR2(1)    
4 BLOOD_DONOR_DT TIMESTAMP(6)    
5 LAST_REG_TERM_COLL_CD VARCHAR2(2)    
6 FULL_NAME_LFMS VARCHAR2(40) Y  
7 LAST_REG_TERM_CURR_CD VARCHAR2(4)    
8 DECEASE_DT TIMESTAMP(6)    
9 FULL_NAME_EFF_DT TIMESTAMP(6)    
10 EMAIL_ADDR VARCHAR2(17) Y  
11 ENRL_PATTN VARCHAR2(1)    
12 LAST_REG_TERM_ENRL_STAT VARCHAR2(1) Y  
13 UI_ENTR_DT TIMESTAMP(6)    
14 EXPCT_DEG_CD VARCHAR2(5)    
15 EXPCT_DEG_DT TIMESTAMP(6)    
16 EXTRACT_TIME TIMESTAMP(6)    
17 FAT_CHG_DT TIMESTAMP(6)    
18 FAT_CHG_SRC VARCHAR2(8)    
19 FERPA_UNLIST_END_DT TIMESTAMP(6)    
20 FERPA_UNLIST_START_DT TIMESTAMP(6)    
21 FERPA_TYPE VARCHAR2(20)    
22 FNAME VARCHAR2(30) Y  
23 FIRST_REG_TERM_DT TIMESTAMP(6)    
24 FIRST_REG_TERM_TYPE VARCHAR2(2) Y  
25 FIRST_REG_TERMYR VARCHAR2(4) Y  
26 FRGN_STU_SUPP_CD VARCHAR2(1)    
27 FULL_NAME_LFMS_UPPER VARCHAR2(40)    
28 GED_TEST_IND VARCHAR2(1)    
29 ID_CARD_NBR VARCHAR2(9)    
30 LAST_INST_ATTND_CD VARCHAR2(2)    
31 LAST_TERM_AUTH_DT TIMESTAMP(6)    
32 LAST_TERM_AUTH_LOCK_IND VARCHAR2(1)    
33 LNAME VARCHAR2(30) Y  
34 LAST_REG_TERM_DT TIMESTAMP(6)    
35 LAST_REG_TERM_TYPE VARCHAR2(2) Y  
36 LAST_REG_TERMYR VARCHAR2(4) Y  
37 MNAME VARCHAR2(35)    
38 NTWRK_ID VARCHAR2(8)    
39 CONTINT_ADM_CD VARCHAR2(2)    
40 NBR_CNTRY_ADM_CD VARCHAR2(3)    
41 CNTY_ADM_CD VARCHAR2(3)    
42 ST_ADM_CD VARCHAR2(2)    
43 PERS_ID VARCHAR2(16)    
44 PREV_FULL_NAME_IND VARCHAR2(1)    
45 RELIG_FNDTN_DT TIMESTAMP(6)    
46 RELIG_FNDTN_CD VARCHAR2(3)    
47 RES_IND VARCHAR2(1)    
48 RES_CHG_DT TIMESTAMP(6)    
49 RUN_TIME TIMESTAMP(6)    
50 SEX_CD VARCHAR2(1)    
51 FERPA_CRE_DT TIMESTAMP(6)    
52 FULL_NAME_SPCL_CHAR_IND VARCHAR2(1)    
53 SSN VARCHAR2(9) Y  
54 STU_DEMO_ID VARCHAR2(16) Y  
55 ACS_LOCK_IND VARCHAR2(1)    
56 CITZN_CHG_DT TIMESTAMP(6)    
57 CITZN_CD VARCHAR2(1)    
58 ETHNIC_CD VARCHAR2(1)    
59 SNAME VARCHAR2(10)    
60 FAT_TERMYR VARCHAR2(4) Y  
61 VLD_STAT_CD VARCHAR2(1)    
62 VET_DISCHRG_DT TIMESTAMP(6)    
63 VET_IND VARCHAR2(1)    

 

 

Views

---------- View VSTU_DIST ----------

Col # Column Name Data Type Not Null? Comments
1 DIST_CD VARCHAR2(15)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 DIST_START_DT TIMESTAMP(6)    
5 DIST_END_DT TIMESTAMP(6)    
6 STU_DEMO_ID VARCHAR2(16)    
7 STU_DIST_ID VARCHAR2(16) Y  
8 STU_TERM_ID VARCHAR2(16)    
9 DIST_TRNSCPT_PRT_IND VARCHAR2(1)    
10 DIST_TYPE_CD VARCHAR2(15)    
11 DIST_YRTERM VARCHAR2(4)    

 

 

Views

---------- View VSTU_ENC ----------

Col # Column Name Data Type Not Null? Comments
1 ENC_AMT NUMBER(7,2)    
2 ENC_SET_CAMPUS_CD VARCHAR2(1)    
3 ENC__CLEAR_SRC VARCHAR2(8)    
4 ENC_CLEAR_DT TIMESTAMP(6)    
5 ENC_SET_COLL_CD VARCHAR2(2)    
6 ENC_ENTR_DT TIMESTAMP(6)    
7 ENC_SET_DEPT_CD VARCHAR2(4)    
8 ENC_CMNT VARCHAR2(70)    
9 ENC_EFF_DT TIMESTAMP(6)    
10 DEFN_ENC_ID VARCHAR2(16)    
11 EXTRACT_TIME TIMESTAMP(6)    
12 RUN_TIME TIMESTAMP(6)    
13 ENC_SET_SRC VARCHAR2(8)    
14 STU_DEMO_ID VARCHAR2(16)    
15 STU_ENC_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_EXTRNL_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRNL_DEG_ACPT_DT TIMESTAMP(6)    
2 EXTRNL_DEG_AWD_DT TIMESTAMP(6)    
3 EXTRNL_DEG_LVL_CD VARCHAR2(2)    
4 EXTRNL_DEG_ABBREV VARCHAR2(25) Y  
5 EXTRNL_DEG_YR NUMBER(5)    
6 EXTRACT_TIME TIMESTAMP(6)    
7 EXTRNL_DEG_INST_CD VARCHAR2(6)    
8 EXTRNL_DEG_INST_NAME VARCHAR2(30)    
9 EXTRNL_DEG_MISSG_CRED_CD VARCHAR2(1)    
10 RUN_TIME TIMESTAMP(6)    
11 EXTRNL_DEG_SEQ_NBR NUMBER(5)    
12 EXTRNL_DEG_SRC_CD VARCHAR2(1)    
13 STU_DEMO_ID VARCHAR2(16)    
14 STU_EXTRNL_DEG_ID VARCHAR2(16) Y  
15 DEFN_TFER_INST_ID VARCHAR2(16)    

 

 

Views

---------- View VSTU_GAS ----------

Col # Column Name Data Type Not Null? Comments
1 GAS_DEPT_MIN_GPA NUMBER(4,3)    
2 GAS_EFF_DT TIMESTAMP(6)    
3 EXTRACT_TIME TIMESTAMP(6)    
4 GAS_CD VARCHAR2(1)    
5 GAS_GPA_REVW_IND VARCHAR2(1)    
6 LTD_DEPT_DEFICY_IND VARCHAR2(1)    
7 LTD_ENGL_CMPRHN_IND VARCHAR2(1)    
8 LTD_GPA_UND_MIN_IND VARCHAR2(1)    
9 LTD_NOT_AVG_ADM_GPA_IND VARCHAR2(1)    
10 LTD_MISSG_CRED_IND VARCHAR2(1)    
11 LTD_NO_BACCL_EQ_IND VARCHAR2(1)    
12 RUN_TIME TIMESTAMP(6)    
13 SSN VARCHAR2(9) Y  
14 STU_DEMO_ID VARCHAR2(16)    
15 STU_GAS_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_GDOL ----------

Col # Column Name Data Type Not Null? Comments
1 GDOL_COLL_CD VARCHAR2(2)    
2 GDOL_CURR_CD VARCHAR2(4)    
3 GDOL_CHG_DT TIMESTAMP(6)    
4 GDOL_TERMN_DT TIMESTAMP(6)    
5 DOCTL_EVAL_CD VARCHAR2(1)    
6 GDOL_EFF_DT TIMESTAMP(6)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 FELWSHP_CUM_SEM_TOT NUMBER(5)    
9 GRAD_DEG_LVL_CD VARCHAR2(1)    
10 GRAD_DEG_OBJ_CD VARCHAR2(1)    
11 RUN_TIME TIMESTAMP(6)    
12 STU_DEMO_ID VARCHAR2(16)    
13 STU_GDOL_ID VARCHAR2(16) Y  
14 THESIS_ADVSR VARCHAR2(20)    
15 THESIS_CUM_UNIT NUMBER(5,2)    
16 THESIS_DEPOSIT_DT TIMESTAMP(6)    

 

 

Views

---------- View VSTU_GRAD_DATA ----------

Col # Column Name Data Type Not Null? Comments
1 GRAD_ENTR_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 STU_DEMO_ID VARCHAR2(16)    
5 STU_GRAD_DATA_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_GRAD_EXAM ----------

Col # Column Name Data Type Not Null? Comments
1 GRAD_EXAM_APPT_DT TIMESTAMP(6)    
2 GRAD_EXAM_COLL_CD VARCHAR2(2)    
3 GRAD_COMMITE_DISSOLVE_DT TIMESTAMP(6)    
4 GRAD_EXAM_CURR_CD VARCHAR2(4)    
5 GRAD_EXAM_DT TIMESTAMP(6)    
6 GRAD_EXAM_SCORE VARCHAR2(1)    
7 GRAD_EXAM_TYPE VARCHAR2(1)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 RUN_TIME TIMESTAMP(6)    
10 STU_DEMO_ID VARCHAR2(16)    
11 STU_GRAD_EXAM_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_HS_ENRL ----------

Col # Column Name Data Type Not Null? Comments
1 HS_CITY_ST VARCHAR2(18)    
2 HS_CLASS_RANK NUMBER    
3 HS_CLASS_SIZE NUMBER    
4 HS_ENRL_END_DT TIMESTAMP(6)    
5 EXTRACT_TIME TIMESTAMP(6)    
6 HS_GRAD_DT TIMESTAMP(6)    
7 HS_HNR_CRS_CD VARCHAR2(1)    
8 HS_ENRL_INST_CD VARCHAR2(6)    
9 HS_ENRL_INST_NAME VARCHAR2(30)    
10 HS_PCT_RANK_TO_UI NUMBER(5)    
11 HS_PCT_RANK NUMBER(5)    
12 HS_RANL_EXCPT_CD VARCHAR2(1)    
13 RUN_TIME TIMESTAMP(6)    
14 SSN VARCHAR2(9) Y  
15 HS_ENRL_START_DT TIMESTAMP(6)    
16 STU_DEMO_ID VARCHAR2(16)    
17 STU_HS_ENRL_ID VARCHAR2(16) Y  
18 DEFN_HS_INST_CD VARCHAR2(16)    
19 HS_ZIP_CD VARCHAR2(9)    

 

 

Views

---------- View VSTU_HS_SUBJ ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRACT_TIME TIMESTAMP(6)    
2 RUN_TIME TIMESTAMP(6)    
3 SSN VARCHAR2(9) Y  
4 STU_DEMO_ID VARCHAR2(16)    
5 STU_HS_ENRL_ID VARCHAR2(16)    
6 STU_HS_SUBJ_ID VARCHAR2(16) Y  
7 HS_SUBJ_CD VARCHAR2(20) Y  
8 HS_SUBJ_UNIT NUMBER(4,2)    

 

 

Views

---------- View VSTU_MIDSEM ----------

Col # Column Name Data Type Not Null? Comments
1 MIDSEM_GRD_CREATE_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 MIDSEM_GRD VARCHAR2(2)    
4 RUN_TIME TIMESTAMP(6)    
5 STU_CRS_ID VARCHAR2(16)    
6 STU_MIDSEM_ID VARCHAR2(16) Y  
7 MIDSEM_GRD_UPDT_DT TIMESTAMP(6)    

 

 

Views

---------- View VSTU_PND_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 PND_DEG_CMNT1 VARCHAR2(60)    
2 PND_DEG_CMNT2 VARCHAR2(60)    
3 PND_DEG_CRE_DT TIMESTAMP(6)    
4 PND_DEG_ABBREV VARCHAR2(5)    
5 PND_DEG_COLL1_CD VARCHAR2(2)    
6 PND_DEG_COLL2_CD VARCHAR2(2)    
7 PND_DEG_COLL3_CD VARCHAR2(2)    
8 PND_DEG_CURR1_CD VARCHAR2(4)    
9 PND_DEG_CURR2_CD VARCHAR2(4)    
10 PND_DEG_CURR3_CD VARCHAR2(4)    
11 PND_DEG_TITLE_OPT_CD VARCHAR2(2)    
12 PND_DEG_PERD_DT TIMESTAMP(6)    
13 PND_DEG_STAT VARCHAR2(1)    
14 EXTRACT_TIME TIMESTAMP(6)    
15 PND_DEG_COLL1_HNR_CD VARCHAR2(1)    
16 PND_DEG_CURR1_HNR_CD VARCHAR2(1)    
17 PND_DEG_CURR2_HNR_CD VARCHAR2(1)    
18 PND_DEG_CURR3_HNR_CD VARCHAR2(1)    
19 PND_DEG_MOD_SRC VARCHAR2(8)    
20 PND_DEG_MOD_DT TIMESTAMP(6)    
21 PND_DEG_FULL_NAME_FMLS VARCHAR2(90)    
22 PND_DEG_FNAME VARCHAR2(30)    
23 PND_DEG_FULL_NAME_LFMS VARCHAR2(90)    
24 PND_DEG_LNAME VARCHAR2(30)    
25 PND_DEG_MNAME VARCHAR2(35)    
26 PND_DEG_SNAME VARCHAR2(10)    
27 RUN_TIME TIMESTAMP(6)    
28 SSN VARCHAR2(9)    
29 STU_DEMO_ID VARCHAR2(16)    
30 STU_PND_DEG_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_PREV_SSN ----------

Col # Column Name Data Type Not Null? Comments
1 PREV_SSN_EFF_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 PREV_SSN VARCHAR2(9) Y  
4 STU_PREV_SSN_ID VARCHAR2(16) Y  
5 RUN_TIME TIMESTAMP(6)    
6 STU_DEMO_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_PRODROP ----------

Col # Column Name Data Type Not Null? Comments
1 PRODROP_CAMPUS_CD VARCHAR2(1)    
2 PRODROP_CD VARCHAR2(2)    
3 PRODROP_COLL_CD VARCHAR2(2)    
4 PRODROP_CRE_DT TIMESTAMP(6)    
5 PRODROP_CURR_CD VARCHAR2(4)    
6 PRODROP_EFF_DT TIMESTAMP(6)    
7 PRODROP_END_DT TIMESTAMP(6)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 PRODROP_MOD_DT TIMESTAMP(6)    
10 PRODROP_LVL_GPA NUMBER(5,3)    
11 RUN_TIME TIMESTAMP(6)    
12 PRODROP_SRC VARCHAR2(1)    
13 PRODROP_STAT VARCHAR2(1)    
14 STU_DEMO_ID VARCHAR2(16)    
15 STU_PRODROP_ID VARCHAR2(16) Y  

 

 

Views

---------- View VSTU_SPCL_GRP ----------

Col # Column Name Data Type Not Null? Comments
1 SPCL_GRP_END_DT TIMESTAMP(6)    
2 EXTRACT_TIME TIMESTAMP(6)    
3 RUN_TIME TIMESTAMP(6)    
4 SPCL_GRP_CD VARCHAR2(20)    
5 SPCL_GRP_TYPE VARCHAR2(30)    
6 SPCL_GRP_START_DT TIMESTAMP(6)    
7 STU_DEMO_ID VARCHAR2(16)    
8 STU_SPCL_GRP_ID VARCHAR2(16) Y  
9 STU_TERM_ID VARCHAR2(16)    

 

 

Views

---------- View VSTU_TBC ----------

Col # Column Name Data Type Not Null? Comments
1 TBC_SUBJ_AREA_CD VARCHAR2(10)    
2 TBC_CRDT_TYPE VARCHAR2(1)    
3 TBC_NOM_CRDT NUMBER(5,2)    
4 TBC_CRS_NBR VARCHAR2(4)    
5 TBC_CRS_SUBJ VARCHAR2(10)    
6 TBC_EXAM_CD VARCHAR2(10)    
7 EXTRACT_TIME TIMESTAMP(6)    
8 RUN_TIME TIMESTAMP(6)    
9 SSN VARCHAR2(9) Y  
10 STU_DEMO_ID VARCHAR2(16) Y  
11 STU_TBC_AREA_ID VARCHAR2(16)    
12 STU_TBC_CRS_ID VARCHAR2(16)    

 

 

Views

---------- View VSTU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_DARS_ADVSR1_SSN VARCHAR2(9)    
2 TERM_DARS_ADVSR2_SSN VARCHAR2(9)    
3 TERM_DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 TERM_DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 PND_ASSTSHP_CD VARCHAR2(1)    
6 AUTH_CNTL_CD VARCHAR2(1)    
7 AUTH_DT TIMESTAMP(6)    
8 AUTH_SRC_CD VARCHAR2(1)    
9 TERM_CAMPUS_CD VARCHAR2(1)    
10 TERM_DARS_CATLG1_TERMYR VARCHAR2(4)    
11 TERM_DARS_CATLG2_TERMYR VARCHAR2(4)    
12 TERM_CLASS_CD VARCHAR2(1)    
13 FNL_PRODROP_CD VARCHAR2(2)    
14 INIT_PRODROP_CD VARCHAR2(2)    
15 COLL_ENRL_CATGRY VARCHAR2(1)    
16 TERM_COLL_CD VARCHAR2(2)    
17 FNL_PRODROP_COLL_CD VARCHAR2(2)    
18 INIT_PRODROP_COLL_CD VARCHAR2(2)    
19 TERM_CRDT_NOCRDT_HOUR NUMBER(5,2)    
20 TERM_CRDT_NOCRDT_UNIT NUMBER(5,2)    
21 TERM_CURR_CD VARCHAR2(4)    
22 FNL_PRODROP_CURR_CD VARCHAR2(4)    
23 INIT_PRODROP_CURR_CD VARCHAR2(4)    
24 TERM_DARS_COLL2_CD VARCHAR2(2)    
25 TERM_DARS_CURR2_CD VARCHAR2(4)    
26 TERM_DARS_SUBSPCL1_CD VARCHAR2(2)    
27 TERM_DARS_SUBSPCL2_CD VARCHAR2(2)    
28 DEANS_LIST_CD VARCHAR2(1)    
29 TERM_EARN_HOUR NUMBER(5,2)    
30 TERM_EARN_UNIT NUMBER(5,2)    
31 FNL_PRODROP_EFF_DT TIMESTAMP(6)    
32 INIT_PRODROP_EFF_DT TIMESTAMP(6)    
33 ENC_OVRIDE_IND VARCHAR2(1)    
34 TERM_ENRL_STAT VARCHAR2(1) Y  
35 EXTRACT_TIME TIMESTAMP(6)    
36 TERM_GRD_HOUR NUMBER(5,2)    
37 TERM_GRD_HOUR_PT NUMBER(5,2)    
38 TERM_GRD_UNIT_PT NUMBER(5,2)    
39 TERM_GRD_UNIT NUMBER(5,2)    
40 INIT_REG_SYS_ACS_DT TIMESTAMP(6)    
41 INIT_REG_SYS_ACS_TIME VARCHAR2(8)    
42 JAMES_SCHLR_IND VARCHAR2(1)    
43 TERM_JOINT_PGM_CD VARCHAR2(2)    
44 NEW_STAT VARCHAR2(1)    
45 TERM_NOM_HOUR NUMBER(5,2)    
46 TERM_NOM_UNIT NUMBER(5,2)    
47 OFF_CAMPUS_WORK_POST_IND VARCHAR2(1)    
48 OFF_CAMPUS_PGM_CD VARCHAR2(2)    
49 TERM_OVRLD_HOUR NUMBER(4,2)    
50 TERM_PND_HOUR NUMBER(5,2)    
51 TERM_PND_UNIT NUMBER(5,2)    
52 TERM_DARS_PPINTRST1_CD VARCHAR2(3)    
53 TERM_DARS_PPINTRST2_CD VARCHAR2(3)    
54 PREV_TERM_CAMPUS_CD VARCHAR2(1)    
55 PREV_TERM_COLL_CD VARCHAR2(2)    
56 PREV_TERM_CURR_CD VARCHAR2(4)    
57 PREV_TERM_JOINT_PGM_CD VARCHAR2(2)    
58 PREV_TERM_SEQ_NBR NUMBER(5)    
59 PREV_TERM_SUBSPCL_CD VARCHAR2(2)    
60 FNL_PRODROP_LVL_GPA NUMBER(5,3)    
61 INIT_PRODROP_LVL_GPA NUMBER(5,3)    
62 TERM_REG_DT TIMESTAMP(6)    
63 TERM_REG_TERMN_DT TIMESTAMP(6)    
64 TERM_RES_IND VARCHAR2(1)    
65 RUN_TIME TIMESTAMP(6)    
66 TERM_SEQ_NBR NUMBER(5)    
67 FNL_PRODROP_SRC_CD VARCHAR2(1)    
68 INIT_PRODROP_SRC_CD VARCHAR2(1)    
69 SSN VARCHAR2(9) Y  
70 FNL_PRODROP_STAT_CD VARCHAR2(1)    
71 INIT_PRODROP_STAT_CD VARCHAR2(1)    
72 STU_DEMO_ID VARCHAR2(16) Y  
73 STU_TERM_ID VARCHAR2(16) Y  
74 TERM_SUBSPCL_CD VARCHAR2(2)    
75 TERM_END_DT TIMESTAMP(6)    
76 DEFN_TERM_ID VARCHAR2(16) Y  
77 TERM_START_DT TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_TERMYR VARCHAR2(4) Y  
80 TERM_UNDLD_HOUR NUMBER(5,2)    
81 VEH_REG_IND VARCHAR2(1)    
82 TERM_VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DT TIMESTAMP(6)    

 

 

Views

---------- View VSTU_TERM_XM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_DARS_ADVSR1_SSN VARCHAR2(9)    
2 TERM_DARS_ADVSR2_SSN VARCHAR2(9)    
3 TERM_DARS_ANCRS1_CURR_CD VARCHAR2(4)    
4 TERM_DARS_ANCRS2_CURR_CD VARCHAR2(4)    
5 PND_ASSTSHP_CD VARCHAR2(1)    
6 AUTH_CNTL_CD VARCHAR2(1)    
7 AUTH_DT TIMESTAMP(6)    
8 AUTH_SRC_CD VARCHAR2(1)    
9 TERM_CAMPUS_CD VARCHAR2(1)    
10 TERM_DARS_CATLG1_TERMYR VARCHAR2(4)    
11 TERM_DARS_CATLG2_TERMYR VARCHAR2(4)    
12 TERM_CLASS_CD VARCHAR2(1)    
13 FNL_PRODROP_CD VARCHAR2(2)    
14 INIT_PRODROP_CD VARCHAR2(2)    
15 COLL_ENRL_CATGRY VARCHAR2(1)    
16 TERM_COLL_CD VARCHAR2(2)    
17 FNL_PRODROP_COLL_CD VARCHAR2(2)    
18 INIT_PRODROP_COLL_CD VARCHAR2(2)    
19 TERM_CRDT_NOCRDT_HOUR NUMBER(5,2)    
20 TERM_CRDT_NOCRDT_UNIT NUMBER(5,2)    
21 TERM_CURR_CD VARCHAR2(4)    
22 FNL_PRODROP_CURR_CD VARCHAR2(4)    
23 INIT_PRODROP_CURR_CD VARCHAR2(4)    
24 TERM_DARS_COLL2_CD VARCHAR2(2)    
25 TERM_DARS_CURR2_CD VARCHAR2(4)    
26 TERM_DARS_SUBSPCL1_CD VARCHAR2(2)    
27 TERM_DARS_SUBSPCL2_CD VARCHAR2(2)    
28 DEANS_LIST_CD VARCHAR2(1)    
29 TERM_EARN_HOUR NUMBER(5,2)    
30 TERM_EARN_UNIT NUMBER(5,2)    
31 FNL_PRODROP_EFF_DT TIMESTAMP(6)    
32 INIT_PRODROP_EFF_DT TIMESTAMP(6)    
33 ENC_OVRIDE_IND VARCHAR2(1)    
34 TERM_ENRL_STAT VARCHAR2(1) Y  
35 EXTRACT_TIME TIMESTAMP(6)    
36 TERM_GRD_HOUR NUMBER(5,2)    
37 TERM_GRD_HOUR_PT NUMBER(5,2)    
38 TERM_GRD_UNIT_PT NUMBER(5,2)    
39 TERM_GRD_UNIT NUMBER(5,2)    
40 INIT_REG_SYS_ACS_DT TIMESTAMP(6)    
41 INIT_REG_SYS_ACS_TIME VARCHAR2(8)    
42 JAMES_SCHLR_IND VARCHAR2(1)    
43 TERM_JOINT_PGM_CD VARCHAR2(2)    
44 NEW_STAT VARCHAR2(1)    
45 TERM_NOM_HOUR NUMBER(5,2)    
46 TERM_NOM_UNIT NUMBER(5,2)    
47 OFF_CAMPUS_WORK_POST_IND VARCHAR2(1)    
48 OFF_CAMPUS_PGM_CD VARCHAR2(2)    
49 TERM_OVRLD_HOUR NUMBER(4,2)    
50 TERM_PND_HOUR NUMBER(5,2)    
51 TERM_PND_UNIT NUMBER(5,2)    
52 TERM_DARS_PPINTRST1_CD VARCHAR2(3)    
53 TERM_DARS_PPINTRST2_CD VARCHAR2(3)    
54 PREV_TERM_CAMPUS_CD VARCHAR2(1)    
55 PREV_TERM_COLL_CD VARCHAR2(2)    
56 PREV_TERM_CURR_CD VARCHAR2(4)    
57 PREV_TERM_JOINT_PGM_CD VARCHAR2(2)    
58 PREV_TERM_SEQ_NBR NUMBER(5)    
59 PREV_TERM_SUBSPCL_CD VARCHAR2(2)    
60 FNL_PRODROP_LVL_GPA NUMBER(5,3)    
61 INIT_PRODROP_LVL_GPA NUMBER(5,3)    
62 TERM_REG_DT TIMESTAMP(6)    
63 TERM_REG_TERMN_DT TIMESTAMP(6)    
64 TERM_RES_IND VARCHAR2(1)    
65 RUN_TIME TIMESTAMP(6)    
66 TERM_SEQ_NBR NUMBER(5)    
67 FNL_PRODROP_SRC_CD VARCHAR2(1)    
68 INIT_PRODROP_SRC_CD VARCHAR2(1)    
69 SSN VARCHAR2(9) Y  
70 FNL_PRODROP_STAT_CD VARCHAR2(1)    
71 INIT_PRODROP_STAT_CD VARCHAR2(1)    
72 STU_DEMO_ID VARCHAR2(16) Y  
73 STU_TERM_ID VARCHAR2(16) Y  
74 TERM_SUBSPCL_CD VARCHAR2(2)    
75 TERM_END_DT TIMESTAMP(6)    
76 DEFN_TERM_ID VARCHAR2(16) Y  
77 TERM_START_DT TIMESTAMP(6)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_TERMYR VARCHAR2(4) Y  
80 TERM_UNDLD_HOUR NUMBER(5,2)    
81 VEH_REG_IND VARCHAR2(1)    
82 TERM_VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DT TIMESTAMP(6)    

 

 

Views

---------- View VSTU_TFER_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 TFER_CRS_ACPT_CD VARCHAR2(2)    
2 TFER_CRS_CRDT_TYPE VARCHAR2(1)    
3 TFER_CRS_DUPL_CRDT_CD VARCHAR2(1)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 TFER_CRS_GRD VARCHAR2(2)    
6 TFER_CRS_INST_FICE_CD VARCHAR2(6) Y  
7 TFER_CRS_INST_NAME VARCHAR2(30)    
8 TFER_CRS_NOM_CRDT NUMBER(7,5)    
9 TFER_CRS_NBR VARCHAR2(5)    
10 RUN_TIME TIMESTAMP(6)    
11 TFER_CRS_INST_SEM_QTR_CD VARCHAR2(1)    
12 SSN VARCHAR2(9) Y  
13 TFER_CRS_INST_ST_CD VARCHAR2(2)    
14 STU_DEMO_ID VARCHAR2(16) Y  
15 STU_TFER_CRS_ID VARCHAR2(16) Y  
16 DEFN_TFER_INST_ID VARCHAR2(16)    
17 TFER_CRS_SUBJ_CD VARCHAR2(5)    
18 TFER_CRS_TERMYR VARCHAR2(10)    
19 TFER_CRS_TITLE VARCHAR2(20)    

 

 

Views

---------- View VSTU_TFER_CRS_OLD ----------

Col # Column Name Data Type Not Null? Comments
1 TFER_CRS_ACPT_CD VARCHAR2(2)    
2 TFER_CRS_CRDT_TYPE VARCHAR2(1)    
3 TFER_CRS_DUPL_CRDT_CD VARCHAR2(1)    
4 EXTRACT_TIME TIMESTAMP(6)    
5 TFER_CRS_GRD VARCHAR2(2)    
6 TFER_CRS_INST_FICE_CD VARCHAR2(6) Y  
7 TFER_CRS_INST_NAME VARCHAR2(30)    
8 TFER_CRS_NOM_CRDT NUMBER(7,5)    
9 TFER_CRS_NBR VARCHAR2(5)    
10 RUN_TIME TIMESTAMP(6)    
11 TFER_CRS_INST_SEM_QTR_CD VARCHAR2(1)    
12 SSN VARCHAR2(9) Y  
13 TFER_CRS_INST_ST_CD VARCHAR2(2)    
14 STU_DEMO_ID VARCHAR2(16) Y  
15 STU_TFER_CRS_ID VARCHAR2(16) Y  
16 DEFN_TFER_INST_ID VARCHAR2(16)    
17 TFER_CRS_SUBJ_CD VARCHAR2(5)    
18 TFER_CRS_TERMYR VARCHAR2(10)    
19 TFER_CRS_TITLE VARCHAR2(20)    

 

 

Views

---------- View VSTU_TUIT ----------

Col # Column Name Data Type Not Null? Comments
1 TUIT_CHG_TEXT VARCHAR2(80)    
2 TUIT_CRE_DT TIMESTAMP(6)    
3 TUIT_CRE_TIME VARCHAR2(8)    
4 TUIT_CRE_SRC VARCHAR2(8)    
5 TUIT_EFF_DT TIMESTAMP(6)    
6 TUIT_ELIG_DT TIMESTAMP(6)    
7 TUIT_ELIG_TERMYR VARCHAR2(4)    
8 EXTRACT_TIME TIMESTAMP(6)    
9 PREV_TUIT_IND VARCHAR2(1)    
10 RUN_TIME TIMESTAMP(6)    
11 STU_DEMO_ID VARCHAR2(16)    
12 STU_TUIT_ID VARCHAR2(16) Y  
13 TUIT_UPDT_DT TIMESTAMP(6)    
14 TUIT_UPDT_TIME VARCHAR2(8)    
15 TUIT_UPDT_SRC VARCHAR2(8)    

 

 

Views

---------- View VSTU_XM_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRACT_TIME TIMESTAMP(6)    
2 RUN_TIME TIMESTAMP(6)    
3 STU_XM_CRS_ID VARCHAR2(16) Y  
4 STU_CRS_ID VARCHAR2(16)    
5 XM_ENRL_STAT VARCHAR2(1)    
6 XM_FEE_AMT NUMBER(7,2)    
7 XM_FEE_REFUND_DT TIMESTAMP(6)    
8 XM_LOC_NAME VARCHAR2(20)    
9 XM_PMT_CD VARCHAR2(1)    
10 XM_PROJ_NBR VARCHAR2(5)    

 

 

Views

---------- View VTBL_NAME ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRACT_TIME TIMESTAMP(6)    
2 RUN_TIME TIMESTAMP(6)    
3 TBL_NAME_DESC VARCHAR2(80)    
4 TBL_NAME_ID VARCHAR2(30) Y  

 

 

Views

---------- View VTBL_RSLT ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRACT_TIME TIMESTAMP(6)    
2 TBL_RSLT_VAL VARCHAR2(30) Y  
3 RUN_TIME TIMESTAMP(6)    
4 TBL_NAME_ID VARCHAR2(30)    
5 TBL_RSLT_DESC VARCHAR2(80)    
6 TBL_RSLT_ID VARCHAR2(16) Y  
7 TBL_VAL_ID VARCHAR2(30)    

 

 

Views

---------- View VTBL_VAL ----------

Col # Column Name Data Type Not Null? Comments
1 EXTRACT_TIME TIMESTAMP(6)    
2 RUN_TIME TIMESTAMP(6)    
3 TBL_NAME_ID VARCHAR2(30) Y  
4 TBL_VAL_DESC VARCHAR2(80)    
5 TBL_VAL_ID VARCHAR2(30) Y  

 

 

Views

---------- View V_ENCUMBRANCE_TYPE ----------

Col # Column Name Data Type Not Null? Comments
1 ENCUMBRANC_TYPE_ID VARCHAR2(16) Y  
2 CONTACT_TEXT_1 VARCHAR2(25)    
3 CONTACT_TEXT_2 VARCHAR2(40)    
4 CONTACT_TEXT_3 VARCHAR2(40)    
5 CONTACT_TEXT_4 VARCHAR2(40)    
6 ENCUMBRANCE_CODE VARCHAR2(8)    
7 ENCUMBRANCE_NAME VARCHAR2(30)    
8 ENCUMBRANCE_TYPE VARCHAR2(10)    
9 EXTRACT_TIME VARCHAR2(26) Y  
10 RUN_TIME VARCHAR2(26) Y  

 

 

Views

---------- View V_PERSON_ID_CARD ----------

Col # Column Name Data Type Not Null? Comments
1 PERSON_ID_CARD_ID VARCHAR2(16) Y  
2 CREATE_DATE VARCHAR2(26)    
3 CREATE_TIME VARCHAR2(8)    
4 CREATED_BY VARCHAR2(8)    
5 I_CARD_NUMBER VARCHAR2(9)    
6 PERSON_ID VARCHAR2(16)    
7 PREVIOUS_IND VARCHAR2(1)    
8 UDPATE_TIME VARCHAR2(8)    
9 UPDATED_BY VARCHAR2(8)    
10 EXTRACT_TIME VARCHAR2(26) Y  
11 RUN_TIME VARCHAR2(26) Y  
12 UPDATE_DATE VARCHAR2(26)    

 

 

Views

---------- View V_PSSN ----------

Col # Column Name Data Type Not Null? Comments
1 PREVIOUS_SSN_ID VARCHAR2(16) Y  
2 EFFECTIVE_DATE VARCHAR2(26) Y  
3 EXTRACT_TIME VARCHAR2(26) Y  
4 IDENTIFIER VARCHAR2(16) Y  
5 PREVIOUS_SSN VARCHAR2(9) Y  
6 RUN_TIME VARCHAR2(26) Y  
7 STU_DEMO_ID VARCHAR2(16) Y  

 

 

Views

---------- View V_STUDENT_ADVISING_H ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ADVISING_H_ID VARCHAR2(16) Y  
2 CAMPUS VARCHAR2(1)    
3 CLEARED_BY VARCHAR2(8)    
4 COLLEGE VARCHAR2(2)    
5 CURRICULUM VARCHAR2(4)    
6 DATE_ESTABLISHED VARCHAR2(26)    
7 END_DATE VARCHAR2(26)    
8 EXTRACT_TIME VARCHAR2(26) Y  
9 RUN_TIME VARCHAR2(26) Y  
10 SET_BY VARCHAR2(8)    
11 STU_DEMO_ID VARCHAR2(16)    
12 TYPE_CODE VARCHAR2(1)    

 

 

Views

---------- View V_STUDENT_CAD ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CAD_ID VARCHAR2(16) Y  
2 CAD_TYPE VARCHAR2(2)    
3 EXTRACT_TIME VARCHAR2(26) Y  
4 MODIFY_DATE VARCHAR2(26)    
5 RUN_TIME VARCHAR2(26) Y  
6 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STUDENT_COURSE_XM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_COURSE_XM_ID VARCHAR2(16) Y  
2 EXTRACT_DATE VARCHAR2(26) Y  
3 RUN_TIME VARCHAR2(26) Y  
4 STU_CRS_ID VARCHAR2(16)    
5 XM_ENR_STATUS VARCHAR2(1)    
6 XM_FEE_AMOUNT NUMBER(7,2)    
7 XM_FEE_REFUND_DATE TIMESTAMP(6)    
8 XM_LOCATION VARCHAR2(20)    
9 XM_PAID_CODE VARCHAR2(1)    
10 XM_PROJECT_NUMBER VARCHAR2(5)    

 

 

Views

---------- View V_STUDENT_CURRICULUM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CURRICULUM_ID VARCHAR2(16) Y  
2 ACTIVE_IND VARCHAR2(1)    
3 CAMPUS VARCHAR2(1)    
4 COLLEGE VARCHAR2(2)    
5 CURRICULUM VARCHAR2(4)    
6 END_DATE VARCHAR2(26)    
7 EXTRACT_TIME VARCHAR2(26) Y  
8 JOINT_PROGRAM VARCHAR2(2)    
9 RUN_TIME VARCHAR2(26) Y  
10 SEQUENCE_NUMBER NUMBER(5)    
11 START_DATE VARCHAR2(26)    
12 STU_CURRICULUM_TYP VARCHAR2(10)    
13 STU_TERM_ID VARCHAR2(16)    
14 SUBSPECIALTY VARCHAR2(2)    
15 YEAR_TERM VARCHAR2(4)    

 

 

Views

---------- View V_STUDENT_DARS_CODES ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DARS_CODES_ID VARCHAR2(16) Y  
2 ADVISOR_SSN_1 VARCHAR2(9)    
3 ADVISOR_SSN_2 VARCHAR2(9)    
4 ANCILLARY_CSWK_1 VARCHAR2(4)    
5 ANCILLARY_CSWK_2 VARCHAR2(4)    
6 CATALOG_YEAR_1 VARCHAR2(4)    
7 CATALOG_YEAR_2 VARCHAR2(4)    
8 DARS_OPTION_1 VARCHAR2(2)    
9 DARS_PGM_ID_2 VARCHAR2(8)    
10 EXTRACT_TIME VARCHAR2(26) Y  
11 PREPROF_INTEREST_1 VARCHAR2(3)    
12 PREPROF_INTEREST_2 VARCHAR2(3)    
13 RUN_TIME VARCHAR2(26) Y  
14 STU_TERM_ID VARCHAR2(16)    
15 YEAR_TERM VARCHAR2(4)    

 

 

Views

---------- View V_STUDENT_ENCUMBRANC ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ENCUMBRANC_ID VARCHAR2(16) Y  
2 AMOUNT NUMBER(7,2)    
3 CAMPUS VARCHAR2(1)    
4 CLEARED_BY VARCHAR2(8)    
5 CLEARED_DATE VARCHAR2(26)    
6 COLLEGE VARCHAR2(2)    
7 DATE_ENTERED VARCHAR2(26)    
8 DEPARTMENT VARCHAR2(4)    
9 DESCRIPTION VARCHAR2(70)    
10 EFFECTIVE_DATE VARCHAR2(26)    
11 ENCUMBRANC_TYPE_ID VARCHAR2(16)    
12 EXTRACT_TIME VARCHAR2(26) Y  
13 RUN_TIME VARCHAR2(26) Y  
14 SET_BY VARCHAR2(8)    
15 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STUDENT_GDOL ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GDOL_ID VARCHAR2(16) Y  
2 COLLEGE VARCHAR2(2)    
3 CURRICULUM VARCHAR2(4)    
4 DEGR_TERM_CHNG_DAT VARCHAR2(26)    
5 DEGR_TERM_DATE VARCHAR2(26)    
6 DOCT_EVAL_CODE VARCHAR2(1)    
7 EFFECTIVE_DATE VARCHAR2(26)    
8 EXTRACT_TIME VARCHAR2(26) Y  
9 FELLOWSHIP_CUM_SEM NUMBER(5)    
10 LEVEL_CODE VARCHAR2(1)    
11 OBJECTIVE_CODE VARCHAR2(1)    
12 RUN_TIME VARCHAR2(26) Y  
13 STU_DEMO_ID VARCHAR2(16)    
14 THESIS_ADVISOR VARCHAR2(20)    
15 THESIS_CUM_UNITS NUMBER(5,2)    
16 THESIS_DEPOSIT_DAT VARCHAR2(26)    

 

 

Views

---------- View V_STUDENT_GRAD_DATA ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GRAD_DATA_ID VARCHAR2(16) Y  
2 ENTERING_DATE_GRAD VARCHAR2(26)    
3 EXTRACT_TIME VARCHAR2(26) Y  
4 RUN_TIME VARCHAR2(26) Y  
5 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STUDENT_GRAD_EXAM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GRAD_EXAM_ID VARCHAR2(16) Y  
2 APPOINTMENT_DATE VARCHAR2(26)    
3 COLLEGE VARCHAR2(2)    
4 COMM_DISSOLVE_DATE VARCHAR2(26)    
5 CURRICULUM VARCHAR2(4)    
6 EXAM_DATE VARCHAR2(26)    
7 EXAM_RESULT VARCHAR2(1)    
8 EXAM_TYPE VARCHAR2(1)    
9 EXTRACT_TIME VARCHAR2(26) Y  
10 RUN_TIME VARCHAR2(26) Y  
11 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STUDENT_PRO_DROP ----------

Col # Column Name Data Type Not Null? Comments
1 STU_PRO_DROP_ID VARCHAR2(16) Y  
2 CAMPUS VARCHAR2(1)    
3 CODE VARCHAR2(2)    
4 COLLEGE VARCHAR2(2)    
5 CREATE_DATE VARCHAR2(26) Y  
6 CURRICULUM VARCHAR2(4)    
7 EFFECTIVE_DATE VARCHAR2(26)    
8 END_DATE VARCHAR2(26)    
9 EXTRACT_TIME VARCHAR2(26) Y  
10 MODIFY_DATE VARCHAR2(26)    
11 PRO_LEVEL NUMBER(5,3)    
12 RUN_TIME VARCHAR2(26) Y  
13 SOURCE VARCHAR2(1)    
14 STATUS VARCHAR2(1)    
15 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STUDENT_SPECIAL_GR ----------

Col # Column Name Data Type Not Null? Comments
1 STU_SPECIAL_GR_ID VARCHAR2(16) Y  
2 END_DATE VARCHAR2(26)    
3 EXTRACT_TIME VARCHAR2(26) Y  
4 RUN_TIME VARCHAR2(26) Y  
5 SPECIAL_GROUP_CODE VARCHAR2(20)    
6 SPECIAL_GROUP_TYPE VARCHAR2(30)    
7 START_DATE VARCHAR2(26)    
8 STU_DEMO_ID VARCHAR2(16)    
9 STU_TERM_ID VARCHAR2(16)    

 

 

Views

---------- View V_STUDENT_TUITION ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TUITION_ID VARCHAR2(16) Y  
2 CHANGE_TEXT VARCHAR2(80)    
3 CREATE_DATE VARCHAR2(26)    
4 CREATE_TIME VARCHAR2(8)    
5 CREATED_BY VARCHAR2(8)    
6 EFFECTIVE_DATE VARCHAR2(26)    
7 ELIGIBLE_DATE VARCHAR2(26)    
8 ELIGIBLE_TERM_YEAR VARCHAR2(4)    
9 EXTRACT_TIME VARCHAR2(26) Y  
10 PREVIOUS_IND VARCHAR2(1)    
11 RUN_TIME VARCHAR2(26) Y  
12 STU_DEMO_ID VARCHAR2(16)    
13 UDPATE_DATE VARCHAR2(26)    
14 UDPATE_TIME VARCHAR2(8)    
15 UPDATED_BY VARCHAR2(8)    

 

 

Views

---------- View V_STU_ADM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ADM_ID VARCHAR2(16) Y  
2 ADM_CODE VARCHAR2(2)    
3 ADM_DECISION VARCHAR2(2)    
4 ADM_DECISION_DATE VARCHAR2(26)    
5 CAMPUS_SI VARCHAR2(2)    
6 CLASS VARCHAR2(1)    
7 COLL_REVIEW VARCHAR2(1)    
8 COLL_SI VARCHAR2(2)    
9 COLLEGE VARCHAR2(2)    
10 CURRICULUM VARCHAR2(4)    
11 DEG_OBJECTIVE VARCHAR2(1)    
12 EDUCATIONAL_MAJOR VARCHAR2(3)    
13 ENGL_LANG_COMP VARCHAR2(1)    
14 ENGL_LANG_SCORE VARCHAR2(3)    
15 EXTRACT_TIME VARCHAR2(26) Y  
16 GPA_GRAD NUMBER(3,2)    
17 GPA_UGRAD NUMBER(3,2)    
18 HRS_EARNED_STATUS VARCHAR2(1)    
19 HS_GRADES VARCHAR2(4)    
20 HS_PCT_COLL_DECILE NUMBER(5)    
21 INTEREST_HONORS VARCHAR2(1)    
22 INTEREST_IND_STUDY VARCHAR2(1)    
23 LAW_SI NUMBER(3,1)    
24 NOA_ISSUED_DATE VARCHAR2(26)    
25 NOA_MSG_1 VARCHAR2(1)    
26 NOA_MSG_2 VARCHAR2(1)    
27 NOA_MSG_3 VARCHAR2(1)    
28 NOA_STATUS VARCHAR2(1)    
29 PATTERN_1 VARCHAR2(1)    
30 PATTERN_2 VARCHAR2(1)    
31 PATTERN_3 VARCHAR2(1)    
32 PATTERN_4 VARCHAR2(1)    
33 PATTERN_5 VARCHAR2(1)    
34 RUN_TIME VARCHAR2(26) Y  
35 SPECIAL_CATEGORY VARCHAR2(1)    
36 SPECIAL_GROUP_1A VARCHAR2(1)    
37 SPECIAL_GROUP_2A VARCHAR2(1)    
38 SPECIAL_GROUP_3 VARCHAR2(1)    
39 SPECIAL_GROUP_4 VARCHAR2(1)    
40 SSN VARCHAR2(9)    
41 STU_DEMO_ID VARCHAR2(16) Y  
42 SUBSPECIALTY VARCHAR2(2)    
43 TERM_DATE VARCHAR2(26)    
44 TFER_GPA NUMBER(5,3)    
45 TFER_HRS_EARNED NUMBER(5,2)    
46 TFER_HRS_GRADED NUMBER(5,2)    
47 TFER_POINTS NUMBER(7,2)    
48 VM_CUM_GPA NUMBER(5,3)    
49 VM_CUM_HRS_GRADED NUMBER(5,2)    
50 VM_SCI_HRS_GRADED NUMBER(5,2)    
51 VM_SCIENCE_GPA NUMBER(5,3)    
52 VM_SUBJECTIVE_EVAL VARCHAR2(3)    

 

 

Views

---------- View V_STU_ADM_TST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_ADM_TST_ID VARCHAR2(16) Y  
2 EXTRACT_TIME VARCHAR2(26) Y  
3 RUN_TIME VARCHAR2(26) Y  
4 SSN VARCHAR2(9) Y  
5 STU_DEMO_ID VARCHAR2(16) Y  
6 TEST_AREA VARCHAR2(2)    
7 TEST_DATE VARCHAR2(26)    
8 TEST_NATL_PCTILE NUMBER(5)    
9 TEST_SCORE NUMBER(5)    
10 TEST_TYPE VARCHAR2(4)    
11 TEST_UI_DECILE NUMBER(5)    

 

 

Views

---------- View V_STU_AWD_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 STU_AWD_DEG_ID VARCHAR2(16) Y  
2 ABBREVIATION VARCHAR2(5)    
3 AWARDED_DATE VARCHAR2(26)    
4 CIPS_CODE VARCHAR2(8)    
5 CIPS_CODE_TEXT VARCHAR2(55)    
6 COLL_HONORS_TEXT VARCHAR2(15)    
7 COLLEGE VARCHAR2(2)    
8 COLLEGE_HONORS VARCHAR2(1)    
9 COLLEGE_NAME VARCHAR2(15)    
10 CURR_HONORS_TEXT VARCHAR2(25)    
11 CURRICULUM VARCHAR2(4)    
12 CURRICULUM_HONORS VARCHAR2(1)    
13 CURRICULUM_NAME VARCHAR2(45)    
14 CURRICULUM2 VARCHAR2(4)    
15 CURRICULUM2_HONORS VARCHAR2(1)    
16 CURRICULUM2_NAME VARCHAR2(45)    
17 CURRICULUM3 VARCHAR2(4)    
18 CURRICULUM3_HONORS VARCHAR2(1)    
19 CURRICULUM3_NAME VARCHAR2(45)    
20 CURR2_HONORS_TEXT VARCHAR2(25)    
21 CURR3_HONORS_TEXT VARCHAR2(25)    
22 DEGR_STUDENT_NAME VARCHAR2(90)    
23 DEGR_TITLE_OPTION VARCHAR2(2)    
24 DEGREE_CODE VARCHAR2(2)    
25 DEGREE_PERIOD VARCHAR2(5)    
26 EXTRACT_TIME VARCHAR2(26) Y  
27 LEDGER_TITLE VARCHAR2(120)    
28 MODIFY_DATE VARCHAR2(26) Y  
29 NAME_SPECIAL_CHAR VARCHAR2(1)    
30 RUN_TIME VARCHAR2(26) Y  
31 STATUS VARCHAR2(1)    
32 STU_AWD_DEG_TYPE VARCHAR2(1)    
33 STU_DEMO_ID VARCHAR2(16)    
34 TRANSCRIPT_TITLE VARCHAR2(120)    

 

 

Views

---------- View V_STU_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CRS_ID VARCHAR2(16) Y  
2 CREDIT_NO_CREDIT VARCHAR2(1)    
3 CREDIT_TYPE VARCHAR2(1)    
4 DEPT_CODE VARCHAR2(5)    
5 DROP_DATE VARCHAR2(26)    
6 DROP_EFFECTIVE_DAT VARCHAR2(26)    
7 DROP_TYPE VARCHAR2(10)    
8 DROPPED_BY VARCHAR2(8)    
9 DUPLICATE_CODE VARCHAR2(1)    
10 E_BY_RULE VARCHAR2(1)    
11 EARNED_CREDIT NUMBER(5,2)    
12 END_DATE VARCHAR2(26)    
13 ENROLL_DATE VARCHAR2(26)    
14 EX_EXPIRATION_DATE VARCHAR2(26)    
15 EXTRACT_TIME VARCHAR2(26) Y  
16 GRADE VARCHAR2(2)    
17 GRADED_CREDIT NUMBER(5,2)    
18 GRADED_SEC_ITYPE VARCHAR2(10) Y  
19 GRADED_SEC_NAME VARCHAR2(3) Y  
20 HONORS_CODE VARCHAR2(1)    
21 NOMINAL_CREDIT NUMBER(4,2)    
22 NUMBER_STU_CRS VARCHAR2(3)    
23 NUMBER_PREFIX VARCHAR2(1)    
24 ORIG_GRADED_SEC_NAME VARCHAR2(3)    
25 PRE_CR_NC_GRADE VARCHAR2(2)    
26 PREVIOUS_GRADE_IND VARCHAR2(1)    
27 RELIGIOUS_IND VARCHAR2(1)    
28 REMEDIAL_IND VARCHAR2(1)    
29 RUBRIC VARCHAR2(5) Y  
30 RUN_TIME VARCHAR2(26) Y  
31 SPECIAL_ACTION_COL VARCHAR2(2)    
32 SSN VARCHAR2(9) Y  
33 START_DATE VARCHAR2(26)    
34 STU_TERM_ID VARCHAR2(16) Y  
35 TECHNICAL_IND VARCHAR2(1)    
36 TERM_END_DATE VARCHAR2(26)    
37 TERM_TYPE VARCHAR2(2) Y  
38 TERM_YEAR VARCHAR2(4) Y  
39 TITLE VARCHAR2(20)    
40 TSCR_NO_POST_IND VARCHAR2(1)    
41 VISITOR_IND VARCHAR2(1)    
42 WITHDRAWN_IND VARCHAR2(1)    
43 YEAR_TERM VARCHAR2(4) Y  

 

 

Views

---------- View V_STU_CRS_SEC ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CRS_SEC_ID VARCHAR2(16) Y  
2 ITYPE VARCHAR2(10) Y  
3 ADDED_BY VARCHAR2(8)    
4 DROP_DATE VARCHAR2(26)    
5 DROP_TYPE VARCHAR2(10)    
6 DROPPED_BY VARCHAR2(8)    
7 ENROLL_DATE VARCHAR2(26)    
8 EXTRACT_TIME VARCHAR2(26) Y  
9 GRADED_INDICATOR VARCHAR2(1) Y  
10 RUN_TIME VARCHAR2(26) Y  
11 SEC_NAME VARCHAR2(3) Y  
12 STU_CRS_ID VARCHAR2(16) Y  
13 TERM_YEAR VARCHAR2(4)    
14 WITHDRAWN_IND VARCHAR2(1)    

 

 

Views

---------- View V_STU_CUR_ADDR ----------

Col # Column Name Data Type Not Null? Comments
1 STU_CUR_ADDR_ID VARCHAR2(16) Y  
2 CITY VARCHAR2(15)    
3 COUNTRY VARCHAR2(3)    
4 EFFECTIVE_DATE VARCHAR2(26) Y  
5 EXTRACT_TIME VARCHAR2(26) Y  
6 LINE1 VARCHAR2(30)    
7 LINE2 VARCHAR2(30)    
8 MAIL_CODE VARCHAR2(6)    
9 PHONE_NUMBER VARCHAR2(25)    
10 RUN_TIME VARCHAR2(26) Y  
11 STATE VARCHAR2(2) Y  
12 STREET VARCHAR2(30)    
13 STU_CUR_ADDR_TYPE VARCHAR2(10) Y  
14 STU_DEMO_ID VARCHAR2(16)    
15 ZIP VARCHAR2(9)    

 

 

Views

---------- View V_STU_DEMO ----------

Col # Column Name Data Type Not Null? Comments
1 STU_DEMO_ID VARCHAR2(16) Y  
2 ADDRESS_REVIEW_DAT VARCHAR2(26)    
3 BIRTH_DATE VARCHAR2(26)    
4 BLOOD_DONOR VARCHAR2(1)    
5 BLOOD_DONOR_DATE VARCHAR2(26)    
6 COLLEGE VARCHAR2(2)    
7 CURRENT_FULL_NAME VARCHAR2(40) Y  
8 CURRICULUM VARCHAR2(4)    
9 DECEASED_DATE VARCHAR2(26)    
10 EFFECTIVE_DATE VARCHAR2(26) Y  
11 EMAIL_ADDR VARCHAR2(17) Y  
12 ENROLLMENT_PATTERN VARCHAR2(1)    
13 ENROLLMENT_STATUS VARCHAR2(1) Y  
14 ENTERING_DATE_UI VARCHAR2(26)    
15 EXPECTED_DEGREE VARCHAR2(5)    
16 EXPECTED_DEGREE_DA VARCHAR2(26)    
17 EXTRACT_TIME VARCHAR2(26) Y  
18 FAT_CHANGE_DATE VARCHAR2(26)    
19 FAT_CHANGED_BY VARCHAR2(8)    
20 FERPA_ED_DATE VARCHAR2(26)    
21 FERPA_ST_DATE VARCHAR2(26)    
22 FERPA_TYPE VARCHAR2(20)    
23 FIRST_NAME VARCHAR2(30) Y  
24 FIRST_TERM_DATE VARCHAR2(26)    
25 FIRST_TERM_TYPE VARCHAR2(2) Y  
26 FIRST_TERM_YEAR VARCHAR2(4) Y  
27 FRGN_STUD_SUPPORT VARCHAR2(1)    
28 FULL_NAME_UPPER_CA VARCHAR2(40)    
29 GED_TEST_IND VARCHAR2(1)    
30 I_CARD_NUMBER VARCHAR2(9)    
31 JR_COLLEGE_CODE VARCHAR2(2)    
32 LAST_AUTH_DATE VARCHAR2(26)    
33 LAST_AUTH_LOCK VARCHAR2(1)    
34 LAST_NAME VARCHAR2(30) Y  
35 LAST_TERM_DATE VARCHAR2(26)    
36 LAST_TERM_TYPE VARCHAR2(2) Y  
37 LAST_TERM_YEAR VARCHAR2(4) Y  
38 MIDDLE_NAME VARCHAR2(35)    
39 NETWORK_ID VARCHAR2(8)    
40 PERS_CONTINENT VARCHAR2(2)    
41 PERS_COUNTRY VARCHAR2(3)    
42 PERS_COUNTY VARCHAR2(3)    
43 PERS_STATE VARCHAR2(2)    
44 PERSON_ID VARCHAR2(16)    
45 PREVIOUS_INDICATOR VARCHAR2(1)    
46 RELIGIOUS_FND_DATE VARCHAR2(26)    
47 RELIGIOUS_FOUNDATI VARCHAR2(3)    
48 RESIDENCE VARCHAR2(1)    
49 RESIDENCE_CHANGE_D VARCHAR2(26)    
50 RUN_TIME VARCHAR2(26) Y  
51 SEX VARCHAR2(1)    
52 SF_CREATE_DATE VARCHAR2(26)    
53 SPECIAL_CHAR_IND VARCHAR2(1)    
54 SSN VARCHAR2(9) Y  
55 STUDENT_ACCESS_LOC VARCHAR2(1)    
56 STUDENT_CIT_CHANGE VARCHAR2(26)    
57 STUDENT_CITIZENSHI VARCHAR2(1)    
58 STUDENT_ETHNIC VARCHAR2(1)    
59 SUFFIX VARCHAR2(10)    
60 TERMINATION_TERM VARCHAR2(4) Y  
61 VALIDATION_STATUS VARCHAR2(1)    
62 VETERAN_DISCHARGE VARCHAR2(26)    
63 VETERAN_IND VARCHAR2(1)    

 

 

Views

---------- View V_STU_EXT_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 STU_EXT_DEG_ID VARCHAR2(16) Y  
2 ACCEPT_DATE VARCHAR2(26)    
3 DEGREE_DATE VARCHAR2(26)    
4 DEGREE_LEVEL VARCHAR2(2)    
5 DEGREE_NAME VARCHAR2(25) Y  
6 DEGREE_YEAR NUMBER(5)    
7 EXTRACT_TIME VARCHAR2(26) Y  
8 INSTITUTION_CODE VARCHAR2(6)    
9 INSTITUTION_NAME VARCHAR2(30)    
10 MISSING_CREDENTIAL VARCHAR2(1)    
11 RUN_TIME VARCHAR2(26) Y  
12 SEQUENCE_NUMBER NUMBER(5)    
13 SOURCE VARCHAR2(1)    
14 STU_DEMO_ID VARCHAR2(16)    
15 STU_TFER_INST_ID VARCHAR2(16)    

 

 

Views

---------- View V_STU_GAS ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GAS_ID VARCHAR2(16) Y  
2 DEPT_MIN_AVG NUMBER(4,3)    
3 EFFECTIVE_DATE VARCHAR2(26)    
4 EXTRACT_TIME VARCHAR2(26) Y  
5 GAS_CODE VARCHAR2(1)    
6 GPA_REVIEW VARCHAR2(1)    
7 LTD_DEPT_DEFICIENC VARCHAR2(1)    
8 LTD_ENG_COMP VARCHAR2(1)    
9 LTD_GPA_BELOW_MIN VARCHAR2(1)    
10 LTD_GPA_NOT_AVG VARCHAR2(1)    
11 LTD_MISSING_CRED VARCHAR2(1)    
12 LTD_NO_US_BACC_EQU VARCHAR2(1)    
13 RUN_TIME VARCHAR2(26) Y  
14 SSN VARCHAR2(9) Y  
15 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STU_GRAD_DATA ----------

Col # Column Name Data Type Not Null? Comments
1 STU_GRAD_DATA_ID VARCHAR2(16) Y  
2 ENTERING_DATE_GRAD VARCHAR2(26)    
3 EXTRACT_TIME VARCHAR2(26) Y  
4 RUN_TIME VARCHAR2(26) Y  
5 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STU_HS_ENRL ----------

Col # Column Name Data Type Not Null? Comments
1 STU_HS_ENRL_ID VARCHAR2(16) Y  
2 CITY_STATE VARCHAR2(18)    
3 CLASS_RANK NUMBER    
4 CLASS_SIZE NUMBER    
5 END_DATE VARCHAR2(26)    
6 EXTRACT_TIME VARCHAR2(26) Y  
7 GRADUATION_DATE VARCHAR2(26)    
8 HONORS_COURSES VARCHAR2(1)    
9 HS_CODE VARCHAR2(6)    
10 HS_NAME VARCHAR2(30)    
11 PERCENTILE_RANK_UI NUMBER(5)    
12 PERCENTILE_UI_HS NUMBER(5)    
13 RANK_EXCEPTION VARCHAR2(1)    
14 RUN_TIME VARCHAR2(26) Y  
15 SSN VARCHAR2(9) Y  
16 START_DATE VARCHAR2(26)    
17 STU_DEMO_ID VARCHAR2(16)    
18 STU_HS_INST_ID VARCHAR2(16)    
19 ZIP VARCHAR2(9)    

 

 

Views

---------- View V_STU_HS_INST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_HS_INST_ID VARCHAR2(16) Y  
2 ACCREDITATION_TYPE VARCHAR2(1)    
3 AP_COURSES VARCHAR2(1)    
4 BUILDING_MNEMONIC VARCHAR2(5)    
5 BUILDING_ROOM VARCHAR2(10)    
6 CHANGE_REASON VARCHAR2(10)    
7 CITY VARCHAR2(20)    
8 CLASS_SIZE VARCHAR2(4)    
9 COMMUNITY_COLLEGE VARCHAR2(10)    
10 CONTACT_PERSON VARCHAR2(20)    
11 COUNTRY VARCHAR2(3)    
12 COUNTY_CODE VARCHAR2(3)    
13 COUNTY_NAME VARCHAR2(80)    
14 EFFECTIVE_DATE VARCHAR2(26) Y  
15 END_DATE VARCHAR2(26)    
16 EXTRACT_TIME VARCHAR2(26) Y  
17 HONORS_COURSES VARCHAR2(1)    
18 HS_CODE VARCHAR2(6) Y  
19 HS_INST_TYPE VARCHAR2(10) Y  
20 HS_NAME VARCHAR2(40)    
21 HS_NAME_UPPER_CASE VARCHAR2(40)    
22 LINE1 VARCHAR2(30)    
23 LINE2 VARCHAR2(30)    
24 MAIL_CODE VARCHAR2(6)    
25 PHONE VARCHAR2(20)    
26 RANK_EXCEPTION VARCHAR2(1)    
27 RUN_TIME VARCHAR2(26) Y  
28 SEMESTER_BASIS VARCHAR2(1)    
29 SIZE_CODE VARCHAR2(1)    
30 SPECIAL_REVIEW_IND VARCHAR2(1)    
31 START_DATE VARCHAR2(26)    
32 STATE VARCHAR2(2)    
33 STREET VARCHAR2(30) Y  
34 TERMINATION_REASON VARCHAR2(20)    
35 TYPE_CODE VARCHAR2(1)    
36 WEIGHTED_RANK VARCHAR2(1)    
37 ZIP VARCHAR2(9)    

 

 

Views

---------- View V_STU_HS_SUBJ ----------

Col # Column Name Data Type Not Null? Comments
1 STU_HS_SUBJ_ID VARCHAR2(16) Y  
2 EXTRACT_TIME VARCHAR2(26) Y  
3 RUN_TIME VARCHAR2(26) Y  
4 SSN VARCHAR2(9) Y  
5 STU_DEMO_ID VARCHAR2(16)    
6 STU_HS_ENRL_ID VARCHAR2(16)    
7 SUBJECT_NAME VARCHAR2(20) Y  
8 SUBJECT_UNITS NUMBER(4,2)    

 

 

Views

---------- View V_STU_MIDSEMESTER ----------

Col # Column Name Data Type Not Null? Comments
1 STU_MIDSEMESTER_ID VARCHAR2(16) Y  
2 CREATE_DATE VARCHAR2(26)    
3 EXTRACT_TIME VARCHAR2(26) Y  
4 GRADE VARCHAR2(2)    
5 RUN_TIME VARCHAR2(26) Y  
6 STU_CRS_ID VARCHAR2(16)    
7 UPDATE_DATE VARCHAR2(26)    

 

 

Views

---------- View V_STU_PND_DEG ----------

Col # Column Name Data Type Not Null? Comments
1 STU_PND_DEG_ID VARCHAR2(16) Y  
2 COMMENTS VARCHAR2(60)    
3 COMMENTS_LINE_2 VARCHAR2(60)    
4 CREATE_DATE VARCHAR2(26)    
5 DEGREE_ABBREVIATIO VARCHAR2(5)    
6 DEGREE_COLLEGE VARCHAR2(2)    
7 DEGREE_COLLEGE2 VARCHAR2(2)    
8 DEGREE_COLLEGE3 VARCHAR2(2)    
9 DEGREE_CURRICULUM VARCHAR2(4)    
10 DEGREE_CURRICULUM2 VARCHAR2(4)    
11 DEGREE_CURRICULUM3 VARCHAR2(4)    
12 DEGREE_OPTION VARCHAR2(2)    
13 DEGREE_PERIOD VARCHAR2(26)    
14 DEGREE_STATUS VARCHAR2(1)    
15 EXTRACT_TIME VARCHAR2(26) Y  
16 HONORS_COLLEGE VARCHAR2(1)    
17 HONORS_CURRICULUM VARCHAR2(1)    
18 HONORS_CURRICULUM2 VARCHAR2(1)    
19 HONORS_CURRICULUM3 VARCHAR2(1)    
20 MODIFIED_BY VARCHAR2(8)    
21 MODIFY_DATE VARCHAR2(26)    
22 NAME_DIPLOMA VARCHAR2(90)    
23 NAME_FIRST VARCHAR2(30)    
24 NAME_FULL VARCHAR2(90)    
25 NAME_LAST VARCHAR2(30)    
26 NAME_MIDDLE VARCHAR2(35)    
27 NAME_SUFFIX VARCHAR2(10)    
28 RUN_TIME VARCHAR2(26) Y  
29 SSN VARCHAR2(9)    
30 STU_DEMO_ID VARCHAR2(16)    

 

 

Views

---------- View V_STU_TBC ----------

Col # Column Name Data Type Not Null? Comments
1 SSN VARCHAR2(9) Y  
2 STU_DEMO_ID VARCHAR2(16) Y  
3 STU_PROFNC_CRS_ID VARCHAR2(16)    
4 STU_PROFNC_AREA_ID VARCHAR2(16)    
5 AREA_SUBJ VARCHAR2(10)    
6 CRS_SUBJ VARCHAR2(10)    
7 CRS_NUMBER VARCHAR2(4)    
8 CRS_CREDIT_TYPE VARCHAR2(1)    
9 CRS_NOMINAL_CREDIT NUMBER(5,2)    
10 EXAM_TYPE VARCHAR2(10)    
11 RUN_TIMER VARCHAR2(26)    
12 EXTRACT_TIME VARCHAR2(26)    

 

 

Views

---------- View V_STU_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TERM_ID VARCHAR2(16) Y  
2 ADVISOR_SSN_1 VARCHAR2(9)    
3 ADVISOR_SSN_2 VARCHAR2(9)    
4 ANCILLARY_CSWK_1 VARCHAR2(4)    
5 ANCILLARY_CSWK_2 VARCHAR2(4)    
6 ASSISTANTSHIP_PEND VARCHAR2(1)    
7 AUTHORIZATION_CONT VARCHAR2(1)    
8 AUTHORIZATION_DATE VARCHAR2(26) Y  
9 AUTHORIZATION_SOUR VARCHAR2(1)    
10 CAMPUS VARCHAR2(1)    
11 CATALOG_YEAR_1 VARCHAR2(4)    
12 CATALOG_YEAR_2 VARCHAR2(4)    
13 CLASS_CODE VARCHAR2(1)    
14 CODE_FIN VARCHAR2(2)    
15 CODE_INI VARCHAR2(2)    
16 COLL_ENR_CATEGORY VARCHAR2(1)    
17 COLLEGE VARCHAR2(2)    
18 COLLEGE_FIN VARCHAR2(2)    
19 COLLEGE_INI VARCHAR2(2)    
20 CR_NC_HOURS NUMBER(5,2)    
21 CR_NC_UNITS NUMBER(5,2)    
22 CURRICULUM VARCHAR2(4)    
23 CURRICULUM_FIN VARCHAR2(4)    
24 CURRICULUM_INI VARCHAR2(4)    
25 DARS_COLL_OPT_2 VARCHAR2(2)    
26 DARS_CURR_OPT_2 VARCHAR2(4)    
27 DARS_OPTION_ID_2 VARCHAR2(2)    
28 DARS_OPTION_1 VARCHAR2(2)    
29 DEANS_LIST_IND VARCHAR2(1)    
30 EARNED_HOURS NUMBER(5,2)    
31 EARNED_UNITS NUMBER(5,2)    
32 EFFECTIVE_DATE_FIN VARCHAR2(26)    
33 EFFECTIVE_DATE_INI VARCHAR2(26)    
34 ENCUMBRANCE_OVERRI VARCHAR2(1)    
35 ENROLLMENT_STATUS VARCHAR2(1) Y  
36 EXTRACT_TIME VARCHAR2(26) Y  
37 GRADED_HOURS NUMBER(5,2)    
38 GRADED_POINTS_HOUR NUMBER(5,2)    
39 GRADED_POINTS_UNIT NUMBER(5,2)    
40 GRADED_UNITS NUMBER(5,2)    
41 INITIAL_ACCESS_DAT VARCHAR2(26)    
42 INITIAL_ACCESS_TIM VARCHAR2(8)    
43 JAMES_SCHOLAR_IND VARCHAR2(1)    
44 JOINT_PROGRAM VARCHAR2(2)    
45 NEW_STATUS VARCHAR2(1)    
46 NOMINAL_HOURS NUMBER(5,2)    
47 NOMINAL_UNITS NUMBER(5,2)    
48 OFF_CAMPUS_ACAD_YE VARCHAR2(1)    
49 OFF_CAMPUS_PROGRAM VARCHAR2(2)    
50 OVERLOAD_HOURS NUMBER(4,2)    
51 PENDING_HOURS NUMBER(5,2)    
52 PENDING_UNITS NUMBER(5,2)    
53 PREPROF_INTEREST_1 VARCHAR2(3)    
54 PREPROF_INTEREST_2 VARCHAR2(3)    
55 PREV_CAMPUS VARCHAR2(1)    
56 PREV_COLLEGE VARCHAR2(2)    
57 PREV_CURRICULUM VARCHAR2(4)    
58 PREV_JOINT_PROGRAM VARCHAR2(2)    
59 PREV_SEQUENCE_NUMR NUMBER(5)    
60 PREV_SUBSPECIALTY VARCHAR2(2)    
61 PRO_LEVEL_FIN NUMBER(5,3)    
62 PRO_LEVEL_INI NUMBER(5,3)    
63 REGISTRATION_DATE VARCHAR2(26)    
64 REGISTRATION_TERMI VARCHAR2(26)    
65 RESIDENCE VARCHAR2(1)    
66 RUN_TIME VARCHAR2(26) Y  
67 SEQUENCE_NUMBER NUMBER(5)    
68 SOURCE_FIN VARCHAR2(1)    
69 SOURCE_INI VARCHAR2(1)    
70 SSN VARCHAR2(9) Y  
71 STATUS_FIN VARCHAR2(1)    
72 STATUS_INI VARCHAR2(1)    
73 STU_DEMO_ID VARCHAR2(16) Y  
74 SUBSPECIALTY VARCHAR2(2)    
75 TERM_END_DATE VARCHAR2(26)    
76 TERM_ID VARCHAR2(16) Y  
77 TERM_START_DATE VARCHAR2(26)    
78 TERM_TYPE VARCHAR2(2) Y  
79 TERM_YEAR VARCHAR2(4) Y  
80 UNDERLOAD_HOURS NUMBER(5,2)    
81 VEHICLE_REGISTRATI VARCHAR2(1)    
82 VISITOR_IND VARCHAR2(1)    
83 WAIVER_RULE_DATE VARCHAR2(26)    

 

 

Views

---------- View V_STU_TFER_CRS ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TFER_CRS_ID VARCHAR2(16) Y  
2 ACCEPT_CODE VARCHAR2(2)    
3 CREDIT_TYPE VARCHAR2(1)    
4 DUPLICATE VARCHAR2(1)    
5 EXTRACT_TIME VARCHAR2(26) Y  
6 GRADE VARCHAR2(2)    
7 INSTITUTION_CODE VARCHAR2(6) Y  
8 INSTITUTION_NAME VARCHAR2(30)    
9 NOMINAL_CREDIT NUMBER(7,5)    
10 NUMBER_STU_TFER_CRS VARCHAR2(5)    
11 RUN_TIME VARCHAR2(26) Y  
12 SEMESTER_QUARTER VARCHAR2(1)    
13 SSN VARCHAR2(9) Y  
14 STATE VARCHAR2(2)    
15 STU_DEMO_ID VARCHAR2(16) Y  
16 STU_TFER_INST_ID VARCHAR2(16)    
17 SUBJECT VARCHAR2(5)    
18 TERM_YEAR VARCHAR2(10)    
19 TITLE VARCHAR2(20)    

 

 

Views

---------- View V_STU_TFER_INST ----------

Col # Column Name Data Type Not Null? Comments
1 STU_TFER_INST_ID VARCHAR2(16) Y  
2 ACCREDITATION VARCHAR2(1)    
3 CALCULATE_GPA VARCHAR2(1)    
4 CLOSED_REASON VARCHAR2(1)    
5 CODE VARCHAR2(6) Y  
6 COUNTRY VARCHAR2(10)    
7 END_DATE VARCHAR2(26)    
8 EXTRACT_TIME VARCHAR2(26) Y  
9 INST_NAME_UPPER_CA VARCHAR2(30)    
10 LIA_CODE VARCHAR2(2)    
11 NAME VARCHAR2(30)    
12 NAME_65 VARCHAR2(65)    
13 RUN_TIME VARCHAR2(26) Y  
14 SEMESTER_OR_QUARTE VARCHAR2(1)    
15 START_DATE VARCHAR2(26)    
16 STATE VARCHAR2(2)    

 

 

Views

---------- View V_TABLE_NAME ----------

Col # Column Name Data Type Not Null? Comments
1 TABLE_NAME_ID VARCHAR2(30) Y  
2 EXTRACT_TIME VARCHAR2(26) Y  
3 RUN_TIME VARCHAR2(26) Y  
4 TABLE_NAME_DESC VARCHAR2(80)    

 

 

Views

---------- View V_TABLE_RSLT ----------

Col # Column Name Data Type Not Null? Comments
1 TABLE_RSLT_ID VARCHAR2(16) Y  
2 EXTRACT_TIME VARCHAR2(26) Y  
3 RSLT_VALUE VARCHAR2(30) Y  
4 RUN_TIME VARCHAR2(26) Y  
5 TABLE_NAME_ID VARCHAR2(30)    
6 TABLE_RSLT_DESC VARCHAR2(80)    
7 TABLE_VALUE_ID VARCHAR2(30)    

 

 

Views

---------- View V_TABLE_VALUE ----------

Col # Column Name Data Type Not Null? Comments
1 TABLE_VALUE_ID VARCHAR2(30) Y  
2 TABLE_NAME_ID VARCHAR2(30) Y  
3 EXTRACT_TIME VARCHAR2(26) Y  
4 RUN_TIME VARCHAR2(26) Y  
5 TABLE_VALUE_DESC VARCHAR2(80)    

 

 

Views

---------- View V_TERM ----------

Col # Column Name Data Type Not Null? Comments
1 TERM_ID VARCHAR2(16) Y  
2 CAMPUS VARCHAR2(1) Y  
3 END_DATE VARCHAR2(26)    
4 EXTRACT_TIME VARCHAR2(26) Y  
5 LAST_CLASS_DATE VARCHAR2(26)    
6 MIS_GRADE_DATE VARCHAR2(26)    
7 MIS_GRADE_LAW VARCHAR2(26)    
8 NAME VARCHAR2(10)    
9 OK_TO_ADD_DROP VARCHAR2(1)    
10 OK_TO_ADVANCE_ENRO VARCHAR2(1)    
11 RUN_TIME VARCHAR2(26) Y  
12 START_DATE VARCHAR2(26)    
13 TERM_TYPE VARCHAR2(10) Y  
14 TERM_YEAR VARCHAR2(4) Y  
15 TRANSCRIPT_TEXT VARCHAR2(20)    
16 YEAR NUMBER(5)