KIDSDD Table - Attachment for RFP 1001251152

Table Name Table Description Field Name Field Description Field Type Field Length Decimal Places Required
AGENCY Service Agency Code and Name AGENCYCODE nyc agency code C 5 0 False
AGENCY Service Agency Code and Name CODE agency code C 7 0 False
AGENCY Service Agency Code and Name FACILITYC nyc facility code C 4 0 False
AGENCY Service Agency Code and Name MAILTO nyc mail to (what ?) C 1 0 False
AGENCY Service Agency Code and Name NAME agency name C 35 0 False
AGENCY Service Agency Code and Name UDF_1 user defined field 1 C 20 0 False
AGENCY Service Agency Code and Name UDF_2 user defined field 2 C 20 0 False
AGENCY Service Agency Code and Name UNITCODE nyc unit code C 5 0 False
APPOINT I-CHAP Appointment tracking AG_CODE agency code C 7 0 True
APPOINT I-CHAP Appointment tracking APPT_TYPE appointment type C 1 0 False
APPOINT I-CHAP Appointment tracking HOMEDATE home visit date D 8 0 False
APPOINT I-CHAP Appointment tracking HOMEVISIT home visit needed ? L 1 0 False
APPOINT I-CHAP Appointment tracking ID system generated id C 8 0 False
APPOINT I-CHAP Appointment tracking LASTCONT last contact type C 1 0 False
APPOINT I-CHAP Appointment tracking MISSDATE appointment date D 8 0 False
APPOINT I-CHAP Appointment tracking NEXTDATE next appointment date D 8 0 False
APPOINT I-CHAP Appointment tracking NFAMCALL # calls to family N 2 0 False
APPOINT I-CHAP Appointment tracking NFAMLET # letter to family N 2 0 False
APPOINT I-CHAP Appointment tracking NFAMVIS # of family visits N 2 0 False
APPOINT I-CHAP Appointment tracking NPROVCALL # calls to provider N 2 0 False
APPOINT I-CHAP Appointment tracking NPROVLET # letter to provider N 2 0 False
APPOINT I-CHAP Appointment tracking NPROVVIS # of provider visits N 2 0 False
APPOINT I-CHAP Appointment tracking OUTCOME outcome of appointment track C 1 0 False
APPOINT I-CHAP Appointment tracking PROBLEM problem for tracking C 1 0 False
APPOINT I-CHAP Appointment tracking RECDATE last contact date D 8 0 False
ARCHIVE Bill Archive File AMOUNT amount provider billed N 8 2 False
ARCHIVE Bill Archive File BALANCE balance=amount-other(not used) N 8 2 False
ARCHIVE Bill Archive File BDATE Billing date on provider bill D 8 0 False
ARCHIVE Bill Archive File BEN_DATE Bill entering date D 8 0 False
ARCHIVE Bill Archive File BILINSID INSURANCE COMPANY BILLED TO C 8 0 False
ARCHIVE Bill Archive File BILL_STA Bill status (hold/process) C 1 0 False
ARCHIVE Bill Archive File CK_AMOUNT nys_price N 8 2 False
ARCHIVE Bill Archive File CK_BATCH check batch number C 5 0 False
ARCHIVE Bill Archive File CK_DATE check start processing date D 8 0 False
ARCHIVE Bill Archive File CK_IDATE check issued date D 8 0 False
ARCHIVE Bill Archive File CK_NUMBER check # C 12 0 False
ARCHIVE Bill Archive File CK_PAID total $ on check (check #) N 9 2 False
ARCHIVE Bill Archive File CK_RESULT check result C 1 0 False
ARCHIVE Bill Archive File COMMENSU commensurate flag C 1 0 False
ARCHIVE Bill Archive File DENYCODE REJECTION CODE FOR INSURANCE C 1 0 False
ARCHIVE Bill Archive File EIAGENCY e.i. billing agency code C 9 0 False
ARCHIVE Bill Archive File ICD9_PROC icd9 for procedure code C 6 0 False
ARCHIVE Bill Archive File ID system id C 8 0 False
ARCHIVE Bill Archive File ID_PROV provider ID C 8 0 False
ARCHIVE Bill Archive File ID_SVC authorization number C 8 0 False
ARCHIVE Bill Archive File INS_BATCH insurance process batch number C 5 0 False
ARCHIVE Bill Archive File INS_BDATE date billing insurance D 8 0 False
ARCHIVE Bill Archive File INS_EDATE insurance return/respone date D 8 0 False
ARCHIVE Bill Archive File INS_PAID amount insurance paid N 8 2 False
ARCHIVE Bill Archive File INS_RESULT result of billing insurance C 1 0 False
ARCHIVE Bill Archive File INS_YN private insurance (yes/no) C 1 0 False
ARCHIVE Bill Archive File INVOICE medicaid invoice number C 9 0 False
ARCHIVE Bill Archive File MD_BATCH medicaid process batch number C 5 0 False
ARCHIVE Bill Archive File MED_BDATE date billing medicaid D 8 0 False
ARCHIVE Bill Archive File MED_BILL medicaid billable (True/False) L 1 0 False
ARCHIVE Bill Archive File MED_NRSUB # of resubmits 0-9 N 1 0 False
ARCHIVE Bill Archive File MED_PAID amount medicaid paid N 8 2 False
ARCHIVE Bill Archive File MED_RDATE medicaid return/response date D 8 0 False
ARCHIVE Bill Archive File MED_RSTA medicaid reconcile result C 1 0 False
ARCHIVE Bill Archive File MED_TECH medicaid for assist tech C 1 0 False
ARCHIVE Bill Archive File MED_TRAN medicaid for transportation C 1 0 False
ARCHIVE Bill Archive File NUM_ADJ number of adjustments N 2 0 False
ARCHIVE Bill Archive File NYS_EXPAMT nys reimbursement exp amount N 8 2 False
ARCHIVE Bill Archive File NYS_EXPRST nys reimbursement exp result C 1 0 False
ARCHIVE Bill Archive File NYS_PRICE nys_rate X units N 8 2 False
ARCHIVE Bill Archive File NYS_RATE rate based on svc date N 8 2 False
ARCHIVE Bill Archive File NY_BATCH billing NYS process batch # C 5 0 False
ARCHIVE Bill Archive File NY_DATE date billing NYS D 8 0 False
ARCHIVE Bill Archive File NY_INVOICE invoice for billing NYS C 6 0 False
ARCHIVE Bill Archive File NY_PAID (ck_amount-ins_paid-med_pai)/2 N 8 2 False
ARCHIVE Bill Archive File NY_RDATE NYS result/respone date D 8 0 False
ARCHIVE Bill Archive File NY_RESULT billing NYS result C 1 0 False
ARCHIVE Bill Archive File NY_RESULT2 record disk update ny_result C 1 0 False
ARCHIVE Bill Archive File OCK_AMOUNT old nys price N 8 2 False
ARCHIVE Bill Archive File OINS_PAID old amount insurance paid N 8 2 False
ARCHIVE Bill Archive File OMED_PAID old amount medicaid paid N 8 2 False
ARCHIVE Bill Archive File ONY_PAID old amount nys paid N 8 2 False
ARCHIVE Bill Archive File OTH_PAID amount other paid N 8 2 False
ARCHIVE Bill Archive File PC_CODE procedure code C 7 0 False
ARCHIVE Bill Archive File PROC_STA bill process status C 1 0 False
ARCHIVE Bill Archive File PV_INVOICE provider invoice number C 12 0 False
ARCHIVE Bill Archive File RETROBILL # of retroactive billing N 1 0 False
ARCHIVE Bill Archive File RTR_BATCH Provider Retro Batch Number C 5 0 False
ARCHIVE Bill Archive File RTR_STA A=pay prv B=prv rec C=prv adj C 1 0 False
ARCHIVE Bill Archive File SBDATE date of service beginning D 8 0 False
ARCHIVE Bill Archive File SEDATE date of service ending D 8 0 False
ARCHIVE Bill Archive File UNITS number of units N 3 0 False
BAGENCY provider's billing agency AG_ADDR1 address 1 C 25 0 False
BAGENCY provider's billing agency AG_ADDR2 address 2 C 25 0 False
BAGENCY provider's billing agency AG_CITY city C 17 0 False
BAGENCY provider's billing agency AG_CODE agency code C 9 0 True
BAGENCY provider's billing agency AG_COOR service coordination L 1 0 True
BAGENCY provider's billing agency AG_CTT_CTY is contract with county C 1 0 True
BAGENCY provider's billing agency AG_CTT_ED contract end date D 8 0 False
BAGENCY provider's billing agency AG_CTT_NUM contract with county number C 12 0 True
BAGENCY provider's billing agency AG_CTT_SD contract start datE D 8 0 False
BAGENCY provider's billing agency AG_CTYEI county e.i. program C 1 0 True
BAGENCY provider's billing agency AG_EADDR1 address 1 of authorized C 25 0 False
BAGENCY provider's billing agency AG_EADDR2 address 1 of authorized C 25 0 False
BAGENCY provider's billing agency AG_ECITY city of authorized C 17 0 False
BAGENCY provider's billing agency AG_EPHONE phone of authorized C 12 0 False
BAGENCY provider's billing agency AG_ESTATE state of authorized C 2 0 False
BAGENCY provider's billing agency AG_EVAL evaluation and multi-disc. L 1 0 True
BAGENCY provider's billing agency AG_EZIP zip of authorized C 10 0 False
BAGENCY provider's billing agency AG_NAME billing agency name C 35 0 True
BAGENCY provider's billing agency AG_PARNAME participant name C 35 0 False
BAGENCY provider's billing agency AG_PHONE telephone C 12 0 False
BAGENCY provider's billing agency AG_RESP respite L 1 0 True
BAGENCY provider's billing agency AG_SSN social security number C 11 0 False
BAGENCY provider's billing agency AG_STATE state C 2 0 False
BAGENCY provider's billing agency AG_SVC services L 1 0 True
BAGENCY provider's billing agency AG_TECH tech assist L 1 0 True
BAGENCY provider's billing agency AG_TIN tax information number C 9 0 True
BAGENCY provider's billing agency AG_TRAN transpotation L 1 0 True
BAGENCY provider's billing agency AG_USETIN ssn or tin C 1 0 False
BAGENCY provider's billing agency AG_ZIP zip C 10 0 True
BAGENCY provider's billing agency IF_DATE date sent to IFMS (Suffolk) D 8 0 True
BAGENCY provider's billing agency IF_SEND need to send to ifms (suffolk) C 1 0 True
BAGENCY provider's billing agency IF_VENDOR ifms vendor for Suffolk C 1 0 True
BAGENCY provider's billing agency REF_LINE Nassau NUMIS system ref. line C 4 0 False
BATCH batch control file ACTIVITY batch activity code C 2 0 False
BATCH batch control file BATCH batch number C 6 0 False
BATCH batch control file BDATE beginning date D 8 0 False
BATCH batch control file DATESENT date of batch activity perform D 8 0 False
BATCH batch control file EDATE ending date D 8 0 False
BATCH batch control file REC_SENT number of records sent N 7 0 False
BATCH batch control file STATUS % reconciled C 20 0 False
BILL Billing AMOUNT amount provider billed N 8 2 True
BILL Billing BALANCE balance=amount-other(not used) N 8 2 True
BILL Billing BDATE Billing date on provider bill D 8 0 True
BILL Billing BEN_DATE Bill entering date D 8 0 True
BILL BILLING BILINSID INSURANCE COMPANY BILLED TO C 8 0 False
BILL Billing BILL_STA Bill status (hold/process) C 1 0 True
BILL Billing CK_AMOUNT nys_price N 8 2 True
BILL Billing CK_BATCH check batch number C 5 0 True
BILL Billing CK_DATE check start processing date D 8 0 True
BILL Billing CK_IDATE check issued date D 8 0 True
BILL Billing CK_NUMBER check # C 12 0 True
BILL Billing CK_PAID total $ on check (check #) N 9 2 True
BILL Billing CK_RESULT check result C 1 0 True
BILL Billing COMMENSU commensurate flag C 1 0 True
BILL Billing DENYCODE REJECTION CODE FOR INSURANCE C 1 0 True
BILL Billing EIAGENCY e.i. billing agency code C 9 0 True
BILL Billing ICD9_PROC icd9 for procedure code C 6 0 False
BILL Billing ID system id C 8 0 True
BILL Billing ID_PROV provider ID C 8 0 True
BILL Billing ID_SVC authorization number C 8 0 True
BILL Billing INS_BATCH insurance process batch number C 5 0 False
BILL Billing INS_BDATE date billing insurance D 8 0 True
BILL Billing INS_EDATE insurance return/respone date D 8 0 True
BILL Billing INS_PAID amount insurance paid N 8 2 True
BILL Billing INS_RESULT result of billing insurance C 1 0 True
BILL Billing INS_YN private insurance (yes/no) C 1 0 True
BILL Billing INVOICE medicaid invoice number C 9 0 False
BILL Billing MD_BATCH medicaid process batch number C 5 0 False
BILL Billing MED_BDATE date billing medicaid D 8 0 True
BILL Billing MED_BILL medicaid billable (True/False) L 1 0 True
BILL Billing MED_NRSUB # of resubmits 0-9 N 1 0 False
BILL Billing MED_PAID amount medicaid paid N 8 2 True
BILL Billing MED_RDATE medicaid return/response date D 8 0 True
BILL Billing MED_RSTA medicaid reconcile result C 1 0 True
BILL Billing MED_TECH medicaid for assist tech C 1 0 True
BILL Billing MED_TRAN medicaid for transportation C 1 0 True
BILL Billing NUM_ADJ number of adjustments N 2 0 True
BILL Billing NYS_EXPAMT nys reimbursement exp amount N 8 2 False
BILL Billing NYS_EXPRST nys reimbursement exp result C 1 0 True
BILL Billing NYS_PRICE nys_rate X units N 8 2 True
BILL Billing NYS_RATE rate based on svc date N 8 2 True
BILL Billing NY_BATCH billing NYS process batch # C 5 0 False
BILL Billing NY_DATE date billing NYS D 8 0 True
BILL Billing NY_INVOICE invoice for billing NYS C 6 0 False
BILL Billing NY_PAID (ck_amount-ins_paid-med_pai)/2 N 8 2 True
BILL Billing NY_RDATE NYS result/respone date D 8 0 True
BILL Billing NY_RESULT billing NYS result C 1 0 True
BILL Billing NY_RESULT2 record disk update ny_result C 1 0 False
BILL Billing OCK_AMOUNT old nys price N 8 2 True
BILL Billing OINS_PAID old amount insurance paid N 8 2 True
BILL Billing OMED_PAID old amount medicaid paid N 8 2 True
BILL Billing ONY_PAID old amount nys paid N 8 2 True
BILL Billing OTH_PAID amount other paid N 8 2 True
BILL Billing PC_CODE procedure code C 7 0 True
BILL Billing PROC_STA bill process status C 1 0 True
BILL Billing PV_INVOICE provider invoice number C 12 0 False
BILL Billing RETROBILL # of retroactive billing N 1 0 True
BILL Billing RTR_BATCH Provider Retro Batch Number C 5 0 True
BILL Billing RTR_STA A=pay prv B=prv rec C=prv adj C 1 0 True
BILL Billing SBDATE date of service beginning D 8 0 True
BILL Billing SEDATE date of service ending D 8 0 True
BILL Billing UNITS number of units N 3 0 True
BILLADJ bill adjustment ADJ_AMOUNT adjust amount N 8 2 True
BILLADJ bill adjustment ADJ_DATE adjustment date D 8 0 True
BILLADJ bill adjustment ADJ_NOTE notes C 40 0 True
BILLADJ bill adjustment ADJ_TYPE adjustment type C 1 0 True
BILLADJ bill adjustment ID ID C 8 0 True
BILLADJ bill adjustment ID_PROV PROVIDER ID C 8 0 True
BILLADJ bill adjustment ID_SVC service id C 8 0 True
BILLADJ bill adjustment NY_ADJAMT nys adjustment amount N 8 2 True
BILLADJ bill adjustment NY_ADJRST adjustment result C 1 0 True
BILLADJ bill adjustment NY_BATCH batch number C 5 0 True
BILLADJ bill adjustment NY_DATE date submit to NYS D 8 0 True
BILLADJ bill adjustment NY_INVOICE ny batch invoice # C 6 0 True
BILLADJ bill adjustment NY_RDATE nys return date/respone D 8 0 True
BILLADJ bill adjustment NY_RESULT ADJUSTMENT BILLING RESULT C 1 0 True
BILLADJ bill adjustment PC_CODE PROCEDURE CODE C 7 0 True
BILLADJ bill adjustment SBDATE service begin date(part of id) D 8 0 True
BILLRTR Bill - retroactive billing EIAGENCY E.I. agency code C 9 0 True
BILLRTR Bill - retroactive billing ID child id C 8 0 True
BILLRTR Bill - retroactive billing ID_PROV provider id C 8 0 False
BILLRTR Bill - retroactive billing ID_SVC authorization number C 8 0 True
BILLRTR Bill - retroactive billing PC_CODE procedure code C 7 0 True
BILLRTR Bill - retroactive billing RTR_AMOUNT retroactive amount N 8 2 True
BILLRTR Bill - retroactive billing RTR_BATCH RTR batch number C 5 0 True
BILLRTR Bill - retroactive billing RTR_CHECK retroactive check number C 12 0 True
BILLRTR Bill - retroactive billing RTR_CHKAMT pay provider chech amount N 10 2 True
BILLRTR Bill - retroactive billing RTR_DATE retroactive process date D 8 0 True
BILLRTR Bill - retroactive billing RTR_IDATE retroactive check issued date D 8 0 True
BILLRTR Bill - retroactive billing RTR_NEWAMT new nys price N 8 2 True
BILLRTR Bill - retroactive billing RTR_NEWRAT new rate N 8 2 True
BILLRTR Bill - retroactive billing RTR_OLDAMT ck_amount from bill.dbf N 8 2 True
BILLRTR Bill - retroactive billing RTR_OLDRAT nys_rate from bill.dbf N 8 2 True
BILLRTR Bill - retroactive billing RTR_RESULT retroactive reconciliation C 1 0 True
BILLRTR Bill - retroactive billing SBDATE service date D 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE ADJBATCH NYS ADJUSTMENT BATCH NUMBER C 5 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE ADJINVOIC ADJUSTMENT INVOICE NUMBER C 6 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE ADJ_AMT NYS ADJUSTMENT AMOUNT N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE ADJ_DATE NYS ADJUSTMENT DATE D 8 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE ADJ_TYPE NYS ADJUSTMENT TYPE C 1 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE AMOUNT   N 8 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE BDATE   D 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE BEN_DATE   D 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE EIAGENCY EIAGENCY C 9 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE EIFSDATE EIFS PROCESS DATE D 8 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE ID Child ID C 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE ID_PROV Provider ID C 8 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE ID_SVC Authorization Number C 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE NYS_PDAMT NYS PAID AMOUNT N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE NYS_RESULT NYS RESULT C 1 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE NY_BATCH NYS Original BATCH Number C 5 0 False
BILLRTR1 NEW BILL RETROACTIVE FILE NY_INVOICE NYS Original INVOICE Number C 6 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE OLDAMOUNT AMOUNT COPIED FROM BILL N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE OLDBALANCE BALANCE COPIED FROM BILL N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE OLDCKAMNT CHK_AMOUNT COPIED FROM BILL N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE OLDNYSPRIC NYSPRICE COPIED FROM BILL N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE OLDNYSRATE NYS_RATE COPIED FROM BILL N 8 2 False
BILLRTR1 NEW BILL RETROACTIVE FILE PC_CODE   C 7 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE PV_INVOICE   C 12 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_AMOUNT Retro Amount N 8 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_BATCH Provider Retro batch number C 5 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_CHECK CHECK Number C 12 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_CHKAMT   N 10 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_DATE DATE Prov Retro Batch Created D 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_IDATE Prov Retro Reconcile Date D 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_NEWAMT   N 8 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_NEWRAT   N 8 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_OLDAMT   N 8 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_OLDRAT   N 8 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_PAID PROVIDER PAID Amount N 9 2 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_RESULT Blank, Paid, Denied C 1 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE RTR_STA   C 1 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE SBDATE Service Begin Date D 8 0 True
BILLRTR1 NEW BILL RETROACTIVE FILE UNITS   N 3 0 True
CHARTBLE ASCII CHART TABLE TO SCREENOUT CCHAR ACTUAL ASCII CHARACTER C 1 0 True
CHARTBLE ASCII CHART TABLE TO SCREENOUT LCHECK LOGICAL TO CHECK THIS CHAR L 1 0 True
CHARTBLE ASCII CHART TABLE TO SCREENOUT NCHAR ASCII NUMBER OF THIS CHAR N 3 0 True
CHILD Child AKAF as known as first name C 20 0 False
CHILD Child AKAL as known as last name C 20 0 False
CHILD Child ALCHFREQ frequency of use alcohol C 1 0 True
CHILD Child ALCHQNTY amount of alcohol N 2 0 True
CHILD Child BIRTHORDER birthorder C 1 0 True
CHILD Child BWGM birth weight in grams N 4 0 False
CHILD Child BWLB partial birth weigth (lb) N 2 0 True
CHILD Child BWOZ partial birth weigth (oz) N 2 0 True
CHILD Child CCASSIGN date assigned to coordinator D 8 0 True
CHILD Child CCNUM service coordinator number C 5 0 True
CHILD Child CCNUM2 E.I. staff code C 5 0 True
CHILD Child CCTYPE service coordinator type C 1 0 True
CHILD Child CCTYPE2 other staff type C 1 0 False
CHILD Child CIGSDAY cigarettes per day N 2 0 True
CHILD Child CLINIC clinic/site code C 5 0 False
CHILD Child COMM_DATE commensurate date D 8 0 True
CHILD Child CTYBIRTH county of birth C 2 0 True
CHILD Child CTYDSS notify county DSS Y/N flag C 1 0 False
CHILD Child CTYRES county of resident C 2 0 True
CHILD Child CTYRESPO fiscal reponsible county C 2 0 True
CHILD Child DOB child's date of birth D 8 0 True
CHILD Child DRUG Other drug use C 1 0 True
CHILD Child EARLY (not used) C 1 0 False
CHILD Child EC Y-active,C-closed,Blank-No C 1 0 True
CHILD Child ECEVDATE most recent ec evaluation date D 8 0 True
CHILD Child ECIFSPDATE most recent ec ifsp date D 8 0 True
CHILD Child ECREFDATE ec referral date D 8 0 True
CHILD Child ECSVDATE most recent ec service date D 8 0 True
CHILD Child ENTDATE case entry date D 8 0 True
CHILD Child ENTRYOP entry operator C 5 0 False
CHILD Child FIRST child's first name C 20 0 True
CHILD Child GESTAGE weeks of gestation N 2 0 True
CHILD Child HEPBSTA Y-active,BLANK-No C 1 0 False
CHILD Child HOSPBIRTH hospital of birth C 30 0 False
CHILD Child HOSPDSCH hospital of discharge C 30 0 False
CHILD Child ID system generated id (internal) C 8 0 True
CHILD Child ID_COMPOSE composed id for matching C 20 0 False
CHILD Child IFSP YYY->interim,initial,6 month C 10 0 True
CHILD Child IHAP Y-active, C-closed, BLANK-No C 1 0 True
CHILD Child IHAPCL not been used (same as ihap) C 1 0 False
CHILD Child IHAPEV YYYY->6,12,20,30 months eval. C 10 0 True
CHILD Child IHEVDATE most recent evaluation date D 8 0 True
CHILD Child IhrefDATE referral date D 8 0 True
CHILD Child IMMU immunization record flag C 1 0 False
CHILD Child IMMUDATE immunization entry date D 8 0 False
CHILD Child IMMUUPDATE immunization update date D 8 0 False
CHILD Child LAST child's last name C 20 0 True
CHILD Child LEADSTA lead status C 1 0 True
CHILD Child LHUNUM local id number (if used) C 15 0 True
CHILD Child MEDICAID medicaid program ? C 1 0 True
CHILD Child MEDICAID_N medicaid number C 8 0 True
CHILD Child MI child's M.I. C 1 0 True
CHILD Child MOMDOB mother's date of birth D 8 0 True
CHILD Child MOMEDU years of education completed N 2 0 True
CHILD Child MOMNAME mother's name C 25 0 False
CHILD Child NECEVAL # of ec valuations N 2 0 True
CHILD Child NECSVC number of ec service records N 3 0 True
CHILD Child NFAMCT number of family court records N 2 0 False
CHILD Child NFAMILY number of family records N 2 0 True
CHILD Child NICU length of stay in NICU N 3 0 True
CHILD Child NIFSP number of ifsp records N 2 0 True
CHILD Child NPHCPDE # of PHCP D&E N 2 0 True
CHILD Child NREFERRAL # of non-ec referral records N 2 0 True
CHILD Child ORIGIN hispanic origin C 2 0 True
CHILD Child PHCP Y-Active,C-Closed, or Blank-No C 1 0 True
CHILD Child PhrefDATE PHCP referral date D 8 0 True
CHILD Child PLURALITY plurality C 1 0 True
CHILD Child PRENAT month prenatal began C 1 0 True
CHILD Child PRENATAL prenatal info collected flag L 1 0 True
CHILD Child PRIMEVAL primary evaluation Y or Blank C 1 0 True
CHILD Child RACE race C 10 0 True
CHILD Child RACEOTHER Race other C 15 0 True
CHILD Child REFDATE1 earlier referral date- ihap/ec D 8 0 True
CHILD Child SEX sex C 1 0 True
CHILD Child SSNUM social security number C 11 0 True
CHILD Child TR_DATE date of transfer D 8 0 False
CHILD Child TR_FLAG transfer tracking flag L 1 0 False
CHILD Child TR_STATUS status used for re-transfer C 1 0 False
CHILD Child UPDATEOP update child record's operator C 5 0 False
CHILD Child UPDDATE case updated date D 8 0 False
CHILD Child USER1 user defined field 1 C 30 0 False
CHILD Child USER2 user defined field 2 C 30 0 False
CINFO Keep county information ADDR1   C 55 0 False
CINFO Keep county information ADDR2   C 55 0 False
CINFO Keep county information CITY   C 30 0 False
CINFO Keep county information CONTNAME   C 60 0 False
CINFO Keep county information CTELNO   C 12 0 False
CINFO Keep county information EIN   C 10 0 False
CINFO Keep county information ETIN   C 10 0 False
CINFO Keep county information MEDGS02   C 7 0 False
CINFO Keep county information MEDISA06   C 7 0 False
CINFO Keep county information NPI National Provider Identifier C 10 0 False
CINFO Keep county information NPI_O 2nd NPI for other Services C 10 0 False
CINFO Keep county information PROGNAME   C 35 0 False
CINFO Keep county information STATE   C 2 0 False
CINFO Keep county information ZIP   C 10 0 False
CLINIC clinic/site ADDR1 address 1 C 35 0 False
CLINIC clinic/site ADDR2 address 2 C 35 0 False
CLINIC clinic/site CODE clinic code C 5 0 False
CLINIC clinic/site NAME clinic/site name C 35 0 False
CLINIC clinic/site PHONE phone C 12 0 False
DEFAULT DEFAULT VALUES FOR CONSTANT #s NVALUE NUMBER OF CLAIMS IN A BATCH N 10 0 True
DISKUSER User info for reading disk ADDR1   C 25 0 False
DISKUSER User info for reading disk ADDR2   C 25 0 False
DISKUSER User info for reading disk AGENCY   C 35 0 True
DISKUSER User info for reading disk CITY   C 17 0 False
DISKUSER User info for reading disk FAX   C 12 0 False
DISKUSER User info for reading disk NAME   C 35 0 False
DISKUSER User info for reading disk PERMIT   C 9 0 True
DISKUSER User info for reading disk PHONE   C 12 0 False
DISKUSER User info for reading disk STATE   C 2 0 False
DISKUSER User info for reading disk STATUS   C 1 0 False
DISKUSER User info for reading disk TEST837   L 1 0 False
DISKUSER User info for reading disk TPARECVD   L 1 0 False
DISKUSER User info for reading disk ZIP   C 10 0 False
ECEVAL Early Care Evaluation ADAPM dev. method - adaptive C 1 0 True
ECEVAL Early Care Evaluation ADAPS dev. status - adaptive C 1 0 True
ECEVAL Early Care Evaluation AUDIOL involved - audiologist L 1 0 True
ECEVAL Early Care Evaluation COGM dev. method - cognitive C 1 0 True
ECEVAL Early Care Evaluation COGS dev. status - cognitive C 1 0 True
ECEVAL Early Care Evaluation COMM dev. method - communication C 1 0 True
ECEVAL Early Care Evaluation COMS dev. status - communication C 1 0 True
ECEVAL Early Care Evaluation DIAG1 1st diagnosed condition C 6 0 True
ECEVAL Early Care Evaluation DIAG2 2nd diagnosed condition C 6 0 True
ECEVAL Early Care Evaluation EDATE date of evaluation D 8 0 True
ECEVAL Early Care Evaluation ELIGIB EI eligibility C 1 0 True
ECEVAL Early Care Evaluation EV_TYPE evaluation type C 1 0 True
ECEVAL Early Care Evaluation ID system generated id C 8 0 True
ECEVAL Early Care Evaluation NURSE involved - nurse L 1 0 True
ECEVAL Early Care Evaluation NURSEPTT nurse practitioner L 1 0 True
ECEVAL Early Care Evaluation NUTRI involved - nutritionist L 1 0 True
ECEVAL Early Care Evaluation OT involved - occup. therapist L 1 0 True
ECEVAL Early Care Evaluation OTHER involved - other L 1 0 True
ECEVAL Early Care Evaluation OTHPHYS involved - other physician L 1 0 True
ECEVAL Early Care Evaluation PEDIA involved - pediatrician L 1 0 True
ECEVAL Early Care Evaluation PHYM dev. method - physical C 1 0 True
ECEVAL Early Care Evaluation PHYS dev status - physical C 1 0 True
ECEVAL Early Care Evaluation PHYSASSI physicians assistant L 1 0 True
ECEVAL Early Care Evaluation PSYCHOL involved - psychologist L 1 0 True
ECEVAL Early Care Evaluation PT involved - physical therapist L 1 0 True
ECEVAL Early Care Evaluation SENM dev. method - sensory C 1 0 True
ECEVAL Early Care Evaluation SENS dev status - sensory C 1 0 True
ECEVAL Early Care Evaluation SOCWKR involved - social worker L 1 0 True
ECEVAL Early Care Evaluation SOC_EMM dev. method - social/emotional C 1 0 True
ECEVAL Early Care Evaluation SOC_EMS dev. status - social/emotional C 1 0 True
ECEVAL Early Care Evaluation SPECED involved - special educator L 1 0 True
ECEVAL Early Care Evaluation SPEECH involved - speech pathologist L 1 0 True
ECEVAL Early Care Evaluation TR_DATE date of transfer D 8 0 False
ECEVAL Early Care Evaluation TR_FLAG transfer tracking flag L 1 0 False
ECEVAL Early Care Evaluation TR_STATUS used for re-transfer C 1 0 False
ECREF Early Care Referral ADAPT area - adaptive C 1 0 True
ECREF Early Care Referral CLOSEDATE date of closure D 8 0 True
ECREF Early Care Referral COG area - cognitive C 1 0 True
ECREF Early Care Referral COMMUN area - communication C 1 0 True
ECREF Early Care Referral COND1 1st condition in ICD9 code C 6 0 True
ECREF Early Care Referral COND2 2nd condition in ICD9 code C 6 0 True
ECREF Early Care Referral CREASON reason for closure C 1 0 True
ECREF Early Care Referral EARLYREF referral source C 1 0 True
ECREF Early Care Referral ECNOTE note pad M 10 0 False
ECREF Early Care Referral ECRCOMMENT comment M 10 0 False
ECREF Early Care Referral ID system generated id C 8 0 True
ECREF Early Care Referral ID_PROV provider id (system generated) C 8 0 True
ECREF Early Care Referral IHAPNOTE I-CHAP notes M 10 0 False
ECREF Early Care Referral PHYSICAL area - physical C 1 0 True
ECREF Early Care Referral REDATE date of E.I. referral D 8 0 True
ECREF Early Care Referral SENSORY area - sensory C 1 0 True
ECREF Early Care Referral SOCEMO area - social emotional C 1 0 True
ECREF Early Care Referral TL_CL_CODE closure reason C 1 0 False
ECREF Early Care Referral TL_CL_DATE closure date D 8 0 False
ECREF Early Care Referral TL_EV_COMP evaluation complete date D 8 0 False
ECREF Early Care Referral TL_EV_ELIG eligible C 1 0 False
ECREF Early Care Referral TL_EV_LCOD evaluation status C 2 0 False
ECREF Early Care Referral TL_EV_MTHD method C 1 0 False
ECREF Early Care Referral TL_EV_NOTE kids eligible C 10 0 False
ECREF Early Care Referral TL_EV_SCHD date referred (evaluation) D 8 0 False
ECREF Early Care Referral TL_EV_SUMM summary received date D 8 0 False
ECREF Early Care Referral TL_IF_BGIN ifsp begin date D 8 0 False
ECREF Early Care Referral TL_IF_COMP ifsp completed date D 8 0 False
ECREF Early Care Referral TL_IF_LCOD ifsp status C 2 0 False
ECREF Early Care Referral TL_IF_SCHD ifsp schedule date D 8 0 False
ECREF Early Care Referral TL_INI_CON initial contact date D 8 0 False
ECREF Early Care Referral TL_IN_LCOD initial contact status C 2 0 False
ECREF Early Care Referral TL_REC_CON most recent contact D 8 0 False
ECREF Early Care Referral TL_REF_RCV county received ref date D 8 0 False
ECREF Early Care Referral TL_SC_ASIG date assigned D 8 0 False
ECREF Early Care Referral TL_SC_CODE current s.c. C 5 0 False
ECREF Early Care Referral TR_DATE date of transfer D 8 0 False
ECREF Early Care Referral TR_FLAG transfer tracking flag L 1 0 False
ECREF Early Care Referral TR_STATUS used for re-transfer C 1 0 False
ECSVC Early Care Service BALANCE unpaid balance N 8 2 True
ECSVC ECSVC BILINSID BILINSID FOR INSURANCE CHECK C 8 0 False
ECSVC Early Care Service CHARGED total amount charged N 8 2 True
ECSVC Early Care Service CK_PAID (not used) N 8 2 True
ECSVC Early Care Service COST total cost of service N 8 2 True
ECSVC Early Care Service CT_BATCH batch # of generating contract C 5 0 False
ECSVC ECSVC DENYCODE DENYCODE FOR INSURANCE C 1 0 False
ECSVC Early Care Service ECCOMMENT comment M 10 0 False
ECSVC Early Care Service EDATE EI service end date D 8 0 True
ECSVC Early Care Service EIAGENCY e.i. agency (billing) C 9 0 True
ECSVC Early Care Service ENTERDATE Date of record entered D 8 0 False
ECSVC Early Care Service ICD9CM icd9 code for madicaid billing C 6 0 True
ECSVC Early Care Service ICD9_PROC icd9 for procedure code C 6 0 True
ECSVC Early Care Service ID system id C 8 0 True
ECSVC Early Care Service ID_PROV provider's id C 8 0 True
ECSVC Early Care Service ID_SVC service authorization number C 8 0 True
ECSVC Early Care Service IFSP_NUM link to ifsp num C 1 0 True
ECSVC Early Care Service INS_PAID insurance paid summary N 8 2 True
ECSVC Early Care Service LASTSVDATE last bill svc date if cancel D D 8 0 True
ECSVC Early Care Service MED_PAID medicaid paid summary N 8 2 True
ECSVC Early Care Service MODIDATE date of record modified D 8 0 False
ECSVC Early Care Service NCLAIM number of claims N 3 0 True
ECSVC Early Care Service NEEDLETTER need a contract letter L 1 0 False
ECSVC Early Care Service NOTEI51 51+ % not ei C 1 0 True
ECSVC Early Care Service NSVC # of services (system used) N 2 0 True
ECSVC Early Care Service NYS_PAID NYS paid summary N 8 2 True
ECSVC Early Care Service OTH_PAID other paid summary N 8 2 True
ECSVC Early Care Service PAMT1 1st payment amount N 8 2 False
ECSVC Early Care Service PAMT2 2nd payment amount N 8 2 False
ECSVC Early Care Service PAMT3 3th payment amount N 8 2 False
ECSVC Early Care Service PC_AMOUNT authorized amount N 8 2 True
ECSVC Early Care Service PC_CODE procedure code C 7 0 True
ECSVC Early Care Service PSRC1 1st payment source C 1 0 False
ECSVC Early Care Service PSRC2 2nd payment source C 1 0 False
ECSVC Early Care Service PSRC3 3th payment source C 1 0 False
ECSVC Early Care Service R_CANCEL reason for canceling service C 1 0 True
ECSVC Early Care Service SDATE service start date D 8 0 True
ECSVC Early Care Service SDAYS # of days per week N 1 0 False
ECSVC Early Care Service SHR # of hours per day N 4 1 False
ECSVC Early Care Service SLOC service location C 1 0 True
ECSVC Early Care Service SMETH service method C 1 0 True
ECSVC Early Care Service SVC service type C 1 0 True
ECSVC Early Care Service SVC_CAT service category C 1 0 True
ECSVC Early Care Service SVC_STATUS service status Ok/Hold/Cancel. C 1 0 True
ECSVC Early Care Service SWKS # of weeks (service) N 2 0 False
ECSVC Early Care Service TOTSVC total # of service (system) N 2 0 True
ECSVC Early Care Service TR_DATE date of transfer D 8 0 False
ECSVC Early Care Service TR_FLAG transfer tracking flag L 1 0 False
ECSVC Early Care Service TR_STATUS used for re-transfer C 1 0 False
ECSVC Early Care Service UNITS number of units N 3 0 True
ECSVC Early Care Service UNIT_CLAIM total unit claimed N 3 0 True
ECSVC Early Care Service UNIT_COST cost per unit N 8 2 True
FAMCT Family Court CTDATE court order date D 8 0 False
FAMCT Family Court CTTRANS court order transport N 5 0 False
FAMCT Family Court CTTUIT court order tuition N 5 0 False
FAMCT Family Court DOCKET court order docket number C 10 0 False
FAMCT Family Court ENDDATE end date D 8 0 False
FAMCT Family Court HCOND handicapping condition C 1 0 False
FAMCT Family Court ID system id C 5 0 False
FAMCT Family Court PDDATE paid date D 8 0 False
FAMCT Family Court PDTRANS paid transport N 5 0 False
FAMCT Family Court PDTUIT paid tuition N 5 0 False
FAMCT Family Court PETDATE petition date D 8 0 False
FAMCT Family Court PETTRANS petition transport N 5 0 False
FAMCT Family Court PETTUIT petition tuition N 5 0 False
FAMCT Family Court PLACE placement authorization C 1 0 False
FAMCT Family Court SISID sis child id C 9 0 False
FAMCT Family Court STACID stac child id C 6 0 False
FAMCT Family Court STDATE start date D 8 0 False
FAMILY Family ADULT1 1st adult name C 30 0 True
FAMILY Family ADULT2 2nd adult name C 30 0 True
FAMILY Family ADULT3 3th adult name C 30 0 True
FAMILY Family CAREMEM memo M 10 0 False
FAMILY Family ID system id C 8 0 True
FAMILY Family ID_HOUSE house id C 8 0 True
FAMILY Family LEGAL legal guardian (y/n) C 1 0 True
FAMILY Family PRIMCARE primary residence (y/n) C 1 0 True
FAMILY Family REL1 relation with 1st adult C 1 0 True
FAMILY Family REL2 relation with 2nd adult C 1 0 True
FAMILY Family REL3 relation with 3nd adult C 1 0 True
H835 CLAIM PAYMENT ADVICE BILLDATE billing date D 8 0 False
H835 CLAIM PAYMENT ADVICE CHARGAMNT CHARGAMOUNT N 8 2 False
H835 CLAIM PAYMENT ADVICE CITYPAID CITY PAID N 8 2 False
H835 CLAIM PAYMENT ADVICE CK_AMOUNT nys_price   0 0 False
H835 CLAIM PAYMENT ADVICE CK_BATCH check batch number C 5 0 False
H835 CLAIM PAYMENT ADVICE COUNTYCOST   N 8 2 False
H835 CLAIM PAYMENT ADVICE ID_PROV provider id (system generated) C 7 0 False
H835 CLAIM PAYMENT ADVICE ID_SVC AUTHORIZATION NUMBER C 8 0 False
H835 CLAIM PAYMENT ADVICE INS_PAID INSURANCE PAID N 8 2 False
H835 CLAIM PAYMENT ADVICE MD_BATCH BATCH NUMBER C 10 0 False
H835 CLAIM PAYMENT ADVICE MEDI_PAID MEDICAL PAID N 8 2 False
H835 CLAIM PAYMENT ADVICE NYS_REIMB   N 8 2 False
H835 CLAIM PAYMENT ADVICE OTH_PAID nys_price N 8 2 False
H835 CLAIM PAYMENT ADVICE PV_INVOICE provider invoice number C 10 0 False
H835 CLAIM PAYMENT ADVICE SVC_DATE SERVICE DATE D 8 0 False
H837CLM Claim Information for 837i AMT01   C 3 0 False
H837CLM Claim Information for 837i AMT02   C 18 0 False
H837CLM Claim Information for 837i AMT_23   C 3 0 False
H837CLM Claim Information for 837i CLM01   C 38 0 False
H837CLM Claim Information for 837i CLM02   C 18 0 False
H837CLM Claim Information for 837i CLM05   C 6 0 False
H837CLM Claim Information for 837i CLM06   C 1 0 False
H837CLM Claim Information for 837i CLM08   C 1 0 False
H837CLM Claim Information for 837i CLM09   C 1 0 False
H837CLM Claim Information for 837i CLM18   C 1 0 False
H837CLM Claim Information for 837i CLMLVL   C 4 0 False
H837CLM Claim Information for 837i CLM_23   C 3 0 False
H837CLM Claim Information for 837i DTP01   C 3 0 False
H837CLM Claim Information for 837i DTP02   C 3 0 False
H837CLM Claim Information for 837i DTP03   C 35 0 False
H837CLM Claim Information for 837i DTP_23   C 3 0 False
H837CLM Claim Information for 837i HDLVL   C 6 0 True
H837CLM Claim Information for 837i HI01BE   C 30 0 False
H837CLM Claim Information for 837i HI01BK   C 30 0 False
H837CLM Claim Information for 837i HI_23BE   C 2 0 False
H837CLM Claim Information for 837i HI_23BK   C 2 0 False
H837CLM Claim Information for 837i ID_SVC   C 8 0 False
H837CLM Claim Information for 837i PRVDLVL   C 4 0 True
H837CLM Claim Information for 837i REF01G1   C 3 0 False
H837CLM Claim Information for 837i REF02G1   C 8 0 False
H837CLM Claim Information for 837i REFG1   C 3 0 False
H837CLM Claim Information for 837i SBCRLVL   C 4 0 False
H837HEAD Header file for 837I BHT   C 3 0 False
H837HEAD Header file for 837I BHT01   C 4 0 False
H837HEAD Header file for 837I BHT02   C 2 0 False
H837HEAD Header file for 837I BHT03   C 30 0 False
H837HEAD Header file for 837I BHT04   C 8 0 False
H837HEAD Header file for 837I BHT05   C 8 0 False
H837HEAD Header file for 837I BHT06   C 2 0 False
H837HEAD Header file for 837I ERRORMSG   C 60 0 False
H837HEAD Header file for 837I ERR_CODE   C 2 0 False
H837HEAD Header file for 837I GE   C 2 0 False
H837HEAD Header file for 837I GE01   C 6 0 False
H837HEAD Header file for 837I GE02   C 9 0 False
H837HEAD Header file for 837I GS   C 2 0 False
H837HEAD Header file for 837I GS01   C 2 0 False
H837HEAD Header file for 837I GS02   C 15 0 False
H837HEAD Header file for 837I GS03   C 15 0 False
H837HEAD Header file for 837I GS04   C 8 0 False
H837HEAD Header file for 837I GS05   C 8 0 False
H837HEAD Header file for 837I GS06   C 9 0 False
H837HEAD Header file for 837I GS07   C 2 0 False
H837HEAD Header file for 837I GS08   C 12 0 False
H837HEAD Header file for 837I HDLVL   C 6 0 True
H837HEAD Header file for 837I IEA   C 3 0 False
H837HEAD Header file for 837I IEA01   C 5 0 False
H837HEAD Header file for 837I IEA02   C 9 0 False
H837HEAD Header file for 837I ISA   C 3 0 False
H837HEAD Header file for 837I ISA01   C 2 0 False
H837HEAD Header file for 837I ISA02   C 10 0 False
H837HEAD Header file for 837I ISA03   C 2 0 False
H837HEAD Header file for 837I ISA04   C 10 0 False
H837HEAD Header file for 837I ISA05   C 2 0 False
H837HEAD Header file for 837I ISA06   C 15 0 False
H837HEAD Header file for 837I ISA07   C 2 0 False
H837HEAD Header file for 837I ISA08   C 15 0 False
H837HEAD Header file for 837I ISA09   C 6 0 False
H837HEAD Header file for 837I ISA10   C 4 0 False
H837HEAD Header file for 837I ISA11   C 1 0 False
H837HEAD Header file for 837I ISA12   C 5 0 False
H837HEAD Header file for 837I ISA13   C 9 0 False
H837HEAD Header file for 837I ISA14   C 1 0 False
H837HEAD Header file for 837I ISA15   C 1 0 False
H837HEAD Header file for 837I ISA16   C 1 0 False
H837HEAD Header file for 837I NM10140   C 2 0 False
H837HEAD Header file for 837I NM10141   C 2 0 False
H837HEAD Header file for 837I NM10240   C 1 0 False
H837HEAD Header file for 837I NM10241   C 1 0 False
H837HEAD Header file for 837I NM10340   C 35 0 False
H837HEAD Header file for 837I NM10341   C 35 0 False
H837HEAD Header file for 837I NM10840   C 2 0 False
H837HEAD Header file for 837I NM10841   C 2 0 False
H837HEAD Header file for 837I NM10940   C 80 0 False
H837HEAD Header file for 837I NM10941   C 80 0 False
H837HEAD Header file for 837I NM140   C 3 0 False
H837HEAD Header file for 837I NM141   C 3 0 False
H837HEAD Header file for 837I PER   C 3 0 False
H837HEAD Header file for 837I PER01   C 2 0 False
H837HEAD Header file for 837I PER02   C 60 0 False
H837HEAD Header file for 837I PER03   C 2 0 False
H837HEAD Header file for 837I PER04   C 80 0 False
H837HEAD Header file for 837I REF   C 3 0 False
H837HEAD Header file for 837I REF0187   C 2 0 False
H837HEAD Header file for 837I REF0287   C 30 0 False
H837HEAD Header file for 837I SE   C 2 0 False
H837HEAD Header file for 837I SE01   C 10 0 False
H837HEAD Header file for 837I SE02   C 9 0 False
H837HEAD Header file for 837I ST   C 2 0 False
H837HEAD Header file for 837I ST01   C 3 0 False
H837HEAD Header file for 837I ST02   C 9 0 False
H837HEAD Header file for 837I STATUS   C 20 0 False
H837PRVD Provider Information for 837i HDLVL   C 6 0 True
H837PRVD Provider Information for 837i HL012TA   N 12 0 False
H837PRVD Provider Information for 837i HL032TA   C 2 0 False
H837PRVD Provider Information for 837i HL042TA   C 1 0 False
H837PRVD Provider Information for 837i HL_2TA   C 2 0 False
H837PRVD Provider Information for 837i N30185   C 55 0 False
H837PRVD Provider Information for 837i N30285   C 55 0 False
H837PRVD Provider Information for 837i N385   C 2 0 False
H837PRVD Provider Information for 837i N40185   C 30 0 False
H837PRVD Provider Information for 837i N40285   C 2 0 False
H837PRVD Provider Information for 837i N40385   C 15 0 False
H837PRVD Provider Information for 837i N485   C 2 0 False
H837PRVD Provider Information for 837i NM10185   C 3 0 False
H837PRVD Provider Information for 837i NM10285   C 1 0 False
H837PRVD Provider Information for 837i NM10385   C 35 0 False
H837PRVD Provider Information for 837i NM10885   C 2 0 False
H837PRVD Provider Information for 837i NM10985   C 80 0 False
H837PRVD Provider Information for 837i NM185   C 3 0 False
H837PRVD Provider Information for 837i PRVDLVL   C 4 0 True
H837PRVD Provider Information for 837i REF011D   C 3 0 False
H837PRVD Provider Information for 837i REF01LU   C 3 0 False
H837PRVD Provider Information for 837i REF021D   C 30 0 False
H837PRVD Provider Information for 837i REF02LU   C 30 0 False
H837PRVD Provider Information for 837i REF1D   C 3 0 False
H837PRVD Provider Information for 837i REFLU   C 10 0 False
H837SBCR Subscriber Information for 837 DMG01   C 2 0 False
H837SBCR Subscriber Information for 837 DMG02   C 8 0 False
H837SBCR Subscriber Information for 837 DMG03   C 1 0 False
H837SBCR Subscriber Information for 837 DMG_TTBA   C 3 0 False
H837SBCR Subscriber Information for 837 HDLVL   C 6 0 False
H837SBCR Subscriber Information for 837 HL0122   N 6 0 False
H837SBCR Subscriber Information for 837 HL0222   N 12 0 False
H837SBCR Subscriber Information for 837 HL0322   C 2 0 False
H837SBCR Subscriber Information for 837 HL0422   C 1 0 False
H837SBCR Subscriber Information for 837 HL_TB   C 2 0 False
H837SBCR Subscriber Information for 837 N301IL   C 55 0 False
H837SBCR Subscriber Information for 837 N302IL   C 55 0 False
H837SBCR Subscriber Information for 837 N3IL   C 2 0 False
H837SBCR Subscriber Information for 837 N401IL   C 30 0 False
H837SBCR Subscriber Information for 837 N402IL   C 2 0 False
H837SBCR Subscriber Information for 837 N403IL   C 15 0 False
H837SBCR Subscriber Information for 837 N4IL   C 2 0 False
H837SBCR Subscriber Information for 837 NM101IL   C 2 0 False
H837SBCR Subscriber Information for 837 NM101PR   C 3 0 False
H837SBCR Subscriber Information for 837 NM102IL   N 1 0 False
H837SBCR Subscriber Information for 837 NM102PR   N 1 0 False
H837SBCR Subscriber Information for 837 NM103IL   C 35 0 False
H837SBCR Subscriber Information for 837 NM103PR   C 35 0 False
H837SBCR Subscriber Information for 837 NM104IL   C 25 0 False
H837SBCR Subscriber Information for 837 NM108IL   C 2 0 False
H837SBCR Subscriber Information for 837 NM108PR   C 2 0 False
H837SBCR Subscriber Information for 837 NM109IL   C 80 0 False
H837SBCR Subscriber Information for 837 NM109PR   C 80 0 False
H837SBCR Subscriber Information for 837 NM1IL   C 3 0 False
H837SBCR Subscriber Information for 837 NM1PR   C 3 0 False
H837SBCR Subscriber Information for 837 PRVDLVL   C 4 0 False
H837SBCR Subscriber Information for 837 SBCRLVL   C 4 0 False
H837SBCR Subscriber Information for 837 SBR01   C 1 0 False
H837SBCR Subscriber Information for 837 SBR02   C 2 0 False
H837SBCR Subscriber Information for 837 SBR04   C 60 0 False
H837SBCR Subscriber Information for 837 SBR09   C 2 0 False
H837SBCR Subscriber Information for 837 SBR_TB   C 3 0 False
H837SV2 ServicesInformation for 837i CLMLVL   C 4 0 False
H837SV2 ServicesInformation for 837i COUNTYP   N 8 2 False
H837SV2 ServicesInformation for 837i DTP01472   C 3 0 False
H837SV2 ServicesInformation for 837i DTP02472   C 2 0 False
H837SV2 ServicesInformation for 837i DTP03472   C 17 0 False
H837SV2 ServicesInformation for 837i DTP_24   C 3 0 False
H837SV2 ServicesInformation for 837i DT_PS   D 8 0 False
H837SV2 ServicesInformation for 837i ERRCODE   C 8 0 False
H837SV2 ServicesInformation for 837i ERRORMSG   C 60 0 False
H837SV2 ServicesInformation for 837i HDLVL   C 6 0 True
H837SV2 ServicesInformation for 837i ID_SVC   C 8 0 False
H837SV2 ServicesInformation for 837i LX01   N 6 0 False
H837SV2 ServicesInformation for 837i LX_23   C 2 0 False
H837SV2 ServicesInformation for 837i PRVDLVL   C 4 0 True
H837SV2 ServicesInformation for 837i P_STA   C 1 0 False
H837SV2 ServicesInformation for 837i SBCRLVL   C 4 0 False
H837SV2 ServicesInformation for 837i SV201   C 20 0 False
H837SV2 ServicesInformation for 837i SV203   C 18 0 False
H837SV2 ServicesInformation for 837i SV204   C 2 0 False
H837SV2 ServicesInformation for 837i SV205   C 1 0 False
H837SV2 ServicesInformation for 837i SV206   C 10 0 False
H837SV2 ServicesInformation for 837i SV2LVL   C 4 0 False
H837SV2 ServicesInformation for 837i SV2_24   C 3 0 False
HIPASTAT Hipaa status time for process END835   L 1 0 False
HIPASTAT Hipaa status time for process END835DT   D 8 0 False
HIPASTAT Hipaa status time for process END835TM   C 8 0 False
HIPASTAT Hipaa status time for process END837   L 1 0 False
HIPASTAT Hipaa status time for process END837DT   D 8 0 False
HIPASTAT Hipaa status time for process END837TM   C 8 0 False
HIPASTAT Hipaa status time for process HDLVL   C 6 0 False
HIPASTAT Hipaa status time for process ID_SVC   C 10 0 False
HIPASTAT Hipaa status time for process INV_NO   C 30 0 False
HIPASTAT Hipaa status time for process SENDERID   C 15 0 False
HIPASTAT Hipaa status time for process ST835DT   D 8 0 False
HIPASTAT Hipaa status time for process ST835TM   C 8 0 False
HIPASTAT Hipaa status time for process ST837DT   D 8 0 False
HIPASTAT Hipaa status time for process ST837TM   C 8 0 False
HIPASTAT Hipaa status time for process START835   L 1 0 False
HIPASTAT Hipaa status time for process START837   L 1 0 False
HIPASTAT Hipaa status time for process STATUS   C 20 0 False
HOUSE Address APARTMENT apartment C 10 0 True
HOUSE Address CENSUS census code C 6 0 True
HOUSE Address CITY city C 20 0 True
HOUSE Address FAMNAM family name C 20 0 True
HOUSE Address FAMSIZE # in household N 2 0 True
HOUSE Address ID_HOUSE house id C 8 0 True
HOUSE Address INCOME income N 6 0 True
HOUSE Address LANGUAGE language at home C 1 0 True
HOUSE Address LEGIS legislative district code C 2 0 True
HOUSE Address NUMBER street number C 9 0 True
HOUSE Address PHONE1 home phone C 12 0 True
HOUSE Address PHONE2 work phone C 12 0 False
HOUSE Address POBOX PO BOX / RDF # C 15 0 True
HOUSE Address SCHL school district C 3 0 True
HOUSE Address STATE state code C 2 0 True
HOUSE Address STREET street name C 20 0 True
HOUSE Address ZIP zip code C 10 0 True
ICD9 ICD9 Code CAT_CODE category code C 2 0 False
ICD9 ICD9 Code EARLYCARE E.I.P (not use) N 1 0 False
ICD9 ICD9 Code ICD9_CODE icd9 code C 6 0 False
ICD9 ICD9 Code ICD9_COND icd9 condition C 40 0 False
ICD9 ICD9 Code IHAP ihap (not use) N 1 0 False
ICD9 ICD9 Code KIND_QUEST kind_quest (not use) C 2 0 False
ICD9 ICD9 Code PHCP phcp (not use) N 1 0 False
ICD9 ICD9 Code QUESTION question (not use) N 1 0 False
ICD9CAT ICD9 Category CAT_CODE category code C 2 0 False
ICD9CAT ICD9 Category CAT_NAME category name C 40 0 False
ICOMPANY Insurance company ADDR1 address part 1 C 25 0 True
ICOMPANY Insurance company ADDR2 address part 2 C 25 0 True
ICOMPANY Insurance company CITY city C 17 0 True
ICOMPANY Insurance company COMPANY insurance company name C 35 0 True
ICOMPANY Insurance company ID_INSURE Insurance company internal id C 8 0 True
ICOMPANY Insurance company INS_CODE insurance company code (DSS) C 2 0 True
ICOMPANY Insurance company NYS_LAW new york state law C 1 0 True
ICOMPANY Insurance company PHONE phone C 12 0 True
ICOMPANY Insurance company STATE state C 2 0 True
ICOMPANY Insurance company ZIP Zip code C 10 0 True
IDFILE System ID and Flags BATCHID batch id seed number N 8 0 False
IDFILE System ID and Flags BILOGBOOK billing log book L 1 0 False
IDFILE System ID and Flags CHK_SYSID checking duplicate system ID L 1 0 True
IDFILE System ID and Flags ECLOGBOOK update E.I. logbook L 1 0 False
IDFILE System ID and Flags HSID house seed number N 8 0 False
IDFILE System ID and Flags IDFORMULAR id expression (formular) C 120 0 False
IDFILE System ID and Flags IHLOGBOOK update I-CHAP logbook L 1 0 False
IDFILE System ID and Flags IMLOGBOOK not book L 1 0 False
IDFILE System ID and Flags INSID insurance seed id N 8 0 True
IDFILE System ID and Flags NYC_DOCNO use NYC documentaion number L 1 0 False
IDFILE System ID and Flags PHLOGBOOK update phcp logbook L 1 0 False
IDFILE System ID and Flags PVID provider id seed number N 8 0 False
IDFILE System ID and Flags SITEID project site id C 6 0 True
IDFILE System ID and Flags SVCID service authorization number N 8 0 True
IDFILE System ID and Flags SYSID system id N 8 0 False
IDFILE System ID and Flags UD1MUST 1st user defined required ? L 1 0 False
IDFILE System ID and Flags UD1PIC 1st user defined field picture C 30 0 False
IDFILE System ID and Flags UD1PROMPT 1st user defined field prompt C 12 0 False
IDFILE System ID and Flags UD1SIZE 1st user defined field size N 2 0 False
IDFILE System ID and Flags UD2MUST 2nd user defined required ? L 1 0 False
IDFILE System ID and Flags UD2PIC 2nd user defined field picture C 30 0 False
IDFILE System ID and Flags UD2PROMPT 2nd user defined field prompt C 12 0 False
IDFILE System ID and Flags UD2SIZE 2nd user defined field size N 2 0 False
IDFILE System ID and Flags UDIDMUST LHU is required ? L 1 0 False
IDFILE System ID and Flags UDIDPIC user defined id picture C 15 0 False
IDFILE System ID and Flags UDIDSIZE user defined id size N 2 0 False
IDFILE System ID and Flags UDPROPER system overwrite proper flag N 1 0 True
IDFILE System ID and Flags WHO_DIDIT record who did it flag L 1 0 False
IFBATCH IFMS batch file BATCH_DATE Batch date D 8 0 True
IFBATCH IFMS batch file IF_BATCH IFMS batch number C 6 0 True
IFBATCH IFMS batch file N_VOUCHER # of vouchers N 3 0 True
IFBATCH IFMS batch file P_RECON percent of reconciled N 8 2 True
IFBATCH IFMS batch file TOT_AMT total amount on batch N 9 2 True
IFMS Suffolk IFMS voucher file BDATE Date on voucher D 8 0 True
IFMS Suffolk IFMS voucher file CK_BATCH KIDS pay provider batch # C 5 0 True
IFMS Suffolk IFMS voucher file CK_DATE Pay provider batch date D 8 0 False
IFMS Suffolk IFMS voucher file CK_IDATE check issued date D 8 0 True
IFMS Suffolk IFMS voucher file CK_NUMBER Check # used to pay voucher C 12 0 True
IFMS Suffolk IFMS voucher file CK_PAID $ amount on pay provider check N 9 2 True
IFMS Suffolk IFMS voucher file EIAGENCY E.I. authrization number C 9 0 True
IFMS Suffolk IFMS voucher file ID_DATE interface id date YYMMDD C 6 0 True
IFMS Suffolk IFMS voucher file IFMS_BATCH IFMS batch number C 6 0 True
IFMS Suffolk IFMS voucher file IFMS_RDATE IFMS return process date D 8 0 True
IFMS Suffolk IFMS voucher file IFMS_RST IFMS process result (P/R) C 1 0 True
IFMS Suffolk IFMS voucher file IFMS_SDATE Send to IFMS date D 8 0 True
IFMS Suffolk IFMS voucher file NUM_BILL # of bills N 3 0 True
IFMS Suffolk IFMS voucher file PV_INVOICE Provider voucher number C 12 0 True
IFMS Suffolk IFMS voucher file PV_NAME Provider name C 35 0 True
IFMS Suffolk IFMS voucher file PV_TAX_ID Provider tax id C 9 0 True
IFMS Suffolk IFMS voucher file RECONCILE Voucher reconciliation status C 1 0 True
IFMS Suffolk IFMS voucher file VOCH_TOTAL Voucher payment amount N 9 2 True
IFSP Early Care IFSP AGREE1 agree with IFSP C 1 0 True
IFSP Early Care IFSP AGREE2 agree with IFSP C 1 0 True
IFSP Early Care IFSP AGREE3 agree with IFSP C 1 0 True
IFSP Early Care IFSP AGREE4 agree with IFSP C 1 0 True
IFSP Early Care IFSP AGREE5 agree with IFSP C 1 0 True
IFSP Early Care IFSP AGREE6 agree with IFSP C 1 0 True
IFSP Early Care IFSP AGREE7 agree 7 C 1 0 True
IFSP Early Care IFSP AGREE8 agree 8 C 1 0 True
IFSP Early Care IFSP AGREE9 agree 9 C 1 0 True
IFSP Early Care IFSP AMEND amend ifsp C 1 0 True
IFSP Early Care IFSP CHILDCARE child care service L 1 0 True
IFSP Early Care IFSP DELAY reason of IFSP delay C 2 0 True
IFSP Early Care IFSP ECDAYS1 # of days (1st) N 1 0 False
IFSP Early Care IFSP ECDAYS2 # of days (2nd) N 1 0 False
IFSP Early Care IFSP ECDAYS3 # of days (3th) N 1 0 False
IFSP Early Care IFSP ECDAYS4 # of days (4th) N 1 0 False
IFSP Early Care IFSP ECDAYS5 # of days (5th) N 1 0 False
IFSP Early Care IFSP ECDAYS6 # of days (6th) N 1 0 False
IFSP Early Care IFSP ECHRS1 # of hours (1st) N 4 1 False
IFSP Early Care IFSP ECHRS2 # of hours (2nd) N 4 1 False
IFSP Early Care IFSP ECHRS3 # of hours (3th) N 4 1 False
IFSP Early Care IFSP ECHRS4 # of hours (4th) N 4 1 False
IFSP Early Care IFSP ECHRS5 # of hours (5th) N 4 1 False
IFSP Early Care IFSP ECHRS6 # of hours (6th) N 4 1 False
IFSP Early Care IFSP ECTYPE1 service type (1st) C 1 0 True
IFSP Early Care IFSP ECTYPE2 service type (2nd) C 1 0 True
IFSP Early Care IFSP ECTYPE3 service type (3th) C 1 0 True
IFSP Early Care IFSP ECTYPE4 service type (4th) C 1 0 True
IFSP Early Care IFSP ECTYPE5 service type (5th) C 1 0 True
IFSP Early Care IFSP ECTYPE6 service type (6th) C 1 0 True
IFSP Early Care IFSP ECTYPE7 type 7 C 1 0 True
IFSP Early Care IFSP ECTYPE8 type 8 C 1 0 True
IFSP Early Care IFSP ECTYPE9 type 9 C 1 0 True
IFSP Early Care IFSP ECWKS1 # of weeks (1st) N 2 0 False
IFSP Early Care IFSP ECWKS2 # of weeks (2nd) N 2 0 False
IFSP Early Care IFSP ECWKS3 # of weeks (3th) N 2 0 False
IFSP Early Care IFSP ECWKS4 # of weeks (4th) N 2 0 False
IFSP Early Care IFSP ECWKS5 # of weeks (5th) N 2 0 False
IFSP Early Care IFSP ECWKS6 # of weeks (6th) N 2 0 False
IFSP Early Care IFSP EFF_EDATE ifsp effective end date D 8 0 True
IFSP Early Care IFSP EFF_SDATE ifsp effective start date D 8 0 True
IFSP Early Care IFSP ETDATE effective through datE D 8 0 True
IFSP Early Care IFSP FOOD food supplements service L 1 0 True
IFSP Early Care IFSP GENETICS genetics service L 1 0 True
IFSP Early Care IFSP HOMEMAKE homemaking service L 1 0 True
IFSP Early Care IFSP HOUSING housing service L 1 0 True
IFSP Early Care IFSP ID system id C 8 0 True
IFSP Early Care IFSP INCOME income assistance service L 1 0 True
IFSP Early Care IFSP LOC1 location (1st) C 1 0 True
IFSP Early Care IFSP LOC2 location (2nd) C 1 0 True
IFSP Early Care IFSP LOC3 location (3th) C 1 0 True
IFSP Early Care IFSP LOC4 location (4th) C 1 0 True
IFSP Early Care IFSP LOC5 location (5th) C 1 0 True
IFSP Early Care IFSP LOC6 location (6th) C 1 0 True
IFSP Early Care IFSP LOC7 location 7 C 1 0 True
IFSP Early Care IFSP LOC8 loc 8 C 1 0 True
IFSP Early Care IFSP LOC9 loc 9 C 1 0 True
IFSP Early Care IFSP MEDICAL medical care service L 1 0 True
IFSP Early Care IFSP METH1 method (1st) C 1 0 True
IFSP Early Care IFSP METH2 method (2nd) C 1 0 True
IFSP Early Care IFSP METH3 method (3th) C 1 0 True
IFSP Early Care IFSP METH4 method (4th) C 1 0 True
IFSP Early Care IFSP METH5 method (5th) C 1 0 True
IFSP Early Care IFSP METH6 method (6th) C 1 0 True
IFSP Early Care IFSP METH7 method 7 C 1 0 True
IFSP Early Care IFSP METH8 method 8 C 1 0 True
IFSP Early Care IFSP METH9 method 9 C 1 0 True
IFSP Early Care IFSP NUM # of ifsp (system) C 1 0 True
IFSP Early Care IFSP OTHSVC other service L 1 0 True
IFSP Early Care IFSP PAY1 payment source (1st) C 1 0 True
IFSP Early Care IFSP PAY2 payment source (2nd) C 1 0 True
IFSP Early Care IFSP PAY3 payment source (3th) C 1 0 True
IFSP Early Care IFSP PAY4 payment source (4th) C 1 0 True
IFSP Early Care IFSP PAY5 payment source (5th) C 1 0 True
IFSP Early Care IFSP PAY6 payment source (6th) C 1 0 True
IFSP Early Care IFSP SPDATE ifsp date D 8 0 True
IFSP Early Care IFSP SPMEMO memo M 10 0 False
IFSP Early Care IFSP SPSTAT ifsp type C 1 0 True
IFSP Early Care IFSP SUPRTGRP support group service L 1 0 True
IFSP Early Care IFSP TECHNO assistive technology device C 1 0 True
IFSP Early Care IFSP TRANSPORT transport (not use) L 1 0 True
IFSP Early Care IFSP TR_DATE date of transfer D 8 0 False
IFSP Early Care IFSP TR_FLAG transfer tracking flag L 1 0 False
IFSP Early Care IFSP TR_STATUS used for re-transfer C 1 0 False
IFSP Early Care IFSP VISIT1 number of visits N 3 0 True
IFSP Early Care IFSP VISIT2 number of visits N 3 0 True
IFSP Early Care IFSP VISIT3 number of visits N 3 0 True
IFSP Early Care IFSP VISIT4 number of visits N 3 0 True
IFSP Early Care IFSP VISIT5 number of visits N 3 0 True
IFSP Early Care IFSP VISIT6 number of visits N 3 0 True
IFSP Early Care IFSP VISIT7 # of visit 7 N 3 0 True
IFSP Early Care IFSP VISIT8 # of visit 8 N 3 0 True
IFSP Early Care IFSP VISIT9 # of visit 9 N 3 0 True
IHAPEVAL I-CHAP Evaluation APT apt score (Denver test) N 6 2 True
IHAPEVAL I-CHAP Evaluation CLDCARE child care concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation COM com score (Denver test) N 6 2 True
IHAPEVAL I-CHAP Evaluation DEVDATE date of ihap evaluation D 8 0 True
IHAPEVAL I-CHAP Evaluation FINAN financial concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation FM fm score (Denver test) N 6 2 True
IHAPEVAL I-CHAP Evaluation GM gm score (Denver test) N 6 2 True
IHAPEVAL I-CHAP Evaluation HEADCM head circum in cm N 4 1 True
IHAPEVAL I-CHAP Evaluation HEADIN head circum in inches N 5 2 True
IHAPEVAL I-CHAP Evaluation HEADPCNT head circum in percentile N 2 0 True
IHAPEVAL I-CHAP Evaluation HLTHCARE halth care concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation HOUSING housing concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation HTCM height in cm N 4 1 True
IHAPEVAL I-CHAP Evaluation HTIN height in inches N 5 2 True
IHAPEVAL I-CHAP Evaluation HTPCNT height in percentile N 2 0 True
IHAPEVAL I-CHAP Evaluation ID system generated id C 8 0 True
IHAPEVAL I-CHAP Evaluation MEASDATE assessment date (adj/gest/age) D 8 0 True
IHAPEVAL I-CHAP Evaluation NUM 1,2,3,or 4->6,12,20,30 months C 1 0 True
IHAPEVAL I-CHAP Evaluation NUTRI nutrition concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation OTHER other concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation PARENT parenting concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation PS ps score (Denver test) N 6 2 True
IHAPEVAL I-CHAP Evaluation RESULT developmental screen result C 1 0 True
IHAPEVAL I-CHAP Evaluation SOCSUP social support concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation STATUS status of growth patterns C 1 0 True
IHAPEVAL I-CHAP Evaluation TEST test used for develop. screen C 1 0 True
IHAPEVAL I-CHAP Evaluation TRANSP transportation concern (T/F) L 1 0 True
IHAPEVAL I-CHAP Evaluation TR_DATE date of transfer D 8 0 False
IHAPEVAL I-CHAP Evaluation TR_FLAG transfer tracking L 1 0 False
IHAPEVAL I-CHAP Evaluation TR_STATUS used for re-transfer C 1 0 False
IHAPEVAL I-CHAP Evaluation WHO who administered screen C 1 0 True
IHAPEVAL I-CHAP Evaluation WTGM weight in gm N 5 0 True
IHAPEVAL I-CHAP Evaluation WTLB weight in lb (partial) N 2 0 True
IHAPEVAL I-CHAP Evaluation WTOZ weight in oz (partial) N 2 0 True
IHAPEVAL I-CHAP Evaluation WTPCNT weight in percentile N 2 0 True
IHAPREF I-CHAP Referral CLOSEDATE date of closure D 8 0 True
IHAPREF I-CHAP Referral COND1 ihap condition 1 C 6 0 True
IHAPREF I-CHAP Referral COND2 ihap condition 2 C 6 0 True
IHAPREF I-CHAP Referral CREASON reason for closure C 1 0 True
IHAPREF I-CHAP Referral DOANTIHBC date of anti-HBc D 8 0 False
IHAPREF I-CHAP Referral DOANTIHBS date of anti-HBs D 8 0 False
IHAPREF I-CHAP Referral DODOSE1 date of 1st hepb dose D 8 0 False
IHAPREF I-CHAP Referral DODOSE2 date of 2nd hepb dose D 8 0 False
IHAPREF I-CHAP Referral DODOSE3 date of 3th hepb dose D 8 0 False
IHAPREF I-CHAP Referral DOHBIG hbig date D 8 0 False
IHAPREF I-CHAP Referral DOHBSAG HBsAG date D 8 0 False
IHAPREF I-CHAP Referral DOLOSTHEPB lost to follow-up date D 8 0 False
IHAPREF I-CHAP Referral DOSE1LOC dose-1 location C 1 0 False
IHAPREF I-CHAP Referral DOSE2LOC dose-2 location C 1 0 False
IHAPREF I-CHAP Referral DOSE3LOC dose-3 location C 1 0 False
IHAPREF I-CHAP Referral HBIGLOC HBIG location C 1 0 False
IHAPREF I-CHAP Referral HEPBSOURCE source of identification N 1 0 False
IHAPREF I-CHAP Referral ID system generated id C 8 0 True
IHAPREF I-CHAP Referral ID_PROV provider id (internal use) C 8 0 True
IHAPREF I-CHAP Referral IHAPDATE ihap referral date D 8 0 True
IHAPREF I-CHAP Referral IHAPNOTE I-CHAP notes M 10 0 False
IHAPREF I-CHAP Referral IHAP_REF ihap referral source C 1 0 True
IHAPREF I-CHAP Referral IHCOMMENT comment M 10 0 False
IHAPREF I-CHAP Referral NEWBORNID newborn screen program id C 20 0 False
IHAPREF I-CHAP Referral RISK1 1st risk factor C 1 0 True
IHAPREF I-CHAP Referral RISK2 2nd risk factor C 1 0 True
IHAPREF I-CHAP Referral RISK3 3th risk factor C 1 0 True
IHAPREF I-CHAP Referral RSANTIHBC Anti-HBc 1-pos/2-neg/3-titer N 1 0 False
IHAPREF I-CHAP Referral RSANTIHBS Anti-HBs 1-pos/2-neg/3-titer N 1 0 False
IHAPREF I-CHAP Referral RSHBSAG HBsAG result 1-pos/2-neg/3-Not N 1 0 False
IHAPREF I-CHAP Referral RSLOSTHEPB 1-can't locate/2-refuse/3-oth. N 1 0 False
IHAPREF I-CHAP Referral TR_DATE date of transfer D 8 0 False
IHAPREF I-CHAP Referral TR_FLAG transfer tracking L 1 0 False
IHAPREF I-CHAP Referral TR_STATUS used for re-transfer C 1 0 False
INSBILL Insurance billing file AMT_FLAG credit/debit (Code : C or D) C 1 0 True
INSBILL Insurance billing file AMT_PAID amount collect from insurance N 8 2 True
INSBILL Insurance billing file ID child internal id C 8 0 True
INSBILL Insurance billing file ID_SVC service auth number C 8 0 True
INSBILL Insurance billing file INS_BATCH kids insurance batch number C 5 0 True
INSBILL Insurance billing file MED_ADJ medicaid adjust C 1 0 True
INSBILL Insurance billing file NYS_ADJ nys adjustment C 1 0 True
INSBILL Insurance billing file SBDATE service beginning date D 8 0 True
INSBILL Insurance billing file SEDATE service ending date D 8 0 True
INSBILL Insurance billing file VEN_BATCH vendor batch number C 5 0 True
INSBILL Insurance billing file VEN_CODE vendor code C 2 0 True
INSBILL Insurance billing file VEN_DATE vendor insurance run date D 8 0 True
INSBILL Insurance billing file VEN_DOC insurance process doc number C 10 0 True
INSTLSTA INSTALATION FILE DATEENTER   D 8 0 False
INSTLSTA INSTALATION FILE RESULT   C 60 0 False
INSTLSTA INSTALATION FILE TIMEENTER   C 8 0 False
INSURE Person insured BILINSID INSURANCE COMPANY BILLED TO C 8 0 False
INSURE Person insured CO_PAY co_pay (yes/no) C 1 0 False
INSURE Person insured DIAG_CODE bill insurance diagnosis code C 6 0 False
INSURE Person insured EICOVERAGE e.i. coverage C 1 0 False
INSURE Person insured EMP_ADDR1 address 1 C 20 0 False
INSURE Person insured EMP_ADDR2 address 2 C 20 0 False
INSURE Person insured EMP_CITY city C 20 0 False
INSURE Person insured EMP_NAME employer name C 30 0 False
INSURE Person insured EMP_PHONE telephone C 12 0 False
INSURE Person insured EMP_STATE state C 2 0 False
INSURE Person insured EMP_ZIP zip code C 10 0 False
INSURE Person insured FROMDATE policy period from date D 8 0 True
INSURE Person insured GROUP_NUM group number C 20 0 False
INSURE Person insured ICOMMENT   M 10 0 False
INSURE Person insured ID ID C 8 0 True
INSURE Person insured ID_INSURE insurance company internal id C 8 0 True
INSURE Person insured LCHPB Child Heatlh Plus B indicator L 1 0 False
INSURE Person insured LFHP Family Health Plus indicator L 1 0 False
INSURE Person insured NAME named insured C 35 0 True
INSURE Person insured PH_ADDR1 addrass 1 C 20 0 False
INSURE Person insured PH_ADDR2 address 2 C 20 0 False
INSURE Person insured PH_CITY city C 20 0 False
INSURE Person insured PH_DOB date of birth D 8 0 False
INSURE Person insured PH_FIRST policy holder first name C 20 0 False
INSURE Person insured PH_LAST polocy holder last name C 20 0 False
INSURE Person insured PH_PHONE telephone C 12 0 False
INSURE Person insured PH_RELA relation to child C 1 0 False
INSURE Person insured PH_SSN social security # C 11 0 False
INSURE Person insured PH_STATE state C 2 0 False
INSURE Person insured PH_ZIP zip code C 10 0 True
INSURE Person insured POLICY_NUM policy number C 20 0 True
INSURE Person insured STOP_USE stop using for e.i. billing L 1 0 True
INSURE Person insured TODATE policy period to date D 8 0 True
KH2MED Generate 837i in 80 columns FULTEXT   C 80 0 False
KHMED Generate hipaa 837i output CCHILDID   C 8 0 True
KHMED Generate hipaa 837i output FULTEXT   C 200 0 False
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CBATCH BATCH NUMBER C 8 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CCHARS BAD CHARACTERS C 25 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CFIELDNAME FIELD NAME C 10 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CFIRSTNAME CHILD FIRST NAME C 20 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CID CHILD ID C 8 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CIS WHAT THE NEW VALUE IS C 50 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CLASTNAME CHILD LAST NAME C 20 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CTABLE TABLE C 8 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CTIME TIME OF RUN C 8 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. CWAS WHAT THE OLD VALUE WAS C 50 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. DRUN DATE OF RUN D 8 0 True
KIDSELOG KIDS ERROR LOG FOR ASCII CHAR. NRECNO RECORD NUMBER OF BAD RECORD N 10 0 True
KIDSMED MEDICAID STAGING FILE CHK_EXIST   L 1 0 False
KIDSMED MEDICAID STAGING FILE CODED_FLAG   L 1 0 False
KIDSMED MEDICAID STAGING FILE CODED_NAME   C 12 0 False
KIDSMED MEDICAID STAGING FILE CODE_VALID   C 50 0 False
KIDSMED MEDICAID STAGING FILE DBF_CALL   C 30 0 False
KIDSMED MEDICAID STAGING FILE DBF_NAME   C 8 0 False
KIDSMED MEDICAID STAGING FILE FIELD_CALL   C 30 0 False
KIDSMED MEDICAID STAGING FILE FIELD_DEC   N 3 0 False
KIDSMED MEDICAID STAGING FILE FIELD_LEN   N 3 0 False
KIDSMED MEDICAID STAGING FILE FIELD_NAME   C 10 0 False
KIDSMED MEDICAID STAGING FILE FIELD_TYPE   C 1 0 False
KIDSMED MEDICAID STAGING FILE FILE_TYPE   C 1 0 False
KIDSMED MEDICAID STAGING FILE NET_FILE   L 1 0 False
KIDSMED MEDICAID STAGING FILE NOTES   C 30 0 False
KIDSMED MEDICAID STAGING FILE PACK_YES   L 1 0 False
KIDSMED MEDICAID STAGING FILE REQUIRED   L 1 0 False
KIDSMED MEDICAID STAGING FILE TAG_CALL   C 30 0 False
KIDSMED MEDICAID STAGING FILE TAG_EXPR   C 80 0 False
KIDSMED MEDICAID STAGING FILE TAG_FIELD   L 1 0 False
KIDSMED MEDICAID STAGING FILE ZAP_YES   L 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ABORTCODE   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ACDNTCODE   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ADJCODE   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE BATCH   C 5 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE BDATE   C 6 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE BILINSID   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE CHAPREF   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE CHILDID   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE CLMREFN   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE CPTCODE   C 5 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE CTYLOC   C 3 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE CTY_MEDI   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE DENTLLAB   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE DENYCODE   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE DIAGNOSIS   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE DISABILITY   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE EMRGNCYC   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE FAMPLAN   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE GROUPID   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE HANDICAP   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ICD9CM   C 6 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ICD9PRCSUF   C 5 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ICD9PRIM   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ICD9PROC   C 6 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ICD9SUFX   C 3 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE ID_SVC   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE INSCOV   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE INS_EDATE   D 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE INS_PAID   N 8 2 False
KIDSMEDI FINAL MEDICAID STAGING FILE INS_YN   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE INVOICE   C 9 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MEDACTAMT   C 7 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MEDACTPAID   C 7 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MEDAPPAMT   C 7 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MEDICAID_N   C 11 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MED_BDATE   D 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MODIFIR1   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MODIFIR2   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MODIFIR3   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE MODIFIR4   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE NYSPRICBAL   C 7 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE NYS_PRICE   N 8 2 False
KIDSMEDI FINAL MEDICAID STAGING FILE NYS_RATE   N 8 2 False
KIDSMEDI FINAL MEDICAID STAGING FILE ORIGCLMR   C 14 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE OTHINSPD   C 7 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE PATSTAT   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE PC_CODE   C 4 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE PLACESEV   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE PRIORAPP   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE PROCRCODE   C 7 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE PROVTYPE   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE REFPROVNO   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SBDATE   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEDATE   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SETEI_CODE   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEVAUTH   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEVPRO   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEVPRONO   C 8 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEVPROTYP   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEV_COD   C 4 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SEX   C 1 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SVC   C 4 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SVC_CAT   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE SVC_SUFF   C 2 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE UNITS   N 3 0 False
KIDSMEDI FINAL MEDICAID STAGING FILE YOB   C 2 0 False
KIDSPC printer control codes P_10CPI printer 10 cpi codes - normal C 60 0 False
KIDSPC printer control codes P_COMPRESS printer compress mode codes C 60 0 False
KIDSPC printer control codes P_NAME printer's name C 40 0 False
KIDSPC printer control codes P_OUTPORT printer output port C 4 0 False
KIDSPC printer control codes P_RESET printer reset codes C 60 0 False
KIDSPC printer control codes P_SETUP printer setup codes C 60 0 False
LOOKUP Code Lookup Table LK_CODE lookup code and description C 45 0 False
LOOKUP Code Lookup Table LK_CODESIZ lookup code size N 1 0 False
LOOKUP Code Lookup Table LK_DISPSIZ description display size N 2 0 False
LOOKUP Code Lookup Table LK_NAME lookup code name C 12 0 False
LOOKUP Code Lookup Table LK_TITLE title of lookup code set C 12 0 False
MDPRTADJ Medicaid Partial RePayment DATESUB Date bill placed in 837 file D 8 0 False
MDPRTADJ Medicaid Partial RePayment INVOICE Old Invoice number from Bill C 9 0 False
MDPRTADJ Medicaid Partial RePayment MD_BATCH Old Batch number from Bill C 5 0 False
MDPRTADJ Medicaid Partial RePayment NEWBATCH New batch number for 837 file C 5 0 False
MDPRTADJ Medicaid Partial RePayment SUBMITTED logical indicator if in 837 L 1 0 False
MDPRTADJ Medicaid Partial RePayment TCN TCN from Medicaid report C 19 0 False
MEDERROR HIPAA 837 ERROR FILE CHILDID   C 8 0 True
MEDERROR HIPAA 837 ERROR FILE ERRDESC   C 50 0 True
MEDERROR HIPAA 837 ERROR FILE FNAME   C 12 0 True
MEDERROR HIPAA 837 ERROR FILE ID_SVC   C 8 0 True
MEDERROR HIPAA 837 ERROR FILE LNAME   C 12 0 True
MEDERROR HIPAA 837 ERROR FILE SBDATE   D 8 0 True
MEMFILE St dt and End dt of Process ENDDATE   D 8 0 False
MEMFILE St dt and End dt of Process ENDTIME   C 10 0 False
MEMFILE St dt and End dt of Process RCOMPLET   C 1 0 False
MEMFILE St dt and End dt of Process REVAL   C 1 0 False
MEMFILE St dt and End dt of Process STDATE   D 8 0 False
MEMFILE St dt and End dt of Process STTIME   C 10 0 False
MEMFILE St dt and End dt of Process TRYDATE   D 8 0 False
MEMFILE St dt and End dt of Process TRYTIME   C 10 0 False
NUBATCH numis batch file BATCH_DATE batch date D 8 0 True
NUBATCH numis batch file NU_BATCH numis batch # C 6 0 True
NUBATCH numis batch file N_RECON # of vouchers have reconciled N 3 0 True
NUBATCH numis batch file N_VOUCHER # of voucher N 3 0 True
NUBATCH numis batch file RECONCILE reconciliation completed 'Y' C 1 0 True
NUBATCH numis batch file TOT_AMT total amount N 9 2 True
NUBATCH numis batch file TRANS_CODE 1-VOCE or 2-VMSE N 1 0 True
NUMIS Numis billing system ADDR_CODE address code (from E.I. auth) C 2 0 True
NUMIS Numis billing system AMT_1 amount charge (1st patient) N 9 2 True
NUMIS Numis billing system AMT_2 amount charge (2nd patient) N 9 2 True
NUMIS Numis billing system AMT_3 amount charge (3th patient) N 9 2 True
NUMIS Numis billing system AMT_4 amount charge (4th patient) N 9 2 True
NUMIS Numis billing system AMT_5 amount charge (5th patient) N 9 2 True
NUMIS Numis billing system AMT_6 amount charge (6th patient) N 9 2 True
NUMIS Numis billing system AMT_7 amount charge (7th patient) N 9 2 True
NUMIS Numis billing system AMT_8 amount charge (8th patient) N 9 2 True
NUMIS Numis billing system BDATE voucher date D 8 0 True
NUMIS Numis billing system BILL_1 # of bills (1st patient) N 3 0 True
NUMIS Numis billing system BILL_2 # of bills (2nd patient) N 3 0 True
NUMIS Numis billing system BILL_3 # of bills (3th patient) N 3 0 True
NUMIS Numis billing system BILL_4 # of bills (4th patient) N 3 0 True
NUMIS Numis billing system BILL_5 # of bills (5th patient) N 3 0 True
NUMIS Numis billing system BILL_6 # of bills (6th patient) N 3 0 True
NUMIS Numis billing system BILL_7 # of bills (7th patient) N 3 0 True
NUMIS Numis billing system BILL_8 # of bills (8th patient) N 3 0 True
NUMIS Numis billing system CK_BATCH pay provider batch # C 5 0 True
NUMIS Numis billing system CK_DATE start process date D 8 0 True
NUMIS Numis billing system CK_IDATE check issued date D 8 0 True
NUMIS Numis billing system CK_NUMBER check # C 12 0 True
NUMIS Numis billing system CK_PAID check amount N 9 2 True
NUMIS Numis billing system CONTRACT contract # (from E.I. auth) C 12 0 True
NUMIS Numis billing system DES_1 description C 30 0 True
NUMIS Numis billing system DES_2 description C 30 0 True
NUMIS Numis billing system DES_3 description C 30 0 True
NUMIS Numis billing system DES_4 description C 30 0 True
NUMIS Numis billing system DES_5 description C 30 0 True
NUMIS Numis billing system DES_6 description C 30 0 True
NUMIS Numis billing system DES_7 description C 30 0 True
NUMIS Numis billing system DES_8 description C 30 0 True
NUMIS Numis billing system EIAGENCY e.i. auth code C 9 0 True
NUMIS Numis billing system ID_1 patient kids id (1st) C 8 0 True
NUMIS Numis billing system ID_2 patient kids id (2nd) C 8 0 True
NUMIS Numis billing system ID_3 patient kids id (3th) C 8 0 True
NUMIS Numis billing system ID_4 patient kids id (4th) C 8 0 True
NUMIS Numis billing system ID_5 patient kids id (5th) C 8 0 True
NUMIS Numis billing system ID_6 patient kids id (6th) C 8 0 True
NUMIS Numis billing system ID_7 patient kids id (7th) C 8 0 True
NUMIS Numis billing system ID_8 patient kids id (8th) C 8 0 True
NUMIS Numis billing system LASTSVDATE last service date (receipt) D 8 0 False
NUMIS Numis billing system NAME_1 patienT name (1st) C 10 0 False
NUMIS Numis billing system NAME_2 patienT name (2nd) C 10 0 False
NUMIS Numis billing system NAME_3 patienT name (3th) C 10 0 False
NUMIS Numis billing system NAME_4 patienT name (4th) C 10 0 False
NUMIS Numis billing system NAME_5 patienT name (5th) C 10 0 False
NUMIS Numis billing system NAME_6 patienT name (6th) C 10 0 False
NUMIS Numis billing system NAME_7 patienT name (7th) C 10 0 False
NUMIS Numis billing system NAME_8 patienT name (8th) C 10 0 False
NUMIS Numis billing system NU_BATCH numis batch number C 6 0 True
NUMIS Numis billing system NU_DATE numis batch date D 8 0 True
NUMIS Numis billing system OPERATOR who start this voucher C 5 0 True
NUMIS Numis billing system PV_ADDR1 provider address line 1 C 25 0 True
NUMIS Numis billing system PV_ADDR2 provider address line 2 C 25 0 True
NUMIS Numis billing system PV_ADDR3 provider address line 3 C 25 0 True
NUMIS Numis billing system PV_INVOICE voucher # C 12 0 False
NUMIS Numis billing system PV_NAME provider name C 35 0 True
NUMIS Numis billing system PV_TAX_ID provider tax id C 9 0 False
NUMIS Numis billing system P_PATIENT # of patients N 1 0 True
NUMIS Numis billing system RECONCILE reconciliation flag C 1 0 True
NUMIS Numis billing system REF_LINE ref. line no. (from E.I. auth) C 4 0 True
NUMIS Numis billing system SVCD_1 last service date (1st pat) D 8 0 True
NUMIS Numis billing system SVCD_2 last service date (2nd pat) D 8 0 True
NUMIS Numis billing system SVCD_3 last service date (3th pat) D 8 0 True
NUMIS Numis billing system SVCD_4 last service date (4th pat) D 8 0 True
NUMIS Numis billing system SVCD_5 last service date (5th pat) D 8 0 True
NUMIS Numis billing system SVCD_6 last service date (6th pat) D 8 0 True
NUMIS Numis billing system SVCD_7 last service date (7th pat) D 8 0 True
NUMIS Numis billing system SVCD_8 last service date (8th pat) D 8 0 True
NUMIS Numis billing system SVC_DESCRI service description C 30 0 False
NUMIS Numis billing system TAX_NT taxable (N-VMSE or T-VOCE) C 1 0 True
NUMIS Numis billing system TRANS_CODE trans code 1-VOCE or 2-VMSE N 1 0 True
NUMIS Numis billing system VOCH_TOTAL voucher total amount N 9 2 True
NURSE NYC Home Visits (HHA) ID system id C 8 0 False
NURSE NYC Home Visits (HHA) ID_PROV provider id C 8 0 False
NURSE NYC Home Visits (HHA) KEPT appointment kept ? C 1 0 False
NURSE NYC Home Visits (HHA) ORDERBY ordered by C 1 0 False
NURSE NYC Home Visits (HHA) SCHDATE date of scheduled visit D 8 0 False
NURSE NYC Home Visits (HHA) TODAY today's date D 8 0 False
NURSE NYC Home Visits (HHA) VISITTYPE type of visit C 1 0 False
NURSE NYC Home Visits (HHA) WHYNOT if not kept, why ? C 1 0 False
OUTCOMES Cohort Outcomes tracking COHOYEAR Cohort year N 4 0 True
OUTCOMES Cohort Outcomes tracking CTYRES Child's county of residence C 2 0 True
OUTCOMES Cohort Outcomes tracking EIELIG EI eligibility C 1 0 True
OUTCOMES Cohort Outcomes tracking ENTRYFORM Entry Summary form complete? L 1 0 True
OUTCOMES Cohort Outcomes tracking EXITFORM Exit summary form completed? L 1 0 True
OUTCOMES Cohort Outcomes tracking ID Child ID C 8 0 True
PHCPDE phcp D & E DEGRP1 authorized service 1 C 1 0 True
PHCPDE phcp D & E DEGRP2 authorized service 2 C 1 0 True
PHCPDE phcp D & E DEGRP3 authorized service 3 C 1 0 True
PHCPDE phcp D & E DEGRP4 authorized service 4 C 1 0 True
PHCPDE phcp D & E DEGRP5 authorized service 5 C 1 0 True
PHCPDE phcp D & E DE_DATE authorization date D 8 0 True
PHCPDE phcp D & E FORMDATE date produce auth form D 8 0 True
PHCPDE phcp D & E ID child id C 8 0 True
PHCPDE phcp D & E ID_PHCPDE D&E authorization # C 8 0 True
PHCPDE phcp D & E ID_PROV provider id C 8 0 True
PHCPREF PHCP referral source ADM_DATE admission date D 8 0 False
PHCPREF PHCP referral source CLOSEDATE closing date D 8 0 True
PHCPREF PHCP referral source COND1 chronic condition 1 C 6 0 True
PHCPREF PHCP referral source COND2 chronic condition 2 C 6 0 True
PHCPREF PHCP referral source CREASON reason for closing C 1 0 True
PHCPREF PHCP referral source HCC health care coverage C 1 0 True
PHCPREF PHCP referral source HCC2 health care coverage 2 C 1 0 True
PHCPREF PHCP referral source HCC3 health care coverage 3 C 1 0 True
PHCPREF PHCP referral source ID system generated id C 8 0 True
PHCPREF PHCP referral source ID_PROV provider id (internal use) C 8 0 True
PHCPREF PHCP referral source INCOME income (1000) N 4 0 False
PHCPREF PHCP referral source PHCOMMENT comment M 10 0 False
PHCPREF PHCP referral source PHCPDATE PHCP referral date D 8 0 True
PHCPREF PHCP referral source PHCPNOTE note pad M 10 0 False
PHCPREF PHCP referral source PHCP_REF phcp referral source C 1 0 True
PHCPREF PHCP referral source SSI receiving SSI C 1 0 True
PHCPREF PHCP referral source TIER1 initial tier C 1 0 True
PHCPREF PHCP referral source TIER2 current tier C 1 0 True
PRIMEVAL Primary Care Evaluation CHARTNUM NYC chart number C 10 0 True
PRIMEVAL Primary Care Evaluation COND1 additional condition C 6 0 True
PRIMEVAL Primary Care Evaluation COND2 additional condition 2 C 6 0 True
PRIMEVAL Primary Care Evaluation DOLEAD date of last lead screen D 8 0 True
PRIMEVAL Primary Care Evaluation DTPD dtp doses C 1 0 True
PRIMEVAL Primary Care Evaluation DTPS dtp status C 1 0 True
PRIMEVAL Primary Care Evaluation HEPBD hepb doses C 1 0 True
PRIMEVAL Primary Care Evaluation HEPBS hepb status C 1 0 True
PRIMEVAL Primary Care Evaluation HIBD hib doses C 1 0 True
PRIMEVAL Primary Care Evaluation HIBS hib status C 1 0 True
PRIMEVAL Primary Care Evaluation ID system id C 8 0 True
PRIMEVAL Primary Care Evaluation ID_PROV provider's id C 8 0 True
PRIMEVAL Primary Care Evaluation LEADRSL lead screen result (ug/dl) N 2 0 True
PRIMEVAL Primary Care Evaluation MMPD mmp doses C 1 0 True
PRIMEVAL Primary Care Evaluation MMPS mmp status C 1 0 True
PRIMEVAL Primary Care Evaluation POLIOD polio doses C 1 0 True
PRIMEVAL Primary Care Evaluation POLIOS polio status C 1 0 True
PRIMEVAL Primary Care Evaluation PRDATE date of last check up D 8 0 True
PRIMEVAL Primary Care Evaluation WELLCHILD regular child check up (y/n) C 1 0 True
PROCODE procode CHARGE1 rate N 7 2 False
PROCODE procode DEND rate effective end date D 8 0 False
PROCODE procode DESCRIP description C 35 0 False
PROCODE procode DSTART rate effective start date D 8 0 False
PROCODE procode HOUR_RATE is hour rate (not used) L 1 0 False
PROCODE procode PROC_CODE medicaid assign procedure code C 7 0 False
PROCODE procode REGION region N 2 0 False
PROVIDER Provider ADDR1 address - 1st line C 25 0 True
PROVIDER Provider ADDR2 address - 2nd line C 25 0 True
PROVIDER Provider AGENCY agency name C 35 0 True
PROVIDER Provider AGENCYCODE agency code C 7 0 True
PROVIDER Provider CITY city C 17 0 True
PROVIDER Provider DEGREE degree - Dr. DDS. C 10 0 False
PROVIDER Provider EIAGENCY E.I. agency code C 9 0 True
PROVIDER Provider EINAME e.i. authorization name C 35 0 True
PROVIDER Provider EI_AUTH e.i authorized provider C 1 0 True
PROVIDER Provider FIRST first name C 20 0 True
PROVIDER Provider ID_PROV provider id C 8 0 True
PROVIDER Provider LAST last name C 20 0 True
PROVIDER Provider MEDICAID medicaid number C 8 0 True
PROVIDER Provider NAME provider's name C 35 0 True
PROVIDER Provider NPI National Provider Identifier C 10 0 False
PROVIDER Provider PHONE phone C 12 0 True
PROVIDER Provider PROGRAM program C 35 0 True
PROVIDER Provider PVCOMMENT comment M 10 0 False
PROVIDER Provider SPEC provider's specialty C 1 0 True
PROVIDER Provider STATE state C 2 0 True
PROVIDER Provider TITLE mr. mrs. C 12 0 False
PROVIDER Provider ZIP zip C 10 0 True
REFERRAL Non Early Care Referral COUNTY county - not used C 2 0 False
REFERRAL Non Early Care Referral END1 1st service end date D 8 0 True
REFERRAL Non Early Care Referral END2 2nd service end date D 8 0 True
REFERRAL Non Early Care Referral END3 3th service end date D 8 0 True
REFERRAL Non Early Care Referral END4 4th service end date D 8 0 True
REFERRAL Non Early Care Referral ID system id C 8 0 True
REFERRAL Non Early Care Referral ID_PROV provider's id C 8 0 True
REFERRAL Non Early Care Referral INIT initiation (referral in) C 1 0 True
REFERRAL Non Early Care Referral PHCPC1 1st phcp cost N 10 0 True
REFERRAL Non Early Care Referral PHCPC2 2nd phcp cost N 10 0 True
REFERRAL Non Early Care Referral PHCPC3 3th phcp cost N 10 0 True
REFERRAL Non Early Care Referral PHCPC4 4th phcp cost N 10 0 True
REFERRAL Non Early Care Referral PHCPQ1 1st phcp program (y/n) C 1 0 True
REFERRAL Non Early Care Referral PHCPQ2 2nd phcp program (y/n) C 1 0 True
REFERRAL Non Early Care Referral PHCPQ3 3th phcp program (y/n) C 1 0 True
REFERRAL Non Early Care Referral PHCPQ4 4th phcp program (y/n) C 1 0 True
REFERRAL Non Early Care Referral REFDATE referral date D 8 0 True
REFERRAL Non Early Care Referral RFCOMMENT comment M 10 0 False
REFERRAL Non Early Care Referral START1 1st service start date D 8 0 True
REFERRAL Non Early Care Referral START2 2nd service start date D 8 0 True
REFERRAL Non Early Care Referral START3 3th service start date D 8 0 True
REFERRAL Non Early Care Referral START4 4th service start date D 8 0 True
REFERRAL Non Early Care Referral SVC1 1st service type C 1 0 True
REFERRAL Non Early Care Referral SVC2 2nd service type C 1 0 True
REFERRAL Non Early Care Referral SVC3 3th service type C 1 0 True
REFERRAL Non Early Care Referral SVC4 4th service type C 1 0 True
SEEDFILE Internal ID seed number SEED_NAME seed number's name C 8 0 False
SEEDFILE Internal ID seed number SEED_NUM seed number N 8 0 False
STAFF Program Staff AGENCY agency C 35 0 False
STAFF Program Staff CODE user's code C 5 0 False
STAFF Program Staff NAME name C 35 0 False
STAFF Program Staff PHONE phone C 12 0 False
STAFF Program Staff PROGRAM program C 35 0 False
STAFF Program Staff STATUS hours working N 4 1 False
USER User BILL_PRIV privilege of e.i. billing C 1 0 False
USER User BROW_AGID browse provider by agency code L 1 0 False
USER User CHECK_SUM security check sum N 6 0 False
USER User CLOCK_ON clock set on / off L 1 0 False
USER User CODE_END display code at end of lookup L 1 0 False
USER User EC_PRIV eip program privilege C 1 0 False
USER User IHAP_PRIV ihap program privilege C 1 0 False
USER User IMMUALL display all immunization dates L 1 0 False
USER User IMMU_PRIV immunization privilege C 1 0 False
USER User LIGHTEN optimize browse / less feature L 1 0 False
USER User NAME user's name C 35 0 False
USER User NO_TBROWSE don't use browser L 1 0 False
USER User NQCOMPRESS network compress print queue C 50 0 False
USER User NQNORMAL network normal print queue C 50 0 False
USER User PAGE_LEFT page is on the left side L 1 0 False
USER User PASSWORD password C 6 0 False
USER User PDCOMPRESS compress printer driver code C 50 0 False
USER User PDNAME printer driver name C 50 0 False
USER User PDNORMAL normal printer driver codes C 50 0 False
USER User PHCP_PRIV phcp privilege (not use) C 1 0 False
USER User PROPER cap first letter of each word L 1 0 False
USER User STICK_MENU sticky menu set on/off L 1 0 False
USER User UDSPEED user type speed (0-enter key) N 3 1 False
USER User UDTIME1 set refresh to time1,xx N 5 0 False
USER User UDTIME2 set refresh to xx,time2 (sec) N 5 0 False
USER User USERCODE usercode C 5 0 False
USER User USE_NPRINT use network printing L 1 0 False
USER User USE_PDRIVE use printer driver L 1 0 False
ECSVC Early Care Service FIRST_SBDT 1st pd svc - (file xfer only) D 8 0 True
VERSION KIDS Version information VNUMBER KIDS version number N 4 0 True
VERSION KIDS Version information COMPLETED Installation completed L 1 0 True
VERSION KIDS Version information VDATE Installation Date D 8 0 True
VERSION KIDS Version information STIME Installation Start Time C 5 0 True
VERSION KIDS Version information ETIME Installation End Time C 5 0 True
BILL Billing NPI_REND Rendering NPI C 10 0 True
CHILD Child RACE1 child.race prior to 9495 C 1 0 True