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 |