AV_GCLUB_OWN_VW

(SQL View)
 Index Back

Giving Club Owner View

Giving Club Owner View 02/15/00 - CD - Reference R-SSEMEG-DM6G6 Prior SQL: SELECT INSTITUTION, GCLUB_CD, GLCUB_NAME FROM PS_AV_GCLUB_TBL

SELECT INSTITUTION, GCLUB_CD, GLCUB_NAME FROM PS_AV_GCLUB_TBL WHERE START_DT <= %CURRENTDATEIN AND (END_DT >= %CURRENTDATEIN OR END_DT IS NULL) AND STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: AV_OPR_DEF_TBL.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

2 GCLUB_CD Character(9) VARCHAR2(9) NOT NULL Giving Club Code

Prompt Table: AV_GCLUB_TBL

3 GLCUB_NAME Character(30) VARCHAR2(30) NOT NULL Giving Club Name