xpms.v_sheet_enumerations

Vista

The Playbook Enumerations sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_enumerations
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
record_id	xpms.canon_text	Sí	RECORD ID (column A), field.
department	xpms.canon_text	Sí	DEPARTMENT (column D), field.
category	xpms.canon_text	Sí	CATEGORY (column E), field.
sub_category	xpms.canon_text	Sí	SUB CATEGORY (column F), field.
enum_domain	xpms.canon_text	Sí	ENUM DOMAIN (column G), field.
enum_code	xpms.canon_text	Sí	ENUM CODE (column H), field.
enum_label	xpms.canon_text	Sí	ENUM LABEL (column I), field.
description	xpms.canon_text	Sí	DESCRIPTION (column J), field.
sort_order	numeric	Sí	SORT ORDER (column K), field.
color_code	xpms.canon_text	Sí	COLOR CODE (column L), field.
target_entity	xpms.canon_text	Sí	TARGET ENTITY (column M), field.
is_default	boolean	Sí	IS DEFAULT (column N), field.
status	xpms.canon_text	Sí	STATUS (column O), field.
flag	boolean	Sí	FLAG (column W), field.
notes	xpms.canon_text	Sí	NOTES (column X), field.
created_by	xpms.canon_text	Sí	CREATED BY (column Y), field.
created_at	timestamp without time zone	Sí	CREATED AT (column Z), field.
updated_at	timestamp without time zone	Sí	UPDATED AT (column AA), field.
organization	text	Sí	ORGANIZATION (column B), computed.
project	text	Sí	PROJECT (column C), computed.
workflow_status	text	Sí	Workflow Status (column P), computed.
incident_priority	text	Sí	Incident Priority (column Q), computed.
shift_and_timesheet_status	text	Sí	Shift & Timesheet Status (column R), computed.
clearance_tier	text	Sí	Clearance Tier (column S), computed.
commercial_state	text	Sí	Commercial State (column T), computed.
asset_condition	text	Sí	Asset Condition (column U), computed.
deployment_state	text	Sí	Deployment State (column V), computed.