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.
