Primavera Software Development Kit SYSTABLES (meta table)

Note: Tables and fields in red are not fully tested and so are not supported in this release. Using unsupported fields may result in inconsistent behavior or data loss.

table_id

seq_num

api_table_name

table_title

table_title_many

guid_flag

guid_action

unref_guid_action

constraints_flag

clobber_action

unref_clobber_action

last_assigned_key

30

1

ACCOUNT

Cost Account

Cost Accounts

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

84

5

ACTVCODE

Activity Code Value

Activity Code Values

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

68

4

ACTVTYPE

Activity Code

Activity Codes

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

2

0

BASETYPE

Baseline Type

Baseline Types

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

70

4

BUDGCHNG

Budget Change

Budget Changes

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

55

3

CALENDAR

Calendar

Calendars

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

3

0

COSTTYPE

Expense Category

Expense Categories

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

4

0

CURRTYPE

Currency Type

Currency Types

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

6

0

DOCCATG

Document Category

Document Categories

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

7

0

DOCSTAT

Document Status

Document Statuses

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

56

3

DOCUMENT

Document

Work Products and Documents

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Keep

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

71

4

EXPPROJ

Contract Management Project

Contract Management Projects

 

 

 

 

 

 

-1

72

4

EXTAPP

External Application

External Applications

 

 

 

 

 

 

-1

9

0

FINDATES

Financial Period

Financial Periods

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

10

0

FUNDSRC

Funding Source

Funding Sources

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

110

7

ISSUHIST

Notification History

Notification History

 

 

 

 

 

 

-1

11

0

MEMOTYPE

Notebook Topic

Notebook Topics

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

12

0

NONWORK

Overhead Code

Overhead Codes

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

13

0

OBS

OBS

OBS

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Keep

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

14

0

PCATTYPE

Project Code

Project Codes

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

32

1

PCATVAL

Project Code Value

Project Code Values

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

44

2

PFOLIO

Portfolio

Portfolios

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

15

0

PHASE

Project Phase

Project Phase List

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

45

2

PREFER

Admin Preferences

Admin Preferences

 

 

 

 

 

 

-1

16

0

PRIVILEG

Security Privilege

Security Privileges

 

 

 

 

 

 

-1

17

0

PROCGROUP

Activity Step Template

Activity Step Templates

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

33

1

PROCITEM

Activity Step Item

Activity Step Items

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

18

0

PROFILE

Security Profile

Security Profiles

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

34

1

PROFPRIV

Profile Privilege

Profile Privileges

 

 

 

 

 

 

-1

59

3

PROJBASE

Project Baseline

Project Baselines

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

96

6

PROJCOST

Project Expense

Project Expenses

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

46

2

PROJECT

Project

Projects

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

85

5

PROJEST

Estimate History

Estimate History

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

60

3

PROJFUND

Project Funding Assignment

Project Funding Assignments

 

 

 

 

 

 

-1

97

6

PROJISSU

Issue

Issues

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

61

3

PROJPCAT

Project Code Assignment

Project Code Assignments

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

86

5

PROJRISK

Risk

Risks

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Keep

-1

75

4

PROJTHRS

Threshold

Thresholds

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Keep

-1

62

3

PROJWBS

WBS

WBS

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Keep

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

76

4

PRPFOLIO

Portfolio WBS Relationship

Portfolio WBS Relationships

 

 

 

 

 

 

-1

19

0

RCATTYPE

Resource Code

Resource Codes

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

35

1

RCATVAL

Resource Code Value

Resource Code Values

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

98

6

RISKCTRL

Risk Control Plan

Risk Control Plans

 

 

 

 

 

 

-1

20

0

RISKTYPE

Risk Type

Risk Types

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

36

1

ROLERATE

Role Price

Role Prices

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

21

0

ROLES

Role

Roles

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

63

3

RPT

Report

Reports

 

 

 

 

 

 

-1

64

3

RPTBATCH

Batch Report

Batch Reports

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

22

0

RPTGROUP

Report Group

Report Groups

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

77

4

RPTLIST

Report Batch Assignment

Report Batch Assignments

 

 

 

 

 

 

-1

78

4

RSRC

Resource

Resources

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

23

0

RSRCCURV

Resource Curve

Resource Curves

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

87

5

RSRCRATE

Resource Price

Resource Prices

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

88

5

RSRCRCAT

Resource Code Assignment

Resource Code Assignments

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

89

5

RSRCROLE

Resource Role Assignment

Resource Role Assignments

 

 

 

 

 

 

-1

48

2

RSRCSEC

Resource Security

Resource Securities

 

 

 

 

 

 

-1

24

0

SHIFT

Shift Name

Shift Names

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

37

1

SHIFTPER

Shift

Shifts

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

91

5

TASK

Activity

Activities

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Prompt

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_Keep

-1

100

6

TASKACTV

Activity Code Assignment

Activity Code Assignments

 

 

 

 

 

 

-1

101

6

TASKDOC

Document Assignment

Document Assignments

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

103

6

TASKFIN

Activity Past Period Actuals

Activity Past Period Actuals

 

 

 

 

 

 

-1

104

6

TASKMEMO

Activity Notebook

Activity Notebook

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

106

6

TASKPRED

Activity Relationship

Activity Relationships

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_Keep

-1

107

6

TASKPROC

Activity Step

Activity Steps

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

108

6

TASKRSRC

Activity Resource Assignment

Activity Resource Assignments

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_Prompt

 

 

 

-1

79

4

TASKSUM

Activity Summary

Activity Summaries

 

 

 

 

 

 

-1

25

0

THRSPARM

Threshold Parameter

Threshold Parameters

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

92

5

TIMESHT

Timesheet

Timesheets

 

 

 

 

 

 

-1

112

7

TRSRCFIN

Activity Resource Assignment Past Period Actuals

Activity Resource Assignment Past Period Actuals

 

 

 

 

 

 

-1

93

5

TRSRCSUM

Activity Resource Summary

Activity Resource Summaries

 

 

 

 

 

 

-1

26

0

TSDATES

Timesheet Interval

Timesheet Intervals

 

 

 

 

 

 

-1

38

1

UDFCODE

User Defined Code

User Defined Codes

 

 

 

 

 

 

-1

27

0

UDFTYPE

User Defined Field

User Defined Fields

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

28

0

UMEASURE

Unit of Measure

Units of Measure

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

29

0

USERCOL

User-defined Column

User-defined Columns

 

 

 

 

 

 

-1

51

2

USERENG

User Product Assignment

User Product Assignments

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

52

2

USEROBS

User OBS Assignment

User OBS Assignments

 

 

 

 

 

 

-1

39

1

USERS

User

Users

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

53

2

USESSION

User Session

User Sessions

 

 

 

 

 

 

-1

50

2

USRDATA

User Setting

User Settings

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

80

4

WBSBUDG

Spending and Benefit Plan

Spending and Benefit Plans

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

81

4

WBSMEMO

EPS, Project and WBS Notebook

EPS, Project and WBS Notebook

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1

94

5

WBSRSRC

High Level Resource Planning Assignment

High Level Resource Planning Assignments

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

109

6

WBSRSRC_QTY

WBSRSRC QTY

WBSRSRC QTY

 

 

 

Y

CA_UpdateExisting (CA_UseExisting,CA_CreateNew,CA

UR_KeepOnly

-1

82

4

WBSSTEP

WBS Milestone

WBS Milestones

 

 

 

Y

CA_UseExisting (CA_UpdateExisting,CA_CreateNew,CA

UR_KeepOnly

-1