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 |
