14.1 sp509_audit_sp111
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| timestamp | date |  | |
| sequence | number | | |
| username | varchar2(256) | | |
| osuser | varchar2(256) | | |
| machine | varchar2(64) | | |
| program | varchar2(256) | | |
| session_id | number | | |
| process_id | varchar2(22) | | |
| job_no | number(9) | | |
| job_ref | varchar2(50) | | |
| old_job_status | number(2) | | |
| new_job_status | number(2) | | |
| old_importance | number(1) | | |
| new_importance | number(1) | | |
| old_on_hold | number(1) | | |
| new_on_hold | number(1) | | |
| transaction_id | number(9) | |
Keys
None.
Column Descriptions
| Field | Description |
|---|---|
| timestamp | Date and time at which these details were saved. Uses the time zone of the DBMS server machine. |
| sequence | Unique identifier: the sequence number of the update. |
| username | DBMS user. |
| osuser | Operating system user. |
| machine | Machine logged onto. |
| program | Program name. |
| session_id | DBMS session id of the session performing the update. |
| process_id | Unix process id (pid) - a number. |
| job_no | Identifier of job. |
| job_ref | End user's unique identifier. |
| old_job_status | Job status before update. |
| new_job_status | Job status after update. |
| old_importance | Importance before update. |
| new_importance | Importance after update. |
| old_on_hold | On Hold status before update. |
| new_on_hold | On Hold status after update. |
| transaction_id | See SP599_TRANSACTION_AUDIT for details. |