AV_MEMBER2_VW

(SQL View)
Index Back

Membership History view

This table mirrors the AV_MEMBERSHIP table for use in the AV_MBR_ENTRY_WRK panel. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, EMPLID, EXT_ORG_ID, AV_MBR_ORG_COD, MEMBERSHIP_NBR, AV_DUES_LVL, AV_MBRSHP_TYP, START_DT, MEMBERSHIP_AMT, EXPIRATION_DT, MBR_TYPE, MOTIVATION_CD, SESSION_NO, MBR_PMT_NO, seq_no FROM PS_AV_MEMBERSHIP -----------------------------------------------------------------------------------------------------------------

SELECT BUSINESS_UNIT, EMPLID, EXT_ORG_ID, AV_MBR_ORG_COD, MEMBERSHIP_NBR, AV_DUES_LVL, AV_MBRSHP_TYP, START_DT, MEMBERSHIP_AMT, EXPIRATION_DT, MBR_TYPE, MOTIVATION_CD, SESSION_NO, MBR_PMT_NO, SEQ_NO, INSTITUTION FROM PS_AV_MEMBERSHIP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
4 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

Prompt Table: AV_MBR_ORG_TBL

5 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number
6 AV_DUES_LVL Character(5) VARCHAR2(5) NOT NULL Dues Level

Prompt Table: AV_MBR_DUES_TBL

7 AV_MBRSHP_TYP Character(15) VARCHAR2(15) NOT NULL Membership Type
8 START_DT Date(10) DATE Start Date
9 MEMBERSHIP_AMT Number(16,2) DECIMAL(15,2) NOT NULL Membership Amount
10 EXPIRATION_DT Date(10) DATE Expiration Date
11 MBR_TYPE Character(1) VARCHAR2(1) NOT NULL Membership type
G=Gift
J=Joint
R=Referral
12 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

Prompt Table: AV_MTVTN_MBR_VW

13 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
14 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
15 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution