app.role_library
TableRow level security on
The org's job descriptions per canon role: its editable copy of the Roles Library (xpms.role, decision D12). Role codes stay canon; the org edits the title and the description. One row per role, kept when removed, so adopting again never brings it back.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.References app.organizations.id |
| role_code | text | No | Canon role code (xpms.role) the row describes.References xpms.role.role_code |
| job_title | text | No | The org's job title for the role. |
| job_summary | text | Yes | Summary of the job. |
| key_responsibilities | text | Yes | Key responsibilities. |
| qualifications | text | Yes | Qualifications. |
| physical_requirements | text | Yes | Physical requirements. |
| required_certifications | text | Yes | Certifications the role requires. |
| default_clearance_tier | text | Yes | Clearance tier the role usually carries. |
| default_radio_channel | text | Yes | Radio channel the role usually monitors. |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |