| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | NETID | Production Network Identification | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | ID | GHO Production Network Version Identification | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | VALIDITY_START | Valid From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | VALIDITY_END | Valid to Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | CREATED_BY | Record Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | CREATED_ON | Record Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CHANGED_BY | Record Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | CHANGED_ON | Record Last Changed on Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | STATUS | GHO Production Network Version Status | char | 1 | 0 | | | | Allow NULL? |
| 11 | CHECKRESULT | Consistency Check Result of a Production Network Version | char | 1 | 0 | | | | Allow NULL? |
| 12 | CAP_ALLOC_EXEC | Capacity Allocation Execution Code | char | 1 | 0 | | | | Allow NULL? |
| 13 | CAP_ALLOC_BY | Record Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | CAP_ALLOC_ON | Record Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | PERIODFREQ | Allocation Frequency | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | CREATED_AT | Record Creation Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | CHANGED_AT | Record Last Change Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 19 | CAP_ALLOC_AT | Record Last Change Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | CAP_ALLOC_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | | | |
| 21 | PLN_ALLOC_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | | | |
| 22 | ACT_ALLOC_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | | | |