SAP ABAP Table T7EHS00_PROT (Health Surveillance Protocols)

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_PROT	Table Relationship Diagram
Short Description	Health Surveillance Protocols

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	PGROUP	☑	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
3	PNUMBER	☑	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number
4	ENDDA	☑	ENDDATUM	DATUM	DATS	8	0	End Date
5	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
6	POWNER	☐	EHS00_POWNER	EHS00_POWNER	CHAR	20	0	Protocol Owner	T7EHS00_POWNER
7	LTEXT	☐	EHS00_LTFLAG	XFELD	CHAR	1	0	Long Text Exists
8	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
9	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	REGULATORY	☐	EHS00_REGUL	EHS00_REGUL	CHAR	1	0	Regulatory Protocol
11	MANDATORY	☐	EHS00_MANDA	EHS00_MANDA	CHAR	1	0	Mandatory Examination
12	SCHEDNR	☐	EHS00_SCHED	EHS00_SCHED	CHAR	1	0	Health Surveillance Protocol Type	*
13	LTA_TRIGGER	☐	EHS00_AERT1	EHS00_AERAT	CHAR	1	0	Long-Term Average Trigger Level	T7EHS00RA
14	NRT_TRIGGER	☐	EHS00_NRTTR	EHS00_NRTTR	CHAR	1	0	Nonroutine Task
15	AND_LTA_TRIGGER	☐	EHS00_AERT2	EHS00_AERAT	CHAR	1	0	Additional Long-Term Average Trigger Level	T7EHS00RA
16	ER_RAT_TRIG	☐	EHS00_AERT3	EHS00_AERAT	CHAR	1	0	Short-Time Exposure Rating	T7EHS00RA
17	ER_RAT_FREQ_TRIG	☐	EHS00_RAT01	EHS00_14RAT	CHAR	1	0	Exposure Frequency Trigger Level	T7EHS00RN
18	SKINEXPFREQ_TRIG	☐	EHS00_RAT02	EHS00_14RAT	CHAR	1	0	Skin Absorption Trigger Level	T7EHS00RN
19	SKINEFFFREQ_TRIG	☐	EHS00_RAT03	EHS00_14RAT	CHAR	1	0	Skin Exposure Effects Trigger Level	T7EHS00RN
20	INGESTFREQ_TRIG	☐	EHS00_RAT04	EHS00_14RAT	CHAR	1	0	Ingestion Effects Trigger Level	T7EHS00RN
21	ALWAYS_CHECK	☐	EHS00_ALWCH	EHS00_ALWCH	CHAR	1	0	Check Assignment of Protocol Manually
22	COST_INT	☐	EHS00_COSTINT	WERT8	CURR	15	2	Internal Costs
23	COST_EXT	☐	EHS00_COSTEXT	WERT8	CURR	15	2	External Costs
24	WAEHR_INT	☐	EHS00_WAERINT	WAERS	CUKY	5	0	Costs Currency	TCURC
25	WAEHR_EXT	☐	EHS00_WAEREXT	WAERS	CUKY	5	0	Costs Currency	TCURC
26	DURATION_INT	☐	EHS00_DURINT	DEC_5	DEC	5	0	Internal Duration
27	DURATION_EXT	☐	EHS00_DUREXT	DEC_5	DEC	5	0	External Duration
28	STATUS	☐	EHS00_STATUS	CHAR01	CHAR	1	0	Object Status	T7EHS00_STATUS
29	ACTIV_INACTIVE	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
30	FREQ_FULL_RV_EX	☐	EHS00_RAT15	EHS00_14RAT	CHAR	1	0	Frequency Reference Values Exceeded	T7EHS00RN
31	FREQ_ACT_LEV_EX	☐	EHS00_RAT16	EHS00_14RAT	CHAR	1	0	Frequency Trigger Levels Exceeded	T7EHS00RN
32	AGE_FROM	☐	EHS00_AGEFROM	NUMC2	NUMC	2	0	Age Restriction: Age from
33	AGE_TO	☐	EHS00_AGETO	NUMC2	NUMC	2	0	Age Restriction: Age to
34	CANCER_RELATED	☐	EHS00_CANCER	CHAR1	CHAR	1	0	Indicator for Cancer Screening
35	.INCLUDE	☐				0	0	EHS: Structure for Administration Fields
36	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
37	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
38	CRDTIMESTAMP	☐	EHS00_CRTS		DEC	15	0	Creation Time
39	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
40	UPDTIMESTAMP	☐	EHS00_UPDTS		DEC	15	0	Time of Last Change
41	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
42	REASON_COMB	☐	EHS00E_PROT_REASON_COMB		CHAR	1	0	Link Triggering Causes with AND

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_PROT	AND_LTA_TRIGGER	T7EHS00RA	ARATE	REF	C	CN
2	T7EHS00_PROT	ER_RAT_FREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
3	T7EHS00_PROT	ER_RAT_TRIG	T7EHS00RA	ARATE	REF	C	CN
4	T7EHS00_PROT	FREQ_ACT_LEV_EX	T7EHS00RN	NRATE	REF	C	CN
5	T7EHS00_PROT	FREQ_FULL_RV_EX	T7EHS00RN	NRATE	REF	C	CN
6	T7EHS00_PROT	INGESTFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
7	T7EHS00_PROT	LTA_TRIGGER	T7EHS00RA	ARATE	REF	C	CN
8	T7EHS00_PROT	MANDT	T000	MANDT	KEY	1	CN
9	T7EHS00_PROT	PGROUP	T7EHS00_PGROUP	PGROUP	KEY	1	CN
10	T7EHS00_PROT	POWNER	T7EHS00_POWNER	POWNER	REF	C	CN
11	T7EHS00_PROT	SKINEFFFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
12	T7EHS00_PROT	SKINEXPFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
13	T7EHS00_PROT	STATUS	T7EHS00_STATUS	STATUS	REF	1	CN
14	T7EHS00_PROT	WAEHR_EXT	TCURC	WAERS
15	T7EHS00_PROT	WAEHR_INT	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in