daily_report

param_witel_kpro

Column Type Null Default Links to Comments Media type
witel varchar(13) Yes NULL
witel2 varchar(16) Yes NULL
reg varchar(3) Yes NULL
witel3 varchar(13) Yes NULL
c_witel varchar(7) Yes NULL

No index defined!

sras_p_witel

Column Type Null Default Links to Comments Media type
WITEL varchar(50) Yes NULL
C_WITEL bigint(20) Yes NULL
KAWASAN varchar(30) Yes NULL
KOTA varchar(30) Yes NULL
REGION bigint(20) Yes NULL
CRO varchar(30) Yes NULL
REG_NEW bigint(20) Yes NULL
WITEL_CLASS varchar(20) Yes NULL
KAWASAN_OLD varchar(100) Yes NULL
WITEL_OLD varchar(100) Yes NULL
WITEL_OLD_ABRV varchar(100) Yes NULL
WITEL_FBCC1 varchar(100) Yes NULL
WITEL_DWH varchar(100) Yes NULL
WITEL_DEPLOYER varchar(100) Yes NULL
WITEL_SC varchar(100) Yes NULL
WITEL2 varchar(12) Yes NULL
KELAS varchar(5) Yes NULL

No index defined!

tmo_v_ihgamers

Column Type Null Default Links to Comments Media type
PERIODE varchar(200) Yes NULL
JENIS varchar(2) Yes NULL
C_WITEL bigint(20) Yes NULL
PS decimal(38,0) Yes NULL
CBT decimal(38,0) Yes NULL

No index defined!

tmp_addon_indibox_nz

Column Type Null Default Links to Comments Media type
REG varchar(30) Yes NULL
WITELS varchar(50) Yes NULL
KELAS varchar(5) Yes NULL
C_WITEL bigint(20) Yes NULL
PSHI decimal(38,0) Yes NULL
PSBI decimal(38,0) Yes NULL
PSYTD decimal(38,0) Yes NULL
LIS decimal(38,0) Yes NULL

No index defined!

tmp_addon_nz

Column Type Null Default Links to Comments Media type
REG varchar(30) Yes NULL
WITELS varchar(50) Yes NULL
KELAS varchar(5) Yes NULL
ADDON varchar(32) Yes NULL
PSHI decimal(38,0) Yes NULL
PSBI decimal(38,0) Yes NULL
PSYTD decimal(38,0) Yes NULL

No index defined!

tmp_ih_byod_report22

Column Type Null Default Links to Comments Media type
C_WITEL varchar(4) Yes NULL
CHANEL varchar(128) Yes NULL
CCAT varchar(4) Yes NULL
PERIODE_PS varchar(200) Yes NULL
JML bigint(20) Yes NULL

No index defined!

tmp_new_lis_paketguru_data

Column Type Null Default Links to Comments Media type
KAWASAN varchar(30) Yes NULL
WITEL varchar(128) Yes NULL
JML_LIS bigint(20) Yes NULL

No index defined!

tmp_new_report_3p_data

Column Type Null Default Links to Comments Media type
STATUS varchar(10) Yes NULL
STATUS_DEMAND varchar(128) Yes NULL
CPACK varchar(10) Yes NULL
CITEM_SPEEDY varchar(30) Yes NULL
TGL varchar(200) Yes NULL
C_WITEL bigint(20) Yes NULL
JENIS varchar(2) Yes NULL
NEWSALES decimal(38,0) Yes NULL
MIGRASI decimal(38,0) Yes NULL
UPDOWN decimal(38,0) Yes NULL

No index defined!

tmp_new_report_paketguru_data

Column Type Null Default Links to Comments Media type
STATUS varchar(10) Yes NULL
STATUS_DEMAND varchar(128) Yes NULL
CPACK varchar(10) Yes NULL
CITEM_SPEEDY varchar(30) Yes NULL
TGL varchar(200) Yes NULL
C_WITEL bigint(20) Yes NULL
JENIS varchar(2) Yes NULL
FLAG_P varchar(9) Yes NULL
NEWSALES decimal(38,0) Yes NULL
MIGRASI decimal(38,0) Yes NULL
UPDOWN decimal(38,0) Yes NULL

No index defined!

tmp_new_report_paketjitu

Column Type Null Default Links to Comments Media type
C_WITEL bigint(20) Yes NULL
CHANNEL varchar(30) Yes NULL
NEW_CHANNEL varchar(50) Yes NULL
PERIODE_PS varchar(200) Yes NULL
JML bigint(20) Yes NULL

No index defined!

tmp_typedeposit_ps

Column Type Null Default Links to Comments Media type
PERIODE_PS varchar(8) Yes NULL
REGIONAL varchar(2) Yes NULL
WITEL varchar(40) Yes NULL
STO varchar(20) Yes NULL
STATUS_RESUME varchar(50) Yes NULL
FLAG_DEPOSIT varchar(5) Yes NULL
JML double Yes NULL

No index defined!

tmp_v_broadband_cham

Column Type Null Default Links to Comments Media type
STATUS varchar(10) Yes NULL
STATUS_DEMAND varchar(128) Yes NULL
CPACK varchar(10) Yes NULL
CITEM_SPEEDY varchar(30) Yes NULL
CITEM_UPD varchar(10) Yes NULL
TGL varchar(200) Yes NULL
KELAS varchar(5) Yes NULL
KAWASAN varchar(30) Yes NULL
WITEL varchar(50) Yes NULL
JML decimal(38,0) Yes NULL

No index defined!

tmp_v_deluxe_premium

