SAP ABAP Table EHS00S_PROT_IOT (EHS: I/O Structure of Basic Data - Health Surv. 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	INTTAB	Structure
Structure	EHS00S_PROT_IOT	Table Relationship Diagram
Short Description	EHS: I/O Structure of Basic Data - Health Surv. Protocol

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	EHS: Standard fields for IOTABs (step loop library)
2	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
3	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
4	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
5	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
6	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
7	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
8	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
9	.INCLUDE	☐				0	0	EHS: Standard Fields for EHS-OH API Structures
10	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
11	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
12	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
13	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
14	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
15	EXTINFO	☐	ESEEXTINFO	CHAR10	CHAR	10	0	External Information
16	ACTYPE	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
17	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
19	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
20	.INCLUDE	☐				0	0	Health Surveillance Protocols
21	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
22	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
23	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number
24	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
25	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
26	POWNER	☐	EHS00_POWNER	EHS00_POWNER	CHAR	20	0	Protocol Owner	T7EHS00_POWNER
27	LTEXT	☐	EHS00_LTFLAG	XFELD	CHAR	1	0	Long Text Exists
28	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
29	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
30	REGULATORY	☐	EHS00_REGUL	EHS00_REGUL	CHAR	1	0	Regulatory Protocol
31	MANDATORY	☐	EHS00_MANDA	EHS00_MANDA	CHAR	1	0	Mandatory Examination
32	SCHEDNR	☐	EHS00_SCHED	EHS00_SCHED	CHAR	1	0	Health Surveillance Protocol Type	*
33	LTA_TRIGGER	☐	EHS00_AERT1	EHS00_AERAT	CHAR	1	0	Long-Term Average Trigger Level	T7EHS00RA
34	NRT_TRIGGER	☐	EHS00_NRTTR	EHS00_NRTTR	CHAR	1	0	Nonroutine Task
35	AND_LTA_TRIGGER	☐	EHS00_AERT2	EHS00_AERAT	CHAR	1	0	Additional Long-Term Average Trigger Level	T7EHS00RA
36	ER_RAT_TRIG	☐	EHS00_AERT3	EHS00_AERAT	CHAR	1	0	Short-Time Exposure Rating	T7EHS00RA
37	ER_RAT_FREQ_TRIG	☐	EHS00_RAT01	EHS00_14RAT	CHAR	1	0	Exposure Frequency Trigger Level	T7EHS00RN
38	SKINEXPFREQ_TRIG	☐	EHS00_RAT02	EHS00_14RAT	CHAR	1	0	Skin Absorption Trigger Level	T7EHS00RN
39	SKINEFFFREQ_TRIG	☐	EHS00_RAT03	EHS00_14RAT	CHAR	1	0	Skin Exposure Effects Trigger Level	T7EHS00RN
40	INGESTFREQ_TRIG	☐	EHS00_RAT04	EHS00_14RAT	CHAR	1	0	Ingestion Effects Trigger Level	T7EHS00RN
41	ALWAYS_CHECK	☐	EHS00_ALWCH	EHS00_ALWCH	CHAR	1	0	Check Assignment of Protocol Manually
42	COST_INT	☐	EHS00_COSTINT	WERT8	CURR	15	2	Internal Costs
43	COST_EXT	☐	EHS00_COSTEXT	WERT8	CURR	15	2	External Costs
44	WAEHR_INT	☐	EHS00_WAERINT	WAERS	CUKY	5	0	Costs Currency	TCURC
45	WAEHR_EXT	☐	EHS00_WAEREXT	WAERS	CUKY	5	0	Costs Currency	TCURC
46	DURATION_INT	☐	EHS00_DURINT	DEC_5	DEC	5	0	Internal Duration
47	DURATION_EXT	☐	EHS00_DUREXT	DEC_5	DEC	5	0	External Duration
48	STATUS	☐	EHS00_STATUS	CHAR01	CHAR	1	0	Object Status	T7EHS00_STATUS
49	ACTIV_INACTIVE	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
50	FREQ_FULL_RV_EX	☐	EHS00_RAT15	EHS00_14RAT	CHAR	1	0	Frequency Reference Values Exceeded	T7EHS00RN
51	FREQ_ACT_LEV_EX	☐	EHS00_RAT16	EHS00_14RAT	CHAR	1	0	Frequency Trigger Levels Exceeded	T7EHS00RN
52	AGE_FROM	☐	EHS00_AGEFROM	NUMC2	NUMC	2	0	Age Restriction: Age from
53	AGE_TO	☐	EHS00_AGETO	NUMC2	NUMC	2	0	Age Restriction: Age to
54	CANCER_RELATED	☐	EHS00_CANCER	CHAR1	CHAR	1	0	Indicator for Cancer Screening
55	.INCLUDE	☐				0	0	EHS: Structure for Administration Fields
56	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
57	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
58	CRDTIMESTAMP	☐	EHS00_CRTS		DEC	15	0	Creation Time
59	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
60	UPDTIMESTAMP	☐	EHS00_UPDTS		DEC	15	0	Time of Last Change
61	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
62	REASON_COMB	☐	EHS00E_PROT_REASON_COMB		CHAR	1	0	Link Triggering Causes with AND
63	PGROUPNAM	☐	EHS00_PGROUPNAM	TEXT20	CHAR	20	0	Description of Health Surveillance Protocol Category
64	SCHEDNAM	☐	EHS00_SCHEDNAM	TEXT20	CHAR	20	0	Description of Protocol Type
65	PNAME	☐	EHS00_PNAME	TEXT40	CHAR	40	0	Description of Health Surveillance Protocol
66	STATUS_TEXT	☐	EHS00_STATUST	TEXT30	CHAR	30	0	Object Status
67	STATUS_ICON	☐	EHS00E_PROT_STATUS_ICON	TEXT50	CHAR	50	0	Health-Surveillance Protocol Status
68	UNSCHED	☐	EHS00E_PROT_UNSCHED		CHAR	1	0	Unplanned Health Surveillance Protocol
69	GENDERTEXT	☐	CCIHE_GENDERTEXT	CHAR60	CHAR	60	0	Description of Gender

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	200