Skip to main content
Skip table of contents

FitnessCode (ver20.11.0)

Descriptive information about a level of fitness (e.g. High Fitness, Healthy, Needs Improvement).

Column Name

Initial Version

Data Type


Code20.11.0Varchar(10)Simple code for the fitness level (typically 'HFZ' = High Fitness, H = 'Healthy', NI = 'Needs Improvement'). Required.
Color20.11.0Number(3)PTP Standard color code for this fitness level (e.g. 1 = Red, 3 = Yellow, 5 = Green). Required.




An optional area to describe any information about this item.

FitnessScaleDefinitionID20.11.0Number(16)Foreign Key to the FitnessScaleDefinition table. Indexed. Required.




Unique identifier for this table. Indexed. Required.

ImportCode20.11.0Varchar(20)A code used to maintain the test hierarchy during import using Data Import Manager.
SortOrder20.11.0Number(10)Sorting position. Required.
WhenCreated20.11.0TIMESTAMP(6)The date and time the record was created. Defaults to system date. Required.
WhenModified20.11.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date. Required.
WhoCreated20.11.0VARCHAR2(100 CHAR)The name of the person who created the record. Defaults to user. Required.
WhoModifed20.11.0VARCHAR2(100 CHAR)The name of the person who modified the record. Defaults to the user. Required.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.