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