Reporting View Target: SOLICITOR

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: SOLICITOR_ASSIGNMENT

Description Contains data about solicitation assignments. This includes information about constituents assigned to either a campaign, type of solicitation, solicitor organization and or solicitor with ask amounts and ask dates.
Key & Frequency One occurrence per campaign per solicitation_type per solicitor_organization per solicitor_uid per assignment_sequence_number per solicitation_year.
Recommended Search Columns CAMPAIGN_TYPE
CAMPAIGN, SOLICITATION_TYPE, SOLICITOR_ORGANIZATION, SOLICITOR_UID, ASSIGNMENT_SEQUENCE_NUMBER, SOLICITATION_YEAR
SOLICITOR_UID
SOLICITOR_ORGANIZATION
RATING

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target

CAMPAIGN Campaign Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)
AFRCTYP

AFRCTYP_CAMPAIGN

NO
NO

CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

NO
NO

CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)
AFBCAMP

AFBCAMP_CMTP_CODE

NO
NO

CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)
ATVCMTP

ATVCMTP_DESC

NO
NO

SOLICITATION_TYPE Solicitation Type Solicitation type code. VARCHAR2(63)
AFRCTYP

AFRCTYP_SOLC_CODE

NO
NO

SOLICITATION_TYPE_DESC Solicitation Type Description Solicitation type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

SOLICITOR_ORGANIZATION Solicitor Organization Solicitor organization code. VARCHAR2(63)
AFRCTYP

AFRCTYP_SOL_ORG

NO
NO

SOLICITOR_ORGANIZATION_NAME Solicitor Organization Name Solicitor organization name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

SOLICITOR_UID Solicitor UID System generated, unique, internal identification number assigned to this solicitor. NUMBER
AFRCTYP

AFRCTYP_PIDM

NO
NO

SOLICITOR_ID Solicitor ID Solicitor current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_ENTITY_IND Solicitor Entity Indicator Indicates whether this is a person or entity record. VARCHAR2(1)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_NAME Solicitor Name Name of the solicitor person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_FIRST_NAME Solicitor First Name Solicitor first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_LAST_NAME Solicitor Last Name Solicitor last name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

ASSIGNMENT_SEQUENCE_NUMBER Assignment Sequence Number System-generated one-up number assigned to constituents assigned to a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record. NUMBER
AFRCTYP

AFRCTYP_SEQ_NO

NO
NO

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this constituent. NUMBER
AFRCTYP

AFRCTYP_CONSTITUENT_PIDM

NO
NO

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

ENTITY_IND Entity Indicator Indicates whether this is a person or entity record. VARCHAR2(1)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

NAME Name Constitutent name. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

FIRST_NAME First Name Constitutent first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

LAST_NAME Last Name Constituent last name or organization name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

RATING Rating Rating code assigned to the constituent by the rater. VARCHAR2(63)
AFRCTYP

AFRCTYP_RATE_CODE

NO
NO

RATING_DESC Rating Description Rating description. VARCHAR2(255)
ATVRATE

ATVRATE_DESC

NO
NO

RATE_AMOUNT Rate Amount Rating amount. NUMBER
ATVRATE

ATVRATE_RATE_AMT

NO
NO

SCREENING Screening Rate screening type assigned to the rater. For example, staff, consultant, volunteer, etc. VARCHAR2(63)
AFRCTYP

AFRCTYP_RSCR_CODE

NO
NO

SCREENING_DESC Screening Description Screening description. VARCHAR2(255)
ATVRSCR

ATVRSCR_DESC

NO
NO

RATER_UID Rater UID System generated, unique, internal identification number assigned to this rater. NUMBER
AFRCTYP

AFRCTYP_RATER_PIDM

NO
NO

RATER_ID Rater ID Rater's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

RATER_NAME Rater Name Rater name. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

RATER_FIRST_NAME Rater First Name Rater first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

RATER_LAST_NAME Rater Last Name Rater last name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

ASK_AMOUNT Ask Amount Amount the solicitor asked the constituent to give or pledge. NUMBER
AFRCTYP

AFRCTYP_ASK_AMOUNT

NO
NO

ASK_DATE Ask Date Date when the solicitor asked the constituent for a gift or a pledge. DATE
AFRCTYP

AFRCTYP_ASK_DATE

NO
NO

ASSIGN_DATE Assignment Date Date when the constituent was assigned to the solicitor. DATE
AFRCTYP

AFRCTYP_ASSSIGN_DATE

NO
NO

SOLICITATION_YEAR Solicitation Year Year in which the solicitation ask amount should be made. VARCHAR2(63)
AFRCTYP

AFRCTYP_DCYR_CODE

NO
NO

SOLICITATION_YEAR_DESC Solicitation Year Description Year description. VARCHAR2(255)
ATVDCYR

ATVDCYR_DCYR_DESC

NO
NO

SOLICITATION_YEAR_START_DATE Solicitation Year Start Date Year start date. DATE
ATVDCYR

ATVDCYR_START_DATE

NO
NO

SOLICITATION_YEAR_END_DATE Solicitation Year End Date Year end date. DATE
ATVDCYR

ATVDCYR_END_DATE

NO
NO

ASSIGNMENT_COMMENT Assignment Comment Assignment comment. VARCHAR2(2000)
AFRCTYP

AFRCTYP_COMMENT

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

SOLICITOR_ASSIGN_USER_ID Solicitor Assignment User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)
AFRCTYP

AFRCTYP_USER

NO
NO

SOLICITOR_ASSIGN_ACTIVITY_DATE Solicitor Assignment Activity Date Date that information for this record in the table was entered or last updated. DATE
AFRCTYP

AFRCTYP_ACTIVITY_DATE

NO
NO

