| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CONDITION_SPEC |
Character(6) |
VARCHAR2(6) NOT NULL |
Condition Specification
Prompt Table:
RQ_CONDITION
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 3 |
COND_LINE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Condition Line Sequence
|
| 4 |
COND_PROCESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition Process Type
STND=Standard Condition
UPRG=User Programmable Condition
Default Value: STND
|
| 5 |
COND_PROCESS_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition Process Identifier
Prompt Table:
COND_PROC_TBL
|
| 6 |
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
|
| 7 |
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
|
| 8 |
CONDITION_DATA |
Character(10) |
VARCHAR2(10) NOT NULL |
Condition Data
Prompt Table:
%EDITTABLE
|
| 9 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SAA_CND_TST_VW
|
| 10 |
TEST_COMPONENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Test Component
Prompt Table:
SA_TCMP_REL_TBL
|
| 11 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 12 |
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.
|
| 13 |
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
|