INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SUBJECTPrompt Table: SUBJECT_TBL
CATALOG_NBR_SRCHCRSE_ID_SRCHOPRIDA=Active
I=Inactive
A=Approved
D=Denied
P=Pending
N=No Access
Y=Read/Write Access
SSR_CRSECAT_VW(SQL View) |
Index Back |
|---|---|
Course Cat View |
| SELECT b.institution , b.subject , ltrim(rtrim(b.catalog_nbr)) , a.crse_id , s.oprid , a.effdt , a.eff_status , a.descr , b.course_approved , s.access_cd FROM ps_crse_catalog a , PS_CRSE_OFFER b , ps_scrty_tbl_acad s WHERE a.crse_id = b.crse_id AND a.effdt = b.effdt AND (a.effdt = ( SELECT MAX(a1.effdt) FROM ps_crse_catalog a1 WHERE a.crse_id = a1.crse_id AND a1.effdt <= %CurrentDateIn) OR (a.effdt > %CurrentDateIn AND NOT EXISTS ( SELECT 'X' FROM PS_CRSE_CATALOG a2 WHERE a.crse_id = a2.crse_id AND a2.effdt <= %CurrentDateIn)) AND a.effdt = ( SELECT MIN(a3.effdt) FROM ps_crse_catalog a3 WHERE a.crse_id = a3.crse_id AND a3.effdt > %CurrentDateIn)) AND b.course_approved = 'A' AND s.access_cd='Y' AND EXISTS ( SELECT 'x' FROM pstreenode t WHERE t.setid=' ' AND t.tree_name='ACAD_ORGANIZATION' AND t.effdt=s.tree_effdt AND t.tree_node=b.acad_org AND t.tree_node_num BETWEEN s.tree_node_num AND s.tree_node_num_end AND NOT EXISTS ( SELECT 'x' FROM ps_scrty_tbl_acad s1 WHERE s1.oprid=s.oprid AND s1.tree_node_num<>s.tree_node_num AND t.tree_node_num BETWEEN s1.tree_node_num AND s1.tree_node_num_end AND s1.tree_node_num BETWEEN s.tree_node_num AND s.tree_node_num_end)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
| 3 | CATALOG_NBR_SRCH |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 4 | CRSE_ID_SRCH |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 5 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | COURSE_APPROVED | Character(1) | VARCHAR2(1) NOT NULL |
Course Approved
A=Approved D=Denied P=Pending |
| 10 | ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=No Access Y=Read/Write Access |