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