sp509_audit_sp111
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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. |