GM_PROP_LNGVW

(SQL View)
 Index Back

Support Team Member Table

This is the parent table for storing information on support team members. These support team members have a set of person data associated to them (addresses, phones, etc) as well as commission information. Child tables of this table are MEMBER_ADDRESS, MEMBER_PHONE.

SELECT DISTINCT A.SETID , A.SUPPORT_TEAM_MBR , A.LANGUAGE_CD , A.NAME1 FROM PS_MEMBER_PRSN_LNG A

  • Related Language Record for GM_SALE_SRCH_VW

    • # 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_SETID_NONVW

    2 GM_PROP_CONTACT Character(8) VARCHAR2(8) NOT NULL Proposal Contact
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GM_CUST_NM Character(40) VARCHAR2(40) NOT NULL Name