Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata
  • The PM_GLOBAL_PARAMS table is commonly used in a production system to specify the default values for various users.
  • These parameters are not specific to a hive or project.
  • There is one table per Project Management cell.



PM_GLOBAL_PARAMETERS

 

 

PK

ID

int

 

PARAM_NAME

varchar(50)

 

PROJECT_PATH

varchar(50)

 

VALUE

varchar(255)

 

DATATYPE_CD

varchar(255)

 

CAN_OVERRIDE

int



Datatype Code

All the parameter tables contain a column called DATA_TYPE_CD. The value (code) entered in this column is used to determine what the object is. The following is a list of data type codes.

DATATYPE_CD

Description

T

Text that is less than 2000 characters

M

Reference to a Text file (> 2000 characters)

C

Reference to a binary file

N

Numeric (Float)

D

Date (yyyy-MM-ddTHH:mm:ss)

I

Integer

B

Boolean (T/F)

IP

(Reserved)

EP

(Reserved)

RTF

Reference to a RTF File

XLS

Reference to a Microsoft Excel file

XML

Reference to a XML file or blob

DOC

Reference to a Microsoft Word document




  • No labels