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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| PAYMENT STATUS | payment_status | payment_status | Text | Status of payment (Cleared and Not Cleared). |
| SB VETERAN | sb_veteran | sb_veteran | Text | Small business veteran owned |
| INDEPENDENT CONTRACTOR | independent_contractor | independent_contractor | Text | |
| SB DISABLED VET | sb_disabled_vet | sb_disabled_vet | Text | Small business disabled veteran |
| YEAR | year | year | Text | The year in which the expenditure was recorded. |
| SOURCE DOCUMENT TYPE | source_document_type | source_document_type | Text | P = Purchase Order; C = Contract |
| PAYMENT TYPE | payment_type | payment_type | Text | Type of payment used to pay the vendor (Check, Wire or ACI (P-Cards)). |
| GENDER | gender | gender | Text | |
| STATUS | status | status | Text | Vendor's status A=Active, B=Bidder, I=Inactive, O=One Time Pay, S=Stop, T=Temporary, S=Self Service |
| CLASS | class | class | Text | The vendor's classification (LLC, Corporation, Sole Proprietor, etc) |
| GEOGRAPHIC AREA | geographic_area | geographic_area | Text | Geographic area of vendor (INP=In EBR Parish, INS=In State, USA=In Country, INTL=International |
| MINORITY | minority | minority | Text | Is the vendor a minority business enterprise |
| DISADVANTAGED | disadvantaged | disadvantaged | Text | Disadvantaged business enterprise |
| DISABLED VETERAN | disabled_veteran | disabled_veteran | Text | Disabled veteran business enterprise |
| SB MINORITY | sb_minority | sb_minority | Text | Small business minority owned |
| SB MINORITY WOMAN | sb_minority_woman | sb_minority_woman | Text | Small business minority woman owned |
| SB NON-MINORITY | sb_non_minority | sb_non_minority | Text | Small business non-minority owned |
| SB DISADVANTAGED | sb_disadvantaged | sb_disadvantaged | Text | Small business disadvantaged business enterprise |
| DIVISION ID | division_id | division_id | Text | The numerical value of the division (within the department) under which the expenditure is authorized and recorded. |
| JOURNAL ENTRY PERIOD | journal_entry_period | journal_entry_period | Text | The month in which the expenditure was recorded. |
| VENDOR NAME 1 | vendor_name_1 | vendor_name_1 | Text | Vendor's primary business name |
| VENDOR TYPE | vendor_type | vendor_type | Text | Indicates the type of business the vendor is in |
| SUBPROGRAM | subprogram | subprogram | Text | The subprogram of the fund used to pay the expenditure. |
| CHECK DATE | check_date | check_date | Calendar date | The date the check was issued to the vendor. |
| DIVISION | division | division | Text | The name of the division (within the department) under which the expenditure is authorized and recorded. |
| PURCHASING DEPARTMENT | purchasing_department | purchasing_department | Text | The department making the purchase |
| INVOICE DATE | invoice_date | invoice_date | Calendar date | The date the invoice was issued to the City-Parish for processing and payment. |
| VENDOR ZIP | vendor_zip | vendor_zip | Text | |
| VENDOR CITY | vendor_city | vendor_city | Text | |
| EXPENSE CATEGORY ID | expense_category_id | expense_category_id | Text | The numerical value of the expenditure type used to track and classify types of expenditures within the City-Parish financial system. |
| FUND | fund | fund | Text | The budgetary name of the fund utilized to pay the expenditure. |
| FUNCTION | function | function | Text | The function/purpose of the fund used to pay the expenditure. |
| PROGRAM | program | program | Text | The program of the fund used to pay the expenditure. |
| INVOICE NUMBER | invoice_number | invoice_number | Text | The id associated with the vendor's invoice that itemizes justification for payment. |
| INVOICE LINE ITEM AMOUNT | invoice_line_item_amount | invoice_line_item_amount | Number | The total value requested for payment through the invoice. |
| INVOICE LINE ITEM DESCRIPTION | invoice_line_item_description | invoice_line_item_description | Text | A description of the specific expenditure for the corresponding invoice. |
| SOURCE DOCUMENT DESCRIPTION | source_document_description | source_document_description | Text | A description of the purchase order or contract. |
| EXPENSE CATEGORY | expense_category | expense_category | Text | Description of the expenditure type. |
| COMMODITY DESCRIPTION | commodity_description | commodity_description | Text | Description classifying the type of good/service being purchased. |
| VENDOR NAME 2 | vendor_name_2 | vendor_name_2 | Text | Vendor doing business as (DBA) name |
| VENDOR STATE | vendor_state | vendor_state | Text | |
| INVOICE STATUS | invoice_status | invoice_status | Text | Status of the invoice P = Paid or V = Voided |
| PURCHASING DEPARTMENT ID | purchasing_department_id | purchasing_department_id | Text | ID indicating the department making the purchase |
| COMMODITY CODE | commodity_code | commodity_code | Text | Code classifying the type of good/service being purchased. |
| SB WOMAN | sb_woman | sb_woman | Text | Small business woman owned |
| PROGRAM ID | program_id | program_id | Text | The numerical value of the program of the fund used to pay the expenditure. |
| CHECK NUMBER | check_number | check_number | Text | The numerical value of the check issued to pay the vendor for the expenditure. |
| DEPARTMENT ID | department_id | department_id | Text | The numerical value of the department under which the expenditure is authorized and recorded. |
| SOURCE DOCUMENT NUMBER | source_document_number | source_document_number | Text | The purchase order or contract number of the document used to procure the goods or services. |
| FUND ID | fund_id | fund_id | Text | The numerical value of the fund utilized to pay the expenditure. |
| SUBPROGRAM ID | subprogram_id | subprogram_id | Text | The numerical value of the subprogram of the fund used to pay the expenditure. |
| LINE NUMBER | line_number | line_number | Text | Line number of the specific expenditure for the corresponding invoice. |
| ETHNICITY | ethnicity | ethnicity | Text | |
| DEPARTMENT | department | department | Text | The name of the department under which the expenditure is authorized and recorded. |
| FUNCTION ID | function_id | function_id | Text | The numerical value of the function/purpose of the fund used to pay the expenditure. |