AV_M_JNT_DTL_VW(SQL View) |
Index Back |
|---|---|
Joint membership detailView of joint memberships joined with their membership payment record. |
| SELECT A.BUSINESS_UNIT , A.SESSION_NO , A.MBR_PMT_NO , A.EMPLID , A.EXT_ORG_ID , A.MBR_TYPE , A.SA_ID_TYPE , A.PEOPLE_RELATION , A.ORG_RELATION , A.PE_RELATION , A.CNST_TYPE , A.ALUMNUS_TYPE , A.INSTITUTION , B.AV_MBR_ORG_COD , B.ADJUSTMENT_FLG , B.AV_TTL_AMT_ENTRY , B.CURRENCY_CD_ENTRY , B.START_DT , B.AV_COMP_CHK FROM PS_AV_MBR_JOINT A , PS_AV_MBR_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND A.MBR_PMT_NO = B.MBR_PMT_NO |
| # | 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
Default Value: AV_SESSION_TBL.INSTITUTION |
| 14 | AV_MBR_ORG_COD | Character(10) | VARCHAR2(10) NOT NULL |
Member Organization Code
Prompt Table: AV_MBR_ORG_TBL |
| 15 | ADJUSTMENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Adjusted Flag
N=No Y=Yes Default Value: N |
| 16 | AV_TTL_AMT_ENTRY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Amt |
| 17 | CURRENCY_CD_ENTRY | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY |
| 18 | START_DT | Date(10) | DATE | Start Date |
| 19 | AV_COMP_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Complimentary
Y/N Table Edit Default Value: N |