RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Operational Data Store
Composite View Target: AA_GIFT_SOCIETY

Description Source composite view contains information on each gift society to which a person or organization is affiliated on a per year basis.

Target Column Business Definition Database Data Type Source Name Source Column
ASSIGNMENT Specifies whether the member was added by the system via a batch job or manually by a user. VARCHAR2(2)

APRDCLB

APRDCLB_DCAM_CODE

ASSIGNMENT_DESC Gift society assignment code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

APRDCLB

APRDCLB_PIDM

GIFT_SOCIETY Gift society code. VARCHAR2(4)

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(2)

ATVDCNP

ATVDCNP_DCST_CODE

GIFT_SOCIETY_CATEGORY_DESC Society category description. VARCHAR2(30)

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(2)

ATVDCST

ATVDCST_PRI_IND

GIFT_SOCIETY_DESC Gift society description. VARCHAR2(30)

ATVDCNP

ATVDCNP_DESC

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

ATVDCNP

ATVDCNP_DCYR_CODE

GIFT_SOCIETY_END_YEAR_DESC Gift society club year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

GIFT_SOCIETY_LEADER_POSN_DESC Leadership position. VARCHAR2(0)

NA

NA

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

APRDCLB

APRDCLB_SOCIETY_NAME

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

ATVDCNP

ATVDCNP_PRIORITY_IND

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

APRDCLB

APRDCLB_DCYR_CODE

GIFT_SOCIETY_YEAR_DESC Gift society club year description. VARCHAR2(30)

ATVDCYR

ATVDCYR_DESC

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; i.e. not computer calculated. VARCHAR2(1)

ATVDCNP

ATVDCNP_MANL_ENTRY_IND

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

ATVDCNP

ATVDCNP_DELETE_IND

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

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

NA

NA

QUALIFY_DATE Date on which the member qualified for the society. DATE

APRDCLB

APRDCLB_QUALIFY_DATE

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

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

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

NA

NA



Ver: 3.1