AV_MBR_BNFT_VW

(SQL View)
 Index Back

Membership Benefits table view

This view mirrors the Membership Benefits table for use on the AV_MBR_ENTRY_WRK panel. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, MBR_PMT_NO, EMPLID, EXT_ORG_ID, AV_STD_BEN, AV_MBR_ORG_COD, AV_DUES_LVL, START_DT, AV_BEN_VAL, MOTIVATION_CD, SESSION_NO, INTV_CD FROM PS_AV_MBR_BNFT -----------------------------------------------------------------------------------------------------------------

SELECT BUSINESS_UNIT, MBR_PMT_NO, EMPLID, EXT_ORG_ID, AV_STD_BEN, AV_MBR_ORG_COD, AV_DUES_LVL, START_DT, AV_BEN_VAL, MOTIVATION_CD, SESSION_NO, INTV_CD, INSTITUTION FROM PS_AV_MBR_BNFT

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

Prompt Table: AV_MBR_ORG_TBL

7 AV_DUES_LVL Character(5) VARCHAR2(5) NOT NULL Dues Level

Prompt Table: AV_MBR_DUES_TBL

8 START_DT Date(10) DATE Start Date
9 AV_BEN_VAL Number(16,2) DECIMAL(15,2) NOT NULL Benefit Value
10 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

Prompt Table: AV_MTVTN_MBR_VW

11 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
12 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
13 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution