Pipeline Name Activity Name

PKOVIS_CDC_ TBVM24 All Activities in Pipeline

PBRVIS_CDC_ TBVM24 All Activities in Pipeline
PSNVIS_CDC_ TBVM24 All Activities in Pipeline
PSOVIS_CDC_ TBVM24 All Activities in Pipeline
PSPVIS_CDC_ TBVM24 All Activities in Pipeline
PEBVIS_CDC_ TBVM24 All Activities in Pipeline
PETVIS_CDC_ TBVM24 All Activities in Pipeline
PAIJVIS_CDC_ TBVM24 All Activities in Pipeline
PACFVIS_CDC_TBVM24 All Activities in Pipeline
PZIVIS_CDC_ TBVM24 All Activities in Pipeline
PTEVIS1_CDC_ TBVM24 All Activities in Pipeline
PTEVIS2_CDC_ TBVM24 All Activities in Pipeline
PTEVIS5_CDC_ TBVM24 All Activities in Pipeline
PTEVIS7_CDC_ TBVM24 All Activities in Pipeline

PKOVIS_CDC_ DATALOAD All Activities in Pipeline

PBRVIS_CDC_ DATALOAD All Activities in Pipeline
PSNVIS_CDC_ DATALOAD All Activities in Pipeline
PSOVIS_CDC_ DATALOAD All Activities in Pipeline
NA PSPVIS_CDC_ DATALOAD All Activities in Pipeline
PEBVIS_CDC_ DATALOAD All Activities in Pipeline
EMEA PETVIS_CDC_ DATALOAD All Activities in Pipeline
PAIJVIS_CDC_ DATALOAD All Activities in Pipeline
PACFVIS_CDC_DATALOAD All Activities in Pipeline
PZIVIS_CDC_ DATALOAD All Activities in Pipeline
PTEVIS1_CDC_ DATALOAD All Activities in Pipeline
PTEVIS2_CDC_ DATALOAD All Activities in Pipeline
PTEVIS5_CDC_ DATALOAD All Activities in Pipeline
APAC PTEVIS7_CDC_ DATALOAD All Activities in Pipeline

Yield_CDC_SP_Activity
Components_CDC_APAC Singlerow_CDC_SP_Activity
ViewData_CDC_SP_Activity

Yield_CDC_SP_Activity
Components_CDC_EMEA Singlerow_CDC_SP_Activity
ViewData_CDC_SP_Activity

Yield_CDC_SP_Activity
Components_CDC_NA Singlerow_CDC_SP_Activity
ViewData_CDC_SP_Activity
Every Day Start time in Modified timings in CST
UTC Timings Timings
7:30 AM
8:15 AM
8:35 AM
9:15 AM
9:40 AM
5:15 AM
5:35 AM
12:15 AM
12:35 AM
1:15 AM
1:35 AM
2:15 AM
2:35 AM
3:15 AM

7:45 AM 1:45 AM
8:25 AM 2:25 AM
8:45 AM 2:45 AM
9:25 AM 3:25 AM
9:50 AM 3:50 AM
5:25 AM 11:25:00 PM Previous Day CST
5:45 AM 11:45:00 PM Previous Day CST
12:25 AM  6:25 PM Previous Day CST
12:45 AM  6:45 PM Previous Day CST
1:25 AM  7:25 PM Previous Day CST
1:45 AM  7:45 PM Previous Day CST
2:25 AM  8:25 PM Previous Day CST
2:45 AM  8:45 PM Previous Day CST
3:25 AM  9:25 PM Previous Day CST

5:40 AM  11:40 PM Previous Day CST

6:25 AM 12:25 AM
6:55 AM 12:55 AM

8:00 AM 2:00 AM
8:45 AM 2:45 AM
9:10 AM 3:10 AM

1:00 PM 7:00 AM
1:45 PM 7:45 AM
2:10 PM 8:10 AM
 Pipeline Name Plant Local Time
Wisconsin-PKOVIS 1:45 AM
Brownwood-PBRVIS 2:25 AM
Sanimex Plant1 VIS - PSNVIS 2:45 AM
Sanimex Plant2 VIS - PSOVIS 3:25 AM
NA Spartanburg VIS - PSPVIS 3:50 AM

Belvoye/Dole VIS - PEBVIS 6:25 AM

EMEA Tangier/Morocco VIS - PETVIS 6:45 AM

Jhagadia India VIS - PAIJVIS 5:55 AM

Foshan VIS - PACFVIS 8:45 AM
Zibo VIS - PZIVIS 9:25 AM
Thailand Plant1 VIS - PTEVIS1 8:45 AM
Thailand Plant2 VIS - PTEVIS2 9:25 AM
Thailand Plant5 VIS - PTEVIS5 9:45 AM
APAC Thailand Plant7 VIS - PTEVIS7 10:25 AM
 Modified timings in CST
Time Zone Plant Local Timings Modified UTC Timings
Timings
1:45 AM -6.00 17:00 11:15
2:25 AM -6.00 18:00 12:15
2:45 AM -6.00 19:00 1:15
3:25 AM -6.00 20:00 2:15
3:50 AM -6.00 21:00 3:15

11:25:00 PM Previous Day CST 1.00 17:00 4:00

11:45:00 PM Previous Day CST 1.00 18:00 5:00

 6:25 PM Previous Day CST 5.30 17:00 22:30

 6:45 PM Previous Day CST 8.00 17:00 1:00
 7:25 PM Previous Day CST 8.00 18:00 2:00
 7:45 PM Previous Day CST 7.00 17:00 0:05
 8:25 PM Previous Day CST 7.00 18:00 1:00
 8:45 PM Previous Day CST 7.00 19:00 2:00
 9:25 PM Previous Day CST 7.00 20:00 3:00
 Timings in IST
Region Plant CDC_TBVM24 DATALOAD Plant_NAME MASTER_LOAD
PKOVIS 11:45 AM 12:05PM VK 10:30PM
PBRVIS 12:55 PM 1:15 PM KB 10:40 PM
PSNVIS 12:00 PM 12:15 PM V1 10:50 PM
NA
PSOVIS 1:00 PM 1:15 PM V2 23:00
PSMVIS 11:05 AM 11:20 AM V3 11:15 PM
PSPVIS 1:40 PM 2:20 PM KS 11:10 PM

PEBVIS 4:45 AM 5:05 AM BL 22:10

EA
EM

TA
PETVIS 5:45 AM 6:05 AM 22:20

PACFVIS 10:45 PM 11:05 PM FS 9:10

PTEVIS3 11:00 PM 11:20 PM T3 5:30
PZIVIS 11:45 PM 12:05 AM ZI 9:20
PTEVIS1 12:05 AM 12:25 AM T1 9:30
AC

PTEVIS7 12:05 AM 12:25 AM T7 10:00

AP

PTEVIS2 12:45 AM 1:05 AM T2 9:40

PTEVIS5 12:45 AM 1:05 AM T5 9:50
PAIJVIS 1:15 AM 1:25 AM JH 21:00

N
A
 Components Timings in IST

Yield 2:30 PM
SerialNumGrading 3:15 PM

NA
View 3:40 PM

Yield 7:45 AM

EA
EM
SerialNumGrading 8:30 AM
View 9:15 AM

Yield 1:45 AM
AC

SerialNumGrading 2:15 AM
AP

View 3:00 AM

V3

Wisconsin-PKOVIS -5 1:15 6:15:00 AM 11:45 12:15:00 AM

Brownwood-PBRVIS -5 2:15 7:15:00 AM 12:45 1:15:00 AM
Sanimex Plant1 VIS - PSNVIS -5 3:15 12:15:00 AM 13:45 2:15:00 AM
Sanimex Plant2 VIS - PSOVIS -5 4:15 1:15:00 AM 14:45 3:15:00 AM
Sanimex Plant3 VIS - PSMVIS -5 3:45 12:45:00 AM 14:15 2:45:00 AM
Spartanburg VIS - PSPVIS -5 5:15 2:15:00 AM 15:45 4:15:00 AM
12:30 AM 12:45 AM

7:05 AM
6:35 AM
 Timings in IST

Region Plant DATALOAD Region Plant DATALOAD Region Plant DATALOAD

PKOVIS VK 11:45 AM PEBVIS BL 4:45 AM PACFVIS FS 10:45 PM

EA
EM
PBRVIS KB 12:55 PM PETVIS TA 5:45 AM PTEVIS3 T3 11:00 PM
PSNVIS V1 12:00 PM Yield 7:45 AM PZIVIS ZI 11:45 PM
NA

PSOVIS V2 1:00 PM PTEVIS1 T1 12:05 AM

AC
AP
PSMVIS V3 11:05 AM PTEVIS7 T7 12:05 AM
PSPVIS KS 1:40 PM PTEVIS2 T2 12:45 AM
Yield 2:30 PM PTEVIS5 T5 12:45 AM
PAIJVIS JH 1:45 AM
Yield 1:45 AM
DATALOAD
 VISPRD Database
VisPrd(VIS2_Project)

AAS Database

AAS (Azure Yield_CDC & CDC_TBVM24

Analysis SerialMaster_
Service) CDC Pipeline
 [USP_LoadSerialMaste
rs_CDC] ---> Deleting
existed Serial Numbers
in SerialMaster tables
by comparing
CDC_TBVM24 table for
All Plants, Inserting the
Data into
SerialMaster_BASE
[dbo]. table , Inserting Data
[USP_GetYieldDat into
a_CDC] ---> SerialMaster_PART
(Delete from Yield table, Inserting Data
where into
SerialNumber in SerialMaster_CAST_Sp
(Select Np_Serial ray table
from
CDC_TBVM24)) & Delete from
After that SerialMaster_BASE
"Inserting" the where NP_Serial in
data for all (Select Np_Serial from
"Calculations" CDC_TBVM24)
Delete from
SerialMaster_PART
where NP_Serial in
(Select Np_Serial from
CDC_TBVM24)
Delete from
SerialMaster_CAST_Sp
ray where NP_Serial in
(Select Np_Serial from
CDC_TBVM24)
 Regions

Plants T1
Tables Calculations
[dbo].[TBVM22] spray
[dbo].[TBVM24] This table is common for All Calculations
[dbo].[TBVM25] PCS Rework
[dbo].[TBVM26]
[dbo].[TBVM27]
[dbo].[TBVM28]
[dbo].[TBVM29]
[dbo].[TBVM32] cast
[dbo].[TBVM33]
[dbo].[TBVM35]
[dbo].[TBVN58] cull,Yield_1_F_Pcs_Cull,2-F Pcs Cull
[dbo].[TBVN60]
[dbo].[TBVN61]

Yield_1_F_Pcs_A, 1-F Pcs Rework,

[dbo].[TBVN62] 2-F Pcs A, 2-F PCS Rework, 1-F PCS
Grind, 1-F Pcs A Epoxy, 2-F Pcs A
Grind, 2-F Pcs A Epoxy
[dbo].[TBVN64]
[dbo].[TBVN66]

[dbo].[TBVN94]
[dbo].[TBVO04]
[dbo].[TBVO05]
[dbo].[TBVO06]
[dbo].[TBVO11]
[dbo].[TBVO13]
[dbo].[TBVO14]
[dbo].[TBVT43]
[dbo].[TBXB99]
[dbo].[TBXC00]
[dbo].[TBXC01]
[dbo].[TBYE13]
[dbo].[TBYE14]
[dbo].[TBYE15]
[dbo].[TBYE17]
 APAC EMEA North America(NA)

T2 T3 T5 T7 ZI FS JH BL TA V1 V2 V3
North America(NA)

VK KB KS
 BL FS JH T1 T2
76379 200850 3264627 1452349 819046 345787
594085 12476 62592 62620 47509 13028
485145 190964 3196401 1399384 843977 339540
111162 108232 2630809 827129 580967 243493
106614 28630 151035 187760 115632 17688
101721 53098 418256 375034 88741 78699
136302 37166 317370 315028 65796 68323
395681 17350 105499 56855 21249 12410
613707 21331 170325 113844 23075 27283
323208 7108 10596 128595 291119 18592
13738 24132 428476 221681 25371
2961 2002 51141 26929 1984
3668 5433 162825 23913 5099
76379 594085 485145 111162 106614

KB KS V1 V2 V3
451470 1553655 878886 2780848 2512359 1187686
526520 59270 61779 122331 218059 116908
385738 1610854 845275 2774933 2454001 1209953
837766 1115461 391162 2202455 1357901 689650
362131 132366 89647 176299 333404 117928
164542 253354 345006 290760 612761 263374
204420 295439 241321 445245 197192
66420 61754 48064 152454 59942
150071 161729 94019 222872 100639
23028 2776 34 1575 323
100286 11656 18631 30078 7792
6544 640 6 592 19
22212 5364 2185 17182 2839
451470 526520 385738 837766 362131

orc sql diff

ADM_COMMON_ORDER_DIM 141998049 142004131 -6082
ADM_CUSTOMER_DIM 30980667 30980677 -10
ADM_ORDER_CHGS_FACT 178033058 178010321 22737
 10/31/2019 T1
Sum
T3 T5 T7 TA ZI 2019(T1) orc sql
245572 929096 1054616 1610644 2130899 October 72335 72335
15410 57535 41375 145629 37240 September 91230 82873
234448 890951 1038115 1572241 2083708 August 77296 70933
147026 699876 547428 930280 1773202 July 78371 69766
17399 54839 160960 145641 70664 June 83428 72368
67005 122837 311580 394639 246712 May 80803 71241
54269 99706 216075 286358 207424 April 58962 53863
10501 20014 98040 110295 37886 March 80081 74760
34942 16217 83915 216037 76213 February 71811 68027
1160 38750 29472 65176 3241 January 75168 73424
7313 34463 82571 110465 2086
1102 5666 2408 38920 528
2046 3667 13317 54973 211
101721 136302 395681 613707 323208
t1 t2
PcsCast
VK PcsGreenCull
286392 1-FPcsSpray d
16586 1-FPcsA
276671 1-FPcsCull
169446 1-FPcsRework
28862 2-FPcsA
72984 2-FPcsCull
70256 2-FPcsRework
12820 1-FPcsAGrind
81649 1-FPcsAEpoxy
4757 2-FPcsAGrind
16020 2-FPcsAEpoxy
1455 PCSRework
5573
164542
diff
0
8357
6363
8605
11060
9562
5099
5321
3784
1744

t3 t5 t7 fs jh zi bl ta v1 v2
v3 ks kb vk
select min(POSTING_DATE),max(POSTING_DATE)
select min(POSTING_DATE),max(POSTING_DATE)
select min(DEACTIVATION_DATE),max(DEACTIVATION_DATE)
select min(DATE_CREATED),max(DATE_CREATED)
select min(CREDAT),max(CREDAT)
select min(CREDAT),max(CREDAT)
select min(DATE_CREATED),max(DATE_CREATED)
select min(CREATE_DATE),max(CREATE_DATE)
select min(ACN_DATE),max(ACN_DATE)
select min(SCORECARD_DATE),max(SCORECARD_DATE)
select min(DATE_ROW_LAST_UPDATED),max(DATE_ROW_LAST_UPDATED)
select min(DATE_ROW_LAST_UPDATED),max(DATE_ROW_LAST_UPDATED)
select min(DATE_ROW_LAST_UPDATED),max(DATE_ROW_LAST_UPDATED)
select min(DATE_ROW_LAST_UPDATED),max(DATE_ROW_LAST_UPDATED)
select min(DATE_ROW_LAST_UPDATED),max(DATE_ROW_LAST_UPDATED)
select min(DATE_CREDIT_HDR_ENTERED),max(DATE_CREDIT_HDR_ENTERED)
select min(DATE_VALID_TO),max(DATE_VALID_TO)
select min(LAST_POSTED_UNRSTRICTED_DATE),max(LAST_POSTED_UNRSTRICTED_DATE)
select min(POSTING_DATE),max(POSTING_DATE)
select min(POSTING_DATE),max(POSTING_DATE)
select min(MATRL_AVAIL_DATE),max(MATRL_AVAIL_DATE)
select min(MATRL_AVAIL_DATE),max(MATRL_AVAIL_DATE)
select min(CREATE_DATE),max(CREATE_DATE)
select min(PGI_DATE),max(PGI_DATE)
select min(CREATED_DATE),max(CREATED_DATE)
select min(CREATED_DATE),max(CREATED_DATE)
select min(CREATED_DATE),max(CREATED_DATE)
select min(CREATED_DATE),max(CREATED_DATE)
select min(DELIVERY_CREATE_DATE),max(DELIVERY_CREATE_DATE)
select min(POSTING_DATE),max(POSTING_DATE)
select min(DELIVERY_DATE),max(DELIVERY_DATE)
select min(ACTIVITY_DATE),max(ACTIVITY_DATE)
select min(INVENTORY_DATE),max(INVENTORY_DATE)
select min(SIS_CREATE_DATE),max(SIS_CREATE_DATE)
select min(DATETIME_CHANGED),max(DATETIME_CHANGED)
select min(DATETIME_CHANGED),max(DATETIME_CHANGED)
select min(DATETIME_CHANGED),max(DATETIME_CHANGED)
select min(LAST_CHANGED_DATE),max(LAST_CHANGED_DATE)
select min(DATE_MATERIAL_STATUS),manx(DATE_MATERIAL_STATUS)
select min(POSTING_DATE),max(POSTING_DATE)
select min(INTRO_DATE),max(INTRO_DATE)
select min(INTRO_DATE),max(INTRO_DATE)
select min(DATE_PRICE_CHANGED),max(DATE_PRICE_CHANGED)
select min(DATE_PRICE_CHANGED).,max(DATE_PRICE_CHANGED)
select min(VALID_FROM),max(VALID_TO)
select min(DT_OLDEST_ORDER),max(DT_OLDEST_ORDER)
select min(DT_OLDEST_ORDER),max(DT_OLDEST_ORDER)
select min(DT_OLDEST_ORDER),max(DT_OLDEST_ORDER)
select min(DATE_CREATED),max(DATE_CREATED)
select min(LAST_CHANGED_DATE),max(LAST_CHANGED_DATE)
select min(activity_date),max(activity_date)
select min(VALID_FROM_DATE),max(VALID_FROM_DATE)
select min(VALID_FROM_DATE),max(VALID_FROM_DATE)
select min(INTRO_DATE),max(INTRO_DATE)
select min(CHANGED_ON_DATE),max(CHANGED_ON_DATE)
select min(DELIV_ITEM_CREATE_DATETIME),max(DELIV_ITEM_CREATE_DATETIME)
select min(CHANGED_ON_DATE),max(CHANGED_ON_DATE)
select min(VALIDITY_START_DATE),max(VALIDITY_END_DATE)
select min(DATE_LAST_INVENTORY),
select min(DATE_CREATED),
select min(DATE_CREATED),
select min(DATE_CHANGED),
select min(DATE_CHANGED),
select min(SHIP_COMPLETE_DATE),
select min(SHIP_ITEM_CREATE_DATE),
select min(SHIP_COMPLETE_DATE),
select min(DATETIME_CREATED),
select min(DATE_CHANGED),
select min(DATE_CHANGED),
select min(DATE_LAST_INVENTORY),
select min(DATE_LAST_INVENTORY),
select min(DATE_LAST_INVENTORY),
select min(DATE_CREATED),
select min(DATE_VALUE),
select min(ACTIVITY_DATE),
select min(ACTIVITY_DATE),
select min(CREATED_ON),
select min(DATE_CREATED),
select min(DATE_CREATED),
select min(DATE_CREATED),
select min(DATE_CREATED),
select min(DATE_CREATED),
select min(DATETIME),
select min(DATETIME),
select min(DATETIME),
select min(DATETIME)
select min(DATETIME),
select min(DATETIME),
select min(DP_CHANGED),
select min(DP_INSPECT),
select min(DC_LAST_ACTIVITY),
select min(DP_PASSED_SAP),
select min(DP_PASSED_SAP),
select min(DP_STOCK_CHANGE),
select min(DP_SPRAY),
select min(DP_CAST),
select min(BEGIN_DATE), max(END_DATE)
select min(DATE_CREATED),
select min(START_DATE), max(END_DATE)
select min(JOB_EFFECTIVE_DATE)
select min(DP_CAST)
select min(DC_VALID)
select min(DC_VALID)
select min(CHANGE_DATE)
select min(DI_EXTRACT_TIME)
select min(VENDOR_VALID_FROM_DATE),max(VENDOR_VALID_TO_DATE) from ADM.DTF_PUR3;
select min(PRICING_VALID_FROM_DATE),max(PRICING_VALID_TO_DATE) from ADM.DTF_PUR3;
select min(PROCESS_DATE),max(PROCESS_DATE) from ADM.DW_FILE_TRANSFER_LOG;
select min(LOG_CREATE_DATETIME),max(LOG_CREATE_DATETIME) from ADM.DW_LOG_TABLE;
select min(DATE_MIN),max(DATE_MAX) from ADM.DW_VALIDATION_DENM_FACT;
select min(DATE_MIN),max(DATE_MAX) from ADM.DW_VALIDATION_FACT;
select min(DATE_ROW_LAST_UP)
select min(DATE_OF_LAST_CHG)
select min(DATE_OF_LAST_CHG)
select min(SIS_CREATE_DATE)
select min(DATE_OF_LAST_CHG)
select min(DATE_OF_LAST_CHG)
select min(REPORTED_ON)
select min(BEGIN_DATE)
select min(BEGIN_DATE),max(END_DATE) from ADM.HR_APPLICATION_FACT;
select min(BEGIN_DATE),max(END_DATE) from ADM.HR_APPLICATION_VAC_FACT;
select min(BEGIN_DATE),max(END_DATE) from ADM.HR_CHILDREN_FACT;
select min(START_DATE),max(END_DATE) from ADM.HR_CONFIDENTIAL;
select min(DATE_CHANGE),max(DATE_CHANGE) from ADM.HR_DAILY_CHGS;
select min(LAST_WORK_DATE),max(LAST_WORK_DATE) from ADM.HR_DATES_FACT;

select min(DATE_CHANGED ),
select min(DATE_CHANGED ),
select min(DATE_CHANGED ),
select min(DATE_REPORTED),
select min(DATE_ELIGIBLE),
select min(DATE_ELIGIBLE),
select min(DATE_ELIGIBLE),

select min(DATE_CHANGED),
select min(CHANGE_DATE ),
select min(CHANGE_DATE ),
select min(CHANGE_DATE ),
select min(CHANGE_DATE ),
select min(CHANGE_DATE ),
select min(CHANGE_DATE ),
select min(CHANGE_DATE ),
select min(DATE_CHANGED),
select min(DATE_CHANGED),
select min(DATE_CHANGED),

