xpms.dim_team
TablaSeguridad a nivel de fila activa
Canon teams (Bible tab 08). A team is a tag that rolls up to a department, never a tree level.
Clave primaria: team_id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| team_id | xpms.canon_code | No | Team code DDDD-Tnn. |
| team | xpms.canon_text | No | Team label. |
| dept_code | xpms.canon_code | No | Department the team rolls up to.Hace referencia a xpms.dim_department.dept_code |
| workgroup_tag | xpms.canon_text | Sí | WORKGROUP TAG from the Playbook Teams sheet. |
| lead_role | xpms.canon_text | Sí | LEAD ROLE from the Playbook Teams sheet. |
| responsibilities | xpms.canon_text | Sí | RESPONSIBILITIES from the Playbook Teams sheet. |
| source_row | integer | Sí | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Sí | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Sí | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Sí | CREATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |
| source_updated_at | timestamp without time zone | Sí | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |