Share this page

# KCRT_REQUESTS_INT

This table corresponds to the KCRT_REQUESTS, KCRT_REQUEST_DETAILS and KNTA_NOTES tables. This table is 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 while allowing for scheduled processing. PL/SQL package will query this table, validate against appropriate tables and imports into the production tables. It also calls 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
--- | --- | ---
KNTA_USER_SECURITY | USER_SECURITY_ID | ASSIGNED_TO_GROUP_ID
KNTA_USERS | USER_ID | ASSIGNED_TO_USER_ID
KCRT_CONTACTS | CONTACT_ID | CONTACT_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USER_SECURITY | USER_SECURITY_ID | GROUP_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | PARAMETER_SET_CONTEXT_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_SUB_TYPES_NLS | REQUEST_SUB_TYPE_ID | REQUEST_SUBTYPE_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID
KCRT_STATUSES_NLS | STATUS_ID | STATUS_ID
KCRT_TRANSACTIONS | TRANSACTION_ID | TRANSACTION_ID
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | WORKFLOW_ID
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | WORKFLOW_STEP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
GROUP_ID | NOT NULL | NUMBER | This value is used to tie records in the interface tables together. Most of database processing is done based on this value.
TRANSACTION_ID | NOT NULL | NUMBER | System-generated identifier
PROCESS_PHASE | NULLABLE | NUMBER | Indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed.
PROCESS_STATUS | NULLABLE | NUMBER | Indicates the current status of the interface record: Pending, In Progress, Errored or Completed.
REQUEST_ID | NULLABLE | NUMBER | Refers to the request_id in KCRT_REQUESTS table
CREATION_DATE | NULLABLE | DATE | Date record was created
CREATED_USERNAME | NOT NULL | VARCHAR2(200) | Username that creates the record
CREATED_BY | NULLABLE | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NULLABLE | DATE | Date record was last updated
LAST_UPDATED_USERNAME | NOT NULL | VARCHAR2(200) | Username that last updated this record
LAST_UPDATED_BY | NULLABLE | NUMBER | Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE | NULLABLE | DATE | Date a record in the entity was last updated
REQUEST_NUMBER | NULLABLE | VARCHAR2(30) | Refers to the request_number in KNTA_REQUESTS table
REQUEST_TYPE_NAME | NOT NULL | VARCHAR2(80) | Type of the request
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type ID used by this request
REQUEST_SUBTYPE_NAME | NULLABLE | VARCHAR2(80) | Sub type name of the request
REQUEST_SUBTYPE_ID | NULLABLE | NUMBER | Request Subtype ID used by this request
DESCRIPTION | NULLABLE | VARCHAR2(400) | Description of the request entered by the user
RELEASE_DATE | NULLABLE | DATE | Date the request was submitted
STATUS_NAME | NULLABLE | VARCHAR2(80) | Status Name of the request
STATUS_ID | NULLABLE | NUMBER | ID of status used by the request
WORKFLOW_NAME | NULLABLE | VARCHAR2(80) | Name of the workflow used by the request
WORKFLOW_ID | NULLABLE | NUMBER | ID of the workflow used by the request
DEPARTMENT_CODE | NULLABLE | VARCHAR2(30) | Code of the department to which the request is assigned to
DEPARTMENT_NAME | NULLABLE | VARCHAR2(80) | Name of the Department to which the request is assigned to
PRIORITY_CODE | NULLABLE | VARCHAR2(30) | Priority of the request
PRIORITY_NAME | NULLABLE | VARCHAR2(80) | Priority Name of the request
APPLICATION | NULLABLE | VARCHAR2(30) | Application code of the request
ASSIGNED_TO_USERNAME | NULLABLE | VARCHAR2(200) | Username assigned to this request
ASSIGNED_TO_USER_ID | NULLABLE | NUMBER | ID of the group assigned to this request
ASSIGNED_TO_GROUP_NAME | NULLABLE | VARCHAR2(30) | Name of the group assigned to this request
ASSIGNED_TO_GROUP_ID | NULLABLE | NUMBER | ID of the group assigned to this request
PROJECT_CODE | NULLABLE | VARCHAR2(30) | Request Group Code of the request
CONTACT_FIRST_NAME | NULLABLE | VARCHAR2(30) | First name of the contact for the request
CONTACT_LAST_NAME | NULLABLE | VARCHAR2(30) | Last name of the contact for the request
CONTACT_ID | NULLABLE | NUMBER | ID of the contact
RELEASED_FLAG | NOT NULL | VARCHAR2(1) | Release identifier
USER_DATA_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context identifier for the user data fields
USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
PARAMETER_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context identifier for the configurable parameters of the request
NOTES | NULLABLE | CLOB | Request notes
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Used to differentiate interface records by their point of origin
SOURCE | NULLABLE | VARCHAR2(100) | Denotes the external source of the request.
WORKFLOW_STEP_ID | NULLABLE | NUMBER | ID of the workflow step that becomes ELIGIBLE for user processing
COMPANY | NULLABLE | VARCHAR2(30) | Identifier for the company this request is associated with
DATA_LANG | NULLABLE | VARCHAR2(40) |

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_REQUESTS_INT_N1 | NONUNIQUE | 1 | GROUP_ID
KCRT_REQUESTS_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: