Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SPRADDR Student
SGHE Banner Operational Data Store Composite View Source: SPRADDR - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
SPRADDR_CNTY_CODE APAIDEN        
SPRADDR_NATN_CODE APAIDEN        
SPRADDR_ASRC_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_SOURCE

NA
SPRADDR_ATYP_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

ADDRESS_TYPE

ADDRESS_TYPE

NA
SPRADDR_CARRIER_ROUTE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

CARRIER_ROUTE

NA
SPRADDR_CITY SPAIDEN COMPOSITE VIEW

AS_ADDRESS

CITY

NA
SPRADDR_CNTY_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

COUNTY_CODE

COUNTY

NA
SPRADDR_CORRECTION_DIGIT SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

CORRECTION_DIGIT

CORRECTION_DIGIT

NA
SPRADDR_DELIVERY_POINT SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

DELIVERY_POINT

DELIVERY_POINT

NA
SPRADDR_FROM_DATE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_START_DATE

NA
SPRADDR_GST_TAX_ID NA COMPOSITE VIEW

AS_ADDRESS

ADDRESS_TAX_ID

NA
SPRADDR_NATN_CODE SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

NATION

NATION

NA
SPRADDR_PIDM NA COMPOSITE VIEW

AS_ADDRESS

ENTITY_UID

NA
SPRADDR_SEQNO SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_SEQ_NO

NA
SPRADDR_STATUS_IND SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_STATUS_IND

NA
SPRADDR_STAT_CODE SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

STATE_PROVINCE

STATE_PROVINCE

NA
SPRADDR_STREET_LINE1 SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

STREET_LINE1

STREET_LINE1

NA
SPRADDR_STREET_LINE2 SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

STREET_LINE2

STREET_LINE2

NA
SPRADDR_STREET_LINE3 SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

STREET_LINE3

STREET_LINE3

NA
SPRADDR_TO_DATE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_END_DATE

NA
SPRADDR_ZIP SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

POSTAL_CODE

POSTAL_CODE

NA


Ver: 8.0