PULSE_GEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator |
Definition: | Contains basic information about a pulse generator device (e.g. an ICD or Pacemaker) implanted into a person |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSOCIATION_DT_TM | DATETIME | Y | The date and time this pulse generator was associated to a person |
ASSOC_PRSNL_ID | DOUBLE | N | The personnel who associated this device |
IMPLANTER_CONTACT_INFO | VARCHAR(100) | Y | The contact information of the physician that implanted the pulse generator |
IMPLANTER_NAME | VARCHAR(50) | Y | The name of the physician that implanted the pulse generator |
IMPLANTING_FACILITY_NAME | VARCHAR(100) | Y | The facility (clinic/hospital) where the pulse generator was implanted |
IMPLANT_DT_TM | DATETIME | Y | The implant date of the pulse generator |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MANUFACTURER_CD | DOUBLE | N | The manufacturer of the pulse generator |
MODEL_IDENT | VARCHAR(50) | Y | The model identifier of the pulse generator |
PERSON_ID | DOUBLE | N | The person associated with this pulse generator |
PULSE_GEN_ID | DOUBLE | N | PRIMARY KEY |
PULSE_GEN_PID_ID | DOUBLE | N | ID for the PID informaton from an external system.The external database's information won't match up exactly with our PERSON table, we need to keep track of this information somehow. These new columns will eventually be used to assist a cardiology tech in manually matching up a PULSE_GEN with a PERSON. |
REMOVAL_DT_TM | DATETIME | Y | The removal date of the pulse generator |
SERIAL_TXT | VARCHAR(40) | Y | The serial number of the pulse generator |
SERIAL_TXT_KEY | VARCHAR(40) | Y | The serial number with all non-alphanumeric characters stripped out and all alphanumeric characters uppercased. |
TYPE_CD | DOUBLE | N | The type of pulse generator (e.g. ICD or pacemaker) |
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
Child Column in PULSE_GEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
PERSON_ID | PERSON | PERSON_ID | |
ASSOC_PRSNL_ID | PRSNL | PERSON_ID | |
PULSE_GEN_PID_ID | PULSE_GEN_PID | PULSE_GEN_PID_ID |
Parent Column in PULSE_GEN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PULSE_GEN_ID | PULSE_GEN_ASSOC_HIST | PULSE_GEN_ID |
PULSE_GEN_EPISODE | PULSE_GEN_ID | ||
PULSE_GEN_LEAD | PULSE_GEN_ID | ||
PULSE_GEN_MEAS | PULSE_GEN_ID | ||
PULSE_GEN_SESSION | PULSE_GEN_ID | ||
PULSE_GEN_SET | PULSE_GEN_ID | ||
PULSE_GEN_STAT | PULSE_GEN_ID |
PULSE_GEN_ASSOC_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Association History |
Definition: | Contains information regarding the association and removal of association of a pulse generator |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_ASSOC_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSOCIATION_DT_TM | DATETIME | Y | The date and time the pulse generator was associated to a person |
ASSOC_PRSNL_ID | DOUBLE | N | The personnel who associated this device |
DISASSOCIATION_DT_TM | DATETIME | Y | The date and time the association of the pulse generator was removed. |
DISASSOC_PRSNL_ID | DOUBLE | N | The personnel who disassociated this device |
PERSON_ID | DOUBLE | N | The Person associated with this history item |
PULSE_GEN_ASSOC_HIST_ID | DOUBLE | N | PRIMARY KEY |
PULSE_GEN_ID | DOUBLE | N | The pulse generator associated with this history item |
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_ASSOC_HIST
Child Column in PULSE_GEN_ASSOC_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
ASSOC_PRSNL_ID | PRSNL | PERSON_ID | |
DISASSOC_PRSNL_ID | PRSNL | PERSON_ID | |
PULSE_GEN_ID | PULSE_GEN | PULSE_GEN_ID |
PULSE_GEN_ATP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator ATP Zone Settings |
Definition: | Contains information about ATP zone settings for a pulse generator |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_ATP
Column Name | Type | Null? | Definition |
---|---|---|---|
PULSE_GEN_ATP_ID | DOUBLE | N | PRIMARY KEY |
PULSE_GEN_SET_ZONE_ID | DOUBLE | N | The pulse generator zone setting ID associated with this ATP zone |
SEQUENCE_CNT | DOUBLE | Y | The number of anti-tachycardia pacing pulse (ATP) sequences programmed per ATP type |
TYPE_CD | DOUBLE | N | The type of anti-tachycardia pacing (ATP) sequences programmed per ATP type |
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 ATP setting, from 1 to 10 |
Relationship Detail - PULSE_GEN_ATP
Child Column in PULSE_GEN_ATP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_SET_ZONE_ID | PULSE_GEN_SET_ZONE | PULSE_GEN_SET_ZONE_ID |
PULSE_GEN_EPISODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Episode |
Definition: | Contains information about an atypical heart rhythm event that a pulse generator device has recorded. |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_EPISODE
Column Name | Type | Null? | Definition |
---|---|---|---|
A_INT_DET_NBR | DOUBLE | Y | The atrial interval at the time of detection |
A_INT_TERM_NBR | DOUBLE | Y | The atrial interval at the time of termination |
DETAILS_TXT | VARCHAR(100) | Y | A text describing details about the detection and therapy delivered |
DETECTION_DT_TM | DATETIME | Y | The detection date and time of the episode |
DOC_LEN_NBR | DOUBLE | Y | The number of pages for this session document |
DOC_UID | VARCHAR(50) | N | The UID for a document associated with this episode |
DURATION_VALUE | DOUBLE | N | The duration of the episode in seconds |
EPISODE_IDENT | VARCHAR(100) | Y | The unique identifier for the episode |
INDUCED_CD | DOUBLE | N | The indication of whether the episode has been induced or not |
PULSE_GEN_EPISODE_ID | DOUBLE | N | PRIMARY KEY |
PULSE_GEN_ID | DOUBLE | N | The pulse generator associated with this episode |
THERAPY_RESULT_CD | DOUBLE | N | The indicator of therapy success |
TYPE_CD | DOUBLE | N | The generic type of the episode being reported |
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 type of the episode being reported |
V_INT_DET_NBR | DOUBLE | Y | The ventricular interval at the time of detection |
V_INT_TERM_NBR | DOUBLE | Y | The ventricular interval at the time of termination |
Relationship Detail - PULSE_GEN_EPISODE
Child Column in PULSE_GEN_EPISODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_ID | PULSE_GEN | PULSE_GEN_ID |
PULSE_GEN_LEAD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pulse Generator Lead |
Definition: | Contains information about a lead for a pulse generator device, such as the model, serial number, manufacturer, and physical location of the lead. |
Table Type: | ACTIVITY |
Column Detail - PULSE_GEN_LEAD
Column Name | Type | Null? | Definition |
---|---|---|---|
CONNECTION_CD | DOUBLE | N | The physical connection status of the lead, either connected or abandoned |
ELECTRODE_POLARITY_CD | DOUBLE | N | The number of electrodes on the lead |
IMPLANT_DT_TM | DATETIME | Y | The implant date of the lead |
LOCATION_CD | DOUBLE | N | The fixation location of the lead, usually indicating a chamber of the heart |
LOCATION_DETAIL1_CD | DOUBLE | N | Further details describing the location |
LOCATION_DETAIL2_CD | DOUBLE | N | Further details describing the location |
LOCATION_DETAIL3_CD | DOUBLE | N | Further details describing the location |
MANUFACTURER_CD | DOUBLE | N | The manufacturer of the lead |
MODEL_IDENT | VARCHAR(50) | Y | The model of the lead |
PULSE_GEN_ID | DOUBLE | N | The pulse generator associated with this lead |
PULSE_GEN_LEAD_ID | DOUBLE | N | PRIMARY KEY |
REMOVAL_DT_TM | DATETIME | Y | The removal date of the lead |
SERIAL_TXT | VARCHAR(40) | Y | The serial number of the lead |
SPECIAL_FUNCTION | VARCHAR(20) | Y | A description of any special attribute or function of the lead |
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_LEAD
Child Column in PULSE_GEN_LEAD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PULSE_GEN_ID | PULSE_GEN | PULSE_GEN_ID |