AV_DONR_APPR

(SQL Table)
 Index Back

Donor appreciation

This table keeps the donor apprecitation items given to a constituent

  • Parent Record Of AV_DONR_APPRCAF

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 DATE_GIVEN Date(10) DATE NOT NULL Date Given
    5 ITEM_CD Character(6) VARCHAR2(6) NOT NULL Item Code

    Prompt Table: AV_ITEM_TBL

    6 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

    Prompt Table: %EDITTABLE

    7 UNIT_CD Character(11) VARCHAR2(11) NOT NULL Unit Code

    Prompt Table: AV_UNIT_TBL

    8 ASGNMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Assignment Type
    S=Staff
    U=Unit
    V=Volunteer

    Default Value: S

    9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: AV_INST_BU_VW

    10 DESCRLONG Long Character CLOB Long Description