Primavera Software Development Kit Static Fields Definitions

 
Static Value Display Value

CURRTYPE - (Currency Types)

 

decimal_digit_cnt - (Number of Digits after Decimal)

 

0

0

1

1

2

2

decimal_symbol - (Decimal Symbol)

 

.

.

,

,

digit_group_symbol - (Digit Grouping Symbol)

 

,

,

.

.

pos_curr_fmt_type - (Positive Currency Format)

 

#1.1

1.1

1.1#

1.1

# 1.1

1.1

1.1 #

1.1

neg_curr_fmt_type - (Negative Currency Format)

 

(#1.1)

(1.1)

-#1.1

-1.1

#-1.1

-1.1

#1.1-

1.1-

(1.1#)

(1.1)

-1.1#

-1.1

1.1-#

1.1-

1.1#-

1.1-

-1.1 #

-1.1

-# 1.1

- 1.1

1.1 #-

1.1 -

# 1.1-

1.1-

# -1.1

-1.1

1.1- #

1.1-

(# 1.1)

( 1.1)

(1.1 #)

(1.1 )

group_digit_cnt - (Currency Group Digit Count)

 

0

0

1

1

2

2

3

3

4

4

5

5

6

6

 

FACTOR - (Estimation Factors)

 

fact_type - (Factor Type)

 

FA_FP

Function Point Complexity Factors

FA_Complex

Bottom-up Complexity Factors

 

PRIVILEG - (Security Privileges)

 

scope_type - (Privilege Scope)

 

ST_Global

Global

ST_Project

Project

 

PROFILE - (Security Profiles)

 

scope_type - (Profile Scope)

 

ST_Global

Global

ST_Project

Project

 

ROLES - (Roles)

 

cost_qty_type - (Price Time Units)

 

QT_Hour

Hour

QT_Day

Day

QT_Week

Week

QT_Month

Month

QT_Year

Year

 

THRSPARM - (Threshold Parameters)

 

thresh_parm_type - (Threshold Parameter Type)

 

TH_Drtn

Duration

TH_Money

Money

TH_Percent

Percent

TH_Ratio

Ratio

TH_Plus

Plus

TH_Minus

Minus

TH_AbsPlus

Absolute, Plus

 

UDFTYPE - (User Defined Fields)

 

table_name - (Table)

 

TASKPROC

Activity Steps

PROJECT

Projects

RSRC

Resources

PROJWBS

WBS

TASK

Activities

TASKRSRC

Activity Resource Assignments

DOCUMENT

Work Products and Documents

PROJCOST

Project Expenses

PROJISSU

Issues

PROJRISK

Risks

PROCITEM

Activity Step Items

logical_data_type - (Data Type)

 

FT_TEXT

Text

FT_START_DATE

Start Date

FT_END_DATE

Finish Date

FT_MONEY

Cost

FT_STATICTYPE

Indicator

FT_INT

Integer

FT_FLOAT_2_DECIMALS

Number

FT_CODE

PickList

 

USERCOL - (User-defined Columns)

 

table_name - (Table)

 

project

Project

rsrc

Resource

projwbs

WBS

task

Activities

taskrsrc

Activity Resource Assignments

rsrcrate

Resource Prices

taskproc

Activity Steps

logical_data_type - (Data Type)

 

FT_TEXT

Text

FT_QTY

Quantity

FT_RSRC_COST_QTY

Rsrc Cost/Qty

FT_QTY_RATE

Price/Qty

FT_DURATION

Duration

FT_START_DATE

Start Date

FT_END_DATE

Finish Date

FT_MONEY

Cost

FT_DATERANGE

Date Range

FT_STATICTYPE

Static

FT_PERCENT

Percent

FT_FLOAT

Number

FT_YESNO

Yes/No

FT_INT

Integer

FT_RSRC_QTY

Rsrc Qty

FT_VARIANT

Variant

FT_FLOAT_2_DECIMALS

2 Decimals

FT_FLOAT_3_DECIMALS

3 Decimals

FT_FLOAT_6_DECIMALS

6 Decimals

FT_QTY_SLASH_QTY

Qty/Qty

FT_QTY_MATERIAL

Material Qty

FT_QTY_LIMIT

Quantity

FT_CODE

PickList

 

SHIFTPER - (Shifts)

 

formatted_start_hour - (Start Hour)

 

0

00:00

1

01:00

2

02:00

3

03:00

4

04:00

5

05:00

6

06:00

7

07:00

8

08:00

9

09:00

10

10:00

11

11:00

12

12:00

13

13:00

14

14:00

15

15:00

16

16:00

17

17:00

18

18:00

19

19:00

20

20:00

21

21:00

22

22:00

23

23:00

formatted_duration - (Duration (Hrs))

 

-24

-24

-23

-23

-22

-22

-21

-21

-20

-20

-19

-19

-18

-18

-17

-17

-16

-16

-15

-15

-14

-14

-13

-13

-12

-12

-11

-11

-10

-10

-9

-9

-8

-8

-7

-7

-6

-6

-5

-5

-4

-4

-3

-3

-2

-2

-1

-1

0

0

1

1

2

2

3

3

4

4

5

5

6

6

7

7

8

8

9

9

10

10

11

11

12

12

13

13

14

14

15

15

16

16

17

17

18

18

19

19

20

20

21

21

22

22

23

23

24

24

 

USERS - (Users)

 

email_type - (EMail Protocol)

 

ET_Internet

Internet

ET_MAPI

MAPI

 

GCHANGE - (Global Changes)

 

user_category - (Available To)

 

G

All Users

U

Current User

T

Another User

 

JOBSVC - (Job Services)

 

job_type - (Service Type)

 

JT_ApplyActuals

Apply Actuals

JT_XERExport

Export

JT_Sched

Schedule

JT_Sum

Summarize

JT_Batch

Batch Reports

status_code - (status_code)

 

JS_Pending

Pending

JS_Running

Running

JS_Complete

Complete

JS_Failed

Failed

JS_Cancelled

Cancelled

recur_type - (Status)

 

RT_RecurEnabled

Enabled

RT_RecurDisabled

Disabled

 

PFOLIO - (Portfolios)

 

pfolio_type - (Portfolio Type)

 

PT_MAN

Manual

PT_AUTO

Auto-Maintained

PT_EPS

EPS

PT_PROJ_CODE

Project Code

scope_level - (Scope Level)

 

1

Summary Data

6

Live Data

user_category - (Available To)

 

G

All Users

U

Current User

T

Another User

pfolio_group - (Portfolio Group)

 

PG_EPS_PROJCODES

EPS

PG_USER

User Portfolios

PG_GLOBAL

Global Portfolios

 

PREFER - (Admin Preferences)

 

week_start_day_num - (Week Start Day)

 

1

Sunday

2

Monday

3

Tuesday

4

Wednesday

5

Thursday

6

Friday

7

Saturday

ts_approval_level - (Number of timesheet approval levels)

 

-1

-1 - No Submission Necessary

0

0 - No Approval Necessary

1

1 - Resource Manager Only

2

2 - PM and RM

ts_approval_type - (Level 2 Timesheet Approval Order)

 

AT_PM_RM

PM before RM

AT_Any

Any Order

tasksum_period_type - (Summarize WBS Interval)

 

SP_Month

Month

SP_Week

Week

trsrcsum_period_type - (Summarize Resource/Role Assignment Interval)

 

SP_Month

Month

SP_Week

Week

ev_compute_type - (E.V. Percent Complete Technique)

 

EC_Cmp_pct

Activity % Complete

EC_0_pct

0/100 % Complete

EC_50_pct

50/50 % Complete

EC_User_pct

Custom % Complete

EC_MS

Use WBS Milestones

EC_Curve

Resource Curves

ev_etc_compute_type - (E.V. Estimate-to-Complete Technique)

 

EE_Rem_hr

Remaining Total Cost

EE_PF_1

(BAC - BCWP)

EE_PF_user

(BAC - BCWP) * Custom

EE_PF_cpi

(BAC - BCWP) / CPI

EE_PF_cpi_spi

(BAC - BCWP) / (CPI * SPI)

ev_calc - (Earned Value Calculation Type)

 

EV_AtCompl

At Completion values with current dates

EV_Budg

Planned values with planned dates

EV_Budg_With_Start_Dates

Planned values with current dates

 

PROJECT - (Projects)

 

fy_start_month_num - (Fiscal Year Begins)

 

1

January

2

February

3

March

4

April

5

May

6

June

7

July

8

August

9

September

10

October

11

November

12

December

checkout_flag - (Project Check-out Status)

 

Y

Checked Out

N

Checked In

def_complete_pct_type - (Default Percent Complete Type)

 

CP_Phys

Physical

CP_Drtn

Duration

CP_Units

Units

risk_level - (Risk Level)

 

1

Very High

2

High

3

Medium

4

Low

5

Very Low

def_duration_type - (Default Duration Type)

 

DT_FixedQty

Fixed Units

DT_FixedDrtn

Fixed Duration and Units/Time

DT_FixedRate

Fixed Units/Time

DT_FixedDUR2

Fixed Duration & Units

def_qty_type - (Default Price Time Units)

 

QT_Hour

Hour

QT_Day

Day

QT_Week

Week

QT_Month

Month

QT_Year

Year

def_rate_type - (Rate Type)

 

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

def_task_type - (Default Activity Type)

 

TT_Task

Task Dependent

TT_Rsrc

Resource Dependent

TT_LOE

Level of Effort

TT_Mile

Start Milestone

TT_FinMile

Finish Milestone

TT_WBS

WBS Summary

loaded_scope_level - (Current Scope Level)

 

0

External Project

1

Project Summary

2

Max WBS Level Summary

3

Timesheet Activities

4

Resource Activities

5

Scheduling Data

6

Analysis Data

7

All Activity Detail

access_level - (Access Level)

 

0

Read Only

1

Shared

2

Exclusive

scope_level - (Scope Level)

 

0

External Project

1

Project Summary

2

Max WBS Level Summary

3

Timesheet Activities

4

Resource Activities

5

Scheduling Data

6

Analysis Data

7

All Activity Detail

open_state - (Open State)

 

CS_Checked

Open

On_Hold

On Hold

CS_Unchecked

Closed

 

RFOLIO - (RFOLIOS)

 

rfolio_type - (rfolio_type)

 

PT_MAN

Manual

PT_AUTO

Auto-Maintained

PT_RSRC

Resource Hierarchy

PT_RSRC_CODE

Resource Code

rfolio_group - (rfolio_group)

 

PG_EPS_PROJCODES

Resource Hierarchy and Resource Codes

PG_USER

User Portfolios

PG_GLOBAL

Global Portfolios

 

TRAKVIEW - (Tracking Layouts)

 

display_type - (Display Type)

 

TD_Acct_Grid

Cost Account Spreadsheet

TD_Acct_Time

Cost Account Profile

TD_Grid

Project Table

TD_Time

Project Gantt/Profile

TD_Bar

Project Bar Chart

TD_Gantt

Gantt Chart

TD_Rsrc

Resource Analysis

 

USERENG - (User Product Assignments)

 

db_engine_type - (Product Type)

 

GENERIC

Generic Engine

PM

Project Management

PA

Portfolio Analysis

TS

Team Member

WU

myPrimavera Portfolios

MM

Methodology Management

JOB

Job Service

WEB_PM

myPrimavera Projects

WEB_RM

myPrimavera Resources

INT_API

Integration API

 

USESSION - (User Sessions)

 

load_projects - (Load Projects)

 

all

All

current

Concurrent User

none

None

load_resource_users - (Load Resources & Users)

 

all

All

current

Concurrent User

open

For Open Projects

load_roles - (Load Roles)

 

all

All

open

For Open Projects

load_reports - (Load Reports)

 

none

None

open

For Open Projects

load_rsrchours - (Load Timesheet Data for Opened Projects)

 

none

None

open

For Open Projects

load_pfolios - (Load Portfolio Data)

 

current

Concurrent User

none

None

other_projects_mode - (Other Projects Mode)

 

OP_None

No other projects

OP_Priority

Closed Projects with Priority above Limit

OP_All

All Closed Projects

remain_qty_spreads_mode - (Remaining Units Spreads Mode)

 

SM_Normal

Use Normal Start/End Dates

SM_Forecast

Use Forecast Start/End Dates

 

VIEWPROP - (Activity Layouts)

 

view_type - (View Type)

 

VP_ACT

Activity Layout

VP_TRAK

Tracking Layout

VP_WEB

Web Site Layout

VP_IMP_OPT

Import Configuration

VP_MSP

MSP Import Template

 

CALENDAR - (Calendars)

 

clndr_type - (Calendar Type)

 

CA_Base

Global Calendar

CA_Rsrc

Resource Calendar

CA_Project

Project Calendar

 

PROJWBS - (WBS)

 

status_code - (Project Status)

 

WS_Planned

Planned

WS_Open

Active

WS_Closed

Inactive

WS_Whatif

What-if

ev_compute_type - (E.V. Percent Complete Technique)

 

EC_Cmp_pct

Activity % Complete

EC_0_pct

0/100 % Complete

EC_50_pct

50/50 % Complete

EC_User_pct

Custom % Complete

EC_MS

Use WBS Milestones

EC_Curve

Resource Curves

ev_etc_compute_type - (E.V. Estimate-to-Complete Technique)

 

EE_Rem_hr

Remaining Total Cost

EE_PF_1

(BAC - BCWP)

EE_PF_user

(BAC - BCWP) * Custom

EE_PF_cpi

(BAC - BCWP) / CPI

EE_PF_cpi_spi

(BAC - BCWP) / (CPI * SPI)

plan_open_state - (Include)

 

CS_Checked

CS_Checked

CS_Grey

CS_Unchecked

CS_Unchecked

CS_Grey

node_type - (Node Type)

 

WBS

WBS

PROJECT

Project

EPS

EPS

 

RPT - (Reports)

 

rpt_type - (Report Type)

 

RP_Web

Web

RP_U_PM_Only

PM Only

RP_U_Non_Dtl

Analyst Normal Mode Compatible

RP_User

Analyst Detail Mode Compatible

rpt_state - (Report State)

 

PS_Normal

Manual

PS_Wiz

Generated

PS_WizMod

Generated-Modified

rpt_scope - (Report Scope)

 

RS_Global

Global

RS_Project

Current Project

 

ACTVTYPE - (Activity Codes)

 

actv_code_type_scope - (Activity Code Type Scope)

 

AS_Global

Global

AS_EPS

EPS

AS_Project

Project

 

BUDGCHNG - (Budget Changes)

 

status_code - (Status)

 

BC_Pending

Pending

BC_Approved

Approved

BC_NotApproved

Not Approved

 

EXTAPP - (External Applications)

 

app_name - (Application Name)

 

Microsoft Project

Microsoft Project

External Application

External Application

 

PROJTHRS - (Thresholds)

 

status_code - (Status)

 

TS_Enable

Enabled

TS_Disable

Disabled

priority_type - (Priority)

 

PT_Top

1 - Top

PT_High

2 - High

PT_Normal

3 - Normal

PT_Low

4 - Low

PT_Lowest

5 - Lowest

thresh_type - (Detail To Monitor)

 

TM_WBS

WBS

TM_Task

Activity

 

RSRC - (Resources)

 

cost_qty_type - (Price Time Units)

 

QT_Hour

Hour

QT_Day

Day

QT_Week

Week

QT_Month

Month

QT_Year

Year

rsrc_type - (Resource Type)

 

RT_Labor

Labor

RT_Equip

Nonlabor

RT_Mat

Material

 

PROJEST - (Estimate History)

 

est_type - (Method)

 

PE_FP

Function Point

PE_UserDef

Top Down Estimate

PE_BottomUp

Bottom Up

rsrc_type - (Resource Type)

 

RT_Labor

Labor

RT_Equip

Nonlabor

RT_Mat

Material

 

PROJRISK - (Risks)

 

priority_type - (Priority)

 

PT_Top

1 - Top

PT_High

2 - High

PT_Normal

3 - Normal

PT_Low

4 - Low

PT_Lowest

5 - Lowest

status_code - (Status)

 

RS_Open

Open

RS_Closed

Closed

 

RSRCROLE - (Resource Role Assignments)

 

skill_level - (Proficiency)

 

1

1 - Master

2

2 - Expert

3

3 - Skilled

4

4 - Proficient

5

5 - Inexperienced

 

TASK - (Activities)

 

complete_pct_type - (Percent Complete Type)

 

CP_Phys

Physical

CP_Drtn

Duration

CP_Units

Units

task_type - (Activity Type)

 

TT_Task

Task Dependent

TT_Rsrc

Resource Dependent

TT_LOE

Level of Effort

TT_Mile

Start Milestone

TT_FinMile

Finish Milestone

TT_WBS

WBS Summary

duration_type - (Duration Type)

 

DT_FixedRate

Fixed Units/Time

DT_FixedDrtn

Fixed Duration and Units/Time

DT_FixedQty

Fixed Units

DT_FixedDUR2

Fixed Duration & Units

review_type - (Review Status)

 

RV_OK

OK

RV_Review

For Review

RV_Reject

Rejected

status_code - (Activity Status)

 

TK_NotStart

Not Started

TK_Active

In Progress

TK_Complete

Completed

cstr_type - (Primary Constraint)

 

< None >

< None >

CS_MSO

Start On

CS_MSOB

Start On or Before

CS_MSOA

Start On or After

CS_MEO

Finish On

CS_MEOB

Finish On or Before

CS_MEOA

Finish On or After

CS_ALAP

As Late As Possible

CS_MANDSTART

Mandatory Start

CS_MANDFIN

Mandatory Finish

priority_type - (Activity Leveling Priority)

 

PT_Top

1 - Top

PT_High

2 - High

PT_Normal

3 - Normal

PT_Low

4 - Low

PT_Lowest

5 - Lowest

cstr_type2 - (Secondary Constraint)

 

< None >

< None >

CS_MSO

Start On

CS_MSOB

Start On or Before

CS_MSOA

Start On or After

CS_MEO

Finish On

CS_MEOB

Finish On or Before

CS_MEOA

Finish On or After

CS_ALAP

As Late As Possible

CS_MANDSTART

Mandatory Start

CS_MANDFIN

Mandatory Finish

 

PROJCOST - (Project Expenses)

 

cost_load_type - (Accrual Type)

 

CL_Start

Start of Activity

CL_End

End of Activity

CL_Uniform

Uniform over Activity

 

PROJISSU - (Issues)

 

priority_type - (Priority)

 

PT_Top

1 - Top

PT_High

2 - High

PT_Normal

3 - Normal

PT_Low

4 - Low

PT_Lowest

5 - Lowest

status_code - (Status)

 

IS_Open

Open

IS_On_Hold

On Hold

IS_Closed

Closed

 

TASKPRED - (Activity Relationships)

 

pred_type - (Relationship Type)

 

PR_FS

FS

PR_FF

FF

PR_SS

SS

PR_SF

SF

 

TASKRSRC - (Activity Resource Assignments)

 

skill_level - (Proficiency)

 

1

1 - Master

2

2 - Expert

3

3 - Skilled

4

4 - Proficient

5

5 - Inexperienced

rate_type - (Rate Type)

 

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

rsrc_type - (Resource Type)

 

RT_Labor

Labor

RT_Equip

Nonlabor

RT_Mat

Material

cost_per_qty_source_type - (Rate Source)

 

ST_Custom

Override

ST_Rsrc

Resource

ST_Role

Role

 

RSRCHOUR - (Timesheet Hours)

 

status_code - (Status)

 

TS_NotStart

Not Started

TS_Active

Not Submitted

TS_Review

Submitted

TS_PMApprov

PM Approved

TS_RMApprov

RM Approved

TS_Approv

Approved

TS_Reject

Rejected