HR_SSTEXT_OO_LN

(SQL View)
 Index Back

Text Catalog

View of Configured ObjectOwnerIds (Related Language)

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

  • Related Language Record for HR_SSTEXT_OO_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description