| # |
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 |
ANALYSIS_DB_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Analysis DB Sequence
|
| 3 |
SAA_CAREER_RPT |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used in academic advisement as a key to the results tables.
Prompt Table:
ACAD_CAR_TBL
|
| 4 |
SAA_ENTRY_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
This field is used in Academic Advisement to track the position of the output in the report.
|
| 5 |
SAA_CONDITION_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
This field is used in the table SAA_ADB_CONDUSE to track multiple conditions at the same entry sequence position in the table.
|
| 6 |
RPT_DATE |
Date(10) |
DATE NOT NULL |
Report Date
|
| 7 |
TSCRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transcript Type
|
| 8 |
SAA_RPT_IDENTIFIER |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to identify a specific run of Academic Advisement Reports within a report type.
|
| 9 |
RQRMNT_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Requirement Group
Prompt Table:
RQ_GRP_TBL
|
| 10 |
RQ_GRP_LINE_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Group Line Nbr
|
| 11 |
REQUIREMENT |
Character(9) |
VARCHAR2(9) NOT NULL |
Academic Requirement
Prompt Table:
RQ_MAIN_TBL
|
| 12 |
RQ_LINE_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Nbr
|
| 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
|
| 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
|
| 15 |
CONDITION_DATA |
Character(10) |
VARCHAR2(10) NOT NULL |
Condition Data
|
| 16 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
|
| 17 |
TEST_COMPONENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Test Component
|
| 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 |
ENTRY_R_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail
|