Jdruker/CargoQueriesForPDMs
DPL results used to verify initial Change Summary table
- Views -- No deltas
- Tables introduced: 63
- Tables modified: 96
- Tables discontinued: 0
- Columns introduced: 71
- Columns modified: 149 for "8.5" + 10 for "8.1" + 44 for table modified entries for Oracle character-length semantics
- Columns discontinued: 4
Number of rows in PDMColumn table July 6th: 43,980 Number of rows in PDMColumn table after data re-created and forced GIM 8.5DRAFT update: 39,117
Table introduced
Table modified
of which 44 are for Oracle character-length semantics
| pageName | Table | Modified in |
|---|---|---|
| pageName | Table | Modified in |
| Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5DRAFT | ANCHOR_FLAGS | 8.5.004 (CUSTOMER_LEFT_FIRST column added) • 8.5.001 (population of FIRST_*_THRD metrics made conditional) |
| Documentation:GIM:Library:Table-ATTEMPT DISPOSITION:8.5DRAFT | ATTEMPT_DISPOSITION | 8.5.003 (In Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CALL RESULT:8.5DRAFT | CALL_RESULT | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_DIM_1 | 8.5.010 (in Microsoft SQL Server, data types for the following columns modified in multi-language databases: CHANNEL, CALLBACK_OFFER_TYPE, CALLBACK_TYPE, CONNECT_ORDER) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | CALLBACK_DIM_2 | 8.5.010 (in Microsoft SQL Server, data types for the following columns modified in multi-language databases: DIAL_DIALOG_RESULT, CALL_DIRECTION, FINAL_DIAL_RESULT, OFFER_TIMING) |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT | CALLBACK_DIM_3 | 8.5.010 (in Microsoft SQL Server, data type for FINAL_TARGET modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.010 (in Microsoft SQL Server, data type for various ID columns modified in multi-language databases, as identified in the column descriptions) • 8.5.009.20 (21 new columns added, as identified in the column descriptions) • 8.5.003 (PUSH_DELIVERY_CONFIRMED_TS and CUSTOMER_READY_TO_START_IXN_TS added • DESIRED_TIME renamed to DESIRED_TIME_TS, which has been made mandatory) |
| Documentation:GIM:Library:Table-CAMPAIGN GROUP SESSION FACT:8.5DRAFT | CAMPAIGN_GROUP_SESSION_FACT | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CAMPAIGN GROUP STATE FACT:8.5DRAFT | CAMPAIGN_GROUP_STATE_FACT | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CAMPAIGN GROUP STATE:8.5DRAFT | CAMPAIGN_GROUP_STATE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CHAT SESSION DIM:8.5DRAFT | CHAT_SESSION_DIM | 8.5.011.14 (ASYNC_MODE column added to table and index) |
| Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT | CHAT_SESSION_FACT | 8.5.014.09 (THREAD_ID column added) • 8.5.011.14 (8 new columns added specific to asynchronous chat, as identified in the column descriptions) |
| Documentation:GIM:Library:Table-CONTACT ATTEMPT FACT:8.5DRAFT | CONTACT_ATTEMPT_FACT | 8.5.003 (RECORD_FIELD_41 through RECORD_FIELD_60 added) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CONTACT INFO TYPE:8.5DRAFT | CONTACT_INFO_TYPE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CTL AUDIT LOG:8.5DRAFT | CTL_AUDIT_LOG | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CTL ETL HISTORY:8.5DRAFT | CTL_ETL_HISTORY | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CTL EXTRACT HISTORY:8.5DRAFT | CTL_EXTRACT_HISTORY | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CTL GDPR HISTORY:8.5DRAFT | CTL_GDPR_HISTORY | 8.5.010.16 (scope extended to cover employee GDPR requests) |
| Documentation:GIM:Library:Table-CTL PURGE HISTORY:8.5DRAFT | CTL_PURGE_HISTORY | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CTL TRANSFORM HISTORY:8.5DRAFT | CTL_TRANSFORM_HISTORY | 8.5.010 (HWM_VALUE2 column added) • 8.5.009 (AUDIT_KEY column added) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT | CTL_UD_TO_UDE_MAPPING | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) • 8.1.201 (CONVERT_EXPRESSION column added) |
| Documentation:GIM:Library:Table-CTL UDE KEYS TO DIM MAPPING:8.5DRAFT | CTL_UDE_KEYS_TO_DIM_MAPPING | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-DATE TIME:8.5DRAFT | DATE_TIME | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-DIALING MODE:8.5DRAFT | DIALING_MODE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | GPM_FACT | 8.5.014.09 (DEFAULT_SCORE, DEFAULT_SCORE_USED, DEFAULT_SCORES_COUNT, GLOBAL_SCORES_COUNT, ADJUSTED_SCORE, INITIAL_SCORE_THRESHOLD, FINAL_SCORE_THRESHOLD, SUITABLE_AGENTS_COUNT, GPM_DIM1_KEY added) • 8.5.011 (START_DATE_TIME_KEY became part of the composite primary key in nonpartitioned as well as partitioned databases) • 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.010 (in Microsoft SQL Server, data type for MEDIA_SERVER_IXN_GUID modified in multi-language databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5DRAFT | GPM_MODEL | 8.5.010 (in Microsoft SQL Server, data type for the MODEL and MODEL_ID columns modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5DRAFT | GPM_PREDICTOR | 8.5.010 (in Microsoft SQL Server, data type for the PREDICTOR and PREDICTOR_ID columns modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: GPM_MODE, GPM_STATUS, GPM_RESULT, GPM_USE, CUSTOMER_FOUND) |
| Documentation:GIM:Library:Table-GROUP ANNEX:8.5DRAFT | GROUP_ANNEX | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | INTERACTION_DESCRIPTOR | 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single- and multi-language databases: CUSTOMER_SEGMENT, SERVICE_TYPE, SERVICE_SUBTYPE, BUSINESS_RESULT) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5DRAFT | INTERACTION_FACT | 8.5.003 (ANCHOR_ID and ANCHOR_SDT_KEY added) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | 8.5.006 (TARGET_ADDRESS column added) • 8.5.004 (IRF_ANCHOR_SENT_TS renamed to IRF_ANCHOR_TS • LAST_INTERACTION_RESOURCE column populated for all media types • scope of ANCHOR_FLAGS_KEY extended • columns added: FOCUS_TIME_COUNT, FOCUS_TIME_DURATION, ASM_COUNT, ASM_ENGAGE_DURATION) • 8.5.003 (IRF_ANCHOR_DATE_TIME_KEY column renamed to IRF_ANCHOR_SENT_TS • LAST_INTERACTION_RESOURCE column populated for voice) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) • 8.5.001 (scope of some CONS_* fields expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE STATE:8.5DRAFT | INTERACTION_RESOURCE_STATE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_TYPE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT | IRF_USER_DATA_CUST_1 | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters) • 8.5.005.09 (data types of CUSTOM_DATA_13 through CUSTOM_DATA_16 changed to character data types) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) • 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added) |
| Documentation:GIM:Library:Table-IRF USER DATA GEN 1:8.5DRAFT | IRF_USER_DATA_GEN_1 | 8.5.011.18 (GSW_CALL_TYPE added) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) • 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added) |
| Documentation:GIM:Library:Table-IRF USER DATA KEYS:8.5DRAFT | IRF_USER_DATA_KEYS | 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added) |
| Documentation:GIM:Library:Table-MEDIA TYPE:8.5DRAFT | MEDIA_TYPE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-MEDIATION SEGMENT FACT:8.5DRAFT | MEDIATION_SEGMENT_FACT | 8.5.004 (USERDATA_FLAG added) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | POST_CALL_SURVEY_DIM_1 | 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: SURVEY_IAGENTSCORE, SURVEY_ICOMPANYSCORE, SURVEY_ICALLSCORE, SURVEY_IPRODUCTSCORE, SURVEY_IQ1) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | POST_CALL_SURVEY_DIM_2 | 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_IQ* columns modified in single-language databases and for the SURVEY_SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | POST_CALL_SURVEY_DIM_3 | 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | POST_CALL_SURVEY_DIM_4 | 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_IQ* columns modified in single-language databases and for the SURVEY_SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | POST_CALL_SURVEY_DIM_5 | 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_IQ* columns modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | POST_CALL_SURVEY_DIM_6 | 8.5.010 (in Microsoft SQL Server, data type for the SURVEY_* columns modified in single-language databases) |
| Documentation:GIM:Library:Table-RECORD FIELD GROUP 1:8.5DRAFT | RECORD_FIELD_GROUP_1 | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RECORD FIELD GROUP 2:8.5DRAFT | RECORD_FIELD_GROUP_2 | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RECORD STATUS:8.5DRAFT | RECORD_STATUS | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RECORD TYPE:8.5DRAFT | RECORD_TYPE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-REQUESTED SKILL COMBINATION:8.5DRAFT | REQUESTED_SKILL_COMBINATION | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RESOURCE ANNEX:8.5DRAFT | RESOURCE_ANNEX | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RESOURCE STATE REASON:8.5DRAFT | RESOURCE_STATE_REASON | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RESOURCE STATE:8.5DRAFT | RESOURCE_STATE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-RESOURCE:8.5DRAFT | RESOURCE_ | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-ROUTING TARGET:8.5DRAFT | ROUTING_TARGET | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT | SDR_ACTIVITIES_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.010 (in Microsoft SQL Server, data type for SESSION_ID modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR ACTIVITY:8.5DRAFT | SDR_ACTIVITY | 8.5.010 (data type for the NAME column modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | SDR_APPLICATION | 8.5.010 (in Microsoft SQL Server, data type for the APPLICATION_* columns modified in single-language databases) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | SDR_CALL_DISPOSITION | 8.5.010 (in Microsoft SQL Server, data type for the FINAL_DISPOSITION column modified in single-language databases and for the DISPOSITION_TYPE and DISPOSITION_CATEGORY columns in single- and multi-language databases) • 8.5.007 (FINAL_DISPOSITION column added) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5DRAFT | SDR_CALL_TYPE | 8.5.010 (in Microsoft SQL Server, data type for the CALL_TYPE and MEDIA_TYPE columns modified in single-language databases) • 8.5.008 (MEDIA_TYPE column added) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT | SDR_CUST_ATRIBUTES_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5DRAFT | SDR_CUST_ATRIBUTES | 8.5.010 (in Microsoft SQL Server, data type for ATRIBUTE_NAME modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT | SDR_ENTRY_POINT | 8.5.010 (in Microsoft SQL Server, data type for DNIS modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXIT POINT:8.5DRAFT | SDR_EXIT_POINT | 8.5.010 (in Microsoft SQL Server, data type for APPLICATION_EXIT_POINT modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT | SDR_EXT_HTTP_REST | 8.5.010 (in Microsoft SQL Server, data type for URL modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT | SDR_EXT_REQUEST_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT | SDR_EXT_REQUEST_OUTCOME | 8.5.010 (in Microsoft SQL Server, data type for SUCCESS modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | SDR_EXT_REQUEST | 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: REQUEST_NAME, REQUEST_TYPE, METHOD) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT | SDR_EXT_SERVICE_OUTCOME | 8.5.010 (in Microsoft SQL Server, data type for SERVICE_NAME and SERVICE_RESPONSE_DESC modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | SDR_GEO_LOCATION | 8.5.010 (in Microsoft SQL Server, data type for COUNTRY_CODE modified in single-language databases and for COUNTRY_NAME, REGION, and TIMEZONE modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | SDR_INPUT_OUTCOME | 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: SELECTED_OPTION, STRIKEOUT, SUCCESS) |
| Documentation:GIM:Library:Table-SDR INPUT:8.5DRAFT | SDR_INPUT | 8.5.010 (in Microsoft SQL Server, data type for INPUT_NAME and INPUT_TYPE modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR LANGUAGE:8.5DRAFT | SDR_LANGUAGE | 8.5.010 (in Microsoft SQL Server, data type for LANGUAGE_CODE and LANGUAGE_NAME modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR MESSAGE:8.5DRAFT | SDR_MESSAGE | 8.5.010 (in Microsoft SQL Server, data type for MESSAGE_FILE modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR MILESTONE:8.5DRAFT | SDR_MILESTONE | 8.5.010 (in Microsoft SQL Server, data type for MILESTONE and MILESTONE_PATH modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SESSION FACT:8.5DRAFT | SDR_SESSION_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.005 (SDR_SURVEY_* keys added) • 8.5.007 (SDR_SURVEY_QUESTIONS_* keys added) |
| Documentation:GIM:Library:Table-SDR SURVEY ANSWERS:8.5DRAFT | SDR_SURVEY_ANSWERS | 8.5.010 (in Microsoft SQL Server, data type for SURVEY_ANSWER_STR modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT | SDR_SURVEY_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.010 (data type for SESSION_ID and INTERACTION_ID modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | SDR_SURVEY_QUESTIONS_I1 | 8.5.010 (in Microsoft SQL Server, data type for the IQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | SDR_SURVEY_QUESTIONS_I2 | 8.5.010 (in Microsoft SQL Server, data type for the IQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SDR_SURVEY_QUESTIONS_S1 | 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SDR_SURVEY_QUESTIONS_S2 | 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS:8.5DRAFT | SDR_SURVEY_QUESTIONS | 8.5.010 (in Microsoft SQL Server, data type for QUESTION modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SDR_SURVEY_S1 | 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SDR_SURVEY_S2 | 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | SDR_SURVEY_STATUS | 8.5.010 (in Microsoft SQL Server, data type for the following columns modified in single-language databases: COMPLETE, RECORDING, OFFER) • 8.5.008 (RECORDING column deprecated) • 8.5.007 (OFFER column added) |
| Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT | SDR_SURVEY_TRANSCRIPT_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.010 (in Microsoft SQL Server, data type for SESSION_ID modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUT:8.5DRAFT | SDR_USER_INPUT | 8.5.010 (in Microsoft SQL Server, data type for USER_INPUT_TYPE modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | SDR_USER_INPUTS_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) • 8.5.010 (in Microsoft SQL Server, data type for UTTERANCE and INTERPRETATION modified in multi-language databases) • 8.5.008 (data type for UTTERANCE and INTERPRETATION increased from 50 to 512 characters) |
| Documentation:GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT | SDR_USER_MILESTONE_FACT | 8.5.010.16 (UPDATE_AUDIT_KEY added) |
| Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT | SM_MEDIA_NEUTRAL_STATE_FACT | 8.5.013.06 (END_DATE_TIME_KEY and RESOURCE_GROUP_COMBINATION_KEY added) • 8.5.003 (CREATE_AUDIT_KEY column added) |
| Documentation:GIM:Library:Table-STG IDB FK VIOLATION:8.5DRAFT | STG_IDB_FK_VIOLATION | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT | STG_TRANSFORM_DISCARDS | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) • 8.5.011.14 (data type for TABLE_NAME increased from 30 to 255 characters) |
| Documentation:GIM:Library:Table-STRATEGY:8.5DRAFT | STRATEGY | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-TECHNICAL DESCRIPTOR:8.5DRAFT | TECHNICAL_DESCRIPTOR | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-TIME ZONE:8.5DRAFT | TIME_ZONE | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-USER DATA CUST DIM 1:8.5DRAFT | USER_DATA_CUST_DIM_1 | 8.5.010 (in Microsoft SQL Server, data type for DIM_ATTRIBUTE_1 through DIM_ATTRIBUTE_5 modified in single- and multi-language databases) • 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
| Documentation:GIM:Library:Table-WORKBIN:8.5DRAFT | WORKBIN | 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics) |
Table discontinued
No results
Column introduced
Column modified -- itemized
| pageName | Table | Column | Column modified |
|---|---|---|---|
| pageName | Table | Column | Column modified |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_DIM_1 | CALLBACK_OFFER_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_DIM_1 | CALLBACK_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_DIM_1 | CHANNEL | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_DIM_1 | CONNECT_ORDER | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | CALLBACK_DIM_2 | CALL_DIRECTION | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | CALLBACK_DIM_2 | DIAL_DIALOG_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | CALLBACK_DIM_2 | FINAL_DIAL_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | CALLBACK_DIM_2 | OFFER_TIMING | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT | CALLBACK_DIM_3 | FINAL_TARGET | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | DS_AUDIT_KEY | 8.5.008 (data type increased from 10 to 19 digits) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | FIRST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | LAST_CALLBACK_OFFERED_TS | 8.5.008 (default value added) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | LAST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | ORIGINATION_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | CALLBACK_FACT | ORS_SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT | COBROWSE_FACT | PAGE_QUERY | 8.5.012.15 (No longer a mandatory field) |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT | CTL_UD_TO_UDE_MAPPING | PROPAGATION_RULE | 8.5.001 (IRF_INITIAL value is added). |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT | CTL_UD_TO_UDE_MAPPING | PROPAGATION_RULE | 8.5.006 (IRF_ROUTE value is added) |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | GPM_FACT | MEDIA_SERVER_IXN_GUID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | GPM_FACT | MESSAGE | 8.5.009.20 (default value no longer defined) |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | GPM_FACT | START_DATE_TIME_KEY | 8.5.011 (added to the composite primary key in nonpartitioned databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5DRAFT | GPM_MODEL | MODEL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5DRAFT | GPM_MODEL | MODEL_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5DRAFT | GPM_PREDICTOR | PREDICTOR | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5DRAFT | GPM_PREDICTOR | PREDICTOR_ID | 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | CUSTOMER_FOUND | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | GPM_MODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | GPM_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | GPM_STATUS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | GPM_USE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | INTERACTION_DESCRIPTOR | BUSINESS_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | INTERACTION_DESCRIPTOR | CUSTOMER_SEGMENT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | INTERACTION_DESCRIPTOR | SERVICE_SUBTYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | INTERACTION_DESCRIPTOR | SERVICE_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5DRAFT | INTERACTION_FACT | STATUS | 8.5.001 (error code 26 added) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5DRAFT | INTERACTION_FACT | SUBJECT | 8.5.007 (data type extended from 255 to 1024 characters) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | ANCHOR_FLAGS_KEY | 8.5.004 (scope extended) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | CONS_INIT_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | CONS_RCV_RING_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | CONS_RCV_RING_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | CONS_RCV_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | CONS_RCV_TALK_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | LAST_INTERACTION_RESOURCE | 8.5.003 and 8.5.004 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | QUEUE_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | INTERACTION_RESOURCE_FACT | ROUTING_POINT_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_TYPE | INTERACTION_SUBTYPE | 8.5.001 (InternalConferenceInvite subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_TYPE | INTERACTION_SUBTYPE | 8.5.005 (OutboundCallback subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_TYPE | INTERACTION_SUBTYPE_CODE | 8.5.001 (INTERNALCONFERENCEINVITE subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_TYPE | INTERACTION_SUBTYPE_CODE | 8.5.005 (OUTBOUNDCALLBACK subtype added) |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT | IRF_USER_DATA_CUST_1 | CUSTOM_DATA_1 through CUSTOM_DATA_16 | 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types). |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT | IRF_USER_DATA_CUST_1 | CUSTOM_DATA_1 through CUSTOM_DATA_16 | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | POST_CALL_SURVEY_DIM_1 | SURVEY_IAGENTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | POST_CALL_SURVEY_DIM_1 | SURVEY_ICALLSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | POST_CALL_SURVEY_DIM_1 | SURVEY_ICOMPANYSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | POST_CALL_SURVEY_DIM_1 | SURVEY_IPRODUCTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | POST_CALL_SURVEY_DIM_1 | SURVEY_IQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | POST_CALL_SURVEY_DIM_2 | SURVEY_IQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | POST_CALL_SURVEY_DIM_2 | SURVEY_IQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | POST_CALL_SURVEY_DIM_2 | SURVEY_IQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | POST_CALL_SURVEY_DIM_2 | SURVEY_SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | POST_CALL_SURVEY_DIM_2 | SURVEY_SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | POST_CALL_SURVEY_DIM_3 | SURVEY_SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | POST_CALL_SURVEY_DIM_3 | SURVEY_SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | POST_CALL_SURVEY_DIM_3 | SURVEY_SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | POST_CALL_SURVEY_DIM_3 | SURVEY_SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | POST_CALL_SURVEY_DIM_3 | SURVEY_SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | POST_CALL_SURVEY_DIM_4 | SURVEY_IQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | POST_CALL_SURVEY_DIM_4 | SURVEY_IQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | POST_CALL_SURVEY_DIM_4 | SURVEY_SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | POST_CALL_SURVEY_DIM_4 | SURVEY_SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | POST_CALL_SURVEY_DIM_4 | SURVEY_SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | POST_CALL_SURVEY_DIM_5 | SURVEY_IQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | POST_CALL_SURVEY_DIM_5 | SURVEY_IQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | POST_CALL_SURVEY_DIM_5 | SURVEY_IQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | POST_CALL_SURVEY_DIM_5 | SURVEY_IQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | POST_CALL_SURVEY_DIM_6 | SURVEY_COMPLETE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | POST_CALL_SURVEY_DIM_6 | SURVEY_IRECOMMENDSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | POST_CALL_SURVEY_DIM_6 | SURVEY_RECORDING | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-RESOURCE:8.5DRAFT | RESOURCE_ | RESOURCE_SUBTYPE | 8.5.003.17 (new value, Person, added for the Agent resource type) |
| Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT | SDR_ACTIVITIES_FACT | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR ACTIVITY:8.5DRAFT | SDR_ACTIVITY | NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | SDR_APPLICATION | APPLICATION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | SDR_APPLICATION | APPLICATION_TITLE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | SDR_APPLICATION | APPLICATION_VERSION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | SDR_CALL_DISPOSITION | DISPOSITION_CATEGORY | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | SDR_CALL_DISPOSITION | DISPOSITION_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | SDR_CALL_DISPOSITION | FINAL_DISPOSITION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5DRAFT | SDR_CALL_TYPE | CALL_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5DRAFT | SDR_CALL_TYPE | MEDIA_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5DRAFT | SDR_CUST_ATRIBUTES | ATRIBUTE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT | SDR_ENTRY_POINT | DNIS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXIT POINT:8.5DRAFT | SDR_EXIT_POINT | APPLICATION_EXIT_POINT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT | SDR_EXT_HTTP_REST | URL | 8.5.008.29 (behavior changed) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT | SDR_EXT_HTTP_REST | URL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT | SDR_EXT_REQUEST_OUTCOME | SUCCESS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | SDR_EXT_REQUEST | METHOD | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | SDR_EXT_REQUEST | REQUEST_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | SDR_EXT_REQUEST | REQUEST_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT | SDR_EXT_SERVICE_OUTCOME | SERVICE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT | SDR_EXT_SERVICE_OUTCOME | SERVICE_RESPONSE_DESC | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | SDR_GEO_LOCATION | COUNTRY_CODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | SDR_GEO_LOCATION | COUNTRY_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | SDR_GEO_LOCATION | REGION | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | SDR_GEO_LOCATION | TIMEZONE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | SDR_INPUT_OUTCOME | SELECTED_OPTION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | SDR_INPUT_OUTCOME | STRIKEOUT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | SDR_INPUT_OUTCOME | SUCCESS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT:8.5DRAFT | SDR_INPUT | INPUT_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT:8.5DRAFT | SDR_INPUT | INPUT_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR LANGUAGE:8.5DRAFT | SDR_LANGUAGE | LANGUAGE_CODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR LANGUAGE:8.5DRAFT | SDR_LANGUAGE | LANGUAGE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR MESSAGE:8.5DRAFT | SDR_MESSAGE | MESSAGE_FILE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR MILESTONE:8.5DRAFT | SDR_MILESTONE | MILESTONE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR MILESTONE:8.5DRAFT | SDR_MILESTONE | MILESTONE_PATH | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY ANSWERS:8.5DRAFT | SDR_SURVEY_ANSWERS | SURVEY_ANSWER_STR | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT | SDR_SURVEY_FACT | INTERACTION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT | SDR_SURVEY_FACT | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | SDR_SURVEY_QUESTIONS_I1 | IQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | SDR_SURVEY_QUESTIONS_I1 | IQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | SDR_SURVEY_QUESTIONS_I1 | IQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | SDR_SURVEY_QUESTIONS_I1 | IQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | SDR_SURVEY_QUESTIONS_I1 | IQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | SDR_SURVEY_QUESTIONS_I2 | IQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | SDR_SURVEY_QUESTIONS_I2 | IQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | SDR_SURVEY_QUESTIONS_I2 | IQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | SDR_SURVEY_QUESTIONS_I2 | IQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | SDR_SURVEY_QUESTIONS_I2 | IQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SDR_SURVEY_QUESTIONS_S1 | SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SDR_SURVEY_QUESTIONS_S1 | SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SDR_SURVEY_QUESTIONS_S1 | SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SDR_SURVEY_QUESTIONS_S1 | SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SDR_SURVEY_QUESTIONS_S1 | SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SDR_SURVEY_QUESTIONS_S2 | SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SDR_SURVEY_QUESTIONS_S2 | SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SDR_SURVEY_QUESTIONS_S2 | SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SDR_SURVEY_QUESTIONS_S2 | SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SDR_SURVEY_QUESTIONS_S2 | SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS:8.5DRAFT | SDR_SURVEY_QUESTIONS | QUESTION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SDR_SURVEY_S1 | SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SDR_SURVEY_S1 | SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SDR_SURVEY_S1 | SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SDR_SURVEY_S1 | SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SDR_SURVEY_S1 | SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SDR_SURVEY_S2 | SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SDR_SURVEY_S2 | SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SDR_SURVEY_S2 | SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SDR_SURVEY_S2 | SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SDR_SURVEY_S2 | SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | SDR_SURVEY_STATUS | COMPLETE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | SDR_SURVEY_STATUS | OFFER | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | SDR_SURVEY_STATUS | RECORDING | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT | SDR_SURVEY_TRANSCRIPT_FACT | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUT:8.5DRAFT | SDR_USER_INPUT | USER_INPUT_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | SDR_USER_INPUTS_FACT | INTERPRETATION | 8.5.008 (data type increased from 50 to 512 characters) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | SDR_USER_INPUTS_FACT | INTERPRETATION | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | SDR_USER_INPUTS_FACT | START_TS_MS | 8.5.008 (no longer mandatory) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | SDR_USER_INPUTS_FACT | UTTERANCE | 8.5.008 (data type increased from 50 to 512 characters) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | SDR_USER_INPUTS_FACT | UTTERANCE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT | STG_TRANSFORM_DISCARDS | CODE | 8.5.001 (error code 26 added) |
| Documentation:GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT | STG_TRANSFORM_DISCARDS | TABLE_NAME | 8.5.011.14 (data type increased from 30 to 255 characters) |
| Documentation:GIM:Library:Table-USER DATA CUST DIM 1:8.5DRAFT | USER_DATA_CUST_DIM_1 | DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
Column modified__full
| Table | Column | Column modified |
|---|---|---|
| Table | Column | Column modified |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_OFFER_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CALLBACK_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CHANNEL | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5DRAFT | CONNECT_ORDER | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | CALL_DIRECTION | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | DIAL_DIALOG_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | FINAL_DIAL_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5DRAFT | OFFER_TIMING | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5DRAFT | FINAL_TARGET | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | DS_AUDIT_KEY | 8.5.008 (data type increased from 10 to 19 digits) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | FIRST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | LAST_CALLBACK_OFFERED_TS | 8.5.008 (default value added) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | LAST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | ORIGINATION_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT | ORS_SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT | PAGE_QUERY | 8.5.012.15 (No longer a mandatory field) |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5DRAFT | PROPAGATION_RULE | 8.5.006 (IRF_ROUTE value is added) • 8.5.001 (IRF_INITIAL value is added). |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | MEDIA_SERVER_IXN_GUID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | MESSAGE | 8.5.009.20 (default value no longer defined) |
| Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT | START_DATE_TIME_KEY | 8.5.011 (added to the composite primary key in nonpartitioned databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5DRAFT | MODEL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5DRAFT | MODEL_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5DRAFT | PREDICTOR | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5DRAFT | PREDICTOR_ID | 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | CUSTOMER_FOUND | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_MODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_STATUS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5DRAFT | GPM_USE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | BUSINESS_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | CUSTOMER_SEGMENT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | SERVICE_SUBTYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5DRAFT | SERVICE_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5DRAFT | STATUS | 8.5.001 (error code 26 added) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5DRAFT | SUBJECT | 8.5.007 (data type extended from 255 to 1024 characters) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | ANCHOR_FLAGS_KEY | 8.5.004 (scope extended) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | CONS_INIT_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | CONS_RCV_RING_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | CONS_RCV_RING_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | CONS_RCV_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | CONS_RCV_TALK_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | LAST_INTERACTION_RESOURCE | 8.5.003 and 8.5.004 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | QUEUE_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5DRAFT | ROUTING_POINT_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_SUBTYPE | 8.5.005 (OutboundCallback subtype added) • 8.5.001 (InternalConferenceInvite subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5DRAFT | INTERACTION_SUBTYPE_CODE | 8.5.005 (OUTBOUNDCALLBACK subtype added) • 8.5.001 (INTERNALCONFERENCEINVITE subtype added) |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5DRAFT | CUSTOM_DATA_1 through CUSTOM_DATA_16 | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) • 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types). |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | SURVEY_IAGENTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | SURVEY_ICALLSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | SURVEY_ICOMPANYSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | SURVEY_IPRODUCTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5DRAFT | SURVEY_IQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | SURVEY_IQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | SURVEY_IQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | SURVEY_IQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | SURVEY_SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5DRAFT | SURVEY_SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | SURVEY_SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | SURVEY_SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | SURVEY_SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | SURVEY_SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5DRAFT | SURVEY_SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | SURVEY_IQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | SURVEY_IQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | SURVEY_SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | SURVEY_SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5DRAFT | SURVEY_SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | SURVEY_IQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | SURVEY_IQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | SURVEY_IQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5DRAFT | SURVEY_IQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | SURVEY_COMPLETE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | SURVEY_IRECOMMENDSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5DRAFT | SURVEY_RECORDING | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-RESOURCE:8.5DRAFT | RESOURCE_SUBTYPE | 8.5.003.17 (new value, Person, added for the Agent resource type) |
| Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR ACTIVITY:8.5DRAFT | NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | APPLICATION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | APPLICATION_TITLE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5DRAFT | APPLICATION_VERSION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | DISPOSITION_CATEGORY | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | DISPOSITION_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5DRAFT | FINAL_DISPOSITION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5DRAFT | CALL_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5DRAFT | MEDIA_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5DRAFT | ATRIBUTE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5DRAFT | DNIS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXIT POINT:8.5DRAFT | APPLICATION_EXIT_POINT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5DRAFT | URL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) • 8.5.008.29 (behavior changed) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5DRAFT | SUCCESS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | METHOD | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | REQUEST_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5DRAFT | REQUEST_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT | SERVICE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5DRAFT | SERVICE_RESPONSE_DESC | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | COUNTRY_CODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | COUNTRY_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | REGION | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5DRAFT | TIMEZONE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | SELECTED_OPTION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | STRIKEOUT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5DRAFT | SUCCESS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT:8.5DRAFT | INPUT_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT:8.5DRAFT | INPUT_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR LANGUAGE:8.5DRAFT | LANGUAGE_CODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR LANGUAGE:8.5DRAFT | LANGUAGE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR MESSAGE:8.5DRAFT | MESSAGE_FILE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR MILESTONE:8.5DRAFT | MILESTONE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR MILESTONE:8.5DRAFT | MILESTONE_PATH | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY ANSWERS:8.5DRAFT | SURVEY_ANSWER_STR | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT | INTERACTION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | IQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | IQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | IQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | IQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I1:8.5DRAFT | IQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | IQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | IQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | IQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | IQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS I2:8.5DRAFT | IQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S1:8.5DRAFT | SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS S2:8.5DRAFT | SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY QUESTIONS:8.5DRAFT | QUESTION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S1:8.5DRAFT | SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY S2:8.5DRAFT | SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | COMPLETE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | OFFER | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY STATUS:8.5DRAFT | RECORDING | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUT:8.5DRAFT | USER_INPUT_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | INTERPRETATION | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) • 8.5.008 (data type increased from 50 to 512 characters) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | START_TS_MS | 8.5.008 (no longer mandatory) |
| Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT | UTTERANCE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) • 8.5.008 (data type increased from 50 to 512 characters) |
| Documentation:GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT | CODE | 8.5.001 (error code 26 added) |
| Documentation:GIM:Library:Table-STG TRANSFORM DISCARDS:8.5DRAFT | TABLE_NAME | 8.5.011.14 (data type increased from 30 to 255 characters) |
| Documentation:GIM:Library:Table-USER DATA CUST DIM 1:8.5DRAFT | DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
Column discontinued
| Table | Column | discontinued in |
|---|---|---|
| Table | Column | discontinued in |
| CALLBACK_FACT | DESIRED_TIME | 8.5.003 (renamed to DESIRED_TIME_TS) |
| INTERACTION_RESOURCE_FACT | IRF_ANCHOR_DATE_TIME_KEY | 8.5.003 (renamed to IRF_ANCHOR_SENT_TS) |
| INTERACTION_RESOURCE_FACT | IRF_ANCHOR_SENT_TS | 8.5.004 (renamed to IRF_ANCHOR_TS) |
| SDR_SURVEY_STATUS | RECORDING | 8.5.008 |
Supplementary queries for possible templatization
New tables/columns for NITR
Could switch on {{{tableIntroduced}}} and {{{colIntroduced}}}. This is the bones of the query for new columns:
{{#cargo_query:
tables=PDMTable,PDMColumn
|join on=PDMTable._pageName=PDMColumn._pageName
|fields=CONCAT(PDMTable.tableName,'.',PDMColumn.colName)
|where=PDMTable._pageName LIKE "%{{#explode:{{FULLPAGENAME}}|:|1}}%" AND PDMColumn.introduced LIKE "%{{{colIntroduced}}}%"
|format=ul
}} This page was last edited on September 21, 2018, at 13:45.
Comments or questions about this documentation? Contact us for support!