Thanks for both of your replies. As a newbie I don't know how to reply to you individually. But here goes. I have Charles Patrick in every census record from 1861 to 1901. In 1901, he was living in Riccarton with the family and was employed as a "jobing flesher" (butcher). BTW, he was supporting a large household of a wife and 10 children at the time.
I also have his death record and the cause was "cerebral hemorrhage." I guess this could have been a stroke - but maybe he could have suffered a fall. There is one story from a cousin of mine suggesting that he had fallen out of a second story window! But did a fall (and resulting injury) land him at the Poorhouse in 1906 - or did a fall occur while institutionalized at the Poorhouse in 1912 and cause his death? Plus, I don't know if the story is true!
I appreciate the tips on the National Archives in Edinburgh and the Burns Center in Kilmarnock but I am in the U.S. and that is a wee bit difficult to get there. On the other hand, I will check the website about workhouses. Thanks for your replies!