GPDE_DV_PRCS_VW

(SQL View)
 Index Back

Deuev Process Status

Deuev Process Status

SELECT A.CAL_RUN_ID , A.PRCSINSTANCE , B.PRCSTYPE , B.PRCSNAME , C.DESCR , B.OPRID , B.RUNDTTM , B.RUNSTATUS , B.RUNSTATUSDESCR , A.FROM_DATE , A.TO_DATE , A.ASOFDATE , A.GPDE_DV_IMMED_IND , A.GPDE_DV_RUN , A.GPDE_DV_RCVER_ID , A.GPDE_DV_SENDER_ID , A.GPDE_RC_FILE_NBR , A.GPDE_RC_DUEVO_CLS FROM PS_GPDE_DV_PRCS_ST A , PS_PMN_PRCSLIST B , PS_PRCSDEFN C WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND C.PRCSTYPE = B.PRCSTYPE AND C.PRCSNAME = B.PRCSNAME

  • Related Language Record: GPDE_DV_PRC_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    7 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    8 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
    1=Cancel
    10=Not Successful
    11=Posted
    12=Unable to post
    13=Resend
    14=Posting
    15=Content Generated
    16=Pending
    17=Success With Warning
    18=Blocked
    19=Restart
    2=Delete
    3=Error
    4=Hold
    5=Queued
    6=Initiated
    7=Processing
    8=Cancelled
    9=Success
    9 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status
    10 FROM_DATE Date(10) DATE From Date
    11 TO_DATE Date(10) DATE Latest Date to be sent to PYR
    12 ASOFDATE Date(10) DATE As of Date
    13 GPDE_DV_IMMED_IND Character(1) VARCHAR2(1) NOT NULL Descr

    Y/N Table Edit

    14 GPDE_DV_RUN Number(5,0) INTEGER NOT NULL Current DEUEV Run
    15 GPDE_DV_RCVER_ID Character(8) VARCHAR2(8) NOT NULL Provider ID
    16 GPDE_DV_SENDER_ID Character(8) VARCHAR2(8) NOT NULL Provider ID
    17 GPDE_RC_FILE_NBR Number(3,0) SMALLINT NOT NULL File Number
    18 GPDE_RC_DUEVO_CLS Character(1) VARCHAR2(1) NOT NULL Deuev Close

    Y/N Table Edit