BUSINESS_UNITEMPLIDEXT_ORG_IDAV_MBR_ORG_CODPrompt Table: AV_MBR_ORG_TBL
MEMBERSHIP_NBRINSTITUTIONSCC_PS_AVMS_BND(SQL View) |
Index Back |
|---|---|
PopSel Bind record for AVMSPopSel Bind record for AVMS admin function used by 3C Engine |
| SELECT A.BUSINESS_UNIT ,A.EMPLID ,A.EXT_ORG_ID ,A.AV_MBR_ORG_COD ,A.MEMBERSHIP_NBR ,B.INSTITUTION FROM PS_AV_MEMBERSHIP A ,PS_AV_BUS_UNIT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | AV_MBR_ORG_COD |
Character(10) | VARCHAR2(10) NOT NULL |
Member Organization Code
Prompt Table: AV_MBR_ORG_TBL |
| 5 | MEMBERSHIP_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Membership Number |
| 6 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |