| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 4 |
AE_APPL_ID_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Application ID Sequence
|
| 5 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 6 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 7 |
TSCRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transcript Type
Prompt Table:
SCRTY_TSCRPT_VW
|
| 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.
Y/N Table Edit
|
| 9 |
AA_DB_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Database Report
Y/N Table Edit
Default Value: N
|
| 10 |
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.
|
| 11 |
TSRQ_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Transcript Request Criteria
A=Advisor
G=Student Group
L=Academic Level
P=Career/Program/Plan
Default Value: P
|
| 12 |
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
Prompt Table:
%EDITTABLE2
|
| 13 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_TBLVW
|
| 14 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBLVW
|
| 15 |
STDNT_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Group
Prompt Table:
STDNT_GROUP_TBL
|
| 16 |
ADVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
This field is used to identify advisors assigned to a student.
Prompt Table:
TS_ADVISOR_VW
|
| 17 |
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
|
| 18 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_TBL_ALT_VW
|
| 19 |
REQUEST_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Complete Status.
A=Acknowledgement Received
C=Completed
G=Generated
N=On Request
P=Printed
R=Reissue Requested
|
| 20 |
REPORT_REQUEST_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Report Request Nbr
|
| 21 |
PART1_NEXT_SEQ |
Character(10) |
VARCHAR2(10) NOT NULL |
Part 1 Next Sequence Number
|