FDA

The following table shows FDA attributes.

FDA

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.