| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DB_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 3 | ROOT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 4 | PARENT_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 5 | DATETIME_CR | Date/Time of Item Creation | decimal | 15 | 0 | | | | |
| 6 | USER_ID_CR | Object Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | DATETIME_CH | Date/Time of Item Change | decimal | 15 | 0 | | | | |
| 8 | USER_ID_CH | Object Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | OC_INC_TYPE | Incident Type | nvarchar | 21 | 0 | | | | Allow NULL? |
| 10 | EXT_CASE_ID | External Case Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | REPORT_REQ_TS | Required in Summary Report | char | 1 | 0 | | | | Allow NULL? |
| 12 | REP_CRIT | Additional Reporting Criteria (OSHA) | nvarchar | 21 | 0 | | | | Allow NULL? |
| 13 | JURISD_PRIV_TS | Privacy Case | char | 1 | 0 | | | | Allow NULL? |
| 14 | INJ_ORG_PROP_TS | Injured on Company's Site | char | 1 | 0 | | | | Allow NULL? |
| 15 | INJ_ON_DUTY_TS | Person Injured on Duty | char | 1 | 0 | | | | Allow NULL? |
| 16 | FATALITY_TS | Fatal Injury / Illness | char | 1 | 0 | | | | Allow NULL? |
| 17 | DEATH_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 18 | DEATH_TIME_ZONE | Time Zone of Death | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | DEATH_LOC_TYPE | Location of Death | nvarchar | 21 | 0 | | | | Allow NULL? |
| 20 | DEATH_CAUSE_TYPE | Cause of Death | nvarchar | 21 | 0 | | | | Allow NULL? |
| 21 | UNCONSC_TS | Unconsciousness | char | 1 | 0 | | | | Allow NULL? |
| 22 | RESUSC_TS | Immediate Resuscitation Performed | char | 1 | 0 | | | | Allow NULL? |
| 23 | TREAT_BEY_FI_TS | Treatment Beyond First Aid | char | 1 | 0 | | | | Allow NULL? |
| 24 | EMERG_ROOM_TS | Emergency Room Treatment | char | 1 | 0 | | | | Allow NULL? |
| 25 | INPAT_TS | Inpatient Treatment Overnight | char | 1 | 0 | | | | Allow NULL? |
| 26 | INPAT_24H_TS | Inpatient Treatment (More Than 24 Hrs) | char | 1 | 0 | | | | Allow NULL? |
| 27 | TRAN_FIRST | Transportation to First Aid | nvarchar | 21 | 0 | | | | Allow NULL? |
| 28 | TRAN_FURTH | Transportation to Further Treatment | nvarchar | 21 | 0 | | | | Allow NULL? |
| 29 | TXC_TRE_COMM_KEY | NodeID | varbinary | 16 | 0 | | | | |
| 30 | EEW_INC_PINJI_D | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
