SAP ABAP Table EHS_EXA_AUD (Examination Results: Audiogram)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HEA (Application Component) Occupational Health
     ⤷ P99Q1 (Package) EH&S: Occupational Health

Basic Data

Table Category	INTTAB	Structure
Structure	EHS_EXA_AUD	Table Relationship Diagram
Short Description	Examination Results: 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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS_EXA_AUD	AUDIO_BASEIND	T7EHS00_AUD_IND	AUDIO_BASEIND	REF	1	CN
2	EHS_EXA_AUD	MANDT	T000	MANDT	KEY	1	CN
3	EHS_EXA_AUD	SRV_NUMBER	T7EHS00_SRV_EXA	SRV_NUMBER	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in