Schedule F2-Data Feed Non-Medicare Medical.csv

Request for Proposal No. 250000003097 ,,,,,,, Health Insurance Database Management System for Michigan Office of Retirement Services ,,,,,,, #Table Name, File Format, Fixed record length,,,,, BCBS_MI_EDW_MEDICALv2, Delimited,,,,,, # Description: ,,,,,,, # Column Layouts:,,,,,,, # col name, alias, missing value, type, start, length, file missing value, format RECTYP, RECTYP,, Character(1),1,1,, ASCII CUSTID, CUSTID,, Character(20),2,20,, ASCII CARRIERID, CARRIERID,, Character(20),3,20,, ASCII GRPSEGID, GRPSEGID,, Character(20),4,20,, ASCII GRPNBR, GRPNBR,, Character(20),5,20,, ASCII SEGMENTCD, SEGMENTCD,, Character(20),6,20,, ASCII GRPNAME, GRPNAME,, Character(80),7,80,, ASCII SUBNATPLAN, SUBNATPLAN,, Character(20),8,20,, ASCII NASCOPLANCD, NASCOPLANCD,, Character(20),9,20,, ASCII HOSTPLANCD, HOSTPLANCD,, Character(20),10,20,, ASCII SUBNATPKGCD, SUBNATPKGCD,, Character(20),11,20,, ASCII SRCSYSCD, SRCSYSCD,, Character(20),12,20,, ASCII CONTRACTNBR, CONTRACTNBR,, Character(20),13,20,, ASCII CLAIMID, CLAIMID,, Integer,14,38,, ASCII LINENBR, LINENBR,, Integer,15,38,, ASCII CLMCTRLNBR, CLMCTRLNBR,, Character(20),16,20,, ASCII EMPSSN, EMPSSN,, Character(20),17,20,, ASCII SUBFIRSTNAME, SUBFIRSTNAME,, Character(80),18,80,, ASCII SUBMIDNAME, SUBMIDNAME,, Character(80),19,80,, ASCII SUBLASTNAME, SUBLASTNAME,, Character(80),20,80,, ASCII SUBZIP, SUBZIP,, Character(20),21,20,, ASCII HICNBR, HICNBR,, Character(20),22,20,, ASCII MEMBERID, MEMBERID,, Integer,23,38,, ASCII MEMSSN, MEMSSN,, Character(20),24,20,, ASCII FIRSTNAME, FIRSTNAME,, Character(80),25,80,, ASCII MIDNAME, MIDNAME,, Character(80),26,80,, ASCII LASTNAME, LASTNAME,, Character(80),27,80,, ASCII MEMSUFFIX, MEMSUFFIX,, Character(35),28,35,, ASCII PATDOB, PATDOB,, Date,29,38,, ASCII YYYYMMDD GENDER, GENDER,, Character(20),30,20,, ASCII EMPREL, EMPREL,, Character(20),31,20,, ASCII CLMTYP, CLMTYP,, Integer,32,20,, ASCII RECIND, RECIND,, Character(20),33,20,, ASCII CLMSTATUSCD, CLMSTATUSCD,, Character(20),34,20,, ASCII RECEIPTDT, RECEIPTDT,, Date,35,38,, ASCII YYYYMMDD PAIDDT, PAIDDT,, Date,36,38,, ASCII YYYYMMDD ADJTYP, ADJTYP,, Character(20),37,20,, ASCII ADJREASCD, ADJREASCD,, Character(20),38,20,, ASCII ADJNBR, ADJNBR,, Character(20),39,20,, ASCII FIRSTSVCDT, FIRSTSVCDT,, Date,40,38,, ASCII YYYYMMDD LASTSVCDT, LASTSVCDT,, Date,41,38,, ASCII YYYYMMDD ADMITDT, ADMITDT,, Date,42,38,, ASCII YYYYMMDD DISCHARGEDT, DISCHARGEDT,, Date,43,38,, ASCII YYYYMMDD ACCIDENTDT, ACCIDENTDT,, Date,44,38,, ASCII YYYYMMDD FACILITYCD, FACILITYCD,, Integer,45,20,, ASCII PLACE, PLACE,, Character(20),46,20,, ASCII BILLTYP, BILLTYP,, Character(20),47,20,, ASCII ADMITTYP, ADMITTYP,, Character(20),48,20,, ASCII ADMITSRC, ADMITSRC,, Character(20),49,20,, ASCII DSTATUS, DSTATUS,, Character(20),50,20,, ASCII COBIND, COBIND,, Character(20),51,20,, ASCII COBSAVINGSIND, COBSAVINGSIND,, Character(20),52,20,, ASCII MEDICAREIND, MEDICAREIND,, Character(20),53,20,, ASCII PREAUTHIND, PREAUTHIND,, Character(20),54,20,, ASCII EMERGENCYIND, EMERGENCYIND,, Character(1),55,1,, ASCII REFIND, REFIND,, Character(20),56,20,, ASCII PDNTWK, PDNTWK,, Character(20),57,20,, ASCII NTWKPROV, NTWKPROV,, Character(20),58,20,, ASCII INOUTPANELIND, INOUTPANELIND,, Character(20),59,20,, ASCII FULLYINSIND, FULLYINSIND,, Character(20),60,20,, ASCII PCESDRGCD, PCESDRGCD,, Character(20),61,20,, ASCII DRGIND, DRGIND,, Character(20),62,20,, ASCII ICDVERSCD, ICDVERSCD,, Character(20),63,20,, ASCII DX1, DX1,, Character(20),64,20,, ASCII DX2, DX2,, Character(20),65,20,, ASCII DX3, DX3,, Character(20),66,20,, ASCII DX4, DX4,, Character(20),67,20,, ASCII DX5, DX5,, Character(20),68,20,, ASCII DX6, DX6,, Character(20),69,20,, ASCII DX7, DX7,, Character(20),70,20,, ASCII DX8, DX8,, Character(20),71,20,, ASCII DX9, DX9,, Character(20),72,20,, ASCII DX10, DX10,, Character(20),73,20,, ASCII DX11, DX11,, Character(20),74,20,, ASCII DX12, DX12,, Character(20),75,20,, ASCII DX13, DX13,, Character(20),76,20,, ASCII DX14, DX14,, Character(20),77,20,, ASCII DX15, DX15,, Character(20),78,20,, ASCII DX16, DX16,, Character(20),79,20,, ASCII DX17, DX17,, Character(20),80,20,, ASCII DX18, DX18,, Character(20),81,20,, ASCII DX19, DX19,, Character(20),82,20,, ASCII DX20, DX20,, Character(20),83,20,, ASCII DX21, DX21,, Character(20),84,20,, ASCII DX22, DX22,, Character(20),85,20,, ASCII DX23, DX23,, Character(20),86,20,, ASCII DX24, DX24,, Character(20),87,20,, ASCII DX25, DX25,, Character(20),88,20,, ASCII DX26, DX26,, Character(20),89,20,, ASCII DX27, DX27,, Character(20),90,20,, ASCII DX28, DX28,, Character(20),91,20,, ASCII DX29, DX29,, Character(20),92,20,, ASCII DX30, DX30,, Character(20),93,20,, ASCII DX31, DX31,, Character(20),94,20,, ASCII DX32, DX32,, Character(20),95,20,, ASCII DX33, DX33,, Character(20),96,20,, ASCII DX34, DX34,, Character(20),97,20,, ASCII DX35, DX35,, Character(20),98,20,, ASCII DX36, DX36,, Character(20),99,20,, ASCII DX37, DX37,, Character(20),100,20,, ASCII REVCD, REVCD,, Character(20),101,20,, ASCII SVCTYP, SVCTYP,, Character(20),102,20,, ASCII PROCCD, PROCCD,, Character(20),103,20,, ASCII PROCMOD1, PROCMOD1,, Character(20),104,20,, ASCII PROCMOD2, PROCMOD2,, Character(20),105,20,, ASCII PROCMOD3, PROCMOD3,, Character(20),106,20,, ASCII ICDPROCCD01, ICDPROCCD01,, Character(20),107,20,, ASCII ICDPROCCD02, ICDPROCCD02,, Character(20),108,20,, ASCII ICDPROCCD03, ICDPROCCD03,, Character(20),109,20,, ASCII ICDPROCCD04, ICDPROCCD04,, Character(20),110,20,, ASCII ICDPROCCD05, ICDPROCCD05,, Character(20),111,20,, ASCII ICDPROCCD06, ICDPROCCD06,, Character(20),112,20,, ASCII ICDPROCCD07, ICDPROCCD07,, Character(20),113,20,, ASCII ICDPROCCD08, ICDPROCCD08,, Character(20),114,20,, ASCII ICDPROCCD09, ICDPROCCD09,, Character(20),115,20,, ASCII ICDPROCCD10, ICDPROCCD10,, Character(20),116,20,, ASCII ICDPROCCD11, ICDPROCCD11,, Character(20),117,20,, ASCII ICDPROCCD12, ICDPROCCD12,, Character(20),118,20,, ASCII ICDPROCCD13, ICDPROCCD13,, Character(20),119,20,, ASCII ICDPROCCD14, ICDPROCCD14,, Character(20),120,20,, ASCII ICDPROCCD15, ICDPROCCD15,, Character(20),121,20,, ASCII ICDPROCCD16, ICDPROCCD16,, Character(20),122,20,, ASCII ICDPROCCD17, ICDPROCCD17,, Character(20),123,20,, ASCII ICDPROCCD18, ICDPROCCD18,, Character(20),124,20,, ASCII ICDPROCCD19, ICDPROCCD19,, Character(20),125,20,, ASCII ICDPROCCD20, ICDPROCCD20,, Character(20),126,20,, ASCII ICDPROCCD21, ICDPROCCD21,, Character(20),127,20,, ASCII ICDPROCCD22, ICDPROCCD22,, Character(20),128,20,, ASCII ICDPROCCD23, ICDPROCCD23,, Character(20),129,20,, ASCII ICDPROCCD24, ICDPROCCD24,, Character(20),130,20,, ASCII ICDPROCCD25, ICDPROCCD25,, Character(20),131,20,, ASCII POA01, POA01,, Character(20),132,20,, ASCII POA02, POA02,, Character(20),133,20,, ASCII POA03, POA03,, Character(20),134,20,, ASCII POA04, POA04,, Character(20),135,20,, ASCII POA05, POA05,, Character(20),136,20,, ASCII POA06, POA06,, Character(20),137,20,, ASCII POA07, POA07,, Character(20),138,20,, ASCII POA08, POA08,, Character(20),139,20,, ASCII POA09, POA09,, Character(20),140,20,, ASCII POA10, POA10,, Character(20),141,20,, ASCII POA11, POA11,, Character(20),142,20,, ASCII POA12, POA12,, Character(20),143,20,, ASCII POA13, POA13,, Character(20),144,20,, ASCII POA14, POA14,, Character(20),145,20,, ASCII POA15, POA15,, Character(20),146,20,, ASCII POA16, POA16,, Character(20),147,20,, ASCII POA17, POA17,, Character(20),148,20,, ASCII POA18, POA18,, Character(20),149,20,, ASCII POA19, POA19,, Character(20),150,20,, ASCII POA20, POA20,, Character(20),151,20,, ASCII POA21, POA21,, Character(20),152,20,, ASCII POA22, POA22,, Character(20),153,20,, ASCII POA23, POA23,, Character(20),154,20,, ASCII POA24, POA24,, Character(20),155,20,, ASCII POA25, POA25,, Character(20),156,20,, ASCII POA26, POA26,, Character(20),157,20,, ASCII POA27, POA27,, Character(20),158,20,, ASCII POA28, POA28,, Character(20),159,20,, ASCII POA29, POA29,, Character(20),160,20,, ASCII POA30, POA30,, Character(20),161,20,, ASCII POA31, POA31,, Character(20),162,20,, ASCII POA32, POA32,, Character(20),163,20,, ASCII POA33, POA33,, Character(20),164,20,, ASCII POA34, POA34,, Character(20),165,20,, ASCII POA35, POA35,, Character(20),166,20,, ASCII POA36, POA36,, Character(20),167,20,, ASCII QTYSVCS, QTYSVCS,, Integer,168,38,, ASCII DAYS, DAYS,, Integer,169,38,, ASCII PMTLIABCD, PMTLIABCD,, Character(18),170,18,, ASCII CHGSUBMIT, CHGSUBMIT,, Float,171,18,, ASCII APPRVCHGAMT, APPRVCHGAMT,, Float,172,18,, ASCII CHGALLOW, CHGALLOW,, Float,173,18,, ASCII SECCHGALLOW, SECCHGALLOW,, Float,174,18,, ASCII DISCAMT, DISCAMT,, Float,175,18,, ASCII GRPLIABAMT, GRPLIABAMT,, Float,176,18,, ASCII NETPAY, NETPAY,, Float,177,18,, ASCII COPAYAMT, COPAYAMT,, Float,178,18,, ASCII COINSAMT, COINSAMT,, Float,179,18,, ASCII DEDUCTAMT, DEDUCTAMT,, Float,180,18,, ASCII ACCESSFEEAMT, ACCESSFEEAMT,, Float,181,18,, ASCII OTHMEMLIABAMT, OTHMEMLIABAMT,, Float,182,18,, ASCII NONCOVCHGAMT, NONCOVCHGAMT,, Float,183,18,, ASCII THIRDPARTY, THIRDPARTY,, Float,184,18,, ASCII TOTMEMLIABAMT, TOTMEMLIABAMT,, Float,185,18,, ASCII MCAREAMT, MCAREAMT,, Float,186,18,, ASCII CHECKNUM, CHECKNUM,, Character(38),187,38,, ASCII SANCTIONCD1, SANCTIONCD1,, Character(20),188,20,, ASCII SANCTIONCD2, SANCTIONCD2,, Character(20),189,20,, ASCII SANCTIONCD3, SANCTIONCD3,, Character(20),190,20,, ASCII SANCTIONCD4, SANCTIONCD4,, Character(20),191,20,, ASCII SANCTIONAMT1, SANCTIONAMT1,, Float,192,18,, ASCII SANCTIONAMT2, SANCTIONAMT2,, Float,193,18,, ASCII SANCTIONAMT3, SANCTIONAMT3,, Float,194,18,, ASCII SANCTIONAMT4, SANCTIONAMT4,, Float,195,18,, ASCII PROVID, PROVID,, Character(20),196,20,, ASCII PROVTAXID, PROVTAXID,, Character(20),197,20,, ASCII PROVTAXIDSEQ, PROVTAXIDSEQ,, Character(20),198,20,, ASCII PROVLICENSE, PROVLICENSE,, Character(20),199,20,, ASCII NPI, NPI,, Character(20),200,20,, ASCII PROVFIRSTNAME, PROVFIRSTNAME,, Character(80),201,80,, ASCII PROVMIDNAME, PROVMIDNAME,, Character(35),202,35,, ASCII PROVLASTNAME, PROVLASTNAME,, Character(80),203,80,, ASCII PROVADDR1, PROVADDR1,, Character(100),204,100,, ASCII PROVADDR2, PROVADDR2,, Character(100),205,100,, ASCII PROVCITY, PROVCITY,, Character(20),206,20,, ASCII PROVSTATE, PROVSTATE,, Character(20),207,20,, ASCII PROVZIP, PROVZIP,, Character(9),208,9,, ASCII PROVTYPE, PROVTYPE,, Character(20),209,20,, ASCII PROVSPCLTY, PROVSPCLTY,, Character(20),210,20,, ASCII PROVSUBSPCLTY, PROVSUBSPCLTY,, Character(20),211,20,, ASCII PROVCLSCD, PROVCLSCD,, Character(20),212,20,, ASCII PROVFORM, PROVFORM,, Character(20),213,20,, ASCII PROVORGNAME, PROVORGNAME,, Character(100),214,100,, ASCII PROVPHONE, PROVPHONE,, Character(20),215,20,, ASCII PROVFAXNUM, PROVFAXNUM,, Character(20),216,20,, ASCII FILLER1, FILLER1,, Character(1),217,1,, ASCII FILLER2, FILLER2,, Character(1),218,1,, ASCII FILLER3, FILLER3,, Character(1),219,1,, ASCII FILLER4, FILLER4,, Character(1),220,1,, ASCII FILLER5, FILLER5,, Character(1),221,1,, ASCII FILLER6, FILLER6,, Character(1),222,1,, ASCII FILLER7, FILLER7,, Character(1),223,1,, ASCII FILLER8, FILLER8,, Character(1),224,1,, ASCII FILLER9, FILLER9,, Character(1),225,1,, ASCII FILLER10, FILLER10,, Character(1),226,1,, ASCII BILLPRVID, BILLPRVID,, Character(20),227,20,, ASCII BILLPROVTAXID, BILLPROVTAXID,, Character(20),228,20,, ASCII BILLPROVLICENSE, BILLPROVLICENSE,, Character(20),229,20,, ASCII BILLPROVNPI, BILLPROVNPI,, Character(20),230,20,, ASCII BILLPROVFIRSTNAME, BILLPROVFIRSTNAME,, Character(80),231,80,, ASCII BILLPROVMIDNAME, BILLPROVMIDNAME,, Character(80),232,80,, ASCII BILLPROVLASTNAME, BILLPROVLASTNAME,, Character(80),233,80,, ASCII BILLPROVADDR1, BILLPROVADDR1,, Character(100),234,100,, ASCII BILLPROVADDR2, BILLPROVADDR2,, Character(100),235,100,, ASCII BILLPROVCITY, BILLPROVCITY,, Character(20),236,20,, ASCII BILLPROVSTATE, BILLPROVSTATE,, Character(20),237,20,, ASCII BILLPROVZIP, BILLPROVZIP,, Character(20),238,20,, ASCII REFPROVID, REFPROVID,, Character(20),239,20,, ASCII REFPROVFORM, REFPROVFORM,, Character(20),240,20,, ASCII ATTPROVID, ATTPROVID,, Character(20),241,20,, ASCII DISPCD1, DISPCD1,, Character(20),242,20,, ASCII DISPCD2, DISPCD2,, Character(20),243,20,, ASCII RBBQUALCD, RBBQUALCD,, Character(20),244,20,, ASCII RBBPROCCDCAT, RBBPROCCDCAT,, Character(20),245,20,, ASCII RBBBENCATIND, RBBBENCATIND,, Character(1),246,1,, ASCII RBBMAXCHGALLOW, RBBMAXCHGALLOW,, Float,247,18,, ASCII RBBEXCESSAMT, RBBEXCESSAMT,, Float,248,18,, ASCII RBBEXCESSOOPAMT, RBBEXCESSOOPAMT,, Float,249,18,, ASCII RBBOOPIND, RBBOOPIND,, Character(1),250,1,, ASCII RBBREMAINAMT, RBBREMAINAMT,, Float,251,18,, ASCII FILLER11, FILLER11,, Character(1),252,1,, ASCII FILLER12, FILLER12,, Character(1),253,1,, ASCII FILLER13, FILLER13,, Character(1),254,1,, ASCII FILLER14, FILLER14,, Character(1),255,1,, ASCII FILLER15, FILLER15,, Character(1),256,1,, ASCII FILLER16, FILLER16,, Character(1),257,1,, ASCII FILLER17, FILLER17,, Character(1),258,1,, ASCII FILLER18, FILLER18,, Character(1),259,1,, ASCII FILLER19, FILLER19,, Character(1),260,1,, ASCII FILLER20, FILLER20,, Character(1),261,1,, ASCII FILLER21, FILLER21,, Character(1),262,1,, ASCII FILLER22, FILLER22,, Character(1),263,1,, ASCII FILLER23, FILLER23,, Character(1),264,1,, ASCII FILLER24, FILLER24,, Character(1),265,1,, ASCII FILLER25, FILLER25,, Character(1),266,1,, ASCII FILLER26, FILLER26,, Character(1),267,1,, ASCII FILLER27, FILLER27,, Character(1),268,1,, ASCII FILLER28, FILLER28,, Character(1),269,1,, ASCII FILLER29, FILLER29,, Character(1),270,1,, ASCII FILLER30, FILLER30,, Character(1),271,1,, ASCII FILLER31, FILLER31,, Character(1),272,1,, ASCII FILLER32, FILLER32,, Character(1),273,1,, ASCII FILLER33, FILLER33,, Character(1),274,1,, ASCII FILLER34, FILLER34,, Character(1),275,1,, ASCII FILLER35, FILLER35,, Character(1),276,1,, ASCII FILLER36, FILLER36,, Character(1),277,1,, ASCII FILLER37, FILLER37,, Character(1),278,1,, ASCII FILLER38, FILLER38,, Character(1),279,1,, ASCII FILLER39, FILLER39,, Character(1),280,1,, ASCII FILLER40, FILLER40,, Character(1),281,1,, ASCII FILLER41, FILLER41,, Character(1),282,1,, ASCII FILLER42, FILLER42,, Character(1),283,1,, ASCII FILLER43, FILLER43,, Character(1),284,1,, ASCII FILLER44, FILLER44,, Character(1),285,1,, ASCII FILLER45, FILLER45,, Character(1),286,1,, ASCII FILLER46, FILLER46,, Character(1),287,1,, ASCII FILLER47, FILLER47,, Character(1),288,1,, ASCII FILLER48, FILLER48,, Character(1),289,1,, ASCII FILLER49, FILLER49,, Character(1),290,1,, ASCII FILLER50, FILLER50,, Character(1),291,1,, ASCII FILLER51, FILLER51,, Character(1),292,1,, ASCII FILLER52, FILLER52,, Character(1),293,1,, ASCII FILLER53, FILLER53,, Character(1),294,1,, ASCII FILLER54, FILLER54,, Character(1),295,1,, ASCII FILLER55, FILLER55,, Character(1),296,1,, ASCII