aurora_standard.chmarstdi

Field Type Null Default Key Extra Comment
rec_type char(2) YES
rec_seq_no char(2) YES
visit_no char(20) YES MUL
princ_dx char(7) YES
dx1 char(7) YES
dx2 char(7) YES
dx3 char(7) YES
dx4 char(7) YES
dx5 char(7) YES
dx6 char(7) YES
dx7 char(7) YES
dx8 char(7) YES
dx9 char(7) YES
dx10 char(7) YES
dx11 char(7) YES
dx12 char(7) YES
dx13 char(7) YES
dx14 char(7) YES
dx15 char(7) YES
dx16 char(7) YES
dx17 char(7) YES
dx18 char(7) YES
dx19 char(7) YES
dx20 char(7) YES
dx21 char(7) YES
dx22 char(7) YES
dx23 char(7) YES
dx24 char(7) YES
dx25 char(7) YES
dx26 char(7) YES
dx27 char(7) YES
dx28 char(7) YES
dx29 char(7) YES
poa char(1) YES
poa1 char(1) YES
poa2 char(1) YES
poa3 char(1) YES
poa4 char(1) YES
poa5 char(1) YES
poa6 char(1) YES
poa7 char(1) YES
poa8 char(1) YES
poa9 char(1) YES
poa10 char(1) YES
poa11 char(1) YES
poa12 char(1) YES
poa13 char(1) YES
poa14 char(1) YES
poa15 char(1) YES
poa16 char(1) YES
poa17 char(1) YES
poa18 char(1) YES
poa19 char(1) YES
poa20 char(1) YES
poa21 char(1) YES
poa22 char(1) YES
poa23 char(1) YES
poa24 char(1) YES
poa25 char(1) YES
poa26 char(1) YES
poa27 char(1) YES
poa28 char(1) YES
poa29 char(1) YES
filler char(97) YES

References

