Dict-Physical

Table MD_Vendor

Card of table MD_Vendor

Name	MD_Vendor
Dimensional Type	Dimension
Comment	Names of organizations with which we do business (e.g., we pay them). Although in Colleague vendors are treated basically like "people," we treat them separately here. Carleton College itself can be a vendor, although this table is not set up to represent Carleton's internal structure in any sophisticated way. (It's set up for other organizations, who we pay, or who pay us.)

Check constraint name of the table MD_Vendor

CKT_MD_VENDOR

List of incoming references of the table MD_Vendor

Relationship_103

MF_UnitCost

MD_Vend_SurrogateKey

Relationship_104

MF_ReadingByHourNoAggregations

MD_Vend_SurrogateKey

Relationship_114

MF_ReadingByHourSnapshot

MD_Vend_SurrogateKey

Relationship_126

MF_GLFact

MD_Vend_SurrogateKey

Relationship_227

MF_ReadingByHourAccumulating

MD_Vend_SurrogateKey

List of diagrams containing the table MD_Vendor

DimsOrganizationDiagram

List of columns of the table MD_Vendor

MD_Vend_SurrogateKey

<None>

numeric

MD_Vend_ColleagueID

DW_ColleagueVendorID

varchar(16)

MD_NonCarlEnt_Name

DW_CommonName

nvarchar(64)

MD_NonCarlEnt_BusAddrCity

City component of organization's main business address. This should be, ideally, a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

DW_Addr_City

nvarchar(32)

MD_NonCarlEnt_BusAddrUSState

US state component of organization's main business address (if in the US). This should be, ideally, a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

DW_Addr_USState

varchar(24)

MD_NonCarlEnt_BusAddrPostalCode

Zipcode component of organization's main business address (if in the US - otherwise possibly a foreign postal code). This should be taken, ideally, from a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

DW_Addr_PostalCode

nvarchar(16)

MD_NonCarlEnt_BusAddrNonUSProvince

State, district, or province component of organization's main business address (if outside the US). This should be, ideally, a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

DW_Addr_StateOrProvince

nvarchar(64)

MD_NonCarlEnt_BusAddrCountry

Country component of organization's main business address. This should be, ideally, a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

DW_Addr_Country

nvarchar(64)

MD_NonCarlEnt_BusAddrLongitude

Geocoded longitude of an organization's main business address (if in the US). This should be, ideally, a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

<None>

float

MD_NonCarlEnt_BusAddrLatitude

Geocoded latitude of an organization's main business address (if in the US). This should be, ideally, a street address (i.e., a physical delivery address) for an organization's primary place of business. But the reality of our transactional systems is that this is often a mailing address.

<None>

float

MD_Vend_AdvanceID

Many vendors will also have Advance IDs, but there is no institutional mechanism for systematically reconciling Advance vendor identities with Colleague ones - that I'm aware of.

So insofar as this field is actually populated, use it with care.

DW_AdvanceID

char(10)

MD_Vend_IsOnlyVendor

'Yes' if a given vendor is really just a vendor and not, e.g., a Carleton employee, alum, or other personal entity. Otherwise 'No'.

DW_YesOrNoNOTNULL

char(3)

MD_Vend_IsActive

DW_YesNoOrUnknown

varchar(7)

MD_Vend_IsApproved

DW_YesOrNoNOTNULL

char(3)

MD_Vend_IsStopPayment

DW_YesOrNoNOTNULL

char(3)

MD_Vend_W9IsOK

DW_YesOrNoNOTNULL

char(3)

MD_Vend_ECheckOK

DW_YesOrNoNOTNULL

char(3)

MD_Vend_PrimaryType

DW_CodeDescLong

varchar(64)

MD_Vend_PrimaryTypeCode

DW_Colleague5CharCode

char(5)

MD_Vend_TypeList

DW_CommaDelimitedList

varchar(128)

128

MD_Vend_IsRegularType

'Yes' if a regular AP-type vendor (AP type = 0001). 'No' otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_Vend_IsLibraryType

'Yes' if a Library AP-type vendor (AP type = 0066). 'No' otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_Vend_IsBookstoreType

'Yes' if a Bookstore AP-type vendor (AP type = 0086). 'No' otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_Vend_IsCSAType

'Yes' if a CSA AP-type vendor (AP type = 0090). 'No' otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_Vend_APTypeList

DW_CommaDelimitedList

varchar(128)

128

MD_Vend_AddedBy

ID of person who added the vendor to Colleague.

DW_CodeDescShort

varchar(16)

MD_Vend_AddedDate

<None>

datetime

MD_Vend_YearsSinceAddedRange

DW_CodeDesc

varchar(32)

MD_Vend_YearAdded

DW_YearAtCarleton

int

MD_Vend_YearsSinceLastPaidRange

DW_CodeDesc

varchar(32)

MD_Vend_YearLastPaid

DW_YearAtCarleton

int

MD_Vend_LastPaidDate

<None>

datetime

MD_Vend_AuditKey

DW_AuditKey

bigint

MD_Vend_Timestamp

<None>

timestamp

List of indexes of the table MD_Vendor

MD_VENDOR_PK

TRUE

FALSE

MD_Vendor

MD_VENDOR_AK

TRUE

FALSE

TRUE

MD_Vendor

List of keys of the table MD_Vendor

Identifier_1

AltKey

Home