| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCollateral Management System |
| 1 | CMS_PCN_CR | Change Requests | 8 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 2 | TCMS_PCN_ACTVT | Business activity definition | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 3 | TCMS_PCN_ACTVT_T | Business activity definition texts | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 4 | TCMS_PCN_A_GRP_T | Business activity group text definition | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 5 | TCMS_PCN_A_MSG | Message sverity change for business activity | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 6 | TCMS_PCN_A_SSTTR | System Status Transition for an Activity | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 7 | TCMS_PCN_CKY_B | Process control key Behavior | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 8 | TCMS_PCN_CR_ST | Change Request Type: Status Transition | 4 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 9 | TCMS_PCN_CR_TY | Change Request Type | 4 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 10 | TCMS_PCN_CR_TY_T | Texts for Change Request Type | 4 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 11 | TCMS_PCN_FCODE | FCODE exclusion set definition for activity | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
| 12 | TCMS_PCN_USTTR | User status transition definition | 5 | CR_TYPE | Change Request Type | nvarchar | 6 | 0 | | |
