Table Detail Report

PULSE_GEN_SET_CHAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Channel Settings
Definition: Contains information about lead voltage channel settings for a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SET_CHAN


Column Name Type Null? Definition
CHAMBER_CD DOUBLE N Defines which chamber of the heart this channel is located. If this channel is a high voltage channel, this value will be zero.
HVCHAN_IND DOUBLE N One if this channel is a high voltage channel. Zero otherwise.
PACING_AMPLITUDE_VALUE DOUBLE N The pacing output amplitude in volts. If this channel is a high voltage channel, this value will be zero.
PACING_CAPTURE_MODE_CD DOUBLE N The method the device uses for managing pacing capture. If this channel is a high voltage channel, this value will be zero.
PACING_POLARITY_CD DOUBLE N The indication of unipolar or bipolar configuration for pacing. If this channel is a high voltage channel, this value will be zero.
PACING_PULSEWIDTH_VALUE DOUBLE N The pacing output pulse width in milliseconds. If this channel is a high voltage channel, this value will be zero.
PULSE_GEN_SET_CHAN_ID DOUBLE N PRIMARY KEY
PULSE_GEN_SET_ID DOUBLE N The pulse generator setting associated with this channel setting
SENSING_ADAPTATION_MODE_CD DOUBLE N Specifies whether the sensitivity is fixed or adapting. If this channel is a high voltage channel, this value will be zero.
SENSING_POLARITY_CD DOUBLE N The indication of unipolar or bipolar configuration for sensing. If this channel is a high voltage channel, this value will be zero.
SENSING_SENSITIVITY_VALUE DOUBLE N The smallest electrical signal programmed to be detected by the device's sensing circuitry in millivolts. If this channel is a high voltage channel, this value will be zero.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PULSE_GEN_SET_CHAN


Child Column in PULSE_GEN_SET_CHAN(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_SET_ID PULSE_GEN_SET PULSE_GEN_SET_ID




Parent Column in PULSE_GEN_SET_CHAN (PK) Child Table Name Child Column Name
Children: PULSE_GEN_SET_CHAN_ID PULSE_GEN_SET_NODE PULSE_GEN_SET_CHAN_ID


PULSE_GEN_SET_CRT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator CRT Setting
Definition: Contains information about CRT settings for a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SET_CRT


Column Name Type Null? Definition
LVRV_DELAY_VAL DOUBLE Y The time between the LV and RV pacing pulses in milliseconds
PACED_CHAMBERS_CD DOUBLE N The ventricular chambers paced during CRT pacing
PULSE_GEN_SET_CRT_ID DOUBLE N PRIMARY KEY
PULSE_GEN_SET_ID DOUBLE N The pulse generator setting associated with this channel setting
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PULSE_GEN_SET_CRT


Child Column in PULSE_GEN_SET_CRT(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_SET_ID PULSE_GEN_SET PULSE_GEN_SET_ID


PULSE_GEN_SET_MAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Magnet Settings
Definition: Contains information about magnet settings for a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SET_MAG


Column Name Type Null? Definition
MAGNET_RESPONSE VARCHAR(100) Y A description of how the device responds to a magnet
PULSE_GEN_SET_ID DOUBLE N The pulse generator setting associated with this magnet setting
PULSE_GEN_SET_MAG_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PULSE_GEN_SET_MAG


Child Column in PULSE_GEN_SET_MAG(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_SET_ID PULSE_GEN_SET PULSE_GEN_SET_ID


PULSE_GEN_SET_NODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Node
Definition: Contains information about a pulse generator lead channel anode or cathode
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SET_NODE


Column Name Type Null? Definition
ELECTRODE_1_CD DOUBLE N Defines the type of electrode for the node
ELECTRODE_2_CD DOUBLE N Defines the type of electrode for the node
ELECTRODE_3_CD DOUBLE N Defines the type of electrode for the node
LOCATION_1_CD DOUBLE N Defines the location of the node
LOCATION_2_CD DOUBLE N Defines the location of the node
LOCATION_3_CD DOUBLE N Defines the location of the node
NODE_FUNCTION_CD DOUBLE N Whether this node is a sensing or a pacing node
NODE_TYPE_CD DOUBLE N Whether this node is an anode or a cathode
PULSE_GEN_SET_CHAN_ID DOUBLE N The channel setting associated with this node
PULSE_GEN_SET_NODE_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PULSE_GEN_SET_NODE


Child Column in PULSE_GEN_SET_NODE(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_SET_CHAN_ID PULSE_GEN_SET_CHAN PULSE_GEN_SET_CHAN_ID


PULSE_GEN_SET_SHOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Shock Zone Settings
Definition: Contains information about shock zone settings for a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SET_SHOCK


Column Name Type Null? Definition
PULSE_GEN_SET_SHOCK_ID DOUBLE N PRIMARY KEY
PULSE_GEN_SET_ZONE_ID DOUBLE N The pulse generator zone setting ID associated with this shock zone
SHOCK_CNT DOUBLE Y The maximum number of shocks set to be delivered at the given shock energy
SHOCK_ENERGY_AMT DOUBLE Y The shock energy delivered at a particular sequence of a zone therapy in joules
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
ZONE_SEQ DOUBLE Y The sequence number for this shock setting, from 1 to 10



Relationship Detail - PULSE_GEN_SET_SHOCK


Child Column in PULSE_GEN_SET_SHOCK(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_SET_ZONE_ID PULSE_GEN_SET_ZONE PULSE_GEN_SET_ZONE_ID