brla-gov/cityparish-expenditures-vwa8-ps2a

 
External

City-Parish Expenditures

  • checkbook
  • expenditures
  • expenses
  • open checkbook
  • open checkbook br
  • And 1 more...

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

Upstream Metadata