Contract

Technical Description of Contract within Prod OMNIA Partners EDW at 25-Mar-2025 12:12:00

Table name

Contract

Display name

Dim.Contract

Description

Dimension table for OMNIA Partners contracts. This dimension contains all information on all contracts, past & present. It may also, from time to time, include contracts that have are still in-progress.

Type of Dimension

Dimension

Update Procedure

UPDATE_Contract

Custom Procedure

Purpose

Concept

Grain

Procedures

The table Contract is accessed by the following Procedures.
No procedures found.

Host Scripts

The table Contract is accessed by the following Host Scripts.

Table relationships

Relationships have been defined between Contract and the following tables:
No table relationships defined for this object.

Columns

The table Contract contains the following columns.
Column NameDisplay NameData TypeDefault ValueSource TableSource ColumnBusiness Key
ContractKeyContract Keyinteger identity(1,1)ContractKey
OrganizationKeyOrganizationKeyintegerOrganizationOrganizationKey
OrganizationIdOrganization IdintStageContract_AddKeysOrganizationId
ContractAccountOwnerContract Account OwnerVARCHARStageContract_AddKeysContractAccountOwner
ContractAccountIdContract Account IdCHAR(18)StageContract_AddKeysContractAccountId
SupplierKeySupplierKeyintegerStageContract_AddKeysSupplierKey
SupplierNameSupplier NameVARCHARStageContract_AddKeysSupplierName
ContractActivatedByContract Activated ByVARCHARStageContract_AddKeysContractActivatedBy
ContractActivatedBySFIdContract Activated By Salesforce IdCHAR(18)StageContract_AddKeysContractActivatedBySFId
ContractActivatedDateContract Activated DateTimestampStageContract_AddKeysContractActivatedDate
ContractReportingFrequencyContract Reporting FrequencyVARCHARStageContract_AddKeysContractReportingFrequency
ContractAdminFeeTypeAdmin Fee TypeVARCHARStageContract_AddKeysContractAdminFeeType
ContractAgreementTypeContract Agreement TypeVARCHARStageContract_AddKeysContractAgreementType
ContractAnticipatedAwardDateAnticipated Award Date cTimestampStageContract_AddKeysContractAnticipatedAwardDate
ContractAwardDateAward Date cTimestampStageContract_AddKeysContractAwardDate
IsContractAwardStatusIn90DaysAward Status in 90 Days cbooleanStageContract_AddKeysIsContractAwardStatusIn90Days
ContractBillingCityBillingCityVARCHARStageContract_AddKeysContractBillingCity
ContractBillingCountryBillingCountryVARCHARStageContract_AddKeysContractBillingCountry
ContractBillingGeocodeAccuracyBillingGeocodeAccuracyVARCHARStageContract_AddKeysContractBillingGeocodeAccuracy
ContractBillingLatitudeBillingLatitudedecimal(18,15)StageContract_AddKeysContractBillingLatitude
ContractBillingLongitudeBillingLongitudedecimal(18,15)StageContract_AddKeysContractBillingLongitude
ContractBillingPostalCodeBillingPostalCodeVARCHARStageContract_AddKeysContractBillingPostalCode
ContractBillingStateBillingStateVARCHARStageContract_AddKeysContractBillingState
ContractBillingStreetBillingStreetVARCHARStageContract_AddKeysContractBillingStreet
IsCapitalContractCapital cbooleanStageContract_AddKeysIsCapitalContract
IsCapitalContractYesNoCapital Contract cVARCHARStageContract_AddKeysIsCapitalContractYesNo
ContractCategoryCategory cVARCHARStageContract_AddKeysContractCategory
ContractOnviaCategoryOnviaCategoryVARCHARStageContract_AddKeysContractOnviaCategory
ContractCompanySignedDateCompanySignedDateTimestampStageContract_AddKeysContractCompanySignedDate
ContractCompanySignedSFIdCompanySignedIdCHAR(18)StageContract_AddKeysContractCompanySignedSFId
ContractCompletionDateCompletion Date cTimestampStageContract_AddKeysContractCompletionDate
ContractGroupAvailabilityContract Group Availability cVARCHARStageContract_AddKeysContractGroupAvailability
ContractManagerNameContract Manager Name cVARCHARStageContract_AddKeysContractManagerName
ContractNumberContract Number cVARCHARStageContract_AddKeysContractNumber
ContractStatusContract Status cVARCHARStageContract_AddKeysContractStatus
ContractTypeContract Type cVARCHARStageContract_AddKeysContractType
SalesforceContractNumberContractNumberVARCHARStageContract_AddKeysSalesforceContractNumber
ContractTermContractTermintStageContract_AddKeysContractTerm
ContractCreatedByCreatedByVARCHARStageContract_AddKeysContractCreatedBy
ContractCreatedByIdCreatedByIdCHAR(18)StageContract_AddKeysContractCreatedById
ContractCreatedDateCreatedDateTimestampStageContract_AddKeysContractCreatedDate
ContractTermEndDateCurrent Term End Date cTimestampStageContract_AddKeysContractTermEndDate
ContractTermEndDateKeyContractTermEndDateKeyintDimContractTermEndDateContractTermEndDateKey
ContractCustomerSignedDateCustomerSignedDateTimestampStageContract_AddKeysContractCustomerSignedDate
ContractCustomerSignedIdCustomerSignedIdCHAR(18)StageContract_AddKeysContractCustomerSignedId
ContractCustomerSignedTitleCustomerSignedTitleVARCHARStageContract_AddKeysContractCustomerSignedTitle
ContractDescriptionDescriptionVARCHARStageContract_AddKeysContractDescription
ContractFinalEndDateKeyContractFinalEndDateKeyintDimContractFinalEndDateContractFinalEndDateKey
ContractFinalEndDateEndDateTimestampStageContract_AddKeysContractFinalEndDate
ContractIdForce Contract ID cVARCHARStageContract_AddKeysContractId
SupplierIdSupplierIdVARCHARStageContract_AddKeysSupplierId
FutureContractSalesforceIdFuture Contract cVARCHARStageContract_AddKeysFutureContractSalesforceId
ContractSalesforceIdIdCHAR(18)StageContract_AddKeysContractSalesforceId0
InternalExternalManagementInternalExternalManagementVARCHARStageContract_AddKeysInternalExternalManagement
ContractIsDeletedIsDeletedbooleanStageContract_AddKeysContractIsDeleted
ContractLastModifiedDateCaseLast Modified Date Case cTimestampStageContract_AddKeysContractLastModifiedDateCase
ContractLastActivityDateLastActivityDateTimestampStageContract_AddKeysContractLastActivityDate
ContractLastApprovedDateLastApprovedDateTimestampStageContract_AddKeysContractLastApprovedDate
ContractLastModifiedByLastModifiedByVARCHARStageContract_AddKeysContractLastModifiedBy
ContractLastModifiedByIdLastModifiedByIdCHAR(18)StageContract_AddKeysContractLastModifiedById
ContractLastModifiedDateLastModifiedDateTimestampStageContract_AddKeysContractLastModifiedDate
ContractLastReferencedDateLastReferencedDateTimestampStageContract_AddKeysContractLastReferencedDate
ContractLastViewedDateLastViewedDateTimestampStageContract_AddKeysContractLastViewedDate
ContractMultipleStandardAdminRatesMultiple Standard Admin Rates cbooleanStageContract_AddKeysContractMultipleStandardAdminRates
ContractNameNameVARCHARStageContract_AddKeysContractName
IsNewSupplierNew Supplier cbooleanStageContract_AddKeysIsNewSupplier
OMNIAContractTypeOMNIA Contract Type cVARCHARStageContract_AddKeysOMNIAContractType
ContractOwnerExpirationNoticeOwnerExpirationNoticeVARCHARStageContract_AddKeysContractOwnerExpirationNotice
ContractOwnerIdOwnerIdCHAR(18)StageContract_AddKeysContractOwnerId
ContractOwnerNameOwnerNameVARCHARStageContract_AddKeysContractOwnerName
ContractPortfolioManagerPortfolio Manager cVARCHARStageContract_AddKeysContractPortfolioManager
PPAContractNumberPPA Contract Number cVARCHARStageContract_AddKeysPPAContractNumber
PPAContractTitlePPA Contract Title cVARCHARStageContract_AddKeysPPAContractTitle
LeadAgencyNamePPA NameVARCHARStageContract_AddKeysLeadAgencyName
ContractPPARevenueSharePercentPPA Rebate Share cdecimal(18,6)StageContract_AddKeysContractPPARevenueSharePercent
LeadAgencyIdPPA SF IdVARCHARStageContract_AddKeysLeadAgencyId
PreviousContractIdPrevious Contract cCHAR(18)StageContract_AddKeysPreviousContractId
PreviousContractNumberPrevious Contract NumberVARCHARStageContract_AddKeysPreviousContractNumber
ContractPricePerUnitPrice Per Unit cnumeric(18)StageContract_AddKeysContractPricePerUnit
ContractProductCategoryProduct Category cCHAR(18)StageContract_AddKeysContractProductCategory
ContractProtestPeriodEndsDateProtest Period Ends cTimestampStageContract_AddKeysContractProtestPeriodEndsDate
ContractPublicOrPrivatePublic Private cVARCHARStageContract_AddKeysContractPublicOrPrivate
PublicSectorContractNumberPublic Sector Contract Number cVARCHARStageContract_AddKeysPublicSectorContractNumber
ContractRenewalResolicitationStatusRenewal Re Solicitation Status cVARCHARStageContract_AddKeysContractRenewalResolicitationStatus
ContractResolicitationDateRe Solicitation Date cTimestampStageContract_AddKeysContractResolicitationDate
ContractRecordTypeRecordTypeVARCHARStageContract_AddKeysContractRecordType
ContractRecordTypeIdRecordTypeIdCHAR(18)StageContract_AddKeysContractRecordTypeId
ContractResolicitationDueDateResolicitation Due cTimestampStageContract_AddKeysContractResolicitationDueDate
ContractResponseDueDateResponse Due Date cTimestampStageContract_AddKeysContractResponseDueDate
ContractRevenueFeeDetailRevenue Fee Detail cVARCHARStageContract_AddKeysContractRevenueFeeDetail
ContractRevenueFeePercentRevenue Fee Percent cdecimal(18,3)StageContract_AddKeysContractRevenueFeePercent
ContractShippingCityShippingCityVARCHARStageContract_AddKeysContractShippingCity
ContractShippingCountryShippingCountryVARCHARStageContract_AddKeysContractShippingCountry
ContractShippingGeocodeAccuracyShippingGeocodeAccuracyVARCHARStageContract_AddKeysContractShippingGeocodeAccuracy
ContractShippingLatitudeShippingLatitudedecimal(18,15)StageContract_AddKeysContractShippingLatitude
ContractShippingLongitudeShippingLongitudedecimal(18,15)StageContract_AddKeysContractShippingLongitude
ContractShippingPostalCodeShippingPostalCodeVARCHARStageContract_AddKeysContractShippingPostalCode
ContractShippingStateShippingStateVARCHARStageContract_AddKeysContractShippingState
ContractShippingStreetShippingStreetVARCHARStageContract_AddKeysContractShippingStreet
ContractSolicitationIdSolicitation cCHAR(18)StageContract_AddKeysContractSolicitationId
ContractSolicitationNameSolicitation Name cVARCHARStageContract_AddKeysContractSolicitationName
ContractSolicitationNumberSolicitation Number cVARCHARStageContract_AddKeysContractSolicitationNumber
ContractSolicitationStatusSolicitation Status cVARCHARStageContract_AddKeysContractSolicitationStatus
SourceEntityNameSourcing Entity cVARCHARStageContract_AddKeysSourceEntityName
SPDDirectorSPD Director cVARCHARStageContract_AddKeysSPDDirector
ContractSpecialTermsSpecialTermsVARCHARStageContract_AddKeysContractSpecialTerms
ContractStandardAdminFeeStandard Admin Fee cdecimal(18,4)StageContract_AddKeysContractStandardAdminFee
ContractStartDateKeyContractStartDateKeyintDimContractStartDateContractStartDateKey
ContractStartDateStartDateTimestampStageContract_AddKeysContractStartDate
ContractStatusActiveExpiredClosedStatusVARCHARStageContract_AddKeysContractStatusActiveExpiredClosed
ContractStatusOrderStatus Order cnumeric(18)StageContract_AddKeysContractStatusOrder
ContractStatusCodeStatusCodeVARCHARStageContract_AddKeysContractStatusCode
ContractSubCategorySubcategory cVARCHARStageContract_AddKeysContractSubCategory
ContractSystemModstampSystemModstampTimestampStageContract_AddKeysContractSystemModstamp
ContractTier1IdTier1 Id cintStageContract_AddKeysContractTier1Id
ContractUnitTypeUnit Type cVARCHARStageContract_AddKeysContractUnitType
ContractVendorExternalRefVendor External Ref cVARCHARStageContract_AddKeysContractVendorExternalRef
ContractVendorIDVendor ID cVARCHARStageContract_AddKeysContractVendorID
ContractVendorNameVendor Name cVARCHARStageContract_AddKeysContractVendorName
ContractVizientSupplierIdVizientSupplierIdVARCHARStageContract_AddKeysContractVizientSupplierId
InitialContractIdInitialContractIdVARCHARStageContract_AddKeysInitialContractId
InitialContractRenewalCountInitialContractRenewalCountintStageContract_AddKeysInitialContractRenewalCount
FinancialReportingSupplierNameFinancial Reporting Supplier NameVARCHARStageContract_AddKeysFinancialReportingSupplierName
SolicitationNumberSolicitationNumberVARCHARStageContract_AddKeysSolicitationNumber
SolicitationRecordTypeSolicitationRecordTypeVARCHARStageContract_AddKeysSolicitationRecordType
SolicitationPPANameSolicitationPPANameVARCHARStageContract_AddKeysSolicitationPPAName
SolicitationNewProductServiceSolicitationNewProductServicebooleanStageContract_AddKeysSolicitationNewProductService
VerticalVerticalvarcharStageContract_AddKeysVertical
Financial_CategoryFinancial CategoryvarcharStageContract_AddKeysFinancial_Category
Financial_SubcategoryFinancial SubcategoryvarcharStageContract_AddKeysFinancial_Subcategory
Rebate_LanguageRebate Languagevarchar(500)StageContract_AddKeysRebate_Language
PPA_Level_1_ForceIdPPA Level 1 ForceIdintStageContract_AddKeysPPA_Level_1_ForceId
Lead_Agency_Contract_ManagerLead Agency Contract ManagervarcharStageContract_AddKeysLead_Agency_Contract_Manager
PPA_Rebate_Contracting__cPPA Rebate ContractingfloatStageContract_AddKeysPPA_Rebate_Contracting__c
dss_source_system_keydss source system keyintegerStageContract_AddKeysdss_source_system_keyY
DSSRecordSourcedss record sourceVARCHARStageContract_AddKeysdss_record_source
dss_load_datedss load dateTimestampStageContract_AddKeysdss_load_date
DSSCreateTimeDSSCreateTimeTimestampDSSCreateTime
DSSUpdateTimeDSSUpdateTimeTimestampDSSUpdateTime

