Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
ENTITY_UID
|
Entity UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
|
AMBPROP
|
AMBPROP_PIDM
|
ID
|
ID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
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
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
PROPOSAL
|
Proposal
|
Proposal code associated to the prospect.
|
VARCHAR2(63)
|
|
AMBPROP
|
AMBPROP_PROP_CODE
|
PROPOSAL_ACTIVE_IND
|
Proposal Active Indicator
|
Indicates whether the proposal is active.
|
VARCHAR2(1)
|
|
ATVPRST
|
ATVPRST_ACTIVE_IND
|
PROPOSAL_ACTIVITY_DATE
|
Proposal Activity Date
|
Date the record was inserted or last modified.
|
DATE
|
|
AMRPROP
|
AMRPROP_ACTIVITY_DATE
|
PROPOSAL_ASK_AMOUNT
|
Proposal Ask Amount
|
Ask amount for the proposal for this prospect.
|
NUMBER
|
|
AMRPROP
|
AMRPROP_TARGET_ASK_AMOUNT
|
PROPOSAL_COMMENT
|
Proposal Comment
|
Free format column for entry of proposal comments.
|
CLOB
|
|
AMBPROP
|
AMBPROP_COMMENT
|
PROPOSAL_DESC
|
Proposal Description
|
Prospect's proposal code description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROPOSAL_DUE_DATE
|
Proposal Due Date
|
Due date of the proposal.
|
DATE
|
|
AMBPROP
|
AMBPROP_DUE_DATE
|
PROPOSAL_PROJECT
|
Proposal Project
|
Project code associated to the proposal.
|
VARCHAR2(63)
|
|
AMRPROP
|
AMRPROP_PROJ_CODE
|
PROPOSAL_PROJECT_DESC
|
Proposal Project Description
|
Proposal project code description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROPOSAL_PROJ_EFF_FROM_DATE
|
Proposal Proj Eff From Date
|
Begin date that project 1 is effective.
|
DATE
|
|
AMRPROP
|
AMRPROP_PROJ_EFF_FROM_DATE
|
PROPOSAL_PROJ_EFF_TO_DATE
|
Proposal Proj Eff To Date
|
End date that project 1 is effective.
|
DATE
|
|
AMRPROP
|
AMRPROP_PROJ_EFF_TO_DATE
|
PROPOSAL_PROJ_GIVH
|
Proposal Proj Givh
|
Giving vehicle code for the proposal/project 1.
|
VARCHAR2(63)
|
|
AMRPROP
|
AMRPROP_GIVH_CODE
|
PROPOSAL_PROJ_GIVH_DESC
|
Proposal Proj Givh Description
|
Proposal/project 1 giving vehicle code description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROPOSAL_SEQUENCE_NUMBER
|
Proposal Sequence Number
|
Prospect proposal code sequence number.
|
NUMBER
|
|
AMRPROP
|
AMRPROP_PROP_SEQ_NO
|
PROPOSAL_STAFF_IDEN
|
Proposal Staff ID
|
Identification code of the staff.
|
VARCHAR2(63)
|
|
AMBPROP
|
AMBPROP_STAFF_IDEN_CODE
|
PROPOSAL_STAFF_IDEN_NAME
|
Proposal Staff ID Name
|
Current name of proposal staff identification code.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
PROPOSAL_STATUS
|
Proposal Status
|
Status code of the proposal for the prospect.
|
VARCHAR2(63)
|
|
AMBPROP
|
AMBPROP_PRST_CODE
|
PROPOSAL_STATUS_DATE
|
Proposal Status Date
|
Date of the proposal status for the prospect.
|
DATE
|
|
AMBPROP
|
AMBPROP_PRST_DATE
|
PROPOSAL_STATUS_DESC
|
Proposal Status Description
|
Status code description associated with the proposal.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|