POC.dbo

Parameters

Name	Type	Mode

Definition

CREATE PROCEDURE GetLookupValues_sp

AS
BEGIN
	
	SET NOCOUNT ON;
	-- Custom
	Select '[Custom] Patient Status' AS DataSet, statusID, statusName from dbo.PatientStatus
	Select '[Custom] Pay Source' AS DataSet, SourceID, SourceName from  dbo.PaymentSource_vw
	Select '[Custom] Roles' AS DataSet, RoleId, RoleName from  dbo.Roles
	Select '[Custom] Groups' AS DataSet, GroupId, GroupName from dbo.Groups WHERE ISNULL(DeleteBy, 0) = 0
	Select '[Custom] Regions' AS DataSet, pkRegionID, RegionName from  dbo.Regions
	Select '[Custom] Language' AS DataSet, LangID, LangDesc from  dbo.Language
	Select '[Custom] Outside Source' AS DataSet, SourceID, IDNum, CompanyName from  dbo.OutsideSource WHERE ISNULL(IsDeleted, 0) = 0
	Select '[Custom] Agency Site' AS DataSet, SiteID, SiteName from  dbo.AgencySite
	Select '[Custom] Case Category' AS DataSet, CaseID, CaseDesc from  dbo.CaseCategory
	Select '[Custom] Location' AS DataSet, PkLocationID, LocationCode, Location from  dbo.Locations Where ISNULL(Deleted, 0) = 0

--Static
	Select '[Static] Service' AS DataSet, ServiceTypeID, ServiceType, ServiceDesc from  ics2.dbo.ServiceType
	Select '[Static] Modifier' AS DataSet, ModifierID, ModifierName, ModifierDes from  ics2.dbo.Modifier
	Select '[Static] Procedure' AS DataSet, ProcCodeID, Code, CodeDesc from  ics2.dbo.ProcCode
	Select '[Static] StatusType' AS DataSet, StatusID, StatusCode from  ics2.dbo.StatusType
	Select '[Static] RuleError' AS DataSet, RuleID, RuleDescription from  ics2.dbo.RuleError
	Select '[Static] ProgramType' AS DataSet, ProgramID, ProgramName from  Ics2.dbo.ProgramType
	Select '[Static] ClaimType' AS DataSet, ClaimTypeID, ClaimTypeName from  Ics2.dbo.ClaimType


END