AV_MBR_BEN_VW (SQL View)	Index Back
Mbrship Dues Benefit this table stores the Membership Organization Benefits associated with joining at the given level. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT A.INSTITUTION, A.AV_MBR_ORG_COD, A.AV_DUES_LVL, A.EFFDT, A.AV_STD_BEN, A.AV_BEN_VAL, A.AV_BEN_FRST FROM PS_AV_MBR_DUES_BEN A, PS_AV_MBR_DUES_AMT B WHERE A.INSTITUTION=B.INSTITUTION AND A.AV_MBR_ORG_COD=B.AV_MBR_ORG_COD AND A.AV_DUES_LVL=B.AV_DUES_LVL AND A.EFFDT=B.EFFDT AND B.EFFDT IN (SELECT MAX(A1.EFFDT) FROM PS_AV_MBR_DUES_DES A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.AV_MBR_ORG_COD=A.AV_MBR_ORG_COD AND A1.AV_DUES_LVL=A.AV_DUES_LVL) AND B.EFF_STATUS='A' -----------------------------------------------------------------------------------------------------------------

AV_MBR_BEN_VW

(SQL View)

Mbrship Dues Benefit

this table stores the Membership Organization Benefits associated with joining at the given level. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT A.INSTITUTION, A.AV_MBR_ORG_COD, A.AV_DUES_LVL, A.EFFDT, A.AV_STD_BEN, A.AV_BEN_VAL, A.AV_BEN_FRST FROM PS_AV_MBR_DUES_BEN A, PS_AV_MBR_DUES_AMT B WHERE A.INSTITUTION=B.INSTITUTION AND A.AV_MBR_ORG_COD=B.AV_MBR_ORG_COD AND A.AV_DUES_LVL=B.AV_DUES_LVL AND A.EFFDT=B.EFFDT AND B.EFFDT IN (SELECT MAX(A1.EFFDT) FROM PS_AV_MBR_DUES_DES A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.AV_MBR_ORG_COD=A.AV_MBR_ORG_COD AND A1.AV_DUES_LVL=A.AV_DUES_LVL) AND B.EFF_STATUS='A' -----------------------------------------------------------------------------------------------------------------

SELECT A.BUSINESS_UNIT, A.AV_MBR_ORG_COD, A.AV_DUES_LVL, A.EFFDT, A.AV_STD_BEN, A.AV_BEN_VAL, A.AV_BEN_FRST FROM PS_AV_MBR_DUES_BEN A, PS_AV_MBR_DUES_AMT B WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.AV_MBR_ORG_COD = B.AV_MBR_ORG_COD AND A.AV_DUES_LVL=B.AV_DUES_LVL AND B.EFF_STATUS='A' AND A.EFFDT=B.EFFDT AND B.EFFDT IN (SELECT MAX(A1.EFFDT) FROM PS_AV_MBR_DUES_DES A1 WHERE A1.BUSINESS_UNIT =A.BUSINESS_UNIT AND A1.AV_MBR_ORG_COD=A.AV_MBR_ORG_COD AND A1.AV_DUES_LVL=A.AV_DUES_LVL)

Parent record: AV_MBR_DUES_AMT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

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

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %DATE

5 AV_STD_BEN Character(6) VARCHAR2(6) NOT NULL Standard Benefit
Prompt Table: AV_ITEM_TBL_VW

6 AV_BEN_VAL Number(16,2) DECIMAL(15,2) NOT NULL Benefit Value

7 AV_BEN_FRST Character(1) VARCHAR2(1) NOT NULL First
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code
3	AV_DUES_LVL	Character(5)	VARCHAR2(5) NOT NULL	Dues Level
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
5	AV_STD_BEN	Character(6)	VARCHAR2(6) NOT NULL	Standard Benefit Prompt Table: AV_ITEM_TBL_VW
6	AV_BEN_VAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Benefit Value
7	AV_BEN_FRST	Character(1)	VARCHAR2(1) NOT NULL	First Y/N Table Edit Default Value: N