| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
CURRENT_DATE
|
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
|
NA
|
SYSDATE
|
|
DOMAIN_VALUE
|
|
The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(6)
|
|
NA
|
NA
|
|
ENTITY_UID
|
|
System generated unique internal identification number assigned to this person or organization entity.
|
NUMBER(8)
|
|
AARMINT
|
AARMINT_PIDM
|
|
INTEREST
|
|
Interest code.
|
VARCHAR2(5)
|
|
AARMINT
|
AARMINT_INTEREST
|
|
INTEREST_APPLIED_AMOUNT
|
|
Membership payment amount.
|
NUMBER(11, 2)
|
|
AARMINT
|
AARMINT_AMOUNT
|
|
INTEREST_COLLEGE
|
|
College code associated with the interest.
|
VARCHAR2(2)
|
|
AABMINT
|
AABMINT_COLL_CODE
|
|
INTEREST_COLLEGE_DESC
|
|
College or school description.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
INTEREST_GROUP
|
|
Group code.
|
VARCHAR2(5)
|
|
AABMINT
|
AABMINT_AMGP_CODE
|
|
INTEREST_GROUP_DESC
|
|
Interest group code description.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
INTEREST_NAME
|
|
Interest description.
|
VARCHAR2(60)
|
|
AABMINT
|
AABMINT_NAME
|
|
INTEREST_TYPE
|
|
Interest type code.
|
VARCHAR2(2)
|
|
AABMINT
|
AABMINT_AMIN_CODE
|
|
INTEREST_TYPE_DESC
|
|
Interest type description.
|
VARCHAR2(30)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MEMBERSHIP_NUMBER
|
|
System-generated number that uniquely identifies a membership.
|
VARCHAR2(7)
|
|
AARMINT
|
AARMINT_MEMB_NO
|
|
MEMBERSHIP_PROGRAM
|
|
Membership code for association.
|
VARCHAR2(5)
|
|
AARMINT
|
AARMINT_MEMBERSHIP
|
|
MEMBERSHIP_TRANSACTION_NUMBER
|
|
System generated unique internal identification number that identifies the transaction number for the ID.
|
VARCHAR2(7)
|
|
AARMINT
|
AARMINT_TRANS_NO
|
|
MIF_DESC
|
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
|
NA
|
NA
|
|
MIF_VALUE
|
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
|
NA
|
NA
|
|
ZONE_VALUE
|
|
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(6)
|
|
NA
|
NA
|