Vocabularies — details
DIC_BP_BGS_ACTIVITY
This dictionary table belongs to the Best Practice suite of tables (originally started by John Howcroft). It is intended to link to BGS.BP_IDENTIFIER.
| No. | Column name | Data type | Notes |
|---|---|---|---|
| 1 | BGS_ACTIVITY_ID | Numeric(22) | Primary key |
| 2 | DESCRIPTION | Varchar(50) | |
| 3 | STATUS | Char(1) | |
| 4 | DATE_ENTERED | Date | |
| 5 | DATE_UPDATED | Date |
Sample data (rows 1 to 2 of 2)
| BGS_ACTIVITY_ID | DESCRIPTION | STATUS | DATE_ENTERED | DATE_UPDATED |
|---|---|---|---|---|
| 1 | DGSM | C | 14-JUN-04 | |
| 2 | SIGMA | C | 14-JUN-04 |