SAP ABAP Table T7EHS00_PROTAGNT (Agents for Protocol)

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_PROTAGNT	Table Relationship Diagram
Short Description	Agents for Protocol

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	T7EHS00_PROT
4	AGENT_ID	☑	EHS00_AGEID	CCIHD_EPID	CHAR	20	0	Agent	T7EHS00_AGENT
5	ENDDA	☑	ENDDATUM	DATUM	DATS	8	0	End Date
6	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
7	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
8	KTEXT	☐	EHS00_MEMO75	EHS00_MEMO75	CHAR	75	0	Notes Field (75 Characters)
9	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
11	STARDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
12	STOPDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
13	.INCLUDE	☐				0	0	EHS: Structure for Administration Fields
14	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
15	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
16	CRDTIMESTAMP	☐	EHS00_CRTS		DEC	15	0	Creation Time
17	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
18	UPDTIMESTAMP	☐	EHS00_UPDTS		DEC	15	0	Time of Last Change
19	AGE_FROM	☐	EHS00E_AG_AGE_FROM	EHS00D_AGE	NUMC	3	0	Age from Which Trigger Levels Apply
20	AGE_TO	☐	EHS00E_AG_AGE_TO		NUMC	3	0	Age to Which Trigger Levels Apply
21	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
22	LTA_TRIGGER	☐	EHS00_AERT1	EHS00_AERAT	CHAR	1	0	Long-Term Average Trigger Level	T7EHS00RA
23	FREQ_FULL_RV_EX	☐	EHS00_RAT15	EHS00_14RAT	CHAR	1	0	Frequency Reference Values Exceeded	T7EHS00RN
24	FREQ_ACT_LEV_EX	☐	EHS00_RAT16	EHS00_14RAT	CHAR	1	0	Frequency Trigger Levels Exceeded	T7EHS00RN
25	ER_RAT_TRIG	☐	EHS00_AERT3	EHS00_AERAT	CHAR	1	0	Short-Time Exposure Rating	T7EHS00RA
26	ER_RAT_FREQ_TRIG	☐	EHS00_RAT01	EHS00_14RAT	CHAR	1	0	Exposure Frequency Trigger Level	T7EHS00RN
27	AND_LTA_TRIGGER	☐	EHS00_AERT2	EHS00_AERAT	CHAR	1	0	Additional Long-Term Average Trigger Level	T7EHS00RA
28	SKINEFFFREQ_TRIG	☐	EHS00_RAT03	EHS00_14RAT	CHAR	1	0	Skin Exposure Effects Trigger Level	T7EHS00RN
29	SKINEXPFREQ_TRIG	☐	EHS00_RAT02	EHS00_14RAT	CHAR	1	0	Skin Absorption Trigger Level	T7EHS00RN
30	INGESTFREQ_TRIG	☐	EHS00_RAT04	EHS00_14RAT	CHAR	1	0	Ingestion Effects Trigger Level	T7EHS00RN

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_PROTAGNT	AGENT_ID	T7EHS00_AGENT	AGENT_ID	KEY
2	T7EHS00_PROTAGNT	AND_LTA_TRIGGER	T7EHS00RA	ARATE	REF	C	CN
3	T7EHS00_PROTAGNT	ER_RAT_FREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
4	T7EHS00_PROTAGNT	ER_RAT_TRIG	T7EHS00RA	ARATE	REF	C	CN
5	T7EHS00_PROTAGNT	FREQ_ACT_LEV_EX	T7EHS00RN	NRATE	REF	C	CN
6	T7EHS00_PROTAGNT	FREQ_FULL_RV_EX	T7EHS00RN	NRATE	REF	C	CN
7	T7EHS00_PROTAGNT	INGESTFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
8	T7EHS00_PROTAGNT	LTA_TRIGGER	T7EHS00RA	ARATE	REF	C	CN
9	T7EHS00_PROTAGNT	MANDT	T000	MANDT	KEY	1	CN
10	T7EHS00_PROTAGNT	PGROUP	T7EHS00_PGROUP	PGROUP	KEY	1	CN
11	T7EHS00_PROTAGNT	PNUMBER	T7EHS00_PROT	PNUMBER	KEY	1	CN
12	T7EHS00_PROTAGNT	SKINEFFFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
13	T7EHS00_PROTAGNT	SKINEXPFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN

History

Last changed by/on	SAP	20050219
SAP Release Created in