Name: CWSRF_July242024_ExportTable

Display Field: Borrower_Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• EPA_Tracking_No (type: esriFieldTypeString, alias: EPA Tracking No, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Borrower_Name (type: esriFieldTypeString, alias: Borrower Name, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• State_Tracking_Number (type: esriFieldTypeString, alias: State Tracking Number, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Type_of_Assistance (type: esriFieldTypeString, alias: Type of Assistance, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Supplemental_Appropriation (type: esriFieldTypeString, alias: Supplemental Appropriation, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Latest_Agreement_Action (type: esriFieldTypeString, alias: Latest Agreement Action, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Initial_Agreement_Date (type: esriFieldTypeDate, alias: Initial Agreement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Initial_Agreement_Amount (type: esriFieldTypeDouble, alias: Initial Agreement Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date_of_Latest_Agreement_Action (type: esriFieldTypeDate, alias: Date of Latest Agreement Action, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Current_Agreement_Amount (type: esriFieldTypeDouble, alias: Current Agreement Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Annual_Interest_Rate____ (type: esriFieldTypeDouble, alias: Annual Interest Rate (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Annual_Fee_Rate____ (type: esriFieldTypeDouble, alias: Annual Fee Rate (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Annual_Finance_Charge____ (type: esriFieldTypeDouble, alias: Annual Finance Charge (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Upfront_Fees (type: esriFieldTypeDouble, alias: Upfront Fees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Repayment_Period__Years_ (type: esriFieldTypeDouble, alias: Repayment Period (Years), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Includes_Additional_Subsidy_ (type: esriFieldTypeString, alias: Includes Additional Subsidy?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Additional_Subsidy_Amount (type: esriFieldTypeDouble, alias: Additional Subsidy Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Green_Project_Reserve__GPR__Tot (type: esriFieldTypeDouble, alias: Green Project Reserve (GPR) Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hardship_Disadvantaged_Communit (type: esriFieldTypeString, alias: Hardship/Disadvantaged Community?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Programmatic_Finance_ (type: esriFieldTypeString, alias: Programmatic Finance?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Sponsorship_Lending_ (type: esriFieldTypeString, alias: Sponsorship Lending?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Sponsorship_Lending__Implementi (type: esriFieldTypeString, alias: Sponsorship Lending: Implementing Partner, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Conduit_Finance_ (type: esriFieldTypeString, alias: Conduit Finance?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Subagreements_To_Date (type: esriFieldTypeDouble, alias: Subagreements To Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Non_SRF_Co_funding (type: esriFieldTypeDouble, alias: Total Non-SRF Co-funding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_SRF_Co_funding___Federal (type: esriFieldTypeDouble, alias: Non-SRF Co-funding - Federal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_SRF_Co_funding___State (type: esriFieldTypeDouble, alias: Non-SRF Co-funding - State, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_SRF_Co_funding___Local (type: esriFieldTypeDouble, alias: Non-SRF Co-funding - Local, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Project_Name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Project_Description (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 32767, nullable: true, editable: true)
• Project_Needs_Categories (type: esriFieldTypeString, alias: Project Needs Categories, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• NPDES_Permit_Number (type: esriFieldTypeString, alias: NPDES Permit Number, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Population_Served_by_Project (type: esriFieldTypeDouble, alias: Population Served by Project, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Project_Start (type: esriFieldTypeDate, alias: Project Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Project_Completion_Date (type: esriFieldTypeDate, alias: Project Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Affected_Waterbody_Designation (type: esriFieldTypeString, alias: Affected Waterbody Designation, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• CWA_Compliance_Objective (type: esriFieldTypeString, alias: CWA Compliance Objective, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Designated_Water_Use___Protect (type: esriFieldTypeString, alias: Designated Water Use - Protect, SQL Type: sqlTypeOther, length: 32767, nullable: true, editable: true)
• Designated_Water_Use___Restore (type: esriFieldTypeString, alias: Designated Water Use - Restore, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Improvement_or_Maintenance_of_R (type: esriFieldTypeString, alias: Improvement or Maintenance of Receiving Waterbody?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Linked_Assistance_Agreement_ (type: esriFieldTypeString, alias: Linked Assistance Agreement?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Linked_Assistance_Agreement___S (type: esriFieldTypeString, alias: Linked Assistance Agreement - State Tracking Number, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• HUC_12 (type: esriFieldTypeString, alias: HUC 12, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• Fund_Method_for_Filter (type: esriFieldTypeString, alias: Fund Method for Filter, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)

Templates:

Name: CWSRF_July242024_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/11/2024 5:47:34 AM

Schema Last Edit Date: 12/11/2024 5:47:34 AM

Data Last Edit Date: 7/24/2024 1:45:57 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat