View table: PDMView
Table structure:
- viewName - String
- shortDesc - String
- viewDesc - Wikitext
- introduced - String
- modified - String
- discontinued - String
- subjectAreas - List of String
- dataExport - String
- SQLQuery - Wikitext
This table has 28 rows altogether.
Page | viewName | shortDesc | viewDesc | introduced | modified | discontinued | subjectAreas | dataExport | SQLQuery |
---|---|---|---|---|---|---|---|---|---|
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN AUDIT LOG | ADMIN_AUDIT_LOG | This administrative view provides access to the data stored in the CTL_AUDIT_LOG table, which allows facts and dimensions to be described by data lineage attributes. Each row represents a logical transaction that is committed by Genesys Info Mart, identifying the ETL job that is involved in the transaction, including the minimum and maximum DATE_TIME values (which give a date-time range for the data that is committed in the transaction), and providing the processing status (an internal indicator of the kind of data that is processed). The columns in this view are identical to those in the underlying table. |
?'"`UNIQ--source-00000008-QINU`"'? | ||||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB HISTORY | ADMIN_ETL_JOB_HISTORY | This view provides information about the execution of each ETL job. A row is added to this view after each ETL job completes. Currently running ETL jobs do not appear in this view. Rows in this view are written once and are not updated. | ?'"`UNIQ--source-00000008-QINU`"'? | ||||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL JOB STATUS | ADMIN_ETL_JOB_STATUS | This view provides information about the most recent execution of each ETL job. A row is added to this view after each ETL job starts and is updated as the job status changes. | ?'"`UNIQ--source-00000008-QINU`"'? | ||||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN ETL STEP HISTORY | ADMIN_ETL_STEP_HISTORY | This view provides information about the execution of each ETL job step. Rows are added to this view for completed ETL job steps only. As each ETL job completes, it adds rows for the completed steps of all currently running ETL jobs, including itself, that have not already been added to the view. Currently running ETL jobs may have steps that are in process or are waiting, and they do not yet appear in the view. Rows in this view are written once and are not updated. |
?'"`UNIQ--source-00000008-QINU`"'? | ||||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-ADMIN EXTRACT HISTORY | ADMIN_EXTRACT_HISTORY | This view provides information about the data that is extracted from each source database table. A row is added to this view after Job_ExtractICON successfully completes extracting a source data table. Rows in this view are written once and are not updated. | ?'"`UNIQ--source-00000008-QINU`"'? | ||||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST | Allows facts to be described based on attributes of an outbound campaign calling list. | Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list. | ?'"`UNIQ--source-0000000C-QINU`"'? | |||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CALLING_LIST_TO_CAMP_FACT | Describes the association of a calling list to an outbound campaign. | Each row describes the association of a calling list to an outbound campaign. The grain of the fact is an accumulating snapshot that represents the duration of the association between a calling list and a campaign. | Facts • Calling_List_To_Campaign | yes | ?'"`UNIQ--source-0000000C-QINU`"'? | |||
Draft:PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN | Allows facts to be described based on attributes of an outbound campaign. | Allows facts to be described based on attributes of an outbound campaign. Each row describes one campaign. | Calling_List_To_Campaign | ?'"`UNIQ--source-00000012-QINU`"'? | ||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-CTL ETL HWM | CTL_ETL_HWM | This view reflects processing progress for the data that is being transferred to the dimensional model tables, but for which certain interaction states are still in progress for the current time interval. In this release, the view is limited to the extracted configuration data and transformed digital data only. |
?'"`UNIQ--source-00000008-QINU`"'? | ||||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_ | Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. | Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. Routing points, queues, and agents can belong to resource groups. Places can belong to place groups. Each row describes one place group or resource group. A new row is issued for each configured place group and resource group, which is identified by its ID in the contact center configuration. Changing a group name causes an update to an existing row. Deleting a group and re-creating it under the same name causes a new row to be issued. | ?'"`UNIQ--source-00000012-QINU`"'? | |||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | GROUP_TO_CAMPAIGN_FACT | Describes the association of an agent or place group to an outbound campaign. | Each row describes the association of an agent or place group to an outbound campaign. The grain of the fact is an accumulating snapshot that represents the duration of the association between an agent or place group and a campaign. | Facts • Campaign_Group_To_Campaign | yes | ?'"`UNIQ--source-00000012-QINU`"'? | |||
Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | PLACE | Allows facts to be described by the attributes of a place. | Allows facts to be described by the attributes of a place. Each row describes one configured place, identified by its ID in the contact center configuration. Changing the place name causes an update to an existing row. Deleting a place and re-creating it under the same name causes a new row to be issued. | ?'"`UNIQ--source-00000012-QINU`"'? | |||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | PLACE_GROUP_FACT | Describes the membership of places in place groups. | Each row describes the membership of one place in one place group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the Configuration Database. | Facts • Place_Group | yes | ?'"`UNIQ--source-00000012-QINU`"'? | |||
Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | RESOURCE_GROUP_FACT | Describes the membership of resources in resource groups. | Each row describes the membership of one resource (routing point, queue, or agent) in one resource group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the configuration database. | Facts • Resource_Group | yes | ?'"`UNIQ--source-00000012-QINU`"'? | |||
Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | RESOURCE_SKILL_FACT | Describes an agent's skills and proficiency levels. | Each row describes one skill at a particular proficiency level that one agent possesses. The grain of the fact is an accumulating snapshot that represents the duration of the configured skill and proficiency, which are identified by a unique ID in the configuration database. | Facts • Resource_Skill | yes | ?'"`UNIQ--source-00000012-QINU`"'? | |||
Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | SKILL | Allows facts to be described by the attributes of a skill. | Allows facts to be described by the attributes of a skill. Each row describes one skill. A new row is issued for each configured skill, identified by its ID in the contact center configuration. Changing a skill name causes an update to an existing row. Deleting a skill and re-creating it under the same name causes a new row to be issued. | ?'"`UNIQ--source-00000012-QINU`"'? | |||||
Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | TENANT | Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data. | Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data. In a single-tenant deployment, the Resources tenant is considered a tenant. In a multi-tenant deployment, the Environment tenant and the configured tenants are considered tenants. Each row describes one tenant. A new row is issued for each configured tenant, identified by its ID in the contact center configuration. Changing a tenant's name causes an update to the existing row. Deleting a tenant and re-creating it under the same name causes a new row to be issued. |
?'"`UNIQ--source-0000000F-QINU`"'? | |||||
PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST | Allows facts to be described based on attributes of an outbound campaign calling list. | Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list. | ?'"`UNIQ--source-0000000C-QINU`"'? | |||||
PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CALLING_LIST_TO_CAMP_FACT | Describes the association of a calling list to an outbound campaign. | Each row describes the association of a calling list to an outbound campaign. The grain of the fact is an accumulating snapshot that represents the duration of the association between a calling list and a campaign. | Facts • Calling_List_To_Campaign | yes | ?'"`UNIQ--source-0000000C-QINU`"'? | |||
PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN | Allows facts to be described based on attributes of an outbound campaign. | Allows facts to be described based on attributes of an outbound campaign. Each row describes one campaign. | Calling_List_To_Campaign | ?'"`UNIQ--source-0000000C-QINU`"'? | ||||
PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_ | Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. | Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. Routing points, queues, and agents can belong to resource groups. Places can belong to place groups. Each row describes one place group or resource group. A new row is issued for each configured place group and resource group, which is identified by its ID in the contact center configuration. Changing a group name causes an update to an existing row. Deleting a group and re-creating it under the same name causes a new row to be issued. | ?'"`UNIQ--source-0000000C-QINU`"'? | |||||
PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | GROUP_TO_CAMPAIGN_FACT | Describes the association of an agent or place group to an outbound campaign. | Each row describes the association of an agent or place group to an outbound campaign. The grain of the fact is an accumulating snapshot that represents the duration of the association between an agent or place group and a campaign. | Facts • Campaign_Group_To_Campaign | yes | ?'"`UNIQ--source-0000000C-QINU`"'? | |||
PEC-REP/Library/PDMLibraryGIM/View-PLACE | PLACE | Allows facts to be described by the attributes of a place. | Allows facts to be described by the attributes of a place. Each row describes one configured place, identified by its ID in the contact center configuration. Changing the place name causes an update to an existing row. Deleting a place and re-creating it under the same name causes a new row to be issued. | ?'"`UNIQ--source-0000000C-QINU`"'? | |||||
PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | PLACE_GROUP_FACT | Describes the membership of places in place groups. | Each row describes the membership of one place in one place group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the Configuration Database. | Facts • Place_Group | yes | ?'"`UNIQ--source-0000000C-QINU`"'? | |||
PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | RESOURCE_GROUP_FACT | Describes the membership of resources in resource groups. | Each row describes the membership of one resource (routing point, queue, or agent) in one resource group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the configuration database. | Facts • Resource_Group | yes | ?'"`UNIQ--source-0000000C-QINU`"'? | |||
PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | RESOURCE_SKILL_FACT | Describes an agent's skills and proficiency levels. | Each row describes one skill at a particular proficiency level that one agent possesses. The grain of the fact is an accumulating snapshot that represents the duration of the configured skill and proficiency, which are identified by a unique ID in the configuration database. | Facts • Resource_Skill | yes | ?'"`UNIQ--source-0000000C-QINU`"'? | |||
PEC-REP/Library/PDMLibraryGIM/View-SKILL | SKILL | Allows facts to be described by the attributes of a skill. | Allows facts to be described by the attributes of a skill. Each row describes one skill. A new row is issued for each configured skill, identified by its ID in the contact center configuration. Changing a skill name causes an update to an existing row. Deleting a skill and re-creating it under the same name causes a new row to be issued. | ?'"`UNIQ--source-0000000C-QINU`"'? | |||||
PEC-REP/Library/PDMLibraryGIM/View-TENANT | TENANT | Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data. | Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data. In a single-tenant deployment, the Resources tenant is considered a tenant. In a multi-tenant deployment, the Environment tenant and the configured tenants are considered tenants. Each row describes one tenant. A new row is issued for each configured tenant, identified by its ID in the contact center configuration. Changing a tenant's name causes an update to the existing row. Deleting a tenant and re-creating it under the same name causes a new row to be issued. |
?'"`UNIQ--source-0000000C-QINU`"'? |