Name: oslisde.OSLISDE.T_ActiveMineralLeaseLARCS

Display Field: CompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4980b0a78803455782d9ed5bd9046267

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ID ( type: esriFieldTypeDouble, alias: ID, editable: true, nullable: false, defaultValue: null, modelName: ID )
• LeaseID ( type: esriFieldTypeInteger, alias: LeaseID, editable: true, nullable: true, defaultValue: null, modelName: LeaseID )
• LesseeCompanyIDInLease ( type: esriFieldTypeInteger, alias: LesseeCompanyIDInLease, editable: true, nullable: true, defaultValue: null, modelName: LesseeCompanyIDInLease )
• LeaseNumber ( type: esriFieldTypeString, alias: LeaseNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LeaseNumber )
• LeaseIssueDate ( type: esriFieldTypeDate, alias: LeaseIssueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LeaseIssueDate )
• LeaseExpirationDate ( type: esriFieldTypeDate, alias: LeaseExpirationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LeaseExpirationDate )
• LeaseRentAmountPerAcre ( type: esriFieldTypeDouble, alias: LeaseRentAmountPerAcre, editable: true, nullable: true, defaultValue: null, modelName: LeaseRentAmountPerAcre )
• LeaseRoyaltyIDInLease ( type: esriFieldTypeInteger, alias: LeaseRoyaltyIDInLease, editable: true, nullable: true, defaultValue: null, modelName: LeaseRoyaltyIDInLease )
• MineralTypeIDInLease ( type: esriFieldTypeInteger, alias: MineralTypeIDInLease, editable: true, nullable: true, defaultValue: null, modelName: MineralTypeIDInLease )
• BasinCodeIDInLease ( type: esriFieldTypeInteger, alias: BasinCodeIDInLease, editable: true, nullable: true, defaultValue: null, modelName: BasinCodeIDInLease )
• GasPlantCodeIDInLease ( type: esriFieldTypeInteger, alias: GasPlantCodeIDInLease, editable: true, nullable: true, defaultValue: null, modelName: GasPlantCodeIDInLease )
• LeasePrimaryTermExpirationDate ( type: esriFieldTypeDate, alias: LeasePrimaryTermExpirationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LeasePrimaryTermExpirationDate )
• LeaseStateOwnershipPercentage ( type: esriFieldTypeDouble, alias: LeaseStateOwnershipPercentage, editable: true, nullable: true, defaultValue: null, modelName: LeaseStateOwnershipPercentage )
• LeaseSourceIDInLease ( type: esriFieldTypeInteger, alias: LeaseSourceIDInLease, editable: true, nullable: true, defaultValue: null, modelName: LeaseSourceIDInLease )
• SSALIDInLease ( type: esriFieldTypeString, alias: SSALIDInLease, editable: true, nullable: true, length: 400, defaultValue: null, modelName: SSALIDInLease )
• LeaseFundCode ( type: esriFieldTypeString, alias: LeaseFundCode, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LeaseFundCode )
• LeaseCounty ( type: esriFieldTypeString, alias: LeaseCounty, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LeaseCounty )
• LeaseAcres ( type: esriFieldTypeDouble, alias: LeaseAcres, editable: true, nullable: true, defaultValue: null, modelName: LeaseAcres )
• LeaseLegalDescription ( type: esriFieldTypeString, alias: LeaseLegalDescription, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LeaseLegalDescription )
• LeaseSuspensionNotes ( type: esriFieldTypeString, alias: LeaseSuspensionNotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LeaseSuspensionNotes )
• LeaseStatusEffectiveDate ( type: esriFieldTypeDate, alias: LeaseStatusEffectiveDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LeaseStatusEffectiveDate )
• AuctionLandID ( type: esriFieldTypeInteger, alias: AuctionLandID, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandID )
• AuctionLandLegalDesription ( type: esriFieldTypeString, alias: AuctionLandLegalDesription, editable: true, nullable: true, length: 400, defaultValue: null, modelName: AuctionLandLegalDesription )
• AuctionLandAcres ( type: esriFieldTypeDouble, alias: AuctionLandAcres, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandAcres )
• AuctionLandCounty ( type: esriFieldTypeString, alias: AuctionLandCounty, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AuctionLandCounty )
• AuctionLandFundCode ( type: esriFieldTypeString, alias: AuctionLandFundCode, editable: true, nullable: true, length: 2, defaultValue: null, modelName: AuctionLandFundCode )
• SSALIDInAuctionLand ( type: esriFieldTypeString, alias: SSALIDInAuctionLand, editable: true, nullable: true, length: 400, defaultValue: null, modelName: SSALIDInAuctionLand )
• AuctionIDInAuctionLand ( type: esriFieldTypeInteger, alias: AuctionIDInAuctionLand, editable: true, nullable: true, defaultValue: null, modelName: AuctionIDInAuctionLand )
• BidderIDInAuctionLand ( type: esriFieldTypeInteger, alias: BidderIDInAuctionLand, editable: true, nullable: true, defaultValue: null, modelName: BidderIDInAuctionLand )
• AuctionLandBidPerAcre ( type: esriFieldTypeDouble, alias: AuctionLandBidPerAcre, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandBidPerAcre )
• AuctionLandCheckNumber ( type: esriFieldTypeString, alias: AuctionLandCheckNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AuctionLandCheckNumber )
• AuctionLandCheckAmount ( type: esriFieldTypeDouble, alias: AuctionLandCheckAmount, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandCheckAmount )
• AuctionLandRoyalty ( type: esriFieldTypeInteger, alias: AuctionLandRoyalty, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandRoyalty )
• AuctionLandIsWithdrawn ( type: esriFieldTypeSmallInteger, alias: AuctionLandIsWithdrawn, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandIsWithdrawn )
• AuctionLandWithdrawnBy ( type: esriFieldTypeInteger, alias: AuctionLandWithdrawnBy, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandWithdrawnBy )
• AuctionLandWithdrawnDate ( type: esriFieldTypeDate, alias: AuctionLandWithdrawnDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AuctionLandWithdrawnDate )
• AuctionLandParcelNumber ( type: esriFieldTypeInteger, alias: AuctionLandParcelNumber, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandParcelNumber )
• TransactionIDInAuctionLand ( type: esriFieldTypeInteger, alias: TransactionIDInAuctionLand, editable: true, nullable: true, defaultValue: null, modelName: TransactionIDInAuctionLand )
• AuctionLandFilingFee ( type: esriFieldTypeDouble, alias: AuctionLandFilingFee, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandFilingFee )
• AuctionLandAdvertisingFee ( type: esriFieldTypeDouble, alias: AuctionLandAdvertisingFee, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandAdvertisingFee )
• AuctionLandAdvancedRental ( type: esriFieldTypeDouble, alias: AuctionLandAdvancedRental, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandAdvancedRental )
• AuctionLandMinimumBonus ( type: esriFieldTypeDouble, alias: AuctionLandMinimumBonus, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandMinimumBonus )
• AuctionLandAdditionalBonus ( type: esriFieldTypeDouble, alias: AuctionLandAdditionalBonus, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandAdditionalBonus )
• AuctionLandMinimumDue ( type: esriFieldTypeDouble, alias: AuctionLandMinimumDue, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandMinimumDue )
• AuctionLandTotalDue ( type: esriFieldTypeDouble, alias: AuctionLandTotalDue, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandTotalDue )
• AuctionLandBidderTable ( type: esriFieldTypeString, alias: AuctionLandBidderTable, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AuctionLandBidderTable )
• NominationIDInAuctionLand ( type: esriFieldTypeInteger, alias: NominationIDInAuctionLand, editable: true, nullable: true, defaultValue: null, modelName: NominationIDInAuctionLand )
• AuctionLandProcessedAtAuction ( type: esriFieldTypeSmallInteger, alias: AuctionLandProcessedAtAuction, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandProcessedAtAuction )
• AuctionLandWellBoreBondAmount ( type: esriFieldTypeDouble, alias: AuctionLandWellBoreBondAmount, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandWellBoreBondAmount )
• AuctionLandNoBid ( type: esriFieldTypeSmallInteger, alias: AuctionLandNoBid, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandNoBid )
• LeaseIDInAuctionLand ( type: esriFieldTypeInteger, alias: LeaseIDInAuctionLand, editable: true, nullable: true, defaultValue: null, modelName: LeaseIDInAuctionLand )
• PaymentIDInAuctionLand ( type: esriFieldTypeInteger, alias: PaymentIDInAuctionLand, editable: true, nullable: true, defaultValue: null, modelName: PaymentIDInAuctionLand )
• AuctionLandIsLandValidated ( type: esriFieldTypeSmallInteger, alias: AuctionLandIsLandValidated, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandIsLandValidated )
• AuctionLandOwnershipPercentage ( type: esriFieldTypeDouble, alias: AuctionLandOwnershipPercentage, editable: true, nullable: true, defaultValue: null, modelName: AuctionLandOwnershipPercentage )
• LeaseStatusID ( type: esriFieldTypeInteger, alias: LeaseStatusID, editable: true, nullable: true, defaultValue: null, modelName: LeaseStatusID )
• LeaseStatusLabel ( type: esriFieldTypeString, alias: LeaseStatusLabel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeaseStatusLabel )
• LeaseStatusIsProducing ( type: esriFieldTypeSmallInteger, alias: LeaseStatusIsProducing, editable: true, nullable: true, defaultValue: null, modelName: LeaseStatusIsProducing )
• LeaseStatusIsActive ( type: esriFieldTypeSmallInteger, alias: LeaseStatusIsActive, editable: true, nullable: true, defaultValue: null, modelName: LeaseStatusIsActive )
• LeaseStatusModifiedDate ( type: esriFieldTypeDate, alias: LeaseStatusModifiedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LeaseStatusModifiedDate )
• LeaseRoyaltyID ( type: esriFieldTypeInteger, alias: LeaseRoyaltyID, editable: true, nullable: true, defaultValue: null, modelName: LeaseRoyaltyID )
• LeaseRoyaltyLabel ( type: esriFieldTypeString, alias: LeaseRoyaltyLabel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeaseRoyaltyLabel )
• LeaseRoyaltyRate ( type: esriFieldTypeDouble, alias: LeaseRoyaltyRate, editable: true, nullable: true, defaultValue: null, modelName: LeaseRoyaltyRate )
• LeaseSourceID ( type: esriFieldTypeInteger, alias: LeaseSourceID, editable: true, nullable: true, defaultValue: null, modelName: LeaseSourceID )
• LeaseSourceLabel ( type: esriFieldTypeString, alias: LeaseSourceLabel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeaseSourceLabel )
• LeaseSourceDescription ( type: esriFieldTypeString, alias: LeaseSourceDescription, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeaseSourceDescription )
• CompanyID ( type: esriFieldTypeInteger, alias: CompanyID, editable: true, nullable: true, defaultValue: null, modelName: CompanyID )
• CompanyName ( type: esriFieldTypeString, alias: CompanyName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CompanyName )
• CompanyAddress ( type: esriFieldTypeString, alias: CompanyAddress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CompanyAddress )
• CompanyCity ( type: esriFieldTypeString, alias: CompanyCity, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CompanyCity )
• CompanyStateCode ( type: esriFieldTypeString, alias: CompanyStateCode, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CompanyStateCode )
• CompanyZipCode ( type: esriFieldTypeString, alias: CompanyZipCode, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CompanyZipCode )
• CompanyEffectiveDate ( type: esriFieldTypeDate, alias: CompanyEffectiveDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CompanyEffectiveDate )
• CompanyEndDate ( type: esriFieldTypeDate, alias: CompanyEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CompanyEndDate )
• CompanyPhoneNumber ( type: esriFieldTypeString, alias: CompanyPhoneNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CompanyPhoneNumber )
• CompanyFaxNumber ( type: esriFieldTypeString, alias: CompanyFaxNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CompanyFaxNumber )
• AuctionID ( type: esriFieldTypeInteger, alias: AuctionID, editable: true, nullable: true, defaultValue: null, modelName: AuctionID )
• AuctionDate ( type: esriFieldTypeDate, alias: AuctionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AuctionDate )
• AuctionIsPublished ( type: esriFieldTypeSmallInteger, alias: AuctionIsPublished, editable: true, nullable: true, defaultValue: null, modelName: AuctionIsPublished )
• MineralTypeID ( type: esriFieldTypeInteger, alias: MineralTypeID, editable: true, nullable: true, defaultValue: null, modelName: MineralTypeID )
• MineralTypeLabel ( type: esriFieldTypeString, alias: MineralTypeLabel, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MineralTypeLabel )

