All Forums Tools
mpmchic 3 posts Joined 02/14
05 Aug 2016
Fastload error: I/O Error on File Open 34

I have a large text file with 366 columns, pipe delimited.   Fastload fails with this error: Error : I/O Error on File Open: 34, Text: pmUnxDskOpen: fopen error (Invalid argument)
 
 
This is this script being run:

SHOW VERSION;

SESSIONS 4;

ERRLIMIT 500;

 

RUN file C:\scripts\fastload_logon.prn;

 

DATABASE HP_MU_OWN_TABLES;

DROP TABLE NPI_DOWNLOAD_ERROR1;

DROP TABLE NPI_DOWNLOAD_ERROR2;

DROP TABLE HP_MU_OWN_TABLES.dim_NPI_BAK;

 

 

CREATE MULTISET TABLE HP_MU_OWN_TABLES.dim_NPI_BAK ,NO FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

NPI VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

ENTITY_TYPE_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

REPLACEMENT_NPI VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

EIN VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_ORGANIZATION_LEGAL_BUSINE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LAST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_FIRST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_MIDDLE_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_NAME_PREFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_NAME_SUFFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_CREDENTIAL_TEXT VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_ORGANIZATION VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_ORGANIZATION_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_LAST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_FIRST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_MIDDLE_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_NAME_PREFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_NAME_SUFFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_CREDENTIAL VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_LAST_NAME_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_FIRST_LINE_BUSINESS_MAILI VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_SECOND_LINE_BUSINESS_MAIL VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_CITY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_STATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_POSTAL_C VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_COUNTRY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_TELEPHON VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_FAX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_FIRST_LINE_BUSINESS_LOCAT VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_SECOND_LINE_BUSINESS_LOCA VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_CITY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_STATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_POSTAL_ VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_COUNTRY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_TELEPHO VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_FAX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_ENUMERATION_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

LAST_UPDATE_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

NPI_DEACTIVATION_REASON_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

NPI_DEACTIVATION_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

NPI_REACTIVATION_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_GENDER_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_LAST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_FIRST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_MIDDLE_NAM VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_TITLE_OR_P VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_TELEPHONE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER_TYPE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER_STATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER_ISSUER VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

IS_SOLE_PROPRIETOR VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

IS_ORGANIZATION_SUBPART VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PARENT_ORGANIZATION_LBN VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PARENT_ORGANIZATION_TIN VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HEALTHCARE_PROV_TAXONOMY_GROUP VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

MAILING_ZIP5 VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,

PRACTICE_ZIP5 VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC)

 

 

PRIMARY INDEX ( NPI );

 

 

SET RECORD VARTEXT DELIMITER '|';

 

DEFINE

NPI001_NPI  (VARCHAR(128)), 

NPI002_Entity_Type_Code  (VARCHAR(128)), 

NPI003_Replacement_NPI  (VARCHAR(128)), 

NPI004_Employer_Identification_Number_EIN  (VARCHAR(128)), 

NPI005_Provider_Organization_Name_Legal_Business_Name  (VARCHAR(128)), 

NPI006_Provider_Last_Name_Legal_Name  (VARCHAR(128)), 

NPI007_Provider_First_Name  (VARCHAR(128)), 

NPI008_Provider_Middle_Name  (VARCHAR(128)), 

NPI009_Provider_Name_Prefix_Text  (VARCHAR(128)), 

NPI010_Provider_Name_Suffix_Text  (VARCHAR(128)), 

NPI011_Provider_Credential_Text  (VARCHAR(128)), 

NPI012_Provider_Other_Organization_Name  (VARCHAR(128)), 

NPI013_Provider_Other_Organization_Name_Type_Code  (VARCHAR(128)), 

NPI014_Provider_Other_Last_Name  (VARCHAR(128)), 

NPI015_Provider_Other_First_Name  (VARCHAR(128)), 

NPI016_Provider_Other_Middle_Name  (VARCHAR(128)), 

NPI017_Provider_Other_Name_Prefix_Text  (VARCHAR(128)), 

NPI018_Provider_Other_Name_Suffix_Text  (VARCHAR(128)), 

NPI019_Provider_Other_Credential_Text  (VARCHAR(128)), 

NPI020_Provider_Other_Last_Name_Type_Code  (VARCHAR(128)), 

NPI021_Provider_First_Line_Business_Mailing_Address  (VARCHAR(128)), 

NPI022_Provider_Second_Line_Business_Mailing_Address  (VARCHAR(128)), 

NPI023_Provider_Business_Mailing_Address_City_Name  (VARCHAR(128)), 

NPI024_Provider_Business_Mailing_Address_State_Name  (VARCHAR(128)), 

NPI025_Provider_Business_Mailing_Address_Postal_Code  (VARCHAR(128)), 

NPI026_Provider_Business_Mailing_Address_Country_Code  (VARCHAR(128)), 

NPI027_Provider_Business_Mailing_Address_Telephone_Num ber  (VARCHAR(128)), 

NPI028_Provider_Business_Mailing_Address_Fax_Number  (VARCHAR(128)), 

NPI029_Provider_First_Line_Business_Practice_Location_ Address  (VARCHAR(128)), 

NPI030_Provider_Second_Line_Business_Practice_Location _Address  (VARCHAR(128)), 

NPI031_Provider_Business_Practice_Location_Address_Cit y_Name  (VARCHAR(128)), 

NPI032_Provider_Business_Practice_Location_Address_Sta te_Name  (VARCHAR(128)), 

NPI033_Provider_Business_Practice_Location_Address_Pos tal_Code  (VARCHAR(128)), 

NPI034_Provider_Business_Practice_Location_Address_Cou ntry_Code  (VARCHAR(128)), 

NPI035_Provider_Business_Practice_Location_Address_Tel ephone_Number  (VARCHAR(128)), 

NPI036_Provider_Business_Practice_Location_Address_Fax _Number  (VARCHAR(128)), 

NPI037_Provider_Enumeration_Date  (VARCHAR(128)), 

NPI038_Last_Update_Date  (VARCHAR(128)), 

NPI039_NPI_Deactivation_Reason_Code  (VARCHAR(128)), 

NPI040_NPI_Deactivation_Date  (VARCHAR(128)), 

NPI041_NPI_Reactivation_Date  (VARCHAR(128)), 

NPI042_Provider_Gender_Code  (VARCHAR(128)), 

NPI043_Authorized_Official_Last_Name  (VARCHAR(128)), 

NPI044_Authorized_Official_First_Name  (VARCHAR(128)), 

NPI045_Authorized_Official_Middle_Name  (VARCHAR(128)), 

NPI046_Authorized_Official_Title_or_Position  (VARCHAR(128)), 

NPI047_Authorized_Official_Telephone_Number  (VARCHAR(128)), 

NPI048_Healthcare_Provider_Taxonomy_Code_1  (VARCHAR(128)), 

NPI049_Provider_License_Number_1  (VARCHAR(128)), 

NPI050_Provider_License_Number_State_Code_1  (VARCHAR(128)), 

NPI051_Healthcare_Provider_Primary_Taxonomy_Switch_1  (VARCHAR(128)), 

NPI052_Healthcare_Provider_Taxonomy_Code_2  (VARCHAR(128)), 

NPI053_Provider_License_Number_2  (VARCHAR(128)), 

NPI054_Provider_License_Number_State_Code_2  (VARCHAR(128)), 

NPI055_Healthcare_Provider_Primary_Taxonomy_Switch_2  (VARCHAR(128)), 

NPI056_Healthcare_Provider_Taxonomy_Code_3  (VARCHAR(128)), 

NPI057_Provider_License_Number_3  (VARCHAR(128)), 

NPI058_Provider_License_Number_State_Code_3  (VARCHAR(128)), 

NPI059_Healthcare_Provider_Primary_Taxonomy_Switch_3  (VARCHAR(128)), 

NPI060_Healthcare_Provider_Taxonomy_Code_4  (VARCHAR(128)), 

NPI061_Provider_License_Number_4  (VARCHAR(128)), 

NPI062_Provider_License_Number_State_Code_4  (VARCHAR(128)), 

NPI063_Healthcare_Provider_Primary_Taxonomy_Switch_4  (VARCHAR(128)), 

NPI064_Healthcare_Provider_Taxonomy_Code_5  (VARCHAR(128)), 

NPI065_Provider_License_Number_5  (VARCHAR(128)), 

NPI066_Provider_License_Number_State_Code_5  (VARCHAR(128)), 

NPI067_Healthcare_Provider_Primary_Taxonomy_Switch_5  (VARCHAR(128)), 

NPI068_Healthcare_Provider_Taxonomy_Code_6  (VARCHAR(128)), 

NPI069_Provider_License_Number_6  (VARCHAR(128)), 

NPI070_Provider_License_Number_State_Code_6  (VARCHAR(128)), 

NPI071_Healthcare_Provider_Primary_Taxonomy_Switch_6  (VARCHAR(128)), 

