SAA_ADB_COURSES
This table contains the transcript and substitution data for a course.
This table contains the data from R_TRANSCRIPT and R_SUBSTITUTION. The following fields have been added that did not previously exist in either table: SAA_CAREER_RPT, RPT_DATE, TSCRPT_TYPE, SAA_RPT_IDENTIFIER, SAA_DISPLAY_TOPIC, SAA_CRSE_TYPE, SAA_OPRID_NAME, SAA_DISPLAY_OPTION, and STDNT_SUB_NBR.
|
Field |
Type |
Length |
Decimal |
Index |
Idx Pos |
Asc/Desc |
|---|---|---|---|---|---|---|
|
EMPLID |
Char |
11 |
0 |
Pri |
1 |
Asc |
|
ANALYSIS_DB_SEQ |
Nbr |
4 |
0 |
Pri |
2 |
Desc |
|
SAA_CAREER_RPT |
Char |
4 |
0 |
Pri |
3 |
Asc |
|
CRSE_TAG |
Char |
4 |
0 |
Pri |
4 |
Asc |
|
RPT_DATE |
Date |
10 |
0 |
Alt |
1 |
Asc |
|
TSCRPT_TYPE |
Char |
5 |
0 |
Alt |
1 |
Asc |
|
SAA_RPT_IDENTIFIER |
Char |
10 |
0 |
Alt |
1 |
Asc |
|
INSTITUTION |
Char |
5 |
0 |
Not applicable (NA) |
NA |
NA |
|
SRC_INSTITUTION |
Char |
5 |
0 |
NA |
NA |
NA |
|
ACAD_CAREER |
Char |
4 |
0 |
NA |
NA |
NA |
|
SRC_CAREER |
Char |
4 |
0 |
NA |
NA |
NA |
|
CRSE_CAREER |
Char |
4 |
0 |
NA |
NA |
NA |
|
STRM |
Char |
4 |
0 |
NA |
NA |
NA |
|
APPLIED_TERM |
Char |
4 |
0 |
NA |
NA |
NA |
|
TERM_TAKEN |
Char |
4 |
0 |
NA |
NA |
NA |
|
CLASS_NBR |
Nbr |
5 |
0 |
NA |
NA |
NA |
|
STDNT_ENRL_STATUS |
Char |
2 |
0 |
NA |
NA |
NA |
|
UNT_TAKEN |
Nbr |
6 |
2 |
NA |
NA |
NA |
|
UNT_EARNED |
Nbr |
6 |
2 |
NA |
NA |
NA |
|
UNT_PRGRSS |
Nbr |
6 |
2 |
NA |
NA |
NA |
|
GRADING_BASIS_ENRL |
Char |
3 |
0 |
NA |
NA |
NA |
|
CRSE_GRADE_OFF |
Char |
3 |
0 |
NA |
NA |
NA |
|
REPEAT_CODE |
Char |
4 |
0 |
NA |
NA |
NA |
|
ASSOCIATED_CLASS |
Nbr |
4 |
0 |
NA |
NA |
NA |
|
AUDIT_GRADE_BASIS |
Char |
1 |
0 |
NA |
NA |
NA NA |
|
EARN_CREDIT |
Char |
1 |
0 |
NA |
NA |
NA |
|
INCLUDE_IN_GPA |
Char |
1 |
0 |
NA |
NA |
NA |
|
UNITS_ATTEMPTED |
Char |
1 |
0 |
NA |
NA |
NA |
|
GRADE_POINTS |
Nbr |
10 |
3 |
NA |
NA |
NA |
|
CRSE_ID |
Char |
6 |
0 |
NA |
NA |
NA |
|
CRSE_OFFER_NBR |
Nbr |
2 |
0 |
NA |
NA |
NA |
|
SESSION_CODE |
Char |
3 |
0 |
NA |
NA |
NA |
|
CLASS_SECTION |
Char |
4 |
0 |
NA |
NA |
NA |
|
ACAD_GROUP |
Char |
5 |
0 |
NA |
NA |
NA |
|
SUBJECT |
Char |
8 |
0 |
NA |
NA |
NA |
|
CATALOG_NBR |
Char |
10 |
0 |
NA |
NA |
NA |
|
DESCR |
Char |
30 |
0 |
NA |
NA |
NA |
|
SSR_COMPONENT |
Char |
3 |
0 |
NA |
NA |
NA |
|
CRS_TOPIC_ID |
Nbr |
3 |
0 |
NA |
NA |
NA |
|
SAA_DISPLAY_TOPIC |
Char |
1 |
0 |
NA |
NA |
NA |
|
EQUIV_CRSE_ID |
Char |
5 |
0 |
NA |
NA |
NA |
|
OVRD_CRSE_EQUIV_ID |
Char |
1 |
0 |
NA |
NA |
NA |
|
START_DT |
Date |
10 |
0 |
NA |
NA |
NA |
|
END_DT |
Date |
10 |
0 |
NA |
NA |
NA |
|
CRSE_COUNT |
Nbr |
5 |
2 |
NA |
NA |
NA |
|
CLASS_ENRL_TYPE |
Char |
1 |
0 |
NA |
NA |
NA |
|
SAA_CRSE_TYPE |
Char |
1 |
0 |
NA |
NA |
NA |
|
RQ_SCHOOL_TYPE |
Char |
4 |
0 |
NA |
NA |
NA |
|
GRADE_CATEGORY |
Char |
4 |
0 |
NA |
NA |
NA |
|
VALID_ATTEMPT |
Char |
1 |
0 |
NA |
NA |
NA |
|
GRD_PTS_PER_UNIT |
Nbr |
10 |
3 |
NA |
NA |
NA |
|
RQMNT_DESIGNTN |
Char |
4 |
0 |
NA |
NA |
NA |
|
SUB_ACAD_GROUP |
Char |
5 |
0 |
NA |
NA |
NA |
|
SUB_CRSE_ID |
Char |
6 |
0 |
NA |
NA |
NA |
|
SUB_SUBJECT |
Char |
8 |
0 |
NA |
NA |
NA |
|
SUB_CATLG_NBR |
Char |
10 |
0 |
NA |
NA |
NA |
|
SAA_SUB_DESCR |
Char |
30 |
0 |
NA |
NA |
NA |
|
OPRID |
Char |
30 |
0 |
NA |
NA |
NA |
|
SAA_OPRID_NAME |
Char |
50 |
0 |
NA |
NA |
NA |
|
SAA_DISPLAY_OPTION |
Char |
1 |
0 |
NA |
NA |
NA |
|
STDNT_SUB_NBR |
Char |
4 |
0 |
NA |
NA |
NA |
|
DESCR254A |
Char |
254 |
0 |
NA |
NA |
NA |