BDWA0 ;IHS/CMI/LAB - DW EXPORT - OLD, NOT USED;
;;1.0;IHS DATA WAREHOUSE;;JAN 23, 2006
;
Q
;; REGISTRATION EXPORT RECORD LAYOUT
;; --------------------------------------------------------------------
;; *** RG1 RECORD LAYOUT ***
;; *** AGTXA ***
;; Piece #
;; 01 001 03 "RG1"
;; 02 UNIQUE REGISTRATION ID
;; 02 004 06 FACILITY CODE
;; 03 010 06 UNIT RECORD NUMBER
;; 04 016 20 LAST NAME
;; 05 036 11 FIRST NAME
;; 06 047 11 MIDDLE NAME
;; 07 059 02 CLASSIFICATION CODE
;; 08 061 07 DATE OF BIRTH
;; 09 068 01 SEX
;; 10 069 09 SOCIAL SECURITY NUMBER
;; 11 078 03 TRIBE CODE
;; 12 081 01 BLOOD QUANTUM
;; 13 082 20 FATHER LAST NAME
;; 14 102 11 FATHER FIRST NAME
;; 15 113 01 FATHER MIDDLE INITIAL
;; 16 114 07 COMMUNITY OF RESIDENCE
;; 17 121 30 MAILING ADDRESS STREET
;; 18 151 15 MAILING ADDRESS TOWN
;; 19 166 02 MAILING ADDRESS STATE
;; 20 168 09 MAILING ADDRESS ZIP
;; --------------------------------------------------------------------
;; *** RG2 FORMAT ***
;; *** AGTX1 ***
;; 01 ... 03 "RG2"
;; 02 UNIQUE REGISTRATION ID
;; 02 177 20 MOTHER NAME LAST X
;; 03 197 11 MOTHER NAME FIRST X
;; 04 208 01 MOTHER NAME MIDDLE INITIAL
;; 05 209 06 DATE OF DEATH
;; 06 215 01 MEDICARE A ELIGIBLE
;; 07 216 14 MEDICARE A ENROLL NUMBER
;; 08 225 01 MEDICARE A SUFFIX
;; 09 230 06 MEDICARE A ELIGIBILITY
;; 10 236 01 MEDICARE B ELIGIBLE
;; 11 237 14 MEDICARE B ENROLL NUMBER
;; 12 246 01 MEDICARE B SUFFIX
;; 13 251 06 MEDICARE B ELIGIBILITY
;; 14 257 01 MEDICARE AB ELIGIBLE
;; 15 258 14 MEDICARE AB ENROLL NUMBER
;; 16 267 01 MEDICARE AB SUFFIX
;; 17 272 06 MEDICARE AB ELIGIBILITY
;; 18 278 01 MEDICAID ELIGIBLE
;; 19 279 14 MEDICAID NUMBER
;; 20 288 01 MEDICAID SUFFIX
;; 21 293 06 MEDICAID ELIGIBILITY DATE
;; 22 299 01 VETERAN
;; 23 300 01 BLUE CROSS ELIGIBLE
;; 24 301 01 OTHER ELIGIBLE
;; 25 302 01 CHS ELIGIBILITY
;; 26 303 01 PATIENT SIGNED
;; 27 304 01 ADD/MODIFY CODE
;; 28 305 06 OPT/MM RELEASE DATE
;; 29 311 01 ELIGIBILITY CODE
;; 30 312 01 BIC ELIGIBILITY CODE
;; 31 313 01 BIC ISSUED (Y or null)
;; 32 314 02 MEDICAID STATE OF ELIGIBILITY
;; 33 316 02 MEDICAID TYPE OF COVERAGE
;; 34 DATE OF LAST UPDATE
;;--------------------------------------------------------------------
;; *** RG3 FORMAT ***
;; *** AGTXA ***
;; 01 03 "RG3"
;; 02 UNIQUE REGISTRATION ID
;; 02
;; 03
;; 04
;; 05
;; 06
;; 07
;;--------------------------------------------------------------------
;; *** RG4 RECORD FORMAT ***
;; *** AGTX1, AGTX2 ***
;; 01 03 "RG4"
;; 02 UNIQUE REGISTRATION ID
;; 02 $P(^AUTTLOC(SITE,0),"^",10)_
;; 03 01 FIRST LETTER OF LN
;; 04 01 FIRST LETTER OF FN
;; 05 SEX
;; 06 HRN
;; 07 blank
;; 08 FACILITY CODE
;; 09 HRN
;;--------------------------------------------------------------------
;; *** RG5 FORMAT ***
;; *** AGTX1 & 2 ***
;; 01 001 03 "RG5"
;; 02 UNIQUE REGISTRATION ID
;; 02 004 14 ELIGIBILITY ENROLLMENT NUMBER
;; 03 018 01 SUFFIX
;; 04 019 01 ELIG TYPE: 1=A, 2=B, 3=AB, 4=M
;; 05 020 07 DATE OF BIRTH
;; 06 027 06 ELIG BEGIN DATE
;; 07 033 20 MEDICARE LAST NAME X
;; 08 053 11 MEDICARE FIRST NAME X
;; 09 064 11 MEDICARE MIDDLE NAME X
;; 10 075 20 MEDICAID LAST NAME X
;; 11 095 11 MEDICAID FIRST NAME X
;; 12 106 11 MEDICAID MIDDLE NAME X
;; 13 117 06 MEDICARE DATE OF BIRTH MMDDYYY
;; 14 123 06 MEDICAID DATE OF BIRTH MMDDYYY
;; 15 129 06 MEDICARE A ELIG. END DATE MMDDYY
;; 16 135 06 MEDICARE B ELIG. END DATE MMDDYY
;; 17 141 06 MEDICARE AB ELIG. END DATE MMDDYY
;; 18 147 06 MEDICAID ELIG. END DATE MMDDYY
;; 153 END RG5
;;
BDWA0 ;IHS/CMI/LAB - DW EXPORT - OLD, NOT USED;
+1 ;;1.0;IHS DATA WAREHOUSE;;JAN 23, 2006
+2 ;
+3 QUIT
+4 ;; REGISTRATION EXPORT RECORD LAYOUT
+5 ;; --------------------------------------------------------------------
+6 ;; *** RG1 RECORD LAYOUT ***
+7 ;; *** AGTXA ***
+8 ;; Piece #
+9 ;; 01 001 03 "RG1"
+10 ;; 02 UNIQUE REGISTRATION ID
+11 ;; 02 004 06 FACILITY CODE
+12 ;; 03 010 06 UNIT RECORD NUMBER
+13 ;; 04 016 20 LAST NAME
+14 ;; 05 036 11 FIRST NAME
+15 ;; 06 047 11 MIDDLE NAME
+16 ;; 07 059 02 CLASSIFICATION CODE
+17 ;; 08 061 07 DATE OF BIRTH
+18 ;; 09 068 01 SEX
+19 ;; 10 069 09 SOCIAL SECURITY NUMBER
+20 ;; 11 078 03 TRIBE CODE
+21 ;; 12 081 01 BLOOD QUANTUM
+22 ;; 13 082 20 FATHER LAST NAME
+23 ;; 14 102 11 FATHER FIRST NAME
+24 ;; 15 113 01 FATHER MIDDLE INITIAL
+25 ;; 16 114 07 COMMUNITY OF RESIDENCE
+26 ;; 17 121 30 MAILING ADDRESS STREET
+27 ;; 18 151 15 MAILING ADDRESS TOWN
+28 ;; 19 166 02 MAILING ADDRESS STATE
+29 ;; 20 168 09 MAILING ADDRESS ZIP
+30 ;; --------------------------------------------------------------------
+31 ;; *** RG2 FORMAT ***
+32 ;; *** AGTX1 ***
+33 ;; 01 ... 03 "RG2"
+34 ;; 02 UNIQUE REGISTRATION ID
+35 ;; 02 177 20 MOTHER NAME LAST X
+36 ;; 03 197 11 MOTHER NAME FIRST X
+37 ;; 04 208 01 MOTHER NAME MIDDLE INITIAL
+38 ;; 05 209 06 DATE OF DEATH
+39 ;; 06 215 01 MEDICARE A ELIGIBLE
+40 ;; 07 216 14 MEDICARE A ENROLL NUMBER
+41 ;; 08 225 01 MEDICARE A SUFFIX
+42 ;; 09 230 06 MEDICARE A ELIGIBILITY
+43 ;; 10 236 01 MEDICARE B ELIGIBLE
+44 ;; 11 237 14 MEDICARE B ENROLL NUMBER
+45 ;; 12 246 01 MEDICARE B SUFFIX
+46 ;; 13 251 06 MEDICARE B ELIGIBILITY
+47 ;; 14 257 01 MEDICARE AB ELIGIBLE
+48 ;; 15 258 14 MEDICARE AB ENROLL NUMBER
+49 ;; 16 267 01 MEDICARE AB SUFFIX
+50 ;; 17 272 06 MEDICARE AB ELIGIBILITY
+51 ;; 18 278 01 MEDICAID ELIGIBLE
+52 ;; 19 279 14 MEDICAID NUMBER
+53 ;; 20 288 01 MEDICAID SUFFIX
+54 ;; 21 293 06 MEDICAID ELIGIBILITY DATE
+55 ;; 22 299 01 VETERAN
+56 ;; 23 300 01 BLUE CROSS ELIGIBLE
+57 ;; 24 301 01 OTHER ELIGIBLE
+58 ;; 25 302 01 CHS ELIGIBILITY
+59 ;; 26 303 01 PATIENT SIGNED
+60 ;; 27 304 01 ADD/MODIFY CODE
+61 ;; 28 305 06 OPT/MM RELEASE DATE
+62 ;; 29 311 01 ELIGIBILITY CODE
+63 ;; 30 312 01 BIC ELIGIBILITY CODE
+64 ;; 31 313 01 BIC ISSUED (Y or null)
+65 ;; 32 314 02 MEDICAID STATE OF ELIGIBILITY
+66 ;; 33 316 02 MEDICAID TYPE OF COVERAGE
+67 ;; 34 DATE OF LAST UPDATE
+68 ;;--------------------------------------------------------------------
+69 ;; *** RG3 FORMAT ***
+70 ;; *** AGTXA ***
+71 ;; 01 03 "RG3"
+72 ;; 02 UNIQUE REGISTRATION ID
+73 ;; 02
+74 ;; 03
+75 ;; 04
+76 ;; 05
+77 ;; 06
+78 ;; 07
+79 ;;--------------------------------------------------------------------
+80 ;; *** RG4 RECORD FORMAT ***
+81 ;; *** AGTX1, AGTX2 ***
+82 ;; 01 03 "RG4"
+83 ;; 02 UNIQUE REGISTRATION ID
+84 ;; 02 $P(^AUTTLOC(SITE,0),"^",10)_
+85 ;; 03 01 FIRST LETTER OF LN
+86 ;; 04 01 FIRST LETTER OF FN
+87 ;; 05 SEX
+88 ;; 06 HRN
+89 ;; 07 blank
+90 ;; 08 FACILITY CODE
+91 ;; 09 HRN
+92 ;;--------------------------------------------------------------------
+93 ;; *** RG5 FORMAT ***
+94 ;; *** AGTX1 & 2 ***
+95 ;; 01 001 03 "RG5"
+96 ;; 02 UNIQUE REGISTRATION ID
+97 ;; 02 004 14 ELIGIBILITY ENROLLMENT NUMBER
+98 ;; 03 018 01 SUFFIX
+99 ;; 04 019 01 ELIG TYPE: 1=A, 2=B, 3=AB, 4=M
+100 ;; 05 020 07 DATE OF BIRTH
+101 ;; 06 027 06 ELIG BEGIN DATE
+102 ;; 07 033 20 MEDICARE LAST NAME X
+103 ;; 08 053 11 MEDICARE FIRST NAME X
+104 ;; 09 064 11 MEDICARE MIDDLE NAME X
+105 ;; 10 075 20 MEDICAID LAST NAME X
+106 ;; 11 095 11 MEDICAID FIRST NAME X
+107 ;; 12 106 11 MEDICAID MIDDLE NAME X
+108 ;; 13 117 06 MEDICARE DATE OF BIRTH MMDDYYY
+109 ;; 14 123 06 MEDICAID DATE OF BIRTH MMDDYYY
+110 ;; 15 129 06 MEDICARE A ELIG. END DATE MMDDYY
+111 ;; 16 135 06 MEDICARE B ELIG. END DATE MMDDYY
+112 ;; 17 141 06 MEDICARE AB ELIG. END DATE MMDDYY
+113 ;; 18 147 06 MEDICAID ELIG. END DATE MMDDYY
+114 ;; 153 END RG5
+115 ;;
