Table Detail Report

PULSE_GEN_MEAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Measurement
Definition: Contains the start and end date and time of a pulse generator measurement
Table Type: ACTIVITY





Column Detail - PULSE_GEN_MEAS


Column Name Type Null? Definition
END_DT_TM DATETIME Y The date and time that this measurement ended
PULSE_GEN_ID DOUBLE N PRIMARY KEY
PULSE_GEN_MEAS_ID DOUBLE N PRIMARY KEY
START_DT_TM DATETIME Y The date and time that this measurement 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_MEAS


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




Parent Column in PULSE_GEN_MEAS (PK) Child Table Name Child Column Name
Children: PULSE_GEN_MEAS_ID PULSE_GEN_MEAS_BATT PULSE_GEN_MEAS_ID
PULSE_GEN_MEAS_CAP PULSE_GEN_MEAS_ID
PULSE_GEN_MEAS_CHAN PULSE_GEN_MEAS_ID
PULSE_GEN_MEAS_HCHAN PULSE_GEN_MEAS_ID


PULSE_GEN_MEAS_BATT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Battery Measurement
Definition: Contains measurements for the battery of a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_MEAS_BATT


Column Name Type Null? Definition
IMPEDANCE_NBR DOUBLE Y The measured battery impedance
PULSE_GEN_MEAS_BATT_ID DOUBLE N PRIMARY KEY
PULSE_GEN_MEAS_ID DOUBLE N The pulse generator measurement associated with this battery measurement
REMAINING_LONGEVITY_AMT DOUBLE Y The estimated amount of battery capacity remaining in months
REMAINING_PERCENTAGE_VALUE DOUBLE Y The estimated amount of battery capacity remaining in percent
RRT_TRIGGER VARCHAR(50) Y The criteria for determining battery end of service condition
STATUS_CD DOUBLE N The stage of battery depletion
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.
VOLTAGE_VALUE DOUBLE Y The measured battery voltage



Relationship Detail - PULSE_GEN_MEAS_BATT


Child Column in PULSE_GEN_MEAS_BATT(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_MEAS_ID PULSE_GEN_MEAS PULSE_GEN_MEAS_ID


PULSE_GEN_MEAS_CAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Capacitor Measurement
Definition: Contains measurements for the capacitor of a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_MEAS_CAP


Column Name Type Null? Definition
CHARGE_DT_TM DATETIME Y The date and time of the capacitor charge
CHARGE_ENERGY_VALUE DOUBLE Y The amount of energy stored after the capacitor charge in Joules
CHARGE_TIME_VALUE DOUBLE Y The duration in seconds of the capacitor charge
CHARGE_TYPE_CD DOUBLE N The type of the capacitor charge
PULSE_GEN_MEAS_CAP_ID DOUBLE N PRIMARY KEY
PULSE_GEN_MEAS_ID DOUBLE N The pulse generator measurement associated with this capacitor measurement
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_MEAS_CAP


Child Column in PULSE_GEN_MEAS_CAP(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_MEAS_ID PULSE_GEN_MEAS PULSE_GEN_MEAS_ID


PULSE_GEN_MEAS_CHAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Lead Channel Measurement
Definition: Contains measurements for the lead channel of a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_MEAS_CHAN


Column Name Type Null? Definition
CHAMBER_CD DOUBLE N Defines which chamber of the heart this channel is located
IMPEDANCE_AMT DOUBLE Y The sum of the impedances of the lead wires and the electrode-myocardial interface in ohms
PACING_THRSHLD_AMPLITUDE_VALUE DOUBLE Y The minimum pulse amplitude needed for pacing capture for a given pulse width
PACING_THRSHLD_MEAS_METHOD_CD DOUBLE N The method that was used to obtain the pacing threshold
PACING_THRSHLD_POLARITY_CD DOUBLE N The type of lead polarity that was used for the pacing threshold measurement
PACING_THRSHLD_PWIDTH_VALUE DOUBLE Y The pulse width that was applied when determining the pacing threshold amplitude
POLARITY_CD DOUBLE N The type of lead polarity used for measuring the lead impedance
PULSE_GEN_MEAS_CHAN_ID DOUBLE N PRIMARY KEY
PULSE_GEN_MEAS_ID DOUBLE N The pulse generator measurement associated with this lead channel measurement
SENSING_INTR_AMPL_MAX_VALUE DOUBLE Y The maximum measured amplitude of the intrinsic cardiac signal
SENSING_INTR_AMPL_MEAN_VALUE DOUBLE Y The average measured amplitude of the intrinsic cardiac signal
SENSING_INTR_AMPL_MIN_VALUE DOUBLE Y The minimum measured amplitude of the intrinsic cardiac signal
SENSING_POLARITY_CD DOUBLE N The type of polarity used for the intrinsic amplitude measurement
STATUS_CD DOUBLE N The indication whether to check 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_MEAS_CHAN


Child Column in PULSE_GEN_MEAS_CHAN(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_MEAS_ID PULSE_GEN_MEAS PULSE_GEN_MEAS_ID


PULSE_GEN_MEAS_HCHAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pulse Generator Lead High Voltage Channel Measurement
Definition: Contains measurements for the lead high voltage channel of a pulse generator
Table Type: ACTIVITY





Column Detail - PULSE_GEN_MEAS_HCHAN


Column Name Type Null? Definition
IMPEDANCE_AMT DOUBLE Y The sum of the impedances of the shock lead wires and the electrode-myocardial interface in ohms
MEASUREMENT_TYPE_CD DOUBLE N The electric pulse type used for measuring the shock lead impedance
PULSE_GEN_MEAS_HCHAN_ID DOUBLE N PRIMARY KEY
PULSE_GEN_MEAS_ID DOUBLE N The pulse generator measurement associated with this high voltage channel measurement
STATUS_CD DOUBLE N The indication whether to check 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_MEAS_HCHAN


Child Column in PULSE_GEN_MEAS_HCHAN(FK) Parent Table Name Parent Column Name
Parents: PULSE_GEN_MEAS_ID PULSE_GEN_MEAS PULSE_GEN_MEAS_ID