| No | Name | Domain | Dty | Len | Scale | Nulls | Foreign Key | Description |
|---|---|---|---|---|---|---|---|---|
| 1 | PLT_ATY_PK | _DPM_PK | I | 4 | N | DPM_AUXTYPES.DPM_PK | References a Primary Key in another table (Foreign Key) [Format 9999 Range 0 - 9999] | |
| 2 | PLT_ID | _DPM_PLATE_ID | I | 4 | N | 'ID' is the unique identifier for a Plate. 'ID' is stored in the DPM_PLATE table. [Format: Int Range: 0 - 99999] | ||
| 3 | PLT_OBJECTIVE | _DPM_DESC | C | 80 | Y | 'Objective' is the reason for running the current assay. 'Objective' is stored in the DPM_PLATE table. [Format: A80 Range: Free text] | ||
| 4 | PLT_START | _DPM_DATE | D | 7 | N | 'Date' is the timestamp for the start of the assay. 'Date' is stored in the DPM_PLATE table. [Format: DDMonYY HH12:MI Range: <= SYSDATE] | ||
| 5 | PLT_Y | _DPM_SEQ | I | 2 | N | 'DimY' is the number of wells in a plate in the Y dimension. 'DimY' is stored in the DPM_PLATE table. [Format: Int Range: 0 - 99] | ||
| 6 | PLT_X | _DPM_SEQ | I | 2 | N | 'DimX' is the number of wells in a plate in the X dimension. 'DimX' is stored in the DPM_PLATE table. [Format: Int Range: 0 - 99] | ||
| 7 | PLT_TEMPLATE | _DPM_TEMPLATE | C | 4 | Y | 'Template' is a name given to a plate design used in routine assays. To create a template simply assign a value to a plate. To run a routine assay, query on this field to retrieve a template. Then duplicate the template and change the header, compound and target data to fit the current assay. 'Template' is stored in the DPM_PLATE table. [Format: A4 Range: Free text] | ||
| 8 | PLT_TECH | _DPM_TECH | C | 4 | Y | 'Tech' is the ID for the technician running the assay. 'Tech' is stored in the DPM_PLATE table. [Format: A4 Range: Free Text | ||