Reporting View Source: SPRADDR

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SPRADDR Student Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPRADDR_CNTY_CODE	APAIDEN	REPORTING VIEW	PLEDGE_ASSOCIATED_ENTITY	ASSOCIATED_COUNTY
SPRADDR_NATN_CODE	APAIDEN	REPORTING VIEW	PLEDGE_ASSOCIATED_ENTITY	ASSOCIATED_NATION
SPRADDR_ASRC_CODE	SPAIDEN	REPORTING VIEW	ADDRESS	ADDRESS_SOURCE	NA
SPRADDR_ATYP_CODE	SPAIDEN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED ORGANIZATION_ENTITY	ADDRESS_TYPE ADDRESS_TYPE_1 ADDRESS_TYPE_2 ADDRESS_TYPE ADDRESS_TYPE ADDRESS_TYPE ADDRESS_TYPE ADDRESS_TYPE	NA
SPRADDR_CARRIER_ROUTE	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY PLEDGE_ASSOCIATED_ENTITY INVOICE PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	CARRIER_ROUTE ASSOCIATED_CARRIER_ROUTE ASSOCIATED_CARRIER_ROUTE REMIT_TO_CARRIER_ROUTE ORDER_FROM_CARRIER_ROUTE RETURN_CARRIER_ROUTE ORDER_FROM_CARRIER_ROUTE REMIT_TO_CARRIER_ROUTE CARRIER_ROUTE CARRIER_ROUTE CARRIER_ROUTE CARRIER_ROUTE CARRIER_ROUTE PHONE_NUMBER_COMBINED CARRIER_ROUTE CARRIER_ROUTE CARRIER_ROUTE CARRIER_ROUTE	NA
SPRADDR_CITY	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY PLEDGE_ASSOCIATED_ENTITY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	CITY ASSOCIATED_CITY ASSOCIATED_CITY FUND_FMGR_CITY ORGN_FMGR_CITY FUND_FMGR_CITY ORGN_FMGR_CITY CITY FUND_FMGR_CITY FUND_FMGR_CITY ORGN_FMGR_CITY FUND_FMGR_CITY ORGN_FMGR_CITY CITY ORDER_FROM_CITY RETURN_CITY ORDER_FROM_CITY REMIT_TO_CITY CITY CITY CITY CITY CITY CITY CITY CITY CITY CITY CITY	NA
SPRADDR_CNTY_CODE	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	COUNTY ASSOCIATED_COUNTY COUNTY COUNTY_1 COUNTY_2 FUND_FMGR_COUNTY ORGN_FMGR_COUNTY FUND_FMGR_COUNTY ORGN_FMGR_COUNTY COUNTY FUND_FMGR_COUNTY FUND_FMGR_COUNTY ORGN_FMGR_COUNTY FUND_FMGR_COUNTY ORGN_FMGR_COUNTY COUNTY ORDER_FROM_COUNTY RETURN_COUNTY ORDER_FROM_COUNTY REMIT_TO_COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY	NA
SPRADDR_CORRECTION_DIGIT	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT PLEDGE_ASSOCIATED_ENTITY INVOICE PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	CORRECTION_DIGIT ASSOCIATED_CORRECTION_DIGIT CORRECTION_DIGIT ASSOCIATED_CORRECTION_DIGIT REMIT_TO_CORRECTION_DIGIT ORDER_FROM_CORRECTION_DIGIT RETURN_CORRECTION_DIGIT ORDER_FROM_CORRECTION_DIGIT REMIT_TO_CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT	NA
SPRADDR_DELIVERY_POINT	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT PLEDGE_ASSOCIATED_ENTITY INVOICE PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	DELIVERY_POINT ASSOCIATED_DELIVERY_POINT DELIVERY_POINT ASSOCIATED_DELIVERY_POINT REMIT_TO_DELIVERY_POINT ORDER_FROM_DELIVERY_POINT RETURN_DELIVERY_POINT ORDER_FROM_DELIVERY_POINT REMIT_TO_DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT	NA
SPRADDR_FROM_DATE	SPAIDEN	REPORTING VIEW	ADDRESS	ADDRESS_START_DATE	NA
SPRADDR_GST_TAX_ID	NA	REPORTING VIEW	ADDRESS	ADDRESS_TAX_ID	NA
SPRADDR_NATN_CODE	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	NATION ASSOCIATED_NATION NATION NATION_1 NATION_2 FUND_FMGR_NATION ORGN_FMGR_NATION FUND_FMGR_NATION ORGN_FMGR_NATION NATION FUND_FMGR_NATION FUND_FMGR_NATION ORGN_FMGR_NATION FUND_FMGR_NATION ORGN_FMGR_NATION NATION ORDER_FROM_NATION RETURN_NATION ORDER_FROM_NATION REMIT_TO_NATION NATION NATION NATION NATION NATION NATION NATION NATION NATION NATION NATION	NA
SPRADDR_PIDM	NA	REPORTING VIEW	ADDRESS ADDRESS_PREFERRED	ENTITY_UID ENTITY_UID	NA
SPRADDR_SEQNO	SPAIDEN	REPORTING VIEW	ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED	ADDRESS_NUMBER ADDRESS_NUMBER ADDRESS_SEQ_NUMBER ADDRESS_SEQ_NUMBER	NA
SPRADDR_STATUS_IND	SPAIDEN	REPORTING VIEW	ADDRESS	ADDRESS_STATUS_IND	NA
SPRADDR_STAT_CODE	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT PLEDGE_ASSOCIATED_ENTITY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	STATE_PROVINCE ASSOCIATED_STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE_1 STATE_PROVINCE_2 ASSOCIATED_STATE_PROVINCE FUND_FMGR_STATE_PROVINCE ORGN_FMGR_STATE_PROVINCE FUND_FMGR_STATE_PROVINCE ORGN_FMGR_STATE_PROVINCE STATE_PROVINCE FUND_FMGR_STATE_PROVINCE FUND_FMGR_STATE_PROVINCE ORGN_FMGR_STATE_PROVINCE FUND_FMGR_STATE_PROVINCE ORGN_FMGR_STATE_PROVINCE STATE_PROVINCE ORDER_FROM_STATE_PROVINCE RETURN_STATE_PROVINCE ORDER_FROM_STATE_PROVINCE REMIT_TO_STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE	NA
SPRADDR_STREET_LINE1	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT PLEDGE_ASSOCIATED_ENTITY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	STREET_LINE1 ASSOCIATED_STREET_LINE1 STREET_LINE1 STREET_LINE1_1 STREET_LINE1_2 ASSOCIATED_STREET_LINE1 FUND_FMGR_STREET_LINE1 ORGN_FMGR_STREET_LINE1 FUND_FMGR_STREET_LINE1 ORGN_FMGR_STREET_LINE1 STREET_LINE1 FUND_FMGR_STREET_LINE1 FUND_FMGR_STREET_LINE1 ORGN_FMGR_STREET_LINE1 FUND_FMGR_STREET_LINE1 ORGN_FMGR_STREET_LINE1 STREET_LINE1 ORDER_FROM_STREET_LINE1 RETURN_STREET_LINE1 ORDER_FROM_STREET_LINE1 REMIT_TO_STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1	NA
SPRADDR_STREET_LINE2	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT PLEDGE_ASSOCIATED_ENTITY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	STREET_LINE2 ASSOCIATED_STREET_LINE2 STREET_LINE2 STREET_LINE2_1 STREET_LINE2_2 ASSOCIATED_STREET_LINE2 FUND_FMGR_STREET_LINE2 ORGN_FMGR_STREET_LINE2 FUND_FMGR_STREET_LINE2 ORGN_FMGR_STREET_LINE2 STREET_LINE2 FUND_FMGR_STREET_LINE2 FUND_FMGR_STREET_LINE2 ORGN_FMGR_STREET_LINE2 FUND_FMGR_STREET_LINE2 ORGN_FMGR_STREET_LINE2 STREET_LINE2 ORDER_FROM_STREET_LINE2 RETURN_STREET_LINE2 ORDER_FROM_STREET_LINE2 REMIT_TO_STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2	NA
SPRADDR_STREET_LINE3	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT PLEDGE_ASSOCIATED_ENTITY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED CURRENT_EMPLOYMENT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	STREET_LINE3 ASSOCIATED_STREET_LINE3 STREET_LINE3 STREET_LINE3_1 STREET_LINE3_2 ASSOCIATED_STREET_LINE3 FUND_FMGR_STREET_LINE3 ORGN_FMGR_STREET_LINE3 FUND_FMGR_STREET_LINE3 ORGN_FMGR_STREET_LINE3 STREET_LINE3 FUND_FMGR_STREET_LINE3 FUND_FMGR_STREET_LINE3 ORGN_FMGR_STREET_LINE3 FUND_FMGR_STREET_LINE3 ORGN_FMGR_STREET_LINE3 STREET_LINE3 ORDER_FROM_STREET_LINE3 RETURN_STREET_LINE3 ORDER_FROM_STREET_LINE3 REMIT_TO_STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3	NA
SPRADDR_TO_DATE	SPAIDEN	REPORTING VIEW	ADDRESS	ADDRESS_END_DATE	NA
SPRADDR_ZIP	SPAIDEN	REPORTING VIEW	CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT PLEDGE_ASSOCIATED_ENTITY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_VIEW OPERATING_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY PURCHASE_ORDER RETURNED_ITEM VENDOR VENDOR GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS PERSON PERSON_ADDRESS	POSTAL_CODE ASSOCIATED_POSTAL_CODE POSTAL_CODE POSTAL_CODE_1 POSTAL_CODE_2 ASSOCIATED_POSTAL_CODE FUND_FMGR_POSTAL_CODE ORGN_FMGR_POSTAL_CODE FUND_FMGR_POSTAL_CODE ORGN_FMGR_POSTAL_CODE POSTAL_CODE FUND_FMGR_POSTAL_CODE FUND_FMGR_POSTAL_CODE ORGN_FMGR_POSTAL_CODE FUND_FMGR_POSTAL_CODE ORGN_FMGR_POSTAL_CODE POSTAL_CODE ORDER_FROM_POSTAL_CODE RETURN_POSTAL_CODE ORDER_FROM_POSTAL_CODE REMIT_TO_POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE	NA

Ver: 8.1