Table Detail Report

PULSE_GEN_PID



Column Section Relationship Section Top of Page


Table-level Detail

Description: PULSE Generator PID informaton
Definition: Contains informaton that comes in the Pjlse Generator's PID field (person content). From external source.
Table Type: ACTIVITY





Column Detail - PULSE_GEN_PID


Column Name Type Null? Definition
ADDRESS_TXT VARCHAR(150) Y The address in this PID information
BIRTH_DT_TM_TXT VARCHAR(8) Y Text version of The birth date for this PID information in the format: YYYYMMDD
NAME_FIRST VARCHAR(30) Y The first name in the PID information
NAME_FIRST_KEY VARCHAR(30) Y The first name key in the PID information
NAME_FULL_FORMATTED VARCHAR(100) Y The full formatted name for this PID information
NAME_LAST VARCHAR(30) Y The last name in the PID information
NAME_LAST_KEY VARCHAR(30) Y The last name key in the PID information
NAME_MIDDLE VARCHAR(30) Y The middle name in the PID information
NAME_MIDDLE_KEY VARCHAR(30) Y The middle name key in the PID information
PULSE_GEN_PID_ID DOUBLE N Primary Key
SEX_CD DOUBLE N The gender in the PID information
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_PID




Parent Column in PULSE_GEN_PID (PK) Child Table Name Child Column Name
Children: PULSE_GEN_PID_ID PULSE_GEN PULSE_GEN_PID_ID


PULSE_GEN_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Session
Definition: Contains information about a device interrogation session
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SESSION


Column Name Type Null? Definition
CLINICIAN_CONTACT VARCHAR(100) Y The contact information for the responsible clinician
CLINICIAN_NAME VARCHAR(50) Y The name of the clinician that is responsible for the examination
CLINIC_NAME VARCHAR(50) Y The name of the clinic where the examination took place
PULSE_GEN_ID DOUBLE N The pulse generator associated with this interrogation session
PULSE_GEN_SESSION_ID DOUBLE N PRIMARY KEY
REPROGRAMMED_CD DOUBLE N The indication of whether the device was reprogrammed during the session
SESSION_DT_TM DATETIME Y The date and time of the in-clinic or remote interrogation session
TYPE_CD DOUBLE N The type of device interaction that generated the current data set
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_SESSION


Child Column in PULSE_GEN_SESSION(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_ID PULSE_GEN PULSE_GEN_ID




Parent Column in PULSE_GEN_SESSION (PK) Child Table Name Child Column Name
Children: PULSE_GEN_SESSION_ID PULSE_GEN_SESSION_DOC PULSE_GEN_SESSION_ID


PULSE_GEN_SESSION_DOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Gen Session Document
Definition: Contains information about a document that a pulse generator has created for a session.
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SESSION_DOC


Column Name Type Null? Definition
DOC_DESC VARCHAR(50) Y A short description of the report type for the pulse generaor document e.g. EGM Report or Capture Threshold
DOC_DT_TM DATETIME Y The date and time for the document
DOC_LEN_NBR DOUBLE Y The number of pages for this session document
DOC_UID VARCHAR(50) N The UID for the document content
PULSE_GEN_SESSION_DOC_ID DOUBLE N PRIMARY KEY
PULSE_GEN_SESSION_ID DOUBLE N The session associated with this pulse generator episode document
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_SESSION_DOC


Child Column in PULSE_GEN_SESSION_DOC(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_SESSION_ID PULSE_GEN_SESSION PULSE_GEN_SESSION_ID


PULSE_GEN_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Setting
Definition: Parent of all pulse generator settings.
Table Type: ACTIVITY





Column Detail - PULSE_GEN_SET


Column Name Type Null? Definition
PULSE_GEN_ID DOUBLE N The pulse generator associated with this setting
PULSE_GEN_SET_ID DOUBLE N PRIMARY KEY
SET_DT_TM DATETIME N The date and time this setting was set on the pulse generator
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


Child Column in PULSE_GEN_SET(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_ID PULSE_GEN PULSE_GEN_ID




Parent Column in PULSE_GEN_SET (PK) Child Table Name Child Column Name
Children: PULSE_GEN_SET_ID PULSE_GEN_SET_BRADY PULSE_GEN_SET_ID
PULSE_GEN_SET_CHAN PULSE_GEN_SET_ID
PULSE_GEN_SET_CRT PULSE_GEN_SET_ID
PULSE_GEN_SET_MAG PULSE_GEN_SET_ID
PULSE_GEN_SET_TACHY PULSE_GEN_SET_ID
PULSE_GEN_SET_ZONE PULSE_GEN_SET_ID


PULSE_GEN_SET_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_SET_BRADY


Column Name Type Null? Definition
AT_MODE_SWITCH_MODE_CD DOUBLE N The atrial tachycardia mode switch mode
AT_MODE_SWITCH_RATE DOUBLE Y The atrial tachycardia mode switch rate in beats per minute
HYST_RATE DOUBLE Y The lower rate for the hysteresis feature in beats per minute
LOW_RATE DOUBLE Y The rate in beats per minute at which the device paces in the absence of a cardiac rhythm faster than the lower rate and without influence from features that can affect the pacing rate
MAX_SENSOR_RATE DOUBLE Y The fastest sensor-driven pacing rate in beats per minute that can be achieved in a rate-adaptive pacing system
MAX_TRACKING_RATE DOUBLE Y The fastest atrial rate in beats per minute at which ventricular pacing occurs with 1:1 synchrony
MODE_CD DOUBLE N The brady pacing mode according to the NBG standard
NIGHT_RATE DOUBLE Y The lower rate for the night rate feature in beats per minute
PAV_DELAY_HIGH_INTERVAL DOUBLE Y The high interval from a paced atrial event to a paced ventricular event in milliseconds
PAV_DELAY_LOW_INTERVAL DOUBLE Y The low interval from a paced atrial event to a paced ventricular event in milliseconds
PULSE_GEN_SET_BRADY_ID DOUBLE N PRIMARY KEY
PULSE_GEN_SET_ID DOUBLE N The pulse generator setting associated with this brady setting
SAV_DELAY_HIGH_INTERVAL DOUBLE Y The high interval from an intrinsic (sensed) P wave to a paced ventricular event in milliseconds
SAV_DELAY_LOW_INTERVAL DOUBLE Y The low interval from an intrinsic (sensed) P wave to a paced ventricular event in milliseconds
SENSOR_TYPE VARCHAR(20) Y The type of sensor applied for rate adaptive pacing
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_MODE VARCHAR(20) Y The brady pacing mode as defined by vendor specific codes



Relationship Detail - PULSE_GEN_SET_BRADY


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