SAA_SCRTY_AA_LN(SQL View) |
Index Back |
---|---|
Transcript Type Prompt TableRelated language view for SAA_SCRTY_AA_VW |
SELECT DISTINCT C.EMPLID , B.OPRID , A.INSTITUTION , A.TSCRPT_TYPE , E.LANGUAGE_CD , E.DESCR FROM PS_SAA_RPT_TYP_TBL A , PS_SAA_SCRTY_AARPT B , PS_STDNT_CAREER C , PS_SAA_RPT_TYP_LNG E WHERE A.INSTITUTION = E.INSTITUTION AND A.TSCRPT_TYPE = E.TSCRPT_TYPE AND A.EFFDT = E.EFFDT AND B.INSTITUTION = A.INSTITUTION AND (B.TSCRPT_TYPE = A.TSCRPT_TYPE OR B.TSCRPT_TYPE= 'ALL') AND B.ACCESS_CD = 'Y' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SAA_RPT_TYP_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.TSCRPT_TYPE = A.TSCRPT_TYPE AND A1.EFFDT <= %CurrentDateIn) AND (EXISTS ( SELECT 'X' FROM PS_SAA_RPT_CAR_TBL D WHERE D.ACAD_CAREER = C.ACAD_CAREER AND D.INSTITUTION = A.INSTITUTION AND D.TSCRPT_TYPE = A.TSCRPT_TYPE AND D.EFFDT = A.EFFDT )) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2 |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SCRTY_TBL_INST |
4 | SAA_TSCRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to save a operator default for report type in the Campus Solutions operator default record.
Prompt Table: SAA_RPT_TYP_TBL |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |