Tables and fields exported to XER when exporting Projects

ACCOUNT - (Cost Accounts)

acct_descr Cost Account Description
acct_id Unique ID
acct_name Cost Account Name
acct_seq_num Sort Order
acct_short_name Cost Account ID
parent_acct_id Parent Cost Account

ACTVCODE - (Activity Code Values)

actv_code_id Unique ID
actv_code_name Description
actv_code_type_id Activity Code
parent_actv_code_id Parent Activity Code Value
seq_num Sort Order
short_name Activity Code Value

ACTVTYPE - (Activity Codes)

actv_code_type Activity Code
actv_code_type_id Unique ID
actv_code_type_scope Activity Code Type Scope
actv_short_len Max Code Length
proj_id EPS/Project
seq_num Sort Order
wbs_id EPS ID

APPLYACTOPTIONS - (Apply Actuals Options)

proj_id Project
respect_duration_type respect_duration_type

BUDGCHNG - (Budget Changes)

budg_chng_id Unique ID
chng_by_name Responsible
chng_cost Amount
chng_date Date
chng_descr Reason
chng_short_name Change Number
proj_id Project
status_code Status
wbs_id WBS
CALENDAR - (Calendars)
base_clndr_id Parent Calendar
clndr_data Data
clndr_id Unique ID
clndr_name Calendar Name
clndr_type Calendar Type
default_flag Default
last_chng_date Date Last Changed
proj_id Project

COSTTYPE - (Expense Categories)

cost_type Expense Category
cost_type_id Unique ID
seq_num Sort Order

CURRTYPE - (Currency Types)

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

DOCCATG - (Document Categories)

doc_catg_id Unique ID
doc_catg_name Category
seq_num Sort Order

DOCSTAT - (Document Statuses)

doc_status_code Status Code
doc_status_id Unique ID
seq_num Sort Order
DOCUMENT - (Work Products and Documents)
author_name Author
deliv_flag Deliverable
doc_catg_id Document Category
doc_content Description
doc_date Revision Date
doc_id Unique ID
doc_mgmt_type Document Management Type
doc_name Title
doc_seq_num Sort Order
doc_short_name Reference No.
doc_status_id Status
external_doc_key External Document Key
guid Global Unique ID
parent_doc_id Parent Document
private_loc Private Location
proj_id Project
public_loc Public Location
tmpl_guid Methodology Global Unique ID
version_name Version

EXPPROJ - (Contract Manager Projects)

exp_group Database Group
exp_passwd Password
exp_proj_name Project Name
exp_user_name Username
login_supplied_flag Prompt for Username and Password
proj_id Project

FINDATES - (Financial Periods)

end_date End Date
fin_dates_id Unique ID
fin_dates_name Period Name
start_date Start Date

FUNDSRC - (Funding Sources)

fund_descr Description
fund_id Unique ID
fund_name Funding Source
parent_fund_id Parent Funding Source
seq_num Sort Order

ISSUHIST - (Notification History)

issue_history Notification History
issue_id Issue
proj_id Project
MEMOTYPE - (Notebook Topics)
eps_flag Available for EPS
memo_type Notebook Topic
memo_type_id Unique ID
proj_flag Available for Projects
seq_num Sort Order
task_flag Available for Activity
wbs_flag Available for WBS

NAVIVIEW - (Navigation Views)

default_flag Default
navi_view_id Unique ID
navi_view_name Navigation View Name

OBS - (OBS)
guid Global Unique ID
obs_descr OBS Description
obs_id Unique ID
obs_name OBS Name
parent_obs_id Parent OBS
seq_num Sort Order

PCATTYPE - (Project Codes)

max_proj_catg_wt Max Code Value Weight
proj_catg_short_len Max Code Length
proj_catg_type Project Code
proj_catg_type_id Unique ID
proj_catg_type_wt Weight
seq_num Sort Order

PCATVAL - (Project Code Values)

parent_proj_catg_id Parent Code
proj_catg_id Unique ID
proj_catg_name Code Description
proj_catg_short_name Project Code
proj_catg_type_id Project Code
proj_catg_wt Weight
seq_num Sort Order

PHASE - (Project Phase List)

phase_id Unique ID
phase_name Category Value
seq_num Sort Order
PROCGROUP - (Activity Step Templates)
proc_group_id Unique ID
proc_group_name Step Template Name
seq_num Sort Order

