aurora_standard.chmarstpt

Field Type Null Default Key Extra Comment
rec_type char(2) YES
rec_seq_no char(2) YES
visit_no char(20) YES MUL
ins_addr1 char(18) YES
ins_addr2 char(18) YES
ins_city char(15) YES
ins_state char(2) YES
ins_zip char(9) YES
emp_name char(24) YES
emp_addr char(18) YES
emp_city char(15) YES
emp_state char(2) YES
emp_zip char(9) YES
filler char(207) YES

References

Local Column References
emp_addr
TableColumn
aurora_standard.abmmpigu_emp_addr
aurora_standard.chmmcqudsp_emp_addr
emp_city
TableColumn
aurora_standard.abmmpigu_emp_city
aurora_standard.chmarsigu_emp_city
aurora_standard.chmarsipat_emp_city
aurora_standard.chmcampigu_emp_city
aurora_standard.chmcampipat_emp_city
aurora_standard.chmexmpigu_emp_city
aurora_standard.chmexmpipat_emp_city
aurora_standard.chmpdemop_emp_city
aurora_standard.chmpdemogu_emp_city
aurora_standard.chmradexpat_emp_city
aurora_standard.chmradexgu_emp_city
emp_zip
TableColumn
aurora_standard.abmmpigu_emp_zip
aurora_standard.chmarsigu_emp_zip
aurora_standard.chmarsipat_emp_zip
aurora_standard.chmcampigu_emp_zip
aurora_standard.chmcampipat_emp_zip
aurora_standard.chmexmpigu_emp_zip
aurora_standard.chmexmpipat_emp_zip
aurora_standard.chmpdemop_emp_zip
aurora_standard.chmpdemogu_emp_zip
aurora_standard.chmradexpat_emp_zip
aurora_standard.chmradexgu_emp_zip
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
emp_name
TableColumn
aurora_standard.chhl7in1ins_grp_emp_name
aurora_standard.chmarcnbfg_emp_name
aurora_standard.chmmcqudsp_emp_name
aurora_standard.hl7in1ins_grp_emp_name
aurora_standard.hl7in1adins_grp_emp_name
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