SAA_ADB_RQDPLAN
This table contains the information about all required plans for a specific requirement group.
This table contains the data from R_RQDPLN_HEADER and R_RQDPLN_DETAIL. The following fields have been added that did not previously exist in either table: SAA_CAREER_RPT, SAA_ENTRY_SEQ, SAA_RQDPLN_SEQ, TSCRPT_TYPE, and SAA_RPT_IDENTIFIER.
|
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_RQDPLN_SEQ |
Nbr |
4 |
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 |
|
RQRMNT_GROUP |
Char |
6 |
0 |
Not applicable (NA) |
NA |
NA |
|
PLANS_NEEDED |
Nbr |
3 |
0 |
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 |