Search only in titles

---

Detail Form

The following options are available (enabled) in the Detail Form:

• Adding new blocks
• Adding "Custom" elements to blocks
• Insert Row
• Delete Row
• Delete
• Save
• Undo
• Redo
• Close Window

In addition, when you want to add a new block, the column field is read-only (with a value of "1").

For a list of Data Elements (DEs), refer to the "P6 DEs" section of the Unifier Data Reference Guide.

This is so the user cannot add an additional (second) column to the block. Unifier recognizes the ordering of columns when the attributes render within an Activity Sheet, during runtime.

Note: Only one column can be created in a block, and you cannot hide blocks within the Detail Form.

In uDesigner Data Structure Setup (uDesigner > Data Structure Setup), the following pre-defined Data Elements (DEs) are provided for you to manually add to a P6 Activity Sheet attribute form:

Note: The DEs listed in the following table can be added to any other form in uDesigner, these DEs behave like any other regular DE in Unifier.

Item	P6 Activity Attribute Label	Data Element Name	Data Definition
1	Activity ID	uuu_P6ActivityId	SYS Short Description Text 40
2	Activity Name	uuu_P6ActivityName	SYS Short Description Text 120
3	CBS Code	uuu_P6CBSCode	SYS Short Description Text 40 Note: The P6 User Interface (UI) does not allow the CBS Code to be more than 20 characters. The P6 database stores the CBS Code field as Varchar(40 Characters).
4	CBS Name	uuu_P6CBSName	SYS Short Description Text 120 Note: The P6 User Interface (UI) does not allow CBS Name to be greater than 100 characters.
5	CBS Path	uuu_P6CBSPath	SYS Description Text 500
6	Activity Status	uuu_P6ActivityStatus	SYS Short Description Text 50
7	Activity Type	uuu_P6ActivityType	SYS Short Description Text 50
8	Activity % Complete	uuu_P6PercentComplete	Decimal Amount
9	Planned Total Cost	uuu_P6PlannedTotalCost	Currency Amount
10	Actual Total Cost	uuu_P6ActualTotalCost	Currency Amount
11	At Completion Total Cost	uuu_P6AtCompletionTotalCost	Currency Amount
12	Remaining Total Cost	uuu_P6RemainingTotalCost	Currency Amount
13	Planned Start	uuu_P6PlannedStart	Date Picker
14	Planned Finish	uuu_P6PlannedFinish	Date Picker
15	Actual Start	uuu_P6ActualStart	Date Picker
16	Actual Finish	uuu_P6ActualFinish	Date Picker
17	Start	uuu_P6Start	Date Picker
18	Finish	uuu_P6Finish	Date Picker
19	Remaining Early Start	uuu_P6RemainingEarlyStart	Date Picker
20	Remaining Early Finish	uuu_P6RemainingEarlyFinish	Date Picker
21	Planned Duration	uuu_P6PlannedDuration	Decimal Amount
22	Actual Duration	uuu_P6ActualDuration	Decimal Amount
23	At Completion Duration	uuu_P6AtCompletionDuration	Decimal Amount
24	Remaining Duration	uuu_P6RemainingDuration	Decimal Amount
25	Primary Constraint	uuu_P6PrimaryConstraint	SYS P6 Activity Constraints
26	Secondary Constraint	uuu_P6SecondaryConstraint	SYS P6 Activity Constraints
27	Cost Code	bitemID	CBS Picker

You have the option of excluding the other fields in the form, except the Activity ID and the Activity Name fields (items 1 and 2 in the preceding table) which are required and mandatory.

If you choose to exclude any of the pre-defined fields, Unifier will not receive data for the excluded field from P6.

Note: The excluded field may still be present within Gateway data mapping template, but the Activity Sheet will not receive the data for that excluded field.

The Activity Attributes in P6 can only have a limited set of DDs, which are needed for data exchange with Unifier. As a result, when you add a new DE to the Detail Form, using the "Custom" option, the resulting page (window) presents a list of DEs with the following DDs, only:

• SYS Short Description Text 32
• SYS Short Description Text 36
• SYS Short Description Text 40
• SYS Short Description Text 50
• SYS Short Description Text 120
• SYS Short Description Text 255
• SYS Description Text 500
• SYS P6 Activity Constraints
• Date Picker
• Currency Amount
• Decimal Amount
• Integer Amount
• SYS P6 Indicator

The Form Designer - Detail Form window has the following options available:

• File

  Save, Restore, and Close window

• Edit

  Undo, Redo, Define Blocks, Insert Row, Add Elements, Delete, Access, Move, and Validation

  The Define Blocks option allows you to open the Form Blocks window and add, modify, remove, or move blocks. The Blocks section of this window allows you to see the name, label, number of columns and rows, border, visibility, label width, and label position.

  The Add Elements option allows you to add Custom Data Elements to the form

• View

  Preview and Properties

• Help

  Unifier Help, Unifier Library, and About Unifier

In uDesigner, you can capture all the Activity Sheet Attributes fields by adding the fields in the form and each DE in this form maps to the corresponding element in P6 Activity attribute, within Gateway Data Mapping template.

You are not required to define the Activity Sheet Attribute form in uDesigner for integration to work. In other words, the P6 Activity Data will get pulled into Unifier without having to create the form.

You are required to define the Activity Sheet Attribute form and use the P6 Activity Picker Data Elements to set up auto-populate (AP) or reverse auto-populate (RAP) in uDesigner forms if you want to:

• Pick activities on Business Process or Shell Attribute forms
• Be able to auto-populate activity data to Business Process or Shell Attribute forms
• Be able to reverse auto-populate data into the Activity Sheet so that the updated data can be sent back to a 3rd party application

The following options are unavailable (disabled) in the Detail Form:

• Editable
• Editable Required
• Read-Only
• Validation
• Preview
• Properties
• Standard
• Linked
• Summary
• Dynamic Datasets

---

Last Published Monday, June 3, 2024