-
Notifications
You must be signed in to change notification settings - Fork 1
Database Documentation
This page holds details on all the fields for all the databases used by the Operations Tracker. Unless otherwise specified, all references to UT refer to the time in seconds from 0 epoch (9/13/16)
dbCatalog
dbMaps
db[Craft]
db[Kerbal]
dbFlt[Flight]
Crafts recordset contains data on crafts within certain SOIs.
Crew recordset contains data on all the kerbals employed by the KSA.
Distance recordsets contain pre-calculated values that the Ops Tracker uses to calculate solar output and signal delay. These recordsets come in two forms, one for planet-to-planet distances, which never change, and one for craft-to-planet distances, which change with craft orbital changes. A craft-to-planet database is used for when a craft is in orbit around Kerbol and needs to know the distance to Kerbin for signal delay. So it's always called dst[craft id]toKerbin. A craft in orbit around another body will just approximate with that body's distance from Kerbin or Kerbol and use a recordset named dst[body name]toKerbin/Kerbol.
Moons recordset contains all moons in the Kerbol system, each given a name and assigned a unique ID. Their reference field links them to the planet they orbit. Can include any additional moons, not just stock. This also contains all details needed for calculating orbital plots.
Parts recordset contains information to be used when displaying part details on craft images.
Planets recordset contains all planets in the Kerbol system, each given a name and assigned a unique ID. Like moons there can be additional planets besides stock. This also contains all details needed for calculating orbital plots.
ID - a unique number, used only for the database key, not by the Ops Tracker. Can be anything as long as it's unique
DB - the name of the database containing the craft information, minus the "db" or "dbFlt" prefix. This is the same name that must be appended to the db[Craft] or dbFlt[Flight] file for this vessel
Vessel - the printed name of the vessel to appear in the menu, can contain a single name or delimited string of multiple names
Type - the name of a vessel description that corresponds to a PNG image file on the server, should match all in-game types (ship, probe, debris, etc), can contain a single type or delimited string of multiple types
Desc - a description of the vessel that will appear as pop-up text when the link is hovered over in the event calendar. Text is constrained to within the menu area so description can be verbose, but shorter is better
SOI - a delimited string that tells the Flight Tracker what SOI the craft is in at what time
[MissionStartTime] - the UT when the mission officially began, be that when an object was discovered, released from another vessel, or launched. If left blank the Vessel Details view will attempt to derive the launch time from the Launches recordset while the menu will sort the start time from the last SOI field entry
[MissionEnd] - a delimited string that contains details on the termination of the mission. If it is not included, the menu will sort end mission times by the last SOI field entry
[Patches] - a delimited string containing information for 2-3 different patch types that can be displayed to the left of the vessel name in the Vessel Details view
[Related] - a delimited string containing information for a craft that is related to this vessel, like a rover or lander or delivery vehicle
[ImgTags] - a delimited string of tag identifiers that would reference this vessel in flickr tag searches
[SiteTags] - a delimited string of tag identifiers that would reference this vessel in KSA website searches
[AddlRes] - a delimited string containing external link information for the vessel
[Timeline] - a delimited string with information on a twitter timeline that contains tweets specifically for this vessel
Vessel String: [UT;]Name[|next entry]
[UT] - the time at which the vessel is to begin being referenced by this name in the menu (name changes for title of page comes from actual vessel DB)
Name - The name of the vessel to show up in the vessel menu. Can just be a single name, no delimination, if it never changes
Type String: [UT;]Type[|next entry]
[UT] - the time at which the vessel is to begin being referenced by this type in the menu and as an icon on the map
Type - The type of the vessel to show up in the vessel menu and on the map. Can just be a single type, no delimination, if it never changes
SOI String: UT;Ref[|next entry]
UT - the time at which the vessel is within this SOI reference
Ref - points to the unique planet or moon ID that identifies the SOI the vessel is within. A value of -1 moves vessel to the Inactive list. A value of -2 removes it from both Active & Inactive listings
MissionEnd String: UTShow;UTEnd;Text
UTShow - the time at which the end mission details should be made visible to the user
UTEnd - the time at which the mission came to an end
Text - context for how the mission ended (Mission Terminated, Vessel Destroyed, Mission Successful, etc)
Patches String: ProgramName;PatchURL;PageURL|VesselName;PatchURL[;PageURL][|PatchURL]
ProgramName - the name of the program. Do not include "Program"
PatchURL - the full URL to the patch image
PageURL - the full URL to the page holding the program data
VesselName - the name of the vessel
PatchURL - the full URL to the patch image
[PageURL] - the full URL to the page holding the vessel data
[PatchURL] - the full URL to the patch image
Related String: DB;Name;Desc[;UT]
DB - the database name of the vessel
Name - the displayed name of the vessel
Desc - the relationship between the two craft
[UT] - the time the relationship between the two craft should appear
AddlRes String: UT;Desc;Link[|next entry]
UT - the time this resource should be available to the user
Desc - description of the resource that will appear over the icon in a popup. This must also match a predefined label in the AddlResourceItems array in ksaGlobals.js so the proper icon is displayed
Link - full URL to the resource
Timeline String: [UT;]Link
[UT] - the time at which this timeline is visible to the user. Not including it means it is shown immediately
Link - full URL for the twitter collection
Activation - the UT at which the kerbal becomes a member of the KSA squad. Also has to be a unique identifier
Kerbal - the name of the kerbal's database record (see db[Kerbal])
Timeline - the full URL of the twitter collection for this kerbal's tweets
FullName - the actual name of the kerbal
BirthDate - MM/DD/YYYY of when the kerbal was born
Speciality - what the kerbal is best at
Hobbies - what the kerbal enjoys in spare time
FamName - the family name as a youngster before taking on the communal Kerman name
Bio - the history of the kerbal prior to joining the KSA
Deactivation - delimited string with information on why/when the kerbal left the KSA duty roster
Deactivation String: UT;Reason
UT - the time at which the kerbal ceased to be an active duty member
Reason - Short description for tooltip that will read "[Reason] on [UT Date]" so for example "Deceased on 12/1/12". NOTE - "Deceased" is the official term used by the Ops Tracker to denote a dead kerbal, and should be supplied for the Reason in the event of death
UT - the time at which the data in this recordset is valid, in seconds since the start of the game
Data - a delimited string containing the time and distance from the sun in elapsed time from the start of the orbit
Data String: UT;Distance[|next entry]
UT - the time since the beginning of the orbit that this distance is equal to
Distance - the distance in km from the craft to Kerbin at this UT
The Data string is exported from KSPTOT graphical analysis tool into a CSV file and can then be converted to the proper string format via this online CSV converter.
UT - the time since the beginning of the orbit that this distance is equal to
Distance - the distance in km from the craft to Kerbin or Kerbol at this UT
Can be imported straight to Access from a CSV generated by KSPTOT
ID - numerical identifier for the body, from 50+
Body - the name of the body
Ref - the number of the ID field that is assigned to the planet this moon orbits
Mass - the mass of the body, taken from the KSP Wiki
Gm - the gravitational constant for this body, taken from KSPTOT's bodies.ini file
Radius - the radius of the body, in km, taken from KSPTOT's bodies.ini file
SolarDay - the length daytime for the body, in seconds, taken from the KSP Wiki
RotPeriod- the rotational period of the body, in seconds, taken from KSPTOT's bodies.ini file
RotIni - the amount the body is rotated at epoch 0, in degrees, taken from KSPTOT's bodies.ini file
SOI - the radius of the body's Sphere of Influence in meters, taken from KSPTOT's bodies.ini file
ObtPeriod - the orbital period of the body in seconds, taken from KSPTOT's bodies.ini file
Desc - the description of the body, taken from the KSP Wiki
Ap - the apoapsis of the body in meters, taken from the KSP Wiki
Pe - the periapsis of the body in meters, taken from the KSP Wiki
Ecc - the eccentricity of the body, taken from the KSP Wiki
Inc - the inclination of the body in degrees, taken from the KSP Wiki
ObtVel - the range of orbital velocity speed in m/s, taken from the KSP Wiki
Density - the density of the body, taken from the KSP Wiki
SurfaceG - the surface gravity of the body, taken from the KSP Wiki
EscapeVel - the speed in m/s needed to escape the body's gravity, taken from the KSP Wiki
[Image] - the image of the body to show in the dialog. If left blank a placeholder is shown
Atmo - whether the body has atmosphere, and if so up to what height, taken from the KSP Wiki
AtmoHeight - the height of the atmosphere in km
Moons - a list of any moons in orbit around the body
TrueAnom - true anomaly, taken from KSPTOT's bodies.ini file
RAAN - right ascension of the ascending node, taken from KSPTOT's bodies.ini file
Arg - argument of periapsis, taken from KSPTOT's bodies.ini file
Color - hexadecimal color value (without #) of the orbital plot line to display on the Surface Map
SMA - semi-major axis, taken from KSPTOT's bodies.ini file
Part - a unique name identifier for the part
[Title] - part title, only needs to be taken out of the HTML field if this part can be included multiple times on a vessel. This is noted by adding an amount="#" element to the <area> tag in the image map for the vessel
HTML - the description and stats for the part that will be inserted into the tooltip
[Notes] - a delimited string containing extra information for a part that can be displayed on a vessel-specific basis at the bottom of the part tooltip
Notes String: RegExp%Text[&next entry]
RegExp - a regular expression that will match any of the vessel DB names this note should be attached to
Text - the text to display in the note (the Note: text before it is added automatically)
ID - numerical identifier for the body, from 0-49
Body - the name of the body
Gm - the gravitational constant for this body, taken from KSPTOT's bodies.ini file
RotIni - the amount the body is rotated at epoch 0, in degrees, taken from KSPTOT's bodies.ini file
SolarDay - the length daytime for the body, in seconds, taken from the KSP Wiki
Radius - the radius of the body, in km, taken from KSPTOT's bodies.ini file
RotPeriod- the rotational period of the body, in seconds, taken from KSPTOT's bodies.ini file
SOI - the radius of the body's Sphere of Influence in meters, taken from KSPTOT's bodies.ini file
ObtPeriod - the orbital period of the body in seconds, taken from KSPTOT's bodies.ini file
Desc - the description of the body, taken from the KSP Wiki
Ap - the apoapsis of the body in meters, taken from the KSP Wiki
Pe - the periapsis of the body in meters, taken from the KSP Wiki
Ecc - the eccentricity of the body, taken from the KSP Wiki
Inc - the inclination of the body in degrees, taken from the KSP Wiki
ObtVel - the range of orbital velocity speed in m/s, taken from the KSP Wiki
Mass - the mass of the body, taken from the KSP Wiki
Density - the density of the body, taken from the KSP Wiki
SurfaceG - the surface gravity of the body, taken from the KSP Wiki
EscapeVel - the speed in m/s needed to escape the body's gravity, taken from the KSP Wiki
[Image] - the image of the body to show in the dialog. If left empty a placeholder will be used
Atmo - whether the body has atmosphere, and if so up to what height, taken from the KSP Wiki
AtmoHeight - the height of the atmosphere in km
Moons - a list of any moons in orbit around the body
These recordsets contain information that allows for the display of items on a dynamic map of the body being displayed. Recordset names should directly match the name of the planet. Templates are provided to make it easy to remember what fields need to be filled out for each marker type.
UT - the time at which the data in this recordset should be displayed
[Flags] - a delimited string that contains all flags to be displayed
[POI] - a delimited string that contains all points of interest to be displayed
[Anomalies] - a delimited string that contains all anomalies to be displayed
[Labels] - a delimited string that contains all labels to be displayed
[Airports] - a delimited string that contains all airports to be displayed
[GroundStations] - a delimited string that contains all ground stations to be displayed
[Aerial] - if checked, the dynamic map will allow the user to see satellite imagery of the body
[Satellite] - if checked, the dynamic map will allow the user to see satellite imagery of the body (this only offers another name for the same type of imagery. If both are checked the map layer will be named Satellite)
[Relief] - if checked, the dynamic map will allow the user to see terrain data of the body, and the elevation data will show in the Info control
[Slope] - if checked, the dynamic map will allow the user to see slope data of the body, and the slope data will show in the Info control
[Biome] - if checked, the dynamic map will allow the user to see biome data of the body, and the current biome will show in the Info control
Flags String: Lat;Lon;Alt;Title;Crew;Plaque;Placed;Link;LinkText[|next item]
Lat - latitude of the flag's position (can be taken from the flag's VESSEL{} in the SFS file)
Lng - longitude (same as above) - if greater than 180 it should be subtracted by 360 before entered into this field
Alt - altitude, in meters (can also be taken from the flag's VESSEL{} in the SFS file)
Title - the name given to the flag (can also be taken from the flag's VESSEL{} in the SFS file)
Crew - who was involved in the mission that planted the flag (or just the kerbal who planted it - can be taken from the flag's VESSEL{} in the SFS file). If null then this field is omitted from the popup text
Plaque - the inscription on the flag (can also be taken from the flag's VESSEL{} in the SFS file)
Placed - the UT the flag was placed on
Link - full URL to whatever expanded material involving the flag's placement (like a mission report) or the database name of a vessel
LinkText - the text that will be hyperlinked. If null then it is assumed the database name of a vessel is used to select it in the Ops Tracker when the link is clicked
POI String: Lat;Lon;Alt;Title;Desc[|next item]
Lat - latitude of the POI position
Lng - longitude (same as above) - if greater than 180 it should be subtracted by 360 before entered into this field
Alt - altitude, in meters
Title - the name given to the POI. If a hyperlink is used, be sure to wrap in single quotes
[Desc] - a description of the item being labeled, if left out it should be 'null'
Anomalies String: Lat;Lon;Alt;Title[|next item]
Lat - latitude of the anomaly position
Lng - longitude (same as above) - if greater than 180 it should be subtracted by 360 before entered into this field
Alt - altitude, in meters
[Title] - the name given to the anomaly, if left out it should be 'null'. If a hyperlink is used, be sure to wrap in single quotes
Labels String: Lat;Lon;Title[|next item]
Lat - latitude of the label position
Lng - longitude (same as above) - if greater than 180 it should be subtracted by 360 before entered into this field
Title - what is displayed for the label
Airports String: Lat;Lon;Title[|next item]
Lat - latitude of the airport position
Lng - longitude (same as above) - if greater than 180 it should be subtracted by 360 before entered into this field
Title - what is displayed for the airport name. If a hyperlink is used, be sure to wrap in single quotes
Ground Station String: Lat;Lon;Alt;Title;MaxRange[|next item]
Lat - latitude of the ground station position
Lng - longitude (same as above) - if greater than 180 it should be subtracted by 360 before entered into this field
Alt - altitude, in meters
Title - the name given to the Ground Station. If a hyperlink is used, be sure to wrap in single quotes
[MaxRange] - the range, in meters, this station can communicate in. If set to 'null', the range is infinite which means it can talk to any probe within the current planetary system that is visible over the horizon
[Ascent Data] recordset contains telemetry information for vessel ascent to orbit after launch.
[Craft Comms] recordset contains information on any communications equipment aboard.
[Craft Data] recordset contains various general information about the vessel that is always displayed with every update.
[Craft Ports] recordset contains information on the status of any docking ports the craft has
[Craft Resources] recordset contains information on vessel resources, types and weight.
[Crew Manifest] recordset contains information on any astronauts currently aboard.
[Flight Data] recordset contains orbital information for when the craft is in space.
[Flightplan] recordset contains maneuver node data that can be displayed on the dynamic map if it occurs along the rendered orbit (usage not required)
[Launch Times] recordset contains information on the timeline leading up to launch, including any scrubs or rescheduling
All recordsets can be updated independently. If you add a record to Craft Data, you do not have to add a corresponding UT record to all the other recordsets. The optional recordsets can be left empty of records but their tables must exist.
Assumes a 1s interval between records!
ID - the time in seconds from 0 epoch at which this data occurs (UT)
Heading - the current heading, in degrees
Pitch - the current pitch, in degrees
Roll - the current roll, in degrees
DstTraveled - the distance the rocket has traveled along its flight path from the launch point, in meters
StageFuel - the amount of fuel remaining in the current stage, in fractional percent
TotalFuel - the amount of fuel remaining in the entire vessel, in fractional percent
Q - the current dynamic pressure of the craft in kilopascals. Used until its value reaches 0
Mass - the mass of the entire vehicle, in tonnes
AoA - the current angle of attack, in degrees
Altitude - the current altitude of the craft above sea level, in meters
Lat - current latitude of the vessel, in degrees
Lon - current longitude of the vessel, in degrees 180 to -180
Apoapsis - the current apokee of the craft, in meters
Periapsis - current perikee of the craft in meters. Not used until the Q value reaches 0
Inclination - the current inclination of the craft, in degrees
Velocity - the current orbital velocity of the craft, in m/s
Thrust - the current thrust produced by all engines, in kN
Gravity - the current level of gravity, used to calculate TWR
DstDownrange - the distance the rocket has traveled over land from the launch point, in meters
Throttle - the current throttle setting of the craft, in whole percent
[AoAWarn] - a delimited string for stalls, sideslips, etc. If omitted, a default "nominal:green" string is used
[Event] - string describing the current status (meco, booster sep, etc). If omitted, no change to text
[Image] - full URL of image to depict current status. If omitted, no change to image
[Phase] - if present, changes the color of the ascent path to represent a new phase of the ascent and pops up a label for line with this text
[EventMark] - if present, drops a marker on the ascent path to signify a notable event happening at that point, with this text as its popup label
[FieldStatus] - flashes the background of specific data fields either yellow or red for the one second that the field is used. What to flash is defined by a delimited string
AoAWarn String: Text:Color
Text - what to display
color - CSS color name for the text (red, green, orange, etc)
FieldStatus String: Field:Code[_next entry]
Field - the name of the JQuery element to flash
Code - the color to flash. wrn for yellow, err for red
UT - the time at which this change occurs
Connection - Whether this craft has a connection to KSC at this time. If so, signal delay will be calculated
Comms - string containing information of all the communications arrays aboard the craft at this time
Comms String: Type;Desc[;Active][|next entry]
Type - either "omni" or "dish" to show the appropriate icon
Desc - what will show up in the tooltip for the icon image
[Active] - true or false value to determine if this comm is being used at the time
UT - the time at which this update occurs
MissionStartTerm - The text that will appear before the mission start UTC time (too many characters will cause text wrap)
CraftName - name of the craft to display at the top of the page. Anything placed in () will not be included in the tag name for loading flickr/website content
CraftImg - string of delimited values that points to one or more 650x400 images of the craft showing its current state (configuration, SOI)
CraftDescTitle - a short event description that will appear at the bottom of the craft image, and at the top of the full description dialog box
CraftDescContent - HTML code to fill in the dialog box that appears when user clicks the craft description title
[NextEventTitle] - text that appears with the Scheduled Event list option if a future event is scheduled. Only shown if this record is the current event
[Content] - either a delimited string that displays a dynamic map or pre-laid out static imagery, or HTML that displays whatever it is programmed to display
[DistanceTraveled] - the total (not change in) distance (in km) the spacecraft has traveled since launch. Number should be pre-formatted
CraftImg String: ImgNormal~ImgBurn~ImgThrust~ImgMap[|next item]
ImgNormal - the full URL of the base image with engine/thrusters off
[ImgBurn] - the full URL of the engine on image overlay or null
[ImgThrust] - the full URL of the thrusters on image overlay or null
ImgMap - the image map overlay that contains part information about the craft or null
Each image map should have a unique ID like craftOverlayMap1, craftOverlayMap2, etc. In order to fill in a part from the Parts recordset, the name of the part in the title attribute of the area tag must start with a &
Content String - Prelaunch/Static Ascent: @Lat|Lng|Text[|Alt]
Lat - the latitude of the launch site
Lng - the longitude of the launch site 180 to -180
Text - the name of the launch site or a position update
Alt - the current altitude of the vessel in km
Content String - Video Ascent: ~MP4|Webm|Ogg
MP4 - the size of the MP4 video, in MB
Webm - the size of the Webm video, in MB
Ogg - the size of the ogg video, in MB
Content String - Orbital, Dynamic Map: !Ecliptic|Polar
Ecliptic- full URL to the image of the ecliptic (side) view for the orbit
Polar - full URL to the image of the polar (top-down) view for the orbit OR caption to use for the first image if only one orbital diagram needed
Content String - Orbital, Static Only: !Ecliptic|[Polar[Top,Left]]
Ecliptic- URL to the image of the ecliptic (side) view for the orbit
Polar - URL to the image of the polar (top-down) view for the orbit. Can be replaced with any string value that does not include ".png" so it knows that this is not an image. This will instead center the single image defined by Ecliptic and use this string as a tooltip caption
[Top - offset in pixels from the top of the content area to show the orbital information box. NOTE the opening bracket is required and does not denote an optional value, although this value can indeed be optional
Left] - offset in pixels from the left of the content area to show the orbital information box NOTE the closing bracket is required and does not denote an optional value, although this value can indeed be optional if Top is also not included
UT - the time at which this change occurs
Ports - a delimited string containing information on the docking ports for the vessel
Ports String: PortName;DB;CraftName[|next entry]
PortName - the name given to the docking port
[DB] - the database name of the craft that is docked to it, otherwise 'null'
[CraftName] - the name of the craft (or other station/base module) that is docked here, otherwise 'null'
UT - the time at which this change occurs
DeltaV - the total amount of delta-v remaining for the craft, in km/s
TotalMass - the mass of the entire craft, including resources, in tonnes
ResourceMass - the mass of all resources aboard the ship that have it, in tonnes
MaxSolarOutput - a delimited string to allow for dynamic calculation of maximum solar output. Take into consideration fixed panels can't all point towards the sun at the same time
Resources - a delimited string containing information of all the resources aboard the craft at this time
MaxSolarOutput String: EC;PanelNum[:next entry]
EC - the max output around Kerbin
PanelNum - the number of panels that produce this output
Resources String: Name;Desc[|next entry]
Name - the name of the resource, like "ElectricCharge", which will also correspond to the image file that holds its resource icon
Desc - what will show up in the tooltip for the resource icon image
UT - the time in seconds at which this change occurs
Crew - a delimited string containing information for all crew members aboard at this time
Crew String: Name;Roster;Boarded[|next entry]
Name - the name of the kerbal, like "Jeb" or "Jebediah Kerman" or "Commander Jeb Kerman"
Roster - the database name of the kerbal's db[Kerbal]
Boarded - the UT at which the kerbal boarded the vessel
UT - the time at which this change occurs
[Rendezvous] - the DB name of the craft that you want to render an orbit for at the same time, will suppress rendering of any PlannedObt data in the Flightplan recordset for the same time period
[SOI Event] - delimited string that describes an SOI exit/entry that should put a hold on all trajectory calculations until a new Flight Data record is loaded
VelocityPe - the speed of the craft at lowest point along current trajectory
VelocityAp - the speed of the craft at highest point along current trajectory
Periapsis - the altitude, in km, of lowest point along current trajectory
Apoapsis - the altitude, in km, of highest point along current trajectory
Orbital Period - number of seconds to complete one orbit. If the orbit is hyperbolic, it should contain the UT of when the vessel will exit the current SOI, as a negative value
Eph - UT at which the record's Keplerian properties are valid. Not to be confused with the the UT of the update
SMA - semi-major axis of the current trajectory
Eccentricity - eccentricity value of the current trajectory
inclination - inclination value of the current trajectory in degrees
RAAN - right ascension of ascending node of the current trajectory in degrees
Arg - argument of periapsis of the current trajectory in degrees
TrueAnom - true anomaly of the current trajectory in degrees
SOI Event String: UT;Type;Reason;Lat;Lng
UT - the time of the SOI event
Type - "entry" or "exit" to display the proper map marker
Reason - verbose explanation of why the orbital data is unavailable
Lat - latitude of the event
Lng - longitude of the event
NOTE: fields can be text, but there should be NO commas included in any of these values. Numbers will be formatted via ASP/JS
UT - the time at which this maneuver should be visible on the map
ExecuteUT - the time in seconds from 0 epoch at which this maneuver node occurs
EndUT - the time in seconds from 0 epoch at which this maneuver node ends (actual, not planned)
Prograde - m/s movement along the prograde vector
Normal - m/s movement along the normal vector
Radial - m/s movement along the radial vector
Total - total amount of delta-v required for maneuver
Data - string of delimited data that contains spacecraft telemetry for each second of the maneuver
[PlannedObt] - string of delimited data that contains the planned orbital properties of the completed maneuver. If used, this will not show the orbit when Rendevous in the Flight Data recordset has a craft assigned, as that craft's orbital plot will be what the current maneuver is aiming for
Thrusters - whether the thrusters are active for this maneuver
Engines - whether the engines are active for this maneuver
Data String: AvgVel;PeAlt;ApAlt;Ecc;Inc;Period;SMA;RAAN;Arg;Mean;Eph;Lat;Lng;Vel;Alt;Dv;PeSpeed;ApSpeed[|next entry]
AvgVel - average velocity calculated from velocity at Pe and velocity at Ap
PeAlt - altitude, in km, of periapsis
ApAlt - altitude, in km, of apoapsis
Ecc - current eccentricity
Inc - current inclination, in degrees
Period - current orbital period, in seconds
SMA - current semi-major axis, in km
RAAN - current right-angle of the ascending node, in degrees
Arg - current argument of periapsis, in degrees
Mean - current mean anomaly, in degrees
Eph - the UT this orbital data is valid
Lat - current latitude of the vessel, in degrees
Lng - current longitude of the vessel, in degrees
Vel - current velocity of the vessel, in km/s
Alt - current altitude of the vessel, in km
Dv - amount of Dv remaining in the maneuver, in km/s
PeSpeed - speed of craft at periapsis, in km/s
ApSpeed - speed of craft at apoapsis, in km/s
PlannedObt String: Ecc;Inc;Period;SMA;RAAN;Arg;Mean;Eph
Ecc - current eccentricity
Inc - current inclination, in degrees
Period - current orbital period, in seconds
SMA - current semi-major axis, in km
RAAN - current right-angle of the ascending node, in degrees
Arg - current argument of periapsis, in degrees
Mean - current mean anomaly, in degrees
Eph - the UT this orbital data is valid
UT - the time at which this change occurs
LaunchTime - the UT at which the planned launch is to occur. If it is the exact same time as UT, this will indicate the launch is on HOLD status
The final entry in the recordset is the actual launch time.
Background recordset contains personal history information for the kerbal
Kerbal Stats recordset contains information about the kerbal's service history and current assignment
Mission recordset contains links to previous missions (that have been written up and posted online)
[Ribbons recordset] contains all ribbons awarded via Final Frontier. Ribbons do not have to be awarded upon initial recordset creation
All recordsets can be updated independently.
UT - the time at which this change occurs
History - summary of service record for kerbal, which is appended to their information dialog
UT - the time at which this change occurs
Rank - the rank of the astronaut, which will appear before their name in the Header
Image - the full URL to the 498x600 image of the kerbal
Science - the amount of science points accrued so far
Distance - how far the kerbal has traveled so far, in km
[Dockings] - the number of dockings performed by the kerbal as reported by Final Frontier. Can be left blank for non-pilots
TMD - Total Mission Days as reported by Final Frontier
TEVA - Total EVA time, as reported by Final Frontier
Status - Plain text label for use in sorting crew in menu
[Assignment] - Plain text label for use in sorting crew in menu
[MissionStart] - the time in UT that the mission begins to show a countdown or MET
[StatusHTML] - tooltip text that can appear for Status elaboration, can include HTML
[MissionHTML] - tooltip text that can appear for Mission elaboration, can include HTML
[Vessel] - the db identifier for the vessel that this kerbal will be performing a mission on
UT - the time at which this mission becomes visible in the mission list
Link - full URL to the mission report
Title - text to appear in drop-down mission list
UT - the time at which this ribbon becomes visible
Ribbon - the name of a ribbon that corresponds to a PNG image file on the server
Title - the name that will appear when the ribbon image is hovered over
Desc - text detailing the ribbon's meaning that appears under the title
[Override] - the UT at which this ribbon is superseded by another, meaning it will no longer be shown after this time unless the user makes it visible
Mission Data recordset contains basic mission information to display in the dialog box when the map popup is clicked to show more info
Flight Data recordset contains flight telemetry data to be plotted out onto the surface map. Best to import from an Excel file or CSV that was exported from KSP
ID - any number, there will never be more than one record in the recordset
Title - the text to display in the title bar of the dialog box
Img - full URL to an image to display in the dialog box
Desc - mission description to display next to the image
Report - full URL to the mission report page
UT - the time associated with this flight data record
ASL - height above sea level in meters for this UT
AGL - height above terrain in meters for this UT
Lat - Latitude in degrees for this UT
lng - Longitude in degrees 180 to -180 for this UT
Spd - velocity in meters per second for this UT
Dist - distance in meters from KSC for this UT