aurora_standard.chmarsta

Field Type Null Default Key Extra Comment
rec_type char(2) YES
rec_seq_no char(2) YES
visit_no char(20) YES MUL
rev1 char(4) YES
hcpcs1 char(5) YES
mod1_1 char(2) YES
mod2_1 char(2) YES
units1 char(7) YES
amt1 char(10) YES
filler char(26) YES
rev2 char(4) YES
hcpcs2 char(5) YES
mod1_2 char(2) YES
mod2_2 char(2) YES
units2 char(7) YES
amt2 char(10) YES
filler1 char(26) YES
rev3 char(4) YES
hcpcs3 char(5) YES
mod1_3 char(2) YES
mod2_3 char(2) YES
units3 char(7) YES
amt3 char(10) YES
filler2 char(54) YES

References

Local Column References
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.chltrnsds_filler1
aurora_standard.chmhaapypy_filler
aurora_standard.drg_workw_filler
aurora_standard.workdescw_filler
amt1
TableColumn
aurora_standard.chmlastrval_amt1
aurora_standard.chmtxstrval_amt1
amt2
TableColumn
aurora_standard.chmlastrval_amt2
aurora_standard.chmtxstrval_amt2
amt3
TableColumn
aurora_standard.chmlastrval_amt3
aurora_standard.chmtxstrval_amt3