SAP ABAP Table CCIHS_IPEVAIOT (EHS: Inc./Acc. Log - Data for Person Affected (Event))

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
     ⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety

Basic Data

Table Category	INTTAB	Structure
Structure	CCIHS_IPEVAIOT	Table Relationship Diagram
Short Description	EHS: Inc./Acc. Log - Data for Person Affected (Event)

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: Inc./Acc. Log - Data for Person Affected (Event)
10	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
12	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
13	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
14	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
15	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
16	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
17	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
18	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
19	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
20	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
21	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
22	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
23	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
24	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
25	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
26	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
27	.INCLUDE	☐				0	0	EHS: Event Data for Person Affected
28	FRTRMT	☐	CCIHE_FRTRMT	CCIHD_PERSON	CHAR	10	0	Further Treatment	*
29	FRTRMTFLG	☐	CCIHE_FRTRMTFLG	CCIHD_EXTFLG	CHAR	1	0	Physician Giving Further Treatment (Internal/External)
30	INTNOTE	☐	CCIHE_INTNOTELXT	TEXT72	CHAR	72	0	Commentary for internal use
31	INTNOTEFLG	☐	CCIHE_INTNOTEFLG	FLAG	CHAR	1	0	Long Text Available for an Internal Note
32	EXTNOTE	☐	CCIHE_EXTNOTELXT	TEXT72	CHAR	72	0	Information for External Purposes
33	EXTNOTEFLG	☐	CCIHE_EXTNOTEFLG	FLAG	CHAR	1	0	Long Text Available on External Note
34	FRTRMTGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
35	.INCLUDE	☐				0	0	EHS: Absence Person Affected (Event Data)
36	OFFJOBDAT	☐	CCIHE_OFFJOBDAT	DATUM	DATS	8	0	Date of Ceasing to Work
37	OFFJOBTIME	☐	CCIHE_OFFJOBTIME	UZEIT	TIMS	6	0	Time of Ceasing to Work
38	IPABSSUBTYPE	☐	CCIHE_IPABSSUBTYPE	SUBTYP	CHAR	4	0	Absence Type	*
39	IPABSBEGDAT	☐	CCIHE_IPABSBEGDAT	DATUM	DATS	8	0	Start Date of Absence
40	IPABSENDDAT	☐	CCIHE_IPABSENDDAT	DATUM	DATS	8	0	End Date of Absence
41	IPABSSEQNUM	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
42	IPABSESTDAYS	☐	CCIHE_IPABSESTDAYS	CCIHD_DAYS	DEC	6	2	Estimated Duration of Absence (in Days)
43	IPABSDAYS	☐	CCIHE_IPABSDAYS	CCIHD_IPABSDAYS	DEC	6	2	Number of Workdays Absent
44	IPABSCALDAYS	☐	CCIHE_IPABSCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days
45	IPRSWBEGDAT	☐	CCIHE_IPRSWBEGDAT	DATUM	DATS	8	0	Start of Restriction or Date of Job Transfer
46	IPRSWENDDAT	☐	CCIHE_IPRSWENDDAT	DATUM	DATS	8	0	End Date of Restriction or Job Transfer
47	IPRSWDAYS	☐	CCIHE_IPRSWDAYS	DEC4_2	DEC	6	2	Number of Workdays with Restriction or Job Transfer
48	IPRSWCALDAYS	☐	CCIHE_IPRSWCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days with Restriction or Job Transfer
49	RECNTIP	☐	CCIHE_RECNTIP	ESDRECN	NUMC	20	0	Reference to Person Affected in Table IP
50	IALPCAT	☐	CCIHE_IALPCAT	CCIHD_IALPCAT	CHAR	3	0	Accident Category	CCIHC_IALPCAT
51	IAREPORTFLG	☐	CCIHE_IAREPORTFLG	ESDFLAG	CHAR	1	0	Reportable Accident
52	IALPREPID	☐	CCIHE_IALPREPID	CCIHD_PRID	CHAR	20	0	Accident Notification Number
53	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
54	IALPSTWCFLG	☐	CCIHE_IALPSTWCFLG	ESDFLAG	CHAR	1	0	Main Work Center
55	IALDEADFLG	☐	CCIHE_IALPDEADFLG	ESDFLAG	CHAR	1	0	Fatality
56	FAPHYS	☐	CCIHE_FAPHYS	CCIHD_PERSON	CHAR	10	0	First Physician to Give Treatment	*
57	FAPHYSFLG	☐	CCIHE_FAPHYSFLG	CCIHD_EXTFLG	CHAR	1	0	First Physician to Give Treatment (Internal/External)
58	IALPHOSP	☐	CCIHE_IALPHOSP	BU_PARTNER	CHAR	10	0	Hospital	BUT000
59	PERSPROT	☐	CCIHE_PERSPROT	CCIHD_PERSPROT	CHAR	21	0	Personal Protective Equipment
60	TECHPROT	☐	CCIHE_TECHPROT	CCIHD_TECHPROT	CHAR	21	0	Technical Safety Device
61	IPEVAAC	☐	CCIHE_IPEVAAC	CHAR21	CHAR	21	0	Safety Measures Taken to Prevent Accidents
62	IACAUS	☐	CCIHE_IACAUS	CCIHD_IACAUS	CHAR	21	0	Cause of Accident	*
63	IAEXINF	☐	CCIHE_IAEXINF	CCIHD_IAEXINF	CHAR	21	0	External Influences on Accident	*
64	IAOBJ	☐	CCIHE_IAOBJ	CCIHD_IAOBJ	CHAR	21	0	Object or Substance that Caused Accident	*
65	IAOBJM	☐	CCIHE_IAOBJM	CCIHD_IAOBJM	CHAR	21	0	Movement of the Object that Caused the Accident	*
66	IPACT	☐	CCIHE_IPACT	CCIHD_IPACT	CHAR	21	0	Activity of Injured Person	*
67	IPMOV	☐	CCIHE_IPMOV	CCIHD_IPMOV	CHAR	21	0	Movement of Injured Person	*
68	IPSTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
69	RELWITNESS	☐	CCIHE_RELWIT	CCIHD_PERSON	CHAR	10	0	Relevant Witness for Person Affected
70	RWITEXFLAG	☐	CCIHE_IPPFLAG	CCIHD_PERSFLAG	CHAR	1	0	External Person
71	IALPEXP	☐	CCIHE_IALPEXP	CCIHD_IALPEXP	NUMC	3	0	Time at Work Center in Months
72	FAPHYSGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
73	RELWITNESSGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
74	OFFJOBTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
75	PRIVCONCFLG	☐	CCIHE_PRIVCONCFLG	ESDFLAG	CHAR	1	0	Privacy Concern Case
76	EMERGRMFLG	☐	CCIHE_EMERGRMFLG	ESDFLAG	CHAR	1	0	Treatment in Emergency Room
77	INPATFLG	☐	CCIHE_INPATFLG	ESDFLAG	CHAR	1	0	Treatment Overnight As Inpatient
78	IPDEATHDATE	☐	CCIHE_IPDEATHDATE	DATUM	DATS	8	0	Date of Death of Person Affected
79	IPACTWTBEG	☐	CCIHE_IPACTWTBEG	TIME	TIMS	6	0	Start of Actual Working Time
80	IPACTWTEND	☐	CCIHE_IPACTWTEND	TIME	TIMS	6	0	End of Actual Working Time
81	IALOC	☐	CCIHE_FALOC	CCIHD_FALOC	CHAR	3	0	Entry Location	CCIHC_FALOC
82	IATRTOHC	☐	CCIHE_IATRTOHC	CCIHD_TRMEANS	CHAR	21	0	Transport to First Aid Center By
83	IATRFRHC	☐	CCIHE_IATRFRHC	CCIHD_TRMEANS	CHAR	21	0	Means of Further Transport from Health Center
84	UNCONSCIOUS	☐	CCIHE_UNCONSCIOUS	ESDFLAG	CHAR	1	0	Person Unconscious
85	RESUSCITATION	☐	CCIHE_RESUSCITATION	ESDFLAG	CHAR	1	0	Resuscitation Performed
86	HOSPITALIZATION	☐	CCIHE_HOSPITALIZATION	ESDFLAG	CHAR	1	0	Hospitalization for over 24 Hours
87	.INCLUDE	☐				0	0	EHS: Absence Person Affected (Derived Data)
88	IPABSBEGTIME	☐	CCIHE_IPABSBEGTIME	UZEIT	TIMS	6	0	Start Time of Absence
89	IPABSENDTIME	☐	CCIHE_IPABSENDTIME	UZEIT	TIMS	6	0	End Time of Absence
90	RETJOBDAT	☐	CCIHE_RETJOBDAT	DATUM	DATS	8	0	Return to Work
91	IPABSHOURS	☐	ABS_ATT_HOURS	JRSTD	DEC	7	2	Absence/Attendance hours
92	IPABSLFZED	☐	ENDDA	DATUM	DATS	8	0	End Date
93	IPABSLINK	☐	CCIHE_IPABSLINK	CHAR2	CHAR	2	0	Linking Absences
94	IPABSFLGKEYNF	☐	CCIHE_IPABSFLGKEYNF	CCIHD_IPABSFLGKEYNF	CHAR	1	0	Absence Record Not Found Owing to Key Change
95	IPABSSUBTYPETXT	☐	CCIHE_IPABSSUBTYPETXT	TEXT25	CHAR	25	0	Description of Absence Type
96	.INCLUDE	☐				0	0	EHS: Work Schedule Person Affected
97	IPREGWTTXT	☐	CCIHE_IPREGWTTXT	TEXT20	CHAR	20	0	Daily Work Schedule
98	IPREGWTBEG	☐	CCIHE_IPREGWTBEG	TIME	TIMS	6	0	Start of Normal Working Time
99	IPREGWTEND	☐	CCIHE_IPREGWTEND	TIME	TIMS	6	0	End of Normal Working Time
100	FRTRMTNAM	☐	CCIHE_FRTRMTNAM	TEXT60	CHAR	60	0	Further Treatment
101	IALPTYPETXT	☐	CCIHE_IATYPETXT	TEXT40	CHAR	40	0	Description of Log Entry Type
102	IALPCATXT	☐	CCIHE_IACATXT	TEXT40	CHAR	40	0	Accident Category
103	FAPHYSNAM	☐	CCIHE_FAPHYSNAM	TEXT60	CHAR	60	0	First Physician to Give Treatment
104	IALPHOSPNAM	☐	CCIHE_IALPHOSPNAM	TEXT60	CHAR	60	0	Name of Hospital
105	QUESFLG	☐	CCIHE_QUESFLG	ESDFLAG	CHAR	1	0	Questionnaire Exists
106	IACAUSTXT	☐	CCIHE_IACAUSTXT	TEXT132	CHAR	132	0	Description of Cause of Accident
107	IAEXINFTXT	☐	CCIHE_IAEXINFTXT	TEXT132	CHAR	132	0	Description of External Influences on Accident
108	IAOBJTXT	☐	CCIHE_IAOBJTXT	TEXT132	CHAR	132	0	Description of the Object that Caused the Accident
109	IAOBJMTXT	☐	CCIHE_IAOBJMTXT	TEXT132	CHAR	132	0	Desc. of the Movement of the Object that Caused the Accident
110	IPACTTXT	☐	CCIHE_IPACTTXT	TEXT132	CHAR	132	0	Description of Activity of Injured Person
111	IPMOVTXT	☐	CCIHE_IPMOVTXT	TEXT132	CHAR	132	0	Description of Movement of Injured Person
112	PERSPROTTXT	☐	CCIHE_PERSPROTTXT	CHAR132	CHAR	132	0	Description of Personal Protective Equipment
113	TECHPROTTXT	☐	CCIHE_TECHPROTTXT	CHAR132	CHAR	132	0	Description of Technical Safety Device
114	IPEVAACTXT	☐	CCIHE_IPEVAACTXT	TEXT132	CHAR	132	0	Description of Safety Measure Taken to Prevent Accidents
115	IPSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
116	IPSHSTATNAM	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
117	KEYDRAWNFLG	☐	CCIHE_KEYDRAWN	ESDFLAG	CHAR	1	0	Key Assigned Automatically
118	IPAGE	☐	CCIHE_IPAGE	CCIHD_PERSONAGE	NUMC	3	0	Age in Years at Time of Accident
119	LSTSHIFT	☐	CCIHE_LSTSHIFT	NUMC3	NUMC	3	0	Lost Shifts
120	RELWITNESSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
121	FAPHYSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
122	FRTRMTGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
123	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
124	NOINPATFLG	☐	CCIHE_INPATFLG	ESDFLAG	CHAR	1	0	Treatment Overnight As Inpatient
125	NOEMERGRMFLG	☐	CCIHE_EMERGRMFLG	ESDFLAG	CHAR	1	0	Treatment in Emergency Room
126	IALDEADDATE	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
127	RETJOBYESFLG	☐	ESEINTERFLG	ESDYESNO	CHAR	1	0	Only for Use in Industrial Hygiene and Safety
128	RETJOBNOFLG	☐	ESEINTERFLG	ESDYESNO	CHAR	1	0	Only for Use in Industrial Hygiene and Safety
129	NUMABSASSIGNED	☐	CCIHE_IPNUMABS	NUMC3	NUMC	3	0	Number of Assigned Absences
130	NUMRESASSIGNED	☐	CCIHE_IPNUMRES	NUMC3	NUMC	3	0	Number of Assigned Restrictions
131	STLTX	☐	STLTX	TEXT25	CHAR	25	0	Job Title
132	IALOCTXT	☐	CCIHE_FALOCTXT	TEXT40	CHAR	40	0	Description of Entry Location
133	IATRTOHCTXT	☐	CCIHE_TRMEANSTXT	TEXT132	CHAR	132	0	Description of Means of Transport
134	IATRFRHCTXT	☐	CCIHE_TRMEANSTXT	TEXT132	CHAR	132	0	Description of Means of Transport

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_IPEVAIOT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_IPEVAIOT	IALOC	CCIHC_FALOC	FALOC	REF	C	CN
3	CCIHS_IPEVAIOT	IALPCAT	CCIHC_IALPCAT	IALPCAT	REF	C	CN
4	CCIHS_IPEVAIOT	IALPHOSP	BUT000	PARTNER	REF	C	CN
5	CCIHS_IPEVAIOT	MANDT	T000	MANDT	KEY	1	CN
6	CCIHS_IPEVAIOT	OFFJOBTIMEZONE	TTZZ	TZONE	REF	1	CN
7	CCIHS_IPEVAIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in