CSL_AUDIT_VW

(SQL View)
 Index Back

CSL Audit View

View of PSAUDIT to view CSL student and parent record changes.

SELECT %Substring(key1 , 1 , 11) , %Substring(key2 , 1 , 5) , %Substring(key3 , 1 , 4) , %Substring(key4 , 1 , 1) ,audit_stamp , audit_oprid , audit_actn , RECNAME , fieldname , oldvalue , newvalue FROM PSAUDIT WHERE recname IN ('INST_PARENT_CSL', 'INST_STDNT_CSL', 'INST_CONTROL')

  • 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: STUDENT_AID

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

    Default Value: OPR_DEF_TBL_CS.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: AID_YEAR_TBL

    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

    Prompt Table: CNAS_RSLT_VW

    5 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    6 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    7 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    10 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
    11 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value