AV_MBR_JOINT_VW(SQL View) |
Index Back |
|---|---|
Joint membership tableThis view is a mirror of the AV_MBR_JOINT table for use on the AV_MBR_ENTRY_WRK panel. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, SESSION_NO, MBR_PMT_NO, EMPLID, EXT_ORG_ID, MBR_TYPE, SA_ID_TYPE, PEOPLE_RELATION, ORG_RELATION, PE_RELATION, CNST_TYPE, ALUMNUS_TYPE FROM PS_AV_MBR_JOINT ----------------------------------------------------------------------------------------------------------------- |
| SELECT BUSINESS_UNIT, SESSION_NO, MBR_PMT_NO, EMPLID, EXT_ORG_ID, MBR_TYPE, SA_ID_TYPE, PEOPLE_RELATION, ORG_RELATION, PE_RELATION, CNST_TYPE, ALUMNUS_TYPE, INSTITUTION FROM PS_AV_MBR_JOINT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 3 | MBR_PMT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Member Payment Number |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: AV_PEOPLE_SRCH |
| 5 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: AV_EXT_ORG_SRCH |
| 6 | MBR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Membership type
G=Gift J=Joint R=Referral |
| 7 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person Default Value: P |
| 8 | PEOPLE_RELATION | Character(2) | VARCHAR2(2) NOT NULL | Relationship |
| 9 | ORG_RELATION | Character(2) | VARCHAR2(2) NOT NULL |
Relationship
BR=Branch CF=Corporate Foundation PC=Parent Company SS=Subsidiary |
| 10 | PE_RELATION | Character(2) | VARCHAR2(2) NOT NULL | Relationship |
| 11 | CNST_TYPE | Number(3,0) | SMALLINT NOT NULL | Constituent Type |
| 12 | ALUMNUS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Alumnus Type
G=Graduate N=Non-Degree U=Undergraduate |
| 13 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |