AV_MBR_JOINT

(SQL Table)
 Index Back

Joint Memberships table

This table holds information on joint Memberships and their constituents.

  • Parent record: AV_MBR_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    3 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: AV_EXT_ORG_SRCH

    6 MBR_TYPE Character(1) VARCHAR2(1) NOT NULL Membership type
    G=Gift
    J=Joint
    R=Referral
    7 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

    8 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    9 ORG_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    BR=Branch
    CF=Corporate Foundation
    PC=Parent Company
    SS=Subsidiary
    10 PE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    11 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
    12 ALUMNUS_TYPE Character(1) VARCHAR2(1) NOT NULL Alumnus Type
    G=Graduate
    N=Non-Degree
    U=Undergraduate
    13 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_SESSION_TBL.INSTITUTION