FitnessCode (ver20.11.0)
Descriptive information about a level of fitness (e.g. High Fitness, Healthy, Needs Improvement).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Code | 20.11.0 | Varchar(10) | Simple code for the fitness level (typically 'HFZ' = High Fitness, H = 'Healthy', NI = 'Needs Improvement'). Required. |
| Color | 20.11.0 | Number(3) | PTP Standard color code for this fitness level (e.g. 1 = Red, 3 = Yellow, 5 = Green). Required. |
Description | 20.11.0 | Varchar(4000) | An optional area to describe any information about this item. |
| FitnessScaleDefinitionID | 20.11.0 | Number(16) | Foreign Key to the FitnessScaleDefinition table. Indexed. Required. |
ID | 20.11.0 | Number(16) | Unique identifier for this table. Indexed. Required. |
| ImportCode | 20.11.0 | Varchar(20) | A code used to maintain the test hierarchy during import using Data Import Manager. |
| SortOrder | 20.11.0 | Number(10) | Sorting position. Required. |
| WhenCreated | 20.11.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 20.11.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 20.11.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
| WhoModifed | 20.11.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |