ASCII value of the delimiter in TPT Export Operator

Tools & Utilities
Enthusiast

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)

17 REPLIES
Teradata Employee

Re: ASCII value of the delimiter in TPT Export Operator

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
Enthusiast

Re: ASCII value of the delimiter in TPT Export Operator

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. 

Teradata Employee

Re: ASCII value of the delimiter in TPT Export Operator

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
Enthusiast

Re: ASCII value of the delimiter in TPT Export Operator

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.

Teradata Employee

Re: ASCII value of the delimiter in TPT Export Operator

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
Enthusiast

Re: ASCII value of the delimiter in TPT Export Operator

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.

Teradata Employee

Re: ASCII value of the delimiter in TPT Export Operator

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
Enthusiast

Re: ASCII value of the delimiter in TPT Export Operator

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.

Teradata Employee

Re: ASCII value of the delimiter in TPT Export Operator

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