AV_GC_INTDES_VW

(SQL View)
 Index Back

Giving Club Initialize Des VW

This view is used by the Giving Clubs cobol program to pull the Giving Clubs selected for Initialization that allow specific designations.

SELECT A.OPRID ,A.RUN_CNTL_ID ,A.INSTITUTION ,A.GCLUB_CD ,B.DESIGNATION ,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_DES_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 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
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