PSAUTHOPTN_VW (SQL View)	Index Back
Authorized optnions view used to discplay the authorized cateogy level and group on the Permission List Options page.

PSAUTHOPTN_VW

(SQL View)

Authorized optnions view

used to discplay the authorized cateogy level and group on the Permission List Options page.

SELECT DISTINCT A.CLASSID , A.OPTN_CATEGORY_LVL , B.OPTN_CATEGORY_GRP FROM PSAUTHOPTN A , PSUSEROPTNDEFN B WHERE A.OPTN_CATEGORY_LVL = B.OPTN_CATEGORY_LVL AND A.USEROPTN = B.USEROPTN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

2 OPTN_CATEGORY_LVL Character(4) VARCHAR2(4) NOT NULL Option Category Level
CRM=Customer Relationship Mgmt
CSTM=Custom
EPM=Enterprise Performance Mgmt
FIN=Financials
HRMS=Human Resources Management
LS=Learning Solutions
PPTL=PeopleTools
SCM=Supply Chain Management

3 OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group
Prompt Table: PSOPTNCATGRPTBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
2	OPTN_CATEGORY_LVL	Character(4)	VARCHAR2(4) NOT NULL	Option Category Level CRM=Customer Relationship Mgmt CSTM=Custom EPM=Enterprise Performance Mgmt FIN=Financials HRMS=Human Resources Management LS=Learning Solutions PPTL=PeopleTools SCM=Supply Chain Management
3	OPTN_CATEGORY_GRP	Character(12)	VARCHAR2(12) NOT NULL	Option Category Group Prompt Table: PSOPTNCATGRPTBL