SAP ABAP Table EHS00S_SRV_DIA (Structure: Diagnoses for a Person (T7EHS00_SRV_DIA))

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	EHS00S_SRV_DIA	Table Relationship Diagram
Short Description	Structure: Diagnoses for a Person (T7EHS00_SRV_DIA)

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	Diagnoses for Person
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PERNR	☐	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number	*
4	DIAG_NUMBER	☐	EHS00_DIANUMBER	NUMC03	NUMC	3	0	Number of Diagnosis of a Person
5	DIAG_CTLG	☐	EHS00_DIAG_CAT	CHAR02	CHAR	2	0	Diagnosis Catalog	T7EHS00_DIAGKT
6	DIAG_CODE	☐	EHS00_DIAGN_CODE	EHS00_DIAGN_CODE	CHAR	6	0	Diagnosis Code	T7EHS00_DIAGSL
7	DIAG_TYPE	☐	EHS00_DIAGN_TYPE	CHAR01	CHAR	1	0	Diagnosis Key Category	T7EHS00_DIAGNTY
8	DIAG_ONSETDATE	☐	EHS00_DIA_STRDATE	DATUM	DATS	8	0	Start Date of Diagnosed Illness
9	DIAG_RECDATE	☐	EHS00_SRV_EXADATE	DATUM	DATS	8	0	Examination Date
10	DIAG_INACTDATE	☐	EHS00_DIA_RESDATE	DATUM	DATS	8	0	End Date for Diagnosed Illness
11	DIAG_SIGNIF	☐	EHS00_DIA_SIGNIF	XFLAG	CHAR	1	0	Diagnosis Significance
12	DIAG_PRIMARY	☐	EHS00_DIA_PRIM	CHAR01	CHAR	1	0	Diagnosis Rating	T7EHS00_DIA_PRI
13	DIAG_SRC	☐	EHS00_DIA_SRC	CHAR02	CHAR	2	0	Diagnosis Source	T7EHS00_DIA_SRC
14	DIAG_CHARACT	☐	EHS00_DIA_CHAR	CHAR02	CHAR	2	0	Cause of Illness	T7EHS00_DIA_CHA
15	DIAG_EFFECT	☐	EHS00_DIA_EFFECT	CHAR02	CHAR	2	0	Effects of Diagnosed Illness	T7EHS00_DIA_EFF
16	DIAG_CATEG	☐	EHS00_DIA_CATEG	CHAR08	CHAR	8	0	Diagnosis Type	T7EHS00_DIA_CAT
17	DIAG_PHYSICIAN	☐	EHS00_DIA_PHYSNR	BU_PARTNER	CHAR	10	0	Physician Responsible for Diagnosis/Test Result	*
18	PHYSFLAG	☐	EHS00_INEXFLAG	EHS00_INEXFLAG	CHAR	1	0	Internal/External Person
19	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service	*
20	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
22	DIAG_PRESP	☐	EHS00_PRESP	EHS00_PARNR	CHAR	10	0	Service Provider/Person Responsible
23	DIAG_USRTXT	☐	EHS00E_DIAG_USRTXT	TEXT132	CHAR	132	0	User-Defined Text Field for Diagnoses
24	DIAG_USRTXTFLG	☐	EHS00E_DIAG_USRTXTFLG	ESDFLAG	CHAR	1	0	Long Text Exists for Diagnosis
25	DIAG_CRITICALFLG	☐	EHS00E_DIAG_CRITICALFLG	ESDFLAG	CHAR	1	0	Critical Diagnosis
26	DIAG_CTLG_SD	☐	EHS00_DIAG_CSD	TEXT10	CHAR	10	0	Description of Diagnosis Catalog
27	DIAG_PHYSNAM	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
28	DIAG_TEXT	☐	EHS00_DIAGN_TXT	TEXT72	CHAR	72	0	Description of Diagnosis
29	DIAG_DESC1	☐	EHS00_DIAGN_TXT	TEXT72	CHAR	72	0	Description of Diagnosis
30	DIAG_DESC2	☐	EHS00_DIAGN_TXT	TEXT72	CHAR	72	0	Description of Diagnosis
31	DIAG_DESC3	☐	EHS00_DIAGN_TXT	TEXT72	CHAR	72	0	Description of Diagnosis
32	DIAG_PRIMARY_TXT	☐	EHS00_DIA_PRIMT	TEXT15	CHAR	15	0	Description of Diagnosis Rating
33	DIAG_SOURCE_TXT	☐	EHS00_DIA_SRCT	TEXT50	CHAR	50	0	Description of Diagnosis Source
34	DIAG_CHARACT_TXT	☐	EHS00_DIA_CHARTXT	TEXT50	CHAR	50	0	Description of Cause
35	DIAG_EFFECT_TXT	☐	EHS00_DIA_EFFT	CHR150	CHAR	150	0	Description of Effect

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in