Target Column |
Business Name |
Business Definition |
Database Data Type |
Business Data Type |
Domain Value |
Source Name |
Source Column |
Local Source |
Local Target |
SOLICITOR_ORGANIZATION
|
Solicitor Organization
|
Solicitor organization code.
|
VARCHAR2(63)
|
|
|
ASRSSAG
|
ASRSSAG_SOL_ORG
|
NO
|
NO
|
SOLICITOR_ORGANIZATION_NAME
|
Solicitor Organization Name
|
Solicitor organization name.
|
VARCHAR2(255)
|
|
|
ASBSORG
|
ASBSORG_NAME
|
NO
|
NO
|
SOLICITOR_UID
|
Solicitor UID
|
System generated, unique, internal identification number assigned to this solicitor.
|
NUMBER
|
|
|
ASRSSAG
|
ASRSSAG_PIDM
|
NO
|
NO
|
SOLICITOR_ID
|
Solicitor ID
|
Solicitor's current identification number.
|
VARCHAR2(63)
|
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
SOLICITOR_NAME
|
Solicitor Name
|
Name of the solicitor (last name, first name, middle initial) or organization name.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
GIFT_SOCIETY_YEAR
|
Gift Society Year
|
Gift society year for the solicitor organization's annual goal.
|
VARCHAR2(63)
|
|
|
ASRSSAG
|
ASRSSAG_DCYR_CODE
|
NO
|
NO
|
GIFT_SOCIETY_YEAR_DESC
|
Gift Society Year Description
|
Gift society club year description.
|
VARCHAR2(255)
|
|
|
ATVDCYR
|
ATVDCYR_DESC
|
NO
|
NO
|
SOLICITOR_PARTICIPATION_GOAL
|
Solicitor Participation Goal
|
Solicitor's annual goal for percentage of contacts who are expected to donate.
|
NUMBER
|
|
|
ASRSSAG
|
ASRSSAG_PARTICIPATION_GOAL
|
NO
|
NO
|
SOLICITOR_GOAL
|
Solicitor Goal
|
Amount of the solicitor annual goal for the gift society.
|
NUMBER
|
|
|
ASRSSAG
|
ASRSSAG_DOLLAR_GOAL
|
NO
|
NO
|
SOLICITOR_DONOR_COUNT_GOAL
|
Solicitor Donor Count Goal
|
Solicitor's annual goal for the number of donors for gifts.
|
NUMBER
|
|
|
ASRSSAG
|
ASRSSAG_DONOR_COUNT_GOAL
|
NO
|
NO
|
MAXIMUM_ASSIGNED_CONTACT_COUNT
|
Maximum Assigned Contact Count
|
Maximum number of contacts that can be assigned to the solicitor.
|
NUMBER
|
|
|
ASRSSAG
|
ASRSSAG_MAX_CONTACTS
|
NO
|
NO
|
REPORT_TO_UID
|
Report To UID
|
Solicitor unique identification to report to that is one level higher in the organization hierarchy.
|
NUMBER
|
|
|
ASRSSAG
|
ASRSSAG_REPORT_TO_PIDM
|
NO
|
NO
|
REPORT_TO_ID
|
Report To ID
|
Report to solicitor current identification number.
|
VARCHAR2(63)
|
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
REPORT_TO_NAME
|
Report To Name
|
Report to solicitor name (last name, first name, middle initial) or organization name.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
SOLICITOR_USER_ID
|
Solicitor User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
|
|
ASRSSAG
|
ASRSSAG_USER
|
NO
|
NO
|
SOLICITOR_ACTIVITY_DATE
|
Solicitor Activity Date
|
Date information for this record in the table was entered or last updated.
|
DATE
|
|
|
ASRSSAG
|
ASRSSAG_ACTIVITY_DATE
|
NO
|
NO
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
|
NA
|
NA
|
NO
|
NO
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
|
NA
|
NA
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
|
NA
|
NA
|
NO
|
NO
|