NPI072_Healthcare_Provider_Taxonomy_Code_7  (VARCHAR(128)), 

NPI073_Provider_License_Number_7  (VARCHAR(128)), 

NPI074_Provider_License_Number_State_Code_7  (VARCHAR(128)), 

NPI075_Healthcare_Provider_Primary_Taxonomy_Switch_7  (VARCHAR(128)), 

NPI076_Healthcare_Provider_Taxonomy_Code_8  (VARCHAR(128)), 

NPI077_Provider_License_Number_8  (VARCHAR(128)), 

NPI078_Provider_License_Number_State_Code_8  (VARCHAR(128)), 

NPI079_Healthcare_Provider_Primary_Taxonomy_Switch_8  (VARCHAR(128)), 

NPI080_Healthcare_Provider_Taxonomy_Code_9  (VARCHAR(128)), 

NPI081_Provider_License_Number_9  (VARCHAR(128)), 

NPI082_Provider_License_Number_State_Code_9  (VARCHAR(128)), 

NPI083_Healthcare_Provider_Primary_Taxonomy_Switch_9  (VARCHAR(128)), 

NPI084_Healthcare_Provider_Taxonomy_Code_10  (VARCHAR(128)), 

NPI085_Provider_License_Number_10  (VARCHAR(128)), 

NPI086_Provider_License_Number_State_Code_10  (VARCHAR(128)), 

NPI087_Healthcare_Provider_Primary_Taxonomy_Switch_10  (VARCHAR(128)), 

NPI088_Healthcare_Provider_Taxonomy_Code_11  (VARCHAR(128)), 

NPI089_Provider_License_Number_11  (VARCHAR(128)), 

NPI090_Provider_License_Number_State_Code_11  (VARCHAR(128)), 

NPI091_Healthcare_Provider_Primary_Taxonomy_Switch_11  (VARCHAR(128)), 

NPI092_Healthcare_Provider_Taxonomy_Code_12  (VARCHAR(128)), 

NPI093_Provider_License_Number_12  (VARCHAR(128)), 

NPI094_Provider_License_Number_State_Code_12  (VARCHAR(128)), 

NPI095_Healthcare_Provider_Primary_Taxonomy_Switch_12  (VARCHAR(128)), 

NPI096_Healthcare_Provider_Taxonomy_Code_13  (VARCHAR(128)), 

NPI097_Provider_License_Number_13  (VARCHAR(128)), 

NPI098_Provider_License_Number_State_Code_13  (VARCHAR(128)), 

NPI099_Healthcare_Provider_Primary_Taxonomy_Switch_13  (VARCHAR(128)), 

NPI100_Healthcare_Provider_Taxonomy_Code_14  (VARCHAR(128)), 

NPI101_Provider_License_Number_14  (VARCHAR(128)), 

NPI102_Provider_License_Number_State_Code_14  (VARCHAR(128)), 

NPI103_Healthcare_Provider_Primary_Taxonomy_Switch_14  (VARCHAR(128)), 

NPI104_Healthcare_Provider_Taxonomy_Code_15  (VARCHAR(128)), 

NPI105_Provider_License_Number_15  (VARCHAR(128)), 

NPI106_Provider_License_Number_State_Code_15  (VARCHAR(128)), 

NPI107_Healthcare_Provider_Primary_Taxonomy_Switch_15  (VARCHAR(128)), 

NPI108_Other_Provider_Identifier_1  (VARCHAR(128)), 

NPI109_Other_Provider_Identifier_Type_Code_1  (VARCHAR(128)), 

NPI110_Other_Provider_Identifier_State_1  (VARCHAR(128)), 

NPI111_Other_Provider_Identifier_Issuer_1  (VARCHAR(128)), 

NPI112_Other_Provider_Identifier_2  (VARCHAR(128)), 

NPI113_Other_Provider_Identifier_Type_Code_2  (VARCHAR(128)), 

NPI114_Other_Provider_Identifier_State_2  (VARCHAR(128)), 

NPI115_Other_Provider_Identifier_Issuer_2  (VARCHAR(128)), 

NPI116_Other_Provider_Identifier_3  (VARCHAR(128)), 

NPI117_Other_Provider_Identifier_Type_Code_3  (VARCHAR(128)), 

NPI118_Other_Provider_Identifier_State_3  (VARCHAR(128)), 

NPI119_Other_Provider_Identifier_Issuer_3  (VARCHAR(128)), 

NPI120_Other_Provider_Identifier_4  (VARCHAR(128)), 

NPI121_Other_Provider_Identifier_Type_Code_4  (VARCHAR(128)), 

NPI122_Other_Provider_Identifier_State_4  (VARCHAR(128)), 

NPI123_Other_Provider_Identifier_Issuer_4  (VARCHAR(128)), 

NPI124_Other_Provider_Identifier_5  (VARCHAR(128)), 

NPI125_Other_Provider_Identifier_Type_Code_5  (VARCHAR(128)), 

NPI126_Other_Provider_Identifier_State_5  (VARCHAR(128)), 

NPI127_Other_Provider_Identifier_Issuer_5  (VARCHAR(128)), 

NPI128_Other_Provider_Identifier_6  (VARCHAR(128)), 

NPI129_Other_Provider_Identifier_Type_Code_6  (VARCHAR(128)), 

NPI130_Other_Provider_Identifier_State_6  (VARCHAR(128)), 

NPI131_Other_Provider_Identifier_Issuer_6  (VARCHAR(128)), 

NPI132_Other_Provider_Identifier_7  (VARCHAR(128)), 

NPI133_Other_Provider_Identifier_Type_Code_7  (VARCHAR(128)), 

NPI134_Other_Provider_Identifier_State_7  (VARCHAR(128)), 

NPI135_Other_Provider_Identifier_Issuer_7  (VARCHAR(128)), 

NPI136_Other_Provider_Identifier_8  (VARCHAR(128)), 

NPI137_Other_Provider_Identifier_Type_Code_8  (VARCHAR(128)), 

NPI138_Other_Provider_Identifier_State_8  (VARCHAR(128)), 

NPI139_Other_Provider_Identifier_Issuer_8  (VARCHAR(128)), 

NPI140_Other_Provider_Identifier_9  (VARCHAR(128)), 

NPI141_Other_Provider_Identifier_Type_Code_9  (VARCHAR(128)), 

NPI142_Other_Provider_Identifier_State_9  (VARCHAR(128)), 

NPI143_Other_Provider_Identifier_Issuer_9  (VARCHAR(128)), 

NPI144_Other_Provider_Identifier_10  (VARCHAR(128)), 

NPI145_Other_Provider_Identifier_Type_Code_10  (VARCHAR(128)), 

NPI146_Other_Provider_Identifier_State_10  (VARCHAR(128)), 

NPI147_Other_Provider_Identifier_Issuer_10  (VARCHAR(128)), 

NPI148_Other_Provider_Identifier_11  (VARCHAR(128)), 

NPI149_Other_Provider_Identifier_Type_Code_11  (VARCHAR(128)), 

NPI150_Other_Provider_Identifier_State_11  (VARCHAR(128)), 

NPI151_Other_Provider_Identifier_Issuer_11  (VARCHAR(128)), 

NPI152_Other_Provider_Identifier_12  (VARCHAR(128)), 

NPI153_Other_Provider_Identifier_Type_Code_12  (VARCHAR(128)), 

NPI154_Other_Provider_Identifier_State_12  (VARCHAR(128)), 

NPI155_Other_Provider_Identifier_Issuer_12  (VARCHAR(128)), 

NPI156_Other_Provider_Identifier_13  (VARCHAR(128)), 

NPI157_Other_Provider_Identifier_Type_Code_13  (VARCHAR(128)), 

NPI158_Other_Provider_Identifier_State_13  (VARCHAR(128)), 

NPI159_Other_Provider_Identifier_Issuer_13  (VARCHAR(128)), 

NPI160_Other_Provider_Identifier_14  (VARCHAR(128)), 

NPI161_Other_Provider_Identifier_Type_Code_14  (VARCHAR(128)), 

NPI162_Other_Provider_Identifier_State_14  (VARCHAR(128)), 

NPI163_Other_Provider_Identifier_Issuer_14  (VARCHAR(128)), 

NPI164_Other_Provider_Identifier_15  (VARCHAR(128)), 

NPI165_Other_Provider_Identifier_Type_Code_15  (VARCHAR(128)), 

NPI166_Other_Provider_Identifier_State_15  (VARCHAR(128)), 

NPI167_Other_Provider_Identifier_Issuer_15  (VARCHAR(128)), 

NPI168_Other_Provider_Identifier_16  (VARCHAR(128)), 

NPI169_Other_Provider_Identifier_Type_Code_16  (VARCHAR(128)), 

NPI170_Other_Provider_Identifier_State_16  (VARCHAR(128)), 

NPI171_Other_Provider_Identifier_Issuer_16  (VARCHAR(128)), 

