All Forums Tools
Arpan.Roy 24 posts Joined 04/16
21 Apr 2016
ASCII value of the delimiter in TPT Export Operator

Hi All,
Is there any way to pass ASCII value of character in TextDelimiter for TPT Export Operator? I want to export  a "TAB" delimited file. But when I'm giving tab a separator, it's taking space as delimiter. So if we can give ASCII character instead of actual character, it might produce the export file with tab as delimiter.
Below is my tpt control file:

DEFINE JOB EXPORT_CODE_ORG_HIER_V_TO_FILE

DESCRIPTION 'export EXPORT_CODE_ORG_HIER_V_TO_FILE'

     (

        DEFINE SCHEMA SCHEMA_CODE_ORG_HIER_V

(

            SYSTEM_CD   VARCHAR(1000)

,PRINCIPAL_CD VARCHAR(1000)

,CORPORATION_CD VARCHAR(1000)

,ENTITY_NAME VARCHAR(1000)

,STATE VARCHAR(1000)

,REGION_NAME VARCHAR(1000)

,DIVISION_NAME VARCHAR(1000)

     );

 

        DEFINE OPERATOR o_ExportOper

        TYPE EXPORT

        SCHEMA SCHEMA_CODE_ORG_HIER_V

        ATTRIBUTES (

            VARCHAR UserName = @UserName

           ,VARCHAR UserPassword = @UserPassword

           ,VARCHAR TdpId = @TdpId

           ,INTEGER MaxSessions = @MaxSessions

           ,INTEGER MinSessions = @MinSessions

  ,VARCHAR PrivateLogName = 'Export'

           ,VARCHAR SpoolMode = 'NoSpool'

           ,VARCHAR WorkingDatabase = @WorkingDatabase

  ,VARCHAR SourceTable = @SourceTable

           ,VARCHAR SelectStmt = @SelectStmt

        );

 

        DEFINE OPERATOR o_FileWritter

        TYPE DATACONNECTOR CONSUMER

        SCHEMA SCHEMA_CODE_ORG_HIER_V

        ATTRIBUTES (

         VARCHAR FileName = @FileName

        ,VARCHAR Format = @Format

        ,VARCHAR TextDelimiter = @TextDelimiter

        ,VARCHAR IndicatorMode = 'N'

        ,VARCHAR OpenMode = 'Write'

,VARCHAR PrivateLogName = 'DataConnector'

        );

        APPLY TO OPERATOR (o_FileWritter[@LoadInst])

           SELECT * FROM OPERATOR (o_ExportOper[@ReadInst]);

     )

     ;

 

Below is the tbuild command I'm executing:

 

tbuild -f /home/aroy001c/Sample/ctl/code_org_hier_v.tpt.ctl -v /home/aroy001c/Sample/logon/aroy001c_tpt.logon -u " WorkingDatabase='NDW_EXTRACT_VIEWS' , SourceTable='CODE_ORG_HIER_V' , MacroDatabase='NDW_TEMP' , load_op=o_ExportOper , LoadInst=1 , ReadInst=1 , MaxSessions=10 , MinSessions=5 , FileName='/home/aroy001c/Sample/tgtfile/ code_org_hier_v.out' , LOAD_DTS='2016-04-21 08:21:34' , Format='DELIMITED' TextDelimiter=' ' , SkipRows=0 , SelectStmt='SELECT TRIM(CAST(SYSTEM_CD  AS VARCHAR(1000))),TRIM(CAST(PRINCIPAL_CD  AS VARCHAR(1000))),TRIM(CAST(CORPORATION_CD  AS VARCHAR(1000))),TRIM(CAST(ENTITY_NAME  AS VARCHAR(1000))),TRIM(CAST(STATE  AS VARCHAR(1000))),TRIM(CAST(REGION_NAME  AS VARCHAR(1000))),TRIM(CAST(DIVISION_NAME  AS VARCHAR(1000))) FROM NDW_EXTRACT_VIEWS.CODE_ORG_HIER_V;'" CODE_ORG_HIER_V

 

Below is the sample outpot file

 

  01626 Belt Ce VA BEY REG ND

8497 9500  Mex NM MOU REG WD

Please help.
Thanks & Regards,
Arpan.
(+919903062694)

feinholz 1234 posts Joined 05/08
21 Apr 2016

The Export operator is not involved in the writing of data to the file.
That is the job of the DataConnector operator.
If you want a "tab" character, then try putting "TAB" (all uppercase) as the value to the TextDelimiter attribute.
According to our documentation for TextDelimiter:
  

Optional attribute that specifies the bytes that separate fields in delimited

records. Any number of characters can be defined via the attribute

assignment.

 

The default delimiter character is the pipe character ( | ). To embed a pipe

delimiter character in your data, precede the pipe character with a

backslash ( \ ).

 

Note: To use the tab character as the delimiter character, specify

TextDelimiter = 'TAB'. Use uppercase “TAB” not lowercase “tab”. The

backslash is required if you want to embed a tab character in your data.

--SteveF

Arpan.Roy 24 posts Joined 04/16
22 Apr 2016

Hi Steve,
Thank you very much for your input. It worked.
So, ASCII or Uniode value of the TextDelimiter can't be given, rather specific character has to be given for TextDelimiter. Is that correct understanding?
 
Thanks & Regards,
Arpan. 

feinholz 1234 posts Joined 05/08
22 Apr 2016

There is an undocumented attribute called TextDelimiterHex that allows you to enter the hex values for a delimiter. The helps when the delimiter is an ASCII unprintable character.
 

--SteveF

Arpan.Roy 24 posts Joined 04/16
26 Apr 2016

Thanks a lot Steve. I'm not sure whether I should start a separate discussion/ thread for below question:
Is there any restriction on the no of columns exported while using Export and Data Connector operator? When I'm exporting more than 255 columns, I'm getting below error.

**** 04:04:48 RDBMS Warning: 3705 Request executed in interpretive EVL mode.

              RDBMS subsystem or component ID: 0

**** 04:04:48 Warning: Export will be spooled,

              because the SELECT request isn't supported in NoSpool Mode.

**** 04:04:48 Select execution completed. 0 data blocks generated.

 

Or this no of columns can be set in database side or any configuration file.

We are planning to export more than 1500 columns for an export. 

 

Also, for FExp, first 3 bytes are binary which we used to remove (like "CxXxX"). Whether the the same rule has to be applied for Export and Data Connector operator or it doesn't produce this kind of cleanup mask.

 

Thanks & Regards,

Arpan.

 

feinholz 1234 posts Joined 05/08
26 Apr 2016

There is no limit on the number of columns that can be processed by the Export operator.
It can handle whatever Teradata supports.
What is the version of TPT and the version of the Teradata Database?
Those messages are warnings and thus should not affect the job.
Does the job not run to completion?

--SteveF

Arpan.Roy 24 posts Joined 04/16
27 Apr 2016

Hi Steve,
Teradata DB Version: 15.10.00.03
TPT Version: 14.10.00.08
The file is getting generated, but exit code is 4. So, when I'll call the job from Linux then, as return code is non zero value, it will be considered as failed.
Below are the tbuild command (adm_201602.ksh) and tpt control file (adm_201602.tpt.ctl). 
------------------------------
adm_201602.tpt.ctl
------------------------------

DEFINE JOB EXPORT_ADM_201602_TO_FILE
DESCRIPTION 'export EXPORT_ADM_201602_TO_FILE'
     (
        DEFINE SCHEMA SCHEMA_ADM_201602
            (
                CUSTOMER_ACCOUNT_ID   VARCHAR(1000),
				ACCOUNT_NUMBER   VARCHAR(1000),
				PREVIOUS_ACCOUNT_NUMBER   VARCHAR(1000),
				HOUSE_ID   VARCHAR(1000),
				ACCT_NUMBER_CHANGE_DATE   VARCHAR(1000),
				PERSISTENT_KEY   VARCHAR(1000),
				HOUSEHOLD_PERSISTENT_KEY   VARCHAR(1000),
				PKEY_CONFIDENCE   VARCHAR(1000),
				"NAME"   VARCHAR(1000),
				ADDRESS1   VARCHAR(1000),
				ADDRESS2   VARCHAR(1000),
				CITY   VARCHAR(1000),
				STATE   VARCHAR(1000),
				ZIP   VARCHAR(1000),
				ZIP4   VARCHAR(1000),
				PHONE_NUMBER   VARCHAR(1000),
				DWELL_TYPE_GROUP   VARCHAR(1000),
				DWELL_TYPE_SUB_GROUP   VARCHAR(1000),
				DWELL_TYPE_DESCRIPTION   VARCHAR(1000),
				PRIMARY_EMAIL   VARCHAR(1000),
				CONTACT_EMAIL   VARCHAR(1000),
				BILLER_EMAIL   VARCHAR(1000),
				CONTACT_EMAIL_FLAG   VARCHAR(1000),
				EMAIL_FLAG   VARCHAR(1000),
				LOCATION_ID   VARCHAR(1000),
				DMA   VARCHAR(1000),
				CUSTOMER_GUID   VARCHAR(1000),
				BILLING_SYSTEM   VARCHAR(1000),
				START_DATE   VARCHAR(1000),
				HSD_SERVICABILITY_IND   VARCHAR(1000),
				VIDEO_SERVICABILITY_IND   VARCHAR(1000),
				VOICE_SERVICABILITY_IND   VARCHAR(1000),
				BULK_COMPLEX_SID   VARCHAR(1000),
				BULK_MASTER_UNITS_COUNT   VARCHAR(1000),
				PANEL_IND   VARCHAR(1000),
				PANELIST_ID   VARCHAR(1000),
				PANELIST_ID1   VARCHAR(1000),
				FIBER_NODE_NM   VARCHAR(1000),
				FIBER_NODE_DESC   VARCHAR(1000),
				FIPS_CODE   VARCHAR(1000),
				LATITUDE   VARCHAR(1000),
				LONGITUDE   VARCHAR(1000),
				ELOC_MARKET_NAME   VARCHAR(1000),
				ORGANIZATION_ID   VARCHAR(1000),
				HOUSE_MISC   VARCHAR(1000),
				ACCOUNT_STATUS   VARCHAR(1000),
				CUSTOMER_TYPE   VARCHAR(1000),
				RESIDENTIAL_IND   VARCHAR(1000),
				BUSINESSSERVICES_IND   VARCHAR(1000),
				BULK_IND   VARCHAR(1000),
				PRIMARY_BULK_MASTER   VARCHAR(1000),
				SECONDARY_BULK_MASTER   VARCHAR(1000),
				SUBSERVIENT   VARCHAR(1000),
				BULK_COURTESY   VARCHAR(1000),
				PRIMARY_BULK_MASTER_ACCOUNT_ID   VARCHAR(1000),
				BULK_PRODUCT_UPGRADEABLE   VARCHAR(1000),
				BULK_PRODUCT_NON_UPGRADEABLE   VARCHAR(1000),
				BULK_CUS_UPG_TYPE   VARCHAR(1000),
				COURTESY_IND   VARCHAR(1000),
				SEASONAL_FLAG   VARCHAR(1000),
				NUMBER_OF_PRODUCTS   VARCHAR(1000),
				PRODUCT_MIX   VARCHAR(1000),
				TENURE_BY_PKEY   VARCHAR(1000),
				TENURE_BY_ACCOUNT   VARCHAR(1000),
				RGU_VIDEO   VARCHAR(1000),
				RGU_HSD   VARCHAR(1000),
				RGU_CDV   VARCHAR(1000),
				RGU_XH   VARCHAR(1000),
				RGU_BULK_VIDEO   VARCHAR(1000),
				RGU_BULK_HSD   VARCHAR(1000),
				RGU_BULK_CDV   VARCHAR(1000),
				VIDEO_PRODUCT_EFF_DT   VARCHAR(1000),
				VIDEO_DAYS_ON_BOOKS   VARCHAR(1000),
				VIDEO_MONTHS_ON_BOOKS   VARCHAR(1000),
				HSD_PRODUCT_EFF_DT   VARCHAR(1000),
				HSD_DAYS_ON_BOOKS   VARCHAR(1000),
				HSD_MONTHS_ON_BOOKS   VARCHAR(1000),
				CDV_PRODUCT_EFF_DT   VARCHAR(1000),
				CDV_DAYS_ON_BOOKS   VARCHAR(1000),
				CDV_MONTHS_ON_BOOKS   VARCHAR(1000),
				XH_PRODUCT_EFF_DT   VARCHAR(1000),
				XH_DAYS_ON_BOOKS   VARCHAR(1000),
				XH_MONTHS_ON_BOOKS   VARCHAR(1000),
				VIDEO_TIER_NAME   VARCHAR(1000),
				VIDEO_BASIC   VARCHAR(1000),
				VIDEO_EXPANDED   VARCHAR(1000),
				VIDEO_GET_STARTED   VARCHAR(1000),
				VIDEO_DIGITAL_ECONOMY   VARCHAR(1000),
				VIDEO_DIGITAL_STARTER   VARCHAR(1000),
				VIDEO_DIGITAL_PREFERRED   VARCHAR(1000),
				VIDEO_BUS_SERVICES_PRIVATE   VARCHAR(1000),
				VIDEO_BUS_SERVICES_PUBLIC   VARCHAR(1000),
				VIDEO_BS_BASICVIDEO_B1   VARCHAR(1000),
				VIDEO_BS_EXPANDEDVIDEO_B2   VARCHAR(1000),
				VIDEO_BS_DIGITAL_STARTER_TIER   VARCHAR(1000),
				VIDEO_BS_DIGITAL_PREFERRED_TIER   VARCHAR(1000),
				VIDEO_BS_DIGITAL_STANDARD_TIER   VARCHAR(1000),
				VIDEO_BS_PUBLIC_BR1   VARCHAR(1000),
				VIDEO_BS_PUBLIC_BR1_5   VARCHAR(1000),
				VIDEO_BS_PUBLIC_BR2   VARCHAR(1000),
				VIDEO_BS_PUBLIC_WSPORTS_BR4   VARCHAR(1000),
				VIDEO_BS_PRIVATE_C0   VARCHAR(1000),
				VIDEO_BS_PRIVATE_C0_5   VARCHAR(1000),
				VIDEO_BS_PRIVATE_C1   VARCHAR(1000),
				VIDEO_BS_PRIVATE_C1_5   VARCHAR(1000),
				VIDEO_BS_PRIVATE_C2   VARCHAR(1000),
				VIDEO_BS_PRIVATE_C3   VARCHAR(1000),
				VIDEO_BULK   VARCHAR(1000),
				HD_SERVICE   VARCHAR(1000),
				DVR_SERVICE   VARCHAR(1000),
				BLASTPLUS_IND   VARCHAR(1000),
				INTERNETPLUS_IND   VARCHAR(1000),
				X1_PLATFORM   VARCHAR(1000),
				X1_PRODUCT_EFF_DT   VARCHAR(1000),
				X1_DAYS_ON_BOOKS   VARCHAR(1000),
				X1_MONTHS_ON_BOOKS   VARCHAR(1000),
				CLOUD_DVR   VARCHAR(1000),
				HSD_TIER_NAME   VARCHAR(1000),
				HSD_ECONOMY_TIER   VARCHAR(1000),
				HSD_ECONOMY_PLUS   VARCHAR(1000),
				HSD_INTERNET_ESSENTIALS   VARCHAR(1000),
				HSD_PERFORMANCE_STARTER   VARCHAR(1000),
				HSD_PERFORMANCE_TIER   VARCHAR(1000),
				HSD_BLAST   VARCHAR(1000),
				HSD_ULTRA   VARCHAR(1000),
				HSD_EXTREME_TIER   VARCHAR(1000),
				HSD_EXTREME_105   VARCHAR(1000),
				HSD_EXTREME_200   VARCHAR(1000),
				HSD_EXTREME_305   VARCHAR(1000),
				HSD_EXTREME_1000   VARCHAR(1000),
				HSD_BS_TELEWORKER_STANDARD   VARCHAR(1000),
				HSD_BS_TELEWORKER_ENHANCED   VARCHAR(1000),
				HSD_BS_TELEWORKER_PREMIUM   VARCHAR(1000),
				HSD_BS_TELEWORKER_DELUXE   VARCHAR(1000),
				HSD_BS_ECONOMY   VARCHAR(1000),
				HSD_BS_STARTER   VARCHAR(1000),
				HSD_BS_PREFERRED   VARCHAR(1000),
				HSD_BS_PREMIUM   VARCHAR(1000),
				HSD_BS_DELUXE   VARCHAR(1000),
				HSD_BS_DELUXE_25   VARCHAR(1000),
				HSD_BS_DELUXE_75   VARCHAR(1000),
				HSD_BS_DELUXE_100   VARCHAR(1000),
				HSD_BS_DELUXE_100PLUS   VARCHAR(1000),
				HSD_BS_DELUXE_150   VARCHAR(1000),
				HSD_BS_DELUXE_250   VARCHAR(1000),
				HSD_BULK   VARCHAR(1000),
				CDV_TIER_NAME   VARCHAR(1000),
				CDV_LOCAL_WITH_MORE   VARCHAR(1000),
				CDV_UNLIMITED   VARCHAR(1000),
				CDV_BUSINESS_VOICE   VARCHAR(1000),
				CDV_BULK   VARCHAR(1000),
				CDV_BV_FOUR_PLUS_LINES   VARCHAR(1000),
				CDV_BV_BASIC_LINE   VARCHAR(1000),
				CDV_BV_FULL_FEATURE_LINE   VARCHAR(1000),
				CDV_BV_TRUNK   VARCHAR(1000),
				CDV_BV_EDGE   VARCHAR(1000),
				CDV_BV_TOLL_FREE   VARCHAR(1000),
				HISPANIC_TIER   VARCHAR(1000),
				XH_TIER_NAME   VARCHAR(1000),
				XH_CONTROL100   VARCHAR(1000),
				XH_CONTROL150   VARCHAR(1000),
				XH_SECURE300   VARCHAR(1000),
				XH_SECURE350   VARCHAR(1000),
				XH_STATUS   VARCHAR(1000),
				XH_CTRL150TIER_CONTRACT_FLAG   VARCHAR(1000),
				PREMIUM_HBO   VARCHAR(1000),
				PREMIUM_SHOWTIME   VARCHAR(1000),
				PREMIUM_CINEMAX   VARCHAR(1000),
				PREMIUM_STARZ   VARCHAR(1000),
				PREMIUM_TMC   VARCHAR(1000),
				INTERNATIONAL_ARABIC   VARCHAR(1000),
				INTERNATIONAL_BRAZILIAN   VARCHAR(1000),
				INTERNATIONAL_CHINESE   VARCHAR(1000),
				INTERNATIONAL_FILIPINO   VARCHAR(1000),
				INTERNATIONAL_FRENCH   VARCHAR(1000),
				INTERNATIONAL_GERMAN   VARCHAR(1000),
				INTERNATIONAL_GREEK   VARCHAR(1000),
				INTERNATIONAL_ISRAELI   VARCHAR(1000),
				INTERNATIONAL_ITALIAN   VARCHAR(1000),
				INTERNATIONAL_JAPANESE   VARCHAR(1000),
				INTERNATIONAL_KOREAN   VARCHAR(1000),
				INTERNATIONAL_OTHER   VARCHAR(1000),
				INTERNATIONAL_POLISH   VARCHAR(1000),
				INTERNATIONAL_PORTUGUESE   VARCHAR(1000),
				INTERNATIONAL_RUSSIAN   VARCHAR(1000),
				INTERNATIONAL_SOUTHASIAN   VARCHAR(1000),
				INTERNATIONAL_VIETNAMESE   VARCHAR(1000),
				PPV_SPORTS_NHL_CENTER_ICE   VARCHAR(1000),
				PPV_SPORTS_ESPN_GAME_PLAN   VARCHAR(1000),
				PPV_SPORTS_ESPN_FULL_COURT   VARCHAR(1000),
				PPV_SPORTS_NBA_LEAGUE_PLAN   VARCHAR(1000),
				PPV_SPORTS_MLB_EXTRA_INNINGS   VARCHAR(1000),
				PPV_SPORTS_MLS_DIRECT_KICK   VARCHAR(1000),
				VIDEO_ADDON_SPORTS_TIER   VARCHAR(1000),
				VIDEO_ADDON_FAMILY_TIER   VARCHAR(1000),
				VIDEO_ADDON_TV_3D   VARCHAR(1000),
				VIDEO_ADDON_MUSIC_CHOICE   VARCHAR(1000),
				SVOD_DISNEY_FAMILY_MOVIES   VARCHAR(1000),
				SVOD_BOLLYWOOD_HITS   VARCHAR(1000),
				STREAMPIX   VARCHAR(1000),
				CALLING_PLAN   VARCHAR(1000),
				CP_LATIN_AMERICA   VARCHAR(1000),
				CP_LATIN_AMERICA_300   VARCHAR(1000),
				CP_MEXICO   VARCHAR(1000),
				CP_MEXICO_300   VARCHAR(1000),
				CP_NSE_ASIA   VARCHAR(1000),
				CP_WESTERN_EUROPE   VARCHAR(1000),
				CP_WORLDWIDE   VARCHAR(1000),
				CP_FAMILY_PLAN   VARCHAR(1000),
				VIDEO_PENETRATION_PCT   VARCHAR(1000),
				HSD_PENETRATION_PCT   VARCHAR(1000),
				CDV_PENETRATION_PCT   VARCHAR(1000),
				SUBSCRIBER_PENETRATION_PCT   VARCHAR(1000),
				EQUIP_EMTA_CNT   VARCHAR(1000),
				EQUIP_MODEM_CNT   VARCHAR(1000),
				EQUIP_ROUTER_WIRELESS_CNT   VARCHAR(1000),
				EQUIP_ROUTER_COMMERCIAL_CNT   VARCHAR(1000),
				EQUIP_WIRELESS_2_GO_CNT   VARCHAR(1000),
				EQUIP_WIRELESS_GATEWAY_CNT   VARCHAR(1000),
				EQUIP_XB3_WIRELESS_GTWY_CNT   VARCHAR(1000),
				EQUIP_CABLE_CARD_CNT   VARCHAR(1000),
				EQUIP_DTA_CNT   VARCHAR(1000),
				EQUIP_DTA_HD_CNT   VARCHAR(1000),
				EQUIP_DTA_SD_CNT   VARCHAR(1000),
				EQUIP_DVR_CNT   VARCHAR(1000),
				EQUIP_DVR_HD_CNT   VARCHAR(1000),
				EQUIP_DVR_HD_XCAL_CNT   VARCHAR(1000),
				EQUIP_DVR_HD_NON_XCAL_CNT   VARCHAR(1000),
				EQUIP_DVR_SD_CNT   VARCHAR(1000),
				EQUIP_DIG_CNT   VARCHAR(1000),
				EQUIP_DIG_HD_CNT   VARCHAR(1000),
				EQUIP_DIG_HD_XCAL_CNT   VARCHAR(1000),
				EQUIP_DIG_HD_NON_XCAL_CNT   VARCHAR(1000),
				EQUIP_DIG_SD_CNT   VARCHAR(1000),
				EQUIP_MOT_CNT   VARCHAR(1000),
				EQUIP_SA_CNT   VARCHAR(1000),
				XH_TOT_DEV_CNT   VARCHAR(1000),
				XH_PERI_CNT   VARCHAR(1000),
				XH_PERI_KP_CNT   VARCHAR(1000),
				XH_PERI_WIFI_CNT   VARCHAR(1000),
				XH_PERI_KEYFOB_CNT   VARCHAR(1000),
				XH_PERI_OTH_CNT   VARCHAR(1000),
				XH_CAM_CNT   VARCHAR(1000),
				XH_DEV_CAM_CNT   VARCHAR(1000),
				XH_CAM_OD_CNT   VARCHAR(1000),
				XH_CAM_ID_CNT   VARCHAR(1000),
				XH_DW_CNT   VARCHAR(1000),
				XH_DW_LEGACY_CNT   VARCHAR(1000),
				XH_SENSORS_DW_CNT   VARCHAR(1000),
				XH_DW_TAKEO_CNT   VARCHAR(1000),
				XH_LIGHT_CNT   VARCHAR(1000),
				XH_LIGHT_CON_CNT   VARCHAR(1000),
				XH_DEV_LIGHT_CNT   VARCHAR(1000),
				XH_MOTSENS_CNT   VARCHAR(1000),
				XH_TSTAT_CNT   VARCHAR(1000),
				XH_TOUCHSC_CNT   VARCHAR(1000),
				XH_OTH_SENS_CNT   VARCHAR(1000),
				XH_OTH_SENS_GLS_CNT   VARCHAR(1000),
				XH_OTH_SENS_CUR_CNT   VARCHAR(1000),
				XH_OTH_SENS_SMK_CNT   VARCHAR(1000),
				XH_OTH_SENS_CO_CNT   VARCHAR(1000),
				XH_OTH_SENS_FLD_CNT   VARCHAR(1000),
				EQUIP_EBIV01   VARCHAR(1000),
				EQUIP_EOL_CNT   VARCHAR(1000),
				MDM_EMTA_WGTWY_OWN_LEASE_FLAG   VARCHAR(1000),
				MRC   VARCHAR(1000),
				ACTIVE_CLV   VARCHAR(1000),
				ACTIVE_CLV_MARGIN   VARCHAR(1000),
				ACTIVE_CLV_MARGIN_SEGMENT   VARCHAR(1000),
				ACTIVE_CLV_NAT_DECILE   VARCHAR(1000),
				ACTIVE_CLV_DIV_DECILE   VARCHAR(1000),
				ACTIVE_CLV_REG_DECILE   VARCHAR(1000),
				STAR_SEGMENT   VARCHAR(1000),
				NINE_BOX_SEGMENT   VARCHAR(1000),
				AUTO_PAY_ENROLLMENT   VARCHAR(1000),
				BILL_COURTESY_IND   VARCHAR(1000),
				REVENUE_TOTAL_AMT   VARCHAR(1000),
				COST_TOTAL_AMT   VARCHAR(1000),
				MARGIN_TOTAL_AMT   VARCHAR(1000),
				MRC_RECURRING_TOTAL_AMT   VARCHAR(1000),
				MRC_RECURRING_VIDEO_AMT   VARCHAR(1000),
				MRC_RECURRING_HSD_AMT   VARCHAR(1000),
				MRC_RECURRING_CDV_AMT   VARCHAR(1000),
				MRC_RECURRING_XH_AMT   VARCHAR(1000),
				COST_RECURRING_TOTAL_AMT   VARCHAR(1000),
				COST_RECURRING_VIDEO_AMT   VARCHAR(1000),
				COST_RECURRING_HSD_AMT   VARCHAR(1000),
				COST_RECURRING_CDV_AMT   VARCHAR(1000),
				COST_RECURRING_XH_AMT   VARCHAR(1000),
				MRM_RECURRING_TOTAL_AMT   VARCHAR(1000),
				MRM_RECURRING_VIDEO_AMT   VARCHAR(1000),
				MRM_RECURRING_HSD_AMT   VARCHAR(1000),
				MRM_RECURRING_CDV_AMT   VARCHAR(1000),
				MRM_RECURRING_XH_AMT   VARCHAR(1000),
				MRM_RECURRING_TOTAL_PCT   VARCHAR(1000),
				MRM_RECURRING_VIDEO_PCT   VARCHAR(1000),
				MRM_RECURRING_HSD_PCT   VARCHAR(1000),
				MRM_RECURRING_CDV_PCT   VARCHAR(1000),
				MRM_RECURRING_XH_PCT   VARCHAR(1000),
				BALANCE_CURRENT_AMT   VARCHAR(1000),
				BALANCE_CUMULATIVE_AMT   VARCHAR(1000),
				BILL_STATEMENT_AMT   VARCHAR(1000),
				BILL_STATEMENT_DT   VARCHAR(1000),
				BILL_PAYMENT_AMT   VARCHAR(1000),
				BILL_PAYMENT_DT   VARCHAR(1000),
				BILL_PAYMENT_CYCLE   VARCHAR(1000),
				DELINQUENCY_STATUS   VARCHAR(1000),
				DELINQUENT_30_BALANCE_AMT   VARCHAR(1000),
				DELINQUENT_60_BALANCE_AMT   VARCHAR(1000),
				DELINQUENT_90_BALANCE_AMT   VARCHAR(1000),
				DELINQUENT_120_BALANCE_AMT   VARCHAR(1000),
				DELINQUENT_30_DAY_EVER   VARCHAR(1000),
				DELINQUENT_60_DAY_EVER   VARCHAR(1000),
				DELINQUENT_90_DAY_EVER   VARCHAR(1000),
				DELINQUENT_120_DAY_EVER   VARCHAR(1000),
				DELINQUENT_NUMBER_OF_TIMES   VARCHAR(1000),
				DELINQUENT_NUMBER_OF_DAYS   VARCHAR(1000),
				DELINQUENCY_LIFETIME_FLAG   VARCHAR(1000),
				WRITE_OFF   VARCHAR(1000),
				DUNNING_GROUP   VARCHAR(1000),
				INTERNAL_STATUS   VARCHAR(1000),
				PROMISE_TO_PAY_FLAG   VARCHAR(1000),
				EQUIFAX_CREDIT_SCORE   VARCHAR(1000),
				EQUIFAX_TRANS_TYPE   VARCHAR(1000),
				EQUIFAX_REASON_CODES   VARCHAR(1000),
				EQUIFAX_REJECT_CODE   VARCHAR(1000),
				EQUIFAX_HIT_CODE   VARCHAR(1000),
				EQUIFAX_MATCH_CODE   VARCHAR(1000),
				EQUIFAX_ID_SCAN   VARCHAR(1000),
				EQUIFAX_LETTER_CODE   VARCHAR(1000),
				EQUIFAX_FRAUD_WARNING   VARCHAR(1000),
				EQUIFAX_DECISION_VERBIAGE   VARCHAR(1000),
				EQUIFAX_CUSTOMER_REF_NUM   VARCHAR(1000),
				EQUIFAX_MODEL_NUMBER   VARCHAR(1000),
				EQUIFAX_EXCHANGE_INDICATOR   VARCHAR(1000),
				NSF_CHECK_COUNT   VARCHAR(1000),
				DEPOSIT_AMT   VARCHAR(1000),
				NEVER_PAY_FLAG   VARCHAR(1000),
				OFFER_NAME   VARCHAR(1000),
				OFFER_MONTHS_DURATION   VARCHAR(1000),
				MRC_NET_OFFER_AMT   VARCHAR(1000),
				OFFER_PROD_MIX_NAME   VARCHAR(1000),
				OFFER_PLAY_MIX_NAME   VARCHAR(1000),
				EBILL   VARCHAR(1000),
				SPANISH_BILL   VARCHAR(1000),
				CONTRACT_TERM_NAME   VARCHAR(1000),
				CONTRACT_START_DATE   VARCHAR(1000),
				CONTRACT_TERM_PERIOD   VARCHAR(1000),
				CON_ACCEPTANCE_CHANNEL   VARCHAR(1000),
				ETF_START_DATE   VARCHAR(1000),
				ETF_START_AMOUNT   VARCHAR(1000),
				ETF_DECLINING_AMOUNT   VARCHAR(1000),
				ETF_DECLINING_PERIOD   VARCHAR(1000),
				CONTRACT_FLAG   VARCHAR(1000),
				ETF_MONTHS_TO_GO   VARCHAR(1000),
				CONTRACT_MONTHS_TO_GO   VARCHAR(1000),
				CONTRACT_ACCEPT_STATUS   VARCHAR(1000),
				XH_CONTRACT_TERM_NAME   VARCHAR(1000),
				XH_CONTRACT_START_DATE   VARCHAR(1000),
				XH_CONTRACT_TERM_PERIOD   VARCHAR(1000),
				XH_CON_ACCEPTANCE_CHANNEL   VARCHAR(1000),
				XH_ETF_START_AMOUNT   VARCHAR(1000),
				XH_ETF_START_DATE   VARCHAR(1000),
				XH_ETF_DECLINING_AMOUNT   VARCHAR(1000),
				XH_ETF_DECLINING_PERIOD   VARCHAR(1000),
				XH_ETF_MONTHS_TO_GO   VARCHAR(1000),
				XH_CONTRACT_MONTHS_TO_GO   VARCHAR(1000),
				XH_CONTRACT_ACCEPT_STATUS   VARCHAR(1000),
				ALL_PPV_REVENUE_AMT   VARCHAR(1000),
				ALL_PPV_COST_AMT   VARCHAR(1000),
				ALL_PPV_MRM_AMT   VARCHAR(1000),
				ALL_PPV_MRM_PCT   VARCHAR(1000),
				XH_SYSTEM_UPGRADES   VARCHAR(1000),
				DISCOUNT_AMT   VARCHAR(1000),
				PACKAGE_CODES   VARCHAR(1000),
				BUNDLE_TIER   VARCHAR(1000),
				TP_BUNDLE_NAME   VARCHAR(1000),
				TP_BUNDLE_CODE   VARCHAR(1000),
				IVR_RESOLVED_TOTAL   VARCHAR(1000),
				IVR_RESOLVED_BILLING   VARCHAR(1000),
				IVR_RESOLVED_SVC   VARCHAR(1000),
				IVR_RESOLVED_SVC_VIDEO   VARCHAR(1000),
				IVR_RESOLVED_SVC_HSD   VARCHAR(1000),
				IVR_RESOLVED_SVC_CDV   VARCHAR(1000),
				IVR_RESOLVED_SVC_XH   VARCHAR(1000),
				IVR_RESOLVED_SVC_OTHER   VARCHAR(1000),
				IVR_RESOLVED_SALES   VARCHAR(1000),
				IVR_RESOLVED_RETENTION   VARCHAR(1000),
				IVR_RESOLVED_OTHER   VARCHAR(1000),
				IVR_UNRESOLVED_TOTAL   VARCHAR(1000),
				IVR_UNRESOLVED_BILLING   VARCHAR(1000),
				IVR_UNRESOLVED_SVC   VARCHAR(1000),
				IVR_UNRESOLVED_SVC_VIDEO   VARCHAR(1000),
				IVR_UNRESOLVED_SVC_HSD   VARCHAR(1000),
				IVR_UNRESOLVED_SVC_CDV   VARCHAR(1000),
				IVR_UNRESOLVED_SVC_XH   VARCHAR(1000),
				IVR_UNRESOLVED_SVC_OTHER   VARCHAR(1000),
				IVR_UNRESOLVED_SALES   VARCHAR(1000),
				IVR_UNRESOLVED_RETENTION   VARCHAR(1000),
				IVR_UNRESOLVED_OTHER   VARCHAR(1000),
				IVR_TOTAL   VARCHAR(1000),
				IVR_BILLING   VARCHAR(1000),
				IVR_SVC   VARCHAR(1000),
				IVR_SVC_VIDEO   VARCHAR(1000),
				IVR_SVC_HSD   VARCHAR(1000),
				IVR_SVC_CDV   VARCHAR(1000),
				IVR_SVC_XH   VARCHAR(1000),
				IVR_SVC_OTHER   VARCHAR(1000),
				IVR_SALES   VARCHAR(1000),
				IVR_RETENTION   VARCHAR(1000),
				IVR_OTHER   VARCHAR(1000),
				TTS_TOTAL_TICKETS   VARCHAR(1000),
				TTS_VIDEO_TICKETS   VARCHAR(1000),
				TTS_HSD_TICKETS   VARCHAR(1000),
				TTS_CDV_TICKETS   VARCHAR(1000),
				TRUCKROLL_TOTAL_CNT   VARCHAR(1000),
				TRUCKROLL_TOTAL_PTS   VARCHAR(1000),
				TRUCKROLL_TOTAL_TIH   VARCHAR(1000),
				TRUCKROLL_INSTALL_CNT   VARCHAR(1000),
				TRUCKROLL_INSTALL_PTS   VARCHAR(1000),
				TRUCKROLL_INSTALL_TIH   VARCHAR(1000),
				TRUCKROLL_SRO_CNT   VARCHAR(1000),
				TRUCKROLL_SRO_PTS   VARCHAR(1000),
				TRUCKROLL_SRO_TIH   VARCHAR(1000),
				TRUCKROLL_TC_CNT   VARCHAR(1000),
				TRUCKROLL_TC_INSTALL_PTS   VARCHAR(1000),
				TRUCKROLL_TC_INSTALL_TIH   VARCHAR(1000),
				TRUCKROLL_COS_CNT   VARCHAR(1000),
				CR_VID_SVC_PRB_CNT   VARCHAR(1000),
				CR_HSD_SVC_PRB_CNT   VARCHAR(1000),
				CR_HSD_CONN_PRB_CNT   VARCHAR(1000),
				CR_CDV_SVC_PRB_CNT   VARCHAR(1000),
				CR_CDV_FEA_PRB_CNT   VARCHAR(1000),
				CR_OTG_PRB_CNT   VARCHAR(1000),
				CR_BILLING_PRB_CNT   VARCHAR(1000),
				CR_CDV_BILLING_PRB_CNT   VARCHAR(1000),
				CR_HSD_BILLING_PRB_CNT   VARCHAR(1000),
				CR_XH_PRB_CNT   VARCHAR(1000),
				CR_BS_PRB_CNT   VARCHAR(1000),
				CR_OTHER_PRB_CNT   VARCHAR(1000),
				CR_CUST_CSE_CNT   VARCHAR(1000),
				CR_COMCAST_CSE_CNT   VARCHAR(1000),
				CR_NW_CSE_CNT   VARCHAR(1000),
				CR_BS_CSE_CNT   VARCHAR(1000),
				CR_APL_SUP_CSE_CNT   VARCHAR(1000),
				CR_HS_CSE_CNT   VARCHAR(1000),
				CR_OTHER_CSE_CNT   VARCHAR(1000),
				CR_CUST_SOL_CNT   VARCHAR(1000),
				CR_COMCAST_SOL_CNT   VARCHAR(1000),
				CR_EQUIP_SOL_CNT   VARCHAR(1000),
				CR_BS_SOL_CNT   VARCHAR(1000),
				CR_BILLING_SOL_CNT   VARCHAR(1000),
				CR_HS_SOL_CNT   VARCHAR(1000),
				CR_NO_TRB_FOUND_SOL_CNT   VARCHAR(1000),
				CR_PROV_SOL_CNT   VARCHAR(1000),
				CR_ACT_SOL_CNT   VARCHAR(1000),
				CR_OTHER_SOL_CNT   VARCHAR(1000),
				CR_AVG_TTR   VARCHAR(1000),
				SURVEYS_TAKEN   VARCHAR(1000),
				RESI_CARE_OVERALL_SAT   VARCHAR(1000),
				RESI_CARE_REP_SAT   VARCHAR(1000),
				RESI_CARE_ISSUE_RESOLVED   VARCHAR(1000),
				RESI_TECH_OVERALL_SAT   VARCHAR(1000),
				RESI_TECH_REP_SAT   VARCHAR(1000),
				RESI_TECH_SERVICE_WORKING   VARCHAR(1000),
				SVC_CNTR_OVERALL_SAT   VARCHAR(1000),
				SVC_CNTR_REP_SAT   VARCHAR(1000),
				SVC_CNTR_ISSUE_RESOLVED   VARCHAR(1000),
				BS_CARE_OVERALL_SAT   VARCHAR(1000),
				BS_CARE_REP_SAT   VARCHAR(1000),
				BS_CARE_ISSUE_RESOLVED   VARCHAR(1000),
				BS_TECH_OVERALL_SAT   VARCHAR(1000),
				BS_TECH_REP_SAT   VARCHAR(1000),
				BS_TECH_SERVICE_WORKING   VARCHAR(1000),
				TOTAL_ERONE_TICKETS   VARCHAR(1000),
				AVG_ERONE_RESOLVE_TIME_SEC   VARCHAR(1000),
				CDV_TOTAL_MIN   VARCHAR(1000),
				CDV_PLACED_MIN   VARCHAR(1000),
				CDV_RCVD_MIN   VARCHAR(1000),
				CDV_TOTAL_CNT   VARCHAR(1000),
				CDV_PLACED_CNT   VARCHAR(1000),
				CDV_RCVD_CNT   VARCHAR(1000),
				HSD_TOTAL_GB   VARCHAR(1000),
				HSD_DOWNLOAD_GB   VARCHAR(1000),
				HSD_UPLOAD_GB   VARCHAR(1000),
				WIFI_TOTAL_GB   VARCHAR(1000),
				WIFI_TOTAL_SESSIONS   VARCHAR(1000),
				LIVE_PPV_PURCHASE_CNT   VARCHAR(1000),
				LIVE_PPV_PURCHASE_AMT   VARCHAR(1000),
				VIDEO_ON_DEMAND   VARCHAR(1000),
				TOTAL_VOD_FREE_LEASE_CNT   VARCHAR(1000),
				TOTAL_VOD_PAID_LEASE_CNT   VARCHAR(1000),
				TOTAL_VOD_LEASE_AMT   VARCHAR(1000),
				TOTAL_VOD_LEASE_DURATION_MINS   VARCHAR(1000),
				ADULT_LEASE_CNT   VARCHAR(1000),
				ADULT_LEASE_DURATION_MINS   VARCHAR(1000),
				KIDS_LEASE_CNT   VARCHAR(1000),
				KIDS_LEASE_DURATION_MINS   VARCHAR(1000),
				MOVIE_LEASE_CNT   VARCHAR(1000),
				MOVIE_LEASE_DURATION_MINS   VARCHAR(1000),
				MUSIC_LEASE_CNT   VARCHAR(1000),
				MUSIC_LEASE_DURATION_MINS   VARCHAR(1000),
				NON_MUSIC_LEASE_CNT   VARCHAR(1000),
				NON_MUSIC_LEASE_DURATION_MINS   VARCHAR(1000),
				EST_TOTAL_PURCHASE_AMT   VARCHAR(1000),
				EST_MOVIE_PURCHASE_AMT   VARCHAR(1000),
				EST_SERIES_PURCHASE_AMT   VARCHAR(1000),
				EST_TOTAL_PURCHASE_CNT   VARCHAR(1000),
				EST_MOVIE_PURCHASE_CNT   VARCHAR(1000),
				EST_SERIES_PURCHASE_CNT   VARCHAR(1000),
				TOT_VIEWING_SEC   VARCHAR(1000),
				TOT_LINEAR_VIEW_SEC   VARCHAR(1000),
				TOT_DVR_VIEW_SEC   VARCHAR(1000),
				TOT_VOD_VIEW_SEC   VARCHAR(1000),
				BA_VIEWING_SEC   VARCHAR(1000),
				BA_LINEAR_VIEW_SEC   VARCHAR(1000),
				BA_DVR_VIEW_SEC   VARCHAR(1000),
				BA_VOD_VIEW_SEC   VARCHAR(1000),
				X1_VIEWING_SEC   VARCHAR(1000),
				X1_LINEAR_VIEW_SEC   VARCHAR(1000),
				X1_DVR_VIEW_SEC   VARCHAR(1000),
				X1_VOD_VIEW_SEC   VARCHAR(1000),
				TOT_CHANNEL_CNT   VARCHAR(1000),
				TOT_LINEAR_CHAN_CNT   VARCHAR(1000),
				TOT_DVR_PLAYBACK_CNT   VARCHAR(1000),
				TOT_VOD_PLAYBACK_CNT   VARCHAR(1000),
				BA_LINEAR_CHAN_CNT   VARCHAR(1000),
				BA_DVR_PLAYBACK_CNT   VARCHAR(1000),
				BA_VOD_PLAYBACK_CNT   VARCHAR(1000),
				X1_LINEAR_CHAN_CNT   VARCHAR(1000),
				X1_DVR_PLAYBACK_CNT   VARCHAR(1000),
				X1_VOD_PLAYBACK_CNT   VARCHAR(1000),
				TOT_PROGRAM_CNT   VARCHAR(1000),
				TOT_LINEAR_PROGRAM_CNT   VARCHAR(1000),
				TOT_DVR_PROGRAM_CNT   VARCHAR(1000),
				TOT_VOD_PROGRAMS_CNT   VARCHAR(1000),
				BA_LINEAR_PROGRAM_CNT   VARCHAR(1000),
				BA_DVR_PROGRAM_CNT   VARCHAR(1000),
				BA_VOD_PROGRAM_CNT   VARCHAR(1000),
				X1_LINEAR_PROGRAM_CNT   VARCHAR(1000),
				X1_DVR_PROGRAM_CNT   VARCHAR(1000),
				X1_VOD_PROGRAM_CNT   VARCHAR(1000),
				DESKTOP_LOGINS   VARCHAR(1000),
				MOBILE_WEB_LOGINS   VARCHAR(1000),
				MOBILE_APP_LOGINS   VARCHAR(1000),
				USE_SELF_SERVICE_ANY   VARCHAR(1000),
				USE_SELF_SERVICE_ALL   VARCHAR(1000),
				USE_SELF_SERVICE_DESKTOP   VARCHAR(1000),
				USE_SELF_SERVICE_MOBILE_WEB   VARCHAR(1000),
				USE_SELF_SERVICE_MOBILE_APP   VARCHAR(1000),
				FIRST_SALES_CHANNEL_GROUP   VARCHAR(1000),
				FIRST_SALES_CHANNEL   VARCHAR(1000),
				FIRST_SALES_ID   VARCHAR(1000),
				FIRST_OPERATOR_ID   VARCHAR(1000),
				VIDEO_SALES_CHANNEL_GROUP   VARCHAR(1000),
				VIDEO_SALES_CHANNEL   VARCHAR(1000),
				VIDEO_SALES_ID   VARCHAR(1000),
				VIDEO_OPERATOR_ID   VARCHAR(1000),
				HSD_SALES_CHANNEL_GROUP   VARCHAR(1000),
				HSD_SALES_CHANNEL   VARCHAR(1000),
				HSD_SALES_ID   VARCHAR(1000),
				HSD_OPERATOR_ID   VARCHAR(1000),
				CDV_SALES_CHANNEL_GROUP   VARCHAR(1000),
				CDV_SALES_CHANNEL   VARCHAR(1000),
				CDV_SALES_ID   VARCHAR(1000),
				CDV_OPERATOR_ID   VARCHAR(1000),
				XH_SALES_CHANNEL_GROUP   VARCHAR(1000),
				XH_SALES_CHANNEL   VARCHAR(1000),
				XH_SALES_ID   VARCHAR(1000),
				XH_OPERATOR_ID   VARCHAR(1000),
				CUSTOMER_CONNECT   VARCHAR(1000),
				CUSTOMER_CONNECT_DT   VARCHAR(1000),
				CUSTOMER_DISCONNECT   VARCHAR(1000),
				CUSTOMER_DISCONNECT_DT   VARCHAR(1000),
				CUSTOMER_DISCONNECT_NP   VARCHAR(1000),
				CUSTOMER_DISCONNECT_VOL   VARCHAR(1000),
				CUST_DISCON_REASON_NAME   VARCHAR(1000),
				CUST_DISCON_REASON_GROUP   VARCHAR(1000),
				CUSTOMER_UPGRADE   VARCHAR(1000),
				CUSTOMER_UPGRADE_DT   VARCHAR(1000),
				CUSTOMER_DOWNGRADE   VARCHAR(1000),
				CUSTOMER_DOWNGRADE_DT   VARCHAR(1000),
				VIDEO_CONNECT   VARCHAR(1000),
				VIDEO_CONNECT_DT   VARCHAR(1000),
				VIDEO_DISCONNECT   VARCHAR(1000),
				VIDEO_DISCONNECT_DT   VARCHAR(1000),
				HSD_CONNECT   VARCHAR(1000),
				HSD_CONNECT_DT   VARCHAR(1000),
				HSD_DISCONNECT   VARCHAR(1000),
				HSD_DISCONNECT_DT   VARCHAR(1000),
				CDV_CONNECT   VARCHAR(1000),
				CDV_CONNECT_DT   VARCHAR(1000),
				CDV_DISCONNECT   VARCHAR(1000),
				CDV_DISCONNECT_DT   VARCHAR(1000),
				XH_CONNECT   VARCHAR(1000),
				XH_CONNECT_DT   VARCHAR(1000),
				XH_DISCONNECT   VARCHAR(1000),
				XH_DISCONNECT_DT   VARCHAR(1000),
				XH_RULE_CNT   VARCHAR(1000),
				XH_ARM_RUL_CNT   VARCHAR(1000),
				XH_THERMOSTAT_RUL_CNT   VARCHAR(1000),
				XH_CO_RUL_CNT   VARCHAR(1000),
				XH_WATER_SEN_RUL_CNT   VARCHAR(1000),
				XH_CAM_RUL_CNT   VARCHAR(1000),
				XH_DW_RUL_CNT   VARCHAR(1000),
				XH_MOTION_RUL_CNT   VARCHAR(1000),
				XH_LIGHTING_RUL_CNT   VARCHAR(1000),
				CUST_DISCON_REF_CD   VARCHAR(1000),
				CUST_DISCON_REF_DESC   VARCHAR(1000),
				VIDEO_SIK   VARCHAR(1000),
				HSD_SIK   VARCHAR(1000),
				CDV_SIK   VARCHAR(1000),
				XH_SIK   VARCHAR(1000),
				ANY_SIK   VARCHAR(1000),
				SOURCE_CUSTOMER_ACCOUNT_ID   VARCHAR(1000),
				SOURCE_ACCOUNT_NUMBER   VARCHAR(1000),
				SOURCE_LOCATION_ID   VARCHAR(1000),
				SOURCE_DISCO_DT   VARCHAR(1000),
				DEST_CUSTOMER_ACCOUNT_ID   VARCHAR(1000),
				DEST_ACCOUNT_NUMBER   VARCHAR(1000),
				DEST_LOCATION_ID   VARCHAR(1000),
				DEST_CONNECT_DT   VARCHAR(1000),
				MOVE_SOURCE   VARCHAR(1000),
				TRANSFER_STATUS   VARCHAR(1000),
				ONBOARDING_SALES_CHANNEL_GROUP   VARCHAR(1000),
				ONBOARDING_SALES_CHANNEL   VARCHAR(1000),
				DEMO_HISPANIC_IND   VARCHAR(1000),
				DEMO_HISPANIC_ACCULTURATION   VARCHAR(1000),
				DEMO_HOME_OWN_RENT   VARCHAR(1000),
				DEMO_LEN_OF_RES   VARCHAR(1000),
				DEMO_DW_TYPE   VARCHAR(1000),
				DEMO_MARITAL_STATUS   VARCHAR(1000),
				DEMO_FIRST_INDV_GENDER   VARCHAR(1000),
				DEMO_SECOND_INDV_GENDER   VARCHAR(1000),
				DEMO_INCOME_CODE   VARCHAR(1000),
				DEMO_FIRST_INDV_EDU   VARCHAR(1000),
				DEMO_CHILDREN_NUM_HH   VARCHAR(1000),
				DEMO_AVG_HH_SIZE   VARCHAR(1000),
				DEMO_NUM_ADULTS_LIVING_UNIT   VARCHAR(1000),
				DEMO_FIRST_INDV_AGE   VARCHAR(1000),
				DEMO_SECOND_INDV_AGE   VARCHAR(1000),
				DEMO_SEC_INDV_EDU   VARCHAR(1000),
				DEMO_GEO_HISPANICITY   VARCHAR(1000),
				DEMO_COMP_FOOTPRINT   VARCHAR(1000),
				DEMO_FIBER   VARCHAR(1000),
				DEMO_OCN   VARCHAR(1000),
				DEMO_OCN_NAME   VARCHAR(1000),
				BLOCK_ID   VARCHAR(1000),
				CBG   VARCHAR(1000),
				CIC   VARCHAR(1000),
				CLEC   VARCHAR(1000),
				FIBER_DATE   VARCHAR(1000),
				FIPS_COUNTY_CODE   VARCHAR(1000),
				FIPS_STATE_CODE   VARCHAR(1000),
				LATA   VARCHAR(1000),
				LATA_SUB_ZONE   VARCHAR(1000),
				LEADING_TELCO   VARCHAR(1000),
				MATCH_LEVEL   VARCHAR(1000),
				NPA   VARCHAR(1000),
				NPA_LOCATION   VARCHAR(1000),
				NXX   VARCHAR(1000),
				PLACE_NAME   VARCHAR(1000),
				PORTABILITY_IND   VARCHAR(1000),
				RATE_CENTER   VARCHAR(1000),
				RATE_CENTER_TYPE   VARCHAR(1000),
				SWITCH_CLLI   VARCHAR(1000),
				TROLL_DATE   VARCHAR(1000),
				OB1_HOLDING_COMPANY_NUMBER   VARCHAR(1000),
				OB1_HOLDING_COMPANY_NAME   VARCHAR(1000),
				OB1_PROVIDER_NAME   VARCHAR(1000),
				OB1_DBA_NAME   VARCHAR(1000),
				OB1_GENERIC_NAME   VARCHAR(1000),
				OB1_TYPE   VARCHAR(1000),
				OB1_TRIPLEPLAY_FLAG   VARCHAR(1000),
				OB1_MAX_ADVERTISED_DL_SPEED   VARCHAR(1000),
				OB1_MAX_ADVERTISED_UL_SPEED   VARCHAR(1000),
				OB2_HOLDING_COMPANY_NUMBER   VARCHAR(1000),
				OB2_HOLDING_COMPANY_NAME   VARCHAR(1000),
				OB2_PROVIDER_NAME   VARCHAR(1000),
				OB2_DBA_NAME   VARCHAR(1000),
				OB2_GENERIC_NAME   VARCHAR(1000),
				OB2_TYPE   VARCHAR(1000),
				OB2_TRIPLEPLAY_FLAG   VARCHAR(1000),
				OB2_MAX_ADVERTISED_DL_SPEED   VARCHAR(1000),
				OB2_MAX_ADVERTISED_UL_SPEED   VARCHAR(1000),
				OB3_HOLDING_COMPANY_NUMBER   VARCHAR(1000),
				OB3_HOLDING_COMPANY_NAME   VARCHAR(1000),
				OB3_PROVIDER_NAME   VARCHAR(1000),
				OB3_DBA_NAME   VARCHAR(1000),
				OB3_GENERIC_NAME   VARCHAR(1000),
				OB3_TYPE   VARCHAR(1000),
				OB3_TRIPLEPLAY_FLAG   VARCHAR(1000),
				OB3_MAX_ADVERTISED_DL_SPEED   VARCHAR(1000),
				OB3_MAX_ADVERTISED_UL_SPEED   VARCHAR(1000),
				OB4_HOLDING_COMPANY_NUMBER   VARCHAR(1000),
				OB4_HOLDING_COMPANY_NAME   VARCHAR(1000),
				OB4_PROVIDER_NAME   VARCHAR(1000),
				OB4_DBA_NAME   VARCHAR(1000),
				OB4_GENERIC_NAME   VARCHAR(1000),
				OB4_TYPE   VARCHAR(1000),
				OB4_TRIPLEPLAY_FLAG   VARCHAR(1000),
				OB4_MAX_ADVERTISED_DL_SPEED   VARCHAR(1000),
				OB4_MAX_ADVERTISED_UL_SPEED   VARCHAR(1000),
				CENTURYLNK_INTERNET   VARCHAR(1000),
				CENTURYLNK_INTERNET_ANNOUNCED   VARCHAR(1000),
				CENTURYLNK_INTERNET_SPEED   VARCHAR(1000),
				CENTURYLNK_INT_ANNOUNCED_DATE   VARCHAR(1000),
				CENTURYLNK_INT_DATE_DETERMINED   VARCHAR(1000),
				CENTURYLNK_PRISM   VARCHAR(1000),
				CENTURYLNK_PRISM_ANNOUNCED   VARCHAR(1000),
				CENTURYLNK_PRISM_ANNOUNCE_DATE   VARCHAR(1000),
				CENTURYLNK_PRISM_DATE_DETERMIN   VARCHAR(1000),
				CENTURYLNK_PRISM_TROLLED_DATE   VARCHAR(1000),
				FIOS_INTERNET   VARCHAR(1000),
				FIOS_INTERNET_ANNOUNCED   VARCHAR(1000),
				FIOS_INTERNET_ANNOUNCED_DATE   VARCHAR(1000),
				FIOS_INTERNET_DATE_DETERMINED   VARCHAR(1000),
				FIOS_INTERNET_MATCH_LEVEL   VARCHAR(1000),
				FIOS_TROLLED_DATE   VARCHAR(1000),
				FIOS_TV   VARCHAR(1000),
				FIOS_TV_ANNOUNCED   VARCHAR(1000),
				FIOS_TV_ANNOUNCED_DATE   VARCHAR(1000),
				FIOS_TV_DATE_DETERMINED   VARCHAR(1000),
				FIOS_TV_MATCH_LEVEL   VARCHAR(1000),
				FRONTIER_INTERNET   VARCHAR(1000),
				FRONTIER_INTERNET_ANNOUNCED   VARCHAR(1000),
				FRONTIER_INTERNET_MATCH_LEVEL   VARCHAR(1000),
				FRONTIER_INT_ANNOUNCED_DATE   VARCHAR(1000),
				FRONTIER_INT_DATE_DETERMINED   VARCHAR(1000),
				FRONTIER_TROLLED_DATE   VARCHAR(1000),
				FRONTIER_TV   VARCHAR(1000),
				FRONTIER_TV_ANNOUNCED   VARCHAR(1000),
				FRONTIER_TV_ANNOUNCED_DATE   VARCHAR(1000),
				FRONTIER_TV_DATE_DETERMINED   VARCHAR(1000),
				FRONTIER_TV_MATCH_LEVEL   VARCHAR(1000),
				UVERSE   VARCHAR(1000),
				UVERSE_ANNOUNCED   VARCHAR(1000),
				UVERSE_ANNOUNCED_DATE   VARCHAR(1000),
				UVERSE_DATE_DETERMINED   VARCHAR(1000),
				UVERSE_INTERNET   VARCHAR(1000),
				UVERSE_MATCH_LEVEL   VARCHAR(1000),
				UVERSE_TROLLED_DATE   VARCHAR(1000),
				GENERATIONAL_KNOWN_SEG   VARCHAR(1000),
				GENERATIONAL_BACKFILL_SEG   VARCHAR(1000),
				CALC_MRC_MIN_03_MO   VARCHAR(1000),
				CALC_MRC_MAX_03_MO   VARCHAR(1000),
				CALC_MRC_AVG_03_MO   VARCHAR(1000),
				CALC_MRC_RANGE_03_MO   VARCHAR(1000),
				CALC_MRC_MMR_03_MO   VARCHAR(1000),
				CALC_MRC_MIN_06_MO   VARCHAR(1000),
				CALC_MRC_MAX_06_MO   VARCHAR(1000),
				CALC_MRC_AVG_06_MO   VARCHAR(1000),
				CALC_MRC_RANGE_06_MO   VARCHAR(1000),
				CALC_MRC_MMR_06_MO   VARCHAR(1000),
				CALC_MRC_MIN_12_MO   VARCHAR(1000),
				CALC_MRC_MAX_12_MO   VARCHAR(1000),
				CALC_MRC_AVG_12_MO   VARCHAR(1000),
				CALC_MRC_RANGE_12_MO   VARCHAR(1000),
				CALC_MRC_MMR_12_MO   VARCHAR(1000),
				CALC_MRC_CURR_MONTH   VARCHAR(1000),
				CALC_MRC_MONTH_01   VARCHAR(1000),
				CALC_MRC_MONTH_02   VARCHAR(1000),
				CALC_MRC_MONTH_03   VARCHAR(1000),
				CALC_MRC_MONTH_04   VARCHAR(1000),
				CALC_MRC_MONTH_05   VARCHAR(1000),
				CALC_MRC_MONTH_06   VARCHAR(1000),
				CALC_MRC_MONTH_07   VARCHAR(1000),
				CALC_MRC_MONTH_08   VARCHAR(1000),
				CALC_MRC_MONTH_09   VARCHAR(1000),
				CALC_MRC_MONTH_10   VARCHAR(1000),
				CALC_MRC_MONTH_11   VARCHAR(1000),
				PREV_RGU_VIDEO   VARCHAR(1000),
				PREV_RGU_HSD   VARCHAR(1000),
				PREV_RGU_CDV   VARCHAR(1000),
				PREV_RGU_XH   VARCHAR(1000),
				PREV_RGU_BULK_VIDEO   VARCHAR(1000),
				PREV_RGU_BULK_HSD   VARCHAR(1000),
				PREV_RGU_BULK_CDV   VARCHAR(1000),
				PREV_NUMBER_OF_PRODUCTS   VARCHAR(1000),
				PREV_PRODUCT_MIX   VARCHAR(1000),
				PREV_VIDEO_TIER_NAME   VARCHAR(1000),
				PREV_HSD_TIER_NAME   VARCHAR(1000),
				PREV_CDV_TIER_NAME   VARCHAR(1000),
				PREV_XH_TIER_NAME   VARCHAR(1000),
				NXTMO_DISCO_MONTH_END_DT   VARCHAR(1000),
				NXTMO_CUSTOMER_DISCONNECT   VARCHAR(1000),
				NXTMO_CUSTOMER_DISCONNECT_DT   VARCHAR(1000),
				NXTMO_CUSTOMER_DISCONNECT_NP   VARCHAR(1000),
				NXTMO_CUSTOMER_DISCONNECT_VOL   VARCHAR(1000),
				NXTMO_CUST_DISCON_REASON_NAME   VARCHAR(1000),
				NXTMO_CUST_DISCON_REASON_GROUP   VARCHAR(1000),
				NXTMO_VIDEO_DISCONNECT   VARCHAR(1000),
				NXTMO_VIDEO_DISCONNECT_DT   VARCHAR(1000),
				NXTMO_HSD_DISCONNECT   VARCHAR(1000),
				NXTMO_HSD_DISCONNECT_DT   VARCHAR(1000),
				NXTMO_CDV_DISCONNECT   VARCHAR(1000),
				NXTMO_CDV_DISCONNECT_DT   VARCHAR(1000),
				NXTMO_XH_DISCONNECT   VARCHAR(1000),
				NXTMO_XH_DISCONNECT_DT   VARCHAR(1000),
				MONTHS_SINCE_LAST_HAD_VIDEO   VARCHAR(1000),
				MONTHS_SINCE_LAST_HAD_HSD   VARCHAR(1000),
				MONTHS_SINCE_LAST_HAD_CDV   VARCHAR(1000),
				MONTHS_SINCE_LAST_HAD_XH   VARCHAR(1000),
				CUSTOMER_SEGMENT_ID   VARCHAR(1000),
				CUSTOMER_SEGMENT_NAME   VARCHAR(1000),
				CHURN_VOL_SCORE   VARCHAR(1000),
				CHURN_VOL_DECILE   VARCHAR(1000),
				CHURN_VOL_SEGMENT   VARCHAR(1000),
				CHURN_NPD_SCORE   VARCHAR(1000),
				CHURN_NPD_DECILE   VARCHAR(1000),
				CHURN_NPD_SEGMENT   VARCHAR(1000),
				TP_ACQ_SCORE   VARCHAR(1000),
				TP_ACQ_NAT_DECILE   VARCHAR(1000),
				TP_ACQ_DIV_DECILE   VARCHAR(1000),
				TP_ACQ_REG_DECILE   VARCHAR(1000),
				TP_UPG_SCORE   VARCHAR(1000),
				TP_UPG_NAT_DECILE   VARCHAR(1000),
				TP_UPG_DIV_DECILE   VARCHAR(1000),
				TP_UPG_REG_DECILE   VARCHAR(1000),
				COMPLETE_CHURN_SCORE   VARCHAR(1000),
				COMPLETE_CHURN_NAT_DECILE   VARCHAR(1000),
				COMPLETE_CHURN_DIV_DECILE   VARCHAR(1000),
				COMPLETE_CHURN_REG_DECILE   VARCHAR(1000),
				SUB_BAD_DEBT_SCORE   VARCHAR(1000),
				SUB_BAD_DEBT_NAT_DECILE   VARCHAR(1000),
				SUB_BAD_DEBT_DIV_DECILE   VARCHAR(1000),
				SUB_BAD_DEBT_REG_DECILE   VARCHAR(1000),
				FIBER_DEFECTOR_SCORE   VARCHAR(1000),
				FIBER_DEFECTOR_NAT_DECILE   VARCHAR(1000),
				FIBER_DEFECTOR_DIV_DECILE   VARCHAR(1000),
				FIBER_DEFECTOR_REG_DECILE   VARCHAR(1000),
				CHSI_DWNGRD_SCORE   VARCHAR(1000),
				CHSI_DWNGRD_NAT_DECILE   VARCHAR(1000),
				CHSI_DWNGRD_DIV_DECILE   VARCHAR(1000),
				CHSI_DWNGRD_REG_DECILE   VARCHAR(1000),
				CDV_DWNGRD_SCORE   VARCHAR(1000),
				CDV_DWNGRD_NAT_DECILE   VARCHAR(1000),
				CDV_DWNGRD_DIV_DECILE   VARCHAR(1000),
				CDV_DWNGRD_REG_DECILE   VARCHAR(1000),
				NONSUB_BAD_DEBT_SCORE   VARCHAR(1000),
				NONSUB_BAD_DEBT_NAT_DECILE   VARCHAR(1000),
				NONSUB_BAD_DEBT_DIV_DECILE   VARCHAR(1000),
				NONSUB_BAD_DEBT_REG_DECILE   VARCHAR(1000),
				DIGVID_XSELL_SCORE   VARCHAR(1000),
				DIGVID_XSELL_NAT_DECILE   VARCHAR(1000),
				DIGVID_XSELL_DIV_DECILE   VARCHAR(1000),
				DIGVID_XSELL_REG_DECILE   VARCHAR(1000),
				CHSI_XSELL_SCORE   VARCHAR(1000),
				CHSI_XSELL_NAT_DECILE   VARCHAR(1000),
				CHSI_XSELL_DIV_DECILE   VARCHAR(1000),
				CHSI_XSELL_REG_DECILE   VARCHAR(1000),
				CDV_XSELL_SCORE   VARCHAR(1000),
				CDV_XSELL_NAT_DECILE   VARCHAR(1000),
				CDV_XSELL_DIV_DECILE   VARCHAR(1000),
				CDV_XSELL_REG_DECILE   VARCHAR(1000),
				DIGVID_ACQ_SCORE   VARCHAR(1000),
				DIGVID_ACQ_NAT_DECILE   VARCHAR(1000),
				DIGVID_ACQ_DIV_DECILE   VARCHAR(1000),
				DIGVID_ACQ_REG_DECILE   VARCHAR(1000),
				HDTV_ACQ_SCORE   VARCHAR(1000),
				HDTV_ACQ_NAT_DECILE   VARCHAR(1000),
				HDTV_ACQ_DIV_DECILE   VARCHAR(1000),
				HDTV_ACQ_REG_DECILE   VARCHAR(1000),
				HDTV_UPG_SCORE   VARCHAR(1000),
				HDTV_UPG_NAT_DECILE   VARCHAR(1000),
				HDTV_UPG_DIV_DECILE   VARCHAR(1000),
				HDTV_UPG_REG_DECILE   VARCHAR(1000),
				WIRELESS_ONLY_ACX_IND   VARCHAR(1000),
				WIRELESS_ONLY_TNS_PROB   VARCHAR(1000),
				WIRELESS_ONLY_TNS_DECILE   VARCHAR(1000),
				WIRELESS_ONLY_TNS_INDEX   VARCHAR(1000),
				NONSUB_FIBER_OWNER_SCORE   VARCHAR(1000),
				NONSUB_FIBER_OWNER_NAT_DECILE   VARCHAR(1000),
				NONSUB_FIBER_OWNER_DIV_DECILE   VARCHAR(1000),
				NONSUB_FIBER_OWNER_REG_DECILE   VARCHAR(1000),
				NONSUB_DBS_OWNER_SCORE   VARCHAR(1000),
				NONSUB_DBS_OWNER_NAT_DECILE   VARCHAR(1000),
				NONSUB_DBS_OWNER_DIV_DECILE   VARCHAR(1000),
				NONSUB_DBS_OWNER_REG_DECILE   VARCHAR(1000),
				NONSUB_HSD_OWNER_SCORE   VARCHAR(1000),
				NONSUB_HSD_OWNER_NAT_DECILE   VARCHAR(1000),
				NONSUB_HSD_OWNER_DIV_DECILE   VARCHAR(1000),
				NONSUB_HSD_OWNER_REG_DECILE   VARCHAR(1000),
				CHSI_ACQ_SCORE   VARCHAR(1000),
				CHSI_ACQ_NAT_DECILE   VARCHAR(1000),
				CHSI_ACQ_DIV_DECILE   VARCHAR(1000),
				CHSI_ACQ_REG_DECILE   VARCHAR(1000),
				CDV_ACQ_SCORE   VARCHAR(1000),
				CDV_ACQ_NAT_DECILE   VARCHAR(1000),
				CDV_ACQ_DIV_DECILE   VARCHAR(1000),
				CDV_ACQ_REG_DECILE   VARCHAR(1000),
				DVR_ACQ_SCORE   VARCHAR(1000),
				DVR_ACQ_NAT_DECILE   VARCHAR(1000),
				DVR_ACQ_DIV_DECILE   VARCHAR(1000),
				DVR_ACQ_REG_DECILE   VARCHAR(1000),
				DVR_UPG_SCORE   VARCHAR(1000),
				DVR_UPG_NAT_DECILE   VARCHAR(1000),
				DVR_UPG_DIV_DECILE   VARCHAR(1000),
				DVR_UPG_REG_DECILE   VARCHAR(1000),
				DIGVID_UPG_SCORE   VARCHAR(1000),
				DIGVID_UPG_NAT_DECILE   VARCHAR(1000),
				DIGVID_UPG_DIV_DECILE   VARCHAR(1000),
				DIGVID_UPG_REG_DECILE   VARCHAR(1000),
				PREM_SVC_UPG_SCORE   VARCHAR(1000),
				PREM_SVC_UPG_NAT_DECILE   VARCHAR(1000),
				PREM_SVC_UPG_DIV_DECILE   VARCHAR(1000),
				PREM_SVC_UPG_REG_DECILE   VARCHAR(1000),
				CMCST_MICRO_SEG   VARCHAR(1000),
				CMCST_SUPER_SEG   VARCHAR(1000),
				NONSUB_OTM_RES_SCORE   VARCHAR(1000),
				NONSUB_OTM_RES_NAT_DECILE   VARCHAR(1000),
				NONSUB_OTM_RES_DIV_DECILE   VARCHAR(1000),
				NONSUB_OTM_RES_REG_DECILE   VARCHAR(1000),
				CLV_SCORE   VARCHAR(1000),
				CLV_NAT_DECILE   VARCHAR(1000),
				CLV_DIV_DECILE   VARCHAR(1000),
				CLV_REG_DECILE   VARCHAR(1000),
				DM_SUB_SCORE   VARCHAR(1000),
				DM_SUB_NAT_DECILE   VARCHAR(1000),
				DM_SUB_DIV_DECILE   VARCHAR(1000),
				DM_SUB_REG_DECILE   VARCHAR(1000),
				DM_NONSUB_SCORE   VARCHAR(1000),
				DM_NONSUB_NAT_DECILE   VARCHAR(1000),
				DM_NONSUB_DIV_DECILE   VARCHAR(1000),
				DM_NONSUB_REG_DECILE   VARCHAR(1000),
				SUB_OTM_RES_SCORE   VARCHAR(1000),
				SUB_OTM_RES_NAT_DECILE   VARCHAR(1000),
				SUB_OTM_RES_DIV_DECILE   VARCHAR(1000),
				SUB_OTM_RES_REG_DECILE   VARCHAR(1000),
				SUB_DBS_OWNER_SCORE   VARCHAR(1000),
				SUB_DBS_OWNER_NAT_DECILE   VARCHAR(1000),
				SUB_DBS_OWNER_DIV_DECILE   VARCHAR(1000),
				SUB_DBS_OWNER_REG_DECILE   VARCHAR(1000),
				SUB_FIBER_OWNER_SCORE   VARCHAR(1000),
				SUB_FIBER_OWNER_NAT_DECILE   VARCHAR(1000),
				SUB_FIBER_OWNER_DIV_DECILE   VARCHAR(1000),
				SUB_FIBER_OWNER_REG_DECILE   VARCHAR(1000),
				NCLV_SCORE   VARCHAR(1000),
				NCLV_NAT_DECILE   VARCHAR(1000),
				NCLV_DIV_DECILE   VARCHAR(1000),
				NCLV_REG_DECILE   VARCHAR(1000),
				VID_HSD_ACQ_SCORE   VARCHAR(1000),
				VID_HSD_ACQ_NAT_DECILE   VARCHAR(1000),
				VID_HSD_ACQ_DIV_DECILE   VARCHAR(1000),
				VID_HSD_ACQ_REG_DECILE   VARCHAR(1000),
				ALL_VALUE_SCORE   VARCHAR(1000),
				ALL_VALUE_NAT_DECILE   VARCHAR(1000),
				ALL_VALUE_DIV_DECILE   VARCHAR(1000),
				ALL_VALUE_REG_DECILE   VARCHAR(1000),
				XH_ACQ_SCORE   VARCHAR(1000),
				XH_ACQ_NAT_DECILE   VARCHAR(1000),
				XH_ACQ_DIV_DECILE   VARCHAR(1000),
				XH_ACQ_REG_DECILE   VARCHAR(1000),
				XH_UPG_SCORE   VARCHAR(1000),
				XH_UPG_NAT_DECILE   VARCHAR(1000),
				XH_UPG_DIV_DECILE   VARCHAR(1000),
				XH_UPG_REG_DECILE   VARCHAR(1000),
				MICRO_SEG_ID   VARCHAR(1000),
				SUPER_SEG_ID   VARCHAR(1000),
				RETIRE_MICRO_SEG   VARCHAR(1000),
				RETIRE_SUPER_SEG   VARCHAR(1000),
				DIGVID_PREFER_UPG_SCORE   VARCHAR(1000),
				DIGVID_PREFER_UPG_NAT_DECILE   VARCHAR(1000),
				DIGVID_PREFER_UPG_DIV_DECILE   VARCHAR(1000),
				DIGVID_PREFER_UPG_REG_DECILE   VARCHAR(1000),
				TP_HIVAL_ACQ_SCORE   VARCHAR(1000),
				TP_HIVAL_ACQ_NAT_DECILE   VARCHAR(1000),
				TP_HIVAL_ACQ_DIV_DECILE   VARCHAR(1000),
				TP_HIVAL_ACQ_REG_DECILE   VARCHAR(1000),
				TP_HIVAL_UPG_SCORE   VARCHAR(1000),
				TP_HIVAL_UPG_NAT_DECILE   VARCHAR(1000),
				TP_HIVAL_UPG_DIV_DECILE   VARCHAR(1000),
				TP_HIVAL_UPG_REG_DECILE   VARCHAR(1000),
				TP_LOWVAL_ACQ_SCORE   VARCHAR(1000),
				TP_LOWVAL_ACQ_NAT_DECILE   VARCHAR(1000),
				TP_LOWVAL_ACQ_DIV_DECILE   VARCHAR(1000),
				TP_LOWVAL_ACQ_REG_DECILE   VARCHAR(1000),
				TP_LOWVAL_UPG_SCORE   VARCHAR(1000),
				TP_LOWVAL_UPG_NAT_DECILE   VARCHAR(1000),
				TP_LOWVAL_UPG_DIV_DECILE   VARCHAR(1000),
				TP_LOWVAL_UPG_REG_DECILE   VARCHAR(1000),
				NONSUB_DIALUP_OWNER_SCORE   VARCHAR(1000),
				NONSUB_DIALUP_OWNER_NAT_DECILE   VARCHAR(1000),
				NONSUB_DIALUP_OWNER_DIV_DECILE   VARCHAR(1000),
				NONSUB_DIALUP_OWNER_REG_DECILE   VARCHAR(1000),
				SUB_DIALUP_OWNER_SCORE   VARCHAR(1000),
				SUB_DIALUP_OWNER_NAT_DECILE   VARCHAR(1000),
				SUB_DIALUP_OWNER_DIV_DECILE   VARCHAR(1000),
				SUB_DIALUP_OWNER_REG_DECILE   VARCHAR(1000),
				VZW_UPG_SCORE   VARCHAR(1000),
				VZW_UPG_NAT_DECILE   VARCHAR(1000),
				VZW_UPG_DIV_DECILE   VARCHAR(1000),
				VZW_UPG_REG_DECILE   VARCHAR(1000),
				MOVERS_SCORE   VARCHAR(1000),
				MOVERS_NAT_DECILE   VARCHAR(1000),
				MOVERS_DIV_DECILE   VARCHAR(1000),
				MOVERS_REG_DECILE   VARCHAR(1000),
				CHURN_TOTAL_SCORE   VARCHAR(1000),
				CHURN_TOTAL_DECILE   VARCHAR(1000),
				CHURN_TOTAL_SEGMENT   VARCHAR(1000),
				CHURN_TOTAL_DECILE_DIV   VARCHAR(1000),
				CHURN_TOTAL_DECILE_REG   VARCHAR(1000),
				CHURN_VOL_DECILE_DIV   VARCHAR(1000),
				CHURN_VOL_DECILE_REG   VARCHAR(1000),
				CHURN_NPD_DECILE_DIV   VARCHAR(1000),
				CHURN_NPD_DECILE_REG   VARCHAR(1000),
				DOWNGRADE_VIDEO_SCORE   VARCHAR(1000),
				DOWNGRADE_VIDEO_DECILE   VARCHAR(1000),
				DOWNGRADE_VIDEO_SEGMENT   VARCHAR(1000),
				DOWNGRADE_VIDEO_DECILE_DIV   VARCHAR(1000),
				DOWNGRADE_VIDEO_DECILE_REG   VARCHAR(1000),
				DOWNGRADE_HSD_SCORE   VARCHAR(1000),
				DOWNGRADE_HSD_DECILE   VARCHAR(1000),
				DOWNGRADE_HSD_SEGMENT   VARCHAR(1000),
				DOWNGRADE_HSD_DECILE_DIV   VARCHAR(1000),
				DOWNGRADE_HSD_DECILE_REG   VARCHAR(1000),
				UPGRADE_VIDEO_SCORE   VARCHAR(1000),
				UPGRADE_VIDEO_DECILE   VARCHAR(1000),
				UPGRADE_VIDEO_SEGMENT   VARCHAR(1000),
				UPGRADE_VIDEO_DECILE_DIV   VARCHAR(1000),
				UPGRADE_VIDEO_DECILE_REG   VARCHAR(1000),
				UPGRADE_XHOME_SCORE   VARCHAR(1000),
				UPGRADE_XHOME_DECILE   VARCHAR(1000),
				UPGRADE_XHOME_SEGMENT   VARCHAR(1000),
				UPGRADE_XHOME_DECILE_DIV   VARCHAR(1000),
				UPGRADE_XHOME_DECILE_REG   VARCHAR(1000),
				CHURN_CNTR_SCORE   VARCHAR(1000),
				CHURN_CNTR_DECILE   VARCHAR(1000),
				CHURN_CNTR_SEGMENT   VARCHAR(1000),
				CHURN_CNTR_DECILE_DIV   VARCHAR(1000),
				CHURN_CNTR_DECILE_REG   VARCHAR(1000),
				CHURN_COMP_SCORE   VARCHAR(1000),
				CHURN_COMP_DECILE   VARCHAR(1000),
				CHURN_COMP_SEGMENT   VARCHAR(1000),
				CHURN_COMP_DECILE_DIV   VARCHAR(1000),
				CHURN_COMP_DECILE_REG   VARCHAR(1000),
				CHURN_MOVE_SCORE   VARCHAR(1000),
				CHURN_MOVE_DECILE   VARCHAR(1000),
				CHURN_MOVE_SEGMENT   VARCHAR(1000),
				CHURN_MOVE_DECILE_DIV   VARCHAR(1000),
				CHURN_MOVE_DECILE_REG   VARCHAR(1000),
				CHURN_SVCS_SCORE   VARCHAR(1000),
				CHURN_SVCS_DECILE   VARCHAR(1000),
				CHURN_SVCS_SEGMENT   VARCHAR(1000),
				CHURN_SVCS_DECILE_DIV   VARCHAR(1000),
				CHURN_SVCS_DECILE_REG   VARCHAR(1000),
				UPG_ADDON_HISP_SCORE   VARCHAR(1000),
				UPG_ADDON_HISP_DECILE   VARCHAR(1000),
				UPG_ADDON_HISP_SEGMENT   VARCHAR(1000),
				UPG_ADDON_HISP_DECILE_DIV   VARCHAR(1000),
				UPG_ADDON_HISP_DECILE_REG   VARCHAR(1000),
				PROSP_DM_NET_RESP_SCORE   VARCHAR(1000),
				PROSP_DM_NET_RESP_NAT_DECILE   VARCHAR(1000),
				PROSP_DM_NET_RESP_DIV_DECILE   VARCHAR(1000),
				PROSP_DM_NET_RESP_REG_DECILE   VARCHAR(1000),
				QUAD_PLAY_SCORE   VARCHAR(1000),
				QUAD_PLAY_NAT_DECILE   VARCHAR(1000),
				QUAD_PLAY_DIV_DECILE   VARCHAR(1000),
				QUAD_PLAY_REG_DECILE   VARCHAR(1000),
				PROSP_DM_NET_RESP2_SCORE   VARCHAR(1000),
				PROSP_DM_NET_RESP2_NAT_DECILE   VARCHAR(1000),
				PROSP_DM_NET_RESP2_DIV_DECILE   VARCHAR(1000),
				PROSP_DM_NET_RESP2_REG_DECILE   VARCHAR(1000),
				UPGRADE_HSD_SCORE   VARCHAR(1000),
				UPGRADE_HSD_DECILE   VARCHAR(1000),
				UPGRADE_HSD_SEGMENT   VARCHAR(1000),
				UPGRADE_HSD_DECILE_DIV   VARCHAR(1000),
				UPGRADE_HSD_DECILE_REG   VARCHAR(1000),
				UPG_VIDTIER_ALL_SCORE   VARCHAR(1000),
				UPG_VIDTIER_ALL_DECILE   VARCHAR(1000),
				UPG_VIDTIER_ALL_SEGMENT   VARCHAR(1000),
				UPG_VIDTIER_ALL_DECILE_DIV   VARCHAR(1000),
				UPG_VIDTIER_ALL_DECILE_REG   VARCHAR(1000),
				UPG_VIDTIER_E2S_SCORE   VARCHAR(1000),
				UPG_VIDTIER_E2S_DECILE   VARCHAR(1000),
				UPG_VIDTIER_E2S_SEGMENT   VARCHAR(1000),
				UPG_VIDTIER_E2S_DECILE_DIV   VARCHAR(1000),
				UPG_VIDTIER_E2S_DECILE_REG   VARCHAR(1000),
				UPG_VIDTIER_S2P_SCORE   VARCHAR(1000),
				UPG_VIDTIER_S2P_DECILE   VARCHAR(1000),
				UPG_VIDTIER_S2P_SEGMENT   VARCHAR(1000),
				UPG_VIDTIER_S2P_DECILE_DIV   VARCHAR(1000),
				UPG_VIDTIER_S2P_DECILE_REG   VARCHAR(1000),
				UPG_ADDON_SPORT_SCORE   VARCHAR(1000),
				UPG_ADDON_SPORT_DECILE   VARCHAR(1000),
				UPG_ADDON_SPORT_SEGMENT   VARCHAR(1000),
				UPG_ADDON_SPORT_DECILE_DIV   VARCHAR(1000),
				UPG_ADDON_SPORT_DECILE_REG   VARCHAR(1000),
				UPG_ADDON_PREM_SCORE   VARCHAR(1000),
				UPG_ADDON_PREM_DECILE   VARCHAR(1000),
				UPG_ADDON_PREM_SEGMENT   VARCHAR(1000),
				UPG_ADDON_PREM_DECILE_DIV   VARCHAR(1000),
				UPG_ADDON_PREM_DECILE_REG   VARCHAR(1000),
				UPG_VIDTIER_E2P_SCORE   VARCHAR(1000),
				UPG_VIDTIER_E2P_DECILE   VARCHAR(1000),
				UPG_VIDTIER_E2P_SEGMENT   VARCHAR(1000),
				UPG_VIDTIER_E2P_DECILE_DIV   VARCHAR(1000),
				UPG_VIDTIER_E2P_DECILE_REG   VARCHAR(1000),
				DOWNGRADE_XH_SCORE   VARCHAR(1000),
				DOWNGRADE_XH_DECILE   VARCHAR(1000),
				DOWNGRADE_XH_SEGMENT   VARCHAR(1000),
				UPG_ADDON_INTL_SCORE   VARCHAR(1000),
				UPG_ADDON_INTL_DECILE   VARCHAR(1000),
				UPG_ADDON_INTL_SEGMENT   VARCHAR(1000),
				UPG_ADDON_INTL_DECILE_DIV   VARCHAR(1000),
				UPG_ADDON_INTL_DECILE_REG   VARCHAR(1000),
				DOWNGRADE_X1_SCORE   VARCHAR(1000),
				DOWNGRADE_X1_DECILE   VARCHAR(1000),
				DOWNGRADE_X1_SEGMENT   VARCHAR(1000),
				DOWNGRADE_X1_DECILE_DIV   VARCHAR(1000),
				DOWNGRADE_X1_DECILE_REG   VARCHAR(1000),
				DELINQ_CUR_2_PD30_SCORE   VARCHAR(1000),
				DELINQ_CUR_2_PD30_DECILE   VARCHAR(1000),
				DELINQ_CUR_2_PD30_SEGMENT   VARCHAR(1000),
				DELINQ_CUR_2_PD30_DECILE_DIV   VARCHAR(1000),
				DELINQ_CUR_2_PD30_DECILE_REG   VARCHAR(1000),
				DELINQ_PD30_2_CUR_SCORE   VARCHAR(1000),
				DELINQ_PD30_2_CUR_DECILE   VARCHAR(1000),
				DELINQ_PD30_2_CUR_SEGMENT   VARCHAR(1000),
				DELINQ_PD30_2_CUR_DECILE_DIV   VARCHAR(1000),
				DELINQ_PD30_2_CUR_DECILE_REG   VARCHAR(1000),
				UPGRADE_CDV_SCORE   VARCHAR(1000),
				UPGRADE_CDV_DECILE   VARCHAR(1000),
				UPGRADE_CDV_SEGMENT   VARCHAR(1000),
				UPGRADE_CDV_DECILE_DIV   VARCHAR(1000),
				UPGRADE_CDV_DECILE_REG   VARCHAR(1000),
				DOWNGRADE_CDV_SCORE   VARCHAR(1000),
				DOWNGRADE_CDV_DECILE   VARCHAR(1000),
				DOWNGRADE_CDV_SEGMENT   VARCHAR(1000),
				DOWNGRADE_CDV_DECILE_DIV   VARCHAR(1000),
				DOWNGRADE_CDV_DECILE_REG   VARCHAR(1000),
				PROSP_COMP_HSS_SCORE   VARCHAR(1000),
				PROSP_COMP_HSS_NAT_DECILE   VARCHAR(1000),
				PROSP_COMP_HSS_DIV_DECILE   VARCHAR(1000),
				PROSP_COMP_HSS_REG_DECILE   VARCHAR(1000),
				PROSP_GEN_CONV_SCORE   VARCHAR(1000),
				PROSP_GEN_CONV_NAT_DECILE   VARCHAR(1000),
				PROSP_GEN_CONV_DIV_DECILE   VARCHAR(1000),
				PROSP_GEN_CONV_REG_DECILE   VARCHAR(1000),
				PROSP_BIZ_LIKELY_SCORE   VARCHAR(1000),
				PROSP_BIZ_LIKELY_NAT_DECILE   VARCHAR(1000),
				PROSP_BIZ_LIKELY_DIV_DECILE   VARCHAR(1000),
				PROSP_BIZ_LIKELY_REG_DECILE   VARCHAR(1000),
				CHURN_6M_TOTAL_SCORE   VARCHAR(1000),
				CHURN_6M_TOTAL_DECILE   VARCHAR(1000),
				CHURN_6M_TOTAL_SEGMENT   VARCHAR(1000),
				CHURN_6M_TOTAL_DECILE_DIV   VARCHAR(1000),
				CHURN_6M_TOTAL_DECILE_REG   VARCHAR(1000),
				CHURN_6M_VOL_SCORE   VARCHAR(1000),
				CHURN_6M_VOL_DECILE   VARCHAR(1000),
				CHURN_6M_VOL_SEGMENT   VARCHAR(1000),
				CHURN_6M_VOL_DECILE_DIV   VARCHAR(1000),
				CHURN_6M_VOL_DECILE_REG   VARCHAR(1000),
				CHURN_6M_NPD_SCORE   VARCHAR(1000),
				CHURN_6M_NPD_DECILE   VARCHAR(1000),
				CHURN_6M_NPD_SEGMENT   VARCHAR(1000),
				CHURN_6M_NPD_DECILE_DIV   VARCHAR(1000),
				CHURN_6M_NPD_DECILE_REG   VARCHAR(1000),
				HSD_UPTIER_ALL_SCORE   VARCHAR(1000),
				HSD_UPTIER_ALL_DECILE   VARCHAR(1000),
				HSD_UPTIER_ALL_SEGMENT   VARCHAR(1000),
				HSD_UPTIER_ALL_DECILE_DIV   VARCHAR(1000),
				HSD_UPTIER_ALL_DECILE_REG   VARCHAR(1000),
				SUB_HSD_OWNER_SCORE   VARCHAR(1000),
				SUB_HSD_OWNER_NAT_DECILE   VARCHAR(1000),
				SUB_HSD_OWNER_DIV_DECILE   VARCHAR(1000),
				SUB_HSD_OWNER_REG_DECILE   VARCHAR(1000),
				TOT_ET_1_OUTAGE   VARCHAR(1000),
				TOT_ET_2_PRIORITY_PLANT_FAULT   VARCHAR(1000),
				TOT_ET_3_POWER_OUTAGE   VARCHAR(1000),
				TOT_ET_4_FIBER_CUT   VARCHAR(1000),
				TOT_ET_5_SVC_CALL_NODE_ALERT   VARCHAR(1000),
				TOT_ET_6_MODERATE_PLANT_FAULT   VARCHAR(1000),
				TOT_ET_7_US_FEC   VARCHAR(1000),
				TOT_ET_8_DS_FEC   VARCHAR(1000),
				TOT_ET_11_WIFI_OUTAGE_CM   VARCHAR(1000),
				TOT_ET_12_LPI   VARCHAR(1000),
				TOT_ET_13_FLUX_OSP   VARCHAR(1000),
				TOT_ET_14_WIFI_OUTAGE_AP   VARCHAR(1000),
				TOT_ET_15_WORST_NODE   VARCHAR(1000),
				TOT_ET_16_SVC_CALL_CLSR_ALERT   VARCHAR(1000),
				TOT_ET_17_SEVERE_PLANT_FAULT   VARCHAR(1000),
				DUR_ET_1_OUTAGE   VARCHAR(1000),
				DUR_ET_2_PRIORITY_PLANT_FAULT   VARCHAR(1000),
				DUR_ET_3_POWER_OUTAGE   VARCHAR(1000),
				DUR_ET_4_FIBER_CUT   VARCHAR(1000),
				DUR_ET_5_SVC_CALL_NODE_ALERT   VARCHAR(1000),
				DUR_ET_6_MODERATE_PLANT_FAULT   VARCHAR(1000),
				DUR_ET_7_US_FEC   VARCHAR(1000),
				DUR_ET_8_DS_FEC   VARCHAR(1000),
				DUR_ET_11_WIFI_OUTAGE_CM   VARCHAR(1000),
				DUR_ET_12_LPI   VARCHAR(1000),
				DUR_ET_13_FLUX_OSP   VARCHAR(1000),
				DUR_ET_14_WIFI_OUTAGE_AP   VARCHAR(1000),
				DUR_ET_15_WORST_NODE   VARCHAR(1000),
				DUR_ET_16_SVC_CALL_CLSR_ALERT   VARCHAR(1000),
				DUR_ET_17_SEVERE_PLANT_FAULT   VARCHAR(1000),
				UNIQ_ET_1_OUTAGE   VARCHAR(1000),
				UNIQ_ET_2_PRIORITY_PLANT_FAULT   VARCHAR(1000),
				UNIQ_ET_3_POWER_OUTAGE   VARCHAR(1000),
				UNIQ_ET_4_FIBER_CUT   VARCHAR(1000),
				UNIQ_ET_5_SVC_CALL_NODE_ALERT   VARCHAR(1000),
				UNIQ_ET_6_MODERATE_PLANT_FAULT   VARCHAR(1000),
				UNIQ_ET_7_US_FEC   VARCHAR(1000),
				UNIQ_ET_8_DS_FEC   VARCHAR(1000),
				UNIQ_ET_11_WIFI_OUTAGE_CM   VARCHAR(1000),
				UNIQ_ET_12_LPI   VARCHAR(1000),
				UNIQ_ET_13_FLUX_OSP   VARCHAR(1000),
				UNIQ_ET_14_WIFI_OUTAGE_AP   VARCHAR(1000),
				UNIQ_ET_15_WORST_NODE   VARCHAR(1000),
				UNIQ_ET_16_SVC_CALL_CLSR_ALERT   VARCHAR(1000),
				UNIQ_ET_17_SEVERE_PLANT_FAULT   VARCHAR(1000),
				HIC_MAX_SCORE   VARCHAR(1000),
				HIC_MIN_SCORE   VARCHAR(1000),
				HIC_AVG_SCORE   VARCHAR(1000),
				HIC_LAST_SCORE   VARCHAR(1000),
				HIC_POLLS_COUNT   VARCHAR(1000),
				HIC_MACS_COUNT   VARCHAR(1000),
				CORP_SYSPRIN   VARCHAR(1000),
				DIVISION   VARCHAR(1000),
				REGION   VARCHAR(1000),
				ENTITY_ID   VARCHAR(1000),
				ENTITY_NAME   VARCHAR(1000),
				HEADEND   VARCHAR(1000),
				CSG_AGENT   VARCHAR(1000),
				DST_FRANCHISE_TAX_AREA   VARCHAR(1000),
				DST_MGMT_AREA   VARCHAR(1000),
				SPIN_CO   VARCHAR(1000),
				MONTH_END_DT   VARCHAR(1000)
			);

        DEFINE OPERATOR o_ExportOper
        TYPE EXPORT
        SCHEMA SCHEMA_ADM_201602
        ATTRIBUTES (
            VARCHAR UserName            = @UserName
           ,VARCHAR UserPassword        = @UserPassword
           ,VARCHAR TdpId               = @TdpId
           ,INTEGER MaxSessions         = @MaxSessions
           ,INTEGER MinSessions         = @MinSessions
           ,VARCHAR PrivateLogName      = 'Export'
           ,VARCHAR SpoolMode           = 'NoSpool'
           ,VARCHAR WorkingDatabase     = @WorkingDatabase
           ,VARCHAR SourceTable         = @SourceTable
           ,VARCHAR SelectStmt          = @SelectStmt
           ,VARCHAR TraceLevel          = 'all'
        );

        DEFINE OPERATOR o_FileWritter
        TYPE DATACONNECTOR CONSUMER
        SCHEMA SCHEMA_ADM_201602
        ATTRIBUTES (
         VARCHAR FileName               = @FileName
        ,VARCHAR Format                 = @Format
        ,VARCHAR TextDelimiter          = @TextDelimiter
        ,VARCHAR IndicatorMode          = 'N'
        ,VARCHAR OpenMode               = 'Write'
        ,VARCHAR PrivateLogName         = 'DataConnector'
        ,VARCHAR TraceLevel             = 'all'
        );
        APPLY TO OPERATOR (o_FileWritter[@LoadInst])
           SELECT * FROM OPERATOR (o_ExportOper[@ReadInst]);
     )
     ;

-------------------------------

adm_201602.ksh

-------------------------------

tbuild -f /home/aroy001c/Sample/ctl/adm_201602.tpt.ctl -v /home/aroy001c/Sample/logon/aroy001c_tpt.logon -u " WorkingDatabase='NDW_EBI_VIEWS' , SourceTable='ADM_201602' , MacroDatabase='NDW_TEMP' , load_op=o_ExportOper , LoadInst=1 , ReadInst=1 , MaxSessions=10 , MinSessions=5 , FileName='/home/aroy001c/Sample/tgtfile/adm_201602.out' , LOAD_DTS='2016-04-27 08:21:34' , Format='DELIMITED' TextDelimiter='|' , SkipRows=0 , SelectStmt='SELECT TRIM(CAST(CUSTOMER_ACCOUNT_ID AS VARCHAR(50))), TRIM(CAST(ACCOUNT_NUMBER AS VARCHAR(50))), TRIM(CAST(PREVIOUS_ACCOUNT_NUMBER AS VARCHAR(50))), TRIM(CAST(HOUSE_ID AS VARCHAR(50))), TRIM(CAST(ACCT_NUMBER_CHANGE_DATE AS VARCHAR(50))), TRIM(CAST(PERSISTENT_KEY AS VARCHAR(50))), TRIM(CAST(HOUSEHOLD_PERSISTENT_KEY AS VARCHAR(50))), TRIM(CAST(PKEY_CONFIDENCE AS VARCHAR(50))), TRIM(CAST("NAME" AS VARCHAR(50))), TRIM(CAST(ADDRESS1 AS VARCHAR(50))), TRIM(CAST(ADDRESS2 AS VARCHAR(50))), TRIM(CAST(CITY AS VARCHAR(50))), TRIM(CAST(STATE AS VARCHAR(50))), TRIM(CAST(ZIP AS VARCHAR(50))), TRIM(CAST(ZIP4 AS VARCHAR(50))), TRIM(CAST(PHONE_NUMBER AS VARCHAR(50))), TRIM(CAST(DWELL_TYPE_GROUP AS VARCHAR(50))), TRIM(CAST(DWELL_TYPE_SUB_GROUP AS VARCHAR(50))), TRIM(CAST(DWELL_TYPE_DESCRIPTION AS VARCHAR(50))), TRIM(CAST(PRIMARY_EMAIL AS VARCHAR(50))), TRIM(CAST(CONTACT_EMAIL AS VARCHAR(50))), TRIM(CAST(BILLER_EMAIL AS VARCHAR(50))), TRIM(CAST(CONTACT_EMAIL_FLAG AS VARCHAR(50))), TRIM(CAST(EMAIL_FLAG AS VARCHAR(50))), TRIM(CAST(LOCATION_ID AS VARCHAR(50))), TRIM(CAST(DMA AS VARCHAR(50))), TRIM(CAST(CUSTOMER_GUID AS VARCHAR(50))), TRIM(CAST(BILLING_SYSTEM AS VARCHAR(50))), TRIM(CAST(START_DATE AS VARCHAR(50))), TRIM(CAST(HSD_SERVICABILITY_IND AS VARCHAR(50))), TRIM(CAST(VIDEO_SERVICABILITY_IND AS VARCHAR(50))), TRIM(CAST(VOICE_SERVICABILITY_IND AS VARCHAR(50))), TRIM(CAST(BULK_COMPLEX_SID AS VARCHAR(50))), TRIM(CAST(BULK_MASTER_UNITS_COUNT AS VARCHAR(50))), TRIM(CAST(PANEL_IND AS VARCHAR(50))), TRIM(CAST(PANELIST_ID AS VARCHAR(50))), TRIM(CAST(PANELIST_ID1 AS VARCHAR(50))), TRIM(CAST(FIBER_NODE_NM AS VARCHAR(50))), TRIM(CAST(FIBER_NODE_DESC AS VARCHAR(50))), TRIM(CAST(FIPS_CODE AS VARCHAR(50))), TRIM(CAST(LATITUDE AS VARCHAR(50))), TRIM(CAST(LONGITUDE AS VARCHAR(50))), TRIM(CAST(ELOC_MARKET_NAME AS VARCHAR(50))), TRIM(CAST(ORGANIZATION_ID AS VARCHAR(50))), TRIM(CAST(HOUSE_MISC AS VARCHAR(50))), TRIM(CAST(ACCOUNT_STATUS AS VARCHAR(50))), TRIM(CAST(CUSTOMER_TYPE AS VARCHAR(50))), TRIM(CAST(RESIDENTIAL_IND AS VARCHAR(50))), TRIM(CAST(BUSINESSSERVICES_IND AS VARCHAR(50))), TRIM(CAST(BULK_IND AS VARCHAR(50))), TRIM(CAST(PRIMARY_BULK_MASTER AS VARCHAR(50))), TRIM(CAST(SECONDARY_BULK_MASTER AS VARCHAR(50))), TRIM(CAST(SUBSERVIENT AS VARCHAR(50))), TRIM(CAST(BULK_COURTESY AS VARCHAR(50))), TRIM(CAST(PRIMARY_BULK_MASTER_ACCOUNT_ID AS VARCHAR(50))), TRIM(CAST(BULK_PRODUCT_UPGRADEABLE AS VARCHAR(50))), TRIM(CAST(BULK_PRODUCT_NON_UPGRADEABLE AS VARCHAR(50))), TRIM(CAST(BULK_CUS_UPG_TYPE AS VARCHAR(50))), TRIM(CAST(COURTESY_IND AS VARCHAR(50))), TRIM(CAST(SEASONAL_FLAG AS VARCHAR(50))), TRIM(CAST(NUMBER_OF_PRODUCTS AS VARCHAR(50))), TRIM(CAST(PRODUCT_MIX AS VARCHAR(50))), TRIM(CAST(TENURE_BY_PKEY AS VARCHAR(50))), TRIM(CAST(TENURE_BY_ACCOUNT AS VARCHAR(50))), TRIM(CAST(RGU_VIDEO AS VARCHAR(50))), TRIM(CAST(RGU_HSD AS VARCHAR(50))), TRIM(CAST(RGU_CDV AS VARCHAR(50))), TRIM(CAST(RGU_XH AS VARCHAR(50))), TRIM(CAST(RGU_BULK_VIDEO AS VARCHAR(50))), TRIM(CAST(RGU_BULK_HSD AS VARCHAR(50))), TRIM(CAST(RGU_BULK_CDV AS VARCHAR(50))), TRIM(CAST(VIDEO_PRODUCT_EFF_DT AS VARCHAR(50))), TRIM(CAST(VIDEO_DAYS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(VIDEO_MONTHS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(HSD_PRODUCT_EFF_DT AS VARCHAR(50))), TRIM(CAST(HSD_DAYS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(HSD_MONTHS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(CDV_PRODUCT_EFF_DT AS VARCHAR(50))), TRIM(CAST(CDV_DAYS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(CDV_MONTHS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(XH_PRODUCT_EFF_DT AS VARCHAR(50))), TRIM(CAST(XH_DAYS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(XH_MONTHS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(VIDEO_TIER_NAME AS VARCHAR(50))), TRIM(CAST(VIDEO_BASIC AS VARCHAR(50))), TRIM(CAST(VIDEO_EXPANDED AS VARCHAR(50))), TRIM(CAST(VIDEO_GET_STARTED AS VARCHAR(50))), TRIM(CAST(VIDEO_DIGITAL_ECONOMY AS VARCHAR(50))), TRIM(CAST(VIDEO_DIGITAL_STARTER AS VARCHAR(50))), TRIM(CAST(VIDEO_DIGITAL_PREFERRED AS VARCHAR(50))), TRIM(CAST(VIDEO_BUS_SERVICES_PRIVATE AS VARCHAR(50))), TRIM(CAST(VIDEO_BUS_SERVICES_PUBLIC AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_BASICVIDEO_B1 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_EXPANDEDVIDEO_B2 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_DIGITAL_STARTER_TIER AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_DIGITAL_PREFERRED_TIER AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_DIGITAL_STANDARD_TIER AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PUBLIC_BR1 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PUBLIC_BR1_5 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PUBLIC_BR2 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PUBLIC_WSPORTS_BR4 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PRIVATE_C0 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PRIVATE_C0_5 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PRIVATE_C1 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PRIVATE_C1_5 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PRIVATE_C2 AS VARCHAR(50))), TRIM(CAST(VIDEO_BS_PRIVATE_C3 AS VARCHAR(50))), TRIM(CAST(VIDEO_BULK AS VARCHAR(50))), TRIM(CAST(HD_SERVICE AS VARCHAR(50))), TRIM(CAST(DVR_SERVICE AS VARCHAR(50))), TRIM(CAST(BLASTPLUS_IND AS VARCHAR(50))), TRIM(CAST(INTERNETPLUS_IND AS VARCHAR(50))), TRIM(CAST(X1_PLATFORM AS VARCHAR(50))), TRIM(CAST(X1_PRODUCT_EFF_DT AS VARCHAR(50))), TRIM(CAST(X1_DAYS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(X1_MONTHS_ON_BOOKS AS VARCHAR(50))), TRIM(CAST(CLOUD_DVR AS VARCHAR(50))), TRIM(CAST(HSD_TIER_NAME AS VARCHAR(50))), TRIM(CAST(HSD_ECONOMY_TIER AS VARCHAR(50))), TRIM(CAST(HSD_ECONOMY_PLUS AS VARCHAR(50))), TRIM(CAST(HSD_INTERNET_ESSENTIALS AS VARCHAR(50))), TRIM(CAST(HSD_PERFORMANCE_STARTER AS VARCHAR(50))), TRIM(CAST(HSD_PERFORMANCE_TIER AS VARCHAR(50))), TRIM(CAST(HSD_BLAST AS VARCHAR(50))), TRIM(CAST(HSD_ULTRA AS VARCHAR(50))), TRIM(CAST(HSD_EXTREME_TIER AS VARCHAR(50))), TRIM(CAST(HSD_EXTREME_105 AS VARCHAR(50))), TRIM(CAST(HSD_EXTREME_200 AS VARCHAR(50))), TRIM(CAST(HSD_EXTREME_305 AS VARCHAR(50))), TRIM(CAST(HSD_EXTREME_1000 AS VARCHAR(50))), TRIM(CAST(HSD_BS_TELEWORKER_STANDARD AS VARCHAR(50))), TRIM(CAST(HSD_BS_TELEWORKER_ENHANCED AS VARCHAR(50))), TRIM(CAST(HSD_BS_TELEWORKER_PREMIUM AS VARCHAR(50))), TRIM(CAST(HSD_BS_TELEWORKER_DELUXE AS VARCHAR(50))), TRIM(CAST(HSD_BS_ECONOMY AS VARCHAR(50))), TRIM(CAST(HSD_BS_STARTER AS VARCHAR(50))), TRIM(CAST(HSD_BS_PREFERRED AS VARCHAR(50))), TRIM(CAST(HSD_BS_PREMIUM AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE_25 AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE_75 AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE_100 AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE_100PLUS AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE_150 AS VARCHAR(50))), TRIM(CAST(HSD_BS_DELUXE_250 AS VARCHAR(50))), TRIM(CAST(HSD_BULK AS VARCHAR(50))), TRIM(CAST(CDV_TIER_NAME AS VARCHAR(50))), TRIM(CAST(CDV_LOCAL_WITH_MORE AS VARCHAR(50))), TRIM(CAST(CDV_UNLIMITED AS VARCHAR(50))), TRIM(CAST(CDV_BUSINESS_VOICE AS VARCHAR(50))), TRIM(CAST(CDV_BULK AS VARCHAR(50))), TRIM(CAST(CDV_BV_FOUR_PLUS_LINES AS VARCHAR(50))), TRIM(CAST(CDV_BV_BASIC_LINE AS VARCHAR(50))), TRIM(CAST(CDV_BV_FULL_FEATURE_LINE AS VARCHAR(50))), TRIM(CAST(CDV_BV_TRUNK AS VARCHAR(50))), TRIM(CAST(CDV_BV_EDGE AS VARCHAR(50))), TRIM(CAST(CDV_BV_TOLL_FREE AS VARCHAR(50))), TRIM(CAST(HISPANIC_TIER AS VARCHAR(50))), TRIM(CAST(XH_TIER_NAME AS VARCHAR(50))), TRIM(CAST(XH_CONTROL100 AS VARCHAR(50))), TRIM(CAST(XH_CONTROL150 AS VARCHAR(50))), TRIM(CAST(XH_SECURE300 AS VARCHAR(50))), TRIM(CAST(XH_SECURE350 AS VARCHAR(50))), TRIM(CAST(XH_STATUS AS VARCHAR(50))), TRIM(CAST(XH_CTRL150TIER_CONTRACT_FLAG AS VARCHAR(50))), TRIM(CAST(PREMIUM_HBO AS VARCHAR(50))), TRIM(CAST(PREMIUM_SHOWTIME AS VARCHAR(50))), TRIM(CAST(PREMIUM_CINEMAX AS VARCHAR(50))), TRIM(CAST(PREMIUM_STARZ AS VARCHAR(50))), TRIM(CAST(PREMIUM_TMC AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_ARABIC AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_BRAZILIAN AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_CHINESE AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_FILIPINO AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_FRENCH AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_GERMAN AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_GREEK AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_ISRAELI AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_ITALIAN AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_JAPANESE AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_KOREAN AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_OTHER AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_POLISH AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_PORTUGUESE AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_RUSSIAN AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_SOUTHASIAN AS VARCHAR(50))), TRIM(CAST(INTERNATIONAL_VIETNAMESE AS VARCHAR(50))), TRIM(CAST(PPV_SPORTS_NHL_CENTER_ICE AS VARCHAR(50))), TRIM(CAST(PPV_SPORTS_ESPN_GAME_PLAN AS VARCHAR(50))), TRIM(CAST(PPV_SPORTS_ESPN_FULL_COURT AS VARCHAR(50))), TRIM(CAST(PPV_SPORTS_NBA_LEAGUE_PLAN AS VARCHAR(50))), TRIM(CAST(PPV_SPORTS_MLB_EXTRA_INNINGS AS VARCHAR(50))), TRIM(CAST(PPV_SPORTS_MLS_DIRECT_KICK AS VARCHAR(50))), TRIM(CAST(VIDEO_ADDON_SPORTS_TIER AS VARCHAR(50))), TRIM(CAST(VIDEO_ADDON_FAMILY_TIER AS VARCHAR(50))), TRIM(CAST(VIDEO_ADDON_TV_3D AS VARCHAR(50))), TRIM(CAST(VIDEO_ADDON_MUSIC_CHOICE AS VARCHAR(50))), TRIM(CAST(SVOD_DISNEY_FAMILY_MOVIES AS VARCHAR(50))), TRIM(CAST(SVOD_BOLLYWOOD_HITS AS VARCHAR(50))), TRIM(CAST(STREAMPIX AS VARCHAR(50))), TRIM(CAST(CALLING_PLAN AS VARCHAR(50))), TRIM(CAST(CP_LATIN_AMERICA AS VARCHAR(50))), TRIM(CAST(CP_LATIN_AMERICA_300 AS VARCHAR(50))), TRIM(CAST(CP_MEXICO AS VARCHAR(50))), TRIM(CAST(CP_MEXICO_300 AS VARCHAR(50))), TRIM(CAST(CP_NSE_ASIA AS VARCHAR(50))), TRIM(CAST(CP_WESTERN_EUROPE AS VARCHAR(50))), TRIM(CAST(CP_WORLDWIDE AS VARCHAR(50))), TRIM(CAST(CP_FAMILY_PLAN AS VARCHAR(50))), TRIM(CAST(VIDEO_PENETRATION_PCT AS VARCHAR(50))), TRIM(CAST(HSD_PENETRATION_PCT AS VARCHAR(50))), TRIM(CAST(CDV_PENETRATION_PCT AS VARCHAR(50))), TRIM(CAST(SUBSCRIBER_PENETRATION_PCT AS VARCHAR(50))), TRIM(CAST(EQUIP_EMTA_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_MODEM_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_ROUTER_WIRELESS_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_ROUTER_COMMERCIAL_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_WIRELESS_2_GO_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_WIRELESS_GATEWAY_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_XB3_WIRELESS_GTWY_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_CABLE_CARD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DTA_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DTA_HD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DTA_SD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DVR_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DVR_HD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DVR_HD_XCAL_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DVR_HD_NON_XCAL_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DVR_SD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DIG_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DIG_HD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DIG_HD_XCAL_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DIG_HD_NON_XCAL_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_DIG_SD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_MOT_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_SA_CNT AS VARCHAR(50))), TRIM(CAST(XH_TOT_DEV_CNT AS VARCHAR(50))), TRIM(CAST(XH_PERI_CNT AS VARCHAR(50))), TRIM(CAST(XH_PERI_KP_CNT AS VARCHAR(50))), TRIM(CAST(XH_PERI_WIFI_CNT AS VARCHAR(50))), TRIM(CAST(XH_PERI_KEYFOB_CNT AS VARCHAR(50))), TRIM(CAST(XH_PERI_OTH_CNT AS VARCHAR(50))), TRIM(CAST(XH_CAM_CNT AS VARCHAR(50))), TRIM(CAST(XH_DEV_CAM_CNT AS VARCHAR(50))), TRIM(CAST(XH_CAM_OD_CNT AS VARCHAR(50))), TRIM(CAST(XH_CAM_ID_CNT AS VARCHAR(50))), TRIM(CAST(XH_DW_CNT AS VARCHAR(50))), TRIM(CAST(XH_DW_LEGACY_CNT AS VARCHAR(50))), TRIM(CAST(XH_SENSORS_DW_CNT AS VARCHAR(50))), TRIM(CAST(XH_DW_TAKEO_CNT AS VARCHAR(50))), TRIM(CAST(XH_LIGHT_CNT AS VARCHAR(50))), TRIM(CAST(XH_LIGHT_CON_CNT AS VARCHAR(50))), TRIM(CAST(XH_DEV_LIGHT_CNT AS VARCHAR(50))), TRIM(CAST(XH_MOTSENS_CNT AS VARCHAR(50))), TRIM(CAST(XH_TSTAT_CNT AS VARCHAR(50))), TRIM(CAST(XH_TOUCHSC_CNT AS VARCHAR(50))), TRIM(CAST(XH_OTH_SENS_CNT AS VARCHAR(50))), TRIM(CAST(XH_OTH_SENS_GLS_CNT AS VARCHAR(50))), TRIM(CAST(XH_OTH_SENS_CUR_CNT AS VARCHAR(50))), TRIM(CAST(XH_OTH_SENS_SMK_CNT AS VARCHAR(50))), TRIM(CAST(XH_OTH_SENS_CO_CNT AS VARCHAR(50))), TRIM(CAST(XH_OTH_SENS_FLD_CNT AS VARCHAR(50))), TRIM(CAST(EQUIP_EBIV01 AS VARCHAR(50))), TRIM(CAST(EQUIP_EOL_CNT AS VARCHAR(50))), TRIM(CAST(MDM_EMTA_WGTWY_OWN_LEASE_FLAG AS VARCHAR(50))), TRIM(CAST(MRC AS VARCHAR(50))), TRIM(CAST(ACTIVE_CLV AS VARCHAR(50))), TRIM(CAST(ACTIVE_CLV_MARGIN AS VARCHAR(50))), TRIM(CAST(ACTIVE_CLV_MARGIN_SEGMENT AS VARCHAR(50))), TRIM(CAST(ACTIVE_CLV_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(ACTIVE_CLV_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(ACTIVE_CLV_REG_DECILE AS VARCHAR(50))), TRIM(CAST(STAR_SEGMENT AS VARCHAR(50))), TRIM(CAST(NINE_BOX_SEGMENT AS VARCHAR(50))), TRIM(CAST(AUTO_PAY_ENROLLMENT AS VARCHAR(50))), TRIM(CAST(BILL_COURTESY_IND AS VARCHAR(50))), TRIM(CAST(REVENUE_TOTAL_AMT AS VARCHAR(50))), TRIM(CAST(COST_TOTAL_AMT AS VARCHAR(50))), TRIM(CAST(MARGIN_TOTAL_AMT AS VARCHAR(50))), TRIM(CAST(MRC_RECURRING_TOTAL_AMT AS VARCHAR(50))), TRIM(CAST(MRC_RECURRING_VIDEO_AMT AS VARCHAR(50))), TRIM(CAST(MRC_RECURRING_HSD_AMT AS VARCHAR(50))), TRIM(CAST(MRC_RECURRING_CDV_AMT AS VARCHAR(50))), TRIM(CAST(MRC_RECURRING_XH_AMT AS VARCHAR(50))), TRIM(CAST(COST_RECURRING_TOTAL_AMT AS VARCHAR(50))), TRIM(CAST(COST_RECURRING_VIDEO_AMT AS VARCHAR(50))), TRIM(CAST(COST_RECURRING_HSD_AMT AS VARCHAR(50))), TRIM(CAST(COST_RECURRING_CDV_AMT AS VARCHAR(50))), TRIM(CAST(COST_RECURRING_XH_AMT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_TOTAL_AMT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_VIDEO_AMT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_HSD_AMT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_CDV_AMT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_XH_AMT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_TOTAL_PCT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_VIDEO_PCT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_HSD_PCT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_CDV_PCT AS VARCHAR(50))), TRIM(CAST(MRM_RECURRING_XH_PCT AS VARCHAR(50))), TRIM(CAST(BALANCE_CURRENT_AMT AS VARCHAR(50))), TRIM(CAST(BALANCE_CUMULATIVE_AMT AS VARCHAR(50))), TRIM(CAST(BILL_STATEMENT_AMT AS VARCHAR(50))), TRIM(CAST(BILL_STATEMENT_DT AS VARCHAR(50))), TRIM(CAST(BILL_PAYMENT_AMT AS VARCHAR(50))), TRIM(CAST(BILL_PAYMENT_DT AS VARCHAR(50))), TRIM(CAST(BILL_PAYMENT_CYCLE AS VARCHAR(50))), TRIM(CAST(DELINQUENCY_STATUS AS VARCHAR(50))), TRIM(CAST(DELINQUENT_30_BALANCE_AMT AS VARCHAR(50))), TRIM(CAST(DELINQUENT_60_BALANCE_AMT AS VARCHAR(50))), TRIM(CAST(DELINQUENT_90_BALANCE_AMT AS VARCHAR(50))), TRIM(CAST(DELINQUENT_120_BALANCE_AMT AS VARCHAR(50))), TRIM(CAST(DELINQUENT_30_DAY_EVER AS VARCHAR(50))), TRIM(CAST(DELINQUENT_60_DAY_EVER AS VARCHAR(50))), TRIM(CAST(DELINQUENT_90_DAY_EVER AS VARCHAR(50))), TRIM(CAST(DELINQUENT_120_DAY_EVER AS VARCHAR(50))), TRIM(CAST(DELINQUENT_NUMBER_OF_TIMES AS VARCHAR(50))), TRIM(CAST(DELINQUENT_NUMBER_OF_DAYS AS VARCHAR(50))), TRIM(CAST(DELINQUENCY_LIFETIME_FLAG AS VARCHAR(50))), TRIM(CAST(WRITE_OFF AS VARCHAR(50))), TRIM(CAST(DUNNING_GROUP AS VARCHAR(50))), TRIM(CAST(INTERNAL_STATUS AS VARCHAR(50))), TRIM(CAST(PROMISE_TO_PAY_FLAG AS VARCHAR(50))), TRIM(CAST(EQUIFAX_CREDIT_SCORE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_TRANS_TYPE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_REASON_CODES AS VARCHAR(50))), TRIM(CAST(EQUIFAX_REJECT_CODE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_HIT_CODE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_MATCH_CODE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_ID_SCAN AS VARCHAR(50))), TRIM(CAST(EQUIFAX_LETTER_CODE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_FRAUD_WARNING AS VARCHAR(50))), TRIM(CAST(EQUIFAX_DECISION_VERBIAGE AS VARCHAR(50))), TRIM(CAST(EQUIFAX_CUSTOMER_REF_NUM AS VARCHAR(50))), TRIM(CAST(EQUIFAX_MODEL_NUMBER AS VARCHAR(50))), TRIM(CAST(EQUIFAX_EXCHANGE_INDICATOR AS VARCHAR(50))), TRIM(CAST(NSF_CHECK_COUNT AS VARCHAR(50))), TRIM(CAST(DEPOSIT_AMT AS VARCHAR(50))), TRIM(CAST(NEVER_PAY_FLAG AS VARCHAR(50))), TRIM(CAST(OFFER_NAME AS VARCHAR(50))), TRIM(CAST(OFFER_MONTHS_DURATION AS VARCHAR(50))), TRIM(CAST(MRC_NET_OFFER_AMT AS VARCHAR(50))), TRIM(CAST(OFFER_PROD_MIX_NAME AS VARCHAR(50))), TRIM(CAST(OFFER_PLAY_MIX_NAME AS VARCHAR(50))), TRIM(CAST(EBILL AS VARCHAR(50))), TRIM(CAST(SPANISH_BILL AS VARCHAR(50))), TRIM(CAST(CONTRACT_TERM_NAME AS VARCHAR(50))), TRIM(CAST(CONTRACT_START_DATE AS VARCHAR(50))), TRIM(CAST(CONTRACT_TERM_PERIOD AS VARCHAR(50))), TRIM(CAST(CON_ACCEPTANCE_CHANNEL AS VARCHAR(50))), TRIM(CAST(ETF_START_DATE AS VARCHAR(50))), TRIM(CAST(ETF_START_AMOUNT AS VARCHAR(50))), TRIM(CAST(ETF_DECLINING_AMOUNT AS VARCHAR(50))), TRIM(CAST(ETF_DECLINING_PERIOD AS VARCHAR(50))), TRIM(CAST(CONTRACT_FLAG AS VARCHAR(50))), TRIM(CAST(ETF_MONTHS_TO_GO AS VARCHAR(50))), TRIM(CAST(CONTRACT_MONTHS_TO_GO AS VARCHAR(50))), TRIM(CAST(CONTRACT_ACCEPT_STATUS AS VARCHAR(50))), TRIM(CAST(XH_CONTRACT_TERM_NAME AS VARCHAR(50))), TRIM(CAST(XH_CONTRACT_START_DATE AS VARCHAR(50))), TRIM(CAST(XH_CONTRACT_TERM_PERIOD AS VARCHAR(50))), TRIM(CAST(XH_CON_ACCEPTANCE_CHANNEL AS VARCHAR(50))), TRIM(CAST(XH_ETF_START_AMOUNT AS VARCHAR(50))), TRIM(CAST(XH_ETF_START_DATE AS VARCHAR(50))), TRIM(CAST(XH_ETF_DECLINING_AMOUNT AS VARCHAR(50))), TRIM(CAST(XH_ETF_DECLINING_PERIOD AS VARCHAR(50))), TRIM(CAST(XH_ETF_MONTHS_TO_GO AS VARCHAR(50))), TRIM(CAST(XH_CONTRACT_MONTHS_TO_GO AS VARCHAR(50))), TRIM(CAST(XH_CONTRACT_ACCEPT_STATUS AS VARCHAR(50))), TRIM(CAST(ALL_PPV_REVENUE_AMT AS VARCHAR(50))), TRIM(CAST(ALL_PPV_COST_AMT AS VARCHAR(50))), TRIM(CAST(ALL_PPV_MRM_AMT AS VARCHAR(50))), TRIM(CAST(ALL_PPV_MRM_PCT AS VARCHAR(50))), TRIM(CAST(XH_SYSTEM_UPGRADES AS VARCHAR(50))), TRIM(CAST(DISCOUNT_AMT AS VARCHAR(50))), TRIM(CAST(PACKAGE_CODES AS VARCHAR(50))), TRIM(CAST(BUNDLE_TIER AS VARCHAR(50))), TRIM(CAST(TP_BUNDLE_NAME AS VARCHAR(50))), TRIM(CAST(TP_BUNDLE_CODE AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_TOTAL AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_BILLING AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SVC AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SVC_VIDEO AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SVC_HSD AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SVC_CDV AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SVC_XH AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SVC_OTHER AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_SALES AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_RETENTION AS VARCHAR(50))), TRIM(CAST(IVR_RESOLVED_OTHER AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_TOTAL AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_BILLING AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SVC AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SVC_VIDEO AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SVC_HSD AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SVC_CDV AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SVC_XH AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SVC_OTHER AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_SALES AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_RETENTION AS VARCHAR(50))), TRIM(CAST(IVR_UNRESOLVED_OTHER AS VARCHAR(50))), TRIM(CAST(IVR_TOTAL AS VARCHAR(50))), TRIM(CAST(IVR_BILLING AS VARCHAR(50))), TRIM(CAST(IVR_SVC AS VARCHAR(50))), TRIM(CAST(IVR_SVC_VIDEO AS VARCHAR(50))), TRIM(CAST(IVR_SVC_HSD AS VARCHAR(50))), TRIM(CAST(IVR_SVC_CDV AS VARCHAR(50))), TRIM(CAST(IVR_SVC_XH AS VARCHAR(50))), TRIM(CAST(IVR_SVC_OTHER AS VARCHAR(50))), TRIM(CAST(IVR_SALES AS VARCHAR(50))), TRIM(CAST(IVR_RETENTION AS VARCHAR(50))), TRIM(CAST(IVR_OTHER AS VARCHAR(50))), TRIM(CAST(TTS_TOTAL_TICKETS AS VARCHAR(50))), TRIM(CAST(TTS_VIDEO_TICKETS AS VARCHAR(50))), TRIM(CAST(TTS_HSD_TICKETS AS VARCHAR(50))), TRIM(CAST(TTS_CDV_TICKETS AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_TOTAL_CNT AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_TOTAL_PTS AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_TOTAL_TIH AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_INSTALL_CNT AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_INSTALL_PTS AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_INSTALL_TIH AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_SRO_CNT AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_SRO_PTS AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_SRO_TIH AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_TC_CNT AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_TC_INSTALL_PTS AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_TC_INSTALL_TIH AS VARCHAR(50))), TRIM(CAST(TRUCKROLL_COS_CNT AS VARCHAR(50))), TRIM(CAST(CR_VID_SVC_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_HSD_SVC_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_HSD_CONN_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_CDV_SVC_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_CDV_FEA_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_OTG_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_BILLING_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_CDV_BILLING_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_HSD_BILLING_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_XH_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_BS_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_OTHER_PRB_CNT AS VARCHAR(50))), TRIM(CAST(CR_CUST_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_COMCAST_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_NW_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_BS_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_APL_SUP_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_HS_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_OTHER_CSE_CNT AS VARCHAR(50))), TRIM(CAST(CR_CUST_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_COMCAST_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_EQUIP_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_BS_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_BILLING_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_HS_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_NO_TRB_FOUND_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_PROV_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_ACT_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_OTHER_SOL_CNT AS VARCHAR(50))), TRIM(CAST(CR_AVG_TTR AS VARCHAR(50))), TRIM(CAST(SURVEYS_TAKEN AS VARCHAR(50))), TRIM(CAST(RESI_CARE_OVERALL_SAT AS VARCHAR(50))), TRIM(CAST(RESI_CARE_REP_SAT AS VARCHAR(50))), TRIM(CAST(RESI_CARE_ISSUE_RESOLVED AS VARCHAR(50))), TRIM(CAST(RESI_TECH_OVERALL_SAT AS VARCHAR(50))), TRIM(CAST(RESI_TECH_REP_SAT AS VARCHAR(50))), TRIM(CAST(RESI_TECH_SERVICE_WORKING AS VARCHAR(50))), TRIM(CAST(SVC_CNTR_OVERALL_SAT AS VARCHAR(50))), TRIM(CAST(SVC_CNTR_REP_SAT AS VARCHAR(50))), TRIM(CAST(SVC_CNTR_ISSUE_RESOLVED AS VARCHAR(50))), TRIM(CAST(BS_CARE_OVERALL_SAT AS VARCHAR(50))), TRIM(CAST(BS_CARE_REP_SAT AS VARCHAR(50))), TRIM(CAST(BS_CARE_ISSUE_RESOLVED AS VARCHAR(50))), TRIM(CAST(BS_TECH_OVERALL_SAT AS VARCHAR(50))), TRIM(CAST(BS_TECH_REP_SAT AS VARCHAR(50))), TRIM(CAST(BS_TECH_SERVICE_WORKING AS VARCHAR(50))), TRIM(CAST(TOTAL_ERONE_TICKETS AS VARCHAR(50))), TRIM(CAST(AVG_ERONE_RESOLVE_TIME_SEC AS VARCHAR(50))), TRIM(CAST(CDV_TOTAL_MIN AS VARCHAR(50))), TRIM(CAST(CDV_PLACED_MIN AS VARCHAR(50))), TRIM(CAST(CDV_RCVD_MIN AS VARCHAR(50))), TRIM(CAST(CDV_TOTAL_CNT AS VARCHAR(50))), TRIM(CAST(CDV_PLACED_CNT AS VARCHAR(50))), TRIM(CAST(CDV_RCVD_CNT AS VARCHAR(50))), TRIM(CAST(HSD_TOTAL_GB AS VARCHAR(50))), TRIM(CAST(HSD_DOWNLOAD_GB AS VARCHAR(50))), TRIM(CAST(HSD_UPLOAD_GB AS VARCHAR(50))), TRIM(CAST(WIFI_TOTAL_GB AS VARCHAR(50))), TRIM(CAST(WIFI_TOTAL_SESSIONS AS VARCHAR(50))), TRIM(CAST(LIVE_PPV_PURCHASE_CNT AS VARCHAR(50))), TRIM(CAST(LIVE_PPV_PURCHASE_AMT AS VARCHAR(50))), TRIM(CAST(VIDEO_ON_DEMAND AS VARCHAR(50))), TRIM(CAST(TOTAL_VOD_FREE_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(TOTAL_VOD_PAID_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(TOTAL_VOD_LEASE_AMT AS VARCHAR(50))), TRIM(CAST(TOTAL_VOD_LEASE_DURATION_MINS AS VARCHAR(50))), TRIM(CAST(ADULT_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(ADULT_LEASE_DURATION_MINS AS VARCHAR(50))), TRIM(CAST(KIDS_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(KIDS_LEASE_DURATION_MINS AS VARCHAR(50))), TRIM(CAST(MOVIE_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(MOVIE_LEASE_DURATION_MINS AS VARCHAR(50))), TRIM(CAST(MUSIC_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(MUSIC_LEASE_DURATION_MINS AS VARCHAR(50))), TRIM(CAST(NON_MUSIC_LEASE_CNT AS VARCHAR(50))), TRIM(CAST(NON_MUSIC_LEASE_DURATION_MINS AS VARCHAR(50))), TRIM(CAST(EST_TOTAL_PURCHASE_AMT AS VARCHAR(50))), TRIM(CAST(EST_MOVIE_PURCHASE_AMT AS VARCHAR(50))), TRIM(CAST(EST_SERIES_PURCHASE_AMT AS VARCHAR(50))), TRIM(CAST(EST_TOTAL_PURCHASE_CNT AS VARCHAR(50))), TRIM(CAST(EST_MOVIE_PURCHASE_CNT AS VARCHAR(50))), TRIM(CAST(EST_SERIES_PURCHASE_CNT AS VARCHAR(50))), TRIM(CAST(TOT_VIEWING_SEC AS VARCHAR(50))), TRIM(CAST(TOT_LINEAR_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(TOT_DVR_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(TOT_VOD_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(BA_VIEWING_SEC AS VARCHAR(50))), TRIM(CAST(BA_LINEAR_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(BA_DVR_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(BA_VOD_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(X1_VIEWING_SEC AS VARCHAR(50))), TRIM(CAST(X1_LINEAR_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(X1_DVR_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(X1_VOD_VIEW_SEC AS VARCHAR(50))), TRIM(CAST(TOT_CHANNEL_CNT AS VARCHAR(50))), TRIM(CAST(TOT_LINEAR_CHAN_CNT AS VARCHAR(50))), TRIM(CAST(TOT_DVR_PLAYBACK_CNT AS VARCHAR(50))), TRIM(CAST(TOT_VOD_PLAYBACK_CNT AS VARCHAR(50))), TRIM(CAST(BA_LINEAR_CHAN_CNT AS VARCHAR(50))), TRIM(CAST(BA_DVR_PLAYBACK_CNT AS VARCHAR(50))), TRIM(CAST(BA_VOD_PLAYBACK_CNT AS VARCHAR(50))), TRIM(CAST(X1_LINEAR_CHAN_CNT AS VARCHAR(50))), TRIM(CAST(X1_DVR_PLAYBACK_CNT AS VARCHAR(50))), TRIM(CAST(X1_VOD_PLAYBACK_CNT AS VARCHAR(50))), TRIM(CAST(TOT_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(TOT_LINEAR_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(TOT_DVR_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(TOT_VOD_PROGRAMS_CNT AS VARCHAR(50))), TRIM(CAST(BA_LINEAR_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(BA_DVR_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(BA_VOD_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(X1_LINEAR_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(X1_DVR_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(X1_VOD_PROGRAM_CNT AS VARCHAR(50))), TRIM(CAST(DESKTOP_LOGINS AS VARCHAR(50))), TRIM(CAST(MOBILE_WEB_LOGINS AS VARCHAR(50))), TRIM(CAST(MOBILE_APP_LOGINS AS VARCHAR(50))), TRIM(CAST(USE_SELF_SERVICE_ANY AS VARCHAR(50))), TRIM(CAST(USE_SELF_SERVICE_ALL AS VARCHAR(50))), TRIM(CAST(USE_SELF_SERVICE_DESKTOP AS VARCHAR(50))), TRIM(CAST(USE_SELF_SERVICE_MOBILE_WEB AS VARCHAR(50))), TRIM(CAST(USE_SELF_SERVICE_MOBILE_APP AS VARCHAR(50))), TRIM(CAST(FIRST_SALES_CHANNEL_GROUP AS VARCHAR(50))), TRIM(CAST(FIRST_SALES_CHANNEL AS VARCHAR(50))), TRIM(CAST(FIRST_SALES_ID AS VARCHAR(50))), TRIM(CAST(FIRST_OPERATOR_ID AS VARCHAR(50))), TRIM(CAST(VIDEO_SALES_CHANNEL_GROUP AS VARCHAR(50))), TRIM(CAST(VIDEO_SALES_CHANNEL AS VARCHAR(50))), TRIM(CAST(VIDEO_SALES_ID AS VARCHAR(50))), TRIM(CAST(VIDEO_OPERATOR_ID AS VARCHAR(50))), TRIM(CAST(HSD_SALES_CHANNEL_GROUP AS VARCHAR(50))), TRIM(CAST(HSD_SALES_CHANNEL AS VARCHAR(50))), TRIM(CAST(HSD_SALES_ID AS VARCHAR(50))), TRIM(CAST(HSD_OPERATOR_ID AS VARCHAR(50))), TRIM(CAST(CDV_SALES_CHANNEL_GROUP AS VARCHAR(50))), TRIM(CAST(CDV_SALES_CHANNEL AS VARCHAR(50))), TRIM(CAST(CDV_SALES_ID AS VARCHAR(50))), TRIM(CAST(CDV_OPERATOR_ID AS VARCHAR(50))), TRIM(CAST(XH_SALES_CHANNEL_GROUP AS VARCHAR(50))), TRIM(CAST(XH_SALES_CHANNEL AS VARCHAR(50))), TRIM(CAST(XH_SALES_ID AS VARCHAR(50))), TRIM(CAST(XH_OPERATOR_ID AS VARCHAR(50))), TRIM(CAST(CUSTOMER_CONNECT AS VARCHAR(50))), TRIM(CAST(CUSTOMER_CONNECT_DT AS VARCHAR(50))), TRIM(CAST(CUSTOMER_DISCONNECT AS VARCHAR(50))), TRIM(CAST(CUSTOMER_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(CUSTOMER_DISCONNECT_NP AS VARCHAR(50))), TRIM(CAST(CUSTOMER_DISCONNECT_VOL AS VARCHAR(50))), TRIM(CAST(CUST_DISCON_REASON_NAME AS VARCHAR(50))), TRIM(CAST(CUST_DISCON_REASON_GROUP AS VARCHAR(50))), TRIM(CAST(CUSTOMER_UPGRADE AS VARCHAR(50))), TRIM(CAST(CUSTOMER_UPGRADE_DT AS VARCHAR(50))), TRIM(CAST(CUSTOMER_DOWNGRADE AS VARCHAR(50))), TRIM(CAST(CUSTOMER_DOWNGRADE_DT AS VARCHAR(50))), TRIM(CAST(VIDEO_CONNECT AS VARCHAR(50))), TRIM(CAST(VIDEO_CONNECT_DT AS VARCHAR(50))), TRIM(CAST(VIDEO_DISCONNECT AS VARCHAR(50))), TRIM(CAST(VIDEO_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(HSD_CONNECT AS VARCHAR(50))), TRIM(CAST(HSD_CONNECT_DT AS VARCHAR(50))), TRIM(CAST(HSD_DISCONNECT AS VARCHAR(50))), TRIM(CAST(HSD_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(CDV_CONNECT AS VARCHAR(50))), TRIM(CAST(CDV_CONNECT_DT AS VARCHAR(50))), TRIM(CAST(CDV_DISCONNECT AS VARCHAR(50))), TRIM(CAST(CDV_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(XH_CONNECT AS VARCHAR(50))), TRIM(CAST(XH_CONNECT_DT AS VARCHAR(50))), TRIM(CAST(XH_DISCONNECT AS VARCHAR(50))), TRIM(CAST(XH_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(XH_RULE_CNT AS VARCHAR(50))), TRIM(CAST(XH_ARM_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_THERMOSTAT_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_CO_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_WATER_SEN_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_CAM_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_DW_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_MOTION_RUL_CNT AS VARCHAR(50))), TRIM(CAST(XH_LIGHTING_RUL_CNT AS VARCHAR(50))), TRIM(CAST(CUST_DISCON_REF_CD AS VARCHAR(50))), TRIM(CAST(CUST_DISCON_REF_DESC AS VARCHAR(50))), TRIM(CAST(VIDEO_SIK AS VARCHAR(50))), TRIM(CAST(HSD_SIK AS VARCHAR(50))), TRIM(CAST(CDV_SIK AS VARCHAR(50))), TRIM(CAST(XH_SIK AS VARCHAR(50))), TRIM(CAST(ANY_SIK AS VARCHAR(50))), TRIM(CAST(SOURCE_CUSTOMER_ACCOUNT_ID AS VARCHAR(50))), TRIM(CAST(SOURCE_ACCOUNT_NUMBER AS VARCHAR(50))), TRIM(CAST(SOURCE_LOCATION_ID AS VARCHAR(50))), TRIM(CAST(SOURCE_DISCO_DT AS VARCHAR(50))), TRIM(CAST(DEST_CUSTOMER_ACCOUNT_ID AS VARCHAR(50))), TRIM(CAST(DEST_ACCOUNT_NUMBER AS VARCHAR(50))), TRIM(CAST(DEST_LOCATION_ID AS VARCHAR(50))), TRIM(CAST(DEST_CONNECT_DT AS VARCHAR(50))), TRIM(CAST(MOVE_SOURCE AS VARCHAR(50))), TRIM(CAST(TRANSFER_STATUS AS VARCHAR(50))), TRIM(CAST(ONBOARDING_SALES_CHANNEL_GROUP AS VARCHAR(50))), TRIM(CAST(ONBOARDING_SALES_CHANNEL AS VARCHAR(50))), TRIM(CAST(DEMO_HISPANIC_IND AS VARCHAR(50))), TRIM(CAST(DEMO_HISPANIC_ACCULTURATION AS VARCHAR(50))), TRIM(CAST(DEMO_HOME_OWN_RENT AS VARCHAR(50))), TRIM(CAST(DEMO_LEN_OF_RES AS VARCHAR(50))), TRIM(CAST(DEMO_DW_TYPE AS VARCHAR(50))), TRIM(CAST(DEMO_MARITAL_STATUS AS VARCHAR(50))), TRIM(CAST(DEMO_FIRST_INDV_GENDER AS VARCHAR(50))), TRIM(CAST(DEMO_SECOND_INDV_GENDER AS VARCHAR(50))), TRIM(CAST(DEMO_INCOME_CODE AS VARCHAR(50))), TRIM(CAST(DEMO_FIRST_INDV_EDU AS VARCHAR(50))), TRIM(CAST(DEMO_CHILDREN_NUM_HH AS VARCHAR(50))), TRIM(CAST(DEMO_AVG_HH_SIZE AS VARCHAR(50))), TRIM(CAST(DEMO_NUM_ADULTS_LIVING_UNIT AS VARCHAR(50))), TRIM(CAST(DEMO_FIRST_INDV_AGE AS VARCHAR(50))), TRIM(CAST(DEMO_SECOND_INDV_AGE AS VARCHAR(50))), TRIM(CAST(DEMO_SEC_INDV_EDU AS VARCHAR(50))), TRIM(CAST(DEMO_GEO_HISPANICITY AS VARCHAR(50))), TRIM(CAST(DEMO_COMP_FOOTPRINT AS VARCHAR(50))), TRIM(CAST(DEMO_FIBER AS VARCHAR(50))), TRIM(CAST(DEMO_OCN AS VARCHAR(50))), TRIM(CAST(DEMO_OCN_NAME AS VARCHAR(50))), TRIM(CAST(BLOCK_ID AS VARCHAR(50))), TRIM(CAST(CBG AS VARCHAR(50))), TRIM(CAST(CIC AS VARCHAR(50))), TRIM(CAST(CLEC AS VARCHAR(50))), TRIM(CAST(FIBER_DATE AS VARCHAR(50))), TRIM(CAST(FIPS_COUNTY_CODE AS VARCHAR(50))), TRIM(CAST(FIPS_STATE_CODE AS VARCHAR(50))), TRIM(CAST(LATA AS VARCHAR(50))), TRIM(CAST(LATA_SUB_ZONE AS VARCHAR(50))), TRIM(CAST(LEADING_TELCO AS VARCHAR(50))), TRIM(CAST(MATCH_LEVEL AS VARCHAR(50))), TRIM(CAST(NPA AS VARCHAR(50))), TRIM(CAST(NPA_LOCATION AS VARCHAR(50))), TRIM(CAST(NXX AS VARCHAR(50))), TRIM(CAST(PLACE_NAME AS VARCHAR(50))), TRIM(CAST(PORTABILITY_IND AS VARCHAR(50))), TRIM(CAST(RATE_CENTER AS VARCHAR(50))), TRIM(CAST(RATE_CENTER_TYPE AS VARCHAR(50))), TRIM(CAST(SWITCH_CLLI AS VARCHAR(50))), TRIM(CAST(TROLL_DATE AS VARCHAR(50))), TRIM(CAST(OB1_HOLDING_COMPANY_NUMBER AS VARCHAR(50))), TRIM(CAST(OB1_HOLDING_COMPANY_NAME AS VARCHAR(50))), TRIM(CAST(OB1_PROVIDER_NAME AS VARCHAR(50))), TRIM(CAST(OB1_DBA_NAME AS VARCHAR(50))), TRIM(CAST(OB1_GENERIC_NAME AS VARCHAR(50))), TRIM(CAST(OB1_TYPE AS VARCHAR(50))), TRIM(CAST(OB1_TRIPLEPLAY_FLAG AS VARCHAR(50))), TRIM(CAST(OB1_MAX_ADVERTISED_DL_SPEED AS VARCHAR(50))), TRIM(CAST(OB1_MAX_ADVERTISED_UL_SPEED AS VARCHAR(50))), TRIM(CAST(OB2_HOLDING_COMPANY_NUMBER AS VARCHAR(50))), TRIM(CAST(OB2_HOLDING_COMPANY_NAME AS VARCHAR(50))), TRIM(CAST(OB2_PROVIDER_NAME AS VARCHAR(50))), TRIM(CAST(OB2_DBA_NAME AS VARCHAR(50))), TRIM(CAST(OB2_GENERIC_NAME AS VARCHAR(50))), TRIM(CAST(OB2_TYPE AS VARCHAR(50))), TRIM(CAST(OB2_TRIPLEPLAY_FLAG AS VARCHAR(50))), TRIM(CAST(OB2_MAX_ADVERTISED_DL_SPEED AS VARCHAR(50))), TRIM(CAST(OB2_MAX_ADVERTISED_UL_SPEED AS VARCHAR(50))), TRIM(CAST(OB3_HOLDING_COMPANY_NUMBER AS VARCHAR(50))), TRIM(CAST(OB3_HOLDING_COMPANY_NAME AS VARCHAR(50))), TRIM(CAST(OB3_PROVIDER_NAME AS VARCHAR(50))), TRIM(CAST(OB3_DBA_NAME AS VARCHAR(50))), TRIM(CAST(OB3_GENERIC_NAME AS VARCHAR(50))), TRIM(CAST(OB3_TYPE AS VARCHAR(50))), TRIM(CAST(OB3_TRIPLEPLAY_FLAG AS VARCHAR(50))), TRIM(CAST(OB3_MAX_ADVERTISED_DL_SPEED AS VARCHAR(50))), TRIM(CAST(OB3_MAX_ADVERTISED_UL_SPEED AS VARCHAR(50))), TRIM(CAST(OB4_HOLDING_COMPANY_NUMBER AS VARCHAR(50))), TRIM(CAST(OB4_HOLDING_COMPANY_NAME AS VARCHAR(50))), TRIM(CAST(OB4_PROVIDER_NAME AS VARCHAR(50))), TRIM(CAST(OB4_DBA_NAME AS VARCHAR(50))), TRIM(CAST(OB4_GENERIC_NAME AS VARCHAR(50))), TRIM(CAST(OB4_TYPE AS VARCHAR(50))), TRIM(CAST(OB4_TRIPLEPLAY_FLAG AS VARCHAR(50))), TRIM(CAST(OB4_MAX_ADVERTISED_DL_SPEED AS VARCHAR(50))), TRIM(CAST(OB4_MAX_ADVERTISED_UL_SPEED AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_INTERNET AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_INTERNET_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_INTERNET_SPEED AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_INT_ANNOUNCED_DATE AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_INT_DATE_DETERMINED AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_PRISM AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_PRISM_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_PRISM_ANNOUNCE_DATE AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_PRISM_DATE_DETERMIN AS VARCHAR(50))), TRIM(CAST(CENTURYLNK_PRISM_TROLLED_DATE AS VARCHAR(50))), TRIM(CAST(FIOS_INTERNET AS VARCHAR(50))), TRIM(CAST(FIOS_INTERNET_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(FIOS_INTERNET_ANNOUNCED_DATE AS VARCHAR(50))), TRIM(CAST(FIOS_INTERNET_DATE_DETERMINED AS VARCHAR(50))), TRIM(CAST(FIOS_INTERNET_MATCH_LEVEL AS VARCHAR(50))), TRIM(CAST(FIOS_TROLLED_DATE AS VARCHAR(50))), TRIM(CAST(FIOS_TV AS VARCHAR(50))), TRIM(CAST(FIOS_TV_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(FIOS_TV_ANNOUNCED_DATE AS VARCHAR(50))), TRIM(CAST(FIOS_TV_DATE_DETERMINED AS VARCHAR(50))), TRIM(CAST(FIOS_TV_MATCH_LEVEL AS VARCHAR(50))), TRIM(CAST(FRONTIER_INTERNET AS VARCHAR(50))), TRIM(CAST(FRONTIER_INTERNET_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(FRONTIER_INTERNET_MATCH_LEVEL AS VARCHAR(50))), TRIM(CAST(FRONTIER_INT_ANNOUNCED_DATE AS VARCHAR(50))), TRIM(CAST(FRONTIER_INT_DATE_DETERMINED AS VARCHAR(50))), TRIM(CAST(FRONTIER_TROLLED_DATE AS VARCHAR(50))), TRIM(CAST(FRONTIER_TV AS VARCHAR(50))), TRIM(CAST(FRONTIER_TV_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(FRONTIER_TV_ANNOUNCED_DATE AS VARCHAR(50))), TRIM(CAST(FRONTIER_TV_DATE_DETERMINED AS VARCHAR(50))), TRIM(CAST(FRONTIER_TV_MATCH_LEVEL AS VARCHAR(50))), TRIM(CAST(UVERSE AS VARCHAR(50))), TRIM(CAST(UVERSE_ANNOUNCED AS VARCHAR(50))), TRIM(CAST(UVERSE_ANNOUNCED_DATE AS VARCHAR(50))), TRIM(CAST(UVERSE_DATE_DETERMINED AS VARCHAR(50))), TRIM(CAST(UVERSE_INTERNET AS VARCHAR(50))), TRIM(CAST(UVERSE_MATCH_LEVEL AS VARCHAR(50))), TRIM(CAST(UVERSE_TROLLED_DATE AS VARCHAR(50))), TRIM(CAST(GENERATIONAL_KNOWN_SEG AS VARCHAR(50))), TRIM(CAST(GENERATIONAL_BACKFILL_SEG AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MIN_03_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MAX_03_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_AVG_03_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_RANGE_03_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MMR_03_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MIN_06_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MAX_06_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_AVG_06_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_RANGE_06_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MMR_06_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MIN_12_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MAX_12_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_AVG_12_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_RANGE_12_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MMR_12_MO AS VARCHAR(50))), TRIM(CAST(CALC_MRC_CURR_MONTH AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_01 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_02 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_03 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_04 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_05 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_06 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_07 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_08 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_09 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_10 AS VARCHAR(50))), TRIM(CAST(CALC_MRC_MONTH_11 AS VARCHAR(50))), TRIM(CAST(PREV_RGU_VIDEO AS VARCHAR(50))), TRIM(CAST(PREV_RGU_HSD AS VARCHAR(50))), TRIM(CAST(PREV_RGU_CDV AS VARCHAR(50))), TRIM(CAST(PREV_RGU_XH AS VARCHAR(50))), TRIM(CAST(PREV_RGU_BULK_VIDEO AS VARCHAR(50))), TRIM(CAST(PREV_RGU_BULK_HSD AS VARCHAR(50))), TRIM(CAST(PREV_RGU_BULK_CDV AS VARCHAR(50))), TRIM(CAST(PREV_NUMBER_OF_PRODUCTS AS VARCHAR(50))), TRIM(CAST(PREV_PRODUCT_MIX AS VARCHAR(50))), TRIM(CAST(PREV_VIDEO_TIER_NAME AS VARCHAR(50))), TRIM(CAST(PREV_HSD_TIER_NAME AS VARCHAR(50))), TRIM(CAST(PREV_CDV_TIER_NAME AS VARCHAR(50))), TRIM(CAST(PREV_XH_TIER_NAME AS VARCHAR(50))), TRIM(CAST(NXTMO_DISCO_MONTH_END_DT AS VARCHAR(50))), TRIM(CAST(NXTMO_CUSTOMER_DISCONNECT AS VARCHAR(50))), TRIM(CAST(NXTMO_CUSTOMER_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(NXTMO_CUSTOMER_DISCONNECT_NP AS VARCHAR(50))), TRIM(CAST(NXTMO_CUSTOMER_DISCONNECT_VOL AS VARCHAR(50))), TRIM(CAST(NXTMO_CUST_DISCON_REASON_NAME AS VARCHAR(50))), TRIM(CAST(NXTMO_CUST_DISCON_REASON_GROUP AS VARCHAR(50))), TRIM(CAST(NXTMO_VIDEO_DISCONNECT AS VARCHAR(50))), TRIM(CAST(NXTMO_VIDEO_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(NXTMO_HSD_DISCONNECT AS VARCHAR(50))), TRIM(CAST(NXTMO_HSD_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(NXTMO_CDV_DISCONNECT AS VARCHAR(50))), TRIM(CAST(NXTMO_CDV_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(NXTMO_XH_DISCONNECT AS VARCHAR(50))), TRIM(CAST(NXTMO_XH_DISCONNECT_DT AS VARCHAR(50))), TRIM(CAST(MONTHS_SINCE_LAST_HAD_VIDEO AS VARCHAR(50))), TRIM(CAST(MONTHS_SINCE_LAST_HAD_HSD AS VARCHAR(50))), TRIM(CAST(MONTHS_SINCE_LAST_HAD_CDV AS VARCHAR(50))), TRIM(CAST(MONTHS_SINCE_LAST_HAD_XH AS VARCHAR(50))), TRIM(CAST(CUSTOMER_SEGMENT_ID AS VARCHAR(50))), TRIM(CAST(CUSTOMER_SEGMENT_NAME AS VARCHAR(50))), TRIM(CAST(CHURN_VOL_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_VOL_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_VOL_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_NPD_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_NPD_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_NPD_SEGMENT AS VARCHAR(50))), TRIM(CAST(TP_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(TP_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(TP_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(TP_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(TP_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(TP_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(TP_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(TP_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(COMPLETE_CHURN_SCORE AS VARCHAR(50))), TRIM(CAST(COMPLETE_CHURN_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(COMPLETE_CHURN_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(COMPLETE_CHURN_REG_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_BAD_DEBT_SCORE AS VARCHAR(50))), TRIM(CAST(SUB_BAD_DEBT_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_BAD_DEBT_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_BAD_DEBT_REG_DECILE AS VARCHAR(50))), TRIM(CAST(FIBER_DEFECTOR_SCORE AS VARCHAR(50))), TRIM(CAST(FIBER_DEFECTOR_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(FIBER_DEFECTOR_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(FIBER_DEFECTOR_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_DWNGRD_SCORE AS VARCHAR(50))), TRIM(CAST(CHSI_DWNGRD_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_DWNGRD_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_DWNGRD_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_DWNGRD_SCORE AS VARCHAR(50))), TRIM(CAST(CDV_DWNGRD_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_DWNGRD_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_DWNGRD_REG_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_BAD_DEBT_SCORE AS VARCHAR(50))), TRIM(CAST(NONSUB_BAD_DEBT_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_BAD_DEBT_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_BAD_DEBT_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_XSELL_SCORE AS VARCHAR(50))), TRIM(CAST(DIGVID_XSELL_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_XSELL_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_XSELL_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_XSELL_SCORE AS VARCHAR(50))), TRIM(CAST(CHSI_XSELL_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_XSELL_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_XSELL_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_XSELL_SCORE AS VARCHAR(50))), TRIM(CAST(CDV_XSELL_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_XSELL_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_XSELL_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(DIGVID_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(HDTV_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(HDTV_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(HDTV_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(HDTV_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(HDTV_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(HDTV_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(HDTV_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(HDTV_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(WIRELESS_ONLY_ACX_IND AS VARCHAR(50))), TRIM(CAST(WIRELESS_ONLY_TNS_PROB AS VARCHAR(50))), TRIM(CAST(WIRELESS_ONLY_TNS_DECILE AS VARCHAR(50))), TRIM(CAST(WIRELESS_ONLY_TNS_INDEX AS VARCHAR(50))), TRIM(CAST(NONSUB_FIBER_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(NONSUB_FIBER_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_FIBER_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_FIBER_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_DBS_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(NONSUB_DBS_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_DBS_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_DBS_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_HSD_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(NONSUB_HSD_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_HSD_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_HSD_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(CHSI_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CHSI_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(CDV_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CDV_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DVR_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(DVR_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DVR_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DVR_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DVR_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(DVR_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DVR_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DVR_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(DIGVID_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(PREM_SVC_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(PREM_SVC_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(PREM_SVC_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(PREM_SVC_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CMCST_MICRO_SEG AS VARCHAR(50))), TRIM(CAST(CMCST_SUPER_SEG AS VARCHAR(50))), TRIM(CAST(NONSUB_OTM_RES_SCORE AS VARCHAR(50))), TRIM(CAST(NONSUB_OTM_RES_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_OTM_RES_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_OTM_RES_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CLV_SCORE AS VARCHAR(50))), TRIM(CAST(CLV_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(CLV_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(CLV_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DM_SUB_SCORE AS VARCHAR(50))), TRIM(CAST(DM_SUB_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DM_SUB_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DM_SUB_REG_DECILE AS VARCHAR(50))), TRIM(CAST(DM_NONSUB_SCORE AS VARCHAR(50))), TRIM(CAST(DM_NONSUB_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DM_NONSUB_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DM_NONSUB_REG_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_OTM_RES_SCORE AS VARCHAR(50))), TRIM(CAST(SUB_OTM_RES_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_OTM_RES_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_OTM_RES_REG_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_DBS_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(SUB_DBS_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_DBS_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_DBS_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_FIBER_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(SUB_FIBER_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_FIBER_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_FIBER_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(NCLV_SCORE AS VARCHAR(50))), TRIM(CAST(NCLV_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NCLV_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NCLV_REG_DECILE AS VARCHAR(50))), TRIM(CAST(VID_HSD_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(VID_HSD_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(VID_HSD_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(VID_HSD_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(ALL_VALUE_SCORE AS VARCHAR(50))), TRIM(CAST(ALL_VALUE_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(ALL_VALUE_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(ALL_VALUE_REG_DECILE AS VARCHAR(50))), TRIM(CAST(XH_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(XH_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(XH_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(XH_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(XH_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(XH_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(XH_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(XH_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(MICRO_SEG_ID AS VARCHAR(50))), TRIM(CAST(SUPER_SEG_ID AS VARCHAR(50))), TRIM(CAST(RETIRE_MICRO_SEG AS VARCHAR(50))), TRIM(CAST(RETIRE_SUPER_SEG AS VARCHAR(50))), TRIM(CAST(DIGVID_PREFER_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(DIGVID_PREFER_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_PREFER_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(DIGVID_PREFER_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(TP_HIVAL_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_ACQ_SCORE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_ACQ_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_ACQ_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_ACQ_REG_DECILE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(TP_LOWVAL_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_DIALUP_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(NONSUB_DIALUP_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_DIALUP_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(NONSUB_DIALUP_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_DIALUP_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(SUB_DIALUP_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_DIALUP_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_DIALUP_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(VZW_UPG_SCORE AS VARCHAR(50))), TRIM(CAST(VZW_UPG_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(VZW_UPG_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(VZW_UPG_REG_DECILE AS VARCHAR(50))), TRIM(CAST(MOVERS_SCORE AS VARCHAR(50))), TRIM(CAST(MOVERS_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(MOVERS_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(MOVERS_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_TOTAL_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_TOTAL_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_TOTAL_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_TOTAL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_TOTAL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_VOL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_VOL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_NPD_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_NPD_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_VIDEO_SCORE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_VIDEO_DECILE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_VIDEO_SEGMENT AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_VIDEO_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_VIDEO_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_HSD_SCORE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_HSD_DECILE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_HSD_SEGMENT AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_HSD_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_HSD_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPGRADE_VIDEO_SCORE AS VARCHAR(50))), TRIM(CAST(UPGRADE_VIDEO_DECILE AS VARCHAR(50))), TRIM(CAST(UPGRADE_VIDEO_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPGRADE_VIDEO_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPGRADE_VIDEO_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPGRADE_XHOME_SCORE AS VARCHAR(50))), TRIM(CAST(UPGRADE_XHOME_DECILE AS VARCHAR(50))), TRIM(CAST(UPGRADE_XHOME_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPGRADE_XHOME_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPGRADE_XHOME_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_CNTR_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_CNTR_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_CNTR_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_CNTR_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_CNTR_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_COMP_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_COMP_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_COMP_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_COMP_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_COMP_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_MOVE_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_MOVE_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_MOVE_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_MOVE_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_MOVE_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_SVCS_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_SVCS_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_SVCS_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_SVCS_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_SVCS_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_HISP_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_HISP_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_HISP_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_HISP_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_HISP_DECILE_REG AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP_SCORE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP_REG_DECILE AS VARCHAR(50))), TRIM(CAST(QUAD_PLAY_SCORE AS VARCHAR(50))), TRIM(CAST(QUAD_PLAY_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(QUAD_PLAY_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(QUAD_PLAY_REG_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP2_SCORE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP2_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP2_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_DM_NET_RESP2_REG_DECILE AS VARCHAR(50))), TRIM(CAST(UPGRADE_HSD_SCORE AS VARCHAR(50))), TRIM(CAST(UPGRADE_HSD_DECILE AS VARCHAR(50))), TRIM(CAST(UPGRADE_HSD_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPGRADE_HSD_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPGRADE_HSD_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_ALL_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_ALL_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_ALL_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_ALL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_ALL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2S_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2S_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2S_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2S_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2S_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_S2P_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_S2P_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_S2P_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_S2P_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_S2P_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_SPORT_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_SPORT_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_SPORT_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_SPORT_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_SPORT_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_PREM_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_PREM_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_PREM_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_PREM_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_PREM_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2P_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2P_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2P_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2P_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_VIDTIER_E2P_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_XH_SCORE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_XH_DECILE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_XH_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_INTL_SCORE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_INTL_DECILE AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_INTL_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_INTL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPG_ADDON_INTL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_X1_SCORE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_X1_DECILE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_X1_SEGMENT AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_X1_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_X1_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DELINQ_CUR_2_PD30_SCORE AS VARCHAR(50))), TRIM(CAST(DELINQ_CUR_2_PD30_DECILE AS VARCHAR(50))), TRIM(CAST(DELINQ_CUR_2_PD30_SEGMENT AS VARCHAR(50))), TRIM(CAST(DELINQ_CUR_2_PD30_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(DELINQ_CUR_2_PD30_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DELINQ_PD30_2_CUR_SCORE AS VARCHAR(50))), TRIM(CAST(DELINQ_PD30_2_CUR_DECILE AS VARCHAR(50))), TRIM(CAST(DELINQ_PD30_2_CUR_SEGMENT AS VARCHAR(50))), TRIM(CAST(DELINQ_PD30_2_CUR_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(DELINQ_PD30_2_CUR_DECILE_REG AS VARCHAR(50))), TRIM(CAST(UPGRADE_CDV_SCORE AS VARCHAR(50))), TRIM(CAST(UPGRADE_CDV_DECILE AS VARCHAR(50))), TRIM(CAST(UPGRADE_CDV_SEGMENT AS VARCHAR(50))), TRIM(CAST(UPGRADE_CDV_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(UPGRADE_CDV_DECILE_REG AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_CDV_SCORE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_CDV_DECILE AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_CDV_SEGMENT AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_CDV_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(DOWNGRADE_CDV_DECILE_REG AS VARCHAR(50))), TRIM(CAST(PROSP_COMP_HSS_SCORE AS VARCHAR(50))), TRIM(CAST(PROSP_COMP_HSS_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_COMP_HSS_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_COMP_HSS_REG_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_GEN_CONV_SCORE AS VARCHAR(50))), TRIM(CAST(PROSP_GEN_CONV_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_GEN_CONV_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_GEN_CONV_REG_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_BIZ_LIKELY_SCORE AS VARCHAR(50))), TRIM(CAST(PROSP_BIZ_LIKELY_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_BIZ_LIKELY_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(PROSP_BIZ_LIKELY_REG_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_TOTAL_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_TOTAL_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_TOTAL_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_6M_TOTAL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_6M_TOTAL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_6M_VOL_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_VOL_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_VOL_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_6M_VOL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_6M_VOL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(CHURN_6M_NPD_SCORE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_NPD_DECILE AS VARCHAR(50))), TRIM(CAST(CHURN_6M_NPD_SEGMENT AS VARCHAR(50))), TRIM(CAST(CHURN_6M_NPD_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(CHURN_6M_NPD_DECILE_REG AS VARCHAR(50))), TRIM(CAST(HSD_UPTIER_ALL_SCORE AS VARCHAR(50))), TRIM(CAST(HSD_UPTIER_ALL_DECILE AS VARCHAR(50))), TRIM(CAST(HSD_UPTIER_ALL_SEGMENT AS VARCHAR(50))), TRIM(CAST(HSD_UPTIER_ALL_DECILE_DIV AS VARCHAR(50))), TRIM(CAST(HSD_UPTIER_ALL_DECILE_REG AS VARCHAR(50))), TRIM(CAST(SUB_HSD_OWNER_SCORE AS VARCHAR(50))), TRIM(CAST(SUB_HSD_OWNER_NAT_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_HSD_OWNER_DIV_DECILE AS VARCHAR(50))), TRIM(CAST(SUB_HSD_OWNER_REG_DECILE AS VARCHAR(50))), TRIM(CAST(TOT_ET_1_OUTAGE AS VARCHAR(50))), TRIM(CAST(TOT_ET_2_PRIORITY_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(TOT_ET_3_POWER_OUTAGE AS VARCHAR(50))), TRIM(CAST(TOT_ET_4_FIBER_CUT AS VARCHAR(50))), TRIM(CAST(TOT_ET_5_SVC_CALL_NODE_ALERT AS VARCHAR(50))), TRIM(CAST(TOT_ET_6_MODERATE_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(TOT_ET_7_US_FEC AS VARCHAR(50))), TRIM(CAST(TOT_ET_8_DS_FEC AS VARCHAR(50))), TRIM(CAST(TOT_ET_11_WIFI_OUTAGE_CM AS VARCHAR(50))), TRIM(CAST(TOT_ET_12_LPI AS VARCHAR(50))), TRIM(CAST(TOT_ET_13_FLUX_OSP AS VARCHAR(50))), TRIM(CAST(TOT_ET_14_WIFI_OUTAGE_AP AS VARCHAR(50))), TRIM(CAST(TOT_ET_15_WORST_NODE AS VARCHAR(50))), TRIM(CAST(TOT_ET_16_SVC_CALL_CLSR_ALERT AS VARCHAR(50))), TRIM(CAST(TOT_ET_17_SEVERE_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(DUR_ET_1_OUTAGE AS VARCHAR(50))), TRIM(CAST(DUR_ET_2_PRIORITY_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(DUR_ET_3_POWER_OUTAGE AS VARCHAR(50))), TRIM(CAST(DUR_ET_4_FIBER_CUT AS VARCHAR(50))), TRIM(CAST(DUR_ET_5_SVC_CALL_NODE_ALERT AS VARCHAR(50))), TRIM(CAST(DUR_ET_6_MODERATE_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(DUR_ET_7_US_FEC AS VARCHAR(50))), TRIM(CAST(DUR_ET_8_DS_FEC AS VARCHAR(50))), TRIM(CAST(DUR_ET_11_WIFI_OUTAGE_CM AS VARCHAR(50))), TRIM(CAST(DUR_ET_12_LPI AS VARCHAR(50))), TRIM(CAST(DUR_ET_13_FLUX_OSP AS VARCHAR(50))), TRIM(CAST(DUR_ET_14_WIFI_OUTAGE_AP AS VARCHAR(50))), TRIM(CAST(DUR_ET_15_WORST_NODE AS VARCHAR(50))), TRIM(CAST(DUR_ET_16_SVC_CALL_CLSR_ALERT AS VARCHAR(50))), TRIM(CAST(DUR_ET_17_SEVERE_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_1_OUTAGE AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_2_PRIORITY_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_3_POWER_OUTAGE AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_4_FIBER_CUT AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_5_SVC_CALL_NODE_ALERT AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_6_MODERATE_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_7_US_FEC AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_8_DS_FEC AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_11_WIFI_OUTAGE_CM AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_12_LPI AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_13_FLUX_OSP AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_14_WIFI_OUTAGE_AP AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_15_WORST_NODE AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_16_SVC_CALL_CLSR_ALERT AS VARCHAR(50))), TRIM(CAST(UNIQ_ET_17_SEVERE_PLANT_FAULT AS VARCHAR(50))), TRIM(CAST(HIC_MAX_SCORE AS VARCHAR(50))), TRIM(CAST(HIC_MIN_SCORE AS VARCHAR(50))), TRIM(CAST(HIC_AVG_SCORE AS VARCHAR(50))), TRIM(CAST(HIC_LAST_SCORE AS VARCHAR(50))), TRIM(CAST(HIC_POLLS_COUNT AS VARCHAR(50))), TRIM(CAST(HIC_MACS_COUNT AS VARCHAR(50))), TRIM(CAST(CORP_SYSPRIN AS VARCHAR(50))), TRIM(CAST(DIVISION AS VARCHAR(50))), TRIM(CAST(REGION AS VARCHAR(50))), TRIM(CAST(ENTITY_ID AS VARCHAR(50))), TRIM(CAST(ENTITY_NAME AS VARCHAR(50))), TRIM(CAST(HEADEND AS VARCHAR(50))), TRIM(CAST(CSG_AGENT AS VARCHAR(50))), TRIM(CAST(DST_FRANCHISE_TAX_AREA AS VARCHAR(50))), TRIM(CAST(DST_MGMT_AREA AS VARCHAR(50))), TRIM(CAST(SPIN_CO AS VARCHAR(50))), TRIM(CAST(MONTH_END_DT AS VARCHAR(50)))  FROM NDW_EBI_VIEWS.ADM_201602;'" ADM_201602

