SAA_ADB_CRSEUSE
This table contains the courses that are used in processing the requirements. The courses can be from an All-Stats, Verify, or Limit line.
This table contains the data from R_COURSE_USEAGE and R_COURSE_DIREC. The following fields have been added that did not previously exist in either table: SAA_CAREER_RPT, SAA_ENTRY_SEQ, SAA_COURSE_SEQ, RPT_DATE, TSCRPT_TYPE, SAA_RPT_IDENTIFIER, RQ_GRP_LINE_NBR, RQ_AA_OVERRIDE, ASOF_DATE, DIRCT_TYPE, SAA_DISPLAY_OPTION, 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 |
|
SAA_COURSE_SEQ |
Nbr |
3 |
0 |
Pri |
5 |
Asc |
|
CRSE_TAG |
Char |
4 |
0 |
Pri |
6 |
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 |
|
RQRMNT_GROUP |
Char |
6 |
0 |
Not applicable (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 |
|
SEL_PROCESS_TYPE |
Char |
3 |
0 |
NA |
NA |
NA |
|
SEL_MODE |
Char |
1 |
0 |
NA |
NA |
NA |
|
IN_PROGRESS_GRD |
Char |
1 |
0 |
NA |
NA |
NA |
|
UNT_TAKEN |
Nbr |
6 |
2 |
NA |
NA |
NA |
|
UNT_EARNED |
Nbr |
6 |
2 |
NA |
NA |
NA |
|
CRSE_COUNT |
Nbr |
5 |
2 |
NA |
NA |
NA |
|
RQ_AA_OVERRIDE |
Char |
9 |
0 |
NA |
NA |
NA |
|
ASOF_DATE |
Date |
10 |
0 |
NA |
NA |
NA |
|
DIRCT_TYPE |
Char |
1 |
0 |
NA |
NA |
NA |
|
SAA_DISPLAY_OPTION |
Char |
1 |
0 |
NA |
NA |
NA |
|
SAA_OPRID_NAME |
Char |
50 |
0 |
NA |
NA |
NA |
|
OPRID |
Char |
30 |
0 |
NA |
NA |
NA |
|
DESCR254A |
Char |
254 |
0 |
NA |
NA |
NA |