Task 02 Term Standardization Lab Guide
📥 Lab input
- •
fragmented-terms.md(mixed terms spec)
💾 Lab output
- •
project-glossary.md(standard term dictionary)
1. Story and lab background
Late in the project, a strange conversation happens in a bug review meeting. The planner says "There's an error on the customer deletion screen," the API developer says "There was a Member referential integrity error when deleting from the User DB," and the front-end developer says "The admin page says client company."
When the plan (member), API spec (User), front-end screen (customer) and DB table (Member) use different words for one business domain like this, communication costs between developers grow and it breeds code rework.
In this lab, you'll learn to use Codex to survey scattered terms across all project docs and build a standard term dictionary (Glossary) that runs from planning all the way to DB variable names.
2. Learning goals
- Identify how domain terms are scattered across docs and design specs.
- Define the project's standard name and English abbreviation (domain standard name).
- Define a standard term dictionary that planners, developers and designers all follow.
- Use AI to map legacy words to variable names and data types.
🛠️ Follow-along lab guide
- Create the lab file: press the download button below and save
fragmented-terms.mdin theautomation/folder. - Hand standardization to Codex: send the **Codex request prompt** below in the Codex Client prompt box and build.
- Review the dictionary: check that scattered terms are correctly mapped to a standard name, standard English name and recommended DB column name.
Download lab materials
Codex request prompt
Task 02 Prompt
Analyze all the terms mixed across the project, like 'member/User/customer/Member' and 'counselor/Expert/teacher/Counselor', and write a project standard term dictionary as a Markdown table.
4. Example output
Codex analyzes the terms together and produces a normalized master dictionary like this.
| Standard name | Standard English name | Data type | Mixed words in use | Recommended DB column |
|---|---|---|---|---|
| General member | User | VARCHAR(50) | member, customer, Member, User | user_id |
| Professional counselor | Expert | VARCHAR(50) | counselor, teacher, Counselor, Expert | expert_id |
| Session booking | Reservation | VARCHAR(50) | booking, request, Book, Reservation | reservation_id |
| Booking status | ReservationStatus | VARCHAR(20) | status, type, Step, Status | res_status |