MEMBER_PERSON

(SQL Table)
 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.

  • Related Language Record: MEMBER_PRSN_LNG

    • # 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 SUPPORT_TEAM_MBR Character(8) VARCHAR2(8) NOT NULL Team Member
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

    Default Value: PERSONAL_DATA.NAME

    5 TEAM_MEMBER_TYPE Character(6) VARCHAR2(6) NOT NULL Team Member Type Code

    Prompt Table: MEMBER_TYPE_TBL

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: OM_VNDR_CUST_VW

    8 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: REGNCD_MBR_VW

    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DEF_COMPCT_SRC Character(4) VARCHAR2(4) NOT NULL Default Commission Pct Source
    MBR=Commissioned Member
    SCH=Commission Schedule
    11 QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Basis
    B=Bookings
    S=Shipments
    12 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %
    13 COMM_BKS Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Bookings
    14 COMM_SHP Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Shipping
    15 COMM_INV Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Invoice
    16 COMM_CASH Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Cash Rec
    17 EXT_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Electronic Mail Address
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL