AV_GC_INIT_VW(SQL View) |
Index Back |
|---|---|
Giving Club Initialization VWThis view is used by the Giving Clubs cobol program to pull the Giving Clubs selected for Initialization that allow all designations. |
| SELECT A.OPRID ,A.RUN_CNTL_ID ,A.INSTITUTION ,A.GCLUB_CD ,B.START_DT ,B.END_DT ,B.STATUS ,B.GCLUB_RESET ,B.GCLUB_ELIG_DESIG ,B.GCLUB_H_CRDT ,B.GCLUB_S_CRDT ,B.GCLUB_SPOUSE ,B.GCLUB_MATCH FROM PS_AV_RUNCTL_GCINT A , PS_AV_GCLUB_TBL 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
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
| 4 | GCLUB_CD |
Character(9) | VARCHAR2(9) NOT NULL | Giving Club Code |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 8 | GCLUB_RESET | Character(1) | VARCHAR2(1) NOT NULL |
Reset Membership at Fiscal Yr
Default Value: Y |
| 9 | GCLUB_ELIG_DESIG | Character(1) | VARCHAR2(1) NOT NULL |
Eligible Designations
A=All S=Specific T=Type Default Value: A |
| 10 | GCLUB_H_CRDT | Character(1) | VARCHAR2(1) NOT NULL |
Hard Credits
N=No Y=Yes Default Value: Y |
| 11 | GCLUB_S_CRDT | Character(1) | VARCHAR2(1) NOT NULL |
Soft Credits
N=No Y=Yes Default Value: N |
| 12 | GCLUB_SPOUSE | Character(1) | VARCHAR2(1) NOT NULL |
Spouse Giving
N=No Y=Yes Default Value: N |
| 13 | GCLUB_MATCH | Character(1) | VARCHAR2(1) NOT NULL |
Matching Gifts
N=No Y=Yes Default Value: N |