SAP ABAP Table CCIHS_FALHIOT (EHS: IOTAB for Injury/Illness Log Entry (CCIHT_FAL))

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_FALHIOT	Table Relationship Diagram
Short Description	EHS: IOTAB for Injury/Illness Log Entry (CCIHT_FAL)

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: Injury/Illness Log
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	FAID	☐	CCIHE_FAID	CCIHD_FAID	CHAR	20	0	Injury/Illness Log Entry
28	FATYPE	☐	CCIHE_FATYPE	CCIHD_FATYPE	CHAR	3	0	Injury/Illness Log Entry Type	CCIHC_FATYPE
29	FAPLANT	☐	CCIHE_FAPLANT	WERKS	CHAR	4	0	Plant Assignment	T001W
30	FASTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
31	FAINITSTATUS	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
32	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
33	FALOC	☐	CCIHE_FALOC	CCIHD_FALOC	CHAR	3	0	Entry Location	CCIHC_FALOC
34	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
35	FATRANSFLG	☐	CCIHE_FATRANSFLG	ESDFLAG	CHAR	1	0	Data Record Is for Transfer to Incident/Accident Log
36	FATRANSDEC	☐	CCIHE_FATRANSDEC	ESDEXTFLAG	CHAR	1	0	Transfer decision injury/illness log - incident/accident log
37	RECNTIA	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
38	TRANSDAT	☐	CCIHE_TRANSDAT	DATUM	DATS	8	0	Date of Data Transfer Injury/Illness Log to Inc./Acc. Log
39	TRANSTIME	☐	CCIHE_TRANSTIME	TIME	TIMS	6	0	Time of Data Transfer Injury/Illness Log to Inc./Acc. Log
40	TRANSNAM	☐	CCIHE_TRANSNAM	USNAM	CHAR	12	0	Administrator Data Transfer Injury/Illness Log to I/A Log
41	FATALFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
42	FAFIRSTRFLG	☐	CCIHE_FAFIRSTRFLG	ESDFLAG	CHAR	1	0	Initial Treatment After Event
43	FADAT	☐	CCIHE_FADAT	DATUM	DATS	8	0	Date When Aid Was Given
44	FATIME	☐	CCIHE_FATIME	TIME	TIMS	6	0	Time and Date of Aid Given
45	FAHELPER	☐	CCIHE_FAHELPER	CCIHD_PERSON	CHAR	10	0	First-Aider
46	FAHELPERFLG	☐	CCIHE_FAHELPERFLG	CCIHD_EXTFLG	CHAR	1	0	First-Aider (External)
47	FATRTOHC	☐	CCIHE_FATRTOHC	CCIHD_TRMEANS	CHAR	21	0	Transport to First Aid Center By	*
48	FATRFRHC	☐	CCIHE_FATRFRHC	CCIHD_TRMEANS	CHAR	21	0	Means of Further Transport from Health Center	*
49	.INCLUDE	☐				0	0	EHS: Event Data
50	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
51	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
52	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
53	ACLOC	☐	CCIHE_ACLOC	CCIHD_ACLOC	CHAR	10	0	Accident Location	*
54	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
55	.INCLUDE	☐				0	0	EHS: Event Data for Person Affected
56	FRTRMT	☐	CCIHE_FRTRMT	CCIHD_PERSON	CHAR	10	0	Further Treatment	*
57	FRTRMTFLG	☐	CCIHE_FRTRMTFLG	CCIHD_EXTFLG	CHAR	1	0	Physician Giving Further Treatment (Internal/External)
58	INTNOTE	☐	CCIHE_INTNOTELXT	TEXT72	CHAR	72	0	Commentary for internal use
59	INTNOTEFLG	☐	CCIHE_INTNOTEFLG	FLAG	CHAR	1	0	Long Text Available for an Internal Note
60	EXTNOTE	☐	CCIHE_EXTNOTELXT	TEXT72	CHAR	72	0	Information for External Purposes
61	EXTNOTEFLG	☐	CCIHE_EXTNOTEFLG	FLAG	CHAR	1	0	Long Text Available on External Note
62	FRTRMTGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
63	.INCLUDE	☐				0	0	EHS: Absence Person Affected (Event Data)
64	OFFJOBDAT	☐	CCIHE_OFFJOBDAT	DATUM	DATS	8	0	Date of Ceasing to Work
65	OFFJOBTIME	☐	CCIHE_OFFJOBTIME	UZEIT	TIMS	6	0	Time of Ceasing to Work
66	IPABSSUBTYPE	☐	CCIHE_IPABSSUBTYPE	SUBTYP	CHAR	4	0	Absence Type	*
67	IPABSBEGDAT	☐	CCIHE_IPABSBEGDAT	DATUM	DATS	8	0	Start Date of Absence
68	IPABSENDDAT	☐	CCIHE_IPABSENDDAT	DATUM	DATS	8	0	End Date of Absence
69	IPABSSEQNUM	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
70	IPABSESTDAYS	☐	CCIHE_IPABSESTDAYS	CCIHD_DAYS	DEC	6	2	Estimated Duration of Absence (in Days)
71	IPABSDAYS	☐	CCIHE_IPABSDAYS	CCIHD_IPABSDAYS	DEC	6	2	Number of Workdays Absent
72	IPABSCALDAYS	☐	CCIHE_IPABSCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days
73	IPRSWBEGDAT	☐	CCIHE_IPRSWBEGDAT	DATUM	DATS	8	0	Start of Restriction or Date of Job Transfer
74	IPRSWENDDAT	☐	CCIHE_IPRSWENDDAT	DATUM	DATS	8	0	End Date of Restriction or Job Transfer
75	IPRSWDAYS	☐	CCIHE_IPRSWDAYS	DEC4_2	DEC	6	2	Number of Workdays with Restriction or Job Transfer
76	IPRSWCALDAYS	☐	CCIHE_IPRSWCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days with Restriction or Job Transfer
77	FAHELPERGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
78	FATIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
79	EVTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
80	OFFJOBTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
81	IAREPORTFLG	☐	CCIHE_IAREPORTFLG	ESDFLAG	CHAR	1	0	Reportable Accident
82	PRIVCONCFLG	☐	CCIHE_PRIVCONCFLG	ESDFLAG	CHAR	1	0	Privacy Concern Case
83	EMERGRMFLG	☐	CCIHE_EMERGRMFLG	ESDFLAG	CHAR	1	0	Treatment in Emergency Room
84	INPATFLG	☐	CCIHE_INPATFLG	ESDFLAG	CHAR	1	0	Treatment Overnight As Inpatient
85	IPDEATHDATE	☐	CCIHE_IPDEATHDATE	DATUM	DATS	8	0	Date of Death of Person Affected
86	UNCONSCIOUS	☐	CCIHE_UNCONSCIOUS	ESDFLAG	CHAR	1	0	Person Unconscious
87	RESUSCITATION	☐	CCIHE_RESUSCITATION	ESDFLAG	CHAR	1	0	Resuscitation Performed
88	HOSPITALIZATION	☐	CCIHE_HOSPITALIZATION	ESDFLAG	CHAR	1	0	Hospitalization for over 24 Hours
89	FATYPETXT	☐	CCIHE_FATYPETXT	TEXT40	CHAR	40	0	Description of Injury/Illness Log Entry Type
90	FALOCTXT	☐	CCIHE_FALOCTXT	TEXT40	CHAR	40	0	Description of Entry Location
91	STTXT	☐	CCIHE_STTXT	TEXT40	CHAR	40	0	System Status
92	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
93	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
94	FAHELPERNAM	☐	CCIHE_FAHELPNAM	TEXT60	CHAR	60	0	Name of First-Aider (Room or Center)
95	FATRTOHCTXT	☐	CCIHE_TRMEANSTXT	TEXT132	CHAR	132	0	Description of Means of Transport
96	FATRFRHCTXT	☐	CCIHE_TRMEANSTXT	TEXT132	CHAR	132	0	Description of Means of Transport
97	ACLOCTXT	☐	CCIHE_ACLOCTXT	TEXT40	CHAR	40	0	Description of Accident Location
98	QUESFLG	☐	CCIHE_QUESFLG	ESDFLAG	CHAR	1	0	Questionnaire Exists
99	FAPLANTTXT	☐	CCIHE_FAPLANTTXT	TEXT30	CHAR	30	0	Description of Plant for Injury/Illness Log Entry
100	FASHSTATNAM	☐	CCIHE_FASHSTATNAM	TEXT4	CHAR	4	0	Status of Injury/Illness Log Entry
101	FASTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
102	IALID	☐	CCIHE_IALID	CCIHD_IAID	CHAR	20	0	Incident/Accident Log Entry
103	KEYDRAWNFLG	☐	CCIHE_KEYDRAWN	ESDFLAG	CHAR	1	0	Key Assigned Automatically
104	TYESFLG	☐	CCIHE_TRANSFLG	ESDFLAG	CHAR	1	0	Status of Data Transfer Injury/Illness Log to Inc./Acc. Log
105	TNOFLG	☐	CCIHE_TRANSFLG	ESDFLAG	CHAR	1	0	Status of Data Transfer Injury/Illness Log to Inc./Acc. Log
106	TDINITFLG	☐	CCIHE_TRANSFLG	ESDFLAG	CHAR	1	0	Status of Data Transfer Injury/Illness Log to Inc./Acc. Log
107	TDYESFLG	☐	CCIHE_TRANSFLG	ESDFLAG	CHAR	1	0	Status of Data Transfer Injury/Illness Log to Inc./Acc. Log
108	TDNOFLG	☐	CCIHE_TRANSFLG	ESDFLAG	CHAR	1	0	Status of Data Transfer Injury/Illness Log to Inc./Acc. Log
109	FRTRMTNAM	☐	CCIHE_FRTRMTNAM	TEXT60	CHAR	60	0	Further Treatment
110	MTNLANGUTXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
111	FAHELPERGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
112	FRTRMTGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
113	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_FALHIOT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_FALHIOT	EVTIMEZONE	TTZZ	TZONE	REF	1	CN
3	CCIHS_FALHIOT	FALOC	CCIHC_FALOC	FALOC	REF	C	CN
4	CCIHS_FALHIOT	FAPLANT	T001W	WERKS	REF	1	CN
5	CCIHS_FALHIOT	FATIMEZONE	TTZZ	TZONE	REF	1	CN
6	CCIHS_FALHIOT	FATYPE	CCIHC_FATYPE	FATYPE	REF	1	CN
7	CCIHS_FALHIOT	MANDT	T000	MANDT	KEY	1	CN
8	CCIHS_FALHIOT	MTNLANGU	T002	SPRAS	REF	1	CN
9	CCIHS_FALHIOT	OFFJOBTIMEZONE	TTZZ	TZONE	REF	1	CN
10	CCIHS_FALHIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in