ACA_SF_HRBRQLNG

(SQL View)
 Index Back

Safe Harbor Query Related Lng

Safe Harbor Query prompt Related language view

SELECT DISTINCT Q.QRYNAME ,LNG.LANGUAGE_CD ,Q.DESCR FROM PSQRYDEFN Q ,PSQRYDEFNLANG LNG ,PSQRYFIELD F1 ,PSQRYFIELD F2 ,PSQRYBIND B WHERE Q.QRYTYPE = 1 AND Q.QRYNAME = F1.QRYNAME AND Q.QRYNAME = F2.QRYNAME AND Q.QRYNAME = B.QRYNAME AND Q.QRYNAME = LNG.QRYNAME AND F1.FIELDNAME = 'EMPLID' AND F1.COLUMNNUM = 1 AND F2.FIELDNAME = 'EMPL_RCD' AND F2.COLUMNNUM = 2 AND B.FIELDNAME = 'ASOFDATE' AND B.BNDNUM = 1

  • Related Language Record for ACA_EXTRACT_QVW ACA_SF_HRBR_QVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description