PROCITEM - (Activity Step Items)

proc_descr Step Description
proc_group_id Activity Step Template
proc_item_id Unique ID
proc_name Step Name
proc_wt Step Weight
seq_num Sort Order

PROJCOST - (Project Expenses)

acct_id Cost Account
act_cost Actual Cost
auto_compute_act_flag Auto Compute Actuals
cost_descr Expense Description
cost_item_id Unique ID
cost_load_type Accrual Type
cost_name Expense Item
cost_per_qty Price / Unit
cost_type_id Expense Category
po_number Document Number
pobs_id pobs_name
proj_id Project
qty_name Unit of Measure
remain_cost Remaining Cost
target_cost Budgeted/Planned Cost
target_qty Budgeted/Planned Units
task_id Activity Name
vendor_name Vendor
PROJECT - (Projects)
acct_id Default Cost Account
act_pct_link_flag Link Percent Complete With Actual
act_this_per_link_flag Link Actual and Actual This Period Units and Costs
add_act_remain_flag Add Actual To Remain
add_by_name Added By
add_date Date Added
allow_complete_flag Can resources mark activities completed
allow_neg_act_flag Allow Negative Actual Units
base_type_id Baseline Type
batch_sum_flag Enable Summarization
checkout_flag Project Check-out Status
chng_eff_cmp_pct_flag Resources Edit Percent Complete
clndr_id Default Calendar
close_period_flag Flag to Store Period Performance
cost_qty_recalc_flag Cost Qty Recalc Flag
critical_drtn_hr_cnt Critical activities have float less than or equal to
critical_path_type critical_path_type
def_complete_pct_type Default Percent Complete Type
def_cost_per_qty Default Price / Unit
def_duration_type Default Duration Type
def_qty_type Default Price Time Units
def_rate_type Rate Type
def_rollup_dates_flag Drive Activity Dates Default
def_task_type Default Activity Type
export_flag Export Flag
fcst_start_date Project Forecast Start
fy_start_month_num Fiscal Year Begins
guid Global Unique ID
last_baseline_update_date Last Update Date
last_checksum Last Checksum
last_fin_dates_id Financial Period
last_recalc_date Last Recalc Date
last_tasksum_date Last Summarized Date
loaded_scope_level Project Scope Level
name_sep_char Code Separator
new_fin_dates_id Financial Period
next_data_date Next Data Date
orig_proj_id Original Project
plan_end_date Must Finish By
plan_start_date Planned Start
priority_num Project Leveling Priority
proj_id Unique ID
proj_short_name Project ID
proj_url Project Web Site URL
project_flag Project Flag
rem_target_link_flag Link Budget/Planned and At Completion
reset_planned_flag Reset Original/Planned to Remaining
risk_level Risk Level
rsrc_multi_assign_flag Can assign resource multiple times to activity
rsrc_self_add_flag Can resources assign selves to activities
scd_end_date Schedule Finish
source_proj_id Source Project
step_complete_flag Physical Percent Complete uses Steps Completed
strgy_priority_num Strategic Priority
sum_assign_level sum_assign_level
sum_base_proj_id Project Baseline
sum_data_date Summarized Data Date
sum_only_flag Contains Summarized Data Only
task_code_base Activity ID Suffix
task_code_prefix Activity ID Prefix
task_code_prefix_flag Activity ID based on selected activity
task_code_step Activity ID Increment
trsrcsum_loaded Summary data loaded
ts_rsrc_mark_act_finish_flag Resources can mark assignments as completed
ts_rsrc_vw_inact_actv_flag Resources can view Inactive Project Activities
use_project_baseline_flag use_project_baseline_flag
wbs_max_sum_level WBS Max Summarization Level
web_local_root_path Web Site Root Directory

PROJEST - (Estimate History)

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

PROJFUND - (Project Funding Assignments)

fund_cost Amount
fund_id Funding Source
fund_wt Fund Share
proj_fund_id Unique ID
proj_id Project

PROJISSU - (Issues)
add_by_name Identified By
add_date Date Identified
base_proj_id Base Project
hi_parm_value Upper Threshold
issue_id Unique ID
issue_name Issue
issue_notes Issue Notes
issue_value Actual Value
lo_parm_value Lower Threshold
obs_id Responsible Manager
priority_type Priority
proj_id Project
resolv_date Resolution Date
rsrc_id Resource
status_code Status
task_id Activity
thresh_id Threshold
thresh_parm_id Threshold Parameter
track_view_id Tracking Layout
wbs_id WBS
PROJPCAT - (Project Code Assignments)
proj_catg_id Code Value
proj_catg_type_id Project Code
proj_id Project

