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 |