DIC_BPD_CATEGORY
This table is a dictionary. It holds translations for the category codes which all the best practice documents fall into.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(3) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(250) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
STATUS |
Char(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 |
| DBD |
DATABASE DESIGN DOCUMENT |
Database Design |
C |
13-JUN-06 |
13-JUN-06 |
| APD |
APPLICATION DESIGN DOCUMENT |
Application Design |
C |
13-JUN-06 |
13-JUN-06 |
| ! |
Not Available - Applicable but try as we might,we can't find a value. |
Not Available |
C |
11-JUL-06 |
|
| - |
Not Applicable |
Not Applicable |
C |
11-JUL-06 |
|
| ? |
Not Entered - We haven't assigned a value yet |
Not Entered |
C |
11-JUL-06 |
|