PROJRISK - (Risks)
add_date Date Identified
impact_date Impact Date
impact_equip_qty Impact Nonlabor Units
impact_expense_cost Impact Expense Cost
impact_mat_qty Impact Material Units
impact_work_qty Impact Labor Units
obs_id Responsible Manager
prbly_pct Probability
priority_type Priority
proj_id Project
risk_descr Risk Description
risk_id Unique ID
risk_name Risk
risk_type_id Risk Type
rsrc_id Resource
status_code Status
wbs_id WBS

PROJTHRS - (Thresholds)
hi_parm_value Upper Threshold
issue_cnt Total Issues
lo_parm_value Lower Threshold
obs_id Responsible Manager
priority_type Priority
proj_id Project
status_code Status
thresh_id Unique ID
thresh_parm_id Threshold Parameter
thresh_type Detail To Monitor
track_view_id Tracking Layout
wbs_id WBS
window_end To Date
window_start From Date
PROJWBS - (WBS)
ann_dscnt_rate_pct
anticip_end_date Anticipated Finish
anticip_start_date Anticipated Start
dscnt_period_type
est_wt Est Weight
ev_compute_type E.V. Percent Complete Technique
ev_etc_compute_type E.V. Estimate-to-Complete Technique
ev_etc_user_value E.V. Performance Factor
ev_user_pct E.V. Percent Complete
guid Global Unique ID
indep_remain_total_cost Independent ETC Total Cost
indep_remain_work_qty Independent ETC Labor Units
obs_id Responsible Manager
orig_cost Original Budget
parent_wbs_id Parent WBS
phase_id Project Phase
plan_open_state
proj_id Project
proj_node_flag Project Node
seq_num Sort Order
status_code Project Status
sum_data_flag Contains Summary Data
tmpl_guid Methodology Global Unique ID
wbs_id Unique ID
wbs_name WBS Name
wbs_short_name WBS Code

RCATTYPE - (Resource Codes)

rsrc_catg_short_len Max Code Length
rsrc_catg_type Resource Code
rsrc_catg_type_id Unique ID
seq_num Sort Order

RCATVAL - (Resource Code Values)

parent_rsrc_catg_id Parent Code
rsrc_catg_id Unique ID
rsrc_catg_name Code Description
rsrc_catg_short_name Resource Code
rsrc_catg_type_id Resource Code
seq_num Sort Order

RISKCTRL - (Risk Control Plans)

proj_id Project
risk_control Risk Control Plan
risk_id Risk

RISKTYPE - (Risk Types)

risk_type Risk Type
risk_type_id Unique ID
seq_num Sort Order
ROLELIMIT - (Role Limits)
max_qty_per_hr Max Units / Time
role_id Role ID
rolelimit_id Unique ID
start_date Effective Date

ROLERATE - (Role Prices)

cost_per_qty Price / Unit
cost_per_qty2 Price / Unit2
cost_per_qty3 Price / Unit3
cost_per_qty4 Price / Unit4
cost_per_qty5 Price / Unit5
role_id Role ID
role_rate_id Unique ID

ROLES - (Roles)
cost_qty_type Price Time Units
def_cost_qty_link_flag Calculate costs from units
parent_role_id Parent Role
pobs_id Default Performing Organization
role_descr Responsibilities
role_id Unique ID
role_name Role Name
role_short_name Role ID
seq_num Sort Order

