| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SA_TEST_TBL
|
| 3 |
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
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
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.
|
| 7 |
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
Default Value: HS
|
| 8 |
SAA_TST_AGE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a flag used to identify if a test score maximum valid age is allowed to be overridden on the setup pages.
Y/N Table Edit
Default Value: N
|
| 9 |
SAA_BEST_TST_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a flag used to identify if the process to calculate the best test score is allowed to be overridden on the setup pages.
Y/N Table Edit
Default Value: N
|