SPA_PLOG_HDR

(SQL Table)
 Index Back

Progress Log Header

Progress Log Header

  • Parent Record Of SPA_PLOG_DTL SPA_PL_DTL_ADJ SPF_PLDTL_TAO SPPLDTLADJ_TEO1 SPPLDTLADJ_TEO2 SPPLDTLADJ_TEO3 SPPLOG_DTL_TEO1 SPPLOG_DTL_TEO2 SPPLOG_DTL_TEO3 SPR_PLOGD_TAO

    • # 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)

    Default Value: NEXT

    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    5 PLOG_STATUS Character(3) VARCHAR2(3) NOT NULL Progress Log Status
    ADJ=Adjusted
    APR=Approved
    DEN=Denied
    HLD=Hold
    LDN=Line Denied
    LPD=Line Pending
    OPN=Open
    PND=Pending
    SUB=Submitted

    Default Value: PND

    6 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

    Default Value: 0

    8 CREATION_DT Date(10) DATE Creation Date
    9 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    10 COMMENTS Long Character CLOB Comment
    11 SPA_ADJUSTED_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate Progress Log/Expenses has been adjusted
    A=Adjusted
    N=Not Adjusted

    Default Value: N