SAP ABAP Table EHS00S_EXA_AUD (Structure: Audiogram)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-HEA (Application Component) Occupational Health
⤷ P99Q1 (Package) EH&S: Occupational Health
⤷ EHS-HEA (Application Component) Occupational Health
⤷ P99Q1 (Package) EH&S: Occupational Health
Basic Data
Table Category | INTTAB | Structure |
Structure | EHS00S_EXA_AUD | Table Relationship Diagram |
Short Description | Structure: Audiogram |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Examination Results: Audiogram | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | SRV_NUMBER | EHS00_SRVNUMBER | NUMC12 | NUMC | 12 | 0 | Number of Medical Service | T7EHS00_SRV_EXA | |
4 | EXAM_GROUP | EHS00_EGROUP | NUMC02 | NUMC | 2 | 0 | Examination Category | ||
5 | EXAM_CODE | EHS00_ECODE | CHAR17 | CHAR | 17 | 0 | Examination Number | ||
6 | EXAM_COUNT | EHS00_EXAMCOUNT | NUMC04 | NUMC | 4 | 0 | Number of Individual Examinations | ||
7 | TEST_NO | EHS00_TESTNO | CHAR08 | CHAR | 8 | 0 | Medical Test Number | ||
8 | PERNR | EHS00_PERNR | EHS00_PERNR | NUMC | 8 | 0 | Personnel number | ||
9 | AUDIO_BASEIND | EHS00_AUDBASE | CHAR01 | CHAR | 1 | 0 | Baseline Indicator | T7EHS00_AUD_IND | |
10 | ASYLOWFREQ_HL | EHS00_AUD_AL | XFLAG | CHAR | 1 | 0 | Asymmetric Low Frequency Hearing Loss | ||
11 | ASYHIGHFREQ_HL | EHS00_AUD_AH | XFLAG | CHAR | 1 | 0 | Asymmetric High Frequency Hearing Loss | ||
12 | LOWFREQ_HL_L | EHS00_AUD_LL | XFLAG | CHAR | 1 | 0 | Low Frequency Hearing Loss Left | ||
13 | STS_L | EHS00_AUD_SL | XFLAG | CHAR | 1 | 0 | 'Standard Threshold Shift' (STS) Left | ||
14 | ETS_L | EHS00_AUD_EL | XFLAG | CHAR | 1 | 0 | 'Early Threshold Shift' Left | ||
15 | POT_HL_L | EHS00_AUD_PL | XFLAG | CHAR | 1 | 0 | 'Potentially Recordable Hearing Loss' Left | ||
16 | DB_L00500HZ | EHS00_DBL05 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 0.5 kHz Left | ||
17 | DB_L01000HZ | EHS00_DBL10 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 1.0 kHz Left | ||
18 | DB_L02000HZ | EHS00_DBL20 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 2.0 kHz Left | ||
19 | DB_L03000HZ | EHS00_DBL30 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 3.0 kHz Left | ||
20 | DB_L04000HZ | EHS00_DBL40 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 4.0 kHz Left | ||
21 | DB_L06000HZ | EHS00_DBL60 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 6.0 kHz Left | ||
22 | DB_L08000HZ | EHS00_DBL80 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 8.0 kHz Left | ||
23 | LOWFREQ_HL_R | EHS00_AUD_LR | XFLAG | CHAR | 1 | 0 | Low Frequency Hearing Loss Right | ||
24 | STS_R | EHS00_AUD_SR | XFLAG | CHAR | 1 | 0 | 'Standard Threshold Shift' (STS) Right | ||
25 | ETS_R | EHS00_AUD_ER | XFLAG | CHAR | 1 | 0 | 'Early Threshold Shift' Right | ||
26 | POT_HL_R | EHS00_AUD_PR | XFLAG | CHAR | 1 | 0 | 'Potentially Recordable Hearing Loss' Right | ||
27 | DB_R00500HZ | EHS00_DBR05 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 0.5 kHz Right | ||
28 | DB_R01000HZ | EHS00_DBR10 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 1.0 kHz Right | ||
29 | DB_R02000HZ | EHS00_DBR20 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 2.0 kHz Right | ||
30 | DB_R03000HZ | EHS00_DBR30 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 3.0 kHz Right | ||
31 | DB_R04000HZ | EHS00_DBR40 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 4.0 kHz Right | ||
32 | DB_R06000HZ | EHS00_DBR60 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 6.0 kHz Right | ||
33 | DB_R08000HZ | EHS00_DBR80 | INT4 | INT4 | 10 | 0 | Audiogram: Decibel Value at 8.0 kHz Right | ||
34 | AUDIO_MASCHINE | EHS00_AUDMSCH | TEXT20 | CHAR | 20 | 0 | Device Number of Audiometer | ||
35 | AUDIO_SOFTWARE | EHS00_AUDSOFT | TEXT20 | CHAR | 20 | 0 | Audiometer Software | ||
36 | TECHNICIAN | EHS00_AUDTECH | BU_PARTNER | CHAR | 10 | 0 | Audiogram Technician | * | |
37 | TECHFLAG | EHS00_INEXFLAG | EHS00_INEXFLAG | CHAR | 1 | 0 | Internal/External Person | ||
38 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
39 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
40 | AUD_EXAM_DATE | EHS00_SRV_EXADATE | DATUM | DATS | 8 | 0 | Examination Date | ||
41 | AUD_EXAM_TIME | EHS00_SRV_EXATIME | SYTIME | TIMS | 6 | 0 | Time of Examination | ||
42 | AUDIO_AGE | EHS00_AUD_AGE | NUMC03 | NUMC | 3 | 0 | Audiogram: Age for Adjustment Data | ||
43 | UPDFLAG | EHS00_ACTIVEFLAG | BOOLEAN | CHAR | 1 | 0 | Active | ||
44 | NEWFLAG | EHS00_ACTIVEFLAG | BOOLEAN | CHAR | 1 | 0 | Active | ||
45 | IGNORE_FLAG | EHS00_ACTIVEFLAG | BOOLEAN | CHAR | 1 | 0 | Active |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EHS00S_EXA_AUD | AUDIO_BASEIND | T7EHS00_AUD_IND | AUDIO_BASEIND | REF | 1 | CN |
2 | EHS00S_EXA_AUD | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | EHS00S_EXA_AUD | SRV_NUMBER | T7EHS00_SRV_EXA | SRV_NUMBER | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |