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 DEPARTMENT

Yes

DEPARTMENR_NAME

Nullable

VARCHAR (150)

Indicates the department name related to this request

Yes

PRIORITY_CODE

Nullable

VARCHAR (30)

Lookupcode for PRIORITY

No

PRIORITY_NAME

Nullable

VARCHAR (150)

Indicates the priority name related to this request

No

APPLICATION

Nullable

VARCHAR (30)

Lookup code for APPLICATION

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 REQUEST_GROUP

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 WF_ PARENT_STATUS

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

Contnet 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