SAA_ADB_WHATIF
This table contains student's academic structure information used in the report. This data is for all reports, not just what-if reports.
This table contains the data from R_WHAT_IF as well as the student's academic structure data if the request is not a what-if request. The following fields have been added that did not previously exist in either table: SAA_CAREER_RPT, SAA_WHATIF_SEQ, TSCRPT_TYPE, SAA_RPT_IDENTIFIER, STDNT_CAR_NBR, PLAN_SEQUENCE, and SUB_PLAN_SEQUENCE.
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_WHATIF_SEQ |
Nbr |
3 |
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 |
ACAD_CAREER |
Char |
4 |
0 |
Not applicable (NA) |
NA |
NA |
CAR_REQ_TERM |
Char |
4 |
0 |
NA |
NA |
NA |
STDNT_CAR_NBR |
Nbr |
3 |
0 |
NA |
NA |
NA |
ACAD_PROG |
Char |
5 |
0 |
NA |
NA |
NA |
ACAD_PROG_TERM |
Char |
4 |
0 |
NA |
NA |
NA |
PLAN_SEQUENCE |
Nbr |
2 |
0 |
NA |
NA |
NA |
ACAD_PLAN |
Char |
10 |
0 |
NA |
NA |
NA |
ACAD_PLAN_TERM |
Char |
4 |
0 |
NA |
NA |
NA |
SUB_PLAN_SEQUENCE |
Nbr |
2 |
0 |
NA |
NA |
NA |
ACAD_SUB_PLAN |
Char |
10 |
0 |
NA |
NA |
NA |
ACAD_SUB_PLAN_TERM |
Char |
4 |
0 |
NA |
NA |
NA |