SP_SUR_CPYVWLNG

(SQL View)
 Index Back

Survey Defin Copy Vw Rel Lang

View of Survey Definition Related Language table used for copying survey that does not default in the setid.

SELECT A.SETID , A.SP_SURVEY_ID , L.LANGUAGE_CD , L.DESCR FROM PS_SP_SUR_DEFN A , PS_SP_SUR_DEFN_LNG L WHERE L.SETID = A.SETID AND L.SP_SURVEY_ID = A.SP_SURVEY_ID

  • Related Language Record for SP_SUR_COPY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COPY_TO_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description