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