| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
AE_APPL_ID_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Application ID Sequence
|
| 5 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 6 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 7 |
TSCRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transcript Type
|
| 8 |
USE_STORED_WHAT_IF |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate if a transcript request is to process an AA report using a stored what-if.
|
| 9 |
AA_DB_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Database Report
Y/N Table Edit
|
| 10 |
TSCRPT_RPT_FMT |
Character(4) |
VARCHAR2(4) NOT NULL |
Report Format
ANTB=Analysis Database
COMP=Completed Only
INC=Incompleted Only
STD=Standard Report Format
|
| 11 |
FIRST_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
First
|
| 12 |
REPORT_RQST_LAST |
Number(9,0) |
DECIMAL(9) NOT NULL |
Last Report Request Nbr
|
| 13 |
PART1_NEXT_SEQ |
Character(10) |
VARCHAR2(10) NOT NULL |
Part 1 Next Sequence Number
|
| 14 |
REPORT_REQUEST_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Report Request Nbr
|
| 15 |
REQUEST_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Request Seq Nbr
|
| 16 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 17 |
DYN_WHERE_1 |
Character(250) |
VARCHAR2(250) NOT NULL |
Dynamic Where Part 1
|
| 18 |
TSRQ_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Transcript Request Criteria
A=Advisor
G=Student Group
L=Academic Level
P=Career/Program/Plan
|
| 19 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 20 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 21 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 22 |
STDNT_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Group
|
| 23 |
ADVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
This field is used to identify advisors assigned to a student.
|
| 24 |
ACADEMIC_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
|
| 25 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
|
| 26 |
INCLUDE_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include
|
| 27 |
CALL_RETCODE |
Number(4,0) |
SMALLINT NOT NULL |
Call Return Code
|
| 28 |
CALL_ERRCODE |
Number(4,0) |
SMALLINT NOT NULL |
Call Error Code
|
| 29 |
CALL_ERRDATA |
Character(60) |
VARCHAR2(60) NOT NULL |
Call Error Data
|
| 30 |
ASOF_DATE |
Date(10) |
DATE |
This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
|
| 31 |
USE_CMPLT_MODEL |
Character(1) |
VARCHAR2(1) NOT NULL |
This fiels is a flag that is passed in the what-if report request for academic advisement to flag whether or not to include the completed transfer credit models when running an advisement report.
N=No
Y=Yes
|