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
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
PROGRAM | program | program | Text | The program of the fund used to pay the expenditure. |
INVOICE DATE | invoice_date | invoice_date | Calendar date | The date the invoice was issued to the City-Parish for processing and payment. |
CHECK NUMBER | check_number | check_number | Text | The numerical value of the check issued to pay the vendor for the expenditure. |
PROGRAM ID | program_id | program_id | Text | The numerical value of the program of the fund used to pay the expenditure. |
COMMODITY CODE | commodity_code | commodity_code | Text | Code classifying the type of good/service being purchased. |
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 |
INVOICE LINE ITEM DESCRIPTION | invoice_line_item_description | invoice_line_item_description | Text | A description of the specific expenditure for the corresponding invoice. |
ETHNICITY | ethnicity | ethnicity | Text | |
EXPENSE CATEGORY | expense_category | expense_category | Text | Description of the expenditure type. |
VENDOR NAME 2 | vendor_name_2 | vendor_name_2 | Text | Vendor doing business as (DBA) name |
VENDOR NAME 1 | vendor_name_1 | vendor_name_1 | Text | Vendor's primary business name |
SB VETERAN | sb_veteran | sb_veteran | Text | Small business veteran owned |
FUNCTION ID | function_id | function_id | Text | The numerical value of the function/purpose of the fund used to pay the expenditure. |
SB WOMAN | sb_woman | sb_woman | Text | Small business woman owned |
CHECK DATE | check_date | check_date | Calendar date | The date the check was issued to the vendor. |
INDEPENDENT CONTRACTOR | independent_contractor | independent_contractor | Text | |
INVOICE NUMBER | invoice_number | invoice_number | Text | The id associated with the vendor's invoice that itemizes justification for payment. |
DEPARTMENT ID | department_id | department_id | Text | The numerical value of the department under which the expenditure is authorized and recorded. |
SB DISABLED VET | sb_disabled_vet | sb_disabled_vet | Text | Small business disabled veteran |
FUNCTION | function | function | Text | The function/purpose of the fund used to pay the expenditure. |
SOURCE DOCUMENT TYPE | source_document_type | source_document_type | Text | P = Purchase Order; C = Contract |
DIVISION ID | division_id | division_id | Text | The numerical value 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 |
PURCHASING DEPARTMENT ID | purchasing_department_id | purchasing_department_id | Text | ID indicating the department making the purchase |
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. |
PURCHASING DEPARTMENT | purchasing_department | purchasing_department | Text | The department making the purchase |
FUND | fund | fund | Text | The budgetary name of the fund utilized to pay the expenditure. |
DEPARTMENT | department | department | Text | The name of the department under which the expenditure is authorized and recorded. |
DIVISION | division | division | Text | The name of the division (within the department) under which the expenditure is authorized and recorded. |
SUBPROGRAM ID | subprogram_id | subprogram_id | Text | The numerical value of the subprogram of the fund used to pay the expenditure. |
INVOICE LINE ITEM AMOUNT | invoice_line_item_amount | invoice_line_item_amount | Number | The total value requested for payment through the invoice. |
VENDOR ZIP | vendor_zip | vendor_zip | 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. |
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)). |
FUND ID | fund_id | fund_id | Text | The numerical value of the fund utilized to pay the expenditure. |
LINE NUMBER | line_number | line_number | Text | Line number of the specific expenditure for the corresponding invoice. |
SUBPROGRAM | subprogram | subprogram | Text | The subprogram of the fund used to pay the expenditure. |
SOURCE DOCUMENT DESCRIPTION | source_document_description | source_document_description | Text | A description of the purchase order or contract. |
JOURNAL ENTRY PERIOD | journal_entry_period | journal_entry_period | Text | The month in which the expenditure was recorded. |
COMMODITY DESCRIPTION | commodity_description | commodity_description | Text | Description classifying the type of good/service being purchased. |
VENDOR STATE | vendor_state | vendor_state | Text | |
VENDOR CITY | vendor_city | vendor_city | Text | |
YEAR | year | year | Text | The year in which the expenditure was recorded. |
Upstream Metadata