Project Dependencies – SQL

The Project Dependencies portlet displays all projects and their associated dependencies that the logged in user has rights to.  This can assist in scheduling and visualizing the breakout of dependencies.

The table below describes the available columns in the portlet.

Column Label Description
Project ID ID of the project
Project Name Name of the project
Type Relationship to above project, Parent Project (P) or Sub Project (S)
Manager Manager of the project
Start Start Date of the project
Finish Finish Date of the project
Gantt Visualization of project timelines
Sort Column Used to order the columns for proper display of the portlet
dimkey Internal code used by the query
Inv_hlth_int Internal code used by the query
Link_dbid Internal code used by the query
link_toggle Internal code used by the query
rel_active Internal code used by the query
rel_dbid Internal code used by the query
rel_mgr_dbid Internal code used by the query
rel_sort Internal code used by the query

 

 

Want access to our solutions?

Register for a free theBasiX™  account and upgrade to theWorX to gain access to all of the content available on RegoXchange™.

Download Details

RegoXchange Content ID: EX1657

Submission Date:

Submitter:

Content Type: Clarity Studio

Related Modules: Project Management

Company: Rego Consulting

Version Support

Versions Supported: 14.x, 15.x, 16.x

Special Instructions

Special Instructions: