CC_OPRCLASS_VW

(SQL View)
Index Back

ProCard Permission List Prompt


SELECT DISTINCT A.OPRCLASS , B.CLASSDEFNDESC FROM PS_SPEEDCHART_HDR A , PSCLASSDEFN B WHERE A.SPEEDTYPE_TYPE = 'C' AND A.SPDCHRT_DEFN_FLG = 'P' AND A.OPRCLASS = B.CLASSID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: OPRCLASS_VW

2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description