Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(63)	GOREMAL	GOREMAL_EMAL_CODE	NO	NO
EMAIL_TYPE_DESC	Email address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ENRL_PLANNING_SERVICE	Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research.	VARCHAR2(63)	FUNCTION	F_EPSCCODE	NO	NO
ENRL_PLANNING_SERVICE_DESC	Enrollment planning service description.	VARCHAR2(255)	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(63)	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(63)	SPRIDEN	SPRIDEN_CREATE_USER	NO	NO
ENTITY_ORIGIN	Source process or system that created or updated this record.	VARCHAR2(63)	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(63)	SPRIDEN	SPRIDEN_USER	NO	NO
FEDERAL_REPORTING_CODE	Government determined code for the reporting state/province codes.	VARCHAR2(5)	STVSTAT	STVSTAT_IPEDS_CDE	NO	NO
GEOGRAPHIC_REGION_COUNT	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS	NO	NO
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(63)	NA	NA	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
ID2	A second identification number assigned to the organization.	VARCHAR2(63)	NA	NA	NO	NO
ID3	A third identification number assigned to the organization.	VARCHAR2(63)	NA	NA	NO	NO
ID_SOURCE	Name of the source system that provided the value in the ID_NUMBER field.	VARCHAR2(63)	NA	NA	NO	NO
MAILING_NAME_ORGANIZATION	Mailing name of the organization.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the organization.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	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(2)	STVNATN	STVNATN_EDI_EQUIV	NO	NO
NATION_ISO_CODE	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO	NO	NO
PHONE_COUNT	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
PHONE_DESC	Telephone number type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PHONE_NUMBER_COMBINED	All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.	VARCHAR2(63)	CALCULATION	SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT	NO	NO
PHONE_TYPE	Telephone type code associated with the organization's preferred telephone number.	VARCHAR2(63)	SPRTELE	SPRTELE_TELE_CODE	NO	NO
PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND	NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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(2)	NA	NA	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
TAX_ID	Organization's identification assigned by their federal government for tax purposes.	VARCHAR2(63)	NA SPBPERS	NA SPBPERS_SSN	NO NO	NO

Ver: 9.2