------------------------------

Command Run Result

------------------------------

[aroy001c@pacdcpaprdetl1 bin] ./adm_201602.ksh
Teradata Parallel Transporter Version 14.10.00.08
Job log: /opt/teradata/client/14.10/tbuild/logs/ADM_201602-5690.out
Job id is ADM_201602-5690, running on pacdcpaprdetl1.cable.comcast.com
Teradata Parallel Transporter DataConnector Version 14.10.00.08
o_FileWritter: Instance 1 directing private log report to 'DataConnector-1'.
o_FileWritter: DataConnector Consumer operator Instances: 1
Teradata Parallel Transporter Export Operator Version 14.10.00.08
o_ExportOper: private log specified: Export-1
o_FileWritter: ECI operator ID: 'o_FileWritter-12456'
o_FileWritter: Operator instance 1 processing file '/home/aroy001c/Sample/tgtfile/adm_201602.out'.
o_ExportOper: connecting sessions
o_ExportOper: sending SELECT request
o_ExportOper: RDBMS Warning: 3705 Request executed in interpretive EVL mode.
              RDBMS subsystem or component ID: 0
o_ExportOper: entering End Export Phase
o_ExportOper: Total Rows Exported:  10000
o_FileWritter: Total files processed: 1.
o_ExportOper: disconnecting sessions
o_ExportOper: Total processor time used = '0.92 Second(s)'
o_ExportOper: Start : Wed Apr 27 06:15:46 2016
o_ExportOper: End   : Wed Apr 27 06:20:23 2016
Job step MAIN_STEP terminated (status 4)
Job ADM_201602 completed successfully, but with warning(s).
Job start: Wed Apr 27 06:15:42 2016
Job end:   Wed Apr 27 06:20:23 2016
[aroy001c@pacdcpaprdetl1 bin] echo $?
4
[aroy001c@pacdcpaprdetl1 bin]

