sp271_start_end_locations
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table provides a list of the permitted values for columns sp064.start_location and sp064.end_location. Also referenced by tables sp123 and sp210_employees.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
location | number(1) |  | |
description | varchar2(40) | | |
field_id | varchar2(100) | |
Keys
primary key (location)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| location | Permitted start_location and end_location values in sp064, sp123 and sp210_employees . |
| description | Depreciated - Start / end location description:
|
| field_id | Key to language translations for description. |