Skip to main content
Skip table of contents

FitnessScaleDefinition (ver20.11.0)

Definitional information describing Fitness Testing metrics.

Column NameInitial VersionData TypeDescription

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.

ImportCode20.11.0Varchar(20)A code used to maintain the test hierarchy during import using Data Import Manager
InvertedScoring20.11.0Number(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.
Locked20.11.0Number(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.

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.