brla-gov/open-checkbook-br-7qhq-wwsg

 
External

Open Checkbook BR

  • checkbook
  • expenditures
  • open checkbook br

Open Checkbook BR

Dataset used to support the Open Checkbook BR web portal (http://checkbook.brla.gov). This data set contains department level City-Parish spending. Some expenditures are not included as they are not tied to a particular department.

In an effort to protect certain information telephone numbers and account numbers are masked with X's. Also, the Check Number field only includes the last 4 digits of the check number.

To see all expenditures please visit the City-Parish Expenditures data set (https://data.brla.gov/Government/City-Parish-Expenditures/vwa8-ps2a)

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
DEPARTMENT IDseg2seg2TextThe numerical value of the department under which the expenditure is authorized and recorded.
VENDOR ZIPvendor_zipvendor_zipTextThe invoice of the vendor paid through the corresponding invoice.
VENDOR NAMEvendor_namevendor_nameTextThe name of the vendor paid through the corresponding invoice.
EXPENSE CATEGORYobject_descobject_descTextDescription of the expenditure type.
SOURCE DOCUMENT DESCRIPTIONsource_doc_descsource_doc_descTextA description of the purchase order or contract.
SOURCE DOCUMENT NUMBERsource_documentsource_documentTextThe purchase order or contract number of the document used to procure the goods or services.
INVOICE LINE ITEM AMOUNTline_item_amountline_item_amountNumberThe total value requested for payment through the invoice.
INVOICE DATEinvoice_dateinvoice_dateCalendar dateThe date the invoice was issued to the City-Parish for processing and payment.
CHECK DATEcheck_datecheck_dateCalendar dateThe date the check was issued to the vendor.
JOURNAL ENTRY PERIODjrnl_entry_perjrnl_entry_perNumberThe month in which the expenditure was recorded.
DIVISIONdivisiondivisionTextThe name of the division (within the department) under which the expenditure is authorized and recorded.
DEPARTMENTdepartmentdepartmentTextThe name of the department under which the expenditure is authorized and recorded.
FUNDfundfundTextThe budgetary name of the fund utilized to pay the expenditure.
FUND IDseg1seg1NumberThe numerical value of the fund utilized to pay the expenditure.
EXPENSE CATEGORY IDobjectobjectNumberThe numerical value of the expenditure type used to track and classify types of expenditures within the City-Parish financial system.
INVOICE LINE ITEM DESCRIPTIONline_item_descline_item_descTextA description of the specific expenditure for the corresponding invoice.
LINE NUMBERline_numberline_numberNumberLine number of the specific expenditure for the corresponding invoice.
COMMODITY CODEcommodity_codecommodity_codeTextStandard classification codes (NIGP Codes) for products and services used to detail where money is spent within the City-Parish.
FUNCTIONfunctionfunctionTextThe function/purpose of the fund used to pay the expenditure.
CHECK NUMBERcheck_numbercheck_numberTextThe numerical value of the check issued to pay the vendor for the expenditure.
INVOICE NUMBERinvoice_numberinvoice_numberTextThe id associated with the vendor's invoice that itemizes justification for payment.
PAYMENT TYPEpayment_typepayment_typeTextType of payment used to pay the vendor (Check, Wire or ACI (P-Cards)).
COMMODITY CODE DESCRIPTIONcommodity_desccommodity_descTextStandard classification for products and services used to detail where money is spent within the City-Parish.
SOURCE DOCUMENT TYPEsource_doc_typesource_doc_typeTextP = Purchase Order; C = Contract
INVOICE STATUSinvoice_statusinvoice_statusTextStatus of the invoice P = Paid or V = Voided
FUNCTION IDseg3seg3TextThe numerical value of the function/purpose of the fund used to pay the expenditure.
YEARjrnl_entry_yearjrnl_entry_yearNumberThe year in which the expenditure was recorded.
PAYMENT STATUSpayment_statuspayment_statusTextStatus of payment (Cleared and Not Cleared).
DIVISION IDseg4seg4TextThe numerical value of the division (within the department) under which the expenditure is authorized and recorded.

Upstream Metadata