Reporting View Target: ADVANCEMENT_ADDRESS_SLOT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ADVANCEMENT_ADDRESS_SLOT_KSU

Description Uses data from the ADDRESS and TELEPHONE reporting view. Displays up to 6 sets of values based on the defined display rule(s) with an internal group of ADDRSLOT and ADDRAUXSLOT and an institution defined internal code. After records are inserted, program sweeps thru PERSON, CONSTITUENT_ENTITY and ORGANIZATION_ENTITY and adds a blank record for any record found that does not have a corresponding slot for each slot rule. This prevents entities from falling off reports because they don't have an active address.
Key & Frequency One row per entity per profile code per address rule
Recommended Search Columns ENTITY_UID, PROFILE_CODE, ADDRESS_RULE

Target Column Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Date record was last updated in the ODS. DATE
NA

SYSDATE

ADDL_PHONE_NOADDR_1 Additional active phone for this address type not hooked to the address listed. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

ADDL_PHONE_NOADDR_2 Additional active phone for this address type not hooked to the address listed. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

ADDL_PHONE_NOADDR_3 Additional active phone for this address type not hooked to the address listed. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

ADDL_PHONE_NOADDR_4 Additional active phone for this address type not hooked to the address listed. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

ADDL_PHONE_NOADDR_5 Additional active phone for this address type not hooked to the address listed. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

ADDL_PHONE_NOADDR_6 Additional active phone for this address type not hooked to the address listed. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

ADDL_PHONE_NOADDR_PRIM_IND_1 Primary indicator to denote primary telephone number of additional phone number. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

ADDL_PHONE_NOADDR_PRIM_IND_2 Primary indicator to denote primary telephone number of additional phone number. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

ADDL_PHONE_NOADDR_PRIM_IND_3 Primary indicator to denote primary telephone number of additional phone number. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

ADDL_PHONE_NOADDR_PRIM_IND_4 Primary indicator to denote primary telephone number of additional phone number. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

ADDL_PHONE_NOADDR_PRIM_IND_5 Primary indicator to denote primary telephone number of additional phone number. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

ADDL_PHONE_NOADDR_PRIM_IND_6 Primary indicator to denote primary telephone number of additional phone number. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

ADDRESS_END_DATE_1 Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_END_DATE_2 Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_END_DATE_3 Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_END_DATE_4 Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_END_DATE_5 Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_END_DATE_6 Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_SEQ_NO_1 Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_SEQ_NO_2 Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_SEQ_NO_3 Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_SEQ_NO_4 Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_SEQ_NO_5 Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_SEQ_NO_6 Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_SOURCE_1 The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(63)
SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_2 The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(63)
SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_3 The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(63)
SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_4 The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(63)
SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_5 The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(63)
SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_6 The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(63)
SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_DESC_1 Description of the address source. VARCHAR2(63)
STVASRC

STVASRC_DESC

ADDRESS_SOURCE_DESC_2 Description of the address source. VARCHAR2(63)
STVASRC

STVASRC_DESC

ADDRESS_SOURCE_DESC_3 Description of the address source. VARCHAR2(63)
STVASRC

STVASRC_DESC

ADDRESS_SOURCE_DESC_4 Description of the address source. VARCHAR2(63)
STVASRC

STVASRC_DESC

ADDRESS_SOURCE_DESC_5 Description of the address source. VARCHAR2(63)
STVASRC

STVASRC_DESC

ADDRESS_SOURCE_DESC_6 Description of the address source. VARCHAR2(63)
STVASRC

STVASRC_DESC

ADDRESS_START_DATE_1 Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

ADDRESS_START_DATE_2 Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

ADDRESS_START_DATE_3 Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

ADDRESS_START_DATE_4 Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

ADDRESS_START_DATE_5 Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

ADDRESS_START_DATE_6 Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

ADDRESS_TYPE_1 Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_2 Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_3 Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_4 Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_5 Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_6 Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_DESC_1 Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADDRESS_TYPE_DESC_2 Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADDRESS_TYPE_DESC_3 Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADDRESS_TYPE_DESC_4 Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADDRESS_TYPE_DESC_5 Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADDRESS_TYPE_DESC_6 Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADDR_RULE Institution profile defined display rule determines which address displays for this person or entity. VARCHAR2(63)
MGRSDAX