RSRC - (Resources)
active_flag Active
auto_compute_act_flag Auto Compute Actuals
clndr_id Calendar
cost_qty_type Price Time Units
curr_id Currency Name
def_cost_qty_link_flag Calculate costs from units
def_qty_per_hr Default Units / Time
email_addr E-Mail Address
employee_code Employee ID
guid Global Unique ID
last_checksum Last Checksum
level_flag Level Flag
load_tasks_flag Load Tasks Flag
office_phone Office Phone
ot_factor Overtime Factor
ot_flag Overtime Allowed
other_phone Other Phone
parent_rsrc_id Parent Resource
pobs_id Default Performing Organization
role_id Primary Role
rsrc_id Unique ID
rsrc_name Resource Name
rsrc_notes Resource Notes
rsrc_seq_num Sort Order
rsrc_short_name Resource ID
rsrc_title_name Title
rsrc_type Resource Type
shift_id Shift
timesheet_flag Uses Timesheets
ts_approve_user_id Timesheet Approval Manager
unit_id Unit of Measure
user_id User Login Name
xfer_complete_day_cnt Not-Started Activities View Window
xfer_notstart_day_cnt Completed Activities View Window
RSRCCURVDATA - (Resource Curve Data)
curv_id Unique ID
curv_name Curve Name
default_flag default_flag
pct_usage_0 pct_usage_0
pct_usage_1 pct_usage_1
pct_usage_10 pct_usage_10
pct_usage_11 pct_usage_11
pct_usage_12 pct_usage_12
pct_usage_13 pct_usage_13
pct_usage_14 pct_usage_14
pct_usage_16 pct_usage_16
pct_usage_17 pct_usage_17
pct_usage_18 pct_usage_18
pct_usage_19 pct_usage_19
pct_usage_2 pct_usage_2
pct_usage_20 pct_usage_20
pct_usage_3 pct_usage_3
pct_usage_4 pct_usage_4
pct_usage_5 pct_usage_5
pct_usage_6 pct_usage_6
pct_usage_8 pct_usage_8
pct_usage_9 pct_usage_9

RSRCLEVELLIST - (RSRCLEVELLISTS)
rsrc_id Resource
rsrc_level_list_id Unique ID
schedoptions_id SCHEDOPTIONS

RSRCRATE - (Resource Prices)

cost_per_qty Price / Unit
cost_per_qty2 Price / Unit2
cost_per_qty3 Price / Unit3
cost_per_qty4 Price / Unit4
cost_per_qty5 Price / Unit5
max_qty_per_hr Max Units / Time
rsrc_id Resource
rsrc_rate_id Unique ID
shift_period_id Shift
start_date Effective Date
RSRCRCAT - (Resource Code Assignments)
rsrc_catg_id Code Value
rsrc_catg_type_id Resource Code
rsrc_id Resource

RSRCROLE - (Resource Role Assignments)

role_id Role
role_name Role Name
role_short_name Role ID
rsrc_id Resource
rsrc_name Resource Name
rsrc_role_id Role
rsrc_short_name Resource ID
rsrc_type Resource Type
skill_level Proficiency

SCHEDOPTIONS - (Schedule Options)

level_all_rsrc_flag level_all_rsrc_flag
level_float_thrs_cnt level_float_thrs_cnt
level_keep_sched_date_flag level_keep_sched_date_flag
level_outer_assign_flag level_outer_assign_flag
level_outer_assign_priority level_outer_assign_priority
level_over_alloc_pct level_over_alloc_pct
level_within_float_flag level_within_float_flag
LevelPriorityList LevelPriorityList
proj_id Project
sched_calendar_on_relationship_lag sched_calendar_on_relationship_lag
sched_float_type sched_float_type
sched_lag_early_start_flag sched_lag_early_start_flag
sched_open_critical_flag sched_open_critical_flag
sched_outer_depend_type sched_outer_depend_type
sched_progress_override sched_progress_override
sched_retained_logic sched_retained_logic
sched_setplantoforecast sched_setplantoforecast
sched_use_expect_end_flag sched_use_expect_end_flag
schedoptions_id Unique ID

SHIFT - (Shift Names)

shift_id Unique ID
shift_name Shift Name

