specs/models/M_TABLE_RECORD
Table Record
A Table Record, sometimes called a table row, represents a single object in a table. This object can be anything, but is constrained in that its properties correspond with the fields for this table (see Table Fields for details). Table records correspond with the database concept of a record.
Fields
Because table fields are generated by the user, tables records can have essentially any set of properties a user wants. The only exception is that every record must have an ID field (see Table Fields for details).
| Name | Description |
|---|---|
| Unique ID | A unique text ID for the table record, determined when it is initially created |
| Fields | All possible fields that can be edited for the record, determined by the active Table Fields within the Table |
| Deletion Status | A boolean that determines whether the record is active or deleted |
| Date Created | When the record was created |
| Date Updated | When the record was last updated |
Usage
- Users can add a new record by clicking the Create Record button on the Table Editor page (see Table Editor doc for details). When creating a record, the ID field is required and must be unique. Other fields are optional, but must be of the specified type if included.
- Users can remove a record by right clicking it on the Table Editor page (see Table Editor doc for details). Records deleted this way are permanently deleted and cannot be restored.
- Users can update existing records at any time from the Table Editor page (see Table Editor doc for details). Users can update any field except the ID field.
Tests
| ID | Name |
|---|---|
| QA-T92 | Table Management : 12 - Create table records from the table detail page |
| QA-T93 | Table Management : 13 - Sort table records by column in table view |
| QA-T94 | Table Management : 14 - Load multiple pages of table records in table view |
| QA-T133 | Record Placeholders : 07 - Delete Table Record |
| QA-T396 | Widgets - Digital History Record Widget |
| QA-T464 | Tables CSV Import : 01 - Import to table |
| QA-T466 | Tables CSV Import : 02 - Import feature data handling |
| QA-T467 | Tables CSV Import : 03 - Import from export |
| QA-T701 | Record Placeholders : 07 / Attempting to Delete a Loaded Table Record |
| QA-T716 | Table Management : 12 / Table Record Data Validation |
Requirements
| ID | Requirement |
|---|---|
| PLAT-8745 (295) | Verify that all required data has been entered and collected as prescribed by the step on completion. Disallow to progress on execution path if verification fails |
| PLAT-8756 (329) | Verify entered data is within configured limit and tolerances as configured in the Master Recipe or material workflow process step, and material model. Allow authorized override of this constraint based on configuration |
| PLAT-8757 (327) | Ability to route and disposition materials based on results of sample testing (off-line) and/or quality testing (in-line) Eg. hold, reject, scrap, or release materials based on sample result |
| PLAT-8759 (326) | Ability to route and disposition materials based on sampling plans Eg. hold or future hold materials until sample testing results are available |
| PLAT-8763 (406) | Ability to consume by pre-configured unit of measure (UoM) quantities such as weight, volume, etc. |
| PLAT-8811 (255) | Ability to verify that equipment (room, suite, area, etc.) meets routine cleaning requirements and prevent process start if cleaning status requirement is not met prior to start of processing. |
| PLAT-8839 (457) | Ability to define work order types to indicate special processing or release procedures. Ie normal, testing, prototype, validation, rush, etc. |
| PLAT-8841 (289) | Ability to exclude a work order from the dispatch list. |
| PLAT-8848 (900) | Equipment & cleaning log - The system must be able to create logs for registration of use, maintenance, calibration & cleaning of equipment and rooms. |
| PLAT-8851 (386) | All maintenance activities on equipment will be tracked and maintained as part of the equipment logs. i.e. calibration, PMs, repairs, etc. |
| PLAT-8862 (127) | Disallow completion of work until all required processing steps have been performed. i.e. disallow batch close when there are incomplete processing steps. |
| PLAT-8874 (848) | The ability to discern invalid or altered records. Ability to annotate data is changed. For GMP or critical data changes annotation can be configured as required. |
| PLAT-8876 (427) | Ability to track material attributes during production operations with associated capabilities to browse their history and their trending e.g. temperature, assays, etc. |
| PLAT-8884 (95) | Ability to view material information for a batch/lot in an App. Information includes all material as part of a material hierarchy, ie. cohort, plate, well, etc.) |
| PLAT-8909 (394) | Ability to track unloading of material from a load-carrier |
| PLAT-8911 (393) | Ability to track loading of material to a load-carrier and its location within the load carrier. Ie. material in a well, plate, flask, tank, tote, etc. |
| PLAT-8913 (392) | Ability to track materials handled in load-carriers. |
| PLAT-8921 (330) | Ability to automatically or manually log an exception when data is not within configured limits and tolerances. Disallow process completion until exceptions have been logged with configured e-signatures and any authorized overrides have been processed |
| PLAT-8925 (390) | Ability to track materials associations using the material tracking model. Ie. track physical material in tray location, trays in batches (Cohorts). |
| PLAT-8928 (388) | Ability to track material inventory and its physical location. |
| PLAT-8930 (385) | Ability to track equipment location for mobile equipment. The equipment log will include the equipment's location history or path. |
| PLAT-8934 (197) | Ability to collaborate on definition of models including ability to simultaneously author/change model definition for equipment, material and production. |