ISIR_AUDIT_VIEW

(SQL View)
 Index Back

ISIR Audits Data View

This View is a join between the AUIDT_ISIR_CHNG and the ISIR_SAR_XREF tables. This View is provided for the FAA to see who, what, and when an ISIR field has been changed.

SELECT a.emplid , a.institution , a.aid_year , a.dttm_stamp , a.isir_txn_nbr , a.oprid , a.oldvalue , a.newvalue , a.correction_status , a.corr_stat_dt , b.recname , b.fieldname , b.isir_field_num , B.DESCR FROM PS_AUDIT_ISIR_CHNG a , PS_ISIR_SAR_XREF b WHERE a.aid_year = b.aid_year AND a.isir_field_num = b.isir_field_num

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: STUDENT_AID

    4 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    5 ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Transaction Num
    6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    7 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
    8 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value
    9 CORRECTION_STATUS Character(1) VARCHAR2(1) NOT NULL Correction Status
    1=Correction(s) Pending
    2=Send Correction(s)
    3=Correction(s) Sent
    4=Correction(s) Accepted
    5=Corrections Rejected
    6=Do Not Send Corrections
    10 CORR_STAT_DT Date(10) DATE Correction Status Date
    11 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    12 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    13 ISIR_FIELD_NUM Character(4) VARCHAR2(4) NOT NULL ISIR Field Num
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description