"datahub-usac/erate-request-for-discount-on-services-frn-status-qdmp-ygft:latest"."erate_request_for_discount_on_services_frn_status"

SELECT
    ":id", -- Socrata column ID
    "award_date", -- The date the contract was awarded by the applicant to service provider.
    "fcdl_comment_frn", -- Explanation of FCDL decision at the FRN level. MR: management reason; CR: cancelled reason; DR: denial reason.
    "organization_entity_type_name", -- Applicant's organization type. 
    "is_based_on_state_master_contract", -- Indicates whether the contract for the FRN is based on a state master contract.  
    "balloon_payment_desc", -- Balance due payment made at the end of the financing period for fiber installation.
    "spac_filed", -- Indicates if an FCC Form 473 Service Provider Annual Certification (SPAC) was filed for the Funding Year associated with the FCC Form 471.
    "fcdl_comment_app", -- Explanation of FCDL decision at the form level. MR: management reason; CR: cancelled reason; DR: denial reason.
    "number_of_terms", -- Number of months for financing related to fiber FRNs.
    "invoicing_mode", -- Type of invoice to be processed for FRN (SPI: Service Provider Invoice – FCC Form 474, BEAR: Billed Entity Applicant Reimbursement Form – FCC Form 472, or NOT SET (when no form has been received yet for the FY and therefore no invoicing mode has been set).
    "is_multiple_award", -- Indicates whether a Funding Request is tied to a contract with a multiple award schedule.
    "post_commitment_rationale", -- Explanation for the funding request decision made for a post commitment transaction. 
    "form_471_frn_fiber_type_name", -- Fiber type for fiber FRNs including Lit Fiber, Dark Fiber, or Self Provisioned Fiber. 
    "is_certified_in_window", -- Indicates whether the application has been certified in the window.
    "source_of_matching_funds_desc", -- Funding source when the applicant is seeking a state match for fiber FRNs.  The E-rate program will provide additional Category One funding (up to 10%) to match state funding for special construction to connect schools and libraries to high-speed broadband services that meet the FCC's long-term capacity broadband goals. 
    "revised_fcdl_comment", -- Explanation of RFCDL decision at the form level.
    "form_471_service_type_name", -- FRN service type including voice, data transmission and/or Internet access, basic maintenance of internal connections, internal connections, or managed internal broadband services.
    "invoicing_ready", -- Invoicing may begin for the FRN as there is an approved FCC Form 486.
    "epc_contract_restriction_type_name", -- Type of restriction that enable applicants to make pricing information confidential such as State Law or Statute, Local Rule, Court Order, Contract Executed with Restrictive Terms.  
    "total_proj_plant_route_feet", -- Total distance between a demark point at an applicant’s location and a service provider’s switching facility or point of presence measured in feet. 
    "total_strands_qty", -- Number of actual glass optical fibers inside the cable sheath. 
    "form_471_frn_status_name", -- Status of the funding request. It includes pending, funded, denied or cancelled. 
    "restriction_citation", -- Reference to a local law or contract to support pricing confidentiality requests.
    "has_voluntary_extension", -- Indicates whether the contact has voluntary extensions that can be exercised by the applicant for the FRN.
    "was_fcc_form_470_posted", -- Indicates whether an FCC Form 470 was posted for the services/products associated with the FRN.
    "form_version", -- Indicates whether the form version of the application is "current" or "original." It can be used to aggregate the data between current and original applications. "Current" is the view of the form processed by USAC. "Original" is the view of the form originally submitted by the applicant upon certification.
    "bid_count", -- Number of bids received by the applicant from service providers in the competitive bidding process.
    "epc_organization_id", -- A unique nine-digit number assigned to identify the service provider.
    "remaining_extension_count", -- Remaining number of contract extensions for the FRN.
    "total_remaining_months_count", -- Number of months left on the contract for the FRN.
    "pricing_confidentiality", -- Indicates whether the FRN pricing must be kept confidential and not disclosed to the public. 
    "months_of_service", -- Number of months a service is provided during a funding year for an FRN based on the service start date and end date. 
    "total_pre_discount_eligible_one_time_costs", -- Total pre-discount eligible non-recurring/one-time charges of a funding request. 
    "form_471_frn_fiber_sub_type_name", -- Fiber subtypes for fiber FRNs.  Options include maintenance and operation, network equipment, network equipment and maintenance, or special construction.
    "is_lease", -- Indicates whether FRN is for leased dark fiber or IRU (Indefensible Right of Use). 
    "annual_interest_rate", -- Annual Interest Rate Associated with a Fiber Application.
    "wave_sequence_number", -- A number that indicates which wave sequence the funding commitment was issued in. 
    "total_authorized_disbursement", -- Total net amount disbursed to a service provider or applicant. 
    "funding_year", -- Funding year for the application.
    "contract_type_name", -- Contract type for the FRN including Month-to-Month, Contract or Tariff. 
    "sc_rate", -- Percentage of discount that is matched by USAC for fiber FRNs under the state matching provision.
    "appeal_wave_number", -- A number that indicates which appeal wave the revised funding decision was issued in.
    "form_486_no", -- Unique # assigned to the FCC Form 486
    "funding_request_number", -- Unique funding request number associated with the FCC Form 471.
    "f486_case_status", -- Form status for the FCC Form 486 including:- Approved: FCC Form 486 and FRN is approved so invoicing may begin- Partially Approved: FCC Form 486 and FRN is partially approved so invoicing may begin for those FRNs approved.
    "revised_fcdl_date", -- Date the applicant FCDL was revised
    "nickname", -- Nickname given to an FRN by an applicant when filling their FCC Form 471.
    "old_470_number", -- FCC Form 470 application number for the FRN submitted in the legacy system (FY2015 and earlier).
    "service_delivery_deadline", -- Services must be installed or product must be delivered on or before this date.
    "old_funding_request_number", -- Funding Request Number from a previous fund year that is related to the FRN.
    "total_ineligible_one_time_costs", -- Total ineligible one-time costs for the FRN level. 
    "state_tribe_match_amt", -- Program provides 1 to 1 dollar match amount in extra Category One fiber special construction funding up to an additional ten percent discount.
    "actual_start_date", -- Service start date from the approved FCC Form 486. Further updates to the service start date are not reflected in this field.
    "fcdl_letter_date", -- The date of the wave that a funding commitment was issued in.  
    "application_number", -- Unique application number is generated at the time an applicant begins to file FCC Form 471. Applicants can request funding for multiple services under the same application number. 
    "state", -- Applicant's state.
    "ben", -- Unique number assigned to the billed entity/ applicant.
    "organization_name", -- Applicant organization name.
    "cnct_email", -- Email Address of the main contact provided by the applicant on the FCC Form 471.
    "contract_number", -- Contract number for the FRN. It can used to filter records related to a specific contract number.
    "establishing_form_470", -- FCC Form 470 application number for the FRN submitted in EPC (FY2016 and later).
    "extended_expiration_date", -- Contract expiration date for contracts that can be extended.
    "account_number", -- Billing account number for the billed entity.
    "spin_name", -- Service provider name for the FRN. 
    "service_start_date", -- Current start date of services on FCC Form 471. Updates to the service start date will be reflected in this field. Service start dates impact commitment amounts because they adjust the months of services.
    "contract_expiration_date", -- Contract expiration date for the FRN. If the FRN is for a tariff or month-to-month service this field displays the service end date. This field can be used to filter the 471 applications that have active contracts.
    "narrative", -- Narrative for the FRN describing the products and services. 
    "total_monthly_recurring_cost", -- Total pre-discount monthly recurring charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type, status or entities. This field should not be used to generate metrics at FRN line item level.   
    "total_monthly_recurring_ineligible_costs", -- Total pre-discount ineligible monthly recurring charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level.   
    "total_monthly_recurring_eligible_costs", -- Total pre-discount eligible monthly recurring charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level.   
    "total_pre_discount_eligible_recurring_costs", -- Total pre-discounted eligible recurring charges of a funding request. It is derived by multiplying the month of service and the pre-discounted monthly recurring charges. 
    "total_one_time_costs", -- Total one-time/non-recurring charge of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level.   
    "total_pre_discount_costs", -- Total pre-discount charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level.   
    "dis_pct", -- Discount rate applied to service or equipment for the FRN.
    "funding_commitment_request", -- The total amount for the Funding Request (FRN) after discount.
    "avg_cost_per_ft_of_plant", -- Average cost of cabling, infrastructure, and associated hardware divided by the total project plant route feet.  
    "eligible_strands_qty", -- Number of eligible fiber strands.
    "total_financed_amt", -- Amount financed for fiber FRNs.
    "pending_reason", -- Indicates the review status of the Funding request. Pending Reason is limited to Current (Committed) forms.  
    "last_date_to_invoice", -- Last date an Invoice (BEAR or SPI) can be received or postmarked
    "user_generated_fcdl_date" -- Date a user associated with the BEN clicked on the file in the Newsfeed in EPC to generate the FCDL
FROM
    "datahub-usac/erate-request-for-discount-on-services-frn-status-qdmp-ygft:latest"."erate_request_for_discount_on_services_frn_status"
LIMIT 100;

sgr mount socrata \
  "datahub-usac/erate-request-for-discount-on-services-frn-status-qdmp-ygft" \
  --handler-options '{
    "domain": "datahub.usac.org",
    "tables": {
        "erate_request_for_discount_on_services_frn_status": "qdmp-ygft"
    }
}'