APP_NAME |
VARCHAR(60) |
Y |
The application which caused the insert. |
ATTR_COUNT |
DOUBLE |
Y |
The number of attributes filled out for a specific row. |
ATTR_ID1 |
DOUBLE |
Y |
%examle% |
ATTR_ID2 |
DOUBLE |
Y |
%examle% |
ATTR_ID3 |
DOUBLE |
Y |
%examle% |
ATTR_ID4 |
DOUBLE |
Y |
%examle% |
ATTR_ID5 |
DOUBLE |
Y |
%examle% |
ATTR_NAME1 |
VARCHAR(40) |
Y |
%examle% |
ATTR_NAME2 |
VARCHAR(40) |
Y |
%examle% |
ATTR_NAME3 |
VARCHAR(40) |
Y |
%examle% |
ATTR_NAME4 |
VARCHAR(40) |
Y |
%examle% |
ATTR_NAME5 |
VARCHAR(40) |
Y |
%examle% |
ATTR_VALUE1 |
VARCHAR(100) |
Y |
%examle% |
ATTR_VALUE2 |
VARCHAR(100) |
Y |
%examle% |
ATTR_VALUE3 |
VARCHAR(100) |
Y |
%examle% |
ATTR_VALUE4 |
VARCHAR(100) |
Y |
%examle% |
ATTR_VALUE5 |
VARCHAR(100) |
Y |
%examle% |
FIELD_COUNT |
DOUBLE |
Y |
The number of fields filled out for this row. |
FIELD_NAME1 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME10 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME2 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME3 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME4 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME5 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME6 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME7 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME8 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_NAME9 |
VARCHAR(30) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW1 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW10 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW2 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW3 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW4 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW5 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW6 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW7 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW8 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_NEW9 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD1 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD10 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD2 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD3 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD4 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD5 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD6 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD7 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD8 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
FIELD_VALUE_OLD9 |
VARCHAR(100) |
Y |
All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one. |
LOGICAL_DOMAIN_ID |
DOUBLE |
Y |
The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
LOG_ID |
DOUBLE |
N |
Primary Key |
LOG_TYPE_CD |
DOUBLE |
N |
The type of log. |
ORGANIZATION_ID |
DOUBLE |
Y |
The Organization that is associated to the logged item. |
PERSON_NAME |
VARCHAR(100) |
Y |
The person who caused the insert. |
REQ_NAME |
VARCHAR(40) |
Y |
(currently not used) |
TASK_NAME |
VARCHAR(60) |
Y |
The task which caused the insert. |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. |