brla-gov/cityparish-expenditures-vwa8-ps2a
Icon for Socrata external plugin
 
Preview
  • cityparish_expenditures
     
 
Readme
Updated 11 hours ago
Indexed 4 hours ago

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
PROGRAMprogramprogramTextThe program of the fund used to pay the expenditure.
INVOICE DATEinvoice_dateinvoice_dateCalendar dateThe date the invoice was issued to the City-Parish for processing and payment.
CHECK NUMBERcheck_numbercheck_numberTextThe numerical value of the check issued to pay the vendor for the expenditure.
PROGRAM IDprogram_idprogram_idTextThe numerical value of the program of the fund used to pay the expenditure.
COMMODITY CODEcommodity_codecommodity_codeTextCode classifying the type of good/service being purchased.
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
INVOICE LINE ITEM DESCRIPTIONinvoice_line_item_descriptioninvoice_line_item_descriptionTextA description of the specific expenditure for the corresponding invoice.
ETHNICITYethnicityethnicityText
EXPENSE CATEGORYexpense_categoryexpense_categoryTextDescription of the expenditure type.
VENDOR NAME 2vendor_name_2vendor_name_2TextVendor doing business as (DBA) name
VENDOR NAME 1vendor_name_1vendor_name_1TextVendor's primary business name
SB VETERANsb_veteransb_veteranTextSmall business veteran owned
FUNCTION IDfunction_idfunction_idTextThe numerical value of the function/purpose of the fund used to pay the expenditure.
SB WOMANsb_womansb_womanTextSmall business woman owned
CHECK DATEcheck_datecheck_dateCalendar dateThe date the check was issued to the vendor.
INDEPENDENT CONTRACTORindependent_contractorindependent_contractorText
INVOICE NUMBERinvoice_numberinvoice_numberTextThe id associated with the vendor's invoice that itemizes justification for payment.
DEPARTMENT IDdepartment_iddepartment_idTextThe numerical value of the department under which the expenditure is authorized and recorded.
SB DISABLED VETsb_disabled_vetsb_disabled_vetTextSmall business disabled veteran
FUNCTIONfunctionfunctionTextThe function/purpose of the fund used to pay the expenditure.
SOURCE DOCUMENT TYPEsource_document_typesource_document_typeTextP = Purchase Order; C = Contract
DIVISION IDdivision_iddivision_idTextThe numerical value 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
PURCHASING DEPARTMENT IDpurchasing_department_idpurchasing_department_idTextID indicating the department making the purchase
SOURCE DOCUMENT NUMBERsource_document_numbersource_document_numberTextThe purchase order or contract number of the document used to procure the goods or services.
PURCHASING DEPARTMENTpurchasing_departmentpurchasing_departmentTextThe department making the purchase
FUNDfundfundTextThe budgetary name of the fund utilized to pay the expenditure.
DEPARTMENTdepartmentdepartmentTextThe name of the department under which the expenditure is authorized and recorded.
DIVISIONdivisiondivisionTextThe name of the division (within the department) under which the expenditure is authorized and recorded.
SUBPROGRAM IDsubprogram_idsubprogram_idTextThe numerical value of the subprogram of the fund used to pay the expenditure.
INVOICE LINE ITEM AMOUNTinvoice_line_item_amountinvoice_line_item_amountNumberThe total value requested for payment through the invoice.
VENDOR ZIPvendor_zipvendor_zipText
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.
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)).
FUND IDfund_idfund_idTextThe numerical value of the fund utilized to pay the expenditure.
LINE NUMBERline_numberline_numberTextLine number of the specific expenditure for the corresponding invoice.
SUBPROGRAMsubprogramsubprogramTextThe subprogram of the fund used to pay the expenditure.
SOURCE DOCUMENT DESCRIPTIONsource_document_descriptionsource_document_descriptionTextA description of the purchase order or contract.
JOURNAL ENTRY PERIODjournal_entry_periodjournal_entry_periodTextThe month in which the expenditure was recorded.
COMMODITY DESCRIPTIONcommodity_descriptioncommodity_descriptionTextDescription classifying the type of good/service being purchased.
VENDOR STATEvendor_statevendor_stateText
VENDOR CITYvendor_cityvendor_cityText
YEARyearyearTextThe year in which the expenditure was recorded.
Upstream Metadata