View table: PDMView

Jump to: navigation, search

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`"'?
Retrieved from "https://all.docs.genesys.com/Special:CargoTables/PDMView (2022-07-06 19:20:16)"