gistfile1.js

module.exports = [
  {
    name: 'Campaign',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      alternateTrackingId: 'string?',
      createdDate: 'date?',
      name: 'string?',
      program: 'string?',
      status: 'string?',
      subType: 'string?',
      type: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Document',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      utilities: 'UtilityCompany[]',
      category: 'string?',
      contractPreference: 'string?',
      createdDate: 'date?',
      documentType: 'string?',
      endDate: 'date?',
      _kind: 'string?',
      name: 'string?',
      passedSystemValidation: 'bool?',
      preferredLanguage: 'string?',
      qaValidated: 'date?',
      signableOnDevice: 'bool?',
      startDate: 'date?',
      _states: 'string?',
      templateId: 'string?',
      _utilityIds: 'string?',
      version: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Employee',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      dealerAdmin: 'bool?',
      dealerId: 'string?',
      dealerName: 'string?',
      email: 'string?',
      badgeId: 'string?',
      firstName: 'string?',
      lastName: 'string?',
      serviceLine: 'string?',
      title: 'string?',
      upliftPayEffectiveDate: 'date?',
      workLocation: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'HoldType',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      businessPurpose: 'string?',
      createdDate: 'date?',
      longDescription: 'string?',
      name: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'InventoryType',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      active: 'bool?',
      createdDate: 'date?',
      defaultBackendProvider: 'string?',
      isDeleted: 'bool?',
      isovaPartNumber: 'string?',
      make: 'string?',
      manufacturer: 'string?',
      model: 'string?',
      mosaicPn: 'string?',
      name: 'string?',
      size: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Inverter',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      displayName: 'string?',
      make: 'string?',
      model: 'string?',
      name: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'ModuleType',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      designedModuleSize: 'double?',
      isDeleted: 'bool?',
      manufacturer: 'string?',
      modelName: 'string?',
      mosaicPN: 'string?',
      name: 'string?',
      sprucePN: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Office',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      businessUnit: 'string?',
      cmsOfficeId: 'string?',
      createdDate: 'date?',
      name: 'string?',
      _state: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'PCTControlConstraints',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      itcBuydownPercentageMax: 'float?',
      itcBuydownPercentageMin: 'float?',
      stateTaxCreditBuydownMax: 'float?',
      stateTaxCreditBuydownMin: 'float?',
      sunHoursKWHMin: 'float?',
      sunHoursPercentageMax: 'float?',
      systemSizeKWMax: 'float?',
      systemSizeKWMin: 'float?',
      utilityRateEscalationMax: 'float?',
      utilityRateEscalationMin: 'float?',
      utilityRatePercentageMax: 'float?',
      utilityRatePercentageMin: 'float?',
      _partitionId: 'string'
    }
  },
  {
    name: 'PCTProduct',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      annualFee: 'double?',
      displayName: 'string?',
      _interestRate: 'double?',
      isActive: 'bool?',
      name: 'string?',
      _productId: 'string?',
      stateId: 'string?',
      termYears: 'double?',
      _type: 'string?',
      utilityId: 'string?',
      warrantyMonitoringYears: 'double?',
      warrantyOperationsMaintenanceYears: 'double?',
      _partitionId: 'string'
    }
  },
  {
    name: 'PCTState',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      utilities: 'PCTStateUtility[]',
      createdDate: 'date?',
      name: 'string?',
      taxCreditBasis: 'bool?',
      taxCreditMaximum: 'double?',
      taxCreditPercentage: 'double?',
      taxCreditPPALeaseLifetimeMaximum: 'double?',
      taxCreditPPALeaseMaximumClaimYears: 'double?',
      taxCreditPPALeasePercentage: 'double?',
      _partitionId: 'string'
    }
  },
  {
    name: 'PCTStateUtility',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      products: 'PCTProduct[]',
      avgSunHours: 'double?',
      avgSystemSize: 'double?',
      cashSystemPricePerWatt: 'double?',
      cashSystemPricePerWattFriendsFamily: 'double?',
      contractType: 'string?',
      financedSystemPricePerWatt: 'double?',
      financedSystemPricePerWattFriendsFamily: 'double?',
      hideSavings: 'bool?',
      incentiveWattMaximumTier1: 'double?',
      incentiveWattMaximumTier2: 'double?',
      incentiveValuePerWattTier1: 'double?',
      incentiveValuePerWattTier2: 'double?',
      isActive: 'bool?',
      medianSunHours: 'double?',
      name: 'string?',
      pacePricePerWatt: 'double?',
      ppaLeasePricePerKWH: 'double?',
      pricePerKWH: 'double?',
      srecValuePerWatt: 'double?',
      stateId: 'string?',
      createdDate: 'date?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Pricebook',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      pricebookEntries: 'PricebookEntry[]',
      products: 'Product[]',
      selectablePricebookEntries: 'PricebookEntry[]',
      createdDate: 'date?',
      isActive: 'bool?',
      isArchived: 'bool?',
      isDeleted: 'bool?',
      name: 'string?',
      pricebookDescription: 'string?',
      _solarUtilityCompanyId: 'string?',
      utilityCompany: 'UtilityCompany',
      _partitionId: 'string'
    }
  },
  {
    name: 'PricebookEntry',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      basePrice: 'double?',
      createdDate: 'date?',
      isActive: 'bool?',
      isDeleted: 'bool?',
      minPrice: 'double?',
      name: 'string?',
      pricebook: 'Pricebook',
      _pricebookId: 'string?',
      product: 'Product',
      productCode: 'string?',
      _productId: 'string?',
      _termOptionsYears: 'string?',
      unitPrice: 'double?',
      useStandardPrice: 'bool?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Product',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      capacity: 'double?',
      createdDate: 'date?',
      _displayUrl: 'string?',
      externalDataSourceId: 'string?',
      externalId: 'string?',
      family: 'string?',
      isActive: 'bool?',
      isDeleted: 'bool?',
      make: 'string?',
      model: 'string?',
      name: 'string?',
      productCode: 'string?',
      productDescription: 'string?',
      productFamilySubtype: 'string?',
      quantityUnitOfMeasure: 'string?',
      rateTableAvailable: 'bool?',
      _partitionId: 'string'
    }
  },
  {
    name: 'RDocument',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      offices: 'Office[]',
      bytes: 'int?',
      category: 'string?',
      createdDate: 'date?',
      displayName: 'string?',
      documentType: 'string?',
      _kind: 'string?',
      name: 'string?',
      _officeIdsString: 'string?',
      paused: 'bool?',
      states: 'string?',
      taskIdentifier: 'int?',
      totalBytes: 'int?',
      _url: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'RecordType',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      isActive: 'bool?',
      name: 'string?',
      recordTypeDescription: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Tariff',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      zipcodes: 'Zipcode[]',
      code: 'string?',
      createdDate: 'date?',
      customerLikelihood: 'double?',
      name: 'string?',
      _surpassThresholdAllowed: 'string?',
      utilityId: 'string?',
      _partitionId: 'string'
    }
  },
  {
    name: 'UtilityCompany',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      tariffs: 'Tariff[]',
      cashSystemPricePerW: 'double?',
      createdDate: 'date?',
      financedSystemPricePerW: 'double?',
      name: 'string?',
      pricebook: 'Pricebook',
      _pricebookId: 'string?',
      serviceAddressState: 'string?',
      utilityRate: 'double?',
      _partitionId: 'string'
    }
  },
  {
    name: 'ZipAssignments',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      name: 'string?',
      _solarUtilityCompanyId: 'string?',
      _zipCode: 'string?',
      _uniqueId: 'string?',
      _solarTariffId: 'string?',
      _recordTypeId: 'string?',
      lastModifiedDate: 'date?',
      _partitionId: 'string'
    }
  },
  {
    name: 'Zipcode',
    primaryKey: '_id',
    properties: {
      _id: 'objectId',
      _externalId: 'string',
      createdDate: 'date?',
      name: 'string?',
      recordType: 'RecordType',
      _recordTypeId: 'string?',
      _solarOfficeId: 'string?',
      _partitionId: 'string'
    }
  }
];