BUSINESS_UNITAV_MBR_ORG_CODAV_DUES_LVLPrompt Table: AV_MBR_TYP_TBL
Prompt Table: AV_MBR_CAT_TBL
Default Value: AV_MBR_ORG_TBL.INSTITUTION
AV_MBR_DUES_TBL(SQL Table) |
Index Back |
|---|---|
Mbrship Dues Tablethis table defines the Dues Level of the Membership Organization |
| # | 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 | AV_DUES_LVL |
Character(5) | VARCHAR2(5) NOT NULL | Dues Level |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | AV_MBRSHP_TYP | Character(15) | VARCHAR2(15) NOT NULL |
Membership Type
Prompt Table: AV_MBR_TYP_TBL |
| 6 | AV_MBRSHP_CAT | Character(15) | VARCHAR2(15) NOT NULL |
Membership Category
Prompt Table: AV_MBR_CAT_TBL |
| 7 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_MBR_ORG_TBL.INSTITUTION |