aurora_standard.chmarstpq

Field Type Null Default Key Extra Comment
rec_type char(2) YES
rec_seq_no char(2) YES
visit_no char(20) YES MUL
pmt_src char(1) YES
filler char(4) YES
hlth_plan char(10) YES
insd_id char(19) YES
filler1 char(21) YES
grp_no char(17) YES
filler2 char(14) YES
last_name char(20) YES
first_name char(9) YES
mi char(1) YES
filler3 char(3) YES
rel_cde char(2) YES
emp_stat char(1) YES
filler4 char(215) YES

References

Local Column References
grp_no
TableColumn
aurora_standard.abmmpii1_grp_no
aurora_standard.abmmpii2_grp_no
aurora_standard.abmmpii3_grp_no
aurora_standard.abmvisi1_grp_no
aurora_standard.abmvisi2_grp_no
aurora_standard.abmvisi3_grp_no
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
last_name
TableColumn
aurora_standard.c7insur2p_last_name
aurora_standard.c7insur3p_last_name
aurora_standard.chm1500rpat_last_name
aurora_standard.chmcmhedpat_last_name
aurora_standard.chmstmtdg_last_name
first_name
TableColumn
aurora_standard.c7insur2p_first_name
aurora_standard.c7insur3p_first_name
aurora_standard.chm1500rpat_first_name
aurora_standard.chmcmhedpat_first_name
aurora_standard.chmstmtdg_first_name
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
mi
TableColumn
aurora_standard.chmarstippat_mi
aurora_standard.chmarstppat_mi
aurora_standard.chmarstphatt_mi
aurora_standard.chmarstphsur_mi
aurora_standard.chmarstphoth_mi
aurora_standard.chmarstphoth2_mi
aurora_standard.chmarstpoatt_mi
aurora_standard.chmarstposur_mi
aurora_standard.chmarstpooth_mi
aurora_standard.chmarstpooth2_mi
aurora_standard.chmlastrpat_mi
aurora_standard.chmlastradm_phy_mi
aurora_standard.chmlastrrnd_phy_mi
aurora_standard.chmlastrref_phy_mi
aurora_standard.chmlastratt_phy_mi
aurora_standard.chmlastrop_phy_mi
aurora_standard.chmlastroth_phy_mi
aurora_standard.chmlastrsub_mi
aurora_standard.chmtxstrpat_mi
aurora_standard.chmtxstratt_phy_mi
aurora_standard.chmtxstrop_phy_mi
aurora_standard.chmtxstrcons_phy_mi
aurora_standard.chmub04bf_76_mi
aurora_standard.chmub04bf_77_mi
aurora_standard.chmub04bf_78_mi
aurora_standard.chmub04bf_79_mi
aurora_standard.chmub04rf_08_mi
aurora_standard.chmub04rl_38_1_mi
aurora_standard.chmub92rl_12_mi
aurora_standard.chmub92rl_38_1_mi
aurora_standard.chmub92rl_82_2_mi
aurora_standard.chmub92rl_83_2a_mi
aurora_standard.chmub92rl_83_2b_mi
aurora_standard.tmpub04rf_08_mi
aurora_standard.tmpub04rl_38_1_mi
aurora_standard.tmpub04rf_76_mi
aurora_standard.tmpub04rf_77_mi
aurora_standard.tmpub04rf_78_mi
aurora_standard.tmpub04rf_79_mi