SPA_PL_HIST_VW

(SQL View)
 Index Back

Progress Log Fluid Approvals

View Created to show History Data in Progress Log Fluid Approval History Page

SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.SEQNUM , A.NAME , A.PL_LINE_STATUS , A.REASON_TYPE , A.REASON_CD , A.DATETIME_STAMP , A.COMMENTS FROM PS_SPA_PLOG_HIST A

  • Parent record: SPA_PLOG_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 PL_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL Progress Log Line Status
    ADJ=Adjusted
    APR=Approved
    DEN=Denied
    HLD=Hold
    OPN=Open
    PND=Pending
    SUB=Submitted
    7 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
    8 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    9 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
    10 COMMENTS Long Character CLOB Comment