RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SPRADDR Student Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: SPRADDR

Source Column Source Form Target Type Target Target Column Calculation Formula
SPRADDR_ASRC_CODE SPAIDEN

REPORTING VIEW

ADDRESS

ADDRESS_SOURCE

NA
SPRADDR_ATYP_CODE SPAIDEN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ADDRESS_BY_RULE

ORGANIZATION_ENTITY

ORGANIZATION_CONTACT

ADDRESS

ADDRESS_CURRENT

ADDRESS_PREFERRED

ADDRESS_TYPE_1

ADDRESS_TYPE_2

ADDRESS_TYPE

ADDRESS_TYPE

ADDRESS_TYPE

ADDRESS_TYPE

ADDRESS_TYPE

ADDRESS_TYPE

NA
SPRADDR_CARRIER_ROUTE SPAIDEN

REPORTING VIEW

CONSTITUENT_ENTITY

CURRENT_EMPLOYMENT

ADDRESS_BY_RULE

VENDOR

ADDRESS_PREFERRED

ORGANIZATION_ENTITY_ADDRESS

PERSON_ADDRESS

PURCHASE_ORDER

INVOICE

ADDRESS_CURRENT

ORGANIZATION_ENTITY

PERSON

GIFT_ASSOCIATED_ENTITY

ADDRESS

RETURNED_ITEM

VENDOR

CURRENT_EMPLOYMENT

CARRIER_ROUTE

PHONE_NUMBER_COMBINED

CARRIER_ROUTE

ORDER_FROM_CARRIER_ROUTE

CARRIER_ROUTE

CARRIER_ROUTE

CARRIER_ROUTE

ORDER_FROM_CARRIER_ROUTE

REMIT_TO_CARRIER_ROUTE

CARRIER_ROUTE

CARRIER_ROUTE

CARRIER_ROUTE

ASSOCIATED_CARRIER_ROUTE

CARRIER_ROUTE

RETURN_CARRIER_ROUTE

REMIT_TO_CARRIER_ROUTE

CARRIER_ROUTE

NA
SPRADDR_CITY SPAIDEN

REPORTING VIEW

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_VIEW

GENERAL_LEDGER

GRANT_FUND

CURRENT_EMPLOYMENT

FIXED_ASSET_FUNDING_SOURCE

GOVERNMENT_STUDENT

GIFT_ASSOCIATED_ENTITY

RETURNED_ITEM

VENDOR

PURCHASE_ORDER

ADDRESS_BY_RULE

ORGANIZATION_ENTITY

CONSTITUENT_ENTITY

VENDOR

ADDRESS_PREFERRED

OPERATING_LEDGER

OPERATING_LEDGER

GOVERNMENT_ACADEMIC_OUTCOME

ORGANIZATION_ENTITY_ADDRESS

FUND_HIERARCHY

ADDRESS_CURRENT

PERSON_ADDRESS

FIXED_ASSET_ACCOUNTING_SOURCE

ORGANIZATION_HIERARCHY

ADDRESS

PERSON

ORGN_FMGR_CITY

ORGN_FMGR_CITY

ORGN_FMGR_CITY

FUND_FMGR_CITY

FUND_FMGR_CITY

CITY

FUND_FMGR_CITY

CITY

ASSOCIATED_CITY

RETURN_CITY

ORDER_FROM_CITY

ORDER_FROM_CITY

CITY

CITY

CITY

REMIT_TO_CITY

CITY

FUND_FMGR_CITY

ORGN_FMGR_CITY

CITY

CITY

CITY

CITY

CITY

FUND_FMGR_CITY

CITY

CITY

CITY

NA
SPRADDR_CNTY_CODE SPAIDEN

REPORTING VIEW

OPERATING_LEDGER

OPERATING_LEDGER

PERSON

FIXED_ASSET_ACCOUNTING_SOURCE

GRANT_VIEW

GENERAL_LEDGER

