Routine Parameters
Fact	GeneralType	GeneralSchema	GeneralObject	parameter_id	GeneralColumn	SQLServerType	is_nullable	is_output
18	P	dbo	uspGetBillOfMaterials	1	@StartProductID	int	True	False
18	P	dbo	uspGetBillOfMaterials	2	@CheckDate	datetime	True	False
18	P	dbo	uspGetEmployeeManagers	1	@BusinessEntityID	int	True	False
18	P	dbo	uspGetManagerEmployees	1	@BusinessEntityID	int	True	False
18	P	dbo	uspGetWhereUsedProductID	1	@StartProductID	int	True	False
18	P	dbo	uspGetWhereUsedProductID	2	@CheckDate	datetime	True	False
18	P	dbo	uspLogError	1	@ErrorLogID	int	True	True
18	P	dbo	uspSearchCandidateResumes	1	@searchString	nvarchar(1000)	True	False
18	P	dbo	uspSearchCandidateResumes	2	@useInflectional	bit	True	False
18	P	dbo	uspSearchCandidateResumes	3	@useThesaurus	bit	True	False
18	P	dbo	uspSearchCandidateResumes	4	@language	int	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	1	@BusinessEntityID	int	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	2	@JobTitle	nvarchar(0050)	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	3	@HireDate	datetime	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	4	@RateChangeDate	datetime	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	5	@Rate	money	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	6	@PayFrequency	tinyint	True	False
18	P	HumanResources	uspUpdateEmployeeHireInfo	7	@CurrentFlag	Flag	True	False
18	P	HumanResources	uspUpdateEmployeeLogin	1	@BusinessEntityID	int	True	False
18	P	HumanResources	uspUpdateEmployeeLogin	2	@OrganizationNode	hierarchyid	True	False
18	P	HumanResources	uspUpdateEmployeeLogin	3	@LoginID	nvarchar(0256)	True	False
18	P	HumanResources	uspUpdateEmployeeLogin	4	@JobTitle	nvarchar(0050)	True	False
18	P	HumanResources	uspUpdateEmployeeLogin	5	@HireDate	datetime	True	False
18	P	HumanResources	uspUpdateEmployeeLogin	6	@CurrentFlag	Flag	True	False
18	P	HumanResources	uspUpdateEmployeePersonalInfo	1	@BusinessEntityID	int	True	False
18	P	HumanResources	uspUpdateEmployeePersonalInfo	2	@NationalIDNumber	nvarchar(0015)	True	False
18	P	HumanResources	uspUpdateEmployeePersonalInfo	3	@BirthDate	datetime	True	False
18	P	HumanResources	uspUpdateEmployeePersonalInfo	4	@MaritalStatus	nchar(0001)	True	False
18	P	HumanResources	uspUpdateEmployeePersonalInfo	5	@Gender	nchar(0001)	True	False
18	FN	dbo	ufnGetDocumentStatusText	1	@Status	tinyint	True	False
18	FN	dbo	ufnGetProductDealerPrice	1	@ProductID	int	True	False
18	FN	dbo	ufnGetProductDealerPrice	2	@OrderDate	datetime	True	False
18	FN	dbo	ufnGetProductListPrice	1	@ProductID	int	True	False
18	FN	dbo	ufnGetProductListPrice	2	@OrderDate	datetime	True	False
18	FN	dbo	ufnGetProductStandardCost	1	@ProductID	int	True	False
18	FN	dbo	ufnGetProductStandardCost	2	@OrderDate	datetime	True	False
18	FN	dbo	ufnGetPurchaseOrderStatusText	1	@Status	tinyint	True	False
18	FN	dbo	ufnGetSalesOrderStatusText	1	@Status	tinyint	True	False
18	FN	dbo	ufnGetStock	1	@ProductID	int	True	False
18	FN	dbo	ufnLeadingZeros	1	@Value	int	True	False
18	TF	dbo	ufnGetContactInformation	1	@PersonID	int	True	False