Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
CAMPUS
|
Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
CAMPUS_DESC
|
Vendor campus description.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
CARRIER_VENDOR
|
|
VARCHAR2(1)
|
|
|
|
NO
|
CARRIER_VENDOR_DESC
|
|
VARCHAR2(16)
|
|
|
|
NO
|
CONTACT_NAME
|
Name or title of the primary contact for the vendor.
|
VARCHAR2(35)
|
FTVVEND
|
FTVVEND_CONTACT
|
NO
|
NO
|
COUNTRY_CODE
|
|
VARCHAR2(4)
|
|
|
|
NO
|
CURRENCY
|
|
VARCHAR2(4)
|
|
|
|
NO
|
CURRENCY_DESC
|
|
VARCHAR2(35)
|
|
|
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DISCOUNT
|
|
VARCHAR2(2)
|
|
|
|
NO
|
DISCOUNT_DESC
|
|
VARCHAR2(35)
|
|
|
|
NO
|
DISCOUNT_PERCENT
|
|
NUMBER
|
|
|
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
ENTITY_TYPE
|
Indicates whether this is person or entity record.
|
VARCHAR2(1)
|
SPRIDEN
|
SPRIDEN_ENTITY_IND
|
NO
|
NO
|
EPROCUREMENT_VENDOR_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
FEDERAL_ADDRESS_NUMBER
|
|
NUMBER
|
|
|
|
NO
|
FEDERAL_ADDRESS_TYPE
|
|
VARCHAR2(2)
|
|
|
|
NO
|
FEDERAL_REPORTABLE_TAX_IND
|
Indicates vendor as reportable for federal tax purposes.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(FTVVEND_1099_RPT_ID)
|
NO
|
NO
|
FEDERAL_REPORT_VENDOR_UID
|
|
NUMBER
|
|
|
|
NO
|
FEDERAL_WITHHOLDING_PERCENT
|
|
NUMBER
|
|
|
|
NO
|
INVOICE_GROUPING
|
|
VARCHAR2(1)
|
|
|
|
NO
|
INVOICE_GROUPING_DESC
|
|
VARCHAR2(23)
|
|
|
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MOST_RECENT_TAX_ID_NOTICE_YEAR
|
Year the most recent tax identification number notice was received.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
NUMBER_OF_TAX_ID_NOTICES
|
Number of tax identification number notices the vendor has received.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
ORDER_FROM_ADDRESS_NUMBER
|
Sequence number of the order from address for the vendor.
|
NUMBER
|
FTVVEND
|
FTVVEND_ADDR_SEQNO
|
NO
|
NO
|
ORDER_FROM_ADDRESS_TYPE
|
Address type of the order from address for the vendor.
|
VARCHAR2(2)
|
FTVVEND
|
FTVVEND_ATYP_CODE
|
NO
|
NO
|
ORDER_FROM_ADDRESS_TYPE_DESC
|
Description for the address type of the vendor.
|
VARCHAR2(30)
|
STVATYP
|
STVATYP_DESC
|
NO
|
NO
|
ORDER_HOLD_REASON
|
|
VARCHAR2(4)
|
|
|
|
NO
|
ORDER_HOLD_REASON_DESC
|
|
VARCHAR2(35)
|
|
|
|
NO
|
PAYMENT_HOLD_REASON
|
|
VARCHAR2(4)
|
|
|
|
NO
|
PAYMENT_HOLD_REASON_DESC
|
|
VARCHAR2(35)
|
|
|
|
NO
|
PHONE_AREA
|
Phone area code for the vendor.
|
VARCHAR2(6)
|
FTVVEND
|
FTVVEND_PHONE_AREA
|
NO
|
NO
|
PHONE_EXT
|
Phone extension for the vendor.
|
VARCHAR2(10)
|
FTVVEND
|
FTVVEND_PHONE_EXT
|
NO
|
NO
|
PHONE_NUMBER
|
Phone number for the vendor.
|
VARCHAR2(12)
|
FTVVEND
|
FTVVEND_PHONE_NUMBER
|
NO
|
NO
|
PHONE_NUMBER_COMBINED
|
Extracted combined phone number for the vendor.
|
VARCHAR2(28)
|
CALCULATION
|
FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER||FTVVEND_PHONE_EXT
|
NO
|
NO
|
REMIT_TO_ADDRESS_NUMBER
|
Sequence number of the address type of the remit to vendor.
|
NUMBER
|
FTVVEND
|
FTVVEND_VEND_CHECK_ADDR_SEQNO
|
NO
|
NO
|
REMIT_TO_ADDRESS_TYPE
|
Identifies the type of address that the payment for the invoice is to be sent.
|
VARCHAR2(4000)
|
FTVVEND
|
FTVVEND_VEND_CHECK_ATYP_CODE
|
NO
|
NO
|
REMIT_TO_ADDRESS_TYPE_DESC
|
Description for the address type of the remit to vendor.
|
VARCHAR2(30)
|
STVATYP
|
STVATYP_DESC
|
NO
|
NO
|
REMIT_TO_VENDOR_UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
FTVVEND
|
FTVVEND_VEND_CHECK_PIDM
|
NO
|
NO
|
STATE_WITHHOLDING_PERCENT
|
|
NUMBER
|
|
|
|
NO
|
TAX_ID
|
Vendor's tax identification number if payment is recorded and accumulated for income tax reporting.
|
VARCHAR2(9)
|
FTVVEND
|
FTVVEND_1099_RPT_ID
|
NO
|
NO
|
TAX_INCOME_TYPE
|
|
VARCHAR2(2)
|
|
|
|
NO
|
TAX_INCOME_TYPE_DESC
|
|
VARCHAR2(35)
|
|
|
|
NO
|
TAX_INCOME_TYPE_KEY
|
|
NUMBER
|
|
|
|
NO
|
VENDOR_ACTIVITY_DATE
|
|
DATE
|
|
|
|
NO
|
VENDOR_COLLECTS_TAX
|
|
VARCHAR2(1)
|
|
|
|
NO
|
VENDOR_COLLECTS_TAX_DESC
|
|
VARCHAR2(23)
|
|
|
|
NO
|
VENDOR_DATA_ORIGIN
|
|
VARCHAR2(30)
|
|
|
|
NO
|
VENDOR_RESIDENCY
|
|
VARCHAR2(1)
|
|
|
|
NO
|
VENDOR_RESIDENCY_DESC
|
|
VARCHAR2(12)
|
|
|
|
NO
|
VENDOR_START_DATE
|
|
DATE
|
|
|
|
NO
|
VENDOR_TERMINATION_DATE
|
|
DATE
|
|
|
|
NO
|
VENDOR_TYPE
|
Type of vendor that classifies the vendor by various demographic criteria.
|
VARCHAR2(2)
|
FTVVENT
|
FTVVENT_VTYP_CODE
|
NO
|
NO
|
VENDOR_TYPE_DESC
|
Description or title of the type of vendor.
|
VARCHAR2(35)
|
FTVVTYP
|
FTVVTYP_DESC
|
NO
|
NO
|
VENDOR_UID
|
System generated unique internal identification number used to access the vendor.
|
NUMBER
|
FTVVEND
|
FTVVEND_PIDM
|
NO
|
NO
|
VENDOR_USER_ID
|
|
VARCHAR2(30)
|
|
|
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|