GOVERNMENT_ACADEMIC_OUTCOME

ORGANIZATION_ENTITY_ADDRESS

GIFT_ASSOCIATED_ENTITY

VENDOR

FUND_HIERARCHY

GRANT_FUND

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

GOVERNMENT_STUDENT

ADDRESS_BY_RULE

ORGANIZATION_CONTACT_SLOT

CURRENT_EMPLOYMENT

CONSTITUENT_ENTITY

FIXED_ASSET_ACCOUNTING_SOURCE

VENDOR

ADDRESS_CURRENT

ORGANIZATION_ENTITY

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

PURCHASE_ORDER

ADDRESS

PERSON_ADDRESS

RETURNED_ITEM

ORGANIZATION_HIERARCHY

ADDRESS_PREFERRED

FUND_FMGR_COUNTY

ORGN_FMGR_COUNTY

COUNTY

FUND_FMGR_COUNTY

ORGN_FMGR_COUNTY

FUND_FMGR_COUNTY

COUNTY

COUNTY

ASSOCIATED_COUNTY

ORDER_FROM_COUNTY

COUNTY

FUND_FMGR_COUNTY

COUNTY

COUNTY_1

COUNTY

COUNTY

COUNTY_2

COUNTY

COUNTY

ORGN_FMGR_COUNTY

REMIT_TO_COUNTY

COUNTY

COUNTY

FUND_FMGR_COUNTY

ORGN_FMGR_COUNTY

ORDER_FROM_COUNTY

COUNTY

COUNTY

RETURN_COUNTY

COUNTY

COUNTY

NA
SPRADDR_CORRECTION_DIGIT SPAIDEN

REPORTING VIEW

CONSTITUENT_ENTITY

CURRENT_EMPLOYMENT

VENDOR

PURCHASE_ORDER

ADDRESS_BY_RULE

ADDRESS_PREFERRED

ORGANIZATION_ENTITY

GIFT_ASSOCIATED_ENTITY

ORGANIZATION_CONTACT

PERSON

RETURNED_ITEM

ADDRESS

ORGANIZATION_ENTITY_ADDRESS

VENDOR

ADDRESS_CURRENT

INVOICE

PERSON_ADDRESS

CORRECTION_DIGIT

CORRECTION_DIGIT

ORDER_FROM_CORRECTION_DIGIT

ORDER_FROM_CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

ASSOCIATED_CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

RETURN_CORRECTION_DIGIT

CORRECTION_DIGIT

CORRECTION_DIGIT

REMIT_TO_CORRECTION_DIGIT

CORRECTION_DIGIT

REMIT_TO_CORRECTION_DIGIT

CORRECTION_DIGIT

NA
SPRADDR_DELIVERY_POINT SPAIDEN

REPORTING VIEW

PURCHASE_ORDER

PERSON

ORGANIZATION_ENTITY

PERSON_ADDRESS

GIFT_ASSOCIATED_ENTITY

ORGANIZATION_CONTACT

INVOICE

CONSTITUENT_ENTITY

RETURNED_ITEM

ADDRESS_BY_RULE

ADDRESS_CURRENT

VENDOR

VENDOR

ADDRESS

CURRENT_EMPLOYMENT

ADDRESS_PREFERRED

ORGANIZATION_ENTITY_ADDRESS

ORDER_FROM_DELIVERY_POINT

DELIVERY_POINT

DELIVERY_POINT

DELIVERY_POINT

ASSOCIATED_DELIVERY_POINT

DELIVERY_POINT

REMIT_TO_DELIVERY_POINT

DELIVERY_POINT

RETURN_DELIVERY_POINT

DELIVERY_POINT

DELIVERY_POINT

ORDER_FROM_DELIVERY_POINT

REMIT_TO_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

OPERATING_LEDGER

FUND_HIERARCHY

CURRENT_EMPLOYMENT

ADDRESS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_VIEW

