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
|
|
AMREXRT AMRPRRT
|
AMREXRT_PIDM AMRPRRT_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
|
INTERNAL_IND
|
Internal Indicator
|
Identifies whether the person rating the donor is internal.
|
VARCHAR2(1)
|
|
CONSTANT
|
DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N'
|
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
|
PRIMARY_IND
|
Primary Indicator
|
Indicates which rate code is primary.
|
VARCHAR2(1)
|
|
AMRPRRT
|
AMRPRRT_PRIMARY_IND
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
RATER_ID
|
Rater ID
|
Rater's current identification number.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
RATER_NAME
|
Rater Name
|
Name of the individual doing the advancement rating.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
RATER_UID
|
Rater UID
|
System generated, unique, internal identification number assigned to this rater.
|
VARCHAR2(63)
|
|
CALCULATION
|
DECODE(AMRPRRT_RATING_PIDM,NULL,AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)
|
RATING
|
Rating
|
Rating.
|
VARCHAR2(63)
|
|
AMREXRT AMRPRRT
|
AMREXRT_EXT_VALUE AMRPRRT_RATE_CODE
|
RATING_AMOUNT
|
Rating Amount
|
Targeted or potential 'ask' or dollar amount associated with this rating code.
|
VARCHAR2(63)
|
|
AMREXRT ATVRATE
|
AMREXRT_EXT_SCORE ATVRATE_RATE_AMT
|
RATING_DATE
|
Rating Date
|
Date this record was created or updated.
|
DATE
|
|
AMREXRT AMRPRRT
|
AMREXRT_ACTIVITY_DATE AMRPRRT_ACTIVITY_DATE
|
RATING_DESC
|
Rating Description
|
Rating description.
|
VARCHAR2(255)
|
|
ATVRATE
|
ATVRATE_DESC
|
RATING_LEVEL
|
Rating Level
|
Matching level of external source.
|
VARCHAR2(63)
|
|
AMREXRT
|
AMREXRT_EXT_LEVEL
|
RATING_TYPE
|
Rating Type
|
Rating type.
|
VARCHAR2(63)
|
|
AMREXRT AMRPRRT
|
AMREXRT_EXRS_CODE AMRPRRT_RTGT_CODE
|
RATING_TYPE_DESC
|
Rating Type Description
|
Rating type description.
|
VARCHAR2(255)
|
|
ATVEXRS ATVRTGT
|
ATVEXRS_DESC ATVRTGT_DESC
|
SCREENING
|
Screening
|
Screening method.
|
VARCHAR2(63)
|
|
AMRPRRT
|
AMRPRRT_RSCR_CODE
|
SCREENING_DESC
|
Screening Description
|
Screening method description.
|
VARCHAR2(255)
|
|
ATVRSCR
|
ATVRSCR_DESC
|