select min(AEDTM
select min(POSITION_START_DATE
select min(DW_LOGDATE
select min(POSITION_START_DATE
select min(DATE_VESTED ),

select min(LOG_CREATE_DATETIME),
select min(DEACTIVATION_DATE ),
select min(SIS_CREATE_DATE
select min(SIS_CREATE_DATE
select min(LAST_CHANGED_DATE ),
select min(DT_OLDEST_ORDER ),

select min(DC_DATE_ORDER_ENTER )
select min(SALES_STATUS_DATE )
select min(SALES_STATUS_DATE )
select min(PCORP_STATUS )
from ADM.ADM_AR_CLOSED_ACCTG_ITEM_FACT
from ADM.ADM_AR_OPEN_ACCTG_ITEM_FACT
from ADM.ADM_ASSET_MASTER_DIM
from ADM.ADM_CARRIER_SCOR_CMP_INPL_TEMP
from ADM.ADM_CARRIER_SCOR_CMPLTD_TEMP
from ADM.ADM_CARRIER_SCOR_IDOCS_FACT
from ADM.ADM_CARRIER_SCOR_INTRPLNT_FACT
from ADM.ADM_CARRIER_SCOR_QUALITY_FACT
from ADM.ADM_CARRIER_SCOR_SHIPMENT_FACT
from ADM.ADM_CARRIER_SCORECARD_FACT
from ADM.ADM_COMMON_ORDER_DIM
from ADM.ADM_COMMON_ORDER_DIM_2
from ADM.ADM_COMMON_ORDER_DIM_Temp
from ADM.adm_Common_Order_Dim_TM
from ADM.adm_Common_Order_Dim_TMP
from ADM.ADM_CREDIT_REQUEST_DIM
from ADM.ADM_CURRENCY_DIM
from ADM.ADM_CUST_SALES_ORD_STOCK_FACT
from ADM.ADM_DEDUCT_CURR_OPEN_DIM
from ADM.ADM_DEDUCTIONS_CLEARED_FACT
from ADM.ADM_DELIVERY_DTL_PROFILE_DIM
from ADM.ADM_DELIVERY_DTL_PROFILE_DIM_Temp
from ADM.ADM_DELIVERY_HDR_DATES_DIM
from ADM.ADM_DELIVERY_HEADER_FACT
from ADM.ADM_DELIVERY_INT_PACKAGE_FACT
from ADM.ADM_DELIVERY_INT_PACKAGE_TEMP
from ADM.ADM_DELIVERY_PACKAGE_FACT
from ADM.ADM_DELIVERY_PACKAGE_TEMP
from ADM.ADM_DELIVERY_SERIAL_FACT
from ADM.ADM_GEN_STOCK_TRANSP_FACT
from ADM.ADM_GEN_ZVOPD
from ADM.ADM_GLOBAL_UNITS_FACT
 from ADM.ADM_INV_USAGE_TEMP
from ADM.ADM_INVOICE_TO_CUSTOMER_FACT
from ADM.ADM_KPAC_MULTI_SHOP_FLOOR_FACT
from ADM.ADM_KPAC_SHOP_FLOOR_FACT
from ADM.ADM_KPAC_SHOP_FLOOR_FACT_TEMP
from ADM.ADM_MATERIAL_DIM
from ADM.ADM_MATERIAL_STATUS_DIM
from ADM.ADM_MATRL_BOAT_STOCK_FACT
from ADM.ADM_MATRL_CLASSIF_DIM
from ADM.ADM_MATRL_CLASSIF_DIM_TEMP
from ADM.ADM_MATRL_COST_DIM
from ADM.ADM_MATRL_COST_TEMP
from ADM.ADM_MATRL_LEADTIME_FACT
from ADM.ADM_MATRL_PLANT_DIM;
from ADM.ADM_MATRL_PLANT_DIM_temp;
from ADM.ADM_MATRL_PLANT_DIM_TEST;
from ADM.ADM_MATRL_SHORTAGE_TEMP;
from ADM.ADM_MATRL_TEMP;
from ADM.ADM_MATRL_UNIT_REPORTS_MVW_Table;
from ADM.ADM_MATRL_VEND_DIM;
from ADM.ADM_MATRL_VEND_TEMP;
from ADM.ADM_MATRL_VITALITY_DIM;
from ADM.ADM_OCT_TEMP;
from ADM.ADM_OPEN_ORDERS_DELIVERY_FACT;
from ADM.ADM_ORDER_CYCLE_TIME_FACT;
from ADM.ADM_PRICE_WATERFALL_MAP_DIM;
max(DATE_LAST_INVENTORY) from ADM.ADM_PRIOR_MONTH_STOCK_SL_DIM;
max(DATE_CREATED) from ADM.ADM_REBATE_AGREEMENTS;
max(DATE_CREATED) from ADM.ADM_REBATE_AGREEMENTS_TEMP;
max(DATE_CHANGED) from ADM.ADM_RETURN_DELIVERY_FACT;
max(DATE_CHANGED) from ADM.ADM_RETURN_DELIVERY_TEMP;
max(SHIP_COMPLETE_DATE) from ADM.ADM_SC_SHIP_DELIV_TEMP;
max(SHIP_ITEM_CREATE_DATE) from ADM.ADM_SC_SHIPPING_DETAIL_FACT;
max(SHIP_COMPLETE_DATE) from ADM.ADM_SC_SHIPPING_HDR_DATES_DIM;
max(DATETIME_CREATED) from ADM.ADM_SCRAP_FACT;
max(DATE_CHANGED) from ADM.ADM_SHIPPING_PDM_FACT;
max(DATE_CHANGED) from ADM.ADM_SHIPPING_PDM_TEMP;
max(DATE_LAST_INVENTORY) from ADM.ADM_STOCK_STRLOCN_DIM;
max(DATE_LAST_INVENTORY) from ADM.ADM_STOCK_STRLOCN_DIM_TEMP;
max(DATE_LAST_INVENTORY) from ADM.ADM_STOCK_STRLOCN_DIM_temp1;
max(DATE_CREATED) from ADM.ADM_SUPPLIER_SCORECARD_FACT;
max(DATE_VALUE) from ADM.ADM_TIME_DIM;
max(ACTIVITY_DATE) from ADM.ADM_UNIT_SHIP_PLAN_FACT;
max(ACTIVITY_DATE) from ADM.ADM_UNIT_SHIP_STG;
max(CREATED_ON) from ADM.ADM_VC_SUM_FACT;
max(DATE_CREATED) from ADM.ADM_VENDOR_COMP_CODE_DIM;
max(DATE_CREATED) from ADM.ADM_VENDOR_COMP_CODE_DIM_TEMP;
max(DATE_CREATED) from ADM.ADM_VENDOR_PURCH_ORG_DIM;
max(DATE_CREATED) from ADM.ADM_VENDOR_PURCH_ORG_DIM_TEMP;
max(DATE_CREATED) from ADM.ADM_ZBIN_LOCATION_DIM;
max(DATETIME) from ADM.BODS_LOG_HistoryTable;
max(DATETIME) from ADM.BODS_LOG_TABLE;
max(DATETIME) from ADM.BODS_LOG_TABLE_sampleData;
max(DATETIME) from ADM.BODS_LOG_TABLE_Temp;
max(DATETIME) from ADM.BODSDailyStausTable;
max(DATETIME) from ADM.BODSDayDataTempTable;
max(DP_CHANGED) from ADM.BRVIS_TBVM24;
max(DP_INSPECT) from ADM.BRVIS_TBVM27;
max(DC_LAST_ACTIVITY) from ADM.BRVIS_TBVM32;
max(DP_PASSED_SAP) from ADM.BRVIS_TBVN58;
max(DP_PASSED_SAP) from ADM.BRVIS_TBVN60;
max(DP_STOCK_CHANGE) from ADM.BRVIS_TBVN62;
max(DP_SPRAY) from ADM.BRVIS_WHSE_VM22VM24_VW;
max(DP_CAST) from ADM.BRVIS_WHSE_VN66VM24_VW;
from ADM.COMP_BASIC_PAY_FACT;
max(DATE_CREATED) from ADM.CORP_ADM_SUPPLIER_SCORECARD_FACT;
from ADM.CORP_HR_CONFIDENTIAL;
, max(JOB_EFFECTIVE_DATE) from ADM.CORP_HR_EMP_AGREEMENT_DIM;
, max(DP_CAST) from ADM.CORP_TBXC96_SERIAL_CLAIM;
, max(DC_VALID) from ADM.CORP_TV01SSAP_TBXF09_QUALITY_DPPM;
, max(DC_VALID) from ADM.CORP_TV01SSAP_TBXF11_DELIVERY_OTPS;
, max(CHANGE_DATE) from ADM.CRM_BP_ADDRESS_DIM;
, max(DI_EXTRACT_TIME) from ADM.DPCPDSB3;

,max(DATE_ROW_LAST_UP) from ADM.ESD_COMMON_ORDER_DIM;

,max(DATE_OF_LAST_CHG) from ADM.ESD_CREDIT_REQUEST_FACT;
,max(DATE_OF_LAST_CHG) from ADM.ESD_CREDITS_FACT;
,max(SIS_CREATE_DATE) from ADM.ESD_CREDITS_FACT;
,max(DATE_OF_LAST_CHG) from ADM.ESD_ORDER_CHGS_FACT;
,max(DATE_OF_LAST_CHG) from ADM.ESD_SHIPMENTS_FACT;
,max(REPORTED_ON) from ADM.HR_ABSENCE_FACT;
,max(END_DATE) from ADM.HR_ADDRESS_HIST;

max(DATE_CHANGED ) from ADM.HR_MULTIJOBS_FACT;

max(DATE_CHANGED ) from ADM.HR_MULTIJOBS_HOSP_FACT;
max(DATE_CHANGED ) from ADM.HR_ORG_FACT;
max(DATE_REPORTED) from ADM.HR_OSHA_FACT;
max(DATE_ELIGIBLE) from ADM.HR_PA0169_TEMP;
max(DATE_ELIGIBLE) from ADM.HR_PACE_FACT;
max(DATE_ELIGIBLE) from ADM.HR_PACE_FACT_TEMP;

max(DATE_CHANGED) from ADM.HR_TMP_HRP1000;

max(CHANGE_DATE ) from ADM.HR_TMP_HRP1003;
max(CHANGE_DATE ) from ADM.HR_TMP_HRP1005;
max(CHANGE_DATE ) from ADM.HR_TMP_HRP1006;
max(CHANGE_DATE ) from ADM.HR_TMP_HRP1007;
max(CHANGE_DATE ) from ADM.HR_TMP_HRP1008;
max(CHANGE_DATE ) from ADM.HR_TMP_HRP1010;
max(CHANGE_DATE ) from ADM.HR_TMP_HRP1013;
max(DATE_CHANGED) from ADM.HR_TMP_HRP9513;
max(DATE_CHANGED) from ADM.HR_TMP_PA0000;
max(DATE_CHANGED) from ADM.HR_TMP_PA0001;

), max(AEDTM
), max(POSI
), max(DW_LOGDATE
), max(POSI
max(DATE_VESTED )

max(LOG_CREATE_DATETIME) from ADM.Jobs_LOG_TABLE

max(DEACTIVATION_DATE ) from ADM ;
), max(SIS_CREATE_DATE ) from ADM ;
), max(SIS_CREATE_DATE ) from ADM.KCOR_ADM_IDD_FA
max(LAST_CHANGED_DATE ) from ADM.KCOR_AD
max(DT_OLDEST_ORDER ) from ADM.KCOR_ADM_MATRL_PLANT

,max(DC_DATE_ORDER_ENTER ) from ADM ;

,max(SALES_STATUS_DATE ) from ADM.KMDW_MATERIALS
,max(SALES_STATUS_DATE ) from ADM.KMDW_MATERIALS_TEMP
,max(PCORP_STATUS ) from ADM.KOHL_ADM_STATUS_DIM

select min(DP_CHANGED )
select min(DP_INSPECT )
select min(DC_LAST_ACTIVITY )
select min(DP_PASSED_SAP )
select min(DP_PASSED_SAP )
select min(DP_RECORD_STATUS )
select min(DP_SPRAY
select min(DP_CAST
select min(DP_LAST_UPDATE )
select min(DP_LAST_UPDATE )
select min(DP_LAST_UPDATE )
select min(DP_LAST_UPDATE )
select min(DP_LAST_UPDATE )
select min(CHANGED_AT )
select min(LAST_UPDATE )
select min(DELIVERY_DT )
select min(DELIVERY_DATE )
select min(CREATE_DT )
select min(CREATE_DATE )
select min(FREIGHTPOITEMDELIVERYDATE )
select min(FACTORY_COMPLETION_DT )
select min(FACTORY_COMPLETION_DT )
select min(IDOC_CREATION_DATE )
select min(IDOC_CREATION_DATE )
select min(EFFECTIVE_DATE )
select min(CLEARING_DATE )
select min(CLEARING_DATE )
select min(PERIOD_END_DATE )
select min(GOODS_RECPT_DATE )
select min(DATE_CREATED )
select min(PERIOD_END_DATE )
select min(PERIOD_YR )
select min(INVENTORY_DATE )
select min(PERIOD_END_DATE )
select min(CLEARING_DATE )
select min(CLEARING_DATE )
select min(LOT_CREATE_DATE )
select min(PERIOD_END_DATE )
select min(CHANGED_ON )
select min(DATE_CREATED )
select min(DATE_CREATED )
select min(DATE_CREATED )
select min(PCORP_STATUS )
select min(EDATU
select min(DP_CHANGED )
select min(DP_INSPECT )
select min(DC_LAST_ACTIVITY )
select min(DP_PASSED_SAP )
select min(DP_PASSED_SAP )
select min(DP_SPRAY
select min(DP_CAST
select min(DP_CHANGED )
select min(DC_LAST_ACTIVITY )
select min(DP_PASSED_SAP )
select min(DP_PASSED_SAP )
select min(DP_SPRAY
select min(DP_CAST
select min(DP_CHANGED )
select min(DP_INSPECT )
select min(DC_LAST_ACTIVITY )
select min(DP_PASSED_SAP )
select min(DP_PASSED_SAP )
select min(DP_RECORD_STATUS )
select min(DP_SPRAY
select min(DP_CAST
select min(0CALDAY
select min(DATE_ROW_LAST_UPDATED )
select min(PGI_DATE )
P_HRP1000;
P_HRP1003;
P_HRP1005;
P_HRP1006;
P_HRP1007;
P_HRP1008;
P_HRP1010;
P_HRP1013;
P_HRP9513;

max(AEDTM ) from ADM.HR_VISIER1_PA0001;

) from ADM.HR_ZPEE ;
max(DW_LOGDATE ) from ADM ;
) from ADM.HR_ZPEE2 ;
max(DATE_VESTED ) from ADM.HR_ZPPC_VEST_TEMP;

M.Jobs_LOG_TABLE ;

M.KCOR_ADM_IDD_FA ;
;
M.KCOR_ADM_MATRL_PLANT_DIM ;
M.KMDW_MATERIALS ;
M.KMDW_MATERIALS_TEMP ;
M.KOHL_ADM_STATUS_DIM ;

,max(DP_CHANGED ) FROM ADM.KOVIS_TBVM24

,max(DP_INSPECT ) FROM ADM.KOVIS_TBVM27
,max(DC_LAST_ACTIV ) FROM ADM.KOVIS_TBVM32
,max(DP_PASSED_SAP ) FROM ADM.KOVIS_TBVN58
,max(DP_PASSED_SAP ) FROM ADM.KOVIS_TBVN60
,max(DP_RECORD_S ) FROM ADM.KOVIS_TBVN62
) ,max(DP_SPRAY ) FROM ADM.KOVIS_WHSE_VM22VM24_VW
) ,max(DP_CAST ) FROM ADM.KOVIS_WHSE_VN66VM24_VW
,max(DP_LAST_UPDATE ) FROM ADM.MK08CCDB_TBUO00
,max(DP_LAST_UPDATE ) FROM ADM.MK08CCDB_TBUO01
,max(DP_LAST_UPDATE ) FROM ADM.MK08CCDB_TBUO17
,max(DP_LAST_UPDATE ) FROM ADM.MK08CCDB_TBUO18
,max(DP_LAST_UPDATE ) FROM ADM.MK08CCDB_TBUO19
,max(CHANGED_AT ) FROM ADM.MK08CCDB_TBXB29_ASR_TE;
,max(LAST_UPDATE ) FROM ADM.MK08CCDB_TBXB32_BR_ZN_;
,max(DELIVERY_DT ) FROM ADM.PRM_CONFIRMATIONS_FACT
,max(DELIVERY_DATE ) FROM ADM.PRM_FREIGHT_PO_FACT
,max(CREATE_DT ) FROM ADM.PRM_PO_HDR_FACT
,max(CREATE_DATE ) FROM ADM.PRM_SALES_ORDER_HDR_FA;
,max(FREIGHTPOITEMDELIVERYDATE ) FROM ADM.PRM_SAP_INTERFACE_TEMP
,max(FAC ) FROM ADM.PRM_SHIPMENT_HDR_FACT
,max(FAC ) FROM ADM.PRM_SHIPMENT_HDR_TEMP
,max(IDOC_CREATIO ) FROM ADM.PUR_CFA_EDI_PUR;
,max(IDOC_CREATIO ) FROM ADM.PUR_CFA_EDI_ZEDIIN_FACT ;
,max(EFFECTIVE_DATE ) FROM ADM.PUR_CFA_MARC_TEMP
,max(CLEARING_DATE ) FROM ADM.PUR_DAILY_INVOICE_FACT
,max(CLEARING_DATE ) FROM ADM.PUR_DAILY_INVOICE_TEMP
 ,max(PERIOD_END_D ) FROM ADM.PUR_DELIVERY_MEASURES_F;
,max(GOODS_RECPT ) FROM ADM.PUR_DELIVERY_MEASURES_ ;
,max(DATE_CREATED ) FROM ADM.PUR_GOODS_RECEIPT_FACT
,max(PERIOD_END_D ) FROM ADM.PUR_GOODS_RECEIPT_SUM_;
,max(PERIOD_YR ) FROM ADM.PUR_INV_ACT_YRLY_FACT
,max(INVENTORY_DATE ) FROM ADM.PUR_MATRL_INVE;
,max(PERIOD_END_D ) FROM ADM.PUR_MNTHLY_INV;
,max(CLEARING_DATE ) FROM ADM.PUR_NON_PO_DLY_ ;
,max(CLEARING_DATE ) FROM ADM.PUR_NON_PO_DLY;
,max(LOT_CREATE_D ) FROM ADM.PUR_QUALITY_RECEIPTS_FAC;
,max(PERIOD_END_D ) FROM ADM.PUR_QUALITY_REC;
,max(CHANGED_ON ) FROM ADM.PUR_QUALITY_SCA;
,max(DATE_CREATED ) FROM ADM.PUR_QUALITY_SCAR_FACT
,max(DATE_CREATED ) FROM ADM.PUR_VENDOR_DIM_2
,max(DATE_CREATED ) FROM ADM.PUR_VENDOR_DM_STG
,max(PCORP_STATUS ) FROM ADM.QCORP_ADM_STATUS_DIM
) ,max(EDATU ) FROM ADM.Schedule_lines_Vbep
,max(DP_CHANGED ) FROM ADM.SNVIS_TBVM24
,max(DP_INSPECT ) FROM ADM.SNVIS_TBVM27
,max(DC_LAST_ACTIV ) FROM ADM.SNVIS_TBVM32
,max(DP_PASSED_SAP ) FROM ADM.SNVIS_TBVN58
,max(DP_PASSED_SAP ) FROM ADM.SNVIS_TBVN60
) ,max(DP_SPRAY ) FROM ADM.SNVIS_WHSE_VM22VM24_VW
) ,max(DP_CAST ) FROM ADM.SNVIS_WHSE_VN66VM24_VW
,max(DP_CHANGED ) FROM ADM.SOVIS_TBVM24
,max(DC_LAST_ACTIV ) FROM ADM.SOVIS_TBVM32
,max(DP_PASSED_SAP ) FROM ADM.SOVIS_TBVN58
,max(DP_PASSED_SAP ) FROM ADM.SOVIS_TBVN60
) ,max(DP_SPRAY ) FROM ADM.SOVIS_WHSE_VM22VM24_VW
) ,max(DP_CAST ) FROM ADM.SOVIS_WHSE_VN66VM24_VW
,max(DP_CHANGED ) FROM ADM.SPVIS_TBVM24
,max(DP_INSPECT ) FROM ADM.SPVIS_TBVM27
 ,max(DC_LAST_ACTIV ) FROM ADM.SPVIS_TBVM32
,max(DP_PASSED_SAP ) FROM ADM.SPVIS_TBVN58
,max(DP_PASSED_SAP ) FROM ADM.SPVIS_TBVN60
,max(DP_RECORD_S ) FROM ADM.SPVIS_TBVN62
) ,max(DP_SPRAY ) FROM ADM.SPVIS_WHSE_VM22VM24_VW
) ,max(DP_CAST ) FROM ADM.SPVIS_WHSE_VN66VM24_VW
) ,max(0CALDAY ) FROM ADM.TBL_OHD_DPCPDSB3
,max(DAT ) FROM ADM.Temp_ADM_COMMON_ORDE ;
,max(PGI_DATE ) FROM ADM.Temp_ADM_DELIVERY_HEADER_FACT ;
select min(Valid_To_), max(Valid_To_Date
select min(AEDAT ), max(AEDAT
select min(AEDAT ), max(AEDAT
select min(AEDAT ), max(AEDAT
select min(DP_SPRA ), max(DP_SPRAY_DATE
select mi ), max(DC_NS
select min(DP_INSP ), max(DP_INSPECT_DA
select min(DC_LAST_), max(DC_LAST_ACTIV
select min(DP_CULL_DATE ), max(DP_CULL_DATE
select min(DP_PASS ), max(DP_PASSED_SAP
select min(DP_PACK_DATE ), max(DP_PACK_DATE
select mi ), max(DP_S
select min(DP_CAST_DATE ), max(DP_CAST_DATE
select min(DP_POT ), max(DP_POTTERY_O
select min(ENDDA ), max(ENDDA
select min(ERDAT ), max(ERDAT )
select min(VALIDITY_START_DATE
VALIDITY_END_DATE ) from ADM.ADM_MATRL_DETERMINATION_FACT
select min(VALID_FROM ),max( VALID_TO ) from ADM.ADM_M
select min), max( VALID_TO_DATE ) from ADM.ADM_MATRL_VEND_DIM
select min),max( VALID_TO_DATE ) from ADM.ADM_MATRL_VEND_TEMP
select min), max( VALIDITY_END_DATE ) from ADM.ADM_PRICE_WATERFALL_MAP_DIM
select min(BEGIN_DATE
),max( END_DATE ) from ADM.COMP_BASIC_PAY_FACT
select min(START_DATE ),max( END_DATE ) from ADM.CORP_H
select min(VENDOR_VALID_FROMVENDOR_VALID_TO_DATE ) from ADM.DTF_PUR3
select min(PRICING_VALID_FROM
PRICING_VALID_TO_DATE ) from ADM.DTF_PUR3
select min(DATE_MIN ), max( DATE_MAX ) from ADM.DW_VALIDATION_DENM_FACT
select min(DATE_MIN ), max( DATE_MAX ) from ADM.DW_VALIDATION_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_ADDRESS_HIST
select min(START_DATE ), max( END_DATE ) from ADM.HR_APPL_TESTING_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_APPLICATION_EVENT_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_APPLICATION_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_APPLICATION_VAC_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_CHILDREN_FACT
select min(START_DATE ), max( END_DATE ) from ADM.HR_CONFIDENTIAL
select min(START_DATE ), max( END_DATE ) from ADM.HR_CONTRACT_FACT
select min(VALID_FR),max( VALID_TO_DATE ) from ADM.HR_COST_CENTER
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_DISABILITY_INC_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_DISABILITY_PAYMENT_FACT
select min(START_DATE ), max( END_DATE ) from ADM.HR_EMP_NAME_HIST
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_INT_CONTROL_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_MISC_BENEFITS
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_PAYGRADE_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_POSITION
select min(EVENT_START_DATE ), max( EVENT_END_DATE ) from ADM.HR_REPORTS_TO_1
select min(EVENT_START_DATE ), max( EVENT_END_DATE ) from ADM.HR_REPORTS_TO_2
select min(EVENT_START
) from ADM.HR_REPORTS_TO_TEMP
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_SHIFT_FACT
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0002
select min(END_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0019
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0021
select min(END_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0028
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0032
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0040
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0077
select min(END_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0094
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PA0106
select min(BEGDA ), max( ENDDA ) from ADM.HR_TMP_PA0171
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PB0001
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_PB0077
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_TMP_POSITION
select min(BEGIN_DATE ), max( END_DATE ) from ADM.HR_UNION_FACT
select min(EVENT_ST), max( EVENT_END_DATE ) from ADM.HR_ZPPSH_HIST
select min(START_DATE ),max( END_DATE ) from ADM.JOB_EX
select min(DC_START_DATE ),max( DC_END_DATE ) from ADM.KCOR_DV20SULR_TBXT3
select min),max( DC_DATE_VALID_TO ) from ADM.KCOR_JD01B2BP_TBYC92_CSP_LIST_PRIC
select min(DC_BEG_DATE ),max( DC_END_DATE ) from ADM.KO
select min(), max( VALID_FROM_DATE ) from ADM.KOHL_HR_COST_CENTER
select min(START_DATE ),max( END_DATE ) from ADM.KOHL_HR_TMP_H
 ;
;
;
;
;
;
;
;
;
;
;
;
;

;
;
;

;
;
;

;
;
;
;

;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
 ;
;
;
;
;
;
;

ADER_FACT ;
max(Valid_To_Date ) from ADM.TEMP_KOHL_ADM_EQUIPMENT_TIME_SEGMENT_DIM ;
max(AEDAT ) from ADM.VBEP_VBAK
max(AEDAT ) from ADM.VEKP
max(AEDAT ) from ADM.VFKP
max(DP_SPRAY_DATE ) from ADM.VIS_TBVM22_SPRAY_FACT ;
) from ADM.VIS_TBVM24_NON_ ;
max(DP_INSPECT_DA) from ADM.VIS_TBVM27_INSPECTION_FA ;
max(DC_LAST_ACTIV) from ADM.VIS_TBVM32_POTT ;
max(DP_CULL_DATE ) from ADM.VIS_TBVN58_POTTE ;
max(DP_PASSED_SAP ) from ADM.VIS_TBVN60_POTTE ;
max(DP_PACK_DATE ) from ADM.VIS_TBVN60_POTTE ;
) from ADM.VIS_TBVN62_STOCK_CHG_FAC ;
max(DP_CAST_DATE ) from ADM.VIS_TBVN66_POTTE ;
max(DP_POTTERY_O) from ADM.VIS_TBVU13_AUTOCULL_FACT ;
max(ENDDA ) from ADM.VISIER_PA0000
max(ERDAT ) from ADM.ZLRF_PACK ;
RL_DETERMINATION_FACT
from ADM.ADM_MATRL_LEADTIME_FACT
L_VEND_DIM
_MATRL_VEND_TEMP
M_PRICE_WATERFALL_MAP_DIM
DM.COMP_BASIC_PAY_FACT
) from ADM.CORP_HR_CONFIDENTIAL
 3

W_VALIDATION_DENM_FACT
W_VALIDATION_FACT
R_ADDRESS_HIST
R_APPL_TESTING_FACT
R_APPLICATION_EVENT_FACT
R_APPLICATION_FACT
R_APPLICATION_VAC_FACT
R_CHILDREN_FACT
R_CONFIDENTIAL
R_CONTRACT_FACT
ADM.HR_COST_CENTER
R_DISABILITY_INC_FACT
R_DISABILITY_PAYMENT_FACT
R_EMP_NAME_HIST
R_INT_CONTROL_FACT
R_MISC_BENEFITS
R_PAYGRADE_FACT
R_POSITION
ADM.HR_REPORTS_TO_1
ADM.HR_REPORTS_TO_2

_SHIFT_FACT
_TMP_PA0002
R_TMP_PA0019
HR_TMP_PA0021
R_TMP_PA0028
_TMP_PA0032
_TMP_PA0040
_TMP_PA0077
R_TMP_PA0094
 HR_TMP_PA0106
MP_PA0171
.HR_TMP_PB0001
R_TMP_PB0077
R_TMP_POSITION
R_UNION_FACT
M.HR_ZPPSH_HIST
) from ADM.JOB_EXEC_STATUS
ADM.KCOR_DV20SULR_TBXT35_SUSER
D01B2BP_TBYC92_CSP_LIST_PRICE_FACT
) from ADM.KOHL_GI10RESI_DISTRIBUTOR
_HR_COST_CENTER
ADM.KOHL_HR_TMP_HRP1001
_SEGMENT_DIM ;
;
;
;

;
ADM.ADM_MATRL_COST_TEMP DATE_PRICE_CHANGED NULL NULL 0
ADM.ADM_MATRL_PLANT_DIM_TEST DT_OLDEST_ORDER NULL NULL 4428735
ADM.ADM_MATRL_SHORTAGE_TEMP DATE_CREATED NULL NULL 0
ADM.ADM_MATRL_VEND_TEMP VALID_TO_DATE NULL NULL 0
ADM.ADM_OCT_TEMP CHANGED_ON_DATE NULL NULL 5290
ADM.ADM_ORDER_CYCLE_TIME_FACT CHANGED_ON_DATE NULL NULL 21822191
ADM.ADM_REBATE_AGREEMENTS_TEMP DATE_CREATED NULL NULL 0
ADM.ADM_UNIT_SHIP_STG ACTIVITY_DATE NULL NULL 0
ADM.BRVIS_TBVM24 DP_CHANGED NULL NULL 0
ADM.BRVIS_TBVM27 DP_INSPECT NULL NULL 0
ADM.BRVIS_WHSE_VM22VM24_VW DP_SPRAY NULL NULL 0
ADM.BRVIS_WHSE_VN66VM24_VW DP_CAST NULL NULL 0
ADM.CORP_HR_EMP_AGREEMENT_DIM JOB_EFFECTIVE_DATE NULL NULL 52201
ADM.DPCPDSB3 DI_EXTRACT_TIME NULL NULL 0
ADM.HR_COST_CENTER VALID_FROM_DATE NULL NULL 0
ADM.HR_EMP_AGREEMENT_DIM JOB_EFFECTIVE_DATE NULL NULL 52201
ADM.HR_EMPLOYEE_DIM BIRTH_DATE NULL NULL 183485
ADM.HR_REPORTS_TO_TEMP EVENT_START_DATE NULL NULL 0
ADM.HR_TMP_PA0081 MIL_REG_DATE NULL NULL 0
ADM.JOB_EXEC_STATUS START_DATE NULL NULL 0
ADM.KMDW_MATERIALS SALES_STATUS_DATE NULL NULL 45583
ADM.KMDW_MATERIALS_TEMP SALES_STATUS_DATE NULL NULL 9339
ADM.KOHL_ADM_STATUS_DIM PCORP_STATUS NULL NULL 0
ADM.KOHL_HR_COST_CENTER VALID_FROM_DATE NULL NULL 0
ADM.KOVIS_TBVN62 DP_RECORD_STATUS NULL NULL 1686812
ADM.KOVIS_WHSE_VM22VM24_VW DP_SPRAY NULL NULL 0
ADM.KOVIS_WHSE_VN66VM24_VW DP_CAST NULL NULL 0
ADM.PRM_SAP_INTERFACE_TEMP FREIGHTPOITEMDELIVERYDATE NULL NULL 0
ADM.PRM_SHIPMENT_HDR_TEMP FACTORY_COMPLETION_DT NULL NULL 0
ADM.PUR_CFA_MARC_TEMP EFFECTIVE_DATE NULL NULL 0
ADM.QCORP_ADM_STATUS_DIM PCORP_STATUS NULL NULL 0
ADM.SNVIS_TBVM24 DP_CHANGED NULL NULL 0
ADM.SNVIS_WHSE_VM22VM24_VW DP_SPRAY NULL NULL 0
ADM.SNVIS_WHSE_VN66VM24_VW DP_CAST NULL NULL 0
ADM.SOVIS_TBVM32 DC_LAST_ACTIVITY NULL NULL 0
ADM.SOVIS_WHSE_VM22VM24_VW DP_SPRAY NULL NULL 0
ADM.SOVIS_WHSE_VN66VM24_VW DP_CAST NULL NULL 0
ADM.SPVIS_TBVN58 DP_PASSED_SAP NULL NULL 0
ADM.SPVIS_TBVN60 DP_PASSED_SAP NULL NULL 0
ADM.SPVIS_TBVN62 DP_RECORD_STATUS NULL NULL 4838180
ADM.SPVIS_WHSE_VM22VM24_VW DP_SPRAY NULL NULL 0
ADM.SPVIS_WHSE_VN66VM24_VW DP_CAST NULL NULL 0
ADM.TEMP_KOHL_ADM_EQUIPMENT_TIME_SEGMENT_DIM Valid_To_Date NULL NULL 0
ADM.VFKP AEDAT NULL NULL 1
ADM.VIS_TBVN66_POTTERY_CAST_FACT DP_CAST_DATE NULL NULL 0
ADM.ZLRF_PACK ERDAT NULL NULL 0
ORC SQL DIFF
STA48ZMS2 STA48XWRC #N/A
STA48ZMS3 STA48XWSH #N/A
TBVM22
TBVM24
TBVM25
TBVM26
TBVM27
TBVM28
TBVN58
TBVN60
TBVN62
TBVN66
select Spray.*,'T3' as plant, to_number(to_char(Spray.dp_Spray, 'YYYYMMDD')) as DateKey,to_number(to_char(Spray.dp_Spray, 'YYYY')) as
Year,to_number(to_char(Spray.dp_Spray, 'MM')) asasMonth
Select a.*, b.CP_CAST_TYPE as CP_CAST_TYPE,'T3' from TBVM22 Spray
plant,to_number(to_char(a.DP_POTTERY_OPRN, 'YYYY')) as
Year,to_number(to_char(a.DP_POTTERY_OPRN, 'MM')) as Month from TBVM24 a, TBVN66 b where a.np_serial = b.np_serial(+)
select Rework.*,'T3' as plant, to_number(to_char(Rework.dp_Rework, 'YYYYMMDD')) as DateKey, to_number(to_char(Rework.dp_Rework, 'YYYY'))
as Year,to_number(to_char(Rework.dp_Rework, 'MM')) as Month from TBVM25 Rework
select
select Kiln.*,'T3' as plant,0
Inspect.*,'T3' as to_number(to_char(Inspect.dp_Inspect,
as plant, DateKey,0 as Year,0 as Month from TBVM26 Kiln
'YYYYMMDD')) as DateKey, to_number(to_char(Inspect.dp_Inspect, 'YYYY')) as
Year,to_number(to_char(Inspect.dp_Inspect, 'MM')) as Month from TBVM27
select Defects.*,'T3' as plant, to_number(to_char(Defects.dp_Defect, 'YYYYMMDD')) Inspect as DateKey, to_number(to_char(Defects.dp_Defect, 'YYYY')) as
Year,to_number(to_char(Defects.dp_Defect, 'MM')) as Month
select Cull.*,'T3' as plant, to_number(to_char(Cull.dp_Cull, from TBVM28
'YYYYMMDD')) Defects to_number(to_char(Cull.dp_Cull, 'YYYY')) as
as DateKey,
Year,to_number(to_char(Cull.dp_Cull, 'MM')) as Month from TBVN58
select Pack.*,'T3' as plant, to_number(to_char(Pack.dp_Pack, Cull as DateKey, to_number(to_char(Pack.dp_Pack, 'YYYY')) as
'YYYYMMDD'))
Year,to_number(to_char(Pack.dp_Pack, 'MM')) as Month
to_number(to_char(StockChange.dp_stock_change, from
'YYYY')) as TBVN60 Pack
Year,to_number(to_char(StockChange.dp_stock_change, 'MM')) as Month from
TBVN62 StockChange
Year,to_number(to_char(cast.dp_cast, 'MM')) as Month from TBVN66 Cast where dp_cast >= TO_DATE('1900-01-01 00:00:00', 'YYYY-MM-DD
HH24:MI:SS')
Delete from TBVM22 Where Plant ='T3'
Delete from TBVM24 Where Plant ='T3'
Delete from TBVM25 Where Plant ='T3'
Delete from TBVM26 Where Plant ='T3'
Delete from TBVM27 Where Plant ='T3'
Delete from TBVM28 Where Plant ='T3'
Delete from TBVN58 Where Plant ='T3'
Delete from TBVN60 Where Plant ='T3'
Delete from TBVN62 Where Plant ='T3'
Delete from TBVN66 Where Plant ='T3'
 DateKey,to_number(to_char(Spray.dp_Spray, 'YYYY')) as Year,to_number(to_char(Spray.dp_Spray, 'MM')) as Month
TBVM22 from TBVM22 Spray
Year,to_number(to_char(a.DP_POTTERY_OPRN, 'MM')) as Month from TBVM24 a, TBVN66 b where a.np_serial =
TBVM24 b.np_serial(+)
to_number(to_char(Rework.dp_Rework, 'YYYY')) as Year,to_number(to_char(Rework.dp_Rework, 'MM')) as Month
TBVM25 from TBVM25 Rework
TBVM26 select Kiln.*,'T3' as plant,0 as DateKey,0 as
to_number(to_char(Inspect.dp_Inspect, Year,0asasYear,to_number(to_char(Inspect.dp_Inspect,
'YYYY')) Month from TBVM26 Kiln 'MM')) as Month
TBVM27 from TBVM27 Inspect
to_number(to_char(Defects.dp_Defect, 'YYYY')) as Year,to_number(to_char(Defects.dp_Defect, 'MM')) as Month
TBVM28 from
selectTBVM28 Defects as plant,to_number(to_char(Employee.DC_LAST_ACTIVITY, 'YYYY')) as
Employee.*,'T3'
TBVM29 Year,to_number(to_char(Employee.DC_LAST_ACTIVITY,
Year,to_number(to_char(PartNumber.DC_LAST_ACTIVITY, 'MM')) as as
'MM')) Month from
Month TBVM29
from Employee
TBVM32 PartNumber where
TBVM32 PartNumber.DP_OUT_EFFECT >= to_date('01/01/1944','dd/mm/yyyy') or PartNumber.dp_OUT_effect is null
TBVM35 select BarCode.*,'T3' as plant from'YYYY'))
to_number(to_char(Cull.dp_Cull, TBVM35 BarCode
as Year,to_number(to_char(Cull.dp_Cull, 'MM')) as Month from TBVN58
TBVN58 Cull
to_number(to_char(Pack.dp_Pack, 'YYYY')) as Year,to_number(to_char(Pack.dp_Pack, 'MM')) as Month from
TBVN60 TBVN60 Pack
Year,to_number(to_char(UnReconciled.DP_UNRCNCLD, 'MM')) as Month from TBVN61 UnReconciled where
TBVN61 dp_cast > to_date('01-JAN-1900','DD-MON-YY')
to_number(to_char(StockChange.dp_stock_change, 'YYYY')) as
TBVN62 Year,to_number(to_char(StockChange.dp_stock_change,
to_number(to_char(cast.dp_cast, 'MM')) as Month from TBVN62
'YYYY')) as Year,to_number(to_char(cast.dp_cast, StockChange
'MM')) as Month from TBVN66
TBVN66 Cast where dp_cast >= TO_DATE('1900-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
TBVO04 select PostingEvent.*,'T3' as plant from TBVO04 PostingEvent
TBVO05 select StockChange.*,'T3' as plant from TBVO05 StockChange
TBVO06 select ProductCode.*,'T3'as plant from TBVO06 ProductCode
TBXB99 select DefectCode.*,'T3' as plant from TBXB99 DefectCode
TBXC00 select ColorCode.*,'T3' as plant from TBXC00 ColorCode
TBYE13 select ProjectCode.*,'T3' as plant from TBYE13 ProjectCode
TBYE14 select ProjectDefect.*,'T3' as plant from TBYE14 ProjectDefect
TBYE17 select Material.*,'T3' as plant from TBYE17 Material
Delete from TBVM22 Where Plant ='T3'
Delete from TBVM24 Where Plant= 'T3'
Delete from TBVM25 Where Plant= 'T3'
Delete from TBVM26 Where Plant= 'T3'
Delete from TBVM27 Where Plant= 'T3'
Delete from TBVM28 Where Plant= 'T3'
Delete from TBVM29 Where Plant= 'T3'
Delete from TBVM32 Where Plant= 'T3'
Delete from TBVM35 Where Plant= 'T3'
Delete from TBVN58 Where Plant= 'T3'
Delete from TBVN60 Where Plant= 'T3'
Delete from TBVN61 Where Plant= 'T3'
Delete from TBVN62 Where Plant= 'T3'
Delete from TBVN66 Where Plant= 'T3'
Delete from TBVO04 Where Plant= 'T3'
Delete from TBVO05 Where Plant= 'T3'
Delete from TBVO06 Where Plant= 'T3'
Delete from TBXB99 Where Plant= 'T3'
Delete from TBXC00 Where Plant= 'T3'
Delete from TBYE13 Where Plant= 'T3'
Delete from TBYE14 Where Plant= 'T3'
Delete from TBYE17 Where Plant= 'T3'
TBVM29
TBVM35
TBVO04
TBVO05
TBVO06
TBXB99
TBXC00
TBYE13
TBYE14
TBYE17
select Employee.*,'T3' as plant,to_number(to_char(Employee.DC_LAST_ACTIVITY, 'YYYY')) as
Year,to_number(to_char(Employee.DC_LAST_ACTIVITY, 'MM')) as Month from TBVM29 Employee
select BarCode.*,'T3' as plant from TBVM35 BarCode
select PostingEvent.*,'T3' as plant from TBVO04 PostingEvent
select StockChange.*,'T3' as plant from TBVO05 StockChange
select ProductCode.*,'T3'as plant from TBVO06 ProductCode
select DefectCode.*,'T3' as plant from TBXB99 DefectCode
select ColorCode.*,'T3' as plant from TBXC00 ColorCode
select ProjectCode.*,'T3' as plant from TBYE13 ProjectCode
select ProjectDefect.*,'T3' as plant from TBYE14 ProjectDefect
select Material.*,'T3' as plant from TBYE17 Material
Delete from TBVM29 Where Plant= 'T3'
Delete from TBVM35 Where Plant= 'T3'
Delete from TBVO04 Where Plant= 'T3'
Delete from TBVO05 Where Plant= 'T3'
Delete from TBVO06 Where Plant= 'T3'
Delete from TBXB99 Where Plant= 'T3'
Delete from TBXC00 Where Plant= 'T3'
Delete from TBYE13 Where Plant= 'T3'
Delete from TBYE14 Where Plant= 'T3'
Delete from TBYE17 Where Plant= 'T3'
Oracle Querie
select NP_SERIAL,DP_CHANGED,'V3' as Plant from tbvm24 where dp_changed > trunc(sysdate-1) and dp_changed <=(SYSDATE)
SQL
delete from TEMP_V3_CDC_TBVM24 where plant = 'V3'
TBVM22
TBVM24
TBVM25
TBVM26
TBVM27
TBVM28
TBVN58
TBVN60
TBVN62
TBVN66
TBVN61
TBVM32
select Spray.*,'T3' as Plant,to_number(to_char(Spray.dp_Spray, 'YYYYMMDD')) as
DateKey,to_number(to_char(Spray.dp_Spray, 'YYYY')) as Year, to_number(to_char(Spray.dp_Spray, 'MM')) as Month from
TBVM22 Spray where DP_SPRAY > TO_DATE('2014-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') and Spray.NP_Serial in
(select NP_Serial from tbvm24
where DP_POTTERY_OPRN where DP_Changed >23:59:59',
> TO_DATE('2014-12-31 trunc(sysdate-1) and (DP_CHANGED)
'YYYY-MM-DD HH24:MI:SS')<=(SYSDATE))
and Cast.np_serial(+) =
BaseSerial.np_serial and BaseSerial.DP_CHANGED > trunc(sysdate-1) and (DP_CHANGED)
from TBVM25 Rework where DP_REWORK > TO_DATE('2014-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') and <=(SYSDATE)
Rework.NP_Serial in (select
23:59:59', 'YYYY-MM-DD NP_Serial from
HH24:MI:SS') tbvm24 whereinDP_Changed
and Kiln.NP_Serial > trunc(sysdate-1)
(select NP_Serial from tbvm24 and (DP_CHANGED)
where DP_Changed <=(SYSDATE))
>
trunc(sysdate-1) and (DP_CHANGED) <=(SYSDATE))
from TBVM27 Inspect where DP_INSPECT > TO_DATE('2014-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') and
Inspect.NP_Serial
TBVM28 Defects wherein (select NP_Serial> from
DP_DEFECT tbvm24 where DP_Changed
TO_DATE('2014-12-31 > trunc(sysdate-1)
23:59:59', 'YYYY-MM-DD and (DP_CHANGED)
HH24:MI:SS') <=(SYSDATE))
and Defects.NP_Serial in
(select NP_Serial from tbvm24 where DP_Changed > trunc(sysdate-1) and (DP_CHANGED) <=(SYSDATE))
23:59:59', 'YYYY-MM-DD HH24:MI:SS') and Cull.NP_Serial in (select NP_Serial from tbvm24 where DP_Changed >
trunc(sysdate-1) and (DP_CHANGED)
12-31 23:59:59', 'YYYY-MM-DD <=(SYSDATE))
HH24:MI:SS') and Pack.NP_Serial in (select NP_Serial from tbvm24 where DP_Changed >
trunc(sysdate-1) and (DP_CHANGED)
HH24:MI:SS') and StockChange.NP_Serial <=(SYSDATE))
in (select NP_Serial from tbvm24 where DP_Changed > trunc(sysdate-1) and
(DP_CHANGED)
12-31 23:59:59',<=(SYSDATE))
'YYYY-MM-DD HH24:MI:SS') and Cast.NP_Serial in (select NP_Serial from tbvm24 where DP_Changed >
trunc(sysdate-1) and (DP_CHANGED) <=(SYSDATE))
Year,to_number(to_char(UnReconciled.DP_UNRCNCLD, 'MM')) as Month from TBVN61 UnReconciled where dp_cast >
TO_DATE('2014-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS')
PartNumber.DP_OUT_EFFECT > TO_DATE('2014-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') or PartNumber.dp_OUT_effect
is null
delete From TBVM22 where TBVM22.NP_Serial in(Select
np_serial From
delete From CDC_TBVM24
TBVM24 where plant = 'T3')in(Select
where TBVM24.NP_Serial
np_serial From
delete From CDC_TBVM24
TBVM25 where plant = 'T3' in(Select
where TBVM25.NP_Serial )
np_serial From
delete From CDC_TBVM24
TBVM26 where plant = 'T3' in(Select
where TBVM26.NP_Serial )
np_serial From CDC_TBVM24 where plant = 'T3' )
delete From TBvm27 where TBVm27.NP_Serial in(Select
np_serial From
delete From CDC_TBVM24
TBVM28 where plant = 'T3' in(Select
where TBVM28.NP_Serial )
np_serial From
delete From CDC_TBVM24
TBVN58 where plant = 'T3'in(Select
where TBVN58.NP_Serial )
np_serial From
delete From CDC_TBVM24
TBVN60 where plant = 'T3'in(Select
where TBVN60.NP_Serial )
np_serial From CDC_TBVM24 where plant = 'T3' )
delete From TBVN62 where TBVN62.NP_Serial in(Select
np_serial From
delete From CDC_TBVM24
TBVN66 where plant = 'T3'in(Select
where TBVN66.NP_Serial )
np_serial From CDC_TBVM24 where plant = 'T3' )
Delete from TBVN61 Where Plant= 'T3'
Delete from TBVM32 Where Plant= 'T3'