SHIFTPER - (Shifts)
shift_id Shift Name
shift_period_id Unique ID
shift_start_hr_num Shift start hour number
TASK - (Activities)
act_end_date Actual Finish
act_equip_qty Actual Nonlabor Units
act_start_date Actual Start
act_this_per_equip_qty Actual This Period Nonlabor Units
act_this_per_work_qty Actual This Period Labor Units
act_work_qty Actual Labor Units
auto_compute_act_flag Auto Compute Actuals
clndr_id Calendar
complete_pct_type Percent Complete Type
create_date Added Date
create_user Added By
cstr_date Primary Constraint Date
cstr_date2 Secondary Constraint Date
cstr_type Primary Constraint
cstr_type2 Secondary Constraint
driving_path_flag Longest Path
duration_type Duration Type
early_end_date Early Finish
early_start_date Early Start
est_wt Est Weight
expect_end_date Expected Finish
external_early_start_date External Early Start
external_late_end_date External Late Finish
float_path Float Path
float_path_order Float Path Order
free_float_hr_cnt Free Float
guid Global Unique ID
late_end_date Late Finish
late_start_date Late Start
lock_plan_flag Lock Remaining
old_reend_date NEED TITLE
old_remain_drtn_hr_cnt NEED TITLE
old_restart_date NEED TITLE
phys_complete_pct NEED TITLE
priority_type Activity Leveling Priority
proj_id Project
reend_date Remaining Early Finish
rem_late_end_date Remaining Late Finish
rem_late_start_date Remaining Late Start
remain_drtn_hr_cnt Remaining Duration
remain_equip_qty Remaining Nonlabor Units
remain_work_qty Remaining Labor Units
restart_date Remaining Early Start
resume_date Resume Date
rev_fdbk_flag New Feedback
review_end_date Review Finish
review_type Review Status
rsrc_id Primary Resource
status_code Activity Status
suspend_date Suspend Date
target_drtn_hr_cnt Original/Planned Duration
target_end_date Planned Finish
target_equip_qty Budgeted/Planned Nonlabor Units
target_start_date Planned Start
target_work_qty Budgeted/Planned Labor Units
task_code Activity ID
task_id Unique ID
task_name Activity Name
task_type Activity Type
tmpl_guid Methodology Global Unique ID
total_float_hr_cnt Total Float
update_date Last Modified Date
update_user Last Modified By
wbs_id WBS

TASKACTV - (Activity Code Assignments)

actv_code_id Activity Code Value
actv_code_type_id Activity Code
proj_id Project
task_id Activity

TASKDOC - (Document Assignments)

doc_id Document
proj_id Project
task_id Activity
taskdoc_id Unique ID
wbs_id WBS
wp_flag Work Product

TASKFDBK - (Activity Feedback)

proj_id Project
task_fdbk Feedback from Primary Resource
task_id Activity
TASKFIN - (Activity Past Period Actuals)
act_equip_cost Actual Nonlabor Cost
act_equip_qty Actual Nonlabor Units
act_expense_cost Actual Expense Cost
act_mat_cost Actual Material Cost
act_work_cost Actual Labor Cost
act_work_qty Actual Labor Units
bcwp Earned Value Cost
bcws Planned Value Cost
fin_dates_id Financial Period
perfm_work_qty Earned Value Labor Units
proj_id Project
sched_work_qty Planned Value Labor Units
task_id Activity Name

TASKMEMO - (Activity Notebook)

memo_id Unique ID
memo_type_id Notebook Topic
proj_id Project
task_id Activity
task_memo Notebook Description

TASKNOTE - (Activity Notes to Resources)

proj_id Project
task_id Activity
task_notes Notes to Resources

TASKPRED - (Activity Relationships)

aref Adjusted Relationship Early Finish
arls Adjusted Relationship Late Start
float_path Float Path
lag_hr_cnt Lag
pred_proj_id Predecessor Project
pred_task_id Predecessor
pred_type Relationship Type
proj_id Successor Project
task_id Successor
task_pred_id Unique ID

TASKPROC - (Activity Steps)

