AV_GC_INTTYP_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.OPRID ,A.RUN_CNTL_ID ,A.INSTITUTION ,A.GCLUB_CD ,B.AV_INST_TYPE ,B.START_DT ,B.END_DT ,B.STATUS ,B.GCLUB_RESET ,B.GCLUB_H_CRDT ,B.GCLUB_S_CRDT ,B.GCLUB_SPOUSE ,B.GCLUB_MATCH FROM PS_AV_RUNCTL_GCINT A , PS_AV_GCLUB_TYP_VW B WHERE A.INSTITUTION = B.INSTITUTION AND A.GCLUB_CD = B.GCLUB_CD

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