| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
RPT_DATE |
Date(10) |
DATE NOT NULL |
Report Date
|
| 3 |
RPT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is the type of Academic Advisement report and is used by the tables in the Analysis Database.
This field is reserved for use by SA.
SPC=Special Report
STD=Standard Report
|
| 4 |
ANALYSIS_DB_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Analysis DB Sequence
Default Value: 1
|
| 5 |
ENTRY_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Entry Sequence
|
| 6 |
RQRMNT_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Requirement Group
Prompt Table:
RQ_GRP_TBL
|
| 7 |
REQUIREMENT |
Character(9) |
VARCHAR2(9) NOT NULL |
Academic Requirement
Prompt Table:
RQ_MAIN_TBL
|
| 8 |
RQ_LINE_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Nbr
|
| 9 |
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
|
| 10 |
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
|
| 11 |
CONDITION_DATA |
Character(10) |
VARCHAR2(10) NOT NULL |
Condition Data
|
| 12 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
|
| 13 |
TEST_COMPONENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Test Component
|
| 14 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 15 |
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.
|
| 16 |
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
|