aurora_standard.chmarstac

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
rate1 char(9) YES
units1 char(4) YES
amt1 char(10) YES
filler char(15) YES
rev2 char(4) YES
rate2 char(9) YES
units2 char(4) YES
amt2 char(10) YES
filler1 char(15) YES
rev3 char(4) YES
rate3 char(9) YES
units3 char(4) YES
amt3 char(10) YES
filler2 char(15) YES
rev4 char(4) YES
rate4 char(9) YES
units4 char(4) YES
amt4 char(10) YES
filler3 char(184) 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
amt4
TableColumn
aurora_standard.chmlastrval_amt4
aurora_standard.chmtxstrval_amt4