PL_MM_PRSTAT_VW

(SQL View)
 Index Back

Mass Maint Prod Statuses

05/01/03 NRA - (#PL880) added to show valid Production Statuses for Mass Maintenance

SELECT FIELDVALUE , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME = 'PROD_STATUS' AND FIELDVALUE IN ('10','15', '20', '30') AND EFF_STATUS = 'A'

  • Related Language Record: PL_MM_PRSTAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name