SAP ABAP Table T7EHS00_SRV_DIA (Diagnoses for Person)

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	TRANSP	Transparent table
Transparent table	T7EHS00_SRV_DIA	Table Relationship Diagram
Short Description	Diagnoses for Person

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PERNR	☑	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number
3	DIAG_NUMBER	☑	EHS00_DIANUMBER	NUMC03	NUMC	3	0	Number of Diagnosis of a Person
4	DIAG_CTLG	☐	EHS00_DIAG_CAT	CHAR02	CHAR	2	0	Diagnosis Catalog	T7EHS00_DIAGKT
5	DIAG_CODE	☐	EHS00_DIAGN_CODE	EHS00_DIAGN_CODE	CHAR	6	0	Diagnosis Code	T7EHS00_DIAGSL
6	DIAG_TYPE	☐	EHS00_DIAGN_TYPE	CHAR01	CHAR	1	0	Diagnosis Key Category	T7EHS00_DIAGNTY
7	DIAG_ONSETDATE	☐	EHS00_DIA_STRDATE	DATUM	DATS	8	0	Start Date of Diagnosed Illness
8	DIAG_RECDATE	☐	EHS00_SRV_EXADATE	DATUM	DATS	8	0	Examination Date
9	DIAG_INACTDATE	☐	EHS00_DIA_RESDATE	DATUM	DATS	8	0	End Date for Diagnosed Illness
10	DIAG_SIGNIF	☐	EHS00_DIA_SIGNIF	XFLAG	CHAR	1	0	Diagnosis Significance
11	DIAG_PRIMARY	☐	EHS00_DIA_PRIM	CHAR01	CHAR	1	0	Diagnosis Rating	T7EHS00_DIA_PRI
12	DIAG_SRC	☐	EHS00_DIA_SRC	CHAR02	CHAR	2	0	Diagnosis Source	T7EHS00_DIA_SRC
13	DIAG_CHARACT	☐	EHS00_DIA_CHAR	CHAR02	CHAR	2	0	Cause of Illness	T7EHS00_DIA_CHA
14	DIAG_EFFECT	☐	EHS00_DIA_EFFECT	CHAR02	CHAR	2	0	Effects of Diagnosed Illness	T7EHS00_DIA_EFF
15	DIAG_CATEG	☐	EHS00_DIA_CATEG	CHAR08	CHAR	8	0	Diagnosis Type	T7EHS00_DIA_CAT
16	DIAG_PHYSICIAN	☐	EHS00_DIA_PHYSNR	BU_PARTNER	CHAR	10	0	Physician Responsible for Diagnosis/Test Result	*
17	PHYSFLAG	☐	EHS00_INEXFLAG	EHS00_INEXFLAG	CHAR	1	0	Internal/External Person
18	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
19	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
21	DIAG_PRESP	☐	EHS00_PRESP	EHS00_PARNR	CHAR	10	0	Service Provider/Person Responsible
22	DIAG_USRTXT	☐	EHS00E_DIAG_USRTXT	TEXT132	CHAR	132	0	User-Defined Text Field for Diagnoses
23	DIAG_USRTXTFLG	☐	EHS00E_DIAG_USRTXTFLG	ESDFLAG	CHAR	1	0	Long Text Exists for Diagnosis
24	DIAG_CRITICALFLG	☐	EHS00E_DIAG_CRITICALFLG	ESDFLAG	CHAR	1	0	Critical Diagnosis

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_SRV_DIA	DIAG_CATEG	T7EHS00_DIA_CAT	DIAG_CAT	KEY	1	CN
2	T7EHS00_SRV_DIA	DIAG_CHARACT	T7EHS00_DIA_CHA	DIAG_CHAR	REF	C	CN
3	T7EHS00_SRV_DIA	DIAG_CODE	T7EHS00_DIAGSL	DIAGN_CODE	REF	1	CN
4	T7EHS00_SRV_DIA	DIAG_CTLG	T7EHS00_DIAGKT	CATID	REF	1	CN
5	T7EHS00_SRV_DIA	DIAG_EFFECT	T7EHS00_DIA_EFF	DIAG_EFF	REF	C	CN
6	T7EHS00_SRV_DIA	DIAG_PRIMARY	T7EHS00_DIA_PRI	DIAG_PRI	KEY	1	CN
7	T7EHS00_SRV_DIA	DIAG_SRC	T7EHS00_DIA_SRC	DIAG_SRC	REF	1	CN
8	T7EHS00_SRV_DIA	DIAG_TYPE	T7EHS00_DIAGNTY	DIAGN_TYPE	REF	C	CN
9	T7EHS00_SRV_DIA	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in