VENDOR

FIXED_ASSET_ACCOUNTING_SOURCE

ORGANIZATION_HIERARCHY

VENDOR

GOVERNMENT_ACADEMIC_OUTCOME

ADDRESS_BY_RULE

ORGANIZATION_ENTITY

ORGANIZATION_ENTITY_ADDRESS

ORGANIZATION_CONTACT_SLOT

PURCHASE_ORDER

GIFT_ASSOCIATED_ENTITY

RETURNED_ITEM

GENERAL_LEDGER

GOVERNMENT_STUDENT

ADDRESS_PREFERRED

PERSON

OPERATING_LEDGER

FIXED_ASSET_FUNDING_SOURCE

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

GRANT_FUND

ADDRESS_CURRENT

PERSON_ADDRESS

NATION

ORGN_FMGR_NATION

NATION

NATION

NATION

FUND_FMGR_NATION

FUND_FMGR_NATION

ORGN_FMGR_NATION

REMIT_TO_NATION

ORGN_FMGR_NATION

NATION

ORDER_FROM_NATION

NATION

NATION

NATION

NATION

NATION_2

ORDER_FROM_NATION

ASSOCIATED_NATION

RETURN_NATION

FUND_FMGR_NATION

NATION

NATION

NATION

FUND_FMGR_NATION

ORGN_FMGR_NATION

NATION

NATION_1

FUND_FMGR_NATION

NATION

NATION

NA
SPRADDR_PIDM NA

REPORTING VIEW

ADDRESS

ADDRESS_PREFERRED

ENTITY_UID

ENTITY_UID

NA
SPRADDR_SEQNO SPAIDEN

REPORTING VIEW

ADDRESS_CURRENT

ADDRESS_PREFERRED

ADDRESS_BY_RULE

ADDRESS

ADDRESS_SEQ_NUMBER

ADDRESS_SEQ_NUMBER

ADDRESS_NUMBER

ADDRESS_NUMBER

NA
SPRADDR_STATUS_IND SPAIDEN

REPORTING VIEW

ADDRESS

ADDRESS_STATUS_IND

NA
SPRADDR_STAT_CODE SPAIDEN

REPORTING VIEW

GIFT_ASSOCIATED_ENTITY

GOVERNMENT_ACADEMIC_OUTCOME

ADDRESS

RETURNED_ITEM

OPERATING_LEDGER

CURRENT_EMPLOYMENT

ORGANIZATION_HIERARCHY

PURCHASE_ORDER

ADDRESS_BY_RULE

CONSTITUENT_ENTITY

FIXED_ASSET_ACCOUNTING_SOURCE

VENDOR

GOVERNMENT_STUDENT

ADDRESS_CURRENT

ORGANIZATION_ENTITY

PERSON_ADDRESS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_FUND

ADDRESS_PREFERRED

ORGANIZATION_ENTITY_ADDRESS

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

FUND_HIERARCHY

ORGANIZATION_CONTACT

FIXED_ASSET_FUNDING_SOURCE

OPERATING_LEDGER

VENDOR

GRANT_VIEW

GENERAL_LEDGER

PERSON

ASSOCIATED_STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

RETURN_STATE_PROVINCE

ORGN_FMGR_STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

ORDER_FROM_STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

FUND_FMGR_STATE_PROVINCE

ORDER_FROM_STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

ORGN_FMGR_STATE_PROVINCE

ORGN_FMGR_STATE_PROVINCE

FUND_FMGR_STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE

STATE_PROVINCE_1

STATE_PROVINCE_2

STATE_PROVINCE

STATE_PROVINCE

FUND_FMGR_STATE_PROVINCE

FUND_FMGR_STATE_PROVINCE

REMIT_TO_STATE_PROVINCE

ORGN_FMGR_STATE_PROVINCE

FUND_FMGR_STATE_PROVINCE

STATE_PROVINCE

