Share this page

# KCRT_FG_MASTER_PROJ_REF_INT

This is a child table of the KCRT_REQUESTS_INT table. It is used to import data into the KCRT_FG_MASTER_PROJ_REF table. This table will be processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allows for scheduled processing. The PL/SQL package queries this table, validates against appropriate tables and imports into the production tables. It can also release the request depending on its status by calling the workflow APIs.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
PM_PROJECTS | PROJECT_ID | REF_MASTER_PROJECT_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID
KCRT_REQUESTS_INT | TRANSACTION_ID | PARENT_TRANSACTION_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
GROUP_ID | NOT NULL | NUMBER | value used to tie records in the interface tables together. Most of the database processing is done based on this value. The value must be the same as the parent's group_ID in the KCRT_REQUESTS_INT table.
TRANSACTION_ID | NOT NULL | NUMBER | System-generated record identifier
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | Links this table to TRANSACTION_ID in KCRT_REQUESTS_INT
REQUEST_ID | NULLABLE | NUMBER | Refers to the request_id in KCRT_REQUESTS table
REQUEST_TYPE_ID | NULLABLE | NUMBER | Request type ID used by this request
REF_MASTER_PROJECT_ID | NULLABLE | NUMBER | If a value is supplied, automatically creates a reference to the specified master project. If supplied, must also specify REF_MASTER_PROJECT_NAME.
REF_MASTER_PROJECT_NAME | NULLABLE | VARCHAR2(1200) | If a value is supplied, automatically creates a reference to the specified master project. If supplied, must also specify REF_MASTER_PROJECT_ID.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_MASTER_PROJ_REF_INT_N1 | NONUNIQUE | 1 | GROUP_ID
KCRT_FG_MASTER_PROJ_REF_INT_N1 | NONUNIQUE | 2 | TRANSACTION_ID

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: