Søgning » Naturdatabasen » Aktivitet
Tabel

Aktivitet


Beskrivelse ?

One instance of collection data for a form of a specific Activity Type.

Størrelse (Antal rækker) ?

858096

Indhold (Kolonner/variable) ?

Navn Indhold
AktID Primary Key
ProgID Reference to the form (activity type) that defines the data that is collected.
AnsvarligMyndighedID A foreign key reference to the authority who carried out the collection and registration of data for the activity.
AktivitetDatoStart The date that the activity started.
AktivitetDatoSlut The date that the activity ended - when no value it means that all data was collected on the start date only.
AktivitetTidStart The time the activity started - not a required value.
AktivitetTidSlut The time the activity ended - not a required value.
TmpID A temporary key given to the activity for handling asynchronous data commits.
JournalNr A user generated key/reference for the activity.
Bemaerk Comments about the activity.
OprettetDato The date the activity was created.
SidstRettetDato The date the activity was last updated.
sysStatusID Foreign key that describes the status.
ParentID Old activity types have been able to be collected as stations and station instances. When an activity has children references, it means it is interpreted as a station.
StedID A reference to the location where the activity took place.
Locked A system key that temporarily can lock an activity from being edited if currently open by a user.
IndsamlingsformaalID Foreign key that explains the overall data collection purpose for this activity.
LastSubmittedDate The date the user last submitted changes for the activity.
IsAlternative When ticked, it means that the activity is missing required data.
IsFlagged When ticked, it means that the activity has flagged data that is seen as being dubious.