SPA_EXP_APR_AU

(SQL Table)
Index Back

Expense Sheet Status History

  • Parent record: SPA_TIME_DTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID

    Prompt Table: SPA_TIME_WO2_VW

    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Report Status
    APY=Approved for Payment
    APZ=Approved For Zero Payment
    CLS=Closed
    DEN=Denied
    DNA=Denied by Approver
    DNU=Denied by Auditor
    ESC=Escheated Payment
    HDA=On Hold, with Approver
    HDU=On Hold, with Auditor
    HLD=On Hold
    MFS=Marked for Submit
    OPN=Open
    PAR=Approvals in Process
    PD=Paid
    PND=Pending
    PRO=In Process
    RAP=Approved
    SFA=Submission in Process
    STG=Staged
    SUB=Submitted for Approval
    XML=Submitted, Pending Validation

    Default Value: PND

    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
    9 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
    10 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    11 COMMENTS Long Character CLOB Comment