ACAD_SCRTY_VW (SQL View)	Index Back
Academic Org Security The Operator Security module uses this table to determine which data the operator can access. If the operator is granted access to a specified academic organization, then they can access other data related to that organization.

ACAD_SCRTY_VW

(SQL View)

Academic Org Security

The Operator Security module uses this table to determine which data the operator can access. If the operator is granted access to a specified academic organization, then they can access other data related to that organization.

SELECT B.ACAD_ORG ,B.DESCR ,C.TREE_EFFDT ,A.TREE_NODE_NUM ,A.TREE_NODE_NUM_END FROM PSTREENODE A ,PS_ACAD_ORG_TBL B ,PS_R_SA505 C WHERE A.SETID = ' ' AND A.TREE_NAME = 'ACAD_ORGANIZATION' AND A.EFFDT = C.TREE_EFFDT AND A.TREE_NODE = B.ACAD_ORG

Related Language Record: ACAD_SCRTY_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

5 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree
4	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
5	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number