MU_SETUP_VW2

(SQL View)
 Index Back

MU Definition

Select Mass Updates with a status equal to 'Initiated' or 'In Progress'.

SELECT MU_ID , DESCR50 , DESCRSHORT , MU_STATUS FROM %Table (MU_SETUP_TBL) WHERE MU_STATUS IN ('I','P')

  • Related Language Record: MU_SETUP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MU_ID Character(15) VARCHAR2(15) NOT NULL Mass Update ID
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 MU_STATUS Character(1) VARCHAR2(1) NOT NULL Mass Update Status
    C=Closed
    I=Initiated
    N=New
    P=In Progress