Manual Activity Sheet Columns
The activity details are presented in columns. The columns are displayed in their defined order. If there is no attribute form defined (for manual activity sheets), all the P6 data elements (uuu_P6 data elements) are displayed as columns.
You can change the default view by creating and managing custom views in the View drop-down list.
Columns | Description |
|---|---|
Sequence No. | This is a read-only column, with a unique, sequential number starting from 1 (one). It indicates the numbering sequence of activities. The column cells are pre-populated with the sequence number provided in the activity sheet properties. In addition to displaying the row number, it displays errors if there are any. To select an activity, click inside the corresponding Sequence No. cell. |
Activity ID <label of the uuu_P6ActivityID> | The activity identification (ID) number for each added activity sheet, starting with letter A. This column shows a color icon that is based on the activity status and type. For example, the green rectangular icon indicates that an activity has not started, the yellow rectangular icon indicates that an activity is in progress, the light green rectangular icon indicates that an activity is completed, and the diamond icon indicates that an activity is milestone activity. The system uses the default sequence number specified in activity sheet properties to populate the field. However, you can edit the column and enter a custom activity ID for a selected activity sheet. This required field only allows alphanumeric characters; make sure that you do no use special characters if you update the field. |
Activity Name <label of the uuu_P6ActivityName> | The name of the activity sheet. You must specify the activity name. This required field only allows alphanumeric characters. You can edit the Activity Name column data. |
Notes | If available, a Notes (paper and paper-clip) icon indicates that there are notes related to the activity. If you have the applicable permission level, you can add notes for the selected activity sheet in the Notes tab. You must have permission to be able to post notes. The functionality is the same as in the CBS rows. For example, you can use notes to specify the reasons for the change of the activity sheet dates or duration from the initial baseline. |
The following shows a list of typical column headings in the Activity Sheet window (the default layout):
Columns | Description |
|---|---|
Start <label of uuu_P6StartDate> | Indicates when the activity is scheduled to start. The column is populated with the project start date by default. You can edit the date by selecting the date picker in the column. You can edit the date before or later but cannot move the date before project start date. For Activities that are In Progress and Completed, the start date will be the Actual Start (uuu_P6ActualStart). For new activities, after the project is scheduled on certain data date, the new activities start date will be by default the data date. Upon scheduling, if the activity is still not started as per the Data Date, the activity will be rescheduled according to the data date. |
Finish <label of uuu_P6FinishDate> | Indicates when the activity is scheduled to finish. The column is populated with the project start date by default for activities with a status of Not Started. You can edit the date. When the activity sheet is not scheduled, the Data Date will be the project start date. For activities that have been created after the activity sheet is scheduled (on certain data date), the finish date will default to the start date that is the Data Date. For Activities that are In Progress and Completed, the finish date will be the date from Data Date plus duration. When an activity sheet has not been scheduled, the Data Date will be the project start date. |
Duration <label of uuu_P6Duration> | Indicates how long the activity is expected to take. The column is populated with duration as one (1) day by default for regular Tasks/Activities and duration as 0 for the milestone activity. Duration will be updated by means of finish date changes or the user can manually update the duration column. Finish date will be calculated accordingly. |
Activity Status <label of uuu_P6ActivityStatus> | The default 'Not Started' will be displayed, and the activity icon (seen before the activity ID) will be in blue color, for not started activities. When the Activity Status changes to 'In Progress' or 'Completed' (based on the activity actual start date and finish dates), the color of the Activity ID will be changed accordingly. |
Activity % Complete | Lets you indicate what percentage of the activity is completed. Before you can manually update the percentage completed, make sure that the Actual Start is specified or change the Activity Status to In Progress. |
WBS Picker | If a Work Breakdown Structure (WBS) Sheet was defined for the project, use this field to select the applicable code. |
Planned Start <label of uuu_P6PlannedStart> | Scheduled start date. This column is populated with the default value of Start Date (uuu_P6Start) for the activities with a Not Started status. When the project is scheduled by using project scheduler, the values for the Start and Planned Start Date will move to the Current Data Date, if they are past dates. |
Planned Finish <label of uuu_P6PlannedFinish> | Scheduled finish date. This column is populated with the default value of Finish Date (uuu_P6Finish) for the activities with a Not Started status. When the project is scheduled by using project scheduler, the values for the Start and Planned Finish Date will be the Planned Start Date plus Duration. The task-dependent activities base their duration on the working and non-working days of the activity calendar, but the resource-dependent activities base their duration on the working and non-working days of the assigned resource's calendar. When multiple resources are assigned, the Finish Date of the activity will be based on the time required by the last resource to finish the same task, based on the resource calendar. You can edit the Duration column value in the activity sheet. This field will allow only integer-type data with no negative values. Note: The calendar that you select for each activity will be used to calculate the Finish Date. |
Planned Duration | Scheduled duration of the activity |
Actual Start | Lets you indicate the specific date and time at which the activity began. |
Actual Finish | Lets you indicate the specific date and time at which the activity was completed. |
Actual Duration | A read-only field that indicates how long the activity took to complete. |
Cost Code | Lets you select a Cost Breakdown Structure (CBS) code for the activity. |
Code Name | A read-only field that displays the name associated with the Cost Code. |
Planned Total Cost | Lets you indicate how much the activity should cost. |
Actual Total Cost | Lets you indicate how much the activity actually cost. |
Remaining Total Cost | Lets you indicate how much is left to spend. |
At Completion Total Cost | Lets you indicate how much the activity cost to complete. |
WBS Code | If applicable, a read-only field that displays the name associated with the WBS Cost Code associated with a Project Cost Sheet. |
WBS Name | A read-only field that displays the name associated with the WBS Cost Code. |
WBS Path | A read-only field that displays the hierarchy associated with the WBS Cost Code. |
Calendar | Indicates the type of calendar selected when the sheet was created. Lets you select a different one, if applicable. |
Include in Project Reporting? | If you want to include this activity in reports, select the checkbox. To remove it from reporting, deselect the checkbox. |
Assigned Resources | A read-only field that displays the resources based on the Master Rate Sheet. |
Activity Constraint Type | Lists the available types defined for the activity. This column is populated with the default value of As Soon As Possible. If you change the selection, the system updates the schedule accordingly. |
Activity Type | This column is populated with the default value of Task Dependent. You can select other values, such as Start Milestone, which will automatically the task to milestone with 0 duration days. |
Predecessor | A read-only field that lists an activity or task that must be completed before this one. |
Successor | A read-only field that lists an activity or task that must be completed after this one. |
Float | A read-only field that indicates how much of a delay (also known as slack) can occur without affecting the schedule. |
Early Start | A read-only field that indicates how early an activity can start based on the amount of float. |
Early finish | A read-only field that indicates how early an activity can finish based on the amount of float. |
Late Start | A read-only field that indicates how late an activity can start based on the amount of float. |
Late finish | A read-only field that indicates how late an activity can finish based on the amount of float. |
Remaining Early Start | Defaults to Start if it is not scheduled or started. You can manually change it for an activity that is In Progress. |
Remaining Early Finish | Defaults to Finish if it is not scheduled or started. You can manually change it for an activity that is In Progress. |
Remaining Duration | Defaults to Duration if it is not scheduled or started. You can manually change it for an activity that is In Progress. |
Planned Units | Lets you specify the number of units of work that you intend to use for the activity. |
Actual Units | Lets you specify the number of units actually expended for the activity. |
Remaining Units | Lets you indicate the number of remaining units of work to be performed on the activity. Also calculated by the system as Planned Units minus Actual Units. |
At Completion Units | Lets you indicate the number of remaining units at completion. Also calculated by the system as Actual Units plus Remaining Units. |
Planned Value | A read-only field that indicates the portion of the baseline total cost of the activity that is scheduled to be completed as of the project data date. |
Earned Value | A read-only field that indicates the portion of the project baseline total cost of the activity that is actually completed as of the project data date. |
Estimate To Complete | A read-only field that indicates the estimated cost to complete the activity. |
ETC Technique | A read-only field that indicates the formula used to calculate the Estimate To Complete. |
Estimate At Completion | A read-only field that indicates the expected total cost of the activity after the defined scope of work is completed. |
Budget At Completion | A read-only field that indicates the planned total cost of the activity through completion. |
Variance At Completion | A read-only field that indicates the difference between the baseline total cost and the current estimate of total cost. |
At Completion Duration | A read-only field that indicates the total working time from the Start date to the Finish date. |
ETC User Value | A read-only field that indicates the Estimate To Complete (ETC) value based on user-entered values. |
Cost Schedule Index | A read-only field that displays a combination of the Schedule Performance Index and the Cost Performance Index.
|
Schedule Performance Index | A read-only field that displays a measure of the work accomplished as a percentage of the work scheduled. |
Cost Performance Index | A read-only field that displays a measure of the work accomplished as a percentage of the actual costs. |
Schedule Variance | A read-only field that displays a measure of the schedule performance. |
Cost Variance | A read-only field that displays a measure of cost performance. |
To Complete Performance Index | A read-only field that displays the ratio of the remaining work to the remaining funds. |
Performance % Complete | Lets you indicate the percentage of the activity that is currently complete. |
Last Published Monday, April 14, 2025