SSR_SSTSRQ_SRCH(SQL View) |
Index Back |
|---|---|
Self Service Transcript RqstThis table is used as a search record in the self service Transcript Request inquiry |
| 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 FROM PS_SA_REQUEST_HDR A , PS_SA_REQUEST_DTL B , PS_SSR_TSCRPT_TYPE C WHERE A.REPORT_REQUEST_NBR = B.REPORT_REQUEST_NBR AND A.TSCRPT_TYPE = C.TSCRPT_TYPE AND A.INSTITUTION = C.INSTITUTION AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SSR_TSCRPT_TYPE C1 WHERE C1.TSCRPT_TYPE = C.TSCRPT_TYPE AND C1.INSTITUTION = C.INSTITUTION AND C1.EFFDT <= %CurrentDateIn) AND C.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 |