aurora_standard.stypddre

Field Type Null Default Key Extra Comment
doc_no bigint(20) unsigned NO PRI auto_increment
company_name varchar(16) YES
entry_desc varchar(10) YES
dfi_immed int(11) YES
svc_class smallint(6) YES
batch_no int(11) YES
batch_date date YES
create_date date YES
file_id varchar(1) YES
used varchar(1) YES
adjusted varchar(1) YES

References

Local Column References
used
TableColumn
HSPI_CURES2015_B1.cbos_inventory_logamount_used
HSPI_Central_Hospital.cbos_inventory_logamount_used
HSPI_Dewitt.cbos_inventory_logamount_used
HSPI_Fulton.cbos_inventory_logamount_used
HSPI_Inferno.cbos_inventory_logamount_used
HSPI_MU2015_E1.cbos_inventory_logamount_used
HSPI_MU2015_G2.cbos_inventory_logamount_used
HSPI_MU2015_G9.cbos_inventory_logamount_used
HSPI_Sandbox.cbos_inventory_logamount_used
HSPI_Summit_General.cbos_inventory_logamount_used
HSPI_United_Physicians.cbos_inventory_logamount_used
MPI.cbos_inventory_logamount_used
aurora_standard.chmbenedi_lifetm_used
aurora_standard.chmbenedo_lifetm_used
aurora_standard.chmibendi_max_used
aurora_standard.chmibendr_max_used
aurora_standard.chmibendo_max_used
aurora_standard.chmmhasticu_used
aurora_standard.chmmhastccu_used
aurora_standard.chrdrugclast_used
aurora_standard.chrschdrlast_used
aurora_standard.jkyemppdaccr_used
aurora_standard.styemplrvac_used
aurora_standard.styemplrsick_used
aurora_standard.styemppdaccr_used
aurora_standard.styptoadaccr_used
aurora_standard.summtotshrs_used
aurora_standard.summtotsbuyback_used
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
create_date
TableColumn
_1.configured_encountersconfenc_create_date
_1548.configured_encountersconfenc_create_date
_435.configured_encountersconfenc_create_date
_436.configured_encountersconfenc_create_date
_436_archive_testing.configured_encountersconfenc_create_date
_437.configured_encountersconfenc_create_date
_8.configured_encountersconfenc_create_date
_999.configured_encountersconfenc_create_date
doc_no
TableColumn
aurora_standard.audpadjdpy_doc_no
aurora_standard.chmgltrcar_doc_no
aurora_standard.chmgltrcrm_doc_no
aurora_standard.chmgltrcip_doc_no
aurora_standard.chmgltrcop_doc_no
aurora_standard.chmgltrcr3_doc_no
aurora_standard.chmgltrcr4_doc_no
aurora_standard.chmgltrccr_doc_no
aurora_standard.chmgltrcaj_doc_no
aurora_standard.chmgltrcnr_doc_no
aurora_standard.chmgltrcnc_doc_no
aurora_standard.chmgltrcfc_doc_no
aurora_standard.chmpadjdpy_doc_no
aurora_standard.chmrefndcheck_doc_no
aurora_standard.discountsinv_doc_no
aurora_standard.odhpayddpy_doc_no
aurora_standard.odhpayidpy_doc_no
aurora_standard.odhpayodpy_doc_no
aurora_standard.odhpayrepy_doc_no
aurora_standard.stfcntrcfa_doc_no
aurora_standard.stgcntrcgenjrn_doc_no
aurora_standard.stgcntrcstdent_doc_no
aurora_standard.sticstvrrec_doc_no
aurora_standard.stoinvceinv_doc_no
aurora_standard.stoordreorig_doc_no
aurora_standard.stoordreinv_doc_no
aurora_standard.stoshipdinv_doc_no
aurora_standard.stoshipdpo_doc_no
aurora_standard.stpactvdinv_doc_no
aurora_standard.stpactvvinv_doc_no
aurora_standard.stpcashdinv_doc_no
aurora_standard.stpcntrcap_doc_no
aurora_standard.stpcntrccd_doc_no
aurora_standard.stpvoidrchk_doc_no
aurora_standard.stractvdinv_doc_no
aurora_standard.stractvvinv_doc_no
aurora_standard.strcashdinv_doc_no
aurora_standard.strcntrcar_doc_no
aurora_standard.strcntrccr_doc_no
aurora_standard.stucntrcreq_doc_no
aurora_standard.stucntrcpo_doc_no
aurora_standard.stucntrcrec_doc_no
aurora_standard.stucntrcinv_doc_no
aurora_standard.stucntrcret_doc_no
aurora_standard.stuinvcdinv_doc_no
aurora_standard.stuinvcdpo_doc_no
aurora_standard.stuinvceinv_doc_no
aurora_standard.stuinvcepo_doc_no
aurora_standard.stuordrdorder_doc_no
aurora_standard.stuordreorig_doc_no
aurora_standard.stuordreorder_doc_no
aurora_standard.stuprcheinv_doc_no
aurora_standard.sturectdrec_doc_no
aurora_standard.sturectdpo_doc_no
aurora_standard.sturecterec_doc_no
aurora_standard.sturectepo_doc_no
aurora_standard.sturqstdpo_doc_no
aurora_standard.sturqstdref_doc_no
aurora_standard.sturtrndret_doc_no
aurora_standard.sturtrndpo_doc_no
aurora_standard.sturtrndrec_doc_no
aurora_standard.sturtrndinv_doc_no
aurora_standard.sturtrneret_doc_no
aurora_standard.stxmtaxdinv_doc_no
aurora_standard.stxtaxldinv_doc_no
aurora_standard.stycdeddpy_doc_no
aurora_standard.stycincdpy_doc_no
aurora_standard.stycntrcpy_doc_no
aurora_standard.stypayarpy_doc_no
aurora_standard.stypddrdpy_doc_no
aurora_standard.styvoidepay_doc_no