SSR_TSRQST_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_SSR_SCRTY_TSRPT D WHERE D.INSTITUTION = A.INSTITUTION AND D.ACCESS_CD = 'Y' AND (D.TSCRPT_TYPE = A.TSCRPT_TYPE OR D.TSCRPT_TYPE= 'ALL') 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 |  OPRID2 |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 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: SSR_SCRTY_TSVW2 |
| 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 |