Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_DESC	Address type description.	VARCHAR2(0)	NA	NA	NO	NO
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(0)	NA	NA	NO	NO
ALTERNATIVE_ID_COUNT	Count of the number of alternative IDs recorded for this person or organization entity.	NUMBER	GORADID	GORADID_ADDITIONAL_ID	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(0)	NA	NA	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(0)	NA	NA	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	NA	NA	NO	NO
COUNTY	County for this address.	VARCHAR2(0)	NA	NA	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(0)	NA	NA	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	NA	NA	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(128)	GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(4)	GOREMAL	GOREMAL_EMAL_CODE	NO	NO
EMAIL_TYPE_DESC	Email address type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ENTITY_ACTIVITY_DATE	Date record was inserted or updated.	DATE	SPRIDEN	SPRIDEN_ACTIVITY_DATE	NO	NO
ENTITY_CREATE_DATA_ORIGIN	Source process or system that created this record.	VARCHAR2(30)	SPRIDEN	SPRIDEN_DATA_ORIGIN	NO	NO
ENTITY_CREATE_DATE	Date that this record was created, either manually or through data load.	DATE	SPRIDEN	SPRIDEN_CREATE_DATE	NO	NO
ENTITY_CREATE_USER	ID of the person who created this record.	VARCHAR2(30)	SPRIDEN	SPRIDEN_CREATE_USER	NO	NO
ENTITY_ORIGIN	Source process or system that created or updated this record.	VARCHAR2(30)	SPRIDEN	SPRIDEN_ORIGIN	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPRIDEN	SPRIDEN_PIDM	NO	NO
ENTITY_UPDATE_USER	User who made the last updated to this record.	VARCHAR2(30)	SPRIDEN	SPRIDEN_USER	NO	NO
EPS_CODE	Enrollment planning service (EPS) marketing code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only).	VARCHAR2(0)	NA	NA	NO	NO
EPS_DESC	Enrollment planning service description.	VARCHAR2(0)	NA	NA	NO	NO
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(0)	NA	NA	NO	NO
ID_NUMBER	Identification number assigned to the organization that is used externally for all communication.	VARCHAR2(9)	SPRIDEN	SPRIDEN_ID	NO	NO
ID_NUMBER2	A second identification number assigned to the organization.	VARCHAR2(0)	NA	NA	NO	NO
ID_NUMBER3	A third identification number assigned to the organization.	VARCHAR2(0)	NA	NA	NO	NO
ID_SOURCE	Name of the source system that provided the value in the ID_NUMBER field.	VARCHAR2(0)	NA	NA	NO	NO
MAILING_NAME_ORGANIZATION	Preferred name of the organization for mailing purposes.	VARCHAR2(60)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
NAME	Name of the organization.	VARCHAR2(60)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(0)	NA	NA	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(0)	NA	NA	NO	NO
NATION_EDI_EQUIVALENT	EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(0)	NA	NA	NO	NO
NATION_SCOD_CODE_ISO	International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(0)	NA	NA	NO	NO
PHONE_DESC	Organization's preferred phone type description.	VARCHAR2(0)	NA	NA	NO	NO
PHONE_NUMBER_COMBINED	Preferred telephone number of the organization.	VARCHAR2(0)	NA	NA	NO	NO
PHONE_TYPE	Telephone type code associated with the organization's preferred telephone number.	VARCHAR2(0)	NA	NA	NO	NO
PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.	VARCHAR2(0)	NA	NA	NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(0)	NA	NA	NO	NO
STATE_EDI_EQUIVALENT	EDI equivalent code used for electronic transfer of state or province information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(0)	NA	NA	NO	NO
STATE_IPEDS_CODE	Identifies the state or province code for federal reporting.	VARCHAR2(0)	NA	NA	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(0)	NA	NA	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(0)	NA	NA	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(0)	NA	NA	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(0)	NA	NA	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(0)	NA	NA	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(0)	NA	NA	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(15)	NA	NA	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: