ISIR_REC_VW

(SQL View)
 Index Back

ISIR Record Field View

ISIR_REC_VW is a view used to associate PS Records with PS Fields for display on the ISIR Audit panel.

SELECT recname , recdescr FROM PSRECDEFN WHERE recname = 'ISIR_PARENT' OR recname = 'ISIR_STUDENT' OR recname = 'DRIVERS_LIC' OR recname = 'ADDRESSES' OR recname = 'PERSONAL_DATA' OR recname = 'VISA_PMT_DATA' OR recname = 'ISIR_CONTROL' OR recname = 'ISIR_INTERPRET' OR recname = 'NAMES' OR recname = 'EMAIL_ADDRESSES' OR recname = 'PERSONAL_PHONE' OR recname = 'PERS_NID' OR recname = 'CITIZENSHIP' OR recname = 'PERSON' OR recname = 'SFA_ISIR_PAR' OR recname = 'SFA_ISIR_STU' OR recname = 'SFA_ISIR_CONT'

  • Parent record: PSRECDEFN_VW

    • # 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