T7EHS00_EXA_AUD SAP table for – Examination Results: Audiogram

Here we would like to draw your attention to T7EHS00_EXA_AUD table in SAP. As we know it is being mainly used with the SAP EHS-HEA (Occupational Health in EHS) component which is coming under EHS module (Environment, Health and Safety). T7EHS00_EXA_AUD is a SAP standard transp table used for storing Examination Results: Audiogram related data in SAP. It comes under the package P99Q1.

SAP T7EHS00_EXA_AUD table

Table T7EHS00_EXA_AUD technical data

TableT7EHS00_EXA_AUD
Data storingExamination Results: Audiogram
ModuleEHS
Sub ModuleEHS-HEA
SAP PackageP99Q1
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP T7EHS00_EXA_AUD Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T7EHS00_EXA_AUD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SRV_NUMBER : Number of Medical Service
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • EXAM_GROUP : Examination Category
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • EXAM_CODE : Examination Number
    Its a key field. Its data type is CHAR (Character String) with field length 17
  • EXAM_COUNT : Number of Individual Examinations
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • TEST_NO : Medical Test Number
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • PERNR : Personnel number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • AUDIO_BASEIND : Baseline Indicator
    Its data type is CHAR (Character String) with field length 1
  • ASYLOWFREQ_HL : Asymmetric Low Frequency Hearing Loss
    Its data type is CHAR (Character String) with field length 1
  • ASYHIGHFREQ_HL : Asymmetric High Frequency Hearing Loss
    Its data type is CHAR (Character String) with field length 1
  • LOWFREQ_HL_L : Low Frequency Hearing Loss Left
    Its data type is CHAR (Character String) with field length 1
  • STS_L : ‘Standard Threshold Shift’ (STS) Left
    Its data type is CHAR (Character String) with field length 1
  • ETS_L : ‘Early Threshold Shift’ Left
    Its data type is CHAR (Character String) with field length 1
  • POT_HL_L : ‘Potentially Recordable Hearing Loss’ Left
    Its data type is CHAR (Character String) with field length 1
  • DB_L00500HZ : Audiogram: Decibel Value at 0.5 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_L01000HZ : Audiogram: Decibel Value at 1.0 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_L02000HZ : Audiogram: Decibel Value at 2.0 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_L03000HZ : Audiogram: Decibel Value at 3.0 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_L04000HZ : Audiogram: Decibel Value at 4.0 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_L06000HZ : Audiogram: Decibel Value at 6.0 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_L08000HZ : Audiogram: Decibel Value at 8.0 kHz Left
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • LOWFREQ_HL_R : Low Frequency Hearing Loss Right
    Its data type is CHAR (Character String) with field length 1
  • STS_R : ‘Standard Threshold Shift’ (STS) Right
    Its data type is CHAR (Character String) with field length 1
  • ETS_R : ‘Early Threshold Shift’ Right
    Its data type is CHAR (Character String) with field length 1
  • POT_HL_R : ‘Potentially Recordable Hearing Loss’ Right
    Its data type is CHAR (Character String) with field length 1
  • DB_R00500HZ : Audiogram: Decibel Value at 0.5 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_R01000HZ : Audiogram: Decibel Value at 1.0 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_R02000HZ : Audiogram: Decibel Value at 2.0 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_R03000HZ : Audiogram: Decibel Value at 3.0 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_R04000HZ : Audiogram: Decibel Value at 4.0 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_R06000HZ : Audiogram: Decibel Value at 6.0 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DB_R08000HZ : Audiogram: Decibel Value at 8.0 kHz Right
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • AUDIO_MASCHINE : Device Number of Audiometer
    Its data type is CHAR (Character String) with field length 20
  • AUDIO_SOFTWARE : Audiometer Software
    Its data type is CHAR (Character String) with field length 20
  • TECHNICIAN : Audiogram Technician
    Its data type is CHAR (Character String) with field length 10
  • TECHFLAG : Internal/External Person
    Its data type is CHAR (Character String) with field length 1
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • AEDTM : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8