BUSINESS_UNITAV_MBR_ORG_CODAV_DUES_LVLEFFDTDefault Value: %DATE
AV_STD_BENPrompt Table: AV_ITEM_TBL_VW
Y/N Table Edit
Default Value: N
AV_MBR_DUES_BEN(SQL Table) |
Index Back |
|---|---|
Mbrship Dues Benefitthis table stores the Membership Organization Benefits associated with joining at the given level. |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %DATE |
| 5 | AV_STD_BEN |
Character(6) | VARCHAR2(6) NOT NULL |
Standard Benefit
Prompt Table: AV_ITEM_TBL_VW |
| 6 | AV_BEN_VAL | Number(16,2) | DECIMAL(15,2) NOT NULL | Benefit Value |
| 7 | AV_BEN_FRST | Character(1) | VARCHAR2(1) NOT NULL |
First
Y/N Table Edit Default Value: N |