HR_MO_OO_VW

(SQL View)
 Index Back

SELECT X.FIELDVALUE , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'OBJECTOWNERID' AND X.EFFDT = ( SELECT MAX(A.EFFDT) FROM PSXLATITEM A WHERE A.FIELDNAME = X.FIELDNAME AND A.FIELDVALUE = X.FIELDVALUE AND A.EFFDT <= %CurrentDateIn)

  • Related Language Record: HR_MO_OO_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_MO_OWNER_ID Character(4) VARCHAR2(4) NOT NULL Mouse Over Data: Owner ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description