SSR_TRQ_SCRT_VW(SQL View) |
Index Back |
|---|---|
Transcript Request Security VWTranscript Request Security View |
| SELECT A.EMPLID , A.INSTITUTION , A.TSCRPT_TYPE , B.OPRID , A.REPORT_REQUEST_NBR , A.REQUEST_SEQ_NBR , A.REQUEST_DT , A.REQUEST_PRT_DT , A.OPRID2 , A.SSR_USE_DYN_TSCRPT , A.FUTURE_RELEASE , A.STRM , A.REQUEST_REASON_TXT , A.REQUEST_COMPLETED , A.REQUEST_REASON_CD , B.TSCRPT_TYPE FROM PS_SSR_TSRQST_INQV A , PS_SCRTY_TSCRPT B WHERE B.INSTITUTION = A.INSTITUTION AND (B.TSCRPT_TYPE = A.TSCRPT_TYPE OR B.TSCRPT_TYPE= 'ALL') AND B.ACCESS_CD = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | TSCRPT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Transcript Type |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | REPORT_REQUEST_NBR | Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr |
| 6 | REQUEST_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Request Seq Nbr |
| 7 | REQUEST_DT | Date(10) | DATE | Request Date |
| 8 | REQUEST_PRT_DT | Date(10) | DATE | Requested Print Date |
| 9 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 10 | SSR_USE_DYN_TSCRPT | Character(1) | VARCHAR2(1) NOT NULL | This flag should be checked if using the new dynamic transcript generation process |
| 11 | 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 |
| 12 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 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 | 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 |
| 16 | TSCRPT_TYPE2 | Character(5) | VARCHAR2(5) NOT NULL | Report Type |