The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Question on Database Table of PPM

Highlighted
rgdalisay
Occasional Advisor

Question on Database Table of PPM

Hi all,

 

I'm just newbie in PPM. Our company is using PPM v8.0

 

As I was checking the Datasources of Dashboard in the Workbench, I noticed that 2 tables that is used for query:

1.) KCRT_STATUSES

2.) KCRT_FIELD_GROUP_DETAILS_V

 

When I tried looking for them in the tables in the DB, I can't seem to find them.

I later found out that KCRT_STATUSES is the same as KCRT_STATUSES_NLS.

Both of them are the same.

 

This means that you can SELECT the KCRT_STATUSES_NLS using KCRT_STATUSES as the table?

 

How does this happend?

Is there other tables in ppm that are like this? If yes, can you list them down?

 

 

Thanks in advance.

2 REPLIES
Sascha_Mohr
Super Collector

Re: Question on Database Table of PPM

Since release 8.x (introduction of MLU) kcrt_statuses is a view and kcrt_statuses_nls and kcrt_statuses_loc are the tables the view is based on.

KCRT_FIELD_GROUP_DETAILS_V is a view too.

hth

Regards
Sascha
Utkarsh_Mishra
Honored Contributor

Re: Question on Database Table of PPM

For more details on table structure, you can refer HP PPM 8.x "Data Model Guide".

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event