Name: CIP Expenditures
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

CIP Expenditures

CIP Expenditures. Monthly Data Extract from FAMIS - Financial Accounting Management Information System. Coded fields may require further analysis to interpret
Organization: State of Hawaii
Last updated: 2024-04-10T22:45:04.694790
Tags: dags, famis

Tables

Table 1

@usgov.state_of_hawaii_cip_expenditures.table_1

135.58 KB
2893 rows
37 columns


CREATE TABLE table_1 (
  "document_type" VARCHAR,
  "encumbrance_type" VARCHAR,
  "reporting_program" VARCHAR,
  "appropriation_type" VARCHAR,
  "mode_of_funding" VARCHAR,
  "transaction_code" VARCHAR,
  "division" VARCHAR,
  "fund" VARCHAR,
  "fiscal_year" BIGINT,
  "appropriation_account" BIGINT,
  "department" VARCHAR,
  "source_object" BIGINT,
  "cost_center" VARCHAR,
  "project" VARCHAR,
  "active" VARCHAR,
  "amount" DOUBLE,
  "encumbrance_number" VARCHAR,
  "encumbrance_number_suffix" VARCHAR,
  "vendor_number" VARCHAR,
  "vendor_name" VARCHAR,
  "invoice_number" VARCHAR,
  "check_number" VARCHAR,
  "check_date" VARCHAR,
  "cvn" VARCHAR,
  "department_vn" VARCHAR,
  "document_number" VARCHAR,
  "fm" BIGINT,
  "enc_fm" VARCHAR,
  "transaction_fiscal_year" BIGINT,
  "processing_year" BIGINT,
  "process_month" BIGINT,
  "process_date" BIGINT,
  "transaction_id" VARCHAR,
  "aging_start_date" DOUBLE,
  "optional_department_data" VARCHAR,
  "invoice_date" DOUBLE,
  "d11_vf_1099_ind" VARCHAR
);