SERVED_CLIENT_FEATURE_FACT
The Served Client Feature Fact table records the features of the served client.
|
Columns |
Type |
Length |
Description |
|||||||||
|
ID |
numeric |
19 |
A 19-digit unique identifier. This is the primary key for the table. |
|||||||||
|
DEVICE_ID |
numeric |
19 |
The Device ID. This is a foreign key to the DEVICE_DIMENSION table. |
|||||||||
|
PARENT_ID |
varchar2 |
100 |
The server ID, this tells who is the parent server for this served client. This is a foreign key to the DEVICE_DIMENSION table. |
|||||||||
|
LASTMODIFIED_DATE_ID |
numeric |
19 |
The time when the served client was last modified. |
|||||||||
|
LAST_SYNC_TIME_ID |
numeric |
19 |
The time when the served client was last synced with its server. |
|||||||||
|
EXPIRATION_ID |
numeric |
19 |
The time when the served client's feature is going to expire. |
|||||||||
|
FEATURE_NAME |
varchar2 |
100 |
The Feature name. |
|||||||||
|
FEATURE_COUNT |
numeric |
19 |
The count of each feature. |
|||||||||
|
SERVED_STATUS |
varchar |
100 |
The status of the served client. A server client status can be one of the following:
|
|||||||||
|
TENANT_ID |
varchar2 |
255 |
The Tenant ID. |