Tables
ACTVCODEActivity code values
ACTVTYPEActivity codes
ADMIN_CONFIGConfigurations for Administrator app
COSTTYPEExpense categories
CURRTYPECurrency information
DOCCATGCategories for documents
DOCUMENT
FACTCATGSize and complexity categories
FACTORSize and complexity factors for bottom-up and function point estimation
FACTVALSize and complexity factor values
FILTPROPFilter properties
LINKWBSLinks between plugin WBS and base WBS
MEMOTYPEActivity specification types
NEXTKEYNext key values for creating all the unique IDs
OBSOBS for a methodology
PHASEWBS categories
POBSPerforming Organization Breakdown Structure
PREFERAdmin preferences
PRMAUDITPrimavera Database Audting
PROCGROUPStep Group
PROCITEMStep Group Item
PROFILEUser security profiles
PROFPRIVSecurity privileges assigned to user profiles
PUBUSERPrivileged (private) database login usernames and passwords
QUALITYActivity attributes
QUERYLIBCBO Query Library
RCATTYPEResource category types
RCATVALResource category values
REFRDELAudit of deleted records for use by refresh processes.
RISKCTRLRisk control text fields
RISKTYPERisk types
ROLESRoles
RPTReport definitions
RPTGROUPReport groups
RSRCResources
RSRCRCATResource categories assigned to resources
RSRCROLERoles assigned to resources
SETTINGSSystem and user Settings
SPIDMAPUsed by auditing to maintain spid to user information
TASKCore activities
TASKACTVActivity codes assigned to activities
TASKDOCWork products and documents assigned to activities
TASKMEMOActivity specifications
TASKPREDActivity dependencies
TASKPROCActivity steps
TASKQUALAttributes assigned to activities
TASKRSRCResources assigned to activities
TASKUSEActivities assigned to methodologies
TCATTYPEMethodology category types
TCATVALMethodology category values
TEMPLATEMethodologies
TMPLCOSTExpenses for a methodology
TMPLRISKMethodology risks
TMPLSHARIdentifies which methodologies are currently locked in shared/exclusive mode by user sessions
TMPLTCATMethodology categories assigned to methodologies
TMPLWBSWBS for a methodology
UDFCODECode values for enumerated UDF
UDFTYPEDefinitions/labels for all user-defined columns
UDFVALUEValues for all user-defined columns
UMEASURE
USERCOLDefinitions/labels for all user-defined columns
USERDATASettings/preferences for users, by topic
USERENGMaps users to database engine types for license enforcement
USERSApplication users
USERTMPLUsers assigned to methodologies with security profiles
USESSIONUser sessions to support methodology-level locking and licensing
VIEWPROPTask grid views
WBSMEMOMethodology / WBS notebook
WBSSTEPWBS Milestones
[Top]
ACTVCODE
Columns
KeyNameTypeDescriptionDefault
PKactv_code_idintegerFK to ACTVCODE table - identifies the activity code value
FKactv_code_type_idintegerFK to ACTVTYPE table - identifies the activity code type
seq_numintegerSequence number for sorting
short_namestring(60)Activity code value
parent_actv_code_idintegerFK to ACTVCODE table - identifies parent in activity code hierarchy
actv_code_namestring(120)Activity code description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_actvcode_actvtypeNONUNIQUEactv_code_type_id
Triggers
PRMAUD_ACTVCODEORSQL Server
RT_ACTVCODE_DELORSQL Server
RT_ACTVCODEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_actvcode_actvtypeFOREIGNactv_code_type_idACTVTYPEactv_code_type_id
pk_actvcodePRIMARYactv_code_id
References
NameTypeTableFieldsTarget Fields
fk_taskactv_actvcodeFOREIGNTASKACTVactv_code_idactv_code_id
[Top]
ACTVTYPE
Columns
KeyNameTypeDescriptionDefault
PKactv_code_type_idintegerFK to ACTVTYPE table - identifies the activity code type
seq_numintegerSequence number for sorting
actv_short_lenintegerMax length of activity code value
actv_code_typestring(40)Activity code name
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_ACTVTYPEORSQL Server
RT_ACTVTYPE_DELORSQL Server
RT_ACTVTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_actvtypePRIMARYactv_code_type_id
References
NameTypeTableFieldsTarget Fields
fk_actvcode_actvtypeFOREIGNACTVCODEactv_code_type_idactv_code_type_id
fk_taskactv_actvtypeFOREIGNTASKACTVactv_code_type_idactv_code_type_id
[Top]
ADMIN_CONFIG
Columns
KeyNameTypeDescriptionDefault
PKconfig_namestring(255)Name of the configuration file the BRE is using
config_typestring(10)would either contain PS or BRE for Presentation config. file **OR** BRE config file, respectively
factory_versionstring(10)Primavera default settings version number. Referred to as the 'Factory Defaults' in the XML config file.
last_change_datedateTimestamp of last change datesysdate
config_valuestring(255)String value for config entry.
config_datablobStorage for the xml config file
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_ADMIN_CONFIGORSQL Server
RT_ADMIN_CONFIG_DELORSQL Server
RT_ADMIN_CONFIGORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_admin_configPRIMARYconfig_name
References
NameTypeTableFieldsTarget Fields
[Top]
COSTTYPE
Columns
KeyNameTypeDescriptionDefault
PKcost_type_idintegerFK to COSTTYPE table - identifies the expense category
seq_numintegerSequence number for sorting
cost_typestring(36)Expense category
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_COSTTYPEORSQL Server
RT_COSTTYPE_DELORSQL Server
RT_COSTTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_costtypePRIMARYcost_type_id
References
NameTypeTableFieldsTarget Fields
fk_tmplcost_costtypeFOREIGNTMPLCOSTcost_type_idcost_type_id
[Top]
CURRTYPE
Columns
KeyNameTypeDescriptionDefault
PKcurr_idintegerFK to CURRTYPE table - identifies the user's view Currency
decimal_digit_cntintegerNumber of digits after decimal
curr_symbolstring(6)Currency symbol
decimal_symbolstring(6)Decimal symbol
digit_group_symbolstring(6)Digit grouping symbol
pos_curr_fmt_typestring(20)Positive currency format
neg_curr_fmt_typestring(20)Negative currency format
curr_typestring(40)Currency - values: US Dollars, Canadian Dollars, etc.
curr_short_namestring(6)Currency ID - Unique currency abbreviation for each currency. (e.g. USD)
group_digit_cntintegerCount of digits in group
base_exch_ratedouble(22,6)Exchange rate of this currency to the base currency
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_curr_short_nameUNIQUEcurr_short_name
Triggers
PRMAUD_CURRTYPEORSQL Server
RT_CURRTYPE_DELORSQL Server
RT_CURRTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_currtypePRIMARYcurr_id
References
NameTypeTableFieldsTarget Fields
fk_prefer_currtypeFOREIGNPREFERcurr_idcurr_id
fk_rsrc_currtypeFOREIGNRSRCcurr_idcurr_id
fk_users_currtypeFOREIGNUSERScurr_idcurr_id
[Top]
DOCCATG
Columns
KeyNameTypeDescriptionDefault
PKdoc_catg_idintegerFK to DOCCATG table - identifies the document category
seq_numintegerSequence number for sorting
doc_catg_namestring(100)Document category name
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_DOCCATGORSQL Server
RT_DOCCATG_DELORSQL Server
RT_DOCCATGORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_doccatgPRIMARYdoc_catg_id
References
NameTypeTableFieldsTarget Fields
fk_document_doccatgFOREIGNDOCUMENTdoc_catg_iddoc_catg_id
[Top]
DOCUMENT
Columns
KeyNameTypeDescriptionDefault
PKdoc_idintegerFK to DOCUMENT table - identifies the document
doc_seq_numinteger
doc_namestring(120)
parent_doc_idinteger
FKdoc_catg_idintegerFK to DOCCATG table - identifies the document category
doc_datedateDocument revision date
version_namestring(20)Document version'1.0'
guidstring(22)Global unique ID
doc_short_namestring(32)Document reference number
author_namestring(100)Document author
private_locstring(255)Private location of document file on file/web server
public_locstring(255)Public location of document file on file/web server
doc_contentblobDocument description/content stored as text string
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_document_doccatgNONUNIQUEdoc_catg_id
Triggers
PRMAUD_DOCUMENTORSQL Server
RT_DOCUMENT_DELORSQL Server
RT_DOCUMENTORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_document_doccatgFOREIGNdoc_catg_idDOCCATGdoc_catg_id
pk_documentPRIMARYdoc_id
References
NameTypeTableFieldsTarget Fields
fk_taskdoc_documentFOREIGNTASKDOCdoc_iddoc_id
[Top]
FACTCATG
Columns
KeyNameTypeDescriptionDefault
PKfact_catg_idintegerFK to FACTCATG table - identifies the factor category. Size and complexity category
seq_numintegerSequence number for sorting
fact_catg_namestring(100)Factor category name
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_FACTCATGORSQL Server
RT_FACTCATG_DELORSQL Server
RT_FACTCATGORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_factcatgPRIMARYfact_catg_id
References
NameTypeTableFieldsTarget Fields
fk_factor_factcatgFOREIGNFACTORfact_catg_idfact_catg_id
fk_tmplwbs_factcatgFOREIGNTMPLWBSfact_catg_idfact_catg_id
[Top]
FACTOR
Columns
KeyNameTypeDescriptionDefault
PKfact_idintegerFK to FACTOR table - identifies the factor
fact_seq_numintegerSequence number for sorting within the factor category
fact_typestring(20)Factor type - Function Point or Bottom-up Complexity
fact_namestring(100)Factor name
def_fact_val_idintegerFK to FACTVAL table - identifies the default factor value
FKfact_catg_idintegerFK to FACTCATG table - identifies the factor category. Size and complexity category
fact_descrblobFactor description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_factor_factcatgNONUNIQUEfact_catg_id
Triggers
PRMAUD_FACTORORSQL Server
RT_FACTOR_DELORSQL Server
RT_FACTORORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_factor_factcatgFOREIGNfact_catg_idFACTCATGfact_catg_id
pk_factorPRIMARYfact_id
References
NameTypeTableFieldsTarget Fields
fk_factval_factorFOREIGNFACTVALfact_idfact_id
[Top]
FACTVAL
Columns
KeyNameTypeDescriptionDefault
PKfact_val_idintegerUnique ID
FKfact_idintegerFK to FACTOR table - identifies the factor
fact_valuestring(24)Factor value
fact_value_descrstring(255)Factor value description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_factval_factorNONUNIQUEfact_id
Triggers
PRMAUD_FACTVALORSQL Server
RT_FACTVAL_DELORSQL Server
RT_FACTVALORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_factval_factorFOREIGNfact_idFACTORfact_id
pk_factvalPRIMARYfact_val_id
References
NameTypeTableFieldsTarget Fields
[Top]
FILTPROP
Columns
KeyNameTypeDescriptionDefault
PKfilter_idintegerUnique ID
table_namestring(16)Name of database table where column resides
filter_typestring(20)Type of filter
filter_namestring(40)Filter name
FKuser_idintegerFK to USERS table - identifies the user
filter_datablobFilter settings stored as text string
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_filtprop_1NONUNIQUEuser_id
Triggers
PRMAUD_FILTPROPORSQL Server
RT_FILTPROP_DELORSQL Server
RT_FILTPROPORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_filtprop_usersFOREIGNuser_idUSERSuser_id
pk_filtpropPRIMARYfilter_id
References
NameTypeTableFieldsTarget Fields
[Top]
LINKWBS
Columns
KeyNameTypeDescriptionDefault
PKlinkwbs_idintegerUnique ID
FKbase_wbs_idintegerFK to TMPLWBS table - base WBS plugin WBS/activity is linked to
base_template_idintegerFK to TEMPLATE table - identifies the base template
plugin_template_idintegerFK to TEMPLATE table - identifies the plugin template
FKplugin_wbs_idintegerFK to TMPLWBS table - plugin WBS which is linked to the base WBS
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_linkwbs_1NONUNIQUEbase_template_id
ndx_linkwbs_2NONUNIQUEplugin_template_id
ndx_linkwbs_tmplwbs_1NONUNIQUEbase_wbs_id
ndx_linkwbs_tmplwbs_2NONUNIQUEplugin_wbs_id
Triggers
PRMAUD_LINKWBSORSQL Server
RT_LINKWBS_DELORSQL Server
RT_LINKWBSORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_linkwbs_tmplwbs_1FOREIGNbase_wbs_idTMPLWBSwbs_id
fk_linkwbs_tmplwbs_2FOREIGNplugin_wbs_idTMPLWBSwbs_id
pk_linkwbsPRIMARYlinkwbs_id
References
NameTypeTableFieldsTarget Fields
[Top]
MEMOTYPE
Columns
KeyNameTypeDescriptionDefault
PKmemo_type_idintegerFK to MEMOTYPE table - identifies the notebook topic
seq_numintegerSequence number for sorting
tmpl_flagstring(1)Indicates whether specification topic available for templates'N'
wbs_flagstring(1)Indicates whether specification topic available for WBS'N'
task_flagstring(1)Indicates whether notebook topic available for activities'N'
memo_typestring(40)Activity specification
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_MEMOTYPEORSQL Server
RT_MEMOTYPE_DELORSQL Server
RT_MEMOTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_memotypePRIMARYmemo_type_id
ck_memotype_task_flagCHECKtask_flagtask_flag in ('Y', 'N')
ck_memotype_tmpl_flagCHECKtmpl_flagtmpl_flag in ('Y', 'N')
ck_memotype_wbs_flagCHECKwbs_flagwbs_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
fk_taskmemo_memotypeFOREIGNTASKMEMOmemo_type_idmemo_type_id
fk_wbsmemo_memotypeFOREIGNWBSMEMOmemo_type_idmemo_type_id
[Top]
NEXTKEY
Columns
KeyNameTypeDescriptionDefault
PKkey_namestring(30)Name of key (unique ID)
key_seq_numintegerCurrent value of key (unique ID)
Indexes
NameUniqueFields
Triggers
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_nextkeyPRIMARYkey_name
References
NameTypeTableFieldsTarget Fields
[Top]
OBS
Columns
KeyNameTypeDescriptionDefault
PKobs_idintegerFK to OBS table - identifies the responsible OBS
seq_numintegerSequence number for sorting
obs_namestring(100)OBS name
parent_obs_idintegerFK to OBS table - identifies parent in OBS hierarchy
obs_descrblobOBS description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_OBSORSQL Server
RT_OBS_DELORSQL Server
RT_OBSORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_obsPRIMARYobs_id
References
NameTypeTableFieldsTarget Fields
fk_tmplwbs_obsFOREIGNTMPLWBSobs_idobs_id
[Top]
PHASE
Columns
KeyNameTypeDescriptionDefault
PKphase_idintegerFK to PHASE table - identifies WBS category value
seq_numintegerSequence number for sorting
phase_namestring(100)WBS category name
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_PHASEORSQL Server
RT_PHASE_DELORSQL Server
RT_PHASEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_phasePRIMARYphase_id
References
NameTypeTableFieldsTarget Fields
fk_tmplwbs_phaseFOREIGNTMPLWBSphase_idphase_id
[Top]
POBS
Columns
KeyNameTypeDescriptionDefault
PKpobs_idintegerPrimary key for table
seq_numintegerSequence number for sorting
pobs_namestring(255)POBS name
pobs_parent_idintegerPOBS parent for current record
pobs_descrstring(255)POBS description
pobs_managerstring(255)POBS manager
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_pobs_parent_idNONUNIQUEpobs_parent_id
Triggers
PRMAUD_POBSORSQL Server
RT_POBS_DELORSQL Server
RT_POBSORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_pobsPRIMARYpobs_id
References
NameTypeTableFieldsTarget Fields
fk_roles_pobsFOREIGNROLESpobs_idpobs_id
fk_rsrc_pobsFOREIGNRSRCpobs_idpobs_id
fk_taskrsrc_pobsFOREIGNTASKRSRCpobs_idpobs_id
fk_tmplcost_pobsFOREIGNTMPLCOSTpobs_idpobs_id
[Top]
PREFER
Columns
KeyNameTypeDescriptionDefault
PKprefer_idintegerUnique ID
max_wbs_level_cntintegerMaximum count of levels in WBS hierarchy
max_rsrc_level_cntintegerMaximum count of levels in resource hierarchy
max_obs_level_cntintegerMaximum count of levels in OBS hierarchy
wbs_short_lenintegerMaximum length of WBS code
rsrc_short_lenintegerMaximum length of resource code
task_code_lenintegerMaximum length of activity code
role_short_lenintegerMaximum length of role code
max_actv_level_cntintegerMaximum count of levels in activity code hierarchy
max_tcat_level_cntintegerMaximum count of levels in methodology category hierarchy
max_rcat_level_cntintegerMaximum count of levels in resource category hierarchy
max_role_level_cntintegerMaximum number of levels allowed in the role tree
day_hr_cntdouble(22,2)Count of hours per day for converting displayed time/duration units
week_hr_cntdouble(22,2)Count of hours per week for converting displayed time/duration units
year_hr_cntdouble(22,2)Count of hours per month for converting displayed time/duration units
month_hr_cntdouble(22,2)Count of hours per month for converting displayed time/duration units
name_sep_charstring(2)Character for separating concatenated code fields for WBS and Resource
year_charstring(4)Display character for years in time/duration fields
month_charstring(4)Display character for months in time/duration fields
week_charstring(4)Display character for weeks in time/duration fields
day_charstring(4)Display character for days in time/duration fields
hour_charstring(4)Display character for minutes in time/duration fields
minute_charstring(4)Display character for minutes in time/duration fields
def_complete_pct_typestring(10)Default complete % type for new activities - Units/Duration/Physical'CP_Drtn'
default_duration_typestring(20)Default duration type for new activities
database_versionstring(30)Version identifier string for database schema
db_namestring(20)Customer chosen identifier for database instance, e.g. ENGINEERING
phase_labelstring(40)Label for global WBS category
rpt_header_1string(255)Report header string for report authoring - choice 1
rpt_header_2string(255)Report header string for report authoring - choice 2
rpt_header_3string(255)Report header string for report authoring - choice 3
rpt_footer_1string(255)Report footer string for report authoring - choice 1
rpt_footer_2string(255)Report footer string for report authoring - choice 2
rpt_footer_3string(255)Report footer string for report authoring - choice 3
rpt_user_1string(255)Provides additional user information for report authoring - beyond header and footer
rpt_user_2string(255)Provides additional user information for report authoring - beyond header and footer
rpt_user_3string(255)Provides additional user information for report authoring - beyond header and footer
FKcurr_idintegerFK to CURRTYPE table - identifies the user's view Currency1
def_task_typestring(12)Default task types'TT_Task'
license_datablobLicense string, encrypted
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_PREFERORSQL Server
RT_PREFER_DELORSQL Server
RT_PREFERORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_prefer_currtypeFOREIGNcurr_idCURRTYPEcurr_id
pk_preferPRIMARYprefer_id
References
NameTypeTableFieldsTarget Fields
[Top]
PRMAUDIT
Columns
KeyNameTypeDescriptionDefault
audit_datedateTimestamp for this audit record
table_namestring(30)Table name of data being audited
pk1string(255)Value of the first primary key for this table audit
pk2string(255)Value of the second primary key for this table audit
pk3string(255)Value of the third primary key for this table audit
pk4string(255)Value of the forth primary key for this table audit
operstring(1)Operation I=insert, U=update, D=delete
prm_user_namestring(32)Primavera username making the transaction
audit_infostring(4000)Column audit that is under 4k
audit_info_extendedblobExtended audit information and blob auditing information
logical_delete_flagstring(1)Flag is Y if this record is a result of a logical delete
rdbms_user_namestring(255)Database user making the transaction (if available)
os_user_namestring(255)Operating system username making the transaction (if available)
programstring(255)Name of program executing the transaction (if available)
host_namestring(255)Host Name of program executing the transaction (if available)
app_namestring(25)Primavera Application Name of executing the transaction (if available)
netaddressstring(24)Net Address of executing the transaction (if available)
Indexes
NameUniqueFields
Triggers
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
References
NameTypeTableFieldsTarget Fields
[Top]
PROCGROUP
Columns
KeyNameTypeDescriptionDefault
PKproc_group_idintegerPrimary Key
seq_numintegerSequence number for sorting
proc_group_namestring(120)Step Group Name
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_PROCGROUPORSQL Server
RT_PROCGROUP_DELORSQL Server
RT_PROCGROUPORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_procgroupPRIMARYproc_group_id
References
NameTypeTableFieldsTarget Fields
fk_procitem_procgroupFOREIGNPROCITEMproc_group_idproc_group_id
[Top]
PROCITEM
Columns
KeyNameTypeDescriptionDefault
PKproc_item_idintegerPrimary Key
FKproc_group_idintegerFK to PROCGROUP
seq_numintegerSequence number for sorting
proc_namestring(120)Step Item Name
proc_wtdouble(22,2)Step Weight
proc_descrblobStep Description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_procitemNONUNIQUEproc_group_id
Triggers
PRMAUD_PROCITEMORSQL Server
RT_PROCITEM_DELORSQL Server
RT_PROCITEMORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_procitemPRIMARYproc_item_id
fk_procitem_procgroupFOREIGNproc_group_idPROCGROUPproc_group_idDEPENDENT
References
NameTypeTableFieldsTarget Fields
[Top]
PROFILE
Columns
KeyNameTypeDescriptionDefault
PKprof_idintegerFK to PROFILE table - identifies security profile for the user for this methodology
default_flagstring(1)Identifies the default profile for new users'N'
superuser_flagstring(1)Identifies the super user profile - can do anything, no individual privileges linked'N'
scope_typestring(12)Scope of profile - global or project
prof_namestring(100)Profile name
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_PROFILEORSQL Server
RT_PROFILE_DELORSQL Server
RT_PROFILEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_profilePRIMARYprof_id
ck_profile_default_flagCHECKdefault_flagdefault_flag in ('Y', 'N')
ck_profile_superuser_flagCHECKsuperuser_flagsuperuser_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
fk_profpriv_profileFOREIGNPROFPRIVprof_idprof_id
fk_users_profileFOREIGNUSERSprof_idprof_id
fk_usertmpl_profileFOREIGNUSERTMPLprof_idprof_id
[Top]
PROFPRIV
Columns
KeyNameTypeDescriptionDefault
PK,FKprof_idintegerFK to PROFILE table - identifies security profile for the user for this methodology
PKpriv_numintegerPrivilege number - identifies the privilege. Privilege names are compiled into the code.
allow_flagstring(1)Identifies which privileges are allowed for this profile'N'
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_PROFPRIVORSQL Server
RT_PROFPRIV_DELORSQL Server
RT_PROFPRIVORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_profpriv_profileFOREIGNprof_idPROFILEprof_id
pk_profprivPRIMARYprof_id,priv_num
ck_profpriv_allow_flagCHECKallow_flagallow_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
[Top]
PUBUSER
Columns
KeyNameTypeDescriptionDefault
PKpublic_group_idintegerUnique ID for private user and the public group which uses it (matches INI file)
private_db_user_namestring(40)Database username used to connect with update privileges
private_db_passwdstring(255)Encoded database password used to connect with update privileges
Indexes
NameUniqueFields
Triggers
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_pubuserPRIMARYpublic_group_id
References
NameTypeTableFieldsTarget Fields
[Top]
QUALITY
Columns
KeyNameTypeDescriptionDefault
PKqual_idintegerFK to QUALITY table - identifies the attribute for filtering in Project Architect
qual_seq_numintegerSequence number for sorting
req_flagstring(1)Identifies locked attributes - cannot be filtered out in Project Architect'N'
qual_namestring(100)Attribute name
qual_descrblobAttribute description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_QUALITYORSQL Server
RT_QUALITY_DELORSQL Server
RT_QUALITYORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_qualityPRIMARYqual_id
ck_quality_req_flagCHECKreq_flagreq_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
fk_taskqual_qualityFOREIGNTASKQUALqual_idqual_id
[Top]
QUERYLIB
Columns
KeyNameTypeDescriptionDefault
PKquery_lib_idintegerPK for QUERYLIB table
app_namestring(25)Application Name
core_flagstring(1)Flag for Primavera query or customer query
match_sqlstring(4000)Tokenized sql for matching
hintsstring(4000)Oracle Hints
replacement_sqlstring(4000)Replaced Sql
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_QUERYLIBORSQL Server
RT_QUERYLIB_DELORSQL Server
RT_QUERYLIBORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_querylibPRIMARYquery_lib_id
References
NameTypeTableFieldsTarget Fields
[Top]
RCATTYPE
Columns
KeyNameTypeDescriptionDefault
PKrsrc_catg_type_idintegerFK to RCATTYPE table - identifies the resource category type
seq_numintegerSequence number for sorting
rsrc_catg_short_lenintegerMax length of resource category value
rsrc_catg_typestring(40)Resource category type
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_RCATTYPEORSQL Server
RT_RCATTYPE_DELORSQL Server
RT_RCATTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_rcattypePRIMARYrsrc_catg_type_id
References
NameTypeTableFieldsTarget Fields
fk_rcatval_rcattypeFOREIGNRCATVALrsrc_catg_type_idrsrc_catg_type_id
fk_rsrcrcat_rcattypeFOREIGNRSRCRCATrsrc_catg_type_idrsrc_catg_type_id
[Top]
RCATVAL
Columns
KeyNameTypeDescriptionDefault
PKrsrc_catg_idintegerFK to RCATVAL table - identifies the resource category value
FKrsrc_catg_type_idintegerFK to RCATTYPE table - identifies the resource category type
seq_numintegerSequence number for sorting
rsrc_catg_short_namestring(32)Resource category value
parent_rsrc_catg_idintegerFK to RCATVAL table - identifies the parent resource category value
rsrc_catg_namestring(100)Resource category description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_rcatval_rcattypeNONUNIQUErsrc_catg_type_id
Triggers
PRMAUD_RCATVALORSQL Server
RT_RCATVAL_DELORSQL Server
RT_RCATVALORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_rcatval_rcattypeFOREIGNrsrc_catg_type_idRCATTYPErsrc_catg_type_id
pk_rcatvalPRIMARYrsrc_catg_id
References
NameTypeTableFieldsTarget Fields
fk_rsrcrcat_rcatvalFOREIGNRSRCRCATrsrc_catg_idrsrc_catg_id
[Top]
REFRDEL
Columns
KeyNameTypeDescriptionDefault
delete_datedateTimestamp for delete.sysdate
table_namestring(30)Name of table for delete operation.
pk1string(255)Generic PK value for table.
pk2string(255)Second PK value for composite keys.
pk3string(255)Third PK value for composite keys.
pk4string(255)Fourth PK value for composite keys.
template_idintegerProject ID
Indexes
NameUniqueFields
ndx_refrdel_delete_dateNONUNIQUEdelete_date
Triggers
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
References
NameTypeTableFieldsTarget Fields
[Top]
RISKCTRL
Columns
KeyNameTypeDescriptionDefault
PK,FKrisk_idintegerUnique ID
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
risk_controlblobRisk control text field
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_riskctrl_1NONUNIQUEtemplate_id
Triggers
PRMAUD_RISKCTRLORSQL Server
RT_RISKCTRL_DELORSQL Server
RT_RISKCTRLORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_riskctrl_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_riskctrl_tmplriskFOREIGNrisk_idTMPLRISKrisk_id
pk_riskctrlPRIMARYrisk_id
References
NameTypeTableFieldsTarget Fields
[Top]
RISKTYPE
Columns
KeyNameTypeDescriptionDefault
PKrisk_type_idintegerFK to RISKTYPE table - identifies the risk type
seq_numintegerSequence number for sorting
risk_typestring(40)Risk type
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_RISKTYPEORSQL Server
RT_RISKTYPE_DELORSQL Server
RT_RISKTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_risktypePRIMARYrisk_type_id
References
NameTypeTableFieldsTarget Fields
fk_tmplrisk_risktypeFOREIGNTMPLRISKrisk_type_idrisk_type_id
[Top]
ROLES
Columns
KeyNameTypeDescriptionDefault
PKrole_idintegerFK to ROLES table - identifies the role for this resource on this activity
role_short_namestring(40)Role code
role_namestring(100)Role name
seq_numintegerSequence number for sorting
parent_role_idintegerFK to ROLES table - identifies the parent in the role hierarchy
FKpobs_idintegerFK to POBS table - identifies the performing organization
role_descrblobRole description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_ROLESORSQL Server
RT_ROLES_DELORSQL Server
RT_ROLESORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_rolesPRIMARYrole_id
fk_roles_pobsFOREIGNpobs_idPOBSpobs_idINDEPENDENT
References
NameTypeTableFieldsTarget Fields
fk_rsrc_rolesFOREIGNRSRCrole_idrole_id
fk_rsrcrole_rolesFOREIGNRSRCROLErole_idrole_id
fk_taskrsrc_rolesFOREIGNTASKRSRCrole_idrole_id
[Top]
RPT
Columns
KeyNameTypeDescriptionDefault
PKrpt_idintegerUnique ID
rpt_typestring(12)Report type - user report or website report
rpt_namestring(80)Report name
FKrpt_group_idintegerUnique ID
rpt_statestring(10)State of the report
rpt_datablobReport settings stored as text field
last_run_datedateLast run execution date/time
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_rpt_rptgroupNONUNIQUErpt_group_id
Triggers
PRMAUD_RPTORSQL Server
RT_RPT_DELORSQL Server
RT_RPTORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_rpt_rptgroupFOREIGNrpt_group_idRPTGROUPrpt_group_id
pk_rptPRIMARYrpt_id
References
NameTypeTableFieldsTarget Fields
[Top]
RPTGROUP
Columns
KeyNameTypeDescriptionDefault
PKrpt_group_idintegerUnique ID
rpt_group_seq_numintegerSequence number for sorting
rpt_group_namestring(80)Report group name
parent_group_idintegerFK to RPTGROUP table - identifies parent in report-group hierarchy
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_RPTGROUPORSQL Server
RT_RPTGROUP_DELORSQL Server
RT_RPTGROUPORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_rptgroupPRIMARYrpt_group_id
References
NameTypeTableFieldsTarget Fields
fk_rpt_rptgroupFOREIGNRPTrpt_group_idrpt_group_id
[Top]
RSRC
Columns
KeyNameTypeDescriptionDefault
PKrsrc_idintegerFK to RSRC table - identifies the resource
rsrc_seq_numintegerSequence number for sorting
rsrc_typestring(10)Resource type Labor, Equipment, or Material'RT_Labor'
ot_flagstring(1)Identifies whether overtime is allowed'N'
rsrc_short_namestring(40)Resource code
rsrc_namestring(100)Resource name
parent_rsrc_idintegerFK to RSRC table - identifies parent in resource hierarchy
FKrole_idintegerFK to ROLES table - identifies the role for this resource on this activity
FKpobs_idintegerFK to POBS table - identifies the performing organization
max_qty_per_hrdouble(22,8)Maximum units per time (hours per hour)
ot_factordouble(22,3)Overtime factor, if overtime allowed (multiplier on the standard price/time)
def_qty_per_hrdouble(22,8)Default units per time (hours per hour)
cost_per_qtydouble(22,8)Price/time to compute costs
guidstring(22)Global unique ID
cost_qty_typestring(24)Time units for resource's price/time (year/month/week/day/hour)
office_phonestring(32)Office phone
employee_codestring(40)Employee code or employee number Employee ID
rsrc_title_namestring(100)Resource job title
email_addrstring(120)Email address
FKcurr_idintegerFK to CURRTYPE table - identifies the user's view Currency1
FKunit_idintegerUMeasure ID
rsrc_notesblobResource notes stored as text string
def_cost_qty_link_flagstring(1)Calculate cost from units'Y'
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_rsrc_rolesNONUNIQUErole_id
Triggers
PRMAUD_RSRCORSQL Server
RT_RSRC_DELORSQL Server
RT_RSRCORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_rsrcPRIMARYrsrc_id
fk_rsrc_currtypeFOREIGNcurr_idCURRTYPEcurr_id
fk_rsrc_rolesFOREIGNrole_idROLESrole_id
fk_rsrc_pobsFOREIGNpobs_idPOBSpobs_idINDEPENDENT
fk_rsrc_umeasureFOREIGNunit_idUMEASUREunit_id
ck_rsrc_ot_flagCHECKot_flag ot_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
fk_rsrcrcat_rsrcFOREIGNRSRCRCATrsrc_idrsrc_id
fk_rsrcrole_rsrcFOREIGNRSRCROLErsrc_idrsrc_id
fk_taskrsrc_rsrcFOREIGNTASKRSRCrsrc_idrsrc_id
[Top]
RSRCRCAT
Columns
KeyNameTypeDescriptionDefault
PK,FKrsrc_idintegerFK to RSRC table - identifies the resource
PK,FKrsrc_catg_type_idintegerFK to RCATTYPE table - identifies the resource category type
FKrsrc_catg_idintegerFK to RCATVAL table - identifies the resource category value
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_rsrcrcat_rcattypeNONUNIQUErsrc_catg_type_id
ndx_rsrcrcat_rcatvalNONUNIQUErsrc_catg_id
Triggers
PRMAUD_RSRCRCATORSQL Server
RT_RSRCRCAT_DELORSQL Server
RT_RSRCRCATORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_rsrcrcat_rcattypeFOREIGNrsrc_catg_type_idRCATTYPErsrc_catg_type_id
fk_rsrcrcat_rsrcFOREIGNrsrc_idRSRCrsrc_id
fk_rsrcrcat_rcatvalFOREIGNrsrc_catg_idRCATVALrsrc_catg_id
pk_rsrcrcatPRIMARYrsrc_id,rsrc_catg_type_id
References
NameTypeTableFieldsTarget Fields
[Top]
RSRCROLE
Columns
KeyNameTypeDescriptionDefault
PK,FKrsrc_idintegerFK to RSRC table - identifies the resource
PK,FKrole_idintegerFK to ROLES table - identifies the role for this resource on this activity
skill_levelintegerProficiency level
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_rsrcrole_rolesNONUNIQUErole_id
Triggers
PRMAUD_RSRCROLEORSQL Server
RT_RSRCROLE_DELORSQL Server
RT_RSRCROLEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_rsrcrole_rolesFOREIGNrole_idROLESrole_id
fk_rsrcrole_rsrcFOREIGNrsrc_idRSRCrsrc_id
pk_rsrcrolePRIMARYrsrc_id,role_id
References
NameTypeTableFieldsTarget Fields
[Top]
SETTINGS
Columns
KeyNameTypeDescriptionDefault
PKnamespacestring(255)Grouping of parameter
PKsetting_namestring(255)Name of Setting
setting_valuestring(4000)Actual Value of setting
user_idintegerUser Specific setting
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
RT_SETTINGS_DELORSQL Server
RT_SETTINGSORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_settingsPRIMARYnamespace,setting_name
References
NameTypeTableFieldsTarget Fields
[Top]
SPIDMAP
Columns
KeyNameTypeDescriptionDefault
PKspidintegerUnique ID
user_idintegerFK to USERS
user_namestring(32)Identified user name
app_namestring(25)Idnetified application name
audit_info_extendedblobHolder for temporary audit data
Indexes
NameUniqueFields
Triggers
TR_PROTECT_SPIDMAPSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_spidmapPRIMARYspid
References
NameTypeTableFieldsTarget Fields
[Top]
TASK
Columns
KeyNameTypeDescriptionDefault
PKtask_idintegerFK to TASK table - identifies the core activity
task_typestring(10)Activity type - task/milestone/etc
complete_pct_typestring(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_typestring(12)Duration type - Fixed-Units/Fixed-Duration/Fixed-Units-per-Time
task_namestring(120)Activity name
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
guidstring(22)Global unique ID
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_task_1NONUNIQUEtemplate_id
Triggers
PRMAUD_TASKORSQL Server
RT_TASK_DELORSQL Server
RT_TASKORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_task_templateFOREIGNtemplate_idTEMPLATEtemplate_id
pk_taskPRIMARYtask_id
References
NameTypeTableFieldsTarget Fields
fk_taskmemo_taskFOREIGNTASKMEMOtask_idtask_id
fk_taskproc_taskFOREIGNTASKPROCtask_idtask_id
fk_taskqual_taskFOREIGNTASKQUALtask_idtask_id
fk_taskuse_taskFOREIGNTASKUSEtask_idtask_id
[Top]
TASKACTV
Columns
KeyNameTypeDescriptionDefault
PK,FKtaskuse_idintegerFK to TASKUSE table - identifies the activity within the methodology
PK,FKactv_code_type_idintegerFK to ACTVTYPE table - identifies the activity code type
FKactv_code_idintegerFK to ACTVCODE table - identifies the activity code value
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskactv_1NONUNIQUEtemplate_id
ndx_taskactv_actvcodeNONUNIQUEactv_code_id
ndx_taskactv_actvtypeNONUNIQUEactv_code_type_id
Triggers
PRMAUD_TASKACTVORSQL Server
RT_TASKACTV_DELORSQL Server
RT_TASKACTVORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskactv_actvcodeFOREIGNactv_code_idACTVCODEactv_code_id
fk_taskactv_actvtypeFOREIGNactv_code_type_idACTVTYPEactv_code_type_id
fk_taskactv_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_taskactv_taskuseFOREIGNtaskuse_idTASKUSEtaskuse_id
pk_taskactvPRIMARYtaskuse_id,actv_code_type_id
References
NameTypeTableFieldsTarget Fields
[Top]
TASKDOC
Columns
KeyNameTypeDescriptionDefault
PKtaskdoc_idintegerUnique ID
FKdoc_idintegerFK to DOCUMENT table - identifies the document
FKwbs_idintegerFK to TMPLWBS table - identifies the WBS
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
wp_flagstring(1)Identifies which documents are work products (outputs) for the activity'N'
FKtaskuse_idintegerFK to TASKUSE table - identifies the activity within the methodology
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskdoc_1NONUNIQUEtemplate_id
ndx_taskdoc_documentNONUNIQUEdoc_id
ndx_taskdoc_taskuseNONUNIQUEtaskuse_id
ndx_taskdoc_tmplwbsNONUNIQUEwbs_id
Triggers
PRMAUD_TASKDOCORSQL Server
RT_TASKDOC_DELORSQL Server
RT_TASKDOCORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskdoc_documentFOREIGNdoc_idDOCUMENTdoc_id
fk_taskdoc_tmplwbsFOREIGNwbs_idTMPLWBSwbs_id
fk_taskdoc_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_taskdoc_taskuseFOREIGNtaskuse_idTASKUSEtaskuse_id
pk_taskdocPRIMARYtaskdoc_id
ck_taskdoc_wp_flagCHECKwp_flagwp_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
[Top]
TASKMEMO
Columns
KeyNameTypeDescriptionDefault
PKmemo_idintegerUnique ID
FKtask_idintegerFK to TASK table - identifies the core activity
FKmemo_type_idintegerFK to MEMOTYPE table - identifies the notebook topic
task_memoblobSpecification contents stored as text string
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskmemo_memotypeNONUNIQUEmemo_type_id
ndx_taskmemo_taskNONUNIQUEtask_id
Triggers
PRMAUD_TASKMEMOORSQL Server
RT_TASKMEMO_DELORSQL Server
RT_TASKMEMOORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskmemo_memotypeFOREIGNmemo_type_idMEMOTYPEmemo_type_id
fk_taskmemo_taskFOREIGNtask_idTASKtask_id
pk_taskmemoPRIMARYmemo_id
References
NameTypeTableFieldsTarget Fields
[Top]
TASKPRED
Columns
KeyNameTypeDescriptionDefault
PKtaskuse_pred_idintegerUnique ID
FKtaskuse_idintegerFK to TASKUSE table - identifies the activity within the methodology
FKpred_taskuse_idintegerFK to TASKUSE table - identifies the predecessor activity within the methodology
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
FKpred_template_idintegerFK to TEMPLATE table - identifies the predecessor methodology
pred_typestring(12)Dependency type - FS/FF/SS/SF
lag_hr_cntdouble(22,6)Time lag of dependency
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskpred_1NONUNIQUEpred_template_id
ndx_taskpred_2NONUNIQUEtemplate_id
ndx_taskpred_taskuse_1NONUNIQUEtaskuse_id
ndx_taskpred_taskuse_2NONUNIQUEpred_taskuse_id
Triggers
PRMAUD_TASKPREDORSQL Server
RT_TASKPRED_DELORSQL Server
RT_TASKPREDORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskpred_taskuse_1FOREIGNtaskuse_idTASKUSEtaskuse_id
fk_taskpred_template_2FOREIGNpred_template_idTEMPLATEtemplate_id
fk_taskpred_taskuse_2FOREIGNpred_taskuse_idTASKUSEtaskuse_id
fk_taskpred_template_1FOREIGNtemplate_idTEMPLATEtemplate_id
pk_taskpredPRIMARYtaskuse_pred_id
References
NameTypeTableFieldsTarget Fields
[Top]
TASKPROC
Columns
KeyNameTypeDescriptionDefault
PKproc_idintegerUnique ID
FKtask_idintegerFK to TASK table - identifies the core activity
seq_numintegerSequence number for sorting
proc_namestring(120)Step name
proc_wtdouble(22,2)Relative weight or contribution of work on task step weight
proc_descrblobStep description stored as text string
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskproc_taskNONUNIQUEtask_id
Triggers
PRMAUD_TASKPROCORSQL Server
RT_TASKPROC_DELORSQL Server
RT_TASKPROCORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskproc_taskFOREIGNtask_idTASKtask_id
pk_taskprocPRIMARYproc_id
References
NameTypeTableFieldsTarget Fields
[Top]
TASKQUAL
Columns
KeyNameTypeDescriptionDefault
PK,FKtask_idintegerFK to TASK table - identifies the core activity
PK,FKqual_idintegerFK to QUALITY table - identifies the attribute for filtering in Project Architect
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskqual_qualityNONUNIQUEqual_id
Triggers
PRMAUD_TASKQUALORSQL Server
RT_TASKQUAL_DELORSQL Server
RT_TASKQUALORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskqual_qualityFOREIGNqual_idQUALITYqual_id
fk_taskqual_taskFOREIGNtask_idTASKtask_id
pk_taskqualPRIMARYtask_id,qual_id
References
NameTypeTableFieldsTarget Fields
[Top]
TASKRSRC
Columns
KeyNameTypeDescriptionDefault
PKtaskrsrc_idintegerUnique ID
FKtaskuse_idintegerFK to TASKUSE table - identifies the activity within the methodology
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
rsrc_typestring(10)Resource type Labor, Equipment, or Material'RT_Labor'
FKrole_idintegerFK to ROLES table - identifies the role for this resource on this activity
FKrsrc_idintegerFK to RSRC table - identifies the resource
FKpobs_idintegerFK to POBS table - identifies the performing organization
skill_levelintegerProficiency level
qty_per_hrdouble(22,8)Units per time for this resource on this activity (hours per hour)
low_qtydouble(22,6)Low count of units for this resource on this activity (hours)
high_qtydouble(22,6)High count of units for this resource on this activity (hours)
cost_qty_link_flagstring(1)Costs Units Linked'Y'
lag_drtn_hr_cntdouble(22,6)Time lag 0
low_costdouble(22,6)Low expense cost
high_costdouble(22,6)High expense cost
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskrsrc_1NONUNIQUEtemplate_id
ndx_taskrsrc_rolesNONUNIQUErole_id
ndx_taskrsrc_rsrcNONUNIQUErsrc_id
ndx_taskrsrc_taskuseNONUNIQUEtaskuse_id
Triggers
PRMAUD_TASKRSRCORSQL Server
RT_TASKRSRC_DELORSQL Server
RT_TASKRSRCORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskrsrc_rolesFOREIGNrole_idROLESrole_id
fk_taskrsrc_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_taskrsrc_rsrcFOREIGNrsrc_idRSRCrsrc_id
fk_taskrsrc_pobsFOREIGNpobs_idPOBSpobs_idINDEPENDENT
fk_taskrsrc_taskuseFOREIGNtaskuse_idTASKUSEtaskuse_id
pk_taskrsrcPRIMARYtaskrsrc_id
References
NameTypeTableFieldsTarget Fields
[Top]
TASKUSE
Columns
KeyNameTypeDescriptionDefault
PKtaskuse_idintegerFK to TASKUSE table - identifies the activity within the methodology
FKtask_idintegerFK to TASK table - identifies the core activity
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
FKwbs_idintegerFK to TMPLWBS table - identifies the WBS
est_wtdouble(22,2)Estimation weight, for top-down estimation
task_codestring(40)Activity code
low_work_qtydouble(22,6)Low count of labor units, rolled up from assigned activities
high_work_qtydouble(22,6)High count of labor units, rolled up from assigned activities
low_equip_qtydouble(22,6)Low count of non-labor units, rolled up from assigned activities
high_equip_qtydouble(22,6)High count of non-labor units, rolled up from assigned activities
low_drtn_hr_cntdouble(22,6)Low duration estimate
high_drtn_hr_cntdouble(22,6)
guidstring(22)Global unique ID
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_taskuse_1NONUNIQUEtemplate_id
ndx_taskuse_taskNONUNIQUEtask_id
ndx_taskuse_tmplwbsNONUNIQUEwbs_id
Triggers
PRMAUD_TASKUSEORSQL Server
RT_TASKUSE_DELORSQL Server
RT_TASKUSEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_taskuse_taskFOREIGNtask_idTASKtask_id
fk_taskuse_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_taskuse_tmplwbsFOREIGNwbs_idTMPLWBSwbs_id
pk_taskusePRIMARYtaskuse_id
References
NameTypeTableFieldsTarget Fields
fk_taskactv_taskuseFOREIGNTASKACTVtaskuse_idtaskuse_id
fk_taskdoc_taskuseFOREIGNTASKDOCtaskuse_idtaskuse_id
fk_taskpred_taskuse_1FOREIGNTASKPREDtaskuse_idtaskuse_id
fk_taskpred_taskuse_2FOREIGNTASKPREDpred_taskuse_idtaskuse_id
fk_taskrsrc_taskuseFOREIGNTASKRSRCtaskuse_idtaskuse_id
fk_tmplcost_taskuseFOREIGNTMPLCOSTtaskuse_idtaskuse_id
[Top]
TCATTYPE
Columns
KeyNameTypeDescriptionDefault
PKtmpl_catg_type_idintegerFK to TCATTYPE table - identifies the methodology category type
seq_numintegerSequence number for sorting
tmpl_catg_short_lenintegerMax length of methodology category value
tmpl_catg_typestring(40)Methodology category type
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_TCATTYPEORSQL Server
RT_TCATTYPE_DELORSQL Server
RT_TCATTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_tcattypePRIMARYtmpl_catg_type_id
References
NameTypeTableFieldsTarget Fields
fk_tcatval_tcattypeFOREIGNTCATVALtmpl_catg_type_idtmpl_catg_type_id
fk_tmpltcat_tcattypeFOREIGNTMPLTCATtmpl_catg_type_idtmpl_catg_type_id
[Top]
TCATVAL
Columns
KeyNameTypeDescriptionDefault
PKtmpl_catg_idintegerFK to TCATVAL table - identifies the methodology category value
FKtmpl_catg_type_idintegerFK to TCATTYPE table - identifies the methodology category type
seq_numintegerSequence number for sorting
tmpl_catg_short_namestring(32)Methodology category value
parent_tmpl_catg_idintegerFK to TCATVAL table - identifies the parent methodology category value
tmpl_catg_namestring(100)Methodology category description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_tcatval_tcattypeNONUNIQUEtmpl_catg_type_id
Triggers
PRMAUD_TCATVALORSQL Server
RT_TCATVAL_DELORSQL Server
RT_TCATVALORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_tcatval_tcattypeFOREIGNtmpl_catg_type_idTCATTYPEtmpl_catg_type_id
pk_tcatvalPRIMARYtmpl_catg_id
References
NameTypeTableFieldsTarget Fields
fk_tmpltcat_tcatvalFOREIGNTMPLTCATtmpl_catg_idtmpl_catg_id
[Top]
TEMPLATE
Columns
KeyNameTypeDescriptionDefault
PKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
add_datedateDate methodology was created
checkout_flagstring(1)Indicates whether the methodology is currently checked out'N'
template_typestring(20)Methodology type - Base/Plugin/Activity-Library
status_codestring(20)Methodology status values: Available, Unavailable
template_namestring(100)Methodology name
task_cntintegerCount of tasks, rolled up from assigned activities
task_code_baseintegerSuffix base value for auto-increment of task code
task_code_stepintegerSuffix step value for auto-increment of task code
low_work_qtydouble(22,6)Low count of labor units, rolled up from assigned activities
high_work_qtydouble(22,6)High count of labor units, rolled up from assigned activities
low_equip_qtydouble(22,6)Low count of non-labor units, rolled up from assigned activities
high_equip_qtydouble(22,6)High count of non-labor units, rolled up from assigned activities
low_work_costdouble(22,6)Low labor cost, rolled up from assigned activities
high_work_costdouble(22,6)High labor cost, rolled up from assigned activities
low_equip_costdouble(22,6)Low non-labor cost, rolled up from assigned activities
high_equip_costdouble(22,6)High non-labor cost, rolled up from assigned activities
low_expense_costdouble(22,6)Low expense cost, rolled up from assigned activities
high_expense_costdouble(22,6)High expense cost, rolled up from assigned activities
def_cost_per_qtydouble(22,8)Default price/time to compute costs when activities have no resources (but do have units)
task_code_prefixstring(20)Prefix for auto-increment of task code
guidstring(22)Global unique ID
def_qty_typestring(24)Time units for methodology's default price/time (year/month/week/day/hour)
add_by_namestring(32)Name of user who created the methodology
low_mat_costdouble(22,6)Low material cost
high_mat_costdouble(22,6)High material cost
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_TEMPLATEORSQL Server
RT_TEMPLATE_DELORSQL Server
RT_TEMPLATEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_templatePRIMARYtemplate_id
ck_template_checkout_flagCHECKcheckout_flagcheckout_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
fk_riskctrl_templateFOREIGNRISKCTRLtemplate_idtemplate_id
fk_task_templateFOREIGNTASKtemplate_idtemplate_id
fk_taskactv_templateFOREIGNTASKACTVtemplate_idtemplate_id
fk_taskdoc_templateFOREIGNTASKDOCtemplate_idtemplate_id
fk_taskpred_template_2FOREIGNTASKPREDpred_template_idtemplate_id
fk_taskpred_template_1FOREIGNTASKPREDtemplate_idtemplate_id
fk_taskrsrc_templateFOREIGNTASKRSRCtemplate_idtemplate_id
fk_taskuse_templateFOREIGNTASKUSEtemplate_idtemplate_id
fk_tmplcost_templateFOREIGNTMPLCOSTtemplate_idtemplate_id
fk_tmplrisk_templateFOREIGNTMPLRISKtemplate_idtemplate_id
fk_tmplshar_templateFOREIGNTMPLSHARtemplate_idtemplate_id
fk_tmpltcat_templateFOREIGNTMPLTCATtemplate_idtemplate_id
fk_tmplwbs_templateFOREIGNTMPLWBStemplate_idtemplate_id
fk_udfvalue_templateFOREIGNUDFVALUEtemplate_idtemplate_id
fk_usertmpl_templateFOREIGNUSERTMPLtemplate_idtemplate_id
fk_wbsmemo_templateFOREIGNWBSMEMOtemplate_idtemplate_id
fk_wbsstep_templateFOREIGNWBSSTEPtemplate_idtemplate_id
[Top]
TMPLCOST
Columns
KeyNameTypeDescriptionDefault
PKcost_item_idintegerUnique ID
FKtaskuse_idintegerFK to TASKUSE table - identifies the activity within the methodology
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
cost_load_typestring(12)Type of cost accrual over the activity duration - Start/End/Uniform
FKcost_type_idintegerFK to COSTTYPE table - identifies the expense category
FKpobs_idintegerFK to POBS table - identifies the performing organization
low_costdouble(22,6)Low expense cost
high_costdouble(22,6)High expense cost
vendor_namestring(100)Vendor name
cost_namestring(120)Expense name
qty_namestring(30)Unit of measure for expense
cost_descrblobExpense description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_tmplcost_1NONUNIQUEtemplate_id
ndx_tmplcost_costtypeNONUNIQUEcost_type_id
ndx_tmplcost_taskuseNONUNIQUEtaskuse_id
Triggers
PRMAUD_TMPLCOSTORSQL Server
RT_TMPLCOST_DELORSQL Server
RT_TMPLCOSTORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_tmplcost_costtypeFOREIGNcost_type_idCOSTTYPEcost_type_id
fk_tmplcost_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_tmplcost_pobsFOREIGNpobs_idPOBSpobs_idINDEPENDENT
fk_tmplcost_taskuseFOREIGNtaskuse_idTASKUSEtaskuse_id
pk_tmplcostPRIMARYcost_item_id
References
NameTypeTableFieldsTarget Fields
[Top]
TMPLRISK
Columns
KeyNameTypeDescriptionDefault
PKrisk_idintegerUnique ID
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
FKwbs_idintegerFK to TMPLWBS table - identifies the WBS
priority_typestring(12)Risk priority
risk_namestring(100)Risk name
FKrisk_type_idintegerFK to RISKTYPE table - identifies the risk type
prbly_pctintegerRisk probability of occurrence
impact_work_qtydouble(22,6)Impact labor units if risk occurs
impact_equip_qtydouble(22,6)Impact non-labor units if risk occurs
impact_expense_costdouble(22,6)Impact expense cost if risk occurs
risk_descrblobRisk description
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_tmplrisk_1NONUNIQUEtemplate_id
ndx_tmplrisk_risktypeNONUNIQUErisk_type_id
ndx_tmplrisk_tmplwbsNONUNIQUEwbs_id
Triggers
PRMAUD_TMPLRISKORSQL Server
RT_TMPLRISK_DELORSQL Server
RT_TMPLRISKORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_tmplrisk_risktypeFOREIGNrisk_type_idRISKTYPErisk_type_id
fk_tmplrisk_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_tmplrisk_tmplwbsFOREIGNwbs_idTMPLWBSwbs_id
pk_tmplriskPRIMARYrisk_id
References
NameTypeTableFieldsTarget Fields
fk_riskctrl_tmplriskFOREIGNRISKCTRLrisk_idrisk_id
[Top]
TMPLSHAR
Columns
KeyNameTypeDescriptionDefault
PK,FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
PK,FKsession_idintegerUnique ID
access_levelintegerAccess level; 1 = Shared; 2 = Exclusive
Indexes
NameUniqueFields
ndx_tmplshar_usessionNONUNIQUEsession_id
Triggers
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_tmplshar_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_tmplshar_usessionFOREIGNsession_idUSESSIONsession_id
pk_tmplsharPRIMARYtemplate_id,session_id
References
NameTypeTableFieldsTarget Fields
[Top]
TMPLTCAT
Columns
KeyNameTypeDescriptionDefault
PK,FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
PK,FKtmpl_catg_type_idintegerFK to TCATTYPE table - identifies the methodology category type
FKtmpl_catg_idintegerFK to TCATVAL table - identifies the methodology category value
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_tmpltcat_tcattypeNONUNIQUEtmpl_catg_type_id
ndx_tmpltcat_tcatvalNONUNIQUEtmpl_catg_id
Triggers
PRMAUD_TMPLTCATORSQL Server
RT_TMPLTCAT_DELORSQL Server
RT_TMPLTCATORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_tmpltcat_tcattypeFOREIGNtmpl_catg_type_idTCATTYPEtmpl_catg_type_id
fk_tmpltcat_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_tmpltcat_tcatvalFOREIGNtmpl_catg_idTCATVALtmpl_catg_id
pk_tmpltcatPRIMARYtemplate_id,tmpl_catg_type_id
References
NameTypeTableFieldsTarget Fields
[Top]
TMPLWBS
Columns
KeyNameTypeDescriptionDefault
PKwbs_idintegerFK to TMPLWBS table - identifies the WBS
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
seq_numintegerSequence number for sorting
est_wtdouble(22,2)Estimation weight, for top-down estimation
wbs_short_namestring(40)WBS code
wbs_namestring(100)WBS name
FKphase_idintegerFK to PHASE table - identifies WBS category value
FKobs_idintegerFK to OBS table - identifies the responsible OBS
parent_wbs_idintegerFK to TMPLWBS table - identifies parent in WBS hierarchy
FKfact_catg_idintegerFK to FACTCATG table - identifies the factor category. Size and complexity category
guidstring(22)Global unique ID
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_tmplwbs_1NONUNIQUEtemplate_id
ndx_tmplwbs_factcatgNONUNIQUEfact_catg_id
ndx_tmplwbs_obsNONUNIQUEobs_id
ndx_tmplwbs_phaseNONUNIQUEphase_id
Triggers
PRMAUD_TMPLWBSORSQL Server
RT_TMPLWBS_DELORSQL Server
RT_TMPLWBSORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_tmplwbs_factcatgFOREIGNfact_catg_idFACTCATGfact_catg_id
fk_tmplwbs_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_tmplwbs_phaseFOREIGNphase_idPHASEphase_id
fk_tmplwbs_obsFOREIGNobs_idOBSobs_id
pk_tmplwbsPRIMARYwbs_id
References
NameTypeTableFieldsTarget Fields
fk_linkwbs_tmplwbs_1FOREIGNLINKWBSbase_wbs_idwbs_id
fk_linkwbs_tmplwbs_2FOREIGNLINKWBSplugin_wbs_idwbs_id
fk_taskdoc_tmplwbsFOREIGNTASKDOCwbs_idwbs_id
fk_taskuse_tmplwbsFOREIGNTASKUSEwbs_idwbs_id
fk_tmplrisk_tmplwbsFOREIGNTMPLRISKwbs_idwbs_id
fk_wbsmemo_tmplwbsFOREIGNWBSMEMOwbs_idwbs_id
fk_wbsstep_tmplwbsFOREIGNWBSSTEPwbs_idwbs_id
[Top]
UDFCODE
Columns
KeyNameTypeDescriptionDefault
PKudf_code_idintegerUnique identifier
FKudf_type_idintegerFK to UDFTYPE
seq_numintegerOrder of values
short_namestring(60)Code Value
udf_code_namestring(120)Description of code
parent_udf_code_idintegerParent for Hierarchical codes
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_udfcode_udf_type_idNONUNIQUEudf_type_id
Triggers
PRMAUD_UDFCODEORSQL Server
RT_UDFCODE_DELORSQL Server
RT_UDFCODEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_udfcodePRIMARYudf_code_id
fk_udfcode_udftypeFOREIGNudf_type_idUDFTYPEudf_type_idDEPENDENT
References
NameTypeTableFieldsTarget Fields
fk_udfvalue_udfcodeFOREIGNUDFVALUEudf_code_idudf_code_id
[Top]
UDFTYPE
Columns
KeyNameTypeDescriptionDefault
PKudf_type_idintegerUnique identifier
table_namestring(30)Name of database table where column resides
udf_type_namestring(32)User defined field name
udf_type_labelstring(40)Label for column
logical_data_typestring(20)Logical data type for column
super_flagstring(1)Super Code Flag'N'
udf_code_short_lenintegerMax Length of Code Values
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_UDFTYPEORSQL Server
RT_UDFTYPE_DELORSQL Server
RT_UDFTYPEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_udftypePRIMARYudf_type_id
References
NameTypeTableFieldsTarget Fields
fk_udfcode_udftypeFOREIGNUDFCODEudf_type_idudf_type_id
fk_udfvalue_udftypeFOREIGNUDFVALUEudf_type_idudf_type_id
[Top]
UDFVALUE
Columns
KeyNameTypeDescriptionDefault
PK,FKudf_type_idintegerFK to UDFTYPE Table
PKfk_idintegerGeneric foreign key to appropriate table. No constrained
FKtemplate_idintegerFK to TEMPLATE table (if appropriate) for performance
udf_datedateDate value
udf_textstring(255)String value
udf_numbernumberGeneric numeric value
FKudf_code_idintegerFK to UDFCODE (if a Code Type)
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_udfvalue_templateNONUNIQUEtemplate_id
ndx_udfvalue_udfcodeNONUNIQUEudf_code_id
Triggers
PRMAUD_UDFVALUEORSQL Server
RT_UDFVALUE_DELORSQL Server
RT_UDFVALUEORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_udfvaluePRIMARYudf_type_id,fk_id
fk_udfvalue_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_udfvalue_udfcodeFOREIGNudf_code_idUDFCODEudf_code_idINDEPENDENT
fk_udfvalue_udftypeFOREIGNudf_type_idUDFTYPEudf_type_idDEPENDENT
References
NameTypeTableFieldsTarget Fields
[Top]
UMEASURE
Columns
KeyNameTypeDescriptionDefault
PKunit_idintegerUnique ID
seq_numintegerSequence Number
unit_namestring(100)Unit Name
unit_abbrevstring(16)Unit abbreviation
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_UMEASUREORSQL Server
RT_UMEASURE_DELORSQL Server
RT_UMEASUREORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_umeasurePRIMARYunit_id
References
NameTypeTableFieldsTarget Fields
fk_rsrc_umeasureFOREIGNRSRCunit_idunit_id
[Top]
USERCOL
Columns
KeyNameTypeDescriptionDefault
PKuser_col_idintegerUnique identifier
table_namestring(16)Name of database table where column resides
logical_data_typestring(20)Logical data type for column
user_col_namestring(32)Name of column
user_col_labelstring(40)Label for column
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
Triggers
PRMAUD_USERCOLORSQL Server
RT_USERCOL_DELORSQL Server
RT_USERCOLORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_usercolPRIMARYuser_col_id
References
NameTypeTableFieldsTarget Fields
[Top]
USERDATA
Columns
KeyNameTypeDescriptionDefault
PKuser_data_idintegerUnique ID
FKuser_idintegerFK to USERS table - identifies the user
topic_namestring(20)Topic for user data. Combination of user_id and topic_name unique.
user_datablobUser settings/preferences for this topic
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_userdata_1NONUNIQUEuser_id
Triggers
PRMAUD_USERDATAORSQL Server
RT_USERDATA_DELORSQL Server
RT_USERDATAORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_userdata_usersFOREIGNuser_idUSERSuser_id
pk_userdataPRIMARYuser_data_id
References
NameTypeTableFieldsTarget Fields
[Top]
USERENG
Columns
KeyNameTypeDescriptionDefault
PKuser_eng_idintegerUnique ID
FKuser_idintegerFK to USERS table - identifies the user
named_user_flagstring(1)Indicates whether this user is licensed for this engine on a named or concurrent user basis'Y'
db_engine_typestring(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_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_usereng_usersNONUNIQUEuser_id
Triggers
PRMAUD_USERENGORSQL Server
RT_USERENG_DELORSQL Server
RT_USERENGORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_usereng_usersFOREIGNuser_idUSERSuser_id
pk_userengPRIMARYuser_eng_id
ck_usereng_named_user_flagCHECKnamed_user_flagnamed_user_flag in ('Y', 'N')
References
NameTypeTableFieldsTarget Fields
[Top]
USERS
Columns
KeyNameTypeDescriptionDefault
PKuser_idintegerFK to USERS table - identifies the user
user_namestring(32)Login name for user
view_idintegerUnique ID
FKprof_idintegerFK to PROFILE table - identifies security profile for the user for this methodology
guidstring(22)Global unique ID
actual_namestring(80)Personal name of user
passwdstring(255)Login password for user
FKcurr_idintegerFK to CURRTYPE table - identifies the user's view Currency1
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_users_profileNONUNIQUEprof_id
Triggers
PRMAUD_USERSORSQL Server
RT_USERS_DELORSQL Server
RT_USERSORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_users_currtypeFOREIGNcurr_idCURRTYPEcurr_id
fk_users_profileFOREIGNprof_idPROFILEprof_id
pk_usersPRIMARYuser_id
References
NameTypeTableFieldsTarget Fields
fk_filtprop_usersFOREIGNFILTPROPuser_iduser_id
fk_userdata_usersFOREIGNUSERDATAuser_iduser_id
fk_usereng_usersFOREIGNUSERENGuser_iduser_id
fk_usertmpl_usersFOREIGNUSERTMPLuser_iduser_id
fk_usession_usersFOREIGNUSESSIONuser_iduser_id
fk_viewprop_usersFOREIGNVIEWPROPuser_iduser_id
[Top]
USERTMPL
Columns
KeyNameTypeDescriptionDefault
PK,FKuser_idintegerFK to USERS table - identifies the user
PK,FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
FKprof_idintegerFK to PROFILE table - identifies security profile for the user for this methodology
FKview_idintegerUnique ID
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_usertmpl_1NONUNIQUEtemplate_id
ndx_usertmpl_profileNONUNIQUEprof_id
ndx_usertmpl_viewpropNONUNIQUEview_id
Triggers
PRMAUD_USERTMPLORSQL Server
RT_USERTMPL_DELORSQL Server
RT_USERTMPLORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_usertmpl_profileFOREIGNprof_idPROFILEprof_id
fk_usertmpl_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_usertmpl_viewpropFOREIGNview_idVIEWPROPview_id
fk_usertmpl_usersFOREIGNuser_idUSERSuser_id
pk_usertmplPRIMARYuser_id,template_id
References
NameTypeTableFieldsTarget Fields
[Top]
USESSION
Columns
KeyNameTypeDescriptionDefault
PKsession_idintegerUnique ID
login_timedateThe time the application logged in
last_active_timedateLast active time of the application
host_namestring(50)Computer host name
FKuser_idintegerFK to USERS table - identifies the user
process_numintegerProcess number for the application running on the host computer
app_namestring(25)The name of the application logged in
hard_drive_codestring(40)Computer hard drive identifier code
db_engine_typestring(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_namestring(32)Operating system login name for user
vdb_instance_guidstring(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
spidintegerRDBMS session id to match database session with primavera session
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_usession_usersNONUNIQUEuser_id
Triggers
RT_USESSION_DELORSQL Server
RT_USESSIONORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_usession_usersFOREIGNuser_idUSERSuser_id
pk_usessionPRIMARYsession_id
References
NameTypeTableFieldsTarget Fields
fk_tmplshar_usessionFOREIGNTMPLSHARsession_idsession_id
[Top]
VIEWPROP
Columns
KeyNameTypeDescriptionDefault
PKview_idintegerUnique ID
view_namestring(40)View name
FKuser_idintegerFK to USERS table - identifies the user
view_typestring(20)Type of view
view_datablobView settings stored as text string
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_viewprop_1NONUNIQUEuser_id
Triggers
PRMAUD_VIEWPROPORSQL Server
RT_VIEWPROP_DELORSQL Server
RT_VIEWPROPORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_viewprop_usersFOREIGNuser_idUSERSuser_id
pk_viewpropPRIMARYview_id
References
NameTypeTableFieldsTarget Fields
fk_usertmpl_viewpropFOREIGNUSERTMPLview_idview_id
[Top]
WBSMEMO
Columns
KeyNameTypeDescriptionDefault
PKwbs_memo_idintegerUnique ID
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
FKwbs_idintegerFK to TMPLWBS table - identifies the WBS
FKmemo_type_idintegerFK to MEMOTYPE table - identifies the notebook topic
wbs_memoblobNotebook contents stored as text string
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_wbsmemo_1NONUNIQUEtemplate_id
ndx_wbsmemo_memotypeNONUNIQUEmemo_type_id
ndx_wbsmemo_tmplwbsNONUNIQUEwbs_id
Triggers
PRMAUD_WBSMEMOORSQL Server
RT_WBSMEMO_DELORSQL Server
RT_WBSMEMOORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_wbsmemo_memotypeFOREIGNmemo_type_idMEMOTYPEmemo_type_id
fk_wbsmemo_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_wbsmemo_tmplwbsFOREIGNwbs_idTMPLWBSwbs_id
pk_wbsmemoPRIMARYwbs_memo_id
References
NameTypeTableFieldsTarget Fields
[Top]
WBSSTEP
Columns
KeyNameTypeDescriptionDefault
PKwbs_step_idintegerUnique ID
FKtemplate_idintegerFK to TEMPLATE table - identifies the methodology
FKwbs_idintegerFK to TMPLWBS table - identifies the WBS
seq_numintegerSequence number for sorting
step_namestring(120)Descriptive name of WBS milestone WBS Milestone
step_wtdouble(22,2)Relative weight or contribution of step weight
update_datedateRefresh audit field of last date updated. Trigger maintained.
update_userstring(255)Refresh audit field of last user updated. Trigger maintained.
create_datedateRefresh audit field for date record created. Trigger maintained.
create_userstring(255)Refresh audit field for user that created the record. Trigger maintained.
delete_session_idintegerDeleted by session id. Client maintained.
delete_datedateDeleted date. Client maintained.
Indexes
NameUniqueFields
ndx_wbsstep_1NONUNIQUEtemplate_id
ndx_wbsstep_tmplwbsNONUNIQUEwbs_id
Triggers
PRMAUD_WBSSTEPORSQL Server
RT_WBSSTEP_DELORSQL Server
RT_WBSSTEPORSQL Server
Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
fk_wbsstep_templateFOREIGNtemplate_idTEMPLATEtemplate_id
fk_wbsstep_tmplwbsFOREIGNwbs_idTMPLWBSwbs_id
pk_wbsstepPRIMARYwbs_step_id
References
NameTypeTableFieldsTarget Fields