City-Parish Expenditures

data.brla.gov | Last Updated 2 Jan 2019

This expenditures dataset includes a listing and description of City-Parish department-level spending. Data is captured from January 1, 2018 to present as any data prior to this date resides in multiple disparate systems in various formats, which were subsequently streamlined through the implementation of the City-Parish's enterprise resource planning system financial module in late 2017. 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.

Tags: expenditures, checkbook, open checkbook, open checkbook br, spending, expenses

This dataset has the following 55 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
YEARyeartextThe year in which the expenditure was recorded.
FUND IDfund_idtextThe numerical value of the fund utilized to pay the expenditure.
FUNDfundtextThe budgetary name of the fund utilized to pay the expenditure.
DEPARTMENT IDdepartment_idtextThe numerical value of the department under which the expenditure is authorized and recorded.
DEPARTMENTdepartmenttextThe name of the department under which the expenditure is authorized and recorded.
FUNCTION IDfunction_idtextThe numerical value of the function/purpose of the fund used to pay the expenditure.
FUNCTIONfunctiontextThe function/purpose of the fund used to pay the expenditure.
DIVISION IDdivision_idtextThe numerical value of the division (within the department) under which the expenditure is authorized and recorded.
DIVISIONdivisiontextThe name of the division (within the department) under which the expenditure is authorized and recorded.
PROGRAM IDprogram_idtextThe numerical value of the program of the fund used to pay the expenditure.
PROGRAMprogramtextThe program of the fund used to pay the expenditure.
SUBPROGRAM IDsubprogram_idtextThe numerical value of the subprogram of the fund used to pay the expenditure.
SUBPROGRAMsubprogramtextThe subprogram of the fund used to pay the expenditure.
JOURNAL ENTRY PERIODjournal_entry_periodtextThe month in which the expenditure was recorded.
INVOICE STATUSinvoice_statustextStatus of the invoice P = Paid or V = Voided
CHECK NUMBERcheck_numbertextThe numerical value of the check issued to pay the vendor for the expenditure.
CHECK DATEcheck_datecalendar_dateThe date the check was issued to the vendor.
INVOICE NUMBERinvoice_numbertextThe id associated with the vendor's invoice that itemizes justification for payment.
LINE NUMBERline_numbertextLine number of the specific expenditure for the corresponding invoice.
INVOICE DATEinvoice_datecalendar_dateThe date the invoice was issued to the City-Parish for processing and payment.
INVOICE LINE ITEM AMOUNTinvoice_line_item_amountnumberThe total value requested for payment through the invoice.
INVOICE LINE ITEM DESCRIPTIONinvoice_line_item_descriptiontextA description of the specific expenditure for the corresponding invoice.
SOURCE DOCUMENT NUMBERsource_document_numbertextThe purchase order or contract number of the document used to procure the goods or services.
SOURCE DOCUMENT TYPEsource_document_typetextP = Purchase Order; C = Contract
SOURCE DOCUMENT DESCRIPTIONsource_document_descriptiontextA description of the purchase order or contract.
EXPENSE CATEGORY IDexpense_category_idtextThe numerical value of the expenditure type used to track and classify types of expenditures within the City-Parish financial system.
EXPENSE CATEGORYexpense_categorytextDescription of the expenditure type.
PURCHASING DEPARTMENT IDpurchasing_department_idtextID indicating the department making the purchase
PURCHASING DEPARTMENTpurchasing_departmenttextThe department making the purchase
COMMODITY CODEcommodity_codetextCode classifying the type of good/service being purchased.
COMMODITY DESCRIPTIONcommodity_descriptiontextDescription classifying the type of good/service being purchased.
PAYMENT TYPEpayment_typetextType of payment used to pay the vendor (Check, Wire or ACI (P-Cards)).
PAYMENT STATUSpayment_statustextStatus of payment (Cleared and Not Cleared).
VENDOR NAME 1vendor_name_1textVendor's primary business name
VENDOR NAME 2vendor_name_2textVendor doing business as (DBA) name
VENDOR CITYvendor_citytext
VENDOR STATEvendor_statetext
VENDOR ZIPvendor_ziptext
VENDOR TYPEvendor_typetextIndicates the type of business the vendor is in
GENDERgendertext
ETHNICITYethnicitytext
STATUSstatustextVendor's status A=Active, B=Bidder, I=Inactive, O=One Time Pay, S=Stop, T=Temporary, S=Self Service
CLASSclasstextThe vendor's classification (LLC, Corporation, Sole Proprietor, etc)
GEOGRAPHIC AREAgeographic_areatextGeographic area of vendor (INP=In EBR Parish, INS=In State, USA=In Country, INTL=International
INDEPENDENT CONTRACTORindependent_contractortext
MINORITYminoritytextIs the vendor a minority business enterprise
DISADVANTAGEDdisadvantagedtextDisadvantaged business enterprise
DISABLED VETERANdisabled_veterantextDisabled veteran business enterprise
SB DISABLED VETsb_disabled_vettextSmall business disabled veteran
SB MINORITYsb_minoritytextSmall business minority owned
SB MINORITY WOMANsb_minority_womantextSmall business minority woman owned
SB NON-MINORITYsb_non_minoritytextSmall business non-minority owned
SB DISADVANTAGEDsb_disadvantagedtextSmall business disadvantaged business enterprise
SB VETERANsb_veterantextSmall business veteran owned
SB WOMANsb_womantextSmall business woman owned