NPI172_Other_Provider_Identifier_17  (VARCHAR(128)), 

NPI173_Other_Provider_Identifier_Type_Code_17  (VARCHAR(128)), 

NPI174_Other_Provider_Identifier_State_17  (VARCHAR(128)), 

NPI175_Other_Provider_Identifier_Issuer_17  (VARCHAR(128)), 

NPI176_Other_Provider_Identifier_18  (VARCHAR(128)), 

NPI177_Other_Provider_Identifier_Type_Code_18  (VARCHAR(128)), 

NPI178_Other_Provider_Identifier_State_18  (VARCHAR(128)), 

NPI179_Other_Provider_Identifier_Issuer_18  (VARCHAR(128)), 

NPI180_Other_Provider_Identifier_19  (VARCHAR(128)), 

NPI181_Other_Provider_Identifier_Type_Code_19  (VARCHAR(128)), 

NPI182_Other_Provider_Identifier_State_19  (VARCHAR(128)), 

NPI183_Other_Provider_Identifier_Issuer_19  (VARCHAR(128)), 

NPI184_Other_Provider_Identifier_20  (VARCHAR(128)), 

NPI185_Other_Provider_Identifier_Type_Code_20  (VARCHAR(128)), 

NPI186_Other_Provider_Identifier_State_20  (VARCHAR(128)), 

NPI187_Other_Provider_Identifier_Issuer_20  (VARCHAR(128)), 

NPI188_Other_Provider_Identifier_21  (VARCHAR(128)), 

NPI189_Other_Provider_Identifier_Type_Code_21  (VARCHAR(128)), 

NPI190_Other_Provider_Identifier_State_21  (VARCHAR(128)), 

NPI191_Other_Provider_Identifier_Issuer_21  (VARCHAR(128)), 

NPI192_Other_Provider_Identifier_22  (VARCHAR(128)), 

NPI193_Other_Provider_Identifier_Type_Code_22  (VARCHAR(128)), 

NPI194_Other_Provider_Identifier_State_22  (VARCHAR(128)), 

NPI195_Other_Provider_Identifier_Issuer_22  (VARCHAR(128)), 

NPI196_Other_Provider_Identifier_23  (VARCHAR(128)), 

NPI197_Other_Provider_Identifier_Type_Code_23  (VARCHAR(128)), 

NPI198_Other_Provider_Identifier_State_23  (VARCHAR(128)), 

NPI199_Other_Provider_Identifier_Issuer_23  (VARCHAR(128)), 

NPI200_Other_Provider_Identifier_24  (VARCHAR(128)), 

NPI201_Other_Provider_Identifier_Type_Code_24  (VARCHAR(128)), 

NPI202_Other_Provider_Identifier_State_24  (VARCHAR(128)), 

NPI203_Other_Provider_Identifier_Issuer_24  (VARCHAR(128)), 

NPI204_Other_Provider_Identifier_25  (VARCHAR(128)), 

NPI205_Other_Provider_Identifier_Type_Code_25  (VARCHAR(128)), 

NPI206_Other_Provider_Identifier_State_25  (VARCHAR(128)), 

NPI207_Other_Provider_Identifier_Issuer_25  (VARCHAR(128)), 

NPI208_Other_Provider_Identifier_26  (VARCHAR(128)), 

NPI209_Other_Provider_Identifier_Type_Code_26  (VARCHAR(128)), 

NPI210_Other_Provider_Identifier_State_26  (VARCHAR(128)), 

NPI211_Other_Provider_Identifier_Issuer_26  (VARCHAR(128)), 

NPI212_Other_Provider_Identifier_27  (VARCHAR(128)), 

NPI213_Other_Provider_Identifier_Type_Code_27  (VARCHAR(128)), 

NPI214_Other_Provider_Identifier_State_27  (VARCHAR(128)), 

NPI215_Other_Provider_Identifier_Issuer_27  (VARCHAR(128)), 

NPI216_Other_Provider_Identifier_28  (VARCHAR(128)), 

NPI217_Other_Provider_Identifier_Type_Code_28  (VARCHAR(128)), 

NPI218_Other_Provider_Identifier_State_28  (VARCHAR(128)), 

NPI219_Other_Provider_Identifier_Issuer_28  (VARCHAR(128)), 

NPI220_Other_Provider_Identifier_29  (VARCHAR(128)), 

NPI221_Other_Provider_Identifier_Type_Code_29  (VARCHAR(128)), 

NPI222_Other_Provider_Identifier_State_29  (VARCHAR(128)), 

NPI223_Other_Provider_Identifier_Issuer_29  (VARCHAR(128)), 

NPI224_Other_Provider_Identifier_30  (VARCHAR(128)), 

NPI225_Other_Provider_Identifier_Type_Code_30  (VARCHAR(128)), 

NPI226_Other_Provider_Identifier_State_30  (VARCHAR(128)), 

NPI227_Other_Provider_Identifier_Issuer_30  (VARCHAR(128)), 

NPI228_Other_Provider_Identifier_31  (VARCHAR(128)), 

NPI229_Other_Provider_Identifier_Type_Code_31  (VARCHAR(128)), 

NPI230_Other_Provider_Identifier_State_31  (VARCHAR(128)), 

NPI231_Other_Provider_Identifier_Issuer_31  (VARCHAR(128)), 

NPI232_Other_Provider_Identifier_32  (VARCHAR(128)), 

NPI233_Other_Provider_Identifier_Type_Code_32  (VARCHAR(128)), 

NPI234_Other_Provider_Identifier_State_32  (VARCHAR(128)), 

NPI235_Other_Provider_Identifier_Issuer_32  (VARCHAR(128)), 

NPI236_Other_Provider_Identifier_33  (VARCHAR(128)), 

NPI237_Other_Provider_Identifier_Type_Code_33  (VARCHAR(128)), 

NPI238_Other_Provider_Identifier_State_33  (VARCHAR(128)), 

NPI239_Other_Provider_Identifier_Issuer_33  (VARCHAR(128)), 

NPI240_Other_Provider_Identifier_34  (VARCHAR(128)), 

NPI241_Other_Provider_Identifier_Type_Code_34  (VARCHAR(128)), 

NPI242_Other_Provider_Identifier_State_34  (VARCHAR(128)), 

NPI243_Other_Provider_Identifier_Issuer_34  (VARCHAR(128)), 

NPI244_Other_Provider_Identifier_35  (VARCHAR(128)), 

NPI245_Other_Provider_Identifier_Type_Code_35  (VARCHAR(128)), 

NPI246_Other_Provider_Identifier_State_35  (VARCHAR(128)), 

NPI247_Other_Provider_Identifier_Issuer_35  (VARCHAR(128)), 

NPI248_Other_Provider_Identifier_36  (VARCHAR(128)), 

NPI249_Other_Provider_Identifier_Type_Code_36  (VARCHAR(128)), 

NPI250_Other_Provider_Identifier_State_36  (VARCHAR(128)), 

NPI251_Other_Provider_Identifier_Issuer_36  (VARCHAR(128)), 

NPI252_Other_Provider_Identifier_37  (VARCHAR(128)), 

NPI253_Other_Provider_Identifier_Type_Code_37  (VARCHAR(128)), 

NPI254_Other_Provider_Identifier_State_37  (VARCHAR(128)), 

NPI255_Other_Provider_Identifier_Issuer_37  (VARCHAR(128)), 

NPI256_Other_Provider_Identifier_38  (VARCHAR(128)), 

NPI257_Other_Provider_Identifier_Type_Code_38  (VARCHAR(128)), 

NPI258_Other_Provider_Identifier_State_38  (VARCHAR(128)), 

NPI259_Other_Provider_Identifier_Issuer_38  (VARCHAR(128)), 

NPI260_Other_Provider_Identifier_39  (VARCHAR(128)), 

NPI261_Other_Provider_Identifier_Type_Code_39  (VARCHAR(128)), 

NPI262_Other_Provider_Identifier_State_39  (VARCHAR(128)), 

NPI263_Other_Provider_Identifier_Issuer_39  (VARCHAR(128)), 

NPI264_Other_Provider_Identifier_40  (VARCHAR(128)), 

NPI265_Other_Provider_Identifier_Type_Code_40  (VARCHAR(128)), 

NPI266_Other_Provider_Identifier_State_40  (VARCHAR(128)), 

NPI267_Other_Provider_Identifier_Issuer_40  (VARCHAR(128)), 

NPI268_Other_Provider_Identifier_41  (VARCHAR(128)), 

NPI269_Other_Provider_Identifier_Type_Code_41  (VARCHAR(128)), 

NPI270_Other_Provider_Identifier_State_41  (VARCHAR(128)), 

NPI271_Other_Provider_Identifier_Issuer_41  (VARCHAR(128)), 

NPI272_Other_Provider_Identifier_42  (VARCHAR(128)), 

