EXT_AUDIT_VW

(SQL View)
 Index Back

EXT Audit View

SACE-98D NEW -FA05 View of PSAUDIT to view student extension changes. .

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

  • 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 CNAS_RULE_SET Character(4) VARCHAR2(4) NOT NULL CNAS Rule Set
    1=Temp Value 1
    2=Temp Value 2
    C=CSL Rule Set

    Prompt Table: CNAS_SETUP_TBL

    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