-----------------------
TPT Job Log
----------------------

[aroy001c@pacdcpaprdetl1 logs] tlogview -l /opt/teradata/client/14.10/tbuild/logs/ADM_201602-5690.out -f DataConnector -g

Private log DataConnector:


[aroy001c@pacdcpaprdetl1 logs] tlogview -l /opt/teradata/client/14.10/tbuild/logs/ADM_201602-5690.out -f Export  -g

Private log Export:


[aroy001c@pacdcpaprdetl1 logs]

 

Again, Thanks in advance.

 

Arpan.

 

 

feinholz 1234 posts Joined 05/08
27 Apr 2016

You must consider a '4' as successful. It is the only way that the Teradata Client Load/Unload products can inform the user that there was a warning. Our products have been working this way for 30 years.

--SteveF

Arpan.Roy 24 posts Joined 04/16
28 Apr 2016

Thanks Steve.
But waht is the cause of this warning and why I'm not able to see the TPT job log using tlogview command?
Thanks & Regards,
Arpan.

feinholz 1234 posts Joined 05/08
28 Apr 2016

The warning is evident in the console output (sometimes it is in the log, but this time it is on the console).
 

o_ExportOper: RDBMS Warning: 3705 Request executed in interpretive EVL mode.

              RDBMS subsystem or component ID: 0
 
