Field Listing for Table OSTDEF_INVESTIGATION
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: | INJUREDPERSONSNAME | Type: | VARCHAR Length: 30 |
Field: | HEALTHANDSAFETYNOTES | Type: | BLOB |
Field: | INFORMATIONNOTES | Type: | BLOB |
Field: | ANALYSISDETAILS | Type: | BLOB |
Field: | WHOISINVOLVED | Type: | BLOB |
Field: | ACTIONASSIGNEDT0 | Type: | VARCHAR Length: 30 |
Field: | ACTIONDUEDATE | Type: | DATE |
Field: | ACTIONCOMPLETIONDATE | Type: | DATE |
Field: | UPDATEDON | Type: | DATE |
Field: | DATEADVISED | Type: | DATE |
Field: | ADVISEDBY | Type: | VARCHAR Length: 30 |
Field: | SIGNEDBY | Type: | VARCHAR Length: 30 |
Field: | DATESIGNED | Type: | DATE |
Field: | CONTACTNUMBER | Type: | VARCHAR Length: 30 |
Field: | ACTIONDETAILS | Type: | BLOB |
Field: | UPDATEHAZARDREGISTER | Type: | BOOLEAN |
Field: | AUTHORITIESADVISED | Type: | BOOLEAN |