drh_vw_orchestration_deidentify

Column	Type
orchestration_session_exec_id	VARCHAR
exec_nature	TEXT
session_id	VARCHAR
session_entry_id	VARCHAR
parent_exec_id	VARCHAR
namespace	TEXT
exec_identity	TEXT
exec_code	TEXT
exec_status	INTEGER
input_text	TEXT
exec_error_text	TEXT
output_text	TEXT
output_nature	TEXT
narrative_md	TEXT
device_id	VARCHAR
orchestration_nature_id	TEXT
version	TEXT
orch_started_at	TIMESTAMPTZ
orch_finished_at	TIMESTAMPTZ
args_json	TEXT
diagnostics_json	TEXT
diagnostics_md	TEXT

SQL DDL

CREATE VIEW drh_vw_orchestration_deidentify AS
SELECT
    osex.orchestration_session_exec_id,
    osex.exec_nature,
    osex.session_id,
    osex.session_entry_id,
    osex.parent_exec_id,
    osex.namespace,
    osex.exec_identity,
    osex.exec_code,
    osex.exec_status,
    osex.input_text,
    osex.exec_error_text,
    osex.output_text,
    osex.output_nature,
    osex.narrative_md,    
    os.device_id,
    os.orchestration_nature_id,
    os.version,
    os.orch_started_at,
    os.orch_finished_at,    
    os.args_json,
    os.diagnostics_json,
    os.diagnostics_md
FROM
    orchestration_session_exec osex
    JOIN orchestration_session os ON osex.session_id = os.orchestration_session_id
WHERE
    os.orchestration_nature_id = 'deidentification'