aurora_standard.hl7pidad

Field Type Null Default Key Extra Comment
seg_pid varchar(3) YES
set_id varchar(4) YES
pat_ext_id varchar(20) YES
pat_int_id varchar(20) YES
alt_pat_id varchar(20) YES
pat_name varchar(48) YES
mom_maiden_nm varchar(48) YES
date_time_birth varchar(26) YES
sex varchar(1) YES
pat_alias varchar(48) YES
race varchar(1) YES
pat_addr varchar(106) YES
county_code varchar(4) YES
hm_phone_num varchar(40) YES
wk_phone_num varchar(40) YES
prim_language varchar(60) YES
marital_stat varchar(1) YES
religion varchar(3) YES
pat_acct_num varchar(20) YES
pat_ssn varchar(16) YES
mother_id varchar(20) YES
ethnic_group varchar(3) YES
birth_place varchar(60) YES
citizenship varchar(4) YES
nationality varchar(20) YES
pat_death_d_t varchar(26) YES
pat_death_ind varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
set_id
TableColumn
HSPI_CURES2015_B1.invoice_batchesrule_set_id
HSPI_Central_Hospital.invoice_batchesrule_set_id
HSPI_Dewitt.invoice_batchesrule_set_id
HSPI_Fulton.invoice_batchesrule_set_id
HSPI_Inferno.invoice_batchesrule_set_id
HSPI_MU2015_E1.invoice_batchesrule_set_id
HSPI_MU2015_G2.invoice_batchesrule_set_id
HSPI_MU2015_G9.invoice_batchesrule_set_id
HSPI_Sandbox.invoice_batchesrule_set_id
HSPI_Summit_General.invoice_batchesrule_set_id
HSPI_United_Physicians.invoice_batchesrule_set_id
MPI.invoice_batchesrule_set_id
aurora_standard.vault_icd9sorder_set_id
sex
TableColumn
HSPI_CURES2015_B1.patientsbirth_sex
HSPI_Central_Hospital.patientsbirth_sex
HSPI_Dewitt.patientsbirth_sex
HSPI_Fulton.patientsbirth_sex
HSPI_Inferno.patientsbirth_sex
HSPI_MU2015_E1.patientsbirth_sex
HSPI_MU2015_G2.patientsbirth_sex
HSPI_MU2015_G9.patientsbirth_sex
HSPI_Sandbox.patientsbirth_sex
HSPI_Summit_General.patientsbirth_sex
HSPI_United_Physicians.patientsbirth_sex
MPI.patientsbirth_sex
_1.chartschrt_sex
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1.cpoe_responsescpoe_res_sex
_1.encountersenc_sex
_1.encountersenc_ins1_insured_sex
_1.encountersenc_ins2_insured_sex
_1.encountersenc_ins3_insured_sex
_1.health_maintenancehm_sex
_1.hl7_accessionsacc_sex
_1.insurances_repositoryirep_ins_insured_sex
_1.non_patientsnpat_sex
_1.ordersord_sex
_1.patient_educationpe_sex
_1.patient_history_fieldsphf_sex
_1.patientspat_sex
_1.patientspat_birth_sex
_1.patientspat_ins1_insured_sex
_1.patientspat_ins2_insured_sex
_1.patientspat_ins3_insured_sex
_1.patients_demographics_snapshotspds_sex
_1.patients_demographics_snapshotspds_ins1_insured_sex
_1.patients_demographics_snapshotspds_ins2_insured_sex
_1.patients_demographics_snapshotspds_ins3_insured_sex
_1.patients_responsibility_estimatesprest_sex
_1.precertspre_sex
_1.precertspre_ins1_insured_sex
_1.precertspre_ins2_insured_sex
_1.radiology_ordersrad_sex
_1.radiology_resultsrad_res_sex
_1188.chartschrt_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1188.cpoe_responsescpoe_res_sex
_1188.encountersenc_sex
_1188.encountersenc_ins1_insured_sex
_1188.encountersenc_ins2_insured_sex
_1188.encountersenc_ins3_insured_sex
_1188.health_maintenancehm_sex
_1188.hl7_accessionsacc_sex
_1188.insurances_repositoryirep_ins_insured_sex
_1188.non_patientsnpat_sex
_1188.ordersord_sex
_1188.patient_educationpe_sex
_1188.patient_history_fieldsphf_sex
_1188.patientspat_sex
_1188.patientspat_birth_sex
_1188.patientspat_ins1_insured_sex
_1188.patientspat_ins2_insured_sex
_1188.patientspat_ins3_insured_sex
_1188.patients_demographics_snapshotspds_sex
_1188.patients_demographics_snapshotspds_ins1_insured_sex
_1188.patients_demographics_snapshotspds_ins2_insured_sex
_1188.patients_demographics_snapshotspds_ins3_insured_sex
_1188.patients_responsibility_estimatesprest_sex
_1188.precertspre_sex
_1188.precertspre_ins1_insured_sex
_1188.precertspre_ins2_insured_sex
_1188.radiology_ordersrad_sex
_1188.radiology_resultsrad_res_sex
_1218.chartschrt_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1218.cpoe_responsescpoe_res_sex
_1218.encountersenc_sex
_1218.encountersenc_ins1_insured_sex
_1218.encountersenc_ins2_insured_sex
_1218.encountersenc_ins3_insured_sex
_1218.health_maintenancehm_sex
_1218.hl7_accessionsacc_sex
_1218.insurances_repositoryirep_ins_insured_sex
_1218.non_patientsnpat_sex
_1218.ordersord_sex
_1218.patient_educationpe_sex
_1218.patient_history_fieldsphf_sex
_1218.patientspat_sex
_1218.patientspat_birth_sex
_1218.patientspat_ins1_insured_sex
_1218.patientspat_ins2_insured_sex
_1218.patientspat_ins3_insured_sex
_1218.patients_demographics_snapshotspds_sex
_1218.patients_demographics_snapshotspds_ins1_insured_sex
_1218.patients_demographics_snapshotspds_ins2_insured_sex
_1218.patients_demographics_snapshotspds_ins3_insured_sex
_1218.patients_responsibility_estimatesprest_sex
_1218.precertspre_sex
_1218.precertspre_ins1_insured_sex
_1218.precertspre_ins2_insured_sex
_1218.radiology_ordersrad_sex
_1218.radiology_resultsrad_res_sex
_1548.chartschrt_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_1548.cpoe_responsescpoe_res_sex
_1548.encountersenc_sex
_1548.encountersenc_ins1_insured_sex
_1548.encountersenc_ins2_insured_sex
_1548.encountersenc_ins3_insured_sex
_1548.health_maintenancehm_sex
_1548.hl7_accessionsacc_sex
_1548.insurances_repositoryirep_ins_insured_sex
_1548.non_patientsnpat_sex
_1548.ordersord_sex
_1548.patient_educationpe_sex
_1548.patient_history_fieldsphf_sex
_1548.patientspat_sex
_1548.patientspat_birth_sex
_1548.patientspat_ins1_insured_sex
_1548.patientspat_ins2_insured_sex
_1548.patientspat_ins3_insured_sex
_1548.patients_demographics_snapshotspds_sex
_1548.patients_demographics_snapshotspds_ins1_insured_sex
_1548.patients_demographics_snapshotspds_ins2_insured_sex
_1548.patients_demographics_snapshotspds_ins3_insured_sex
_1548.patients_responsibility_estimatesprest_sex
_1548.precertspre_sex
_1548.precertspre_ins1_insured_sex
_1548.precertspre_ins2_insured_sex
_1548.radiology_ordersrad_sex
_1548.radiology_resultsrad_res_sex
_435.chartschrt_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_435.cpoe_responsescpoe_res_sex
_435.encountersenc_sex
_435.encountersenc_ins1_insured_sex
_435.encountersenc_ins2_insured_sex
_435.encountersenc_ins3_insured_sex
_435.health_maintenancehm_sex
_435.hl7_accessionsacc_sex
_435.insurances_repositoryirep_ins_insured_sex
_435.non_patientsnpat_sex
_435.ordersord_sex
_435.patient_educationpe_sex
_435.patient_history_fieldsphf_sex
_435.patientspat_sex
_435.patientspat_birth_sex
_435.patientspat_ins1_insured_sex
_435.patientspat_ins2_insured_sex
_435.patientspat_ins3_insured_sex
_435.patients_demographics_snapshotspds_sex
_435.patients_demographics_snapshotspds_ins1_insured_sex
_435.patients_demographics_snapshotspds_ins2_insured_sex
_435.patients_demographics_snapshotspds_ins3_insured_sex
_435.patients_responsibility_estimatesprest_sex
_435.precertspre_sex
_435.precertspre_ins1_insured_sex
_435.precertspre_ins2_insured_sex
_435.radiology_ordersrad_sex
_435.radiology_resultsrad_res_sex
_436.chartschrt_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436.cpoe_responsescpoe_res_sex
_436.encountersenc_sex
_436.encountersenc_ins1_insured_sex
_436.encountersenc_ins2_insured_sex
_436.encountersenc_ins3_insured_sex
_436.health_maintenancehm_sex
_436.hl7_accessionsacc_sex
_436.insurances_repositoryirep_ins_insured_sex
_436.non_patientsnpat_sex
_436.ordersord_sex
_436.patient_educationpe_sex
_436.patient_history_fieldsphf_sex
_436.patientspat_sex
_436.patientspat_birth_sex
_436.patientspat_ins1_insured_sex
_436.patientspat_ins2_insured_sex
_436.patientspat_ins3_insured_sex
_436.patients_demographics_snapshotspds_sex
_436.patients_demographics_snapshotspds_ins1_insured_sex
_436.patients_demographics_snapshotspds_ins2_insured_sex
_436.patients_demographics_snapshotspds_ins3_insured_sex
_436.patients_responsibility_estimatesprest_sex
_436.precertspre_sex
_436.precertspre_ins1_insured_sex
_436.precertspre_ins2_insured_sex
_436.radiology_ordersrad_sex
_436.radiology_resultsrad_res_sex
_436_archive_testing.chartschrt_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_436_archive_testing.cpoe_responsescpoe_res_sex
_436_archive_testing.encountersenc_sex
_436_archive_testing.encountersenc_ins1_insured_sex
_436_archive_testing.encountersenc_ins2_insured_sex
_436_archive_testing.encountersenc_ins3_insured_sex
_436_archive_testing.health_maintenancehm_sex
_436_archive_testing.hl7_accessionsacc_sex
_436_archive_testing.insurances_repositoryirep_ins_insured_sex
_436_archive_testing.non_patientsnpat_sex
_436_archive_testing.ordersord_sex
_436_archive_testing.patient_educationpe_sex
_436_archive_testing.patient_history_fieldsphf_sex
_436_archive_testing.patientspat_sex
_436_archive_testing.patientspat_ins1_insured_sex
_436_archive_testing.patientspat_ins2_insured_sex
_436_archive_testing.patientspat_ins3_insured_sex
_436_archive_testing.patients_demographics_snapshotspds_sex
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_sex
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_sex
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_sex
_436_archive_testing.patients_responsibility_estimatesprest_sex
_436_archive_testing.precertspre_sex
_436_archive_testing.precertspre_ins1_insured_sex
_436_archive_testing.precertspre_ins2_insured_sex
_436_archive_testing.radiology_ordersrad_sex
_436_archive_testing.radiology_resultsrad_res_sex
_437.chartschrt_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_437.cpoe_responsescpoe_res_sex
_437.encountersenc_sex
_437.encountersenc_ins1_insured_sex
_437.encountersenc_ins2_insured_sex
_437.encountersenc_ins3_insured_sex
_437.health_maintenancehm_sex
_437.hl7_accessionsacc_sex
_437.insurances_repositoryirep_ins_insured_sex
_437.non_patientsnpat_sex
_437.ordersord_sex
_437.patient_educationpe_sex
_437.patient_history_fieldsphf_sex
_437.patientspat_sex
_437.patientspat_birth_sex
_437.patientspat_ins1_insured_sex
_437.patientspat_ins2_insured_sex
_437.patientspat_ins3_insured_sex
_437.patients_demographics_snapshotspds_sex
_437.patients_demographics_snapshotspds_ins1_insured_sex
_437.patients_demographics_snapshotspds_ins2_insured_sex
_437.patients_demographics_snapshotspds_ins3_insured_sex
_437.patients_responsibility_estimatesprest_sex
_437.precertspre_sex
_437.precertspre_ins1_insured_sex
_437.precertspre_ins2_insured_sex
_437.radiology_ordersrad_sex
_437.radiology_resultsrad_res_sex
_8.chartschrt_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_8.cpoe_responsescpoe_res_sex
_8.encountersenc_sex
_8.encountersenc_ins1_insured_sex
_8.encountersenc_ins2_insured_sex
_8.encountersenc_ins3_insured_sex
_8.health_maintenancehm_sex
_8.hl7_accessionsacc_sex
_8.insurances_repositoryirep_ins_insured_sex
_8.non_patientsnpat_sex
_8.ordersord_sex
_8.patient_educationpe_sex
_8.patient_history_fieldsphf_sex
_8.patientspat_sex
_8.patientspat_birth_sex
_8.patientspat_ins1_insured_sex
_8.patientspat_ins2_insured_sex
_8.patientspat_ins3_insured_sex
_8.patients_demographics_snapshotspds_sex
_8.patients_demographics_snapshotspds_ins1_insured_sex
_8.patients_demographics_snapshotspds_ins2_insured_sex
_8.patients_demographics_snapshotspds_ins3_insured_sex
_8.patients_responsibility_estimatesprest_sex
_8.precertspre_sex
_8.precertspre_ins1_insured_sex
_8.precertspre_ins2_insured_sex
_8.radiology_ordersrad_sex
_8.radiology_resultsrad_res_sex
_81.chartschrt_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_81.cpoe_responsescpoe_res_sex
_81.encountersenc_sex
_81.encountersenc_ins1_insured_sex
_81.encountersenc_ins2_insured_sex
_81.encountersenc_ins3_insured_sex
_81.health_maintenancehm_sex
_81.hl7_accessionsacc_sex
_81.insurances_repositoryirep_ins_insured_sex
_81.non_patientsnpat_sex
_81.ordersord_sex
_81.patient_educationpe_sex
_81.patient_history_fieldsphf_sex
_81.patientspat_sex
_81.patientspat_birth_sex
_81.patientspat_ins1_insured_sex
_81.patientspat_ins2_insured_sex
_81.patientspat_ins3_insured_sex
_81.patients_demographics_snapshotspds_sex
_81.patients_demographics_snapshotspds_ins1_insured_sex
_81.patients_demographics_snapshotspds_ins2_insured_sex
_81.patients_demographics_snapshotspds_ins3_insured_sex
_81.patients_responsibility_estimatesprest_sex
_81.precertspre_sex
_81.precertspre_ins1_insured_sex
_81.precertspre_ins2_insured_sex
_81.radiology_ordersrad_sex
_81.radiology_resultsrad_res_sex
_999.chartschrt_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
_999.cpoe_responsescpoe_res_sex
_999.encountersenc_sex
_999.encountersenc_ins1_insured_sex
_999.encountersenc_ins2_insured_sex
_999.encountersenc_ins3_insured_sex
_999.health_maintenancehm_sex
_999.hl7_accessionsacc_sex
_999.insurances_repositoryirep_ins_insured_sex
_999.non_patientsnpat_sex
_999.ordersord_sex
_999.patient_educationpe_sex
_999.patient_history_fieldsphf_sex
_999.patientspat_sex
_999.patientspat_birth_sex
_999.patientspat_ins1_insured_sex
_999.patientspat_ins2_insured_sex
_999.patientspat_ins3_insured_sex
_999.patients_demographics_snapshotspds_sex
_999.patients_demographics_snapshotspds_ins1_insured_sex
_999.patients_demographics_snapshotspds_ins2_insured_sex
_999.patients_demographics_snapshotspds_ins3_insured_sex
_999.patients_responsibility_estimatesprest_sex
_999.precertspre_sex
_999.precertspre_ins1_insured_sex
_999.precertspre_ins2_insured_sex
_999.radiology_ordersrad_sex
_999.radiology_resultsrad_res_sex
aurora_standard.abmmpii1_sex
aurora_standard.abmmpii2_sex
aurora_standard.abmmpii3_sex
aurora_standard.abmmpigu_sex
aurora_standard.abmvisgu_sex
aurora_standard.abmvisi1_sex
aurora_standard.abmvisi2_sex
aurora_standard.abmvisi3_sex
aurora_standard.bevispat_sex
aurora_standard.bevisbdpat_sex
aurora_standard.bevisbd2pat_sex
aurora_standard.bharp_sex
aurora_standard.bharg_sex
aurora_standard.bparp_sex
aurora_standard.bparg_sex
aurora_standard.bpar2p_sex
aurora_standard.bpar2g_sex
aurora_standard.bpmpip_sex
aurora_standard.bpmpi2p_sex
aurora_standard.bpmrp_sex
aurora_standard.bpmr2p_sex
aurora_standard.c7mpip_sex
aurora_standard.c7mpigu_sex
aurora_standard.c8dtlsp_sex
aurora_standard.c9mpip_sex
aurora_standard.chhl7in1ins_sex
aurora_standard.chmarbexpat_sex
aurora_standard.chmarsipat_sex
aurora_standard.chmarsiins1_sex
aurora_standard.chmarsiins2_sex
aurora_standard.chmarsiins3_sex
aurora_standard.chmazstdpat_sex
aurora_standard.chmazstipat_sex
aurora_standard.chmazstopat_sex
aurora_standard.chmbatexpat_sex
aurora_standard.chmcampipat_sex
aurora_standard.chmcampiins1_sex
aurora_standard.chmcampiins2_sex
aurora_standard.chmcampiins3_sex
aurora_standard.chmcmhedpat_sex
aurora_standard.chmexmpipat_sex
aurora_standard.chmexmpiins1_sex
aurora_standard.chmexmpiins2_sex
aurora_standard.chmexmpiins3_sex
aurora_standard.chmexvisins1_sex
aurora_standard.chmexvisins2_sex
aurora_standard.chmexvisins3_sex
aurora_standard.chmhcaphpat_sex
aurora_standard.chmhcapspat_sex
aurora_standard.chmhistpp_sex
aurora_standard.chmhstmrpat_sex
aurora_standard.chmhstrmpat_sex
aurora_standard.chmlastrpat_sex
aurora_standard.chmmhastpat_sex
aurora_standard.chmmrhdrupd_sex
aurora_standard.chmnrcexpat_sex
aurora_standard.chmokipdpat_sex
aurora_standard.chmokopdpat_sex
aurora_standard.chmpdemop_sex
aurora_standard.chmpdemoins1_sex
aurora_standard.chmpdemoins2_sex
aurora_standard.chmpdemoins3_sex
aurora_standard.chmradexpat_sex
aurora_standard.chmradexins1_sex
aurora_standard.chmradexins2_sex
aurora_standard.chmradexins3_sex
aurora_standard.chmtxstrpat_sex
aurora_standard.hl7gt1guar_sex
aurora_standard.hl7gt1adguar_sex
aurora_standard.hl7in1ins_sex
aurora_standard.hl7in1adins_sex
race
TableColumn
_1.chartschrt_race
_1.encountersenc_race
_1.orders_afpsoafp_race
_1.patientspat_race
_1.precertspre_race
_1188.chartschrt_race
_1188.encountersenc_race
_1188.orders_afpsoafp_race
_1188.patientspat_race
_1188.precertspre_race
_1218.chartschrt_race
_1218.encountersenc_race
_1218.orders_afpsoafp_race
_1218.patientspat_race
_1218.precertspre_race
_1548.chartschrt_race
_1548.encountersenc_race
_1548.orders_afpsoafp_race
_1548.patientspat_race
_1548.precertspre_race
_435.chartschrt_race
_435.encountersenc_race
_435.orders_afpsoafp_race
_435.patientspat_race
_435.precertspre_race
_436.chartschrt_race
_436.encountersenc_race
_436.orders_afpsoafp_race
_436.patientspat_race
_436.precertspre_race
_436_archive_testing.chartschrt_race
_436_archive_testing.encountersenc_race
_436_archive_testing.orders_afpsoafp_race
_436_archive_testing.patientspat_race
_436_archive_testing.precertspre_race
_437.chartschrt_race
_437.encountersenc_race
_437.orders_afpsoafp_race
_437.patientspat_race
_437.precertspre_race
_8.chartschrt_race
_8.encountersenc_race
_8.orders_afpsoafp_race
_8.patientspat_race
_8.precertspre_race
_81.chartschrt_race
_81.encountersenc_race
_81.orders_afpsoafp_race
_81.patientspat_race
_81.precertspre_race
_999.chartschrt_race
_999.encountersenc_race
_999.orders_afpsoafp_race
_999.patientspat_race
_999.precertspre_race
aurora_standard.bharp_race
aurora_standard.bharg_race
aurora_standard.bhguarg_race
aurora_standard.bhtguarg_race
aurora_standard.bparp_race
aurora_standard.bparg_race
aurora_standard.bpar2p_race
aurora_standard.bpar2g_race
aurora_standard.bpmpip_race
aurora_standard.bpmpi2p_race
aurora_standard.chmazstdpat_race
aurora_standard.chmazstipat_race
aurora_standard.chmazstopat_race
aurora_standard.chmhistpp_race
aurora_standard.chmlastrpat_race
aurora_standard.chmmhastpat_race
aurora_standard.chmokipdpat_race
aurora_standard.chmokopdpat_race
aurora_standard.chmtxstrpat_race
aurora_standard.hl7gt1guar_race
aurora_standard.tmpmrrptsex_race