Transfers between Safran and Safran or P6 and P6

Modified on Thu, 16 Oct at 2:31 PM

TABLE OF CONTENTS

Introduction
The list of fields for Safran
The list of fields for P6

Introduction

When transferring data between Safran and Safran, or P6 and P6, IDE detects that each of the endpoints use the same Host System and therefore automatically adds some Host Specific settings at Activity and ResourceAssignment levels. The tables below show which fields are added for each of Safran and P6.

The list of fields for Safran

The list of fields that are automatically added to a transfer when source and destination is Safran.

DataType	Description	HostSystemIlapTermName	ILAPId	PlObjType
Boolean	Activity duration fit flag	SP_Act_activity_duration_fit_flag	ada9e6f0-247c-4fd5-a8a3-50525978dcbb	Activity
Boolean	Activity existence flag	SP_Act_activity_existence_flag	a5c41c5c-eef3-4dd0-b921-a11855d1795a	Activity
Integer	Future use	SP_Act_analyse_opt	36dc2378-3ed5-4ba6-9c5c-feae2a13331e	Activity
Float	Approved variations quantity	SP_Act_approved_vo_qty	98eee131-f5ff-4477-93c4-e9256160ea75	Activity
String	Units for duration field	SP_Act_duration_units	5dacaeb9-8b05-4551-8e49-ffeb926311f4	Activity
Boolean	Hammock flag	SP_Act_hammock_flag	aa967877-e2e1-4b7d-888e-77e53b46ba36	Activity
Integer	Flag for “all job packs defined”	SP_Act_job_flag	66410e4d-d6e9-422e-9304-3e85376f824a	Activity
Integer	Is activity manually progress updated? 1=yes 0=no	SP_Act_manual_prog_flag	4cf32a41-99de-4ea5-8439-1613382b2db4	Activity
Integer	Minimum duration used with activity fit option	SP_Act_minimum_duration	84fcad0d-1014-4a75-b40c-0bb1ccb1917b	Activity
Boolean	Progress out of sync flag Is set to 1 for activity during baseline update if volume progress and time progress is not matching for at least one resource	SP_Act_out_of_sync	f93e9e22-f318-40eb-b916-da9ed08d5d95	Activity
Float	Time percent completed – related to current_progress	SP_Act_current_pc	6a7a2b0b-e35e-4474-9da0-30bd47a6d9ef	Activity
Integer	Remaining duration analyzed	SP_Act_remain_duration_analyzed	3355a122-2fa3-43f9-b864-b7b1d1eafb8d	Activity
String	Remarks	SP_Act_remarks	ec64ad69-b27c-4c52-91af-04ec3ba180c0	Activity
Integer	Sub-Network Id	SP_Act_subnetwork_id	e14fda8d-5d16-48ee-ac06-88f642bff3c6	Activity
String	Formating unit for the duration field (w=weeks d=days h=hours m=minutes)	SP_Act_duration_format	ed62de6b-a2b8-42b4-b540-acaf383c81d3	Activity

String	Formating unit for the duration field (w=weeks d=days h=hours m=minutes)	SP_ResA_duration_format	75027795-7146-461f-a614-7d60c1fedbe5	ResourceUsage
Integer	Flag for inclusion in Rsh. Internal flag: current scope (configurable summary)	SP_ResA_rsh_flag	919ebb02-21ec-485c-975a-6d94f8ad80f6	ResourceUsage
Integer	Flag for inclusion in Tsh Internal flag: total scope (configurable summary)	SP_ResA_tsh_flag	2f3dcd40-efee-4c0a-ad3d-1d36bfaa8302	ResourceUsage
Integer	Resource type	SP_ResA_type	f6b47091-5776-40c5-ab79-5b84a499d89b	ResourceUsage
Integer	Variation order sequence number	SP_ResA_vo_seq	1dfae7b9-b7bc-485a-a637-01bfea40fe1b	ResourceUsage
String	Change order number as specified by user	SP_ResA_changeorder_number	9258b6ab-e2f8-4c23-a913-eb7eb3832be4	ResourceUsage
String	Change order type: V = Variation Order R = Variation Order Request I = Internal Change S = Subcontracted	SP_ResA_changeorder_type	d932d2fe-6497-48b1-8bfd-e7a5d436f77b	ResourceUsage

The list of fields for P6

The list of fields that are automatically added to a transfer when source and destination is Safran.

