| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CONDITION_SPEC |
Character(6) |
VARCHAR2(6) NOT NULL |
Condition Specification
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 5 |
RQ_CONNECT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Connector Type
AND=AND
OR=OR
Default Value: AND
|
| 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:
RQRMNT_USE_TBL
|
| 7 |
COND_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition Type
STD=Standard
Default Value: STD
|
| 8 |
SAA_CALC_TST_SCORE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a Yes/No field used by dynamic conditions to set the condition as one where test scores need to be calculated.
Y/N Table Edit
Default Value: N
|
| 9 |
SAA_CALC_TST_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to define how to calculate the combined test score for dynamic conditions.
A=Average of the Components
S=Sum of the Components
|
| 10 |
SAA_TST_SCORE_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
This field contains translate values that allow the user to define how test scores are grouped in dynamic conditions.
D=Tests Taken on Different Dates
S=Tests Taken on Same Date
|
| 11 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SAA_CND_TST_VW
|
| 12 |
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
Prompt Table:
RQ_NOTINCOND_SR
|
| 13 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 14 |
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.
|
| 15 |
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
|
| 16 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 17 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: RQ_CONDITION.DESCR
|
| 18 |
DESCR254A |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|