| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
Default Value: %date
|
| 5 |
REV_ENG_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reverse Engineering Type
CL=Course Lists in Requirements
CN=Conditions in RG, RQ, RQLN
CO=Courses in Course Lists
RQ=Requirements in REQ Group
Default Value: CO
|
| 6 |
RQRMNT_USEAGE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
ADV=Academic Advisement
ENR=Requisite/Restriction
PLNR=Student Planner Report
SHR=Rq Course Share Restrictn
SHR1=Entity Course Share Restrictn
STD=Student Individualized Plan
Prompt Table:
%EDITTABLE8
|
| 7 |
CRSE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Course ID
Prompt Table:
CRSE_CAT_R2_VW
|
| 8 |
SUBJECT |
Character(8) |
VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table:
SUBJECT_VW
|
| 9 |
CATALOG_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Catalog Nbr
Prompt Table:
CRSE_CATNO_SRCH
|
| 10 |
ACAD_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Group
|
| 11 |
COURSE_LIST |
Character(9) |
VARCHAR2(9) NOT NULL |
Course List
Prompt Table:
CLST_MAIN_TBL
|
| 12 |
REQUIREMENT |
Character(9) |
VARCHAR2(9) NOT NULL |
Academic Requirement
Prompt Table:
RQ_MAIN_3_VW
|
| 13 |
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
Default Value: NA
|
| 14 |
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
Default Value: EQ
|
| 15 |
CONDITION_DATA |
Character(10) |
VARCHAR2(10) NOT NULL |
Condition Data
Prompt Table:
%EDITTABLE
|
| 16 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SAA_CND_TST_VW
|
| 17 |
TEST_COMPONENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Test Component
Prompt Table:
SA_TCMP_REL_TBL
|
| 18 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 19 |
SAA_MAX_VALID_AGE |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to track the maximum age of a test score in months for Academic Advisement.
|
| 20 |
SAA_BEST_TEST_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used to track the method to select the correct test score in Academic Advisement when multiple versions of the same test are found.
AV=Average of All Scores Taken
FT=First Test Taken
HS=Highest Score
LS=Lowest Score
LT=Last Test Taken
|
| 21 |
IGNORE_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Ignore Condition Operator
Y/N Table Edit
Default Value: N
|
| 22 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 23 |
SAA_INC_WILDCARDS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to pass a yes/no flag into the sqr for reverse engineering that will allow the user to decide if they want all course list details for the course to print if the course can be picked up by a wildcard.
Y/N Table Edit
Default Value: Y
|