INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTION_TBL
AV_MBR_ORG_CODAV_MBR_DUES_VW(SQL View) |
Index Back |
|---|---|
Membership Organizationthis table defines a Membership Organization |
| SELECT INSTITUTION, AV_MBR_ORG_COD, DESCR60 FROM PS_AV_MBR_ORG_TBL WHERE AV_MBR_DUES_REQ = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AV_MBR_ORG_COD |
Character(10) | VARCHAR2(10) NOT NULL | Member Organization Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |