AV_MBR_BUILD(SQL View) |
Index Back |
|---|---|
Run Build View for MBR.Run Build View for Member |
| SELECT A.BUSINESS_UNIT , A.AV_MBR_ORG_COD , B.AV_AUDIENCE , B.AUD_TYPE , B.AV_MBR_CRIT_TYP , A.AV_SELECTION_PRCS , A.INSTITUTION , A.RSRC_INTV_TYPE , A.START_DATE , A.END_DATE 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 A.INSTITUTION = B.INSTITUTION AND B.BUILT_FLG = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT Prompt Table: AV_BUS_UNIT_TBL |
| 2 | AV_MBR_ORG_COD |
Character(10) | VARCHAR2(10) NOT NULL | Member Organization Code |
| 3 | AV_AUDIENCE |
Character(10) | VARCHAR2(10) NOT NULL |
Audience Code
Prompt Table: %EDITTABLE |
| 4 | AUD_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
A=Administrative R=Reporting S=Segmentation |
| 5 | AV_MBR_CRIT_TYP |
Character(1) | VARCHAR2(1) NOT NULL |
This field is used to capture the type of Membership Criteria the user is setting up. It will identify whether to search for Person (people) or Organization (businesses).
B=Both O=Organization P=Person |
| 6 | AV_SELECTION_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Select of Process in Audience Criteria.
B=Build/Merge Process P=Population Selection Default Value: B |
| 7 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 8 | RSRC_INTV_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Initiative Type
Prompt Table: AV_INTV_TYP_TBL |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |