AVMBRCRIT1BLDVW

(SQL View)
Index Back

Mbr Organization Criteria vw

this table defines a Non Dues Membership Organization for Build/Merge Process.

SELECT DISTINCT A.BUSINESS_UNIT , B.AV_MBR_ORG_COD , A.DESCR60 FROM PS_AV_MBR_ORG_TBL A , PS_AV_MBR_CRIT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AV_MBR_ORG_COD = B.AV_MBR_ORG_COD AND B.BUILT_FLG='Y' AND A.AV_SELECTION_PRCS = 'B'

# 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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description