Tables | |||||||||
---|---|---|---|---|---|---|---|---|---|
ACTVCODE | Activity code values | ||||||||
ACTVTYPE | Activity codes | ||||||||
ADMIN_CONFIG | Configurations for Administrator app | ||||||||
COSTTYPE | Expense categories | ||||||||
CURRTYPE | Currency information | ||||||||
DOCCATG | Categories for documents | ||||||||
DOCUMENT | |||||||||
FACTCATG | Size and complexity categories | ||||||||
FACTOR | Size and complexity factors for bottom-up and function point estimation | ||||||||
FACTVAL | Size and complexity factor values | ||||||||
FILTPROP | Filter properties | ||||||||
LINKWBS | Links between plugin WBS and base WBS | ||||||||
MEMOTYPE | Activity specification types | ||||||||
NEXTKEY | Next key values for creating all the unique IDs | ||||||||
OBS | OBS for a methodology | ||||||||
PHASE | WBS categories | ||||||||
POBS | Performing Organization Breakdown Structure | ||||||||
PREFER | Admin preferences | ||||||||
PRMAUDIT | Primavera Database Audting | ||||||||
PROCGROUP | Step Group | ||||||||
PROCITEM | Step Group Item | ||||||||
PROFILE | User security profiles | ||||||||
PROFPRIV | Security privileges assigned to user profiles | ||||||||
PUBUSER | Privileged (private) database login usernames and passwords | ||||||||
QUALITY | Activity attributes | ||||||||
QUERYLIB | CBO Query Library | ||||||||
RCATTYPE | Resource category types | ||||||||
RCATVAL | Resource category values | ||||||||
REFRDEL | Audit of deleted records for use by refresh processes. | ||||||||
RISKCTRL | Risk control text fields | ||||||||
RISKTYPE | Risk types | ||||||||
ROLES | Roles | ||||||||
RPT | Report definitions | ||||||||
RPTGROUP | Report groups | ||||||||
RSRC | Resources | ||||||||
RSRCRCAT | Resource categories assigned to resources | ||||||||
RSRCROLE | Roles assigned to resources | ||||||||
SETTINGS | System and user Settings | ||||||||
SPIDMAP | Used by auditing to maintain spid to user information | ||||||||
TASK | Core activities | ||||||||
TASKACTV | Activity codes assigned to activities | ||||||||
TASKDOC | Work products and documents assigned to activities | ||||||||
TASKMEMO | Activity specifications | ||||||||
TASKPRED | Activity dependencies | ||||||||
TASKPROC | Activity steps | ||||||||
TASKQUAL | Attributes assigned to activities | ||||||||
TASKRSRC | Resources assigned to activities | ||||||||
TASKUSE | Activities assigned to methodologies | ||||||||
TCATTYPE | Methodology category types | ||||||||
TCATVAL | Methodology category values | ||||||||
TEMPLATE | Methodologies | ||||||||
TMPLCOST | Expenses for a methodology | ||||||||
TMPLRISK | Methodology risks | ||||||||
TMPLSHAR | Identifies which methodologies are currently locked in shared/exclusive mode by user sessions | ||||||||
TMPLTCAT | Methodology categories assigned to methodologies | ||||||||
TMPLWBS | WBS for a methodology | ||||||||
UDFCODE | Code values for enumerated UDF | ||||||||
UDFTYPE | Definitions/labels for all user-defined columns | ||||||||
UDFVALUE | Values for all user-defined columns | ||||||||
UMEASURE | |||||||||
USERCOL | Definitions/labels for all user-defined columns | ||||||||
USERDATA | Settings/preferences for users, by topic | ||||||||
USERENG | Maps users to database engine types for license enforcement | ||||||||
USERS | Application users | ||||||||
USERTMPL | Users assigned to methodologies with security profiles | ||||||||
USESSION | User sessions to support methodology-level locking and licensing | ||||||||
VIEWPROP | Task grid views | ||||||||
WBSMEMO | Methodology / WBS notebook | ||||||||
WBSSTEP | WBS Milestones |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | actv_code_id | integer | FK to ACTVCODE table - identifies the activity code value | |
FK | actv_code_type_id | integer | FK to ACTVTYPE table - identifies the activity code type | |
seq_num | integer | Sequence number for sorting | ||
short_name | string(60) | Activity code value | ||
parent_actv_code_id | integer | FK to ACTVCODE table - identifies parent in activity code hierarchy | ||
actv_code_name | string(120) | Activity code description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_actvcode_actvtype | NONUNIQUE | actv_code_type_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_ACTVCODE | OR | SQL Server | ||
RT_ACTVCODE_DEL | OR | SQL Server | ||
RT_ACTVCODE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_actvcode_actvtype | FOREIGN | actv_code_type_id | ACTVTYPE | actv_code_type_id | |||
pk_actvcode | PRIMARY | actv_code_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_taskactv_actvcode | FOREIGN | TASKACTV | actv_code_id | actv_code_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | actv_code_type_id | integer | FK to ACTVTYPE table - identifies the activity code type | |
seq_num | integer | Sequence number for sorting | ||
actv_short_len | integer | Max length of activity code value | ||
actv_code_type | string(40) | Activity code name | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_ACTVTYPE | OR | SQL Server | ||
RT_ACTVTYPE_DEL | OR | SQL Server | ||
RT_ACTVTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_actvtype | PRIMARY | actv_code_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_actvcode_actvtype | FOREIGN | ACTVCODE | actv_code_type_id | actv_code_type_id |
fk_taskactv_actvtype | FOREIGN | TASKACTV | actv_code_type_id | actv_code_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | config_name | string(255) | Name of the configuration file the BRE is using | |
config_type | string(10) | would either contain PS or BRE for Presentation config. file **OR** BRE config file, respectively | ||
factory_version | string(10) | Primavera default settings version number. Referred to as the 'Factory Defaults' in the XML config file. | ||
last_change_date | date | Timestamp of last change date | sysdate | |
config_value | string(255) | String value for config entry. | ||
config_data | blob | Storage for the xml config file | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_ADMIN_CONFIG | OR | SQL Server | ||
RT_ADMIN_CONFIG_DEL | OR | SQL Server | ||
RT_ADMIN_CONFIG | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_admin_config | PRIMARY | config_name |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | cost_type_id | integer | FK to COSTTYPE table - identifies the expense category | |
seq_num | integer | Sequence number for sorting | ||
cost_type | string(36) | Expense category | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_COSTTYPE | OR | SQL Server | ||
RT_COSTTYPE_DEL | OR | SQL Server | ||
RT_COSTTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_costtype | PRIMARY | cost_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tmplcost_costtype | FOREIGN | TMPLCOST | cost_type_id | cost_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | curr_id | integer | FK to CURRTYPE table - identifies the user's view Currency | |
decimal_digit_cnt | integer | Number of digits after decimal | ||
curr_symbol | string(6) | Currency symbol | ||
decimal_symbol | string(6) | Decimal symbol | ||
digit_group_symbol | string(6) | Digit grouping symbol | ||
pos_curr_fmt_type | string(20) | Positive currency format | ||
neg_curr_fmt_type | string(20) | Negative currency format | ||
curr_type | string(40) | Currency - values: US Dollars, Canadian Dollars, etc. | ||
curr_short_name | string(6) | Currency ID - Unique currency abbreviation for each currency. (e.g. USD) | ||
group_digit_cnt | integer | Count of digits in group | ||
base_exch_rate | double(22,6) | Exchange rate of this currency to the base currency | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_curr_short_name | UNIQUE | curr_short_name |
Triggers | ||||
---|---|---|---|---|
PRMAUD_CURRTYPE | OR | SQL Server | ||
RT_CURRTYPE_DEL | OR | SQL Server | ||
RT_CURRTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_currtype | PRIMARY | curr_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_prefer_currtype | FOREIGN | PREFER | curr_id | curr_id |
fk_rsrc_currtype | FOREIGN | RSRC | curr_id | curr_id |
fk_users_currtype | FOREIGN | USERS | curr_id | curr_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | doc_catg_id | integer | FK to DOCCATG table - identifies the document category | |
seq_num | integer | Sequence number for sorting | ||
doc_catg_name | string(100) | Document category name | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_DOCCATG | OR | SQL Server | ||
RT_DOCCATG_DEL | OR | SQL Server | ||
RT_DOCCATG | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_doccatg | PRIMARY | doc_catg_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_document_doccatg | FOREIGN | DOCUMENT | doc_catg_id | doc_catg_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | doc_id | integer | FK to DOCUMENT table - identifies the document | |
doc_seq_num | integer | |||
doc_name | string(120) | |||
parent_doc_id | integer | |||
FK | doc_catg_id | integer | FK to DOCCATG table - identifies the document category | |
doc_date | date | Document revision date | ||
version_name | string(20) | Document version | '1.0' | |
guid | string(22) | Global unique ID | ||
doc_short_name | string(32) | Document reference number | ||
author_name | string(100) | Document author | ||
private_loc | string(255) | Private location of document file on file/web server | ||
public_loc | string(255) | Public location of document file on file/web server | ||
doc_content | blob | Document description/content stored as text string | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_document_doccatg | NONUNIQUE | doc_catg_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_DOCUMENT | OR | SQL Server | ||
RT_DOCUMENT_DEL | OR | SQL Server | ||
RT_DOCUMENT | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_document_doccatg | FOREIGN | doc_catg_id | DOCCATG | doc_catg_id | |||
pk_document | PRIMARY | doc_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_taskdoc_document | FOREIGN | TASKDOC | doc_id | doc_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | fact_catg_id | integer | FK to FACTCATG table - identifies the factor category. Size and complexity category | |
seq_num | integer | Sequence number for sorting | ||
fact_catg_name | string(100) | Factor category name | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_FACTCATG | OR | SQL Server | ||
RT_FACTCATG_DEL | OR | SQL Server | ||
RT_FACTCATG | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_factcatg | PRIMARY | fact_catg_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_factor_factcatg | FOREIGN | FACTOR | fact_catg_id | fact_catg_id |
fk_tmplwbs_factcatg | FOREIGN | TMPLWBS | fact_catg_id | fact_catg_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | fact_id | integer | FK to FACTOR table - identifies the factor | |
fact_seq_num | integer | Sequence number for sorting within the factor category | ||
fact_type | string(20) | Factor type - Function Point or Bottom-up Complexity | ||
fact_name | string(100) | Factor name | ||
def_fact_val_id | integer | FK to FACTVAL table - identifies the default factor value | ||
FK | fact_catg_id | integer | FK to FACTCATG table - identifies the factor category. Size and complexity category | |
fact_descr | blob | Factor description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_factor_factcatg | NONUNIQUE | fact_catg_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_FACTOR | OR | SQL Server | ||
RT_FACTOR_DEL | OR | SQL Server | ||
RT_FACTOR | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_factor_factcatg | FOREIGN | fact_catg_id | FACTCATG | fact_catg_id | |||
pk_factor | PRIMARY | fact_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_factval_factor | FOREIGN | FACTVAL | fact_id | fact_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | fact_val_id | integer | Unique ID | |
FK | fact_id | integer | FK to FACTOR table - identifies the factor | |
fact_value | string(24) | Factor value | ||
fact_value_descr | string(255) | Factor value description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_factval_factor | NONUNIQUE | fact_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_FACTVAL | OR | SQL Server | ||
RT_FACTVAL_DEL | OR | SQL Server | ||
RT_FACTVAL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_factval_factor | FOREIGN | fact_id | FACTOR | fact_id | |||
pk_factval | PRIMARY | fact_val_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | filter_id | integer | Unique ID | |
table_name | string(16) | Name of database table where column resides | ||
filter_type | string(20) | Type of filter | ||
filter_name | string(40) | Filter name | ||
FK | user_id | integer | FK to USERS table - identifies the user | |
filter_data | blob | Filter settings stored as text string | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_filtprop_1 | NONUNIQUE | user_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_FILTPROP | OR | SQL Server | ||
RT_FILTPROP_DEL | OR | SQL Server | ||
RT_FILTPROP | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_filtprop_users | FOREIGN | user_id | USERS | user_id | |||
pk_filtprop | PRIMARY | filter_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | linkwbs_id | integer | Unique ID | |
FK | base_wbs_id | integer | FK to TMPLWBS table - base WBS plugin WBS/activity is linked to | |
base_template_id | integer | FK to TEMPLATE table - identifies the base template | ||
plugin_template_id | integer | FK to TEMPLATE table - identifies the plugin template | ||
FK | plugin_wbs_id | integer | FK to TMPLWBS table - plugin WBS which is linked to the base WBS | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_linkwbs_1 | NONUNIQUE | base_template_id | |||||
ndx_linkwbs_2 | NONUNIQUE | plugin_template_id | |||||
ndx_linkwbs_tmplwbs_1 | NONUNIQUE | base_wbs_id | |||||
ndx_linkwbs_tmplwbs_2 | NONUNIQUE | plugin_wbs_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_LINKWBS | OR | SQL Server | ||
RT_LINKWBS_DEL | OR | SQL Server | ||
RT_LINKWBS | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_linkwbs_tmplwbs_1 | FOREIGN | base_wbs_id | TMPLWBS | wbs_id | |||
fk_linkwbs_tmplwbs_2 | FOREIGN | plugin_wbs_id | TMPLWBS | wbs_id | |||
pk_linkwbs | PRIMARY | linkwbs_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | memo_type_id | integer | FK to MEMOTYPE table - identifies the notebook topic | |
seq_num | integer | Sequence number for sorting | ||
tmpl_flag | string(1) | Indicates whether specification topic available for templates | 'N' | |
wbs_flag | string(1) | Indicates whether specification topic available for WBS | 'N' | |
task_flag | string(1) | Indicates whether notebook topic available for activities | 'N' | |
memo_type | string(40) | Activity specification | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_MEMOTYPE | OR | SQL Server | ||
RT_MEMOTYPE_DEL | OR | SQL Server | ||
RT_MEMOTYPE | OR | SQL Server |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_taskmemo_memotype | FOREIGN | TASKMEMO | memo_type_id | memo_type_id |
fk_wbsmemo_memotype | FOREIGN | WBSMEMO | memo_type_id | memo_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | key_name | string(30) | Name of key (unique ID) | |
key_seq_num | integer | Current value of key (unique ID) |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers |
---|
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_nextkey | PRIMARY | key_name |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | obs_id | integer | FK to OBS table - identifies the responsible OBS | |
seq_num | integer | Sequence number for sorting | ||
obs_name | string(100) | OBS name | ||
parent_obs_id | integer | FK to OBS table - identifies parent in OBS hierarchy | ||
obs_descr | blob | OBS description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_OBS | OR | SQL Server | ||
RT_OBS_DEL | OR | SQL Server | ||
RT_OBS | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_obs | PRIMARY | obs_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tmplwbs_obs | FOREIGN | TMPLWBS | obs_id | obs_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | phase_id | integer | FK to PHASE table - identifies WBS category value | |
seq_num | integer | Sequence number for sorting | ||
phase_name | string(100) | WBS category name | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_PHASE | OR | SQL Server | ||
RT_PHASE_DEL | OR | SQL Server | ||
RT_PHASE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_phase | PRIMARY | phase_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tmplwbs_phase | FOREIGN | TMPLWBS | phase_id | phase_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | pobs_id | integer | Primary key for table | |
seq_num | integer | Sequence number for sorting | ||
pobs_name | string(255) | POBS name | ||
pobs_parent_id | integer | POBS parent for current record | ||
pobs_descr | string(255) | POBS description | ||
pobs_manager | string(255) | POBS manager | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_pobs_parent_id | NONUNIQUE | pobs_parent_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_POBS | OR | SQL Server | ||
RT_POBS_DEL | OR | SQL Server | ||
RT_POBS | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_pobs | PRIMARY | pobs_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | prefer_id | integer | Unique ID | |
max_wbs_level_cnt | integer | Maximum count of levels in WBS hierarchy | ||
max_rsrc_level_cnt | integer | Maximum count of levels in resource hierarchy | ||
max_obs_level_cnt | integer | Maximum count of levels in OBS hierarchy | ||
wbs_short_len | integer | Maximum length of WBS code | ||
rsrc_short_len | integer | Maximum length of resource code | ||
task_code_len | integer | Maximum length of activity code | ||
role_short_len | integer | Maximum length of role code | ||
max_actv_level_cnt | integer | Maximum count of levels in activity code hierarchy | ||
max_tcat_level_cnt | integer | Maximum count of levels in methodology category hierarchy | ||
max_rcat_level_cnt | integer | Maximum count of levels in resource category hierarchy | ||
max_role_level_cnt | integer | Maximum number of levels allowed in the role tree | ||
day_hr_cnt | double(22,2) | Count of hours per day for converting displayed time/duration units | ||
week_hr_cnt | double(22,2) | Count of hours per week for converting displayed time/duration units | ||
year_hr_cnt | double(22,2) | Count of hours per month for converting displayed time/duration units | ||
month_hr_cnt | double(22,2) | Count of hours per month for converting displayed time/duration units | ||
name_sep_char | string(2) | Character for separating concatenated code fields for WBS and Resource | ||
year_char | string(4) | Display character for years in time/duration fields | ||
month_char | string(4) | Display character for months in time/duration fields | ||
week_char | string(4) | Display character for weeks in time/duration fields | ||
day_char | string(4) | Display character for days in time/duration fields | ||
hour_char | string(4) | Display character for minutes in time/duration fields | ||
minute_char | string(4) | Display character for minutes in time/duration fields | ||
def_complete_pct_type | string(10) | Default complete % type for new activities - Units/Duration/Physical | 'CP_Drtn' | |
default_duration_type | string(20) | Default duration type for new activities | ||
database_version | string(30) | Version identifier string for database schema | ||
db_name | string(20) | Customer chosen identifier for database instance, e.g. ENGINEERING | ||
phase_label | string(40) | Label for global WBS category | ||
rpt_header_1 | string(255) | Report header string for report authoring - choice 1 | ||
rpt_header_2 | string(255) | Report header string for report authoring - choice 2 | ||
rpt_header_3 | string(255) | Report header string for report authoring - choice 3 | ||
rpt_footer_1 | string(255) | Report footer string for report authoring - choice 1 | ||
rpt_footer_2 | string(255) | Report footer string for report authoring - choice 2 | ||
rpt_footer_3 | string(255) | Report footer string for report authoring - choice 3 | ||
rpt_user_1 | string(255) | Provides additional user information for report authoring - beyond header and footer | ||
rpt_user_2 | string(255) | Provides additional user information for report authoring - beyond header and footer | ||
rpt_user_3 | string(255) | Provides additional user information for report authoring - beyond header and footer | ||
FK | curr_id | integer | FK to CURRTYPE table - identifies the user's view Currency | 1 |
def_task_type | string(12) | Default task types | 'TT_Task' | |
license_data | blob | License string, encrypted | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_PREFER | OR | SQL Server | ||
RT_PREFER_DEL | OR | SQL Server | ||
RT_PREFER | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_prefer_currtype | FOREIGN | curr_id | CURRTYPE | curr_id | |||
pk_prefer | PRIMARY | prefer_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
audit_date | date | Timestamp for this audit record | ||
table_name | string(30) | Table name of data being audited | ||
pk1 | string(255) | Value of the first primary key for this table audit | ||
pk2 | string(255) | Value of the second primary key for this table audit | ||
pk3 | string(255) | Value of the third primary key for this table audit | ||
pk4 | string(255) | Value of the forth primary key for this table audit | ||
oper | string(1) | Operation I=insert, U=update, D=delete | ||
prm_user_name | string(32) | Primavera username making the transaction | ||
audit_info | string(4000) | Column audit that is under 4k | ||
audit_info_extended | blob | Extended audit information and blob auditing information | ||
logical_delete_flag | string(1) | Flag is Y if this record is a result of a logical delete | ||
rdbms_user_name | string(255) | Database user making the transaction (if available) | ||
os_user_name | string(255) | Operating system username making the transaction (if available) | ||
program | string(255) | Name of program executing the transaction (if available) | ||
host_name | string(255) | Host Name of program executing the transaction (if available) | ||
app_name | string(25) | Primavera Application Name of executing the transaction (if available) | ||
netaddress | string(24) | Net Address of executing the transaction (if available) |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers |
---|
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | proc_group_id | integer | Primary Key | |
seq_num | integer | Sequence number for sorting | ||
proc_group_name | string(120) | Step Group Name | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_PROCGROUP | OR | SQL Server | ||
RT_PROCGROUP_DEL | OR | SQL Server | ||
RT_PROCGROUP | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_procgroup | PRIMARY | proc_group_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_procitem_procgroup | FOREIGN | PROCITEM | proc_group_id | proc_group_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | proc_item_id | integer | Primary Key | |
FK | proc_group_id | integer | FK to PROCGROUP | |
seq_num | integer | Sequence number for sorting | ||
proc_name | string(120) | Step Item Name | ||
proc_wt | double(22,2) | Step Weight | ||
proc_descr | blob | Step Description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_procitem | NONUNIQUE | proc_group_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_PROCITEM | OR | SQL Server | ||
RT_PROCITEM_DEL | OR | SQL Server | ||
RT_PROCITEM | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_procitem | PRIMARY | proc_item_id | |||||
fk_procitem_procgroup | FOREIGN | proc_group_id | PROCGROUP | proc_group_id | DEPENDENT |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | prof_id | integer | FK to PROFILE table - identifies security profile for the user for this methodology | |
default_flag | string(1) | Identifies the default profile for new users | 'N' | |
superuser_flag | string(1) | Identifies the super user profile - can do anything, no individual privileges linked | 'N' | |
scope_type | string(12) | Scope of profile - global or project | ||
prof_name | string(100) | Profile name | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_PROFILE | OR | SQL Server | ||
RT_PROFILE_DEL | OR | SQL Server | ||
RT_PROFILE | OR | SQL Server |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_profpriv_profile | FOREIGN | PROFPRIV | prof_id | prof_id |
fk_users_profile | FOREIGN | USERS | prof_id | prof_id |
fk_usertmpl_profile | FOREIGN | USERTMPL | prof_id | prof_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | prof_id | integer | FK to PROFILE table - identifies security profile for the user for this methodology | |
PK | priv_num | integer | Privilege number - identifies the privilege. Privilege names are compiled into the code. | |
allow_flag | string(1) | Identifies which privileges are allowed for this profile | 'N' | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_PROFPRIV | OR | SQL Server | ||
RT_PROFPRIV_DEL | OR | SQL Server | ||
RT_PROFPRIV | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_profpriv_profile | FOREIGN | prof_id | PROFILE | prof_id | |||
pk_profpriv | PRIMARY | prof_id,priv_num | |||||
ck_profpriv_allow_flag | CHECK | allow_flag | allow_flag in ('Y', 'N') |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | public_group_id | integer | Unique ID for private user and the public group which uses it (matches INI file) | |
private_db_user_name | string(40) | Database username used to connect with update privileges | ||
private_db_passwd | string(255) | Encoded database password used to connect with update privileges |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers |
---|
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_pubuser | PRIMARY | public_group_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | qual_id | integer | FK to QUALITY table - identifies the attribute for filtering in Project Architect | |
qual_seq_num | integer | Sequence number for sorting | ||
req_flag | string(1) | Identifies locked attributes - cannot be filtered out in Project Architect | 'N' | |
qual_name | string(100) | Attribute name | ||
qual_descr | blob | Attribute description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_QUALITY | OR | SQL Server | ||
RT_QUALITY_DEL | OR | SQL Server | ||
RT_QUALITY | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_quality | PRIMARY | qual_id | |||||
ck_quality_req_flag | CHECK | req_flag | req_flag in ('Y', 'N') |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_taskqual_quality | FOREIGN | TASKQUAL | qual_id | qual_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | query_lib_id | integer | PK for QUERYLIB table | |
app_name | string(25) | Application Name | ||
core_flag | string(1) | Flag for Primavera query or customer query | ||
match_sql | string(4000) | Tokenized sql for matching | ||
hints | string(4000) | Oracle Hints | ||
replacement_sql | string(4000) | Replaced Sql | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_QUERYLIB | OR | SQL Server | ||
RT_QUERYLIB_DEL | OR | SQL Server | ||
RT_QUERYLIB | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_querylib | PRIMARY | query_lib_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | rsrc_catg_type_id | integer | FK to RCATTYPE table - identifies the resource category type | |
seq_num | integer | Sequence number for sorting | ||
rsrc_catg_short_len | integer | Max length of resource category value | ||
rsrc_catg_type | string(40) | Resource category type | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RCATTYPE | OR | SQL Server | ||
RT_RCATTYPE_DEL | OR | SQL Server | ||
RT_RCATTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_rcattype | PRIMARY | rsrc_catg_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_rcatval_rcattype | FOREIGN | RCATVAL | rsrc_catg_type_id | rsrc_catg_type_id |
fk_rsrcrcat_rcattype | FOREIGN | RSRCRCAT | rsrc_catg_type_id | rsrc_catg_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | rsrc_catg_id | integer | FK to RCATVAL table - identifies the resource category value | |
FK | rsrc_catg_type_id | integer | FK to RCATTYPE table - identifies the resource category type | |
seq_num | integer | Sequence number for sorting | ||
rsrc_catg_short_name | string(32) | Resource category value | ||
parent_rsrc_catg_id | integer | FK to RCATVAL table - identifies the parent resource category value | ||
rsrc_catg_name | string(100) | Resource category description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_rcatval_rcattype | NONUNIQUE | rsrc_catg_type_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RCATVAL | OR | SQL Server | ||
RT_RCATVAL_DEL | OR | SQL Server | ||
RT_RCATVAL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_rcatval_rcattype | FOREIGN | rsrc_catg_type_id | RCATTYPE | rsrc_catg_type_id | |||
pk_rcatval | PRIMARY | rsrc_catg_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_rsrcrcat_rcatval | FOREIGN | RSRCRCAT | rsrc_catg_id | rsrc_catg_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
delete_date | date | Timestamp for delete. | sysdate | |
table_name | string(30) | Name of table for delete operation. | ||
pk1 | string(255) | Generic PK value for table. | ||
pk2 | string(255) | Second PK value for composite keys. | ||
pk3 | string(255) | Third PK value for composite keys. | ||
pk4 | string(255) | Fourth PK value for composite keys. | ||
template_id | integer | Project ID |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_refrdel_delete_date | NONUNIQUE | delete_date |
Triggers |
---|
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | risk_id | integer | Unique ID | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
risk_control | blob | Risk control text field | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_riskctrl_1 | NONUNIQUE | template_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RISKCTRL | OR | SQL Server | ||
RT_RISKCTRL_DEL | OR | SQL Server | ||
RT_RISKCTRL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_riskctrl_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_riskctrl_tmplrisk | FOREIGN | risk_id | TMPLRISK | risk_id | |||
pk_riskctrl | PRIMARY | risk_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | risk_type_id | integer | FK to RISKTYPE table - identifies the risk type | |
seq_num | integer | Sequence number for sorting | ||
risk_type | string(40) | Risk type | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RISKTYPE | OR | SQL Server | ||
RT_RISKTYPE_DEL | OR | SQL Server | ||
RT_RISKTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_risktype | PRIMARY | risk_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tmplrisk_risktype | FOREIGN | TMPLRISK | risk_type_id | risk_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | role_id | integer | FK to ROLES table - identifies the role for this resource on this activity | |
role_short_name | string(40) | Role code | ||
role_name | string(100) | Role name | ||
seq_num | integer | Sequence number for sorting | ||
parent_role_id | integer | FK to ROLES table - identifies the parent in the role hierarchy | ||
FK | pobs_id | integer | FK to POBS table - identifies the performing organization | |
role_descr | blob | Role description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_ROLES | OR | SQL Server | ||
RT_ROLES_DEL | OR | SQL Server | ||
RT_ROLES | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_roles | PRIMARY | role_id | |||||
fk_roles_pobs | FOREIGN | pobs_id | POBS | pobs_id | INDEPENDENT |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_rsrc_roles | FOREIGN | RSRC | role_id | role_id |
fk_rsrcrole_roles | FOREIGN | RSRCROLE | role_id | role_id |
fk_taskrsrc_roles | FOREIGN | TASKRSRC | role_id | role_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | rpt_id | integer | Unique ID | |
rpt_type | string(12) | Report type - user report or website report | ||
rpt_name | string(80) | Report name | ||
FK | rpt_group_id | integer | Unique ID | |
rpt_state | string(10) | State of the report | ||
rpt_data | blob | Report settings stored as text field | ||
last_run_date | date | Last run execution date/time | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_rpt_rptgroup | NONUNIQUE | rpt_group_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RPT | OR | SQL Server | ||
RT_RPT_DEL | OR | SQL Server | ||
RT_RPT | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_rpt_rptgroup | FOREIGN | rpt_group_id | RPTGROUP | rpt_group_id | |||
pk_rpt | PRIMARY | rpt_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | rpt_group_id | integer | Unique ID | |
rpt_group_seq_num | integer | Sequence number for sorting | ||
rpt_group_name | string(80) | Report group name | ||
parent_group_id | integer | FK to RPTGROUP table - identifies parent in report-group hierarchy | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RPTGROUP | OR | SQL Server | ||
RT_RPTGROUP_DEL | OR | SQL Server | ||
RT_RPTGROUP | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_rptgroup | PRIMARY | rpt_group_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_rpt_rptgroup | FOREIGN | RPT | rpt_group_id | rpt_group_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | rsrc_id | integer | FK to RSRC table - identifies the resource | |
rsrc_seq_num | integer | Sequence number for sorting | ||
rsrc_type | string(10) | Resource type Labor, Equipment, or Material | 'RT_Labor' | |
ot_flag | string(1) | Identifies whether overtime is allowed | 'N' | |
rsrc_short_name | string(40) | Resource code | ||
rsrc_name | string(100) | Resource name | ||
parent_rsrc_id | integer | FK to RSRC table - identifies parent in resource hierarchy | ||
FK | role_id | integer | FK to ROLES table - identifies the role for this resource on this activity | |
FK | pobs_id | integer | FK to POBS table - identifies the performing organization | |
max_qty_per_hr | double(22,8) | Maximum units per time (hours per hour) | ||
ot_factor | double(22,3) | Overtime factor, if overtime allowed (multiplier on the standard price/time) | ||
def_qty_per_hr | double(22,8) | Default units per time (hours per hour) | ||
cost_per_qty | double(22,8) | Price/time to compute costs | ||
guid | string(22) | Global unique ID | ||
cost_qty_type | string(24) | Time units for resource's price/time (year/month/week/day/hour) | ||
office_phone | string(32) | Office phone | ||
employee_code | string(40) | Employee code or employee number Employee ID | ||
rsrc_title_name | string(100) | Resource job title | ||
email_addr | string(120) | Email address | ||
FK | curr_id | integer | FK to CURRTYPE table - identifies the user's view Currency | 1 |
FK | unit_id | integer | UMeasure ID | |
rsrc_notes | blob | Resource notes stored as text string | ||
def_cost_qty_link_flag | string(1) | Calculate cost from units | 'Y' | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_rsrc_roles | NONUNIQUE | role_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RSRC | OR | SQL Server | ||
RT_RSRC_DEL | OR | SQL Server | ||
RT_RSRC | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_rsrc | PRIMARY | rsrc_id | |||||
fk_rsrc_currtype | FOREIGN | curr_id | CURRTYPE | curr_id | |||
fk_rsrc_roles | FOREIGN | role_id | ROLES | role_id | |||
fk_rsrc_pobs | FOREIGN | pobs_id | POBS | pobs_id | INDEPENDENT | ||
fk_rsrc_umeasure | FOREIGN | unit_id | UMEASURE | unit_id | |||
ck_rsrc_ot_flag | CHECK | ot_flag | ot_flag in ('Y', 'N') |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_rsrcrcat_rsrc | FOREIGN | RSRCRCAT | rsrc_id | rsrc_id |
fk_rsrcrole_rsrc | FOREIGN | RSRCROLE | rsrc_id | rsrc_id |
fk_taskrsrc_rsrc | FOREIGN | TASKRSRC | rsrc_id | rsrc_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | rsrc_id | integer | FK to RSRC table - identifies the resource | |
PK,FK | rsrc_catg_type_id | integer | FK to RCATTYPE table - identifies the resource category type | |
FK | rsrc_catg_id | integer | FK to RCATVAL table - identifies the resource category value | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_rsrcrcat_rcattype | NONUNIQUE | rsrc_catg_type_id | |||||
ndx_rsrcrcat_rcatval | NONUNIQUE | rsrc_catg_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RSRCRCAT | OR | SQL Server | ||
RT_RSRCRCAT_DEL | OR | SQL Server | ||
RT_RSRCRCAT | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_rsrcrcat_rcattype | FOREIGN | rsrc_catg_type_id | RCATTYPE | rsrc_catg_type_id | |||
fk_rsrcrcat_rsrc | FOREIGN | rsrc_id | RSRC | rsrc_id | |||
fk_rsrcrcat_rcatval | FOREIGN | rsrc_catg_id | RCATVAL | rsrc_catg_id | |||
pk_rsrcrcat | PRIMARY | rsrc_id,rsrc_catg_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | rsrc_id | integer | FK to RSRC table - identifies the resource | |
PK,FK | role_id | integer | FK to ROLES table - identifies the role for this resource on this activity | |
skill_level | integer | Proficiency level | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_rsrcrole_roles | NONUNIQUE | role_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_RSRCROLE | OR | SQL Server | ||
RT_RSRCROLE_DEL | OR | SQL Server | ||
RT_RSRCROLE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_rsrcrole_roles | FOREIGN | role_id | ROLES | role_id | |||
fk_rsrcrole_rsrc | FOREIGN | rsrc_id | RSRC | rsrc_id | |||
pk_rsrcrole | PRIMARY | rsrc_id,role_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | namespace | string(255) | Grouping of parameter | |
PK | setting_name | string(255) | Name of Setting | |
setting_value | string(4000) | Actual Value of setting | ||
user_id | integer | User Specific setting | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
RT_SETTINGS_DEL | OR | SQL Server | ||
RT_SETTINGS | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_settings | PRIMARY | namespace,setting_name |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | spid | integer | Unique ID | |
user_id | integer | FK to USERS | ||
user_name | string(32) | Identified user name | ||
app_name | string(25) | Idnetified application name | ||
audit_info_extended | blob | Holder for temporary audit data |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
TR_PROTECT_SPIDMAP | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_spidmap | PRIMARY | spid |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | task_id | integer | FK to TASK table - identifies the core activity | |
task_type | string(10) | Activity type - task/milestone/etc | ||
complete_pct_type | string(10) | Controls how the Activity % Complete is computed for the activity - either Duration (based on Duration % Complete), Units (based on Units % Complete), or Physical (entered by user) | 'CP_Drtn' | |
duration_type | string(12) | Duration type - Fixed-Units/Fixed-Duration/Fixed-Units-per-Time | ||
task_name | string(120) | Activity name | ||
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
guid | string(22) | Global unique ID | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_task_1 | NONUNIQUE | template_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASK | OR | SQL Server | ||
RT_TASK_DEL | OR | SQL Server | ||
RT_TASK | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_task_template | FOREIGN | template_id | TEMPLATE | template_id | |||
pk_task | PRIMARY | task_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | taskuse_id | integer | FK to TASKUSE table - identifies the activity within the methodology | |
PK,FK | actv_code_type_id | integer | FK to ACTVTYPE table - identifies the activity code type | |
FK | actv_code_id | integer | FK to ACTVCODE table - identifies the activity code value | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskactv_1 | NONUNIQUE | template_id | |||||
ndx_taskactv_actvcode | NONUNIQUE | actv_code_id | |||||
ndx_taskactv_actvtype | NONUNIQUE | actv_code_type_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKACTV | OR | SQL Server | ||
RT_TASKACTV_DEL | OR | SQL Server | ||
RT_TASKACTV | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskactv_actvcode | FOREIGN | actv_code_id | ACTVCODE | actv_code_id | |||
fk_taskactv_actvtype | FOREIGN | actv_code_type_id | ACTVTYPE | actv_code_type_id | |||
fk_taskactv_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_taskactv_taskuse | FOREIGN | taskuse_id | TASKUSE | taskuse_id | |||
pk_taskactv | PRIMARY | taskuse_id,actv_code_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | taskdoc_id | integer | Unique ID | |
FK | doc_id | integer | FK to DOCUMENT table - identifies the document | |
FK | wbs_id | integer | FK to TMPLWBS table - identifies the WBS | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
wp_flag | string(1) | Identifies which documents are work products (outputs) for the activity | 'N' | |
FK | taskuse_id | integer | FK to TASKUSE table - identifies the activity within the methodology | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskdoc_1 | NONUNIQUE | template_id | |||||
ndx_taskdoc_document | NONUNIQUE | doc_id | |||||
ndx_taskdoc_taskuse | NONUNIQUE | taskuse_id | |||||
ndx_taskdoc_tmplwbs | NONUNIQUE | wbs_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKDOC | OR | SQL Server | ||
RT_TASKDOC_DEL | OR | SQL Server | ||
RT_TASKDOC | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskdoc_document | FOREIGN | doc_id | DOCUMENT | doc_id | |||
fk_taskdoc_tmplwbs | FOREIGN | wbs_id | TMPLWBS | wbs_id | |||
fk_taskdoc_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_taskdoc_taskuse | FOREIGN | taskuse_id | TASKUSE | taskuse_id | |||
pk_taskdoc | PRIMARY | taskdoc_id | |||||
ck_taskdoc_wp_flag | CHECK | wp_flag | wp_flag in ('Y', 'N') |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | memo_id | integer | Unique ID | |
FK | task_id | integer | FK to TASK table - identifies the core activity | |
FK | memo_type_id | integer | FK to MEMOTYPE table - identifies the notebook topic | |
task_memo | blob | Specification contents stored as text string | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskmemo_memotype | NONUNIQUE | memo_type_id | |||||
ndx_taskmemo_task | NONUNIQUE | task_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKMEMO | OR | SQL Server | ||
RT_TASKMEMO_DEL | OR | SQL Server | ||
RT_TASKMEMO | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskmemo_memotype | FOREIGN | memo_type_id | MEMOTYPE | memo_type_id | |||
fk_taskmemo_task | FOREIGN | task_id | TASK | task_id | |||
pk_taskmemo | PRIMARY | memo_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | taskuse_pred_id | integer | Unique ID | |
FK | taskuse_id | integer | FK to TASKUSE table - identifies the activity within the methodology | |
FK | pred_taskuse_id | integer | FK to TASKUSE table - identifies the predecessor activity within the methodology | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
FK | pred_template_id | integer | FK to TEMPLATE table - identifies the predecessor methodology | |
pred_type | string(12) | Dependency type - FS/FF/SS/SF | ||
lag_hr_cnt | double(22,6) | Time lag of dependency | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskpred_1 | NONUNIQUE | pred_template_id | |||||
ndx_taskpred_2 | NONUNIQUE | template_id | |||||
ndx_taskpred_taskuse_1 | NONUNIQUE | taskuse_id | |||||
ndx_taskpred_taskuse_2 | NONUNIQUE | pred_taskuse_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKPRED | OR | SQL Server | ||
RT_TASKPRED_DEL | OR | SQL Server | ||
RT_TASKPRED | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskpred_taskuse_1 | FOREIGN | taskuse_id | TASKUSE | taskuse_id | |||
fk_taskpred_template_2 | FOREIGN | pred_template_id | TEMPLATE | template_id | |||
fk_taskpred_taskuse_2 | FOREIGN | pred_taskuse_id | TASKUSE | taskuse_id | |||
fk_taskpred_template_1 | FOREIGN | template_id | TEMPLATE | template_id | |||
pk_taskpred | PRIMARY | taskuse_pred_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | proc_id | integer | Unique ID | |
FK | task_id | integer | FK to TASK table - identifies the core activity | |
seq_num | integer | Sequence number for sorting | ||
proc_name | string(120) | Step name | ||
proc_wt | double(22,2) | Relative weight or contribution of work on task step weight | ||
proc_descr | blob | Step description stored as text string | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskproc_task | NONUNIQUE | task_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKPROC | OR | SQL Server | ||
RT_TASKPROC_DEL | OR | SQL Server | ||
RT_TASKPROC | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskproc_task | FOREIGN | task_id | TASK | task_id | |||
pk_taskproc | PRIMARY | proc_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | task_id | integer | FK to TASK table - identifies the core activity | |
PK,FK | qual_id | integer | FK to QUALITY table - identifies the attribute for filtering in Project Architect | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskqual_quality | NONUNIQUE | qual_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKQUAL | OR | SQL Server | ||
RT_TASKQUAL_DEL | OR | SQL Server | ||
RT_TASKQUAL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskqual_quality | FOREIGN | qual_id | QUALITY | qual_id | |||
fk_taskqual_task | FOREIGN | task_id | TASK | task_id | |||
pk_taskqual | PRIMARY | task_id,qual_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | taskrsrc_id | integer | Unique ID | |
FK | taskuse_id | integer | FK to TASKUSE table - identifies the activity within the methodology | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
rsrc_type | string(10) | Resource type Labor, Equipment, or Material | 'RT_Labor' | |
FK | role_id | integer | FK to ROLES table - identifies the role for this resource on this activity | |
FK | rsrc_id | integer | FK to RSRC table - identifies the resource | |
FK | pobs_id | integer | FK to POBS table - identifies the performing organization | |
skill_level | integer | Proficiency level | ||
qty_per_hr | double(22,8) | Units per time for this resource on this activity (hours per hour) | ||
low_qty | double(22,6) | Low count of units for this resource on this activity (hours) | ||
high_qty | double(22,6) | High count of units for this resource on this activity (hours) | ||
cost_qty_link_flag | string(1) | Costs Units Linked | 'Y' | |
lag_drtn_hr_cnt | double(22,6) | Time lag | 0 | |
low_cost | double(22,6) | Low expense cost | ||
high_cost | double(22,6) | High expense cost | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskrsrc_1 | NONUNIQUE | template_id | |||||
ndx_taskrsrc_roles | NONUNIQUE | role_id | |||||
ndx_taskrsrc_rsrc | NONUNIQUE | rsrc_id | |||||
ndx_taskrsrc_taskuse | NONUNIQUE | taskuse_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKRSRC | OR | SQL Server | ||
RT_TASKRSRC_DEL | OR | SQL Server | ||
RT_TASKRSRC | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskrsrc_roles | FOREIGN | role_id | ROLES | role_id | |||
fk_taskrsrc_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_taskrsrc_rsrc | FOREIGN | rsrc_id | RSRC | rsrc_id | |||
fk_taskrsrc_pobs | FOREIGN | pobs_id | POBS | pobs_id | INDEPENDENT | ||
fk_taskrsrc_taskuse | FOREIGN | taskuse_id | TASKUSE | taskuse_id | |||
pk_taskrsrc | PRIMARY | taskrsrc_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | taskuse_id | integer | FK to TASKUSE table - identifies the activity within the methodology | |
FK | task_id | integer | FK to TASK table - identifies the core activity | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
FK | wbs_id | integer | FK to TMPLWBS table - identifies the WBS | |
est_wt | double(22,2) | Estimation weight, for top-down estimation | ||
task_code | string(40) | Activity code | ||
low_work_qty | double(22,6) | Low count of labor units, rolled up from assigned activities | ||
high_work_qty | double(22,6) | High count of labor units, rolled up from assigned activities | ||
low_equip_qty | double(22,6) | Low count of non-labor units, rolled up from assigned activities | ||
high_equip_qty | double(22,6) | High count of non-labor units, rolled up from assigned activities | ||
low_drtn_hr_cnt | double(22,6) | Low duration estimate | ||
high_drtn_hr_cnt | double(22,6) | |||
guid | string(22) | Global unique ID | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_taskuse_1 | NONUNIQUE | template_id | |||||
ndx_taskuse_task | NONUNIQUE | task_id | |||||
ndx_taskuse_tmplwbs | NONUNIQUE | wbs_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TASKUSE | OR | SQL Server | ||
RT_TASKUSE_DEL | OR | SQL Server | ||
RT_TASKUSE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_taskuse_task | FOREIGN | task_id | TASK | task_id | |||
fk_taskuse_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_taskuse_tmplwbs | FOREIGN | wbs_id | TMPLWBS | wbs_id | |||
pk_taskuse | PRIMARY | taskuse_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | tmpl_catg_type_id | integer | FK to TCATTYPE table - identifies the methodology category type | |
seq_num | integer | Sequence number for sorting | ||
tmpl_catg_short_len | integer | Max length of methodology category value | ||
tmpl_catg_type | string(40) | Methodology category type | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TCATTYPE | OR | SQL Server | ||
RT_TCATTYPE_DEL | OR | SQL Server | ||
RT_TCATTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_tcattype | PRIMARY | tmpl_catg_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tcatval_tcattype | FOREIGN | TCATVAL | tmpl_catg_type_id | tmpl_catg_type_id |
fk_tmpltcat_tcattype | FOREIGN | TMPLTCAT | tmpl_catg_type_id | tmpl_catg_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | tmpl_catg_id | integer | FK to TCATVAL table - identifies the methodology category value | |
FK | tmpl_catg_type_id | integer | FK to TCATTYPE table - identifies the methodology category type | |
seq_num | integer | Sequence number for sorting | ||
tmpl_catg_short_name | string(32) | Methodology category value | ||
parent_tmpl_catg_id | integer | FK to TCATVAL table - identifies the parent methodology category value | ||
tmpl_catg_name | string(100) | Methodology category description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_tcatval_tcattype | NONUNIQUE | tmpl_catg_type_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TCATVAL | OR | SQL Server | ||
RT_TCATVAL_DEL | OR | SQL Server | ||
RT_TCATVAL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_tcatval_tcattype | FOREIGN | tmpl_catg_type_id | TCATTYPE | tmpl_catg_type_id | |||
pk_tcatval | PRIMARY | tmpl_catg_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tmpltcat_tcatval | FOREIGN | TMPLTCAT | tmpl_catg_id | tmpl_catg_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
add_date | date | Date methodology was created | ||
checkout_flag | string(1) | Indicates whether the methodology is currently checked out | 'N' | |
template_type | string(20) | Methodology type - Base/Plugin/Activity-Library | ||
status_code | string(20) | Methodology status values: Available, Unavailable | ||
template_name | string(100) | Methodology name | ||
task_cnt | integer | Count of tasks, rolled up from assigned activities | ||
task_code_base | integer | Suffix base value for auto-increment of task code | ||
task_code_step | integer | Suffix step value for auto-increment of task code | ||
low_work_qty | double(22,6) | Low count of labor units, rolled up from assigned activities | ||
high_work_qty | double(22,6) | High count of labor units, rolled up from assigned activities | ||
low_equip_qty | double(22,6) | Low count of non-labor units, rolled up from assigned activities | ||
high_equip_qty | double(22,6) | High count of non-labor units, rolled up from assigned activities | ||
low_work_cost | double(22,6) | Low labor cost, rolled up from assigned activities | ||
high_work_cost | double(22,6) | High labor cost, rolled up from assigned activities | ||
low_equip_cost | double(22,6) | Low non-labor cost, rolled up from assigned activities | ||
high_equip_cost | double(22,6) | High non-labor cost, rolled up from assigned activities | ||
low_expense_cost | double(22,6) | Low expense cost, rolled up from assigned activities | ||
high_expense_cost | double(22,6) | High expense cost, rolled up from assigned activities | ||
def_cost_per_qty | double(22,8) | Default price/time to compute costs when activities have no resources (but do have units) | ||
task_code_prefix | string(20) | Prefix for auto-increment of task code | ||
guid | string(22) | Global unique ID | ||
def_qty_type | string(24) | Time units for methodology's default price/time (year/month/week/day/hour) | ||
add_by_name | string(32) | Name of user who created the methodology | ||
low_mat_cost | double(22,6) | Low material cost | ||
high_mat_cost | double(22,6) | High material cost | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TEMPLATE | OR | SQL Server | ||
RT_TEMPLATE_DEL | OR | SQL Server | ||
RT_TEMPLATE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_template | PRIMARY | template_id | |||||
ck_template_checkout_flag | CHECK | checkout_flag | checkout_flag in ('Y', 'N') |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | cost_item_id | integer | Unique ID | |
FK | taskuse_id | integer | FK to TASKUSE table - identifies the activity within the methodology | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
cost_load_type | string(12) | Type of cost accrual over the activity duration - Start/End/Uniform | ||
FK | cost_type_id | integer | FK to COSTTYPE table - identifies the expense category | |
FK | pobs_id | integer | FK to POBS table - identifies the performing organization | |
low_cost | double(22,6) | Low expense cost | ||
high_cost | double(22,6) | High expense cost | ||
vendor_name | string(100) | Vendor name | ||
cost_name | string(120) | Expense name | ||
qty_name | string(30) | Unit of measure for expense | ||
cost_descr | blob | Expense description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_tmplcost_1 | NONUNIQUE | template_id | |||||
ndx_tmplcost_costtype | NONUNIQUE | cost_type_id | |||||
ndx_tmplcost_taskuse | NONUNIQUE | taskuse_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TMPLCOST | OR | SQL Server | ||
RT_TMPLCOST_DEL | OR | SQL Server | ||
RT_TMPLCOST | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_tmplcost_costtype | FOREIGN | cost_type_id | COSTTYPE | cost_type_id | |||
fk_tmplcost_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_tmplcost_pobs | FOREIGN | pobs_id | POBS | pobs_id | INDEPENDENT | ||
fk_tmplcost_taskuse | FOREIGN | taskuse_id | TASKUSE | taskuse_id | |||
pk_tmplcost | PRIMARY | cost_item_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | risk_id | integer | Unique ID | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
FK | wbs_id | integer | FK to TMPLWBS table - identifies the WBS | |
priority_type | string(12) | Risk priority | ||
risk_name | string(100) | Risk name | ||
FK | risk_type_id | integer | FK to RISKTYPE table - identifies the risk type | |
prbly_pct | integer | Risk probability of occurrence | ||
impact_work_qty | double(22,6) | Impact labor units if risk occurs | ||
impact_equip_qty | double(22,6) | Impact non-labor units if risk occurs | ||
impact_expense_cost | double(22,6) | Impact expense cost if risk occurs | ||
risk_descr | blob | Risk description | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_tmplrisk_1 | NONUNIQUE | template_id | |||||
ndx_tmplrisk_risktype | NONUNIQUE | risk_type_id | |||||
ndx_tmplrisk_tmplwbs | NONUNIQUE | wbs_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TMPLRISK | OR | SQL Server | ||
RT_TMPLRISK_DEL | OR | SQL Server | ||
RT_TMPLRISK | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_tmplrisk_risktype | FOREIGN | risk_type_id | RISKTYPE | risk_type_id | |||
fk_tmplrisk_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_tmplrisk_tmplwbs | FOREIGN | wbs_id | TMPLWBS | wbs_id | |||
pk_tmplrisk | PRIMARY | risk_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_riskctrl_tmplrisk | FOREIGN | RISKCTRL | risk_id | risk_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
PK,FK | session_id | integer | Unique ID | |
access_level | integer | Access level; 1 = Shared; 2 = Exclusive |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_tmplshar_usession | NONUNIQUE | session_id |
Triggers |
---|
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_tmplshar_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_tmplshar_usession | FOREIGN | session_id | USESSION | session_id | |||
pk_tmplshar | PRIMARY | template_id,session_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
PK,FK | tmpl_catg_type_id | integer | FK to TCATTYPE table - identifies the methodology category type | |
FK | tmpl_catg_id | integer | FK to TCATVAL table - identifies the methodology category value | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_tmpltcat_tcattype | NONUNIQUE | tmpl_catg_type_id | |||||
ndx_tmpltcat_tcatval | NONUNIQUE | tmpl_catg_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TMPLTCAT | OR | SQL Server | ||
RT_TMPLTCAT_DEL | OR | SQL Server | ||
RT_TMPLTCAT | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_tmpltcat_tcattype | FOREIGN | tmpl_catg_type_id | TCATTYPE | tmpl_catg_type_id | |||
fk_tmpltcat_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_tmpltcat_tcatval | FOREIGN | tmpl_catg_id | TCATVAL | tmpl_catg_id | |||
pk_tmpltcat | PRIMARY | template_id,tmpl_catg_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | wbs_id | integer | FK to TMPLWBS table - identifies the WBS | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
seq_num | integer | Sequence number for sorting | ||
est_wt | double(22,2) | Estimation weight, for top-down estimation | ||
wbs_short_name | string(40) | WBS code | ||
wbs_name | string(100) | WBS name | ||
FK | phase_id | integer | FK to PHASE table - identifies WBS category value | |
FK | obs_id | integer | FK to OBS table - identifies the responsible OBS | |
parent_wbs_id | integer | FK to TMPLWBS table - identifies parent in WBS hierarchy | ||
FK | fact_catg_id | integer | FK to FACTCATG table - identifies the factor category. Size and complexity category | |
guid | string(22) | Global unique ID | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_tmplwbs_1 | NONUNIQUE | template_id | |||||
ndx_tmplwbs_factcatg | NONUNIQUE | fact_catg_id | |||||
ndx_tmplwbs_obs | NONUNIQUE | obs_id | |||||
ndx_tmplwbs_phase | NONUNIQUE | phase_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_TMPLWBS | OR | SQL Server | ||
RT_TMPLWBS_DEL | OR | SQL Server | ||
RT_TMPLWBS | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_tmplwbs_factcatg | FOREIGN | fact_catg_id | FACTCATG | fact_catg_id | |||
fk_tmplwbs_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_tmplwbs_phase | FOREIGN | phase_id | PHASE | phase_id | |||
fk_tmplwbs_obs | FOREIGN | obs_id | OBS | obs_id | |||
pk_tmplwbs | PRIMARY | wbs_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | udf_code_id | integer | Unique identifier | |
FK | udf_type_id | integer | FK to UDFTYPE | |
seq_num | integer | Order of values | ||
short_name | string(60) | Code Value | ||
udf_code_name | string(120) | Description of code | ||
parent_udf_code_id | integer | Parent for Hierarchical codes | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_udfcode_udf_type_id | NONUNIQUE | udf_type_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_UDFCODE | OR | SQL Server | ||
RT_UDFCODE_DEL | OR | SQL Server | ||
RT_UDFCODE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_udfcode | PRIMARY | udf_code_id | |||||
fk_udfcode_udftype | FOREIGN | udf_type_id | UDFTYPE | udf_type_id | DEPENDENT |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_udfvalue_udfcode | FOREIGN | UDFVALUE | udf_code_id | udf_code_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | udf_type_id | integer | Unique identifier | |
table_name | string(30) | Name of database table where column resides | ||
udf_type_name | string(32) | User defined field name | ||
udf_type_label | string(40) | Label for column | ||
logical_data_type | string(20) | Logical data type for column | ||
super_flag | string(1) | Super Code Flag | 'N' | |
udf_code_short_len | integer | Max Length of Code Values | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_UDFTYPE | OR | SQL Server | ||
RT_UDFTYPE_DEL | OR | SQL Server | ||
RT_UDFTYPE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_udftype | PRIMARY | udf_type_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_udfcode_udftype | FOREIGN | UDFCODE | udf_type_id | udf_type_id |
fk_udfvalue_udftype | FOREIGN | UDFVALUE | udf_type_id | udf_type_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | udf_type_id | integer | FK to UDFTYPE Table | |
PK | fk_id | integer | Generic foreign key to appropriate table. No constrained | |
FK | template_id | integer | FK to TEMPLATE table (if appropriate) for performance | |
udf_date | date | Date value | ||
udf_text | string(255) | String value | ||
udf_number | number | Generic numeric value | ||
FK | udf_code_id | integer | FK to UDFCODE (if a Code Type) | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_udfvalue_template | NONUNIQUE | template_id | |||||
ndx_udfvalue_udfcode | NONUNIQUE | udf_code_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_UDFVALUE | OR | SQL Server | ||
RT_UDFVALUE_DEL | OR | SQL Server | ||
RT_UDFVALUE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_udfvalue | PRIMARY | udf_type_id,fk_id | |||||
fk_udfvalue_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_udfvalue_udfcode | FOREIGN | udf_code_id | UDFCODE | udf_code_id | INDEPENDENT | ||
fk_udfvalue_udftype | FOREIGN | udf_type_id | UDFTYPE | udf_type_id | DEPENDENT |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | unit_id | integer | Unique ID | |
seq_num | integer | Sequence Number | ||
unit_name | string(100) | Unit Name | ||
unit_abbrev | string(16) | Unit abbreviation | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_UMEASURE | OR | SQL Server | ||
RT_UMEASURE_DEL | OR | SQL Server | ||
RT_UMEASURE | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_umeasure | PRIMARY | unit_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_rsrc_umeasure | FOREIGN | RSRC | unit_id | unit_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | user_col_id | integer | Unique identifier | |
table_name | string(16) | Name of database table where column resides | ||
logical_data_type | string(20) | Logical data type for column | ||
user_col_name | string(32) | Name of column | ||
user_col_label | string(40) | Label for column | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields |
Triggers | ||||
---|---|---|---|---|
PRMAUD_USERCOL | OR | SQL Server | ||
RT_USERCOL_DEL | OR | SQL Server | ||
RT_USERCOL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
pk_usercol | PRIMARY | user_col_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | user_data_id | integer | Unique ID | |
FK | user_id | integer | FK to USERS table - identifies the user | |
topic_name | string(20) | Topic for user data. Combination of user_id and topic_name unique. | ||
user_data | blob | User settings/preferences for this topic | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_userdata_1 | NONUNIQUE | user_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_USERDATA | OR | SQL Server | ||
RT_USERDATA_DEL | OR | SQL Server | ||
RT_USERDATA | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_userdata_users | FOREIGN | user_id | USERS | user_id | |||
pk_userdata | PRIMARY | user_data_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | user_eng_id | integer | Unique ID | |
FK | user_id | integer | FK to USERS table - identifies the user | |
named_user_flag | string(1) | Indicates whether this user is licensed for this engine on a named or concurrent user basis | 'Y' | |
db_engine_type | string(20) | Database engine type (concatenated with the application suite type): i.e., P3e_PM / TP_PM / TP_MM, etc. This is a static type. | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_usereng_users | NONUNIQUE | user_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_USERENG | OR | SQL Server | ||
RT_USERENG_DEL | OR | SQL Server | ||
RT_USERENG | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_usereng_users | FOREIGN | user_id | USERS | user_id | |||
pk_usereng | PRIMARY | user_eng_id | |||||
ck_usereng_named_user_flag | CHECK | named_user_flag | named_user_flag in ('Y', 'N') |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | user_id | integer | FK to USERS table - identifies the user | |
user_name | string(32) | Login name for user | ||
view_id | integer | Unique ID | ||
FK | prof_id | integer | FK to PROFILE table - identifies security profile for the user for this methodology | |
guid | string(22) | Global unique ID | ||
actual_name | string(80) | Personal name of user | ||
passwd | string(255) | Login password for user | ||
FK | curr_id | integer | FK to CURRTYPE table - identifies the user's view Currency | 1 |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_users_profile | NONUNIQUE | prof_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_USERS | OR | SQL Server | ||
RT_USERS_DEL | OR | SQL Server | ||
RT_USERS | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_users_currtype | FOREIGN | curr_id | CURRTYPE | curr_id | |||
fk_users_profile | FOREIGN | prof_id | PROFILE | prof_id | |||
pk_users | PRIMARY | user_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK,FK | user_id | integer | FK to USERS table - identifies the user | |
PK,FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
FK | prof_id | integer | FK to PROFILE table - identifies security profile for the user for this methodology | |
FK | view_id | integer | Unique ID | |
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_usertmpl_1 | NONUNIQUE | template_id | |||||
ndx_usertmpl_profile | NONUNIQUE | prof_id | |||||
ndx_usertmpl_viewprop | NONUNIQUE | view_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_USERTMPL | OR | SQL Server | ||
RT_USERTMPL_DEL | OR | SQL Server | ||
RT_USERTMPL | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_usertmpl_profile | FOREIGN | prof_id | PROFILE | prof_id | |||
fk_usertmpl_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_usertmpl_viewprop | FOREIGN | view_id | VIEWPROP | view_id | |||
fk_usertmpl_users | FOREIGN | user_id | USERS | user_id | |||
pk_usertmpl | PRIMARY | user_id,template_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | session_id | integer | Unique ID | |
login_time | date | The time the application logged in | ||
last_active_time | date | Last active time of the application | ||
host_name | string(50) | Computer host name | ||
FK | user_id | integer | FK to USERS table - identifies the user | |
process_num | integer | Process number for the application running on the host computer | ||
app_name | string(25) | The name of the application logged in | ||
hard_drive_code | string(40) | Computer hard drive identifier code | ||
db_engine_type | string(20) | Database engine type (concatenated with the application suite type): i.e., P3e_PM / TP_PM / TP_MM, etc. This is a static type. | ||
os_user_name | string(32) | Operating system login name for user | ||
vdb_instance_guid | string(22) | Tracks a VDB engine instance; when going multi-user, if an engine is destroyed, it can quickly free all these rows with one query | ||
spid | integer | RDBMS session id to match database session with primavera session | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_usession_users | NONUNIQUE | user_id |
Triggers | ||||
---|---|---|---|---|
RT_USESSION_DEL | OR | SQL Server | ||
RT_USESSION | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_usession_users | FOREIGN | user_id | USERS | user_id | |||
pk_usession | PRIMARY | session_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_tmplshar_usession | FOREIGN | TMPLSHAR | session_id | session_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | view_id | integer | Unique ID | |
view_name | string(40) | View name | ||
FK | user_id | integer | FK to USERS table - identifies the user | |
view_type | string(20) | Type of view | ||
view_data | blob | View settings stored as text string | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_viewprop_1 | NONUNIQUE | user_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_VIEWPROP | OR | SQL Server | ||
RT_VIEWPROP_DEL | OR | SQL Server | ||
RT_VIEWPROP | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_viewprop_users | FOREIGN | user_id | USERS | user_id | |||
pk_viewprop | PRIMARY | view_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
fk_usertmpl_viewprop | FOREIGN | USERTMPL | view_id | view_id |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | wbs_memo_id | integer | Unique ID | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
FK | wbs_id | integer | FK to TMPLWBS table - identifies the WBS | |
FK | memo_type_id | integer | FK to MEMOTYPE table - identifies the notebook topic | |
wbs_memo | blob | Notebook contents stored as text string | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_wbsmemo_1 | NONUNIQUE | template_id | |||||
ndx_wbsmemo_memotype | NONUNIQUE | memo_type_id | |||||
ndx_wbsmemo_tmplwbs | NONUNIQUE | wbs_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_WBSMEMO | OR | SQL Server | ||
RT_WBSMEMO_DEL | OR | SQL Server | ||
RT_WBSMEMO | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_wbsmemo_memotype | FOREIGN | memo_type_id | MEMOTYPE | memo_type_id | |||
fk_wbsmemo_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_wbsmemo_tmplwbs | FOREIGN | wbs_id | TMPLWBS | wbs_id | |||
pk_wbsmemo | PRIMARY | wbs_memo_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |
Columns | ||||
---|---|---|---|---|
Key | Name | Type | Description | Default |
PK | wbs_step_id | integer | Unique ID | |
FK | template_id | integer | FK to TEMPLATE table - identifies the methodology | |
FK | wbs_id | integer | FK to TMPLWBS table - identifies the WBS | |
seq_num | integer | Sequence number for sorting | ||
step_name | string(120) | Descriptive name of WBS milestone WBS Milestone | ||
step_wt | double(22,2) | Relative weight or contribution of step weight | ||
update_date | date | Refresh audit field of last date updated. Trigger maintained. | ||
update_user | string(255) | Refresh audit field of last user updated. Trigger maintained. | ||
create_date | date | Refresh audit field for date record created. Trigger maintained. | ||
create_user | string(255) | Refresh audit field for user that created the record. Trigger maintained. | ||
delete_session_id | integer | Deleted by session id. Client maintained. | ||
delete_date | date | Deleted date. Client maintained. |
Indexes | |||||||
---|---|---|---|---|---|---|---|
Name | Unique | Fields | |||||
ndx_wbsstep_1 | NONUNIQUE | template_id | |||||
ndx_wbsstep_tmplwbs | NONUNIQUE | wbs_id |
Triggers | ||||
---|---|---|---|---|
PRMAUD_WBSSTEP | OR | SQL Server | ||
RT_WBSSTEP_DEL | OR | SQL Server | ||
RT_WBSSTEP | OR | SQL Server |
Constraints | |||||||
---|---|---|---|---|---|---|---|
Name | Type | Fields | Target | Fields | Delete rule | Refer Type | Condition |
fk_wbsstep_template | FOREIGN | template_id | TEMPLATE | template_id | |||
fk_wbsstep_tmplwbs | FOREIGN | wbs_id | TMPLWBS | wbs_id | |||
pk_wbsstep | PRIMARY | wbs_step_id |
References | ||||
---|---|---|---|---|
Name | Type | Table | Fields | Target Fields |