FileMan FileNo | FileMan Filename | Package |
---|---|---|
727.827 | CLINIC EXTRACT | DSS Extracts |
Package | Total | Routines |
---|---|---|
DSS Extracts | 6 | ECXUCBOC ^ECX(727.827 ^ECX(729 ECX8271 ECX8272 ECXSCXN |
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 |
|
Name | Field # of Occurrence |
---|---|
$$ECXDATEX^ECXUTL | 8OT+1, 160OT+1, 161OT+1 |
$$ECXTIMEX^ECXUTL | 162OT+1 |
$$ECXYMX^ECXUTL | 1OT+1 |
Name | Line Occurrences (* Changed, ! Killed) |
---|---|
^ECX(727.827 - [#727.827] | 2(XREF 1S), 2(XREF 1K) |
>> | Not killed explicitly |
* | Changed |
! | Killed |
~ | Newed |
Name | Field # of Occurrence |
---|---|
>> DA | 2(XREF 1S), 2(XREF 1K) |
>> DINUM | .01+1* |
X | .01+1!, 1+1!, 2(XREF 1S), 2(XREF 1K), 5+1!, 6+1!, 8+1!, 9+1!, 12+1!, 13+1! , 15+1!, 16+1!, 17+1!, 18+1!, 19+1!, 20+1!, 21+1!, 22+1!, 23+1!, 24+1! , 25+1!, 26+1!, 27+1!, 28+1!, 29+1!, 30+1!, 31+1!, 32+1!, 33+1!, 35+1! , 37+1!, 42+1!, 43+1!, 45+1!, 46+1!, 47+1!, 48+1!, 51+1!, 52+1!, 53+1! , 54+1!, 55+1!, 56+1!, 57+1!, 58+1!, 60+1!, 64+1!, 66+1!, 68+1!, 73+1! , 74+1!, 76+1!, 77+1!, 81+1!, 86+1!, 88+1!, 89+1!, 90+1!, 91+1!, 92+1! , 93+1!, 96+1!, 97+1!, 98+1!, 99+1!, 100+1!, 101+1!, 102+1!, 103+1!, 104+1! , 105+1!, 106+1!, 107+1!, 108+1!, 109+1!, 110+1!, 112+1!, 113+1!, 114+1!, 115+1! , 116+1!, 119+1!, 120+1!, 121+1!, 122+1!, 123+1!, 124+1!, 127+1!, 129+1!, 131+1! , 132+1!, 133+1!, 134+1!, 135+1!, 136+1!, 137+1!, 138+1!, 139+1!, 140+1!, 141+1! , 142+1!, 143+1!, 144+1!, 145+1!, 146+1!, 147+1!, 148+1!, 149+1!, 150+1!, 151+1! , 152+1!, 153+1!, 154+1!, 155+1!, 156+1!, 157+1!, 160+1!, 161+1!, 162+1!, 163+1! , 164+1!, 165+1!, 166+1!, 167+1!, 168+1! |
>> Y | 1OT+1*, 8OT+1*, 160OT+1*, 161OT+1*, 162OT+1* |
>> Y(0 | 1OT+1*, 8OT+1*, 160OT+1*, 161OT+1*, 162OT+1* |