AV_INTV_GOALS(SQL Table) |
Index Back |
|---|---|
Initiative GoalsInitiative Goals |
| # | 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 | AV_GOAL_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Goal Type
Prompt Table: AV_GOAL_TYP_TBL |
| 4 | GOAL_DT |
Date(10) | DATE NOT NULL |
Target Date
Default Value: %Date |
| 5 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | 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 |
| 7 | AV_AUDIENCE | Character(10) | VARCHAR2(10) NOT NULL |
Audience Code
Prompt Table: AV_INTV_AUD2_VW |
| 8 | 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 Default Value: S |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: AV_INSTALL_INST.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 10 | GOAL_AMOUNT | Number(16,2) | DECIMAL(15,2) NOT NULL | Goal Amount |
| 11 | GOAL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Goal Percent |
| 12 | GOAL_TOTAL | Number(9,0) | DECIMAL(9) NOT NULL | Goal Total |