How Core Fields are populated on Upload from ILAP Analytics

Modified on Fri, 5 Jun at 3:33 PM

TABLE OF CONTENTS


Core fields read via a named host field can be overridden by mappings in Config (ILAP Term → host field). Fields sent as-is are not affected by Config mappings.


Schedule Core Fields

Core field nameApi response fieldFormulaData typeDescription
DescriptionDescription
TextThe schedule's name or title.
CompletedDateCompletedDate
DateThe date the schedule finished (or is planned to finish).
StartedDateStartedDate
DateThe date the schedule started (or is planned to start).
CurrentProgressCurrentProgress
NumberThe schedule's overall progress, as a percentage.
CutoffDateCutoffDate
DateThe data date / status date the schedule is current as of.
CodeCode
TextThe schedule's unique identifier in the host system.


Resource Core Fields

Core field nameApi response fieldFormulaData typeDescription
DescriptionDescription
TextThe resource's name or title.
CodeCode
TextThe resource's unique identifier in the host system.


Calendar Core Fields

Core field nameApi response fieldFormulaData typeDescription
HoursPerDayHoursPerDay
NumberThe number of working hours in a standard day for this calendar.
StartStart
DateThe calendar's start date.
FinishFinish
DateThe calendar's finish date.
DescriptionDescription
TextThe calendar's name or title.
CodeCode
TextThe calendar's unique identifier in the host system.


Profile Core Fields

Core field nameApi response fieldFormulaData typeDescription
TypeType
EnumThe shape of the resource distribution profile. Possible values: Cumulative, Incremental.
DescriptionDescription
TextThe profile's name or title.
CodeCode
TextThe profile's unique identifier in the host system.


Activity Core Fields

Core field nameApi response fieldFormulaData typeDescription
ActivityTypeActivityType
EnumThe kind of activity. Possible values: RegularActivity, MilestoneStart, MilestoneFinish, Hammock.
DescriptionDescription
TextThe activity's name or title.
FinishAsEarlyAsPossibleFinishAsEarlyAsPossible
BooleanConstraint: the activity should finish as early as the schedule allows.
FinishNoLaterThanFinishNoLaterThan
DateConstraint date: the activity must finish on or before this date.
MustFinishOnMustFinishOn
DateConstraint date: the activity must finish exactly on this date.
MustStartOnMustStartOn
DateConstraint date: the activity must start exactly on this date.
StartAsEarlyAsPossibleStartAsEarlyAsPossible
BooleanConstraint: the activity should start as early as the schedule allows.
StartAsLateAsPossibleStartAsLateAsPossible
BooleanConstraint: the activity should start as late as the schedule allows.
StartNoEarlierThanStartNoEarlierThan
DateConstraint date: the activity must start on or after this date.
StartNoLaterThanStartNoLaterThan
DateConstraint date: the activity must start on or before this date.
ActualFinishActualFinish
DateThe date the activity actually finished.
ActualStartActualStart
DateThe date the activity actually started.
ActualWorkHoursActualWorkHours
NumberWork hours already expended on the activity.
CurrentProgressCurrentProgress
NumberThe activity's progress, as a percentage.
EarlyStartEarlyStart
DateThe earliest the activity can start (forward-pass schedule date).
EarlyFinishEarlyFinish
DateThe earliest the activity can finish (forward-pass schedule date).
LateFinishLateFinish
DateThe latest the activity can finish without delaying the project (backward pass).
LateStartLateStart
DateThe latest the activity can start without delaying the project (backward pass).
FreeFloatHoursFreeFloatHours
NumberHours the activity can slip without delaying any successor.
TotalFloatHoursTotalFloatHours
NumberHours the activity can slip without delaying the project finish.
PlannedWorkHoursPlannedWorkHours
NumberThe planned / budgeted work hours for the activity.
RemainingWorkHoursRemainingWorkHours
NumberThe work hours still remaining on the activity.
IsAlwaysOnScheduleIsAlwaysOnScheduleif IsAlwaysOnSchedule has a value
return value
else return false
BooleanWhether the activity is flagged to always be treated as on-schedule.
IsCancelledCancelledDateIsCancelled = (CancelledDate is not null)BooleanWhether the activity has been cancelled.
CancelledDateCancelledDate
DateThe date the activity was cancelled.
PlannedProgressPlannedProgress
NumberThe planned progress at the data date, as a percentage.
DurationHoursDurationHours
NumberThe activity's duration in hours.
RemainingDurationHoursRemainingDurationHours
NumberThe activity's remaining duration in hours.
FinishOnOrAfterFinishOnOrAfter
DateConstraint date: the activity must finish on or after this date.
CalendarCalendarId
(resolved via lookup)
Resolved to the Calendar exported in the same transferReferenceThe calendar that governs the activity's working time.
CodeCode
TextThe activity's unique identifier in the host system.


Resource Assignment Core Fields

Core field nameApi response fieldFormulaData typeDescription
PlannedHoursPlannedHours
NumberPlanned work hours assigned to the resource on the activity.
ActualHoursActualHours
NumberActual work hours the resource has spent on the activity.
CurrentProgressCurrentProgress
NumberThe progress of the resource's assignment, as a percentage.
ResourceResourceId
(resolved via lookup)
Resolved to the Resource exported earlier in the same transferReferenceThe resource assigned to the activity.
ProfileProfileId
(resolved via lookup)
Resolved to the Profile exported earlier in the same transferReferenceThe distribution profile applied to the assignment.
CalendarCalendarId
(resolved via lookup)
Kept as the value already on the assignment (not re-resolved for assignments)ReferenceThe calendar governing the assignment's working time.
CodeCode
TextThe assignment's unique identifier in the host system.


Successor Core Fields

Core field nameApi response fieldFormulaData typeDescription
TypeType
EnumThe dependency relationship type. Possible values: StartToStart, StartToFinish, FinishToStart, FinishToFinish.
LagHoursLagHours
NumberThe lag, in hours, on the relationship.
CalendarCalendarId
(resolved via lookup)
Resolved to the Calendar exported earlier in the same transferReferenceThe calendar used to interpret the lag.
SuccessorObjectSuccessorObjectId
(resolved via lookup)
Resolved to the successor Activity (the link target)ReferenceThe successor activity (the link target).
CodeCode
TextThe link's unique identifier in the host system.


Structure Core Fields

Core field nameApi response fieldFormulaData typeDescription
DescriptionDescription
TextThe structure's name or title.
TypeType
EnumThe kind of structure. Possible values: Wbs, FlatList, HierarchicalList.
CodeCode
TextThe structure's unique identifier in the host system.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article