aurora_standard.chmutahr

Field Type Null Default Key Extra Comment
visit_no char(9) YES MUL
rec_type char(1) YES
filler char(31) YES
rev1 char(3) YES
units1 char(3) YES
amt1 char(8) YES
filler2 char(24) YES
filler3 char(31) YES
rev2 char(3) YES
units2 char(3) YES
amt2 char(8) YES
filler4 char(55) YES
rev3 char(3) YES
units3 char(3) YES
amt3 char(8) YES
filler5 char(55) YES
rev4 char(3) YES
units4 char(3) YES
amt4 char(8) YES
filler6 char(55) YES
rev5 char(3) YES
units5 char(3) YES
amt5 char(8) YES
filler7 char(55) YES
rev6 char(3) YES
units6 char(3) YES
amt6 char(8) YES
filler8 char(55) YES
rev7 char(3) YES
units7 char(3) YES
amt7 char(8) YES
filler9 char(55) YES
rev8 char(3) YES
units8 char(3) YES
amt8 char(8) YES
filler10 char(55) YES
rev9 char(3) YES
units9 char(3) YES
amt9 char(8) YES
filler11 char(55) YES
rev10 char(3) YES
units10 char(3) YES
amt10 char(8) YES
filler12 char(55) YES
rev11 char(3) YES
units11 char(3) YES
amt11 char(8) YES
filler13 char(55) YES
rev12 char(3) YES
units12 char(3) YES
amt12 char(8) YES
filler14 char(55) YES
rev13 char(3) YES
units13 char(3) YES
amt13 char(8) YES
filler15 char(55) YES
rev14 char(3) YES
units14 char(3) YES
amt14 char(8) YES
filler16 char(55) YES
rev15 char(3) YES
units15 char(3) YES
amt15 char(8) YES
filler17 char(55) YES
filler18 char(52) 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.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
amt4
TableColumn
aurora_standard.chmlastrval_amt4
aurora_standard.chmtxstrval_amt4
amt5
TableColumn
aurora_standard.chmlastrval_amt5
aurora_standard.chmtxstrval_amt5