9.2.0.4
--------------------- Jump to ---------------------
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 |
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
Col # | Column Name | Data Type | Not Null? | Comments |
---|---|---|---|---|
1 | DUMMY_ONE | VARCHAR2(80 BYTE) | Y |
Tables
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
Col # | Column Name | Data Type | Not Null? | Comments |
---|---|---|---|---|
1 | UIUCSTUDENT_USER | VARCHAR2(30 BYTE) | Y | |
2 | FULLNAME | VARCHAR2(30 BYTE) |
Tables
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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) |