SAA_RPT_RQST_VW(SQL View) |
Index Back |
|---|---|
Advisement Report RequestThis table contains the data to produce an Academic Advisement report. |
| SELECT EMPLID , ANALYSIS_DB_SEQ , RPT_DATE , RPT_TYPE , SAA_RPT_IDENTIFIER , INSTITUTION , TSCRPT_TYPE , OPRID , SAA_PROCESSED_DATE , SAA_PROCESSING_CD , WHAT_IF_FL FROM PS_SAA_RPT_RQST |
| # | 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 | ANALYSIS_DB_SEQ |
Number(4,0) | SMALLINT NOT NULL | Analysis DB Sequence |
| 3 | RPT_DATE | Date(10) | DATE | Report Date |
| 4 | RPT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
This field is the type of Academic Advisement report and is used by the tables in the Analysis Database.
This field is reserved for use by SA.
SPC=Special Report STD=Standard Report |
| 5 | SAA_RPT_IDENTIFIER | Character(10) | VARCHAR2(10) NOT NULL | This field is used to identify a specific run of Academic Advisement Reports within a report type. |
| 6 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 7 | TSCRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Transcript Type
Prompt Table: TRANSCRIPT_TYPE |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | SAA_PROCESSED_DATE | Date(10) | DATE | This field is used in Academic Advisement to track when a report request has been processed. |
| 10 | 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 |
| 11 | WHAT_IF_FL | Character(1) | VARCHAR2(1) NOT NULL |
Use Career Simulation
Y/N Table Edit Default Value: N |