Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Locating specific data warehouse tables that contain custom fields and their corresponding data.

Questions
Tags
Users
Badges
Jon Chinnery
(10●5●5) Mar 12 '14, 11:49 a.m.
I have customized the CCM application to capture custom attributes against defects. Example - I added a field for capturing 'defect category'. All the system field data is flowing from RQM CCM to 'Request' table of DW. But we need to find the DW tables which store the custom field data.

0 votes

1 answer
4,321 views
0 votes

Accepted answer

Permanent link
Clara Forero
JAZZ DEVELOPER (621●2) Mar 14 '14, 12:50 p.m.

Hi Jon,

These are the tables where you can find request related custom attributes (all of them are in the RICALM schema): REQUEST_COMPONENT_EXT, REQUEST_CATEGORY_EXT,  REQUEST_RESOURCE_EXT, REQUEST_RELEASE_EXT, REQUEST_ITERATION_EXT, REQUEST_PROJECT_EXT, REQUEST_TEAM_EXT, REQUEST_TIMELINE_EXT, EQUEST_REQUEST_EXT, REQUEST_INT_EXT, REQUEST_LONG_EXT, REQUEST_BOOL_EXT, REQUEST_STRING_EXT, REQUEST_STRING_M_EXT, REQUEST_STRING_L_EXT, REQUEST_TIMESTAMP_EXT, REQUEST_DECIMAL_EXT.

Thanks,

Clara

 

,

Jon Chinnery selected this answer as the correct answer

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020

Question asked: Mar 12 '14, 11:49 a.m.

Question was seen: 4,321 times

Last updated: Mar 14 '14, 12:50 p.m.

Confirmation Cancel Confirm