| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | VALFR | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | VALTO | Valid-To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | DELFLG | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 8 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | | | | Allow NULL? |
| 9 | CRDAT | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | CRNAM | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | UPDDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | SRSID | Source of Data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | OWNID | Data Provider | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | FAID | Injury/Illness Log Entry | nvarchar | 20 | 0 | | | | Allow NULL? |
| 17 | FATYPE | Injury/Illness Log Entry Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | FAPLANT | Plant Assignment | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | FASTATUS | Status | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | FAINITSTATUS | Initial Status of an Object | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | MTNLANGU | Language of Entry | char | 1 | 0 | | | | Allow NULL? |
| 22 | FALOC | Entry Location | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 24 | FATRANSFLG | Data Record Is for Transfer to Incident/Accident Log | char | 1 | 0 | | | | Allow NULL? |
| 25 | FATRANSDEC | Transfer decision injury/illness log - incident/accident log | char | 1 | 0 | | | | Allow NULL? |
| 26 | RECNTIA | Sequential Number of Data Record | nvarchar | 20 | 0 | | | | Allow NULL? |
| 27 | TRANSDAT | Date of Data Transfer Injury/Illness Log to Inc./Acc. Log | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | TRANSTIME | Time of Data Transfer Injury/Illness Log to Inc./Acc. Log | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | TRANSNAM | Administrator Data Transfer Injury/Illness Log to I/A Log | nvarchar | 12 | 0 | | | | Allow NULL? |
| 30 | FATALFLG | Fatality | char | 1 | 0 | | | | Allow NULL? |
| 31 | FAFIRSTRFLG | Initial Treatment After Event | char | 1 | 0 | | | | Allow NULL? |
| 32 | FADAT | Date When Aid Was Given | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | FATIME | Time and Date of Aid Given | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | FAHELPER | First-Aider | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | FAHELPERFLG | First-Aider (External) | char | 1 | 0 | | | | Allow NULL? |
| 36 | FATRTOHC | Transport to First Aid Center By | nvarchar | 21 | 0 | | | | Allow NULL? |
| 37 | FATRFRHC | Means of Further Transport from Health Center | nvarchar | 21 | 0 | | | | Allow NULL? |
| 38 | EVDAT | Event Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | EVTIME | Event Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 40 | RECNTWAH | Reference to Work Area | nvarchar | 20 | 0 | | | | Allow NULL? |
| 41 | ACLOC | Accident Location | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | ACLOCDESC | Description of Accident Location | nvarchar | 60 | 0 | | | | Allow NULL? |
| 43 | FRTRMT | Further Treatment | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | FRTRMTFLG | Physician Giving Further Treatment (Internal/External) | char | 1 | 0 | | | | Allow NULL? |
| 45 | INTNOTE | Commentary for internal use | nvarchar | 72 | 0 | | | | Allow NULL? |
| 46 | INTNOTEFLG | Long Text Available for an Internal Note | char | 1 | 0 | | | | Allow NULL? |
| 47 | EXTNOTE | Information for External Purposes | nvarchar | 72 | 0 | | | | Allow NULL? |
| 48 | EXTNOTEFLG | Long Text Available on External Note | char | 1 | 0 | | | | Allow NULL? |
| 49 | FRTRMTGRP | Person Group | char | 1 | 0 | | | | Allow NULL? |
| 50 | OFFJOBDAT | Date of Ceasing to Work | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | OFFJOBTIME | Time of Ceasing to Work | nvarchar | 6 | 0 | | | | Allow NULL? |
| 52 | IPABSSUBTYPE | Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | IPABSBEGDAT | Start Date of Absence | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | IPABSENDDAT | End Date of Absence | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | IPABSSEQNUM | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 56 | IPABSESTDAYS | Estimated Duration of Absence (in Days) | decimal | 6 | 2 | | | | |
| 57 | IPABSDAYS | Number of Workdays Absent | decimal | 6 | 2 | | | | |
| 58 | IPABSCALDAYS | Calendar Days | decimal | 8 | 2 | | | | |
| 59 | IPRSWBEGDAT | Start of Restriction or Date of Job Transfer | nvarchar | 8 | 0 | | | | Allow NULL? |
| 60 | IPRSWENDDAT | End Date of Restriction or Job Transfer | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | IPRSWDAYS | Number of Workdays with Restriction or Job Transfer | decimal | 6 | 2 | | | | |
| 62 | IPRSWCALDAYS | Calendar Days with Restriction or Job Transfer | decimal | 8 | 2 | | | | |
| 63 | FAHELPERGRP | Person Group | char | 1 | 0 | | | | Allow NULL? |
| 64 | FATIMEZONE | Valid Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 65 | EVTIMEZONE | Valid Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 66 | OFFJOBTIMEZONE | Valid Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 67 | IAREPORTFLG | Reportable Accident | char | 1 | 0 | | | | Allow NULL? |
| 68 | PRIVCONCFLG | Privacy Concern Case | char | 1 | 0 | | | | Allow NULL? |
| 69 | EMERGRMFLG | Treatment in Emergency Room | char | 1 | 0 | | | | Allow NULL? |
| 70 | INPATFLG | Treatment Overnight As Inpatient | char | 1 | 0 | | | | Allow NULL? |
| 71 | IPDEATHDATE | Date of Death of Person Affected | nvarchar | 8 | 0 | | | | Allow NULL? |
| 72 | UNCONSCIOUS | Person Unconscious | char | 1 | 0 | | | | Allow NULL? |
| 73 | RESUSCITATION | Resuscitation Performed | char | 1 | 0 | | | | Allow NULL? |
| 74 | HOSPITALIZATION | Hospitalization for over 24 Hours | char | 1 | 0 | | | | Allow NULL? |
| 75 | BLOCKFLG | EHS: Lock Indicator | char | 1 | 0 | | | | Allow NULL? |