DataType	Description	HostSystemIlapTermName	ILAPId	PlObjType
Boolean	The option that determines whether the activity's actual and remaining units start date finish date and percent complete are computed automatically using the planned dates planned units and the schedule percent complete. If this option is selected the actual/remaining units and actual dates are automatically updated when project actuals are applied. Use this option to assume that all work for the activity proceeds according to plan.	P6_Act_AutoComputeActuals	f843ba1d-79c7-4501-8ca6-ff0bbb4b6bfb	Activity
String	The duration type of the activity. One of 'Fixed Units/Time' 'Fixed Duration and Units/Time' 'Fixed Units' or 'Fixed Duration and Units'. For 'Fixed Units/Time' activities the resource units per time are constant when the activity duration or units are changed. This type is used when an activity has fixed resources with fixed productivity output per time period. For 'Fixed Duration and Units/Time' activities the activity duration is constant as the units or resource units per time are changed. This type is used when the activity is to be completed within a fixed time period regardless of the resources assigned. For 'Fixed Units' activities the activity units are constant when the duration or resource units per time are changed. This type is used when the total amount of work is fixed and increasing the resources can decrease the activity duration.	P6_Act_DurationType	4fc87a47-915f-44d1-85bd-ed772068b6f2	Activity
Integer	The integer representing the critical path this activity is on. The value 1 is the most critical path value 2 is the second most critical path etc.	P6_Act_FloatPath	9e2d7f3b-7294-41d4-9c6b-44f4f87f8313	Activity
Integer	The integer representing the order in which this object was found on one of the critical paths.	P6_Act_FloatPathOrder	3175839e-c11c-4f83-9689-13d6cecd077b	Activity
Boolean	The flag that indicates whether an activity is on the longest path. Default = 'N'	P6_Act_IsLongestPath	f3efc069-8841-42f4-93ee-90b4bc0938b7	Activity
String	The activity percent complete type: 'Physical' 'Duration' or 'Units'.	P6_Act_PercentCompleteType	3580ee70-7894-45d2-8e4d-ad5618d59efe	Activity
DateTime	The date when a suspended task or resource dependent activity should be resumed. The resume date must be later than the suspend date and earlier than the actual finish date. The Suspend/Resume period behaves like a nonworktime on the activity calendar or resource calendar for task and resource dependent activities.	P6_Act_ResumeDate	b737d819-a3da-4d62-a855-67c0322cf79c	Activity
String	The current status of the activity either 'Not Started' 'In Progress' or 'Completed'.	P6_Act_Status	76409f37-0d6d-4dc4-b4d3-54945372a3e5	Activity
DateTime	The start date when the progress of a task or resource dependent activity is delayed from. The suspend date must be later than the actual start date which the activity must have. The progress of the activity can be resumed by setting the resume date. The Suspend/Resume period behaves like a nonworktime on the activity calendar or resource calendar for task and resource dependent activities.	P6_Act_SuspendDate	9352f091-14b9-40bd-a2ce-784dd94a3eb4	Activity
String	The short code assigned to each WBS element for identification. Each WBS element is uniquely identified by concatenating its own code together with its parents' codes.	P6_Act_WBSCode	323bcbfb-c5ca-45bc-a6a7-c960c526b14d	Activity
String	The name of the WBS element.	P6_Act_WBSName	04bde157-78c7-4425-92e0-2b01be5d036b	Activity
String	The WBS hierarchy of the activity.	P6_Act_WBSPath	74add858-ad33-4c3e-9698-cf1acd24f9a2	Activity

Boolean	The flag indicating whether new resource/role assignments drive activity dates by default.	P6_ResA_DrivingActivityDatesFlag	a0e28df2-907d-4300-8c5c-a16ec3efb8eb	ResourceUsage
Float	The planned units per time at which the resource is to perform work on this activity. For example a person assigned full time would perform 8 hours of work per day. A department of five people may perform at 5 days per day. This field is named BudgetedUnitsPerTime in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.	P6_ResA_PlannedUnitsPerTime	2745223b-c107-4f79-965b-bec5d4b60479	ResourceUsage
Float	(missing)	P6_ResA_RemainingUnits	9b38fdc9-4103-42ab-9fd4-21efb9048ba8	ResourceUsage
Float	The units per time at which the resource will be performing work on the remaining portion of this activity. For example a person assigned full time would perform 8 hours of work per day. A department of five people may perform at 5 days per day.	P6_ResA_RemainingUnitsPerTime	b03f003c-80ce-452a-99af-b0172e1b2ccc	ResourceUsage
String	The resource type: 'Labor' 'Nonlabor' or 'Material'.	P6_ResA_ResourceType	210bb608-ac56-4987-915e-c1c11c955625	ResourceUsage