PM_GLOBAL_PARAMS Table
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 |