| Column Name | Display Name | Data Type | Default Value | Source Table | Source Column | Business Key |
| OrganizationId | Organization Id | varchar | | StageSalesforceContracts_2 | OrganizationId | |
| ContractAccountOwner | Contract Account Owner | varchar | | StageSalesforceContracts_2 | ContractAccountOwner | |
| ContractAccountId | Contract Account Id | varchar | | StageSalesforceContracts_2 | ContractAccountId | |
| SupplierName | Supplier Name | varchar | | StageSalesforceContracts_2 | SupplierName | |
| ContractActivatedBy | Contract Activated By | varchar | | StageSalesforceContracts_2 | ContractActivatedBy | |
| ContractActivatedBySFId | Contract Activated By Salesforce Id | varchar | | StageSalesforceContracts_2 | ContractActivatedBySFId | |
| ContractActivatedDate | Contract Activated Date | Timestamp | | StageSalesforceContracts_2 | ContractActivatedDate | |
| ContractReportingFrequency | Contract Reporting Frequency | varchar | | StageSalesforceContracts_2 | ContractReportingFrequency | |
| ContractAdminFeeType | Admin Fee Type | varchar | | StageSalesforceContracts_2 | ContractAdminFeeType | |
| ContractAgreementType | Contract Agreement Type | varchar | | StageSalesforceContracts_2 | ContractAgreementType | |
| ContractAnticipatedAwardDate | Anticipated Award Date c | Timestamp | | StageSalesforceContracts_2 | ContractAnticipatedAwardDate | |
| ContractAwardDate | Award Date c | Timestamp | | StageSalesforceContracts_2 | ContractAwardDate | |
| IsContractAwardStatusIn90Days | Award Status in 90 Days c | boolean | | StageSalesforceContracts_2 | IsContractAwardStatusIn90Days | |
| ContractBillingCity | BillingCity | varchar | | StageSalesforceContracts_2 | ContractBillingCity | |
| ContractBillingCountry | BillingCountry | varchar | | StageSalesforceContracts_2 | ContractBillingCountry | |
| ContractBillingGeocodeAccuracy | BillingGeocodeAccuracy | varchar | | StageSalesforceContracts_2 | ContractBillingGeocodeAccuracy | |
| ContractBillingLatitude | BillingLatitude | decimal(18,15) | | StageSalesforceContracts_2 | ContractBillingLatitude | |
| ContractBillingLongitude | BillingLongitude | decimal(18,15) | | StageSalesforceContracts_2 | ContractBillingLongitude | |
| ContractBillingPostalCode | BillingPostalCode | varchar | | StageSalesforceContracts_2 | ContractBillingPostalCode | |
| ContractBillingState | BillingState | varchar | | StageSalesforceContracts_2 | ContractBillingState | |
| ContractBillingStreet | BillingStreet | varchar | | StageSalesforceContracts_2 | ContractBillingStreet | |
| IsCapitalContract | Capital c | boolean | | StageSalesforceContracts_2 | IsCapitalContract | |
| IsCapitalContractYesNo | Capital Contract c | varchar | | StageSalesforceContracts_2 | IsCapitalContractYesNo | |
| ContractCategory | Category c | varchar | | StageSalesforceContracts_2 | ContractCategory | |
| ContractCompanySignedDate | CompanySignedDate | Timestamp | | StageSalesforceContracts_2 | ContractCompanySignedDate | |
| ContractCompanySignedSFId | CompanySignedId | varchar | | StageSalesforceContracts_2 | ContractCompanySignedSFId | |
| ContractCompletionDate | Completion Date c | Timestamp | | StageSalesforceContracts_2 | ContractCompletionDate | |
| ContractGroupAvailability | Contract Group Availability c | varchar | | StageSalesforceContracts_2 | ContractGroupAvailability | |
| ContractManagerName | Contract Manager Name c | varchar | | StageSalesforceContracts_2 | ContractManagerName | |
| ContractNumber | Contract Number c | varchar | | StageSalesforceContracts_2 | ContractNumber | |
| ContractStatus | Contract Status c | varchar | | StageSalesforceContracts_2 | ContractStatus | |
| SalesforceContractNumber | ContractNumber | varchar | | StageSalesforceContracts_2 | SalesforceContractNumber | |
| ContractType | Contract Type c | varchar | | StageSalesforceContracts_2 | ContractType | |
| ContractTerm | ContractTerm | int | | StageSalesforceContracts_2 | ContractTerm | |
| ContractCreatedBy | CreatedBy | varchar | | StageSalesforceContracts_2 | ContractCreatedBy | |
| ContractCreatedById | CreatedById | varchar | | StageSalesforceContracts_2 | ContractCreatedById | |
| ContractCreatedDate | CreatedDate | Timestamp | | StageSalesforceContracts_2 | ContractCreatedDate | |
| ContractTermEndDate | Current Term End Date c | Timestamp | | StageSalesforceContracts_2 | ContractTermEndDate | |
| ContractCustomerSignedDate | CustomerSignedDate | Timestamp | | StageSalesforceContracts_2 | ContractCustomerSignedDate | |
| ContractCustomerSignedId | CustomerSignedId | varchar | | StageSalesforceContracts_2 | ContractCustomerSignedId | |
| ContractCustomerSignedTitle | CustomerSignedTitle | varchar | | StageSalesforceContracts_2 | ContractCustomerSignedTitle | |
| ContractDescription | Description | varchar | | StageSalesforceContracts_2 | ContractDescription | |
| ContractFinalEndDate | EndDate | Timestamp | | StageSalesforceContracts_2 | ContractFinalEndDate | |
| ContractId | Force Contract ID c | varchar | | StageSalesforceContracts_2 | ContractId | |
| SupplierId | SupplierId | varchar | | StageSalesforceContracts_2 | SupplierId | |
| FutureContractSalesforceId | Future Contract c | varchar | | StageSalesforceContracts_2 | FutureContractSalesforceId | |
| ContractSalesforceId | Id | varchar | | StageSalesforceContracts_2 | ContractSalesforceId | 0 |
| InternalExternalManagement | InternalExternalManagement | varchar | | StageSalesforceContracts_2 | InternalExternalManagement | |
| ContractIsDeleted | IsDeleted | boolean | | StageSalesforceContracts_2 | ContractIsDeleted | |
| ContractLastModifiedDateCase | Last Modified Date Case c | Timestamp | | StageSalesforceContracts_2 | ContractLastModifiedDateCase | |
| ContractLastActivityDate | LastActivityDate | Timestamp | | StageSalesforceContracts_2 | ContractLastActivityDate | |
| ContractLastApprovedDate | LastApprovedDate | Timestamp | | StageSalesforceContracts_2 | ContractLastApprovedDate | |
| ContractLastModifiedBy | LastModifiedBy | varchar | | StageSalesforceContracts_2 | ContractLastModifiedBy | |
| ContractLastModifiedById | LastModifiedById | varchar | | StageSalesforceContracts_2 | ContractLastModifiedById | |
| ContractLastModifiedDate | LastModifiedDate | Timestamp | | StageSalesforceContracts_2 | ContractLastModifiedDate | |
| ContractLastReferencedDate | LastReferencedDate | Timestamp | | StageSalesforceContracts_2 | ContractLastReferencedDate | |
| ContractLastViewedDate | LastViewedDate | Timestamp | | StageSalesforceContracts_2 | ContractLastViewedDate | |
| ContractMultipleStandardAdminRates | Multiple Standard Admin Rates c | boolean | | StageSalesforceContracts_2 | ContractMultipleStandardAdminRates | |
| ContractName | Name | varchar | | StageSalesforceContracts_2 | ContractName | |
| IsNewSupplier | New Supplier c | boolean | | StageSalesforceContracts_2 | IsNewSupplier | |
| OMNIAContractType | OMNIA Contract Type c | varchar | | StageSalesforceContracts_2 | OMNIAContractType | |
| ContractOwnerExpirationNotice | OwnerExpirationNotice | varchar | | StageSalesforceContracts_2 | ContractOwnerExpirationNotice | |
| ContractOwnerId | OwnerId | varchar | | StageSalesforceContracts_2 | ContractOwnerId | |
| ContractOwnerName | OwnerName | varchar | | StageSalesforceContracts_2 | ContractOwnerName | |
| ContractPortfolioManager | Portfolio Manager c | varchar | | StageSalesforceContracts_2 | ContractPortfolioManager | |
| PPAContractNumber | PPA Contract Number c | varchar | | StageSalesforceContracts_2 | PPAContractNumber | |
| PPAContractTitle | PPA Contract Title c | varchar | | StageSalesforceContracts_2 | PPAContractTitle | |
| LeadAgencyName | PPA Name | varchar | | StageSalesforceContracts_2 | LeadAgencyName | |
| ContractPPARevenueSharePercent | PPA Rebate Share c | decimal(18,3) | | StageSalesforceContracts_2 | ContractPPARevenueSharePercent | |
| LeadAgencyId | PPA SF Id | varchar | | StageSalesforceContracts_2 | LeadAgencyId | |
| PreviousContractId | Previous Contract c | varchar | | StageSalesforceContracts_2 | PreviousContractId | |
| PreviousContractNumber | Previous Contract Number | varchar | | StageSalesforceContracts_2 | PreviousContractNumber | |
| ContractPricePerUnit | Price Per Unit c | numeric(18) | | StageSalesforceContracts_2 | ContractPricePerUnit | |
| ContractProductCategory | Product Category c | varchar | | StageSalesforceContracts_2 | ContractProductCategory | |
| ContractProtestPeriodEndsDate | Protest Period Ends c | Timestamp | | StageSalesforceContracts_2 | ContractProtestPeriodEndsDate | |
| ContractPublicOrPrivate | Public Private c | varchar | | StageSalesforceContracts_2 | ContractPublicOrPrivate | |
| PublicSectorContractNumber | Public Sector Contract Number c | varchar | | StageSalesforceContracts_2 | PublicSectorContractNumber | |
| ContractRenewalResolicitationStatus | Renewal Re Solicitation Status c | varchar | | StageSalesforceContracts_2 | ContractRenewalResolicitationStatus | |
| ContractResolicitationDate | Re Solicitation Date c | Timestamp | | StageSalesforceContracts_2 | ContractResolicitationDate | |
| ContractRecordType | RecordType | varchar | | StageSalesforceContracts_2 | ContractRecordType | |
| ContractRecordTypeId | RecordTypeId | varchar | | StageSalesforceContracts_2 | ContractRecordTypeId | |
| ContractResolicitationDueDate | Resolicitation Due c | Timestamp | | StageSalesforceContracts_2 | ContractResolicitationDueDate | |
| ContractResponseDueDate | Response Due Date c | Timestamp | | StageSalesforceContracts_2 | ContractResponseDueDate | |
| ContractRevenueFeeDetail | Revenue Fee Detail c | varchar | | StageSalesforceContracts_2 | ContractRevenueFeeDetail | |
| ContractRevenueFeePercent | Revenue Fee Percent c | decimal(18,3) | | StageSalesforceContracts_2 | ContractRevenueFeePercent | |
| ContractShippingCity | ShippingCity | varchar | | StageSalesforceContracts_2 | ContractShippingCity | |
| ContractShippingCountry | ShippingCountry | varchar | | StageSalesforceContracts_2 | ContractShippingCountry | |
| ContractShippingGeocodeAccuracy | ShippingGeocodeAccuracy | varchar | | StageSalesforceContracts_2 | ContractShippingGeocodeAccuracy | |
| ContractShippingLatitude | ShippingLatitude | decimal(18,15) | | StageSalesforceContracts_2 | ContractShippingLatitude | |
| ContractShippingLongitude | ShippingLongitude | decimal(18,15) | | StageSalesforceContracts_2 | ContractShippingLongitude | |
| ContractShippingPostalCode | ShippingPostalCode | varchar | | StageSalesforceContracts_2 | ContractShippingPostalCode | |
| ContractShippingState | ShippingState | varchar | | StageSalesforceContracts_2 | ContractShippingState | |
| ContractShippingStreet | ShippingStreet | varchar | | StageSalesforceContracts_2 | ContractShippingStreet | |
| ContractSolicitationId | Solicitation c | varchar | | StageSalesforceContracts_2 | ContractSolicitationId | |
| ContractSolicitationName | Solicitation Name c | varchar | | StageSalesforceContracts_2 | ContractSolicitationName | |
| ContractSolicitationNumber | Solicitation Number c | varchar | | StageSalesforceContracts_2 | ContractSolicitationNumber | |
| ContractSolicitationStatus | Solicitation Status c | varchar | | StageSalesforceContracts_2 | ContractSolicitationStatus | |
| SourceEntityName | Sourcing Entity c | varchar | | StageSalesforceContracts_2 | SourceEntityName | |
| SPDDirector | SPD Director c | varchar | | StageSalesforceContracts_2 | SPDDirector | |
| ContractSpecialTerms | SpecialTerms | varchar | | StageSalesforceContracts_2 | ContractSpecialTerms | |
| ContractStandardAdminFee | Standard Admin Fee c | decimal(18,4) | | StageSalesforceContracts_2 | ContractStandardAdminFee | |
| ContractStartDate | StartDate | Timestamp | | StageSalesforceContracts_2 | ContractStartDate | |
| ContractStatusActiveExpiredClosed | Status | varchar | | StageSalesforceContracts_2 | ContractStatusActiveExpiredClosed | |
| ContractStatusOrder | Status Order c | numeric(18) | | StageSalesforceContracts_2 | ContractStatusOrder | |
| ContractStatusCode | StatusCode | varchar | | StageSalesforceContracts_2 | ContractStatusCode | |
| ContractSubCategory | Subcategory c | varchar | | StageSalesforceContracts_2 | ContractSubCategory | |
| ContractSystemModstamp | SystemModstamp | Timestamp | | StageSalesforceContracts_2 | ContractSystemModstamp | |
| ContractTier1Id | Tier1 Id c | int | | StageSalesforceContracts_2 | ContractTier1Id | |
| ContractUnitType | Unit Type c | varchar | | StageSalesforceContracts_2 | ContractUnitType | |
| ContractVendorExternalRef | Vendor External Ref c | varchar | | StageSalesforceContracts_2 | ContractVendorExternalRef | |
| ContractVendorID | Vendor ID c | varchar | | StageSalesforceContracts_2 | ContractVendorID | |
| ContractVendorName | Vendor Name c | varchar | | StageSalesforceContracts_2 | ContractVendorName | |
| ContractVizientSupplierId | VizientSupplierId | varchar | | StageSalesforceContracts_2 | ContractVizientSupplierId | |
| InitialContractId | InitialContractId | varchar | | StageSalesforceContracts_2 | InitialContractId | |
| InitialContractRenewalCount | InitialContractRenewalCount | int | | StageSalesforceContracts_2 | InitialContractRenewalCount | |
| SolicitationNumber | SolicitationNumber | varchar | | StageSalesforceContracts_2 | SolicitationNumber | |
| SolicitationRecordType | SolicitationRecordType | varchar | | StageSalesforceContracts_2 | SolicitationRecordType | |
| SolicitationPPAName | SolicitationPPAName | varchar | | StageSalesforceContracts_2 | SolicitationPPAName | |
| SolicitationNewProductService | SolicitationNewProductService | boolean | | StageSalesforceContracts_2 | SolicitationNewProductService | |
| FinancialReportingSupplierName | FinancialReportingSupplierName | varchar | | StageSalesforceContracts_2 | FinancialReportingSupplierName | |
| Vertical | Vertical | varchar | | StageSalesforceContracts_2 | Vertical | |
| Financial_Category | Financial Category | varchar | | StageSalesforceContracts_2 | Financial_Category | |
| Financial_Subcategory | Financial Subcategory | varchar | | StageSalesforceContracts_2 | Financial_Subcategory | |
| Rebate_Language | Rebate Language | varchar(500) | | StageSalesforceContracts_2 | Rebate_Language | |
| Lead_Agency_Contract_Manager | Lead Agency Contract Manager | varchar(1300) | | StageSalesforceContracts_2 | Lead_Agency_Contract_Manager | |
| PPA_Rebate_Contracting__c | PPA Rebate Contracting | float | | StageSalesforceContracts_2 | PPA_Rebate_Contracting__c | |
| dss_source_system_key | dss source system key | integer | | StageSalesforceContracts_2 | dss_source_system_key | |
| dss_record_source | dss record source | varchar | | StageSalesforceContracts_2 | dss_record_source | |
| dss_load_date | dss load date | Timestamp | | StageSalesforceContracts_2 | dss_load_date | |
| DSSCreateTime | DSSCreateTime | Timestamp | | | DSSCreateTime | |
| DSSUpdateTime | DSSUpdateTime | Timestamp | | | DSSUpdateTime | |
| PPA_Level_1_ForceId | PPA Level 1 ForceId | int | | StageSalesforceContracts_2 | PPA_Level_1_ForceId | |
