A reference table of job titles
Table of Contents
This page is a capture in the inbox bucket of the product backlog — a pre-sprint idea, not yet pulled into a sprint as a story.
1. What
Add a table of job titles. A job title is an entity that a person selects from a list. It is not free text.
The entity has a code, a name and a description. An account refers to a job title by key, in place of the job_title text column. The screens show the field as a list. The existing titles in the Acme account data become rows of the table.
2. Why
Today job_title is a nullable free-text column on the accounts table. Free text gives spelling variants, so the same title appears in many forms. A report cannot group by title, and a screen cannot offer a list to choose from.
3. References
projects/ores.sql/create/iam/iam_accounts_create.sql, thejob_titlecolumn.projects/ores.sql/populate/acme/, the account data that holds the current titles.