Field Listing for Table OSTDEF_INCIDENTREGISTER
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: | INCIDENTNUMBER | Type: | INTEGER |
Field: | INJUREDPERSON | Type: | VARCHAR Length: 30 |
Field: | INCIDENTSITE | Type: | VARCHAR Length: 50 |
Field: | SHIFT | Type: | VARCHAR Length: 10 |
Field: | SUPERVISOR | Type: | VARCHAR Length: 30 |
Field: | WITNESS | Type: | VARCHAR Length: 30 |
Field: | INCIDENTDATE | Type: | DATE |
Field: | INCIDENTTIME | Type: | TIME |
Field: | INCIDENTTYPE | Type: | VARCHAR Length: 12 |
Field: | INCIDENTSEVERITY | Type: | VARCHAR Length: 25 |
Field: | TREATMENT | Type: | VARCHAR Length: 25 |
Field: | INJURYTYPE | Type: | VARCHAR Length: 20 |
Field: | WHATHAPPENED | Type: | BLOB |
Field: | INCIDENTREPORTER | Type: | VARCHAR Length: 30 |
Field: | REPORTERSPHONE | Type: | VARCHAR Length: 20 |
Field: | REPORTERSPOSITION | Type: | VARCHAR Length: 20 |
Field: | SERIOUSHARMFORM | Type: | BOOLEAN |
Field: | OTHERCOMMENTS | Type: | BLOB |
Field: | BPMIDBACK | Type: | BOOLEAN |
Field: | BPUPPERBACK | Type: | BOOLEAN |
Field: | BPNECK | Type: | BOOLEAN |
Field: | BPNOSETHROAT | Type: | BOOLEAN |
Field: | BPLEFTHAND | Type: | BOOLEAN |
Field: | BPRIGHTHAND | Type: | BOOLEAN |
Field: | BPLEFTTHUMB | Type: | BOOLEAN |
Field: | BPRIGHTTHUMB | Type: | BOOLEAN |
Field: | BPLEFTFINGERS | Type: | BOOLEAN |
Field: | BPRIGHTFINGERS | Type: | BOOLEAN |
Field: | BPLEFTWRIST | Type: | BOOLEAN |
Field: | BPRIGHTWRIST | Type: | BOOLEAN |
Field: | BPLEFTARM | Type: | BOOLEAN |
Field: | BPRIGHTARM | Type: | BOOLEAN |
Field: | BPLEFTELBOW | Type: | BOOLEAN |
Field: | BPRIGHTELBOW | Type: | BOOLEAN |
Field: | BPLEFTSHOULDER | Type: | BOOLEAN |
Field: | BPRIGHTSHOULDER | Type: | BOOLEAN |
Field: | BPLEFTTHIGH | Type: | BOOLEAN |
Field: | BPRIGHTTHIGH | Type: | BOOLEAN |
Field: | BPLEFTKNEE | Type: | BOOLEAN |
Field: | BPRIGHTKNEE | Type: | BOOLEAN |
Field: | BPLEFTCALF | Type: | BOOLEAN |
Field: | BPRIGHTCALF | Type: | BOOLEAN |
Field: | BPLEFTANKLE | Type: | BOOLEAN |
Field: | BPRIGHTANKLE | Type: | BOOLEAN |
Field: | BPRIGHTFOOT | Type: | BOOLEAN |
Field: | BPLEFTTOES | Type: | BOOLEAN |
Field: | BPRIGHTTOES | Type: | BOOLEAN |
Field: | BPLEFTEYE | Type: | BOOLEAN |
Field: | BPRIGHTEYE | Type: | BOOLEAN |
Field: | BPLEFTEAR | Type: | BOOLEAN |
Field: | BPRIGHTEAR | Type: | BOOLEAN |
Field: | BPLEFTFOOT | Type: | BOOLEAN |
Field: | BPFACETEETH | Type: | BOOLEAN |
Field: | BPHEAD | Type: | BOOLEAN |
Field: | BPABDOMEN | Type: | BOOLEAN |
Field: | BPLOWERBACK | Type: | BOOLEAN |