Table Detail Report
PULSE_GEN_SET_TACHY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Tachycardia Settings |
Definition: | Contains information about Tachycardia settings for a pulse generator |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_SET_TACHY
Column Name | Type | Null? | Definition |
---|---|---|---|
ASTAT_CD | DOUBLE | N | The high level programmed status for atrial tachy therapies |
PULSE_GEN_SET_ID | DOUBLE | N | The pulse generator setting associated with this channel setting |
PULSE_GEN_SET_TACHY_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. |
VSTAT_CD | DOUBLE | N | The high level programmed status for ventricular tachy therapies |
Relationship Detail - PULSE_GEN_SET_TACHY
Child Column in PULSE_GEN_SET_TACHY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_SET_ID | PULSE_GEN_SET | PULSE_GEN_SET_ID |
PULSE_GEN_SET_ZONE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Zone Settings |
Definition: | Contains information about zone settings for a pulse generator |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_SET_ZONE
Column Name | Type | Null? | Definition |
---|---|---|---|
DETECTION_BEATS_DEN | DOUBLE | Y | The denominator portion of the tachy detection ratio in heartbeats |
DETECTION_BEATS_NUM | DOUBLE | Y | The numerator portion of the tachy detection ratio in heartbeats |
DETECTION_DETAILS | VARCHAR(50) | Y | A text describing arrhythmia detection details |
DETECTION_INTERVAL | DOUBLE | Y | The upper interval limit of the zone for tachy therapy detection in milliseconds |
PULSE_GEN_SET_ID | DOUBLE | N | The pulse generator setting associated with this channel setting |
PULSE_GEN_SET_ZONE_ID | DOUBLE | N | PRIMARY KEY |
STATUS_CD | DOUBLE | N | The status of the zone, whether it is is active or not |
TYPE_CD | DOUBLE | N | The general type of the zone for tachy therapy detection |
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. |
VENDOR_TYPE_CD | DOUBLE | N | The vendor specific type of the zone for tachy therapy detection |
Relationship Detail - PULSE_GEN_SET_ZONE
Child Column in PULSE_GEN_SET_ZONE(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_ZONE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PULSE_GEN_SET_ZONE_ID | PULSE_GEN_ATP | PULSE_GEN_SET_ZONE_ID |
PULSE_GEN_SET_SHOCK | PULSE_GEN_SET_ZONE_ID |
PULSE_GEN_STAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Statistic |
Definition: | Contains the start and end date and time of a pulse generator statistic |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_STAT
Column Name | Type | Null? | Definition |
---|---|---|---|
END_DT_TM | DATETIME | Y | The date and time that this statistic ended |
PULSE_GEN_ID | DOUBLE | N | The pulse generator associated with this pulse generator statistic |
PULSE_GEN_STAT_ID | DOUBLE | N | PRIMARY KEY |
START_DT_TM | DATETIME | Y | The date and time that this statistic began |
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_STAT
Child Column in PULSE_GEN_STAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_ID | PULSE_GEN | PULSE_GEN_ID |
Parent Column in PULSE_GEN_STAT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PULSE_GEN_STAT_ID | PULSE_GEN_STAT_AT | PULSE_GEN_STAT_ID |
PULSE_GEN_STAT_BRADY | PULSE_GEN_STAT_ID | ||
PULSE_GEN_STAT_CRT | PULSE_GEN_STAT_ID | ||
PULSE_GEN_STAT_HR | PULSE_GEN_STAT_ID | ||
PULSE_GEN_STAT_TACHY | PULSE_GEN_STAT_ID |
PULSE_GEN_STAT_AT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Atrial Tachyarrhythmia Statistics |
Definition: | Contains statistics from a single Atrial Tachyarrhythmia event |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_STAT_AT
Column Name | Type | Null? | Definition |
---|---|---|---|
BURDEN_PERCENT | DOUBLE | Y | The percent of time in AT AF per day |
MODE_SW_COUNT | DOUBLE | Y | The number of mode switches |
MODE_SW_COUNT_PER_DAY | DOUBLE | Y | The average number of mode switches per day |
MODE_SW_MAX_DURATION | DOUBLE | Y | The maximum contiguous time the device is in AT mode switch |
MODE_SW_PERCENT_TIME | DOUBLE | Y | The percentage of time the device is in AT mode switch |
MODE_SW_PERCENT_TIME_PER_DAY | DOUBLE | Y | The percentage of time per day the device is in AT mode switch |
PULSE_GEN_STAT_AT_ID | DOUBLE | N | PRIMARY KEY |
PULSE_GEN_STAT_ID | DOUBLE | N | The pulse generator statistic associated with this AT statistic |
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_STAT_AT
Child Column in PULSE_GEN_STAT_AT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_STAT_ID | PULSE_GEN_STAT | PULSE_GEN_STAT_ID |
PULSE_GEN_STAT_BRADY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Bradycardia Statistics |
Definition: | Contains statistics from a single Bradycardia event |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_STAT_BRADY
Column Name | Type | Null? | Definition |
---|---|---|---|
AP_VP_PERCENT | DOUBLE | Y | The percentage of atrial pace - ventricular pace sequences in relationship to all AV sequences |
AP_VS_PERCENT | DOUBLE | Y | The percentage of atrial pace - ventricular sense sequences in relationship to all AV sequences |
AS_VP_PERCENT | DOUBLE | Y | The percentage of atrial sense - ventricular pace sequences in relationship to all AV sequences |
AS_VS_PERCENT | DOUBLE | Y | The percentage of atrial sense - ventricular sense sequences in relationship to all AV sequences |
PULSE_GEN_STAT_BRADY_ID | DOUBLE | N | PRIMARY KEY |
PULSE_GEN_STAT_ID | DOUBLE | N | The pulse generator statistic associated with this brady statistic |
RA_PACED_PERCENT | DOUBLE | Y | The percentage of pacing events in the right atrium |
RV_PACED_PERCENT | DOUBLE | Y | The percentage of pacing events in the right ventrical |
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_STAT_BRADY
Child Column in PULSE_GEN_STAT_BRADY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_STAT_ID | PULSE_GEN_STAT | PULSE_GEN_STAT_ID |