SP_SUR_SVTYPVWL

(SQL View)
Index Back

Surveys by Service Type Lang

Surveys by Service Type Rel Lang

SELECT DISTINCT B.SETID , A.ROLE_TYPE , B.SP_SURVEY_ID , L.LANGUAGE_CD , L.DESCR FROM PS_SP_SUR_SVTYPSUR A , PS_SET_CNTRL_GROUP S , PS_SP_SUR_DEFN B , PS_SP_SUR_DEFN_LNG L WHERE B.SETID = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'SP_04' AND S.SETID = A.SETID AND B.SP_SURVEY_ID = A.SP_SURVEY_ID AND B.SP_SUR_LIFE_STATUS = 'P' AND L.SETID = B.SETID AND L.SP_SURVEY_ID = B.SP_SURVEY_ID

  • Related Language Record for SP_SUR_SVTYP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    3 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description