XER Tables That Matter for a Viewer or Converter

PROJECT

Project header. Key cited columns:

CALENDAR

clndr_type stored values (e.g. CA_Base / CA_Project / CA_Rsrc) are not listed in the Oracle data map. Plan Academy's XER parser note uses CA_base / CA_Project. Treat those codes as unverified against Oracle until seen on a live XER.

SCHEDOPTIONS

Schedule-calculation flags for the project. Oracle lists (among others):

How those flags encode Retained Logic vs Progress Override vs Actual Dates is not spelled out in the column map. See Retained Logic vs Progress Override vs Actual Dates for the UI meanings. Exact Y/N pairing of the two flag columns is unverified.

The _multiple_longest_path columns are on the cited project map. Oracle did not publish UI labels (Calculate multiple float paths / Total vs Free Float / ending activity / path count) for them. See Multiple Float Paths Rank Chains; They Are Not Longest Path or TF Critical.

TASK

Activities. Not WBS rows. Key cited columns:

Durations and floats in XER are hours (*_hr_cnt).

TASKPRED

Activity relationships. See TASKPRED (Activity Relationships).

PROJWBS

WBS nodes. Not activities. See P6 WBS.

RSRC

Resource dictionary. Cited columns from the Oracle data map:

TASKRSRC

Activity resource assignments.

UDFTYPE / UDFVALUE

User-defined field definitions and values.

UDFTYPE (Oracle): udf_type_id (Unique ID), udf_type_name (User Defined Field), udf_type_label (Title), table_name (Table), logical_data_type (Data Type), super_flag (Secure Code).

