SAA_ARPT_INSCAR(SQL View) |
Index Back |
|---|---|
Analysis DB Report InformationThis table contains the data for a specific report in the Academic Advisement Analysis Database. |
| SELECT a.EMPLID , a.INSTITUTION , a.SAA_CAREER_RPT , a.ANALYSIS_DB_SEQ , a.TSCRPT_TYPE , a.RPT_DATE , b.SAA_AARPT_TYPE , b.SAA_PLNRRPT_TYPE , b.SAA_WHIFRPT_TYPE , b.SAA_WHRPT_TYP_ADVR , b.SAA_WHRPT_TYP_PREM , b.SAA_WHIFXFR_TYPE , b.SAA_WHXFR_TYP_PREM FROM PS_SAA_ADB_REPORT a , PS_INSTITUTION_TBL b WHERE a.INSTITUTION = b.INSTITUTION AND b.EFFDT = ( SELECT MAX (b1.EFFDT) FROM PS_INSTITUTION_TBL b1 WHERE b1.INSTITUTION = b.INSTITUTION AND b1.EFFDT <= %CurrentDateIn) AND b.EFF_STATUS='A' |
| # | 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 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | 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 |
| 4 | ANALYSIS_DB_SEQ |
Number(4,0) | SMALLINT NOT NULL | Analysis DB Sequence |
| 5 | TSCRPT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Transcript Type
Prompt Table: TRANSCRIPT_TYPE |
| 6 | RPT_DATE | Date(10) | DATE | Report Date |
| 7 | SAA_AARPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service advisement reports.
Prompt Table: SAA_RPT_TYP_TBL |
| 8 | SAA_PLNRRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service planner reports.
Prompt Table: SAA_RPT_TYP_TBL |
| 9 | SAA_WHIFRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table: SAA_RPT_TYP_TBL |
| 10 | SAA_WHRPT_TYP_ADVR | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table: SAA_RPT_TYP_TBL |
| 11 | SAA_WHRPT_TYP_PREM | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table: SAA_RPT_TYP_TBL |
| 12 | SAA_WHIFXFR_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table: SAA_RPT_TYP_TBL |
| 13 | SAA_WHXFR_TYP_PREM | Character(5) | VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table: SAA_RPT_TYP_TBL |