SAARPTRSLTSRCH(SQL View) |
Index Back |
|---|---|
Advising Report Search ViewThis view is used to search for report results for the administrative view of the report. |
| SELECT A.EMPLID , B.SAA_CAREER_RPT , A.ANALYSIS_DB_SEQ , A.INSTITUTION , A.TSCRPT_TYPE , A.RPT_DATE , A.SAA_PROCESSED_DATE , A.SAA_PROCESSING_CD FROM PS_SAA_RPT_RQST A , PS_SAA_ADB_REPORT B WHERE A.EMPLID = B.EMPLID AND A.ANALYSIS_DB_SEQ = B.ANALYSIS_DB_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | SAA_CAREER_RPT |
Character(4) | VARCHAR2(4) NOT NULL |
This field is used in academic advisement as a key to the results tables.
Prompt Table: ACAD_CAR_TBL |
| 3 | ANALYSIS_DB_SEQ |
Number(4,0) | SMALLINT NOT NULL |
Report Sequence
Default Value: 0 |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 5 | TSCRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Report Type
Prompt Table: SAA_RPT_TYP_TBL |
| 6 | RPT_DATE | Date(10) | DATE | Report Date |
| 7 | SAA_PROCESSED_DATE | Date(10) | DATE | This field is used in Academic Advisement to track when a report request has been processed. |
| 8 | SAA_PROCESSING_CD | Character(2) | VARCHAR2(2) NOT NULL |
This field is used to track the status of an Academic Advisement Report as it is being generated.
00=Completed Successfully 10=Request Pending 20=Request Processing 30=Error Processing Request 40=Request Canceled 50=Report Results Purged |