HR_SSTEXT_OO_VW

(SQL View)
Index Back

Text Catalog

View of Configured ObjectOwnerIds

SELECT DISTINCT A.OBJECTOWNERID , B.XLATLONGNAME FROM PS_HR_SSTEXT_CFG A , PSXLATITEM B WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM XL, B, %CurrentDateIn)

  • Related Language Record: HR_SSTEXT_OO_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description