Goods & Services (Goods) Dataset

Data Wrangling Project

vw_ACRE_GoodsAndServices_Goods - Sample Output

This view contains the following columns, pulling data from all Goods & Services transactions that have Goods or Services within them.

  • ServiceID
  • ReasonForService
  • OrganizationID
  • ServiceProvider
  • ClientID
  • ClientName
  • TransactionDate
  • ProgramID (if there is more than one Program, this will display "-1")
  • Program (if there is more than one Program, this will display "Multiple")
  • GoodsID
  • GoodsInTransaction
  • GoodsType
  • NoOfUnits
  • UnitType
  • UnitPrice
  • UnitCost
  • UserID
  • StaffName

Documentation

vw_ACRE_GoodsAndServices_Goods - Sample Output