NA
SPRADDR_STREET_LINE1 SPAIDEN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_ENTITY_ADDRESS

FIXED_ASSET_ACCOUNTING_SOURCE

PURCHASE_ORDER

FUND_HIERARCHY

ADDRESS_BY_RULE

CONSTITUENT_ENTITY

GIFT_ASSOCIATED_ENTITY

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

VENDOR

GENERAL_LEDGER

ADDRESS_CURRENT

FIXED_ASSET_FUNDING_SOURCE

OPERATING_LEDGER

VENDOR

GRANT_VIEW

PERSON_ADDRESS

FIXED_ASSET_FUNDING_SOURCE

GRANT_FUND

ADDRESS

ORGANIZATION_ENTITY

FIXED_ASSET_ACCOUNTING_SOURCE

CURRENT_EMPLOYMENT

ADDRESS_PREFERRED

PERSON

RETURNED_ITEM

STREET_LINE1_2

STREET_LINE1

ORGN_FMGR_STREET_LINE1

ORDER_FROM_STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

ASSOCIATED_STREET_LINE1

STREET_LINE1

STREET_LINE1_1

FUND_FMGR_STREET_LINE1

STREET_LINE1

REMIT_TO_STREET_LINE1

FUND_FMGR_STREET_LINE1

STREET_LINE1

FUND_FMGR_STREET_LINE1

ORGN_FMGR_STREET_LINE1

ORDER_FROM_STREET_LINE1

ORGN_FMGR_STREET_LINE1

STREET_LINE1

ORGN_FMGR_STREET_LINE1

FUND_FMGR_STREET_LINE1

STREET_LINE1

STREET_LINE1

FUND_FMGR_STREET_LINE1

STREET_LINE1

STREET_LINE1

STREET_LINE1

RETURN_STREET_LINE1

NA
SPRADDR_STREET_LINE2 SPAIDEN

REPORTING VIEW

GIFT_ASSOCIATED_ENTITY

FIXED_ASSET_FUNDING_SOURCE

ORGANIZATION_ENTITY

ORGANIZATION_ENTITY_ADDRESS

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

VENDOR

GENERAL_LEDGER

RETURNED_ITEM

GRANT_FUND

ADDRESS_BY_RULE

PERSON_ADDRESS

FIXED_ASSET_FUNDING_SOURCE

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

GRANT_VIEW

ADDRESS

ORGANIZATION_CONTACT_SLOT

PURCHASE_ORDER

VENDOR

FUND_HIERARCHY

PERSON

CONSTITUENT_ENTITY

FIXED_ASSET_ACCOUNTING_SOURCE

ADDRESS_CURRENT

FIXED_ASSET_ACCOUNTING_SOURCE

OPERATING_LEDGER

CURRENT_EMPLOYMENT

ADDRESS_PREFERRED

ASSOCIATED_STREET_LINE2

ORGN_FMGR_STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2_2

REMIT_TO_STREET_LINE2

FUND_FMGR_STREET_LINE2

RETURN_STREET_LINE2

FUND_FMGR_STREET_LINE2

STREET_LINE2

STREET_LINE2

FUND_FMGR_STREET_LINE2

ORGN_FMGR_STREET_LINE2

STREET_LINE2

ORGN_FMGR_STREET_LINE2

STREET_LINE2

STREET_LINE2_1

ORDER_FROM_STREET_LINE2

ORDER_FROM_STREET_LINE2

STREET_LINE2

STREET_LINE2

STREET_LINE2

ORGN_FMGR_STREET_LINE2

STREET_LINE2

FUND_FMGR_STREET_LINE2

FUND_FMGR_STREET_LINE2

STREET_LINE2

STREET_LINE2

NA
SPRADDR_STREET_LINE3 SPAIDEN

REPORTING VIEW

FIXED_ASSET_FUNDING_SOURCE

VENDOR

