SCC_DISCREPSRCH

(SQL View)
Index Back

SELECT MAX(P.OPRID) , MAX(P.RECNAME) , MAX(R.RECDESCR) , MAX(P.SCC_AUTHORIZATION) FROM PS_SCC_PERMISNOPVW P , PSRECDEFN R , PS_SCC_DISCREP_TBL D WHERE R.RECNAME = P.RECNAME AND D.RECNAME = R.RECNAME GROUP BY P.OPRID , P.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
4 SCC_AUTHORIZATION Character(1) VARCHAR2(1) NOT NULL Authorization level. What level of authorization is granted.
R=Read Only
W=Read/Write