MGRSDAX_INTERNAL_CODE

AUXILLARY2_PHONE Auxillary active phone for this address type as defined in MGRSDAX ADDRAUXSLOT - 1 VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

AUXILLARY2_PHONE_PRIMARY_IND Primary indicator to denote primary telephone number of auxillary phone number 2. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

AUXILLARY2_PHONE_TYPE Primary indicator to denote primary telephone number of auxillary phone number 2. VARCHAR2(63)
SPRTELE

SPRTELE_ATYP_CODE

AUXILLARY_PHONE Auxillary active phone for this address type as defined in MGRSDAX ADDRAUXSLOT - 2 VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

AUXILLARY_PHONE_PRIMARY_IND Primary indicator to denote primary telephone number of auxillary phone number 1. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

AUXILLARY_PHONE_TYPE Auxillary active phone type for this address type as defined in MGRSDAX ADDRAUXSLOT - 1 VARCHAR2(63)
SPRTELE

SPRTELE_ATYP_CODE

CITY_1 Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CITY_2 Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CITY_3 Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CITY_4 Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CITY_5 Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CITY_6 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_1 County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_CODE_2 County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_CODE_3 County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_CODE_4 County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_CODE_5 County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_CODE_6 County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC_1 County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

COUNTY_DESC_2 County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

COUNTY_DESC_3 County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

COUNTY_DESC_4 County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

COUNTY_DESC_5 County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

COUNTY_DESC_6 County name for the address. VARCHAR2(255)
STVCNTY

STVCNTY_DESC

ENTITY_IND Indicates whether the entity is a person or an organization. VARCHAR2(1)
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_1 Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_2 Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_3 Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_4 Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_5 Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_6 Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_DESC_1 Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

NATION_DESC_2 Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

NATION_DESC_3 Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

NATION_DESC_4 Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

NATION_DESC_5 Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

NATION_DESC_6 Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

PHONE_FORMAT_1 Telephone number combined in a single field formatted (999) 999-9999. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_FORMAT_2 Telephone number combined in a single field formatted (999) 999-9999. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_FORMAT_3 Telephone number combined in a single field formatted (999) 999-9999. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_FORMAT_4 Telephone number combined in a single field formatted (999) 999-9999. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_FORMAT_5 Telephone number combined in a single field formatted (999) 999-9999. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_FORMAT_6 Telephone number combined in a single field formatted (999) 999-9999. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_PRIMARY_IND_1 Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

PHONE_PRIMARY_IND_2 Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

PHONE_PRIMARY_IND_3 Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

PHONE_PRIMARY_IND_4 Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

PHONE_PRIMARY_IND_5 Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

PHONE_PRIMARY_IND_6 Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

POSTAL_CODE_FORMAT_1 Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

POSTAL_CODE_FORMAT_2 Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

POSTAL_CODE_FORMAT_3 Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

POSTAL_CODE_FORMAT_4 Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

POSTAL_CODE_FORMAT_5 Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

POSTAL_CODE_FORMAT_6 Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

PREFERRED_ADDRESS_IND_1 Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)
FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

PREFERRED_ADDRESS_IND_2 Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)
FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

PREFERRED_ADDRESS_IND_3 Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)
FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

PREFERRED_ADDRESS_IND_4 Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)
FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

PREFERRED_ADDRESS_IND_5 Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)
FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

PREFERRED_ADDRESS_IND_6 Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)
FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

PROFILE_CODE This BUSINESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria. VARCHAR2(63)
MGRSDAX

MGRSDAX_PROFILE_CODE

STATE_PROVINCE_1 State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_2 State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_3 State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_4 State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_5 State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_6 State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC_1 State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STATE_PROVINCE_DESC_2 State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STATE_PROVINCE_DESC_3 State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STATE_PROVINCE_DESC_4 State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STATE_PROVINCE_DESC_5 State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STATE_PROVINCE_DESC_6 State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STREET_LINE1_1 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE1_2 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE1_3 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE1_4 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE1_5 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE1_6 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2_1 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE2_2 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE2_3 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE2_4 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE2_5 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE2_6 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3_1 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE3_2 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE3_3 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE3_4 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE3_5 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE3_6 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4_1 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

