DIC_PRIORITY
Dictionary table containing valid priorities for the software error reporting system (from very high to very low).
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(3) |
Primary key
|
2 |
DESCRIPTION |
Varchar(68) |
|
3 |
TRANSLATION |
Varchar(50) |
|
4 |
STATUS |
Varchar(1) |
|
5 |
DATE_ENTERED |
Date |
|
6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 5 of 5)
CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
HI |
High - fix ASAP |
2 |
C |
05-NOV-02 |
07-JUN-04 |
MED |
Medium - fix within two days |
3 |
C |
05-NOV-02 |
07-JUN-04 |
VHI |
Very high - urgent, fix now |
1 |
C |
05-NOV-02 |
07-JUN-04 |
LOW |
Low - fix within a week |
4 |
C |
05-NOV-02 |
07-JUN-04 |
VLO |
Very low - fix when possible |
5 |
C |
05-NOV-02 |
07-JUN-04 |