NPI273_Other_Provider_Identifier_Type_Code_42  (VARCHAR(128)), 

NPI274_Other_Provider_Identifier_State_42  (VARCHAR(128)), 

NPI275_Other_Provider_Identifier_Issuer_42  (VARCHAR(128)), 

NPI276_Other_Provider_Identifier_43  (VARCHAR(128)), 

NPI277_Other_Provider_Identifier_Type_Code_43  (VARCHAR(128)), 

NPI278_Other_Provider_Identifier_State_43  (VARCHAR(128)), 

NPI279_Other_Provider_Identifier_Issuer_43  (VARCHAR(128)), 

NPI280_Other_Provider_Identifier_44  (VARCHAR(128)), 

NPI281_Other_Provider_Identifier_Type_Code_44  (VARCHAR(128)), 

NPI282_Other_Provider_Identifier_State_44  (VARCHAR(128)), 

NPI283_Other_Provider_Identifier_Issuer_44  (VARCHAR(128)), 

NPI284_Other_Provider_Identifier_45  (VARCHAR(128)), 

NPI285_Other_Provider_Identifier_Type_Code_45  (VARCHAR(128)), 

NPI286_Other_Provider_Identifier_State_45  (VARCHAR(128)), 

NPI287_Other_Provider_Identifier_Issuer_45  (VARCHAR(128)), 

NPI288_Other_Provider_Identifier_46  (VARCHAR(128)), 

NPI289_Other_Provider_Identifier_Type_Code_46  (VARCHAR(128)), 

NPI290_Other_Provider_Identifier_State_46  (VARCHAR(128)), 

NPI291_Other_Provider_Identifier_Issuer_46  (VARCHAR(128)), 

NPI292_Other_Provider_Identifier_47  (VARCHAR(128)), 

NPI293_Other_Provider_Identifier_Type_Code_47  (VARCHAR(128)), 

NPI294_Other_Provider_Identifier_State_47  (VARCHAR(128)), 

NPI295_Other_Provider_Identifier_Issuer_47  (VARCHAR(128)), 

NPI296_Other_Provider_Identifier_48  (VARCHAR(128)), 

NPI297_Other_Provider_Identifier_Type_Code_48  (VARCHAR(128)), 

NPI298_Other_Provider_Identifier_State_48  (VARCHAR(128)), 

NPI299_Other_Provider_Identifier_Issuer_48  (VARCHAR(128)), 

NPI300_Other_Provider_Identifier_49  (VARCHAR(128)), 

NPI301_Other_Provider_Identifier_Type_Code_49  (VARCHAR(128)), 

NPI302_Other_Provider_Identifier_State_49  (VARCHAR(128)), 

NPI303_Other_Provider_Identifier_Issuer_49  (VARCHAR(128)), 

NPI304_Other_Provider_Identifier_50  (VARCHAR(128)), 

NPI305_Other_Provider_Identifier_Type_Code_50  (VARCHAR(128)), 

NPI306_Other_Provider_Identifier_State_50  (VARCHAR(128)), 

NPI307_Other_Provider_Identifier_Issuer_50  (VARCHAR(128)), 

NPI308_Is_Sole_Proprietor  (VARCHAR(128)), 

NPI309_Is_Organization_Subpart  (VARCHAR(128)), 

NPI310_Parent_Organization_LBN  (VARCHAR(128)), 

NPI311_Parent_Organization_TIN  (VARCHAR(128)), 

NPI312_Authorized_Official_Name_Prefix_Text  (VARCHAR(128)), 

NPI313_Authorized_Official_Name_Suffix_Text  (VARCHAR(128)), 

NPI314_Authorized_Official_Credential_Text  (VARCHAR(128)), 

NPI315_Healthcare_Provider_Taxonomy_Group_1  (VARCHAR(128)), 

NPI316_Healthcare_Provider_Taxonomy_Group_2  (VARCHAR(128)), 

NPI317_Healthcare_Provider_Taxonomy_Group_3  (VARCHAR(128)), 

NPI318_Healthcare_Provider_Taxonomy_Group_4  (VARCHAR(128)), 

NPI319_Healthcare_Provider_Taxonomy_Group_5  (VARCHAR(128)), 

NPI320_Healthcare_Provider_Taxonomy_Group_6  (VARCHAR(128)), 

NPI321_Healthcare_Provider_Taxonomy_Group_7  (VARCHAR(128)), 

NPI322_Healthcare_Provider_Taxonomy_Group_8  (VARCHAR(128)), 

NPI323_Healthcare_Provider_Taxonomy_Group_9  (VARCHAR(128)), 

NPI324_Healthcare_Provider_Taxonomy_Group_10  (VARCHAR(128)), 

NPI325_Healthcare_Provider_Taxonomy_Group_11  (VARCHAR(128)), 

NPI326_Healthcare_Provider_Taxonomy_Group_12  (VARCHAR(128)), 

NPI327_Healthcare_Provider_Taxonomy_Group_13  (VARCHAR(128)), 

NPI328_Healthcare_Provider_Taxonomy_Group_14  (VARCHAR(128)), 

NPI329_Healthcare_Provider_Taxonomy_Group_15  (VARCHAR(128));

 

FILE="c:\data\npidata.txt";

 

SHOW;

 

BEGIN LOADING dim_NPI_BAK  ERRORFILES NPI_DOWNLOAD_ERROR1,NPI_DOWNLOAD_ERROR2;

 

INSERT INTO HP_MU_OWN_TABLES.dim_NPI_BAK

(

 

NPI, ENTITY_TYPE_CODE, REPLACEMENT_NPI, EIN, PROV_ORGANIZATION_LEGAL_BUSINE,

PROV_LAST_NAME, PROV_FIRST_NAME, PROV_MIDDLE_NAME, PROV_NAME_PREFIX,

PROV_NAME_SUFFIX, PROV_CREDENTIAL_TEXT, PROV_OTHER_ORGANIZATION,

PROV_OTHER_ORGANIZATION_CODE, PROV_OTHER_LAST_NAME, PROV_OTHER_FIRST_NAME,

PROV_OTHER_MIDDLE_NAME, PROV_OTHER_NAME_PREFIX, PROV_OTHER_NAME_SUFFIX,

PROV_OTHER_CREDENTIAL, PROV_OTHER_LAST_NAME_CODE, PROV_FIRST_LINE_BUSINESS_MAILI,

PROV_SECOND_LINE_BUSINESS_MAIL, PROV_BUSINESS_MAILING_CITY, PROV_BUSINESS_MAILING_STATE,

PROV_BUSINESS_MAILING_POSTAL_C, PROV_BUSINESS_MAILING_COUNTRY,

PROV_BUSINESS_MAILING_TELEPHON, PROV_BUSINESS_MAILING_FAX, PROV_FIRST_LINE_BUSINESS_LOCAT,

PROV_SECOND_LINE_BUSINESS_LOCA, PROV_BUSINESS_PRACTICE_CITY,

PROV_BUSINESS_PRACTICE_STATE, PROV_BUSINESS_PRACTICE_POSTAL_,

PROV_BUSINESS_PRACTICE_COUNTRY, PROV_BUSINESS_PRACTICE_TELEPHO,

PROV_BUSINESS_PRACTICE_FAX, PROV_ENUMERATION_DATE, LAST_UPDATE_DATE,

NPI_DEACTIVATION_REASON_CODE, NPI_DEACTIVATION_DATE, NPI_REACTIVATION_DATE,

PROV_GENDER_CODE, AUTHORIZED_OFFICIAL_LAST_NAME, AUTHORIZED_OFFICIAL_FIRST_NAME,

AUTHORIZED_OFFICIAL_MIDDLE_NAM, AUTHORIZED_OFFICIAL_TITLE_OR_P,

AUTHORIZED_OFFICIAL_TELEPHONE, HLTHCARE_PROV_TAXO_CODE, PROV_LIC_NBR,

PROV_LIC_NBR_STATE_CODE, HLTHCARE_PROV_PRIM_TAXO_SW, HLTHCARE_PROV_TAXO_CODE_2,

PROV_LIC_NBR_2, PROV_LIC_NBR_STATE_CODE_2, HLTHCARE_PROV_PRIM_TAXO_SW_2,

HLTHCARE_PROV_TAXO_CODE_3, PROV_LIC_NBR_3, PROV_LIC_NBR_STATE_CODE_3,

HLTHCARE_PROV_PRIM_TAXO_SW_3, HLTHCARE_PROV_TAXO_CODE_4, PROV_LIC_NBR_4,

PROV_LIC_NBR_STATE_CODE_4, HLTHCARE_PROV_PRIM_TAXO_SW_4, HLTHCARE_PROV_TAXO_CODE_5,

PROV_LIC_NBR_5, PROV_LIC_NBR_STATE_CODE_5, HLTHCARE_PROV_PRIM_TAXO_SW_5,

OTHER_PROV_IDENTIFIER, OTHER_PROV_IDENTIFIER_TYPE, OTHER_PROV_IDENTIFIER_STATE,

OTHER_PROV_IDENTIFIER_ISSUER, IS_SOLE_PROPRIETOR, IS_ORGANIZATION_SUBPART,

PARENT_ORGANIZATION_LBN, PARENT_ORGANIZATION_TIN, HEALTHCARE_PROV_TAXONOMY_GROUP

 

)

 

