(Created page with "= Initial Conversion Job Aids= ==Temp table to convert column descriptions into tabular format== Word-process 81gim_ref_oracle.doc: Search for Style Heading 3 (no content) an...") |
|||
| Line 1: | Line 1: | ||
= Initial Conversion Job Aids= | = Initial Conversion Job Aids= | ||
| − | ==Temp table to convert column descriptions into tabular format== | + | {{#switch:{{#explode:{{FULLPAGENAME}}|:|1}} |
| − | Word-process | + | |GIM= |
| + | ==Temp table to convert GIM column descriptions into tabular format== | ||
| + | Word-process the .doc file from the last PDF: Search for Style Heading 3 (no content) and do a global replace with:<br><nowiki>}}^p{{Temp^p|text=<br> then copy all to this wiki page, delete the first Column ending stub, add a closing set of double braces (}})</nowiki> at the end, and save the page. | ||
{{Temp | {{Temp | ||
| Line 41: | Line 43: | ||
|text=UPDATE_AUDIT_KEY | |text=UPDATE_AUDIT_KEY | ||
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key 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.}} | The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key 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.}} | ||
| + | |ICON=}} | ||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] | ||
Revision as of 14:21, May 3, 2016
Initial Conversion Job Aids
Temp table to convert GIM column descriptions into tabular format
Word-process the .doc file from the last PDF: Search for Style Heading 3 (no content) and do a global replace with:
}}^p{{Temp^p|text=<br> then copy all to this wiki page, delete the first Column ending stub, add a closing set of double braces (}}) at the end, and save the page.
| {{{column}}} | ATTEMPT_DISPOSITION_KEY
The key that uniquely identifies the disposition. The value combines the state and the descriptor that provides additional details. The key value enables you to calculate the state by using appropriate bit masks. The first eight bits specify the cause, which equals the integer value that is supplied by Outbound Contact Server. The next eight bits specify the descriptor that is generated by Genesys Info Mart. Column |
| {{{column}}} | CAUSE
The cause as specified in the OCS model. This value can change with localization. Column |
| {{{column}}} | CAUSE_ID
An integer that equals the value that is supplied by Outbound Contact Server to specify the cause. Column |
| {{{column}}} | CAUSE_CODE
The cause code that is equivalent to the OCS model cause. This value does not change with localization. Column |
| {{{column}}} | DESCRIPTOR
Specifies whether the final transition was caused by an agent or by the system, or whether this is unknown. Because not all outbound dispositions support descriptor, most dispositions have only an 'Unknown' value. This is a string value that can be localized or changed, based on reporting needs. Column |
| {{{column}}} | DESCRIPTOR_CODE
The code of the descriptor. This field is set to one of the following values: - BY_AGENT - BY_SYSTEM - UNKNOWN This value is not localizable and should not be changed. Column |
| {{{column}}} | CREATE_AUDIT_KEY
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. Column |
| {{{column}}} | UPDATE_AUDIT_KEY
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key 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. |