STREET_LINE4_2 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

STREET_LINE4_3 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

STREET_LINE4_4 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

STREET_LINE4_5 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

STREET_LINE4_6 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

Description	Uses data from the ADDRESS and TELEPHONE reporting view. Displays up to 6 sets of values based on the defined display rule(s) with an internal group of ADDRSLOT and ADDRAUXSLOT and an institution defined internal code. After records are inserted, program sweeps thru PERSON, CONSTITUENT_ENTITY and ORGANIZATION_ENTITY and adds a blank record for any record found that does not have a corresponding slot for each slot rule. This prevents entities from falling off reports because they don't have an active address.
Key & Frequency	One row per entity per profile code per address rule
Recommended Search Columns	ENTITY_UID, PROFILE_CODE, ADDRESS_RULE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was last updated in the ODS.	DATE	NA	SYSDATE
ADDL_PHONE_NOADDR_1	Additional active phone for this address type not hooked to the address listed.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
ADDL_PHONE_NOADDR_2	Additional active phone for this address type not hooked to the address listed.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
ADDL_PHONE_NOADDR_3	Additional active phone for this address type not hooked to the address listed.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
ADDL_PHONE_NOADDR_4	Additional active phone for this address type not hooked to the address listed.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
ADDL_PHONE_NOADDR_5	Additional active phone for this address type not hooked to the address listed.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
ADDL_PHONE_NOADDR_6	Additional active phone for this address type not hooked to the address listed.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
ADDL_PHONE_NOADDR_PRIM_IND_1	Primary indicator to denote primary telephone number of additional phone number.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
ADDL_PHONE_NOADDR_PRIM_IND_2	Primary indicator to denote primary telephone number of additional phone number.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
ADDL_PHONE_NOADDR_PRIM_IND_3	Primary indicator to denote primary telephone number of additional phone number.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
ADDL_PHONE_NOADDR_PRIM_IND_4	Primary indicator to denote primary telephone number of additional phone number.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
ADDL_PHONE_NOADDR_PRIM_IND_5	Primary indicator to denote primary telephone number of additional phone number.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
ADDL_PHONE_NOADDR_PRIM_IND_6	Primary indicator to denote primary telephone number of additional phone number.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
ADDRESS_END_DATE_1	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_END_DATE_2	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_END_DATE_3	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_END_DATE_4	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_END_DATE_5	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_END_DATE_6	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_SEQ_NO_1	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SEQ_NO_2	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SEQ_NO_3	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SEQ_NO_4	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SEQ_NO_5	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SEQ_NO_6	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SOURCE_1	The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_2	The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_3	The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_4	The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_5	The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_6	The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_DESC_1	Description of the address source.	VARCHAR2(63)	STVASRC	STVASRC_DESC
ADDRESS_SOURCE_DESC_2	Description of the address source.	VARCHAR2(63)	STVASRC	STVASRC_DESC
ADDRESS_SOURCE_DESC_3	Description of the address source.	VARCHAR2(63)	STVASRC	STVASRC_DESC
ADDRESS_SOURCE_DESC_4	Description of the address source.	VARCHAR2(63)	STVASRC	STVASRC_DESC
ADDRESS_SOURCE_DESC_5	Description of the address source.	VARCHAR2(63)	STVASRC	STVASRC_DESC
ADDRESS_SOURCE_DESC_6	Description of the address source.	VARCHAR2(63)	STVASRC	STVASRC_DESC
ADDRESS_START_DATE_1	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_START_DATE_2	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_START_DATE_3	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_START_DATE_4	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_START_DATE_5	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_START_DATE_6	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_TYPE_1	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_2	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_3	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_4	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_5	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_6	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_DESC_1	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADDRESS_TYPE_DESC_2	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADDRESS_TYPE_DESC_3	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADDRESS_TYPE_DESC_4	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADDRESS_TYPE_DESC_5	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADDRESS_TYPE_DESC_6	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADDR_RULE	Institution profile defined display rule determines which address displays for this person or entity.	VARCHAR2(63)	MGRSDAX	MGRSDAX_INTERNAL_CODE
AUXILLARY2_PHONE	Auxillary active phone for this address type as defined in MGRSDAX ADDRAUXSLOT - 1	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
AUXILLARY2_PHONE_PRIMARY_IND	Primary indicator to denote primary telephone number of auxillary phone number 2.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
AUXILLARY2_PHONE_TYPE	Primary indicator to denote primary telephone number of auxillary phone number 2.	VARCHAR2(63)	SPRTELE	SPRTELE_ATYP_CODE
AUXILLARY_PHONE	Auxillary active phone for this address type as defined in MGRSDAX ADDRAUXSLOT - 2	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
AUXILLARY_PHONE_PRIMARY_IND	Primary indicator to denote primary telephone number of auxillary phone number 1.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
AUXILLARY_PHONE_TYPE	Auxillary active phone type for this address type as defined in MGRSDAX ADDRAUXSLOT - 1	VARCHAR2(63)	SPRTELE	SPRTELE_ATYP_CODE
CITY_1	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CITY_2	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CITY_3	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CITY_4	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CITY_5	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CITY_6	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_1	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_CODE_2	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_CODE_3	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_CODE_4	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_CODE_5	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_CODE_6	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC_1	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
COUNTY_DESC_2	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
COUNTY_DESC_3	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
COUNTY_DESC_4	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
COUNTY_DESC_5	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
COUNTY_DESC_6	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	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_1	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_2	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_3	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_4	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_5	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_6	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC_1	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_DESC_2	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_DESC_3	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_DESC_4	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_DESC_5	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_DESC_6	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PHONE_FORMAT_1	Telephone number combined in a single field formatted (999) 999-9999.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_FORMAT_2	Telephone number combined in a single field formatted (999) 999-9999.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_FORMAT_3	Telephone number combined in a single field formatted (999) 999-9999.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_FORMAT_4	Telephone number combined in a single field formatted (999) 999-9999.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_FORMAT_5	Telephone number combined in a single field formatted (999) 999-9999.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_FORMAT_6	Telephone number combined in a single field formatted (999) 999-9999.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_PRIMARY_IND_1	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
PHONE_PRIMARY_IND_2	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
PHONE_PRIMARY_IND_3	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
PHONE_PRIMARY_IND_4	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
PHONE_PRIMARY_IND_5	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
PHONE_PRIMARY_IND_6	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
POSTAL_CODE_FORMAT_1	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
POSTAL_CODE_FORMAT_2	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
POSTAL_CODE_FORMAT_3	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
POSTAL_CODE_FORMAT_4	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
POSTAL_CODE_FORMAT_5	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
POSTAL_CODE_FORMAT_6	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PREFERRED_ADDRESS_IND_1	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PREFERRED_ADDRESS_IND_2	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PREFERRED_ADDRESS_IND_3	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PREFERRED_ADDRESS_IND_4	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PREFERRED_ADDRESS_IND_5	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PREFERRED_ADDRESS_IND_6	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PROFILE_CODE	This BUSINESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_PROFILE_CODE
STATE_PROVINCE_1	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_2	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_3	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_4	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_5	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_6	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC_1	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STATE_PROVINCE_DESC_2	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STATE_PROVINCE_DESC_3	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STATE_PROVINCE_DESC_4	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STATE_PROVINCE_DESC_5	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STATE_PROVINCE_DESC_6	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1_1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE1_2	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE1_3	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE1_4	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE1_5	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE1_6	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2_1	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE2_2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE2_3	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE2_4	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE2_5	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE2_6	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3_1	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE3_2	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE3_3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE3_4	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE3_5	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE3_6	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4_1	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
STREET_LINE4_2	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
STREET_LINE4_3	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
STREET_LINE4_4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
STREET_LINE4_5	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
STREET_LINE4_6	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