VALUES

(

:NPI001_NPI,

:NPI002_Entity_Type_Code,

:NPI003_Replacement_NPI,

:NPI004_Employer_Identification_Number_EIN,

:NPI005_Provider_Organization_Name_Legal_Business_Name ,

:NPI006_Provider_Last_Name_Legal_Name,

:NPI007_Provider_First_Name,

:NPI008_Provider_Middle_Name,

:NPI009_Provider_Name_Prefix_Text,

:NPI010_Provider_Name_Suffix_Text,

:NPI011_Provider_Credential_Text,

:NPI012_Provider_Other_Organization_Name,

:NPI013_Provider_Other_Organization_Name_Type_Code,

:NPI014_Provider_Other_Last_Name,

:NPI015_Provider_Other_First_Name,

:NPI016_Provider_Other_Middle_Name,

:NPI017_Provider_Other_Name_Prefix_Text,

:NPI018_Provider_Other_Name_Suffix_Text,

:NPI019_Provider_Other_Credential_Text,

:NPI020_Provider_Other_Last_Name_Type_Code,

:NPI021_Provider_First_Line_Business_Mailing_Address,

:NPI022_Provider_Second_Line_Business_Mailing_Address,

:NPI023_Provider_Business_Mailing_Address_City_Name,

:NPI024_Provider_Business_Mailing_Address_State_Name,

:NPI025_Provider_Business_Mailing_Address_Postal_Code,

:NPI026_Provider_Business_Mailing_Address_Country_Code ,

:NPI027_Provider_Business_Mailing_Address_Telephone_Nu mber,

:NPI028_Provider_Business_Mailing_Address_Fax_Number,

:NPI029_Provider_First_Line_Business_Practice_Location _Address,

:NPI030_Provider_Second_Line_Business_Practice_Locatio n_Address,

:NPI031_Provider_Business_Practice_Location_Address_Ci ty_Name,

:NPI032_Provider_Business_Practice_Location_Address_St ate_Name,

:NPI033_Provider_Business_Practice_Location_Address_Po stal_Code,

:NPI034_Provider_Business_Practice_Location_Address_Co untry_Code,

:NPI035_Provider_Business_Practice_Location_Address_Te lephone_Number,

:NPI036_Provider_Business_Practice_Location_Address_Fa x_Number,

:NPI037_Provider_Enumeration_Date,

:NPI038_Last_Update_Date,

:NPI039_NPI_Deactivation_Reason_Code,

:NPI040_NPI_Deactivation_Date,

:NPI041_NPI_Reactivation_Date,

:NPI042_Provider_Gender_Code,

:NPI043_Authorized_Official_Last_Name,

:NPI044_Authorized_Official_First_Name,

:NPI045_Authorized_Official_Middle_Name,

:NPI046_Authorized_Official_Title_or_Position,

:NPI047_Authorized_Official_Telephone_Number,

:NPI048_Healthcare_Provider_Taxonomy_Code_1,

:NPI049_Provider_License_Number_1,

:NPI050_Provider_License_Number_State_Code_1,

:NPI051_Healthcare_Provider_Primary_Taxonomy_Switch_1,

:NPI052_Healthcare_Provider_Taxonomy_Code_2,

:NPI053_Provider_License_Number_2,

:NPI054_Provider_License_Number_State_Code_2,

:NPI055_Healthcare_Provider_Primary_Taxonomy_Switch_2,

:NPI056_Healthcare_Provider_Taxonomy_Code_3,

:NPI057_Provider_License_Number_3,

:NPI058_Provider_License_Number_State_Code_3,

:NPI059_Healthcare_Provider_Primary_Taxonomy_Switch_3,

:NPI060_Healthcare_Provider_Taxonomy_Code_4,

:NPI061_Provider_License_Number_4,

:NPI062_Provider_License_Number_State_Code_4,

:NPI063_Healthcare_Provider_Primary_Taxonomy_Switch_4,

:NPI064_Healthcare_Provider_Taxonomy_Code_5,

:NPI065_Provider_License_Number_5,

:NPI066_Provider_License_Number_State_Code_5,

:NPI067_Healthcare_Provider_Primary_Taxonomy_Switch_5,

:NPI108_Other_Provider_Identifier_1,

:NPI109_Other_Provider_Identifier_Type_Code_1,

:NPI110_Other_Provider_Identifier_State_1,

:NPI111_Other_Provider_Identifier_Issuer_1,

:NPI308_Is_Sole_Proprietor,

:NPI309_Is_Organization_Subpart,

:NPI310_Parent_Organization_LBN,

:NPI311_Parent_Organization_TIN,

:NPI315_Healthcare_Provider_Taxonomy_Group_1

);

 

END LOADING;

 

LOGOFF;

Fred 1096 posts Joined 08/04
05 Aug 2016

Use a comma before FILE, not a semicolon.

