SAA_ADB_RESULTS
This table is new and contains detail information about Requirement Group, Requirements, Requirement Lines, Careers, Program, Plans, Subplans, Overrides, and Statistical Information about each area.
This table contains the data from R_RQRMNT_GROUP, R_REQUIREMENT, R_RQRMNT_LINE, R_RG_LINK, R_ORDER, R_CAREER, R_ACAD_PROG, R_ACAD_PLAN_ R_ACAD_SUBPLAN, R_UNIT_CRSE_GPA, R_OVERRIDE_RG, R_OVERRIDE_RQ, and R_OVERRIDE_LN. The following fields have been added that did not previously exist in any of the tables: SAA_CAREER_RPT, SAA_ENTRY_SEQ, RPT_DATE, TSCRPT_TYPE, SAA_REPORT_IDENTIFIER, RQ_GRP_LINE_NBR, RQRMNT_LIST_SEQ, RQ_GRP_LINE_TYPE, RQ_AA_OVERRIDE, ASOF_DATE, SAA_PRINT_CNTL, SAA_DISPLAY_OPTION, SAA_DISPLAY_GPA, SAA_DISPLAY_UNITS, SAA_DISPLAY_CRSCNT, and SAA_OPRID_NAME.
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 |
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 |
ENTRY_R_TYPE |
Char |
6 |
0 |
Not applicable (NA) |
NA |
NA |
ACAD_CAREER |
Char |
4 |
0 |
NA |
NA |
NA |
ACAD_PROG |
Char |
5 |
0 |
NA |
NA |
NA |
ACAD_PLAN |
Char |
10 |
0 |
NA |
NA |
NA |
ACAD_SUB_PLAN |
Char |
10 |
0 |
NA |
NA |
NA |
RQ_DATE |
Date |
10 |
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 |
RQRMNT_LIST_SEQ |
Nbr |
3 |
0 |
NA |
NA |
NA |
RQ_GRP_LINE_TYPE |
Char |
4 |
0 |
NA |
NA |
NA |
REQ_LINE_TYPE |
Char |
3 |
0 |
NA |
NA |
NA |
DISP_SELECT_LINE |
Char |
1 |
0 |
NA |
NA |
NA |
PARTITION_FAIL |
Char |
1 |
0 |
NA |
NA |
NA |
UNITS_REQUIRED |
Nbr |
7 |
2 |
NA |
NA |
NA |
SAA_UNITS_USED |
Nbr |
7 |
2 |
NA |
NA |
NA |
UNITS_NEEDED |
Nbr |
7 |
2 |
NA |
NA |
NA |
CRSES_REQUIRED |
Nbr |
7 |
2 |
NA |
NA |
NA |
SAA_CRSES_USED |
Nbr |
7 |
2 |
NA |
NA |
NA |
CRSES_NEEDED |
Nbr |
7 |
2 |
NA |
NA |
NA |
SAA_CRSE_COUNT |
Nbr |
4 |
0 |
NA |
NA |
NA |
GPA_REQUIRED |
Nbr |
7 |
3 |
NA |
NA |
NA |
GPA_ACTUAL |
Nbr |
7 |
3 |
NA |
NA |
NA |
RQ_AA_OVERRIDE |
Char |
9 |
0 |
NA |
NA |
NA |
ASOF_DATE |
Date |
10 |
0 |
NA |
NA |
NA |
RQ_OVRD_ACTION |
Char |
4 |
0 |
NA |
NA |
NA |
OLD_MIN_UNITS |
Nbr |
7 |
2 |
NA |
NA |
NA |
NEW_MIN_UNITS |
Nbr |
7 |
2 |
NA |
NA |
NA |
OLD_MAX_UNITS |
Nbr |
7 |
2 |
NA |
NA |
NA |
NEW_MAX_UNITS |
Nbr |
7 |
2 |
NA |
NA |
NA |
OLD_MIN_CRSES |
Nbr |
7 |
2 |
NA |
NA |
NA |
NEW_MIN_CRSES |
Nbr |
7 |
2 |
NA |
NA |
NA |
OLD_MAX_CRSES |
Nbr |
7 |
2 |
NA |
NA |
NA |
NEW_MAX_CRSES |
Nbr |
7 |
2 |
NA |
NA |
NA |
REF_RQMT_GROUP |
Char |
6 |
0 |
NA |
NA |
NA |
REF_REQUIREMENT |
Char |
9 |
0 |
NA |
NA |
NA |
ITEM_R_STATUS |
Char |
4 |
0 |
NA |
NA |
NA |
SAA_PRINT_CNTL |
Char |
4 |
0 |
NA |
NA |
NA |
SAA_DISPLAY_OPTION |
Char |
1 |
0 |
NA |
NA |
NA |
SAA_DISPLAY_GPA |
Char |
1 |
0 |
NA |
NA |
NA |
SAA_DISPLAY_UNITS |
Char |
1 |
0 |
NA |
NA |
NA |
SAA_DISPLAY_CRSCNT |
Char |
1 |
0 |
NA |
NA |
NA |
OPRID |
Char |
30 |
0 |
NA |
NA |
NA |
SAA_OPRID_NAME |
Char |
50 |
0 |
NA |
NA |
NA |
DESCR254A |
Char |
254 |
0 |
NA |
NA |
NA |
SAA_HIDE_STATUS |
Char |
1 |
0 |
NA |
NA |
NA |