INST_AUDIT_VIEW

(SQL View)
 Index Back

INST Audits Data View

This View is a join between the AUIDT_INST_CHNG and the INST_XREF tables.

SELECT a.emplid, a.institution, a.aid_year, a.app_source_code, a.dttm_stamp, a.oprid, a.oldvalue, a.newvalue, b.recname, b.fieldname FROM PS_AUDIT_INST_CHNG a, PS_INST_XREF b WHERE a.aid_year = b.aid_year AND a.inst_field_num = b.inst_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: STUDENT_AID

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: STUDENT_AID

    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 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 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).