JPM_QUAL_REC_VW

(SQL View)
 Index Back

SELECT R.RECNAME , R.RECDESCR FROM PSRECDEFN R WHERE R.RECTYPE IN (0, 1) AND 1 = ( SELECT COUNT(*) FROM PSRECFIELDALL F WHERE F.RECNAME = R.RECNAME AND F.FIELDNAME NOT IN ('EFFDT', 'EFFSEQ', 'OPRID', 'ROWSECCLASS') 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