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

Ver: 8.1