complete_flag Completed
complete_pct Step % Complete
proc_descr Step Description
proc_id Unique ID
proc_name Step Name
proc_wt Step Weight
proj_id Project
seq_num Sort Order
task_id Activity
TASKRSRC - (Activity Resource Assignments)
acct_id Cost Account
act_end_date Actual Finish
act_ot_cost Actual Overtime Cost
act_ot_qty Actual Overtime Units
act_reg_cost Actual Regular Cost
act_reg_qty Actual Regular Units
act_start_date Actual Start
act_this_per_cost Actual This Period Cost
act_this_per_qty Actual This Period Units
actual_crv Actual Units Profile
cost_per_qty Price / Unit
cost_per_qty_source_type Rate Source
cost_qty_link_flag Cost Units Linked
create_date Assigned Date
create_user Assigned by
curv_id Curve
guid Global Unique ID
has_rsrchours Assignment Has Timesheet data
old_reend_date Old Remaining End Date
old_remain_drtn_hr_cnt Old Remaining Duration
old_restart_date Old Remaining Start Date
ot_factor Overtime Factor
pend_act_ot_qty Pend Actual Overtime Units
pend_act_reg_qty Pend Actual Regular Units
pend_complete_pct Pend % Complete
pend_remain_qty Pend Remaining Units
pobs_id pobs_name
proj_id Project
rate_type Rate Type
reend_date Remaining Early Finish
relag_drtn_hr_cnt Remaining Lag
rem_late_end_date Remaining Late Finish
rem_late_start_date Remaining Late Start
remain_cost Remaining Cost
remain_crv Remaining Units Profile
remain_qty Remaining Units
remain_qty_per_hr Remaining Units / Time
restart_date Remaining Early Start
role_id Role
rollup_dates_flag Drive Activity Dates
rsrc_id Resource ID Name
rsrc_type Resource Type
skill_level Proficiency
target_cost Budgeted/Planned Cost
target_crv Planned Units Profile
target_end_date Planned Finish
target_lag_drtn_hr_cnt Original/Planned Lag
target_qty Budgeted/Planned Units
target_qty_per_hr Budgeted/Planned Units / Time
target_start_date Planned Start
task_id Activity Name
[Link]|wbs_id EPS/WBS
taskrsrc_sum_id Activity Resource Summary
taskrsrc_id Unique ID
ts_pend_act_end_flag Pending Actual End Date Flag
THRSPARM - (Threshold Parameters)
rsrc_flag Applies to Resources
seq_num Sort Order
task_flag Applies to Activities
thresh_field_name Threshold Field Name
thresh_parm_id Unique ID
thresh_parm_name Threshold Parameter
thresh_parm_type Threshold Parameter Type
thresh_short_name Threshold Name
wbs_flag Applies to WBS

TRSRCFIN - (Activity Resource Assignment Past Period Actuals)

act_cost Actual Cost
act_qty Actual Units
fin_dates_id Financial Period
proj_id Project
task_id Activity Name
taskrsrc_id Assignment ID

UDFCODE - (User Defined Codes)

short_name Code
udf_code_id Unique ID
udf_code_name Code Name
udf_type_id User Defined Field

UDFTYPE - (User Defined Fields)

indicator_expression indicator_expression
logical_data_type Data Type
summary_indicator_expression summary_indicator_expression
super_flag Secure Code
table_name Table
udf_type_id Unique ID
udf_type_label Title
udf_type_name User Defined Field

UDFVALUE - (User Defined Field Values)

fk_id Activity Step Item
proj_id Project
udf_code_id udf_code_id
udf_date udf_date
udf_number udf_number
udf_text udf_text
udf_type_id User Defined Field

UMEASURE - (Units of Measure)

seq_num Sort Order
unit_abbrev Unit Abbreviation
unit_id Unique ID
unit_name Unit Name
USERS - (Users)
actual_name Personal Name
all_rsrc_access_flag All Resource Access
curr_id Global Profile
email_addr User EMail Address
email_send_server Outgoing Mail Server
email_srv_passwd Mail Login Password
email_srv_user_name Mail Login Name / Profile
email_type EMail Protocol
global_flag Global
guid Global Unique ID
navi_view_id Navigation View Name
office_phone Office Phone
override_naviview_flag Allow Users to override options in views
passwd Password
prof_id Global Profile
user_id Unique ID
user_name Login Name

WBSBUDG - (Spending and Benefit Plans)

benefit_cost Benefit Plan
proj_id Project
spend_cost Spending Plan
start_date Date
wbs_budg_id Unique ID
wbs_id WBS

WBSMEMO - (EPS, Project and WBS Notebook)

memo_type_id Notebook Topic
proj_id Project
wbs_id WBS
wbs_memo Notebook Description
wbs_memo_id Unique ID

WBSRSRC - (High Level Planning Assignments)

auto_compute_dates_flag Life of Project
committed_flag Committed
end_date Finish
proj_id Project
role_id Role
rsrc_id Resource
rsrc_request_data Search Criteria
start_date Start
wbrs_cat_id Status Code
wbs_id WBS
wbsrsrc_id Unique ID

WBSRSRC_QTY - (High Level Planning Assignment Quantities)

month_start Unique ID
qty qty
wbsrsrc_id High Level Planning Assignment
week_start Unique ID

WBSSTEP - (WBS Milestones)

complete_flag Completed
proj_id Project ID
seq_num Sort Order
step_name WBS Milestone
step_wt Weight
wbs_id WBS
wbs_step_id Unique ID