RSP_ASSIGN_GLVW

(SQL View)
 Index Back

Assignment Group

Assignment Group and Type for Assignment.

SELECT A.SETID , A.MARKET , B.ASSIGN_OWNER , A.ASSIGN_GROUP , A.LANGUAGE_CD , A.DESCR FROM PS_RSF_ASSIGNG_LNG A , PS_RSF_ASSIGN_GRP B WHERE A.SETID = B.SETID AND A.MARKET = B.MARKET AND A.ASSIGN_GROUP = B.ASSIGN_GROUP

  • Related Language Record for RSP_ASSIGN_GRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    3 ASSIGN_OWNER Character(3) VARCHAR2(3) NOT NULL Assigment Group Owner
    FS=Service
    PRM=Partner Sales
    RC=Case
    RSF=Sales
    RSP=Account Management

    Default Value: RSP

    4 ASSIGN_GROUP Character(30) VARCHAR2(30) NOT NULL This field is used to specify assignment group name for Territory assignment.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description