HR_OBD_CFG_SVWL

(SQL View)
Index Back

OnBoarding Config Docs

Related Language Search view for Configure Documents.

SELECT DOCUMENT_ID , LANGUAGE_CD , ATTACH_DESCR FROM PS_HR_OBD_CFG_ATTL A WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_HR_OBD_CFG_ATTL A1 WHERE A1.DOCUMENT_ID = A.DOCUMENT_ID AND A1.LANGUAGE_CD = A.LANGUAGE_CD AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record for HR_OBD_CFG_SVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document Id
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ATTACH_DESCR Character(50) VARCHAR2(50) NOT NULL Document