Field Listing for Table OSTDEF_SERIOUSHARMLOG
Field: | HEADERSYSUNIQUEID | Type: | DOUBLE |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |
Field: | BUSINESSNAME | Type: | VARCHAR Length: 50 |
Field: | BUSINESSADDRESS | Type: | BLOB |
Field: | PERSONREPORTING | Type: | VARCHAR Length: 25 |
Field: | PERSONSTATUS | Type: | VARCHAR Length: 15 |
Field: | ACCIDENTLOCATION | Type: | BLOB |
Field: | INJUREDPERSONSNAME | Type: | VARCHAR Length: 25 |
Field: | RESIDENTADDRESS | Type: | BLOB |
Field: | JOBTITLE | Type: | VARCHAR Length: 25 |
Field: | EMPLOYSTATUS | Type: | VARCHAR Length: 25 |
Field: | EMPLOYMENTPERIOD | Type: | VARCHAR Length: 15 |
Field: | TREATMENTTYPE | Type: | VARCHAR Length: 25 |
Field: | TIMEOFACCIDENT | Type: | TIME |
Field: | DATEOFACCIDENT | Type: | DATE |
Field: | HOURSWORKEDBEFORE | Type: | DOUBLE |
Field: | MECHANISM | Type: | VARCHAR Length: 25 |
Field: | AGENCYOFACCIDENT | Type: | VARCHAR Length: 25 |
Field: | BODYPART | Type: | VARCHAR Length: 25 |
Field: | OTHERINJURIES | Type: | BLOB |
Field: | ACCIDENTNOTES | Type: | BLOB |
Field: | INVESTIGATION | Type: | BOOLEAN |
Field: | HAZARD | Type: | BOOLEAN |
Field: | COMPILERNAME | Type: | VARCHAR Length: 50 |
Field: | COMPILEDDATE | Type: | DATE |
Field: | COMPILERPOSITION | Type: | VARCHAR Length: 25 |
Field: | INCIDENTNUMBER | Type: | INTEGER |
Field: | INCIDENTSHIFT | Type: | VARCHAR Length: 15 |
Field: | N01 | Type: | BOOLEAN |
Field: | N02 | Type: | BOOLEAN |
Field: | N03 | Type: | BOOLEAN |
Field: | N04 | Type: | BOOLEAN |
Field: | N05 | Type: | BOOLEAN |
Field: | N06 | Type: | BOOLEAN |
Field: | N07 | Type: | BOOLEAN |
Field: | N08 | Type: | BOOLEAN |
Field: | N09 | Type: | BOOLEAN |
Field: | N10 | Type: | BOOLEAN |
Field: | N11 | Type: | BOOLEAN |
Field: | N12 | Type: | BOOLEAN |
Field: | N13 | Type: | BOOLEAN |
Field: | N14 | Type: | BOOLEAN |
Field: | N15 | Type: | BOOLEAN |
Field: | N16 | Type: | BOOLEAN |
Field: | N17 | Type: | BOOLEAN |
Field: | N18 | Type: | BOOLEAN |
Field: | N19 | Type: | BOOLEAN |
Field: | N20 | Type: | BOOLEAN |
Field: | N21 | Type: | BOOLEAN |
Field: | N22 | Type: | BOOLEAN |
Field: | N23 | Type: | BOOLEAN |
Field: | N24 | Type: | BOOLEAN |
Field: | N25 | Type: | BOOLEAN |
Field: | N26 | Type: | BOOLEAN |