brla-gov/cityparish-expenditures-vwa8-ps2a

  • checkbook
  • expenditures
  • expenses
  • open checkbook
  • open checkbook br
  • + 1

City-Parish Expenditures

City-Parish Expenditures

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
PAYMENT STATUSpayment_statuspayment_statusTextStatus of payment (Cleared and Not Cleared).
SB VETERANsb_veteransb_veteranTextSmall business veteran owned
INDEPENDENT CONTRACTORindependent_contractorindependent_contractorText
SB DISABLED VETsb_disabled_vetsb_disabled_vetTextSmall business disabled veteran
YEARyearyearTextThe year in which the expenditure was recorded.
SOURCE DOCUMENT TYPEsource_document_typesource_document_typeTextP = Purchase Order; C = Contract
PAYMENT TYPEpayment_typepayment_typeTextType of payment used to pay the vendor (Check, Wire or ACI (P-Cards)).
GENDERgendergenderText
STATUSstatusstatusTextVendor's status A=Active, B=Bidder, I=Inactive, O=One Time Pay, S=Stop, T=Temporary, S=Self Service
CLASSclassclassTextThe vendor's classification (LLC, Corporation, Sole Proprietor, etc)
GEOGRAPHIC AREAgeographic_areageographic_areaTextGeographic area of vendor (INP=In EBR Parish, INS=In State, USA=In Country, INTL=International
MINORITYminorityminorityTextIs the vendor a minority business enterprise
DISADVANTAGEDdisadvantageddisadvantagedTextDisadvantaged business enterprise
DISABLED VETERANdisabled_veterandisabled_veteranTextDisabled veteran business enterprise
SB MINORITYsb_minoritysb_minorityTextSmall business minority owned
SB MINORITY WOMANsb_minority_womansb_minority_womanTextSmall business minority woman owned
SB NON-MINORITYsb_non_minoritysb_non_minorityTextSmall business non-minority owned
SB DISADVANTAGEDsb_disadvantagedsb_disadvantagedTextSmall business disadvantaged business enterprise
DIVISION IDdivision_iddivision_idTextThe numerical value of the division (within the department) under which the expenditure is authorized and recorded.
JOURNAL ENTRY PERIODjournal_entry_periodjournal_entry_periodTextThe month in which the expenditure was recorded.
VENDOR NAME 1vendor_name_1vendor_name_1TextVendor's primary business name
VENDOR TYPEvendor_typevendor_typeTextIndicates the type of business the vendor is in
SUBPROGRAMsubprogramsubprogramTextThe subprogram of the fund used to pay the expenditure.
CHECK DATEcheck_datecheck_dateCalendar dateThe date the check was issued to the vendor.
DIVISIONdivisiondivisionTextThe name of the division (within the department) under which the expenditure is authorized and recorded.
PURCHASING DEPARTMENTpurchasing_departmentpurchasing_departmentTextThe department making the purchase
INVOICE DATEinvoice_dateinvoice_dateCalendar dateThe date the invoice was issued to the City-Parish for processing and payment.
VENDOR ZIPvendor_zipvendor_zipText
VENDOR CITYvendor_cityvendor_cityText
EXPENSE CATEGORY IDexpense_category_idexpense_category_idTextThe numerical value of the expenditure type used to track and classify types of expenditures within the City-Parish financial system.
FUNDfundfundTextThe budgetary name of the fund utilized to pay the expenditure.
FUNCTIONfunctionfunctionTextThe function/purpose of the fund used to pay the expenditure.
PROGRAMprogramprogramTextThe program of the fund used to pay the expenditure.
INVOICE NUMBERinvoice_numberinvoice_numberTextThe id associated with the vendor's invoice that itemizes justification for payment.
INVOICE LINE ITEM AMOUNTinvoice_line_item_amountinvoice_line_item_amountNumberThe total value requested for payment through the invoice.
INVOICE LINE ITEM DESCRIPTIONinvoice_line_item_descriptioninvoice_line_item_descriptionTextA description of the specific expenditure for the corresponding invoice.
SOURCE DOCUMENT DESCRIPTIONsource_document_descriptionsource_document_descriptionTextA description of the purchase order or contract.
EXPENSE CATEGORYexpense_categoryexpense_categoryTextDescription of the expenditure type.
COMMODITY DESCRIPTIONcommodity_descriptioncommodity_descriptionTextDescription classifying the type of good/service being purchased.
VENDOR NAME 2vendor_name_2vendor_name_2TextVendor doing business as (DBA) name
VENDOR STATEvendor_statevendor_stateText
INVOICE STATUSinvoice_statusinvoice_statusTextStatus of the invoice P = Paid or V = Voided
PURCHASING DEPARTMENT IDpurchasing_department_idpurchasing_department_idTextID indicating the department making the purchase
COMMODITY CODEcommodity_codecommodity_codeTextCode classifying the type of good/service being purchased.
SB WOMANsb_womansb_womanTextSmall business woman owned
PROGRAM IDprogram_idprogram_idTextThe numerical value of the program 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.
DEPARTMENT IDdepartment_iddepartment_idTextThe numerical value of the department under which the expenditure is authorized and recorded.
SOURCE DOCUMENT NUMBERsource_document_numbersource_document_numberTextThe purchase order or contract number of the document used to procure the goods or services.
FUND IDfund_idfund_idTextThe numerical value of the fund utilized to pay the expenditure.
SUBPROGRAM IDsubprogram_idsubprogram_idTextThe numerical value of the subprogram of the fund used to pay the expenditure.
LINE NUMBERline_numberline_numberTextLine number of the specific expenditure for the corresponding invoice.
ETHNICITYethnicityethnicityText
DEPARTMENTdepartmentdepartmentTextThe name of the department under which the expenditure is authorized and recorded.
FUNCTION IDfunction_idfunction_idTextThe numerical value of the function/purpose of the fund used to pay the expenditure.

Upstream Metadata