GRADE_RSTR_SCTY (SQL View)	Index Back
Grade Roster Security View Use this search record to restrict operator access to the Class Table. This view retrieves class sections offered by Academic Organizations an operator is granted access to.

GRADE_RSTR_SCTY

(SQL View)

Grade Roster Security View

Use this search record to restrict operator access to the Class Table. This view retrieves class sections offered by Academic Organizations an operator is granted access to.

select a.strm, a.class_nbr, c.oprid, c.access_cd from PS_CLASS_TBL a, ps_scrty_tbl_acad c where c.access_cd='Y' and exists (select 'x' from pstreenode e where e.setid=' ' and e.tree_name='ACAD_ORGANIZATION' and e.effdt=c.tree_effdt and e.tree_node=a.acad_org and e.tree_node_num between c.tree_node_num and c.tree_node_num_end and not exists (select 'x' from ps_scrty_tbl_acad g where c.oprid=g.oprid and c.tree_node_num<>g.tree_node_num and e.tree_node_num between g.tree_node_num and g.tree_node_num_end and g.tree_node_num between c.tree_node_num and c.tree_node_num_end))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STRM Character(4) VARCHAR2(4) NOT NULL Term
Default Value: OPR_DEF_TBL_CS.STRM
Prompt Table: TERM_VAL_TBL

2 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_VAL_TBL
2	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access