Share this page
DIM_REQUESTS
This table stores all the information of a request.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
DIM_PERSON |
ASSIGNED_TO_USER_ID |
PK_PERSON_ID |
|
DIM_CONTACTS |
CONTACT_ID |
PK_ CONTACT_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
SCD2 |
|---|---|---|---|---|
|
PK_REQUESTS_ID |
Nullable |
INT |
System-generated identifier
|
No |
|
MD_BUSINESS_KEY |
Nullable |
VARCHAR (1000) |
Primary key that is mapped to one or more source columns
|
No |
|
MD_ENTERPRISE_KEY |
Nullable |
INT |
Unique identifier for entity |
No |
|
REQUEST_NUMBER |
Nullable |
VARCHAR (30) |
Indicates the sequential request number identifier that the user sees. Value is retrieved from the REQUEST_ID. |
No |
|
REQUEST_TYPE_ID |
Nullable |
INT |
Identifier that denotes what type of request this record is |
Yes |
|
REQUEST_TYPE_NAME |
Nullable |
VARCHAR (80) |
Indicates the request type name of this request |
Yes |
|
REQUEST_SUBTYPE_ID |
Nullable |
INT |
Identifier that denotes what type of sub-request this record is, if provided. |
Yes |
|
REQUEST_SUBTYPE_NAME |
Nullable |
VARCHAR (80) |
Indicates the request subtype name of this request |
Yes |
|
REQUEST_DESCRIPTION |
Nullable |
VARCHAR (400) |
Short description of the selected request |
No |
|
RELEASE_DATE |
Nullable |
DATE |
Date wherein this request was released |
No |
|
REQUEST_STATUS_ID |
Nullable |
INT |
Identifier for the current request status |
No |
|
REQUEST_STATUS_NAME |
Nullable |
VARCHAR (80) |
Indicates the request status name of this request |
No |
|
WORKFLOW_ID |
Nullable |
INT |
Identifier for the workflow associated with this record |
No |
|
WORKFLOW_NAME |
Nullable |
VARCHAR (150) |
Indicates the workflow name of this request |
No |
|
DEPARTMENT_CODE |
Nullable |
VARCHAR (30) |
Lookup code for |
Yes |
|
DEPARTMENR_NAME |
Nullable |
VARCHAR (150) |
Indicates the department name related to this request |
Yes |
|
PRIORITY_CODE |
Nullable |
VARCHAR (30) |
Lookup code for |
No |
|
PRIORITY_NAME |
Nullable |
VARCHAR (150) |
Indicates the priority name related to this request |
No |
|
APPLICATION |
Nullable |
VARCHAR (30) |
Lookup code for |
Yes |
|
APPLICATION_NAME |
Nullable |
VARCHAR (150) |
Indicates the application name related to this request |
Yes |
|
ASSIGNED_TO_USER_ID |
Nullable |
INT |
Identifier for the user wherein this request was assigned to |
Yes |
|
ASSIGNED_TO_USER_ BUSINESS_KEY |
Nullable |
VARCHAR (1000) |
Foreign key that is mapped to DIM_PERSON
|
Yes |
|
ASSIGNED_TO_USER_ ENTERPRISE_KEY |
Nullable |
INT |
Unique identifier for foreign key
|
Yes |
|
ASSIGNED_TO_USER_ NAME |
Nullable |
VARCHAR (200) |
Indicates the user name of this request assign to |
Yes |
|
ASSIGNED_TO_GROUP_ID |
Nullable |
INT |
Identifier for the security group wherein this request was assigned to |
Yes |
|
ASSIGNED_TO_GROUP_ NAME |
Nullable |
VARCHAR (150) |
Indicates the group name of this request assign to |
Yes |
|
PROJECT_CODE |
Nullable |
VARCHAR (30) |
Indicates the project code related to request. Lookup code for |
No |
|
PROJECT_CODE_NAME |
Nullable |
VARCHAR (150) |
Indicates the project code name related to request
|
No |
|
CONTACT_ID |
Nullable |
INT |
Identifier for the contacts associated with this record |
No |
|
CONTACT_BUSINESS_KEY |
Nullable |
VARCHAR (1000) |
Foreign key that is mapped to DIM_CONTACTS
|
No |
|
CONTACT_ENTERPRISE_ KEY |
Nullable |
INT |
Unique identifier for foreign key
|
No |
|
CONTACT_NAME |
Nullable |
VARCHAR (200) |
Indicates the contact name related to request
|
No |
|
STATUS_CODE |
Nullable |
VARCHAR (30) |
Lookup code for |
No |
|
STATUS_NAME |
Nullable |
VARCHAR (150) |
Indicates the status name of this request
|
No |
|
USER_DATA_SET_ CONTEXT_ID |
Nullable |
INT |
Parameter set context identifier for the user data fields |
Yes |
|
USER_DATA1-20 |
Nullable |
VARCHAR (200) |
User data segment |
No |
|
VISIBLE_USER_DATA1-20 |
Nullable |
VARCHAR (200) |
User data segment |
No |
|
PERCENT_COMPLETE |
Nullable |
NUMERIC |
Percentage of completion of this request (100 if the request is closed) |
No |
|
MD_BATCH_ID |
Nullable |
INT |
ID of data batch |
No |
|
MD_PROCESS_ID |
Nullable |
INT |
ID of ETL process running on a specific task |
No |
|
MD_SOURCE_INSTANCE_ ID |
Nullable |
INT |
Content pack ID of source instance |
No |
|
MD_CREATEDDATE |
Nullable |
DATETIME |
Date of the record being inserted |
No |
|
MD_DELETEDDATE |
Nullable |
DATETIME |
Date of the record being deleted |
No |
|
MD_LASTMODDATE |
Nullable |
DATETIME |
Date of the record being updated |
No |
|
MD_TRANSLASTIND |
Nullable |
VARCHAR (1) |
Flags whether it is the latest record after updated by SCD2 |
No |
|
MD_TRANSENDDATE |
Nullable |
DATETIME |
End date of the record being effective |
No |
|
MD_ACTIVESTATUSIND |
Nullable |
VARCHAR (1) |
Flags whether or not the old record is deleted |
No |
|
MD_HASH_CODE_SCD1 |
Nullable |
VARCHAR (40) |
(Only for dimension table) Hash code that is generated by SCD1 columns |
No |
|
MD_HASH_CODE_SCD2 |
Nullable |
VARCHAR (40) |
(Only for dimension table) Hash code that is generated by SCD2 columns |
No |
Projections
This table uses no projections.
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
REQUESTS_ENTERPRISE_XREF_SEQ |
MD_ENTERPRISE_KEY |
|
REQUESTS_KEY_LOOKUP_SEQ |
PK_ REQUESTS_ID |
|
PERSON_ENTERPRISE_XREF_SEQ |
PERSON_ENTERPRISE_KEY |
|
PERSON_KEY_LOOKUP_SEQ |
PERSON_ID |
|
CONTACTS_ENTERPRISE_XREF_SEQ |
CONTACT_ENTERPRISE_KEY |
|
CONTACTS_KEY_LOOKUP_SEQ |
CONTACT_ID |
