brla-gov/purchase-orders-and-contracts-2ung-w7t4

 
External

Purchase Orders and Contracts

  • contracts
  • procurement
  • purchase orders
  • purchasing

Purchase Orders and Contracts

Listing of all purchase orders and contracts issued to procure goods and/or services within City-Parish.

In the City-Parish, a PO/Contract is made up of two components: a header and one or many detail items that comprise the overarching PO/Contract. The header contains information that pertains to the entire PO/Contract. This includes, but is not limited to, the total amount of the PO/Contract, the department requesting the purchase and the vendor providing the goods or services. The detail item(s) contain information that is specific to the individual item ordered or service procured through the PO/Contract. The item/service description, item/service quantity and the cost of the item is located within the PO/Contract details. There may be one or many detail items on an individual PO/Contract. For example, a Purchase Order for a computer equipment may include three items: the computer, the monitor and the base software package.

Both header information and detail item information are included in this dataset in order to provide a comprehensive view of the PO/Contract data. The Record Type field indicates whether the record is a header record (H) or detail item record (D). In the computer purchase example from above, the system would display 4 records – one header record and 3 detail item records.

It should be noted header information will be duplicated on all detail items. No detail item information will be displayed on the header record.

***In October of 2017, the City-Parish switched to a new system used to track PO/Contracts. This data contains all PO/Contracts entered in or after October 2017. For prior year data, please see the Legacy Purchase Order dataset https://data.brla.gov/Government/Legacy-Purchase-Orders/54bn-2sqf

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
SB MINORITYsmb_minsmb_minTextSmall business minority owned
SOURCE DOCUMENT TYPEsource_doc_typesource_doc_typeTextCode representing the type of PO/Contract P = Purchase Order, C = Contract
DEPARTMENT NUMBERdept_numdept_numNumberNumber of the department which the PO/Contract is for
DOCUMENT STATUS CODEsource_doc_status_codesource_doc_status_codeNumberCode indicating the status of the PO/Contract.
DOCUMENT STATUS DESCRIPTIONsource_doc_status_descriptionsource_doc_status_descriptionTextDescription of the status of the PO/Contract.
VENDOR STATEvendor_statevendor_stateText
VENDOR ZIPvendor_zipvendor_zipText
GENDERvendor_gendervendor_genderText
ETHNICITYvendor_ethnicityvendor_ethnicityText
STATUSvendor_statusvendor_statusTextVendor's status A=Active, B=Bidder, I=Inactive, O=One Time Pay, S=Stop, T=Temporary, S=Self Service
CLASSvendor_classvendor_classTextThe vendor's classification (LLC, Corporation, Sole Proprietor, etc)
GEOGRAPHIC AREAvendor_geographic_codevendor_geographic_codeTextGeographic area of vendor (INP=In EBR Parish, INS=In State, USA=In Country, INTL=International
INDEPENDENT CONTRACTORvendor_independent_contractorvendor_independent_contractorTextWhether or not the vendor is an independent contractor
MINORITYisminorityisminorityTextIs the vendor a minority business enterprise
DISABLED VETERANdvbedvbeTextDisabled veteran business enterprise
SB DISABLED VETdvsedvseTextSmall business disabled veteran
SB MINORITY WOMANsmb_mn_womsmb_mn_womTextSmall business minority woman owned
SB NON-MINORITYsb_non_mnsb_non_mnTextSmall business non-minority owned
SB VETERANvet_sm_busvet_sm_busTextSmall business veteran owned
SB WOMANsmb_womansmb_womanTextSmall business woman owned
ITEM TOTAL COSTitem_total_costitem_total_costNumberTotal (extended) cost of the PO/Contract line item being ordered.
COMMODITY CODEcommodity_codecommodity_codeTextCode classifying the type of good/service being purchased.
COMMODITY DESCRIPTIONcommodity_desccommodity_descTextDescription classifying the type of good/service being purchased.
ITEM UNIT OF MEASUREitem_unit_of_meaitem_unit_of_meaTextCode indicating Unit of Measure for this PO/Contract line item.
ITEM QUANTITY ORDEREDitem_quantity_ordereditem_quantity_orderedNumberQuantity being ordered for this PO/Contract line item.
ITEM DESCRIPTIONitem_descriptionitem_descriptionTextDescription of good or service being ordered on this PO/Contract line item.
ITEM NUMBERitem_numberitem_numberNumberSequential number of the detail PO/Contract line item.
VENDOR TYPEvendor_typevendor_typeTextIndicates the type of business the vendor is in.
VENDOR CITYvendor_cityvendor_cityText
VENDOR NAME 1vendor_name_1vendor_name_1TextVendor's primary business name
ANNUAL CONTRACTannual_contractannual_contractTextFor PO only, the annual contract this PO was purchased from
EXTENSION DATEextended_through_dateextended_through_dateCalendar dateFor contracts only, date contract has been extended
EXPIRATION DATEinitial_expiration_dateinitial_expiration_dateCalendar dateFor contracts only, expected date for work to end
START DATEestimated_start_dateestimated_start_dateCalendar dateFor contracts only, estimated date for work to begin
DEPARTMENT NAMEdept_namedept_nameTextDepartment name which the PO/Contract is for
DOCUMENT DESCRIPTIONsource_doc_descsource_doc_descTextDescription of the good/service being procured.
DOCUMENT NUMBERsource_documentsource_documentNumberNumeric ID of the PO/Contract
ITEM UNIT COSTitem_unit_costitem_unit_costNumberUnit Cost for this PO/Contract line item.
VENDOR NAME 2vendor_name_2vendor_name_2TextVendor doing business as (DBA) name
COST CENTER NAMEcost_center_namecost_center_nameTextDescription of Cost Center of the Department which the PO/Contract is for. This will often show which of the Department's Divisions issued the PO/Contract
DOCUMENT TYPE CODEsource_doc_type_codesource_doc_type_codeTextCode indicating the type of PO/Contract.
REQUISITION NUMBERrequisition_norequisition_noNumberRequisition number used for purchase.
VOUCHED AMOUNTvouched_amountvouched_amountNumberActual amount invoiced against PO/Contract. This amount may be less than the original PO/Contract amount.
INPUT DATEinput_dateinput_dateCalendar dateDate PO/Contract was entered into the system
TOTAL AMOUNTtotal_amounttotal_amountNumberTotal amount of PO/Contract
DOCUMENT TYPE DESCRIPTIONsource_doc_type_descriptionsource_doc_type_descriptionTextDescription of the type of PO/Contract.
DISADVANTAGEDdbedbeTextDisadvantaged business enterprise
RECORD TYPErecord_typerecord_typeTextH or D. H indicates record is a header record. D indicates a detail record. A PO/Contract will have 1 header record and at least 1 detail item
TOTAL ITEMStotal_itemstotal_itemsNumberTotal number of detail items on PO/Contract. Each PO/Contract will have at least 1 detail item.
SB DISADVANTAGEDsmb_dbesmb_dbeTextSmall business disadvantaged business enterprise
COST CENTERcost_centercost_centerNumberCost Center of the Department which the PO/Contract is for. This will often show which of the Department's Divisions issued the PO/Contract
EXPENSE TYPE DESCRIPTIONobject_descobject_descTextThe description of the type of expense for this good/service.
EXPENSE TYPEobjectobjectTextThe code indicating the type of expense for this good/service.

Upstream Metadata