SSR_TSRQST_INQV(SQL View) |
Index Back |
|---|---|
Transcript Request InquiryTranscript Request Inquiry view |
| SELECT A.EMPLID , A.REPORT_REQUEST_NBR , A.REQUEST_SEQ_NBR , B.INSTITUTION , B.TSCRPT_TYPE , B.REQUEST_DT , B.REQUEST_PRT_DT , B.OPRID , B.SSR_USE_DYN_TSCRPT , B.FUTURE_RELEASE , B.STRM , B.REQUEST_REASON_CD , B.REQUEST_REASON_TXT , B.REQUEST_COMPLETED , C.SSR_TSCRPT_TOT_FEE , C.SSR_PAYMENT_DATE FROM %Table(SA_REQUEST_HDR) B INNER JOIN %Table(SA_REQUEST_DTL) A ON B.REPORT_REQUEST_NBR = A.REPORT_REQUEST_NBR LEFT OUTER JOIN %Table(SA_REQUEST_DEL) C ON A.REPORT_REQUEST_NBR = C.REPORT_REQUEST_NBR AND A.REQUEST_SEQ_NBR = C.REQUEST_SEQ_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | REPORT_REQUEST_NBR | Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr |
| 3 | REQUEST_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Request Seq Nbr |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | TSCRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Transcript Type |
| 6 | REQUEST_DT | Date(10) | DATE | Request Date |
| 7 | REQUEST_PRT_DT | Date(10) | DATE | Requested Print Date |
| 8 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 9 | 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 |
| 10 | 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 |
| 11 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 12 | REQUEST_REASON_CD | Character(3) | VARCHAR2(3) NOT NULL |
Request Reason
DCH=Data Change EOT=End of Term Print ERQ=External Request GRD=Graduation SRQ=Student's Request WEB=Web Transcript Request |
| 13 | REQUEST_REASON_TXT | Character(50) | VARCHAR2(50) NOT NULL | Request Reason |
| 14 | 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 |
| 15 | 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) |
| 16 | SSR_PAYMENT_DATE | Date(10) | DATE | Payment Date for Request Official Transcript |