FDA
The following table shows FDA attributes.
| Attribute | Description |
|---|---|
| FDA ID | The unique identifier for the CAT_FDA table. |
| Replacement ID | The unique identifier of the replacement entry whenever the entry is marked for deletion as a 'Duplicate.' |
| FDA Product Class | The FDA Product Class i.e., 1, 2, Not Classified etc. |
| FDA Product Code | The FDA Product Code i.e., HQR, DGO etc. |
| FDA Product Code Name | The Product Code Name i.e., Ige, Peroxidase, Antigen, Antiserum, Control etc. |
| Create Date | The date when an entry was first created. |
| Last Modified Date | The date when last modification to the entry was made. |
| To Be Deleted | This indicates whether or not a record is marked for deletion (i.e. Y or N). |
| To Be Deleted On | The date when the record will be deleted. |
| Delete Reason | The reason why the entry is marked for deletion (i.e. values are Duplicate or Inaccurate). |
| Is Private? | Yes = Private entry; No = Original Technopedia entry |
| Private Flag | 0 = Not Modified (i.e. original Technopedia entry); 1 = Modified Technopedia object; 2 = Proprietary object (those that have negative IDs). |
| Private Type | PRIVATE_TYPE = NULL if PRIVATE_FLAG = 0,PRIVATE_TYPE = Modified Technopedia entry if PRIVATE_FLAG = 1,PRIVATE_TYPE = Proprietary entry if PRIVATE_FLAG = 2. |