AUDIT_INST_CHNG

(SQL Table)
 Index Back

Audit of INST Data

This table contains all the 'change' activitity to those correctable ISIR fields from the following tables: INST_CONTROL, INST_STUDENT, INST_PARENT. This table is used to build a view against the INST_XREF table in order to present meaningful audit information.

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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
    4 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    5 DTTM_STAMP DateTime(26) TIMESTAMP NOT NULL 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.
    6 INST_FIELD_NUM Character(4) VARCHAR2(4) NOT NULL INST Field Nbr
    7 INST_ROW_NUM Number(3,0) SMALLINT NOT NULL INST Row Number
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    9 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
    10 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value