AV_INTV_PLANAUD

(SQL Table)
 Index Back

Initiatvie Plan Audience

This is a junction record that links Audiences that have been defined for an Initiative to that Initiatives PR Plan. A PR Plan can have mutiple Audiences and an Audience can belong to multiple PR Plans. Many to Many junction.

  • Parent record: AV_INTV_PLAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

    Prompt Table: AV_INTV_TBL

    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Prompt Table: AV_INTV_PLAN

    4 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
    5 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code

    Prompt Table: AV_INTV_AUD2_VW

    6 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