Primavera Software Development Kit Tables and Fields
             
Note: Tables and fields in red are not fully tested and so are not supported for this release. Using unsupported fields may result in inconsistent behavior or data loss.    
Table Title Description      
ACCOUNT Cost Accounts Cost accounts contain the organization's Cost Account IDs. Available across all projects, they support tracking of costs and earned value based on the organization’s Cost Account IDs    
ACTVCODE Activity Code Values This table contains values for all the defined Activity Codes. Activity Codes are user-defined codes to classify and categorize activities according to the organization’s and project’s needs. Activity Codes can be defined by project as well as globally across all projects.    
ACTVTYPE Activity Codes This table contains the Activity Codes. Activity Codes are user-defined codes to classify and categorize activities according to the organization’s and project’s needs. Activity Codes can be defined by project as well as globally across all projects.    
BASETYPE Baseline Types Baseline types are used to categorize project baselines. They are useful to standardize baselines and help benchmark performance across projects.    
BUDGCHNG Budget Changes The Budget Change Log is used to track changes made from the Original Budget. You can set the status of the change as pending, approve or not approved, assign a responsible person, and specify the amount of the change. The Budget Change Log applies to each WBS, Project and EPS.     
CALENDAR Calendars This table contains all calendars - global calendars, resource calendars, and project-specific calendars. Global calendars can be assigned to projects and resources. Resource calendars can be assigned only to resources. Project calendars are specific to projects.    
COSTTYPE Expense Categories Expense categories are used to categorize project expenses. They are used for standardizing expenses and for rolling up expenses across projects.    
CURRTYPE Currency Types A currency type is set for every database. The user is able to specify the currency, its symbol, decimal symbol, number of decimal places, the positive and negative currency format and the digit grouping symbol.    
DOCCATG Document Categories Document categories are used to categorize documents. They are used for standardizing documents across projects.    
DOCSTAT Document Statuses Document status codes are used to identify the current status of work products and documents.    
DOCUMENT Work Products and Documents The Documents table contains all project-related documents. This includes guidelines, procedures, standards, plans, design templates, and worksheets. A document can be a reference document for an activity, providing standards and guidelines for performing the work; or it can be a work product, a document that was produced during the activity.    
EXPPROJ Contract Management Projects Primavera's contract management-related data.    
EXTAPP External Applications External Applications table allows you to define what external applications your Primavera application is linked to. You can specify global applications or project specific applications. We currently support two project level external applications - linking a project to Microsoft Project project and linking a project to an Expedition project.    
FUNDSRC Funding Sources This table contains the Funding Sources. Funding Sources are user-defined. They are assigned to projects and EPS nodes to allocate the amount each source is contributing.     
FINDATES Financial Periods Customized financial periods can provide more accurate display and reporting of actual units and costs. Rather than spreading costs evenly throughout the length of a project, users can view how actual costs were incurred by customized financial periods within a Start Date and an End Date.    
ISSUHIST Notification History The history of notifications for project issues.    
MEMOTYPE Notebook Topics Activity specifications topics, which can be associated with activities. These topics contain instructions or descriptions for performing an activity. Examples of specification topics are Purpose, Entry Criteria, Tools & Techniques, and Exit Criteria.     
NONWORK Overhead Codes Overhead codes are used to log timesheet hours for activities, which are not associated with any current projects.    
OBS OBS The organizational breakdown structure is a hierarchical arrangement of an organization's management structure.    
PCATTYPE Project Codes Project Codes are unlimited, hierarchical codes. These codes are assigned to projects and then used for organizing to rollup project information.    
PCATVAL Project Code Values This table contains values for all the defined Project Codes. Project Codes are user-defined codes to classify and categorize projects across the organization. Project Codes are defined globally.    
PFOLIO Portfolios Portfolios are sets of projects grouped together.  Use Portfolios to limit the amount of data loaded.        
PHASE Project Phase List The set of possible WBS category values. Note that the label used for WBS category is dynamic; the system administrator controls it.    
PREFER Admin Preferences Administration preferences are global settings, data limits, and defaults that apply across all projects.    
PRIVILEG Security Privileges The set of all security privileges. Individual privileges are combined into security profiles that are then assigned to application users.    
PROCGROUP Acitivity Step Templates Activity step templates enable you to define a group of steps common to multiple activities, then assign the template to activities.     
PROCITEM Acitivity Step Items Contains activity step template items, which are steps in the associated activity templates.    
PROFILE Security Profiles Security profiles consist of lists of privileges. Profiles are granted to users of the application, allowing them to perform certain functions in the application. Security profiles are global as well as by project.    
PROFPRIV Profile Privileges Contains the security privileges assigned to user profiles.      
PROJBASE Project Baselines Contains the project baseline information. The baselines act as a snapshot of a project plan that can be used to track a project's cost, schedule and performance.    
PROJCOST Project Expenses Project expenses are non-resource costs associated with a project. Project expenses are assigned to activities. They are typically one-time expenditures for non-reusable items.     
PROJECT Projects Contains project details and settings.    
PROJEST Estimate History Histories of top-down estimates saved for projects.    
PROJFUND Project Funding Assignments Project/EPS Funding Sources    
PROJISSU Issues Project issues are known problems within a project plan that require attention or corrective action. The threshold monitor may create issues manually or automatically when a project threshold is exceeded.    
PROJPCAT Project Code Assignments Project codes assigned to Projects.    
PROJRISK Risks The potential risks associated with a project.    
PROJTHRS Thresholds Project thresholds are created to automatically monitor various project tracking parameters including cost, schedule, and earned value. Project issues are automatically generated when thresholds are exceeded during threshold monitoring.    
PROJWBS WBS The project work breakdown structure (WBS) is a hierarchical arrangement of the products and services produced during and by a project. Each element of a WBS may contain more-detailed WBS elements, activities, or both.     
PRPFOLIO Portfolios WBS Relationships This table contains the grouping of projects within each defined portfolio.      
RCATTYPE Resource Codes Resource Codes are unlimited, hierarchical codes. These codes are assigned to resources and then used for organizing resource information.    
RCATVAL Resource Code Values This table contains values for all the defined Resource Codes. Resource Codes are user-defined codes to classify and categorize resources across the organization. Resource Codes are defined globally.    
RISKCTRL Risk Control Plans A memo containing the control plans for project risks.    
RISKTYPE Risk Types Risk types are used to categorize risks. They are useful to standardize risks across projects.    
ROLERATE Role Prices Role rates enable you to select a predefined price per unit for cost calculating when assigning the role to an activity.     
ROLES Roles Roles are project-personnel job titles or skills. Roles are defined globally across projects. Roles are assigned to activities and to resources. The set of roles you assign to an activity define an activity's skill requirements and facilitate resource staffing for the activity. The set of roles you assign to a resource describe a resource's skill capabilities.     
RPT Reports This table contains the set of all reports, including global reports and project-specific reports.    
RPTBATCH Batch Reports Batch reports are sets of reports that can be run together as a series. This is easier than running all the reports individually.    
RPTGROUP Report Groups Report groups are used to organize and categorize reports.    
RPTLIST Batch Report Assign     Contains each batch report and the reports that belong to each group.     
RSRC Resources Resources contain the personnel and equipment that perform work on activities across all projects. Resources are always time-based and are generally reused between activities and between projects.     
RSRCCURV Resource Curves This table contains the defined resource curves.  Resource curves enable you to specify how you want resource units or cost spread over the duration of an activity.      
RSRCRATE Resource Prices The time-varying price per time and maximum units per time for all resources.    
RSRCRCAT Resource Code Assignments The set of Resource Codes assigned to resources.    
RSRCSEC Resource Security Resource security allows you to restrict a user's ability to access resources by assigning the user to a resource node in the hierarchy. The table contains the user - resource node associations.    
RSRCROLE Resource Role Assignments The set of roles assigned to resources, describing the resources' skill capabilities.     
SHIFT Shift Names The set of defined shift names.    
SHIFTPER Shifts The set of defined shift calendars for resources.    
TASK Activities The set of activities for all projects.    
TASKACTV Activity Code Assignments The set of Activity Codes assigned to activities.    
TASKDOC Document Assignments The set of documents assigned to activities.    
TASKFIN Activity Past Period Actuals The set of past period atuals associated with activities.    
TASKMEMO Notebook Items The set of activity specifications associated with activities.    
TASKPRED Activity Relationships The set of relationships for activities, including predecessors and successors.    
TASKPROC Activity Steps The set of steps associated with each activity.    
TASKRSRC Activity Resource Assignments The set of resources assigned to perform activities.    
TASKSUM Activity Summaries Contains summary data that was generated by the Summarizer. The data in this table is summarized to the WBS level.    
THRSPARM Threshold Parameters The set of parameters available to define project thresholds, such as cost, schedule, and earned value.    
TIMESHT Timesheets The set of timesheets that have been opened by resources.    
TRSRCFIN Activity Resource Assignments Past Period Actuals Contains past period actual data associated with resource assignments.    
TRSRCSUM Activity Resource Summaries Contains persisted spread data generated by the Summarizer. The values are summarized to the WBS level that is specified by the user.    
TSDATES Timesheet Intervals Stores all of the start and end dates for the timesheets    
UDFCODE User-defined Codes Set of user-defined codes associated with project issues.    
UDFTYPE User-defined Fields Set of user-defined field types.    
UMEASURE Units of Measure Set of units of measure.    
USERCOL User-defined Columns Definitions/labels for all user-defined columns    
USERENG User product assignments Maps users to database engine types for license enforcement. It also specifies whether the user is concurrent or named.    
USEROBS User OBS Assignments Users are assigned to global OBS elements to define the scope of project and EPS security for the users. For a user to have access to a project or EPS, the user must be assigned to an OBS element within that project or EPS. (Or, the user must have Admin Superuser privileges.) This gives the user access to any WBS areas their assigned OBS is responsible for.    
USERS Users The set of application users who are allowed to use Project Planner. Each user is assigned a global security profile and zero or more project-level profiles.    
USESSION User Session Whenever a user logs in, that begins a session. The session ends when the user logs out. As a server serving multiple users, there may be several user sessions being managed at the same time. However, from the session’s point of view, there is usually only one row in this table—the current session.    
USRDATA User Settings Settings and preferences for the users by topic.      
WBSBUDG Spending and Benefit Plans Periodic budgets for projects including the Spending Plan and Benefit Plan information.    
WBSMEMO WBS, Project and                                  EPS Notebook Items Contains all of the Notebook information for WBS, projects and EPS.    
WBSRSRC High Level Resource Planning Assignments Contains high-level resource planning assignment data. High-level resources can be assigned at Project or WBS level.    
WBSRSRC_QTY High Level Resource Planning Assignments Allocations Contains high-level resource planning allocation data.    
WBSSTEP WBS Milestones WBS Milestones that are assigned to the WBS and used for Earned Value calculations.    
ACCOUNT        
(home) Field Name Description Column Name Data Type Field Type Read-Only Nullable Stored    
  acct_concat_name Cost Account ID Unique identifier of a cost account - the concatenation of the cost account's own ID together with its parents' IDs. String FT_TEXT   Y Calc    
  acct_descr Cost Account Description The description of a cost account. Memo <HTML>   Y Db(delayed    
  acct_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  acct_name Cost Account Name The name of a cost account. String FT_TEXT   Db    
  acct_seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
  acct_short_name Cost Account ID A short ID assigned to each cost account for identification. Each cost account is uniquely identified by concatenating its own ID together with its parents' IDs. String FT_TEXT   Db    
  act_cost Actual Total Cost The actual total cost for the cost account, including labor resources, nonlabor resources, material resources and project expenses.  Actual Total Cost =  Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost. Double FT_MONEY   Y Calc    
  act_equip_cost Actual Nonlabor Cost The actual cost for all nonlabor resource assignments associated with the cost account. Includes nonovertime plus overtime cost. Double FT_MONEY   Y Calc    
  act_equip_ot_cost Actual Overtime Nonlabor Cost The actual overtime cost for all nonlabor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  act_equip_reg_cost Actual Regular Nonlabor Cost The actual nonovertime cost for all nonlabor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  act_expense_cost Actual Expense Cost The actual cost for all project expenses associated with the cost account. Double FT_MONEY   Y Cache    
  act_mat_cost Actual Material Cost The total actual material cost for all child activities. Double FT_MONEY   Y Cache    
  act_work_cost Actual Labor Cost The actual cost for all labor resource assignments associated with the cost account. Includes nonovertime plus overtime cost. Double FT_MONEY   Y Calc    
  act_work_ot_cost Actual Overtime Labor Cost The actual overtime cost for all labor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  act_work_reg_cost Actual Regular Labor Cost The actual nonovertime cost for all labor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  assigned_flag Assigned Indicates whether the cost account is assigned to expenses or activity-resource assignments in the current project. String FT_YESNO Y Y Calc    
  base_acct_id Baseline Account The cost account of labor cost, nonlabor cost, material cost, and expenses when the baseline is saved. Integer <FK>   Y Mem    
  base_cost BL Total Cost The total cost including labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses in the primary baseline associated with the cost account. BL Total Cost = BL Labor Cost + BL Nonlabor Cost + BL Material Cost + BL Expense Cost. Double FT_MONEY Y Y Cache    
  base_equip_cost BL Nonlabor Cost The cost for all nonlabor resource assignments in the primary baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  base_expense_cost BL Expense Cost The cost for all project expenses in the primary baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  base_mat_cost BL Material Cost The cost for all project expenses in the primary baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  base_work_cost BL Labor Cost The cost for all labor resource assignments in the primary baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  parent_acct_id Parent Cost Account The parent account within the cost account hierarchy. Integer <FK_TREE>   Y Db    
  remain_cost Remaining Total Cost The remaining total cost for the cost account, including labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses.  Remaining Total Cost =  Remaining Labor Cost + Remaining Nonlabor Cost + Remaining Material Cost + Remaining Expense Cost. Double FT_MONEY   Y Calc    
  remain_equip_cost Remaining Nonlabor Cost The remaining cost for all nonlabor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  remain_expense_cost Remaining Expense Cost The remaining cost for all project expenses associated with the cost account. Double FT_MONEY   Y Cache    
  remain_mat_cost Remaining Material Cost Sum of all remaining material cost for the activities in the wbs. Double FT_MONEY   Y Cache    
  remain_work_cost Remaining Labor Cost The remaining cost for all labor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  row_count Cost Account Count Cost Account Count Integer FT_INT Y Y Calc    
  target_cost Total Cost The planned total cost for the cost account, including labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses.  Planned Total Cost =  Planned Labor Cost + Planned Nonlabor Cost + Planned Material Cost + Planned Expense Cost. Double FT_MONEY   Y Calc    
  target_equip_cost Nonlabor Cost The planned cost for all nonlabor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  target_expense_cost Expense Cost The planned cost for all project expenses associated with the cost account. Double FT_MONEY   Y Cache    
  target_mat_cost Material Cost   Double FT_MONEY   Y Cache    
  target_work_cost Labor Cost The planned cost for all labor resource assignments associated with the cost account. Double FT_MONEY   Y Cache    
  total_cost At Completion Total Cost The total cost at completion is the sum of the actual plus remaining cost for all labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses associated with the cost account. Double FT_MONEY Y Y Calc    
  total_equip_cost At Completion Nonlabor Cost The nonlabor cost at completion is the sum of the actual plus remaining cost for all nonlabor resource assignments associated with the cost account. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost. Double FT_MONEY   Y Calc    
  total_expense_cost At Completion Expense Cost The expense cost at completion is the sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost. Double FT_MONEY Y Y Calc    
  total_mat_cost At Completion Material Cost Sum of all at completion material cost. Double FT_MONEY   Y Calc    
  total_work_cost At Completion Labor Cost The labor cost at completion is the sum of the actual plus remaining cost for all labor resource assignments associated with the cost account. Computed as Actual Labor Cost + Remaining Labor Cost. Double FT_MONEY   Y Calc    
                 
ACTVCODE              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  actv_code_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  actv_code_name Description The description of an Activity Code value. String FT_TEXT   Y Db    
  actv_code_type_id Activity Code The Activity Code. Integer <FK>   Db    
  actvcode_concat_name Code Value The value of the activity code. String FT_TEXT   Calc    
  parent_actv_code_id Parent Activity Code Value The parent Activity Code value in the user code value hierarchy. Integer <FK_TREE>   Y Db    
  row_count Activity Code Value Count   Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
  short_name Activity Code Value The value of the activity code. String FT_TEXT   Db    
                 
ACTVTYPE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  actv_code_type Activity Code Each Activity Code has a list of possible values, any of which can be assigned to an activity. Activity Codes allow you to classify and categorize activities. String FT_TEXT   Db    
  actv_code_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  actv_code_type_scope Activity Code Type Scope Scope of the activity code type. String FT_STATICTYPE   Db    
  actv_short_len Max Code Length The maximum number of characters allowed for values of this Activity Code. Double FT_INT   Db    
  proj_id EPS/Project Identifies the project which owns this Activity Code (if this is a project-level Activity Code). Double <FK>   Y Db    
  project_id Project Identifies the project. String FT_TEXT   Y Calc    
  row_count Activity Code Count Activity Code Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Double <SEQ>   Db    
  super_flag Secure Code Indicates whether the code is controlled by a special security privilege. String FT_YESNO   Db    
  wbs_id EPS ID   Double <FK> Y Y Mem    
             
BASETYPE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  base_type Baseline Type Baseline types are used to categorize project baselines.  They are useful to standardize baselines and help benchmark performance across projects. String FT_TEXT   Db    
  base_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  base_type_seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
  row_count Baseline Type Count Baseline Type Count Integer FT_INT Y Y Calc    
                 
BUDGCHNG              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  budg_chng_id Unique ID Unique ID generated by the system.. Integer <PK> Y   Db    
  chng_by_name Responsible Person responsible for the change. String FT_TEXT   Y Db    
  chng_cost Amount Amount of budget change. Double FT_MONEY   Y Db    
  chng_date Date Date of budget change entry.  Uses the system date by default. Date FT_START_DATE   Db    
  chng_descr Reason Descriptive reason for budget change request. String <HTML>   Y Db    
  chng_short_name Change Number Change number that is automatically incremented according to when changes are added.  This can be changed to any number. String FT_TEXT   Db    
  proj_id Project Project to which the budget change applies. Integer <FK>   Db    
  row_count Budget Change Count Budget Change Count Integer FT_INT Y Y Calc    
  status_code Status Status of budget change request.  Values:  'Pending', 'Approved', 'Not Approved'. String FT_STATICTYPE   Db    
  wbs_id WBS WBS element to which the budget change applies. Integer <FK>   Db    
                 
CALENDAR              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  base_clndr_id Parent Calendar The global calendar to which this calendar is linked.  Any changes to the global calendar are automatically propagated to this calendar. Integer <FK_TREE>   Y Db    
  clndr_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  clndr_name Calendar Name The name of the calendar. String FT_TEXT   Db    
  clndr_type Calendar Type The calendar type - either global, resource, or project. Global calendars can be assigned to projects and resources. Resource calendars can be assigned only to resources. Project calendars are specific to projects. String FT_STATICTYPE   Db    
  default_flag Default Identifies the default global calendar (applies to global calendars only). String FT_YESNO   Y Db    
  last_chng_date Date Last Changed Date of last changes to calendar. Date FT_START_DATE   Y Db    
  proj_id Project The project which owns this calendar (if this is a project-level calendar). Integer <FK>   Y Db    
  row_count Calendar Count Calendar Count Integer FT_INT Y Y Calc    
             
COSTTYPE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  cost_type Expense Category The name of the expense category. String FT_TEXT   Db    
  cost_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  row_count Expense Category Count Expense Category Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
                 
CURRTYPE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  base_exch_rate Exchange Rate The current exchange rate between the selected currency and the base currency. Double FT_FLOAT_6_DECIMALS Y   Db    
  curr_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  curr_short_name Currency ID The identifiers for all currencies defined in Project Management. String FT_TEXT Y   Db    
  curr_symbol Currency Symbol The symbol used to identify each defined currency. String FT_TEXT Y   Db    
  curr_type Currency Name The names of all defined currencies. String FT_TEXT Y   Db    
  decimal_digit_cnt Number of Digits after Decimal The number of decimal places displayed. Integer FT_INT Y   Db    
  decimal_symbol Decimal Symbol The decimal symbol displayed. String FT_TEXT Y   Db    
  digit_group_symbol Digit Grouping Symbol The symbol used to group the numbers. String FT_TEXT Y   Db    
  group_digit_cnt Currency Group Digit Count Digits in Group. Integer FT_INT Y   Db    
  is_base Base The currency used to store cost in the Project Management database. The exchange rate for the base currency is always 1.0. The base currency ID, name, and symbol default to U.S. dollars and can be edited but never deleted. String FT_YESNO Y Y Calc    
  neg_curr_fmt_type Negative Currency Format The symbol used to display a negative currency. String FT_TEXT Y   Db    
  pos_curr_fmt_type Positive Currency Format The symbol used to display a positive currency. String FT_TEXT Y   Db    
  row_count Currency Type Count Currency Type Count Integer FT_INT Y Y Calc    
             
DOCCATG                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  doc_catg_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  doc_catg_name Category The name of the document category. String FT_TEXT   Db    
  row_count Document Category Count Document Category Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
             
DOCSTAT                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  doc_status_code Status Code Document status codes are used to identify the current status of documents. String FT_TEXT   Db    
  doc_status_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  row_count Document Status Count Document Status Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number used for sorting. Integer <SEQ>   Db    
                 
DOCUMENT              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  assigned_flag Assigned to Current Project Indicates whether the document is currently assigned to WBS elements or activities within the current project. String FT_YESNO Y Y Calc    
  author_name Author The author who created the document. String FT_TEXT   Y Db    
  deliv_flag Deliverable Identifies the work products and documents which are project deliverables. Project deliverables are delivered to the customer or end user. String FT_YESNO   Y Db    
  doc_catg_id Document Category The category to which the document is assigned. Integer <FK>   Y Db    
  doc_content Description The document description or content stored as a text field in the database. Memo <HTML>   Y Db(delayed    
  doc_date Revision Date The date of last revision of the document. Date FT_START_DATE   Y Db    
  doc_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  doc_name Title The title or name of the document. String FT_TEXT   Db    
  doc_seq_num Sort Order Sequence number used for sorting. Integer <SEQ>   Db    
  doc_short_name Reference No. The reference number of the document. This is a tracking number to identify the document. String FT_TEXT   Y Db    
  doc_status_id Status The current status of the document. Integer <FK>   Y Db    
  guid Global Unique ID Global Unique Identifier generated by the system. String <GUID>   Y Db    
  parent_doc_id Parent Document The parent document within the document hierarchy. Integer <FK_TREE>   Y Db    
  private_loc Private Location The directory and file name or URL where the source copy of the document is stored and edited.  Use this for referencing the planned. String FT_TEXT   Y Db    
  proj_id Project The project which owns the document. Integer <FK> Y   Db    
  public_loc Public Location The directory and file name or URL where a public copy of the document is made available. Use this for sharing documents with Timesheets users and published websites. String FT_TEXT   Y Db    
  row_count Document Count Document Count Integer FT_INT Y Y Calc    
  tmpl_guid Methodology Global Unique ID Global Unique Identifier generated by the system. String <GUID>   Y Db    
  version_name Version The version or release of the document. String FT_TEXT   Db    
                 
EXPPROJ                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  exp_group Database Group The database group ID. String FT_TEXT   Db    
  exp_group_proj_name Database Group and Project Name The database group and project name. String FT_TEXT   Calc    
  exp_proj_name Project Name The project name. String FT_TEXT   Db    
  exp_user_name Username The user name. String FT_TEXT   Y Db    
  login_supplied_flag Prompt for Username and Password The flag that indicates, whether username and password need to be prompted. String FT_TEXT   Db    
  proj_id proj_id Identifies the project. Integer <PK_FK> Y   Db    
  wbs_id WBS   Integer <FK>   Y Cache    
                 
EXTAPP                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  app_data_loc External Data Path or Database Alias The location (full path or database alias) of application data file or database. String FT_TEXT   Y Db    
  app_data_name External Project Name or Identifier The name of the project or identifier that is being linked. String FT_TEXT   Y Db    
  app_exe_name Application Executable Name The location of the executable for the external application. String FT_TEXT   Db    
  app_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  app_name Application Name The name of the external application.  When linking to a Microsoft project, the application name should read Microsoft Project.  When linking to an Expedition project, the application name should read Expedition. String FT_STATICTYPE   Db    
  app_parm_string Application Parameter String Parameter string for application connection. String FT_TEXT   Y Db    
  app_user_name Login Name The application username. String FT_TEXT   Y Db    
  login_supply_flag Prompt for login name and password When logging into the external application, you can choose to be prompted or you can enter a username and password that will be used. String FT_TEXT   Db    
  proj_id Project Identifies the project which owns this external link. (this will be null for global-level). Integer <FK>   Y Db    
  row_count External Application Count External Application Count Integer FT_INT Y Y Calc    
  wbs_id Password The id of the root level wbs. Integer <FK>   Y Calc    
                 
FINDATES                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  end_date End Date Financial Period End Date. Date FT_START_DATE   Db    
  fin_dates_id Unique ID Unique ID. Integer <PK> Y   Db    
  fin_dates_name Period Name User defined financial period for storing period performance. String FT_TEXT   Db    
  findates_interval Financial Period Financial period. String FT_TEXT   Cache    
  row_count Financial Period Count Financial period count. Integer FT_INT Y Y Calc    
  start_date Start Date Financial Period Start Date. Date FT_START_DATE   Db    
             
FUNDSRC            
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  fund_descr Description The description of funding source. Memo <HTML>   Y Db(delayed    
  fund_id Unique ID Unique ID. Integer <PK> Y   Db    
  fund_name Funding Source The name of the funding source. String FT_TEXT   Db    
  parent_fund_id Parent Funding Source Identifies the funding source hierarchy. Integer <FK_TREE>   Y Db    
  row_count Funding Source Count Funding Source Count. Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number used for sorting. Integer <SEQ>   Db    
             
ISSUHIST                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  issue_history Notification History History of notifications and messages for the issue. Memo FT_TEXT   Y Db(delayed    
  issue_id Issue Identifies the issue. Integer <PK_FK> Y   Db    
  proj_id Project The project which owns this issue. Integer <FK>   Db    
  row_count Notification History Count Notification History Count. Integer FT_INT Y Y Calc    
                 
MEMOTYPE              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  eps_flag Available for EPS The topic will be available to assign to the EPS. String FT_YESNO   Db    
  memo_type Notebook Topic Notebook Topics are topics which can be associated with activities, WBS, projects and EPS.  When creating topics, you specify which level of the hierarchy you would like the topic to appear.   These topics contain instructions or descriptions for performing an activity, WBS, project or EPS. Examples of notebook topics are Purpose, Entry Criteria, Tools & Techniques, and Exit Criteria. Notebook topics are stored as text fields in the database. String FT_TEXT   Db    
  memo_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  proj_flag Available for Projects The topic will be available to assign to projects. String FT_YESNO   Db    
  row_count Notebook Topic Count Notebook Topic Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
  task_flag Available for Activity The topic will be available to assign to activities. String FT_YESNO   Db    
  wbs_flag Available for WBS The topic will be available to assign to  WBS. String FT_YESNO   Db    
             
NONWORK            
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  nonwork_code Overhead Code A short code which uniquely identifies an overhead code. String FT_TEXT   Db    
  nonwork_type Overhead Description Description of overhead code. String FT_TEXT   Db    
  nonwork_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  row_count Overhead Code Count Overhead Code Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
                 
OBS                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  guid Global Unique ID Global Unique Identifier generated by the system. String <GUID>   Y Db    
  obs_descr OBS Description The description of the person/role in the organization. Memo <HTML>   Y Db(delayed    
  obs_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  obs_name OBS Name The name of the person/role in the organization. String FT_TEXT Db    
  parent_obs_id Parent OBS The parent OBS value in the OBS hierarchy. Integer <FK_TREE> Y Db    
  row_count OBS Count OBS Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number used for sorting. Integer <SEQ> Db    
  users_list Users The list of users who are assigned to each OBS item. String FT_TEXT Y Y Calc    
         
PCATTYPE        
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  max_proj_catg_wt Max Code Value Weight This is an editable field used to calculate the Project Score. This field automatically defaults to the maximum weight of the code values for this code definition. The value entered cannot be less than the maximum weight of the code values for the code definition. Double FT_FLOAT Db    
  proj_catg_short_len Max Code Length The maximum number of characters allowed for values of this Project Code. Integer FT_INT Db    
  proj_catg_type Project Code Each Project Code has a list of possible values, any of which can be assigned to a project. Project Codes allow you to classify and categorize projects. String FT_TEXT Db    
  proj_catg_type_id Unique ID Unique ID generated by the system.. Integer <PK> Y Db    
  proj_catg_type_wt Weight Editable field used to calculate the Project Score. Double FT_FLOAT   Db    
  proj_catg_type_wt_pct Weight Percent This is a non-editable field that displays the percentage amount that corresponds to the Project Code Definition Weight. It is calculated by taking the weight of the Project Code Definition and dividing it by the total of all Project Code Definition weights. Double FT_FLOAT Y Y Calc    
  row_count Project Code Count Project code count. Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence Number used for sorting. Integer <SEQ>   Db    
  super_flag Secure Code Indicates whether the code is controlled by a special security privilege. String FT_YESNO   Db    
                 
PCATVAL                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  parent_proj_catg_id Parent Code Identifies the parent project code value. Integer <FK_TREE>   Y Db    
  pcatval_concat_name Code Value The value of the project code. String FT_TEXT   Calc    
  proj_catg_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  proj_catg_name Code Description The description of the project code. String FT_TEXT   Y Db    
  proj_catg_short_name Project Code The value of the project code. String FT_TEXT   Db    
  proj_catg_type_id Project Code Identifies the project code type. Integer <FK>   Db    
  proj_catg_wt Weight Editable field used to calculate the Project Score. Double FT_FLOAT   Db    
  row_count Project Code Value Count Project Code Value Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence Number for sorting. Integer <SEQ>   Db    
  user_id Workflow Recipient The workflow recipient field is used for the Project Initiation route by project code feature in myPrimavera.  Each value can have one licensed myPrimavera or Timesheet user assigned. Integer FT_INT   Y Calc    
                 
PFOLIO                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  closed_proj_flag Include Closed Projects Indicates whether Closed projects are included. String FT_YESNO   Db    
  pfolio_data Portfolio Data Portfolio data as text string - list of projects for manually created portfolios and the project filter criteria for automatically maintained portfolios. Memo FT_TEXT   Y Db(delayed    
  pfolio_descr Portfolio Description The description of the portfolio. String FT_TEXT   Y Db    
  pfolio_group Portfolio Group Specifies which group the portfolio is a part of. The options are EPS and Project Codes, User Portfolios or Global Portfolios. String FT_STATICTYPE   Y Calc    
  pfolio_id Unique ID Unique ID. Integer <PK> Y   Db    
  pfolio_name Portfolio Name The name of the portfolio. String FT_TEXT   Db    
  pfolio_type Portfolio Type Type of portfolio - manual or automatic. String FT_STATICTYPE   Db    
  proj_count Total Projects Specifies the number of projects included in the Portfolio. Integer FT_INT   Y Calc    
  row_count Portfolio Count Portfolio Row Count Integer FT_INT Y Y Calc    
  user_category Available To Specifies whether the portfolio is available to all users, current user or another user. String FT_STATICTYPE   Y Mem    
  user_id Owner Identifies user who owns the portfolio. Integer <FK>   Y Db    
  whatif_proj_flag Include What-if Projects Indicates whether What-if projects are included. String FT_YESNO   Db    
                 
PHASE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  phase_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  phase_name Category Value WBS category value.  Note that the label used for WBS category is dynamic; it is controlled by the system administrator. String FT_TEXT   Db    
  row_count WBS Category Count WBS Category Count Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
                 
PREFER                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  acct_short_len Max Cost Account ID length The maximum number characters allowed for Cost Account IDs (at each level in the cost account tree). Integer FT_INT   Db    
  allow_user_time_period_flag Allow the User to Define Time period Allows the use to specify the work hours for each time period. String FT_YESNO   Db    
  complete_task_hrs_flag Log hours on completed activities Identifies whether Timesheets users are allowed to log timesheet hours on activities which are already marked as Completed. String FT_YESNO   Db    
  curr_id Currency ID Base currency's currency id. Integer <FK>   Y Db    
  day_char Day Abbreviation The abbreviation character for time periods of days. This abbreviation is used for displaying time units and durations in the user's selected display formats. String FT_TEXT   Db    
  day_hr_cnt Work Hours Per Day The number of work hours per day. This conversion factor is used for displaying time units and durations in the user's selected display formats. Double FT_FLOAT   Db    
  db_name Database Name Database name unique across the enterprise. String FT_TEXT   Db    
  def_target_drtn_hr_cnt Activity Default Duration The Original Duration assigned to new activities by default. Double FT_DURATION   Db    
  default_timesheet_flag Resources use timesheets by default Identifies whether new resources use timesheets by default. String FT_YESNO   Db    
  ermm_enabled_flag Project Architect Enabled Indicates whether the Project Architect feature is enabled in Project Management. The Project Architect should be disabled when the Methodology Management database is not available. String FT_YESNO   Y Db    
  ev_calc Earned Value Calculation Type   String FT_STATICTYPE   Y Calc    
  ev_compute_type E.V. Percent Complete Technique The technique used for computing earned-value percent complete. This setting is assigned to new projects by default. It can be modified for each project WBS element. String FT_STATICTYPE   Y Db    
  ev_etc_compute_type E.V. Estimate-to-Complete Technique The technique for computing earned-value estimate-to-complete. This setting is assigned to new projects by default. It can be modified for each project WBS element. String FT_STATICTYPE   Y Db    
  ev_etc_user_value E.V. Performance Factor User-defined performance factor, PF, for computing Earned Value Estimate to Complete. Estimate to Complete is PF * (Budget at Completion - Earned Value). This value is assigned to new projects by default. It can be modified for each project WBS element. Double FT_FLOAT_2_DECIMALS   Db    
  ev_fix_cost_flag Include expenses in earned value Indicates whether project expenses are included in earned value computations. Resource cost are always included. String FT_TEXT   Db    
  ev_user_pct E.V. Percent Complete User-defined percent complete for computing earned value for activities within the WBS. A value of, say, 25 means that 25% of the planned amount is earned when the activity is started and the remainder is earned when the activity is completed. This value is assigned to new projects by default. It can be modified for each project WBS element. Integer FT_INT   Db    
  exp_display_root_url Contract Management URL Contract management URL to link Expedition data. String FT_TEXT   Y Calc    
  future_ts_cnt Number of future timesheets to access The number of future timesheets that Timesheets users are allowed to access. Integer FT_INT   Db    
  future_ts_hrs_flag Log hours on future timesheets Identifies whether the user can log hours in the future. String FT_YESNO   Db    
  hour_char Hour Abbreviation The abbreviation character for time periods of hours. This abbreviation is used for displaying time units and durations in the user's selected display formats. String FT_TEXT   Db    
  hr_decimal_cnt Decimal digits for timesheet hours Number of decimal digits for recording hours in timesheets in Timesheets. Integer FT_INT   Db    
  max_acct_level_cnt Max levels in Cost Account tree The maximum number of levels that can be created in the cost account hierarchy. Integer FT_INT   Db    
  max_actv_level_cnt Max Activity Code tree levels The maximum number of levels that can be created in Activity Code hierarchies. Integer FT_INT   Db    
  max_base_cnt Max baselines per project The maximum number of baselines that can be created per project. Integer FT_INT   Db    
  max_eps_level_cnt Max EPS tree levels Maximum count of levels in EPS hierarchy. Integer FT_INT   Db    
  max_obs_level_cnt Max levels in OBS tree The maximum number of levels that can be created in OBS hierarchies. Integer FT_INT   Db    
  max_pcat_level_cnt Max Project Code tree levels Maximum count of levels in project category hierarchy. Integer FT_INT   Db    
  max_rcat_level_cnt Max Resource Code tree levels Maximum count of levels in resource code hierarchy. Integer FT_INT   Db    
  max_role_level_cnt Max levels in Role tree Maximum count of levels in the Role hierarchy. Integer FT_INT   Db    
  max_rsrc_level_cnt Max levels in Resource tree The maximum number of levels that can be created in the resource hierarchy. Integer FT_INT   Db    
  max_task_actv_type_cnt Max Activity Codes per project The maximum number of project-level activity user codes that can be created per project. Integer FT_INT   Db    
  max_wbs_level_cnt Max levels in WBS tree The maximum number of levels that can be created in WBS hierarchies. Integer FT_INT   Db    
  minute_char Minute Abbreviation The abbreviation character for time periods of minutes. This abbreviation is used for displaying time units and durations in the user's selected display formats. String FT_TEXT   Db    
  month_char Month Abbreviation The abbreviation character for time periods of months. This abbreviation is used for displaying time units and durations in the user's selected display formats. String FT_TEXT   Db    
  month_hr_cnt Work Hours Per Month The number of work hours per month. This conversion factor is used for displaying time units and durations in the user's selected display formats. Double FT_FLOAT   Db    
  name_sep_char WBS Code Separator The character used for separating code fields for the Cost Account tree. This is also the WBS code separator for new projects by default. String FT_TEXT   Db    
  notstart_task_hrs_flag Log hours on not-started activities Identifies whether Timesheets users are allowed to log timesheet hours on activities which are still marked as Not Started. String FT_YESNO   Db    
  past_ts_cnt Number of past timesheets to access The number past timesheets a user can access. Integer FT_INT   Db    
  phase_label WBS Category label The dynamic label used for the WBS category.  Project Management allows the system administrator to dynamically label the WBS category. String FT_TEXT   Db    
  postend_task_hrs_flag Log hours after activity finish Identifies whether Timesheets users are allowed to log timesheet hours on activities for dates after the activities' actual finish dates. String FT_YESNO   Db    
  prefer_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  prestart_task_hrs_flag Log hours before activity start Identifies whether Timesheets users are allowed to log timesheet hours on activities for dates prior to the activities' actual start dates. String FT_YESNO   Db    
  proj_short_len Max Project ID length The maximum number characters allowed for Project IDs. Integer FT_INT   Db    
  projinit_admin_user_id Workflow Administrator   Integer <FK>   Db    
  role_short_len Max Role ID length The maximum number characters allowed for Role IDs. Integer FT_INT   Db    
  row_count Admin Preferences Count Admin Preferences Count Integer FT_INT Y Y Calc    
  rsrc_short_len Max Resource ID length The maximum number characters allowed for Resource IDs (at each level in the resource tree). Integer FT_INT   Db    
  task_code_len Max Activity ID length The maximum number characters allowed for Activity IDs. Integer FT_INT   Db    
  tasksum_period_type Summarize WBS Interval The interval to summarize and store WBS level spreads. String FT_STATICTYPE   Db    
  trsrcsum_period_type Summarize Resource/Role Assignment Interval The interval to summarize and store Resource and Role level spreads. String FT_STATICTYPE   Db    
  ts_approval_level Number of timesheet approval levels The number of approval levels required for timesheets (0, 1, or 2) before timesheets hours are applied to activities as actuals. Integer FT_STATICTYPE   Db    
  ts_approval_type Level 2 Timesheet Approval Order Indicates the approval sequence, if any, required for level 2 timesheet approvals. For example, project managers must approve before resource manager do, or vice versa. String FT_STATICTYPE   Y Db    
  ts_approve_user_id Default timesheet approval manager The resource manager assigned to approve timesheets for new resources by default. Integer <FK>   Y Db    
  ts_daily_flag Timesheet hours entered daily Identifies whether Timesheets users enter timesheet hours daily or by entire timesheet reporting period. String FT_YESNO   Db    
  wbs_short_len Max WBS code length The maximum number characters allowed for WBS codes (at each level in the WBS tree). Integer FT_INT   Db    
  week_char Week Abbreviation The abbreviation character for time periods of weeks. This abbreviation is used for displaying time units and durations in the user's selected display formats. String FT_TEXT   Db    
  week_hr_cnt Work Hours Per Week The number of work hours per week. This conversion factor is used for displaying time units and durations in the user's selected display formats. Double FT_FLOAT   Db    
  week_start_day_num Week Start Day The starting day of the week as displayed in all calendars. Integer FT_STATICTYPE   Db    
  xfer_complete_day_cnt Default window for completed activities The time window (days) to access completed activities in Timesheets, assigned to new resources by default. Integer FT_INT   Db    
  xfer_notstart_day_cnt Default window for not-started activities The time window (days) to access not-started activities in Timesheets, assigned to new resources by default. Integer FT_INT   Db    
  year_char Year Abbreviation The abbreviation character for time periods of years. This abbreviation is used for displaying time units and durations in the user's selected display formats. String FT_TEXT   Db    
  year_hr_cnt Work Hours Per Year The number of work hours per year. This conversion factor is used for displaying time units and durations in the user's selected display formats. Double FT_FLOAT   Db    
                 
PRIVILEG                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  priv_caption Privilege Name of security privilege. String FT_TEXT Y Y Mem    
  priv_name Privilege Abbreviation Abbreviation of security privilege. String FT_TEXT Y Y Mem    
  priv_num Unique ID Unique ID generated by the system. Integer <PK> Y   Mem    
  priv_num Unique ID Unique ID generated by the system. Integer <PK> Y   Mem    
  row_count Security Privilege Count Security Privilege Count Integer FT_INT Y Y Calc    
  scope_type Privilege Scope Scope of security privilege. Security privileges have either global scope or project scope. String FT_STATICTYPE Y   Mem    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ> Y   Mem    
                 
PROCGROUP              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  proc_group_id Unique ID Unique ID. Integer <PK> Y   Db    
  proc_group_name Step Template Name The name of the Activity Step Template.  This name must be unique. String FT_TEXT   Db    
  row_count Activity Step Template Count Activity Step Template Count. Integer FT_INT Y Y Calc    
  seq_num Sort Order Sort order. Integer <SEQ>   Db    
  step_cnt Step Count The total number of steps in the template. Integer FT_INT Y Y Calc    
                 
PROCITEM                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  proc_descr Step Description The description of the step. Memo <HTML>   Y Db(delayed    
  proc_group_id Activity Step Template The activity step template. Integer <FK>   Db    
  proc_item_id Unique ID Unique ID. Integer <PK> Y   Db    
  proc_name Step Name The activity step.  Activities are divided into sequential steps to divide the work into manageable units. String FT_TEXT   Db    
  proc_wt Step Weight The weight that is assigned to the step.  This is a user defined field that is used to calculate the physical percent complete when the project option is set. Double FT_FLOAT   Db    
  row_count Activity Step Item Count The number of step items in the activity step. Integer FT_INT Y Y Calc    
  seq_num Sort Order Sort order. Integer <SEQ>   Db    
                 
PROFILE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  OPS_G_EditActivityStepTemplates Edit Activity Step Templates Security privilege to edit activity step templates. String FT_YESNO Y Y Cache    
  OPS_G_EditMspTemplates Edit Microsoft Project Templates Security privilege to edit Microsoft Project templates. String FT_YESNO Y Y Cache    
  OSP_E_DeleteProj Delete Project within EPS Delete Project within EPS String FT_YESNO Y Y Cache    
  OSP_E_NewProj Create Project within EPS Create Project within EPS String FT_YESNO Y Y Cache    
  OSP_G_Acct Edit Cost Accounts Security privilege to edit cost accounts. String FT_YESNO Y Y Cache    
  OSP_G_ActCodes Edit Global Activity Codes Security privilege to edit global activity codes. String FT_YESNO Y Y Cache    
  OSP_G_ActvView Edit Global Activity and Assignment Layouts and Filters Security privilege to edit global activity layouts and filters. String FT_YESNO Y Y Cache    
  OSP_G_AddActCodes Add Global Activity Codes Security privilege to add global activities. String FT_YESNO Y Y Cache    
  OSP_G_AddDeleteSecureCodes Add and Delete Secure Codes Security privilege to add and delete secure codes. String FT_YESNO Y Y Cache    
  OSP_G_AddEPSActCodes Add EPS Activity Codes Security privilege to add EPS activity codes. String FT_YESNO Y Y Cache    
  OSP_G_AddIssueCodes Add Global Issue Codes Security privilege to add global issue codes. String FT_YESNO Y Y Cache    
  OSP_G_AddProjCodes Add Project Codes Security privilege to add project codes. String FT_YESNO Y Y Cache    
  OSP_G_AddResource Add Resources Security privilege to add resources. String FT_YESNO Y Y Cache    
  OSP_G_AddResourceCodes Add Resource Codes Security privilege to add resource codes. String FT_YESNO Y Y Cache    
  OSP_G_AdminExtApp Administer Global External Applications Security privilege to administer global external applications. String FT_YESNO Y Y Cache    
  OSP_G_AdminPref Edit Admin Preferences and Categories Security privilege to edit the Admin Preferences. String FT_YESNO Y Y Cache    
  OSP_G_AssignSecureCodes Assign Secure Codes Security privilege to assign secure codes. String FT_YESNO Y Y Cache    
  OSP_G_Calendar Edit Global Calendars Security privilege to edit global and resource calendars. String FT_YESNO Y Y Cache    
  OSP_G_DeleteActCodes Delete Global Activity Codes Security privilege to delete global activity codes. String FT_YESNO Y Y Cache    
  OSP_G_DeleteEPSActCodes Delete EPS Activity Codes Security privilege to delete EPS activity codes. String FT_YESNO Y Y Cache    
  OSP_G_DeleteIssueCodes Delete Global Issue Codes Security privilege to delete global issue codes. String FT_YESNO Y Y Cache    
  OSP_G_DeleteProjCodes Delete Project Codes Security privilege to delete project codes. String FT_YESNO Y Y Cache    
  OSP_G_DeleteResource Delete Resources Security privilege to delete resources. String FT_YESNO Y Y Cache    
  OSP_G_DeleteResourceCodes Delete Resource Codes Security privilege to delete resource codes. String FT_YESNO Y Y Cache    
  OSP_G_EdReport Edit Global Reports Security privilege to edit global reports. String FT_YESNO Y Y Cache    
  OSP_G_EditEPSActCodes Edit EPS Activity Codes Security privilege to edit EPS activity codes. String FT_YESNO Y Y Cache    
  OSP_G_EditGlobalChange Edit Global Change Definitions Security privilege to edit global change definitions. String FT_YESNO Y Y Cache    
  OSP_G_EditIssueCodes Edit Global Issue Codes Security privilege to edit global issue codes. String FT_YESNO Y Y Cache    
  OSP_G_EditIssueTemplate Edit Issue Forms Security privilege to edit issue forms. String FT_YESNO Y Y Cache    
  OSP_G_EditResourceCodes Edit Resource Codes Security privilege to edit resource codes. String FT_YESNO Y Y Cache    
  OSP_G_EditSecureCodes Edit Secure Codes Security privilege to edit secure codes. String FT_YESNO Y Y Cache    
  OSP_G_FinancialPeriods Edit Financial Period Dates Security privilege to edit financial period dates. String FT_YESNO Y Y Cache    
  OSP_G_FundSrcs Edit Funding Sources Security privilege to edit funding sources. String FT_YESNO Y Y Cache    
  OSP_G_Import Import Global Information Security privilege to import global information. String FT_YESNO Y Y Cache    
  OSP_G_OBS Edit OBS Security privilege to edit global OBS. String FT_YESNO Y Y Cache    
  OSP_G_Portfolios Edit Global Portfolios Security privilege to edit global portfolios. String FT_YESNO Y Y Cache    
  OSP_G_Profile Edit Security Profiles Security privilege to edit security profiles. String FT_YESNO Y Y Cache    
  OSP_G_ProjArch Run Project Architect Security privilege to run the Project Architect. String FT_YESNO Y Y Cache    
  OSP_G_ProjRsrcCodes Edit Project Codes Security privilege to edit project and resource codes. String FT_YESNO Y Y Cache    
  OSP_G_ProjView Edit Global Project and WBS Layouts Security privilege to edit global project and WBS layouts. String FT_YESNO Y Y Cache    
  OSP_G_ReadonlySDK View All Global/Project Data via SDK Security privilege to to view all global/project data via SDK. String FT_YESNO Y Y Cache    
  OSP_G_ResourceCalendar Edit Resource Calendars Security privilege to edit resource calendars. String FT_YESNO Y Y Cache    
  OSP_G_Role Edit Roles Security privilege to edit global roles. String FT_YESNO Y Y Cache    
  OSP_G_Rsrc Edit Resources Security privilege to edit global resources. String FT_YESNO Y Y Cache    
  OSP_G_RsrcCalendar Edit Personal Resource Calendar Security privilege to edit personal resource calendar. String FT_YESNO Y Y Cache    
  OSP_G_RsrcCosts View Resource and Role Costs Security privilege to view the resource cost. String FT_YESNO Y Y Cache    
  OSP_G_RunJobServices Administer Job Services Security privilege to administer a Job Service. String FT_YESNO Y Y Cache    
  OSP_G_TimesheetDates Edit Timesheet Dates Security privilege to edit timesheet dates. String FT_YESNO Y Y Cache    
  OSP_G_TrakView Edit Global Tracking Layouts Security privilege to edit global tracking layouts. String FT_YESNO Y Y Cache    
  OSP_G_Tsht Approve Resource Timesheets Security privilege to approve timesheets. String FT_YESNO Y Y Cache    
  OSP_G_User Edit Users Security privilege to edit users. String FT_YESNO Y Y Cache    
  OSP_G_ViewRoleProficiency View Resource Role Proficiency Security privilege to to view resource role proficiency. String FT_YESNO Y Y Cache    
  OSP_G_ViewSecureCodes View Secure Codes Security privilege to view secure codes. String FT_YESNO Y Y Cache    
  OSP_P_ActCodes Edit Project Activity Codes Security privilege to edit project activity codes. String FT_YESNO Y Y Cache    
  OSP_P_AddActCodes Add Project Activity Codes Security privilege to add project activity codes. String FT_YESNO Y Y Cache    
  OSP_P_AdminExtApp Administer Project External Applications Security privilege to administer project level external applications. String FT_YESNO Y Y Cache    
  OSP_P_ApplyActuals Apply Actuals Security privilege to apply actuals. String FT_YESNO Y Y Cache    
  OSP_P_AssignIssueForms Assign Issue Forms Security privilege to assign issue forms. String FT_YESNO Y Y Cache    
  OSP_P_Base Maintain Project Baselines Security privilege to maintain project baselines. String FT_YESNO Y Y Cache    
  OSP_P_BaselineAssign Assign Project Baseline Security privilege to assign project baseline. String FT_YESNO Y Y Cache    
  OSP_P_BaselineUpdate Run Baseline Update Security privilege to run baseline update. String FT_YESNO Y Y Cache    
  OSP_P_Calendar Edit Project Calendars Security privilege to edit project calendars. String FT_YESNO Y Y Cache    
  OSP_P_CheckInOut Check In/Check Out Project Security privilege to check-in/check-out projects. String FT_YESNO Y Y Cache    
  OSP_P_CloseOut Store Period Performance Security privilege to store period performance. String FT_YESNO Y Y Cache    
  OSP_P_Cost View Project Costs/Financials Security privilege to view project costs/financials. String FT_YESNO Y Y Cache    
  OSP_P_CreateProjRequest Create Project Requests and Processes Security privilege to create project requests and processes. String FT_YESNO Y Y Cache    
  OSP_P_CreateWorkgroup Create Workgroups Security privilege to create workgroups. String FT_YESNO Y Y Cache    
  OSP_P_DeleteActCodes Delete Project Activity Codes Security privilege to delete project activity codes. String FT_YESNO Y Y Cache    
  OSP_P_DeleteWorkgroup Delete Workgroups Security privilege to delete workgroups. String FT_YESNO Y Y Cache    
  OSP_P_EdReport Edit Project Reports Security privilege to edit project reports. String FT_YESNO Y Y Cache    
  OSP_P_EditExpProjectLink Edit Contract Management Project Link Security privilege to edit contract management project link. String FT_YESNO Y Y Cache    
  OSP_P_EditPeriodPerformance Edit Period Performance Security privilege to edit period performance. String FT_YESNO Y Y Cache    
  OSP_P_EditProjRequest Edit Project Request and Process Templates Security privilege to edit project request and process templates. String FT_YESNO Y Y Cache    
  OSP_P_EditRsrcCurve Edit Resource Curves Security privilege to edit resource curves. String FT_YESNO Y Y Cache    
  OSP_P_EditRsrcTeam Edit Global Resource and Role Teams Edit Global Resource Teams String FT_YESNO Y Y Cache    
  OSP_P_EditTemplate Add/Edit Project Template Documents Security privilege to add/edit project template documents. String FT_YESNO Y Y Cache    
  OSP_P_EditUdf Edit User Defined Fields Security privilege to edit User Defined Fields. String FT_YESNO Y Y Cache    
  OSP_P_EditWorkspace Modify Project Workspace and Workgroup Preferences Security privilege to modify project workspace and workgroup preferences. String FT_YESNO Y Y Cache    
  OSP_P_Level Level Resources Security privilege to level resources. String FT_YESNO Y Y Cache    
  OSP_P_Monitor Monitor Project Thresholds Security privilege to monitor project thresholds. String FT_YESNO Y Y Cache    
  OSP_P_Prop Edit Project Details Except Financials Security privilege to edit project details, except financial data. String FT_YESNO Y Y Cache    
  OSP_P_Publish Publish Project Website Security privilege to Publish Project Website. String FT_YESNO Y Y Cache    
  OSP_P_ResourceRequest Perform Activity Resource Requests Security privilege to perform activity resource request. String FT_YESNO Y Y Cache    
  OSP_P_RunGlobalChange Run Global Change Security privilege to run Global Change on the open project(s). String FT_YESNO Y Y Cache    
  OSP_P_Sched Schedule Project Security privilege to schedule, level, and apply actuals. String FT_YESNO Y Y Cache    
  OSP_P_SumProj Summarize Project Security privilege to summarize a project. String FT_YESNO Y Y Cache    
  OSP_P_Super Project SuperUser The Admin SuperUser has access to the entire system.  There must always be at least one user in the system with the Admin SuperUser privilege assigned.  This privilege cannot be deleted. String FT_YESNO Y Y Cache    
  OSP_P_ViewExpedition Import/View Contract Management Data Security privilege to import/view contract management data. String FT_YESNO Y Y Cache    
  OSP_P_WPsDocs Edit Project Work Products and Documents Security privilege to edit work products and documents. String FT_YESNO Y Y Cache    
  OSP_W_DeleteTask Delete Project Activities Delete Project Activities String FT_YESNO Y Y Cache    
  OSP_W_DeleteTaskTSActuals Delete Project Data with Timesheet Actuals Delete Project Activities with Timesheet Actuals String FT_YESNO Y Y Cache    
  OSP_W_EPSFin Edit EPS Financials Security privilege to edit the EPS financials. String FT_YESNO Y Y Cache    
  OSP_W_EPSNoFin Edit EPS Except Financials Security privilege to edit all EPS information except the financials. String FT_YESNO Y Y Cache    
  OSP_W_EditAssignmentForResourcePlanning Edit Assignments for Resource Planning Security privilege to edit high-level resource assignments. String FT_YESNO Y Y Cache    
  OSP_W_Est Project Top-Down Estimation Security privilege to run Top-Down Estimation on the project. String FT_YESNO Y Y Cache    
  OSP_W_Expense Edit Project Expenses Security privilege to edit the project expenses. String FT_YESNO Y Y Cache    
  OSP_W_Pred Edit Project Activity Relationships Security privilege to edit the activity relationships in the project. String FT_YESNO Y Y Cache    
  OSP_W_Risk Edit Project Thresholds, Issues and Risks Security privilege to edit project Thresholds, Issues, and Risks. String FT_YESNO Y Y Cache    
  OSP_W_TaskNoPred Add/Edit Project Activities Except Relationships Security privilege to edit all activity information except relationships. String FT_YESNO Y Y Cache    
  OSP_W_Tsht Approve Timesheets as Project Manager Security privilege to approve timesheets as Project Manager. String FT_YESNO Y Y Cache    
  OSP_W_WBSFin Edit Project WBS Financials Security privilege to edit the financials for the WBS. String FT_YESNO Y Y Cache    
  OSP_W_WBSNoFin Edit Project WBS Except Financials Security privilege to edit the WBS of the project except the financials. String FT_YESNO Y Y Cache    
  default_flag Default Identifies the security profile assigned to new users by default. String FT_YESNO Y Y Db    
  prof_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  prof_name Profile Name Name of security profile. String FT_TEXT Y   Db    
  row_count Security Profile Count Security Profile Count Integer FT_INT Y Y Calc    
  scope_type Profile Scope Scope of security profile. Security profiles have either global scope or project scope. String FT_STATICTYPE Y Y Db    
  superuser_flag Superuser Identifies the superuser profile.  Superuser profiles are automatically granted all privileges. String FT_YESNO Y Y Db    
                 
PROFPRIV                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  allow_flag Has Privilege Identifies whether the privilege is granted or not for the profile. String FT_YESNO Y Y Db    
  priv_num Security Privilege The security privilege. Integer <PK_FK> Y   Db    
  prof_id Security Profile The security profile. Integer <PK_FK> Y   Db    
  row_count Profile Privilege Count Profile Privilege Count Integer FT_INT Y Y Calc    
                 
PROJBASE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  base_type_id Baseline Type The baseline type assigned to the baseline.  The baseline types are defined by the administrator. Integer <FK>   Y Db    
  baseline_is_project_baseline_flag Project Baseline This flag determines which baseline will be used as the baseline for the project when summarizing. String FT_YESNO   Y Calc    
  current_baseline_flag Primary Baseline This flag determines which baseline will be used as the primary baseline for the project. String FT_YESNO   Y Calc    
  current_baseline_flag1 Secondary Baseline This flag determines which baseline will be used as the secondary baseline for the project. String FT_YESNO   Y Calc    
  current_baseline_flag2 Tertiary Baseline This flag determines which baseline will be used as the tertiary baseline for the project. String FT_YESNO   Y Calc    
  data_date Data Date The data date of the baseline. Date FT_START_DATE Y Y Calc    
  last_baseline_update_date Last Update Date Last date when the baseline was updated. Date FT_START_DATE Y Y Db    
  last_recalc_date Last Recalc Date The data date for the current project that is used for scheduling. Date FT_START_DATE Y Y Db    
  orig_proj_id Original Project The planned project from which the project baseline was created, if the current project is a project baseline. Integer <FK>   Db    
  plan_start_date Planned Start The planned start date of the project.  Used by the project scheduler. Date FT_START_DATE   Y Db    
  proj_id Unique ID Unique ID for the project. Integer <PK> Y   Db    
  proj_name Project Name The project name. String FT_TEXT   Calc    
  proj_short_name Project ID The Project ID. String FT_TEXT   Y Db    
  row_count Project Baseline Count Project Baseline Count Integer FT_INT Y Y Calc    
                 
PROJCOST                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  acct_id Cost Account The cost account associated with the project expense. Integer <FK>   Y Db    
  act_cost Actual Cost The actual cost for the project expense. Double FT_MONEY   Y Db    
  act_units Actual Units The actual number of units incurred for the expense. Double FT_FLOAT_3_DECIMALS   Y Calc    
  at_completion_units At Completion Units The sum of the Actual Units plus Remaining Units. Double FT_FLOAT_3_DECIMALS   Y Calc    
  auto_compute_act_flag Auto Compute Actuals Identifies whether the actual and remaining cost for the expense are computed automatically using the planned cost and the activity's schedule percent complete.  If this option is selected, the actual/remaining cost are automatically updated when project actuals are applied.  This assumes the expenses are made according to plan. String FT_YESNO   Y Db    
  cost_descr Expense Description The description of the expense. Memo <HTML>   Y Db(delayed    
  cost_item_id Unique ID Unique Id generated by the system. Integer <PK> Y   Db    
  cost_load_type Accrual Type The accrual type for the project expense. If the accrual type is Start of Activity, the entire expense cost are accrued at the start date of the activity. If the accrual type is End of Activity, the entire expense cost are accrued at the finish date of the activity.  If the accrual type is Uniform over Activity, the expense cost are accrued uniformly over the duration of the activity. String FT_STATICTYPE   Y Db    
  cost_name Expense Item The name of the project expense. String FT_TEXT   Db    
  cost_per_qty Price / Unit The planned price per unit for the project expense. This number is multiplied by the planned number of units to compute the planned cost. Double FT_MONEY   Db    
  cost_type_id Expense Category The expense category for the project expense. Integer <FK>   Y Db    
  expense_complete Expense % Complete Actual Cost / (Actual Cost + Remaining Cost) Double FT_PERCENT   Y Calc    
  over_budget_flag Over Budget Indicates whether the project expense is over budget. An expense is over budget when the actual cost + remaining cost exceeds the planned cost. String FT_YESNO   Y Calc    
  po_number Document Number The document number for the expense. Use this for the purchase order number, invoice number, requisition number, or similar, as needed. String FT_TEXT   Y Db    
  proj_id Project The project which owns the expense. Integer <FK> Y Y Db    
  qty_name Unit of Measure The value used to quantify the expense. Examples are square feet, cubic yards, and pounds. String FT_TEXT   Y Db    
  remain_cost Remaining Cost The remaining cost for the project expense.  Before actual expenses are made, remaining cost should be the same as planned cost.  While the activity is in progress, the remaining cost should be updated to reflect the estimated remaining cost required for the expense.  After the expense is completed, the remaining cost should be zero. Double FT_MONEY   Y Db    
  remain_units Remaining Units The remaining number of units to be incurred for the expense. Double FT_FLOAT_3_DECIMALS   Y Calc    
  row_count Project Expense Count The number of expenses in the band. Integer FT_INT Y Y Calc    
  target_cost Planned Cost The planned cost for the project expense. Double FT_MONEY   Y Db    
  target_qty Planned Units The planned number of units for the project expense. This number is multiplied by the price per unit to compute the planned cost. Double FT_FLOAT_3_DECIMALS   Y Db    
  task_id Activity Name The activity to which the project expense is linked.  Every project expense is associated with one activity in the project. Integer <FK>   Db    
  total_cost At Completion Cost The cost at completion is the sum of the actual plus remaining cost for the project expense. Computed as Actual Cost + Remaining Cost. Double FT_MONEY   Y Cache    
  vendor_name Vendor The name of the vendor providing the product or service associated with the expense. String FT_TEXT   Y Db    
                 
PROJECT                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  access_level Access Level Determine the ability to modify the contents of the current project beyond the root wbs level. All data that is modifiable on this project when it is closed, such as the project notebook and project level budgets, are not affected by this -- they are always editable if the current user has security access, and shared. Integer FT_STATICTYPE   Mem    
  acct_id Default Cost Account The cost account assigned to new activities and project expenses by default. Integer <FK>   Y Db    
  act_pct_link_flag Link Percent Complete With Actual Indicates whether actual units and cost should be recalculated when % complete changes. String FT_YESNO   Db    
  act_this_per_link_flag Link Actual and Actual This Period Units and Costs Indicates whether the actual units and cost are linked to the actual-this-period units and cost. String FT_YESNO   Db    
  add_act_remain_flag Add Actual To Remain Indicates whether to add Actual Units to Remaining Units or subtract Actual Units from At Complete Units when Actual Units and Cost are updated. String FT_YESNO   Db    
  add_by_name Added By The name of the user who added the project to the Project Management database. String FT_TEXT   Db    
  add_date Date Added The date on which the project was added to the Project Management database. Date FT_START_DATE   Db    
  allow_complete_flag Can resources mark activities completed Indicates whether primary resources can mark the project activities as completed. If not selected, a primary resource can only mark an activity as For Review. In this case the project manager reviews the activity and marks it as either Rejected or Completed. String FT_YESNO   Db    
  allow_neg_act_flag Allow Negative Actual Units Indicates if negative actual units are allowed on assignment when actual units are applied from timesheets. String FT_YESNO   Db    
  base_proj_id Baseline The name of the baseline that is set as the baseline to the project. Integer <FK>   Y Mem    
  base_proj_id1 Secondary Baseline The name of the baseline that is set as the second baseline to the project. Integer <FK>   Y Mem    
  base_proj_id2 Tertiary Baseline The name of the baseline that is set as the third baseline to the project. Integer <FK>   Y Mem    
  base_type_id Baseline Type The baseline type for the project baseline. Baseline types are used to categorize project baselines. Integer <FK>   Y Db    
  baseline_data_date Baseline Data Date The data date of the baseline. Date FT_START_DATE Y Y Calc    
  baseline_name Baseline The name of the baseline that is set as the baseline to the project. String FT_TEXT Y Y Calc    
  batch_sum_flag Enable Summarization When this field is true, the Summarizer service will automatically summarize the project.  If this is false, the project will be skipped during the summary run. String FT_YESNO   Db    
  checkout_date Date Checked Out The date on which the project was checked out. Date FIELD_TYPE_19 Y Y Db    
  checkout_flag Project Check-out Status Indicates that the project is currently checked out to an external file or database and is being managed remotely. String FT_STATICTYPE   Db    
  checkout_user_id Checked Out By The name of the user who checked out the project. Integer <FK> Y Y Db    
  chng_eff_cmp_pct_flag Resources Edit Percent Complete Indicates whether the project's resource update the remaining units or the percent complete for their activities using Timesheets. String FT_YESNO   Db    
  clndr_id Default Calendar The calendar assigned to new activities by default. Integer <FK>   Db    
  cost_qty_recalc_flag Cost Qty Recalc Flag Indicates when costs and quantities are linked, and costs are updated, whether the quantities should be updated or not. String FT_YESNO   Y Db    
  critical_drtn_hr_cnt Critical activities have float less than or equal to When an activity has total float which is less than or equal to this duration, the activity is marked as critical. Double FT_DURATION   Db    
  critical_path_type critical_path_type Critical Path Type String FT_TEXT   Db    
  data_date Data Date The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied. Date FT_START_DATE   Y Calc    
  def_complete_pct_type Default Percent Complete Type The percent complete type assigned to new activities by default. The Percent Complete Type controls whether the Activity % Complete is tied to the activity's Duration % Complete, Units % Complete, or Physical % Complete. String FT_STATICTYPE   Db    
  def_cost_per_qty Default Price / Unit Activities may have planned, actual, or remaining units without any resources being assigned. This price is used to estimate resource cost for such activities. This price is also used to compute cost for activities in cases where resources are assigned but the resources have no prices.  Resource cost is computed as the resource units multiplied by the price per time. Double FT_RSRC_COST_QTY   Db    
  def_duration_type Default Duration Type The duration type assigned to new activities by default. String FT_STATICTYPE   Db    
  def_qty_type Default Price Time Units The time units associated with the project's default price per time. String FT_STATICTYPE   Db    
  def_rate_type Rate Type The rate type assigned to new resource assignments by default. This is used to determine which price/unit will be set on the resource assignment. String FT_STATICTYPE   Y Db    
  def_rollup_dates_flag Drive Activity Dates Default Indicates whether the resource assignment flag 'Drive Activity Dates' should be set to True or False when a resource assignment is added. String FT_YESNO   Db    
  def_task_type Default Activity Type The default activity type for new activities in the project. String FT_STATICTYPE   Db    
  default_flag Default Project Indicates this is the default project within the set of currently-opened projects. The Default Project is used when adding new data where there is no obvious project context. For example, when the Activity grid is grouped by a global activity code and when there are multiple projects, if a user adds a new activity there is no way to know which project the new activity should belong to. In this situation, the new activity is assigned to the 'Default Project'. String FT_YESNO   Y Calc    
  fcst_start_date Project Forecast Start An alternate start date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in  a resource analysis layout, tracking or PA).  In the User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates. Date FT_START_DATE   Y Db    
  fy_start_month_num Fiscal Year Begins The month which marks the beginning of the fiscal year for the project. Integer FT_STATICTYPE   Db    
  guid Global Unique ID Global Unique Identifier that is generated by the system. String <GUID>   Y Db    
  last_checksum Last Checksum Indicates whether any project information has changed.  The Summarizer uses this field to know whether a project needs to be resummarized. Integer FT_INT   Y Db    
  last_fin_dates_id Financial Period   Integer <FK>   Y Db    
  last_tasksum_date Last Summarized Date The date the project was last summarized. Date FT_START_DATE   Y Db    
  msp_managed_flag MS Project Managed Flag If true, then this project is managed in Microsoft Project and is accessible in Project Management as read-only.  If false, then the project is managed in Project Management. String FT_YESNO   Db    
  new_fin_dates_id Financial Period   Integer <FK>   Mem    
  open_state Open State Whether the project is open (loaded into memory) or closed. String FT_STATICTYPE   Y Calc    
  orig_proj_id Original Project The planned project from which the project baseline was created, if the current project is a project baseline. Integer FT_INT   Y Db    
  plan_end_date Must Finish By The date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler. Date FT_END_DATE   Y Db    
  plan_start_date Planned Start The planned start date of the project.  Used by the project scheduler. Date FT_START_DATE   Db    
  priority_num Project Leveling Priority Priority for scheduling. Integer FT_INT   Db    
  proj_catg_approval_id Approval   Integer <FK>   Y Calc    
  proj_catg_division_id Division   Integer <FK>   Y Calc    
  proj_catg_location_id Location   Integer <FK>   Y Calc    
  proj_catg_priority_code_id Priority Code   Integer <FK>   Y Calc    
  proj_catg_strategic_alignment_id Strategic Alignment   Integer <FK>   Y Calc    
  proj_id Unique ID Unique ID. Integer <PK> Y   Db    
  proj_name Project Name The name of the project. The Project Name does not need to be unique. String FT_TEXT   Calc    
  proj_short_name Project ID A short code which uniquely identifies the project. String FT_TEXT   Db    
  proj_url Project Web Site URL The project website URL is the web address of the project's website. The project stakeholders can browse the project website at this URL using their web browsers. String FT_TEXT   Y Db    
  rem_target_link_flag Link Planned and At Completion Indicates whether planned units and cost are linked to At Completion units and cost for not started activities. String FT_YESNO   Db    
  reset_planned_flag Reset Planned to Remaining Indicates whether to reset Remaining duration and units to Original duration and Planned units, or to reset Original duration and Planned units to Remaining duration and units for not started activities or when marking an In-Progress activity as not started. String FT_YESNO   Db    
  risk_level Risk Level Project risk level: 5 - Very Low, 4 - Low, 3 - Medium, 2 - High, 1 - Very High. Integer FT_STATICTYPE   Y Db    
  root_wbs_id EPS Hierarchy Identifies the root WBS. Integer <FK> Y Y Cache    
  rsrc_multi_assign_flag Can assign resource multiple times to activity Indicates whether a resource can be assigned more than once to the same activity. This is useful when the resource is expected to perform more than one role on an activity, for example, documentation plus QA. String FT_YESNO   Y Db    
  rsrc_self_add_flag Can resources assign selves to activities Indicates whether Timesheets users are allowed to assign themselves to activities in this project. If not selected, the project manager must first assign resources to the activities before the Timesheets users, as resources, can access the activities. String FT_YESNO   Db    
  scd_end_date Schedule Finish The early finish date of the latest activity in the project, as computed by the project scheduler. Date FT_END_DATE Y Y Db    
  scope_level Scope Level Determines how much data to load for this project Integer FT_STATICTYPE   Y Cache    
  step_complete_flag Physical Percent Complete uses Steps Completed Indicates whether activity physical percent complete is automatically computed from the activity steps completed. String FT_YESNO   Db    
  strgy_priority_num Strategic Priority Range 1 to 10,000 Integer FT_INT   Y Db    
  sum_assign_level sum_assign_level   String FT_TEXT   Db    
  sum_base_proj_id Project Baseline Identifies the project's baseline to use for computing summaries. Integer FT_INT   Y Db    
  sum_data_date Summarized Data Date Identifies the data date of the project when it was last summarized -- only updated by summarizer. Date FT_START_DATE   Y Db    
  sum_only_flag Contains Summarized Data Only If True, then this project does not contain any detail data, and cannot be opened. Projects which have been consolidated from another location have this set to Y. String FT_YESNO   Db    
  task_code_base Activity ID Suffix The suffix is used for auto-numbering of Activity IDs.  When a new activity is created, the Activity ID is automatically generated using auto-numbering. Activity ID auto-numbering concatenates the prefix and the suffix, with the suffix incremented to make the code unique.   Example: 'A', '1000', '10' yields Activity IDs of 'A1010', 'A1020', 'A1030', etc. Integer FT_INT   Db    
  task_code_prefix Activity ID Prefix The prefix is used for auto-numbering of Activity IDs.  When a new activity is created, the Activity ID is automatically generated using auto-numbering. Activity ID auto-numbering concatenates the prefix and the suffix, with the suffix incremented to make the code unique.   Example: 'A', '1000', '10' yields Activity IDs of 'A1010', 'A1020', 'A1030', etc. String FT_TEXT   Db    
  task_code_prefix_flag Activity ID based on selected activity Indicates that the alphabetic prefix of the activity ID of the currently selected activity is used for the prefix of the new activity. String FT_YESNO   Db    
  task_code_step Activity ID Increment The increment is used for auto-numbering of Activity IDs.  When a new activity is created, the Activity ID is automatically generated using auto-numbering. Activity ID auto-numbering concatenates the prefix and the suffix, with the suffix incremented to make the code unique.   Example: 'A', '1000', '10' yields Activity IDs of 'A1010', 'A1020', 'A1030', etc. Integer FT_INT   Db    
  tot_funding Total Funding The total amount of funding contributed to the project by your funding sources. Double FT_MONEY Y Y Calc    
  use_project_baseline_flag use_project_baseline_flag   String FT_YESNO   Db    
  user_cost1 user_cost1 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost10 user_cost10 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost11 user_cost11 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost12 user_cost12 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost13 user_cost13 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost14 user_cost14 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost15 user_cost15 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost2 user_cost2 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost3 user_cost3 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost4 user_cost4 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost5 user_cost5 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost6 user_cost6 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost7 user_cost7 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost8 user_cost8 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_cost9 user_cost9 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_end_date1 user_end_date1 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date2 user_end_date2 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_number1 user_number1 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number10 user_number10 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number2 user_number2 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number3 user_number3 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number4 user_number4 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number5 user_number5 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number6 user_number6 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number7 user_number7 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number8 user_number8 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number9 user_number9 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_start_date1 user_start_date1 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date2 user_start_date2 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_text1 user_text1 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text2 user_text2 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text3 user_text3 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text4 user_text4 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text5 user_text5 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text6 user_text6 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  wbs_max_sum_level WBS Max Summarization Level The maximum level within the project's WBS to perform summarization - default to 1. Integer FT_INT   Y Db    
  web_local_root_path Web Site Root Directory Root directory for storing project website files before they are published to the web server. This directory is where the project website publisher places its output files. String FT_TEXT   Y Db    
                 
PROJEST                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  adj_mult_pct Adjustment Factor The adjustment, in percent, made to the estimated units before application to the activities. Integer FT_INT Y Y Db    
  adjusted_est_qty Adjusted Units The estimated units, including any adjustment, for application to the selected activities. Double FT_QTY Y   Calc    
  applied_flag Applied Indicates whether the estimate was applied to the activities. If not selected, the estimate was saved to the estimation history but not actually applied. String FT_YESNO Y Y Db    
  bu_cmplx_value Size/Complexity Bottom-up Integer FT_INT Y Y Db    
  est_date Date The date on which the estimation was made. Date FT_START_DATE Y   Db    
  est_name Estimate Name The unique name of the estimate. String FT_TEXT Y   Db    
  est_notes Assumptions & Notes Assumptions and notes associated with the estimate. Memo <HTML> Y Y Db(delayed    
  est_qty Estimated Units The estimated units, prior to any adjustment, for application to the selected activities. Double FT_QTY Y   Db    
  est_task_cnt Total Activities The total number of activities involved in the top-down estimation. Integer FT_INT Y Y Db    
  est_type Method The type of estimate. String FT_STATICTYPE Y   Db    
  fp_cmplx_value Total Degree of Influence The total degree of influence (TDI), used in top-down function point estimation. Integer FT_INT Y Y Db    
  fp_cnt Final Adjusted FP Count The final adjusted function point count, used in top-down function point estimation. Integer FT_INT Y Y Db    
  fp_prod_avg_value FP/Person-Month The average productivity in function points per person-month used in top-down function point estimation. Double FT_INT Y Y Db    
  fp_unadj_cnt Unadjusted FP Count The unadjusted function point count (UFP), used in top-down function point estimation. Integer FT_INT Y Y Db    
  proj_est_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  proj_id Project The project for which the estimate was made. Integer <FK> Y   Db    
  row_count Estimate History Count Estimate History Count Integer FT_INT Y Y Calc    
  rsrc_id Resource The resource for which the estimate was made. Scoping a top-down estimate by resource means that only the activities assigned to the selected resource, or to any child of the selected resource, are included in the estimate. Integer <FK> Y Y Db    
  rsrc_type Resource Type Indicates whether the resource is labor, nonlabor, or material. String FT_STATICTYPE Y   Db    
  wbs_id WBS The WBS for which the estimate was made. Scoping a top-down estimate by WBS means that only the activities associated with the selected WBS, or with any child element of the selected WBS, are included in the estimate. Integer <FK> Y Y Db    
                 
PROJFUND                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  fund_cost Amount The amount of funding for the source. Double FT_MONEY   Y Db    
  fund_id Funding Source Identifies the funding source. Integer <FK>   Db    
  fund_wt Fund Share Relative contribution of funding share. Double FT_PERCENT   Y Db    
  proj_fund_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  proj_id Project Identifies the project. Integer <FK>   Db    
  row_count Project Funding Assignment Count Project Funding Assignment Count Integer FT_INT Y Y Calc    
                 
PROJISSU                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  add_by_name Identified By The identifier of the issue.  This may be the name of the user who created the issue or Monitor, if the issue was automatically generated by the threshold monitor. String FT_TEXT   Db    
  add_date Date Identified The date when the issue was identified. Date FT_START_DATE   Y Db    
  baseline_name Baseline Name The name of the baseline that is set as the baseline to the project. String FT_TEXT Y Y Calc    
  hi_parm_value Upper Threshold The upper value of the threshold parameter which triggered the issue. Issues are triggered when the actual/observed parameters values are greater than or equal to the upper threshold. Double FT_VARIANT   Y Db    
  issue_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  issue_name Issue The name of the issue.  Issues which are automatically generated by the threshold monitor are named after the threshold parameter that triggered the issue. String FT_TEXT   Db    
  issue_notes Issue Notes Notes associated with the issue. Memo <HTML>   Y Db(delayed    
  issue_value Actual Value The actual value of the threshold parameter for the issue.  Issues are automatically generated by the threshold monitor when actual values of threshold parameters exceed target values. Double FT_VARIANT   Y Db    
  lo_parm_value Lower Threshold The lower value of the threshold parameter which triggered the issue. Issues are triggered when the actual/observed parameters values are less than or equal to the lower threshold. Double FT_VARIANT   Y Db    
  obs_id Responsible Manager The project manager from the project's OBS tree who is responsible for the issue. Integer <FK>   Db    
  priority_type Priority The priority of the issue. The priority can be Top, High, Normal, Low or Lowest. The priority can be used to group and sort by. String FT_STATICTYPE   Db    
  proj_id Project The project which owns the issue. Integer <FK> Y Y Db    
  resolv_date Resolution Date The expected resolution date for the issue. Date FT_START_DATE   Y Db    
  row_count Issue Count The number of issues that appear when banded. Integer FT_INT Y Y Calc    
  rsrc_id Resource The resource to which the issue applies. If a parent resource is selected, the issue applies to all child resources as well. Integer <FK>   Y Db    
  status_code Status The status of the issue; Open, On Hold or Closed. String FT_STATICTYPE   Db    
  task_id Activity The activity the issue applies to. Integer <FK>   Y Db    
  thresh_id Threshold The threshold which triggered the issue, if the issue was generated automatically by the threshold monitor. Integer <FK> Y Y Db    
  thresh_parm_id Threshold Parameter The threshold parameter associated with the issue. If the issue was generated automatically by the threshold monitor, this is the threshold parameter which triggered the issue. Integer <FK>   Y Db    
  track_view_id Tracking Layout The tracking layout associated with the issue. This tracking layout is automatically displayed when the Issue Navigator is used to navigate to the Tracking screen. Integer <FK>   Y Db    
  wbs_id WBS The WBS to which the issue applies. If a parent WBS is selected, the issue applies to all child elements as well. If the top WBS is selected, the issue applies to the entire project. Integer <FK>   Db    
                 
PROJPCAT                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  proj_catg_id Code Value Identifies the project category value. Integer <FK>   Db    
  proj_catg_type_id Project Code Unique ID generated by the system. Integer <PK_FK> Y   Db    
  proj_id Project Identifies the project. Integer <PK_FK> Y   Db    
  row_count Project Code Assignment Count Project Code Assignment Count Integer FT_INT Y Y Calc    
                 
PROJRISK                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  add_date Date Identified The date the risk was identified. Date FT_START_DATE   Db    
  exposure_equip_qty Exposure Nonlabor Units The net exposure of the risk on the project in terms of nonlabor units. The exposure nonlabor units are calculated as the impact nonlabor units times the risk probability. Double FT_QTY Y Y Calc    
  exposure_expense_cost Exposure Expense Cost The net exposure of the risk on the project in terms of expenses. The exposure expenses are calculated as the impact expenses times the risk probability. Double FT_MONEY Y Y Calc    
  exposure_mat_qty Exposure Material Units The net exposure of the risk on the project in terms of material units. The exposure material units are calculated as the impact material units times the risk probability. Double FT_QTY_MATERIAL Y Y Cache    
  exposure_work_qty Exposure Labor Units The net exposure of the risk on the project in terms of labor units. The exposure labor units are calculated as the impact labor units times the risk probability. Double FT_QTY Y Y Calc    
  impact_date Impact Date The estimated impact date of the risk. When the risk WBS impact is computed, only activities forward of the risk impact date are involved. Date FT_START_DATE   Db    
  impact_equip_qty Impact Nonlabor Units The estimated impact of the risk on the project in terms of nonlabor units, if the risk occurs. Double FT_QTY   Y Db    
  impact_expense_cost Impact Expense Cost The estimated  impact of the risk on the project in terms of expenses, if the risk occurs. Double FT_MONEY   Y Db    
  impact_mat_qty Impact Material Units The estimated impact of the risk on the project in terms of material units, if the risk occurs. Double FT_QTY_MATERIAL   Y Db    
  impact_task_cnt Impacted Activities The number of activities that will be impacted by the Risk. Integer FT_INT Y Y Cache    
  impact_work_qty Impact Labor Units The estimated impact of the risk on the project in terms of labor units, if the risk occurs. Double FT_QTY   Y Db    
  obs_id Responsible Manager The project manager from the project's OBS tree who is responsible for the risk. Integer <FK>   Db    
  prbly_pct Probability The probability of occurrence of the risk, as a percent. A probability of 50 means there is a 50% chance the risk will occur. Integer FT_INT   Y Db    
  priority_type Priority The priority of the risk.  The priority can be either Top, High, Normal, Low, or Lowest. String FT_STATICTYPE   Db    
  proj_id Project The project which owns the risk. Integer <FK> Y Y Db    
  remain_equip_cost Current Nonlabor Cost The current total nonlabor cost for the impacted activities, before risk impact. Double FT_MONEY Y Y Cache    
  remain_equip_qty Current Nonlabor Units The current total nonlabor units for the impacted activities, before risk impact. Double FT_QTY Y Y Cache    
  remain_expense_cost Current Expense Cost The current total expense cost for the impacted activities, before risk impact. Double FT_MONEY Y Y Cache    
  remain_mat_cost Current Material Cost The current total material cost for the impacted activities, before risk impact. Double FT_MONEY Y Y Cache    
  remain_mat_qty Current Material Units The current total material units for the impacted activities, before risk impact. Double FT_QTY_MATERIAL Y Y Cache    
  remain_total_cost Current Total Cost The current total expense cost, labor cost, nonlabor cost, and material cost for the impacted activities, before risk impact. Double FT_MONEY Y Y Cache    
  remain_work_cost Current Labor Cost The current  total labor cost for the impacted activities, before risk impact. Double FT_MONEY Y Y Cache    
  remain_work_qty Current Labor Units The current total labor units for the impacted activities, before risk impact. Double FT_QTY Y Y Cache    
  risk_descr Risk Description The description of the risk. Memo <HTML>   Y Db(delayed    
  risk_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  risk_name Risk The name of the risk. String FT_TEXT   Db    
  risk_type_id Risk Type Risk types are setup in the Admin Categories dialog.  These risk types can then be assigned to each risk to be used for sorting and grouping. Integer <FK>   Y Db    
  row_count Risk Count The number of risks that appear when banded. Integer FT_INT Y Y Calc    
  rsrc_id Resource The resource to which the risk applies. If a parent resource is selected, the risk applies to all child resources as well. Integer <FK>   Y Db    
  status_code Status The current status of the risk. String FT_STATICTYPE   Db    
  wbs_id WBS The WBS to which the risk applies. If a parent WBS is selected, the risk applies to all child elements as well. If the top WBS is selected, the risk applies to the entire project. Integer <FK>   Db    
                 
PROJTHRS                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  hi_parm_value Upper Threshold The upper value of the threshold parameter which will trigger an issue. An issue is raised by the threshold monitor when the actual/observed value of the threshold parameter is found to be greater than or equal to the upper threshold value. If the upper threshold value is null, it is ignored. Example: The Cost % of Budget upper threshold  is set to 120%. Whenever the actual cost is greater than or equal to 120% of planned, an issue is raised. Double FT_VARIANT   Y Db    
  issue_cnt Total Issues The total number of issues currently associated with the threshold. Integer FT_INT Y Y Mem    
  lo_parm_value Lower Threshold The lower value of the threshold parameter which will trigger an issue. An issue is raised by the threshold monitor when the actual/observed value of the threshold parameter is found to be less than or equal to the lower threshold value. If the lower threshold value is null, it is ignored. Example: The Total Float lower threshold  is set to 1d. Whenever the observed total float is less than or equal to 1d, an issue is raised. Double FT_VARIANT   Y Db    
  obs_id Responsible Manager The project manager from the project's OBS tree who is responsible for the threshold. Any issues generated from the threshold will have the same responsible OBS. Integer <FK>   Db    
  priority_type Priority The priority of any issues generated from the threshold. String FT_STATICTYPE   Db    
  proj_id Project The project which owns the threshold. Integer <FK> Y Y Db    
  row_count Threshold Count The number of thresholds in the band. Integer FT_INT Y Y Calc    
  status_code Status The current status of the threshold. String FT_STATICTYPE   Db    
  thresh_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  thresh_name Threshold The name of the Threshold. String FT_TEXT Y Y Calc    
  thresh_parm_id Threshold Parameter The threshold parameter which is monitored. Integer <FK>   Db    
  thresh_type Detail To Monitor The level of detail to monitor, either Activity or WBS.  The threshold parameter is calculated at the activity level or at the WBS level, whichever is selected. String FT_STATICTYPE   Db    
  track_view_id Tracking Layout The tracking layout for with any issues generated from the threshold. Integer <FK>   Y Db    
  wbs_id WBS The WBS to which the threshold applies. Only the activities and child WBS elements under the selected WBS are monitored for the threshold. If the top WBS is selected, the entire project is monitored. Integer <FK>   Db    
  window_end To Date The ending date of the time window that is monitored. Any activities or WBS elements with start/finish dates which intersect this time window are monitored. String FT_DATERANGE   Y Db    
  window_start From Date The starting date of the time window that is monitored. Any activities or WBS elements with start/finish dates which intersect this time window are monitored. String FT_DATERANGE   Y Db    
                 
PROJWBS                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  ACWP Actual Cost Actual Cost is the Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost as of the project data date. Same as the Actual Total Cost. Double FT_MONEY Y Y Calc    
  AV Accounting Variance Accounting Variance is the Planned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value. Double FT_MONEY Y Y Calc    
  CPI Cost Performance Index Cost Performance Index is the Earned Value divided by the Actual Cost. A value less than 1 indicates that Actual Cost have exceeded the Planned Value. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  CV Cost Variance Cost Variance is the Earned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value. Double FT_MONEY Y Y Calc    
  CVI Cost Variance Index Cost Variance Index is the Cost Variance divided by the Earned Value. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  EAC Estimate At Completion Cost Estimate Cost at Completion is the Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS. Double FT_MONEY Y Y Calc    
  OSP_E_DeleteProj Delete Project within EPS Delete project within EPS String FT_YESNO Y Y Cache    
  OSP_E_NewProj Create Project within EPS Create project within EPS String FT_YESNO Y Y Cache    
  OSP_G_AddEPSActCodes Add EPS Activity Codes Add EPS Activity Codes String FT_YESNO Y Y Cache    
  OSP_G_DeleteEPSActCodes Delete EPS Activity Codes Delete EPS Activity Codes String FT_YESNO Y Y Cache    
  OSP_G_EditEPSActCodes Edit EPS Activity Codes Edit EPS Activity Codes String FT_YESNO Y Y Cache    
  OSP_P_ActCodes Edit Project Activity Codes Edit Project Activity Codes String FT_YESNO Y Y Cache    
  OSP_P_AddActCodes Add Project Activity Codes Add Project Activity Codes String FT_YESNO Y Y Cache    
  OSP_P_AdminExtApp Administer Project External Applications Administer Project External Applications String FT_YESNO Y Y Cache    
  OSP_P_ApplyActuals Apply Actuals Apply Actuals String FT_YESNO Y Y Cache    
  OSP_P_AssignIssueForms Assign Issue Forms Assign Issue Forms String FT_YESNO Y Y Cache    
  OSP_P_Base Maintain Project Baselines Maintain Project Baselines String FT_YESNO Y Y Cache    
  OSP_P_BaselineAssign Assign Project Baseline Assign Project Baseline String FT_YESNO Y Y Cache    
  OSP_P_BaselineUpdate Run Baseline Update Run Baseline Update String FT_YESNO Y Y Cache    
  OSP_P_Calendar Edit Project Calendars Edit Project Calendars String FT_YESNO Y Y Cache    
  OSP_P_CheckInOut Check In/Check Out Project Check In/Check Out Project String FT_YESNO Y Y Cache    
  OSP_P_CloseOut Store Period Performance Store Period Performance String FT_YESNO Y Y Cache    
  OSP_P_Cost View Project Costs/Financials View Project Costs/Financials String FT_YESNO Y Y Cache    
  OSP_P_CreateWorkgroup Create Workgroups Create Workgroups String FT_YESNO Y Y Cache    
  OSP_P_DeleteActCodes Delete Project Activity Codes Delete Project Activity Codes String FT_YESNO Y Y Cache    
  OSP_P_DeleteWorkgroup Delete Workgroups Delete Workgroups String FT_YESNO Y Y Cache    
  OSP_P_EdReport Edit Project Reports Edit Project Reports String FT_YESNO Y Y Cache    
  OSP_P_EditExpProjectLink Edit Contract Management Project Link Edit Contract Management Project Link String FT_YESNO Y Y Cache    
  OSP_P_EditPeriodPerformance Edit Period Performance Edit Period Performance String FT_YESNO Y Y Cache    
  OSP_P_EditTemplate Add/Edit Project Template Documents Add/Edit Project Template Documents String FT_YESNO Y Y Cache    
  OSP_P_EditWorkspace Modify Project Workspace and Workgroup Preferences Modify Project Workspace and Workgroup Preferences String FT_YESNO Y Y Cache    
  OSP_P_Level Level Resources Level Resources String FT_YESNO Y Y Cache    
  OSP_P_Monitor Monitor Project Thresholds Monitor Project Thresholds String FT_YESNO Y Y Cache    
  OSP_P_Prop Edit Project Details Except Financials Edit Project Details Except Financials String FT_YESNO Y Y Cache    
  OSP_P_Publish Publish Project Website Publish Project Website String FT_YESNO Y Y Cache    
  OSP_P_ResourceRequest Perform Activity Resource Requests Perform Activity Resource Requests String FT_YESNO Y Y Cache    
  OSP_P_RunGlobalChange Run Global Change Run Global Change String FT_YESNO Y Y Cache    
  OSP_P_Sched Schedule Project Project Schedule, Level and Apply Actuals String FT_YESNO Y Y Cache    
  OSP_P_SumProj Summarize Project Summarize Project String FT_YESNO Y Y Cache    
  OSP_P_Super Project SuperUser Project SuperUser String FT_YESNO Y Y Cache    
  OSP_P_ViewExpedition Import/View Contract Management Data Import/View Contract Management Data String FT_YESNO Y Y Cache    
  OSP_P_WPsDocs Edit Project Work Products and Documents Edit Project Work Products and Documents String FT_YESNO Y Y Cache    
  OSP_W_DeleteTask Delete Project Activities Delete Project Activities String FT_YESNO Y Y Cache    
  OSP_W_DeleteTaskTSActuals Delete Project Data with Timesheet Actuals Delete Project Activities with Timesheet Actuals String FT_YESNO Y Y Cache    
  OSP_W_EPSFin Edit EPS Financials Edit EPS Financials String FT_YESNO Y Y Cache    
  OSP_W_EPSNoFin Edit EPS Except Financials Edit EPS Except Financials String FT_YESNO Y Y Cache    
  OSP_W_EditAssignmentForResourcePlanning Edit Assignments for Resource Planning Edit Assignments for Resource Planning String FT_YESNO Y Y Cache    
  OSP_W_Est Project Top-Down Estimation Project Top-Down Estimation String FT_YESNO Y Y Cache    
  OSP_W_Expense Edit Project Expenses Edit Project Expenses String FT_YESNO Y Y Cache    
  OSP_W_Pred Edit Project Activity Relationships Edit Project Activity Relationships String FT_YESNO Y Y Cache    
  OSP_W_Risk Edit Project Thresholds, Issues and Risks Edit Project Thresholds, Issues and Risks String FT_YESNO Y Y Cache    
  OSP_W_TaskNoPred Add/Edit Project Activities Except Relationships Edit Project Activities Except Relationships String FT_YESNO Y Y Cache    
  OSP_W_Tsht Approve Timesheets as Project Manager Approve Timesheets as Project Manager String FT_YESNO Y Y Cache    
  OSP_W_WBSFin Edit Project WBS Financials Edit Project WBS Financials String FT_YESNO Y Y Cache    
  OSP_W_WBSNoFin Edit Project WBS Except Financials Edit Project WBS Except Financials String FT_YESNO Y Y Cache    
  SPI Schedule Performance Index Schedule Performance Index is the Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  SV Schedule Variance Schedule Variance is the Earned Value minus the Planned Value. A negative value indicates that less work was actually performed than was scheduled. Double FT_MONEY Y Y Calc    
  SVI Schedule Variance Index Schedule Variance Index is the Schedule Variance divided by the Planned Value. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  TCPI To Complete Performance Index The To Complete Performance Index is (Budget at Completion - Earned Value) / (Estimate at Completion - Actual Cost). Double FT_FLOAT_2_DECIMALS Y Y Calc    
  VAC Variance At Completion Variance At Completion is the baseline Budget at Completion minus the Estimate at Completion Cost. A negative value indicates an estimated cost overrun. Double FT_MONEY Y Y Calc    
  act_cost Actual Total Cost Sum of all actual total cost in the project. Double FT_MONEY Y Y Calc    
  act_drtn_hr_cnt Actual Duration The actual duration of the WBS.  This information is rolled up from the children tasks. Double FT_DURATION   Y Calc    
  act_end_date Actual Finish The date on which the WBS is actually finished.  This information is rolled up from the children tasks. Date FT_END_DATE   Y Calc    
  act_equip_cost Actual Nonlabor Cost The actual cost for all nonlabor resources assigned to the activities under the WBS. Double FT_MONEY   Y Calc    
  act_equip_qty Actual Nonlabor Units The actual units for all nonlabor resources assigned to the activities under the WBS. Double FT_QTY   Y Calc    
  act_expense_cost Actual Expense Cost The total actual expense cost for all child activities. Double FT_MONEY Y Y Calc    
  act_mat_cost Actual Material Cost The total actual material cost for all child activities. Double FT_MONEY   Y Calc    
  act_pct_spent Cost % of Planned The proportion of the cost budget that has been spent.  Computed as actual total cost / baseline total cost. Double FT_PERCENT Y Y Calc    
  act_start_date Actual Start The date on which the WBS is started.  This information is rolled up from the children tasks. Date FT_START_DATE   Y Calc    
  act_this_per_equip_cost Actual This Period Nonlabor Cost The actual this period cost for all nonlabor resources assigned to the project. Double FT_MONEY   Y Calc    
  act_this_per_equip_qty Actual This Period Nonlabor Units The actual this period cost for all nonlabor resources assigned to the project. Double FT_QTY   Y Calc    
  act_this_per_mat_cost Actual This Period Material Cost The actual this period cost for all material resources assigned to the project. Double FT_MONEY   Y Calc    
  act_this_per_work_cost Actual This Period Labor Cost The actual this period cost for all labor resources assigned to the project. Double FT_MONEY   Y Calc    
  act_this_per_work_qty Actual This Period Labor Units The actual this period units for all labor resources assigned to the project. Double FT_QTY   Y Calc    
  act_work_cost Actual Labor Cost The total actual labor cost for all child activities. Double FT_MONEY   Y Calc    
  act_work_qty Actual Labor Units The total actual labor units for all child activities. Double FT_QTY   Y Calc    
  active_cnt Actual In-Progress Activities The number of child activities that have an actual start. Integer FT_INT Y Y Calc    
  anticip_end_date Anticipated Finish Anticipated finish date of WBS, Project and EPS elements.  User-entered - not dependent upon any other fields.  If there are no children, the anticipated finish  date will be the Finish date displayed in the columns. Date FT_END_DATE   Y Db    
  anticip_start_date Anticipated Start Anticipated start date of WBS, Project and EPS elements.  User-entered - not dependent upon any other fields.  If there are no children, the anticipated start  date will be the Start date displayed in the columns. Date FT_START_DATE   Y Db    
  av_work Accounting Variance - Labor Units Accounting Variance Labor Units is the Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units. Double FT_QTY Y Y Calc    
  bac Budget At Completion Budget at Completion is the Baseline Labor Cost + Baseline Nonlabor Cost + Baseline Expense Cost + Baseline Material Cost. Same as the Baseline Total Cost. Double FT_MONEY Y Y Calc    
  bac_work Budget At Completion (BAC) - Labor Units Budget At Completion (BAC) - Labor Units Double FT_QTY Y Y Calc    
  base_active_cnt BL In-Progress Activities The number of child activities in the Baseline that have an actual start. Integer FT_INT Y Y Calc    
  base_complete_cnt BL Completed Activities The number of child activities in the Baseline that have an actual finish. Integer FT_INT Y Y Calc    
  base_cost BL Total Cost The total cost for the WBS in the baseline, including labor resources, nonlabor resources, material resources, and project expenses. BL Total Cost = BL Labor Cost + BL Nonlabor Cost + BL Material Cost + BL Expense Cost. Double FT_MONEY Y Y Calc    
  base_drtn_hr_cnt BL Duration The latest baseline finish date - the earliest baseline start date. Double FT_DURATION Y Y Calc    
  base_end_date BL Project Finish The latest finish date of all the activities in the project baseline. Date FT_END_DATE Y Y Calc    
  base_equip_cost BL Nonlabor Cost The cost for all nonlabor resources in the baseline assigned to activities in the WBS. Computed from the baseline Planned (or At Completion) nonlabor units. If no resources are assigned, computed as the activity BL Nonlabor Units * Project Default Price/Time. Double FT_MONEY Y Y Calc    
  base_equip_qty BL Nonlabor Units The sum of Planned (or At Completion) Units in the baseline for all nonlabor resources assigned to activities in the WBS. Double FT_QTY Y Y Calc    
  base_expense_cost BL Expense Cost Sum of all expense cost in the baseline assigned to activities in the wbs. Double FT_MONEY Y Y Calc    
  base_mat_cost BL Material Cost The Planned (or At Completion) Cost in the baseline for all material resources assigned to activities in the WBS. Double FT_MONEY Y Y Calc    
  base_notstarted_cnt BL Not-Started Activities The number of child activities in the Baseline that have not started. Integer FT_INT Y Y Calc    
  base_start_date BL Project Start The earliest start date of all activities in the project baseline. Date FT_START_DATE Y Y Calc    
  base_work_cost BL Labor Cost The cost for all labor resources in the baseline assigned to activities in the WBS. Computed from the baseline Planned (or At Completion) labor units. If no resources are assigned, computed as the sum of the activities BL Labor Units * Project Default Price/Time. Double FT_MONEY Y Y Calc    
  base_work_qty BL Labor Units The sum of Planned (or At Completion) Units in the baseline for all labor resources assigned to activities in the WBS. Double FT_QTY Y Y Calc    
  bcwp Earned Value Cost Earned value cost for the project. Not editable. Double FT_MONEY Y Y Calc    
  bcws Planned Value Cost Planned cost of work scheduled for the project.  Not editable. Double FT_MONEY Y Y Calc    
  complete_cnt Actual Completed Activities The number of activities that have an Actual Finish in the wbs. Integer FT_INT Y Y Calc    
  cost_complete_pct Cost % Complete The percent complete of cost for all labor resources, nonlabor resources, material resources, and expenses for the wbs. Computed as Actual Total Cost / At CompleteTotal Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT Y Y Calc    
  cpi_work Cost Performance Index - Labor Units Cost Performance Index Labor Units is the Earned Value Labor Units / Actual Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  cur_var Current Variance Computed as the Current Budget minus the Total Spending Plan.  Not rolled up. Double FT_MONEY Y Y Calc    
  curr_budg Current Budget The Current Budget is the sum of the Original Budget plus the Approved and Pending budgets from the budget change log.  Not rolled up. Double FT_MONEY Y Y Calc    
  cv_work Cost Variance - Labor Units Calculated as Earned Value Labor Units - Actual Labor Units. Double FT_QTY Y Y Calc    
  cvi_work Cost Variance Index - Labor Units Cost Variance Index is the Cost Variance Labor Units divided by Earned Value Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  distrib_cur_budg Distributed Current Budget Computed as sum of the Current Budget values from one level lower.  Not rolled up. Double FT_MONEY Y Y Calc    
  drtn_pct_spent Duration % of Planned The actual Duration Percent of Original of the activity.  Computed as Actual Duration/BL Duration * 100.  The value can exceed 100. Double FT_PERCENT Y Y Calc    
  eac_work Estimate At Completion - Labor Units Calculated as Estimate At Completion - Labor Units. Double FT_QTY Y Y Calc    
  effort_complete_pct Units % Complete The percent complete of units for the resource assignments in the wbs. Computed as Actual Units / At Complete Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  end_date Finish The current finish date of the wbs. Date FT_END_DATE   Y Calc    
  equip_complete_pct Nonlabor Units % Complete The percent complete of units for all nonlabor resources for the wbs. Computed as Actual Nonlabor Units / At Complete Nonlabor Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  equip_cost_complete_pct Nonlabor Cost % Complete The percent complete of cost for all nonlabor resources assigned to the wbs. Computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  est_wt Est Weight The estimation weight for the WBS element, used for top-down estimation. Top-down estimation weights are used to calculate the proportion of units that each WBS element or activity receives in relation to its siblings in the WBS hierarchy.  Top-down estimation distributes estimated units in a top-down manner to activities using the WBS hierarchy. Double FT_FLOAT   Db    
  etc Estimate To Complete Calculated Estimate To Complete using specified technique. Double FT_MONEY Y Y Calc    
  etc_work_qty Estimate To Complete Labor Units Sum of all to-complete labor units in the wbs. Double FT_QTY   Y Calc    
  ev_compute_type E.V. Percent Complete Technique The technique used for computing earned-value percent complete for activities within the WBS. String FT_STATICTYPE   Y Db    
  ev_etc_compute_type E.V. Estimate-to-Complete Technique The technique for computing earned-value estimate-to-complete for activities within the WBS. String FT_STATICTYPE   Y Db    
  ev_etc_user_value E.V. Performance Factor User-defined performance factor, PF, for computing Earned Value Estimate to Complete. Estimate to Complete is PF * (Budget at Completion - Earned Value). Double FT_FLOAT_2_DECIMALS   Y Db    
  ev_user_pct E.V. Percent Complete User-defined percent complete for computing earned value for activities within the WBS. A value of, say, 25 means that 25% of the planned amount is earned when the activity is started and the remainder is earned when the activity is completed. Integer FT_INT   Y Db    
  expense_complete_pct Expense Cost % Complete The percent complete of cost for all expenses associated with the wbs. Computed as Actual Expense Cost / At Complete Expense Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT Y Y Calc    
  forecast_end_date Forecast Finish Date An alternate end date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in  a resource analysis layout, tracking or PA).  In User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates. Date FT_END_DATE   Y Calc    
  forecast_start_date Forecast Start Date An alternate start date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in  a resource analysis layout, tracking or PA).  In the User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates. Date FT_START_DATE   Y Calc    
  guid Global Unique ID Global Unique Identifier generated by the system. String <GUID>   Y Db    
  indep_remain_total_cost Independent ETC Total Cost User-entered Estimate to Complete Cost. Double FT_MONEY   Y Db    
  indep_remain_work_qty Independent ETC Labor Units User-entered Estimate to Complete Labor Units. Double FT_QTY   Y Db    
  input_list Work Product and Documents The set of work products and documents associated with the WBS element. String FT_TEXT Y Y Calc    
  mat_cost_complete_pct Material Cost % Complete The percent complete of cost for all material resources assigned to the wbs. Computed as Actual Material Cost / At Complete Material Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  node_type Node Type A node is either wbs, project, and eps. String FT_STATICTYPE Y Y Calc    
  notstarted_cnt Actual Not-Started Activities Number of activities that do not have an Actual Start in the wbs. Integer FT_INT Y Y Calc    
  obs_id Responsible Manager The project manager from the project's OBS tree who is responsible for the WBS. Integer <FK>   Db    
  orig_cost Original Budget Original budget for WBS element. Double FT_MONEY   Y Db    
  parent_wbs_id Parent WBS The parent WBS in the WBS hierarchy. Integer <FK_TREE>   Y Db    
  perfm_complete_pct Performance % Complete The performance percent complete is used to compute earned value and may be based on the Activity % Complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the WBS. The Performance % Complete specifies what percentage of the wbs planned worth has been earned so far. Double FT_PERCENT Y Y Calc    
  perfm_work_qty Earned Value Labor Units Earned value for the wbs. This field is calculated from the Earned Value technique specified for the wbs. Double FT_QTY Y Y Calc    
  phase_id Project Phase WBS category value.  Note that the label used for the WBS category is dynamic; it is controlled by the system administrator. Integer <FK>   Y Db    
  primary_base_end_date BL1 Finish The latest finish date of all the activities in the primary baseline. Date FT_END_DATE Y Y Calc    
  primary_base_start_date BL1 Start The earliest start date of all activities in the primary baseline. Date FT_START_DATE Y Y Calc    
  proj_catg_approval_id Approval   Integer <FK> Y Y Calc    
  proj_catg_division_id Division   Integer <FK> Y Y Calc    
  proj_catg_location_id Location   Integer <FK> Y Y Calc    
  proj_catg_priority_code_id Priority Code   Integer <FK> Y Y Calc    
  proj_catg_strategic_alignment_id Strategic Alignment   Integer <FK> Y Y Calc    
  proj_id Project The project which owns the WBS. Integer <FK> Y   Db    
  reend_date Remaining Early Finish The latest remaining finish of all activities in the wbs. Date FT_END_DATE   Y Calc    
  remain_cost Remaining Total Cost Sum of all remaining total cost in the wbs. Double FT_MONEY Y Y Calc    
  remain_drtn_hr_cnt Remaining Duration The remaining duration is calculated as the Latest Early Finish - Earliest Early Start (calendar of  the activity with the latest EF is used). Double FT_DURATION   Calc    
  remain_equip_cost Remaining Nonlabor Cost Sum of all remaining nonlabor cost for the activities in the wbs. Double FT_MONEY   Y Calc    
  remain_equip_qty Remaining Nonlabor Units Sum of all remaining nonlabor units for the activities in the wbs. Double FT_QTY   Y Calc    
  remain_expense_cost Remaining Expense Cost The remaining cost for all project expenses associated with the wbs. Double FT_MONEY Y Y Calc    
  remain_mat_cost Remaining Material Cost Sum of all remaining material cost for the activities in the wbs. Double FT_MONEY   Y Calc    
  remain_work_cost Remaining Labor Cost Sum of all remaining labor cost for the activities in the wbs. Double FT_MONEY   Y Calc    
  remain_work_qty Remaining Labor Units Sum of all remaining labor units for the activities in the wbs. Double FT_QTY   Y Calc    
  request_cost Proposed Budget The Proposed Budget is the sum of the Original Budget plus the Approved and Pending budgets from the budget change log.  Not rolled up. Double FT_MONEY Y Y Calc    
  restart_date Remaining Early Start The earliest remaining start of all activities assigned to the wbs. Date FT_START_DATE   Y Calc    
  sched_complete_pct Schedule % Complete The Schedule % Complete specifies how much of the wbs's baseline duration has been completed so far.  Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the BL Start, the Schedule % Complete is 0.  If the data date is later than the BL Finish, the Schedule % Complete is 100.   The Schedule % Complete indicates how much of the wbs duration should be currently completed, relative to the selected baseline. Double FT_PERCENT Y Y Calc    
  sched_work_qty Planned Value Labor Units Uneditable planned cost of work scheduled for the wbs. Double FT_QTY Y Y Calc    
  secondary_base_end_date BL2 Finish The latest finish date of all the activities in the secondary baseline. Date FT_END_DATE Y Y Calc    
  secondary_base_start_date BL2 Start The earliest start date of all activities in the secondary baseline. Date FT_START_DATE Y Y Calc    
  seq_num Sort Order Seq Num for sorting. Integer <SEQ> Db    
  spi_work Schedule Performance Index - Labor Units Calculated as Earned Value Labor Units divided by Planned Value Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  start_date Start The current start date of the wbs. Date FT_START_DATE Y Calc    
  status_code Project Status The WBS status can be either Open or Closed.  A WBS which is closed means that Timesheets users cannot access any activities within the WBS. String FT_STATICTYPE Db    
  steps_complete_pct Steps % Complete Percent complete using the WBS Milestones that are assigned to a WBS. Double FT_PERCENT Y Y Calc    
  sum_data_flag Contains Summary Data True when the WBS has been summarized. String FT_YESNO Y Db    
  sv_work Schedule Variance - Labor Units Schedule Variance Labor Units is the Earned Value Labor Units minus the Planned Value Labor Units. Double FT_QTY Y Y Calc    
  svi_work Schedule Variance Index - Labor Units Schedule Variance Index is the Schedule Variance Labor Units divided by Planned Value Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  task_cnt Total Activities The total number of activities under this WBS element. This includes all activities under any child WBS elements as well. Integer FT_INT Y Y Cache    
  task_sum_id Activity Summary   Integer <FK>   Y Calc    
  tertiary_base_end_date BL3 Finish The latest finish date of all the activities in the tertiary baseline. Date FT_END_DATE Y Y Calc    
  tertiary_base_start_date BL3 Start The earliest start date of all activities in the tertiary baseline. Date FT_START_DATE Y Y Calc    
  tmpl_guid Methodology Global Unique ID Global Unique Identifier generated by the system. String <GUID>   Y Db    
  tot_benefit_plan Total Benefit Plan Sum of the Monthly Benefit Plan.  Not rolled up. Double FT_MONEY Y Y Calc    
  tot_benefit_plan_tally Total Benefit Plan Tally Sum of the Monthly Benefit Plan Tally.  Not rolled up. Double FT_MONEY Y Y Calc    
  tot_spend_plan Total Spending Plan Sum of the Monthly Spending Plan.  Not rolled up. Double FT_MONEY Y Y Calc    
  tot_spend_plan_tally Total Spending Plan Tally Sum of the Monthly Spending Plan Tally.  Not rolled up. Double FT_MONEY Y Y Calc    
  total_cost At Completion Total Cost Sum of all at completion total cost in the project. Double FT_MONEY Y Y Calc    
  total_drtn_hr_cnt At Completion Duration Calculated as Finish - Start. Double FT_DURATION   Y Calc    
  total_equip_cost At Completion Nonlabor Cost Sum of all at completion nonlabor cost in the wbs. Double FT_MONEY   Y Calc    
  total_equip_qty At Completion Nonlabor Units Sum of all at completion nonlabor units in the wbs. Double FT_QTY   Y Calc    
  total_expense_cost At Completion Expense Cost Sum of all at completion expense cost in the wbs. Double FT_MONEY Y Y Calc    
  total_float_hr_cnt Total Float Calculated as Late Start - Early Start or Late Finish - Early Finish. Double FT_DURATION Y Y Calc    
  total_mat_cost At Completion Material Cost Sum of all at completion material cost in the wbs. Double FT_MONEY   Y Calc    
  total_work_cost At Completion Labor Cost Sum of all at completion labor cost in the wbs. Double FT_MONEY   Y Calc    
  total_work_qty At Completion Labor Units Sum of all at completion labor units in the project. Double FT_QTY   Y Calc    
  unalloc_budg Unallocated Budget Calculated as Total Current Budget - Distributed Current Budget. Double FT_MONEY Y Y Calc    
  undistrib_cur_var Undistributed Current Variance Computed as the Total Spending Plan minus the Total Spending Plan Tally.  Not rolled up. Double FT_MONEY Y Y Calc    
  user_cost1 user_cost1 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_prof_id Security Profile The security profile that the logged in user is assigned on the wbs. Integer <FK> Y Y Cache    
  vac_work Variance At Completion - Labor Units Budget at Completion is computed from the baseline. Double FT_QTY Y Y Calc    
  var_cost Variance - BL Total Cost Variance Total Cost is calculated as BL Total Cost - At Completion Total Cost. Double FT_MONEY   Y Calc    
  var_drtn_hr_cnt Variance - BL Duration Variance Duration is the duration between the activity's BL Duration and the At Completion Duration. Computed as BL Duration - At Completion Duration. Double FT_DURATION Y Y Calc    
  var_end_date_drtn_hr_cnt Variance - BL Finish Date Variance Finish Date is the duration between the BL Finish date and the Finish Date in the current project.  Calculated as BL Finish - Finish Date. Double FT_DURATION Y Y Calc    
  var_equip_cost Variance - BL Nonlabor Cost Variance Nonlabor Cost is calculated as BL Nonlabor Cost - At Completion Nonlabor Cost. Double FT_MONEY   Y Calc    
  var_equip_qty Variance - BL Nonlabor Units Variance Nonlabor Units is calculated as BL Nonlabor Units - At Completion Nonlabor Units. Double FT_QTY   Y Calc    
  var_expense_cost Variance - BL Expense Cost Variance Expense Cost is calculated as BL Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost). Double FT_MONEY   Y Calc    
  var_mat_cost Variance - BL Material Cost Variance Material Cost is calculated as BL Material Cost - At Completion Material Cost. Double FT_MONEY   Y Calc    
  var_start_date_drtn_hr_cnt Variance - BL Start Date Variance Start Date is the duration between the BL Start date and the Start Date in the current project.  Calculated as  BL Start - Start Date. Double FT_DURATION Y Y Calc    
  var_work_cost Variance - BL Labor Cost Variance Labor Cost is calculated as BL Labor Cost - At Completion Labor Cost. Double FT_MONEY   Y Calc    
  var_work_qty Variance - BL Labor Units Variance Labor Units is calculated as BL Labor Units - At Completion Labor Units. Double FT_QTY   Y Calc    
  wbs_concat_name WBS Code Unique identifier of a WBS element - the concatenation of the WBS element's own code together with its parents' codes. String FT_TEXT   Y Calc    
  wbs_id Unique ID Unique ID. Integer <PK> Y   Db    
  wbs_name WBS Name The name of the WBS element. String FT_TEXT   Db    
  wbs_path WBS Path The WBS Path is the same as the WBS Code without the project level displayed. String FT_TEXT Y Y Calc    
  wbs_short_name WBS Code A 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. String FT_TEXT   Db    
  work_complete_pct Labor Units % Complete The percent complete of units for all labor resources for the wbs. Computed as Actual Labor Units / At Complete Labor Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  work_cost_complete_pct Labor Cost % Complete The percent complete of cost for all labor resources assigned to the wbs. Computed as Actual Labor Cost / At Complete Labor Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
                 
PRPFOLIO                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  caption Project Project String FT_TEXT   Calc    
  pfolio_id Owner Owner Integer <PK_FK> Y   Db    
  row_count Portfolio WBS Relationship Count Portfolio WBS Relationship Count Integer FT_INT Y Y Calc    
  wbs_id WBS WBS Integer <PK_FK> Y   Db    
  wbs_name WBS Name WBS Name String FT_TEXT   Y Db    
  wbs_short_name WBS Code WBS Code String FT_TEXT   Y Db    
                 
RCATTYPE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  row_count Resource Code Count Resource Code Count Integer FT_INT Y Y Calc    
  rsrc_catg_short_len Max Code Length The maximum number of characters allowed for values of this Resource Code. Integer FT_INT   Db    
  rsrc_catg_type Resource Code Each Resource Code has a list of possible values, any of which can be assigned to a resource. Resource Codes allow you to classify and categorize resources. String FT_TEXT   Db    
  rsrc_catg_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
  super_flag Secure Code Indicates whether the code is controlled by a special security privilege. String FT_YESNO   Db    
                 
RCATVAL                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  parent_rsrc_catg_id Parent Code Identifies the parent resource code value. Integer <FK_TREE>   Y Db    
  rcatval_concat_name Resource Code Value The value of the resource code. String FT_TEXT   Calc    
  row_count Resource Code Value Count Resource Code Value Count Integer FT_INT Y Y Calc    
  rsrc_catg_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  rsrc_catg_name Code Description The description of the resource code. String FT_TEXT   Y Db    
  rsrc_catg_short_name Resource Code The value of the resource code. String FT_TEXT   Db    
  rsrc_catg_type_id Resource Code Identifies the resource code type. Integer <FK>   Db    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
                 
RISKCTRL                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  proj_id Project The project which owns the risk. Integer <FK> Db    
  risk_control Risk Control Plan A description of the control plan for the risk. Memo <HTML> Y Db(delayed    
  risk_id Risk Unique ID generated by the system. Integer <PK_FK> Y Db    
  row_count Risk Control Plan Count Risk Control Plan Count Integer FT_INT Y Y Calc    
                 
RISKTYPE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  risk_type Risk Type Risk types are used to categorize risks.  They are useful to standardize risks across projects.  The Risk types are setup in the Admin Categories dialog. String FT_TEXT   Db    
  risk_type_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  row_count Risk Type Count The number of risks in the band. Integer FT_INT Y Y Calc    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
                 
ROLERATE                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  cost_per_qty Price / Unit The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty2 Price / Unit2 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty3 Price / Unit3 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty4 Price / Unit4 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty5 Price / Unit5 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY   Y Db    
  role_id Role ID   Integer <FK> Y   Db    
  role_rate_id Unique ID   Integer <PK> Y   Db    
  row_count Role Price Count The number of role prices. Integer FT_INT Y Y Calc    
                 
ROLES                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  assigned_flag Assigned to Current Project Indicates whether the role is currently assigned to activities in the current project. String FT_YESNO Y Y Calc    
  cost_per_qty Price / Unit The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty2 Price / Unit2 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty3 Price / Unit3 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty4 Price / Unit4 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty5 Price / Unit5 The non-overtime price per time for the role.  Double FT_RSRC_COST_QTY Y Y Calc    
  def_cost_qty_link_flag Calculate costs from units   String FT_YESNO   Db    
  parent_role_id Parent Role The parent role in the role hierarchy. Integer <FK_TREE>   Y Db    
  role_concat_name Role ID Role value - the concatenation of the element's own code value together with its parents' code values. String FT_TEXT   Y Calc    
  role_descr Responsibilities The responsibilities for the role. Memo <HTML>   Y Db(delayed    
  role_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  role_name Role Name The name of the role. The role name uniquely identifies the role. String FT_TEXT   Db    
  role_short_name Role ID A short code which uniquely identifies the role. String FT_TEXT Db    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Db    
                 
RPT                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  proj_id Project The project which owns the report, if this is a project-level report. Integer <FK>   Y Db    
  row_count Report Count Report Count Integer FT_INT Y Y Calc    
  rpt_domain Report Domain   String FT_STATICTYPE   Calc    
  rpt_group_id Report Group The report group that the report is associated with. Integer <FK>   Y Db    
  rpt_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  rpt_name Report Name The name of the report. String FT_TEXT   Db    
  rpt_scope Report Scope The scope of the report - either Global or Project. Project-level reports are available only within the owner project.  Global reports are available from any project. String FT_STATICTYPE   Calc    
  rpt_state Report State The state of the report - Manual, Generated, or Generated-Modified. String FT_STATICTYPE   Y Db    
  rpt_type Report Type The type of report - Web, PM Only, PA Normal Mode Compatible, or PA Detail Mode Compatible. String FT_STATICTYPE   Db    
                 
RPTBATCH              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  proj_id Project The project which owns the batch report, if this is a project-level report batch. Integer <FK> Y Y Db    
  row_count Batch Report Count Batch Report Count Integer FT_INT Y Y Calc    
  rpt_batch_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  rpt_batch_name Batch Report The name of the batch report. String FT_TEXT   Db    
                 
RPTGROUP              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  parent_group_id Parent Report Group Identifies the parent report group. Integer <FK_TREE> Y Y Db    
  row_count Report Group Count Report Group Count Integer FT_INT Y Y Calc    
  rpt_group_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  rpt_group_name Report Group The name of the report group. String FT_TEXT Y   Db    
  rpt_group_seq_num Sort Order Sequence number for sorting. Integer <SEQ> Y   Db    
                 
RPTLIST                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  row_count Report Batch Assignment Count The number of reports in the band. Integer FT_INT Y Y Calc    
  rpt_batch_id Batch Report Unique ID generated by the system. Integer <PK_FK> Y   Db    
  rpt_id Report Unique ID generated by the system. Integer <PK_FK> Y   Db    
  seq_num Sort Order Sequence number for sorting. Integer <SEQ>   Y Db    
                 
RSRC                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  active_flag Active Indicates whether the resource is currently active. Nonactive resources may have left the organization but are not deleted from the system since they may have actual hours. String FT_YESNO   Y Db    
  assigned_flag Assigned to Current Project Indicates whether the resource is currently assigned to activities in the current project. String FT_YESNO Y Y Calc    
  auto_compute_act_flag Auto Compute Actuals Identifies whether the activity actual and remaining units, start dates and finish dates for the resource are computed automatically using the planned dates, planned units and the activity's schedule percent complete.  If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. This assumes that all work by the resource proceeds according to plan. String FT_YESNO   Y Db    
  clndr_id Calendar The calendar assigned to the resource.  Resource calendars can be assigned from the global calendar pool or the resource calendar pool. Integer <FK>   Db    
  cost_per_qty Price / Unit The nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to.  In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty2 Price / Unit2 The second nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty3 Price / Unit3 The third nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty4 Price / Unit4 The fourth nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY Y Y Calc    
  cost_per_qty5 Price / Unit5 The fifth nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY Y Y Calc    
  curr_id Currency Name The names of all defined currencies. Integer <FK>   Db    
  def_cost_qty_link_flag Calculate costs from units Setting to determine when resource assignments are added, should the cost and units be linked. String FT_YESNO   Y Db    
  def_qty_per_hr Default Units / Time The Default Units/Time setting determines what the Remaining Units/Time and Planned Units/Time  will be set to when a resource assignment is added. Double FT_QTY_RATE   Y Db    
  email_addr E-Mail Address Email address for the resource. String FT_TEXT   Y Db    
  employee_code Employee ID The resource identifier within the organization, typically the employee number or social security number. String FT_TEXT   Y Db    
  guid Global Unique ID Global Unique Identifier generated by the system. String <GUID>   Y Db    
  late_remain_equip_qty Remaining Late NonLabor Units   Double FT_QTY Y Y Calc    
  late_remain_work_qty Remaining Late Labor Units   Double FT_QTY Y Y Calc    
  max_qty_per_hr Max Units/Time The maximum work units per time this resource can perform on all their assigned activities. For example, a person working full time could perform 8 hours of work per day. A department of five people may perform at 5 days per day. Double FT_QTY_RATE Y Y Calc    
  office_phone Office Phone Office phone number for the resource. String FT_TEXT   Y Db    
  ot_factor Overtime Factor The overtime factor is used to compute the overtime price for the resource. Overtime price = nonovertime price * overtime factor. Double FT_FLOAT   Y Db    
  ot_flag Overtime Allowed Indicates whether the resource is allowed to  log overtime hours. String FT_YESNO   Db    
  other_phone Other Phone Other phone number for the resource - pager, home phone, cell phone, etc. String FT_TEXT   Y Db    
  parent_rsrc_id Parent Resource The parent resource in the resource hierarchy. Integer <FK_TREE>   Y Db    
  primary_flag Primary on Current Project Indicates if the resource is assigned as a primary resource in the current project. String FT_YESNO   Y Calc    
  role_code_list Role IDs The set of roles the resource can perform. String FT_TEXT Y Y Calc    
  role_id Primary Role The id of the role that is assigned as the resource's primary role. Integer <FK>   Y Db    
  role_list Roles The set of roles the resource can perform. String FT_TEXT Y Y Calc    
  rsrc_catg_classification_id Classification   Integer <FK>   Y Calc    
  rsrc_catg_employee_class_id Employee Class   Integer <FK>   Y Calc    
  rsrc_catg_office_id Office   Integer <FK>   Y Calc    
  rsrc_concat_name Resource Full Code Unique identifier of a resource - the concatenation of the cost account's own ID together with its parents' IDs. String FT_TEXT Y Y Calc    
  rsrc_id Unique ID The name of the report included in the batch report. Integer <PK> Y   Db    
  rsrc_name Resource Name The name of the resource. String FT_TEXT   Db    
  rsrc_notes Resource Notes Notes about the resource. Memo <HTML>   Y Db(delayed    
  rsrc_seq_num Sort Order Sequence number used for sorting. Integer <SEQ>   Db    
  rsrc_short_name Resource ID A short code which uniquely identifies the resource. String FT_TEXT   Db    
  rsrc_title_name Title The title of the resource. String FT_TEXT   Y Db    
  rsrc_type Resource Type Indicates whether the resource is labor, nonlabor, or material. String FT_STATICTYPE   Db    
  shift_id Shift ID of the shift associated with the Resource. Integer <FK>   Y Db    
  timesheet_flag Uses Timesheets Indicates whether the resource uses timesheets in Timesheets. String FT_YESNO   Y Db    
  ts_approve_user_id Timesheet Approval Manager The resource manager assigned to approve timesheets for the resource. Integer <FK>   Y Db    
  unit_id Unit of Measure The unit of measure assigned to a material resource. Integer <FK>   Y Db    
  user_id User Login Name User login name for the resource. Integer <FK>   Y Db    
  user_number1 user_number1 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number2 user_number2 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_text1 user_text1 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text2 user_text2 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text3 user_text3 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text4 user_text4 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
               
RSRCCURV              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  curv_id Unique ID Unique ID Integer <PK> Y   Db    
  curv_name Resource Curve Name Resource Curve Name String FT_TEXT   Db    
  curve_value_percent Curve Value Percent Curve Value Percent String FT_TEXT   Y Calc    
  default_flag Default Default String FT_YESNO Y Y Db    
  default_flag_descr Default Flag Description Default Flag Description String FT_TEXT   Calc    
  row_count Resource Curve Count Resource Curve Count Integer FT_INT Y Y Calc    
                 
RSRCRATE              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  cost_per_qty Price / Unit The nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to.  In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty2 Price / Unit2 The second nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty3 Price / Unit3 The third nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty4 Price / Unit4 The fourth nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty5 Price / Unit5 The fifth nonovertime price per time for the resource. This price is used to compute cost for any activities the resource is assigned to. In general, Cost = Units * Price per Time. Double FT_RSRC_COST_QTY   Y Db    
  max_qty_per_hr Max Units / Time The maximum work units per time this resource can perform on all their assigned activities. For example, a person working full time could perform 8 hours of work per day. A department of five people may perform at 5 days per day. Double FT_QTY_RATE   Y Db    
  row_count Resource Price Count Resource Price Count Integer FT_INT Y Y Calc    
  rsrc_id Resource Identifies the resource. Integer <FK>   Db    
  rsrc_rate_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  shift_period_id Shift The ID of the shift. Integer <FK>   Y Db    
  start_date Effective Date Effective date for the resource price and maximum units per time. Date FT_START_DATE   Db    
               
RSRCRCAT              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  row_count Resource Code Assignment Count Resource Code Assignment Count Integer FT_INT Y Y Calc    
  rsrc_catg_id Code Value The value of the resource code. Integer <FK>   Db    
  rsrc_catg_type_id Resource Code The resource code. Integer <PK_FK> Y   Db    
  rsrc_id Resource Unique ID generated by the system. Integer <PK_FK> Y   Db    
                 
RSRCROLE              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  primary_role_flag Primary Role Indicates whether the role is assigned as a Primary Role. String FT_YESNO   Y Calc    
  role_id Role Identifies the role. Integer <PK_FK> Y   Db    
  row_count Resource Role Assignment Count Resource Role Assignment Count Integer FT_INT Y Y Calc    
  rsrc_id Resource Unique ID generated by the system. Integer <PK_FK> Y   Db    
  skill_level Proficiency The resource's  proficiency at performing this role. Integer FT_STATICTYPE   Y Db    
                 
RSRCSEC                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  row_count Resource Security Count   Integer FT_INT Y Y Calc    
  rsrc_id Resource Access Resource access assigned to the user. Integer FT_INT   Y Db    
  user_id User Identifies the User assigned to the resource access node. Integer <PK_FK> Y   Db    
                 
SHIFT                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  row_count Shift Name Count Shift Name Count Integer FT_INT Y Y Calc    
  shift_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  shift_name Shift Name Name of the shift. String FT_TEXT   Db    
                 
SHIFTPER                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  formatted_duration Duration (Hrs) The duration of the shift. String FT_STATICTYPE   Calc    
  formatted_start_hour Start Hour The start time of the shift that is displayed on screen.  The values range from 00:00 to 24:00 String FT_STATICTYPE   Calc    
  row_count Shift Count Shift Count Integer FT_INT Y Y Calc    
  shift_id Shift Name The name of the shift. Integer <FK>   Db    
  shift_number Sort Order Sequence number for sorting. Integer <SEQ>   Calc    
  shift_period_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
                 
TASK                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  ACWP Actual Cost Actual Cost is the Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost as of the project data date. Same as the Actual Total Cost. Double FT_MONEY Y Y Cache    
  AV Accounting Variance Accounting Variance is the Planned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value. Double FT_MONEY Y Y Calc    
  BAC Budget At Completion Budget at Completion is the baseline Labor Cost + baseline Nonlabor Cost + baseline Expense Cost + baseline Material Cost. Same as the baseline Total Cost. Double FT_MONEY Y Y Cache    
  BCWP Earned Value Cost Earned Value Cost is the Budget at Completion * Performance % Complete. The method for computing the Performance Percent Complete depends on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the baseline. Double FT_MONEY Y Y Cache    
  BCWS Planned Value Cost Planned Value Cost is the Budget at Completion * Schedule % Complete.  The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far.  Budget at Completion is computed from the baseline. When an activity has assignments, the Planned Value Cost is calculated as the Budget At Completion * (Data date of current project - Baseline Assignment start date)/(Baseline Assignment start date) for each of the assignments and then summed to the activity level. Double FT_MONEY Y Y Cache    
  CPI Cost Performance Index Cost Performance Index is the Earned Value divided by the Actual Cost. A value less than 1 indicates that Actual Cost have exceeded the Planned Value. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  CV Cost Variance Cost Variance is the Earned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value. Double FT_MONEY Y Y Calc    
  CVI Cost Variance Index Cost Variance Index is the Cost Variance divided by Earned Value. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  EAC Estimate At Completion Cost Estimate Cost at Completion is the Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS. Double FT_MONEY Y Y Calc    
  ETC Estimate To Complete Estimate Cost to Complete is calculated from the baseline as either the Remaining Total Cost for the activity, or as the Performance Factor * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS. Double FT_MONEY Y Y Cache    
  SPI Schedule Performance Index Schedule Performance Index is the Earned Value divided by Planned Value.  A value less than 1 indicates that less work was actually performed than was scheduled. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  SV Schedule Variance Schedule Variance is the Earned Value minus the Planned Value. A negative value indicates that less work was actually performed than was scheduled. Double FT_MONEY Y Y Calc    
  SVI Schedule Variance Index Schedule Variance Index is the Schedule Variance divided by Planned Value. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  TCPI To Complete Performance Index The To Complete Performance Index is (Budget at Completion - Earned Value) / (Estimate at Completion - Actual Cost). Double FT_FLOAT_2_DECIMALS Y Y Calc    
  VAC Variance At Completion Variance At Completion is the Budget at Completion (baseline Total Cost) minus Estimate at Completion Cost. Double FT_MONEY Y Y Calc    
  account_code_list Cost Account IDs Account IDs and Expenses IDs for the list of accounts assigned to this activity. String FT_TEXT Y Y Calc    
  account_list Cost Accounts The list of accounts and expenses assigned to this activity. String FT_TEXT Y Y Calc    
  act_cost Actual Total Cost The Actual Total Cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses.  Actual Total Cost =  Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost. Double FT_MONEY Y Y Cache    
  act_drtn_hr_cnt Actual Duration Actual duration is the total working time from the activity actual start date to the actual finish date (for completed activities), or to the current data date (for in-progress activities). The actual working time is computed using the activity's calendar. Double FT_DURATION   Y Calc    
  act_end_date Actual Finish The date on which the activity is actually finished. Date FT_END_DATE   Y Db    
  act_equip_cost Actual Nonlabor Cost The actual cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Nonlabor Units * Project Default Price / Time. Double FT_MONEY   Y Cache    
  act_equip_qty Actual Nonlabor Units The actual units for all nonlabor resources assigned to the activity. Double FT_QTY   Y Db    
  act_expense_cost Actual Expense Cost The actual cost for all project expenses associated with the activity. Double FT_MONEY Y Y Cache    
  act_mat_cost Actual Material Cost The actual cost for all material resources assigned to the activity. Double FT_MONEY   Y Cache    
  act_pct_spent Cost % of Planned The activity actual cost percent of budget is the (Actual Total Cost / baseline Total Cost) * 100, or equivalently as (Actual Cost / Budget at Completion) * 100.  The value can exceed 100.  The baseline Total Cost is the activity’s Budget at Completion from the baseline. Double FT_PERCENT Y Y Calc    
  act_start_date Actual Start The date on which the activity is actually started. Date FT_START_DATE   Y Db    
  act_this_per_equip_cost Actual This Period Nonlabor Cost The actual this period cost for all nonlabor resources assigned to the activity. Double FT_MONEY   Y Cache    
  act_this_per_equip_qty Actual This Period Nonlabor Units The actual this period units for all nonlabor resources assigned to the activity. Double FT_QTY   Y Db    
  act_this_per_mat_cost Actual This Period Material Cost The actual this period cost for all material resources assigned to the activity. Double FT_MONEY   Y Cache    
  act_this_per_work_cost Actual This Period Labor Cost The actual this period cost for all labor resources assigned to the activity. Double FT_MONEY Y Cache    
  act_this_per_work_qty Actual This Period Labor Units The actual this period units for all labor resources assigned to the activity. Double FT_QTY   Y Db    
  act_work_cost Actual Labor Cost The actual cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Labor Units * Project Default Price / Time. Double FT_MONEY   Y Cache    
  act_work_qty Actual Labor Units The actual units for all labor resources assigned to the activity. Double FT_QTY   Y Db    
  active_cnt Actual In-Progress Activities The number of activities that are currently in progress. Integer FT_INT Y Y Cache    
  actv_code_crm_related_id CRM Related   Integer <FK>   Y Calc    
  actv_code_site_id Site   Integer <FK>   Y Calc    
  actv_code_sub_contractor_id Sub Contractor   Integer <FK>   Y Calc    
  actv_code_work_order_category_id Work Order Category   Integer <FK>   Y Calc    
  auto_compute_act_flag Auto Compute Actuals Identifies whether the actual and remaining units, start date, finish date, and percent complete for the activity are computed automatically using the planned dates, planned units and the activity's schedule percent complete.  If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. This assumes that all work for the activity proceeds according to plan. String FT_YESNO   Y Db    
  av_work Accounting Variance - Labor Units Accounting Variance Labor Units is the Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units. Double FT_QTY Y Y Calc    
  bac_work Budget At Completion (BAC) - Labor Units Budget at Completion - Labor Units is equal to the baseline Labor Units. Double FT_QTY Y Y Cache    
  base_active_cnt BL In-Progress Activities The number of activities that should be currently in progress, according to the project baseline. Integer FT_INT Y Y Cache    
  base_complete_cnt BL Completed Activities The number of activities that should be currently completed, according to the project baseline. Integer FT_INT Y Y Cache    
  base_cost BL Total Cost The total cost for the activity in the baseline, including labor resources, nonlabor resources, material resources, and project expenses. BL Total Cost = BL Labor Cost + BL Nonlabor Cost + BL Material Cost + BL Expense Cost. Double FT_MONEY Y Y Cache    
  base_drtn_hr_cnt BL Duration The duration for the activity in the project baseline. Double FT_DURATION Y Y Cache    
  base_end_date BL Project Finish The current finish date of the activity in the project baseline. When earned value is using planned dates then the finish will be set to the activity's planned finish date.  When earned value is using current dates then the finish will be set to the remaining early finish date when the activity is not started or in progress, then the actual finish date once the activity is completed. Date FT_END_DATE Y Y Cache    
  base_equip_cost BL Nonlabor Cost The cost for all nonlabor resources assigned to the activity in the baseline. Computed from the baseline Planned (or At Completion) nonlabor units. If no resources are assigned, computed as the activity BL Nonlabor Units * Project Default Price/Time. Double FT_MONEY Y Y Cache    
  base_equip_qty BL Nonlabor Units The sum of the Planned (or At Completion) Units for all nonlabor resources assigned to the activity in the project baseline. Double FT_QTY Y Y Cache    
  base_expense_cost BL Expense Cost The cost for all project expenses associated with the activity in the baseline.. Computed as the sum of the baseline Planned (or At Completion) expense cost. Double FT_MONEY Y Y Cache    
  base_mat_cost BL Material Cost The Planned (or At Completion) Cost for all material resources assigned to the activity in the baseline. Double FT_MONEY Y Y Cache    
  base_notstarted_cnt BL Not-Started Activities The number of activities that should be currently not started, according to the project baseline. Integer FT_INT Y Y Cache    
  base_start_date BL Project Start The current start date of the activity in the project baseline.  When earned value is using planned dates then the start will be set to the activity's planned start date.  When earned value is using current dates then the start will be set to the planned start date until the activity is started, then set to the actual start date. Date FT_START_DATE Y Y Cache    
  base_task_id Baseline Activity Identifies the primary baseline activity. Integer <FK>   Y Mem    
  base_task_id1 Baseline Activity Identifies the second baseline activity. Integer <FK>   Y Mem    
  base_task_id2 Baseline Activity Identifies the third baseline activity. Integer <FK>   Y Mem    
  base_work_cost BL Labor Cost The cost for all labor resources assigned to the activity in the primary baseline. Computed from the baseline Planned (or At Completion) labor units. If no resources are assigned, computed as the activity BL Labor Units * Project Default Price/Time. Double FT_MONEY Y Y Cache    
  base_work_qty BL Labor Units The sum of the Planned (or At Completion) Units for all labor resources assigned to the activity in the project baseline. Double FT_QTY Y Y Cache    
  calc_phys_complete_pct Physical % Complete The physical percent complete can either be user entered or calculated from the activity's weighted steps.  There is a project setting specifying this. Double FT_PERCENT Calc    
  clndr_id Calendar The calendar assigned to the activity.  Activity calendars can be assigned from the global calendar pool or the project calendar pool. Integer <FK> Db    
  complete_cnt Actual Completed Activities The number of activities that are currently completed. Integer FT_INT Y Y Cache    
  complete_pct Activity % Complete The activity percent complete. This value is tied to the activity Duration % Complete, Units % Complete, or Physical % Complete, depending on the setting for the activity's Percent Complete Type, which is one of ""Duration"", ""Units"", or ""Physical"".  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  complete_pct_type Percent Complete Type The activity percent complete type is one of ""Duration"", ""Units"", or ""Physical"". The percent complete type controls whether the Activity % Complete is tied to the Duration % Complete, the Units % Complete, or the Physical % Complete for the activity. Set the percent complete type to ""Duration"" for activities which are duration driven, for example, administration tasks and training classes.  Set the percent complete type to ""Physical"" for activities which are work-product driven, for example, creating a document or a product. Set the percent complete type to ""Units"" for activities which are work effort driven, for example, providing a consulting service. String FT_STATICTYPE Db    
  cost_complete_pct Cost % Complete The percent complete of cost for all labor resources, nonlabor resources, material resources, and expenses for the activity. Computed as Actual Total Cost / At Completion Total Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT Y Y Calc    
  cpi_work Cost Performance Index - Labor Units Cost Performance Index Labor Units is the Earned Value Labor Units / Actual Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  create_date Added Date The date this activity was inserted. Date FT_START_DATE Y Y Db    
  create_user Added By The name of the user who added the activity to the project. String FT_TEXT Y Y Db    
  critical_flag Critical Indicates whether the activity is critical. An activity is critical when its Total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project. String FT_YESNO Y   Cache    
  cstr_date Primary Constraint Date The constraint date for the activity, if the activity has a constraint. The activity's constraint type determines whether this is a start date or finish date.  Activity constraints are used by the project scheduler. Date FT_START_DATE   Y Db    
  cstr_date2 Secondary Constraint Date The second constraint date for the activity, if the activity has a constraint. Date FT_START_DATE   Y Db    
  cstr_type Primary Constraint The type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler.  Start date constraints are 'Start On', 'Start On or Before', 'Start On or After' and 'Mandatory Start'.  Finish date constraints are 'Finish On', 'Finish On or Before', 'Finish On or After' and 'Mandatory Finish'.  Another type of constraint, 'As Late as Possible', schedules the activity as late as possible based on the available free float. String FT_STATICTYPE   Y Db    
  cstr_type2 Secondary Constraint The second type of constraint applied to the activity start or finish date. String FT_STATICTYPE   Y Db    
  cv_work Cost Variance - Labor Units Cost Variance Labor Units is calculated as Earned Value Labor Units - Actual Labor Units. Double FT_QTY Y Y Calc    
  cvi_work Cost Variance Index - Labor Units Cost Variance Index Labor Units is the Cost Variance Labor Units divided by Earned Value Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  driving_path_flag Longest Path Indicates whether an activity is on the longest path. The longest path is defined as activities that are on the critical path and determine the end date of the project. Defining critical activities based on the longest path in the project provides an alternative to viewing critical activities based on float. String FT_YESNO Y   Db    
  drtn_complete_pct Duration % Complete The Original Duration is taken from the current plan, not from the baseline. Double FT_PERCENT   Y Calc    
  drtn_pct_spent Duration % of Planned The actual Duration Percent of Original of the activity.  Computed as Actual Duration / Original Duration * 100.  The value can exceed 100. Double FT_PERCENT Y Y Calc    
  duration_type Duration Type The duration type of the activity. One of ""Fixed Units per Time"", ""Fixed Duration"", or ""Fixed Units"".  For Fixed Units per 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 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. String FT_STATICTYPE   Db    
  eac_work Estimate At Completion - Labor Units Estimate At Completion Labor Units is calculated as Actual Labor Units + Estimate To Complete Labor Units.  (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the WBS.) Double FT_QTY Y Y Calc    
  early_end_date Early Finish The earliest possible date the activity can finish. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability. Date FT_END_DATE Y Y Db    
  early_start_date Early Start The earliest possible date the remaining work for the activity can begin. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability. Date FT_START_DATE Y Y Db    
  effort_complete_pct Units % Complete The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as Actual Units / At Completion Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  end_date Finish The current finish date of the activity.  Set to the activity remaining early finish date while the activity is not started or in progress, and the actual finish date once the activity is completed. Date FT_END_DATE   Cache    
  equip_complete_pct Nonlabor Units % Complete The percent complete of units for all nonlabor resources for the activity. Computed as Actual Nonlabor Units / At Completion Nonlabor Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  equip_cost_complete_pct Nonlabor Cost % Complete The percent complete of cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  est_wt Est Weight The estimation weight for the activity, used for top-down estimation. Top-down estimation weights are used to calculate the proportion of units that each activity receives in relation to the other activities within the same WBS. Top-down estimation distributes estimated units in a top-down manner to activities using the WBS hierarchy. Double FT_FLOAT   Db    
  etc_work_qty Estimate To Complete Labor Units The estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Planned Labor Units - Planned Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS. Double FT_QTY   Y Cache    
  expect_end_date Expected Finish The date the activity is expected to be finished according to the progress made on the activity's work products. The expected finish date is entered manually by people familiar with progress of the activity's work products. Date FT_END_DATE   Y Db    
  expense_complete_pct Expense Cost % Complete The percent complete of cost for all expenses associated with the activity. Computed as Actual Expense Cost / At Completion Expense Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT Y Y Calc    
  external_early_start_date External Early Start The External Early Start date is the date the external relationship was scheduled to finish.  This date may be used to calculate the start date of the current activity during scheduling.  This field is populated on import when an external relationship is lost. Date FIELD_TYPE_19 Y Y Db    
  external_late_end_date External Late Finish The External Late Finish date is the late start date of lost the external relationship.  This date may be used to calculate the finish date of the current activity during scheduling.  This field is populated on import when a successor relationship is lost. Date FIELD_TYPE_19 Y Y Db    
  float_path Float Path The project scheduler determines the most critical and sub-critical paths. The float path field identifies the critical path that each activity is on. The number starts from 1 (where 1 is most critical) to the max number of float paths identified by the scheduler.  This field is used when determining multiple float paths using the Free Float and Total Float method. Integer FT_INT Y Y Db    
  float_path_order Float Path Order This field is computed by the project scheduler and identifies the order in which the activities were processed within the float path. Integer FT_INT Y Y Db    
  free_float_hr_cnt Free Float The amount of time the activity can be delayed before delaying the start date of any successor activity. Double FT_DURATION Y Y Db    
  guid Global Unique ID Global Unique ID generated by the system. String <GUID>   Y Db    
  input_list Work Products and Documents The list of work products and documents associated with the activity. String FT_TEXT Y Y Calc    
  late_end_date Late Finish The latest possible date the activity must finish without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability. Date FT_END_DATE Y Y Db    
  late_start_date Late Start The latest possible date the remaining work for the activity must begin without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability. Date FT_START_DATE Y Y Db    
  lock_plan_flag Lock Remaining Indicates that the planned labor and nonlabor units for the activity will not be modified by top-down estimation. String FT_YESNO   Y Db    
  mat_cost_complete_pct Material Cost % Complete The percent complete of cost for all material resources assigned to the activity. Computed as Actual Material Cost / At Completion Material Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  notstarted_cnt Actual Not-Started Activities The number of activities that are currently not started. Integer FT_INT Y Y Cache    
  perfm_complete_pct Performance % Complete The activity performance percent complete. The performance percent complete is used to compute earned value and may be based on the Activity % Complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the activity's WBS. The Performance % Complete specifies what percentage of the activity's planned worth has been earned so far. Double FT_PERCENT Y Y Calc    
  perfm_work_qty Earned Value Labor Units Earned Value Labor Units Performed is the portion of the baseline Labor Units that is actually completed as of the project data date.  Computed as baseline Labor Units * Performance % Complete.  The Earned Value Labor Units is essentially the labor units earned value for the activity.  The method for computing the Performance % Complete depends on the earned value technique selected for the activity's WBS.  The baseline Labor Units in taken from the baseline. Double FT_QTY Y Y Calc    
  pred_list Predecessors The list of activities assigned as predecessors to this activity. String FT_TEXT Y Y Calc    
  primary_base_active_cnt BL1 In-Progress Activities   Integer FT_INT Y Y Cache    
  primary_base_complete_cnt BL1 Completed Activities   Integer FT_INT Y Y Cache    
  primary_base_cost BL1 Total Cost   Double FT_MONEY Y Y Cache    
  primary_base_drtn_hr_cnt BL1 Duration   Double FT_DURATION Y Y Cache    
  primary_base_end_date BL1 Finish The current finish date of the activity in the primary baseline. When earned value is using planned dates then the finish will be set to the activity's planned finish date.  When earned value is using current dates then the finish will be set to the remaining early finish date when the activity is not started or in progress, then the actual finish date once the activity is completed. Date FT_END_DATE Y Y Cache    
  primary_base_equip_cost BL1 Nonlabor Cost The cost at completion for all nonlabor resource assignments in the current baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  primary_base_equip_qty BL1 Nonlabor Units   Double FT_QTY Y Y Cache    
  primary_base_expense_cost BL1 Expense Cost The cost at completion for all project expenses in the current baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  primary_base_mat_cost BL1 Material Cost   Double FT_MONEY Y Y Cache    
  primary_base_notstarted_cnt BL1 Not-Started Activities   Integer FT_INT Y Y Cache    
  primary_base_start_date BL1 Start The current start of the activity in the primary baseline. When earned value is using planned dates then the start will be set to the activity's planned start date.  When earned value is using current dates then the start will be set to the planned start date until the activity is started, then set to the actual start date. Date FT_START_DATE Y Y Cache    
  primary_base_work_cost BL1 Labor Cost The cost at completion for all labor resource assignments in the current baseline associated with the cost account. Double FT_MONEY Y Y Cache    
  primary_base_work_qty BL1 Labor Units   Double FT_QTY Y Y Cache    
  priority_type Activity Leveling Priority The activity priority can be used to prioritize activities in a project when performing resource leveling. String FT_STATICTYPE   Db    
  proj_base_task_id Baseline Activity   Integer <FK>   Y Mem    
  proj_catg_approval_id Approval   Integer <FK>   Y Calc    
  proj_catg_division_id Division   Integer <FK>   Y Calc    
  proj_catg_location_id Location   Integer <FK>   Y Calc    
  proj_catg_priority_code_id Priority Code   Integer <FK>   Y Calc    
  proj_catg_strategic_alignment_id Strategic Alignment   Integer <FK>   Y Calc    
  proj_id Project Project Integer <FK> Y   Db    
  reend_date Remaining Early Finish The date the remaining work for the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date.  This is the finish date that Timesheets users follow. Date FT_END_DATE   Y Db    
  rem_late_end_date Remaining Late Finish Remaining late end date is calculated by the scheduler. Date FT_END_DATE Y Y Db    
  rem_late_start_date Remaining Late Start Remaining late start date is calculated by the scheduler. Date FT_START_DATE Y Y Db    
  remain_cost Remaining Total Cost The remaining total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses.  Remaining Total Cost =  Remaining Labor Cost + Remaining Nonlabor Cost + Remaining Material Cost + Remaining Expense Cost. Double FT_MONEY Y Y Cache    
  remain_drtn_hr_cnt Remaining Duration Remaining duration is the total working time from the activity remaining start date to the remaining finish date. The remaining working time is computed using the activity's calendar. Before the activity is started, the remaining duration is the same as the Original Duration. After the activity is completed the remaining duration is zero. Double FT_DURATION   Db    
  remain_equip_cost Remaining Nonlabor Cost The remaining cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Nonlabor Units * Project Default Price / Time. Double FT_MONEY   Y Cache    
  remain_equip_qty Remaining Nonlabor Units The remaining units for all nonlabor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity.  Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero. Double FT_QTY   Y Db    
  remain_expense_cost Remaining Expense Cost The remaining cost for all project expenses associated with the activity. Double FT_MONEY Y Y Cache    
  remain_float_hr_cnt Remaining Float The amount of time remaining by which the activity can be delayed before delaying the project finish date. Computed as Late Finish - Remaining Finish.  If the remaining finish is the same as the early finish ( in general, when the activity is not started), then the remaining float is the same as the total float. Double FT_DURATION Y Y Calc    
  remain_mat_cost Remaining Material Cost The remaining cost for all material resources assigned to the activity. Double FT_MONEY   Y Cache    
  remain_work_cost Remaining Labor Cost The remaining cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Labor Units * Project Default Price / Time. Double FT_MONEY   Y Cache    
  remain_work_qty Remaining Labor Units The remaining units for all labor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity.  Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero. Double FT_QTY   Y Db    
  resource_code_list Resource IDs Resource IDs for the list of resources assigned to this activity. String FT_TEXT Y Y Calc    
  resource_list Resources The list of resources assigned to this activity. String FT_TEXT Y Y Calc    
  restart_date Remaining Early Start The date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager.  Before the activity is started, the remaining start date is the same as the planned start date.  This is the start date that Timesheets users follow. Date FT_START_DATE   Y Db    
  resume_date Resume Date The date progress is resumed on an activity. Date FT_START_DATE   Y Db    
  rev_fdbk_flag New Feedback Indicates that the primary resource has sent feedback notes about this activity which have not been reviewed yet. String FT_YESNO   Y Db    
  review_end_date Review Finish The finish date of the activity as proposed by the primary resource using Timesheets, while the activity is in ""For Review"" state. If the project manager approves the activity completion, the Review Finish is copied to the Actual Finish. Date FT_END_DATE Y Y Db    
  review_type Review Status The activity review status is set to 'For Review' by the primary resource when he feels the activity is completed but when primary resources are not allowed to mark activities as 'Completed'. The project manager must either mark the activity as 'OK' or reject the work by setting the review status to 'Rejected'. The primary resource must resubmit the activity later. String FT_STATICTYPE   Db    
  role_code_list Role IDs Role IDs for the list of roles assigned to this activity. String FT_TEXT Y Y Calc    
  role_list Roles The list of roles assigned to this activity. String FT_TEXT Y Y Calc    
  row_count Activity Count The total number of activities that are in the band. Integer FT_INT Y Y Calc    
  rsrc_id Primary Resource Primary Resource Integer <FK>   Y Db    
  sched_complete_pct Schedule % Complete The activity schedule percent complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far.  Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline Start, the Schedule % Complete is 0.  If the data date is later than the baseline Finish, the Schedule % Complete is 100.   The Schedule % Complete indicates how much of the activity duration should be currently completed, relative to the selected baseline. Double FT_PERCENT Y Y Calc    
  sched_work_qty Planned Value Labor Units Planned Value Labor Units Scheduled is the portion of the baseline Labor Units that is scheduled to be completed as of the project data date.  Computed as baseline Labor Units * Schedule % Complete.  The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far.  The baseline Labor Units is taken from the baseline. Double FT_QTY Y Y Calc    
  secondary_base_end_date BL2 Finish The current finish date of the activity in the secondary baseline.  When earned value is using planned dates then the finish will be set to the activity's planned finish date.  When earned value is using current dates then the finish will be set to the remaining early finish date when the activity is not started or in progress, then the actual finish date once the activity is completed. Date FT_END_DATE Y Y Cache    
  secondary_base_start_date BL2 Start The current start date of the activity in the secondary baseline.  When earned value is using planned dates then the start will be set to the activity's planned start date.  When earned value is using current dates then the start will be set to the planned start date until the activity is started, then set to the actual start date. Date FT_START_DATE Y Y Cache    
  spi_work Schedule Performance Index - Labor Units Schedule Performance Index Labor Units is the Earned Value Labor Units divided by Planned Value Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  start_date Start The current start date of the activity.  Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started. Date FT_START_DATE   Cache    
  status_code Activity Status The current status of the activity, either Not Started, In Progress, or Completed. String FT_STATICTYPE   Db    
  step_active_cnt Steps In Progress The number of steps that are currently in progress. Integer FT_INT Y Y Calc    
  step_cnt Activity Step Count The total number of steps assigned to the activity. Integer FT_INT Y Y Calc    
  step_complete_cnt Steps Completed The number of steps that are currently completed. Integer FT_INT Y Y Calc    
  step_notstarted_cnt Steps Not Started The number of steps that are currently not started. Integer FT_INT Y Y Calc    
  succ_list Successors The list of activities assigned as successors to this activity. String FT_TEXT Y Y Calc    
  suspend_date Suspend Date The date progress is suspended on an activity. Date FT_END_DATE Y Db    
  sv_work Schedule Variance - Labor Units Schedule Variance Labor Units is the Earned Value Labor Units minus Planned Value Labor Units. Double FT_QTY Y Y Calc    
  svi_work Schedule Variance Index - Labor Units Schedule Variance Index is the Schedule Variance Labor Units divided by the Planned Value Labor Units. Double FT_FLOAT_2_DECIMALS Y Y Calc    
  target_cost Planned Total Cost The planned total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Planned Total Cost =  Planned Labor Cost + Planned Nonlabor Cost + Planned Material Cost + Planned Expense Cost. Double FT_MONEY Y Y Cache    
  target_drtn_hr_cnt Planned Duration Original Duration is the total working time from the activity planned start date to the planned finish date. The planned working time is computed using the activity's calendar. Double FT_DURATION   Db    
  target_end_date Planned Finish The date the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager.  This date is not changed by the project scheduler after the activity has been started. Date FT_END_DATE   Db    
  target_equip_cost Planned Nonlabor Cost The planned cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Planned Nonlabor Units * Project Default Price / Time. Double FT_MONEY   Y Cache    
  target_equip_qty Planned Nonlabor Units The planned units for all nonlabor resources assigned to the activity. Double FT_QTY   Y Db    
  target_expense_cost Planned Expense Cost The planned cost for all project expenses associated with the activity. Double FT_MONEY Y Y Cache    
  target_mat_cost Planned Material Cost The planned cost for all material resources assigned to the activity. Double FT_MONEY   Y Cache    
  target_start_date Planned Start The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. Date FT_START_DATE   Db    
  target_work_cost Planned Labor Cost The planned costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Planned Labor Units * Project Default Price / Time. Double FT_MONEY   Y Cache    
  target_work_qty Planned Labor Units The planned units for all labor resources assigned to the activity. Double FT_QTY   Y Db    
  task_code Activity ID A short ID which uniquely identifies the activity within the project. String FT_TEXT   Db    
  task_fdbk Feedback from Primary Resource Comments about the activity from the activity's primary resource. Memo <HTML> Y Y Calc    
  task_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  task_name Activity Name The name of the activity. The activity name does not have to be unique. String FT_TEXT   Db    
  task_note Notes to Resources Managers write notes to resources pertaining to the activity and then these notes can be viewed by the resource in Project Management. Memo <HTML>   Y Calc    
  task_type Activity Type The type of activity, either  'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone' or 'Finish Milestone'.   A Task Dependent activity is scheduled using the activity's calendar rather than the calendars of the assigned resources.  A Resource Dependent activity is scheduled using the calendars of the assigned resources.  This type is used when several resources are assigned to the activity, but they may work separately.  A Start/Finish Milestone is a zero-duration activity, marking a significant start/end of project event. A Level of Effort activity has a duration which is determined by its dependent activities. Administration-type activities are typically level of effort. String FT_STATICTYPE   Db    
  taskrsrc_cnt Activity Resource Assignment Count The number of resources assigned to the activity. Integer FT_INT Y Y Cache    
  tertiary_base_end_date BL3 Finish The current finish date of the activity in the tertiary baseline.  When earned value is using planned dates then the finish will be set to the activity's planned finish date.  When earned value is using current dates then the finish will be set to the remaining early finish date when the activity is not started or in progress, then the actual finish date once the activity is completed. Date FT_END_DATE Y Y Cache    
  tertiary_base_start_date BL3 Start The current start date of the activity in the tertiary baseline.  When earned value is using planned dates then the start will be set to the activity's planned start date.  When earned value is using current dates then the start will be set to the planned start date until the activity is started, then set to the actual start date. Date FT_START_DATE Y Y Cache    
  tmpl_guid Methodology Global Unique ID Methodology Global Unique ID String <GUID>   Y Db    
  total_cost At Completion Total Cost The total cost at completion for the activity, including labor resources, nonlabor resources, material resources, and project expenses. At Completion Total Cost =  At Completion Labor Cost + At Completion Nonlabor Cost + At Completion Material Cost + At Completion Expense Cost. Double FT_MONEY Y Y Calc    
  total_drtn_hr_cnt At Completion Duration The duration at completion is the total working time from the activity's current start date to the current finish date. The current start date is the planned start date until the activity is started, then it is the actual start date. The current finish date is the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed. The total working time is computed using the activity's calendar. Double FT_DURATION   Y Calc    
  total_equip_cost At Completion Nonlabor Cost The nonlabor cost at completion is the sum of the actual plus remaining cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost. Same as the planned nonlabor cost if the activity is not started and the actual nonlabor cost once the activity is completed. Double FT_MONEY   Y Calc    
  total_equip_qty At Completion Nonlabor Units The nonlabor units at completion is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Units + Remaining Nonlabor Units. Same as the planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed. Double FT_QTY   Y Cache    
  total_expense_cost At Completion Expense Cost The expense cost at completion is the sum of the actual plus remaining cost for all expenses associated with the activity. Computed as Actual Expense Cost + Remaining Expense Cost. Double FT_MONEY Y Y Calc    
  total_float_hr_cnt Total Float The amount of time the activity can be delayed before delaying the project finish date. Total float can be computed as Late Start - Early Start or as Late Finish - Early Finish; this option can be set when running the project scheduler. Double FT_DURATION Y Y Db    
  total_mat_cost At Completion Material Cost The material cost at completion is the sum of the actual plus remaining cost for all material resources assigned to the activity. Computed as Actual Material Cost + Remaining Material Cost. Same as the planned material cost if the activity is not started and the actual material cost once the activity is completed. Double FT_MONEY   Y Calc    
  total_work_cost At Completion Labor Cost The labor cost at completion is the sum of the actual plus remaining cost for all labor resources assigned to the activity. Computed as Actual Labor Cost + Remaining Labor Cost. Same as the planned labor cost if the activity is not started and the actual labor cost once the activity is completed. Double FT_MONEY   Y Calc    
  total_work_qty At Completion Labor Units The labor units at completion is the sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as Actual Labor Units + Remaining Labor Units. Same as the planned labor units if the activity is not started and the actual labor units once the activity is completed. Double FT_QTY   Y Cache    
  update_date Last Modified Date The date this activity was last modified. Date FT_START_DATE Y Y Db    
  update_user Last Modified By The user who last modified this activity. String FT_TEXT Y Y Db    
  user_end_date1 user_end_date1 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date2 user_end_date2 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date3 user_end_date3 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date4 user_end_date4 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date5 user_end_date5 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date6 user_end_date6 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date7 user_end_date7 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date8 user_end_date8 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_integer1 user_integer1 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer2 user_integer2 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer3 user_integer3 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer4 user_integer4 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer5 user_integer5 User defined integer field 5. Integer FT_INT   Y Calc    
  user_integer6 user_integer6 User defined integer field 6. Integer FT_INT   Y Calc    
  user_integer7 user_integer7 User defined integer field 7. Integer FT_INT   Y Calc    
  user_integer8 user_integer8 User defined integer field 8. Integer FT_INT   Y Calc    
  user_number1 user_number1 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number2 user_number2 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number3 user_number3 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number4 user_number4 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number5 user_number5 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number6 user_number6 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number7 user_number7 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number8 user_number8 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_start_date1 user_start_date1 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date2 user_start_date2 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date3 user_start_date3 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date4 user_start_date4 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date5 user_start_date5 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date6 user_start_date6 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date7 user_start_date7 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date8 user_start_date8 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_text1 user_text1 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text2 user_text2 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text3 user_text3 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text4 user_text4 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text5 user_text5 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text6 user_text6 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text7 user_text7 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text8 user_text8 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  vac_work Variance At Completion - Labor Units Variance At Completion Labor Units is the Baseline Planned Total Labor Units minus Estimate at Completion Labor Units. Double FT_QTY Y Y Calc    
  var_cost Variance - BL Total Cost Variance Total Cost is calculated as BL Total Cost - At Completion Total Cost. Double FT_MONEY   Y Calc    
  var_drtn_hr_cnt Variance - BL Duration Variance Duration is the duration between the activity's BL Duration and the At Completion Duration. Computed as BL Duration - At Completion Duration. Double FT_DURATION Y Y Calc    
  var_end_date_drtn_hr_cnt Variance - BL Finish Date Variance Finish Date is the duration between the BL Finish date and the Finish Date in the current project.  Calculated as BL Finish - Finish Date. Double FT_DURATION Y Y Calc    
  var_equip_cost Variance - BL Nonlabor Cost Variance Nonlabor Cost is calculated as BL Nonlabor Cost - At Completion Nonlabor Cost. Double FT_MONEY   Y Calc    
  var_equip_qty Variance - BL Nonlabor Units Variance Nonlabor Units is calculated as BL Nonlabor Units - At Completion Nonlabor Units. Double FT_QTY   Y Calc    
  var_expense_cost Variance - BL Expense Cost Variance Expense Cost is calculated as BL Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost). Double FT_MONEY   Y Calc    
  var_mat_cost Variance - BL Material Cost Variance Material Cost is calculated as BL Material Cost - At Completion Material Cost. Double FT_MONEY   Y Calc    
  var_primary_cost Variance - BL1 Total Cost   Double FT_MONEY   Y Calc    
  var_primary_drtn_hr_cnt Variance - BL1 Duration   Double FT_DURATION Y Y Calc    
  var_primary_end_date_drtn_hr_cnt Variance - BL1 Finish Date   Double FT_DURATION Y Y Calc    
  var_primary_equip_cost Variance - BL1 Nonlabor Cost   Double FT_MONEY   Y Calc    
  var_primary_equip_qty Variance - BL1 Nonlabor Units   Double FT_QTY   Y Calc    
  var_primary_expense_cost Variance - BL1 Expense Cost   Double FT_MONEY   Y Calc    
  var_primary_mat_cost Variance - BL1 Material Cost   Double FT_MONEY   Y Calc    
  var_primary_start_date_drtn_hr_cnt Variance - BL1 Start Date   Double FT_DURATION Y Y Calc    
  var_primary_work_cost Variance - BL1 Labor Cost   Double FT_MONEY   Y Calc    
  var_primary_work_qty Variance - BL1 Labor Units   Double FT_QTY   Y Calc    
  var_start_date_drtn_hr_cnt Variance - BL Start Date Variance Start Date is the duration between the BL Start date and the Start Date in the current project.  Calculated as  BL Start - Start Date. Double FT_DURATION Y Y Calc    
  var_work_cost Variance - BL Labor Cost Variance Labor Cost is calculated as BL Labor Cost - At Completion Labor Cost. Double FT_MONEY   Y Calc    
  var_work_qty Variance - BL Labor Units Variance Labor Units is calculated as BL Labor Units - At Completion Labor Units. Double FT_QTY   Y Calc    
  wbs_id WBS WBS Integer <FK>   Db    
  wbs_name WBS Name The name of the WBS element. String FT_TEXT Y Y Calc    
  wbs_path WBS Path The WBS Path is the same as the WBS Code without the project level displayed. String FT_TEXT Y Y Calc    
  work_complete_pct Labor Units % Complete The percent complete of units for all labor resources for the activity. Computed as Actual Labor Units / At Completion Labor Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  work_cost_complete_pct Labor Cost % Complete The percent complete of cost for all labor resources assigned to the activity. Computed as Actual Labor Cost / At Completion Labor Cost * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
                 
TASKACTV            
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  actv_code_id Activity Code Value The value of the Activity Code. Integer <FK>   Db    
  actv_code_type_id Activity Code The Activity Code. Integer <PK_FK> Y   Db    
  proj_id Project The project which owns the activity. Integer <FK> Y   Db    
  row_count Activity Code Assignment Count Activity Code Assignment Count Integer FT_INT Y Y Calc    
  task_id Activity Unique ID generated by the system. Integer <PK_FK> Y   Db    
                 
TASKDOC                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  doc_id Document Identifies the document. Integer <FK>   Db    
  proj_id Project The project which owns the activity. Integer <FK> Y Y Db    
  row_count Document Assignment Count Document Assignment Count Integer FT_INT Y Y Calc    
  task_id Activity The activity to which the document is assigned. Integer <FK>   Y Db    
  taskdoc_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  wbs_id WBS The WBS for the activity to which the document is assigned.  A document can also be assigned directly to the WBS and then later to an activity, for top-down planning. Integer <FK>   Db    
  wp_flag Work Product Indicates whether the document is a work product for the activity. Work products are produced or output by an activity. String FT_YESNO   Y Db    
             
TASKFIN                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  act_equip_cost Actual Nonlabor Cost Displays the Actual Nonlabor Cost that is stored in the user-defined financial period. Double FT_MONEY   Y Db    
  act_equip_qty Actual Nonlabor Units Displays the Actual Nonlabor Units that are stored in the user-defined financial period. Double FT_QTY   Y Db    
  act_expense_cost Actual Expense Cost Displays the Actual Expense Cost that is stored in the user-defined financial period. Double FT_MONEY   Y Db    
  act_mat_cost Actual Material Cost Displays the Actual Material Cost that is stored in the user-defined financial period. Double FT_MONEY   Y Db    
  act_work_cost Actual Labor Cost Displays the Actual Labor Cost that is stored in the user-defined financial period. Double FT_MONEY   Y Db    
  act_work_qty Actual Labor Units Displays the Actual Labor Units that are stored in the user-defined financial period. Double FT_QTY   Y Db    
  bcwp Earned Value Cost Displays the Actual Earned Value Cost that is stored in the user-defined financial period. Calculated as Earned Value Cost – total earned value cost stored for all financial periods. Double FT_MONEY   Y Db    
  bcws Planned Value Cost Displays the Planned Value Cost that is stored in the user-defined financial period. Double FT_MONEY   Y Db    
  fin_dates_id Financial Period   Integer <PK_FK> Y   Db    
  perfm_work_qty Earned Value Labor Units Displays the Actual Earned Value Labor Units that are stored in the user-defined financial period. Calculated as Earned Value Labor Units – total earned value labor units stored for all financial periods. Double FT_QTY   Y Db    
  proj_id Project   Integer <FK> Y   Db    
  row_count Activity Past Period Actuals Count Number of past period actuals. Integer FT_INT Y Y Calc    
  sched_work_qty Planned Value Labor Units Displays the Planned Value Labor Units that is stored in the user-defined financial period. Double FT_QTY   Y Db    
  task_id Activity Name   Integer <PK_FK> Y   Db    
             
TASKMEMO                
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  memo_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  memo_type_id Notebook Topic The activity specification topic. Integer <FK>   Db    
  proj_id Project The project which owns the activity. Integer <FK> Y   Db    
  row_count Activity Notebook Count Notebook Item Count Integer FT_INT Y Y Calc    
  task_id Activity The ID of the task to which the Notebook Item is assigned. Integer <FK>   Db    
  task_memo Notebook Description The information that is associated to the Notebook topic. Memo <HTML>   Y Db(delayed    
                 
TASKPRED              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  aref Adjusted Relationship Early Finish   Date FIELD_TYPE_19 Y Y Calc    
  arls Adjusted Relationship Late Start   Date FIELD_TYPE_19 Y Y Calc    
  critical_flag Critical Indicates whether the relationship is critical. The relationship is critical when both the predecessor and successor activities are critical. Activities are critical because their Total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project. String FT_YESNO Y Y Cache    
  driving_flag Driving Indicates whether the Free Float for this relationship is zero or less. Any delay in the predecessor activity will delay the successor activity. String FT_YESNO Y Y Cache    
  free_float Free Float The amount of time the predecessor activity can be delayed before delaying the successor activity. Double FT_FLOAT   Y Calc    
  lag_hr_cnt Lag The time lag of the relationship.  This is the time lag between the predecessor activity's start or finish date and the successor activity's start or finish date, depending on the relationship type. The time lag is based on the successor activity's calendar. This value is specified by the project manager and is used by the project scheduler when scheduling activities. Double FT_DURATION   Y Db    
  pred_proj_id Predecessor Project The project which owns the successor activity. Integer <FK> Y   Db    
  pred_task_id Predecessor The predecessor activity. Integer <FK>   Y Db    
  pred_type Relationship Type The type of relationship, either FS (finish-to-start), FF (finish-to-finish), SS (start-to-start), or SF (start-to-finish). Most relationships are finish-to-start. String FT_STATICTYPE   Db    
  proj_id Successor Project The project which owns the predecessor activity. Integer <FK> Y   Db    
  ref Relationship Early Finish The first workperiod (using the relationship calendar) after the relationship early start plus any relationship lag. Early Start assumes the relationship type is finish to start or finish to finish. This field is computed by the project scheduler when using the multiple float path method. Date FIELD_TYPE_19 Y Y Calc    
  res Relationship Early Start The first workperiod (using the relationship calendar) after the predecessor's early finish date, assuming that the relationship type is a finish to start or finish to finish. This field is computed by the project scheduler when using the multiple float path method. Date FIELD_TYPE_19 Y Y Calc    
  rff Relationship Free Float The Free Float on the relationship. Calculated as Successor Early Start (assuming a Finish to Start relationship) - Relationship Early Finish on the predecessors calendar. This field is computed by the project scheduler when using the multiple float path method. Double FT_DURATION Y Y Calc    
  rlf Relationship Late Finish The first workperiod (using the relationship calendar) before the successors late start date. This field is computed by the project scheduler when using the multiple float path method. Date FIELD_TYPE_19 Y Y Calc    
  rls Relationship Late Start The first workperiod (using the relationship calendar) after the predecessor’s late finish. This field is computed by the project scheduler when using the multiple float path method. Date FIELD_TYPE_19 Y Y Calc    
  row_count Activity Relationship Count Activity Relationship Count Integer FT_INT Y Y Calc    
  rsff Relationship Successor Free Float Calculated as Successor Early Start - Relationship Early Finish on the Successors Calendar.This field is computed by the project scheduler when using the multiple float path method. Double FT_DURATION Y Y Calc    
  rstf Relationship Successor Total Float The relationship successor Total Float is the total float of the potential successor activity if that specific relationship was the driving relationship, using the successor’s calendar. This field is computed by the project scheduler when using the multiple float path method. Double FT_DURATION Y Y Calc    
  rtf Relationship Total Float The Total Float on the relationship.  Calculated as Relationship Late Start – Relationship Early Start on the predecessor’s calendar. This field is computed by the project scheduler when using the multiple float path method. Double FT_DURATION Y Y Calc    
  task_id Successor The successor activity. Integer <FK>   Y Db    
  task_pred_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
                 
TASKPROC              
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  complete_flag Completed Indicates whether the step has been completed. String FT_YESNO   Db    
  complete_pct Step % Complete Percent complete for the step, entered by the user. Must be between 0 and 100. Double FT_PERCENT   Db    
  proc_descr Step Description The description of the step. Memo <HTML>   Y Db(delayed    
  proc_id Unique ID The current late start date of the successor activity. Integer <PK> Y   Db    
  proc_name Step Name The activity step.  Activities are divided into sequential steps to divide the work into manageable units. String FT_TEXT   Db    
  proc_pct Step Weight Percent A noneditable field that displays the percentage amount that corresponds to the step.  It is calculated by taking the weight of the step and dividing it by the total of all weights for the activity. Double FT_FLOAT   Calc    
  proc_wt Step Weight The weight that is assigned to the step.  This is a user defined field that is used to calculate the physical percent complete when the project option is set. Double FT_FLOAT   Db    
  proj_id Project The project which owns the activity. Integer <FK> Y   Db    
  row_count Activity Step Count Activity Step Count Integer FT_INT Y Y Calc    
  seq_num Sort Order The sequence number of the step. Integer <SEQ>   Db    
  task_id Activity The ID of the Task which the steps are assigned. Integer <FK>   Db    
  user_cost1 user_cost1 A user-defined field for storing currency. Double FT_MONEY   Y Calc    
  user_end_date1 user_end_date1 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_number1 user_number1 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_start_date1 user_start_date1 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_text1 user_text1 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
         
TASKRSRC        
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  acct_id Cost Account The cost account for work performed by the resource on this activity. Integer <FK>   Y Db    
  act_cost Actual Cost The actual nonovertime plus overtime cost for the resource assignment on the activity. Computed as Actual Cost = Actual Regular Cost + Actual Overtime Cost. Double FT_MONEY   Y Cache    
  act_drtn_hr_cnt Actual Duration Actual duration is the total working time from the activity actual start date to the actual finish date (for completed activities), or to the current data date (for in-progress activities). The actual working time is computed using the activity's calendar. Double FT_DURATION Y Y Calc    
  act_end_date Actual Finish The date the resource actually finished working on the activity. Date FT_END_DATE   Y Db    
  act_ot_cost Actual Overtime Cost The actual overtime cost for the resource assignment on the activity. Computed as Actual Overtime Cost = Actual Overtime Units * Cost per Time * Overtime Factor. Double FT_MONEY   Y Db    
  act_ot_qty Actual Overtime Units The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. Double FT_QTY   Db    
  act_qty Actual Units The actual nonovertime plus overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. Computed as Actual Units = Actual Regular Units + Actual Overtime Units. Double FT_QTY   Cache    
  act_reg_cost Actual Regular Cost The actual nonovertime cost for the resource assignment on the activity. Computed as Actual Regular Cost = Actual Regular Units * Cost per Time. Double FT_MONEY   Y Db    
  act_reg_qty Actual Regular Units The actual nonovertime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. Double FT_QTY   Db    
  act_start_date Actual Start The date the resource actually started working on the activity. Date FT_START_DATE   Y Db    
  act_this_per_cost Actual This Period Cost The actual cost of the resource assignment for the current period. Double FT_MONEY   Y Db    
  act_this_per_qty Actual This Period Units The actual units the resource has worked in the current period. Double FT_QTY   Db    
  cost_per_qty Price / Unit The price per time for the assignment on this activity.  This price is used to compute the assignment’s cost for the activity.  When a resource is assigned to the activity, the resource's price is copied to the assignment based on the effective date of the price and the activity start date.  The assignment price is refreshed whenever prices are synchronized for the project. Double FT_RSRC_COST_QTY   Y Db    
  cost_per_qty_source_type Rate Source The rate source determines which price/unit will be used to calculate costs for the assignment when both a resource and role are assigned.  To use a different price/unit then the one assigned to the resource or role, choose the Custom option. String FT_STATICTYPE   Db    
  cost_qty_link_flag Cost Units Linked Identifies whether cost should be calculated based from units or not.  If this field is not checked then cost will be user entered and not calculated from units. String FT_YESNO   Y Db    
  curv_id Curve The name of the resource curve that determines how resources and cost are distributed over time for this activity. Integer <FK>   Y Db    
  effort_complete_pct Units % Complete The percent complete of units for the resource assignment on the activity. Computed as Actual Units / At Completion Units * 100.  Always in the range 0 to 100. Double FT_PERCENT   Y Calc    
  end_date Finish The current finish date of the resource assignment on the activity.  Set to the planned finish date until the activity is completed, then set to the actual finish date. Date FT_END_DATE   Cache    
  guid Global Unique ID Global Unique ID generated by the system. String <GUID>   Y Db    
  ot_factor Overtime Factor The overtime factor used to compute the overtime price for the resource assignment on this activity. Overtime price = standard price * overtime factor. When the resource is assigned to the activity, the resource's overtime factor is copied to the assignment. The assignment overtime factor is refreshed from the resource value when resource prices are synchronized for the project. Double FT_FLOAT   Y Db    
  pend_complete_pct Pend % Complete An estimate of the percentage of the resource's units of work completed on this activity. The pending percent complete is entered by each resource using Timesheets. This value is used to compute the resource's remaining units for the activity when project actuals are applied.  The project manager specifies whether resources update their Percent Complete or Remaining Units for each project. Double FT_PERCENT   Y Db    
  pend_remain_qty Pend Remaining Units An estimate of the resource's remaining units on this activity. The pending remaining units is entered by each resource using Timesheets. This value is copied to the resource's remaining units for the activity when project actuals are applied.  The project manager specifies whether resources update their Percent Complete or Remaining Units for each project. Double FT_QTY   Y Db    
  primary_flag Primary Resource Indicates whether this resource is the activity's primary resource. The primary resource is responsible for the overall work on the activity and for updating the activity status. String FT_YESNO   Y Calc    
  proj_id Project Project Integer <FK> Y   Db    
  rate_type Rate Type The rate type determines which of the 5 prices specified for the resource or role will be used to calculate the cost for the assignment. String FT_STATICTYPE   Y Db    
  reend_date Remaining Early Finish The date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date. Date FT_END_DATE   Y Db    
  rem_late_end_date Remaining Late Finish Remaining late finish date is calculated by the scheduler. Date FT_END_DATE Y Y Db    
  rem_late_start_date Remaining Late Start Remaining late start date is calculated by the scheduler. Date FT_START_DATE Y Y Db    
  remain_cost Remaining Early Cost The remaining cost for the resource assignment on the activity. Computed as Remaining Cost = Remaining Units * Cost per Time. Double FT_MONEY   Y Db    
  remain_drtn_hr_cnt Remaining Duration Remaining duration is the remaining working time for the resource assignment on the activity, from the resource's remaining start date to the remaining finish date. The remaining working time is computed using the calendar determined by the Activity Type. Resource Dependent activities use the resource's calendar; other activity types use the activity's calendar. Before the activity is started, the remaining duration is the same as the Original Duration. After the activity is completed the remaining duration is zero. Double FT_DURATION   Y Calc    
  remain_lag_drtn_hr_cnt Remaining Lag The time lag between the activity's remaining start date and the resource's remaining start date on the activity. If the resource's remaining work starts on the activity's remaining start date, the lag is zero. Before the activity is started, the remaining lag is the same as the planned lag. Double FT_DURATION   Calc    
  remain_qty Remaining Early Units The remaining units of work to be performed by this resource on this activity.  Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero. Double FT_QTY   Db    
  remain_qty_per_hr Remaining Units / Time 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. Double FT_QTY_RATE   Db    
  restart_date Remaining Early Start The date the resource is scheduled to begin the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager.  Before the activity is started, the remaining start date is the same as the planned start date. Date FT_START_DATE   Y Db    
  role_id Role Role Integer <FK>   Y Db    
  rollup_dates_flag Drive Activity Dates Indicates whether the resource assignment dates should drive the activity dates when the resource assignment dates change. String FT_YESNO   Y Db    
  rsrc_catg_classification_id Classification   Integer <FK> Y Y Calc    
  rsrc_catg_employee_class_id Employee Class   Integer <FK> Y Y Calc    
  rsrc_catg_office_id Office   Integer <FK> Y Y Calc    
  rsrc_id Resource ID Name Resource ID Name Integer <FK>   Y Db    
  rsrc_type Resource Type Indicates whether the resource is labor, nonlabor or material. String FT_STATICTYPE   Db    
  skill_level Proficiency The skill level that is associated with the role.  The values are Master, Expert, Skilled, Proficient, and Inexperienced. Integer FT_STATICTYPE   Y Db    
  staffed_remain_cost Staffed Remaining Cost Time distribution of the resource's remaining cost for resource assignments that have filled a role. Double FT_MONEY Y Y Calc    
  staffed_remain_qty Staffed Remaining Units Time distribution of the resource's remaining units for resource assignments that have filled a role. Double FT_QTY Y Y Calc    
  start_date Start The current start date of the resource assignment on the activity.  Set to the planned start date until the activity is started, then set to the actual start date. Date FT_START_DATE   Cache    
  target_cost Planned Cost The planned cost for the resource assignment on the activity. Computed as Planned Cost = Planned Units * Price per Time. Double FT_MONEY   Y Db    
  target_drtn_hr_cnt Planned Duration Original Duration is the planned working time for the resource assignment on the activity, from the resource's planned start date to the planned finish date. The planned working time is computed using the calendar determined by the Activity Type. Resource Dependent activities use the resource's calendar; other activity types use the activity's calendar. This is the duration that Timesheets users follow and the schedule variance is measured against. Double FT_DURATION   Calc    
  target_end_date Planned Finish The date the resource is scheduled to finish working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. This is the finish date that Timesheets users follow and schedule variance is measured against. Date FT_END_DATE   Db    
  target_lag_drtn_hr_cnt Planned Lag The planned time lag between the activity's planned start date and the resource's planned start date on the activity. If the resource is planned to start work when the activity is planned to start, the planned lag is zero. Double FT_DURATION   Db    
  target_qty Planned Units The planned units of work for the resource assignment on the activity. Double FT_QTY   Db    
  target_qty_per_hr Planned Units / Time 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. Double FT_QTY_RATE   Db    
  target_start_date Planned Start The date the resource is scheduled to begin working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. This is the start date that Timesheets users follow and schedule variance is measured against. Date FT_START_DATE   Db    
  task_id Activity Name Activity Integer <FK> Y   Db    
  taskrsrc_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  taskrsrc_sum_id Activity Resource Summary Unique ID generated by the system. Integer <FK>   Y Mem    
  total_cost At Completion Cost The cost at completion is the sum of the actual plus remaining cost for the resource assignment on the activity. Computed as Actual Cost + Remaining Cost. Double FT_MONEY   Y Cache    
  total_drtn_hr_cnt At Completion Duration The duration at completion is the total working time from the activity's current start date to the current finish date. The current start date is the planned start date until the activity is started, then it is the actual start date. The current finish date is the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed. The total working time is computed using the activity's calendar. Double FT_DURATION Y Y Calc    
  total_qty At Completion Units The units at completion is the sum of the actual plus remaining units for the resource assignment on the activity. Computed as Actual Units + Remaining Units. Same as the planned units if the activity is not started and the actual units once the activity is completed. Double FT_QTY   Cache    
  unit_of_measure Unit of Measure The unit of measure for a material resources. String FT_TEXT Y Y Calc    
  unstaffed_remain_cost Unstaffed Remaining Cost Time distribution of the resource's remaining cost for resource assignments that have not filled a role. Double FT_MONEY Y Y Calc    
  unstaffed_remain_qty Unstaffed Remaining Units Time distribution of the resource's remaining units for resource assignments that have not filled a role. Double FT_QTY Y Y Calc    
  user_end_date1 user_end_date1 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date2 user_end_date2 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date3 user_end_date3 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date4 user_end_date4 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date5 user_end_date5 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date6 user_end_date6 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date7 user_end_date7 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_end_date8 user_end_date8 A user-defined field for storing finish dates. Date FT_END_DATE   Y Calc    
  user_integer1 user_integer1 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer2 user_integer2 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer3 user_integer3 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer4 user_integer4 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer5 user_integer5 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer6 user_integer6 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer7 user_integer7 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_integer8 user_integer8 A user-defined field for storing integers. Integer FT_INT   Y Calc    
  user_number1 user_number1 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number2 user_number2 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number3 user_number3 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number4 user_number4 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number5 user_number5 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number6 user_number6 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number7 user_number7 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_number8 user_number8 A user-defined field for storing numbers with 2 decimal digits precision. Double FT_FLOAT_2_DECIMALS   Y Calc    
  user_start_date1 user_start_date1 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date2 user_start_date2 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date3 user_start_date3 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date4 user_start_date4 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date5 user_start_date5 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date6 user_start_date6 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date7 user_start_date7 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_start_date8 user_start_date8 A user-defined field for storing start dates. Date FT_START_DATE   Y Calc    
  user_text1 user_text1 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text2 user_text2 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text3 user_text3 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text4 user_text4 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text5 user_text5 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text6 user_text6 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text7 user_text7 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
  user_text8 user_text8 A user-defined field for storing text strings. String FT_TEXT   Y Calc    
         
TASKSUM        
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  act_drtn_hr_cnt act_drtn_hr_cnt The actual duration. Double FT_TEXT Y Y Db    
  act_end_date act_end_date The latest actual finish date of all activities in the wbs. Date FT_TEXT Y Y Db    
  act_equip_cost act_equip_cost The actual cost for all nonlabor resources assigned to the activity. Double FT_MONEY Y Y Db    
  act_equip_qty act_equip_qty The actual nonlabor units. Double FT_TEXT Y Y Db    
  act_expense_cost act_expense_cost The actual cost for all project expenses associated with the wbs. Double FT_MONEY Y Y Db    
  act_mat_cost act_mat_cost The actual material cost. Double FT_MONEY Y Y Db    
  act_start_date act_start_date The earliest actual start date of all activities in the wbs. Date FT_TEXT Y Y Db    
  act_this_per_equip_cost act_this_per_equip_cost The actual this period cost for all nonlabor resources assigned to the activities. Double FT_MONEY Y Y Db    
  act_this_per_equip_qty act_this_per_equip_qty The actual this period units for all nonlabor resources assigned to the activities. Double FT_TEXT Y Y Db    
  act_this_per_mat_cost act_this_per_mat_cost The actual this period material cost. Double FT_MONEY Y Y Db    
  act_this_per_work_cost act_this_per_work_cost The actual this period cost for all labor resources assigned to the activities. Double FT_MONEY Y Y Db    
  act_this_per_work_qty act_this_per_work_qty The actual this period units for all labor resources assigned to the activities. Double FT_TEXT Y Y Db    
  act_work_cost act_work_cost The actual cost for all labor resources assigned to the activity. Double FT_MONEY Y Y Db    
  act_work_qty act_work_qty The actual labor units. Double FT_TEXT Y Y Db    
  active_cnt active_cnt The number of actual in-progress activities. Integer FT_TEXT Y Y Db    
  base_active_cnt base_active_cnt The number of activities that should be currently in progress, according to the baseline. Integer FT_TEXT Y Y Db    
  base_complete_cnt base_complete_cnt The number of activities that should be currently completed, according to the baseline. Integer FT_TEXT Y Y Db    
  base_drtn_hr_cnt base_drtn_hr_cnt The duration for the activity in the baseline. Double FT_TEXT Y Y Db    
  base_end_date base_end_date The current latest finish date of all  activities in the wbs for the primary baseline. Date FT_TEXT Y Y Db    
  base_equip_cost base_equip_cost The planned cost for all nonlabor resources assigned to the wbs in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned, computed as the activity BL Planned Nonlabor Units * Project Default Price / Time. Double FT_MONEY Y Y Db    
  base_equip_qty base_equip_qty The sum of the Planned (or At Completion) Units for all nonlabor resources assigned to the activity in the project baseline. Double FT_TEXT Y Y Db    
  base_expense_cost base_expense_cost The planned cost for all project expenses associated with the wbs in the primary baseline. Computed as the baseline actual expense cost plus the baseline remaining expense cost. Double FT_MONEY Y Y Db    
  base_mat_cost base_mat_cost   Double FT_MONEY Y Y Db    
  base_notstarted_cnt base_notstarted_cnt The number of activities that should be currently not started, according to the baseline. Integer FT_TEXT Y Y Db    
  base_start_date base_start_date The current earliest start date of all  activities in the wbs for the primary baseline. Date FT_TEXT Y Y Db    
  base_work_cost base_work_cost The planned cost for all labor resources assigned to the wbs in the primary baseline. Computed from the baseline At Completion labor units. If no resources are assigned, computed as the activity BL Planned Nonlabor Units * Project Default Price / Time. Double FT_MONEY Y Y Db    
  base_work_qty base_work_qty The sum of the Planned (or At Completion) Units for all labor resources assigned to the activity in the project baseline. Double FT_TEXT Y Y Db    
  bcwp bcwp Earned Value is the Budget at Completion * Performance % Complete.  The method for computing the performance percent complete depends on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the primary baseline. Double FT_MONEY Y Y Db    
  bcws bcws Planned Value Cost is the Budget at Completion * Schedule % Complete.  The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far.  Budget at Completion is computed from the baseline. Double FT_MONEY Y Y Db    
  complete_cnt complete_cnt The number of actual completed activities. Integer FT_TEXT Y Y Db    
  etc etc Estimate to Complete is calculated as either the Remaining Total Cost for the activity or as PF * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the primary baseline. Double FT_MONEY Y Y Db    
  etc_work_qty etc_work_qty The estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (BL Planned Labor Units - Planned Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS. Double FT_TEXT Y Y Db    
  notstarted_cnt notstarted_cnt The number of not started activities. Integer FT_TEXT Y Y Db    
  perfm_work_qty perfm_work_qty Planned Labor Units Performed is the portion of the baseline labor units that is actually completed as of the project data date. Computed as BL Planned Labor Units * Performance % Complete. The planned labor units performed is essentially the labor units earned value for the activity. The method for computing the Performance % Complete depends on the earned-value technique selected for the activity's WBS.  The BL Planned Labor Units is taken from the primary baseline. Double FT_TEXT Y Y Db    
  proj_id Project The project ID of where the WBS lives. Integer <FK> Y   Db    
  reend_date reend_date reend_date Date FT_TEXT Y Y Db    
  remain_drtn_hr_cnt remain_drtn_hr_cnt Remaining duration is the total working time from the wbs remaining start date to the remaining finish date. Double FT_TEXT Y Y Db    
  remain_equip_cost remain_equip_cost The remaining nonlabor cost for all project expenses associated with the activities in the wbs. Double FT_MONEY Y Y Db    
  remain_equip_qty remain_equip_qty The remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the WBS. Double FT_TEXT Y Y Db    
  remain_expense_cost remain_expense_cost The remaining cost for all project expenses associated with the activities in the wbs. Double FT_MONEY Y Y Db    
  remain_mat_cost remain_mat_cost The remaining material cost in the wbs. Double FT_MONEY Y Y Db    
  remain_work_cost remain_work_cost The remaining labor cost for all project expenses associated with the activities in the wbs. Double FT_MONEY Y Y Db    
  remain_work_qty remain_work_qty The remaining units for all labor resources assigned to the activities. The remaining units reflects the work remaining to be done for the WBS. Double FT_TEXT Y Y Db    
  restart_date restart_date restart_date Date FT_TEXT Y Y Db    
  row_count Activity Summary Count Activity Summary Count Integer FT_INT Y Y Calc    
  sched_work_qty sched_work_qty Planned Labor Units Scheduled is the portion of the baseline labor units that is scheduled to be completed as of the project data date. Computed as BL Planned Labor Units * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The BL Planned Labor Units is taken from the primary baseline. Double FT_TEXT Y Y Db    
  spread_data spread_data Contains all spread data rolled up to the WBS that was specified. Memo FT_TEXT Y Y Db(delayed    
  task_sum_id Unique ID Unique ID generated by the system. Integer <PK> Y   Db    
  total_drtn_hr_cnt total_drtn_hr_cnt The duration at completion. Double FT_TEXT Y Y Db    
  total_float_hr_cnt total_float_hr_cnt The amount of time the wbs can be delayed before delaying the project finish date. Total float can be computed as Late Start - Early Start or as Late Finish - Early Finish; this option can be set when running the project scheduler. Double FT_TEXT Y Y Db    
  wbs_id WBS The WBS ID for the information that is summarized. Integer <FK> Y   Db    
         
THRSPARM        
(home) Field Name Column Name Description Data Type Field Type Read-Only Nullable Stored    
  row_count Threshold Parameter Count Threshold P