SOLICITOR_ASSIGNED_IND Solicitor Assigned Indicator Determines if the solicitor has been assigned to the contact. (Y)es, solicitor is assigned, (N)o, solicitor is not assigned. VARCHAR2(1)
AFRCTYP

DECODE (AFRCTYP_PIDM, NULL, 'N', 'Y')

NO
NO

Ver: 9.2

Description	Contains data about solicitation assignments. This includes information about constituents assigned to either a campaign, type of solicitation, solicitor organization and or solicitor with ask amounts and ask dates.
Key & Frequency	One occurrence per campaign per solicitation_type per solicitor_organization per solicitor_uid per assignment_sequence_number per solicitation_year.
Recommended Search Columns	CAMPAIGN_TYPE CAMPAIGN, SOLICITATION_TYPE, SOLICITOR_ORGANIZATION, SOLICITOR_UID, ASSIGNMENT_SEQUENCE_NUMBER, SOLICITATION_YEAR SOLICITOR_UID SOLICITOR_ORGANIZATION RATING

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
CAMPAIGN	Campaign	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)	AFRCTYP	AFRCTYP_CAMPAIGN	NO	NO
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE	NO	NO
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC	NO	NO
SOLICITATION_TYPE	Solicitation Type	Solicitation type code.	VARCHAR2(63)	AFRCTYP	AFRCTYP_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Solicitation Type Description	Solicitation type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(63)	AFRCTYP	AFRCTYP_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	AFRCTYP	AFRCTYP_PIDM	NO	NO
SOLICITOR_ID	Solicitor ID	Solicitor current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_ENTITY_IND	Solicitor Entity Indicator	Indicates whether this is a person or entity record.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_NAME	Solicitor Name	Name of the solicitor person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_FIRST_NAME	Solicitor First Name	Solicitor first name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_LAST_NAME	Solicitor Last Name	Solicitor last name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSIGNMENT_SEQUENCE_NUMBER	Assignment Sequence Number	System-generated one-up number assigned to constituents assigned to a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record.	NUMBER	AFRCTYP	AFRCTYP_SEQ_NO	NO	NO
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this constituent.	NUMBER	AFRCTYP	AFRCTYP_CONSTITUENT_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether this is a person or entity record.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Constitutent name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
FIRST_NAME	First Name	Constitutent first name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
LAST_NAME	Last Name	Constituent last name or organization name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
RATING	Rating	Rating code assigned to the constituent by the rater.	VARCHAR2(63)	AFRCTYP	AFRCTYP_RATE_CODE	NO	NO
RATING_DESC	Rating Description	Rating description.	VARCHAR2(255)	ATVRATE	ATVRATE_DESC	NO	NO
RATE_AMOUNT	Rate Amount	Rating amount.	NUMBER	ATVRATE	ATVRATE_RATE_AMT	NO	NO
SCREENING	Screening	Rate screening type assigned to the rater. For example, staff, consultant, volunteer, etc.	VARCHAR2(63)	AFRCTYP	AFRCTYP_RSCR_CODE	NO	NO
SCREENING_DESC	Screening Description	Screening description.	VARCHAR2(255)	ATVRSCR	ATVRSCR_DESC	NO	NO
RATER_UID	Rater UID	System generated, unique, internal identification number assigned to this rater.	NUMBER	AFRCTYP	AFRCTYP_RATER_PIDM	NO	NO
RATER_ID	Rater ID	Rater's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
RATER_NAME	Rater Name	Rater name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
RATER_FIRST_NAME	Rater First Name	Rater first name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
RATER_LAST_NAME	Rater Last Name	Rater last name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASK_AMOUNT	Ask Amount	Amount the solicitor asked the constituent to give or pledge.	NUMBER	AFRCTYP	AFRCTYP_ASK_AMOUNT	NO	NO
ASK_DATE	Ask Date	Date when the solicitor asked the constituent for a gift or a pledge.	DATE	AFRCTYP	AFRCTYP_ASK_DATE	NO	NO
ASSIGN_DATE	Assignment Date	Date when the constituent was assigned to the solicitor.	DATE	AFRCTYP	AFRCTYP_ASSSIGN_DATE	NO	NO
SOLICITATION_YEAR	Solicitation Year	Year in which the solicitation ask amount should be made.	VARCHAR2(63)	AFRCTYP	AFRCTYP_DCYR_CODE	NO	NO
SOLICITATION_YEAR_DESC	Solicitation Year Description	Year description.	VARCHAR2(255)	ATVDCYR	ATVDCYR_DCYR_DESC	NO	NO
SOLICITATION_YEAR_START_DATE	Solicitation Year Start Date	Year start date.	DATE	ATVDCYR	ATVDCYR_START_DATE	NO	NO
SOLICITATION_YEAR_END_DATE	Solicitation Year End Date	Year end date.	DATE	ATVDCYR	ATVDCYR_END_DATE	NO	NO
ASSIGNMENT_COMMENT	Assignment Comment	Assignment comment.	VARCHAR2(2000)	AFRCTYP	AFRCTYP_COMMENT	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
SOLICITOR_ASSIGN_USER_ID	Solicitor Assignment User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	AFRCTYP	AFRCTYP_USER	NO	NO
SOLICITOR_ASSIGN_ACTIVITY_DATE	Solicitor Assignment Activity Date	Date that information for this record in the table was entered or last updated.	DATE	AFRCTYP	AFRCTYP_ACTIVITY_DATE	NO	NO
SOLICITOR_ASSIGNED_IND	Solicitor Assigned Indicator	Determines if the solicitor has been assigned to the contact. (Y)es, solicitor is assigned, (N)o, solicitor is not assigned.	VARCHAR2(1)	AFRCTYP	DECODE (AFRCTYP_PIDM, NULL, 'N', 'Y')	NO	NO