Firstly I'm open to suggestions if people have better solutions or ideas. I would like to be able to create a list with a 'username' field that will pull additional fields from the information stored in the User Profile Service.
People picker columns do offer some of the information I want but not the users picture or other fields I would like to use. The other benefit of a BCS connection is that it will use the 'username' set in the first field and pull through other columns of information based on that first field. Additionally it would update when they or we update their profile.
Is it possible to connect to BCS to the information stored in the User Profile Service?