Local Column References
dx1
TableColumn
_1.encounters_cpt_codesecp_dx1
_1.encounters_cpt_codesecp_dx10
_1.precerts_cpt_codespcp_dx1
_1188.encounters_cpt_codesecp_dx1
_1188.encounters_cpt_codesecp_dx10
_1188.precerts_cpt_codespcp_dx1
_1218.encounters_cpt_codesecp_dx1
_1218.encounters_cpt_codesecp_dx10
_1218.precerts_cpt_codespcp_dx1
_1548.encounters_cpt_codesecp_dx1
_1548.encounters_cpt_codesecp_dx10
_1548.precerts_cpt_codespcp_dx1
_435.encounters_cpt_codesecp_dx1
_435.encounters_cpt_codesecp_dx10
_435.precerts_cpt_codespcp_dx1
_436.encounters_cpt_codesecp_dx1
_436.encounters_cpt_codesecp_dx10
_436.precerts_cpt_codespcp_dx1
_436_archive_testing.encounters_cpt_codesecp_dx1
_436_archive_testing.encounters_cpt_codesecp_dx10
_436_archive_testing.precerts_cpt_codespcp_dx1
_437.encounters_cpt_codesecp_dx1
_437.encounters_cpt_codesecp_dx10
_437.precerts_cpt_codespcp_dx1
_8.encounters_cpt_codesecp_dx1
_8.encounters_cpt_codesecp_dx10
_8.precerts_cpt_codespcp_dx1
_81.encounters_cpt_codesecp_dx1
_81.encounters_cpt_codesecp_dx10
_81.precerts_cpt_codespcp_dx1
_999.encounters_cpt_codesecp_dx1
_999.encounters_cpt_codesecp_dx10
_999.precerts_cpt_codespcp_dx1
aurora_standard.chmadmpradmit_dx1
aurora_standard.chmcostrcreason_dx1
aurora_standard.chmhid4creason_dx1
aurora_standard.chmmhastother_dx1
aurora_standard.chmmhastother_dx10
aurora_standard.chmmhastother_dx11
aurora_standard.chmmhastother_dx12
aurora_standard.chmmhastother_dx13
aurora_standard.chmmhastother_dx14
aurora_standard.chmmhastother_dx15
aurora_standard.chmmhastother_dx16
aurora_standard.chmmhastother_dx17
aurora_standard.chmmhastother_dx18
aurora_standard.chmmhastother_dx19
aurora_standard.chmmhastpoa_dx1
aurora_standard.chmmhastpoa_dx10
aurora_standard.chmmhastpoa_dx11
aurora_standard.chmmhastpoa_dx12
aurora_standard.chmmhastpoa_dx13
aurora_standard.chmmhastpoa_dx14
aurora_standard.chmmhastpoa_dx15
aurora_standard.chmmhastpoa_dx16
aurora_standard.chmmhastpoa_dx17
aurora_standard.chmmhastpoa_dx18
aurora_standard.chmmhastpoa_dx19
dx2
TableColumn
_1.encounters_cpt_codesecp_dx2
_1.precerts_cpt_codespcp_dx2
_1188.encounters_cpt_codesecp_dx2
_1188.precerts_cpt_codespcp_dx2
_1218.encounters_cpt_codesecp_dx2
_1218.precerts_cpt_codespcp_dx2
_1548.encounters_cpt_codesecp_dx2
_1548.precerts_cpt_codespcp_dx2
_435.encounters_cpt_codesecp_dx2
_435.precerts_cpt_codespcp_dx2
_436.encounters_cpt_codesecp_dx2
_436.precerts_cpt_codespcp_dx2
_436_archive_testing.encounters_cpt_codesecp_dx2
_436_archive_testing.precerts_cpt_codespcp_dx2
_437.encounters_cpt_codesecp_dx2
_437.precerts_cpt_codespcp_dx2
_8.encounters_cpt_codesecp_dx2
_8.precerts_cpt_codespcp_dx2
_81.encounters_cpt_codesecp_dx2
_81.precerts_cpt_codespcp_dx2
_999.encounters_cpt_codesecp_dx2
_999.precerts_cpt_codespcp_dx2
aurora_standard.chmadmpradmit_dx2
aurora_standard.chmcostrcreason_dx2
aurora_standard.chmhid4creason_dx2
aurora_standard.chmmhastother_dx2
aurora_standard.chmmhastother_dx20
aurora_standard.chmmhastother_dx21
aurora_standard.chmmhastother_dx22
aurora_standard.chmmhastother_dx23
aurora_standard.chmmhastother_dx24
aurora_standard.chmmhastother_dx25
aurora_standard.chmmhastother_dx26
aurora_standard.chmmhastother_dx27
aurora_standard.chmmhastother_dx28
aurora_standard.chmmhastother_dx29
aurora_standard.chmmhastpoa_dx2
aurora_standard.chmmhastpoa_dx20
aurora_standard.chmmhastpoa_dx21
aurora_standard.chmmhastpoa_dx22
aurora_standard.chmmhastpoa_dx23
aurora_standard.chmmhastpoa_dx24
aurora_standard.chmmhastpoa_dx25
aurora_standard.chmmhastpoa_dx26
aurora_standard.chmmhastpoa_dx27
aurora_standard.chmmhastpoa_dx28
aurora_standard.chmmhastpoa_dx29
dx3
TableColumn
_1.encounters_cpt_codesecp_dx3
_1.precerts_cpt_codespcp_dx3
_1188.encounters_cpt_codesecp_dx3
_1188.precerts_cpt_codespcp_dx3
_1218.encounters_cpt_codesecp_dx3
_1218.precerts_cpt_codespcp_dx3
_1548.encounters_cpt_codesecp_dx3
_1548.precerts_cpt_codespcp_dx3
_435.encounters_cpt_codesecp_dx3
_435.precerts_cpt_codespcp_dx3
_436.encounters_cpt_codesecp_dx3
_436.precerts_cpt_codespcp_dx3
_436_archive_testing.encounters_cpt_codesecp_dx3
_436_archive_testing.precerts_cpt_codespcp_dx3
_437.encounters_cpt_codesecp_dx3
_437.precerts_cpt_codespcp_dx3
_8.encounters_cpt_codesecp_dx3
_8.precerts_cpt_codespcp_dx3
_81.encounters_cpt_codesecp_dx3
_81.precerts_cpt_codespcp_dx3
_999.encounters_cpt_codesecp_dx3
_999.precerts_cpt_codespcp_dx3
aurora_standard.chmadmpradmit_dx3
aurora_standard.chmcostrcreason_dx3
aurora_standard.chmhid4creason_dx3
aurora_standard.chmmhastother_dx3
aurora_standard.chmmhastpoa_dx3
dx4
TableColumn
_1.encounters_cpt_codesecp_dx4
_1.precerts_cpt_codespcp_dx4
_1188.encounters_cpt_codesecp_dx4
_1188.precerts_cpt_codespcp_dx4
_1218.encounters_cpt_codesecp_dx4
_1218.precerts_cpt_codespcp_dx4
_1548.encounters_cpt_codesecp_dx4
_1548.precerts_cpt_codespcp_dx4
_435.encounters_cpt_codesecp_dx4
_435.precerts_cpt_codespcp_dx4
_436.encounters_cpt_codesecp_dx4
_436.precerts_cpt_codespcp_dx4
_436_archive_testing.encounters_cpt_codesecp_dx4
_436_archive_testing.precerts_cpt_codespcp_dx4
_437.encounters_cpt_codesecp_dx4
_437.precerts_cpt_codespcp_dx4
_8.encounters_cpt_codesecp_dx4
_8.precerts_cpt_codespcp_dx4
_81.encounters_cpt_codesecp_dx4
_81.precerts_cpt_codespcp_dx4
_999.encounters_cpt_codesecp_dx4
_999.precerts_cpt_codespcp_dx4
aurora_standard.chmmhastother_dx4
aurora_standard.chmmhastpoa_dx4
dx5
TableColumn
_1.encounters_cpt_codesecp_dx5
_1188.encounters_cpt_codesecp_dx5
_1218.encounters_cpt_codesecp_dx5
_1548.encounters_cpt_codesecp_dx5
_435.encounters_cpt_codesecp_dx5
_436.encounters_cpt_codesecp_dx5
_436_archive_testing.encounters_cpt_codesecp_dx5
_437.encounters_cpt_codesecp_dx5
_8.encounters_cpt_codesecp_dx5
_81.encounters_cpt_codesecp_dx5
_999.encounters_cpt_codesecp_dx5
aurora_standard.chmmhastother_dx5
aurora_standard.chmmhastpoa_dx5
dx6
TableColumn
_1.encounters_cpt_codesecp_dx6
_1188.encounters_cpt_codesecp_dx6
_1218.encounters_cpt_codesecp_dx6
_1548.encounters_cpt_codesecp_dx6
_435.encounters_cpt_codesecp_dx6
_436.encounters_cpt_codesecp_dx6
_436_archive_testing.encounters_cpt_codesecp_dx6
_437.encounters_cpt_codesecp_dx6
_8.encounters_cpt_codesecp_dx6
_81.encounters_cpt_codesecp_dx6
_999.encounters_cpt_codesecp_dx6
aurora_standard.chmmhastother_dx6
aurora_standard.chmmhastpoa_dx6
dx7
TableColumn
_1.encounters_cpt_codesecp_dx7
_1188.encounters_cpt_codesecp_dx7
_1218.encounters_cpt_codesecp_dx7
_1548.encounters_cpt_codesecp_dx7
_435.encounters_cpt_codesecp_dx7
_436.encounters_cpt_codesecp_dx7
_436_archive_testing.encounters_cpt_codesecp_dx7
_437.encounters_cpt_codesecp_dx7
_8.encounters_cpt_codesecp_dx7
_81.encounters_cpt_codesecp_dx7
_999.encounters_cpt_codesecp_dx7
aurora_standard.chmmhastother_dx7
aurora_standard.chmmhastpoa_dx7
dx8
TableColumn
_1.encounters_cpt_codesecp_dx8
_1188.encounters_cpt_codesecp_dx8
_1218.encounters_cpt_codesecp_dx8
_1548.encounters_cpt_codesecp_dx8
_435.encounters_cpt_codesecp_dx8
_436.encounters_cpt_codesecp_dx8
_436_archive_testing.encounters_cpt_codesecp_dx8
_437.encounters_cpt_codesecp_dx8
_8.encounters_cpt_codesecp_dx8
_81.encounters_cpt_codesecp_dx8
_999.encounters_cpt_codesecp_dx8
aurora_standard.chmmhastother_dx8
aurora_standard.chmmhastpoa_dx8
dx9
TableColumn
_1.encounters_cpt_codesecp_dx9
_1188.encounters_cpt_codesecp_dx9
_1218.encounters_cpt_codesecp_dx9
_1548.encounters_cpt_codesecp_dx9
_435.encounters_cpt_codesecp_dx9
_436.encounters_cpt_codesecp_dx9
_436_archive_testing.encounters_cpt_codesecp_dx9
_437.encounters_cpt_codesecp_dx9
_8.encounters_cpt_codesecp_dx9
_81.encounters_cpt_codesecp_dx9
_999.encounters_cpt_codesecp_dx9
aurora_standard.chmmhastother_dx9
aurora_standard.chmmhastpoa_dx9
poa
TableColumn
_1.encounters_ub04enc_ub04_72_a_poa
_1.encounters_ub04enc_ub04_72_b_poa
_1.encounters_ub04enc_ub04_72_c_poa
_1188.encounters_ub04enc_ub04_72_a_poa
_1188.encounters_ub04enc_ub04_72_b_poa
_1188.encounters_ub04enc_ub04_72_c_poa
_1218.encounters_ub04enc_ub04_72_a_poa
_1218.encounters_ub04enc_ub04_72_b_poa
_1218.encounters_ub04enc_ub04_72_c_poa
_1548.encounters_ub04enc_ub04_72_a_poa
_1548.encounters_ub04enc_ub04_72_b_poa
_1548.encounters_ub04enc_ub04_72_c_poa
_435.encounters_ub04enc_ub04_72_a_poa
_435.encounters_ub04enc_ub04_72_b_poa
_435.encounters_ub04enc_ub04_72_c_poa
_436.encounters_ub04enc_ub04_72_a_poa
_436.encounters_ub04enc_ub04_72_b_poa
_436.encounters_ub04enc_ub04_72_c_poa
_436_archive_testing.encounters_ub04enc_ub04_72_a_poa
_436_archive_testing.encounters_ub04enc_ub04_72_b_poa
_436_archive_testing.encounters_ub04enc_ub04_72_c_poa
_437.encounters_ub04enc_ub04_72_a_poa
_437.encounters_ub04enc_ub04_72_b_poa
_437.encounters_ub04enc_ub04_72_c_poa
_8.encounters_ub04enc_ub04_72_a_poa
_8.encounters_ub04enc_ub04_72_b_poa
_8.encounters_ub04enc_ub04_72_c_poa
_81.encounters_ub04enc_ub04_72_a_poa
_81.encounters_ub04enc_ub04_72_b_poa
_81.encounters_ub04enc_ub04_72_c_poa
_999.encounters_ub04enc_ub04_72_a_poa
_999.encounters_ub04enc_ub04_72_b_poa
_999.encounters_ub04enc_ub04_72_c_poa
aurora_standard.abshl7di9_poa
aurora_standard.chmazstdprin_poa
aurora_standard.chmazstde_poa1
aurora_standard.chmazstde_poa2
aurora_standard.chmazstde_poa3
aurora_standard.chmazstde_poa4
aurora_standard.chmazstde_poa5
aurora_standard.chmazstde_poa6
aurora_standard.chmazstiprin_poa
aurora_standard.chmazstie_poa1
aurora_standard.chmazstie_poa2
aurora_standard.chmazstie_poa3
aurora_standard.chmazstie_poa4
aurora_standard.chmazstie_poa5
aurora_standard.chmazstie_poa6
aurora_standard.chmazstoprin_poa
aurora_standard.chmazstoe_poa1
aurora_standard.chmazstoe_poa2
aurora_standard.chmazstoe_poa3
aurora_standard.chmazstoe_poa4
aurora_standard.chmazstoe_poa5
aurora_standard.chmazstoe_poa6
aurora_standard.chmlastrpri_poa
aurora_standard.chmlastre_poa1
aurora_standard.chmlastre_poa2
aurora_standard.chmlastre_poa3
aurora_standard.chmlastre_poa4
aurora_standard.chmlastre_poa5
aurora_standard.chmmhastadm_poa
aurora_standard.chmokipdprin_poa
aurora_standard.chmtxstrpri_poa
aurora_standard.chmtxstre_poa1
aurora_standard.chmtxstre_poa2
aurora_standard.chmtxstre_poa3
aurora_standard.chmtxstre_poa4
aurora_standard.chmtxstre_poa5
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
filler
TableColumn
aurora_standard.chlmdssds_filler
aurora_standard.chlswbddcnt_filler
aurora_standard.chltrnsdcnt_filler
aurora_standard.chltrnsds_filler
aurora_standard.chmhaapypy_filler
aurora_standard.drg_workw_filler
aurora_standard.workdescw_filler