Why wont the data just go into Biotics as it is?
A. The main reasons are invalid values or characters in controlled-value fields and mismatched data types. The Oracle database enforces controlled-value fields much more rigorously than in BCD. In addition, some fields that will accept only specific types of data, such as numbers or complete dates. For example, the formatted date fields in Biotics require a year, month, and day. If you have a partial date, the field will be null in Biotics. For example, EORANKDATE needs to be qced to make sure it contains a complete date,* whereas LASTOBSDATE and FIRSTOBSDATE do not require a complete date. *For more information on EORANKDATE, see below under question about other critical QCs.