mpmchic 3 posts Joined 02/14
08 Aug 2016

 DEFINE
   NPI001_NPI  (VARCHAR(128)), 
   NPI002_Entity_Type_Code  (VARCHAR(128)), 
   NPI003_Replacement_NPI  (VARCHAR(128)), 
   NPI004_Employer_Identification_Number_EIN  (VARCHAR(128)), 
   NPI005_Provider_Organization_Name_Legal_Business_Name  (VARCHAR(128)), 
   NPI006_Provider_Last_Name_Legal_Name  (VARCHAR(128)), 
   NPI007_Provider_First_Name  (VARCHAR(128)), 
   NPI008_Provider_Middle_Name  (VARCHAR(128)), 
   NPI009_Provider_Name_Prefix_Text  (VARCHAR(128)), 
   NPI010_Provider_Name_Suffix_Text  (VARCHAR(128)), 
   NPI011_Provider_Credential_Text  (VARCHAR(128)), 
   NPI012_Provider_Other_Organization_Name  (VARCHAR(128)), 
   NPI013_Provider_Other_Organization_Name_Type_Code  (VARCHAR(128)), 
   NPI014_Provider_Other_Last_Name  (VARCHAR(128)), 
   NPI015_Provider_Other_First_Name  (VARCHAR(128)), 
   NPI016_Provider_Other_Middle_Name  (VARCHAR(128)), 
   NPI017_Provider_Other_Name_Prefix_Text  (VARCHAR(128)), 
   NPI018_Provider_Other_Name_Suffix_Text  (VARCHAR(128)), 
   NPI019_Provider_Other_Credential_Text  (VARCHAR(128)), 
   NPI020_Provider_Other_Last_Name_Type_Code  (VARCHAR(128)), 
   NPI021_Provider_First_Line_Business_Mailing_Address  (VARCHAR(128)), 
   NPI022_Provider_Second_Line_Business_Mailing_Address  (VARCHAR(128)), 
   NPI023_Provider_Business_Mailing_Address_City_Name  (VARCHAR(128)), 
   NPI024_Provider_Business_Mailing_Address_State_Name  (VARCHAR(128)), 
   NPI025_Provider_Business_Mailing_Address_Postal_Code  (VARCHAR(128)), 
   NPI026_Provider_Business_Mailing_Address_Country_Code  (VARCHAR(128)), 
   NPI027_Provider_Business_Mailing_Address_Telephone_Number  (VARCHAR(128)), 
   NPI028_Provider_Business_Mailing_Address_Fax_Number  (VARCHAR(128)), 
   NPI029_Provider_First_Line_Business_Practice_Location_Address  (VARCHAR(128)), 
   NPI030_Provider_Second_Line_Business_Practice_Location_Address  (VARCHAR(128)), 
   NPI031_Provider_Business_Practice_Location_Address_City_Name  (VARCHAR(128)), 
   NPI032_Provider_Business_Practice_Location_Address_State_Name  (VARCHAR(128)), 
   NPI033_Provider_Business_Practice_Location_Address_Postal_Code  (VARCHAR(128)), 
   NPI034_Provider_Business_Practice_Location_Address_Country_Code  (VARCHAR(128)), 
   NPI035_Provider_Business_Practice_Location_Address_Telephone_Number  (VARCHAR(128)), 
   NPI036_Provider_Business_Practice_Location_Address_Fax_Number  (VARCHAR(128)), 
   NPI037_Provider_Enumeration_Date  (VARCHAR(128)), 
   NPI038_Last_Update_Date  (VARCHAR(128)), 
   NPI039_NPI_Deactivation_Reason_Code  (VARCHAR(128)), 
   NPI040_NPI_Deactivation_Date  (VARCHAR(128)), 
   NPI041_NPI_Reactivation_Date  (VARCHAR(128)), 
   NPI042_Provider_Gender_Code  (VARCHAR(128)), 
   NPI043_Authorized_Official_Last_Name  (VARCHAR(128)), 
   NPI044_Authorized_Official_First_Name  (VARCHAR(128)), 
   NPI045_Authorized_Official_Middle_Name  (VARCHAR(128)), 
   NPI046_Authorized_Official_Title_or_Position  (VARCHAR(128)), 
   NPI047_Authorized_Official_Telephone_Number  (VARCHAR(128)), 
   NPI048_Healthcare_Provider_Taxonomy_Code_1  (VARCHAR(128)), 
   NPI049_Provider_License_Number_1  (VARCHAR(128)), 
   NPI050_Provider_License_Number_State_Code_1  (VARCHAR(128)), 
   NPI051_Healthcare_Provider_Primary_Taxonomy_Switch_1  (VARCHAR(128)), 
   NPI052_Healthcare_Provider_Taxonomy_Code_2  (VARCHAR(128)), 
   NPI053_Provider_License_Number_2  (VARCHAR(128)), 
   NPI054_Provider_License_Number_State_Code_2  (VARCHAR(128)), 
   NPI055_Healthcare_Provider_Primary_Taxonomy_Switch_2  (VARCHAR(128)), 
   NPI056_Healthcare_Provider_Taxonomy_Code_3  (VARCHAR(128)), 
   NPI057_Provider_License_Number_3  (VARCHAR(128)), 
   NPI058_Provider_License_Number_State_Code_3  (VARCHAR(128)), 
   NPI059_Healthcare_Provider_Primary_Taxonomy_Switch_3  (VARCHAR(128)), 
   NPI060_Healthcare_Provider_Taxonomy_Code_4  (VARCHAR(128)), 
   NPI061_Provider_License_Number_4  (VARCHAR(128)), 
   NPI062_Provider_License_Number_State_Code_4  (VARCHAR(128)), 
   NPI063_Healthcare_Provider_Primary_Taxonomy_Switch_4  (VARCHAR(128)), 
   NPI064_Healthcare_Provider_Taxonomy_Code_5  (VARCHAR(128)), 
   NPI065_Provider_License_Number_5  (VARCHAR(128)), 
   NPI066_Provider_License_Number_State_Code_5  (VARCHAR(128)), 
   NPI067_Healthcare_Provider_Primary_Taxonomy_Switch_5  (VARCHAR(128)), 
   NPI068_Healthcare_Provider_Taxonomy_Code_6  (VARCHAR(128)), 
   NPI069_Provider_License_Number_6  (VARCHAR(128)), 
   NPI070_Provider_License_Number_State_Code_6  (VARCHAR(128)), 
   NPI071_Healthcare_Provider_Primary_Taxonomy_Switch_6  (VARCHAR(128)), 
   NPI072_Healthcare_Provider_Taxonomy_Code_7  (VARCHAR(128)), 
   NPI073_Provider_License_Number_7  (VARCHAR(128)), 
   NPI074_Provider_License_Number_State_Code_7  (VARCHAR(128)), 
   NPI075_Healthcare_Provider_Primary_Taxonomy_Switch_7  (VARCHAR(128)), 
   NPI076_Healthcare_Provider_Taxonomy_Code_8  (VARCHAR(128)), 
   NPI077_Provider_License_Number_8  (VARCHAR(128)), 
   NPI078_Provider_License_Number_State_Code_8  (VARCHAR(128)), 
   NPI079_Healthcare_Provider_Primary_Taxonomy_Switch_8  (VARCHAR(128)), 
   NPI080_Healthcare_Provider_Taxonomy_Code_9  (VARCHAR(128)), 
   NPI081_Provider_License_Number_9  (VARCHAR(128)), 
   NPI082_Provider_License_Number_State_Code_9  (VARCHAR(128)), 
   NPI083_Healthcare_Provider_Primary_Taxonomy_Switch_9  (VARCHAR(128)), 
   NPI084_Healthcare_Provider_Taxonomy_Code_10  (VARCHAR(128)), 
   NPI085_Provider_License_Number_10  (VARCHAR(128)), 
   NPI086_Provider_License_Number_State_Code_10  (VARCHAR(128)), 
   NPI087_Healthcare_Provider_Primary_Taxonomy_Switch_10  (VARCHAR(128)), 
   NPI088_Healthcare_Provider_Taxonomy_Code_11  (VARCHAR(128)), 
   NPI089_Provider_License_Number_11  (VARCHAR(128)), 
   NPI090_Provider_License_Number_State_Code_11  (VARCHAR(128)), 
   NPI091_Healthcare_Provider_Primary_Taxonomy_Switch_11  (VARCHAR(128)), 
   NPI092_Healthcare_Provider_Taxonomy_Code_12  (VARCHAR(128)), 
   NPI093_Provider_License_Number_12  (VARCHAR(128)), 
   NPI094_Provider_License_Number_State_Code_12  (VARCHAR(128)), 
   NPI095_Healthcare_Provider_Primary_Taxonomy_Switch_12  (VARCHAR(128)), 
   NPI096_Healthcare_Provider_Taxonomy_Code_13  (VARCHAR(128)), 
   NPI097_Provider_License_Number_13  (VARCHAR(128)), 
   NPI098_Provider_License_Number_State_Code_13  (VARCHAR(128)), 
   NPI099_Healthcare_Provider_Primary_Taxonomy_Switch_13  (VARCHAR(128)), 
   NPI100_Healthcare_Provider_Taxonomy_Code_14  (VARCHAR(128)), 
   NPI101_Provider_License_Number_14  (VARCHAR(128)), 
   NPI102_Provider_License_Number_State_Code_14  (VARCHAR(128)), 
   NPI103_Healthcare_Provider_Primary_Taxonomy_Switch_14  (VARCHAR(128)), 
   NPI104_Healthcare_Provider_Taxonomy_Code_15  (VARCHAR(128)), 
   NPI105_Provider_License_Number_15  (VARCHAR(128)), 
   NPI106_Provider_License_Number_State_Code_15  (VARCHAR(128)), 
   NPI107_Healthcare_Provider_Primary_Taxonomy_Switch_15  (VARCHAR(128)), 
   NPI108_Other_Provider_Identifier_1  (VARCHAR(128)), 
   NPI109_Other_Provider_Identifier_Type_Code_1  (VARCHAR(128)), 
   NPI110_Other_Provider_Identifier_State_1  (VARCHAR(128)), 
   NPI111_Other_Provider_Identifier_Issuer_1  (VARCHAR(128)), 
   NPI112_Other_Provider_Identifier_2  (VARCHAR(128)), 
   NPI113_Other_Provider_Identifier_Type_Code_2  (VARCHAR(128)), 
   NPI114_Other_Provider_Identifier_State_2  (VARCHAR(128)), 
   NPI115_Other_Provider_Identifier_Issuer_2  (VARCHAR(128)), 
   NPI116_Other_Provider_Identifier_3  (VARCHAR(128)), 
   NPI117_Other_Provider_Identifier_Type_Code_3  (VARCHAR(128)), 
   NPI118_Other_Provider_Identifier_State_3  (VARCHAR(128)), 
   NPI119_Other_Provider_Identifier_Issuer_3  (VARCHAR(128)), 
   NPI120_Other_Provider_Identifier_4  (VARCHAR(128)), 
   NPI121_Other_Provider_Identifier_Type_Code_4  (VARCHAR(128)), 
   NPI122_Other_Provider_Identifier_State_4  (VARCHAR(128)), 
   NPI123_Other_Provider_Identifier_Issuer_4  (VARCHAR(128)), 
   NPI124_Other_Provider_Identifier_5  (VARCHAR(128)), 
   NPI125_Other_Provider_Identifier_Type_Code_5  (VARCHAR(128)), 
   NPI126_Other_Provider_Identifier_State_5  (VARCHAR(128)), 
   NPI127_Other_Provider_Identifier_Issuer_5  (VARCHAR(128)), 
   NPI128_Other_Provider_Identifier_6  (VARCHAR(128)), 
   NPI129_Other_Provider_Identifier_Type_Code_6  (VARCHAR(128)), 
   NPI130_Other_Provider_Identifier_State_6  (VARCHAR(128)), 
   NPI131_Other_Provider_Identifier_Issuer_6  (VARCHAR(128)), 
   NPI132_Other_Provider_Identifier_7  (VARCHAR(128)), 
   NPI133_Other_Provider_Identifier_Type_Code_7  (VARCHAR(128)), 
   NPI134_Other_Provider_Identifier_State_7  (VARCHAR(128)), 
   NPI135_Other_Provider_Identifier_Issuer_7  (VARCHAR(128)), 
   NPI136_Other_Provider_Identifier_8  (VARCHAR(128)), 
   NPI137_Other_Provider_Identifier_Type_Code_8  (VARCHAR(128)), 
   NPI138_Other_Provider_Identifier_State_8  (VARCHAR(128)), 
   NPI139_Other_Provider_Identifier_Issuer_8  (VARCHAR(128)), 
   NPI140_Other_Provider_Identifier_9  (VARCHAR(128)), 
   NPI141_Other_Provider_Identifier_Type_Code_9  (VARCHAR(128)), 
   NPI142_Other_Provider_Identifier_State_9  (VARCHAR(128)), 
   NPI143_Other_Provider_Identifier_Issuer_9  (VARCHAR(128)), 
   NPI144_Other_Provider_Identifier_10  (VARCHAR(128)), 
   NPI145_Other_Provider_Identifier_Type_Code_10  (VARCHAR(128)), 
   NPI146_Other_Provider_Identifier_State_10  (VARCHAR(128)), 
   NPI147_Other_Provider_Identifier_Issuer_10  (VARCHAR(128)), 
   NPI148_Other_Provider_Identifier_11  (VARCHAR(128)), 
   NPI149_Other_Provider_Identifier_Type_Code_11  (VARCHAR(128)), 
   NPI150_Other_Provider_Identifier_State_11  (VARCHAR(128)), 
   NPI151_Other_Provider_Identifier_Issuer_11  (VARCHAR(128)), 
   NPI152_Other_Provider_Identifier_12  (VARCHAR(128)), 
   NPI153_Other_Provider_Identifier_Type_Code_12  (VARCHAR(128)), 
   NPI154_Other_Provider_Identifier_State_12  (VARCHAR(128)), 
   NPI155_Other_Provider_Identifier_Issuer_12  (VARCHAR(128)), 
   NPI156_Other_Provider_Identifier_13  (VARCHAR(128)), 
   NPI157_Other_Provider_Identifier_Type_Code_13  (VARCHAR(128)), 
   NPI158_Other_Provider_Identifier_State_13  (VARCHAR(128)), 
   NPI159_Other_Provider_Identifier_Issuer_13  (VARCHAR(128)), 
   NPI160_Other_Provider_Identifier_14  (VARCHAR(128)), 
   NPI161_Other_Provider_Identifier_Type_Code_14  (VARCHAR(128)), 
   NPI162_Other_Provider_Identifier_State_14  (VARCHAR(128)), 
   NPI163_Other_Provider_Identifier_Issuer_14  (VARCHAR(128)), 
   NPI164_Other_Provider_Identifier_15  (VARCHAR(128)), 
   NPI165_Other_Provider_Identifier_Type_Code_15  (VARCHAR(128)), 
   NPI166_Other_Provider_Identifier_State_15  (VARCHAR(128)), 
   NPI167_Other_Provider_Identifier_Issuer_15  (VARCHAR(128)), 
   NPI168_Other_Provider_Identifier_16  (VARCHAR(128)), 
   NPI169_Other_Provider_Identifier_Type_Code_16  (VARCHAR(128)), 
   NPI170_Other_Provider_Identifier_State_16  (VARCHAR(128)), 
   NPI171_Other_Provider_Identifier_Issuer_16  (VARCHAR(128)), 
   NPI172_Other_Provider_Identifier_17  (VARCHAR(128)), 
   NPI173_Other_Provider_Identifier_Type_Code_17  (VARCHAR(128)), 
   NPI174_Other_Provider_Identifier_State_17  (VARCHAR(128)), 
   NPI175_Other_Provider_Identifier_Issuer_17  (VARCHAR(128)), 
   NPI176_Other_Provider_Identifier_18  (VARCHAR(128)), 
   NPI177_Other_Provider_Identifier_Type_Code_18  (VARCHAR(128)), 
   NPI178_Other_Provider_Identifier_State_18  (VARCHAR(128)), 
   NPI179_Other_Provider_Identifier_Issuer_18  (VARCHAR(128)), 
   NPI180_Other_Provider_Identifier_19  (VARCHAR(128)), 
   NPI181_Other_Provider_Identifier_Type_Code_19  (VARCHAR(128)), 
   NPI182_Other_Provider_Identifier_State_19  (VARCHAR(128)), 
   NPI183_Other_Provider_Identifier_Issuer_19  (VARCHAR(128)), 
   NPI184_Other_Provider_Identifier_20  (VARCHAR(128)), 
   NPI185_Other_Provider_Identifier_Type_Code_20  (VARCHAR(128)), 
   NPI186_Other_Provider_Identifier_State_20  (VARCHAR(128)), 
   NPI187_Other_Provider_Identifier_Issuer_20  (VARCHAR(128)), 
   NPI188_Other_Provider_Identifier_21  (VARCHAR(128)), 
   NPI189_Other_Provider_Identifier_Type_Code_21  (VARCHAR(128)), 
   NPI190_Other_Provider_Identifier_State_21  (VARCHAR(128)), 
   NPI191_Other_Provider_Identifier_Issuer_21  (VARCHAR(128)), 
   NPI192_Other_Provider_Identifier_22  (VARCHAR(128)), 
   NPI193_Other_Provider_Identifier_Type_Code_22  (VARCHAR(128)), 
   NPI194_Other_Provider_Identifier_State_22  (VARCHAR(128)), 
   NPI195_Other_Provider_Identifier_Issuer_22  (VARCHAR(128)), 
   NPI196_Other_Provider_Identifier_23  (VARCHAR(128)), 
   NPI197_Other_Provider_Identifier_Type_Code_23  (VARCHAR(128)), 
   NPI198_Other_Provider_Identifier_State_23  (VARCHAR(128)), 
   NPI199_Other_Provider_Identifier_Issuer_23  (VARCHAR(128)), 
   NPI200_Other_Provider_Identifier_24  (VARCHAR(128)), 
   NPI201_Other_Provider_Identifier_Type_Code_24  (VARCHAR(128)), 
   NPI202_Other_Provider_Identifier_State_24  (VARCHAR(128)), 
   NPI203_Other_Provider_Identifier_Issuer_24  (VARCHAR(128)), 
   NPI204_Other_Provider_Identifier_25  (VARCHAR(128)), 
   NPI205_Other_Provider_Identifier_Type_Code_25  (VARCHAR(128)), 
   NPI206_Other_Provider_Identifier_State_25  (VARCHAR(128)), 
   NPI207_Other_Provider_Identifier_Issuer_25  (VARCHAR(128)), 
   NPI208_Other_Provider_Identifier_26  (VARCHAR(128)), 
   NPI209_Other_Provider_Identifier_Type_Code_26  (VARCHAR(128)), 
   NPI210_Other_Provider_Identifier_State_26  (VARCHAR(128)), 
   NPI211_Other_Provider_Identifier_Issuer_26  (VARCHAR(128)), 
   NPI212_Other_Provider_Identifier_27  (VARCHAR(128)), 
   NPI213_Other_Provider_Identifier_Type_Code_27  (VARCHAR(128)), 
   NPI214_Other_Provider_Identifier_State_27  (VARCHAR(128)), 
   NPI215_Other_Provider_Identifier_Issuer_27  (VARCHAR(128)), 
   NPI216_Other_Provider_Identifier_28  (VARCHAR(128)), 
   NPI217_Other_Provider_Identifier_Type_Code_28  (VARCHAR(128)), 
   NPI218_Other_Provider_Identifier_State_28  (VARCHAR(128)), 
   NPI219_Other_Provider_Identifier_Issuer_28  (VARCHAR(128)), 
   NPI220_Other_Provider_Identifier_29  (VARCHAR(128)), 
   NPI221_Other_Provider_Identifier_Type_Code_29  (VARCHAR(128)), 
   NPI222_Other_Provider_Identifier_State_29  (VARCHAR(128)), 
   NPI223_Other_Provider_Identifier_Issuer_29  (VARCHAR(128)), 
   NPI224_Other_Provider_Identifier_30  (VARCHAR(128)), 
   NPI225_Other_Provider_Identifier_Type_Code_30  (VARCHAR(128)), 
   NPI226_Other_Provider_Identifier_State_30  (VARCHAR(128)), 
   NPI227_Other_Provider_Identifier_Issuer_30  (VARCHAR(128)), 
   NPI228_Other_Provider_Identifier_31  (VARCHAR(128)), 
   NPI229_Other_Provider_Identifier_Type_Code_31  (VARCHAR(128)), 
   NPI230_Other_Provider_Identifier_State_31  (VARCHAR(128)), 
   NPI231_Other_Provider_Identifier_Issuer_31  (VARCHAR(128)), 
   NPI232_Other_Provider_Identifier_32  (VARCHAR(128)), 
   NPI233_Other_Provider_Identifier_Type_Code_32  (VARCHAR(128)), 
   NPI234_Other_Provider_Identifier_State_32  (VARCHAR(128)), 
   NPI235_Other_Provider_Identifier_Issuer_32  (VARCHAR(128)), 
   NPI236_Other_Provider_Identifier_33  (VARCHAR(128)), 
   NPI237_Other_Provider_Identifier_Type_Code_33  (VARCHAR(128)), 
   NPI238_Other_Provider_Identifier_State_33  (VARCHAR(128)), 
   NPI239_Other_Provider_Identifier_Issuer_33  (VARCHAR(128)), 
   NPI240_Other_Provider_Identifier_34  (VARCHAR(128)), 
   NPI241_Other_Provider_Identifier_Type_Code_34  (VARCHAR(128)), 
   NPI242_Other_Provider_Identifier_State_34  (VARCHAR(128)), 
   NPI243_Other_Provider_Identifier_Issuer_34  (VARCHAR(128)), 
   NPI244_Other_Provider_Identifier_35  (VARCHAR(128)), 
   NPI245_Other_Provider_Identifier_Type_Code_35  (VARCHAR(128)), 
   NPI246_Other_Provider_Identifier_State_35  (VARCHAR(128)), 
   NPI247_Other_Provider_Identifier_Issuer_35  (VARCHAR(128)), 
   NPI248_Other_Provider_Identifier_36  (VARCHAR(128)), 
   NPI249_Other_Provider_Identifier_Type_Code_36  (VARCHAR(128)), 
   NPI250_Other_Provider_Identifier_State_36  (VARCHAR(128)), 
   NPI251_Other_Provider_Identifier_Issuer_36  (VARCHAR(128)), 
   NPI252_Other_Provider_Identifier_37  (VARCHAR(128)), 
   NPI253_Other_Provider_Identifier_Type_Code_37  (VARCHAR(128)), 
   NPI254_Other_Provider_Identifier_State_37  (VARCHAR(128)), 
   NPI255_Other_Provider_Identifier_Issuer_37  (VARCHAR(128)), 
   NPI256_Other_Provider_Identifier_38  (VARCHAR(128)), 
   NPI257_Other_Provider_Identifier_Type_Code_38  (VARCHAR(128)), 
   NPI258_Other_Provider_Identifier_State_38  (VARCHAR(128)), 
   NPI259_Other_Provider_Identifier_Issuer_38  (VARCHAR(128)), 
   NPI260_Other_Provider_Identifier_39  (VARCHAR(128)), 
   NPI261_Other_Provider_Identifier_Type_Code_39  (VARCHAR(128)), 
   NPI262_Other_Provider_Identifier_State_39  (VARCHAR(128)), 
   NPI263_Other_Provider_Identifier_Issuer_39  (VARCHAR(128)), 
   NPI264_Other_Provider_Identifier_40  (VARCHAR(128)), 
   NPI265_Other_Provider_Identifier_Type_Code_40  (VARCHAR(128)), 
   NPI266_Other_Provider_Identifier_State_40  (VARCHAR(128)), 
   NPI267_Other_Provider_Identifier_Issuer_40  (VARCHAR(128)), 
   NPI268_Other_Provider_Identifier_41  (VARCHAR(128)), 
   NPI269_Other_Provider_Identifier_Type_Code_41  (VARCHAR(128)), 
   NPI270_Other_Provider_Identifier_State_41  (VARCHAR(128)), 
   NPI271_Other_Provider_Identifier_Issuer_41  (VARCHAR(128)), 
   NPI272_Other_Provider_Identifier_42  (VARCHAR(128)), 
   NPI273_Other_Provider_Identifier_Type_Code_42  (VARCHAR(128)), 
   NPI274_Other_Provider_Identifier_State_42  (VARCHAR(128)), 
   NPI275_Other_Provider_Identifier_Issuer_42  (VARCHAR(128)), 
   NPI276_Other_Provider_Identifier_43  (VARCHAR(128)), 
   NPI277_Other_Provider_Identifier_Type_Code_43  (VARCHAR(128)), 
   NPI278_Other_Provider_Identifier_State_43  (VARCHAR(128)), 
   NPI279_Other_Provider_Identifier_Issuer_43  (VARCHAR(128)), 
   NPI280_Other_Provider_Identifier_44  (VARCHAR(128)), 
   NPI281_Other_Provider_Identifier_Type_Code_44  (VARCHAR(128)), 
   NPI282_Other_Provider_Identifier_State_44  (VARCHAR(128)), 
   NPI283_Other_Provider_Identifier_Issuer_44  (VARCHAR(128)), 
   NPI284_Other_Provider_Identifier_45  (VARCHAR(128)), 
   NPI285_Other_Provider_Identifier_Type_Code_45  (VARCHAR(128)), 
   NPI286_Other_Provider_Identifier_State_45  (VARCHAR(128)), 
   NPI287_Other_Provider_Identifier_Issuer_45  (VARCHAR(128)), 
   NPI288_Other_Provider_Identifier_46  (VARCHAR(128)), 
   NPI289_Other_Provider_Identifier_Type_Code_46  (VARCHAR(128)), 
   NPI290_Other_Provider_Identifier_State_46  (VARCHAR(128)), 
   NPI291_Other_Provider_Identifier_Issuer_46  (VARCHAR(128)), 
   NPI292_Other_Provider_Identifier_47  (VARCHAR(128)), 
   NPI293_Other_Provider_Identifier_Type_Code_47  (VARCHAR(128)), 
   NPI294_Other_Provider_Identifier_State_47  (VARCHAR(128)), 
   NPI295_Other_Provider_Identifier_Issuer_47  (VARCHAR(128)), 
   NPI296_Other_Provider_Identifier_48  (VARCHAR(128)), 
   NPI297_Other_Provider_Identifier_Type_Code_48  (VARCHAR(128)), 
   NPI298_Other_Provider_Identifier_State_48  (VARCHAR(128)), 
   NPI299_Other_Provider_Identifier_Issuer_48  (VARCHAR(128)), 
   NPI300_Other_Provider_Identifier_49  (VARCHAR(128)), 
   NPI301_Other_Provider_Identifier_Type_Code_49  (VARCHAR(128)), 
   NPI302_Other_Provider_Identifier_State_49  (VARCHAR(128)), 
   NPI303_Other_Provider_Identifier_Issuer_49  (VARCHAR(128)), 
   NPI304_Other_Provider_Identifier_50  (VARCHAR(128)), 
   NPI305_Other_Provider_Identifier_Type_Code_50  (VARCHAR(128)), 
   NPI306_Other_Provider_Identifier_State_50  (VARCHAR(128)), 
   NPI307_Other_Provider_Identifier_Issuer_50  (VARCHAR(128)), 
   NPI308_Is_Sole_Proprietor  (VARCHAR(128)), 
   NPI309_Is_Organization_Subpart  (VARCHAR(128)), 
   NPI310_Parent_Organization_LBN  (VARCHAR(128)), 
   NPI311_Parent_Organization_TIN  (VARCHAR(128)), 
   NPI312_Authorized_Official_Name_Prefix_Text  (VARCHAR(128)), 
   NPI313_Authorized_Official_Name_Suffix_Text  (VARCHAR(128)), 
   NPI314_Authorized_Official_Credential_Text  (VARCHAR(128)), 
   NPI315_Healthcare_Provider_Taxonomy_Group_1  (VARCHAR(128)), 
   NPI316_Healthcare_Provider_Taxonomy_Group_2  (VARCHAR(128)), 
   NPI317_Healthcare_Provider_Taxonomy_Group_3  (VARCHAR(128)), 
   NPI318_Healthcare_Provider_Taxonomy_Group_4  (VARCHAR(128)), 
   NPI319_Healthcare_Provider_Taxonomy_Group_5  (VARCHAR(128)), 
   NPI320_Healthcare_Provider_Taxonomy_Group_6  (VARCHAR(128)), 
   NPI321_Healthcare_Provider_Taxonomy_Group_7  (VARCHAR(128)), 
   NPI322_Healthcare_Provider_Taxonomy_Group_8  (VARCHAR(128)), 
   NPI323_Healthcare_Provider_Taxonomy_Group_9  (VARCHAR(128)), 
   NPI324_Healthcare_Provider_Taxonomy_Group_10  (VARCHAR(128)), 
   NPI325_Healthcare_Provider_Taxonomy_Group_11  (VARCHAR(128)), 
   NPI326_Healthcare_Provider_Taxonomy_Group_12  (VARCHAR(128)), 
   NPI327_Healthcare_Provider_Taxonomy_Group_13  (VARCHAR(128)), 
   NPI328_Healthcare_Provider_Taxonomy_Group_14  (VARCHAR(128)), 
   NPI329_Healthcare_Provider_Taxonomy_Group_15  (VARCHAR(128)),

 FILE="c:\data\npidata.txt";

thank you Fred, that worked!  I copied out the corrected DEFINE statement.
 
 
 
 

Ivyuan 63 posts Joined 01/10
11 Aug 2016

Hi,
Glad to know that it worked after correcting the syntax error. It would be nice for FastLoad not to issue the misleading message which leads to a Teradata DataConnector related error. Teradata FastLoad team will be fixing this misleading message issue.
Thanks!

You must sign in to leave a comment.