In what jobs are tattoos and piercings inappropriate? Appropriate? Tolerated?

Where do you draw the line?

For the purposes of this question, please assume no racial or offensive subject tattoos. No tattoos above the collarbone.

For this question, for piercings, only ears, nose, cheeks, lip and eyebrow. Small gauges, limited to only one facial tattoo (unless both dimples).