SSR_ACADPLNSVWL(SQL View) |
Index Back |
---|---|
Acad Plan Rel Lang Security VWThis is the related language view for SSR_ACADPLN_SVW |
SELECT a.institution , a.acad_plan , b.oprid , c.language_cd , c.effdt , c.descr FROM PS_ACAD_PLAN_TBL a , ps_scrty_tbl_plan b , ps_acad_plan_lang c WHERE a.institution = c.institution AND a.acad_plan = c.acad_plan AND a.effdt = c.effdt AND a.institution = b.institution AND (a.acad_plan = b.acad_plan OR b.acad_plan = 'ALL') AND NOT EXISTS ( SELECT 'X' FROM ps_scrty_tbl_plan d WHERE d.access_cd = 'N' AND d.oprid = b.oprid AND d.institution = b.institution AND d.acad_plan = b.acad_plan) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | ACAD_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table: ACAD_PLAN_TBL |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |