SA_REQUEST_SRCH(SQL View) |
Index Back |
|---|---|
Transcript Request Search RecThis table is used as a search record in the Transcript Request panelgroup. |
| SELECT D.OPRID , A.REPORT_REQUEST_NBR , B.EMPLID , A.INSTITUTION , A.TSCRPT_TYPE , A.OPRID , A.REQUEST_DT , A.FUTURE_RELEASE , A.STRM , A.REQUEST_PRT_DT , C.FIRST_NAME_SRCH , C.LAST_NAME_SRCH , A.SSR_USE_DYN_TSCRPT FROM PS_SA_REQUEST_HDR A , PS_SA_REQUEST_DTL B , PS_HCR_PERSON_NM_I C , PS_SCRTY_TSCRPT D WHERE D.ACCESS_CD = 'Y' AND (D.TSCRPT_TYPE = A.TSCRPT_TYPE OR D.TSCRPT_TYPE= 'ALL') AND D.INSTITUTION = A.INSTITUTION AND A.SSR_USE_DYN_TSCRPT <> 'Y' AND A.REPORT_REQUEST_NBR = B.REPORT_REQUEST_NBR AND B.EMPLID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID4 |
Character(30) | VARCHAR2(30) NOT NULL | This is a mixed-case OPRID field used for transcript searching to assign the correct transcript security to view the specific transcript types to be viewed in the component search |
| 2 | REPORT_REQUEST_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 5 | TSCRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Transcript Type
Default Value: OPR_DEF_TBL_CS.TSCRPT_TYPE Prompt Table: SCRTY_TSCRT_VW2 |
| 6 | SSR_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
This field is the UPPERCASE of OPRID. This field is needed to improve performance when searching the transcript request component. This field just be changes to Mixed case if the installation allows for Mixed-Case Operator IDs.
Default Value: OPR_DEF_TBL_CS.OPRID |
| 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 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 12 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 13 | SSR_USE_DYN_TSCRPT | Character(1) | VARCHAR2(1) NOT NULL | This flag should be checked if using the new dynamic transcript generation process |