Column Documentation

No documentation found

UI Config Column Documentation

No documentation found

Transformations

The table Contract uses the following transformations.
Column NameTransformation StringBusiness Definition
dss_source_system_keyStageContract_AddKeys.dss_source_system_keynon conformed dimension key

Source diagram

The Contract source diagram.

Source tables

The Contract source tables.

Indexes

The table Contract contains the following Indexes.
No indexes found for this object.

Extended Properties

Object NameDisplay NameVariable NameValue
TABLE_TYPESF_TABLE_TYPE 
TYPE_3_COLSSF_TYPE_3_COLS 
INCREMENTAL_LOAD_TABLESF_INCREMENTAL_LOAD_TABLE 
INCREMENTAL_LOAD_COLUMNSF_INCREMENTAL_LOAD_COLUMN 
INCREMENTAL_LOAD_COLUMN_TYPESF_INCREMENTAL_LOAD_COLUMN_TYPE 
INCREMENTAL_LOAD_PARAMETERSF_INCREMENTAL_LOAD_PARAMETER 

Storage

Location of Contract
Filegroup:
Target Name:Dim
Connection Name:Snowflake
Database:OMNIAPARTNERSDW
Schema:DIM

Build Information

Set based processing.
With MINUS select using: Except
With MINUS select using: Except

Procedure includes the following FROM statement:-
FROM [TABLEOWNER].[StageContract_AddKeys] StageContract_AddKeys

Procedure includes the following WHERE statement:-
WHERE StageContract_AddKeys.SupplierKey>0

DELETE before update using:-
WHERE Contract.ContractSalesforceId NOT IN (SELECT DISTINCT StageContract_AddKeys.ContractSalesforceId FROM [TABLEOWNER].[StageContract_AddKeys])

Procedure Generated from Template:
Template Name:wsl_snowflake_pscript_perm

Fact Tables

The table Contract links to the following Fact Tables.

Dimensions

The table Contract is a snowflake to the following Dimensions.
This Dimension is not a snowflake.

Hierarchies

The table Contract has the following hierarchies defined.
If Maint is Y the Schema and Table columns list the external table which defines the hierarchy elements for this hierarchy.
No hierarchies found.

Hierarchy elements

The above hierarchies have the following elements defined.
No hierarchies found.

Examples

Usage

Notes

Return to Top