aurora_standard.chpcardd

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
card_code varchar(6) YES
card_desc varchar(15) YES
card_num varchar(16) YES
company_name varchar(20) YES
expiration_date date YES
international_no varchar(20) YES
authorization_code varchar(8) YES
contact_phone varchar(12) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
company_name
TableColumn
_1.client_contactsclicon_company_name
_1188.client_contactsclicon_company_name
_1218.client_contactsclicon_company_name
_1548.client_contactsclicon_company_name
_435.client_contactsclicon_company_name
_436.client_contactsclicon_company_name
_436_archive_testing.client_contactsclicon_company_name
_437.client_contactsclicon_company_name
_8.client_contactsclicon_company_name
_81.client_contactsclicon_company_name
_999.client_contactsclicon_company_name
expiration_date
TableColumn
_1.inventoryinv_expiration_date
_1.patients_immunizationspim_expiration_date
_1.patients_implantable_devicespid_expiration_date
_1188.inventoryinv_expiration_date
_1188.patients_immunizationspim_expiration_date
_1188.patients_implantable_devicespid_expiration_date
_1218.inventoryinv_expiration_date
_1218.patients_immunizationspim_expiration_date
_1218.patients_implantable_devicespid_expiration_date
_1548.inventoryinv_expiration_date
_1548.patients_immunizationspim_expiration_date
_1548.patients_implantable_devicespid_expiration_date
_435.inventoryinv_expiration_date
_435.patients_immunizationspim_expiration_date
_435.patients_implantable_devicespid_expiration_date
_436.inventoryinv_expiration_date
_436.patients_immunizationspim_expiration_date
_436.patients_implantable_devicespid_expiration_date
_436_archive_testing.inventoryinv_expiration_date
_436_archive_testing.patients_immunizationspim_expiration_date
_436_archive_testing.patients_implantable_devicespid_expiration_date
_437.inventoryinv_expiration_date
_437.patients_immunizationspim_expiration_date
_437.patients_implantable_devicespid_expiration_date
_8.inventoryinv_expiration_date
_8.patients_immunizationspim_expiration_date
_8.patients_implantable_devicespid_expiration_date
_81.inventoryinv_expiration_date
_81.patients_immunizationspim_expiration_date
_81.patients_implantable_devicespid_expiration_date
_999.inventoryinv_expiration_date
_999.patients_immunizationspim_expiration_date
_999.patients_implantable_devicespid_expiration_date
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code
contact_phone
TableColumn
aurora_standard.styoctccgov_entity_contact_phone