SSR_OFF_RQST_VW

(SQL View)
 Index Back

Official Transcript Requests

View for previous official transcript requests

SELECT B.EMPLID , A.OPRID , A.REPORT_REQUEST_NBR , B.REQUEST_SEQ_NBR , A.TSCRPT_TYPE , A.INSTITUTION , A.REQUEST_DT , A.FUTURE_RELEASE , A.STRM , A.REQUEST_PRT_DT , C.SSR_DELIVER_METHOD , A.NUMBER_OF_COPIES , B.SEND_TO_NAME , B.COMPLETION_CODE , A.REQUEST_COMPLETED , C.SSR_PAYMENT_STATUS , C.SSR_TSCRPT_TOT_FEE FROM PS_SA_REQUEST_HDR A , PS_SA_REQUEST_DTL B , PS_SA_REQUEST_DEL C , PS_SSR_TSCRPT_TYPE D WHERE A.REPORT_REQUEST_NBR = B.REPORT_REQUEST_NBR AND A.REPORT_REQUEST_NBR = C.REPORT_REQUEST_NBR AND B.REQUEST_SEQ_NBR = C.REQUEST_SEQ_NBR AND A.TSCRPT_TYPE = D.TSCRPT_TYPE AND A.INSTITUTION = D.INSTITUTION AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SSR_TSCRPT_TYPE D1 WHERE D1.TSCRPT_TYPE = D.TSCRPT_TYPE AND D1.INSTITUTION = D.INSTITUTION AND D1.EFFDT <= %CurrentDateIn) AND D.TRANSCRIPT_LEVEL = '20'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_CS.OPRID

3 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr
4 REQUEST_SEQ_NBR Number(5,0) INTEGER NOT NULL Request Seq Nbr
5 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

Default Value: OPR_DEF_TBL_CS.TSCRPT_TYPE

Prompt Table: SSR_SCRTY_TSVW3

6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

7 REQUEST_DT Date(10) DATE Request Date

Default Value: %Date

8 FUTURE_RELEASE Character(2) VARCHAR2(2) NOT NULL Future Release
DG=Degree Confer Date
GP=Grades Post
HD=Specific Date
HO=Hold
IP=Immediate Processing
TP=Transfer Credit Post
9 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

10 REQUEST_PRT_DT Date(10) DATE Requested Print Date
11 SSR_DELIVER_METHOD Character(4) VARCHAR2(4) NOT NULL Official transcript delivery method

Prompt Table: SSR_DELIVER_TBL

12 NUMBER_OF_COPIES Number(2,0) SMALLINT NOT NULL Number of Copies
13 SEND_TO_NAME Character(55) VARCHAR2(55) NOT NULL Send To
14 COMPLETION_CODE Character(4) VARCHAR2(4) NOT NULL Completion Code
000=Successful
100=Holds
500=Warning
15 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
16 SSR_PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status flag for Request Official Transcript
R=Received
U=Unsuccessful
17 SSR_TSCRPT_TOT_FEE Number(11,2) DECIMAL(10,2) NOT NULL Total delivery method charge/fee for Request Official Transcript (quantity * fee + delivery charge + additional fee)