SAA_ADB_CRSEAVL
This table contains the courses that would be displayed in the Display Select Line in an advisement report. The field SAA_WHERE_DETAIL contains the filter needed to pull in courses, whether it is one course or a wildcard course.
The data in this table is new and cannot be mapped from the Analysis Database tables.
|
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 |
|
SAA_ENTRY_SEQ |
Nbr |
4 |
0 |
Pri |
4 |
Asc |
|
SAA_COURSE_SEQ |
Nbr |
3 |
0 |
Pri |
5 |
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 |
|
COURSE_LIST |
Char |
9 |
0 |
Not applicable (NA) |
NA |
NA |
|
EFFDT |
Date |
10 |
0 |
NA |
NA |
NA |
|
R_COURSE_SEQUENCE |
Nbr |
7 |
0 |
NA |
NA |
NA |
|
RQRMNT_GROUP |
Char |
6 |
0 |
NA |
NA |
NA |
|
RQ_GRP_LINE_NBR |
Char |
4 |
0 |
NA |
NA |
NA |
|
REQUIREMENT |
Char |
9 |
0 |
NA |
NA |
NA |
|
RQ_LINE_NBR |
Char |
4 |
0 |
NA |
NA |
NA |
|
SUBJECT |
Char |
8 |
0 |
NA |
NA |
NA |
|
CATALOG_NBR |
Char |
10 |
0 |
NA |
NA |
NA |
|
CRSE_ID |
Char |
6 |
0 |
NA |
NA |
NA |
|
CRS_TOPIC_ID |
Nbr |
3 |
0 |
NA |
NA |
NA |
|
RQMNT_DESIGNTN |
Char |
4 |
0 |
NA |
NA |
NA |
|
DESCR |
Char |
30 |
0 |
NA |
NA |
NA |
|
SAA_WHERE_DETAIL |
Char |
100 |
0 |
NA |
NA |
NA |