| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 4 |
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:
ACAD_CAR_TBL
|
| 5 |
DEGR_CHKOUT_STAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Degree Checkout Status
AG=Applied for Graduation
AP=Approved
AW=Degree Awarded
DN=Denied
EG=Eligible for Graduation
IR=Program in Review
PN=Needs to Finish Pending Work
WD=Withdrawn
|
| 6 |
DEGR_CHKOUT_STAT_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
New Degree Checkout Status
AP=Approved
AW=Degree Awarded
DN=Denied
IR=Program in Review
PN=Needs to Finish Pending Work
WD=Withdrawn
|
| 7 |
ACAD_PROG1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_CARVW
|
| 8 |
ACAD_PROG2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_CARVW
|
| 9 |
ACAD_PROG3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program 3
Prompt Table:
ACAD_PROG_CARVW
|
| 10 |
EXP_GRAD_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Expected Graduation Term
Prompt Table:
TERM_TBL
|
| 11 |
COMPLETION_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Completion Term
Prompt Table:
TERM_TBL
|
| 12 |
SSR_ACADPROG_DTOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Grad Report Date Option
C=Confer Date
T=Today's Date
U=User Defined
Default Value: T
|
| 13 |
SSR_ACADPROG_DT |
Date(10) |
DATE |
Grad Report Program Date
|
| 14 |
REPORT_REQUEST_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Report Request Nbr
|
| 15 |
TSCRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transcript Type
Prompt Table:
SCRTY_TSCRPT_VW
|
| 16 |
TSCRPT_TYPE2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Report Type
Prompt Table:
SSR_SCRTY_TS_VW
|
| 17 |
TSCRPT_ASOF_DATE |
Date(10) |
DATE |
Transcript default as of date
|
| 18 |
SSR_USE_DYN_TSCRPT |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag should be checked if using the new dynamic transcript generation process
Y/N Table Edit
Default Value: Y
|
| 19 |
OUTPUT_DEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Output Destination
1=Printer
2=Page
Default Value: OPR_DEF_TBL_CS.OUTPUT_DEST
|
| 20 |
CREATE_TRNS_REQ_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Transcript Request
Y/N Table Edit
Default Value: N
|
| 21 |
REPORT_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Report
Y/N Table Edit
Default Value: N
|
| 22 |
UPDATE_DEGREE_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Programs and Degrees
Y/N Table Edit
Default Value: N
|
| 23 |
CREATE_LIST_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Population
Y/N Table Edit
Default Value: Y
|
| 24 |
LS_EXPORT_FILE_FMT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used in graduation processing to let the user select the format of the file export from the database. At this time, the choices are tab, space, or comma delimited.
C=Comma Delimited
S=Space Delimited
T=Tab Delimited
|
| 25 |
DATE1 |
Date(10) |
DATE |
Effective Date
|
| 26 |
AA_DB_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Database Report
Y/N Table Edit
Default Value: N
|