SSR_TSRQHDR_VW(SQL View) |
Index Back |
|---|---|
Request Header ViewView on request header, that includes only completed requests and keyed by transcript type. |
| SELECT INSTITUTION , TSCRPT_TYPE , REPORT_REQUEST_NBR , OPRID , REQUEST_DT , REQUEST_PRT_DT , FUTURE_RELEASE , REQUEST_REASON_TXT , REQUEST_COMPLETED FROM PS_SA_REQUEST_HDR WHERE SSR_USE_DYN_TSCRPT = 'Y' AND REQUEST_COMPLETED = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | TSCRPT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Transcript Type
Default Value: OPR_DEF_TBL_CS.TSCRPT_TYPE Prompt Table: SCRTY_TSCRPT_VW |
| 3 | REPORT_REQUEST_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | REQUEST_DT | Date(10) | DATE |
Request Date
Default Value: %date |
| 6 | REQUEST_PRT_DT | Date(10) | DATE | Requested Print Date |
| 7 | 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 |
| 8 | REQUEST_REASON_TXT | Character(50) | VARCHAR2(50) NOT NULL | Request Reason |
| 9 | 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 |