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_ASRC_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_SOURCE

NA
SPRADDR_ATYP_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AS_ADDRESS

ADDRESS_TYPE

ADDRESS_TYPE

NA
SPRADDR_CARRIER_ROUNT SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CARRIER_ROUTE

 
SPRADDR_CARRIER_ROUTE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AS_ADDRESS

CARRIER_ROUTE

CARRIER_ROUTE

 
SPRADDR_CITY SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

CITY

CITY

CITY

CITY

CITY

CITY

CITY

CITY

NA
SPRADDR_CNTY_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

COUNTY_CODE

COUNTY

COUNTY_CODE

COUNTY

COUNTY_CODE

COUNTY

COUNTY_CODE

COUNTY

 
SPRADDR_CORRECTION_DIGIT SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

 
SPRADDR_COUNTY SPAIDEN        
SPRADDR_DELIVERY_POINT SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

DELIVERY_POINT

DELIVERY_POINT

DELIVERY_POINT

DELIVERY_POINT

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_HOUSE_NUMBER TBD COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

HOUSE_NUMBER

HOUSE_NUMBER

HOUSE_NUMBER

HOUSE_NUMBER

 
SPRADDR_NATN_CODE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

NATION

NATION

NATION

NATION

NATION

NATION

NATION

NATION

NA
SPRADDR_PIDM NA COMPOSITE VIEW

AS_ADDRESS

ENTITY_UID

NA
SPRADDR_SEQNO SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AS_ADDRESS

ADDRESS_SEQ_NO

ADDRESS_SEQ_NO

NA
SPRADDR_STATUS_IND SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

CONTACT_ADDRESS_STATUS_IND

ADDRESS_STATUS_IND

CONTACT_ADDRESS_STATUS_IND

ADDRESS_STATUS_IND

 
SPRADDR_STAT_CODE SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

 
SPRADDR_STREET_LINE1 SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

NA
SPRADDR_STREET_LINE2 FTMFMGR COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

 
SPRADDR_STREET_LINE3 SPAIDEN COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

 
SPRADDR_STREET_LINE4 SPAIDEN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

STREET_LINE4

STREET_LINE4

STREET_LINE4

STREET_LINE4

STREET_LINE4

STREET_LINE4

STREET_LINE4

STREET_LINE4

 
SPRADDR_TO_DATE SPAIDEN COMPOSITE VIEW

AS_ADDRESS

ADDRESS_END_DATE

NA
SPRADDR_ZIP FTMFMGR COMPOSITE VIEW

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

AS_ADDRESS

AA_ORGANIZATION_CONTACT

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

 
STVCNTY_DESC SPAIDEN        
STVSTAT_DESC SPAIDEN        


Ver: