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

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: