CCIHT_FAL

EHS: Injury/Illness Log | #masterdata | Component: Environment, Health, and Safety / Product Compliance
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
TRANSDAT Date of Data Transfer Injury/Illness Log to Inc./Acc. Log
TRANSTIME Time of Data Transfer Injury/Illness Log to Inc./Acc. Log
FADAT Date When Aid Was Given
FATIME Time and Date of Aid Given
EVDAT Event Date
EVTIME Event Time
OFFJOBDAT Date of Ceasing to Work
OFFJOBTIME Time of Ceasing to Work
IPABSBEGDAT Start Date of Absence
IPABSENDDAT End Date of Absence
IPRSWBEGDAT Start of Restriction or Date of Job Transfer
IPRSWENDDAT End Date of Restriction or Job Transfer
IPDEATHDATE Date of Death of Person Affected
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
FATRANSFLG Data Record Is for Transfer to Incident/Accident Log Show values
FATRANSDEC Transfer decision injury/illness log - incident/accident log Show values
FATALFLG Fatality Show values
FAFIRSTRFLG Initial Treatment After Event Show values
INTNOTEFLG Long Text Available for an Internal Note Show values
EXTNOTEFLG Long Text Available on External Note Show values
FRTRMTGRP Person Group Show values
FAHELPERGRP Person Group Show values
IAREPORTFLG Reportable Accident Show values
PRIVCONCFLG Privacy Concern Case Show values
EMERGRMFLG Treatment in Emergency Room Show values
INPATFLG Treatment Overnight As Inpatient Show values
UNCONSCIOUS Person Unconscious Show values
RESUSCITATION Resuscitation Performed Show values
HOSPITALIZATION Hospitalization for over 24 Hours Show values
BLOCKFLG Lock Indicator Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
RECNROOT Sequential Number of Data Record ESDRECN
FAID Injury/Illness Log Entry CCIHD_FAID
FASTATUS Status J_STATUS
FAINITSTATUS Initial Status of an Object J_STATUS
OBJNR Object number J_OBJNR
RECNTIA Sequential Number of Data Record ESDRECN
TRANSNAM Administrator Data Transfer Injury/Illness Log to I/A Log USNAM
FAHELPER First-Aider CCIHD_PERSON
FAHELPERFLG First-Aider (External) CCIHD_EXTFLG
FATRTOHC Transport to First Aid Center By CCIHD_TRMEANS
FATRFRHC Means of Further Transport from Health Center CCIHD_TRMEANS
RECNTWAH Reference to Work Area ESDRECN
ACLOCDESC Description of Accident Location TEXT60
FRTRMTFLG Physician Giving Further Treatment (Internal/External) CCIHD_EXTFLG
INTNOTE Commentary for internal use TEXT72
EXTNOTE Information for External Purposes TEXT72
IPABSSUBTYPE Absence Type SUBTYP
IPABSSEQNUM Number of Infotype Record With Same Key NUM03
IPABSESTDAYS Estimated Duration of Absence (in Days) CCIHD_DAYS
IPABSDAYS Number of Workdays Absent CCIHD_IPABSDAYS
IPABSCALDAYS Calendar Days CCIHD_IPABSCALDAYS
IPRSWDAYS Number of Workdays with Restriction or Job Transfer DEC4_2
IPRSWCALDAYS Calendar Days with Restriction or Job Transfer CCIHD_IPABSCALDAYS
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • CCIHT_FAL.AENNR == AENR.AENNR
  • CCIHT_FAL.MANDT == AENR.MANDT
Relationship to Time Zone Table
  • CCIHT_FAL.MANDT == TTZZ.CLIENT
  • CCIHT_FAL.EVTIMEZONE == TTZZ.TZONE
EHS: Foreign Key for Entry Location
  • Entry Location
  • Client
EHS: Foreign Key for Plant
  • CCIHT_FAL.MANDT == T001W.MANDT
  • CCIHT_FAL.FAPLANT == T001W.WERKS
Relationship to Time Zone Table
  • CCIHT_FAL.MANDT == TTZZ.CLIENT
  • CCIHT_FAL.FATIMEZONE == TTZZ.TZONE
EHS: Foreign Key for Injury/Illness Log Entry Type
Client CCIHT_FAL.MANDT == T000.MANDT
EHS: Relationship to Maintenance Language CCIHT_FAL.MTNLANGU == T002.SPRAS
Relationship to Time Zone
  • CCIHT_FAL.MANDT == TTZZ.CLIENT
  • CCIHT_FAL.OFFJOBTIMEZONE == TTZZ.TZONE
EHS: Foreign Key for Substance Authorization Group
  • CCIHT_FAL.MANDT == TCG56.MANDT
  • CCIHT_FAL.SRSID == TCG56.SRSID