SAP ABAP Table CCIHT_FAL (EHS: Injury/Illness Log)

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	TRANSP	Transparent table
Transparent table	CCIHT_FAL	Table Relationship Diagram
Short Description	EHS: Injury/Illness Log

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	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	FAID	☐	CCIHE_FAID	CCIHD_FAID	CHAR	20	0	Injury/Illness Log Entry
19	FATYPE	☐	CCIHE_FATYPE	CCIHD_FATYPE	CHAR	3	0	Injury/Illness Log Entry Type	CCIHC_FATYPE
20	FAPLANT	☐	CCIHE_FAPLANT	WERKS	CHAR	4	0	Plant Assignment	T001W
21	FASTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
22	FAINITSTATUS	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
23	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
24	FALOC	☐	CCIHE_FALOC	CCIHD_FALOC	CHAR	3	0	Entry Location	CCIHC_FALOC
25	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
26	FATRANSFLG	☐	CCIHE_FATRANSFLG	ESDFLAG	CHAR	1	0	Data Record Is for Transfer to Incident/Accident Log
27	FATRANSDEC	☐	CCIHE_FATRANSDEC	ESDEXTFLAG	CHAR	1	0	Transfer decision injury/illness log - incident/accident log
28	RECNTIA	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
29	TRANSDAT	☐	CCIHE_TRANSDAT	DATUM	DATS	8	0	Date of Data Transfer Injury/Illness Log to Inc./Acc. Log
30	TRANSTIME	☐	CCIHE_TRANSTIME	TIME	TIMS	6	0	Time of Data Transfer Injury/Illness Log to Inc./Acc. Log
31	TRANSNAM	☐	CCIHE_TRANSNAM	USNAM	CHAR	12	0	Administrator Data Transfer Injury/Illness Log to I/A Log
32	FATALFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
33	FAFIRSTRFLG	☐	CCIHE_FAFIRSTRFLG	ESDFLAG	CHAR	1	0	Initial Treatment After Event
34	FADAT	☐	CCIHE_FADAT	DATUM	DATS	8	0	Date When Aid Was Given
35	FATIME	☐	CCIHE_FATIME	TIME	TIMS	6	0	Time and Date of Aid Given
36	FAHELPER	☐	CCIHE_FAHELPER	CCIHD_PERSON	CHAR	10	0	First-Aider
37	FAHELPERFLG	☐	CCIHE_FAHELPERFLG	CCIHD_EXTFLG	CHAR	1	0	First-Aider (External)
38	FATRTOHC	☐	CCIHE_FATRTOHC	CCIHD_TRMEANS	CHAR	21	0	Transport to First Aid Center By
39	FATRFRHC	☐	CCIHE_FATRFRHC	CCIHD_TRMEANS	CHAR	21	0	Means of Further Transport from Health Center
40	.INCLUDE	☐				0	0	EHS: Event Data
41	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
42	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
43	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
44	ACLOC	☐	CCIHE_ACLOC	CCIHD_ACLOC	CHAR	10	0	Accident Location	*
45	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
46	.INCLUDE	☐				0	0	EHS: Event Data for Person Affected
47	FRTRMT	☐	CCIHE_FRTRMT	CCIHD_PERSON	CHAR	10	0	Further Treatment	*
48	FRTRMTFLG	☐	CCIHE_FRTRMTFLG	CCIHD_EXTFLG	CHAR	1	0	Physician Giving Further Treatment (Internal/External)
49	INTNOTE	☐	CCIHE_INTNOTELXT	TEXT72	CHAR	72	0	Commentary for internal use
50	INTNOTEFLG	☐	CCIHE_INTNOTEFLG	FLAG	CHAR	1	0	Long Text Available for an Internal Note
51	EXTNOTE	☐	CCIHE_EXTNOTELXT	TEXT72	CHAR	72	0	Information for External Purposes
52	EXTNOTEFLG	☐	CCIHE_EXTNOTEFLG	FLAG	CHAR	1	0	Long Text Available on External Note
53	FRTRMTGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
54	.INCLUDE	☐				0	0	EHS: Absence Person Affected (Event Data)
55	OFFJOBDAT	☐	CCIHE_OFFJOBDAT	DATUM	DATS	8	0	Date of Ceasing to Work
56	OFFJOBTIME	☐	CCIHE_OFFJOBTIME	UZEIT	TIMS	6	0	Time of Ceasing to Work
57	IPABSSUBTYPE	☐	CCIHE_IPABSSUBTYPE	SUBTYP	CHAR	4	0	Absence Type	*
58	IPABSBEGDAT	☐	CCIHE_IPABSBEGDAT	DATUM	DATS	8	0	Start Date of Absence
59	IPABSENDDAT	☐	CCIHE_IPABSENDDAT	DATUM	DATS	8	0	End Date of Absence
60	IPABSSEQNUM	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
61	IPABSESTDAYS	☐	CCIHE_IPABSESTDAYS	CCIHD_DAYS	DEC	6	2	Estimated Duration of Absence (in Days)
62	IPABSDAYS	☐	CCIHE_IPABSDAYS	CCIHD_IPABSDAYS	DEC	6	2	Number of Workdays Absent
63	IPABSCALDAYS	☐	CCIHE_IPABSCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days
64	IPRSWBEGDAT	☐	CCIHE_IPRSWBEGDAT	DATUM	DATS	8	0	Start of Restriction or Date of Job Transfer
65	IPRSWENDDAT	☐	CCIHE_IPRSWENDDAT	DATUM	DATS	8	0	End Date of Restriction or Job Transfer
66	IPRSWDAYS	☐	CCIHE_IPRSWDAYS	DEC4_2	DEC	6	2	Number of Workdays with Restriction or Job Transfer
67	IPRSWCALDAYS	☐	CCIHE_IPRSWCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days with Restriction or Job Transfer
68	FAHELPERGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
69	FATIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
70	EVTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
71	OFFJOBTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
72	IAREPORTFLG	☐	CCIHE_IAREPORTFLG	ESDFLAG	CHAR	1	0	Reportable Accident
73	PRIVCONCFLG	☐	CCIHE_PRIVCONCFLG	ESDFLAG	CHAR	1	0	Privacy Concern Case
74	EMERGRMFLG	☐	CCIHE_EMERGRMFLG	ESDFLAG	CHAR	1	0	Treatment in Emergency Room
75	INPATFLG	☐	CCIHE_INPATFLG	ESDFLAG	CHAR	1	0	Treatment Overnight As Inpatient
76	IPDEATHDATE	☐	CCIHE_IPDEATHDATE	DATUM	DATS	8	0	Date of Death of Person Affected
77	UNCONSCIOUS	☐	CCIHE_UNCONSCIOUS	ESDFLAG	CHAR	1	0	Person Unconscious
78	RESUSCITATION	☐	CCIHE_RESUSCITATION	ESDFLAG	CHAR	1	0	Resuscitation Performed
79	HOSPITALIZATION	☐	CCIHE_HOSPITALIZATION	ESDFLAG	CHAR	1	0	Hospitalization for over 24 Hours

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in