DIC_ABUNDANCE
Dictionary of abundance, for use in various situations
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(5) |
Primary key
|
2 |
DESCRIPTION |
Varchar(20) |
|
3 |
STATUS |
Char(1) |
|
4 |
TRANSLATION |
Varchar(20) |
|
5 |
ORDER_CTRL |
Numeric(22) |
|
6 |
DATE_ENTERED |
Date |
|
7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 7 of 7)
CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
ORDER_CTRL |
DATE_ENTERED |
DATE_UPDATED |
A |
ABUNDANT |
C |
Abundant |
5 |
04-JUN-03 |
|
C |
COMMON |
C |
Common |
10 |
04-JUN-03 |
|
R |
RARE |
C |
Rare |
15 |
04-JUN-03 |
|
P |
PRESENT |
C |
Present |
20 |
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 |
|