| # |
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 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 4 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 5 |
TSCRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transcript Type
Prompt Table:
SSR_SCRTY_TS_VW
|
| 6 |
SSR_TSCRPT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Choose to Generate, Print or Generate and Print transcripts.
A=Request, Generate and Print
B=Generate and Print Transcript
G=Generate Transcript
P=Print Transcript
R=Create Transcript Request
Default Value: G
|
| 7 |
SSR_TSPRNT_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Milestones by Program on the Transcript
E=Student ID
L=Last Name
P=Zip/Postal Code
Default Value: E
|
| 8 |
TSBG_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Criteria
D=Request Date
N=Request Nbr
Default Value: N
|
| 9 |
REP_REQ_NBR_FROM |
Character(9) |
VARCHAR2(9) NOT NULL |
Report Request Number
Prompt Table:
%EDITTABLE
|
| 10 |
REP_REQ_NBR_TO |
Character(9) |
VARCHAR2(9) NOT NULL |
Report Request Nbr To
Prompt Table:
%EDITTABLE
|
| 11 |
REQ_PRT_DT_FROM |
Date(10) |
DATE |
Request Print Date From
|
| 12 |
REQ_PRT_DT_TO |
Date(10) |
DATE |
Request Print Date To
|
| 13 |
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
|
| 14 |
SSR_TSPRNT_XML |
Character(1) |
VARCHAR2(1) NOT NULL |
Output XML File
N=No
X=XML only
Y=Yes
Default Value: N
|
| 15 |
SSR_FILE_PATH_OUT |
Character(127) |
VARCHAR2(127) NOT NULL |
Output Filepath
|