Offline, your PS3 sign-in ID is used. Online, your PSN ID is used.
I have lots of accounts on my PS3, so they tend to be the same as the PSN ID of that account to save mix-ups. I imagine many people are the same and thus wouldn't notice this distinction.