|
|
| Line 1: |
Line 1: |
| − | = View TENANT =
| |
| | | | |
| − |
| |
| − |
| |
| − | {{PDMView
| |
| − | |viewName = TENANT
| |
| − | |shortDesc =
| |
| − | |viewDesc =
| |
| − | |introduced =
| |
| − | |SQL = <source lang="xml">select
| |
| − | ID as TENANT_KEY,
| |
| − | NAME as TENANT_NAME,
| |
| − | ID as TENANT_CFG_DBID,
| |
| − | CREATED_TS as START_TS,
| |
| − | DELETED_TS as END_TS,
| |
| − | CREATE_AUDIT_KEY as CREATE_AUDIT_KEY,
| |
| − | UPDATE_AUDIT_KEY as UPDATE_AUDIT_KEY
| |
| − | from
| |
| − | GIDB_GC_TENANT
| |
| − | UNION ALL
| |
| − | SELECT - 1 AS TENANT_KEY,
| |
| − | 'UNKNOWN' AS TENANT_NAME,
| |
| − | - 1 AS TENANT_CFG_DBID,
| |
| − | -1 AS START_TS,
| |
| − | -1 AS END_TS,
| |
| − | -1 AS CREATE_AUDIT_KEY,
| |
| − | -1 AS UPDATE_AUDIT_KEY
| |
| − | FROM dual
| |
| − | UNION ALL
| |
| − | SELECT - 2 AS TENANT_KEY,
| |
| − | 'NO_VALUE' AS TENANT_NAME,
| |
| − | - 1 AS TENANT_CFG_DBID,
| |
| − | -1 AS START_TS,
| |
| − | -1 AS END_TS,
| |
| − | -1 AS CREATE_AUDIT_KEY,
| |
| − | -1 AS UPDATE_AUDIT_KEY
| |
| − | FROM dual
| |
| − |
| |
| − | </source>
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = TENANT_KEY
| |
| − | |colDesc = The surrogate key that is used to join to the TENANT dimension.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = TENANT_NAME
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = TENANT_CFG_DBID
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = START_TS
| |
| − | |colDesc = The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = END_TS
| |
| − | |colDesc = The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = CREATE_AUDIT_KEY
| |
| − | |colDesc = The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = UPDATE_AUDIT_KEY
| |
| − | |colDesc = The surrogate key used to join to the CTL_AUDIT_LOG dimension. Specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify recently modified data.
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentview = TENANT
| |
| − | |foreignKey = TENANT_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parenttable = CTL_AUDIT_LOG
| |
| − | |foreignKey = CREATE_AUDIT_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parenttable = CTL_AUDIT_LOG
| |
| − | |foreignKey = UPDATE_AUDIT_KEY
| |
| − | }}
| |
| − |
| |
| − | </onlyinclude>
| |
| − |
| |
| − | [[Category:V:GIM:8.5DRAFT]]
| |
