RS_SO_AUDIT

(SQL Table)
 Index Back

Service Order Records Audit

  • Audit Record Of FO_CNDTE_COMP FO_CTE_ACMP_DEG FO_CTE_ACMP_LIC FO_CTE_ACMP_LNG FO_CTE_ACMP_MEM FO_JOBOPENVW FO_JOBOPEN_HDR FO_JOBOPEN_VW1 FO_JOBOPEN_WRK FO_JOBOPN_AET FO_JOBSRCH_WRK FO_SO_HDR_UPG FO_SO_LINE_UPG FO_SRCH_COMP FO_SRC_ACMP_DEG FO_SRC_ACMP_LIC FO_SRC_ACMP_LNG FO_SRC_ACMP_MEM RS_RRRQATVAL_VW RS_RR_AT_VAL_VW RS_RR_RQ_AT_VAL RS_RR_RQ_AT_VW RS_SO_ACMP_DEG RS_SO_ACMP_LIC RS_SO_ACMP_LNG RS_SO_ACMP_MEM RS_SO_COMMENTS RS_SO_EXPCMP_VW RS_SO_EXPDEG_VW RS_SO_EXPDTS_VW RS_SO_EXPFX1_VW RS_SO_EXPFX2_VW RS_SO_EXPHDR_VW RS_SO_EXPLIC_VW RS_SO_EXPLNE_VW RS_SO_EXPLNG_VW RS_SO_EXPMEM_VW RS_SO_EXPPRT_VW RS_SO_EXPSTS_VW RS_SO_HDR RS_SO_INT_PARTY RS_SO_LINE RS_SO_LINE_COMP RS_SO_LINE_REC RS_SO_LN_AT_VAL RS_SO_LN_RQ_AT RS_SO_OWNER RS_SO_PRIORITY RS_SO_STATUS RS_SO_STAT_VW1 RS_SO_TMPLT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUDIT_RECNAME Character(15) VARCHAR2(15) NOT NULL Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    3 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    4 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
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    7 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    8 START_DT Date(10) DATE Start Date
    9 END_DT Date(10) DATE End Date
    10 EST_DAYS Number(5,0) INTEGER NOT NULL Estimated number of days
    11 PERIOD_DAYS Number(5,0) INTEGER NOT NULL Number of Work Days
    12 KEY_REQS Character(100) VARCHAR2(100) NOT NULL Key Requirements
    13 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
    14 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience