Category: Accounting
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The DatabaseName field stores the DatabaseName of the table. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The TableName field stores the TableName of the table. |
| CurPerm | BIGINT | --,---,---,---,---,---,--9 | The CurPerm field stores the Current Physical Size of the table in bytes. |
| CurPermWithoutFallback | BIGINT | --,---,---,---,---,---,--9 | The CurPermWithoutFallback field stores the Current Physical Size of the table without fallback in bytes. |
| CurPermCDS | DECIMAL(28,3) | --(25).9(3) | The CurPermCDS field stores the Logical (CDS) Size of the table in bytes. It excludes Fallback subtable. |
| CompressionFactor | FLOAT | -9.99999999999999E-999 | The CompressionFactor field stores the X value which is 1:X times when compared to the physical size of the table. |
| LastCollectTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The LastCollectTimeStamp field stores the Last statistics collection time stamp. |
| CurrentTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The CurrentTimeStamp field stores the Current TimeStamp value. |
| IsValid | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | The IsValid field indicates if for the table collect stats has been run or not. |