Templates:

• Name: oslisde.OSLISDE.T_ActiveMineralLeaseLARCS
  Description:
  Prototype:
  MineralTypeID: null
  MineralTypeLabel: null
  ID: 0
  LeaseID: null
  LesseeCompanyIDInLease: null
  LeaseNumber: null
  LeaseIssueDate: null
  LeaseExpirationDate: null
  LeaseRentAmountPerAcre: null
  LeaseRoyaltyIDInLease: null
  MineralTypeIDInLease: null
  BasinCodeIDInLease: null
  GasPlantCodeIDInLease: null
  LeasePrimaryTermExpirationDate: null
  LeaseStateOwnershipPercentage: null
  LeaseSourceIDInLease: null
  SSALIDInLease: null
  LeaseFundCode: null
  LeaseCounty: null
  LeaseAcres: null
  LeaseLegalDescription: null
  LeaseSuspensionNotes: null
  LeaseStatusEffectiveDate: null
  AuctionLandID: null
  AuctionLandLegalDesription: null
  AuctionLandAcres: null
  AuctionLandCounty: null
  AuctionLandFundCode: null
  SSALIDInAuctionLand: null
  AuctionIDInAuctionLand: null
  BidderIDInAuctionLand: null
  AuctionLandBidPerAcre: null
  AuctionLandCheckNumber: null
  AuctionLandCheckAmount: null
  AuctionLandRoyalty: null
  AuctionLandIsWithdrawn: null
  AuctionLandWithdrawnBy: null
  AuctionLandWithdrawnDate: null
  AuctionLandParcelNumber: null
  TransactionIDInAuctionLand: null
  AuctionLandFilingFee: null
  AuctionLandAdvertisingFee: null
  AuctionLandAdvancedRental: null
  AuctionLandMinimumBonus: null
  AuctionLandAdditionalBonus: null
  AuctionLandMinimumDue: null
  AuctionLandTotalDue: null
  AuctionLandBidderTable: null
  NominationIDInAuctionLand: null
  AuctionLandProcessedAtAuction: null
  AuctionLandWellBoreBondAmount: null
  AuctionLandNoBid: null
  LeaseIDInAuctionLand: null
  PaymentIDInAuctionLand: null
  AuctionLandIsLandValidated: null
  AuctionLandOwnershipPercentage: null
  LeaseStatusID: null
  LeaseStatusLabel: null
  LeaseStatusIsProducing: null
  LeaseStatusIsActive: null
  LeaseStatusModifiedDate: null
  LeaseRoyaltyID: null
  LeaseRoyaltyLabel: null
  LeaseRoyaltyRate: null
  LeaseSourceID: null
  LeaseSourceLabel: null
  LeaseSourceDescription: null
  CompanyID: null
  CompanyName: null
  CompanyAddress: null
  CompanyCity: null
  CompanyStateCode: null
  CompanyZipCode: null
  CompanyEffectiveDate: null
  CompanyEndDate: null
  CompanyPhoneNumber: null
  CompanyFaxNumber: null
  AuctionID: null
  AuctionDate: null
  AuctionIsPublished: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata