Blue Relay Support Desk

Unique ID for an activity actioned against an item 

User ID that took the action. Include the User cube for more information (ie name or email) 

The time the action was taken 

High level action that was taken against an Item -> Created, Modified, Deleted, Child_Created (ie child file added), and Child_Deleted. For cases of Workflow actions -> Completed, Due, Activated. 
NOTE: Task history details are found in the Task Dimension.  

The action MODIFIED requires more information to specify Renamed or Description changed. 

Specifies the Activity’s object type -> Tag, Attribute, Comment, Workflow, Status, Item 

Attribute name. 

Attribute’s value. 

User that created the attribute 

Username that created the attribute. To see more information about the creator, include the User dimension.  

Readable date format (YYYY-MM-DD) for when the attribute was created. 

Timestamp format of created date 

Readable date format (YYYY-MM-DD) for when the attribute was last modified. 

Text of the written comment  

User that wrote the comment 

Readable date format (YYYY-MM-DD) for when it was created. 

Timestamp format of created date 

Readable date format (YYYY-MM-DD) for when it was last modified. 

System ID for the specific form answer 

Form template name 

Full name of the user who submitted the form. 

Readable date format (YYYY-MM-DD) for when it was submitted 

Full timestamp of the submitted date 

Answer to question 1 of the form 

General representation of all other question columns from Q1-Q66 

Automatic system ID assigned on User creation 

Usually contains email. Dependent on the data entered in the “Username” field on user setup. 

First and last name of the user 

Indicates if the user is Active, Locked, Invited, Forgotten Password, or part of a Locked Company. Invited users indicate users that have not logged in. 

User’s first name 

User’s middle name 

ID of the item 

Title of the file, folder, or form. 

Optional description field  

Item status 

File Revisions – applicable to files only  

Indicates if it is a Form, Folder, or File. 

File version 

User ID of the creator 

Name of the creator. More information available via User dimension. 

Readable date format (YYYY-MM-DD) for when the item was created. 

Timestamp format of created date 

Readable date format (YYYY-MM-DD) for when the item was last modified. 

Item ID of the Project 

Title of the Project, Request Form q1 

Project Requestor – full name 

Department of the requestor, based on the department attribute of the user 

Request Form Question 2 

Question 3 

Question 4 

Full name of the Project Developer, calculated via user id found in question 25. 

Department of the developer. This is an attribute on the user profile. 

Full name of the project owner. Calculated via ownerId in question 6. 

Department of the owner. Attribute on the user profile. 

Question 7 

Question 8 

Question 9 

Question 10 

Question 11 

Question 12 

Question 14 

Question 15 

Question 16 

Question 17, in readable date format (YYYY-MM-DD).  

Question 17, in a detailed timestamp format that can be used as a Time dimension filter. 

Question 18, in readable date format (YYYY-MM-DD).  

Question 18, in a detailed timestamp format that can be used as a Time dimension filter. 

Question 19 

Question 22 

Question 32 

Question 34 

Question 35 

Question 36 

Question 37 

Question 38 

A calculation of what Workflow applied to this project, based on the dataset Workflow Duration Calculator, uploaded to the BR instance. 

A client-directed summation of days the project was on a specific workflow, based on the Workflow Duration Calculator data. 

A client-directed summation of days the project was on a specific workflow, based on the Workflow Duration Calculator data. 

A client-directed summation of days the project was on a specific workflow, based on the Workflow Duration Calculator data. 

A client-directed calculation based on the value of Request Type: 
CASE  

            WHEN LOWER(${CUBE.requestType}) IN ( 
           'aep anoc', 

            'aep eoc', 

            'aep sb', 

            'change pages & p/a updates', 

            'directories', 

            'group aep eoc', 

            'group aep eoc book', 

            'group aep template', 

            'mpsers aep anoc', 

            'mpsers aep eoc', 

            'mpsers aep sb', 

            'monthly formularies', 

            'som aep anoc', 

            'som aep baag', 

            'som aep eoc', 

            'yearly formulary updates') 

          THEN 'Yes' 

          ELSE 'No' 

        END 

A client-directed calculation based on the value of Request Exception: 
 
CASE  

          WHEN LOWER(${CUBE.rushException}) = 'yes' THEN 'No' 

          WHEN ${CUBE.daysToComplete} > ${CUBE.totalDaysNoEdits} THEN 'No' 

          ELSE 'Yes' 

END 
 

A client-directed calculation: 
 
CASE  

          WHEN LOWER(${CUBE.rushException}) = 'yes' AND ${CUBE.daysToComplete} < ${CUBE.totalDaysNoEdits}  
         THEN 'Yes' 

          ELSE 'No' 

END 

A client-directed calculation: 
 
CASE  

          WHEN LOWER(${CUBE.rushOverride}) = 'yes' THEN 'Planned' 

          ELSE 'Not Planned' 

END 
 

Readable date format (YYYY-MM-DD) for created date. 

Timestamp format of created date 

Project status (item status) 

Automatic system ID of the tag 

ID of the Item the Tag was created against. 

Value of the tag 

Readable date format (YYYY-MM-DD) for when it was created. 

Timestamp format of created date 

Readable date format (YYYY-MM-DD) for when it was last modified. 

Automatic system ID of the task instance 

Task Subject 

ID of the Item that the task is for 

Task Description 

Task status -> Active, Completed, Skipped. 

Hours elapsed between Activation Date and Termination Date, rounded to 1 decimal place.  

Days elapsed between Activation Date and Termination Date, rounded to 0 decimal places. 

Time the task was activated 

Readable date format (YYYY-MM-DD) of the above. 

Time the task was terminated  

Readable date format (YYYY-MM-DD) of the above. 

Time the task was/is due 

Readable date format (YYYY-MM-DD) of the above. 

Instance ID of the task’s calling Workflow  

Name of the calling  workflow 

Automatic system ID assigned on User creation 

Usually contains email. Dependent on the data entered in the “Username” field on user setup. 

First and last name of the user 

Indicates if the user is Active, Locked, Invited, Forgotten Password, or part of a Locked Company. Invited users indicate users that have not logged in. 

User’s first name 

User’s middle name 

User’s last name 

Readable date format (YYYY-MM-DD) for when the user was created. 

Automatic system ID assigned on department/attribute assignment. 

Automatic system ID of the workflow instance 

Workflow title  

ID of the Item that the workflow is for 

Specify if this is a boxcar or parent workflow  

Workflow template description 

Status of the workflow: Active, Completed, Skipped. 

Hours elapsed between Activation Date and Termination Date, rounded to 1 decimal place.  

Days elapsed between Activation Date and Termination Date, rounded to 0 decimal places.  

Time the workflow was activated 

Readable date format (YYYY-MM-DD) of the above. 

Time the Workflow  was terminated  

Readable date format (YYYY-MM-DD) of the above. 

Time the Workflow was/is due 

Readable date format (YYYY-MM-DD) of the above. 

If this is a boxcar, this field will contain the calling/parent workflow instance ID 

Empty unless this Workflow is a boxcar, then this field will contain the calling workflow name 

Used for Time Dimension report filtering. Not all tasks are activated, thus do not have activation dates above. 

Automatic system ID of the workflow. Would be seen on the workflow setup page in Blue Relay 

Workflow title  

Workflow template description 

Indicates if this workflow is enabled or not as per the setting configuration on the Workflow Template in Blue Relay. 

ID of the user that created the Workflow 

Username of the creator (linked from the User table) 

Timestamp of when the Workflow was created, usable by Time Dimension filter 

Readable date format (YYYY-MM-DD) of the above. Cannot be used in Time Dimension filter. 

Timestamp of when the workflow was last modified.