Column Type Null Default Links to Comments Media type
C_WITEL bigint(20) Yes NULL
DESC_PACK varchar(150) Yes NULL
PERIODE varchar(200) Yes NULL
ALL_PREMDEL decimal(38,0) Yes NULL
J_3PD_P_BLNINI decimal(38,0) Yes NULL

No index defined!

tmp_v_growth_sales_radir_data

Column Type Null Default Links to Comments Media type
TGL varchar(200) Yes NULL
C_WITEL bigint(20) Yes NULL
JML bigint(20) Yes NULL

No index defined!

tmp_v_lis_2p_lis

Column Type Null Default Links to Comments Media type
KAWASAN varchar(30) Yes NULL
WITEL varchar(50) Yes NULL
C_WITEL bigint(20) Yes NULL
CPACK varchar(10) Yes NULL
CITEM_SPEEDY varchar(30) Yes NULL
CITEM_UPD varchar(10) Yes NULL
PERIODE varchar(200) Yes NULL
STATUS_DEMAND varchar(30) Yes NULL
JENIS varchar(2) Yes NULL
PSBLN decimal(38,0) Yes NULL
CHURN decimal(38,0) Yes NULL
UPDOWN_DOWNSELLING decimal(38,0) Yes NULL
MIGRASI decimal(38,0) Yes NULL

No index defined!

tmp_v_lis_indihome_3p_new2

Column Type Null Default Links to Comments Media type
CWITEL double Yes NULL
PERIODE varchar(200) Yes NULL
MTD varchar(200) Yes NULL
SALES decimal(38,0) Yes NULL
SALES_FTTH decimal(38,0) Yes NULL
CHURN bigint(20) Yes NULL
CHURN_FTTH decimal(38,0) Yes NULL
LIS decimal(38,0) Yes NULL
FTTH decimal(38,0) Yes NULL

No index defined!

tmp_v_lis_netizen

Column Type Null Default Links to Comments Media type
CWITEL bigint(20) Yes NULL
PERIODE varchar(200) Yes NULL
MTD varchar(200) Yes NULL
SALES decimal(38,0) Yes NULL
SALES_FTTH decimal(38,0) Yes NULL
CHURN decimal(38,0) Yes NULL
CHURN_FTTH decimal(38,0) Yes NULL
LIS decimal(38,0) Yes NULL
FTTH decimal(38,0) Yes NULL

No index defined!

tmp_v_new_pt2_report

Column Type Null Default Links to Comments Media type
REGIONAL varchar(3) Yes NULL
WITEL varchar(30) Yes NULL
INPORDER double Yes NULL
PS double Yes NULL
GLIVE double Yes NULL
ALSOURCE double Yes NULL
INVEN double Yes NULL
CONSTRUC double Yes NULL
SURV double Yes NULL
PT1TOT double Yes NULL
UNSCS double Yes NULL
TOTODPINP double Yes NULL
TOTAL double Yes NULL

No index defined!

tmp_v_prov_ihsmart

Column Type Null Default Links to Comments Media type
C_WITEL double Yes NULL
JENIS varchar(7) Yes NULL
JML double Yes NULL

No index defined!

tmp_v_prov_indibox

Column Type Null Default Links to Comments Media type
C_WITEL double Yes NULL
JENIS varchar(7) Yes NULL
JML double Yes NULL

No index defined!

tmp_v_prov_pdd

Column Type Null Default Links to Comments Media type
REGIONAL varchar(2) Yes NULL
WITEL varchar(40) Yes NULL
ORDER_DATE varchar(8) Yes NULL
TGL_PS varchar(8) Yes NULL
PROVIDER varchar(40) Yes NULL
CATEGORY varchar(150) Yes NULL
STATUS_RESUME varchar(40) Yes NULL
CHANNEL varchar(200) Yes NULL
FLAG_DATA varchar(10) Yes NULL
JML double Yes NULL

No index defined!

tmp_v_report_growth_sales

Column Type Null Default Links to Comments Media type
TGL varchar(200) Yes NULL
C_WITEL bigint(20) Yes NULL
SALES decimal(38,0) Yes NULL
UPDOWN decimal(38,0) Yes NULL
SALES_MIG decimal(38,0) Yes NULL

No index defined!

tmp_v_sales_digital

Column Type Null Default Links to Comments Media type
CGEST varchar(2) Yes NULL
TGL varchar(200) Yes NULL
CHANEL varchar(32) Yes NULL
CPACK varchar(10) Yes NULL
CITEM_SPEEDY varchar(30) Yes NULL
KAWASAN varchar(30) Yes NULL
WITEL varchar(50) Yes NULL
PP_CHANEL varchar(30) Yes NULL
NEW_CHANEL varchar(50) Yes NULL
SALES decimal(38,0) Yes NULL
UPDOWN decimal(38,0) Yes NULL
SALES_MIG decimal(38,0) Yes NULL

No index defined!

tmp_v_status_sc_indibox

Column Type Null Default Links to Comments Media type
REG varchar(30) Yes NULL
WITELS varchar(50) Yes NULL
KELAS varchar(5) Yes NULL
RE decimal(38,0) Yes NULL
VA decimal(38,0) Yes NULL
PI decimal(38,0) Yes NULL
PS decimal(38,0) Yes NULL

No index defined!

v_lis_2p_ms2n

Column Type Null Default Links to Comments Media type
C_WITEL bigint(20) Yes NULL
MTD varchar(200) Yes NULL
PERIODE varchar(200) Yes NULL
JML bigint(20) Yes NULL

No index defined!