AV_GCLUB_TBL

(SQL Table)
 Index Back

Giving Club Table

Giving Club Table

  • Related Language Record: AVGCLUBTBLLNG

  • Parent Record Of AV_GCLUB_LVL

    • # 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
    3 GLCUB_NAME Character(30) VARCHAR2(30) NOT NULL Giving Club Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

    Prompt Table: AV_GCLUB_ADM_VW

    6 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

    Prompt Table: AV_INTV_CMP_VW

    7 START_DT Date(10) DATE Start Date
    8 END_DT Date(10) DATE end date
    9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    10 GCLUB_RESET Character(1) VARCHAR2(1) NOT NULL Reset Membership at Fiscal Yr

    Default Value: Y

    11 GCLUB_NOTIFY Character(1) VARCHAR2(1) NOT NULL Notify Staff Assigned to Donor
    N=No
    Y=Yes

    Default Value: Y

    12 GCLUB_ACKN Character(1) VARCHAR2(1) NOT NULL Special Acknowledgement
    N=No
    Y=Yes

    Default Value: N

    13 GCLUB_ELIG_DESIG Character(1) VARCHAR2(1) NOT NULL Eligible Designations
    A=All
    S=Specific
    T=Type

    Default Value: A

    14 GCLUB_H_CRDT Character(1) VARCHAR2(1) NOT NULL Hard Credits
    N=No
    Y=Yes

    Default Value: Y

    15 GCLUB_S_CRDT Character(1) VARCHAR2(1) NOT NULL Soft Credits
    N=No
    Y=Yes

    Default Value: N

    16 GLCUB_PLEDGE Character(1) VARCHAR2(1) NOT NULL Pledges
    N=No
    Y=Yes

    Default Value: N

    17 GCLUB_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Giving
    N=No
    Y=Yes

    Default Value: N

    18 GCLUB_MATCH Character(1) VARCHAR2(1) NOT NULL Matching Gifts
    N=No
    Y=Yes

    Default Value: N

    19 GCLUB_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Giving Club Name

    Default Value: AV_GCLUB_TBL.GLCUB_NAME