sp073_restriction_types
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table defines the restriction types that may be specified when booking a job through one of the booking APIs.
If the system has been configured to support restricted jobs and the gantt user has been given access to the restriction type, then the gantt user will be able to view data that has been configured as sensitive on the job. If the gantt user has not been assigned the restriction type then they will not be able to view sensitive data.
Restriction Types can be set up through ServiceManager which uses the internal /wiki/spaces/SCH142/pages/28222519 API.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| restriction_no | number(9) |  | |
| restriction_ref | varchar2(30) | |
Keys
primary key (restriction_no)
unique (restriction_ref)
Primary Key Referenced From
Column Descriptions
Field | Description |
|---|---|
| restriction_no | ServiceOptimizer generated unique identifier |
| restriction_ref | Unique reference for the restriction type. Valid characters are a-Z, 0-9, space, _ |