FitnessScaleDefinition (ver20.11.0)
Definitional information describing Fitness Testing metrics.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Description | 20.11.0 | Varchar(4000) | An optional area to describe any information about this item. |
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 |
| InvertedScoring | 20.11.0 | Number(1) | Flag to determine whether: 0 = higher scores are better (e.g. Curl-Ups), or 1 = lower scores are better (e.g. One-Mile Run). Required. |
| Locked | 20.11.0 | Number(1) | 0 = Unlocked, 1 = Locked (i.e. cannot be updated using Data Import Manager). Required. Default 0. |
Name | 20.11.0 | Varchar(36) | Name provided for this fitness event, such as Curl-Ups, One-Mile Run, etc. Required. |
UnitsID | 20.11.0 | Number(16) | Foreign Key to the CodeSet table values with the CodeType='Test Units'. Indexed. 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(305 CHAR) | The name of the person who created the record. Defaults to user. Required. |
| WhoModified | 20.11.0 | VARCHAR2(305 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |