HR_OBD_CFG_SVW

(SQL View)
 Index Back

OnBoarding Config Docs

Search view for Configure Documents.

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

  • Related Language Record: HR_OBD_CFG_SVWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document Id
    2 ATTACH_DESCR Character(50) VARCHAR2(50) NOT NULL Document