AUDIT_HCSCM_ASF

(SQL Table)
Index Back

Audit for Associated fields

  • Audit Record Of HCSCM_ASSOC_FLD HCSCM_ASSOC_VW1 HCSCM_ASSOC_VW2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP NOT NULL Date and Time Stamp
    3 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
    4 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PSPNLGRPDEFN

    5 HCSCM_FLD_GRP Character(4) VARCHAR2(4) NOT NULL Field Group
    6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    7 HCSCM_ASSOC_REC Character(15) VARCHAR2(15) NOT NULL Associated Field Rec Name

    Prompt Table: PSRECDEFN

    8 HCSCM_ASSOC_FLD Character(18) VARCHAR2(18) NOT NULL Associated Field Field Name

    Prompt Table: HCSCM_RCFLD_DVW