SPB_ROLETYSURVL

(SQL View)
 Index Back

Role Type Survey Rel Lang

Clone of Role Type table with change to prompt table for setid to pick up only setids for surveys associated to the Role Type Rel Language

SELECT A.SETID , A.ROLE_TYPE , L.LANGUAGE_CD , L.DESCRSHORT , L.DESCR FROM PS_SPB_ROLE_TYPE A , PS_SPB_ROLETYP_LNG L WHERE L.SETID = A.SETID AND L.ROLE_TYPE = A.ROLE_TYPE

  • Related Language Record for SPB_ROLETY_SURV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SVTYP_SETIDV

    2 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description