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