*****NOTE***** This record layout does not match the Vital Statistics file currently being produced through DSAF. The Date of Birth and Date of Death fields have been changed from YYDDD format to YYYYMMDD format in order to make them Y2K compliant. As a result all subsequent data elements are shifted by 3 to 6 columns. Also, coding for race has been expanded and now uses the new coding scheme. DSC 4/10/00 Downloaded 9/15/99 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ **** VITAL STATISTICS RECORD REC 269 1 269 COMMENT: THIS RECORD LAYOUT APPLIES IF THE FINDER KEY FIELD WAS BENE_CLM_NUM_GRP (HIC) OR BENE_CLM_ACNT_NUM (CAN). THE RECORD LENGTH IS DEPENDENT UPON THE LENGTH OF THE ORIGINAL FINDER RECORD SINCE IT IS APPENDED TO THE VITAL STATISTICS RECORD RESPONSE. **** BENEFICIARY CLAIM NUMBER GROUP 11 1 11 THIS NUMBER UNIQUELY IDENTIFIES A MEDICARE GROUP BENEFICIARY. STANDARD ALIAS: BENE_CLM_NUM_GRP COMMON ALIAS: HIC COBOL ALIAS: BENE_CLM_NUM 1. BENEFICIARY CLAIM ACCOUNT CHAR 9 1 9 THE NUMBER IDENTIFYING THE PRIMARY BENEFICIARY NUMBER UNDER THE SSA OR RRB PROGRAMS. STANDARD ALIAS: BENE_CLM_ACNT_NUM COMMON ALIAS: CAN SAS ALIAS: SSN SOURCE: SSA,RRB LIMITATIONS: RRB-ISSUED NUMBERS CONTAIN AN OVERPUNCH IN THE FIRST POSITION THAT MAY APPEAR AS A PLUS ZERO OR A-G. RRB-FORMATTED NUMBERS MAY CAUSE MATCHING PROBLEMS ON NON-IBM MACHINES. 2. BENEFICIARY IDENTIFICATION CHAR 2 10 11 THE CODE IDENTIFYING THE TYPE OF RELATIONSHIP CODE BETWEEN AN INDIVIDUAL AND A PRIMARY SOCIAL SECURITY ADMINISTRATION (SSA) BENEFICIARY. STANDARD ALIAS: BENE_IDENT_CD COMMON ALIAS: BIC SAS ALIAS: BIC CODES: A = PRIMARY CLAIMANT B = AGED WIFE, AGE 62 OR OVER (1ST CLAIMANT) B1 = AGED HUSBAND, AGE 62 OR OVER (1ST CLAIMANT) B2 = YOUNG WIFE, WITH A CHILD IN HER CARE (1ST CLAIMANT) B3 = AGED WIFE (2ND CLAIMANT) B4 = AGED HUSBAND (2ND CLAIMANT) B5 = YOUNG WIFE (2ND CLAIMANT) B6 = DIVORCED WIFE, AGE 62 OR OVER (1ST CLAIMANT) 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ B7 = YOUNG WIFE (3RD CLAIMANT) B8 = AGED WIFE (3RD CLAIMANT) B9 = DIVORCED WIFE (2ND CLAIMANT) BA = AGED WIFE (4TH CLAIMANT) BD = AGED WIFE (5TH CLAIMANT) BG = AGED HUSBAND (3RD CLAIMANT) BH = AGED HUSBAND (4TH CLAIMANT) BJ = AGED HUSBAND (5TH CLAIMANT) BK = YOUNG WIFE (4TH CLAIMANT) BL = YOUNG WIFE (5TH CLAIMANT) BN = DIVORCED WIFE (3RD CLAIMANT) BP = DIVORCED WIFE (4TH CLAIMANT) BQ = DIVORCED WIFE (5TH CLAIMANT) BR = DIVORCED HUSBAND (1ST CLAIMANT) BT = DIVORCED HUSBAND (2ND CLAIMANT) BW = YOUNG HUSBAND (2ND CLAIMANT) BY = YOUNG HUSBAND (1ST CLAIMANT) C1-C9,CA-CK = CHILD (INCLUDES MINOR, STUDENT OR DISABLED CHILD) D = AGED WIDOW, 60 OR OVER (1ST CLAIMANT) D1 = AGED WIDOWER, AGE 60 OR OVER (1ST CLAIMANT) D2 = AGED WIDOW (2ND CLAIMANT) D3 = AGED WIDOWER (2ND CLAIMANT) D4 = WIDOW (REMARRIED AFTER ATTAINMENT OF AGE 60) (1ST CLAIMANT) D5 = WIDOWER (REMARRIED AFTER ATTAINMENT OF AGE 60) (1ST CLAIMANT) D6 = SURVIVING DIVORCED WIFE, AGE 60 OR OVER (1ST CLAIMANT) D7 = SURVIVING DIVORCED WIFE (2ND CLAIMANT) D8 = AGED WIDOW (3RD CLAIMANT) D9 = REMARRIED WIDOW (2ND CLAIMANT) DA = REMARRIED WIDOW (3RD CLAIMANT) DD = AGED WIDOW (4TH CLAIMANT) DG = AGED WIDOW (5TH CLAIMANT) DH = AGED WIDOWER (3RD CLAIMANT) DJ = AGED WIDOWER (4TH CLAIMANT) DK = AGED WIDOWER (5TH CLAIMANT) DL = REMARRIED WIDOW (4TH CLAIMANT) DM = SURVIVING DIVORCED HUSBAND (2ND CLAIMANT) DN = REMARRIED WIDOW (5TH CLAIMANT) DP = REMARRIED WIDOWER (2ND CLAIMANT) DQ = REMARRIED WIDOWER (3RD CLAIMANT) DR = REMARRIED WIDOWER (4TH CLAIMANT) DS = SURVIVING DIVORCED HUSBAND (3RD CLAIMANT) DT = REMARRIED WIDOWER (5TH CLAIMANT) DV = SURVIVING DIVORCED WIFE (3RD CLAIMANT) DW = SURVIVING DIVORCED WIFE (4TH CLAIMANT) DX = SURVIVING DIVORCED HUSBAND (4TH CLAIMANT) DY = SURVIVING DIVORCED WIFE (5TH CLAIMANT) 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ DZ = SURVIVING DIVORCED HUSBAND (5TH CLAIMANT) E = MOTHER (WIDOW) (1ST CLAIMANT) E1 = SURVIVING DIVORCED MOTHER (1ST CLAIMANT) E2 = MOTHER (WIDOW) (2ND CLAIMANT) E3 = SURVIVING DIVORCED MOTHER (2ND CLAIMANT) E4 = FATHER (WIDOWER) (1ST CLAIMANT) E5 = SURVIVING DIVORCED FATHER (WIDOWER) (1ST CLAIMANT) E6 = FATHER (WIDOWER) (2ND CLAIMANT) E7 = MOTHER (WIDOW) (3RD CLAIMANT) E8 = MOTHER (WIDOW) (4TH CLAIMANT) E9 = SURVIVING DIVORCED FATHER (WIDOWER) (2ND CLAIMANT) EA = MOTHER (WIDOW) (5TH CLAIMANT) EB = SURVIVING DIVORCED MOTHER (3RD CLAIMANT) EC = SURVIVING DIVORCED MOTHER (4TH CLAIMANT) ED = SURVIVING DIVORCED MOTHER (5TH CLAIMANT EF = FATHER (WIDOWER) (3RD CLAIMANT) EG = FATHER (WIDOWER) (4TH CLAIMANT) EH = FATHER (WIDOWER) (5TH CLAIMANT) EJ = SURVIVING DIVORCED FATHER (3RD CLAIMANT) EK = SURVIVING DIVORCED FATHER (4TH CLAIMANT) EM = SURVIVING DIVORCED FATHER (5TH CLAIMANT) F1 = FATHER F2 = MOTHER F3 = STEPFATHER F4 = STEPMOTHER F5 = ADOPTING FATHER F6 = ADOPTING MOTHER F7 = SECOND ALLEGED FATHER F8 = SECOND ALLEGED MOTHER J1 = PRIMARY PROUTY ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) J2 = PRIMARY PROUTY ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) J3 = PRIMARY PROUTY NOT ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) J4 = PRIMARY PROUTY NOT ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) K1 = PROUTY WIFE ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (1ST CLAIMANT) K2 = PROUTY WIFE ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) (1ST CLAIMANT) K3 = PROUTY WIFE NOT ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (1ST 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ CLAIMANT) K4 = PROUTY WIFE NOT ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) (1ST CLAIMANT) K5 = PROUTY WIFE ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (2ND CLAIMANT) K6 = PROUTY WIFE ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) (2ND CLAIMANT) K7 = PROUTY WIFE NOT ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (2ND CLAIMANT) K8 = PROUTY WIFE NOT ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) (2ND CLAIMANT) K9 = PROUTY WIFE ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (3RD CLAIMANT) KA = PROUTY WIFE ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) (3RD CLAIMANT) KB = PROUTY WIFE NOT ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (3RD CLAIMANT) KC = PROUTY WIFE NOT ENTITLED TO HIB (OVER 2 Q.C.) (RSI TRUST FUND) (3RD CLAIMANT) KD = PROUTY WIFE ENTITLED TO HIB (LESS THAN 3 Q.C.) (GENERAL FUND) (4TH CLAIMANT) KE = PROUTY WIFE ENTITLED TO HIB (OVER 2 Q.C (4TH CLAIMANT) KF = PROUTY WIFE NOT ENTITLED TO HIB (LESS THAN 3 Q.C.)(4TH CLAIMANT) KG = PROUTY WIFE NOT ENTITLED TO HIB (OVER 2 Q.C.)(4TH CLAIMANT) KH = PROUTY WIFE ENTITLED TO HIB (LESS THAN 3 Q.C.)(5TH CLAIMANT) KJ = PROUTY WIFE ENTITLED TO HIB (OVER 2 Q.C.) (5TH CLAIMANT) KL = PROUTY WIFE NOT ENTITLED TO HIB (LESS THAN 3 Q.C.)(5TH CLAIMANT) KM = PROUTY WIFE NOT ENTITLED TO HIB (OVER 2 Q.C.) (5TH CLAIMANT) M = UNINSURED-NOT QUALIFIED FOR DEEMED HIB M1 = UNINSURED-QUALIFIED BUT REFUSED HIB T = UNINSURED-ENTITLED TO HIB UNDER DEEMED OR RENAL PROVISIONS TA = MQGE (PRIMARY CLAIMANT) TB = MQGE AGED SPOUSE (FIRST CLAIMANT) TC = MQGE DISABLED ADULT CHILD (FIRST CLAIMANT) TD = MQGE AGED WIDOW(ER) (FIRST CLAIMANT) TE = MQGE YOUNG WIDOW(ER) (FIRST CLAIMANT) TF = MQGE PARENT (MALE) TG = MQGE AGED SPOUSE (SECOND CLAIMANT) TH = MQGE AGED SPOUSE (THIRD CLAIMANT) TJ = MQGE AGED SPOUSE (FOURTH CLAIMANT) TK = MQGE AGED SPOUSE (FIFTH CLAIMANT) 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ TL = MQGE AGED WIDOW(ER) (SECOND CLAIMANT) TM = MQGE AGED WIDOW(ER) (THIRD CLAIMANT) TN = MQGE AGED WIDOW(ER) (FOURTH CLAIMANT) TP = MQGE AGED WIDOW(ER) (FIFTH CLAIMANT) TQ = MQGE PARENT (FEMALE) TR = MQGE YOUNG WIDOW(ER) (SECOND CLAIMANT) TS = MQGE YOUNG WIDOW(ER) (THIRD CLAIMANT) TT = MQGE YOUNG WIDOW(ER) (FOURTH CLAIMANT) TU = MQGE YOUNG WIDOW(ER) (FIFTH CLAIMANT) TV = MQGE DISABLED WIDOW(ER) FIFTH CLAIMANT TW = MQGE DISABLED WIDOW(ER) FIRST CLAIMANT TX = MQGE DISABLED WIDOW(ER) SECOND CLAIMANT TY = MQGE DISABLED WIDOW(ER) THIRD CLAIMANT TZ = MQGE DISABLED WIDOW(ER) FOURTH CLAIMANT T2-T9 = DISABLED CHILD (SECOND TO NINTH CLAIMANT) W = DISABLED WIDOW, AGE 50 OR OVER (1ST CLAIMANT) W1 = DISABLED WIDOWER, AGE 50 OR OVER (1ST CLAIMANT) W2 = DISABLED WIDOW (2ND CLAIMANT) W3 = DISABLED WIDOWER (2ND CLAIMANT) W4 = DISABLED WIDOW (3RD CLAIMANT) W5 = DISABLED WIDOWER (3RD CLAIMANT) W6 = DISABLED SURVIVING DIVORCED WIFE (1ST CLAIMANT) W7 = DISABLED SURVIVING DIVORCED WIFE (2ND CLAIMANT) W8 = DISABLED SURVIVING DIVORCED WIFE (3RD CLAIMANT) W9 = DISABLED WIDOW (4TH CLAIMANT) WB = DISABLED WIDOWER (4TH CLAIMANT) WC = DISABLED SURVIVING DIVORCED WIFE (4TH CLAIMANT) WF = DISABLED WIDOW (5TH CLAIMANT) WG = DISABLED WIDOWER (5TH CLAIMANT) WJ = DISABLED SURVIVING DIVORCED WIFE (5TH CLAIMANT) WR = DISABLED SURVIVING DIVORCED HUSBAND (1ST CLAIMANT) WT = DISABLED SURVIVING DIVORCED HUSBAND (2ND CLAIMANT) SOURCE: SSA **** BENEFICIARY NAME GROUP GROUP 23 12 34 THE BENEFICIARY'S FULL NAME. STANDARD ALIAS: BENE_NAME_GRP 3. BENEFICIARY SURNAME CHAR 12 12 23 THE LAST NAME OF THE MEDICARE BENEFICIARY STANDARD ALIAS: BENE_SRNM_NAME 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ SOURCE: EDB 4. BENEFICIARY GIVEN NAME CHAR 10 24 33 THE FIRST NAME OF THE MEDICARE BENEFICIARY STANDARD ALIAS: BENE_GVN_NAME 5. BENEFICIARY MIDDLE NAME CHAR 1 34 34 THE FIRST POSITION (LETTER) OF A BENEFICIARY'S MIDDLE NAME. STANDARD ALIAS: BENE_MDL_NAME SOURCE: SSA 6. FILLER CHAR 132 35 166 7. BENEFICIARY BIRTH DATE CHAR 5 167 171 THE BIRTH DATE OF THE BENEFICIARY. STANDARD ALIAS: BENE_BIRTH_DT COMMON ALIAS: DOB SAS ALIAS: DOB EDIT-RULES: YYDDD SOURCE: EDB 8. BENEFICIARY DEATH DATE CHAR 5 172 176 THE DATE OF A BENEFICIARY'S DEATH. STANDARD ALIAS: BENE_DEATH_DT EDIT-RULES: YYDDD SOURCE: EDB 9. BENEFICIARY RESIDENCE SSA CHAR 2 177 178 THE SSA STANDARD STATE CODE OF A BENEFICIARY'S STANDARD STATE CODE RESIDENCE. STANDARD ALIAS: BENE_RSDNC_SSA_STD_STATE_CD SAS ALIAS: STATE_CD CODES: 01 = ALABAMA 02 = ALASKA 03 = ARIZONA 04 = ARKANSAS 05 = CALIFORNIA 05 = COLORADO 07 = CONNECTICUT 08 = DELAWARE 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ 09 = DISTRICT OF COLUMBIA 10 = FLORIDA 11 = GEORGIA 12 = HAWAII 13 = IDAHO 14 = ILLINOIS 15 = INDIANA 16 = IOWA 17 = KANSAS 18 = KENTUCKY 19 = LOUISIANA 20 = MAINE 21 = MARYLAND 22 = MASSACHUSETTS 23 = MICHIGAN 24 = MINNESOTA 25 = MISSISSIPPI 26 = MISSOURI 27 = MONTANA 28 = NEBRASKA 29 = NEVADA 30 = NEW HAMPSHIRE 31 = NEW JERSEY 32 = NEW MEXICO 33 = NEW YORK 34 = NORTH CAROLINA 35 = NORTH DAKOTA 36 = OHIO 37 = OKLAHOMA 38 = OREGON 39 = PENNSYLVANIA 40 = PUERTO RICO 41 = RHODE ISLAND 42 = SOUTH CAROLINA 43 = SOUTH DAKOTA 44 = TENNESSEE 45 = TEXAS 46 = UTAH 47 = VERMONT 48 = VIRGIN ISLANDS 49 = VIRGINIA 50 = WASHINGTON 51 = WEST VIRGINIA 52 = WISCONSIN 53 = WYOMING 54 = AFRICA 55 = CALIFORNIA; INSTITUTIONAL PROVIDER OF SERVICES (IPS) ONLY 56 = CANADA 57 = CENTRAL AMERICA AND WEST INDIES 58 = EUROPE 59 = MEXICO 60 = OCEANIA 61 = PHILIPPINES 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ 62 = SOUTH AMERICA 63 = U.S. POSSESSIONS 64 = AMERICAN SAMOA 65 = GUAM 66 = SAIPAN 67 = TEXAS; INSTITUTIONAL PROVIDER OF SERVICES (IPS) ONLY 97 = NORTHERN MARIANAS 98 = GUAM 99 = WITH 000 COUNTY CODE IS AMERICAN SAMOA; OTHERWISE UNKNOWN COMMENT: 1. USED IN CONJUNCTION WITH A COUNTY CODE, AS SELECTION CRITERIA FOR THE DETERMINATION OF PAYMENT RATES FOR HMO REIMBURSEMENT. 2. CONCERNING INDIVIDUALS DIRECTLY BILLABLE FOR PART B AND/OR PART A PREMIUMS, THIS ELEMENT IS USED TO DETERMINE IF THE BENEFICIARY WILL RECEIVE A BILL IN ENGLISH OR SPANISH. 3. ALSO USED FOR SPECIAL STUDIES. SOURCE: SSA 10. BENEFICIARY RESIDENCE SSA CHAR 3 179 181 THE SSA STANDARD COUNTY CODE OF A BENEFICIARY'S STANDARD COUNTY CODE RESIDENCE. STANDARD ALIAS: BENE_RSDNC_SSA_STD_CNTY_CD SAS ALIAS: CNTY_CD SOURCE: SSA 11. BENEFICIARY MAILING CONTACT CHAR 5 182 186 THE ZIP CODE OF THE MAILING ADDRESS WHERE THE ZIP CODE BENEFICIARY MAY BE CONTACTED. STANDARD ALIAS: BENE_MLG_CNTCT_ZIP_CD SAS ALIAS: ZIP_CD SOURCE: EDB 12. BENEFICIARY SEX CODE CHAR 1 187 187 THE SEX OF A BENEFICIARY. CODES: 1 = MALE 2 = FEMALE 0 = UNKNOWN 13. BENEFICIARY RACE CODE CHAR 1 188 188 THE RACE OF A BENEFICIARY. STANDARD ALIAS: BENE_RACE_CD SAS ALIAS: RACE_CD 1 VITAL STATISTICS RECORD POSITIONS NAME TYPE LENGTH BEG END CONTENTS --------------------------- ---- ------ --------- ------------------------------------------------------------ CODES: 0 = UNKNOWN 1 = WHITE 2 = BLACK 3 = OTHER SOURCE: SSA 14. FINDER RESPONSE CODE CHAR 1 189 189 CODE INDICATING WHAT THE FINDER KEY FIELD MATCHES. STANDARD ALIAS: FNDR_RSPNC_CD CODES: 0 = NOT IN FILE 1 = BENE_CLM_NUM_GRP MATCH 2 = XREF_BENE_CLM_NUM_GRP MATCH 3 = BENE_CLM_ACNT_NUM MATCH WITH BIC EQUATE 4 = BENE_CLM_ACNT_NUM MATCH WITH NO INPUT BIC 15. ORIGINAL FINDER RECORD CHAR 11 190 200 ORIGINAL FINDER 11 BYTE RECORD 16. ORIGINAL FINDER RECORD CHAR 14 190 203 REDEFINITION OF: ORGNL_FNDR_11_TXT ORIGINAL FINDER 14 BYTE RECORD 17. ORIGINAL FINDER RECORD CHAR 30 190 219 REDEFINITION OF: ORGNL_FNDR_11_TXT ORIGINAL FINDER 30 BYTE RECORD 18. ORIGINAL FINDER RECORD CHAR 45 190 234 REDEFINITION OF: ORGNL_FNDR_11_TXT ORIGINAL FINDER 45 BYTE RECORD 19. ORIGINAL FINDER RECORD CHAR 80 190 269 REDEFINITION OF: ORGNL_FNDR_11_TXT ORIGINAL FINDER 80 BYTE RECORD