Aconex - Mails
Description: The data displayed in the Aconex - Mails subject area, and in any out-of-the-box or custom dashboard is based on the projects that you have access in Aconex.
Use the Aconex - Mails subject area to discover information such as (but not limited to):
- Identify existing red flags on your projects like delayed correspondences
- Identify the most/least active organizations based on mail correspondences/responses
- Compare and analyze mail activity across the project portfolio
- Track KPIs, view mail details, etc.
You can also create your own data sets and/or data flows to:
- Implement custom logic to get deeper insights like Avg. RFI turnaround time, and Mails overdue.
- Achieve custom dashboard requirements using Mail Project Fields
Subject Area: Aconex - Mails
| Folder | SubFolder | Field Name | Dimension/ Fact | Description |
|---|---|---|---|---|
| Project General (Project) | ||||
| Project | General (Project) | Project Name | Dimension | Displays a list of all projects that the logged in user has access to in Aconex. |
| Project | General (Project) | Datasource Id | Dimension | Datasource Id |
| Project | General (Project) | Project Id | Dimension | The unique ID of the project in Aconex. |
| Mails General - (Mails) | ||||
| Mails | General - (Mails) | Mail Unique ID | Dimension | The unique ID of the mail in Aconex. |
| Mails | General - (Mails) | Mail Type | Dimension | Mail Type |
| Mails | General - (Mails) | Mail Number | Dimension | Mail number in Aconex |
| Mails | General - (Mails) | Mail Status | Dimension | Shows the status of a mail sent. If a custom configured status is not available then it shows the standard status like Outstanding, Overdue, Responded or Closed-Out. Overdue mail is determined when a mail expecting a response which is currently in either Partial or Outstanding state has breached the due date. |
| Mails | General - (Mails) | Response Required | Dimension | Indicates if the mail requires a response. It's 'Y' if a mail has a response required date. |
| Mails | General - (Mails) | Subject | Dimension | Mail subject |
| Mails | General - (Mails) | Reason for Issue | Dimension | The reason the mail was sent for approval. |
| Mails | General - (Mails) | My Organization | Dimension | The logged-in user's organization name. |
| Mails | General - (Mails) | To User | Dimension | The name of the recipient. |
| Mails | General - (Mails) | To Organization | Dimension | Mail recipient's organization name |
| Mails | General - (Mails) | From User | Dimension | Mail sender's name. |
| Mails | General - (Mails) | From Organization | Dimension | Mail sender's organization name. |
| Mails | General - (Mails) | Recipient Type | Dimension | Indicates if the user was in the To or Cc list of this mail. |
| Mails | General - (Mails) | Reply Type | Dimension | Indicates if the mail was a Response, Forward, or Original type. |
| Mails | General - (Mails) | Parent Id | Dimension | Parent ID is used to show/identify the initial mail and its responses. Mail Unique ID of the initial mail is the Parent ID for all its reply mail(s). |
| Mails | General - (Mails) | Reference Number | Dimension | A unique number assigned to the initial mail in an email thread. The same reference number applies to all mails within an email thread. |
| Mails | General - (Mails) | Attribute 1 | Dimension | A dynamic attribute that can be relabeled on given project as required |
| Mails | General - (Mails) | Attribute 2 | Dimension | A dynamic attribute that can be relabeled on given project as required |
| Mails | General - (Mails) | Attribute 3 | Dimension | A dynamic attribute that can be relabeled on given project as required |
| Mails | General - (Mails) | Attribute 4 | Dimension | A dynamic attribute that can be relabeled on given project as required |
| Mails | General - (Mails) | Closed Out By User | Dimension | Name of the user who closed out the mail. |
| Mails | General - (Mails) | Closed Out By Org | Dimension | The name of the organization of the user who closed out the mail. |
| Mails Dates - (Mails) | ||||
| Mails | Dates - (Mails) | Read Date | Dimension | The date on which the mail recipient read the Mail. |
| Mails | Dates - (Mails) | Due Date | Dimension | Response required date for the particular mail |
| Mails | Dates - (Mails) | Sent Date | Dimension | Mail sent date |
| Mails | Dates - (Mails) | Update Date | Dimension | The last time that the mail was modified or an action was taken on it, such as a mail status change, a draft mail is sent, or a mail waiting for approval is approved. |
| Mails | Dates - (Mails) | Closed Out Date | Dimension | The date on which the mail was closed out. |
| Mails | Dates - (Mails) | Responded Date | Dimension | The most recent date when a response was sent or received for a correspondence. |
| Project Fields | Text (Common) |
The contents of this folder depend on the project fields selected by your organization in the CIC Administration application. A maximum of 50 Aconex project fields (common + non-common) of Text data type, common to several projects, can be displayed. Contact your CIC Administrator if you want to include or exclude any project fields in CIC to create your custom dashboard. |
||
| Project Fields | Date (Common) |
The contents of this folder depend on the project fields selected by your organization in the CIC Administration application. A maximum of 50 Aconex project fields (common + non-common) of Date data type, common to several projects, can be displayed. Contact your CIC Administrator if you want to include or exclude any project fields in CIC to create your custom dashboard. |
||
| Project Fields | Number (Common) |
The contents of this folder depend on the project fields selected by your organization in the CIC Administration application. A maximum of 50 Aconex project fields (common + non-common) of Number data type, common to several projects, can be displayed. Contact your CIC Administrator if you want to include or exclude any project fields in CIC to create your custom dashboard. |
||
| Project Fields | Text (Non-Common) |
The contents of this folder depend on the project fields selected by your organization in the CIC Administration application. A maximum of 50 Aconex project fields (common + non-common) of Text data type, specific to individual projects, can be displayed. Contact your CIC Administrator if you want to include or exclude any project fields in CIC to create your custom dashboard. |
||
| Project Fields | Date (Non-Common) |
The contents of this folder depend on the project fields selected by your organization in the CIC Administration application. A maximum of 50 Aconex project fields (common + non-common) of Date data type, specific to individual projects, can be displayed. Contact your CIC Administrator if you want to include or exclude any project fields in CIC to create your custom dashboard. |
||
| Project Fields | Number (Non-Common) |
The contents of this folder depend on the project fields selected by your organization in the CIC Administration application. A maximum of 50 Aconex project fields (common + non-common)of Number data type, specific to individual projects, can be displayed. Contact your CIC Administrator if you want to include or exclude any project fields in CIC to create your custom dashboard. |
||
| Files | General - (Files) | Files are attached in mails other than type transmittals. Use Files to know about attachments in mail types other than transmittals. | ||
| Files | General - (Files) | File Unique Id | Dimension | The Unique ID of a file. |
| Files | General - (Files) | File Name | Dimension | Name of given file. |
| Files | General - (Files) | File Size | Dimension | The file size attached in the mail. |
| Files | General - (Files) | File Type | Dimension | The file type attached in the mail. |
| Documents General - (Documents) | ||||
| Documents | General - (Documents) | Document Number | Dimension | Code number of the document in the document register |
| Documents | General - (Documents) | Document Type | Dimension | Document Type |
| Documents | General - (Documents) | Document Discipline | Dimension | Document Discipline |
| Documents | General - (Documents) | Document Title | Dimension | Document title |
| Documents | General - (Documents) | Document Revision | Dimension | Revision(s) associated with the given doc in the doc register. |
| Documents | General - (Documents) | Document Version | Dimension | Version(s) associated with given doc in the doc register. |
| Fact - Aconex Mails Fact - Mails | ||||
| Fact - Aconex Mails | Fact - Mails | # of Distinct Mails (Sent + Inbox) | Fact |
A distinct count of mails, sent and received by logged-in user's organization.
|
| Fact - Aconex Mails | Fact - Mails | # of Mails (Sent) | Fact |
Distinct count of mails, sent by logged in user's org.
|
| Fact - Aconex Mails | Fact - Mails | # of Mails (Inbox) | Fact |
Distinct count of mails, received by logged in user's org.
|
| Fact - Aconex Mails | Fact - Mails | # of Registered Documents Attached (Transmittal) | Fact |
A distinct count of attached documents in all mails sent and received (of type transmittals) by logged-in user's organization.
|