AVMBRCRIT1BLDVW(SQL View) |
Index Back |
---|---|
Mbr Organization Criteria vwthis 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 |