aurora_standard.stygrupr

Field Type Null Default Key Extra Comment
group_code varchar(6) YES UNI
group_desc varchar(30) YES
vend_code varchar(6) YES
pay_to varchar(6) YES
active_flag varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
group_code
TableColumn
_1.billing_codesbil_group_code
_1.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_1.ledgerled_group_code
_1.pre_services_adjust_codesprestsac_group_code
_1188.billing_codesbil_group_code
_1188.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_1188.ledgerled_group_code
_1188.pre_services_adjust_codesprestsac_group_code
_1218.billing_codesbil_group_code
_1218.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_1218.ledgerled_group_code
_1218.pre_services_adjust_codesprestsac_group_code
_1548.billing_codesbil_group_code
_1548.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_1548.ledgerled_group_code
_1548.pre_services_adjust_codesprestsac_group_code
_435.billing_codesbil_group_code
_435.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_435.ledgerled_group_code
_435.pre_services_adjust_codesprestsac_group_code
_436.billing_codesbil_group_code
_436.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_436.ledgerled_group_code
_436.pre_services_adjust_codesprestsac_group_code
_436_archive_testing.billing_codesbil_group_code
_436_archive_testing.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_436_archive_testing.ledgerled_group_code
_436_archive_testing.pre_services_adjust_codesprestsac_group_code
_437.billing_codesbil_group_code
_437.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_437.ledgerled_group_code
_437.pre_services_adjust_codesprestsac_group_code
_8.billing_codesbil_group_code
_8.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_8.ledgerled_group_code
_8.pre_services_adjust_codesprestsac_group_code
_81.billing_codesbil_group_code
_81.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_81.ledgerled_group_code
_81.pre_services_adjust_codesprestsac_group_code
_999.billing_codesbil_group_code
_999.encounters_payments_edi_logs_cpt_codes_adjust_codesepelccac_group_code
_999.ledgerled_group_code
_999.pre_services_adjust_codesprestsac_group_code
aurora_standard.chpinsrctarget_group_code
aurora_standard.stgwhseddept_group_code
aurora_standard.tmpbiggdfin_group_code
group_desc
TableColumn
aurora_standard.chmmcgrccare_group_desc
aurora_standard.chnchrscsub_group_desc
aurora_standard.stgwhseddept_group_desc
aurora_standard.tmpbiggdfin_group_desc
pay_to
TableColumn
aurora_standard.stpvendrdflt_pay_to
vend_code
TableColumn
aurora_standard.vndxrefold_vend_code
aurora_standard.vndxrefnew_vend_code