If you look up that Teradata Database warning code in the documentation, it says:
 
3705 Request executed in interpretive EVL mode.
Explanation: This is a warning only, not an error. It indicates that the current request will be executed using interpretive
EVL code rather than executable EVL code. Cases where this warning will be returned are:
a) Ran out of parser tree segments when trying to generate the executable EVL code.
b) Ran out of Plastic Step segment when trying to fit both interpretive EVL code and executable EVL code in the Plastic
Steps.
c) Ran out of space in the concrete step segment when building one large single step. In an attempt to save space, the compiled
is replaced with the interpretive EVL code. The only remedy is to simplify the query.
Generated By: GNCStEvl, GncApply.
For Whom: DBA User and System Support Representative.
Note: The request is still processed despite the warning.
Remedy: This message is for information only. To avoid the warning, user may increase the DBS Control Record field
MaxParseTreeSegs for case (a) and field StepsSegmentSize for case (b). See Teradata Utilities Manual for information on
DBS Control fields.
 

--SteveF

DiEgoR 33 posts Joined 08/06
24 May 2016

I have a similar question so posting into this thread. As per this recipe http://superuser.com/questions/318420/formatting-a-comma-delimited-csv-to-force-excel-to-interpret-value-as-a-string?lq=1
I'd like to use

DEFINE JOB qstart2
(
apply to operator ($file_writer ATTR (QuotedData='Y'
  ,OpenQuoteMark  = '"\t'
  ,CloseQuoteMark = '"'
  ,TextDelimiter  = ';'
))
  SELECT * FROM OPERATOR($EXPORT);
);

