ACAD_SCRTY_LV (SQL View)	Index Back
Acad Org Sec Rel Lang View 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_LV

(SQL View)

Acad Org Sec Rel Lang View

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.LANGUAGE_CD ,B.DESCR FROM PSTREENODE A ,PS_ACAD_ORG_LANG 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 for ACAD_SCRTY_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description