ASF Home   |   KID Home   |   Search/Login   |   Help   |   Privacy Thu Apr 25 20:15:14 2024 (Sydney/AU)
Australian Speleological Federation KID: ASF Field Definitions

Definitions for ASF KID

This document was created from the ASF KID on Thu Apr 25, 2024

This is the current list of the data fields in the ASF's KID. They are identical with the draft data fields of the Informatics Commission (UISIC) of the International Union of Speleology. The definitions below are arranged in UISIC Field ID (FID) order. The FID and field name are shown first, followed by the other details. If the field has coded values a link to the available codes for that field will be provided.

The full list of all definitions is here: Field Definitions.    The full list of all field value codes is here: Field Value Codes.
Also see the Notes at the end for the meanings of the various abbreviations used here.

To find a field name in this list use your browsers search facility to search for the text or partial text. If you know the FID, you can go straight to the field by adding #fid to the URL in your browser window and pressing <Return>.

Total number of FIDs: 5

427 : Key-in ID
Entity: XK
Data type: Alphanumeric Max length: 10 Coding: U Single/Multi-valued: S

Definition: The database internal record ID identifying a data entry session, a session being any period which is considered one logical unit, and which could include entering several Update ID batches. Usage: (1) This field is not entered by a user but by the system.

428 : Key-in - person ID
Entity: XK
Data type: Alphanumeric Max length: 10 Coding: U Single/Multi-valued: S

Definition: The internal record ID from the Person database identifying the person who performed a data-entry session. Comment: (1) This field would normally be present when a Person database was available on the site, and would normally use it as a lookup. (2) If key-in records are being kept at the site, then entering this field is mandatory.

429 : Key-in - start date
Entity: XK
Data type: Date Max length: 10 Coding: U Single/Multi-valued: S

Definition: The start date of a data entry session. Usage: This field is not entered by a user but by the system.

430 : Key-in - person
Entity: XK
Data type: Alphanumeric Max length: 25 Coding: U Single/Multi-valued: S

Definition: The full name of the person performing the data entry session. The format is Familyname comma space Givenname. Example: Smith, John Comment: (1) This field would normally be included in a table only when the person's name could not be shown via a link to the Person ID in the Person database. Usage: (1) The value would normally be auto-filled at the same time as performing a lookup for 428[Key-in - person ID] via the Person database. (2) If there is no Person database, or the person's name is not yet in the Person database, enter the person's full name in this field, observing the correct format: Smith, John. This format helps with later identification and processing of this name when adding it to a Person database.

449 : Key-in - end date
Entity: XK
Data type: Date Max length: 10 Coding: U Single/Multi-valued: S

Definition: The end date of a data entry session. Comment: (1) This field is not entered by a user but by the system, which keeps the current session updated to the current date.

Back to Top

Notes

Entities: 
   AR = Article in a publication
   AT = Field or attribute
   AV = Field value
   CA = Cave or karst feature
   EN = Entity
   JN = Journal
   OR = Organisation
   PA = Land parcel
   PE = Person
   PH = Photograph
   PL = Plan or map
   PM = Marker (Permanent mark)
   PS = Map series
   RE = Region or area
   RP = Report
   SM = Specimen
   SP = Species
   ST = Site
   SU = Subject
   SV = Survey
   SY = System field
   XK = A key-in batch
   XL = An upload batch
   XU = An update batch

Data type: 

   A = Alphanumeric
   N = Numeric; A "real" number allowing decimal places and many significant digits, typically around 15.
   D = Date
   L = Logical; True or False.
   I = Integer (short); A whole number in the range -32,767 to +32,768.
   M = Memo; A variable-length free-text field.
   B = BLOB; A Binary Large Object, e.g. a photo image.
Maximum length:
When a Numeric data type is expressed as text characters, its maximum length must allow for the maximum value and the finest precision, and if necessary, a leading sign. This maximum must also be considered on an international basis. For example, a field value which has maximum text characters of "-9999.999" consists of sign(1) + whole number digits(4) + decimal separator(1) + decimal digits(3), giving a total text length of 9, with a "scale" of 3. This would be expressed as a "Max. length" of 9.3

Codes for field coding: 

   I = International coding   U = Uncoded   L = Locally coded
Codes for single or multi-valued: 
   S = Single-valued   M = Multi-valued


[ ASF | KID | search | help | privacy ]