LOINC Code 38196-2 : Appearance of Blood

No Database Connections Available for "PublishCode" (used: InUse 10 of 10: PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 83303 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 160800 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 165473 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 82465 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 778ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 47155 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 723ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 146828 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 608ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 94824 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 461ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 93247 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 258ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 82787 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 63ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 78574 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey))