JPM_RLAT_REC_VW

(SQL View)
 Index Back

SELECT R.RECNAME , R.RECDESCR FROM PSRECDEFN R WHERE R.RECTYPE IN (0, 1) AND EXISTS ( SELECT 'X' FROM PSRECFIELDALL F WHERE F.RECNAME = R.RECNAME AND %Truncate(F.USEEDIT / 2, 0) * 2 <> F.USEEDIT)

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