Share this page
KDEM_DEMANDS
This is a replication table. The demand field information in various tables are denormalized and stored in this table for improving query performance. There should be one record per request per demand set in this table.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KCRT_STATUSES_NLS |
STATUS_ID |
STATUS_ID |
|
KWFL_VERIFICATION_TEMP |
WORKFLOW_ID |
WORKFLOW_ID |
|
KWFL_WORKFLOWS_NLS |
WORKFLOW_ID |
WORKFLOW_ID |
|
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 |
|
KDEM_DEMAND_SETS |
DEMAND_SET_ID |
DEMAND_SET_ID |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KCRT_REQUESTS |
REQUEST_ID |
REQUEST_ID |
|
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
REQUEST_TYPE_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
DEMAND_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 |
|
DEMAND_SET_ID |
NOT NULL |
NUMBER |
Identifier for the set this demand belongs in |
|
REQUEST_ID |
NOT NULL |
NUMBER |
Identifier that identifies the request associated with the demand |
|
REQUEST_NUMBER |
NULLABLE |
VARCHAR2(30) |
Indicates the sequential request number identifier that the user sees. Value is retrieved from the request_id. |
|
REQUEST_TYPE_ID |
NULLABLE |
NUMBER |
Identifier that denotes what type of Request this record is. |
|
REQUEST_TYPE_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the type of request this record is |
|
REQUEST_SUBTYPE_ID |
NULLABLE |
NUMBER |
Identifier that denotes what type of sub-request this record is, if provided. |
|
REQUEST_SUBTYPE_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the type of sub-request this record is |
|
REQUEST_SUB_TYPE_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the type of sub-request this record is |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
Short description of the demand |
|
RELEASE_DATE |
NULLABLE |
DATE |
Date wherein this demand was released. |
|
STATUS_ID |
NULLABLE |
NUMBER |
Identifier for the current demand status. |
|
STATUS_NAME |
NULLABLE |
VARCHAR2(4000) |
Name of the status of the demand |
|
STATUS_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'WF_PARENT_STATUS' |
|
WORKFLOW_ID |
NULLABLE |
NUMBER |
Identifier for the workflow associated with this record. |
|
WORKFLOW_NAME |
NULLABLE |
VARCHAR2(80) |
Name of workflow associated with this record |
|
DEPARTMENT_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'DEPARTMENT'. |
|
DEPARTMENT_MEANING |
NULLABLE |
VARCHAR2(4000) |
Description of the department |
|
PRIORITY_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'PRIORITY'. |
|
PRIORITY_MEANING |
NULLABLE |
VARCHAR2(4000) |
Description of the priority |
|
APPLICATION |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'APPLICATION' |
|
APPLICATION_MEANING |
NULLABLE |
VARCHAR2(4000) |
Description of the application |
|
MODULE_MEANING |
NULLABLE |
VARCHAR2(4000) |
Description of the module |
|
ASSIGNED_TO_USER_ID |
NULLABLE |
NUMBER |
Identifier for the user wherein this request was assigned to. |
|
ASSIGNED_TO_USERNAME |
NULLABLE |
VARCHAR2(200) |
Name of the user wherein this demand was assigned to |
|
ASSIGNED_TO_GROUP_ID |
NULLABLE |
NUMBER |
Identifier for the security group wherein this demand was assigned to |
|
ASSIGNED_TO_GROUPNAME |
NULLABLE |
VARCHAR2(4000) |
Name of the security group wherein this demand was assigned to |
|
PROJECT_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup Code for 'REQUEST_GROUP' |
|
RELEASED_FLAG |
NULLABLE |
VARCHAR2(1) |
Flag to determine whether the demand is released |
|
CREATED_BY_USERNAME |
NULLABLE |
VARCHAR2(200) |
Resource who created this demand (in name form) |
|
PROJECT_NAME |
NULLABLE |
VARCHAR2(4000) |
Project name for this demand |
|
CONTACT_ID |
NULLABLE |
NUMBER |
Identifier that identifies the contact for this demand |
|
CONTACT_NAME |
NULLABLE |
VARCHAR2(200) |
Name of contact for the demand |
|
CONTACT_PHONE_NUMBER |
NULLABLE |
VARCHAR2(30) |
Phone number of contact for the demand |
|
CONTACT_EMAIL |
NULLABLE |
VARCHAR2(80) |
Email address of contact for the demand |
|
COMPANY_NAME |
NULLABLE |
VARCHAR2(4000) |
Company name for the demand |
|
COMPANY |
NULLABLE |
VARCHAR2(30) |
Identifier that identify which company this demand is associated with |
|
PERCENT_COMPLETE |
NULLABLE |
NUMBER |
Percent complete of demand |
|
SCHEDULE_DATE |
NULLABLE |
DATE |
Date demand was scheduled |
|
REJECT_DATE |
NULLABLE |
DATE |
Date demand was rejected |
|
EFFORT |
NULLABLE |
NUMBER |
Amount of effort for this demand |
|
DEMAND_SATISFIED_DATE |
NULLABLE |
DATE |
Date demand was satisfied |
|
SERVICE_REQUESTED_DATE |
NULLABLE |
DATE |
Date service was requested |
|
SLA_LEVEL_CODE |
NULLABLE |
VARCHAR2(30) |
Code lookup for Service Level Agreement |
|
SLA_LEVEL |
NULLABLE |
VARCHAR2(100) |
Actual Service Level Agreement for this demand |
|
VIOLATION_DATE |
NULLABLE |
DATE |
Date of violation |
|
SERVICE_SATISFIED_DATE |
NULLABLE |
DATE |
Date demand service was satisfied |
|
PARAMETER1-50 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
VISIBLE_PARAMETER1-50 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
ASSIGNED_TO_NAME |
NULLABLE |
VARCHAR2(80) |
Full name of the assigned to user |
|
CREATED_BY_NAME |
NULLABLE |
VARCHAR2(80) |
Full name of the created by user |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KDEM_DEMANDS_N2 |
NONUNIQUE |
1 |
DEMAND_SET_ID |
|
KDEM_DEMANDS_N2 |
NONUNIQUE |
2 |
PARAMETER2 |
|
KDEM_DEMANDS_N3 |
NONUNIQUE |
1 |
DEMAND_SET_ID |
|
KDEM_DEMANDS_N3 |
NONUNIQUE |
2 |
PARAMETER3 |
|
KDEM_DEMANDS_N4 |
NONUNIQUE |
1 |
DEMAND_SET_ID |
|
KDEM_DEMANDS_N4 |
NONUNIQUE |
2 |
PARAMETER4 |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KDEM_DEMANDS_S |
DEMAND_ID |
