AV_GCLUB_TYP_VW

(SQL View)
 Index Back

Giving Club Type View

Giving Club Type View 02/15/00 - CD - Reference R-SSEMEG-DM6G6 Prior SQL: SELECT A.INSTITUTION ,A.GCLUB_CD ,B.AV_INST_TYPE ,A.START_DT ,A.END_DT ,A.GCLUB_H_CRDT ,A.GCLUB_S_CRDT ,A.GCLUB_SPOUSE ,A.GCLUB_MATCH FROM PS_AV_GCLUB_TBL A, PS_AV_GCLUB_ETYPE B WHERE A.INSTITUTION = B.INSTITUTION AND A.GCLUB_CD = B.GCLUB_CD

SELECT A.INSTITUTION ,A.GCLUB_CD ,B.AV_INST_TYPE ,A.START_DT ,A.END_DT ,A.STATUS ,A.GCLUB_RESET ,A.GCLUB_H_CRDT ,A.GCLUB_S_CRDT ,A.GCLUB_SPOUSE ,A.GCLUB_MATCH FROM PS_AV_GCLUB_TBL A , PS_AV_GCLUB_ETYPE B WHERE A.INSTITUTION = B.INSTITUTION AND A.GCLUB_CD = B.GCLUB_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 GCLUB_CD Character(9) VARCHAR2(9) NOT NULL Giving Club Code
3 AV_INST_TYPE Character(6) VARCHAR2(6) NOT NULL Designation Type
4 START_DT Date(10) DATE Start Date
5 END_DT Date(10) DATE end date
6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
7 GCLUB_RESET Character(1) VARCHAR2(1) NOT NULL Reset Membership at Fiscal Yr
8 GCLUB_H_CRDT Character(1) VARCHAR2(1) NOT NULL Hard Credits
N=No
Y=Yes
9 GCLUB_S_CRDT Character(1) VARCHAR2(1) NOT NULL Soft Credits
N=No
Y=Yes
10 GCLUB_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Giving
N=No
Y=Yes
11 GCLUB_MATCH Character(1) VARCHAR2(1) NOT NULL Matching Gifts
N=No
Y=Yes