GENERAL_LEDGER

ADDRESS_CURRENT

ORGANIZATION_ENTITY_ADDRESS

PERSON_ADDRESS

RETURNED_ITEM

CURRENT_EMPLOYMENT

FUND_HIERARCHY

ADDRESS

GRANT_VIEW

ORGANIZATION_ENTITY

ORGANIZATION_CONTACT

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

OPERATING_LEDGER

OPERATING_LEDGER

VENDOR

CONSTITUENT_ENTITY

GIFT_ASSOCIATED_ENTITY

ORGANIZATION_CONTACT_SLOT

FIXED_ASSET_FUNDING_SOURCE

ORGANIZATION_HIERARCHY

GRANT_FUND

ADDRESS_PREFERRED

ORGANIZATION_CONTACT_SLOT

PURCHASE_ORDER

ADDRESS_BY_RULE

PERSON

ORGN_FMGR_STREET_LINE3

REMIT_TO_STREET_LINE3

FUND_FMGR_STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

RETURN_STREET_LINE3

STREET_LINE3

STREET_LINE3

STREET_LINE3

ORGN_FMGR_STREET_LINE3

STREET_LINE3

STREET_LINE3

FUND_FMGR_STREET_LINE3

ORGN_FMGR_STREET_LINE3

FUND_FMGR_STREET_LINE3

ORGN_FMGR_STREET_LINE3

ORDER_FROM_STREET_LINE3

STREET_LINE3

ASSOCIATED_STREET_LINE3

STREET_LINE3_1

FUND_FMGR_STREET_LINE3

STREET_LINE3

FUND_FMGR_STREET_LINE3

STREET_LINE3

STREET_LINE3_2

ORDER_FROM_STREET_LINE3

STREET_LINE3

STREET_LINE3

NA
SPRADDR_TO_DATE SPAIDEN

REPORTING VIEW

ADDRESS

ADDRESS_END_DATE

NA
SPRADDR_ZIP SPAIDEN

REPORTING VIEW

GENERAL_LEDGER

GRANT_FUND

PERSON_ADDRESS

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

FIXED_ASSET_ACCOUNTING_SOURCE

RETURNED_ITEM

ORGANIZATION_HIERARCHY

GOVERNMENT_STUDENT

ADDRESS

ORGANIZATION_ENTITY_ADDRESS

CONSTITUENT_ENTITY

FIXED_ASSET_ACCOUNTING_SOURCE

VENDOR

ORGANIZATION_ENTITY

GIFT_ASSOCIATED_ENTITY

OPERATING_LEDGER

ORGANIZATION_CONTACT

OPERATING_LEDGER

VENDOR

ADDRESS_BY_RULE

GOVERNMENT_ACADEMIC_OUTCOME

ADDRESS_PREFERRED

FIXED_ASSET_FUNDING_SOURCE

GRANT_VIEW

ADDRESS_CURRENT

FIXED_ASSET_FUNDING_SOURCE

PURCHASE_ORDER

FUND_HIERARCHY

PERSON

FUND_FMGR_POSTAL_CODE

FUND_FMGR_POSTAL_CODE

POSTAL_CODE

POSTAL_CODE_1

POSTAL_CODE_2

FUND_FMGR_POSTAL_CODE

RETURN_POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

ORGN_FMGR_POSTAL_CODE

ORDER_FROM_POSTAL_CODE

POSTAL_CODE

ASSOCIATED_POSTAL_CODE

FUND_FMGR_POSTAL_CODE

POSTAL_CODE

ORGN_FMGR_POSTAL_CODE

REMIT_TO_POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

ORGN_FMGR_POSTAL_CODE

ORGN_FMGR_POSTAL_CODE

POSTAL_CODE

FUND_FMGR_POSTAL_CODE

ORDER_FROM_POSTAL_CODE

POSTAL_CODE

POSTAL_CODE

NA


Ver: 3.1