Tables and Fields Exported to XER when Exporting Resources
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
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
group_digit_cnt Currency Group Digit Count
neg_curr_fmt_type Negative Currency Format
pos_curr_fmt_type Positive Currency Format
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
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 Enterprise/Organization
role_descr Responsibilities
role_id Unique ID
role_name Role Name
role_short_name Role ID
seq_num Sort Order
RSRC - (Resources)
flag
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
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 Enterprise/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
RSRC - (Resources continued)
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
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
_ g_ yp _ 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
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
UMEASURE - (Units of Measure)
seq_num Sort Order
unit_abbrev Unit Abbreviation
unit_id Unique ID
unit_name Unit Name
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 - (WBSRSRC QTY)
fin_dates_id1 fin_dates_id1
fin_dates_id2 fin_dates_id2
fin_qty1 fin_qty1
fin_qty2 fin_qty2
month_start Unique ID
qty qty
wbsrsrc_id High Level Planning Assignment
week_start Unique ID
