Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_END_DATE	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_START_DATE	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
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
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
COMPANY	Address city, town or municipality.	VARCHAR2(1020)	APREHIS	APREHIS_EMPR_NAME
CONTACT_NAME	When entity_ind = 'O' - Organizational contact name where contact type = 1st otherwise null	VARCHAR2(3062)	AOBORGN	NA
COUNTY_CODE	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(4)	FUNCTION	GOKODSF.F_GET_DESC
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPRIDEN	SPRIDEN_PIDM
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PREFERRED_ADDRESS_IND	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STREET_LINE1	First line of the address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
TITLE	When entity_ind = 'P' - position_title of individual otherwise job_title of contact where contact_type = '1st'	VARCHAR2(1020)	ATVJOBC	ATVJOBC_DESC

Ver: 8.4.1