Field Listing for Table OSTDEF_TIME_AUDIT_LOG
| Field: | TABLENAME | Type: | VARCHAR Length: 50 |
| Field: | RECORDID | Type: | DOUBLE |
| Field: | ACTIONTYPE | Type: | VARCHAR Length: 20 |
| Field: | EMPLOYEENAME | Type: | VARCHAR Length: 20 |
| Field: | MODIFIEDBY | Type: | VARCHAR Length: 20 |
| Field: | MODIFIEDBYTYPE | Type: | VARCHAR Length: 20 |
| Field: | FIELDNAME | Type: | VARCHAR Length: 50 |
| Field: | OLDVALUE | Type: | VARCHAR Length: 255 |
| Field: | NEWVALUE | Type: | VARCHAR Length: 255 |
| Field: | DESCRIPTION | Type: | VARCHAR Length: 500 |
| Field: | REASON | Type: | VARCHAR Length: 500 |
| Field: | ERRORMESSAGE | Type: | VARCHAR Length: 500 |
| Field: | IPADDRESS | Type: | VARCHAR Length: 50 |
| Field: | DEVICEINFO | Type: | VARCHAR Length: 255 |
| Field: | GPSLATITUDE | Type: | DOUBLE |
| Field: | GPSLONGITUDE | Type: | DOUBLE |
| Field: | GPSACCURACY | Type: | DOUBLE |
| Field: | ISAUTOMATED | Type: | BOOLEAN |
| Field: | SESSIONID | Type: | VARCHAR Length: 50 |
| Field: | APICALLID | Type: | VARCHAR Length: 50 |
| Field: | GATEWAY_GUID | Type: | VARCHAR Length: 36 |
| Field: | CHECKSUM | Type: | VARCHAR Length: 64 |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |