/
sp104_activity_status
sp104_activity_status
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Analytics
Loading data...
This table records the history of status changes for fault and appointment activities.
Note that this table is not currently populated and is deprecated from V9.0.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| activity_no | number(9) |  | |
| update_time | date | sysdate | |
| status | number(2) | |
Keys
primary key (activity_no, update_time, status)
foreign key (activity_no) references sp100_activities (activity_no)
foreign key (status) references sp117_status_descriptions (status)
Column Descriptions
| Field | Description |
|---|---|
| activity_no | The activity identifier. |
| update_time | The time the status was updated. Uses the time zone of the DBMS server machine. |
| status | The new status following the update. |
, multiple selections available,
Related content
14.1 sp104_activity_status
14.1 sp104_activity_status
More like this
sp299_appointment_status
sp299_appointment_status
More like this
14.1 sp299_appointment_status
14.1 sp299_appointment_status
More like this