in the TPT job. How can I specify the tab so that it is inserted correctly via OpenQuoteMark?
Currently with '"\t' literally three characters ",\,t are being inserted. I need the \t to be converted into a tab.
 

input output putput

feinholz 1234 posts Joined 05/08
24 May 2016

Did you try pressing the TAB key on your keyboard?
 

--SteveF

DiEgoR 33 posts Joined 08/06
25 May 2016

I have just tried out with pressing TAB on the keyboard in vi. It gets converted to a space in the resulting exported text file. So unfortunately it does not work this way either.

input output putput

feinholz 1234 posts Joined 05/08
26 May 2016

There is an undocumented attribute called TextDelimiterHex.
Enter the hex values for those 2 characters.
The attribute is a VARCHAR attribute so put the hex values in single quotes.
 

--SteveF

DiEgoR 33 posts Joined 08/06
30 May 2016

Hmm, I actually need  the tab in the OpenQuoteMark, not in the TextDelimiter. Judging by its name seems like TextDelimiterHex should't be of help here. Or am I missing something? 

input output putput

feinholz 1234 posts Joined 05/08
31 May 2016

Ah yes, sorry about that. My mistake.
If "vi" converts the TAB to spaces, then you would have to find another way to get the real TAB character into the string. We do not currently interpret \t as meaning the TAB character.

--SteveF

CarlosAL 512 posts Joined 04/08
01 Jun 2016

Hi Steve.
I'm afraid it's not about vi. Even if you manage to get the TAB character (0x09) into the tpt script for the OpenQuoteMark attribute, tpt will replace it with one space (0x20) in the generated file.
(This happens at least in TPT 14.10.00.11).
Cheers.
Carlos. 

feinholz 1234 posts Joined 05/08
01 Jun 2016

I just found out that we actually do support "OpenQuoteMarkHex" and "CloseQuoteMarkHex" attributes.
They are not documented (mainly because we wanted to revamp how we support hex code in attribute values, but have not had the time to work on it, and did not want to de-support something after documenting them).
Give those a try and let me know if they work for you.
 

--SteveF

You must sign in to leave a comment.