| FileMan FileNo | FileMan Filename | Package |
|---|---|---|
| 727.827 | CLINIC EXTRACT | DSS Extracts |
| Package | Total | FileMan Files |
|---|---|---|
| Registration | 3 | MEDICAL CENTER DIVISION(#40.8)[3] ENROLLMENT STATUS(#27.15)[61] PATIENT(#2)[4] |
| Scheduling | 2 | HOSPITAL LOCATION(#44)[11, 130] TEAM(#404.51)[14] |
| DSS Extracts | 1 | DSS EXTRACT LOG(#727)[2] |
| Field # | Name | Loc | Type | Details |
|---|---|---|---|---|
| .01 | SEQUENCE NUMBER | 0;1 | NUMBER | ************************REQUIRED FIELD************************
|
| 1 | YEAR MONTH | 0;2 | FREE TEXT | ************************REQUIRED FIELD************************
|
| 2 | EXTRACT NUMBER | 0;3 | POINTER TO DSS EXTRACT LOG FILE (#727) | ************************REQUIRED FIELD************************ DSS EXTRACT LOG(#727)
|
| 3 | FACILITY | 0;4 | POINTER TO MEDICAL CENTER DIVISION FILE (#40.8) | MEDICAL CENTER DIVISION(#40.8)
|
| 4 | PATIENT NO. - DFN | 0;5 | POINTER TO PATIENT FILE (#2) | ************************REQUIRED FIELD************************ PATIENT(#2)
|
| 5 | SSN | 0;6 | FREE TEXT |
|
| 6 | NAME | 0;7 | FREE TEXT |
|
| 7 | IN/OUT PATIENT INDICATOR | 0;8 | SET |
|
| 8 | DAY | 0;9 | FREE TEXT |
|
| 9 | PLACEHOLD FEEDER KEY | 0;10 | FREE TEXT |
|
| 10 | OVERBOOKED INDICATOR | 0;11 | SET |
|
| 11 | *PLACEHOLDER | 0;12 | POINTER TO HOSPITAL LOCATION FILE (#44) | HOSPITAL LOCATION(#44)
|
| 12 | TREATING SPECIALITY | 0;13 | FREE TEXT |
|
| 13 | TIME | 0;14 | FREE TEXT |
|
| 14 | PLACEHOLD PRIMARY CARE TEAM | 0;15 | POINTER TO TEAM FILE (#404.51) | TEAM(#404.51)
|
| 15 | PLACEHOLD PC PROVIDER | 0;16 | FREE TEXT |
|
| 16 | PLACEHOLD PC PROV PERSON CLASS | 0;17 | FREE TEXT |
|
| 17 | PROVIDER | 0;18 | FREE TEXT |
|
| 18 | PROVIDER PERSON CLASS | 0;19 | FREE TEXT |
|
| 19 | PLACEHOLD CPT QTY & MODS #1 | 0;20 | FREE TEXT |
|
| 20 | PLACEHOLD CPT QTY & MODS #2 | 0;21 | FREE TEXT |
|
| 21 | PLACEHOLD CPT QTY & MODS #3 | 0;22 | FREE TEXT |
|
| 22 | PLACEHOLD CPT QTY & MODS #4 | 0;23 | FREE TEXT |
|
| 23 | PLACEHOLD CPT QTY & MODS #5 | 0;24 | FREE TEXT |
|
| 24 | PLACEHOLD CPT QTY & MODS #6 | 1;1 | FREE TEXT |
|
| 25 | PLACEHOLD CPT QTY & MODS #7 | 1;2 | FREE TEXT |
|
| 26 | PLACEHOLD CPT QTY & MODS #8 | 1;3 | FREE TEXT |
|
| 27 | PLACEHOLDER | 1;4 | FREE TEXT |
|
| 28 | PLACEHOLDER | 1;5 | FREE TEXT |
|
| 29 | PLACEHOLDER | 1;6 | FREE TEXT |
|
| 30 | PLACEHOLDER | 1;7 | FREE TEXT |
|
| 31 | PLACEHOLDER | 1;8 | FREE TEXT |
|
| 32 | DATE OF BIRTH | 1;9 | FREE TEXT |
|
| 33 | ELIGIBILITY | 1;10 | FREE TEXT |
|
| 34 | VETERAN | 1;11 | SET |
|
| 35 | PLACEHOLD RACE | 1;12 | FREE TEXT |
|
| 36 | POW STATUS | 1;13 | SET |
|
| 37 | POW LOCATION | 1;14 | FREE TEXT |
|
| 38 | RADIATION STATUS | 1;15 | SET |
|
| 39 | RADIATION ENCOUNTER INDICATOR | 1;16 | SET |
|
| 40 | AGENT ORANGE STATUS | 1;17 | SET |
|
| 41 | AGENT ORANGE ENC INDICATOR | 1;18 | SET |
|
| 42 | PLACEHOLD MPI | 1;19 | FREE TEXT |
|
| 43 | PLACEHOLD DSS PRODUCT DEPT | 1;20 | FREE TEXT |
|
| 44 | SEX | 1;21 | SET |
|
| 45 | ZIP+4 | 1;22 | FREE TEXT |
|
| 46 | PLACEHOLDER | 1;23 | FREE TEXT |
|
| 47 | PLACEHOLDER | 1;24 | FREE TEXT |
|
| 48 | ENCOUNTER ELIGIBILITY | 1;25 | NUMBER |
|
| 49 | MST STATUS | 1;26 | SET |
|
| 50 | MST ENCOUNTER INDICATOR | 1;27 | SET |
|
| 51 | PLACEHOLD SHARE AGREEMNT PAYOR | 1;28 | FREE TEXT |
|
| 52 | PLACEHOLD SHARE AGREEMNT INSUR | 1;29 | FREE TEXT |
|
| 53 | ENROLLMENT LOCATION | 1;30 | FREE TEXT |
|
| 54 | STATE CODE | 1;31 | FREE TEXT |
|
| 55 | COUNTY CODE | 1;32 | FREE TEXT |
|
| 56 | PLACEHOLD ASSOC PC PROVIDER | 1;33 | FREE TEXT |
|
| 57 | PLACEHOLD AS PC PROV PERSON CL | 1;34 | FREE TEXT |
|
| 58 | PLACEHOLDER | 1;35 | FREE TEXT |
|
| 59 | DOM,PRRTP AND SAARTP INDICATOR | 1;36 | SET |
|
| 60 | ENROLLMENT CATEGORY | 1;37 | FREE TEXT |
|
| 61 | ENROLLMENT STATUS | 2;1 | POINTER TO ENROLLMENT STATUS FILE (#27.15) | ENROLLMENT STATUS(#27.15)
|
| 62 | SHAD STATUS | 2;2 | SET |
|
| 63 | PURPLE HEART INDICATOR | 2;3 | SET |
|
| 64 | PERIOD OF SERVICE | 2;4 | FREE TEXT |
|
| 65 | OBSERVATION PATIENT INDICATOR | 2;5 | SET |
|
| 66 | ENCOUNTER NUMBER | 2;6 | FREE TEXT |
|
| 67 | AGENT ORANGE LOCATION | 2;7 | SET |
|
| 68 | PRODUCTION DIVISION CODE | 2;8 | FREE TEXT |
|
| 69 | APPOINTMENT TYPE | 2;9 | SET |
|
| 70 | PURPOSE OF VISIT | 2;10 | SET |
|
| 71 | PLACEHOLD MEANS TEST | 2;11 | SET |
|
| 72 | HEAD & NECK CANCER INDICATOR | 2;12 | SET |
|
| 73 | PLACEHOLD ETHNICITY | 2;13 | FREE TEXT |
|
| 74 | PLACEHOLD RACE 1 | 2;14 | FREE TEXT |
|
| 75 | CBOC STATUS INDICATOR | 2;15 | SET |
|
| 76 | PLACEHOLD DSS IP # | 2;16 | NUMBER |
|
| 77 | ENROLLMENT PRIORITY | 2;17 | FREE TEXT |
|
| 78 | USER ENROLLEE | 2;18 | SET |
|
| 79 | PATIENT TYPE | 2;19 | SET |
|
| 80 | CV STATUS ELIGIBILITY | 2;20 | SET |
|
| 81 | CV ELIGIBILITY END DATE | 2;21 | FREE TEXT |
|
| 82 | ENCOUNTER CV | 2;22 | SET |
|
| 83 | PLACEHOLD NAT'L PAT REC FLAG | 2;23 | SET |
|
| 84 | SW ASIA CONDITIONS | 2;24 | SET |
|
| 85 | ENCOUNTER SWAC | 2;25 | SET |
|
| 86 | ERI | 2;26 | FREE TEXT |
|
| 87 | ENC HEAD/NECK CA | 2;27 | SET |
|
| 88 | OEF/OIF | 2;28 | FREE TEXT |
|
| 89 | OEF/OIF RETURN DATE | 2;29 | FREE TEXT |
|
| 90 | PLACEHOLD ASSOC PC PROV NPI | 2;30 | FREE TEXT |
|
| 91 | PLACEHOLD PC PROVIDER NPI | 2;31 | FREE TEXT |
|
| 92 | PROVIDER NPI | 2;32 | FREE TEXT |
|
| 93 | COUNTRY CODE | 3;1 | FREE TEXT |
|
| 94 | ENCOUNTER SHAD | 3;2 | SET |
|
| 95 | PATCAT | 3;3 | SET |
|
| 96 | SECONDARY PROVIDER #1 | 3;4 | FREE TEXT |
|
| 97 | SECONDARY PROVIDER #1 PC | 3;5 | FREE TEXT |
|
| 98 | SECONDARY PROVIDER #1 NPI | 3;6 | FREE TEXT |
|
| 99 | SECONDARY PROVIDER #2 | 3;7 | FREE TEXT |
|
| 100 | SECONDARY PROVIDER #2 PC | 3;8 | FREE TEXT |
|
| 101 | SECONDARY PROVIDER #2 NPI | 3;9 | FREE TEXT |
|
| 102 | SECONDARY PROVIDER #3 | 3;10 | FREE TEXT |
|
| 103 | SECONDARY PROVIDER #3 PC | 3;11 | FREE TEXT |
|
| 104 | SECONDARY PROVIDER #3 NPI | 3;12 | FREE TEXT |
|
| 105 | SECONDARY PROVIDER #4 | 3;13 | FREE TEXT |
|
| 106 | SECONDARY PROVIDER #4 PC | 3;14 | FREE TEXT |
|
| 107 | SECONDARY PROVIDER #4 NPI | 3;15 | FREE TEXT |
|
| 108 | SECONDARY PROVIDER #5 | 3;16 | FREE TEXT |
|
| 109 | SECONDARY PROVIDER #5 PC | 3;17 | FREE TEXT |
|
| 110 | SECONDARY PROVIDER #5 NPI | 3;18 | FREE TEXT |
|
| 111 | ED DISPOSITION CODE | 3;19 | SET |
|
| 112 | PRIMARY ICD-10 CODE | 3;20 | FREE TEXT |
|
| 113 | SECONDARY ICD-10 CODE #1 | 3;21 | FREE TEXT |
|
| 114 | SECONDARY ICD-10 CODE #2 | 3;22 | FREE TEXT |
|
| 115 | SECONDARY ICD-10 CODE #3 | 3;23 | FREE TEXT |
|
| 116 | SECONDARY ICD-10 CODE #4 | 3;24 | FREE TEXT |
|
| 117 | ENCOUNTER SC | 3;25 | SET |
|
| 118 | VIETNAM | 3;26 | SET |
|
| 119 | SECONDARY PROVIDER #6 | 3;27 | FREE TEXT |
|
| 120 | SECONDARY PROVIDER #6 PC | 3;28 | FREE TEXT |
|
| 121 | SECONDARY PROVIDER #6 NPI | 3;29 | FREE TEXT |
|
| 122 | SECONDARY PROVIDER #7 | 4;1 | FREE TEXT |
|
| 123 | SECONDARY PROVIDER #7 PC | 4;2 | FREE TEXT |
|
| 124 | SECONDARY PROVIDER #7 NPI | 4;3 | FREE TEXT |
|
| 125 | CAMP LEJEUNE STATUS | 4;4 | SET |
|
| 126 | ENCOUNTER CAMP LEJEUNE | 4;5 | SET |
|
| 127 | PRIMARY PROCEDURE | 4;6 | FREE TEXT |
|
| 128 | COMBAT VETERAN INDICATOR | 4;7 | SET |
|
| 129 | COMBAT VETERAN LOCATION | 4;8 | FREE TEXT |
|
| 130 | CLINIC IEN | 4;9 | POINTER TO HOSPITAL LOCATION FILE (#44) | HOSPITAL LOCATION(#44)
|
| 131 | NEW FEEDER KEY | 4;10 | FREE TEXT |
|
| 132 | PATIENT DIVISION | 4;11 | FREE TEXT |
|
| 133 | CPT, QTY & MODIFIERS #1 | 4;12 | FREE TEXT |
|
| 134 | CPT, QTY & MODIFIERS #2 | 4;13 | FREE TEXT |
|
| 135 | CPT, QTY & MODIFIERS #3 | 4;14 | FREE TEXT |
|
| 136 | CPT, QTY & MODIFIERS #4 | 4;15 | FREE TEXT |
|
| 137 | CPT, QTY & MODIFIERS #5 | 4;16 | FREE TEXT |
|
| 138 | CPT, QTY & MODIFIERS #6 | 4;17 | FREE TEXT |
|
| 139 | CPT, QTY & MODIFIERS #7 | 5;1 | FREE TEXT |
|
| 140 | CPT, QTY & MODIFIERS #8 | 5;2 | FREE TEXT |
|
| 141 | CPT, QTY & MODIFIERS #9 | 5;3 | FREE TEXT |
|
| 142 | CPT, QTY & MODIFIERS #10 | 5;4 | FREE TEXT |
|
| 143 | CPT, QTY & MODIFIERS #11 | 5;5 | FREE TEXT |
|
| 144 | CPT, QTY & MODIFIERS #12 | 5;6 | FREE TEXT |
|
| 145 | CPT, QTY & MODIFIERS #13 | 5;7 | FREE TEXT |
|
| 146 | CPT, QTY & MODIFIERS #14 | 5;8 | FREE TEXT |
|
| 147 | CPT, QTY & MODIFIERS #15 | 5;9 | FREE TEXT |
|
| 148 | CPT, QTY & MODIFIERS #16 | 5;10 | FREE TEXT |
|
| 149 | CPT, QTY & MODIFIERS #17 | 5;11 | FREE TEXT |
|
| 150 | CPT, QTY & MODIFIERS #18 | 6;1 | FREE TEXT |
|
| 151 | CPT, QTY & MODIFIERS #19 | 6;2 | FREE TEXT |
|
| 152 | CPT, QTY & MODIFIERS #20 | 6;3 | FREE TEXT |
|
| 153 | CPT, QTY & MODIFIERS #21 | 6;4 | FREE TEXT |
|
| 154 | CPT, QTY & MODIFIERS #22 | 6;5 | FREE TEXT |
|
| 155 | CPT, QTY & MODIFIERS #23 | 6;6 | FREE TEXT |
|
| 156 | CPT, QTY & MODIFIERS #24 | 6;7 | FREE TEXT |
|
| 157 | CPT, QTY & MODIFIERS #25 | 6;8 | FREE TEXT |
|
| 158 | SERVICE CONNECTED STATUS | 6;9 | SET |
|
| 159 | NON-COUNT FLAG | 6;10 | SET |
|
| 160 | PLACEHOLD CERNER1 | 7;1 | FREE TEXT |
|
| 161 | ADMISSION DATE | 8;1 | FREE TEXT |
|
| 162 | ADMISSION TIME | 8;2 | FREE TEXT |
|
| 163 | PLACEHOLD CERNER2 | 8;3 | FREE TEXT |
|
| 164 | NEW MPI | 8;4 | FREE TEXT |
|
| 165 | PROVIDER TAXONOMY | 8;5 | FREE TEXT |
|
| 166 | PROVIDER STATION | 8;6 | FREE TEXT |
|
| 167 | FEEDER LOCATION | 8;7 | FREE TEXT |
|
| 168 | CPRS PROVIDER STATION | 8;8 | FREE TEXT |
|
| 169 | SELF IDENTIFIED GENDER | 8;9 | SET |
|