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 |