UDFVALUE (Oracle): udf_type_id (User Defined Field), fk_id (labeled "Activity Step Item" — that label is Oracle's; treat the join target as the object the UDF is on, not necessarily a step), proj_id, udf_text, udf_number, udf_date, udf_code_id.

ACTVTYPE / ACTVCODE / TASKACTV

Activity codes (dictionary + values + assignments). These usually do not survive a clean XER → MSPDI round-trip as P6 activity codes.

ACTVTYPE: actv_code_type_id (Unique ID), actv_code_type (Activity Code), actv_code_type_scope (Activity Code Type Scope), actv_short_len (Max Code Length), proj_id (EPS/Project), seq_num, super_flag.

ACTVCODE: actv_code_id (Unique ID), short_name (Activity Code Value), actv_code_name (Description), actv_code_type_id, parent_actv_code_id, seq_num, color (P6 EPPM only).

TASKACTV: task_id (Activity), actv_code_id (Activity Code Value), actv_code_type_id (Activity Code), proj_id (Project).

FUNDSRC / PROJFUND

Funding-source dictionary and project/EPS assignments. Not Original Budget (PROJWBS.orig_cost) and not spending plan (WBSBUDG).

FUNDSRC (Oracle): fund_id (Unique ID), fund_name (Funding Source), fund_descr (Description), parent_fund_id (Parent Funding Source), seq_num (Sort Order).

PROJFUND (Oracle): proj_fund_id (Unique ID), proj_id (Project), fund_id (Funding Source), fund_cost (Amount), fund_wt (Fund Share).

See Funding.

WBSBUDG / BUDGCHNG

Monthly spending/benefit plan rows, and the budget-change log. Original Budget is PROJWBS.orig_cost, not these tables.

WBSBUDG (Oracle): wbs_budg_id (Unique ID), wbs_id (WBS), proj_id (Project), start_date (Date), spend_cost (Spending Plan), benefit_cost (Benefit Plan).

BUDGCHNG (Oracle): budg_chng_id (Unique ID), wbs_id (WBS), proj_id (Project), chng_cost (Amount), chng_date (Date), chng_by_name (Responsible), chng_descr (Reason), chng_short_name (Change Number), status_code (Status).

See Spending Plan.

SHIFT / SHIFTPER

Resource-shift names and 24-hour segments. Not a calendar. RSRC.shift_id points at SHIFT. RSRCRATE.shift_period_id is labeled Shift.

SHIFT (Oracle): shift_id (Unique ID), shift_name (Shift Name).

SHIFTPER (Oracle): shift_period_id (Unique ID), shift_id (Shift Name), shift_start_hr_num (Shift start hour number).

See A Shift.

RCATTYPE / RCATVAL / RSRCRCAT

Resource-code dictionary, values, and assignments. Global. Not ACTVTYPE / TASKACTV.

RCATTYPE (Oracle): rsrc_catg_type_id (Unique ID), rsrc_catg_type (Resource Code), rsrc_catg_short_len (Max Code Length), seq_num (Sort Order), super_flag (Secure Code).

RCATVAL (Oracle): rsrc_catg_id (Unique ID), rsrc_catg_short_name (Resource Code), rsrc_catg_name (Code Description), rsrc_catg_type_id (Resource Code), parent_rsrc_catg_id (Parent Code), seq_num (Sort Order).

RSRCRCAT (Oracle): rsrc_id (Resource), rsrc_catg_type_id (Resource Code), rsrc_catg_id (Code Value).

See Resource Codes Tag Resources, Not Activities.

ROLECATTYPE / ROLECATVAL / ROLERCAT

Role-code dictionary, values, and assignments. On the role, not on TASKRSRC.

ROLECATTYPE (Oracle): role_catg_type_id (Unique ID), role_catg_type (Role Code), role_catg_short_len (Max Code Length), seq_num (Sort Order), super_flag (Secure Code).

ROLECATVAL (Oracle): role_catg_id (Unique ID), role_catg_short_name (Role Code Name), role_catg_name (Code Description), role_catg_type_id (Role Code ID), parent_role_catg_id (Parent Code), seq_num (Sort Order).

ROLERCAT (Oracle): role_id (Role ID), role_catg_type_id (Role Code ID), role_catg_id (Code Value).

See Role Codes Tag Roles, Not Resources.

ASGNMNTCATTYPE / ASGNMNTCATVAL / ASGNMNTACAT

Assignment-code dictionary, values, and assignments. Join is TASKRSRC, not RSRC.

ASGNMNTCATTYPE (Oracle): asgnmnt_catg_type_id (Unique Id), asgnmnt_catg_type (Assignment Code), asgnmnt_catg_short_len (Max Code Length), seq_num (Sort Order), super_flag (Secure Code).

ASGNMNTCATVAL (Oracle): asgnmnt_catg_id (Unique Id), asgnmnt_catg_short_name (Assignment Code Value), asgnmnt_catg_name (Code Description), asgnmnt_catg_type_id (Assignment Code), parent_asgnmnt_catg_id (Parent Code Value Id), seq_num (Sort Order).

ASGNMNTACAT (Oracle): taskrsrc_id (Activity Resource/Role Assignment), proj_id (Project), asgnmnt_catg_type_id (Assignment Code), asgnmnt_catg_id (Assignment Code Value).

See Assignment Codes Tag TASKRSRC, Not the Resource.

UMEASURE

Material unit-of-measure dictionary. Labor/nonlabor units are time, not this table. RSRC.unit_id points here.

UMEASURE (Oracle): unit_id (Unique ID), unit_name (Unit Name), unit_abbrev (Unit Abbreviation), seq_num (Sort Order).

See Units of Measure Label Material, Not Labor Time.

COSTTYPE

Expense-category dictionary. Flat. PROJCOST.cost_type_id points here. Not ACCOUNT.

COSTTYPE (Oracle): cost_type_id (Unique ID), cost_type (Expense Category), seq_num (Sort Order).

See Expense Categories Label Expenses, Not Cost Accounts.

CURRTYPE

Currency dictionary. Costs are stored in the base (rate 1.0). RSRC.curr_id is labeled Currency Name.

CURRTYPE (Oracle): curr_id (Unique ID), curr_short_name (Currency ID), curr_type (Currency Name), curr_symbol (Currency Symbol), base_exch_rate (Exchange Rate), decimal_digit_cnt (Number of Digits after Decimal), decimal_symbol (Decimal Symbol), digit_group_symbol (Digit Grouping Symbol), group_digit_cnt (Currency Group Digit Count), pos_curr_fmt_type (Positive Currency Format), neg_curr_fmt_type (Negative Currency Format).

See Costs Are Stored in the Base Currency. The Admin > Currencies dialog is not a table. See Currencies.

Rate types

Five Price/Unit slots. Titles are enterprise data, not a project-XER table. Assignment pick is TASKRSRC.rate_type. See Rate Types Are Five Named Price/Unit Slots.

DOCCATG / DOCSTAT

Document-category and document-status dictionaries. Flat. FKs on DOCUMENT.

DOCCATG (Oracle): doc_catg_id (Unique ID), doc_catg_name (Category), seq_num (Sort Order).

DOCSTAT (Oracle): doc_status_id (Unique ID), doc_status_code (Status Code), seq_num (Sort Order).

See Document Categories and Statuses Are Labels, Not Files.

WBSSTEP

WBS milestones. Weighted checkpoints on a WBS for performance percent complete. Not TASK start/finish milestones and not TASKPROC steps.

WBSSTEP (Oracle): wbs_step_id (Unique ID), wbs_id (WBS), proj_id (Project ID), step_name (WBS Milestone), step_wt (Weight), complete_flag (Completed), seq_num (Sort Order).

See WBS Milestones Are Weighted WBS Checkpoints, Not TASK Milestones.

Step templates

Reusable activity-step checklists (Enterprise Data / Enterprise → Activity Step Templates). No step-template table on the project XER map. Applied steps are TASKPROC. See Step Templates Are Reusable Checklists, Not TASKPROC Rows.

Resource / role teams

Named member groups for resource or role views (Global or User). Enterprise / administration data. No team table on the project XER map. Export is Download on the Administration teams tabs, not XER. See Resource and Role Teams Are View Groups, Not Resources.

Issue codes

Enterprise issue-code dictionary (Issue Codes page). No issue-code table on the project XER map. PROJISSU has no issue-code column. API: UDF codes are also known as issue codes; assign with UDFValue. See Issue Codes Tag Issues, Not Activities.

Future period buckets

Typed Planned / Remaining Early Units on an assignment (Manual curve). No dedicated future-period table on the project XER map. Oracle says a P6 Professional XER can import/export manual future period buckets. TASKRSRC.curv_id is Curve; target_crv / remain_crv / actual_crv are labeled Planned / Remaining / Actual Units Profile. Oracle does not say those columns are the typed buckets. Do not invent a bucket %T. See Future Period Buckets Are Typed Assignment Units, Not a Curve.

Publication

Project flags for EPPM Publication Services (reports / Extended Schema). Not Check Out, not Enable Summarization.

priority_num is Project Leveling Priority. See Publication.

High-level planning (WBSRSRC_QTY)

WBS/project resource-planning quantity rows. Not TASKRSRC and not WBSBUDG. No assignment-header table on the project XER map. Do not invent WBSRSRC / PROJWSRSRC / ProjectResource as an XER %T.

WBSRSRC_QTY (Oracle): fin_dates_id1 (fin_dates_id1), fin_dates_id2 (fin_dates_id2), fin_qty1 (fin_qty1), fin_qty2 (fin_qty2), month_start (Unique ID), qty (qty), week_start (Unique ID).

Oracle's API says ProjectResourceQuantity "corresponds to a record in the wbsrsrc_qty table." Oracle does not label qty as Total Units. PROJECT.fcst_start_date is Project Forecast Start. PROJECT.sum_assign_level is labeled sum_assign_level — Oracle did not say that is Summarize/Publish based on. See High-Level Planning Assignments Sit on WBS or Project, Not TASK.

Recalculate Assignment Costs

Command, not a table. Rewrites assignment costs from current resource/role prices. No RECALC table. PROJECT.cost_qty_recalc_flag is labeled Cost Qty Recalc Flag — Oracle did not say that is the command, Recalculate assignment costs after scheduling, or Calculate costs from units. PROJECT.act_this_per_link_flag is the required Calculations-tab option. TASKRSRC.cost_qty_link_flag is Calculate costs from units (assignment). The cited SCHEDOPTIONS map has no after-scheduling recalc column. See Recalculate Assignment Costs Rewrites Costs from Current Rates.

Professional reports

Stored report definitions (Tools > Reports / Report Wizard / Report Editor). Export is .ERP, not XER. No report table on the project XER map. Do not invent REPORT / RPT / ERP as an XER %T. See Professional Reports Are a Stored Definition, Not a Layout.

Update Progress

Command, not a table. Estimates on-schedule progress for spotlighted or selected activities. No UPDATEPROG table. After it runs you see dates, units, and a new data date. Do not invent a command %T. See Update Progress Estimates On-Schedule Progress for a New Data Date.

Update Baseline

Command, not a table. Merges selected current-project data into an existing baseline (Project > Maintain Baselines > Update). No UPDATEBASELINE / MAINTAIN table. PROJECT.last_baseline_update_date is Last Update Date. Do not invent a command %T. See Update Baseline Merges Selected Current-Project Data Into an Existing Baseline.

Schedule Log

Report/file written when you calculate the schedule (Tools > Schedule / Activities Schedule). No SCHEDLOG table. PROJECT.last_schedule_date is Last Scheduled Date (P6 EPPM only). Oracle did not say that column is the log. Do not invent a log %T. See Schedule Log.

Check Schedule

Health/quality report (Tools > Check Schedule Report / Actions > Check Schedule). No CHECKSCHED table. Oracle's project XER map TOC lists no Check Schedule table. UI settings are saved per project. Oracle did not name an XER column for those settings. SCHEDOPTIONS is Calculate schedule, not this report. Do not invent a check %T. See Check Schedule.

Trace Logic

Bottom-layout / Activities detail-window view of the selected activity's predecessors and successors. No TRACE / TRACELOGIC table. Oracle's project XER map TOC lists no Trace Logic table. Relationships are TASKPRED. TASK.driving_path_flag is Longest Path, not this view. Do not invent a view %T. See Trace Logic.

Progress Line

Gantt Chart decoration (Bar Chart Options / View > Progress line). No PROGRESSLINE / PROGLINE table. Oracle's project XER map TOC lists no Progress Line table. Do not invent a decoration %T. See Progress Line.

Dissolve

Command, not a table. Removes an activity and joins its predecessor and successor activities. No DISSOLVE table. Oracle's project XER map TOC lists no Dissolve table. After it runs you see TASK / TASKPRED changes. Do not invent a command %T. See Dissolve Removes an Activity and Joins Its Predecessors to Its Successors.

Curtain attachment

Gantt Chart decoration (View > Attachments / Layout Options bar → Attachments → Curtain). No CURTAIN / ATTACH table. Oracle's project XER map TOC lists no Curtain table. Do not invent a decoration %T. See Curtain Attachment.

Text attachment

Gantt Chart decoration (View > Attachments / Layout Options bar → Attachments → Text). No TEXT / ATTACH table. Oracle's project XER map TOC lists no Text attachment table. Do not invent a decoration %T. See Text Attachment.

Activity Network

Top-layout / Activities-page diagram of activities and relationships by WBS. No ACTIVITYNETWORK / ANP table. Oracle's project XER map TOC lists no Activity Network table. Relationships are TASKPRED. Box positions save as a separate .ANP file (Save/Open Network Positions), not in project XER. Do not invent a view %T. See Activity Network.

Activity Usage Spreadsheet

Top or bottom layout timescaled activity spreadsheet (View > Show on Top / Show on Bottom). No ACTIVITYUSAGE / ACTUSAGE / USAGE / SPREADSHEET table. Oracle's project XER map TOC lists no Activity Usage Spreadsheet table. Oracle: you cannot change the data in this view. Past-period actuals you can display are TASKFIN / TRSRCFIN. Typed buckets are not a dedicated table. Do not invent a view %T. See Activity Usage Spreadsheet.

Resource Usage Spreadsheet

Activities bottom layout or Resource Assignments Show on Top timescaled resource/role spreadsheet. No RESOURCEUSAGE / RSRCUSAGE / USAGE / SPREADSHEET table. Oracle's project XER map TOC lists no Resource Usage Spreadsheet table. Oracle: with privilege you can edit Budgeted or Planned Units and Remaining (Early) Units. Past-period actuals you can display are TASKFIN / TRSRCFIN. Typed buckets are not a dedicated table. Do not invent a view %T. See Resource Usage Spreadsheet.

Activity Usage Profile

Activities Show on Bottom histogram of activity units/cost (vertical bars and cumulative curves). No ACTIVITYUSAGE / ACTUSAGE / USAGE / PROFILE / HISTOGRAM table. Oracle's project XER map TOC lists no Activity Usage Profile table. Profile Options, timescale, and selected-activity vs all-activity are not columns on the cited TASK or TASKRSRC maps. Past-period actuals you can display are TASKFIN / TRSRCFIN. Typed buckets are not a dedicated table. Do not invent a view %T. See Activity Usage Profile.

Resource Usage Profile

Activities Show on Bottom histogram of resource/role units/cost (regular or stacked; limits / overallocation / availability). No RESOURCEUSAGE / RSRCUSAGE / USAGE / PROFILE / HISTOGRAM table. Oracle's project XER map TOC lists no Resource Usage Profile table. Profile Options, timescale, Show All Projects, Regular vs Stacked, and selected resource/role are not columns on the cited TASK or TASKRSRC maps. Past-period actuals you can display are TASKFIN / TRSRCFIN. Typed buckets are not a dedicated table. ROLELIMIT is Role Limits, not this view. Do not invent a view %T. See Resource Usage Profile.

Tracking

Professional Enterprise > Tracking window and its four layout types (Project Table, Project Bar Chart, Project Gantt/Profile, Resource Analysis). No TRACKING / TRACK / LAYOUT / PROFILE / HISTOGRAM table. Oracle's project XER map TOC lists no Tracking table. Layouts export as .PLF, not XER. PROJISSU.track_view_id and PROJTHRS.track_view_id are labeled Tracking Layout — a pointer on the issue/threshold, not the layout definition. Profile Settings, timescale, Project Explorer / Resource Explorer selection, Regular vs Stacked, and Top vs Bottom are not columns on the cited TASK or TASKRSRC maps. Do not invent a view %T. See Tracking.

Gantt bars

Layout bar definitions (View > Bars / Layout Options bar → Bars; Timescale / Filter / style / necking / labels). No BAR / BARS / GANTT / LAYOUT table. Oracle's project XER map TOC lists no Gantt-bar table. Layouts travel as .plf, not XER. Dates a bar can draw are ordinary TASK (or baseline-project) dates — not the bar list. Do not invent a bar %T. See Gantt Bars Are Layout Bar Definitions, Not an XER Table.

Sight Lines

Gantt Chart background gridlines (Bar Chart Options Sight Lines tab). No SIGHTLINE / SIGHT / GRIDLINE table. Oracle's project XER map TOC lists no Sight Lines table. Do not invent a decoration %T. See Sight Lines Are Gantt Background Gridlines, Not an XER Table.

Show Relationships

Gantt Chart decoration (Bar Chart Options General tab / Top Layout toolbar). No SHOWREL / RELLINE / RELATIONSHIPLINE table. Oracle's project XER map TOC lists no Show Relationships table. Relationships are TASKPRED. Do not invent a decoration %T. See Show Relationships.

Timescale

Gantt / profile / spreadsheet date-axis format (Layout Options bar → Timescale). No TIMESCALE / TIMESCL / DATEINTERVAL / ORDINAL / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Timescale table. Type, Date Interval, Timescale Start, Two/Three Lines, Shift Calendar, Financial Period Calendar, and ordinal dates are not columns on the cited maps. FINDATES is the financial-period calendar, not this dialog. CALENDAR is work time. SHIFT / SHIFTPER are resource-shift names — Oracle did not say Timescale Shift Calendar is that table. Layouts travel as .plf. Do not invent a view %T. See Timescale.

Group and Sort

Layout grouping bands and within-group sort (View > Group and Sort / Layout Options bar → Group and Sort). No GROUPANDSORT / GROUPSORT / GROUPBY / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Group and Sort table. Do not invent a grouping %T. Layouts travel as .plf. PROJWBS.seq_num is WBS Sort Order, not this dialog. See Group and Sort.

Columns

Layout column list (Available/Selected Options, Edit Column title/width/alignment, Copy From). No COLUMNS / COLUMN / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Columns table. Do not invent a column-list %T. Layouts travel as .plf. Fields a column can display are ordinary TASK (or other table) values — not this dialog. See Columns.

Non-work time shading

Gantt Chart decoration (EPPM Customize View → Gantt tab Non-work time shading; timescale background / global default calendar). No NONWORK / SHADING / NONWORKSHADING / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Non-work time shading table. CALENDAR is work time / exceptions, not this decoration. Do not invent a decoration %T. See Non-Work Time Shading.

Table Font and Row

Layout table appearance (View > Table Font and Row / Layout or Display Options bar → Table Font and Row; Font / Color / row height / Show Icons). No TABLEFONT / TABLE_FONT / ROWHEIGHT / FONT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Table Font and Row table. Layouts travel as .plf. Do not invent a font %T. See Table Font and Row.

Line Numbers

View decoration (View > Line Numbers / Layout toolbar; sequential visible-row column; hash/number-sign heading). No LINENUMBERS / LINENUM / LINE_NUMBERS / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Line Numbers table. Layouts travel as .plf. TASK.task_code is Activity ID, not this column. Do not invent a decoration %T. See Line Numbers.

Chart Font and Colors

Layout chart appearance (View > Chart Font and Colors / Display Options bar → Chart Font and Colors; Font / Back Color / Box Color). No CHARTFONT / CHART_FONT / BOXCOLOR / FONT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Chart Font and Colors table. Layouts travel as .plf. Do not invent a font %T. See Chart Font and Colors.

Show Legend

Gantt Chart decoration (Bar Chart Options General tab / View, Barchart Options). No LEGEND / SHOWLEGEND / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Show Legend table. Do not invent a decoration %T. Layouts travel as .plf. See Show Legend.

Attach Notebook

Gantt Chart decoration (Bars → Bar Labels; pick a notebook item as a bar label). No ATTACHNOTEBOOK / ATTACH / BARLABEL / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Attach Notebook table. MEMOTYPE / TASKMEMO / WBSMEMO are notebook data, not this bar-label. Do not invent a decoration %T. Layouts travel as .plf. See Attach Notebook.

Collapsed Bars

Gantt Chart decoration (Bar Chart Options Collapsed Bars tab). No COLLAPSEDBARS / COLLAPSE / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Collapsed Bars table. Do not invent a decoration %T. Layouts travel as .plf. See Collapsed Bars.

Chart Box Template

Layout chart-box field list (View > Chart Box Template / Top Layout toolbar; apply an existing template or customize). No CHARTBOX / CHART_BOX / BOXTEMPLATE / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Chart Box Template table. Do not invent a template %T. Layouts travel as .plf. Activity Network box positions are .ANP, not this command. See Chart Box Template.

Arrange Children / Align Children

Layout chart-box placement (View > Arrange Children / Align Children / Top Layout toolbar; horizontally or vertically; left, right, or center). No ARRANGE / ALIGN / ARRANGECHILDREN / ALIGNCHILDREN / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Arrange Children or Align Children table. Do not invent a placement %T. Layouts travel as .plf. Activity Network box positions are .ANP, not this command. See Arrange Children / Align Children.

Data Date line

Gantt Chart decoration (Bar Chart Options Data Date tab; Style / Size / Color). No DATADATELINE / DATADATE / DATELINE table. Oracle's project XER map TOC lists no Data Date line table. PROJECT.last_recalc_date is Last Recalc Date — the as-of date, not this decoration. Do not invent a decoration %T. Layouts travel as .plf. See Data Date Line.

Zoom to Best Fit

Layout command (View > Zoom > Zoom to Best Fit / Display toolbar; resizes a chart view to the visible area). No ZOOM / ZOOMBESTFIT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Zoom table. Do not invent a zoom %T. Layouts travel as .plf. See Zoom to Best Fit.

Limit Text Label Characters

Gantt Chart decoration (Bar Chart Options General tab; maximum characters, including spaces, for text labels on individual bars). No LIMITTEXT / TEXTLABEL / BARLABEL / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Limit Text Label Characters table. Do not invent a decoration %T. Layouts travel as .plf. See Limit Text Label Characters.

Default Size for Notebook Items

Gantt Chart decoration (Bar Chart Options General tab; Width / Height for notebook items displayed on the Gantt). No DEFAULTSIZE / NOTEBOOKSIZE / GANTT / LAYOUT / VIEW table. Oracle's project XER map TOC lists no Default Size table. MEMOTYPE / TASKMEMO / WBSMEMO are notebook data, not this Width/Height. Do not invent a decoration %T. Layouts travel as .plf. See Default Size for Notebook Items.

Fill Down

Command, not a table. Copies text from the first selected row to other selected rows in a column (Edit > Fill Down). No FILLDOWN / FILL / FILL_DOWN table. Oracle's project XER map TOC lists no Fill Down table. After it runs you see changed field values on the filled rows. Do not invent a command %T. See Fill Down Copies First-Selected-Row Text Down a Table Column.

User Preferences

Per-user dialog (Edit > User Preferences). Display of time, date, and currency; session options. No USERPREF / USERPREFERENCES / USERDATA table on the project XER map. Do not invent a preferences %T. View currency is not CURRTYPE. See User Preferences.

Admin Preferences

Enterprise dialog (Admin > Admin Preferences). Application-wide defaults. No ADMINPREF / ADMINPREFERENCES table on the project XER map. Do not invent a preferences %T. WBS EV technique columns are PROJWBS, not this dialog. See Admin Preferences.

Admin Categories

Enterprise dialog (Admin > Admin Categories). Standard category dictionaries. No ADMINCAT / ADMINCATEGORIES table on the project XER map. Do not invent a dialog %T. Dictionaries Oracle names on the project map: COSTTYPE, DOCCATG, DOCSTAT, MEMOTYPE, PHASE, RISKTYPE, UMEASURE. No BASETYPE table. PROJECT.base_type_id is Baseline Type. See Admin Categories, Expense Categories Label Expenses, Not Cost Accounts, Document Categories and Statuses Are Labels, Not Files, Notebooks (MEMOTYPE / TASKMEMO / WBSMEMO) — Not Schedule Logic, WBS Category, Risks Are Uncertain Events, Not Issues or Thresholds, Units of Measure Label Material, Not Labor Time.

Security Profiles

Enterprise dialog (Admin > Security Profiles). Global and project privilege sets. No PROFILE / SECURITY / SECURITYPROFILE / USERS table on the project XER map. Do not invent a profile %T. Assignment is Admin > Users, not this dialog. OBS is the OBS tree. TASKUSER is Activity Owners. See Security Profiles.

Users

Enterprise dialog (Admin > Users). Login accounts; Global Access / Project Access / Module Access. No USERS / USER table on the project XER map. Do not invent a user %T. TASKUSER is Activity Owners, not this dialog. RSRC.user_id is User Login Name (resource-to-user link). Assignment of a profile is this dialog; the privilege set is Admin > Security Profiles. See Users.

Currencies (Admin > Currencies)

Enterprise dialog (Admin > Currencies). Currency dictionary (base + additional view currencies). No ADMINCURRENCIES / ADMIN_CURR table. The dictionary is CURRTYPE — see Costs Are Stored in the Base Currency. Do not invent a dialog %T. View currency is User Preferences Currency tab, not this dialog. See Currencies.

Job Services

Interval scheduler (Tools > Job Services). Apply Actuals, Batch Reports, Export, Schedule, Summarize. No JOBSERV / JOB / JOBSERVICE table on the project XER map. Do not invent a job %T. APPLYACTOPTIONS is Apply Actual Options, not this dialog. See Job Services.

Send Project

Command (File > Send Project). Creates a project XER and attaches it to email. No SENDPROJECT / SEND / EMAIL table on the project XER map. Do not invent a command %T. The file is a normal project XER. See Send Project Creates an XER and Emails It; It.

Import

Command/wizard (File > Import). Reads formats Oracle names (Primavera PM XER, Primavera P6 XML, Microsoft Project XML, MPX, Spreadsheet XLSX). No IMPORT / IMPORTWIZARD table on the project XER map. Do not invent a wizard %T. The file is a normal project XER (or another format Oracle named). See File > Import Starts the Import Wizard; It.

Export

Command/wizard (File > Export). Writes formats Oracle names (Primavera PM XER, Primavera P6 XML, Microsoft Project XML, MPX, Spreadsheet XLSX, UN/CEFACT, IPMDAR, CPP, Contractor XER). No EXPORT / EXPORTWIZARD table on the project XER map. Do not invent a wizard %T. The file is a normal project XER (or another format Oracle named). See File > Export Starts the Export Wizard; It.

Copy Project

Command (Edit > Copy / Paste of a project; Copy Project Options). Creates another PROJECT. No COPYPROJECT / COPYPROJ / COPY_PROJECT table on the project XER map. Do not invent a command %T. After it runs you see another project. See Copy Project.

Copy WBS

Command (Edit > Copy / Paste of a WBS element; Copy WBS Options). Creates another PROJWBS (and TASK rows if Activities is marked). No COPYWBS / COPY_WBS table on the project XER map. Do not invent a command %T. After it runs you see another WBS. See Copy WBS.

Copy Activity

Command (Edit > Copy / Paste of activities; Copy Activity Options). Creates another TASK. No COPYACTIVITY / COPYACT / COPY_ACTIVITY table on the project XER map. Do not invent a command %T. After it runs you see another activity. See Copy Activity.

Cut Activity

Command (Edit > Cut / Paste of activities). Moves an activity. No CUTACTIVITY / CUTACT / CUT_ACTIVITY table on the project XER map. Do not invent a command %T. After it runs you see the activity in the paste target. See Cut Activity.

Cut WBS

Command (Edit > Cut / Paste of a WBS element). Moves a WBS. No CUTWBS / CUT_WBS / CUTWBSOPTIONS table on the project XER map. Do not invent a command %T. After it runs you see the WBS in the paste target. See Cut WBS.

Delete WBS

Command (Edit > Delete of a WBS element; Merge or Delete WBS Element(s)). Removes a PROJWBS row (and TASK rows, or reassigns TASK.wbs_id to the parent if Merge). No DELETEWBS / DELETE_WBS / DELWBS / MERGEWBS / MERGE_WBS table on the project XER map. Do not invent a command %T. After it runs the WBS is gone. See Delete WBS.

Delete Activity

Command (Edit > Delete of an activity). Removes a TASK. No DELETEACTIVITY / DELACT / DELETE_ACTIVITY / DELETEACT table on the project XER map. Do not invent a command %T. After it runs the activity is gone. See Delete Activity.

Add WBS from Template

Command (EPPM Activities Context / Row Actions Add WBS from Template; Select WBS; Copy WBS Options). Creates another PROJWBS (and any TASK rows that came with the included data). No ADDWBSFROMTEMPLATE / COPYWBSFROMTEMPLATE / WBSTEMPLATE / WBSFROMTEMPLATE table on the project XER map. Do not invent a command %T. After it runs you see another WBS. See Add WBS from Template.

Add WBS

Command (Project > WBS; Edit > Add of a WBS element). Creates another PROJWBS as a child of the selected node (indented one level). No ADDWBS / ADD_WBS / ADDWBSELEMENT table on the project XER map. Do not invent a command %T. After it runs you see another WBS. See Add WBS.

Edit WBS

Command (Project > WBS select; Move toolbar and/or WBS Details). Changes a PROJWBS row. No EDITWBS / EDIT_WBS table on the project XER map. Do not invent a command %T. After it runs you see a changed WBS. See Edit WBS.

Add Activity

Command (Project > Activities; Edit > Add of an activity in the Activity Table or Activity Network; optional New Activity wizard). Creates another TASK. No ADDACTIVITY / ADDACT / ADD_ACTIVITY / NEWACTIVITY / NEWACT table on the project XER map. Do not invent a command %T. After it runs you see another activity. See Add Activity.

Renumber Activity IDs

Command (Edit > Renumber Activity IDs of selected activities). Rewrites TASK.task_code (Activity ID). No RENUMBER / RENUMBERACTIVITY / RENUMBER_ACTIVITY_IDS / RENUMBERACT / RENUMID table on the project XER map. Do not invent a command %T. After it runs you see changed Activity IDs. See Renumber Activity Ids.

Change an activity's WBS assignment

Command (Project, Activities; Activity Details General tab WBS; Select). Changes TASK.wbs_id. No CHANGEWBS / CHANGE_WBS / CHANGEACTWBS / CHANGEACTIVITYWBS table on the project XER map. Do not invent a command %T. After it runs you see a changed owning WBS. See Change an Activity's WBS Assignment.

Edit Activity

Command (Define general activity information / Change activity information in the Activity Table). Changes TASK fields. No EDITACTIVITY / EDITACT / EDIT_ACTIVITY / DEFINEGENERAL / CHANGEACTIVITY / CHANGEACT table on the project XER map. Do not invent a command %T. After it runs you see changed activity fields. See Edit Activity.

Link Activities

Command (Edit > Link Activities of selected activities in the Activity Table or Activity Network). Creates finish-to-start TASKPRED rows in listed order. No LINKACTIVITIES / LINKACT / LINK_ACTIVITIES / LINKSELECTED / LINK_SELECTED_ACTIVITIES table on the project XER map. Do not invent a command %T. After it runs you see another relationship. See Link Activities.

Unlink Activities

Command (Edit > Unlink Activities). Removes relationships between the selected activities. No UNLINK / UNLINKACTIVITIES / UNLINK_ACTIVITIES / UNLINKACT table on the project XER map. Do not invent a command %T. After it runs you see missing TASKPRED rows. A Viewer cannot tell this command from Remove predecessor. See Unlink Activities.

Assign Predecessors

Command (Edit > Assign > Predecessors / Add predecessor relationships; Assign Predecessors dialog). Creates TASKPRED rows (pred_task_id = predecessor, task_id = successor). No ASSIGNPRED / ASSIGNPREDECESSOR / ASSIGNPREDECESSORS / ASSIGN_PRED / ASSIGN_PREDECESSORS table on the project XER map. Do not invent a command %T. After it runs you see another relationship. See Assign Predecessors.

Assign Successors

Command (Edit > Assign > Successors / Activity Details Assign). Creates a TASKPRED row. No ASSIGNSUCC / ASSIGNSUCCESSOR / ASSIGN_SUCC table on the project XER map. Do not invent a command %T. After it runs you see a new successor. See Assign Successors.

Change predecessor relationships

Command (Project, Activities; Activity Details Predecessors or Relationships tab; Assign / double-click Relationship Type or Lag / Remove). Changes a TASKPRED row (or adds/removes one). No CHANGEPRED / CHANGEPREDECESSOR / CHANGE_PRED / CHANGEPREDECESSORRELATIONSHIPS table on the project XER map. Do not invent a command %T. After it runs you see a changed (or new or missing) TASKPRED. A Viewer cannot tell this command from Add predecessor, Remove predecessor, Assign Predecessors, or Edit relationships in the Gantt Chart / Activity Network. See Change Predecessor Relationships.

Remove predecessor relationships

Command (Project, Activities; Activity Details Predecessors or Relationships tab; select the predecessor; Remove; Yes). Removes a TASKPRED row. No REMOVEPRED / REMOVEPREDECESSOR / REMOVE_PRED / REMOVEPREDECESSORRELATIONSHIPS table on the project XER map. Do not invent a command %T. After it runs you see a missing TASKPRED. A Viewer cannot tell this command from Unlink, Change predecessor Remove, Gantt delete, Network delete, or Assign Predecessors Remove. See Remove Predecessor Relationships.

Display the Activity Network

How-to (View, Show on Top, Activity Network / Layout Options bar / Top Layout toolbar). Opens the view. Does not write TASKPRED. No DISPLAYNETWORK / DISPLAYACTNETWORK / ACTIVITYNETWORK / ANP / NETWORK / LAYOUT table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to or had Show on Top set to Activity Network. See Display the Activity Network.

Display Trace Logic

How-to (View, Show on Bottom, Trace Logic / Layout Options bar / Bottom Layout toolbar). Opens the view. Does not write TASKPRED. No DISPLAYTRACE / DISPLAY_TRACE_LOGIC / TRACE / TRACELOGIC / TRACE_LOGIC table on the project XER map. Do not invent a command %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to. See Display Trace Logic.

Set Trace Logic preferences

How-to (View, Bottom Layout Options; predecessor count; successor count; Apply). Does not write TASKPRED. No TRACEPREF / TRACELEVEL / SETTRACE table on the project XER map. Do not invent a command %T. See Set Trace Logic Preferences.

Display the Gantt Chart

How-to (View, Show on Top or Show on Bottom, Gantt Chart / Layout Options bar / Top Layout toolbar). Opens the view. Does not write TASKPRED. No DISPLAYGANTT / DISPLAY_GANTT_CHART / GANTT / GANTTCHART / LAYOUT table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to or had Show on Top or Show on Bottom set to Gantt Chart. See Display the Gantt Chart.

Display the Activity Table

How-to / view object (View > Show on Top > Table / Top Layout toolbar; The Activity Table). Opens the table. Oracle does not print a Display the Activity Table how-to. Does not write TASKPRED. No DISPLAYTABLE / DISPLAY_ACTIVITY_TABLE / ACTIVITYTABLE / TABLE / LAYOUT table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used Show on Top Table. See Display the Activity Table.

Dissolve an activity

How-to (Edit, Dissolve of an activity). Removes a TASK and joins predecessor and successor activities. No DISSOLVEACTIVITY / DISSOLVE_ACTIVITY / DISSOLVACT table on the project XER map. Do not invent a command %T. After it runs you see a missing TASK and rewritten TASKPRED. A Viewer cannot tell this how-to from Delete. See Dissolve an Activity.

The Activity Table

View object (table-format activity list). Show or hide: Top Layout toolbar table-view icon; View > Show on Top > Table. Oracle does not print Display the Activity Table. No ACTIVITYTABLE / ACTTABLE / TABLE / LAYOUT / DISPLAYTABLE table on the project XER map. Do not invent a view %T. Showing or hiding the table does not write TASK. See Display the Activity Table.

Define Activity Table columns

How-to (View, Columns / Layout Options bar → Columns; Available Columns / Selected Options; OK or Apply). Does not write TASK. No COLUMNS / ACTCOLUMNS / TABLECOLUMNS / LAYOUT / DISPLAYCOLUMNS table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used this how-to. See Define Activity Table Columns.

Customize activity column titles

How-to (View, Columns / Layout Options bar → Columns; Edit Column; a new title; OK or Apply). Does not write TASK. No COLUMNTITLE / COLTITLE / EDITCOLUMN / LAYOUTTITLE table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used this how-to. See Customize Activity Column Titles.

Change activity information in the Activity Table

How-to (double-click the information you want to change). May change TASK fields. No CHANGEACT / EDITTABLE / TABLEEDIT table on the project XER map. Do not invent a command %T. A Viewer cannot tell this how-to from Details edit, import, or Global Change. See Change Activity Information in the Activity Table.

Sort activity information in the Activity Table

How-to (click a column label; up arrow ascending / down arrow descending). Does not write TASK. No SORT / SORTACT / TABLESORTED / LAYOUTSORT table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used this how-to. See Sort Activity Information in the Activity Table.

Change group row fonts and colors

How-to (View, Group and Sort / Layout Options bar → Group and Sort; Font & Color cell; Font or Color). Does not write TASK. No GROUPFONT / GROUPCOLOR / FONCOLOR / LAYOUTGROUP table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used this how-to. See Change Group Row Fonts and Colors.

Change Activity Table font, color, and row height

How-to (View, Table Font and Row; Font; Color; Row Height; Show Icons; OK). Does not write TASK. No TABLEFONT / TABLEROW / FONTROW / LAYOUTFONT table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used this how-to. See Change Activity Table Font, Color, and Row Height.

Move around a Gantt Chart

How-to (drag major timescale unit to pan; drag minor unit to expand or contract; horizontal scroll bar). Does not write TASK. No MOVEGANTT / PAN / TIMESCROLL / LAYOUTPAN table on the project XER map. Do not invent a view %T. A Viewer cannot reconstruct that the planner used this how-to. See Move Around a Gantt Chart.

Add a bar to the Gantt Chart

How-to (View, Bars / Layout Options bar → Bars; Add; Display; name; Timescale; Filter; Bar Style / Settings / Labels; Apply). Does not write TASK. No GANTTBAR / ADDBAR / BARSTYLE / LAYOUTBAR table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Add a Bar to the Gantt Chart.

Change a bar in the Gantt Chart

How-to (View, Bars / Layout Options bar → Bars; Display; Name; Timescale; Filter; Bar Style / Settings / Labels; OK or Apply). Does not write TASK. No CHANGEBAR / GANTTBAR / BARSTYLE / LAYOUTBAR table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change a Bar in the Gantt Chart.

Apply Gantt Chart settings from another layout

How-to (View, Bars / Layout Options bar → Bars; Copy From; Apply or Open). Does not write TASK. No COPYFROM / APPLYGANTT / LAYOUTCOPY / GANTTCOPY table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Apply Gantt Chart Settings from Another Layout.

Position a bar in the Gantt Chart

How-to (View, Bars / Layout Options bar → Bars; Bar Style; Options row; OK or Apply). Does not write TASK. No BARROW / BARPOSITION / GANTTROW / LAYOUTBAR table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Position a Bar in the Gantt Chart.

Change the background lines in the Gantt Chart

How-to (View, Bars / Layout Options bar → Bars; Options; Sight Lines; Horizontal / Vertical checkboxes; Apply). Does not write TASK. No SIGHTLINE / BACKGROUNDLINE / GANTTLINE / LAYOUTSIGHT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change the Background Lines in the Gantt Chart.

Show or hide the Gantt Chart legend

How-to (View, Barchart Options; General; Show Legend; OK or Apply). Does not write TASK. No LEGEND / SHOWLEGEND / GANTTLEGEND / LAYOUTLEGEND table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Show or Hide the Gantt Chart Legend.

Show or hide relationship lines in the Gantt Chart

How-to (View, Barchart Options; Options; General; Show Relationships; OK or Apply; or Top Layout toolbar). Does not write TASKPRED. No SHOWREL / SHOWRELATIONSHIPS / RELLINE / LAYOUTREL table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. See Show or Hide Relationship Lines in the Gantt Chart.

Customize the data date line

How-to (View, Bars / Layout Options bar → Bars; Options; Data Date; Style / Size / Color; OK or Apply). Does not write TASK. The date is PROJECT.last_recalc_date. No DATADATELINE / DDLINE / LAYOUTDD table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Customize the Data Date Line.

Change a Gantt Chart bar's filter

How-to (View, Bars; Filter column; mark checkboxes; OK or Apply. Gantt Chart sibling also: Layout Options bar → Bars; Modify on user-defined filters). Does not write TASK. No BARFILTER / GANTTFILTER / FILTERBAR table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change a Gantt Chart Bar's Filter.

Change a Gantt Chart bar's label

How-to (Bar Labels tab; Add / Delete; Position and Label; OK or Apply. One page: View, Top Layout Options, Bars. Gantt Chart sibling: View, Bars / Layout Options bar). Does not write TASK. No BARLABEL / GANTTLABEL / LAYOUTLABEL table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change a Gantt Chart Bar's Label.

Change a Gantt Chart bar's settings

How-to (View, Bars / Layout Options bar → Bars; Bar Settings; Show bar when collapsed; Show bar for grouping bands; Calendar nonwork time; Activity nonwork intervals; OK or Apply). Does not write TASK. No BARSETTINGS / NECKING / SHOWBARCOLLAPSED table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change a Gantt Chart Bar's Settings.

Change a Gantt Chart bar's style

How-to (Bar Style tab; shape, color, pattern, row; OK or Apply. One page: View, Top Layout Options, Bars. Gantt Chart sibling: View, Bars / Layout Options bar). Does not write TASK. No BARSTYLE / GANTTSTYLE / BARSHAPE table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change a Gantt Chart Bar's Style.

Change a Gantt Chart bar's timescale

How-to (Timescale column. One page: View, Top Layout Options, Bars; Apply only; value-to-bar table. Gantt Chart sibling: View, Bars / Layout Options bar; OK or Apply). Does not write TASK. No BARTIMESCALE / GANTTTIMESCALE / BARTYPE table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Change a Gantt Chart Bar's Timescale.

Move to a specific activity in the Gantt Chart

How-to (double-click in the Gantt Chart next to the activity). Does not write TASK. No MOVETO / JUMPTO / GOTOBAR table on the project XER map. Do not invent a view %T. See Move to a Specific Activity in the Gantt Chart.

Change an activity's start and finish dates in the Gantt Chart

How-to (hand pointer on the bar end; drag left or right; duration unchanged; Yes on constraint Confirmation). Writes activity dates (and may write a constraint). No GANTTDRAG / MOVEDATES table on the project XER map. Do not invent a view %T. See Change an Activity's Start and Finish Dates in the Gantt Chart.

Delete a bar from the Gantt Chart

How-to (View, Bars; select the bar; Delete. TOC page also: Layout Options bar → Bars. Working-with sibling: Display the Gantt Chart, then View, Bars. Tip: clear Display to hide without deleting). Does not write TASK. No DELETEBAR / GANTTBAR / LAYOUTBAR table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Delete a Bar from the Gantt Chart.

Change an activity's duration in the Gantt Chart

How-to (double-ended arrow on the right end; drag right to increase, left to decrease). Writes activity duration (and may write units). No GANTTDURATION / DRAGDURATION table on the project XER map. Do not invent a view %T. See Change an Activity's Duration in the Gantt Chart.

Add a curtain attachment in a Gantt Chart

How-to (Layout Options bar → Attachments, Curtain, Add Curtain; Display; Start / Finish; color; fill pattern; OK). Does not write TASK. No CURTAIN / ATTACH / ATTACHMENT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Add a Curtain Attachment in a Gantt Chart.

Hide a curtain attachment in a Gantt Chart

How-to (double-click the curtain; clear Display; OK). Hide does not delete. Does not write TASK. No CURTAIN / HIDECURTAIN table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Hide a Curtain Attachment in a Gantt Chart.

Add a text attachment to a Gantt Chart

How-to (Layout Options bar → Attachments, Text; Font; OK). Does not write TASK. No TEXT / ATTACH / ATTACHMENT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Add a Text Attachment to a Gantt Chart.

Remove a text attachment from a Gantt Chart

How-to (click the text attachment; press Delete). Does not write TASK. No TEXT / REMOVETEXT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Remove a Text Attachment from a Gantt Chart.

Attach notebook items to bars in a Gantt Chart

How-to (Layout Options bar → Bars; Bar Labels; Add; Label = notebook item; Click options for dimensions). Does not write TASK. MEMOTYPE / TASKMEMO are notebook data, not this decoration. No ATTACHNOTEBOOK / BARLABEL table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Attach Notebook Items to Bars in a Gantt Chart.

Hide all curtain attachments in the Gantt Chart

How-to (Layout Options bar → Attachments, Curtain, Hide All). Hide does not delete. Does not write TASK. No CURTAIN / HIDEALL table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Hide All Curtain Attachments in the Gantt Chart.

Delete a curtain attachment from a Gantt Chart

How-to (double-click the curtain; Delete; save the layout or it stays). Does not write TASK. No CURTAIN / DELETECURTAIN table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Delete a Curtain Attachment from a Gantt Chart.

Display all curtain attachments in the Gantt Chart

How-to (Layout Options bar → Attachments, Curtain, Show All). Does not write TASK. No CURTAIN / SHOWALL table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Display All Curtain Attachments in the Gantt Chart.

Apply a Progress Line to the Gantt Chart

How-to (View, Bar Chart Options; Progress Line tab; OK; View, Progress line). Does not write TASK. No PROGRESSLINE / PROGLINE table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Apply a Progress Line to the Gantt Chart.

Display the Activity Usage Profile

How-to (View, Show on Bottom, Activity Usage Profile; or Layout Options bar → Show on Bottom; or Bottom Layout toolbar). Does not write TASK. No ACTUSAGE / PROFILE / HISTOGRAM table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Display the Activity Usage Profile.

Define the Activity Usage Profile

How-to (Display Options bar / right-click → Activity Usage Profile Options; Data and Graph; Apply or OK). Does not write TASK. No ACTUSAGE / PROFILEOPTIONS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Define the Activity Usage Profile.

Show or hide the profile legend in the histogram

How-to (Display Options bar / right-click → the Profile Options; Graph; Show Legend). Does not write TASK. No PROFILELEGEND table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Show or Hide the Profile Legend in the Histogram.

Display the Resource Usage Profile

How-to (View, Show on Bottom, Resource Usage Profile; or Layout Options bar → Show on Bottom; or Bottom Layout toolbar). Does not write TASK. No RSRUSAGE / PROFILE / HISTOGRAM table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Display the Resource Usage Profile.

Define the Resource Usage Profile

How-to (Display Options bar → Resource Usage Profile Options; Stacked: choose Stacked Histogram first). Regular vs Stacked options are separate how-tos. Does not write TASK. No RSRUSAGE / PROFILEOPTIONS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Define the Resource Usage Profile.

Define the Resource Usage Profile - Regular Histogram

How-to (Resource Usage Profile Options; Data and Graph; Preferences → Resource Analysis). Does not write TASK. No RSRUSAGE / REGULARHIST table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Define the Resource Usage Profile - Regular Histogram.

Define the Resource Usage Profile - Stacked Histogram

How-to (Resource Usage Profile Options; Data and Graph; Preferences → Resource Analysis). Does not write TASK. No RSRUSAGE / STACKEDHIST table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Define the Resource Usage Profile - Stacked Histogram.

View a profile of resource allocation across all projects

How-to (View, Show on Bottom, Resource Usage Profile; right pane Display Options bar → Show All Projects). Does not write TASK. No RSRUSAGE / SHOWALLPROJECTS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See View a Profile of Resource Allocation Across All Projects.

View a profile of resource allocation for a specific project

How-to (View, Show on Bottom, Resource Usage Profile; right pane Display Options bar, Show All Projects not selected). Does not write TASK. No RSRUSAGE / OPENPROJECTS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See View a Profile of Resource Allocation for a Specific Project.

Show or hide resource limits in the Resource Usage Profile

How-to (Resource Usage Profile Options; Data tab; Additional Data Options: Show Limit and Show Allocated Limit). Does not write TASK. No RSRUSAGE / SHOWLIMIT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Show or Hide Resource Limits in the Resource Usage Profile.

Show or hide resource overallocation in the Resource Usage Profile

How-to (Resource Usage Profile Options; Data tab; Additional Data Options: Show Limit and Show Overallocation). Does not write TASK. No RSRUSAGE / SHOWOVERALLOC table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Show or Hide Resource Overallocation in the Resource Usage Profile.

Show or hide resource availability in the Resource Usage Profile

How-to (Show All Projects; Resource Usage Profile Options; Data tab; Additional Data Options: Show Available Units). Does not write TASK. No RSRUSAGE / SHOWAVAIL table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Show or Hide Resource Availability in the Resource Usage Profile.

Show or hide overtime information in the Resource Usage Profile

How-to (Show All Projects not selected; Resource Usage Profile Options; Data tab; Show Overtime). Does not write TASK. No RSRUSAGE / SHOWOVERTIME table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Show or Hide Overtime Information in the Resource Usage Profile.

Filter activities according to the Resource Usage Profile

How-to (left pane Display Activities for Selected: Resource or Time Period). Does not write TASK. No RSRUSAGE / DISPLAYACTS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Filter Activities According to the Resource Usage Profile.

Display the Resource Usage Spreadsheet

How-to (Activities: View, Show on Bottom, Resource Usage Spreadsheet; Resource Assignments: View, Show on Top, Resource Usage Spreadsheet). Does not write TASK. No RESOURCEUSAGE / SPREADSHEET table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Display the Resource Usage Spreadsheet.

Display roles in the Resource Usage Spreadsheet

How-to (Activities; left-pane Display Options bar → Select View, By Role; all-projects only). Does not write TASK. No RESOURCEUSAGE / BYROLE table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Display Roles in the Resource Usage Spreadsheet.

Select resources or roles for the Resource Usage Spreadsheet

How-to (left pane select resource or role; Shift contiguous; Ctrl noncontiguous). Does not write TASK. No RESOURCEUSAGE / SELECTRSRC table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Select Resources or Roles for the Resource Usage Spreadsheet.

View a spreadsheet of resource allocation across all projects

How-to (View, Show on Bottom, Resource Usage Spreadsheet; right pane Display Options bar → Show All Projects). Does not write TASK. No RESOURCEUSAGE / SHOWALLPROJECTS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See View a Spreadsheet of Resource Allocation Across All Projects.

View a spreadsheet of resource allocation for a specific project

How-to (Activities: Show on Bottom, Show All Projects not selected; Resource Assignments: View, Resource Usage Spreadsheet). Does not write TASK. No RESOURCEUSAGE / OPENPROJECTS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See View a Spreadsheet of Resource Allocation for a Specific Project.

View a spreadsheet of resource overallocation across all projects

How-to (Show All Projects; Spreadsheet Fields, Customize; Overallocated Early Units and/or Overallocated Late Units; Ok). Does not write TASK. No RESOURCEUSAGE / OVERALLOC table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See View a Spreadsheet of Resource Overallocation Across All Projects.

Filter activities according to the Resource Usage Spreadsheet

How-to (left pane Display Activities for Selected: Resource or Assignments). Does not write TASK. No RESOURCEUSAGE / DISPLAYACTS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Filter Activities According to the Resource Usage Spreadsheet.

Customize Resource Usage Spreadsheet columns

How-to (Activities: Columns, Customize on left/middle panes; Resource Assignments: Spreadsheet Fields, Customize; OK / Apply / Default). Does not write TASK. No RESOURCEUSAGE / RUSCOLS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Customize Resource Usage Spreadsheet Columns.

Select Resource Usage Spreadsheet fields

How-to (right-click → Spreadsheet Fields; predefined or Customize). Does not write TASK. No RESOURCEUSAGE / RUSFIELDS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Select Resource Usage Spreadsheet Fields.

Resize the panes of the Resource Usage Spreadsheet

How-to (drag the split bar left or right). Does not write TASK. No RESOURCEUSAGE / RUSPANES table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Resize the Panes of the Resource Usage Spreadsheet.

Group and sort Resource Usage Spreadsheet columns in the Activities window

How-to (left or middle pane Display Options bar → Group and Sort By; predefined or Customize). Does not write TASK. No RESOURCEUSAGE / RUSGROUPSORT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Group and Sort Resource Usage Spreadsheet Columns in the Activities Window.

Group and sort Resource Usage Spreadsheet columns in the Resource Assignments window

How-to (Activity Resource Assignments layout; Display Options bar → Group and Sort By; predefined or Customize). Does not write TASK. No RESOURCEUSAGE / RUSGROUPSORT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Group and Sort Resource Usage Spreadsheet Columns in the Resource Assignments Window Is Display Options Bar, Group and Sort By.

Copy and paste resource spreadsheet data to Microsoft Excel

How-to (Project, Resource Assignments; Edit, Copy; Excel Paste). Does not write TASK. Reporting only. No RESOURCEUSAGE / EXCELPASTE table on the project XER map. Do not invent a view %T. See Copy and Paste Resource Spreadsheet Data to Microsoft Excel.

Copy and paste data from Microsoft Excel into P6 Professional

How-to (right-click Range Paste). Does not invent a RANGEPASTE XER table. Do not invent a view %T. See Copy and Paste Data from Microsoft Excel Into P6 Professional.

Display the Activity Usage Spreadsheet

How-to (Activities: View, Show on Top or Show on Bottom, Activity Usage Spreadsheet). Does not write TASK. No ACTUSAGE / SPREADSHEET table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Display the Activity Usage Spreadsheet.

Customize Activity Usage Spreadsheet columns

How-to (display the spreadsheet; View, Columns; left pane; OK / Apply / Default). Does not write TASK. No ACTUSAGE / AUSCOLS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Customize Activity Usage Spreadsheet Columns.

Select Activity Usage Spreadsheet fields

How-to (right-click → Spreadsheet Fields; Available Options / Selected Options; OK / Apply / Default). Does not write TASK. No ACTUSAGE / AUSFIELDS table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Select Activity Usage Spreadsheet Fields.

Open a tracking layout

How-to (Enterprise, Tracking; View, Layout, Open; or Display Options bar in the Layout window, Layout, Open; OK). Does not write TASK. No TRACKING / LAYOUT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Open a Tracking Layout.

Types of tracking layouts

How-to (catalog: Project Table, Project Bar Chart, Project Gantt/Profile, Resource Analysis). Does not write TASK. No TRACKING / LAYOUT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Types of Tracking Layouts.

Share a layout with other users

How-to (All Users on first create, Tracking only; save existing as All Users or Another User; export then Email; or publish). Does not write TASK. No TRACKING / LAYOUT / SHARE table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Share a Layout With Other Users.

Save a tracking layout

How-to (View, Layout, Save or Save As; or Display Options bar in the Layout window, Layout, Save or Save As; Save As: All Users, Current User, or Another User). Does not write TASK. No TRACKING / LAYOUT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Save a Tracking Layout.

Export a tracking layout

How-to (View, Layout, Open; or Display Options bar in the Layout window, Layout, Open; Export; Save; Primavera Layout File .PLF). Does not write TASK. No TRACKING / LAYOUT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Export a Tracking Layout Writes a Primavera Layout File (.plf).

Import a tracking layout

How-to (View, Layout, Open; or Display Options bar in the Layout window, Layout, Open; Import; Open). Does not write TASK. No TRACKING / LAYOUT table on the project XER map. Do not invent a view %T. Layouts travel as .plf. See Import a Tracking Layout.

Publish tracking layouts

How-to (Tools, Publish, Tracking Layouts; Select; filename with no extension; Open). Does not write TASK. No TRACKING / LAYOUT / PUBLISH table on the project XER map. Do not invent a view %T. See Publish Tracking Layouts.

Change successor relationships

Command (Project, Activities; Activity Details Successors or Relationships tab; Assign / double-click Relationship Type or Lag / Remove). Changes a TASKPRED row (or adds/removes one). No CHANGESUCC / CHANGESUCCESSOR / CHANGE_SUCC / CHANGESUCCESSORRELATIONSHIPS table on the project XER map. Do not invent a command %T. After it runs you see a changed (or new or missing) TASKPRED. A Viewer cannot tell this command from Add successor, Remove successor, Assign Successors, or Edit relationships in the Gantt Chart / Activity Network. See Change Successor Relationships.

Remove successor relationships

Command (Project, Activities; Activity Details Successors or Relationships tab; select the successor; Remove; Yes). Removes a TASKPRED row. No REMOVESUCC / REMOVESUCCESSOR / REMOVE_SUCC / REMOVESUCCESSORRELATIONSHIPS table on the project XER map. Do not invent a command %T. After it runs you see a missing TASKPRED. A Viewer cannot tell this command from Unlink, Change successor Remove, Gantt delete, Network delete, or Assign Successors Remove. See Remove Successor Relationships.

Create relationships in the Gantt Chart

Command (draw from predecessor activity-bar edges to a successor in the Gantt Chart). Creates a TASKPRED row. No CREATEGANTT / CREATEREL / GANTTREL / CREATE_GANTT_RELATIONSHIP table on the project XER map. Do not invent a command %T. After it runs you see another relationship. A Viewer cannot tell this command from Assign, Link Activities, Network draw, or EPPM Gantt drag. See Create Relationships in the Gantt Chart.

Create relationships in the Activity Network

Command (draw from predecessor activity box edge to successor box). Creates a TASKPRED row. No CREATENETWORK / NETWORKREL / DRAWBOXREL table on the project XER map. Do not invent a command %T. After it runs you see a new relationship. See Create Relationships in the Activity Network.

Edit relationships in the Gantt Chart

Command (double-click the relationship line in the Gantt Chart; type; lag days; OK). Changes a TASKPRED row. No EDITGANTT / EDITREL / GANTTREL / EDIT_GANTT_RELATIONSHIP table on the project XER map. Do not invent a command %T. After it runs you see a changed TASKPRED. A Viewer cannot tell this command from Change predecessor, Network edit, or EPPM Configuring Activity Relationships. See Edit Relationships in the Gantt Chart.

Delete relationships in the Gantt Chart

Command (double-click the Gantt relationship line; Delete; Yes). Removes a TASKPRED row. No DELETEGANTT / DELETEREL / GANTTREL / DELETE_GANTT_RELATIONSHIP table on the project XER map. Do not invent a command %T. After it runs you see a missing TASKPRED. A Viewer cannot tell this command from Unlink, Details Remove, Network delete, or EPPM Delete Relationship. See Delete Relationships in the Gantt Chart.

Edit relationships in the Activity Network

Command (double-click the relationship line in the Activity Network; a new relationship type; lag days; OK). Changes a TASKPRED row. No EDITNETWORK / EDITREL / NETWORKREL / EDIT_NETWORK_RELATIONSHIP table on the project XER map. Do not invent a command %T. After it runs you see a changed TASKPRED. A Viewer cannot tell this command from Change predecessor, Gantt edit, or EPPM Configuring Activity Relationships. See Edit Relationships in the Activity Network.

Delete relationships in the Activity Network

Command (double-click the Network relationship line; Delete; Yes). Removes a TASKPRED row. No DELETENETWORK / DELETEREL / NETWORKREL / DELETE_NETWORK_RELATIONSHIP table on the project XER map. Do not invent a command %T. After it runs you see a missing TASKPRED. A Viewer cannot tell this command from Unlink, Details Remove, Gantt delete, or EPPM Delete Relationship. See Delete Relationships in the Activity Network.

View activity relationships in the Gantt Chart

How-to (Layout Options bar → Show on Top, Gantt Chart; a line connecting two activity bars). Does not write TASKPRED. No VIEWGANTT / VIEWREL / GANTTVIEW / VIEW_GANTT_RELATIONSHIP table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to. See View Activity Relationships in the Gantt Chart.

View activity relationships in the Activity Network

How-to (hierarchy table on the left; a line connecting two activity boxes). Does not write TASKPRED. No VIEWNETWORK / VIEWREL / NETWORKVIEW / VIEW_NETWORK_RELATIONSHIP table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to. See View Activity Relationships in the Activity Network.

View activity relationships in Activity Details

How-to (Layout Options bar → Show on Bottom, Activity Details; Predecessors / Successors / Relationships tabs). Does not write TASKPRED. No VIEWDETAILS / VIEWREL / ACTIVITYDETAILS / VIEW_DETAILS_RELATIONSHIP table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to. See View Activity Relationships in Activity Details.

View activity relationships in the Activity Table

How-to (View, Columns / Layout Options bar → Columns; Predecessor Details / Successor Details). Does not write TASKPRED. No VIEWTABLE / VIEWREL / TABLEREL table on the project XER map. Do not invent a view %T. See View Activity Relationships in the Activity Table.

View activity relationships in Trace logic

How-to (Layout Options bar → Show on Bottom, Trace Logic; selected activity only; blue border; left pred / right succ). Does not write TASKPRED. No VIEWTRACE / VIEWREL / TRACE / TRACELOGIC / VIEW_TRACE_RELATIONSHIP table on the project XER map. Do not invent a view %T. Relationships are TASKPRED. A Viewer cannot reconstruct that the planner used this how-to. See View Activity Relationships in Trace Logic.

Visualizer

Separate Professional app (Tools > Visualizer). Layouts export as .VLF, not XER. Can import an Activity .PLF as a Gantt. No Visualizer table on the project XER map. Do not invent VISUALIZER / VLF / LAYOUT as an XER %T. See Visualizer.

Claim Digger / Schedule Comparison

Difference report (Tools > Schedule Comparison launches Visualizer). No comparison table on the project XER map. Do not invent CLAIM / DIGG / COMPARE / SCHEDCOMP as an XER %T. See Claim Digger.

Summarize

Command/service (Tools > Summarize / Enable Summarization / Summarizer). Rolls project data for EPS/summarized pages. No summary-data or spread-data table on the project XER map. Do not invent TASKSUM / SUMDATA / PROJSUM as an XER %T.

sum_data_date is not last_recalc_date. px_enable_publication_flag is Enable Publication. sum_assign_level is labeled sum_assign_level — Oracle did not say that is Summarize Project based on. sum_base_proj_id is Project Baseline. See Summarizer Stores Rolled-Up EPS Totals; It.

TASKFDBK / TASKNOTE

Activity Feedback and Notes to Resources. Not TASKMEMO. See Activity Feedback.

TASKFDBK (Oracle): proj_id (Project), task_fdbk (Feedback from Resources (P6 EPPM) Feedback from Primary Resource (P6 Professional)), task_id (Activity). Oracle listed only those three columns.

TASKNOTE (Oracle): proj_id (Project), task_id (Activity), task_notes (Notes to Resources).

TASK.rev_fdbk_flag is New Feedback.

Discussion / Unread Comments

Activity Discussion comments (Discussion tab / Team Member). No Discussion or ActivityComment table on the project XER map. Do not invent a Discussion %T. TASKPRED.comments is relationship Comments, not this thread. TASKFDBK / TASKNOTE are Feedback. REST UnreadCommentCount is Team Member Discussion, not Feedback. See Discussion.

PROJEST

Saved top-down / function-point estimate history. Professional only. Not Independent ETC, remaining duration, or spending plan. See Estimate History.

PROJEST (Oracle): proj_est_id (Unique ID), proj_id (Project), wbs_id (WBS), rsrc_id (Resource), rsrc_type (Resource Type), est_name (Estimate Name), est_type (Method), est_date (Date), est_notes (Assumptions & Notes), est_qty (Estimated Units), est_task_cnt (Total Activities), applied_flag (Applied), adj_mult_pct (Adjustment Factor), bu_cmplx_value (Size/Complexity), fp_unadj_cnt (Unadjusted FP Count), fp_cmplx_value (Total Degree of Influence), fp_cnt (Final Adjusted FP Count), fp_prod_avg_value (FP/Person-Month).

est_type / applied_flag stored tokens are unverified. PROJWBS.est_wt and TASK.est_wt are Est Weight (P6 Professional only) — the apply weights, not the history row.

Unverified

• On-disk %T / %F / %R marker syntax (not in Oracle column map).
• Stored enum strings for clndr_type, pred_type, cstr_type, task_type, status_code, complete_pct_type (Oracle map gives labels, not codes). Codes used elsewhere in this repo are cited from MPXJ / other Oracle maps and marked there.
• Exact encoding of SCHEDOPTIONS retained-logic vs progress-override flags.