| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RQ_AA_OVERRIDE |
Character(9) |
VARCHAR2(9) NOT NULL |
Advisement Override
Prompt Table:
AA_OVERRIDE
|
| 2 |
RQ_AA_OVRD_LN_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Override Line Number
|
| 3 |
CONDITION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used to track which type of condition will be used as either a condition or pre-condition in Academic Advisement.
AST=Academic Standing
CGA=Cumulative Grade Point Avg.
GRP=Student Group
GRS=Student Groups
LVL=Academic Level
NA=None
PL=Academic Plan
PLS=Academic Plans
PPL=Primary Academic Plan
PPR=Primary Academic Program
PR=Academic Program
PRS=Academic Programs
SPL=Academic Sub Plan
SPS=Academic Sub Plans
TBL=Dynamic Condition
TST=Test Score
|
| 4 |
CONDITION_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Condition Operator
EQ=Equal
GE=Greater or Equal
GT=Greater Than
IN=In
LE=Less or Equal
LT=Less Than
NE=Not Equal
NI=Not In
|
| 5 |
CONDITION_DATA |
Character(10) |
VARCHAR2(10) NOT NULL |
Condition Data
|
| 6 |
COURSE_LIST |
Character(9) |
VARCHAR2(9) NOT NULL |
Course List
Prompt Table:
CLST_STD_S_VW
|
| 7 |
RQRMNT_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Requirement Group
Prompt Table:
RQ_GRP_STD_SCH1
|
| 8 |
REQUIREMENT |
Character(9) |
VARCHAR2(9) NOT NULL |
Academic Requirement
Prompt Table:
RQ_MAIN_STD_VW
|
| 9 |
MIN_UNITS_REQD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Minimum Units
|
| 10 |
MIN_CRSES_REQD |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Minimum Courses
|
| 11 |
MAX_UNITS_ALLOWD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Maximum Units Allowed
|
| 12 |
MAX_CRSES_ALLOWD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Maximum Courses Allowed
|