INSTITUTIONAV_MBR_ORG_CODAV_MBR_ORG_VW(SQL View) |
Index Back |
|---|---|
Membership Organization ViewThis view show all Member Organizations for the Institution. |
| SELECT INSTITUTION, AV_MBR_ORG_COD, DESCR60, START_DATE, END_DATE FROM PS_AV_MBR_ORG_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | AV_MBR_ORG_COD |
Character(10) | VARCHAR2(10) NOT NULL | Member Organization Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |