DIC_RCS_STATUS
Dictionary table used to validate field RCS_STATUS in the table DIC_ROCK_NAMEV3. This validation was previously controlled by a check constraint - this is now removed.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Char(1) |
Primary key
|
| 2 |
DATA |
Varchar(40) |
|
| 3 |
DATE_ENTERED |
Date |
|
| 4 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 5 of 5)
| CODE |
DATA |
DATE_ENTERED |
DATE_UPDATED |
| C |
CURRENT |
16-OCT-03 |
16-OCT-03 |
| O |
OBSOLETE |
16-OCT-03 |
|
| H |
HIERARCHY |
16-OCT-03 |
|
| N |
NON_VALIDATED ENTRY |
16-OCT-03 |
|
| Q |
NON_COMPLIANT QUALIFIER |
20-JUN-06 |
|
