adp-dbt-docs-um-nz-dev.amplifoninternal.com
Open in
urlscan Pro
2404:6800:4003:c11::79
Public Scan
URL:
https://adp-dbt-docs-um-nz-dev.amplifoninternal.com/
Submission: On May 19 via automatic, source certstream-suspicious — Scanned from NZ
Submission: On May 19 via automatic, source certstream-suspicious — Scanned from NZ
Form analysis 1 forms found in the DOM
<form class="fields fields-flush launcher-hide-sidebar ng-pristine ng-valid" ng-class="{visible: filters_visible}" ng-submit="onUpdateSelector()">
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('resource_types')}" data-form-type="resource_types">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('resource_types')" ng-blur="onSelectBlur('resource_types')">
<option selected="" disabled="" hidden="" class="ng-binding"> All selected </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('resource_types')">
<li ng-click="onSelectAll('resource_types', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Models <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Seeds <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Snapshots <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Sources <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Tests <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Analyses <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Exposures <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Metrics <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
</ul>
<div class="field-label">resources</div>
</div>
</label>
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('packages')}" data-form-type="packages">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('packages')" ng-blur="onSelectBlur('packages')">
<option selected="" disabled="" hidden="" class="ng-binding"> dlh_um_apac </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('packages')">
<li ng-click="onSelectAll('packages', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.packages -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.packages" ng-click="onItemSelect('packages', item, $event)"> dlh_um_apac <span ng-show="isSelected('packages', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.packages -->
</ul>
<div class="field-label">packages</div>
</div>
</label>
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('tags')}" data-form-type="tags">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('tags')" ng-blur="onSelectBlur('tags', $event)">
<option selected="" disabled="" hidden="" class="ng-binding"> All selected </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('tags')">
<li ng-click="onSelectAll('tags', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null --><span ng-if="item == null" class="ng-scope">untagged</span><!-- end ngIf: item == null -->
<!-- ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null -->
<!-- ngIf: item != null --><span ng-if="item != null" class="ng-binding ng-scope">on-run-start</span><!-- end ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
</ul>
<div class="field-label">tags</div>
</div>
</label>
<label class="field" style="flex: 4 0 160px">
<input type="text" class="field-input form-control input-dark ng-pristine ng-untouched ng-valid ng-empty" ng-model="selectorService.selection.dirty.include" placeholder="...">
<div class="field-label">--select</div>
</label>
<label class="field" style="flex: 4 0 160px">
<input type="text" class="field-input form-control input-dark ng-pristine ng-untouched ng-valid ng-empty" ng-model="selectorService.selection.dirty.exclude" placeholder="...">
<div class="field-label">--exclude</div>
</label>
<label class="field" style="flex: 0 0 80px">
<input type="submit" id="submit-graph-selection" class="field-input form-control input-dark" ng-class="{'dirty-submit': selectorService.isDirty()}" value="Update Graph">
<div class="field-label text-center" style="width: 100%"></div>
</label>
<label class="field" style="flex: 0 0 80px">
<button type="button" ng-click="closeGraph()" class="field-input form-control input-dark text-center"><svg class="icn icn-md">
<use xlink:href="#icn-close"></use>
</svg>
</button>
</label>
</form>Text Content
icons
LINEAGE GRAPH
All selected
* Select All
* Models
* Seeds
* Snapshots
* Sources
* Tests
* Analyses
* Exposures
* Metrics
resources
dlh_um_apac
* Select All
* dlh_um_apac
packages
All selected
* Select All
* untagged
* on-run-start
tags
--select
--exclude
* Overview
* Project
Database
* Sources
* replica
* FOX_NZ__A G_B_APPOINTMENT
* FOX_NZ__AG_B_APPO INTMENT_EXT_NZL
* FOX_NZ__AG_B_A PPOINTMENT_NAME
* FOX_NZ__AG_B_EMPLOYE E_WORKING_HOURS
* FOX_NZ__AG_S_ OUTCOME_EXT_NZL
* FOX_N Z__AG_S_SERVICE
* FOX_NZ__AG_S_ SERVICE_EXT_NZL
* FOX_NZ__AG _S_SERVICE_TYPE
* FOX_N Z__CM_B_ADDRESS
* FO X_NZ__CM_B_SHOP
* FOX_NZ__CM _B_SHOP_EXT_NZL
* FOX_NZ__CM_B _SHOP_HIERARCHY
* FOX_NZ __CM_S_CAMPAIGN
* FOX_NZ__CM_S_C AMPAIGN_EXT_NZL
* FOX_NZ__CM_S_CAM PAIGN_MEDIATYPE
* FOX_NZ__CM_ S_CAMPAIGN_SHOP
* FOX_NZ__CM_ S_CAMPAIGN_TYPE
* FOX_NZ_ _CM_S_DAYCENTER
* FOX_NZ__CM_S_DA YCENTER_EXT_NZL
* FOX_NZ __CM_S_EMPLOYEE
* FOX_NZ__CM_S_E MPLOYEE_EXT_NZL
* FOX_NZ_ _CM_S_MEDIATYPE
* FOX_N Z__CS_S_CHANNEL
* FOX_NZ__CU_B_AC C_TRACK_EXT_NZL
* FOX_NZ __CU_B_ACTIVITY
* FOX_N Z__CU_B_ADDRESS
* FOX_NZ__CU _B_ADDRESS_BOOK
* FOX_NZ__CU_B_ADDRE SS_BOOK_EXT_NZL
* FOX_NZ__CU_B_ ADDRESS_EXT_NZL
* FOX_NZ_ _CU_B_AUDIOGRAM
* FOX_NZ__CU_B_AU DIOGRAM_EXT_NZL
* FOX_NZ__CU_B_C USTOMER_MAPPING
* FOX_NZ__CU_B_CUST_ENT ITL_DET_EXT_NZL
* FOX_NZ__CU_B_ FUNDING_EXT_NZL
* FOX_NZ__CU_B_ HA_ITEM_HISTORY
* FOX_NZ__CU_B_HA_ITEM_ HISTORY_EXT_NZL
* FOX_NZ__CU_B_HEARIN G_CHECK_EXT_NZL
* FOX_NZ__CU_B_INSURANC E_CLAIM_EXT_NZL
* FO X_NZ__CU_B_NOTE
* FOX_NZ__CU_B_OTH ER_ITEM_HISTORY
* FOX_N Z__CU_B_PROFILE
* FOX_NZ__CU_B_PROFILE_A TTRIBUTE_LOOKUP
* FOX_NZ__CU_B_ PROFILE_EXT_ITA
* FOX_NZ__CU_B_QUEST IONNAIRE_DETAIL
* FOX_NZ__CU_B_QUEST IONNAIRE_HEADER
* FOX_NZ__CU_S _AUDIOGRAM_TYPE
* FOX_NZ__CU_S_ENTI TLEMENT_EXT_NZL
* FOX_NZ__C U_S_HICONDITION
* FOX_NZ__CU_S_QUEST IONNAIRE_ANSWER
* FOX_ NZ__CU_S_STATUS
* FO X_NZ__CU_S_TYPE
* FOX_NZ__ET_B_ECONO MIC_TRANSACTION
* FOX_NZ__ET_B_ECO_TRAN SACTION_EXT_NZL
* FOX_NZ__ET_B_PA YMENT_ATTRIBUTE
* FO X_NZ__PD_S_BAND
* FOX _NZ__PD_S_CLASS
* FOX _NZ__PD_S_GROUP
* FOX_NZ_ _PD_S_PRICELIST
* FOX_N Z__PD_S_PRODUCT
* FOX_NZ__P D_S_PRODUCT_CIF
* FOX_NZ__PD_S_P RODUCT_DISCOUNT
* FOX_NZ__PD_S_ PRODUCT_EXT_NZL
* FOX_NZ __PD_S_SUBCLASS
* FOX_NZ__PD_S _SUBCLASS_GROUP
* FOX_NZ __PD_S_SUPPLIER
* FOX_NZ__PD_S_S UPPLIER_EXT_NZL
* FOX_NZ__PO_B_PURCHA SE_ORDER_DETAIL
* FOX_NZ__PO_B_PURCHA SE_ORDER_HEADER
* FOX_NZ__PO_B_PURCH_ ORD_DET_EXT_NZL
* FOX_NZ__PO_B_PURCH_O RD_HEAD_EXT_NZL
* FOX_NZ__RE_B_REPA IR_ORDER_DETAIL
* FOX_NZ__RE_B_REPA IR_ORDER_HEADER
* FOX_NZ__RE_B_REP_ORD _DETAIL_EXT_NZL
* FOX_NZ__RE_B_REP_ORD _HEADER_EXT_NZL
* FOX_NZ__SA _B_QUOTE_DETAIL
* FOX_NZ__SA _B_QUOTE_HEADER
* FOX_NZ__SA_B_QUOTE _HEADER_EXT_NZL
* FOX_NZ__SA_B_QU OTE_PRICE_SPLIT
* FOX_NZ__SA_B_QUOTE_PRIC E_SPLIT_EXT_NZL
* FOX_NZ__SA _B_SALES_DETAIL
* FOX_NZ__SA _B_SALES_HEADER
* FOX_NZ__SA_B_SALES _HEADER_EXT_NZL
* FOX_NZ__SA_B_SA LES_PRICE_SPLIT
* FOX_NZ__SA_B_SALES_PRIC E_SPLIT_EXT_NZL
* FOX_NZ__S A_S_MARKET_TYPE
* FOX_NZ__ST_B_ELECTRONI C_DELIVERY_NOTE
* FOX_NZ__ST_ B_STORE_BALANCE
* FOX_NZ__S Y_ACTIVITY_TYPE
* FOX_NZ__S Y_DOCUMENT_TYPE
* FOX_NZ__S Y_EMPLOYEE_TYPE
* FO X_NZ__SY_GENDER
* FOX_NZ__SY _GENERAL_STATUS
* FOX_NZ__S Y_LOCATION_TYPE
* FO X_NZ__SY_RESULT
* FOX_NZ __TM_B_ACTIVITY
* FOX_NZ__TM_B _MARKETING_LIST
* FOX_NZ__TM_B_MARKETIN G_LIST_CUSTOMER
* FO X_NZ__US_B_USER
Exposures
Metrics
Projects
* dlh_um_apac
* macros
* UM_DELTA
* create _um_delta_table
* create_ um_errors_table
* create _um_merge_table
* delete_er rors_from_delta
* drop _um_delta_temps
* i nsert_fk_errors
* insert_nu ll_field_errors
* manage_um_delta
* set_ delta_to_ignore
* gener ate_schema_name
* test_check_ddl
* test_ equal_row_count
* tes t_length_column
* udfs
* create_ numtodsinterval
* models
* PKG _UM_1_AG_FOX_NZ
* EDW__UM_AG_B_AP POINTMENT__P_NZ
* EDW__UM_AG_B_EMPLOYEE_WORK ING_HOURS__P_NZ
* EDW__UM_AG_ S_OUTCOME__P_NZ
* EDW__UM_AG_S_SER VICE_TYPE__P_NZ
* EDW__UM_AG_ S_SERVICE__P_NZ
* TMP_EDW__UM_AG_B_APPOINTMENT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_B_EMPLOYEE_WORKING_HOURS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_S_OUTCOME__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_S_SERVICE_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_S_SERVICE__P _NZ_NEW_RECORDS
* PKG _UM_1_CM_FOX_NZ
* EDW__UM_CM_ B_ADDRESS__P_NZ
* EDW__UM_CM_S_CAMPAIGN_ MEDIATYPE__P_NZ
* EDW__UM_CM_S_CAMP AIGN_SHOP__P_NZ
* EDW__UM_CM_S_CAMP AIGN_TYPE__P_NZ
* EDW__UM_CM_S _CAMPAIGN__P_NZ
* EDW__UM_CM_S _EMPLOYEE__P_NZ
* EDW__UM_CM_S_ MEDIATYPE__P_NZ
* TMP_EDW__UM_CM_B_ADDRESS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN_MEDIATYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN_SHOP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_EMPLOYEE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_MEDIATYPE__P _NZ_NEW_RECORDS
* PKG _UM_1_CU_FOX_NZ
* EDW__UM_CU_B_ACC_TRAC K_EXT_NZL__P_NZ
* EDW__UM_CU_B _ACTIVITY__P_NZ
* EDW__UM_CU_B_ADD RESS_BOOK__P_NZ
* EDW__UM_CU_ B_ADDRESS__P_NZ
* EDW__UM_CU_B_ ATTRIBUTE__P_NZ
* EDW__UM_CU_B_ AUDIOGRAM__P_NZ
* EDW__U M_CU_B_CLINICAL
* EDW__UM_CU_B_CUSTOME R_MAPPING__P_NZ
* EDW__UM_CU_B_CUST_ ENTITLEMENT_DET
* EDW__UM_CU_ B_FUNDING__P_NZ
* EDW__UM_CU_B_HEAR ING_CHECK__P_NZ
* EDW__UM_CU_B_INSURA NCE_CLAIM__P_NZ
* EDW__UM_CU_B_ITE M_HISTORY__P_NZ
* EDW__UM_ CU_B_NOTE__P_NZ
* EDW__UM_CU_ B_PROFILE__P_NZ
* EDW__UM_CU_S_AUDIO GRAM_TYPE__P_NZ
* EDW__UM_C U_S_ENTITLEMENT
* EDW__UM_C U_S_HICONDITION
* EDW__UM_CU _S_STATUS__P_NZ
* EDW__UM_ CU_S_TYPE__P_NZ
* TMP_EDW__UM_CU_B_ACC_TRACK_EXT_NZL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ACTIVITY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ADDRESS_BOOK__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ADDRESS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ATTRIBUTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_AUDIOGRAM__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_CLINI CAL_NEW_RECORDS
* TMP_EDW__UM_CU_B_CUSTOMER_MAPPING__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_CUST_ENTITLEMENT_ DET_NEW_RECORDS
* TMP_EDW__UM_CU_B_FUNDING__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_HEARING_CHECK__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_INSURANCE_CLAIM__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ITEM_HISTORY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_NOTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_PROFILE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_S_AUDIOGRAM_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_S_ENTITLEM ENT_NEW_RECORDS
* TMP_EDW__UM_CU_S_HICONDIT ION_NEW_RECORDS
* TMP_EDW__UM_CU_S_STATUS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_S_TYPE__P _NZ_NEW_RECORDS
* PKG _UM_1_ET_FOX_NZ
* EDW__UM_ET_B_ECONOMIC_TR ANSACTION__P_NZ
* EDW__UM_ET_B_PAYMENT_ ATTRIBUTE__P_NZ
* TMP_EDW__UM_ET_B_ECONOMIC_TRANSACTION__P _NZ_NEW_RECORDS
* TMP_EDW__UM_ET_B_PAYMENT_ATTRIBUTE__P _NZ_NEW_RECORDS
* PKG _UM_1_OT_FOX_NZ
* EDW__UM_CS_ S_CHANNEL__P_NZ
* ED W__UM_US_B_USER
* TMP_EDW__UM_CS_S_CHANNEL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_US_B_U SER_NEW_RECORDS
* PKG _UM_1_PD_FOX_NZ
* EDW__UM_ PD_S_BAND__P_NZ
* EDW__UM_PD_S_CLASS _SUBCLASS__P_NZ
* EDW__UM_P D_S_GROUP__P_NZ
* EDW__UM_PD_S_ PRICELIST__P_NZ
* EDW__UM_PD_S_PR ODUCT_CIF__P_NZ
* EDW__UM_PD_S_PRODUCT _DISCOUNT__P_NZ
* EDW__UM_PD_ S_PRODUCT__P_NZ
* EDW__UM_PD_S_SUBCL ASS_GROUP__P_NZ
* EDW__UM_PD_S _SUPPLIER__P_NZ
* TMP_EDW__UM_PD_S_BAND__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_CLASS_SUBCLASS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_GROUP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRICELIST__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRODUCT_CIF__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRODUCT_DISCOUNT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRODUCT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_SUBCLASS_GROUP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_SUPPLIER__P _NZ_NEW_RECORDS
* PKG _UM_1_PO_FOX_NZ
* EDW__UM _PO_B_PO_HEADER
* EDW__UM_PO_B_PURCHA SE_ORDER_DETAIL
* TMP_EDW__UM_PO_B_PO_HEA DER_NEW_RECORDS
* TMP_EDW__UM_PO_B_PURCHASE_ORDER_DET AIL_NEW_RECORDS
* PKG _UM_1_QU_FOX_NZ
* EDW__UM_QU_B_QUESTIONNAI RE_DETAIL__P_NZ
* EDW__UM_QU_B_QUESTIONNAI RE_HEADER__P_NZ
* EDW__UM_QU_S_QUESTIONNAI RE_ANSWER__P_NZ
* TMP_EDW__UM_QU_B_QUESTIONNAIRE_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_QU_B_QUESTIONNAIRE_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_QU_S_QUESTIONNAIRE_ANSWER__P _NZ_NEW_RECORDS
* PKG _UM_1_SA_FOX_NZ
* EDW__UM_RE_B_REPAIR_ORD ER_DETAIL__P_NZ
* EDW__UM_RE_B_REPAIR_ORD ER_HEADER__P_NZ
* EDW__UM_SA_B_QUO TE_DETAIL__P_NZ
* EDW__UM_SA_B_QUO TE_HEADER__P_NZ
* EDW__UM_SA_B_QUOTE_PR ICE_SPLIT__P_NZ
* EDW__UM_SA_B_SAL ES_DETAIL__P_NZ
* EDW__UM_SA_B_SAL ES_HEADER__P_NZ
* EDW__UM_SA_B_SALES_PR ICE_SPLIT__P_NZ
* TMP_EDW__UM_RE_B_REPAIR_ORDER_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_RE_B_REPAIR_ORDER_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_QUOTE_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_QUOTE_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_SALES_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_SALES_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_SALES_PRICE_SPLIT__P _NZ_NEW_RECORDS
* PKG_UM _1_SA_MD_FOX_NZ
* EDW__UM_SA_S_MA RKET_TYPE__P_NZ
* TMP_EDW__UM_SA_S_MARKET_TYPE__P _NZ_NEW_RECORDS
* PKG _UM_1_SH_FOX_NZ
* EDW__UM_SH_B_SHOP_ HIERARCHY__P_NZ
* EDW__UM_ SH_B_SHOP__P_NZ
* EDW__UM_SH_S_ DAYCENTER__P_NZ
* TMP_EDW__UM_SH_B_SHOP_HIERARCHY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SH_B_SHOP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SH_S_DAYCENTER__P _NZ_NEW_RECORDS
* PKG _UM_1_ST_FOX_NZ
* EDW__UM_ST_B_ELECTRONIC _DEL_NOTE__P_NZ
* EDW__UM_ST_B_STOR E_BALANCE__P_NZ
* TMP_EDW__UM_ST_B_ELECTRONIC_DEL_NOTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_ST_B_STORE_BALANCE__P _NZ_NEW_RECORDS
* PKG _UM_1_SY_FOX_NZ
* EDW__UM_SY_S_ACTI VITY_TYPE__P_NZ
* EDW__UM_SY_S_DOCU MENT_TYPE__P_NZ
* EDW__UM_SY_S_EMPL OYEE_TYPE__P_NZ
* EDW__UM_SY _S_GENDER__P_NZ
* EDW__UM_SY_S_GENER AL_STATUS__P_NZ
* EDW__UM_SY_S_LOCA TION_TYPE__P_NZ
* EDW__UM_SY _S_RESULT__P_NZ
* TMP_EDW__UM_SY_S_ACTIVITY_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_DOCUMENT_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_EMPLOYEE_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_GENDER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_GENERAL_STATUS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_LOCATION_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_RESULT__P _NZ_NEW_RECORDS
* PKG _UM_1_TM_FOX_NZ
* EDW__UM_TM_B _ACTIVITY__P_NZ
* EDW__UM_TM_B_MARKETING_ LIST_CUST__P_NZ
* EDW__UM_TM_B_MARKE TING_LIST__P_NZ
* TMP_EDW__UM_TM_B_ACTIVITY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_TM_B_MARKETING_LIST_CUST__P _NZ_NEW_RECORDS
* TMP_EDW__UM_TM_B_MARKETING_LIST__P _NZ_NEW_RECORDS
* Tables and Views
* amp-dp-apac-dev
* adp_dlh_l1
* EDW__UM_AG_B_AP POINTMENT__P_NZ
* EDW__UM_AG_B_EMPLOYEE_WORK ING_HOURS__P_NZ
* EDW__UM_AG_ S_OUTCOME__P_NZ
* EDW__UM_AG_S_SER VICE_TYPE__P_NZ
* EDW__UM_AG_ S_SERVICE__P_NZ
* EDW__UM_CM_ B_ADDRESS__P_NZ
* EDW__UM_CM_S_CAMPAIGN_ MEDIATYPE__P_NZ
* EDW__UM_CM_S_CAMP AIGN_SHOP__P_NZ
* EDW__UM_CM_S_CAMP AIGN_TYPE__P_NZ
* EDW__UM_CM_S _CAMPAIGN__P_NZ
* EDW__UM_CM_S _EMPLOYEE__P_NZ
* EDW__UM_CM_S_ MEDIATYPE__P_NZ
* EDW__UM_CS_ S_CHANNEL__P_NZ
* EDW__UM_CU_B_ACC_TRAC K_EXT_NZL__P_NZ
* EDW__UM_CU_B _ACTIVITY__P_NZ
* EDW__UM_CU_B_ADD RESS_BOOK__P_NZ
* EDW__UM_CU_ B_ADDRESS__P_NZ
* EDW__UM_CU_B_ ATTRIBUTE__P_NZ
* EDW__UM_CU_B_ AUDIOGRAM__P_NZ
* EDW__U M_CU_B_CLINICAL
* EDW__UM_CU_B_CUSTOME R_MAPPING__P_NZ
* EDW__UM_CU_B_CUST_ ENTITLEMENT_DET
* EDW__UM_CU_ B_FUNDING__P_NZ
* EDW__UM_CU_B_HEAR ING_CHECK__P_NZ
* EDW__UM_CU_B_INSURA NCE_CLAIM__P_NZ
* EDW__UM_CU_B_ITE M_HISTORY__P_NZ
* EDW__UM_ CU_B_NOTE__P_NZ
* EDW__UM_CU_ B_PROFILE__P_NZ
* EDW__UM_CU_S_AUDIO GRAM_TYPE__P_NZ
* EDW__UM_C U_S_ENTITLEMENT
* EDW__UM_C U_S_HICONDITION
* EDW__UM_CU _S_STATUS__P_NZ
* EDW__UM_ CU_S_TYPE__P_NZ
* EDW__UM_ET_B_ECONOMIC_TR ANSACTION__P_NZ
* EDW__UM_ET_B_PAYMENT_ ATTRIBUTE__P_NZ
* EDW__UM_ PD_S_BAND__P_NZ
* EDW__UM_PD_S_CLASS _SUBCLASS__P_NZ
* EDW__UM_P D_S_GROUP__P_NZ
* EDW__UM_PD_S_ PRICELIST__P_NZ
* EDW__UM_PD_S_PR ODUCT_CIF__P_NZ
* EDW__UM_PD_S_PRODUCT _DISCOUNT__P_NZ
* EDW__UM_PD_ S_PRODUCT__P_NZ
* EDW__UM_PD_S_SUBCL ASS_GROUP__P_NZ
* EDW__UM_PD_S _SUPPLIER__P_NZ
* EDW__UM _PO_B_PO_HEADER
* EDW__UM_PO_B_PURCHA SE_ORDER_DETAIL
* EDW__UM_QU_B_QUESTIONNAI RE_DETAIL__P_NZ
* EDW__UM_QU_B_QUESTIONNAI RE_HEADER__P_NZ
* EDW__UM_QU_S_QUESTIONNAI RE_ANSWER__P_NZ
* EDW__UM_RE_B_REPAIR_ORD ER_DETAIL__P_NZ
* EDW__UM_RE_B_REPAIR_ORD ER_HEADER__P_NZ
* EDW__UM_SA_B_QUO TE_DETAIL__P_NZ
* EDW__UM_SA_B_QUO TE_HEADER__P_NZ
* EDW__UM_SA_B_QUOTE_PR ICE_SPLIT__P_NZ
* EDW__UM_SA_B_SAL ES_DETAIL__P_NZ
* EDW__UM_SA_B_SAL ES_HEADER__P_NZ
* EDW__UM_SA_B_SALES_PR ICE_SPLIT__P_NZ
* EDW__UM_SA_S_MA RKET_TYPE__P_NZ
* EDW__UM_SH_B_SHOP_ HIERARCHY__P_NZ
* EDW__UM_ SH_B_SHOP__P_NZ
* EDW__UM_SH_S_ DAYCENTER__P_NZ
* EDW__UM_ST_B_ELECTRONIC _DEL_NOTE__P_NZ
* EDW__UM_ST_B_STOR E_BALANCE__P_NZ
* EDW__UM_SY_S_ACTI VITY_TYPE__P_NZ
* EDW__UM_SY_S_DOCU MENT_TYPE__P_NZ
* EDW__UM_SY_S_EMPL OYEE_TYPE__P_NZ
* EDW__UM_SY _S_GENDER__P_NZ
* EDW__UM_SY_S_GENER AL_STATUS__P_NZ
* EDW__UM_SY_S_LOCA TION_TYPE__P_NZ
* EDW__UM_SY _S_RESULT__P_NZ
* EDW__UM_TM_B _ACTIVITY__P_NZ
* EDW__UM_TM_B_MARKETING_ LIST_CUST__P_NZ
* EDW__UM_TM_B_MARKE TING_LIST__P_NZ
* ED W__UM_US_B_USER
* TMP_EDW__UM_AG_B_APPOINTMENT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_B_EMPLOYEE_WORKING_HOURS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_S_OUTCOME__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_S_SERVICE_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_AG_S_SERVICE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_B_ADDRESS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN_MEDIATYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN_SHOP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_CAMPAIGN__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_EMPLOYEE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CM_S_MEDIATYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CS_S_CHANNEL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ACC_TRACK_EXT_NZL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ACTIVITY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ADDRESS_BOOK__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ADDRESS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ATTRIBUTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_AUDIOGRAM__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_CLINI CAL_NEW_RECORDS
* TMP_EDW__UM_CU_B_CUSTOMER_MAPPING__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_CUST_ENTITLEMENT_ DET_NEW_RECORDS
* TMP_EDW__UM_CU_B_FUNDING__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_HEARING_CHECK__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_INSURANCE_CLAIM__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_ITEM_HISTORY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_NOTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_B_PROFILE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_S_AUDIOGRAM_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_S_ENTITLEM ENT_NEW_RECORDS
* TMP_EDW__UM_CU_S_HICONDIT ION_NEW_RECORDS
* TMP_EDW__UM_CU_S_STATUS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_CU_S_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_ET_B_ECONOMIC_TRANSACTION__P _NZ_NEW_RECORDS
* TMP_EDW__UM_ET_B_PAYMENT_ATTRIBUTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_BAND__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_CLASS_SUBCLASS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_GROUP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRICELIST__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRODUCT_CIF__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRODUCT_DISCOUNT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_PRODUCT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_SUBCLASS_GROUP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PD_S_SUPPLIER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_PO_B_PO_HEA DER_NEW_RECORDS
* TMP_EDW__UM_PO_B_PURCHASE_ORDER_DET AIL_NEW_RECORDS
* TMP_EDW__UM_QU_B_QUESTIONNAIRE_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_QU_B_QUESTIONNAIRE_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_QU_S_QUESTIONNAIRE_ANSWER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_RE_B_REPAIR_ORDER_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_RE_B_REPAIR_ORDER_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_QUOTE_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_QUOTE_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_SALES_DETAIL__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_SALES_HEADER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_B_SALES_PRICE_SPLIT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SA_S_MARKET_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SH_B_SHOP_HIERARCHY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SH_B_SHOP__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SH_S_DAYCENTER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_ST_B_ELECTRONIC_DEL_NOTE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_ST_B_STORE_BALANCE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_ACTIVITY_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_DOCUMENT_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_EMPLOYEE_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_GENDER__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_GENERAL_STATUS__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_LOCATION_TYPE__P _NZ_NEW_RECORDS
* TMP_EDW__UM_SY_S_RESULT__P _NZ_NEW_RECORDS
* TMP_EDW__UM_TM_B_ACTIVITY__P _NZ_NEW_RECORDS
* TMP_EDW__UM_TM_B_MARKETING_LIST_CUST__P _NZ_NEW_RECORDS
* TMP_EDW__UM_TM_B_MARKETING_LIST__P _NZ_NEW_RECORDS
* TMP_EDW__UM_US_B_U SER_NEW_RECORDS
* adp _dlh_replica_db
* FOX_NZ__A G_B_APPOINTMENT
* FOX_NZ__AG_B_APPO INTMENT_EXT_NZL
* FOX_NZ__AG_B_A PPOINTMENT_NAME
* FOX_NZ__AG_B_EMPLOYE E_WORKING_HOURS
* FOX_NZ__AG_S_ OUTCOME_EXT_NZL
* FOX_N Z__AG_S_SERVICE
* FOX_NZ__AG_S_ SERVICE_EXT_NZL
* FOX_NZ__AG _S_SERVICE_TYPE
* FOX_N Z__CM_B_ADDRESS
* FO X_NZ__CM_B_SHOP
* FOX_NZ__CM _B_SHOP_EXT_NZL
* FOX_NZ__CM_B _SHOP_HIERARCHY
* FOX_NZ __CM_S_CAMPAIGN
* FOX_NZ__CM_S_C AMPAIGN_EXT_NZL
* FOX_NZ__CM_S_CAM PAIGN_MEDIATYPE
* FOX_NZ__CM_ S_CAMPAIGN_SHOP
* FOX_NZ__CM_ S_CAMPAIGN_TYPE
* FOX_NZ_ _CM_S_DAYCENTER
* FOX_NZ__CM_S_DA YCENTER_EXT_NZL
* FOX_NZ __CM_S_EMPLOYEE
* FOX_NZ__CM_S_E MPLOYEE_EXT_NZL
* FOX_NZ_ _CM_S_MEDIATYPE
* FOX_N Z__CS_S_CHANNEL
* FOX_NZ__CU_B_AC C_TRACK_EXT_NZL
* FOX_NZ __CU_B_ACTIVITY
* FOX_N Z__CU_B_ADDRESS
* FOX_NZ__CU _B_ADDRESS_BOOK
* FOX_NZ__CU_B_ADDRE SS_BOOK_EXT_NZL
* FOX_NZ__CU_B_ ADDRESS_EXT_NZL
* FOX_NZ_ _CU_B_AUDIOGRAM
* FOX_NZ__CU_B_AU DIOGRAM_EXT_NZL
* FOX_NZ__CU_B_C USTOMER_MAPPING
* FOX_NZ__CU_B_CUST_ENT ITL_DET_EXT_NZL
* FOX_NZ__CU_B_ FUNDING_EXT_NZL
* FOX_NZ__CU_B_ HA_ITEM_HISTORY
* FOX_NZ__CU_B_HA_ITEM_ HISTORY_EXT_NZL
* FOX_NZ__CU_B_HEARIN G_CHECK_EXT_NZL
* FOX_NZ__CU_B_INSURANC E_CLAIM_EXT_NZL
* FO X_NZ__CU_B_NOTE
* FOX_NZ__CU_B_OTH ER_ITEM_HISTORY
* FOX_N Z__CU_B_PROFILE
* FOX_NZ__CU_B_PROFILE_A TTRIBUTE_LOOKUP
* FOX_NZ__CU_B_ PROFILE_EXT_ITA
* FOX_NZ__CU_B_QUEST IONNAIRE_DETAIL
* FOX_NZ__CU_B_QUEST IONNAIRE_HEADER
* FOX_NZ__CU_S _AUDIOGRAM_TYPE
* FOX_NZ__CU_S_ENTI TLEMENT_EXT_NZL
* FOX_NZ__C U_S_HICONDITION
* FOX_NZ__CU_S_QUEST IONNAIRE_ANSWER
* FOX_ NZ__CU_S_STATUS
* FO X_NZ__CU_S_TYPE
* FOX_NZ__ET_B_ECONO MIC_TRANSACTION
* FOX_NZ__ET_B_ECO_TRAN SACTION_EXT_NZL
* FOX_NZ__ET_B_PA YMENT_ATTRIBUTE
* FO X_NZ__PD_S_BAND
* FOX _NZ__PD_S_CLASS
* FOX _NZ__PD_S_GROUP
* FOX_NZ_ _PD_S_PRICELIST
* FOX_N Z__PD_S_PRODUCT
* FOX_NZ__P D_S_PRODUCT_CIF
* FOX_NZ__PD_S_P RODUCT_DISCOUNT
* FOX_NZ__PD_S_ PRODUCT_EXT_NZL
* FOX_NZ __PD_S_SUBCLASS
* FOX_NZ__PD_S _SUBCLASS_GROUP
* FOX_NZ __PD_S_SUPPLIER
* FOX_NZ__PD_S_S UPPLIER_EXT_NZL
* FOX_NZ__PO_B_PURCHA SE_ORDER_DETAIL
* FOX_NZ__PO_B_PURCHA SE_ORDER_HEADER
* FOX_NZ__PO_B_PURCH_ ORD_DET_EXT_NZL
* FOX_NZ__PO_B_PURCH_O RD_HEAD_EXT_NZL
* FOX_NZ__RE_B_REPA IR_ORDER_DETAIL
* FOX_NZ__RE_B_REPA IR_ORDER_HEADER
* FOX_NZ__RE_B_REP_ORD _DETAIL_EXT_NZL
* FOX_NZ__RE_B_REP_ORD _HEADER_EXT_NZL
* FOX_NZ__SA _B_QUOTE_DETAIL
* FOX_NZ__SA _B_QUOTE_HEADER
* FOX_NZ__SA_B_QUOTE _HEADER_EXT_NZL
* FOX_NZ__SA_B_QU OTE_PRICE_SPLIT
* FOX_NZ__SA_B_QUOTE_PRIC E_SPLIT_EXT_NZL
* FOX_NZ__SA _B_SALES_DETAIL
* FOX_NZ__SA _B_SALES_HEADER
* FOX_NZ__SA_B_SALES _HEADER_EXT_NZL
* FOX_NZ__SA_B_SA LES_PRICE_SPLIT
* FOX_NZ__SA_B_SALES_PRIC E_SPLIT_EXT_NZL
* FOX_NZ__S A_S_MARKET_TYPE
* FOX_NZ__ST_B_ELECTRONI C_DELIVERY_NOTE
* FOX_NZ__ST_ B_STORE_BALANCE
* FOX_NZ__S Y_ACTIVITY_TYPE
* FOX_NZ__S Y_DOCUMENT_TYPE
* FOX_NZ__S Y_EMPLOYEE_TYPE
* FO X_NZ__SY_GENDER
* FOX_NZ__SY _GENERAL_STATUS
* FOX_NZ__S Y_LOCATION_TYPE
* FO X_NZ__SY_RESULT
* FOX_NZ __TM_B_ACTIVITY
* FOX_NZ__TM_B _MARKETING_LIST
* FOX_NZ__TM_B_MARKETIN G_LIST_CUSTOMER
* FO X_NZ__US_B_USER
WELCOME!
Welcome to the auto-generated documentation for your dbt project!
NAVIGATION
You can use the Project and Database navigation tabs on the left side of the
window to explore the models in your project.
PROJECT TAB
The Project tab mirrors the directory structure of your dbt project. In this
tab, you can see all of the models defined in your dbt project, as well as
models imported from dbt packages.
DATABASE TAB
The Database tab also exposes your models, but in a format that looks more like
a database explorer. This view shows relations (tables and views) grouped into
database schemas. Note that ephemeral models are not shown in this interface, as
they do not exist in the database.
GRAPH EXPLORATION
You can click the blue icon on the bottom-right corner of the page to view the
lineage graph of your models.
On model pages, you'll see the immediate parents and children of the model
you're exploring. By clicking the Expand button at the top-right of this lineage
pane, you'll be able to see all of the models that are used to build, or are
built from, the model you're exploring.
Once expanded, you'll be able to use the --select and --exclude model selection
syntax to filter the models in the graph. For more information on model
selection, check out the dbt docs.
Note that you can also right-click on models to interactively filter and explore
the graph.
--------------------------------------------------------------------------------
MORE INFORMATION
* What is dbt?
* Read the dbt viewpoint
* Installation
* Join the dbt Community for questions and discussion
260 SEARCH RESULTS
Name Description Column SQL Tags
EDW__UM_CU_B_CUST_ENTITLEMENT_DET MODEL
columns: CLAIM_DATE, CLAIM_DATE columns: CLAIMED_QUANTITY, CLAIMED_QUANTITY
columns: CLAIMED_VALUE, CLAIMED_VALUE Show 26 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'COUNTER',
'ENTITLEMENT_CODE', 'FITTING_TYPE', 'CUSTOMER_CODE'], pre_hook =
manage_um_delta('EDW__UM_CU_B_CUST_ENTITLEMENT_DET', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'COUNTER', 'ENTITLEMENT_CODE', 'FITTING_TYPE', 'CUSTOMER_CODE',
'DOCUMENT_TYPE_CODE', 'CLAIM_DATE', 'CLAIMED_QUANTITY', 'CLAIMED_VALUE',
'DOCUMENT_NUMBER', 'DOCUMENT_DATE', 'DOCUMENT_LINENUMBER', 'DT_INSERT',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'DT_START', 'DT_END', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'COUNTER', 'ENTITLEMENT_CODE', 'FITTING_TYPE',
'CUSTOMER_CODE'], ['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD', 'COMPANY_CODE',
'DIVISION_CODE', 'COUNTER', 'ENTITLEMENT_CODE', 'FITTING_TYPE', 'CUSTOMER_CODE',
'ROWGUID'], ['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'NEW_RECORDS.COUNTER\tCOUNTER,',
'TRIM(NEW_RECORDS.ENTITLEMENT_CODE)\tENTITLEMENT_CODE,',
'NEW_RECORDS.FITTING_TYPE\tFITTING_TYPE,',
'TRIM(NEW_RECORDS.CUSTOMER_CODE)\tCUSTOMER_CODE,',
'TRIM(NEW_RECORDS.DOCUMENT_TYPE_CODE)\tDOCUMENT_TYPE_CODE,',
'NEW_RECORDS.CLAIM_DATE\tCLAIM_DATE,',
'NEW_RECORDS.CLAIMED_QUANTITY\tCLAIMED_QUANTITY,',
'NEW_RECORDS.CLAIMED_VALUE\tCLAIMED_VALUE,',
'NEW_RECORDS.DOCUMENT_NUMBER\tDOCUMENT_NUMBER,',
'NEW_RECORDS.DOCUMENT_DATE\tDOCUMENT_DATE,',
'NEW_RECORDS.DOCUMENT_LINENUMBER\tDOCUMENT_LINENUMBER,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.DT_START\tDT_START,',
'NEW_RECORDS.DT_END\tDT_END,', 'NEW_RECORDS.ROWGUID\tROWGUID,'], {},
['COMPANY_CODE', 'DIVISION_CODE', 'COUNTER', 'ENTITLEMENT_CODE', 'FITTING_TYPE',
'CUSTOMER_CODE', 'DOCUMENT_TYPE_CODE', 'CLAIM_DATE', 'CLAIMED_QUANTITY',
'CLAIMED_VALUE', 'DOCUMENT_NUMBER', 'DOCUMENT_DATE', 'DOCUMENT_LINENUMBER',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'DT_START', 'DT_END',
'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID',
'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook =
["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_CU_B_CUST_ENTITLEMENT_DET_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_B_CUST_ENTITLEMENT_DET_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_CU_B_CUST_ENTITLEMENT_DET_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_CU_B_CUST_ENTITLEMENT_DET_MERGE
EDW__UM_SY_S_ACTIVITY_TYPE__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 18 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'ACTIVITY_TYPE_CODE'],
pre_hook = manage_um_delta('EDW__UM_SY_S_ACTIVITY_TYPE__P_NZ', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'ACTIVITY_TYPE_CODE', 'ACTIVITY_TYPE_DESCR',
'DOCUMENT_TYPE_CODE', 'DT_START', 'DT_END', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID'], ['COMPANY_CODE', 'DIVISION_CODE',
'ACTIVITY_TYPE_CODE'], ['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD', 'COMPANY_CODE',
'DIVISION_CODE', 'ACTIVITY_TYPE_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.ACTIVITY_TYPE_CODE))\tACTIVITY_TYPE_CODE,',
'NEW_RECORDS.ACTIVITY_TYPE_DESCR\tACTIVITY_TYPE_DESCR,',
'UPPER(TRIM(NEW_RECORDS.DOCUMENT_TYPE_CODE))\tDOCUMENT_TYPE_CODE,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.DT_END\tDT_END,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{'EDW__UM_SY_S_DOCUMENT_TYPE': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('DOCUMENT_TYPE_CODE',
'DOCUMENT_TYPE_CODE')]}, ['COMPANY_CODE', 'DIVISION_CODE', 'ACTIVITY_TYPE_CODE',
'ACTIVITY_TYPE_DESCR', 'DOCUMENT_TYPE_CODE', 'DT_START', 'DT_END', 'DT_INSERT',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD',
'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS',
'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_SY_S_ACTIVITY_TYPE__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_SY_S_ACTIVITY_TYPE__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_SY_S_ACTIVITY_TYPE__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_SY_S_ACTIVITY_TYPE__P_NZ_MERGE
EDW__UM_ST_B_STORE_BALANCE__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 31 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'SHOP_CODE', 'PRODUCT_CODE',
'STOCK_LOCATION_TYPE_CODE', 'STOCK_LOCATION_CODE', 'SERIAL_NUMBER'], pre_hook =
manage_um_delta('EDW__UM_ST_B_STORE_BALANCE__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'SHOP_CODE', 'PRODUCT_CODE', 'STOCK_LOCATION_TYPE_CODE',
'STOCK_LOCATION_CODE', 'SERIAL_NUMBER', 'DT_RECEIPT', 'BALANCE',
'DOCUMENT_TYPE_CODE', 'DOCUMENT_DATE', 'DOCUMENT_NUMBER', 'FLG_QUALITYCHECK',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'SHOP_CODE', 'PRODUCT_CODE',
'STOCK_LOCATION_TYPE_CODE', 'STOCK_LOCATION_CODE', 'SERIAL_NUMBER'],
['X_AUD_FROM_TS', 'COMPANY_CODE', 'DIVISION_CODE', 'SHOP_CODE', 'PRODUCT_CODE',
'STOCK_LOCATION_TYPE_CODE', 'STOCK_LOCATION_CODE', 'SERIAL_NUMBER', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.SHOP_CODE))\tSHOP_CODE,',
'UPPER(TRIM(NEW_RECORDS.PRODUCT_CODE))\tPRODUCT_CODE,',
'UPPER(TRIM(NEW_RECORDS.STOCK_LOCATION_TYPE_CODE))\tSTOCK_LOCATION_TYPE_CODE,',
'UPPER(TRIM(NEW_RECORDS.STOCK_LOCATION_CODE))\tSTOCK_LOCATION_CODE,',
'NEW_RECORDS.SERIAL_NUMBER\tSERIAL_NUMBER,',
'NEW_RECORDS.DT_RECEIPT\tDT_RECEIPT,', 'NEW_RECORDS.BALANCE\tBALANCE,',
'UPPER(TRIM(NEW_RECORDS.DOCUMENT_TYPE_CODE))\tDOCUMENT_TYPE_CODE,',
'NEW_RECORDS.DOCUMENT_DATE\tDOCUMENT_DATE,',
'NEW_RECORDS.DOCUMENT_NUMBER\tDOCUMENT_NUMBER,',
'NEW_RECORDS.FLG_QUALITYCHECK\tFLG_QUALITYCHECK,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,'], {}, ['COMPANY_CODE',
'DIVISION_CODE', 'SHOP_CODE', 'PRODUCT_CODE', 'STOCK_LOCATION_TYPE_CODE',
'STOCK_LOCATION_CODE', 'SERIAL_NUMBER', 'DT_RECEIPT', 'BALANCE',
'DOCUMENT_TYPE_CODE', 'DOCUMENT_DATE', 'DOCUMENT_NUMBER', 'FLG_QUALITYCHECK',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID',
'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS',
'X_AUD_COMPANY_CD', 'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if
exists {{ target.dataset }}.TMP_EDW__UM_ST_B_STORE_BALANCE__P_NZ_NEW_RECORDS",
"drop table if exists {{ target.dataset
}}.TMP_EDW__UM_ST_B_STORE_BALANCE__P_NZ_DELTA", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_ST_B_STORE_BALANCE__P_NZ_MERGE"] ) }} select *
from {{target.dataset}}.TMP_EDW__UM_ST_B_STORE_BALANCE__P_NZ_MERGE
EDW__UM_CM_S_CAMPAIGN__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 26 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'CAMPAIGN_CODE'], pre_hook =
manage_um_delta('EDW__UM_CM_S_CAMPAIGN__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'CAMPAIGN_CODE', 'CAMPAIGN_DESCR', 'CAMPAIGN_TYPE_CODE',
'STATUS_CODE', 'DT_UPDATE_STATUS', 'DT_START', 'DT_END', 'DT_INSERT',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'DT_INSERT_EXT',
'USERINSERT_EXT', 'DT_UPDATE_EXT', 'USERUPDATE_EXT'], ['COMPANY_CODE',
'DIVISION_CODE', 'CAMPAIGN_CODE'], ['X_AUD_FROM_TS', 'COMPANY_CODE',
'DIVISION_CODE', 'CAMPAIGN_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.CAMPAIGN_CODE))\tCAMPAIGN_CODE,',
'NEW_RECORDS.CAMPAIGN_DESCR\tCAMPAIGN_DESCR,',
'UPPER(TRIM(NEW_RECORDS.CAMPAIGN_TYPE_CODE))\tCAMPAIGN_TYPE_CODE,',
'UPPER(TRIM(NEW_RECORDS.STATUS_CODE))\tSTATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_STATUS\tDT_UPDATE_STATUS,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.DT_END\tDT_END,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT_1, INTERVAL 13 HOUR) DT_INSERT_EXT,',
'TRIM(NEW_RECORDS.USERINSERT_1)\tUSERINSERT_EXT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE_1, INTERVAL 13 HOUR) DT_UPDATE_EXT,',
'TRIM(NEW_RECORDS.USERUPDATE_1)\tUSERUPDATE_EXT,'],
{'EDW__UM_CM_S_CAMPAIGN_TYPE': [('CAMPAIGN_TYPE_CODE', 'CAMPAIGN_TYPE_CODE'),
('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE', 'DIVISION_CODE')]},
['COMPANY_CODE', 'DIVISION_CODE', 'CAMPAIGN_CODE', 'CAMPAIGN_DESCR',
'CAMPAIGN_TYPE_CODE', 'STATUS_CODE', 'DT_UPDATE_STATUS', 'DT_START', 'DT_END',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID',
'DT_INSERT_EXT', 'USERINSERT_EXT', 'DT_UPDATE_EXT', 'USERUPDATE_EXT',
'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD',
'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if
exists {{ target.dataset }}.TMP_EDW__UM_CM_S_CAMPAIGN__P_NZ_NEW_RECORDS", "drop
table if exists {{ target.dataset }}.TMP_EDW__UM_CM_S_CAMPAIGN__P_NZ_DELTA",
"drop table if exists {{ target.dataset
}}.TMP_EDW__UM_CM_S_CAMPAIGN__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_CM_S_CAMPAIGN__P_NZ_MERGE
EDW__UM_SH_B_SHOP_HIERARCHY__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 19 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'LEVEL_TYPE_CODE', 'CODE', 'FATHER_CODE',
'DT_START', 'DT_END'], pre_hook =
manage_um_delta('EDW__UM_SH_B_SHOP_HIERARCHY__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'LEVEL_TYPE_CODE', 'CODE', 'FATHER_CODE', 'DT_START', 'DT_END',
'DESCR', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'LEVEL_TYPE_CODE', 'CODE', 'FATHER_CODE',
'DT_START', 'DT_END'], ['X_AUD_FROM_TS', 'COMPANY_CODE', 'DIVISION_CODE',
'LEVEL_TYPE_CODE', 'CODE', 'FATHER_CODE', 'DT_START', 'DT_END', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'TRIM(NEW_RECORDS.LEVEL_TYPE_CODE)\tLEVEL_TYPE_CODE,',
'TRIM(NEW_RECORDS.CODE)\tCODE,', 'TRIM(NEW_RECORDS.FATHER_CODE)\tFATHER_CODE,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.DT_END\tDT_END,',
'NEW_RECORDS.DESCR\tDESCR,', 'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13
HOUR) DT_INSERT,', 'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{}, ['COMPANY_CODE', 'DIVISION_CODE', 'LEVEL_TYPE_CODE', 'CODE', 'FATHER_CODE',
'DT_START', 'DT_END', 'DESCR', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE',
'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_SH_B_SHOP_HIERARCHY__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_SH_B_SHOP_HIERARCHY__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_SH_B_SHOP_HIERARCHY__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_SH_B_SHOP_HIERARCHY__P_NZ_MERGE
EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 26 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'QUOTE_DATE', 'QUOTE_NUMBER',
'QUOTE_LINENUMBER', 'INVOICE_TO_CODE'], pre_hook =
manage_um_delta('EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'QUOTE_DATE', 'QUOTE_NUMBER', 'QUOTE_LINENUMBER',
'INVOICE_TO_CODE', 'QUANTITY', 'UNIT_GROSS_AMOUNT', 'UNIT_NET_AMOUNT',
'WRITE_OFF_AMOUNT', 'MARKET_TYPE_CODE', 'INVOICE_NUMBER', 'INVOICE_DATE',
'CURRENCY_CODE', 'CURRENCY_RATE', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE',
'USERUPDATE', 'ROWGUID'], ['COMPANY_CODE', 'DIVISION_CODE', 'QUOTE_DATE',
'QUOTE_NUMBER', 'QUOTE_LINENUMBER', 'INVOICE_TO_CODE'], ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'QUOTE_DATE', 'QUOTE_NUMBER',
'QUOTE_LINENUMBER', 'INVOICE_TO_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'NEW_RECORDS.QUOTE_DATE\tQUOTE_DATE,',
'NEW_RECORDS.QUOTE_NUMBER\tQUOTE_NUMBER,',
'NEW_RECORDS.QUOTE_LINENUMBER\tQUOTE_LINENUMBER,', 'UPPER(
TRIM(NEW_RECORDS.INVOICE_TO_CODE))\tINVOICE_TO_CODE,',
'NEW_RECORDS.QUANTITY\tQUANTITY,',
'NEW_RECORDS.UNIT_GROSS_AMOUNT\tUNIT_GROSS_AMOUNT,',
'NEW_RECORDS.UNIT_NET_AMOUNT\tUNIT_NET_AMOUNT,',
'NEW_RECORDS.WRITE_OFF_AMOUNT\tWRITE_OFF_AMOUNT,', 'UPPER(
TRIM(NEW_RECORDS.MARKET_TYPE_CODE))\tMARKET_TYPE_CODE,',
'NEW_RECORDS.INVOICE_NUMBER\tINVOICE_NUMBER,',
'NEW_RECORDS.INVOICE_DATE\tINVOICE_DATE,', 'UPPER(
TRIM(NEW_RECORDS.CURRENCY_CODE))\tCURRENCY_CODE,',
'NEW_RECORDS.CURRENCY_RATE\tCURRENCY_RATE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{'EDW__UM_SA_B_QUOTE_DETAIL': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('QUOTE_DATE', 'QUOTE_DATE'),
('QUOTE_LINENUMBER', 'QUOTE_LINENUMBER'), ('QUOTE_NUMBER', 'QUOTE_NUMBER')]},
['COMPANY_CODE', 'DIVISION_CODE', 'QUOTE_DATE', 'QUOTE_NUMBER',
'QUOTE_LINENUMBER', 'INVOICE_TO_CODE', 'QUANTITY', 'UNIT_GROSS_AMOUNT',
'UNIT_NET_AMOUNT', 'WRITE_OFF_AMOUNT', 'MARKET_TYPE_CODE', 'INVOICE_NUMBER',
'INVOICE_DATE', 'CURRENCY_CODE', 'CURRENCY_RATE', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P_NZ_NEW_RECORDS", "drop table if exists
{{ target.dataset }}.TMP_EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P_NZ_DELTA", "drop
table if exists {{ target.dataset
}}.TMP_EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_SA_B_QUOTE_PRICE_SPLIT__P_NZ_MERGE
EDW__UM_CU_B_CUSTOMER_MAPPING__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 18 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE',
'MAPPING_CODE'], pre_hook =
manage_um_delta('EDW__UM_CU_B_CUSTOMER_MAPPING__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'CUSTOMER_CODE', 'MAPPING_CODE', 'ID', 'DT_START', 'DT_END',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'MAPPING_CODE'],
['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE',
'CUSTOMER_CODE', 'MAPPING_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,',
'UPPER(TRIM(NEW_RECORDS.MAPPING_CODE))\tMAPPING_CODE,', 'NEW_RECORDS.ID\tID,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.COMPANY_CODE\tDT_END,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,'], {}, ['COMPANY_CODE',
'DIVISION_CODE', 'CUSTOMER_CODE', 'MAPPING_CODE', 'ID', 'DT_START', 'DT_END',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID',
'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS',
'X_AUD_COMPANY_CD', 'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if
exists {{ target.dataset
}}.TMP_EDW__UM_CU_B_CUSTOMER_MAPPING__P_NZ_NEW_RECORDS", "drop table if exists
{{ target.dataset }}.TMP_EDW__UM_CU_B_CUSTOMER_MAPPING__P_NZ_DELTA", "drop table
if exists {{ target.dataset }}.TMP_EDW__UM_CU_B_CUSTOMER_MAPPING__P_NZ_MERGE"] )
}} select * from
{{target.dataset}}.TMP_EDW__UM_CU_B_CUSTOMER_MAPPING__P_NZ_MERGE
EDW__UM_PD_S_PRODUCT_CIF__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 17 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'PRODUCT_CODE', 'CIF_CODE', 'DT_VALID'],
pre_hook = manage_um_delta('EDW__UM_PD_S_PRODUCT_CIF__P_NZ', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'PRODUCT_CODE', 'CIF_CODE', 'DT_VALID',
'VALUE', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'PRODUCT_CODE', 'CIF_CODE', 'DT_VALID'],
['X_AUD_FROM_TS', 'COMPANY_CODE', 'DIVISION_CODE', 'PRODUCT_CODE', 'CIF_CODE',
'DT_VALID', 'ROWGUID'], ['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'TRIM(NEW_RECORDS.PRODUCT_CODE)\tPRODUCT_CODE,',
'UPPER(TRIM(NEW_RECORDS.CIF_CODE))\tCIF_CODE,',
'NEW_RECORDS.DT_VALID\tDT_VALID,', 'NEW_RECORDS.VALUE\tVALUE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{'EDW__UM_PD_S_PRODUCT': [('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE',
'DIVISION_CODE'), ('PRODUCT_CODE', 'PRODUCT_CODE')]}, ['COMPANY_CODE',
'DIVISION_CODE', 'PRODUCT_CODE', 'CIF_CODE', 'DT_VALID', 'VALUE', 'DT_INSERT',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD',
'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS',
'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_PD_S_PRODUCT_CIF__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_PD_S_PRODUCT_CIF__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_PD_S_PRODUCT_CIF__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_PD_S_PRODUCT_CIF__P_NZ_MERGE
EDW__UM_CM_S_CAMPAIGN_TYPE__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 17 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'CAMPAIGN_TYPE_CODE'], pre_hook =
manage_um_delta('EDW__UM_CM_S_CAMPAIGN_TYPE__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'CAMPAIGN_TYPE_CODE', 'CAMPAIGN_TYPE_DESCR', 'DT_START',
'DT_END', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'CAMPAIGN_TYPE_CODE'], ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'CAMPAIGN_TYPE_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'TRIM(NEW_RECORDS.CAMPAIGN_TYPE_CODE)\tCAMPAIGN_TYPE_CODE,',
'NEW_RECORDS.CAMPAIGN_TYPE_DESCR\tCAMPAIGN_TYPE_DESCR,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.DT_END\tDT_END,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{}, ['COMPANY_CODE', 'DIVISION_CODE', 'CAMPAIGN_TYPE_CODE',
'CAMPAIGN_TYPE_DESCR', 'DT_START', 'DT_END', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_CM_S_CAMPAIGN_TYPE__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CM_S_CAMPAIGN_TYPE__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_CM_S_CAMPAIGN_TYPE__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_CM_S_CAMPAIGN_TYPE__P_NZ_MERGE
EDW__UM_SA_B_SALES_DETAIL__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 59 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER',
'SALE_LINENUMBER'], pre_hook =
manage_um_delta('EDW__UM_SA_B_SALES_DETAIL__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER', 'SALE_LINENUMBER',
'SALE_LINENUMBER_REF', 'STATUS_CODE', 'DT_UPDATE_STATUS',
'VALIDATION_STATUS_CODE', 'DT_UPDATE_VALIDATION_STATUS', 'PRODUCT_CODE',
'SERIAL_NUMBER', 'SIDE_CODE', 'QUANTITY', 'CURRENCY_CODE', 'CURRENCY_RATE',
'UNIT_GROSS_PRICE', 'UNIT_NET_PRICE', 'UNIT_NET_CALCULATED',
'UNIT_NET_PRICELIST', 'PRICELIST_CODE', 'PROMOTION_CODE', 'VAT_CODE', 'VAT',
'PURCHASE_ORDER_DATE', 'PURCHASE_ORDER_NUMBER', 'PURCHASE_ORDER_LINENUMBER',
'EDN_DATE', 'EDN_NUMBER', 'FLG_SUPPORT', 'SUPPORTED_PRODUCT_CODE',
'SUPPORTED_SERIAL_NUMBER', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID'], ['COMPANY_CODE', 'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER',
'SALE_LINENUMBER'], ['X_AUD_FROM_TS', 'COMPANY_CODE', 'DIVISION_CODE',
'SALE_DATE', 'SALE_NUMBER', 'SALE_LINENUMBER', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'NEW_RECORDS.SALE_DATE\tSALE_DATE,', 'NEW_RECORDS.SALE_NUMBER\tSALE_NUMBER,',
'NEW_RECORDS.SALE_LINENUMBER\tSALE_LINENUMBER,',
'NEW_RECORDS.SALE_LINENUMBER_REF\tSALE_LINENUMBER_REF,',
'UPPER(TRIM(NEW_RECORDS.STATUS_CODE))\tSTATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_STATUS\tDT_UPDATE_STATUS,',
'TRIM(NEW_RECORDS.VALIDATION_STATUS_CODE)\tVALIDATION_STATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_VALIDATION_STATUS\tDT_UPDATE_VALIDATION_STATUS,',
'UPPER(TRIM(NEW_RECORDS.PRODUCT_CODE))\tPRODUCT_CODE,',
'NEW_RECORDS.SERIAL_NUMBER\tSERIAL_NUMBER,',
'UPPER(TRIM(NEW_RECORDS.SIDE_CODE))\tSIDE_CODE,',
'NEW_RECORDS.QUANTITY\tQUANTITY,',
'UPPER(TRIM(NEW_RECORDS.CURRENCY_CODE))\tCURRENCY_CODE,',
'NEW_RECORDS.CURRENCY_RATE\tCURRENCY_RATE,',
'NEW_RECORDS.UNIT_GROSS_PRICE\tUNIT_GROSS_PRICE,',
'NEW_RECORDS.UNIT_NET_PRICE\tUNIT_NET_PRICE,',
'NEW_RECORDS.UNIT_NET_CALCULATED\tUNIT_NET_CALCULATED,',
'NEW_RECORDS.UNIT_NET_PRICELIST\tUNIT_NET_PRICELIST,',
'UPPER(TRIM(NEW_RECORDS.PRICELIST_CODE))\tPRICELIST_CODE,',
'UPPER(TRIM(NEW_RECORDS.PROMOTION_CODE))\tPROMOTION_CODE,',
'UPPER(TRIM(NEW_RECORDS.VAT_CODE))\tVAT_CODE,', 'NEW_RECORDS.VAT\tVAT,',
'NEW_RECORDS.PURCHASE_ORDER_DATE\tPURCHASE_ORDER_DATE,',
'NEW_RECORDS.PURCHASE_ORDER_NUMBER\tPURCHASE_ORDER_NUMBER,',
'NEW_RECORDS.PURCHASE_ORDER_LINENUMBER\tPURCHASE_ORDER_LINENUMBER,',
'NEW_RECORDS.EDN_DATE\tEDN_DATE,', 'NEW_RECORDS.EDN_NUMBER\tEDN_NUMBER,',
'TRIM(NEW_RECORDS.FLG_SUPPORT)\tFLG_SUPPORT,',
'TRIM(NEW_RECORDS.SUPPORTED_PRODUCT_CODE)\tSUPPORTED_PRODUCT_CODE,',
'NEW_RECORDS.SUPPORTED_SERIAL_NUMBER\tSUPPORTED_SERIAL_NUMBER,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'trim(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'trim(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{'EDW__UM_PD_S_PRODUCT': [('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE',
'DIVISION_CODE'), ('PRODUCT_CODE', 'PRODUCT_CODE')],
'EDW__UM_SA_B_SALES_HEADER': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('SALE_DATE', 'SALE_DATE'), ('SALE_NUMBER',
'SALE_NUMBER')]}, ['COMPANY_CODE', 'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER',
'SALE_LINENUMBER', 'SALE_LINENUMBER_REF', 'STATUS_CODE', 'DT_UPDATE_STATUS',
'VALIDATION_STATUS_CODE', 'DT_UPDATE_VALIDATION_STATUS', 'PRODUCT_CODE',
'SERIAL_NUMBER', 'SIDE_CODE', 'QUANTITY', 'CURRENCY_CODE', 'CURRENCY_RATE',
'UNIT_GROSS_PRICE', 'UNIT_NET_PRICE', 'UNIT_NET_CALCULATED',
'UNIT_NET_PRICELIST', 'PRICELIST_CODE', 'PROMOTION_CODE', 'VAT_CODE', 'VAT',
'PURCHASE_ORDER_DATE', 'PURCHASE_ORDER_NUMBER', 'PURCHASE_ORDER_LINENUMBER',
'EDN_DATE', 'EDN_NUMBER', 'FLG_SUPPORT', 'SUPPORTED_PRODUCT_CODE',
'SUPPORTED_SERIAL_NUMBER', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID',
'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook =
["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_SA_B_SALES_DETAIL__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_SA_B_SALES_DETAIL__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_SA_B_SALES_DETAIL__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_SA_B_SALES_DETAIL__P_NZ_MERGE
EDW__UM_CU_B_FUNDING__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 25 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE',
'COUNTER'], pre_hook = manage_um_delta('EDW__UM_CU_B_FUNDING__P_NZ', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'COUNTER', 'FUNDING_CODE',
'CLAIM_NUMBER', 'DT_CLAIM', 'FUNDING_OFFICE_CODE', 'FUNDING_OFFICE',
'FLG_ARCHIVED', 'DT_ARCHIVED', 'NOTE', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE',
'USERUPDATE', 'ROWGUID', 'PO_NUMBER', 'FITTING_TYPE_CODE'], ['COMPANY_CODE',
'DIVISION_CODE', 'CUSTOMER_CODE', 'COUNTER'], ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'COUNTER',
'ROWGUID'], ['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,',
'NEW_RECORDS.COUNTER\tCOUNTER,', 'NEW_RECORDS.FUNDING_CODE\tFUNDING_CODE,',
'NEW_RECORDS.CLAIM_NUMBER\tCLAIM_NUMBER,', 'NEW_RECORDS.DT_CLAIM\tDT_CLAIM,',
'NEW_RECORDS.FUNDING_OFFICE_CODE\tFUNDING_OFFICE_CODE,',
'NEW_RECORDS.FUNDING_OFFICE\tFUNDING_OFFICE,',
'NEW_RECORDS.FLG_ARCHIVED\tFLG_ARCHIVED,',
'NEW_RECORDS.DT_ARCHIVED\tDT_ARCHIVED,', 'NEW_RECORDS.NOTE\tNOTE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'NEW_RECORDS.PO_NUMBER\tPO_NUMBER,',
'NEW_RECORDS.FITTING_TYPE_CODE\tFITTING_TYPE_CODE,'], {}, ['COMPANY_CODE',
'DIVISION_CODE', 'CUSTOMER_CODE', 'COUNTER', 'FUNDING_CODE', 'CLAIM_NUMBER',
'DT_CLAIM', 'FUNDING_OFFICE_CODE', 'FUNDING_OFFICE', 'FLG_ARCHIVED',
'DT_ARCHIVED', 'NOTE', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID', 'PO_NUMBER', 'FITTING_TYPE_CODE', 'X_AUD_COMPANY_CD',
'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS',
'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_CU_B_FUNDING__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_B_FUNDING__P_NZ_DELTA", "drop table if exists
{{ target.dataset }}.TMP_EDW__UM_CU_B_FUNDING__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_CU_B_FUNDING__P_NZ_MERGE
EDW__UM_SA_B_SALES_HEADER__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 71 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER'], pre_hook =
manage_um_delta('EDW__UM_SA_B_SALES_HEADER__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER', 'DOCUMENT_TYPE_CODE',
'STATUS_CODE', 'DT_UPDATE_STATUS', 'VALIDATION_STATUS_CODE',
'DT_UPDATE_VALIDATION_STATUS', 'SHOP_CODE', 'LAPTOP_CODE', 'CUSTOMER_CODE',
'EMPLOYEE_CODE', 'MARKET_TYPE_CODE', 'PAYMENT_MODE_CODE', 'PAYMENT_METHOD_CODE',
'PAYER_CODE', 'INVOICE_TO_CODE', 'CURRENCY_CODE', 'CURRENCY_RATE',
'GROSS_AMOUNT', 'DT_EXPIRATION', 'SALE_CANCELLATION_DATE',
'SALE_CANCELLATION_NUMBER', 'PREVIOUS_DOCUMENT_TYPE_CODE',
'PREVIOUS_DOCUMENT_DATE', 'PREVIOUS_DOCUMENT_NUMBER', 'NEXT_DOCUMENT_TYPE_CODE',
'NEXT_DOCUMENT_DATE', 'NEXT_DOCUMENT_NUMBER', 'DELIVERY_DATE',
'DELIVERY_EMPLOYEE_CODE', 'JOURNEY_DATE', 'JOURNEY_NUMBER', 'REASON_CODE',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'DT_INSERT', 'ROWGUID',
'INSURANCE_CODE', 'DT_INSERT_EXT', 'USERINSERT_EXT', 'DT_UPDATE_EXT',
'USERUPDATE_EXT'], ['COMPANY_CODE', 'DIVISION_CODE', 'SALE_DATE',
'SALE_NUMBER'], ['X_AUD_FROM_TS', 'COMPANY_CODE', 'DIVISION_CODE', 'SALE_DATE',
'SALE_NUMBER', 'ROWGUID'], ['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'NEW_RECORDS.SALE_DATE\tSALE_DATE,', 'NEW_RECORDS.SALE_NUMBER\tSALE_NUMBER,',
'UPPER(TRIM(NEW_RECORDS.DOCUMENT_TYPE_CODE))\tDOCUMENT_TYPE_CODE,',
'UPPER(TRIM(NEW_RECORDS.STATUS_CODE))\tSTATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_STATUS\tDT_UPDATE_STATUS,',
'UPPER(TRIM(NEW_RECORDS.VALIDATION_STATUS_CODE))\tVALIDATION_STATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_VALIDATION_STATUS\tDT_UPDATE_VALIDATION_STATUS,',
'TRIM(NEW_RECORDS.SHOP_CODE)\tSHOP_CODE,',
'UPPER(TRIM(NEW_RECORDS.LAPTOP_CODE))\tLAPTOP_CODE,',
'UPPER(TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,',
'UPPER(TRIM(NEW_RECORDS.EMPLOYEE_CODE))\tEMPLOYEE_CODE,',
'UPPER(TRIM(NEW_RECORDS.MARKET_TYPE_CODE))\tMARKET_TYPE_CODE,',
'UPPER(TRIM(NEW_RECORDS.PAYMENT_MODE_CODE))\tPAYMENT_MODE_CODE,',
'UPPER(TRIM(NEW_RECORDS.PAYMENT_METHOD_CODE))\tPAYMENT_METHOD_CODE,',
'UPPER(TRIM(NEW_RECORDS.PAYER_CODE))\tPAYER_CODE,',
'UPPER(TRIM(NEW_RECORDS.INVOICE_TO_CODE))\tINVOICE_TO_CODE,',
'UPPER(TRIM(NEW_RECORDS.CURRENCY_CODE))\tCURRENCY_CODE,',
'NEW_RECORDS.CURRENCY_RATE\tCURRENCY_RATE,',
'NEW_RECORDS.GROSS_AMOUNT\tGROSS_AMOUNT,',
'NEW_RECORDS.DT_EXPIRATION\tDT_EXPIRATION,',
'NEW_RECORDS.SALE_CANCELLATION_DATE\tSALE_CANCELLATION_DATE,',
'NEW_RECORDS.SALE_CANCELLATION_NUMBER\tSALE_CANCELLATION_NUMBER,',
'UPPER(TRIM(NEW_RECORDS.PREVIOUS_DOCUMENT_TYPE_CODE))\tPREVIOUS_DOCUMENT_TYPE_CODE,',
'NEW_RECORDS.PREVIOUS_DOCUMENT_DATE\tPREVIOUS_DOCUMENT_DATE,',
'NEW_RECORDS.PREVIOUS_DOCUMENT_NUMBER\tPREVIOUS_DOCUMENT_NUMBER,',
'UPPER(TRIM(NEW_RECORDS.NEXT_DOCUMENT_TYPE_CODE))\tNEXT_DOCUMENT_TYPE_CODE,',
'NEW_RECORDS.NEXT_DOCUMENT_DATE\tNEXT_DOCUMENT_DATE,',
'NEW_RECORDS.NEXT_DOCUMENT_NUMBER\tNEXT_DOCUMENT_NUMBER,',
'NEW_RECORDS.DELIVERY_DATE\tDELIVERY_DATE,',
'UPPER(TRIM(NEW_RECORDS.DELIVERY_EMPLOYEE_CODE))\tDELIVERY_EMPLOYEE_CODE,',
'NEW_RECORDS.JOURNEY_DATE\tJOURNEY_DATE,',
'NEW_RECORDS.JOURNEY_NUMBER\tJOURNEY_NUMBER,',
'UPPER(TRIM(NEW_RECORDS.REASON_CODE))\tREASON_CODE,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'NEW_RECORDS.ROWGUID\tROWGUID,',
'UPPER(TRIM(NEW_RECORDS.INSURANCE_CODE))\tINSURANCE_CODE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT_1, INTERVAL 13 HOUR) DT_INSERT_EXT,',
'TRIM(NEW_RECORDS.USERINSERT_1)\tUSERINSERT_EXT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE_1, INTERVAL 13 HOUR) DT_UPDATE_EXT,',
'TRIM(NEW_RECORDS.USERUPDATE_1)\tUSERUPDATE_EXT,'],
{'EDW__UM_CU_B_ADDRESS_BOOK': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('CUSTOMER_CODE', 'CUSTOMER_CODE')],
'EDW__UM_CU_S_CUSTOMER_TYPE': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('CUSTOMER_TYPE_CODE', 'TYPE_CODE')],
'EDW__UM_SA_S_MARKET_TYPE': [('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE',
'DIVISION_CODE'), ('MARKET_TYPE_CODE', 'MARKET_TYPE_CODE')],
'EDW__UM_SH_B_SHOP': [('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE',
'DIVISION_CODE'), ('DELIVERY_SHOP_CODE', 'SHOP_CODE')]}, ['COMPANY_CODE',
'DIVISION_CODE', 'SALE_DATE', 'SALE_NUMBER', 'DOCUMENT_TYPE_CODE',
'STATUS_CODE', 'DT_UPDATE_STATUS', 'VALIDATION_STATUS_CODE',
'DT_UPDATE_VALIDATION_STATUS', 'SHOP_CODE', 'LAPTOP_CODE', 'CUSTOMER_CODE',
'EMPLOYEE_CODE', 'MARKET_TYPE_CODE', 'PAYMENT_MODE_CODE', 'PAYMENT_METHOD_CODE',
'PAYER_CODE', 'INVOICE_TO_CODE', 'CURRENCY_CODE', 'CURRENCY_RATE',
'GROSS_AMOUNT', 'DT_EXPIRATION', 'SALE_CANCELLATION_DATE',
'SALE_CANCELLATION_NUMBER', 'PREVIOUS_DOCUMENT_TYPE_CODE',
'PREVIOUS_DOCUMENT_DATE', 'PREVIOUS_DOCUMENT_NUMBER', 'NEXT_DOCUMENT_TYPE_CODE',
'NEXT_DOCUMENT_DATE', 'NEXT_DOCUMENT_NUMBER', 'DELIVERY_DATE',
'DELIVERY_EMPLOYEE_CODE', 'JOURNEY_DATE', 'JOURNEY_NUMBER', 'REASON_CODE',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'DT_INSERT', 'ROWGUID',
'INSURANCE_CODE', 'DT_INSERT_EXT', 'USERINSERT_EXT', 'DT_UPDATE_EXT',
'USERUPDATE_EXT', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID',
'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook =
["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_SA_B_SALES_HEADER__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_SA_B_SALES_HEADER__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_SA_B_SALES_HEADER__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_SA_B_SALES_HEADER__P_NZ_MERGE
EDW__UM_AG_S_OUTCOME__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 16 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'OUTCOME_CODE'], pre_hook =
manage_um_delta('EDW__UM_AG_S_OUTCOME__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'OUTCOME_CODE', 'OUTCOME_DESCR', 'ENTITY_TYPE_CODE',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'OUTCOME_CODE'], ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'OUTCOME_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'TRIM(NEW_RECORDS.OUTCOME_CODE)\tOUTCOME_CODE,',
'NEW_RECORDS.OUTCOME_DESCR\tOUTCOME_DESCR,',
'UPPER(TRIM(NEW_RECORDS.ENTITY_TYPE_CODE))\tENTITY_TYPE_CODE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{}, ['COMPANY_CODE', 'DIVISION_CODE', 'OUTCOME_CODE', 'OUTCOME_DESCR',
'ENTITY_TYPE_CODE', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID',
'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook =
["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_AG_S_OUTCOME__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_AG_S_OUTCOME__P_NZ_DELTA", "drop table if exists
{{ target.dataset }}.TMP_EDW__UM_AG_S_OUTCOME__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_AG_S_OUTCOME__P_NZ_MERGE
EDW__UM_CU_B_AUDIOGRAM__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 81 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE',
'ACTIVITY_DATE', 'TYPE_CODE', 'TYPE_OUT_CODE', 'HICONDITION_CODE', 'SIDE_CODE',
'FRAME'], pre_hook = manage_um_delta('EDW__UM_CU_B_AUDIOGRAM__P_NZ', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'ACTIVITY_DATE', 'TYPE_CODE',
'TYPE_OUT_CODE', 'HICONDITION_CODE', 'SIDE_CODE', 'FRAME', 'MATERIAL', 'FREQ_1',
'VALUE_1', 'FLGMASK_1', 'FLGNOANSWER_1', 'FREQ_2', 'VALUE_2', 'FLGMASK_2',
'FLGNOANSWER_2', 'FREQ_3', 'VALUE_3', 'FLGMASK_3', 'FLGNOANSWER_3', 'FREQ_4',
'VALUE_4', 'FLGMASK_4', 'FLGNOANSWER_4', 'FREQ_5', 'VALUE_5', 'FLGMASK_5',
'FLGNOANSWER_5', 'FREQ_6', 'VALUE_6', 'FLGMASK_6', 'FLGNOANSWER_6', 'FREQ_7',
'VALUE_7', 'FLGMASK_7', 'FLGNOANSWER_7', 'FREQ_8', 'VALUE_8', 'FLGMASK_8',
'FLGNOANSWER_8', 'FREQ_9', 'VALUE_9', 'FLGMASK_9', 'FLGNOANSWER_9', 'FREQ_10',
'VALUE_10', 'FLGMASK_10', 'FLGNOANSWER_10', 'FREQ_11', 'VALUE_11', 'FLGMASK_11',
'FLGNOANSWER_11', 'FREQ_12', 'VALUE_12', 'FLGMASK_12', 'FLGNOANSWER_12',
'FREQ_13', 'VALUE_13', 'FLGMASK_13', 'FLGNOANSWER_13', 'FREQ_14', 'VALUE_14',
'FLGMASK_14', 'FLGNOANSWER_14', 'FREQ_15', 'VALUE_15', 'FLGMASK_15',
'FLGNOANSWER_15', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID'], ['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'ACTIVITY_DATE',
'TYPE_CODE', 'TYPE_OUT_CODE', 'HICONDITION_CODE', 'SIDE_CODE', 'FRAME'],
['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE',
'CUSTOMER_CODE', 'ACTIVITY_DATE', 'TYPE_CODE', 'TYPE_OUT_CODE',
'HICONDITION_CODE', 'SIDE_CODE', 'FRAME', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,',
'NEW_RECORDS.ACTIVITY_DATE\tACTIVITY_DATE,',
'NEW_RECORDS.TYPE_CODE\tTYPE_CODE,',
'NEW_RECORDS.TYPE_OUT_CODE\tTYPE_OUT_CODE,',
'NEW_RECORDS.HICONDITION_CODE\tHICONDITION_CODE,',
'UPPER(TRIM(NEW_RECORDS.SIDE_CODE))\tSIDE_CODE,', 'NEW_RECORDS.FRAME\tFRAME,',
'NEW_RECORDS.MATERIAL\tMATERIAL,', 'NEW_RECORDS.FREQ_1\tFREQ_1,',
'NEW_RECORDS.VALUE_1\tVALUE_1,', 'NEW_RECORDS.FLGMASK_1\tFLGMASK_1,',
'TRIM(NEW_RECORDS.FLGNOANSWER_1)\tFLGNOANSWER_1,',
'NEW_RECORDS.FREQ_2\tFREQ_2,', 'NEW_RECORDS.VALUE_2\tVALUE_2,',
'NEW_RECORDS.FLGMASK_2\tFLGMASK_2,',
'TRIM(NEW_RECORDS.FLGNOANSWER_2)\tFLGNOANSWER_2,',
'NEW_RECORDS.FREQ_3\tFREQ_3,', 'NEW_RECORDS.VALUE_3\tVALUE_3,',
'NEW_RECORDS.FLGMASK_3\tFLGMASK_3,',
'TRIM(NEW_RECORDS.FLGNOANSWER_3)\tFLGNOANSWER_3,',
'NEW_RECORDS.FREQ_4\tFREQ_4,', 'NEW_RECORDS.VALUE_4\tVALUE_4,',
'NEW_RECORDS.FLGMASK_4\tFLGMASK_4,',
'TRIM(NEW_RECORDS.FLGNOANSWER_4)\tFLGNOANSWER_4,',
'NEW_RECORDS.FREQ_5\tFREQ_5,', 'NEW_RECORDS.VALUE_5\tVALUE_5,',
'NEW_RECORDS.FLGMASK_5\tFLGMASK_5,',
'TRIM(NEW_RECORDS.FLGNOANSWER_5)\tFLGNOANSWER_5,',
'NEW_RECORDS.FREQ_6\tFREQ_6,', 'NEW_RECORDS.VALUE_6\tVALUE_6,',
'NEW_RECORDS.FLGMASK_6\tFLGMASK_6,',
'TRIM(NEW_RECORDS.FLGNOANSWER_6)\tFLGNOANSWER_6,',
'NEW_RECORDS.FREQ_7\tFREQ_7,', 'NEW_RECORDS.VALUE_7\tVALUE_7,',
'NEW_RECORDS.FLGMASK_7\tFLGMASK_7,',
'TRIM(NEW_RECORDS.FLGNOANSWER_7)\tFLGNOANSWER_7,',
'NEW_RECORDS.FREQ_8\tFREQ_8,', 'NEW_RECORDS.VALUE_8\tVALUE_8,',
'NEW_RECORDS.FLGMASK_8\tFLGMASK_8,',
'TRIM(NEW_RECORDS.FLGNOANSWER_8)\tFLGNOANSWER_8,',
'NEW_RECORDS.FREQ_9\tFREQ_9,', 'NEW_RECORDS.VALUE_9\tVALUE_9,',
'NEW_RECORDS.FLGMASK_9\tFLGMASK_9,',
'TRIM(NEW_RECORDS.FLGNOANSWER_9)\tFLGNOANSWER_9,',
'NEW_RECORDS.FREQ_10\tFREQ_10,', 'NEW_RECORDS.VALUE_10\tVALUE_10,',
'NEW_RECORDS.FLGMASK_10\tFLGMASK_10,',
'TRIM(NEW_RECORDS.FLGNOANSWER_10)\tFLGNOANSWER_10,',
'NEW_RECORDS.FREQ_11\tFREQ_11,', 'NEW_RECORDS.VALUE_11\tVALUE_11,',
'NEW_RECORDS.FLGMASK_11\tFLGMASK_11,',
'TRIM(NEW_RECORDS.FLGNOANSWER_11)\tFLGNOANSWER_11,',
'NEW_RECORDS.FREQ_12\tFREQ_12,', 'NEW_RECORDS.VALUE_12\tVALUE_12,',
'NEW_RECORDS.FLGMASK_12\tFLGMASK_12,',
'TRIM(NEW_RECORDS.FLGNOANSWER_12)\tFLGNOANSWER_12,',
'NEW_RECORDS.FREQ_13\tFREQ_13,', 'NEW_RECORDS.VALUE_13\tVALUE_13,',
'NEW_RECORDS.FLGMASK_13\tFLGMASK_13,',
'TRIM(NEW_RECORDS.FLGNOANSWER_13)\tFLGNOANSWER_13,',
'NEW_RECORDS.FREQ_14\tFREQ_14,', 'NEW_RECORDS.VALUE_14\tVALUE_14,',
'NEW_RECORDS.FLGMASK_14\tFLGMASK_14,',
'TRIM(NEW_RECORDS.FLGNOANSWER_14)\tFLGNOANSWER_14,',
'NEW_RECORDS.FREQ_15\tFREQ_15,', 'NEW_RECORDS.VALUE_15\tVALUE_15,',
'NEW_RECORDS.FLGMASK_15\tFLGMASK_15,',
'TRIM(NEW_RECORDS.FLGNOANSWER_15)\tFLGNOANSWER_15,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{'EDW__UM_CU_B_ADDRESS_BOOK': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('CUSTOMER_CODE', 'CUSTOMER_CODE')],
'EDW__UM_CU_S_AUDIOGRAM_TYPE': [('TYPE_CODE', 'AUDIOGRAM_TYPE_CODE'),
('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE', 'DIVISION_CODE')]},
['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'ACTIVITY_DATE', 'TYPE_CODE',
'TYPE_OUT_CODE', 'HICONDITION_CODE', 'SIDE_CODE', 'FRAME', 'MATERIAL', 'FREQ_1',
'VALUE_1', 'FLGMASK_1', 'FLGNOANSWER_1', 'FREQ_2', 'VALUE_2', 'FLGMASK_2',
'FLGNOANSWER_2', 'FREQ_3', 'VALUE_3', 'FLGMASK_3', 'FLGNOANSWER_3', 'FREQ_4',
'VALUE_4', 'FLGMASK_4', 'FLGNOANSWER_4', 'FREQ_5', 'VALUE_5', 'FLGMASK_5',
'FLGNOANSWER_5', 'FREQ_6', 'VALUE_6', 'FLGMASK_6', 'FLGNOANSWER_6', 'FREQ_7',
'VALUE_7', 'FLGMASK_7', 'FLGNOANSWER_7', 'FREQ_8', 'VALUE_8', 'FLGMASK_8',
'FLGNOANSWER_8', 'FREQ_9', 'VALUE_9', 'FLGMASK_9', 'FLGNOANSWER_9', 'FREQ_10',
'VALUE_10', 'FLGMASK_10', 'FLGNOANSWER_10', 'FREQ_11', 'VALUE_11', 'FLGMASK_11',
'FLGNOANSWER_11', 'FREQ_12', 'VALUE_12', 'FLGMASK_12', 'FLGNOANSWER_12',
'FREQ_13', 'VALUE_13', 'FLGMASK_13', 'FLGNOANSWER_13', 'FREQ_14', 'VALUE_14',
'FLGMASK_14', 'FLGNOANSWER_14', 'FREQ_15', 'VALUE_15', 'FLGMASK_15',
'FLGNOANSWER_15', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID',
'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook =
["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_CU_B_AUDIOGRAM__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_B_AUDIOGRAM__P_NZ_DELTA", "drop table if exists
{{ target.dataset }}.TMP_EDW__UM_CU_B_AUDIOGRAM__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_CU_B_AUDIOGRAM__P_NZ_MERGE
EDW__UM_AG_S_SERVICE__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 30 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'SERVICE_CODE'], pre_hook =
manage_um_delta('EDW__UM_AG_S_SERVICE__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'SERVICE_CODE', 'SHOP_CODE', 'SERVICE_DESCR',
'SERVICE_TYPE_CODE', 'DEFAULT_DURATION', 'FLG_NEWJOURNEY', 'DT_START', 'DT_END',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID',
'FLG_CHARGEABLE', 'DT_INSERT_EXT', 'USERINSERT_EXT', 'DT_UPDATE_EXT',
'USERUPDATE_EXT'], ['COMPANY_CODE', 'DIVISION_CODE', 'SERVICE_CODE'],
['X_AUD_FROM_TS', 'COMPANY_CODE', 'DIVISION_CODE', 'SERVICE_CODE', 'SHOP_CODE',
'ROWGUID'], ['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.SERVICE_CODE))\tSERVICE_CODE,',
'TRIM(NEW_RECORDS.SHOP_CODE)\tSHOP_CODE,',
'NEW_RECORDS.SERVICE_DESCR\tSERVICE_DESCR,',
'UPPER(TRIM(NEW_RECORDS.SERVICE_TYPE_CODE))\tSERVICE_TYPE_CODE,',
'NEW_RECORDS.DEFAULT_DURATION\tDEFAULT_DURATION,',
'TRIM(NEW_RECORDS.FLG_NEWJOURNEY)\tFLG_NEWJOURNEY,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.DT_END\tDT_END,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'TRIM(NEW_RECORDS.FLG_CHARGEABLE)\tFLG_CHARGEABLE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT_1, INTERVAL 13 HOUR) DT_INSERT_EXT,',
'TRIM(NEW_RECORDS.USERINSERT_1)\tUSERINSERT_EXT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE_1, INTERVAL 13 HOUR) DT_UPDATE_EXT,',
'TRIM(NEW_RECORDS.USERUPDATE_1)\tUSERUPDATE_EXT,'],
{'EDW__UM_AG_S_SERVICE_TYPE': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('SERVICE_TYPE_CODE',
'SERVICE_TYPE_CODE')]}, ['COMPANY_CODE', 'DIVISION_CODE', 'SERVICE_CODE',
'SHOP_CODE', 'SERVICE_DESCR', 'SERVICE_TYPE_CODE', 'DEFAULT_DURATION',
'FLG_NEWJOURNEY', 'DT_START', 'DT_END', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE',
'USERUPDATE', 'ROWGUID', 'FLG_CHARGEABLE', 'DT_INSERT_EXT', 'USERINSERT_EXT',
'DT_UPDATE_EXT', 'USERUPDATE_EXT', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_AG_S_SERVICE__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_AG_S_SERVICE__P_NZ_DELTA", "drop table if exists
{{ target.dataset }}.TMP_EDW__UM_AG_S_SERVICE__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_AG_S_SERVICE__P_NZ_MERGE
EDW__UM_RE_B_REPAIR_ORDER_HEADER__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 61 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'COMPANY_CODE', 'DIVISION_CODE', 'ORDER_DATE', 'ORDER_NUMBER'], pre_hook =
manage_um_delta('EDW__UM_RE_B_REPAIR_ORDER_HEADER__P_NZ', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'ORDER_DATE', 'ORDER_NUMBER', 'SHOP_CODE',
'LAPTOP_CODE', 'STATUS_CODE', 'DT_UPDATE_STATUS', 'VALIDATION_STATUS_CODE',
'DT_UPDATE_VALIDATION_STATUS', 'REASON_CODE', 'PRIORITY_CODE', 'CUSTOMER_CODE',
'EMPLOYEE_CODE', 'REPAIRER_TYPE_CODE', 'REPAIRER_CODE',
'REPAIR_LOCATION_TYPE_CODE', 'REPAIR_LOCATION_CODE', 'DT_REPAIR',
'MARKET_TYPE_CODE', 'INVOICE_TO_CODE', 'PAYER_CODE', 'CURRENCY_CODE',
'CURRENCY_RATE', 'GROSS_AMOUNT', 'DELIVERY_SHOP_CODE',
'PREVIOUS_DOCUMENT_TYPE_CODE', 'PREVIOUS_DOCUMENT_DATE',
'PREVIOUS_DOCUMENT_NUMBER', 'NEXT_DOCUMENT_TYPE_CODE', 'NEXT_DOCUMENT_DATE',
'NEXT_DOCUMENT_NUMBER', 'DELIVERY_DATE', 'QUOTE_MAX_AMOUNT', 'FLG_QUOTE',
'FLG_REPLACEMENT', 'JOURNEY_DATE', 'JOURNEY_NUMBER', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'DT_INSERT_EXT', 'USERINSERT_EXT',
'DT_UPDATE_EXT', 'USERUPDATE_EXT'], ['COMPANY_CODE', 'DIVISION_CODE',
'ORDER_DATE', 'ORDER_NUMBER'], ['X_AUD_FROM_TS', 'COMPANY_CODE',
'DIVISION_CODE', 'ORDER_DATE', 'ORDER_NUMBER', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'NEW_RECORDS.ORDER_DATE\tORDER_DATE,',
'NEW_RECORDS.ORDER_NUMBER\tORDER_NUMBER,', 'UPPER(
TRIM(NEW_RECORDS.SHOP_CODE))\tSHOP_CODE,', 'UPPER(
TRIM(NEW_RECORDS.LAPTOP_CODE))\tLAPTOP_CODE,', 'UPPER(
TRIM(NEW_RECORDS.STATUS_CODE))\tSTATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_STATUS\tDT_UPDATE_STATUS,',
'TRIM(NEW_RECORDS.VALIDATION_STATUS_CODE)\tVALIDATION_STATUS_CODE,',
'NEW_RECORDS.DT_UPDATE_VALIDATION_STATUS\tDT_UPDATE_VALIDATION_STATUS,', 'UPPER(
TRIM(NEW_RECORDS.REASON_CODE))\tREASON_CODE,', 'UPPER(
TRIM(NEW_RECORDS.PRIORITY_CODE))\tPRIORITY_CODE,', 'UPPER(
TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,', 'UPPER(
TRIM(NEW_RECORDS.EMPLOYEE_CODE))\tEMPLOYEE_CODE,', 'UPPER(
TRIM(NEW_RECORDS.REPAIRER_TYPE_CODE))\tREPAIRER_TYPE_CODE,', 'UPPER(
TRIM(NEW_RECORDS.REPAIRER_CODE))\tREPAIRER_CODE,', 'UPPER(
TRIM(NEW_RECORDS.REPAIR_LOCATION_TYPE_CODE))\tREPAIR_LOCATION_TYPE_CODE,',
'UPPER( TRIM(NEW_RECORDS.REPAIR_LOCATION_CODE))\tREPAIR_LOCATION_CODE,',
'NEW_RECORDS.DT_REPAIR\tDT_REPAIR,', 'UPPER(
TRIM(NEW_RECORDS.MARKET_TYPE_CODE))\tMARKET_TYPE_CODE,', 'UPPER(
TRIM(NEW_RECORDS.INVOICE_TO_CODE))\tINVOICE_TO_CODE,', 'UPPER(
TRIM(NEW_RECORDS.PAYER_CODE))\tPAYER_CODE,', 'UPPER(
TRIM(NEW_RECORDS.CURRENCY_CODE))\tCURRENCY_CODE,',
'NEW_RECORDS.CURRENCY_RATE\tCURRENCY_RATE,',
'NEW_RECORDS.GROSS_AMOUNT\tGROSS_AMOUNT,', 'UPPER(
TRIM(NEW_RECORDS.DELIVERY_SHOP_CODE))\tDELIVERY_SHOP_CODE,', 'UPPER(
TRIM(NEW_RECORDS.PREVIOUS_DOCUMENT_TYPE_CODE))\tPREVIOUS_DOCUMENT_TYPE_CODE,',
'NEW_RECORDS.PREVIOUS_DOCUMENT_DATE\tPREVIOUS_DOCUMENT_DATE,',
'NEW_RECORDS.PREVIOUS_DOCUMENT_NUMBER\tPREVIOUS_DOCUMENT_NUMBER,', 'UPPER(
TRIM(NEW_RECORDS.NEXT_DOCUMENT_TYPE_CODE))\tNEXT_DOCUMENT_TYPE_CODE,',
'NEW_RECORDS.NEXT_DOCUMENT_DATE\tNEXT_DOCUMENT_DATE,',
'NEW_RECORDS.NEXT_DOCUMENT_NUMBER\tNEXT_DOCUMENT_NUMBER,',
'NEW_RECORDS.DELIVERY_DATE\tDELIVERY_DATE,',
'NEW_RECORDS.QUOTE_MAX_AMOUNT\tQUOTE_MAX_AMOUNT,', 'UPPER(
TRIM(NEW_RECORDS.FLG_QUOTE))\tFLG_QUOTE,', 'UPPER(
TRIM(NEW_RECORDS.FLG_REPLACEMENT))\tFLG_REPLACEMENT,',
'NEW_RECORDS.JOURNEY_DATE\tJOURNEY_DATE,',
'NEW_RECORDS.JOURNEY_NUMBER\tJOURNEY_NUMBER,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'trim(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT_1, INTERVAL 13 HOUR) DT_INSERT_EXT,',
'TRIM(NEW_RECORDS.USERINSERT_1)\tUSERINSERT_EXT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE_1, INTERVAL 13 HOUR) DT_UPDATE_EXT,',
'TRIM(NEW_RECORDS.USERUPDATE_1)\tUSERUPDATE_EXT,'],
{'EDW__UM_SY_S_DOCUMENT_TYPE': [('COMPANY_CODE', 'COMPANY_CODE'),
('DIVISION_CODE', 'DIVISION_CODE'), ('NEXT_DOCUMENT_TYPE_CODE',
'DOCUMENT_TYPE_CODE'), ('PREVIOUS_DOCUMENT_TYPE_CODE', 'DOCUMENT_TYPE_CODE')],
'EDW__UM_SA_S_MARKET_TYPE': [('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE',
'DIVISION_CODE'), ('MARKET_TYPE_CODE', 'MARKET_TYPE_CODE')],
'EDW__UM_SH_B_SHOP': [('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE',
'DIVISION_CODE'), ('SHOP_CODE', 'SHOP_CODE')], 'EDW__UM_CU_B_ADDRESS_BOOK':
[('COMPANY_CODE', 'COMPANY_CODE'), ('DIVISION_CODE', 'DIVISION_CODE'),
('CUSTOMER_CODE', 'CUSTOMER_CODE')]}, ['COMPANY_CODE', 'DIVISION_CODE',
'ORDER_DATE', 'ORDER_NUMBER', 'SHOP_CODE', 'LAPTOP_CODE', 'STATUS_CODE',
'DT_UPDATE_STATUS', 'VALIDATION_STATUS_CODE', 'DT_UPDATE_VALIDATION_STATUS',
'REASON_CODE', 'PRIORITY_CODE', 'CUSTOMER_CODE', 'EMPLOYEE_CODE',
'REPAIRER_TYPE_CODE', 'REPAIRER_CODE', 'REPAIR_LOCATION_TYPE_CODE',
'REPAIR_LOCATION_CODE', 'DT_REPAIR', 'MARKET_TYPE_CODE', 'INVOICE_TO_CODE',
'PAYER_CODE', 'CURRENCY_CODE', 'CURRENCY_RATE', 'GROSS_AMOUNT',
'DELIVERY_SHOP_CODE', 'PREVIOUS_DOCUMENT_TYPE_CODE', 'PREVIOUS_DOCUMENT_DATE',
'PREVIOUS_DOCUMENT_NUMBER', 'NEXT_DOCUMENT_TYPE_CODE', 'NEXT_DOCUMENT_DATE',
'NEXT_DOCUMENT_NUMBER', 'DELIVERY_DATE', 'QUOTE_MAX_AMOUNT', 'FLG_QUOTE',
'FLG_REPLACEMENT', 'JOURNEY_DATE', 'JOURNEY_NUMBER', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'DT_INSERT_EXT', 'USERINSERT_EXT',
'DT_UPDATE_EXT', 'USERUPDATE_EXT', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_RE_B_REPAIR_ORDER_HEADER__P_NZ_NEW_RECORDS", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_RE_B_REPAIR_ORDER_HEADER__P_NZ_DELTA",
"drop table if exists {{ target.dataset
}}.TMP_EDW__UM_RE_B_REPAIR_ORDER_HEADER__P_NZ_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_RE_B_REPAIR_ORDER_HEADER__P_NZ_MERGE
EDW__UM_CU_S_ENTITLEMENT MODEL
columns: CALCULATION_ORDER, CALCULATION_ORDER columns: COMPANY_CODE,
COMPANY_CODE columns: DIVISION_CODE, DIVISION_CODE Show 26 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'ENTITLEMENT_CODE',
'FITTING_TYPE'], pre_hook = manage_um_delta('EDW__UM_CU_S_ENTITLEMENT', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'ENTITLEMENT_CODE', 'FITTING_TYPE',
'ENTITLEMENT_DESCR', 'MAX_QUANTITY_PER_SALE', 'MIN_QUANTITY', 'MAX_QUANTITY',
'MIN_VALUE', 'MAX_VALUE', 'TIMEFRAME_MONTH_RESTRICTED', 'CALCULATION_ORDER',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'DT_START', 'DT_END',
'PRODUCT_CODE', 'ROWGUID'], ['COMPANY_CODE', 'DIVISION_CODE',
'ENTITLEMENT_CODE', 'FITTING_TYPE'], ['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD',
'COMPANY_CODE', 'DIVISION_CODE', 'ENTITLEMENT_CODE', 'FITTING_TYPE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'TRIM(NEW_RECORDS.ENTITLEMENT_CODE)\tENTITLEMENT_CODE,',
'NEW_RECORDS.FITTING_TYPE\tFITTING_TYPE,',
'NEW_RECORDS.ENTITLEMENT_DESCR\tENTITLEMENT_DESCR,',
'NEW_RECORDS.MAX_QUANTITY_PER_SALE\tMAX_QUANTITY_PER_SALE,',
'NEW_RECORDS.MIN_QUANTITY\tMIN_QUANTITY,',
'NEW_RECORDS.MAX_QUANTITY\tMAX_QUANTITY,', 'NEW_RECORDS.MIN_VALUE\tMIN_VALUE,',
'NEW_RECORDS.MAX_VALUE\tMAX_VALUE,',
'NEW_RECORDS.TIMEFRAME_MONTH_RESTRICTED\tTIMEFRAME_MONTH_RESTRICTED,',
'NEW_RECORDS.CALCULATION_ORDER\tCALCULATION_ORDER,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.DT_START\tDT_START,',
'NEW_RECORDS.DT_END\tDT_END,',
'UPPER(TRIM(NEW_RECORDS.PRODUCT_CODE))\tPRODUCT_CODE,',
'NEW_RECORDS.ROWGUID\tROWGUID,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,'], {}, ['COMPANY_CODE',
'DIVISION_CODE', 'ENTITLEMENT_CODE', 'FITTING_TYPE', 'ENTITLEMENT_DESCR',
'MAX_QUANTITY_PER_SALE', 'MIN_QUANTITY', 'MAX_QUANTITY', 'MIN_VALUE',
'MAX_VALUE', 'TIMEFRAME_MONTH_RESTRICTED', 'CALCULATION_ORDER', 'DT_INSERT',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'DT_START', 'DT_END', 'PRODUCT_CODE',
'ROWGUID', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD',
'X_AUD_INSERT_TS', 'X_AUD_COMPANY_CD', 'X_AUD_FROM_TS'], [], True), post_hook =
["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_CU_S_ENTITLEMENT_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_S_ENTITLEMENT_DELTA", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_S_ENTITLEMENT_MERGE"] ) }} select * from
{{target.dataset}}.TMP_EDW__UM_CU_S_ENTITLEMENT_MERGE
EDW__UM_SY_S_LOCATION_TYPE__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 17 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'LOCATION_TYPE_CODE'],
pre_hook = manage_um_delta('EDW__UM_SY_S_LOCATION_TYPE__P_NZ', 'P_NZ',
['COMPANY_CODE', 'DIVISION_CODE', 'LOCATION_TYPE_CODE', 'LOCATION_TYPE_DESCR',
'DT_START', 'DT_END', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE',
'ROWGUID'], ['COMPANY_CODE', 'DIVISION_CODE', 'LOCATION_TYPE_CODE'],
['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE',
'LOCATION_TYPE_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.LOCATION_TYPE_CODE))\tLOCATION_TYPE_CODE,',
'NEW_RECORDS.LOCATION_TYPE_DESCR\tLOCATION_TYPE_DESCR,',
'NEW_RECORDS.DT_START\tDT_START,', 'NEW_RECORDS.DT_END\tDT_END,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{}, ['COMPANY_CODE', 'DIVISION_CODE', 'LOCATION_TYPE_CODE',
'LOCATION_TYPE_DESCR', 'DT_START', 'DT_END', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_SY_S_LOCATION_TYPE__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_SY_S_LOCATION_TYPE__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_SY_S_LOCATION_TYPE__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_SY_S_LOCATION_TYPE__P_NZ_MERGE
EDW__UM_CU_B_HEARING_CHECK__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 46 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'JOURNEY_NUMBER',
'JOURNEY_DATE', 'CUSTOMER_CODE'], pre_hook =
manage_um_delta('EDW__UM_CU_B_HEARING_CHECK__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'JOURNEY_NUMBER', 'JOURNEY_DATE', 'CUSTOMER_CODE',
'HEARING_CHECK_DATE', 'APPOINTMENT_ID', 'AUDIOGRAM_TYPE_CODE', 'PTA1_L',
'PTA1_R', 'PTA2_L', 'PTA2_R', 'NALPHL', 'FREQ_500_L', 'FREQ_500_R', 'FREQ_1_L',
'FREQ_1_R', 'FREQ_2_L', 'FREQ_2_R', 'FREQ_3_L', 'FREQ_3_R', 'FREQ_4_L',
'FREQ_4_R', 'FLG_TINNITUS_ONE_YEAR', 'FLG_PULSATILE_TINNITUS',
'FLG_SUDDEN_CHANGE_HEARING', 'FLG_EAR_PAIN', 'FLG_INFLAMMATION', 'FLG_DIZZINES',
'FLG_CONCERNS', 'FLG_INDUSTRIAL_NOISES', 'RESULT_CODE', 'CLINICIAN_CODE',
'NOTE', 'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID',
'AIDABILITY'], ['COMPANY_CODE', 'DIVISION_CODE', 'JOURNEY_NUMBER',
'JOURNEY_DATE', 'CUSTOMER_CODE'], ['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD',
'COMPANY_CODE', 'DIVISION_CODE', 'JOURNEY_NUMBER', 'JOURNEY_DATE',
'CUSTOMER_CODE', 'HEARING_CHECK_DATE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'NEW_RECORDS.JOURNEY_NUMBER\tJOURNEY_NUMBER,',
'NEW_RECORDS.JOURNEY_DATE\tJOURNEY_DATE,',
'UPPER(TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,',
'NEW_RECORDS.HEARING_CHECK_DATE\tHEARING_CHECK_DATE,',
'NEW_RECORDS.APPOINTMENT_ID\tAPPOINTMENT_ID,',
'NEW_RECORDS.AUDIOGRAM_TYPE_CODE\tAUDIOGRAM_TYPE_CODE,',
'NEW_RECORDS.PTA1_L\tPTA1_L,', 'NEW_RECORDS.PTA1_R\tPTA1_R,',
'NEW_RECORDS.PTA2_L\tPTA2_L,', 'NEW_RECORDS.PTA2_R\tPTA2_R,',
'NEW_RECORDS.NALPHL\tNALPHL,', 'NEW_RECORDS.FREQ_500_L\tFREQ_500_L,',
'NEW_RECORDS.FREQ_500_R\tFREQ_500_R,', 'NEW_RECORDS.FREQ_1_L\tFREQ_1_L,',
'NEW_RECORDS.FREQ_1_R\tFREQ_1_R,', 'NEW_RECORDS.FREQ_2_L\tFREQ_2_L,',
'NEW_RECORDS.FREQ_2_R\tFREQ_2_R,', 'NEW_RECORDS.FREQ_3_L\tFREQ_3_L,',
'NEW_RECORDS.FREQ_3_R\tFREQ_3_R,', 'NEW_RECORDS.FREQ_4_L\tFREQ_4_L,',
'NEW_RECORDS.FREQ_4_R\tFREQ_4_R,',
'NEW_RECORDS.FLG_TINNITUS_ONE_YEAR\tFLG_TINNITUS_ONE_YEAR,',
'NEW_RECORDS.FLG_PULSATILE_TINNITUS\tFLG_PULSATILE_TINNITUS,',
'NEW_RECORDS.FLG_SUDDEN_CHANGE_HEARING\tFLG_SUDDEN_CHANGE_HEARING,',
'NEW_RECORDS.FLG_EAR_PAIN\tFLG_EAR_PAIN,',
'NEW_RECORDS.FLG_INFLAMMATION\tFLG_INFLAMMATION,',
'NEW_RECORDS.FLG_DIZZINES\tFLG_DIZZINES,',
'NEW_RECORDS.FLG_CONCERNS\tFLG_CONCERNS,',
'NEW_RECORDS.FLG_INDUSTRIAL_NOISES\tFLG_INDUSTRIAL_NOISES,',
'NEW_RECORDS.RESULT_CODE\tRESULT_CODE,',
'NEW_RECORDS.CLINICIAN_CODE\tCLINICIAN_CODE,', 'NEW_RECORDS.NOTE\tNOTE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,',
'NEW_RECORDS.AIDABILITY\tAIDABILITY,'], {}, ['COMPANY_CODE', 'DIVISION_CODE',
'JOURNEY_NUMBER', 'JOURNEY_DATE', 'CUSTOMER_CODE', 'HEARING_CHECK_DATE',
'APPOINTMENT_ID', 'AUDIOGRAM_TYPE_CODE', 'PTA1_L', 'PTA1_R', 'PTA2_L', 'PTA2_R',
'NALPHL', 'FREQ_500_L', 'FREQ_500_R', 'FREQ_1_L', 'FREQ_1_R', 'FREQ_2_L',
'FREQ_2_R', 'FREQ_3_L', 'FREQ_3_R', 'FREQ_4_L', 'FREQ_4_R',
'FLG_TINNITUS_ONE_YEAR', 'FLG_PULSATILE_TINNITUS', 'FLG_SUDDEN_CHANGE_HEARING',
'FLG_EAR_PAIN', 'FLG_INFLAMMATION', 'FLG_DIZZINES', 'FLG_CONCERNS',
'FLG_INDUSTRIAL_NOISES', 'RESULT_CODE', 'CLINICIAN_CODE', 'NOTE', 'DT_INSERT',
'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'AIDABILITY',
'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID', 'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD',
'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [], True), post_hook = ["drop view if
exists {{ target.dataset }}.TMP_EDW__UM_CU_B_HEARING_CHECK__P_NZ_NEW_RECORDS",
"drop table if exists {{ target.dataset
}}.TMP_EDW__UM_CU_B_HEARING_CHECK__P_NZ_DELTA", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_B_HEARING_CHECK__P_NZ_MERGE"] ) }} select *
from {{target.dataset}}.TMP_EDW__UM_CU_B_HEARING_CHECK__P_NZ_MERGE
EDW__UM_CU_B_INSURANCE_CLAIM__P_NZ MODEL
columns: X_AUD_DATASOURCE_ID, X_AUD_DATASOURCE_ID columns: X_AUD_SESSION_ID,
X_AUD_SESSION_ID columns: X_AUD_FROM_TS, X_AUD_FROM_TS Show 33 more
{{ config( materialized = 'incremental', unique_key = ['X_AUD_FROM_TS',
'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE',
'CLAIM_NUMBER'], pre_hook =
manage_um_delta('EDW__UM_CU_B_INSURANCE_CLAIM__P_NZ', 'P_NZ', ['COMPANY_CODE',
'DIVISION_CODE', 'CUSTOMER_CODE', 'CLAIM_NUMBER', 'DT_CLAIM_RECEIVED',
'STATUS_CODE', 'INSURER_CODE', 'INSURER_BRAND', 'REQUEST_TYPE', 'CLAIMANT_NAME',
'SHOP_CODE', 'DT_CLIENT_CONTACTED', 'DT_APPOINTMENT', 'ORIGINAL_HEARING_AID',
'CURRENT_EQUIVALENT_MODEL', 'REPLACEMENT_VALUE', 'INSURANCE_DISCOUNT',
'DEPRECIATION', 'CLIENT_EXCESS', 'TOTAL_TO_PAID', 'HEARING_AID_SIDE', 'NOTE',
'DT_INSERT', 'USERINSERT', 'DT_UPDATE', 'USERUPDATE', 'ROWGUID'],
['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'CLAIM_NUMBER'],
['X_AUD_FROM_TS', 'X_AUD_COMPANY_CD', 'COMPANY_CODE', 'DIVISION_CODE',
'CUSTOMER_CODE', 'CLAIM_NUMBER', 'SHOP_CODE', 'ROWGUID'],
['TRIM(NEW_RECORDS.COMPANY_CODE)\tX_AUD_COMPANY_CD,',
'TRIM(NEW_RECORDS.COMPANY_CODE)\tCOMPANY_CODE,',
'TRIM(NEW_RECORDS.DIVISION_CODE)\tDIVISION_CODE,',
'UPPER(TRIM(NEW_RECORDS.CUSTOMER_CODE))\tCUSTOMER_CODE,',
'NEW_RECORDS.CLAIM_NUMBER\tCLAIM_NUMBER,',
'NEW_RECORDS.DT_CLAIM_RECEIVED\tDT_CLAIM_RECEIVED,',
'NEW_RECORDS.STATUS_CODE\tSTATUS_CODE,',
'NEW_RECORDS.INSURER_CODE\tINSURER_CODE,',
'NEW_RECORDS.INSURER_BRAND\tINSURER_BRAND,',
'NEW_RECORDS.REQUEST_TYPE\tREQUEST_TYPE,',
'NEW_RECORDS.CLAIMANT_NAME\tCLAIMANT_NAME,',
'TRIM(NEW_RECORDS.SHOP_CODE)\tSHOP_CODE,',
'NEW_RECORDS.DT_CLIENT_CONTACTED\tDT_CLIENT_CONTACTED,',
'NEW_RECORDS.DT_APPOINTMENT\tDT_APPOINTMENT,',
'NEW_RECORDS.ORIGINAL_HEARING_AID\tORIGINAL_HEARING_AID,',
'NEW_RECORDS.CURRENT_EQUIVALENT_MODEL\tCURRENT_EQUIVALENT_MODEL,',
'NEW_RECORDS.REPLACEMENT_VALUE\tREPLACEMENT_VALUE,',
'NEW_RECORDS.INSURANCE_DISCOUNT\tINSURANCE_DISCOUNT,',
'NEW_RECORDS.DEPRECIATION\tDEPRECIATION,',
'NEW_RECORDS.CLIENT_EXCESS\tCLIENT_EXCESS,',
'NEW_RECORDS.TOTAL_TO_PAID\tTOTAL_TO_PAID,',
'NEW_RECORDS.HEARING_AID_SIDE\tHEARING_AID_SIDE,', 'NEW_RECORDS.NOTE\tNOTE,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_INSERT, INTERVAL 13 HOUR) DT_INSERT,',
'TRIM(NEW_RECORDS.USERINSERT)\tUSERINSERT,',
'TIMESTAMP_ADD(NEW_RECORDS.DT_UPDATE, INTERVAL 13 HOUR) DT_UPDATE,',
'TRIM(NEW_RECORDS.USERUPDATE)\tUSERUPDATE,', 'NEW_RECORDS.ROWGUID\tROWGUID,'],
{}, ['COMPANY_CODE', 'DIVISION_CODE', 'CUSTOMER_CODE', 'CLAIM_NUMBER',
'DT_CLAIM_RECEIVED', 'STATUS_CODE', 'INSURER_CODE', 'INSURER_BRAND',
'REQUEST_TYPE', 'CLAIMANT_NAME', 'SHOP_CODE', 'DT_CLIENT_CONTACTED',
'DT_APPOINTMENT', 'ORIGINAL_HEARING_AID', 'CURRENT_EQUIVALENT_MODEL',
'REPLACEMENT_VALUE', 'INSURANCE_DISCOUNT', 'DEPRECIATION', 'CLIENT_EXCESS',
'TOTAL_TO_PAID', 'HEARING_AID_SIDE', 'NOTE', 'DT_INSERT', 'USERINSERT',
'DT_UPDATE', 'USERUPDATE', 'ROWGUID', 'X_AUD_COMPANY_CD', 'X_AUD_DATASOURCE_ID',
'X_AUD_SESSION_ID', 'X_AUD_AGENT_CD', 'X_AUD_INSERT_TS', 'X_AUD_FROM_TS'], [],
True), post_hook = ["drop view if exists {{ target.dataset
}}.TMP_EDW__UM_CU_B_INSURANCE_CLAIM__P_NZ_NEW_RECORDS", "drop table if exists {{
target.dataset }}.TMP_EDW__UM_CU_B_INSURANCE_CLAIM__P_NZ_DELTA", "drop table if
exists {{ target.dataset }}.TMP_EDW__UM_CU_B_INSURANCE_CLAIM__P_NZ_MERGE"] ) }}
select * from {{target.dataset}}.TMP_EDW__UM_CU_B_INSURANCE_CLAIM__P_NZ_MERGE
Show 240 more
Refocus on NodeView documentationHide this and parentsHide this and
childrenExport PNG