Goods & Services (Merged) Dataset

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")
• AssistanceType
  
• AssistanceProvided
  
• AssistanceInTransaction
  
• Minutes
  
• NoOfUnits
  
• UnitPrice
  
• UnitCost
  
• UserID
  
• StaffName

Documentation

• vw_ACRE_GoodsAndServices_Merged - Sample Data.csv
• vw_ACRE_GoodsAndServices_Merged - Schema.csv