ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
CAMPUS	Campus of the vendor.			NA	NA
CAMPUS_DESC	Vendor campus description.			NA	NA
CONTACT_NAME	Name or title of the primary contact for the vendor.			FTVVEND	FTVVEND_CONTACT
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
ENTITY_TYPE	Indicates whether this is person or entity record.			SPRIDEN	SPRIDEN_ENTITY_IND
FEDERAL_REPORTABLE_TAX_IND	Indicates vendor as reportable for federal tax purposes.			CALCULATION	DECODE(FTVVEND_1099_RPT_ID)
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MOST_RECENT_TAX_ID_NOTICE_YEAR	Year the most recent tax identification number notice was received.			NA	NA
NUMBER_OF_TAX_ID_NOTICES	Number of tax identification number notices the vendor has received.			NA	NA
ORDER_FROM_ADDRESS_NUMBER	Sequence number of the order from address for the vendor.			FTVVEND	FTVVEND_ADDR_SEQNO
ORDER_FROM_ADDRESS_TYPE	Address type of the order from address for the vendor.			FTVVEND	FTVVEND_ATYP_CODE
ORDER_FROM_ADDRESS_TYPE_DESC	Description for the address type of the vendor.			STVATYP	STVATYP_DESC
PHONE_AREA	Phone area code for the vendor.			FTVVEND	FTVVEND_PHONE_AREA
PHONE_EXT	Phone extension for the vendor.			FTVVEND	FTVVEND_PHONE_EXT
PHONE_NUMBER	Phone number for the vendor.			FTVVEND	FTVVEND_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Extracted combined phone number for the vendor.			CALCULATION	FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER||FTVVEND_PHONE_EXT
REMIT_TO_ADDRESS_NUMBER	Sequence number of the address type of the remit to vendor.			FTVVEND	FTVVEND_VEND_CHECK_ADDR_SEQNO
REMIT_TO_ADDRESS_TYPE	Identifies the type of address that the payment for the invoice is to be sent.			FTVVEND	FTVVEND_VEND_CHECK_ATYP_CODE
REMIT_TO_ADDRESS_TYPE_DESC	Description for the address type of the remit to vendor.			STVATYP	STVATYP_DESC
REMIT_TO_VENDOR_UID	System generated, unique, internal identification number assigned to this person or organization entity.			FTVVEND	FTVVEND_VEND_CHECK_PIDM
TAX_ID	Vendor's tax identification number if payment is recorded and accumulated for income tax reporting.			FTVVEND	FTVVEND_1099_RPT_ID
VENDOR_TYPE	Type of vendor that classifies the vendor by various demographic criteria.			FTVVENT	FTVVENT_VTYP_CODE
VENDOR_TYPE_DESC	Description or title of the type of vendor.			FTVVTYP	FTVVTYP_DESC
VENDOR_UID	System generated unique internal identification number used to access the vendor.			FTVVEND	FTVVEND_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3