PERM_RCRDS_VW2

(SQL View)
 Index Back

Rename OPRCLASS Fields

The system uses PERM_RCRDS_VW1 and PERM_RCRDS_VW2 during the process of changing a permission list in the database.

SELECT A.RECNAME ,B.SQLTABLENAME FROM PSRECFIELD A , PSRECDEFN B WHERE A.FIELDNAME = 'OPRCLASS' AND A.RECNAME = B.RECNAME AND B.RECTYPE = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name