RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Operational Data Store
Reporting View Target: GIFT_SOCIETY

Description Contains detail information for all gift societies to which a constituent has been associated by gift society year, including member leadership position as applicable.
Key & Frequency One row per entity per gift society year per gift society.
Recommended Search Columns ENTITY_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ASSIGNMENT Specifies whether the member was added by the system via a batch job or manually by a user. VARCHAR2(63)

APRDCLB

APRDCLB_DCAM_CODE

ASSIGNMENT_DESC Gift society assignment code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DECEASED_DATE Date the person died. DATE

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

DECEASED_STATUS Indicates whether a person is deceased. VARCHAR2(1)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

APRDCLB

APRDCLB_PIDM

GIFT_SOCIETY Gift society code. VARCHAR2(63)

APRDCLB

APRDCLB_DCNP_CODE

GIFT_SOCIETY_BASE_AMOUNT Base amount for the gift society that would qualify an identification number to be part of the society. NUMBER

NA

NA

GIFT_SOCIETY_CATEGORY Category of gift societies. VARCHAR2(63)

ATVDCNP

ATVDCNP_DCST_CODE

GIFT_SOCIETY_CATEGORY_DESC Society category description. VARCHAR2(255)

ATVDCST

ATVDCST_DESC

GIFT_SOCIETY_CATEGORY_PRIORITY Society type priority. Lowest number is the highest priority. A number may only be used once in the priority field. NUMBER

ATVDCST

ATVDCST_PRI_IND

GIFT_SOCIETY_DESC Gift society description. VARCHAR2(255)

ATVDCNP

ATVDCNP_DESC

GIFT_SOCIETY_END_YEAR Ending society year of the gift society. No members are allowed after this year. NUMBER

ATVDCNP

ATVDCNP_DCYR_CODE

GIFT_SOCIETY_END_YEAR_DESC Gift society club year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

GIFT_SOCIETY_LEADER_POSN Indicates a leadership position whether it be an officer, honorary, or chair. VARCHAR2(63)

NA

NA

GIFT_SOCIETY_LEADER_POSN_DESC Leadership position. VARCHAR2(255)

NA

NA

GIFT_SOCIETY_NAME Gift society name. The name defaults from the constituent or organization record when a membership is created. The name may be changed for each membership created. VARCHAR2(63)

APRDCLB

APRDCLB_SOCIETY_NAME

GIFT_SOCIETY_PRIORITY Unique priority indicator of the gift society. Lowest number is the highest priority. NUMBER

ATVDCNP

ATVDCNP_PRIORITY_IND

GIFT_SOCIETY_YEAR Gift society year for which the constituent/organization is a member. NUMBER

APRDCLB

APRDCLB_DCYR_CODE

GIFT_SOCIETY_YEAR_DESC Gift society club year description. VARCHAR2(255)

ATVDCYR

ATVDCYR_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IND_GIFT_SOCIETY_QUALIFY_AMT Qualifying gift amount for the identification number. NUMBER

NA

NA

LIFETIME_GIFT_SOCIETY_IND Indicates whether the gift society is a lifetime membership. VARCHAR2(1)

CALCULATION

DECODE(APRDCLB_DCYR_CODE,'9999','Y','N')

MANUAL_ENTRY_IND Indicates whether gift society members must be entered into this society manually, not computer calculated. VARCHAR2(1)

ATVDCNP

ATVDCNP_MANL_ENTRY_IND

MEMBER_DELETE_IND Specifies whether a member may be deleted from the gift society. VARCHAR2(1)

ATVDCNP

ATVDCNP_DELETE_IND

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

QUALIFY_DATE Date the membe+G11442r qualified for the society. DATE

APRDCLB

APRDCLB_QUALIFY_DATE

RULE_NUMBER Rule number by which the member qualified for the gift society. NUMBER

APRDCLB

APRDCLB_RULE_NO

YEAR_END_DATE Ending date of the gift society year. DATE

ATVDCYR

ATVDCYR_END_DATE

YEAR_START_DATE Beginning date of the gift society year. DATE

ATVDCYR

ATVDCYR_START_DATE



Ver: 3.1