Share this page
For any given record, only the fields relevant to the type of the changed data have values. Fields for other data types are NULL.
The AUDIT_LOG and AUDIT_PROPERTIES tables replace the HISTORY table, which no longer exists.
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AP_PROPERTY_ID | The record ID. | int | 4 | |||
| AP_ACTION_ID | The audit log record: AUDIT_LOG.AU_ACTION_ID. | int | 4 | ||||
| AP_TABLE_NAME | If the property change was saved in the database, the name of the table in which the change occurred. | varchar | 40 |  | |||
| AP_FIELD_NAME | If the property change was saved in the database, the field (column) that was changed. | varchar | 40 | | |||
| AP_PROPERTY_NAME | If the property change was saved in the database, the user-defined label for the field that was changed (SYSTEM_FIELD.SF_USER_LABEL). If not a database field, the name of the property. | varchar | 50 | | |||
| AP_OLD_VALUE | The value before the change for types other than timestamp or large object fields. If there is no previous value, or if timestamp or large object, NULL. | varchar | 2000 | | |||
| AP_NEW_VALUE | The value resulting from the change for types other than timestamp or large object fields. NULL for timestamp and large object. | varchar | 2000 | | |||
| AP_OLD_LONG_VALUE | The value before the change for large object fields. If there is no previous value or if not a large object, NULL. | varchar | 16 | | |||
| AP_NEW_LONG_VALUE | The value resulting from the change for large object fields, such as memo fields. If not a large object, NULL. | varchar | 16 | | |||
| AP_OLD_DATE_VALUE | The value before the change for timestamp fields. If there is no previous value or if not a timestamp , NULL. | datetime | 4 | | |||
| AP_NEW_DATE_VALUE | The value resulting from the change for timestamp fields. If not a timestamp , NULL. | datetime | 4 | |
| Index | Description | Primary | Unique |
|---|---|---|---|
| AP_ACTION_IDX | |||
| AP_PRIMARYKEY | | | |
| AP_TABLE_NAME_FIELD_NAME_IDX |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | AUTR_27990060_QPM_MILESTONES | Trigger | 2 | |
| AUTR_345769792_ENVIRONMENTS | Trigger | 2 | |
| AUTR_363696399_TESTCYCL | Trigger | 2 | |
| AUTR1386687709_COMPONENT | Trigger | 2 | |
| AUTR1815529430_RESULTS | Trigger | 2 | |
| AUTR1916707492_TEST_CONFIGS | Trigger | 2 | |
| AUTR2571410_TEST | Trigger | 2 | |
| AUTR64594118_CYCLE | Trigger | 2 | |
| AUTR66132_BUG | Trigger | 2 | |
| AUTR81022_REQ | Trigger | 2 | |
| AUTR81515_RUN | Trigger | 2 | |
 | td.BUG | Table | Information about defects. | 1 |
| td.COMPONENT | Table | Business Process Components. | 1 |
| td.CYCLE | Table | Test sets. | 1 |
| td.ENVIRONMENTS | Table | Testing environments. | 1 |
| MVTR_BUG | Trigger | 2 | |
| MVTR_REQ | Trigger | 2 | |
| td.QPM_MILESTONES | Table | Significant periods for quality measurements in the context of a RELEASE. | 1 |
| td.REQ | Table | Details of individual requirements and the structure of the requirements tree. | 1 |
| td.RESULTS | Table | The results of a RUN. | 1 |
| td.RUN | Table | Execution records for test instances. | 1 |
| td.TEST | Table | Details of the design test from the test plan module. | 1 |
| td.TEST_CONFIGS | Table | The data to be used in the run of a Test. | 1 |
| td.TESTCYCL | Table | Instances of design tests in test sets. | 1 |
 | td.V_TESTSET_REQ_COVER | View | 2 |
Related Objects
