Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACTIVE_PROSPECT_STRATEGY_IND
|
Active Prospect Strategy Indicator
|
Indicates whether the strategy plan is active based upon its status and if the system date is between the start and end date of the strategy plan.
|
CHAR(1)
|
|
CALCULATION
|
CASE WHEN STRATEGY_PLAN_STATUS_IND
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
ASKING_AMOUNT
|
Asking Amount
|
Asking amount for the contact/project.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ASK_AMT
|
ASK_AMOUNT2
|
Ask Amount 2
|
Second asking amount for the contact/project.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ASK_AMT_2
|
ASK_AMOUNT3
|
Ask Amount 3
|
Third asking amount for the contact/project.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ASK_AMT_3
|
ASK_AMOUNT4
|
Ask Amount 4
|
Fourth asking amount for the contact/project.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ASK_AMT_4
|
CALL_REPORT_COMMENT
|
Call Report Comment
|
Call report used to elaborate on the contact explanation.
|
CLOB
|
|
AMRCONT
|
AMRCONT_CALL_REPORT
|
CONTACT_COMMENT
|
Contact Comment
|
Comment recorded for the contact made.
|
VARCHAR2(2000)
|
|
AMRCONT
|
AMRCONT_CONTACT
|
CONTACT_CREATE_DATE
|
Contact Create Date
|
Date the contact was added.
|
DATE
|
|
AMRCONT
|
AMRCONT_CREATE_DATE
|
CONTACT_DATE
|
Contact Date
|
Date the contact was made.
|
DATE
|
|
AMRCONT
|
AMRCONT_CONTACT_DATE
|
CONTACT_DATE_FISCAL_YEAR
|
Contact Date Fiscal Year
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
|
ATVFISC
|
ATVFISC_CODE
|
CONTACT_DATE_FISCAL_YEAR_DESC
|
Contact Date Fiscal Year Description
|
Fiscal year description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CONTACT_TYPE
|
Contact Type
|
Type of contact between the institution and person.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_SCNT_CODE
|
CONTACT_TYPE_DESC
|
Contact Type Description
|
Contact type description.
|
VARCHAR2(255)
|
|
ATVSCNT
|
ATVSCNT_DESC
|
CREATE_TICKLER_IND
|
Create Tickler Indicator
|
Determines if a follow-up action message is to be created. (Y)es it will be created, (N)o, it does not need to be created.
|
VARCHAR2(1)
|
|
AMRCONT
|
AMRCONT_CREATE_TICKLER
|
FOLLOWUP_ASSIGNEE_UID
|
Followup Assignee UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
|
GOBEACC
|
GOBEACC_PIDM
|
ITEM_REF_NUMBER
|
Item Ref Number
|
Internal generated number for each contact.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ITEM_REFNO
|
MESSAGES_SENT_COUNT
|
Messages Sent Count
|
Number of messages sent for the contact.
|
NUMBER
|
|
GURTKLR
|
GURTKLR_PIDM
|
MOVE
|
Move
|
Move code associated with a plan or associated with a contact that is not plan related.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_MOVE_CODE
|
MOVE_DESC
|
Move Description
|
Move code description.
|
VARCHAR2(255)
|
|
ATVMOVE
|
ATVMOVE_DESC
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
PERSON_COMPLETED_IDEN
|
Person Completed ID
|
Identification code assigned to contact.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_IDEN_CODE_ASGN
|
PERSON_COMPLETED_IDEN_NAME
|
Person Completed ID Name
|
Staff member name responsible for the follow-up action.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
PERSON_RESPONSIBLE_IDEN
|
Person Responsible ID
|
Staff identification code of the person responsible for originating and carrying out the contact.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_IDEN_CODE
|
PERSON_RESPONSIBLE_IDEN_NAME
|
Person Responsible ID Name
|
Name of the person assigned to make the contact.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
PERSON_RESPONSIBLE_UID
|
Person Responsible UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
|
SPRIDEN
|
SPRIDEN_PIDM
|
PERSON_UID
|
Person UID
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_PIDM
|
PLAN_MOVE_SEQUENCE_NUMBER
|
Plan Move Sequence Number
|
When populated, move sequence number determines that the move is complete because a plan is associated to the move.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_MOVE_SEQ_NO
|
PRIMARY_STAFF_IDEN
|
Primary Staff ID
|
Staff identification code of the person with primary responsibility for the prospect.
|
VARCHAR2(63)
|
|
AMRSTAF
|
AMRSTAF_IDEN_CODE
|
PRIMARY_STAFF_IDEN_NAME
|
Primary Staff ID Name
|
Name of the person with primary responsibility for this prospect.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
PRIMARY_STAFF_UID
|
Primary Staff UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
|
GOBEACC
|
GOBEACC_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
PROJECT
|
Project
|
Project/interest code.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_PROJ_CODE
|
PROJECT2
|
Project 2
|
Second project or interest area.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_PROJ_CODE_2
|
PROJECT3
|
Project 3
|
Third project or interest area.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_PROJ_CODE_3
|
PROJECT4
|
Project 4
|
Fourth project or interest area.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_PROJ_CODE_3
|
PROJECT_DESC
|
Project Description
|
Project/interest description.
|
VARCHAR2(255)
|
|
ATVPROJ
|
ATVPROJ_DESC
|
PROJECT_DESC2
|
Project Description 2
|
Second project or interest area description.
|
VARCHAR2(255)
|
|
ATVPROJ
|
ATVPROJ_DESC
|
PROJECT_DESC3
|
Project Description 3
|
Third project or interest area description.
|
VARCHAR2(255)
|
|
ATVPROJ
|
ATVPROJ_DESC
|
PROJECT_DESC4
|
Project Description 4
|
Fourth project or interest area description.
|
VARCHAR2(255)
|
|
ATVPROJ
|
ATVPROJ_DESC
|
PROPOSAL
|
Proposal
|
Proposal code associated to the prospect.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_PROP_CODE
|
PROPOSAL_SEQUENCE_NUMBER
|
Proposal Sequence Number
|
Proposal code sequence number.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_PROP_SEQ_NO
|
PROSPECT_CONTACT_ACTIVITY_DATE
|
Prospect Contact Activity Date
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
|
AMRCONT
|
AMRCONT_ACTIVITY_DATE
|
PROSPECT_CONTACT_IND
|
Prospect Contact Indicator
|
Identifies the constituent for the contact as a prospect (Y)es or a general constituent contact (N)o.
|
VARCHAR2(1)
|
|
CALCULATION
|
CASE(AMRCONT_GEN_CONTACT_IND)
|
PROSPECT_CONTACT_USER_ID
|
Prospect Contact User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_USER_ID
|
RECENT_TICKLER_STATUS
|
Recent Tickler Status
|
Determines the most recent follow-up action tickler status. Follow-up action is (C)omplete, Follow-up action has not yet occurred, (P)ending, Follow-up action is no longer pending, although it is still planned and on (H)old.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_TICK_STATUS
|
RECENT_TICKLER_STATUS_DESC
|
Recent Tickler Status Description
|
Recent tickler status description.
|
VARCHAR2(255)
|
|
MGT_VALIDATION
|
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TICKLER_STATUS' AND VALUE = RECENT_TICKLER_STATUS
|
STAFF_ASSIGNED_COUNT
|
Staff Assigned Count
|
Count of staff assigned.
|
NUMBER
|
|
FUNCTION
|
MAKFUNC.F_COUNT_STAFF_ASSIGNMENT
|
START_DATE_FISCAL_YEAR
|
Start Date Fiscal Year
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
|
ATVFISC
|
ATVFISC_CODE
|
START_DATE_FISCAL_YEAR_DESC
|
Start Date Fiscal Year Description
|
Fiscal year description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
STRATEGY_PLAN
|
Strategy Plan
|
Strategy plan name.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_STGY_PLAN
|
STRATEGY_PLAN_END_DATE
|
Strategy Plan End Date
|
Strategy plan end date.
|
DATE
|
|
CALCULATION
|
NVL(AMBPLAN_END_DATE,'31-DEC-2099')
|
STRATEGY_PLAN_SEQUENCE_NUMBER
|
Strategy Plan Sequence Number
|
Internal sequence number allowing multiple strategies for the strategy plan.
|
NUMBER
|
|
AMBPLAN
|
AMBPLAN_PLAN_SEQ_NO
|
STRATEGY_PLAN_START_DATE
|
Strategy Plan Start Date
|
Strategy plan start date.
|
DATE
|
|
AMBPLAN
|
AMBPLAN_START_DATE
|
STRATEGY_PLAN_STATUS_IND
|
Strategy Plan Status Indicator
|
Indicates whether the strategy plan is (1) active or (0) inactive.
|
VARCHAR2(1)
|
|
AMBPLAN
|
AMBPLAN_ACTIVE_IND
|
STRATEGY_PLAN_STATUS_IND_DESC
|
Strategy Plan Status Indicator Description
|
Strategy plan status description.
|
VARCHAR2(255)
|
|
AMBPLAN
|
AMBPLAN_STATUS_IND
|
TICKLER_CONFIDENTIAL_IND
|
Tickler Confidential Indicator
|
Determines if the follow-up message is to remain confidential. (Y)es confidential, (N)ot confidential.
|
VARCHAR2(1)
|
|
CALCULATION
|
NVL(AMRCONT_CONFID_IND)
|
TICKLER_DATE
|
Tickler Date
|
Tickler message date.
|
DATE
|
|
AMRCONT
|
AMRCONT_TICK_DATE
|
TICKLER_MESSAGE
|
Tickler Message
|
Tickler message.
|
VARCHAR2(255)
|
|
AMRCONT
|
AMRCONT_TICKLER
|
TOTAL_EXPENSE
|
Total Expense
|
Total of all expenses for the contact.
|
NUMBER
|
|
FUNCTION
|
SUM(NVL(AMRPEXP_EXPN_AMT, 0))
|
TOTAL_STAFF_COUNT
|
Total Staff Count
|
Total number of staff attending the contact visit.
|
NUMBER
|
|
CALCULATION
|
COUNT(AMRATTN_PIDM)
|