AV_ADJ_MBR_JNT

(SQL Table)
 Index Back

Adjust Member Joint

This table is used for membership adjustments. The records are adjustment records for the Joint membership table.

  • Parent record: AV_ADJ_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 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

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

    Prompt Table: AV_EXT_ORG_SRCH

    7 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

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

    Default Value: AV_SESSION_TBL.INSTITUTION