DIC_SOLE_STRUCTURE
Dictionary table listing and expanding the codes for different types of sole structure, eg. flute casts, flame structures.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(10) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(50) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
TRANSLATION |
Varchar(50) |
|
| 5 |
ORDER_CTRL |
Numeric(22) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 16 of 16)
| CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
ORDER_CTRL |
DATE_ENTERED |
DATE_UPDATED |
| FLUTE |
FLUTE CASTS |
C |
Flute Casts |
5 |
04-JUN-03 |
|
| GROOVE |
GROOVE CASTS |
C |
Groove Casts |
10 |
04-JUN-03 |
|
| TOOL |
TOOL MARKS, TYPE UNDEFINED |
C |
Tool Marks |
15 |
04-JUN-03 |
|
| TOOLPROD |
PROD MARKS |
C |
Prod Marks |
20 |
04-JUN-03 |
|
| TOOLROLL |
ROLL MARKS |
C |
Roll Marks |
25 |
04-JUN-03 |
|
| TOOLBRUSH |
BRUSH MARKS |
C |
Brush Marks |
30 |
04-JUN-03 |
|
| TOOLBOUNCE |
BOUNCE MARKS |
C |
Bounce Marks |
35 |
04-JUN-03 |
|
| TOOLSKIP |
SKIP MARKS |
C |
Skip Marks |
40 |
04-JUN-03 |
|
| SCOUR |
SCOUR MARKS |
C |
Scour Marks |
45 |
04-JUN-03 |
|
| LOAD |
LOAD STRUCTURES, TYPE UNDEFINED |
C |
Load Structures |
50 |
04-JUN-03 |
|
| LOADCAST |
LOAD CASTS |
C |
Load Casts |
55 |
04-JUN-03 |
|
| LOADFLAME |
FLAME STRUCTURES |
C |
Flame Structures |
60 |
04-JUN-03 |
|
| LOADBALL |
BALL AND PILLOW STRUCTURE |
C |
Ball and Pillow Structure |
65 |
04-JUN-03 |
|
| * |
NOT APPLICABLE |
C |
Not Applicable |
900 |
04-JUN-03 |
|
| ! |
NOT AVAILABLE |
C |
Not Available |
905 |
04-JUN-03 |
|
| ? |
NOT ENTERED |
C |
Not Entered |
910 |
04-JUN-03 |
|
