DROP TABLE MID.MID_D_IMP_BALANCE_TTYD;
COMMIT;
CREATE TABLE MID.MID_D_IMP_BALANCE_TTYD
(
ACCT_MONTH VARCHAR(6),
PARTITION_ID VARCHAR(2),
PROD_ID VARCHAR(20),
START_TIME VARCHAR(14),
RATE_TIME VARCHAR(14),
OPERATION_TYPE_ID VARCHAR(16),
CALLING_NUMBER VARCHAR(20),
CALLED_NUMBER VARCHAR(20),
CALLING_AREA_ID VARCHAR(10),
CALLED_AREA_ID VARCHAR(10),
IN_TRUNK_NUMBER VARCHAR(8),
OUT_TRUNK_NUMBER VARCHAR(8),
RAW_UNIT_TYPE INTEGER,
RAW_UNITS VARCHAR(12),
RATE_UNIT_TYPE VARCHAR(2),
IS_FREE VARCHAR(6),
RATE_UNITS INTEGER,
CALLING_AREA_CODE VARCHAR(10),
CALLED_AREA_CODE VARCHAR(10),
TOTAL_DUE_AMOUNT DECIMAL(12,2),
RATE_ID VARCHAR(10),
DURATION INTEGER,
CITY_ID VARCHAR(10),
FILE_NAME VARCHAR(128),
STATUS VARCHAR(12),
RATE_KEY3 VARCHAR(12),
DIRECTION VARCHAR(10),
FILE_CLASS_ID VARCHAR(32),
TOTAL_DUE_UNITS INTEGER,
TABLE_NAME VARCHAR(128),
PROVINCE_ID VARCHAR(12),
DURATION_SEC6 INTEGER,
IN_TRUNK_GROUP VARCHAR(16),
OUT_TRUNK_GROUP VARCHAR(16),
CALLING_GROUP_ID VARCHAR(16),
CALLED_GROUP_ID VARCHAR(16)
) COMPRESS YES
PARTITION BY RANGE(PARTITION_ID,CITY_ID)
(PART PART01_810 STARTING('01','810') ENDING('01','811') EXCLUSIVE IN MID_DAY_PER,
PART PART01_811 STARTING('01','811') ENDING('01','812') EXCLUSIVE IN MID_DAY_PER,
PART PART01_812 STARTING('01','812') ENDING('01','813') EXCLUSIVE IN MID_DAY_PER,
PART PART01_813 STARTING('01','813') ENDING('01','814') EXCLUSIVE IN MID_DAY_PER,
PART PART01_814 STARTING('01','814') ENDING('01','815') EXCLUSIVE IN MID_DAY_PER,
PART PART01_815 STARTING('01','815') ENDING('01','816') EXCLUSIVE IN MID_DAY_PER,
PART PART01_816 STARTING('01','816') ENDING('01','817') EXCLUSIVE IN MID_DAY_PER,
PART PART01_817 STARTING('01','817') ENDING('01','818') EXCLUSIVE IN MID_DAY_PER,
PART PART01_818 STARTING('01','818') ENDING('01','819') EXCLUSIVE IN MID_DAY_PER,
PART PART01_819 STARTING('01','819') ENDING('01','820') EXCLUSIVE IN MID_DAY_PER,
PART PART01_820 STARTING('01','820') ENDING('01','821') EXCLUSIVE IN MID_DAY_PER,
PART PART01_821 STARTING('01','821') ENDING('01','822') EXCLUSIVE IN MID_DAY_PER,
PART PART01_822 STARTING('01','822') ENDING('01','823') EXCLUSIVE IN MID_DAY_PER,
PART PART01_823 STARTING('01','823') ENDING('01','824') EXCLUSIVE IN MID_DAY_PER,
PART PART01_824 STARTING('01','824') ENDING('01','825') EXCLUSIVE IN MID_DAY_PER,
PART PART01_825 STARTING('01','825') ENDING('01','826') EXCLUSIVE IN MID_DAY_PER,
PART PART01_826 STARTING('01','826') ENDING('01','827') EXCLUSIVE IN MID_DAY_PER,
PART PART01_827 STARTING('01','827') ENDING('01','828') EXCLUSIVE IN MID_DAY_PER,
PART PART01_828 STARTING('01','828') ENDING('01','829') EXCLUSIVE IN MID_DAY_PER,
PART PART01_829 STARTING('01','829') ENDING('01','830') EXCLUSIVE IN MID_DAY_PER,
PART PART01_830 STARTING('01','830') ENDING('01','831') EXCLUSIVE IN MID_DAY_PER,
PART PART02_810 STARTING('02','810') ENDING('02','811') EXCLUSIVE IN MID_DAY_PER,
PART PART02_811 STARTING('02','811') ENDING('02','812') EXCLUSIVE IN MID_DAY_PER,
PART PART02_812 STARTING('02','812') ENDING('02','813') EXCLUSIVE IN MID_DAY_PER,
PART PART02_813 STARTING('02','813') ENDING('02','814') EXCLUSIVE IN MID_DAY_PER,
PART PART02_814 STARTING('02','814') ENDING('02','815') EXCLUSIVE IN MID_DAY_PER,
PART PART02_815 STARTING('02','815') ENDING('02','816') EXCLUSIVE IN MID_DAY_PER,
PART PART02_816 STARTING('02','816') ENDING('02','817') EXCLUSIVE IN MID_DAY_PER,
PART PART02_817 STARTING('02','817') ENDING('02','818') EXCLUSIVE IN MID_DAY_PER,
PART PART02_818 STARTING('02','818') ENDING('02','819') EXCLUSIVE IN MID_DAY_PER,
PART PART02_819 STARTING('02','819') ENDING('02','820') EXCLUSIVE IN MID_DAY_PER,
PART PART02_820 STARTING('02','820') ENDING('02','821') EXCLUSIVE IN MID_DAY_PER,
PART PART02_821 STARTING('02','821') ENDING('02','822') EXCLUSIVE IN MID_DAY_PER,
PART PART02_822 STARTING('02','822') ENDING('02','823') EXCLUSIVE IN MID_DAY_PER,
PART PART02_823 STARTING('02','823') ENDING('02','824') EXCLUSIVE IN MID_DAY_PER,
PART PART02_824 STARTING('02','824') ENDING('02','825') EXCLUSIVE IN MID_DAY_PER,
PART PART02_825 STARTING('02','825') ENDING('02','826') EXCLUSIVE IN MID_DAY_PER,
PART PART02_826 STARTING('02','826') ENDING('02','827') EXCLUSIVE IN MID_DAY_PER,
PART PART02_827 STARTING('02','827') ENDING('02','828') EXCLUSIVE IN MID_DAY_PER,
PART PART02_828 STARTING('02','828') ENDING('02','829') EXCLUSIVE IN MID_DAY_PER,
PART PART02_829 STARTING('02','829') ENDING('02','830') EXCLUSIVE IN MID_DAY_PER,
PART PART02_830 STARTING('02','830') ENDING('02','831') EXCLUSIVE IN MID_DAY_PER,
PART PART03_810 STARTING('03','810') ENDING('03','811') EXCLUSIVE IN MID_DAY_PER,
PART PART03_811 STARTING('03','811') ENDING('03','812') EXCLUSIVE IN MID_DAY_PER,
PART PART03_812 STARTING('03','812') ENDING('03','813') EXCLUSIVE IN MID_DAY_PER,
PART PART03_813 STARTING('03','813') ENDING('03','814') EXCLUSIVE IN MID_DAY_PER,
PART PART03_814 STARTING('03','814') ENDING('03','815') EXCLUSIVE IN MID_DAY_PER,
PART PART03_815 STARTING('03','815') ENDING('03','816') EXCLUSIVE IN MID_DAY_PER,
PART PART03_816 STARTING('03','816') ENDING('03','817') EXCLUSIVE IN MID_DAY_PER,
PART PART03_817 STARTING('03','817') ENDING('03','818') EXCLUSIVE IN MID_DAY_PER,
PART PART03_818 STARTING('03','818') ENDING('03','819') EXCLUSIVE IN MID_DAY_PER,
PART PART03_819 STARTING('03','819') ENDING('03','820') EXCLUSIVE IN MID_DAY_PER,
PART PART03_820 STARTING('03','820') ENDING('03','821') EXCLUSIVE IN MID_DAY_PER,
PART PART03_821 STARTING('03','821') ENDING('03','822') EXCLUSIVE IN MID_DAY_PER,
PART PART03_822 STARTING('03','822') ENDING('03','823') EXCLUSIVE IN MID_DAY_PER,
PART PART03_823 STARTING('03','823') ENDING('03','824') EXCLUSIVE IN MID_DAY_PER,
PART PART03_824 STARTING('03','824') ENDING('03','825') EXCLUSIVE IN MID_DAY_PER,
PART PART03_825 STARTING('03','825') ENDING('03','826') EXCLUSIVE IN MID_DAY_PER,
PART PART03_826 STARTING('03','826') ENDING('03','827') EXCLUSIVE IN MID_DAY_PER,
PART PART03_827 STARTING('03','827') ENDING('03','828') EXCLUSIVE IN MID_DAY_PER,
PART PART03_828 STARTING('03','828') ENDING('03','829') EXCLUSIVE IN MID_DAY_PER,
PART PART03_829 STARTING('03','829') ENDING('03','830') EXCLUSIVE IN MID_DAY_PER,
PART PART03_830 STARTING('03','830') ENDING('03','831') EXCLUSIVE IN MID_DAY_PER,
PART PART04_810 STARTING('04','810') ENDING('04','811') EXCLUSIVE IN MID_DAY_PER,
PART PART04_811 STARTING('04','811') ENDING('04','812') EXCLUSIVE IN MID_DAY_PER,
PART PART04_812 STARTING('04','812') ENDING('04','813') EXCLUSIVE IN MID_DAY_PER,
PART PART04_813 STARTING('04','813') ENDING('04','814') EXCLUSIVE IN MID_DAY_PER,
PART PART04_814 STARTING('04','814') ENDING('04','815') EXCLUSIVE IN MID_DAY_PER,
PART PART04_815 STARTING('04','815') ENDING('04','816') EXCLUSIVE IN MID_DAY_PER,
PART PART04_816 STARTING('04','816') ENDING('04','817') EXCLUSIVE IN MID_DAY_PER,
PART PART04_817 STARTING('04','817') ENDING('04','818') EXCLUSIVE IN MID_DAY_PER,
PART PART04_818 STARTING('04','818') ENDING('04','819') EXCLUSIVE IN MID_DAY_PER,
PART PART04_819 STARTING('04','819') ENDING('04','820') EXCLUSIVE IN MID_DAY_PER,
PART PART04_820 STARTING('04','820') ENDING('04','821') EXCLUSIVE IN MID_DAY_PER,
PART PART04_821 STARTING('04','821') ENDING('04','822') EXCLUSIVE IN MID_DAY_PER,
PART PART04_822 STARTING('04','822') ENDING('04','823') EXCLUSIVE IN MID_DAY_PER,
PART PART04_823 STARTING('04','823') ENDING('04','824') EXCLUSIVE IN MID_DAY_PER,
PART PART04_824 STARTING('04','824') ENDING('04','825') EXCLUSIVE IN MID_DAY_PER,
PART PART04_825 STARTING('04','825') ENDING('04','826') EXCLUSIVE IN MID_DAY_PER,
PART PART04_826 STARTING('04','826') ENDING('04','827') EXCLUSIVE IN MID_DAY_PER,
PART PART04_827 STARTING('04','827') ENDING('04','828') EXCLUSIVE IN MID_DAY_PER,
PART PART04_828 STARTING('04','828') ENDING('04','829') EXCLUSIVE IN MID_DAY_PER,
PART PART04_829 STARTING('04','829') ENDING('04','830') EXCLUSIVE IN MID_DAY_PER,
PART PART04_830 STARTING('04','830') ENDING('04','831') EXCLUSIVE IN MID_DAY_PER,
PART PART05_810 STARTING('05','810') ENDING('05','811') EXCLUSIVE IN MID_DAY_PER,
PART PART05_811 STARTING('05','811') ENDING('05','812') EXCLUSIVE IN MID_DAY_PER,
PART PART05_812 STARTING('05','812') ENDING('05','813') EXCLUSIVE IN MID_DAY_PER,
PART PART05_813 STARTING('05','813') ENDING('05','814') EXCLUSIVE IN MID_DAY_PER,
PART PART05_814 STARTING('05','814') ENDING('05','815') EXCLUSIVE IN MID_DAY_PER,
PART PART05_815 STARTING('05','815') ENDING('05','816') EXCLUSIVE IN MID_DAY_PER,
PART PART05_816 STARTING('05','816') ENDING('05','817') EXCLUSIVE IN MID_DAY_PER,
PART PART05_817 STARTING('05','817') ENDING('05','818') EXCLUSIVE IN MID_DAY_PER,
PART PART05_818 STARTING('05','818') ENDING('05','819') EXCLUSIVE IN MID_DAY_PER,
PART PART05_819 STARTING('05','819') ENDING('05','820') EXCLUSIVE IN MID_DAY_PER,
PART PART05_820 STARTING('05','820') ENDING('05','821') EXCLUSIVE IN MID_DAY_PER,
PART PART05_821 STARTING('05','821') ENDING('05','822') EXCLUSIVE IN MID_DAY_PER,
PART PART05_822 STARTING('05','822') ENDING('05','823') EXCLUSIVE IN MID_DAY_PER,
PART PART05_823 STARTING('05','823') ENDING('05','824') EXCLUSIVE IN MID_DAY_PER,
PART PART05_824 STARTING('05','824') ENDING('05','825') EXCLUSIVE IN MID_DAY_PER,
PART PART05_825 STARTING('05','825') ENDING('05','826') EXCLUSIVE IN MID_DAY_PER,
PART PART05_826 STARTING('05','826') ENDING('05','827') EXCLUSIVE IN MID_DAY_PER,
PART PART05_827 STARTING('05','827') ENDING('05','828') EXCLUSIVE IN MID_DAY_PER,
PART PART05_828 STARTING('05','828') ENDING('05','829') EXCLUSIVE IN MID_DAY_PER,
PART PART05_829 STARTING('05','829') ENDING('05','830') EXCLUSIVE IN MID_DAY_PER,
PART PART05_830 STARTING('05','830') ENDING('05','831') EXCLUSIVE IN MID_DAY_PER,
PART PART06_810 STARTING('06','810') ENDING('06','811') EXCLUSIVE IN MID_DAY_PER,
PART PART06_811 STARTING('06','811') ENDING('06','812') EXCLUSIVE IN MID_DAY_PER,
PART PART06_812 STARTING('06','812') ENDING('06','813') EXCLUSIVE IN MID_DAY_PER,
PART PART06_813 STARTING('06','813') ENDING('06','814') EXCLUSIVE IN MID_DAY_PER,
PART PART06_814 STARTING('06','814') ENDING('06','815') EXCLUSIVE IN MID_DAY_PER,
PART PART06_815 STARTING('06','815') ENDING('06','816') EXCLUSIVE IN MID_DAY_PER,
PART PART06_816 STARTING('06','816') ENDING('06','817') EXCLUSIVE IN MID_DAY_PER,
PART PART06_817 STARTING('06','817') ENDING('06','818') EXCLUSIVE IN MID_DAY_PER,
PART PART06_818 STARTING('06','818') ENDING('06','819') EXCLUSIVE IN MID_DAY_PER,
PART PART06_819 STARTING('06','819') ENDING('06','820') EXCLUSIVE IN MID_DAY_PER,
PART PART06_820 STARTING('06','820') ENDING('06','821') EXCLUSIVE IN MID_DAY_PER,
PART PART06_821 STARTING('06','821') ENDING('06','822') EXCLUSIVE IN MID_DAY_PER,
PART PART06_822 STARTING('06','822') ENDING('06','823') EXCLUSIVE IN MID_DAY_PER,
PART PART06_823 STARTING('06','823') ENDING('06','824') EXCLUSIVE IN MID_DAY_PER,
PART PART06_824 STARTING('06','824') ENDING('06','825') EXCLUSIVE IN MID_DAY_PER,
PART PART06_825 STARTING('06','825') ENDING('06','826') EXCLUSIVE IN MID_DAY_PER,
PART PART06_826 STARTING('06','826') ENDING('06','827') EXCLUSIVE IN MID_DAY_PER,
PART PART06_827 STARTING('06','827') ENDING('06','828') EXCLUSIVE IN MID_DAY_PER,
PART PART06_828 STARTING('06','828') ENDING('06','829') EXCLUSIVE IN MID_DAY_PER,
PART PART06_829 STARTING('06','829') ENDING('06','830') EXCLUSIVE IN MID_DAY_PER,
PART PART06_830 STARTING('06','830') ENDING('06','831') EXCLUSIVE IN MID_DAY_PER,
PART PART07_810 STARTING('07','810') ENDING('07','811') EXCLUSIVE IN MID_DAY_PER,
PART PART07_811 STARTING('07','811') ENDING('07','812') EXCLUSIVE IN MID_DAY_PER,
PART PART07_812 STARTING('07','812') ENDING('07','813') EXCLUSIVE IN MID_DAY_PER,
PART PART07_813 STARTING('07','813') ENDING('07','814') EXCLUSIVE IN MID_DAY_PER,
PART PART07_814 STARTING('07','814') ENDING('07','815') EXCLUSIVE IN MID_DAY_PER,
PART PART07_815 STARTING('07','815') ENDING('07','816') EXCLUSIVE IN MID_DAY_PER,
PART PART07_816 STARTING('07','816') ENDING('07','817') EXCLUSIVE IN MID_DAY_PER,
PART PART07_817 STARTING('07','817') ENDING('07','818') EXCLUSIVE IN MID_DAY_PER,
PART PART07_818 STARTING('07','818') ENDING('07','819') EXCLUSIVE IN MID_DAY_PER,
PART PART07_819 STARTING('07','819') ENDING('07','820') EXCLUSIVE IN MID_DAY_PER,
PART PART07_820 STARTING('07','820') ENDING('07','821') EXCLUSIVE IN MID_DAY_PER,
PART PART07_821 STARTING('07','821') ENDING('07','822') EXCLUSIVE IN MID_DAY_PER,
PART PART07_822 STARTING('07','822') ENDING('07','823') EXCLUSIVE IN MID_DAY_PER,
PART PART07_823 STARTING('07','823') ENDING('07','824') EXCLUSIVE IN MID_DAY_PER,
PART PART07_824 STARTING('07','824') ENDING('07','825') EXCLUSIVE IN MID_DAY_PER,
PART PART07_825 STARTING('07','825') ENDING('07','826') EXCLUSIVE IN MID_DAY_PER,
PART PART07_826 STARTING('07','826') ENDING('07','827') EXCLUSIVE IN MID_DAY_PER,
PART PART07_827 STARTING('07','827') ENDING('07','828') EXCLUSIVE IN MID_DAY_PER,
PART PART07_828 STARTING('07','828') ENDING('07','829') EXCLUSIVE IN MID_DAY_PER,
PART PART07_829 STARTING('07','829') ENDING('07','830') EXCLUSIVE IN MID_DAY_PER,
PART PART07_830 STARTING('07','830') ENDING('07','831') EXCLUSIVE IN MID_DAY_PER,
PART PART08_810 STARTING('08','810') ENDING('08','811') EXCLUSIVE IN MID_DAY_PER,
PART PART08_811 STARTING('08','811') ENDING('08','812') EXCLUSIVE IN MID_DAY_PER,
PART PART08_812 STARTING('08','812') ENDING('08','813') EXCLUSIVE IN MID_DAY_PER,
PART PART08_813 STARTING('08','813') ENDING('08','814') EXCLUSIVE IN MID_DAY_PER,
PART PART08_814 STARTING('08','814') ENDING('08','815') EXCLUSIVE IN MID_DAY_PER,
PART PART08_815 STARTING('08','815') ENDING('08','816') EXCLUSIVE IN MID_DAY_PER,
PART PART08_816 STARTING('08','816') ENDING('08','817') EXCLUSIVE IN MID_DAY_PER,
PART PART08_817 STARTING('08','817') ENDING('08','818') EXCLUSIVE IN MID_DAY_PER,
PART PART08_818 STARTING('08','818') ENDING('08','819') EXCLUSIVE IN MID_DAY_PER,
PART PART08_819 STARTING('08','819') ENDING('08','820') EXCLUSIVE IN MID_DAY_PER,
PART PART08_820 STARTING('08','820') ENDING('08','821') EXCLUSIVE IN MID_DAY_PER,
PART PART08_821 STARTING('08','821') ENDING('08','822') EXCLUSIVE IN MID_DAY_PER,
PART PART08_822 STARTING('08','822') ENDING('08','823') EXCLUSIVE IN MID_DAY_PER,
PART PART08_823 STARTING('08','823') ENDING('08','824') EXCLUSIVE IN MID_DAY_PER,
PART PART08_824 STARTING('08','824') ENDING('08','825') EXCLUSIVE IN MID_DAY_PER,
PART PART08_825 STARTING('08','825') ENDING('08','826') EXCLUSIVE IN MID_DAY_PER,
PART PART08_826 STARTING('08','826') ENDING('08','827') EXCLUSIVE IN MID_DAY_PER,
PART PART08_827 STARTING('08','827') ENDING('08','828') EXCLUSIVE IN MID_DAY_PER,
PART PART08_828 STARTING('08','828') ENDING('08','829') EXCLUSIVE IN MID_DAY_PER,
PART PART08_829 STARTING('08','829') ENDING('08','830') EXCLUSIVE IN MID_DAY_PER,
PART PART08_830 STARTING('08','830') ENDING('08','831') EXCLUSIVE IN MID_DAY_PER,
PART PART09_810 STARTING('09','810') ENDING('09','811') EXCLUSIVE IN MID_DAY_PER,
PART PART09_811 STARTING('09','811') ENDING('09','812') EXCLUSIVE IN MID_DAY_PER,
PART PART09_812 STARTING('09','812') ENDING('09','813') EXCLUSIVE IN MID_DAY_PER,
PART PART09_813 STARTING('09','813') ENDING('09','814') EXCLUSIVE IN MID_DAY_PER,
PART PART09_814 STARTING('09','814') ENDING('09','815') EXCLUSIVE IN MID_DAY_PER,
PART PART09_815 STARTING('09','815') ENDING('09','816') EXCLUSIVE IN MID_DAY_PER,
PART PART09_816 STARTING('09','816') ENDING('09','817') EXCLUSIVE IN MID_DAY_PER,
PART PART09_817 STARTING('09','817') ENDING('09','818') EXCLUSIVE IN MID_DAY_PER,
PART PART09_818 STARTING('09','818') ENDING('09','819') EXCLUSIVE IN MID_DAY_PER,
PART PART09_819 STARTING('09','819') ENDING('09','820') EXCLUSIVE IN MID_DAY_PER,
PART PART09_820 STARTING('09','820') ENDING('09','821') EXCLUSIVE IN MID_DAY_PER,
PART PART09_821 STARTING('09','821') ENDING('09','822') EXCLUSIVE IN MID_DAY_PER,
PART PART09_822 STARTING('09','822') ENDING('09','823') EXCLUSIVE IN MID_DAY_PER,
PART PART09_823 STARTING('09','823') ENDING('09','824') EXCLUSIVE IN MID_DAY_PER,
PART PART09_824 STARTING('09','824') ENDING('09','825') EXCLUSIVE IN MID_DAY_PER,
PART PART09_825 STARTING('09','825') ENDING('09','826') EXCLUSIVE IN MID_DAY_PER,
PART PART09_826 STARTING('09','826') ENDING('09','827') EXCLUSIVE IN MID_DAY_PER,
PART PART09_827 STARTING('09','827') ENDING('09','828') EXCLUSIVE IN MID_DAY_PER,
PART PART09_828 STARTING('09','828') ENDING('09','829') EXCLUSIVE IN MID_DAY_PER,
PART PART09_829 STARTING('09','829') ENDING('09','830') EXCLUSIVE IN MID_DAY_PER,
PART PART09_830 STARTING('09','830') ENDING('09','831') EXCLUSIVE IN MID_DAY_PER,
PART PART10_810 STARTING('10','810') ENDING('10','811') EXCLUSIVE IN MID_DAY_PER,
PART PART10_811 STARTING('10','811') ENDING('10','812') EXCLUSIVE IN MID_DAY_PER,
PART PART10_812 STARTING('10','812') ENDING('10','813') EXCLUSIVE IN MID_DAY_PER,
PART PART10_813 STARTING('10','813') ENDING('10','814') EXCLUSIVE IN MID_DAY_PER,
PART PART10_814 STARTING('10','814') ENDING('10','815') EXCLUSIVE IN MID_DAY_PER,
PART PART10_815 STARTING('10','815') ENDING('10','816') EXCLUSIVE IN MID_DAY_PER,
PART PART10_816 STARTING('10','816') ENDING('10','817') EXCLUSIVE IN MID_DAY_PER,
PART PART10_817 STARTING('10','817') ENDING('10','818') EXCLUSIVE IN MID_DAY_PER,
PART PART10_818 STARTING('10','818') ENDING('10','819') EXCLUSIVE IN MID_DAY_PER,
PART PART10_819 STARTING('10','819') ENDING('10','820') EXCLUSIVE IN MID_DAY_PER,
PART PART10_820 STARTING('10','820') ENDING('10','821') EXCLUSIVE IN MID_DAY_PER,
PART PART10_821 STARTING('10','821') ENDING('10','822') EXCLUSIVE IN MID_DAY_PER,
PART PART10_822 STARTING('10','822') ENDING('10','823') EXCLUSIVE IN MID_DAY_PER,
PART PART10_823 STARTING('10','823') ENDING('10','824') EXCLUSIVE IN MID_DAY_PER,
PART PART10_824 STARTING('10','824') ENDING('10','825') EXCLUSIVE IN MID_DAY_PER,
PART PART10_825 STARTING('10','825') ENDING('10','826') EXCLUSIVE IN MID_DAY_PER,
PART PART10_826 STARTING('10','826') ENDING('10','827') EXCLUSIVE IN MID_DAY_PER,
PART PART10_827 STARTING('10','827') ENDING('10','828') EXCLUSIVE IN MID_DAY_PER,
PART PART10_828 STARTING('10','828') ENDING('10','829') EXCLUSIVE IN MID_DAY_PER,
PART PART10_829 STARTING('10','829') ENDING('10','830') EXCLUSIVE IN MID_DAY_PER,
PART PART10_830 STARTING('10','830') ENDING('10','831') EXCLUSIVE IN MID_DAY_PER,
PART PART11_810 STARTING('11','810') ENDING('11','811') EXCLUSIVE IN MID_DAY_PER,
PART PART11_811 STARTING('11','811') ENDING('11','812') EXCLUSIVE IN MID_DAY_PER,
PART PART11_812 STARTING('11','812') ENDING('11','813') EXCLUSIVE IN MID_DAY_PER,
PART PART11_813 STARTING('11','813') ENDING('11','814') EXCLUSIVE IN MID_DAY_PER,
PART PART11_814 STARTING('11','814') ENDING('11','815') EXCLUSIVE IN MID_DAY_PER,
PART PART11_815 STARTING('11','815') ENDING('11','816') EXCLUSIVE IN MID_DAY_PER,
PART PART11_816 STARTING('11','816') ENDING('11','817') EXCLUSIVE IN MID_DAY_PER,
PART PART11_817 STARTING('11','817') ENDING('11','818') EXCLUSIVE IN MID_DAY_PER,
PART PART11_818 STARTING('11','818') ENDING('11','819') EXCLUSIVE IN MID_DAY_PER,
PART PART11_819 STARTING('11','819') ENDING('11','820') EXCLUSIVE IN MID_DAY_PER,
PART PART11_820 STARTING('11','820') ENDING('11','821') EXCLUSIVE IN MID_DAY_PER,
PART PART11_821 STARTING('11','821') ENDING('11','822') EXCLUSIVE IN MID_DAY_PER,
PART PART11_822 STARTING('11','822') ENDING('11','823') EXCLUSIVE IN MID_DAY_PER,
PART PART11_823 STARTING('11','823') ENDING('11','824') EXCLUSIVE IN MID_DAY_PER,
PART PART11_824 STARTING('11','824') ENDING('11','825') EXCLUSIVE IN MID_DAY_PER,
PART PART11_825 STARTING('11','825') ENDING('11','826') EXCLUSIVE IN MID_DAY_PER,
PART PART11_826 STARTING('11','826') ENDING('11','827') EXCLUSIVE IN MID_DAY_PER,
PART PART11_827 STARTING('11','827') ENDING('11','828') EXCLUSIVE IN MID_DAY_PER,
PART PART11_828 STARTING('11','828') ENDING('11','829') EXCLUSIVE IN MID_DAY_PER,
PART PART11_829 STARTING('11','829') ENDING('11','830') EXCLUSIVE IN MID_DAY_PER,
PART PART11_830 STARTING('11','830') ENDING('11','831') EXCLUSIVE IN MID_DAY_PER,
PART PART12_810 STARTING('12','810') ENDING('12','811') EXCLUSIVE IN MID_DAY_PER,
PART PART12_811 STARTING('12','811') ENDING('12','812') EXCLUSIVE IN MID_DAY_PER,
PART PART12_812 STARTING('12','812') ENDING('12','813') EXCLUSIVE IN MID_DAY_PER,
PART PART12_813 STARTING('12','813') ENDING('12','814') EXCLUSIVE IN MID_DAY_PER,
PART PART12_814 STARTING('12','814') ENDING('12','815') EXCLUSIVE IN MID_DAY_PER,
PART PART12_815 STARTING('12','815') ENDING('12','816') EXCLUSIVE IN MID_DAY_PER,
PART PART12_816 STARTING('12','816') ENDING('12','817') EXCLUSIVE IN MID_DAY_PER,
PART PART12_817 STARTING('12','817') ENDING('12','818') EXCLUSIVE IN MID_DAY_PER,
PART PART12_818 STARTING('12','818') ENDING('12','819') EXCLUSIVE IN MID_DAY_PER,
PART PART12_819 STARTING('12','819') ENDING('12','820') EXCLUSIVE IN MID_DAY_PER,
PART PART12_820 STARTING('12','820') ENDING('12','821') EXCLUSIVE IN MID_DAY_PER,
PART PART12_821 STARTING('12','821') ENDING('12','822') EXCLUSIVE IN MID_DAY_PER,
PART PART12_822 STARTING('12','822') ENDING('12','823') EXCLUSIVE IN MID_DAY_PER,
PART PART12_823 STARTING('12','823') ENDING('12','824') EXCLUSIVE IN MID_DAY_PER,
PART PART12_824 STARTING('12','824') ENDING('12','825') EXCLUSIVE IN MID_DAY_PER,
PART PART12_825 STARTING('12','825') ENDING('12','826') EXCLUSIVE IN MID_DAY_PER,
PART PART12_826 STARTING('12','826') ENDING('12','827') EXCLUSIVE IN MID_DAY_PER,
PART PART12_827 STARTING('12','827') ENDING('12','828') EXCLUSIVE IN MID_DAY_PER,
PART PART12_828 STARTING('12','828') ENDING('12','829') EXCLUSIVE IN MID_DAY_PER,
PART PART12_829 STARTING('12','829') ENDING('12','830') EXCLUSIVE IN MID_DAY_PER,
PART PART12_830 STARTING('12','830') ENDING('12','831') EXCLUSIVE IN MID_DAY_PER,
PART PART13_810 STARTING('13','810') ENDING('13','811') EXCLUSIVE IN MID_DAY_PER,
PART PART13_811 STARTING('13','811') ENDING('13','812') EXCLUSIVE IN MID_DAY_PER,
PART PART13_812 STARTING('13','812') ENDING('13','813') EXCLUSIVE IN MID_DAY_PER,
PART PART13_813 STARTING('13','813') ENDING('13','814') EXCLUSIVE IN MID_DAY_PER,
PART PART13_814 STARTING('13','814') ENDING('13','815') EXCLUSIVE IN MID_DAY_PER,
PART PART13_815 STARTING('13','815') ENDING('13','816') EXCLUSIVE IN MID_DAY_PER,
PART PART13_816 STARTING('13','816') ENDING('13','817') EXCLUSIVE IN MID_DAY_PER,
PART PART13_817 STARTING('13','817') ENDING('13','818') EXCLUSIVE IN MID_DAY_PER,
PART PART13_818 STARTING('13','818') ENDING('13','819') EXCLUSIVE IN MID_DAY_PER,
PART PART13_819 STARTING('13','819') ENDING('13','820') EXCLUSIVE IN MID_DAY_PER,
PART PART13_820 STARTING('13','820') ENDING('13','821') EXCLUSIVE IN MID_DAY_PER,
PART PART13_821 STARTING('13','821') ENDING('13','822') EXCLUSIVE IN MID_DAY_PER,
PART PART13_822 STARTING('13','822') ENDING('13','823') EXCLUSIVE IN MID_DAY_PER,
PART PART13_823 STARTING('13','823') ENDING('13','824') EXCLUSIVE IN MID_DAY_PER,
PART PART13_824 STARTING('13','824') ENDING('13','825') EXCLUSIVE IN MID_DAY_PER,
PART PART13_825 STARTING('13','825') ENDING('13','826') EXCLUSIVE IN MID_DAY_PER,
PART PART13_826 STARTING('13','826') ENDING('13','827') EXCLUSIVE IN MID_DAY_PER,
PART PART13_827 STARTING('13','827') ENDING('13','828') EXCLUSIVE IN MID_DAY_PER,
PART PART13_828 STARTING('13','828') ENDING('13','829') EXCLUSIVE IN MID_DAY_PER,
PART PART13_829 STARTING('13','829') ENDING('13','830') EXCLUSIVE IN MID_DAY_PER,
PART PART13_830 STARTING('13','830') ENDING('13','831') EXCLUSIVE IN MID_DAY_PER,
PART PART14_810 STARTING('14','810') ENDING('14','811') EXCLUSIVE IN MID_DAY_PER,
PART PART14_811 STARTING('14','811') ENDING('14','812') EXCLUSIVE IN MID_DAY_PER,
PART PART14_812 STARTING('14','812') ENDING('14','813') EXCLUSIVE IN MID_DAY_PER,
PART PART14_813 STARTING('14','813') ENDING('14','814') EXCLUSIVE IN MID_DAY_PER,
PART PART14_814 STARTING('14','814') ENDING('14','815') EXCLUSIVE IN MID_DAY_PER,
PART PART14_815 STARTING('14','815') ENDING('14','816') EXCLUSIVE IN MID_DAY_PER,
PART PART14_816 STARTING('14','816') ENDING('14','817') EXCLUSIVE IN MID_DAY_PER,
PART PART14_817 STARTING('14','817') ENDING('14','818') EXCLUSIVE IN MID_DAY_PER,
PART PART14_818 STARTING('14','818') ENDING('14','819') EXCLUSIVE IN MID_DAY_PER,
PART PART14_819 STARTING('14','819') ENDING('14','820') EXCLUSIVE IN MID_DAY_PER,
PART PART14_820 STARTING('14','820') ENDING('14','821') EXCLUSIVE IN MID_DAY_PER,
PART PART14_821 STARTING('14','821') ENDING('14','822') EXCLUSIVE IN MID_DAY_PER,
PART PART14_822 STARTING('14','822') ENDING('14','823') EXCLUSIVE IN MID_DAY_PER,
PART PART14_823 STARTING('14','823') ENDING('14','824') EXCLUSIVE IN MID_DAY_PER,
PART PART14_824 STARTING('14','824') ENDING('14','825') EXCLUSIVE IN MID_DAY_PER,
PART PART14_825 STARTING('14','825') ENDING('14','826') EXCLUSIVE IN MID_DAY_PER,
PART PART14_826 STARTING('14','826') ENDING('14','827') EXCLUSIVE IN MID_DAY_PER,
PART PART14_827 STARTING('14','827') ENDING('14','828') EXCLUSIVE IN MID_DAY_PER,
PART PART14_828 STARTING('14','828') ENDING('14','829') EXCLUSIVE IN MID_DAY_PER,
PART PART14_829 STARTING('14','829') ENDING('14','830') EXCLUSIVE IN MID_DAY_PER,
PART PART14_830 STARTING('14','830') ENDING('14','831') EXCLUSIVE IN MID_DAY_PER,
PART PART15_810 STARTING('15','810') ENDING('15','811') EXCLUSIVE IN MID_DAY_PER,
PART PART15_811 STARTING('15','811') ENDING('15','812') EXCLUSIVE IN MID_DAY_PER,
PART PART15_812 STARTING('15','812') ENDING('15','813') EXCLUSIVE IN MID_DAY_PER,
PART PART15_813 STARTING('15','813') ENDING('15','814') EXCLUSIVE IN MID_DAY_PER,
PART PART15_814 STARTING('15','814') ENDING('15','815') EXCLUSIVE IN MID_DAY_PER,
PART PART15_815 STARTING('15','815') ENDING('15','816') EXCLUSIVE IN MID_DAY_PER,
PART PART15_816 STARTING('15','816') ENDING('15','817') EXCLUSIVE IN MID_DAY_PER,
PART PART15_817 STARTING('15','817') ENDING('15','818') EXCLUSIVE IN MID_DAY_PER,
PART PART15_818 STARTING('15','818') ENDING('15','819') EXCLUSIVE IN MID_DAY_PER,
PART PART15_819 STARTING('15','819') ENDING('15','820') EXCLUSIVE IN MID_DAY_PER,
PART PART15_820 STARTING('15','820') ENDING('15','821') EXCLUSIVE IN MID_DAY_PER,
PART PART15_821 STARTING('15','821') ENDING('15','822') EXCLUSIVE IN MID_DAY_PER,
PART PART15_822 STARTING('15','822') ENDING('15','823') EXCLUSIVE IN MID_DAY_PER,
PART PART15_823 STARTING('15','823') ENDING('15','824') EXCLUSIVE IN MID_DAY_PER,
PART PART15_824 STARTING('15','824') ENDING('15','825') EXCLUSIVE IN MID_DAY_PER,
PART PART15_825 STARTING('15','825') ENDING('15','826') EXCLUSIVE IN MID_DAY_PER,
PART PART15_826 STARTING('15','826') ENDING('15','827') EXCLUSIVE IN MID_DAY_PER,
PART PART15_827 STARTING('15','827') ENDING('15','828') EXCLUSIVE IN MID_DAY_PER,
PART PART15_828 STARTING('15','828') ENDING('15','829') EXCLUSIVE IN MID_DAY_PER,
PART PART15_829 STARTING('15','829') ENDING('15','830') EXCLUSIVE IN MID_DAY_PER,
PART PART15_830 STARTING('15','830') ENDING('15','831') EXCLUSIVE IN MID_DAY_PER,
PART PART16_810 STARTING('16','810') ENDING('16','811') EXCLUSIVE IN MID_DAY_PER,
PART PART16_811 STARTING('16','811') ENDING('16','812') EXCLUSIVE IN MID_DAY_PER,
PART PART16_812 STARTING('16','812') ENDING('16','813') EXCLUSIVE IN MID_DAY_PER,
PART PART16_813 STARTING('16','813') ENDING('16','814') EXCLUSIVE IN MID_DAY_PER,
PART PART16_814 STARTING('16','814') ENDING('16','815') EXCLUSIVE IN MID_DAY_PER,
PART PART16_815 STARTING('16','815') ENDING('16','816') EXCLUSIVE IN MID_DAY_PER,
PART PART16_816 STARTING('16','816') ENDING('16','817') EXCLUSIVE IN MID_DAY_PER,
PART PART16_817 STARTING('16','817') ENDING('16','818') EXCLUSIVE IN MID_DAY_PER,
PART PART16_818 STARTING('16','818') ENDING('16','819') EXCLUSIVE IN MID_DAY_PER,
PART PART16_819 STARTING('16','819') ENDING('16','820') EXCLUSIVE IN MID_DAY_PER,
PART PART16_820 STARTING('16','820') ENDING('16','821') EXCLUSIVE IN MID_DAY_PER,
PART PART16_821 STARTING('16','821') ENDING('16','822') EXCLUSIVE IN MID_DAY_PER,
PART PART16_822 STARTING('16','822') ENDING('16','823') EXCLUSIVE IN MID_DAY_PER,
PART PART16_823 STARTING('16','823') ENDING('16','824') EXCLUSIVE IN MID_DAY_PER,
PART PART16_824 STARTING('16','824') ENDING('16','825') EXCLUSIVE IN MID_DAY_PER,
PART PART16_825 STARTING('16','825') ENDING('16','826') EXCLUSIVE IN MID_DAY_PER,
PART PART16_826 STARTING('16','826') ENDING('16','827') EXCLUSIVE IN MID_DAY_PER,
PART PART16_827 STARTING('16','827') ENDING('16','828') EXCLUSIVE IN MID_DAY_PER,
PART PART16_828 STARTING('16','828') ENDING('16','829') EXCLUSIVE IN MID_DAY_PER,
PART PART16_829 STARTING('16','829') ENDING('16','830') EXCLUSIVE IN MID_DAY_PER,
PART PART16_830 STARTING('16','830') ENDING('16','831') EXCLUSIVE IN MID_DAY_PER,
PART PART17_810 STARTING('17','810') ENDING('17','811') EXCLUSIVE IN MID_DAY_PER,
PART PART17_811 STARTING('17','811') ENDING('17','812') EXCLUSIVE IN MID_DAY_PER,
PART PART17_812 STARTING('17','812') ENDING('17','813') EXCLUSIVE IN MID_DAY_PER,
PART PART17_813 STARTING('17','813') ENDING('17','814') EXCLUSIVE IN MID_DAY_PER,
PART PART17_814 STARTING('17','814') ENDING('17','815') EXCLUSIVE IN MID_DAY_PER,
PART PART17_815 STARTING('17','815') ENDING('17','816') EXCLUSIVE IN MID_DAY_PER,
PART PART17_816 STARTING('17','816') ENDING('17','817') EXCLUSIVE IN MID_DAY_PER,
PART PART17_817 STARTING('17','817') ENDING('17','818') EXCLUSIVE IN MID_DAY_PER,
PART PART17_818 STARTING('17','818') ENDING('17','819') EXCLUSIVE IN MID_DAY_PER,
PART PART17_819 STARTING('17','819') ENDING('17','820') EXCLUSIVE IN MID_DAY_PER,
PART PART17_820 STARTING('17','820') ENDING('17','821') EXCLUSIVE IN MID_DAY_PER,
PART PART17_821 STARTING('17','821') ENDING('17','822') EXCLUSIVE IN MID_DAY_PER,
PART PART17_822 STARTING('17','822') ENDING('17','823') EXCLUSIVE IN MID_DAY_PER,
PART PART17_823 STARTING('17','823') ENDING('17','824') EXCLUSIVE IN MID_DAY_PER,
PART PART17_824 STARTING('17','824') ENDING('17','825') EXCLUSIVE IN MID_DAY_PER,
PART PART17_825 STARTING('17','825') ENDING('17','826') EXCLUSIVE IN MID_DAY_PER,
PART PART17_826 STARTING('17','826') ENDING('17','827') EXCLUSIVE IN MID_DAY_PER,
PART PART17_827 STARTING('17','827') ENDING('17','828') EXCLUSIVE IN MID_DAY_PER,
PART PART17_828 STARTING('17','828') ENDING('17','829') EXCLUSIVE IN MID_DAY_PER,
PART PART17_829 STARTING('17','829') ENDING('17','830') EXCLUSIVE IN MID_DAY_PER,
PART PART17_830 STARTING('17','830') ENDING('17','831') EXCLUSIVE IN MID_DAY_PER,
PART PART18_810 STARTING('18','810') ENDING('18','811') EXCLUSIVE IN MID_DAY_PER,
PART PART18_811 STARTING('18','811') ENDING('18','812') EXCLUSIVE IN MID_DAY_PER,
PART PART18_812 STARTING('18','812') ENDING('18','813') EXCLUSIVE IN MID_DAY_PER,
PART PART18_813 STARTING('18','813') ENDING('18','814') EXCLUSIVE IN MID_DAY_PER,
PART PART18_814 STARTING('18','814') ENDING('18','815') EXCLUSIVE IN MID_DAY_PER,
PART PART18_815 STARTING('18','815') ENDING('18','816') EXCLUSIVE IN MID_DAY_PER,
PART PART18_816 STARTING('18','816') ENDING('18','817') EXCLUSIVE IN MID_DAY_PER,
PART PART18_817 STARTING('18','817') ENDING('18','818') EXCLUSIVE IN MID_DAY_PER,
PART PART18_818 STARTING('18','818') ENDING('18','819') EXCLUSIVE IN MID_DAY_PER,
PART PART18_819 STARTING('18','819') ENDING('18','820') EXCLUSIVE IN MID_DAY_PER,
PART PART18_820 STARTING('18','820') ENDING('18','821') EXCLUSIVE IN MID_DAY_PER,
PART PART18_821 STARTING('18','821') ENDING('18','822') EXCLUSIVE IN MID_DAY_PER,
PART PART18_822 STARTING('18','822') ENDING('18','823') EXCLUSIVE IN MID_DAY_PER,
PART PART18_823 STARTING('18','823') ENDING('18','824') EXCLUSIVE IN MID_DAY_PER,
PART PART18_824 STARTING('18','824') ENDING('18','825') EXCLUSIVE IN MID_DAY_PER,
PART PART18_825 STARTING('18','825') ENDING('18','826') EXCLUSIVE IN MID_DAY_PER,
PART PART18_826 STARTING('18','826') ENDING('18','827') EXCLUSIVE IN MID_DAY_PER,
PART PART18_827 STARTING('18','827') ENDING('18','828') EXCLUSIVE IN MID_DAY_PER,
PART PART18_828 STARTING('18','828') ENDING('18','829') EXCLUSIVE IN MID_DAY_PER,
PART PART18_829 STARTING('18','829') ENDING('18','830') EXCLUSIVE IN MID_DAY_PER,
PART PART18_830 STARTING('18','830') ENDING('18','831') EXCLUSIVE IN MID_DAY_PER,
PART PART19_810 STARTING('19','810') ENDING('19','811') EXCLUSIVE IN MID_DAY_PER,
PART PART19_811 STARTING('19','811') ENDING('19','812') EXCLUSIVE IN MID_DAY_PER,
PART PART19_812 STARTING('19','812') ENDING('19','813') EXCLUSIVE IN MID_DAY_PER,
PART PART19_813 STARTING('19','813') ENDING('19','814') EXCLUSIVE IN MID_DAY_PER,
PART PART19_814 STARTING('19','814') ENDING('19','815') EXCLUSIVE IN MID_DAY_PER,
PART PART19_815 STARTING('19','815') ENDING('19','816') EXCLUSIVE IN MID_DAY_PER,
PART PART19_816 STARTING('19','816') ENDING('19','817') EXCLUSIVE IN MID_DAY_PER,
PART PART19_817 STARTING('19','817') ENDING('19','818') EXCLUSIVE IN MID_DAY_PER,
PART PART19_818 STARTING('19','818') ENDING('19','819') EXCLUSIVE IN MID_DAY_PER,
PART PART19_819 STARTING('19','819') ENDING('19','820') EXCLUSIVE IN MID_DAY_PER,
PART PART19_820 STARTING('19','820') ENDING('19','821') EXCLUSIVE IN MID_DAY_PER,
PART PART19_821 STARTING('19','821') ENDING('19','822') EXCLUSIVE IN MID_DAY_PER,
PART PART19_822 STARTING('19','822') ENDING('19','823') EXCLUSIVE IN MID_DAY_PER,
PART PART19_823 STARTING('19','823') ENDING('19','824') EXCLUSIVE IN MID_DAY_PER,
PART PART19_824 STARTING('19','824') ENDING('19','825') EXCLUSIVE IN MID_DAY_PER,
PART PART19_825 STARTING('19','825') ENDING('19','826') EXCLUSIVE IN MID_DAY_PER,
PART PART19_826 STARTING('19','826') ENDING('19','827') EXCLUSIVE IN MID_DAY_PER,
PART PART19_827 STARTING('19','827') ENDING('19','828') EXCLUSIVE IN MID_DAY_PER,
PART PART19_828 STARTING('19','828') ENDING('19','829') EXCLUSIVE IN MID_DAY_PER,
PART PART19_829 STARTING('19','829') ENDING('19','830') EXCLUSIVE IN MID_DAY_PER,
PART PART19_830 STARTING('19','830') ENDING('19','831') EXCLUSIVE IN MID_DAY_PER,
PART PART20_810 STARTING('20','810') ENDING('20','811') EXCLUSIVE IN MID_DAY_PER,
PART PART20_811 STARTING('20','811') ENDING('20','812') EXCLUSIVE IN MID_DAY_PER,
PART PART20_812 STARTING('20','812') ENDING('20','813') EXCLUSIVE IN MID_DAY_PER,
PART PART20_813 STARTING('20','813') ENDING('20','814') EXCLUSIVE IN MID_DAY_PER,
PART PART20_814 STARTING('20','814') ENDING('20','815') EXCLUSIVE IN MID_DAY_PER,
PART PART20_815 STARTING('20','815') ENDING('20','816') EXCLUSIVE IN MID_DAY_PER,
PART PART20_816 STARTING('20','816') ENDING('20','817') EXCLUSIVE IN MID_DAY_PER,
PART PART20_817 STARTING('20','817') ENDING('20','818') EXCLUSIVE IN MID_DAY_PER,
PART PART20_818 STARTING('20','818') ENDING('20','819') EXCLUSIVE IN MID_DAY_PER,
PART PART20_819 STARTING('20','819') ENDING('20','820') EXCLUSIVE IN MID_DAY_PER,
PART PART20_820 STARTING('20','820') ENDING('20','821') EXCLUSIVE IN MID_DAY_PER,
PART PART20_821 STARTING('20','821') ENDING('20','822') EXCLUSIVE IN MID_DAY_PER,
PART PART20_822 STARTING('20','822') ENDING('20','823') EXCLUSIVE IN MID_DAY_PER,
PART PART20_823 STARTING('20','823') ENDING('20','824') EXCLUSIVE IN MID_DAY_PER,
PART PART20_824 STARTING('20','824') ENDING('20','825') EXCLUSIVE IN MID_DAY_PER,
PART PART20_825 STARTING('20','825') ENDING('20','826') EXCLUSIVE IN MID_DAY_PER,
PART PART20_826 STARTING('20','826') ENDING('20','827') EXCLUSIVE IN MID_DAY_PER,
PART PART20_827 STARTING('20','827') ENDING('20','828') EXCLUSIVE IN MID_DAY_PER,
PART PART20_828 STARTING('20','828') ENDING('20','829') EXCLUSIVE IN MID_DAY_PER,
PART PART20_829 STARTING('20','829') ENDING('20','830') EXCLUSIVE IN MID_DAY_PER,
PART PART20_830 STARTING('20','830') ENDING('20','831') EXCLUSIVE IN MID_DAY_PER,
PART PART21_810 STARTING('21','810') ENDING('21','811') EXCLUSIVE IN MID_DAY_PER,
PART PART21_811 STARTING('21','811') ENDING('21','812') EXCLUSIVE IN MID_DAY_PER,
PART PART21_812 STARTING('21','812') ENDING('21','813') EXCLUSIVE IN MID_DAY_PER,
PART PART21_813 STARTING('21','813') ENDING('21','814') EXCLUSIVE IN MID_DAY_PER,
PART PART21_814 STARTING('21','814') ENDING('21','815') EXCLUSIVE IN MID_DAY_PER,
PART PART21_815 STARTING('21','815') ENDING('21','816') EXCLUSIVE IN MID_DAY_PER,
PART PART21_816 STARTING('21','816') ENDING('21','817') EXCLUSIVE IN MID_DAY_PER,
PART PART21_817 STARTING('21','817') ENDING('21','818') EXCLUSIVE IN MID_DAY_PER,
PART PART21_818 STARTING('21','818') ENDING('21','819') EXCLUSIVE IN MID_DAY_PER,
PART PART21_819 STARTING('21','819') ENDING('21','820') EXCLUSIVE IN MID_DAY_PER,
PART PART21_820 STARTING('21','820') ENDING('21','821') EXCLUSIVE IN MID_DAY_PER,
PART PART21_821 STARTING('21','821') ENDING('21','822') EXCLUSIVE IN MID_DAY_PER,
PART PART21_822 STARTING('21','822') ENDING('21','823') EXCLUSIVE IN MID_DAY_PER,
PART PART21_823 STARTING('21','823') ENDING('21','824') EXCLUSIVE IN MID_DAY_PER,
PART PART21_824 STARTING('21','824') ENDING('21','825') EXCLUSIVE IN MID_DAY_PER,
PART PART21_825 STARTING('21','825') ENDING('21','826') EXCLUSIVE IN MID_DAY_PER,
PART PART21_826 STARTING('21','826') ENDING('21','827') EXCLUSIVE IN MID_DAY_PER,
PART PART21_827 STARTING('21','827') ENDING('21','828') EXCLUSIVE IN MID_DAY_PER,
PART PART21_828 STARTING('21','828') ENDING('21','829') EXCLUSIVE IN MID_DAY_PER,
PART PART21_829 STARTING('21','829') ENDING('21','830') EXCLUSIVE IN MID_DAY_PER,
PART PART21_830 STARTING('21','830') ENDING('21','831') EXCLUSIVE IN MID_DAY_PER,
PART PART22_810 STARTING('22','810') ENDING('22','811') EXCLUSIVE IN MID_DAY_PER,
PART PART22_811 STARTING('22','811') ENDING('22','812') EXCLUSIVE IN MID_DAY_PER,
PART PART22_812 STARTING('22','812') ENDING('22','813') EXCLUSIVE IN MID_DAY_PER,
PART PART22_813 STARTING('22','813') ENDING('22','814') EXCLUSIVE IN MID_DAY_PER,
PART PART22_814 STARTING('22','814') ENDING('22','815') EXCLUSIVE IN MID_DAY_PER,
PART PART22_815 STARTING('22','815') ENDING('22','816') EXCLUSIVE IN MID_DAY_PER,
PART PART22_816 STARTING('22','816') ENDING('22','817') EXCLUSIVE IN MID_DAY_PER,
PART PART22_817 STARTING('22','817') ENDING('22','818') EXCLUSIVE IN MID_DAY_PER,
PART PART22_818 STARTING('22','818') ENDING('22','819') EXCLUSIVE IN MID_DAY_PER,
PART PART22_819 STARTING('22','819') ENDING('22','820') EXCLUSIVE IN MID_DAY_PER,
PART PART22_820 STARTING('22','820') ENDING('22','821') EXCLUSIVE IN MID_DAY_PER,
PART PART22_821 STARTING('22','821') ENDING('22','822') EXCLUSIVE IN MID_DAY_PER,
PART PART22_822 STARTING('22','822') ENDING('22','823') EXCLUSIVE IN MID_DAY_PER,
PART PART22_823 STARTING('22','823') ENDING('22','824') EXCLUSIVE IN MID_DAY_PER,
PART PART22_824 STARTING('22','824') ENDING('22','825') EXCLUSIVE IN MID_DAY_PER,
PART PART22_825 STARTING('22','825') ENDING('22','826') EXCLUSIVE IN MID_DAY_PER,
PART PART22_826 STARTING('22','826') ENDING('22','827') EXCLUSIVE IN MID_DAY_PER,
PART PART22_827 STARTING('22','827') ENDING('22','828') EXCLUSIVE IN MID_DAY_PER,
PART PART22_828 STARTING('22','828') ENDING('22','829') EXCLUSIVE IN MID_DAY_PER,
PART PART22_829 STARTING('22','829') ENDING('22','830') EXCLUSIVE IN MID_DAY_PER,
PART PART22_830 STARTING('22','830') ENDING('22','831') EXCLUSIVE IN MID_DAY_PER,
PART PART23_810 STARTING('23','810') ENDING('23','811') EXCLUSIVE IN MID_DAY_PER,
PART PART23_811 STARTING('23','811') ENDING('23','812') EXCLUSIVE IN MID_DAY_PER,
PART PART23_812 STARTING('23','812') ENDING('23','813') EXCLUSIVE IN MID_DAY_PER,
PART PART23_813 STARTING('23','813') ENDING('23','814') EXCLUSIVE IN MID_DAY_PER,
PART PART23_814 STARTING('23','814') ENDING('23','815') EXCLUSIVE IN MID_DAY_PER,
PART PART23_815 STARTING('23','815') ENDING('23','816') EXCLUSIVE IN MID_DAY_PER,
PART PART23_816 STARTING('23','816') ENDING('23','817') EXCLUSIVE IN MID_DAY_PER,
PART PART23_817 STARTING('23','817') ENDING('23','818') EXCLUSIVE IN MID_DAY_PER,
PART PART23_818 STARTING('23','818') ENDING('23','819') EXCLUSIVE IN MID_DAY_PER,
PART PART23_819 STARTING('23','819') ENDING('23','820') EXCLUSIVE IN MID_DAY_PER,
PART PART23_820 STARTING('23','820') ENDING('23','821') EXCLUSIVE IN MID_DAY_PER,
PART PART23_821 STARTING('23','821') ENDING('23','822') EXCLUSIVE IN MID_DAY_PER,
PART PART23_822 STARTING('23','822') ENDING('23','823') EXCLUSIVE IN MID_DAY_PER,
PART PART23_823 STARTING('23','823') ENDING('23','824') EXCLUSIVE IN MID_DAY_PER,
PART PART23_824 STARTING('23','824') ENDING('23','825') EXCLUSIVE IN MID_DAY_PER,
PART PART23_825 STARTING('23','825') ENDING('23','826') EXCLUSIVE IN MID_DAY_PER,
PART PART23_826 STARTING('23','826') ENDING('23','827') EXCLUSIVE IN MID_DAY_PER,
PART PART23_827 STARTING('23','827') ENDING('23','828') EXCLUSIVE IN MID_DAY_PER,
PART PART23_828 STARTING('23','828') ENDING('23','829') EXCLUSIVE IN MID_DAY_PER,
PART PART23_829 STARTING('23','829') ENDING('23','830') EXCLUSIVE IN MID_DAY_PER,
PART PART23_830 STARTING('23','830') ENDING('23','831') EXCLUSIVE IN MID_DAY_PER,
PART PART24_810 STARTING('24','810') ENDING('24','811') EXCLUSIVE IN MID_DAY_PER,
PART PART24_811 STARTING('24','811') ENDING('24','812') EXCLUSIVE IN MID_DAY_PER,
PART PART24_812 STARTING('24','812') ENDING('24','813') EXCLUSIVE IN MID_DAY_PER,
PART PART24_813 STARTING('24','813') ENDING('24','814') EXCLUSIVE IN MID_DAY_PER,
PART PART24_814 STARTING('24','814') ENDING('24','815') EXCLUSIVE IN MID_DAY_PER,
PART PART24_815 STARTING('24','815') ENDING('24','816') EXCLUSIVE IN MID_DAY_PER,
PART PART24_816 STARTING('24','816') ENDING('24','817') EXCLUSIVE IN MID_DAY_PER,
PART PART24_817 STARTING('24','817') ENDING('24','818') EXCLUSIVE IN MID_DAY_PER,
PART PART24_818 STARTING('24','818') ENDING('24','819') EXCLUSIVE IN MID_DAY_PER,
PART PART24_819 STARTING('24','819') ENDING('24','820') EXCLUSIVE IN MID_DAY_PER,
PART PART24_820 STARTING('24','820') ENDING('24','821') EXCLUSIVE IN MID_DAY_PER,
PART PART24_821 STARTING('24','821') ENDING('24','822') EXCLUSIVE IN MID_DAY_PER,
PART PART24_822 STARTING('24','822') ENDING('24','823') EXCLUSIVE IN MID_DAY_PER,
PART PART24_823 STARTING('24','823') ENDING('24','824') EXCLUSIVE IN MID_DAY_PER,
PART PART24_824 STARTING('24','824') ENDING('24','825') EXCLUSIVE IN MID_DAY_PER,
PART PART24_825 STARTING('24','825') ENDING('24','826') EXCLUSIVE IN MID_DAY_PER,
PART PART24_826 STARTING('24','826') ENDING('24','827') EXCLUSIVE IN MID_DAY_PER,
PART PART24_827 STARTING('24','827') ENDING('24','828') EXCLUSIVE IN MID_DAY_PER,
PART PART24_828 STARTING('24','828') ENDING('24','829') EXCLUSIVE IN MID_DAY_PER,
PART PART24_829 STARTING('24','829') ENDING('24','830') EXCLUSIVE IN MID_DAY_PER,
PART PART24_830 STARTING('24','830') ENDING('24','831') EXCLUSIVE IN MID_DAY_PER,
PART PART25_810 STARTING('25','810') ENDING('25','811') EXCLUSIVE IN MID_DAY_PER,
PART PART25_811 STARTING('25','811') ENDING('25','812') EXCLUSIVE IN MID_DAY_PER,
PART PART25_812 STARTING('25','812') ENDING('25','813') EXCLUSIVE IN MID_DAY_PER,
PART PART25_813 STARTING('25','813') ENDING('25','814') EXCLUSIVE IN MID_DAY_PER,
PART PART25_814 STARTING('25','814') ENDING('25','815') EXCLUSIVE IN MID_DAY_PER,
PART PART25_815 STARTING('25','815') ENDING('25','816') EXCLUSIVE IN MID_DAY_PER,
PART PART25_816 STARTING('25','816') ENDING('25','817') EXCLUSIVE IN MID_DAY_PER,
PART PART25_817 STARTING('25','817') ENDING('25','818') EXCLUSIVE IN MID_DAY_PER,
PART PART25_818 STARTING('25','818') ENDING('25','819') EXCLUSIVE IN MID_DAY_PER,
PART PART25_819 STARTING('25','819') ENDING('25','820') EXCLUSIVE IN MID_DAY_PER,
PART PART25_820 STARTING('25','820') ENDING('25','821') EXCLUSIVE IN MID_DAY_PER,
PART PART25_821 STARTING('25','821') ENDING('25','822') EXCLUSIVE IN MID_DAY_PER,
PART PART25_822 STARTING('25','822') ENDING('25','823') EXCLUSIVE IN MID_DAY_PER,
PART PART25_823 STARTING('25','823') ENDING('25','824') EXCLUSIVE IN MID_DAY_PER,
PART PART25_824 STARTING('25','824') ENDING('25','825') EXCLUSIVE IN MID_DAY_PER,
PART PART25_825 STARTING('25','825') ENDING('25','826') EXCLUSIVE IN MID_DAY_PER,
PART PART25_826 STARTING('25','826') ENDING('25','827') EXCLUSIVE IN MID_DAY_PER,
PART PART25_827 STARTING('25','827') ENDING('25','828') EXCLUSIVE IN MID_DAY_PER,
PART PART25_828 STARTING('25','828') ENDING('25','829') EXCLUSIVE IN MID_DAY_PER,
PART PART25_829 STARTING('25','829') ENDING('25','830') EXCLUSIVE IN MID_DAY_PER,
PART PART25_830 STARTING('25','830') ENDING('25','831') EXCLUSIVE IN MID_DAY_PER,
PART PART26_810 STARTING('26','810') ENDING('26','811') EXCLUSIVE IN MID_DAY_PER,
PART PART26_811 STARTING('26','811') ENDING('26','812') EXCLUSIVE IN MID_DAY_PER,
PART PART26_812 STARTING('26','812') ENDING('26','813') EXCLUSIVE IN MID_DAY_PER,
PART PART26_813 STARTING('26','813') ENDING('26','814') EXCLUSIVE IN MID_DAY_PER,
PART PART26_814 STARTING('26','814') ENDING('26','815') EXCLUSIVE IN MID_DAY_PER,
PART PART26_815 STARTING('26','815') ENDING('26','816') EXCLUSIVE IN MID_DAY_PER,
PART PART26_816 STARTING('26','816') ENDING('26','817') EXCLUSIVE IN MID_DAY_PER,
PART PART26_817 STARTING('26','817') ENDING('26','818') EXCLUSIVE IN MID_DAY_PER,
PART PART26_818 STARTING('26','818') ENDING('26','819') EXCLUSIVE IN MID_DAY_PER,
PART PART26_819 STARTING('26','819') ENDING('26','820') EXCLUSIVE IN MID_DAY_PER,
PART PART26_820 STARTING('26','820') ENDING('26','821') EXCLUSIVE IN MID_DAY_PER,
PART PART26_821 STARTING('26','821') ENDING('26','822') EXCLUSIVE IN MID_DAY_PER,
PART PART26_822 STARTING('26','822') ENDING('26','823') EXCLUSIVE IN MID_DAY_PER,
PART PART26_823 STARTING('26','823') ENDING('26','824') EXCLUSIVE IN MID_DAY_PER,
PART PART26_824 STARTING('26','824') ENDING('26','825') EXCLUSIVE IN MID_DAY_PER,
PART PART26_825 STARTING('26','825') ENDING('26','826') EXCLUSIVE IN MID_DAY_PER,
PART PART26_826 STARTING('26','826') ENDING('26','827') EXCLUSIVE IN MID_DAY_PER,
PART PART26_827 STARTING('26','827') ENDING('26','828') EXCLUSIVE IN MID_DAY_PER,
PART PART26_828 STARTING('26','828') ENDING('26','829') EXCLUSIVE IN MID_DAY_PER,
PART PART26_829 STARTING('26','829') ENDING('26','830') EXCLUSIVE IN MID_DAY_PER,
PART PART26_830 STARTING('26','830') ENDING('26','831') EXCLUSIVE IN MID_DAY_PER,
PART PART27_810 STARTING('27','810') ENDING('27','811') EXCLUSIVE IN MID_DAY_PER,
PART PART27_811 STARTING('27','811') ENDING('27','812') EXCLUSIVE IN MID_DAY_PER,
PART PART27_812 STARTING('27','812') ENDING('27','813') EXCLUSIVE IN MID_DAY_PER,
PART PART27_813 STARTING('27','813') ENDING('27','814') EXCLUSIVE IN MID_DAY_PER,
PART PART27_814 STARTING('27','814') ENDING('27','815') EXCLUSIVE IN MID_DAY_PER,
PART PART27_815 STARTING('27','815') ENDING('27','816') EXCLUSIVE IN MID_DAY_PER,
PART PART27_816 STARTING('27','816') ENDING('27','817') EXCLUSIVE IN MID_DAY_PER,
PART PART27_817 STARTING('27','817') ENDING('27','818') EXCLUSIVE IN MID_DAY_PER,
PART PART27_818 STARTING('27','818') ENDING('27','819') EXCLUSIVE IN MID_DAY_PER,
PART PART27_819 STARTING('27','819') ENDING('27','820') EXCLUSIVE IN MID_DAY_PER,
PART PART27_820 STARTING('27','820') ENDING('27','821') EXCLUSIVE IN MID_DAY_PER,
PART PART27_821 STARTING('27','821') ENDING('27','822') EXCLUSIVE IN MID_DAY_PER,
PART PART27_822 STARTING('27','822') ENDING('27','823') EXCLUSIVE IN MID_DAY_PER,
PART PART27_823 STARTING('27','823') ENDING('27','824') EXCLUSIVE IN MID_DAY_PER,
PART PART27_824 STARTING('27','824') ENDING('27','825') EXCLUSIVE IN MID_DAY_PER,
PART PART27_825 STARTING('27','825') ENDING('27','826') EXCLUSIVE IN MID_DAY_PER,
PART PART27_826 STARTING('27','826') ENDING('27','827') EXCLUSIVE IN MID_DAY_PER,
PART PART27_827 STARTING('27','827') ENDING('27','828') EXCLUSIVE IN MID_DAY_PER,
PART PART27_828 STARTING('27','828') ENDING('27','829') EXCLUSIVE IN MID_DAY_PER,
PART PART27_829 STARTING('27','829') ENDING('27','830') EXCLUSIVE IN MID_DAY_PER,
PART PART27_830 STARTING('27','830') ENDING('27','831') EXCLUSIVE IN MID_DAY_PER,
PART PART28_810 STARTING('28','810') ENDING('28','811') EXCLUSIVE IN MID_DAY_PER,
PART PART28_811 STARTING('28','811') ENDING('28','812') EXCLUSIVE IN MID_DAY_PER,
PART PART28_812 STARTING('28','812') ENDING('28','813') EXCLUSIVE IN MID_DAY_PER,
PART PART28_813 STARTING('28','813') ENDING('28','814') EXCLUSIVE IN MID_DAY_PER,
PART PART28_814 STARTING('28','814') ENDING('28','815') EXCLUSIVE IN MID_DAY_PER,
PART PART28_815 STARTING('28','815') ENDING('28','816') EXCLUSIVE IN MID_DAY_PER,
PART PART28_816 STARTING('28','816') ENDING('28','817') EXCLUSIVE IN MID_DAY_PER,
PART PART28_817 STARTING('28','817') ENDING('28','818') EXCLUSIVE IN MID_DAY_PER,
PART PART28_818 STARTING('28','818') ENDING('28','819') EXCLUSIVE IN MID_DAY_PER,
PART PART28_819 STARTING('28','819') ENDING('28','820') EXCLUSIVE IN MID_DAY_PER,
PART PART28_820 STARTING('28','820') ENDING('28','821') EXCLUSIVE IN MID_DAY_PER,
PART PART28_821 STARTING('28','821') ENDING('28','822') EXCLUSIVE IN MID_DAY_PER,
PART PART28_822 STARTING('28','822') ENDING('28','823') EXCLUSIVE IN MID_DAY_PER,
PART PART28_823 STARTING('28','823') ENDING('28','824') EXCLUSIVE IN MID_DAY_PER,
PART PART28_824 STARTING('28','824') ENDING('28','825') EXCLUSIVE IN MID_DAY_PER,
PART PART28_825 STARTING('28','825') ENDING('28','826') EXCLUSIVE IN MID_DAY_PER,
PART PART28_826 STARTING('28','826') ENDING('28','827') EXCLUSIVE IN MID_DAY_PER,
PART PART28_827 STARTING('28','827') ENDING('28','828') EXCLUSIVE IN MID_DAY_PER,
PART PART28_828 STARTING('28','828') ENDING('28','829') EXCLUSIVE IN MID_DAY_PER,
PART PART28_829 STARTING('28','829') ENDING('28','830') EXCLUSIVE IN MID_DAY_PER,
PART PART28_830 STARTING('28','830') ENDING('28','831') EXCLUSIVE IN MID_DAY_PER,
PART PART29_810 STARTING('29','810') ENDING('29','811') EXCLUSIVE IN MID_DAY_PER,
PART PART29_811 STARTING('29','811') ENDING('29','812') EXCLUSIVE IN MID_DAY_PER,
PART PART29_812 STARTING('29','812') ENDING('29','813') EXCLUSIVE IN MID_DAY_PER,
PART PART29_813 STARTING('29','813') ENDING('29','814') EXCLUSIVE IN MID_DAY_PER,
PART PART29_814 STARTING('29','814') ENDING('29','815') EXCLUSIVE IN MID_DAY_PER,
PART PART29_815 STARTING('29','815') ENDING('29','816') EXCLUSIVE IN MID_DAY_PER,
PART PART29_816 STARTING('29','816') ENDING('29','817') EXCLUSIVE IN MID_DAY_PER,
PART PART29_817 STARTING('29','817') ENDING('29','818') EXCLUSIVE IN MID_DAY_PER,
PART PART29_818 STARTING('29','818') ENDING('29','819') EXCLUSIVE IN MID_DAY_PER,
PART PART29_819 STARTING('29','819') ENDING('29','820') EXCLUSIVE IN MID_DAY_PER,
PART PART29_820 STARTING('29','820') ENDING('29','821') EXCLUSIVE IN MID_DAY_PER,
PART PART29_821 STARTING('29','821') ENDING('29','822') EXCLUSIVE IN MID_DAY_PER,
PART PART29_822 STARTING('29','822') ENDING('29','823') EXCLUSIVE IN MID_DAY_PER,
PART PART29_823 STARTING('29','823') ENDING('29','824') EXCLUSIVE IN MID_DAY_PER,
PART PART29_824 STARTING('29','824') ENDING('29','825') EXCLUSIVE IN MID_DAY_PER,
PART PART29_825 STARTING('29','825') ENDING('29','826') EXCLUSIVE IN MID_DAY_PER,
PART PART29_826 STARTING('29','826') ENDING('29','827') EXCLUSIVE IN MID_DAY_PER,
PART PART29_827 STARTING('29','827') ENDING('29','828') EXCLUSIVE IN MID_DAY_PER,
PART PART29_828 STARTING('29','828') ENDING('29','829') EXCLUSIVE IN MID_DAY_PER,
PART PART29_829 STARTING('29','829') ENDING('29','830') EXCLUSIVE IN MID_DAY_PER,
PART PART29_830 STARTING('29','830') ENDING('29','831') EXCLUSIVE IN MID_DAY_PER,
PART PART30_810 STARTING('30','810') ENDING('30','811') EXCLUSIVE IN MID_DAY_PER,
PART PART30_811 STARTING('30','811') ENDING('30','812') EXCLUSIVE IN MID_DAY_PER,
PART PART30_812 STARTING('30','812') ENDING('30','813') EXCLUSIVE IN MID_DAY_PER,
PART PART30_813 STARTING('30','813') ENDING('30','814') EXCLUSIVE IN MID_DAY_PER,
PART PART30_814 STARTING('30','814') ENDING('30','815') EXCLUSIVE IN MID_DAY_PER,
PART PART30_815 STARTING('30','815') ENDING('30','816') EXCLUSIVE IN MID_DAY_PER,
PART PART30_816 STARTING('30','816') ENDING('30','817') EXCLUSIVE IN MID_DAY_PER,
PART PART30_817 STARTING('30','817') ENDING('30','818') EXCLUSIVE IN MID_DAY_PER,
PART PART30_818 STARTING('30','818') ENDING('30','819') EXCLUSIVE IN MID_DAY_PER,
PART PART30_819 STARTING('30','819') ENDING('30','820') EXCLUSIVE IN MID_DAY_PER,
PART PART30_820 STARTING('30','820') ENDING('30','821') EXCLUSIVE IN MID_DAY_PER,
PART PART30_821 STARTING('30','821') ENDING('30','822') EXCLUSIVE IN MID_DAY_PER,
PART PART30_822 STARTING('30','822') ENDING('30','823') EXCLUSIVE IN MID_DAY_PER,
PART PART30_823 STARTING('30','823') ENDING('30','824') EXCLUSIVE IN MID_DAY_PER,
PART PART30_824 STARTING('30','824') ENDING('30','825') EXCLUSIVE IN MID_DAY_PER,
PART PART30_825 STARTING('30','825') ENDING('30','826') EXCLUSIVE IN MID_DAY_PER,
PART PART30_826 STARTING('30','826') ENDING('30','827') EXCLUSIVE IN MID_DAY_PER,
PART PART30_827 STARTING('30','827') ENDING('30','828') EXCLUSIVE IN MID_DAY_PER,
PART PART30_828 STARTING('30','828') ENDING('30','829') EXCLUSIVE IN MID_DAY_PER,
PART PART30_829 STARTING('30','829') ENDING('30','830') EXCLUSIVE IN MID_DAY_PER,
PART PART30_830 STARTING('30','830') ENDING('30','831') EXCLUSIVE IN MID_DAY_PER,
PART PART31_810 STARTING('31','810') ENDING('31','811') EXCLUSIVE IN MID_DAY_PER,
PART PART31_811 STARTING('31','811') ENDING('31','812') EXCLUSIVE IN MID_DAY_PER,
PART PART31_812 STARTING('31','812') ENDING('31','813') EXCLUSIVE IN MID_DAY_PER,
PART PART31_813 STARTING('31','813') ENDING('31','814') EXCLUSIVE IN MID_DAY_PER,
PART PART31_814 STARTING('31','814') ENDING('31','815') EXCLUSIVE IN MID_DAY_PER,
PART PART31_815 STARTING('31','815') ENDING('31','816') EXCLUSIVE IN MID_DAY_PER,
PART PART31_816 STARTING('31','816') ENDING('31','817') EXCLUSIVE IN MID_DAY_PER,
PART PART31_817 STARTING('31','817') ENDING('31','818') EXCLUSIVE IN MID_DAY_PER,
PART PART31_818 STARTING('31','818') ENDING('31','819') EXCLUSIVE IN MID_DAY_PER,
PART PART31_819 STARTING('31','819') ENDING('31','820') EXCLUSIVE IN MID_DAY_PER,
PART PART31_820 STARTING('31','820') ENDING('31','821') EXCLUSIVE IN MID_DAY_PER,
PART PART31_821 STARTING('31','821') ENDING('31','822') EXCLUSIVE IN MID_DAY_PER,
PART PART31_822 STARTING('31','822') ENDING('31','823') EXCLUSIVE IN MID_DAY_PER,
PART PART31_823 STARTING('31','823') ENDING('31','824') EXCLUSIVE IN MID_DAY_PER,
PART PART31_824 STARTING('31','824') ENDING('31','825') EXCLUSIVE IN MID_DAY_PER,
PART PART31_825 STARTING('31','825') ENDING('31','826') EXCLUSIVE IN MID_DAY_PER,
PART PART31_826 STARTING('31','826') ENDING('31','827') EXCLUSIVE IN MID_DAY_PER,
PART PART31_827 STARTING('31','827') ENDING('31','828') EXCLUSIVE IN MID_DAY_PER,
PART PART31_828 STARTING('31','828') ENDING('31','829') EXCLUSIVE IN MID_DAY_PER,
PART PART31_829 STARTING('31','829') ENDING('31','830') EXCLUSIVE IN MID_DAY_PER,
PART PART31_830 STARTING('31','830') ENDING('31','831') EXCLUSIVE IN MID_DAY_PER);
COMMIT;
COMMENT ON MID.MID_D_IMP_BALANCE_TTYD
(
PROD_ID IS ' --产品 对应源文件中: $2',
START_TIME IS ' --开始时间 对应源文件中: $3',
RATE_TIME IS ' --批价时间 对应源文件中: $5',
OPERATION_TYPE_ID IS ' --业务级别 对应源文件中: $6',
CALLING_NUMBER IS ' --主叫号码 对应源文件中: $7',
CALLED_NUMBER IS ' --被叫号码 对应源文件中: $8',
CALLING_AREA_ID IS ' --主叫营业区 对应源文件中: $11',
CALLED_AREA_ID IS ' --被叫营业区 对应源文件中: $12',
IN_TRUNK_NUMBER IS ' --入中继 对应源文件中: $13',
OUT_TRUNK_NUMBER IS ' --出中继 对应源文件中: $14',
RAW_UNIT_TYPE IS ' --次数类型 对应源文件中: $15',
RAW_UNITS IS ' --计费单位 对应源文件中: $16',
RATE_UNIT_TYPE IS ' --批价费率类型：6:6秒次 2：分钟次 对应源文件中: $17',
IS_FREE IS ' --无用 对应源文件中: $18',
RATE_UNITS IS ' --批价次数 对应源文件中: $19',
CALLING_AREA_CODE IS ' --主叫营业区代码 对应源文件中: $20',
CALLED_AREA_CODE IS ' --被叫叫营业区代码 对应源文件中: $21',
TOTAL_DUE_AMOUNT IS ' --批价金额 对应源文件中: $26',
RATE_ID IS ' --费率ID 对应源文件中: $28',
DURATION IS ' --时长 对应源文件中: $30',
CITY_ID IS ' --地市 对应源文件中: $31',
FILE_NAME IS ' --文件名 对应源文件中: $33',
STATUS IS ' --状态（无用） 对应源文件中: $35',
RATE_KEY3 IS ' --预留字段 对应源文件中: $46',
DIRECTION IS ' --结算方向（无用） 对应源文件中: $44',
FILE_CLASS_ID IS ' --文件名ID 对应源文件中: $45',
TOTAL_DUE_UNITS IS ' --计费次数 对应源文件中: $48',
TABLE_NAME IS ' --入库表名 对应源文件中: $54',
PROVINCE_ID IS ' --省份 对应源文件中: $58',
DURATION_SEC6 IS ' --6秒次数 对应源文件中: $60',
IN_TRUNK_GROUP IS ' --入中继分组 对应源文件中: $61',
OUT_TRUNK_GROUP IS ' --出中继分组 对应源文件中: $62',
CALLING_GROUP_ID IS ' --主叫分组 对应源文件中: $65',
CALLED_GROUP_ID IS ' --被叫分组 对应源文件中: $66'
);
COMMIT;
发表评论
相关推荐
这一步是临时存储原始数据，确保新分区表创建后可以恢复数据。 4. **创建分区表空间**： 分区表需要特定的表空间来存储各个分区。使用`db2 -tvf create_tablespaces.sql`执行SQL脚本来创建这些表空间，例如，查找...
在上面的示例中，我们创建了一个名为 lineitem 的表，该表有四个分区，分别是 A、B、C 和 D，每个分区的范围都是基于 l_shipdate 字段的值。 在DB2数据库中，我们也可以使用 ALTER TABLE 语句来添加新的分区，例如...
以下是对创建DB2表分区的详细说明： 1. **日期方式创建表分区** - 在这种类型的分区中，我们基于日期字段对表进行分割。例如，`CREATE TABLE`语句中的`PARTITION BY RANGE(DATA_DATE)`声明表明我们将根据`DATA_...
当执行删除表操作时，DB2会在日志文件中记录一条关于该表的信息，并在恢复历史记录文件中保存用于重新创建表的DDL语句。 1. **标识已删除表**：通过调用`LISTHISTORYDROPPEDTABLE`命令来列出所有已删除的表。 2. **...
DB2支持多种存储类型，如堆表存储（Heap）、索引组织表（Index-Organized Table, IOT）和分区表等。 1. **堆表存储**：这是最基础的存储方式，数据按照插入顺序存储，没有特定的排序。每个记录的物理位置可能随着新...
6. **db2 create table table_name (column1 datatype, column2 datatype,...)**：创建新表，定义列名和数据类型。 7. **db2 insert into table_name values (value1, value2,...)**：向表中插入数据。 8. **db2 ...
在这个例子中，`customer`和`sales`表均基于`cust_id`字段进行哈希分区，这意味着具有相同`cust_id`的数据会被分配到同一个分区中。 #### 八、总结 DB2 数据库分区特性 (DPF) 是一项重要的技术，它通过将数据分布...
分区表通过将数据按规则分割成多个部分存储，减少了每次查询所需扫描的数据量。 **判断方法：** 可以使用`DESCRIBE TABLE`命令来检查表是否为分区表。 **修复分区表问题：** 如果发现分区表有问题，可以尝试使用`...
- **解释:** 每个表可以创建的索引数量上限为 32767 个，或者受限于系统资源（如内存）。过多的索引不仅占用大量存储空间，还会影响写入性能。 #### 10. SQL 语句或视图中所引用的最大表数 - **限制:** 一个 SQL ...
- 在Oracle中，创建表使用`CREATE TABLE`，而在DB2中同样如此。 - Oracle的`ALTER TABLE`用于修改表结构，DB2也提供相同功能。 - 两者都支持`DROP TABLE`来删除表，但需要注意的是，Oracle默认是不回收空间的，而...
以上步骤详细阐述了在DB2中建立单机版数据库以及导入表的过程，包括实例启动、数据库创建、连接、分区、缓冲池、模式、表空间和表的创建，以及权限管理。这些操作对于数据库管理员和数据库开发者来说至关重要，确保...
1. **分区表**：对于大型表，采用分区技术可以显著提高查询速度，特别是在处理范围查询或过滤特定分区数据时。 2. **数据压缩**：利用DB2的数据压缩特性可以减少磁盘占用空间，同时降低I/O负载，间接提高系统性能。 ...
- **外键**：DB2支持外键约束，但在GreenPlum/PostgreSQL中，外键约束可能会受到分区等因素的影响。 - **唯一约束**：DB2支持在表级或列级定义唯一约束，而在GreenPlum/PostgreSQL中也可以这样做，但实现方式可能略...
在DB2中，创建表是数据库设计的基础。你可以使用`CREATE TABLE`语句定义表结构，包括字段名、数据类型、长度、约束条件等。例如，创建一个包含员工信息的表可能如下： ```sql CREATE TABLE Employees ( ID INT ...
例如，通过分区，大表可以根据特定字段进行分割，优化查询效率。 此外，DB2的GUI工具如DB2 Control Center和IBM Data Studio，为管理员和开发者提供了直观的界面来管理数据库。这些工具可以帮助执行日常任务，如...
- **分区表损坏后的处理**：使用脚本提取工具（如`gj$ db2look_tbowner.ksh-t 表名`）获取表结构脚本，并重新执行该脚本来重建分区表。 #### 六、锁级别与索引 - **表级锁与行级锁**： - **表级锁**：在大多数情况...
创建表时，需要定义字段名、数据类型、长度和约束条件，如主键、外键和唯一性约束。 2. **SQL支持**：DB2全面支持SQL（结构化查询语言），允许用户进行数据查询、插入、更新和删除操作。此外，还支持复杂的SQL子句...
- **临时表不能建索引**：DB2中的临时表不允许创建索引。 - **CURSOR不能定义为WITH UR(可以但…)**：虽然DB2允许定义带有`WITH UR`的游标，但在实际应用中可能会遇到性能问题。 - **CURSOR ORDER BY以后不能FOR ...
了解如何分析查询执行计划，使用索引策略，调整表分区等技巧，有助于提升DB2数据库的性能。 这份"IBM DB2通用数据库SQL入门"PDF教程将涵盖以上所有主题，并可能深入探讨每个话题，提供实例和练习，帮助你从零开始...