KCRT_REQUESTS
This table stores all the header information of a request.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_SECURITY_GROUPS_NLS |
SECURITY_GROUP_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_USERS |
USER_ID |
LAST_UPDATED_BY |
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 |
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
USER_DATA_SET_CONTEXT_ID |
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
WORKFLOW_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
REQUEST_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date a record in the entity was last updated |
REQUEST_NUMBER |
NOT NULL |
VARCHAR2(30) |
Indicates the sequential request number identifier that the user sees. Value is retrieved from the request_id |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Identifier that denotes what type of Request this record is |
REQUEST_SUBTYPE_ID |
NULLABLE |
NUMBER |
Identifier that denotes what type of sub-request this record is, if provided |
DESCRIPTION |
NULLABLE |
VARCHAR2(400) |
Short description of the selected request |
RELEASE_DATE |
NULLABLE |
DATE |
Date wherein this request was released |
STATUS_ID |
NOT NULL |
NUMBER |
Identifier for the current request status |
WORKFLOW_ID |
NULLABLE |
NUMBER |
Identifier for the workflow associated with this record |
DEPARTMENT_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'DEPARTMENT' |
PRIORITY_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'PRIORITY' |
APPLICATION |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'APPLICATION' |
ASSIGNED_TO_USER_ID |
NULLABLE |
NUMBER |
Identifier for the user wherein this request was assigned to |
ASSIGNED_TO_GROUP_ID |
NULLABLE |
NUMBER |
Identifier for the security group wherein this request was assigned to |
PROJECT_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup Code for 'REQUEST_GROUP' |
CONTACT_ID |
NULLABLE |
NUMBER |
Identifier for the contacts associated with this record |
COMPANY |
NULLABLE |
VARCHAR2(30) |
Identifier field for the Company this request is associated with |
UPDATED_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this record has been updated |
STATUS_CODE |
NOT NULL |
VARCHAR2(30) |
Lookup code for 'WF_PARENT_STATUS' |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on) |
SOURCE |
NULLABLE |
VARCHAR2(100) |
For records that have been updated by an interface or migrator, provides additional information about the source of the external update |
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 |
PERCENT_COMPLETE |
NOT NULL |
NUMBER |
Percent complete of this request (100 if the request is closed) |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_REQUESTS_N1 |
NONUNIQUE |
1 |
REQUEST_TYPE_ID |
KCRT_REQUESTS_N2 |
NONUNIQUE |
1 |
WORKFLOW_ID |
KCRT_REQUESTS_N3 |
NONUNIQUE |
1 |
ASSIGNED_TO_USER_ID |
KCRT_REQUESTS_N4 |
NONUNIQUE |
1 |
ASSIGNED_TO_GROUP_ID |
KCRT_REQUESTS_N5 |
NONUNIQUE |
1 |
STATUS_ID |
KCRT_REQUESTS_N6 |
NONUNIQUE |
1 |
APPLICATION |
KCRT_REQUESTS_N7 |
NONUNIQUE |
1 |
RELEASE_DATE |
KCRT_REQUESTS_N8 |
NONUNIQUE |
1 |
CREATED_BY |
KCRT_REQUESTS_N9 |
NONUNIQUE |
1 |
LAST_UPDATE_DATE |
KCRT_REQUESTS_N10 |
NONUNIQUE |
1 |
CREATION_DATE |
KCRT_REQUESTS_U1 |
UNIQUE |
1 |
REQUEST_ID |
KCRT_REQUESTS_U2 |
UNIQUE |
1 |
REQUEST_NUMBER |
Sequences
Sequence Name |
Sequence Type |
---|---|
KCRT_REQUESTS_S |
REQUEST_ID |