Skip to main content

User Dataset Specification

Updated over a month ago

User Dataset Specification

User Dataset Specification

The "User Dataset Specification" holds Care Intelligence user details, including roles assigned. Its unique key is User_ID. It is referenced by root-level Transaction_User_ID and other User_ID fields like Author_User_ID, Void_User_ID, etc. It has references to managed and viewed departments as well as to viewed other users. It includes references to assigned roles by Role_Code.

Key Components of the Dataset

User Profiles

  • Stores detailed information about each user, including personal details, contact information, and organizational affiliations.

  • Helps in identifying users and customizing their experience based on their profile attributes.

User Roles

  • Contains data on the roles assigned to each user, defining access levels and permissions within the system.

  • Ensures that users have appropriate access to resources pertinent to their roles.

Assigned Pages

  • Tracks which parts of the system each user can access, aligning with their roles and responsibilities.

  • Helps in managing user navigation and usability within the system.

Login Sessions

  • Captures details about each user's login sessions, including session duration, login times, and activity logs.

  • Vital for security audits and operational monitoring.

Logs

  • Provides a record of user actions and changes within the system.

  • Offers an audit trail that enhances security and compliance.

Raw Data for Users and Their Sessions

  • Contains unprocessed, detailed data related to users and their interactions with the system.

  • Crucial for deep analysis, troubleshooting, and refining user management strategies.

This dataset is essential for organizations looking to efficiently manage user data and ensure robust system security, supporting comprehensive insights into user activities and system access controls.

Table: User

Column Name

Is Nullable

Data Type

Description

User_ID

YES

STRING

Unique identifier for each user in the system.

User_Name

YES

STRING

Name of the user.

System_User

YES

BOOL

Indicator specifying whether the user is a system user.

Time_Zone_Code

YES

STRING

Code representing the time zone associated with the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

Time_Zone_Abbreviation

YES

STRING

Abbreviation for the time zone associated with the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

Time_Zone_System_Code

YES

STRING

Code representing the time zone system used by the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

Time_Zone_Name

YES

STRING

Name of the time zone associated with the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

Active

YES

BOOL

Indicator specifying whether the user account is active.

Initials

YES

STRING

Initials of the user.

Title

YES

STRING

Title or designation of the user.

Phone_Number

YES

STRING

Phone number associated with the user.

Mobile_Number

YES

STRING

Mobile number associated with the user.

Email_Address

YES

STRING

Email address of the user.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user account was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user account was last modified.

Owner_Key

YES

INT64

Key identifying the owner of the user account.

Owner_Type

YES

STRING

The type of owner associated with the user account is determined as follows: If the User_Owner_ID is not null, the owner type is 'INDV', which corresponds to individual users.

Owner_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the owner of the user account was created.

Owner_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the owner of the user account was last modified.

Transaction_User_ID

YES

STRING

Unique identifier for the user who performed the transaction related to the user account.

Transaction_User_Name

YES

STRING

Name of the user who performed the transaction related to the user account.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record associated with the user account was last modified.

Table: User Assigned Department Home Pages

Column Name

Is Nullable

Data Type

Description

User_ID

YES

STRING

Unique identifier for each user in the system.

User_Name

YES

STRING

Name of the user.

Active_User

YES

BOOL

Indicator specifying whether the user account is active.

Department_Owner_Key

YES

INT64

Key identifying the owner of the department.

Department_ID

YES

STRING

Identifier for the department associated with the user's assigned home page.

Department_Name

YES

STRING

Name of the department associated with the user's assigned home page. This value is derived from the Department_Name field in the Department table.

Active_Department

YES

BOOL

Indicator specifying whether the department associated with the user's assigned home page is active. This value is derived from the Active field in the Department table.

Department_Member

YES

BOOL

Indicator specifying whether the user is a department member.

Department_Manager

YES

BOOL

Indicator specifying whether the user is a department manager.

Department_Member_

YES

BOOL

(Incomplete field description provided in the source content.)

User Dataset Specification

User Assigned Department Home Pages

Columns and Descriptions

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was created.

  • Department_Manager_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's role as a department manager was created.

  • Department_Member_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was last modified.

  • Department_Manager_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's role as a department manager was last modified.

  • Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Department_Manager_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a manager.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the department home page assignment.

  • Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who performed the transaction related to the department home page assignment.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the user's assigned department home page was last modified.

User Assigned Individual Home Pages

Columns and Descriptions

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each user in the system.

  • User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user.

  • Active_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user account is active.

  • Home_Page_User_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and their assigned individual home page.

  • Home_Page_User_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the individual home page.

  • Home_Page_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the individual home page associated with the user.

  • Home_Page_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or title of the individual home page associated with the user.

  • Home_Page_Active_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the individual home page associated with the user is active.

  • Home_Page_User_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was created.

  • Home_Page_User_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the assignment of the individual home page.

  • Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who performed the transaction related to the assignment of the individual home page.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the user's assigned individual home page was last modified.

User Roles

Columns and Descriptions

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each user in the system.

  • User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user.

  • Active_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user account is active.

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the role assigned to the user.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role assigned to the user.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the assignment of roles to the user.

  • Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who performed the transaction related to the assignment of roles to the user.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the user roles was last modified.

User Role Permission Criteria

Columns and Descriptions

  • Permission_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each permission or authorization associated with a role or user.

  • Criteria_Assignment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key associated with the assignment of criteria to a specific role or user.

  • Criteria_Assignment_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria assignment was created.

  • Criteria_Assignment_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria assignment.

  • Criteria_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific criteria or condition.

  • Criteria_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a group or category of related criteria.

  • Criteria_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the criteria group (e.g., purpose, context, or usage).

  • Criteria_Group_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator (e.g., Yes/No) whether the criteria group is active or relevant.

  • Criteria_Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID associated with the transaction or action related to the criteria.

  • Criteria_Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who performed the transaction related to the criteria.

  • Criteria_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria was created.

  • Criteria_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria.

User Dataset Specification

User Role Permission Criteria

Columns

  • Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria.

  • Criteria_Operator_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the operator used in the criteria (e.g., equal, greater than, contains).

  • Criteria_Operator_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value associated with the operator in the criteria (e.g., specific role name, numeric threshold).

  • Criteria_Operator_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria operator was created.

  • Criteria_Operator_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria operator.

  • Criteria_Element_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific element or attribute within the criteria.

  • Criteria_Element_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the criteria element (e.g., role, user, permission).

  • Criteria_Element_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the criteria element class (e.g., role, user, permission).

  • Criteria_Element_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label of the specific criteria element (e.g., role name, user ID).

  • Criteria_Element_Display_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display name or user-friendly label for the criteria element.

  • Criteria_Element_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria element was created.

  • Criteria_Element_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria element.

User Role Permission Criteria Values

Columns

  • Criteria_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific criteria or condition.

  • Criteria_Value_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key associated with a specific value or setting related to the criteria.

  • Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The actual value or setting associated with the criteria (e.g., role name, numeric threshold).

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description or details related to the criteria value.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria value was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria value.

User Role Permissions

Columns

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific user role within the system.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description or name of the user role (e.g., “Administrator,” “Analyst,” etc.).

  • Permission_Grant_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key associated with the grant of permissions to a specific role.

  • Permission_Grant_Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who granted the permissions.

  • Permission_Grant_Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who granted the permissions.

  • Permission_Grant_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission grant was created.

  • Permission_Grant_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the permission grant.

  • Permission_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific permission or authorization.

  • Permission_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label of the specific permission (e.g., “Read,” “Write,” “Execute”).

  • Permission_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the purpose or scope of the permission (e.g., “Access patient records”).

  • Permission_Active_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission became active.

  • Permission_Inactive_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission was deactivated or revoked.

  • Permission_Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator (e.g., Yes/No) whether the permission is currently active.

  • Permission_Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who modified the permission.

  • Permission_Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who modified the permission.

  • Permission_View_Only

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator (e.g., Yes/No) whether the permission allows view-only access.

  • Permission_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission was created.

  • Permission_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the permission.

  • Permission_Resource_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific resource associated with the permission.

  • Permission_Resource_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the resource (e.g., “Patient Records,” “Billing Data”).

  • Permission_Resource_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the resource class (e.g., “Medical Records,” “Financial Data”).

  • Permission_Resource_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label of the specific resource (e.g., “Patient Record Access,” “Billing Report”).

  • Permission_Resource_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional details or context related to the resource (e.g., “View patient history”).

  • Permission_Resource_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the resource was created.

  • Permission_Resource_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the resource.

User Role Log

Columns

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the role.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role.

User Dataset Specification

User Role Log Fields

General Fields

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the role was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the role was last modified.

  • Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the record was last modified in the system.

  • Transaction_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the user who performed the transaction.

  • Deleted_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator if the record is deleted.

  • Type

  • Type: STRING

  • Required: YES

  • Description: Type of the user role.

  • Tenant

  • Type: STRING

  • Required: YES

  • Description: Identifier for the tenant or client.

  • Active_Version

  • Type: BOOL

  • Required: YES

  • Description: Indicates the active version of the record.

  • Date

  • Type: DATE

  • Required: YES

  • Description: Date of the user role log entry.

  • Sequence

  • Type: INT64

  • Required: YES

  • Description: Sequence number of the user role log entry.

  • Source_System_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the source system.

  • Source_Timestamp

  • Type: STRING

  • Required: YES

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the source file.

Permissions

  • Permissions

  • Type: ARRAY

  • Required: NO

  • Description: Permissions associated with the role.

Permissions Fields

  • Grant_Key

  • Type: INT64

  • Required: NO

  • Description: Key for the permission grant.

  • Grant_Transaction_User_ID

  • Type: STRING

  • Required: NO

  • Description: Identifier for the user who granted the permission.

  • Grant_Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the permission was granted.

  • Grant_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the permission grant was last modified.

  • Key

  • Type: INT64

  • Required: NO

  • Description: Key for the permission.

  • Name

  • Type: STRING

  • Required: NO

  • Description: Name of the permission.

  • Description

  • Type: STRING

  • Required: NO

  • Description: Description of the permission.

  • Active_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the permission became active.

  • Inactive_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the permission became inactive.

  • Transaction_User_ID

  • Type: STRING

  • Required: NO

  • Description: Identifier for the user who performed the transaction.

  • View_Only

  • Type: BOOL

  • Required: NO

  • Description: Indicates if the permission is view-only.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the permission was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the permission was last modified.

Resource

  • Resource

  • Type: STRUCT

  • Required: NO

  • Description: Resource associated with the permission.

Resource Fields

  • Key

  • Type: INT64

  • Required: NO

  • Description: Key for the resource.

  • Class

  • Type: STRING

  • Required: NO

  • Description: Class of the resource.

  • Class_Description

  • Type: STRING

  • Required: NO

  • Description: Description of the resource class.

  • Name

  • Type: STRING

  • Required: NO

  • Description: Name of the resource.

  • Description

  • Type: STRING

  • Required: NO

  • Description: Description of the resource.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the resource was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the resource was last modified.

Criteria

  • Criteria

  • Type: ARRAY

  • Required: NO

  • Description: Criteria associated with the permission.

Criteria Fields

  • Assignment_Key

  • Type: INT64

  • Required: NO

  • Description: Key for the criteria assignment.

  • Assignment_Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the criteria assignment was created.

  • Assignment_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the criteria assignment was last modified.

  • Key

  • Type: INT64

  • Required: NO

  • Description: Key for the criteria.

  • Group_Code

  • Type: STRING

  • Required: NO

  • Description: Code for the criteria group.

  • Group_Description

  • Type: STRING

  • Required: NO

  • Description: Description of the criteria group.

  • Group_Indicator

  • Type: BOOL

  • Required: NO

  • Description: Indicator for the criteria group.

  • Transaction_User_ID

  • Type: STRING

  • Required: NO

  • Description: Identifier for the user who performed the transaction.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the criteria was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the criteria was last modified.

Operator

  • Operator

  • Type: STRUCT

  • Required: NO

  • Description: Operator for the criteria.

Operator Fields

  • Code

  • Type: STRING

  • Required: NO

  • Description: Code for the operator.

  • Value

  • Type: STRING

  • Required: NO

  • Description: Value for the operator.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the operator was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the operator was last modified.

Element

  • Element

  • Type: STRUCT

  • Required: NO

  • Description: Element associated with the criteria.

Element Fields

  • Key

  • Type: INT64

  • Required: NO

  • Description: Key for the element.

  • Class

  • Type: STRING

  • Required: NO

  • Description: Class of the element.

  • Class_Description

  • Type: STRING

  • Required: NO

  • Description: Description of the element class.

  • Name

  • Type: STRING

  • Required: NO

  • Description: Name of the element.

  • Display_Name

  • Type: STRING

  • Required: NO

  • Description: Display name of the element.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the element was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the element was last modified.

Values

  • Values

  • Type: ARRAY

  • Required: NO

  • Description: Values associated with the criteria.

Values Fields

  • Key

  • Type: INT64

  • Required: NO

  • Description: Key for the value.

  • Value

  • Type: STRING

  • Required: NO

  • Description: Value for the criteria.

  • Description

  • Type: STRING

  • Required: NO

  • Description: Description of the value.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the value was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the value was last modified.

User Dataset Specification

User_Role_Log Table

Schema Information

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

General Fields

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed in the user role log entry.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Role Fields

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the role.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was last modified.

Permissions

  • Permissions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Permissions associated with the role.

Permissions Fields

  • Grant_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the permission grant.

  • Grant_Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who granted the permission.

  • Grant_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was granted.

  • Grant_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission grant was last modified.

  • Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the permission.

  • Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the permission.

  • Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the permission.

  • Active_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission became active.

  • Inactive_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission became inactive.

  • Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • View_Only

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates if the permission is view-only.

  • Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was created.

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was last modified.

Resource Fields

  • Resource

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Resource associated with the permission.

Resource Details

  • Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the resource.

  • Class

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Class of the resource.

  • Class_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the resource class.

  • Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the resource.

  • Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the resource.

  • Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the resource was created.

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the resource was last modified.

Criteria Fields

  • Criteria

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Criteria associated with the permission.

Criteria Details

  • Assignment_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the criteria assignment.

  • Assignment_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria assignment was created.

  • Assignment_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria assignment was last modified.

  • Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the criteria.

  • Group_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the criteria group.

  • Group_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the criteria group.

  • Group_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator for the criteria group.

  • Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria was created.

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria was last modified.

Operator Fields

  • Operator

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Operator for the criteria.

Operator Details

  • Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the operator.

  • Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Value for the operator.

  • Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the operator was created.

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the operator was last modified.

Element Fields

  • Element

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Element associated with the criteria.

Element Details

  • Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the element.

  • Class

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Class of the element.

  • Class_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the element class.

  • Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the element.

  • Display_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Display name of the element.

  • Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the element was created.

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the element was last modified.

Values Fields

  • Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Values associated with the criteria.

Values Details

  • Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the value.

  • Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Value for the criteria.

  • Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the value.

  • Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the value was created.

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the value was last modified.

Record Fields

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified in the system.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the record is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the user role.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant.

User Dataset Specification

User Role Log

Columns

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the active version of the record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the user role log entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the user role log entry.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

User Session Last Login

Columns

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each user in the system.

  • User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user.

  • User_Status

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Status of the user session.

  • System_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user is a system user.

  • User_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the user session status.

  • User_Last_Login_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user last logged in to the system.

  • User_Last_Logout_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user last logged out of the system.

  • User_Session_End_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type indicating how the user session ended, such as logout or timeout.

User Session Log

Columns

  • Session_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each session in the system.

  • JVM_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the Java Virtual Machine (JVM) associated with the session.

  • Session_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the session.

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session started.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session ended.

  • End_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type indicating how the session ended, such as logout or timeout.

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user associated with the session.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session record was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the session was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the session.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the session record has been deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the session.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the session.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the session record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the session record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the session record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the session data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating when the session data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the session data originates.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the session data.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the session record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

User Log

Columns

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each user in the system.

  • Full_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user.

  • System_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user is a system user.

  • Time_Zone

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Time zone associated with the user.

Time Zone Structure

  • Time_Zone_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the time zone associated with the user.

  • Time_Zone_Abbreviation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Abbreviation for the time zone associated with the user.

  • Time_Zone_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the time zone system used by the user.

  • Time_Zone_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the time zone associated with the user.

Additional Columns

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user account is active.

  • Initials

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Initials of the user.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title or designation of the user.

  • Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Phone number associated with the user.

  • Mobile_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Mobile number associated with the user.

  • Email_Address

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Email address of the user.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user account was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user account was last modified.

Owner Structure

  • Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the user account.

  • Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of owner of the user account. The value 'INDV' corresponds to individual users and maps to 'APPL_USER_TYPE_DIM.APPL_USER_TYPE_CODE = 'I' in ACM reporting, indicating individual user ownership.

  • Owner_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the owner of the user account was created.

  • Owner_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the owner of the user account was last modified.

Viewed Departments

  • Viewed_Departments

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Departments viewed by the user.

Department Member Relationship Structure

(Details not provided in the input content)

User Dataset Specification

User_log

Managed_Departments

  • Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Department_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the department.

  • Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the user's assigned home page.

  • Department_Member_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was created.

  • Department_Member_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was last modified.

Viewed_Users

  • Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Home_Page_User_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the individual home page.

  • Home_Page_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the individual home page associated with the user.

  • Home_Page_User_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was created.

  • Home_Page_User_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was last modified.

Roles

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the role assigned to the user.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role assigned to the user.

Other Fields

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the user was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the user account.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of user.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the user.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the user account.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the user record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the user record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the user data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the user data originates.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user record has been deleted. If Deleted_Indicator is set to false, it means the user record is not deleted and should be included in all views. Used as a filter to exclude deleted user records from all views.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the user data.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the user record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

User_raw

General Information

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each user in the system.

  • Full_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user.

  • System_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user is a system user.

Time_Zone

  • Time_Zone_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the time zone associated with the user.

  • Time_Zone_Abbreviation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Abbreviation for the time zone associated with the user.

  • Time_Zone_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the time zone system used by the user.

  • Time_Zone_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the time zone associated with the user.

Other Fields

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user account is active.

  • Initials

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Initials of the user.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title or designation of the user.

  • Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Phone number associated with the user.

  • Mobile_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Mobile number associated with the user.

  • Email_Address

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Email address of the user.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user account was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user account was last modified.

Owner

  • Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the user account.

  • Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of owner of the user account. The value INDV corresponds to individual users and maps to APPL_USER_TYPE_DIM.APPL_USER_TYPE_CODE = 'I' in ACM reporting, indicating individual user ownership.

  • Owner_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the owner of the user account was created.

  • Owner_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the owner of the user account was last modified.

User Dataset Specification

Departments Viewed by the User

Parameters in the Array

  • Viewed_Departments.Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Viewed_Departments.Department_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the department.

  • Viewed_Departments.Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the user's assigned home page.

  • Viewed_Departments.Department_Member_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was created.

  • Viewed_Departments.Department_Member_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was last modified.

Departments Managed by the User

Parameters in the Array

  • Managed_Departments.Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Managed_Departments.Department_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the department.

  • Managed_Departments.Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the user's assigned home page.

  • Managed_Departments.Department_Member_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was created.

  • Managed_Departments.Department_Member_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was last modified.

Users Viewed by the User

Parameters in the Array

  • Viewed_Users.Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Viewed_Users.Home_Page_User_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the individual home page.

  • Viewed_Users.Home_Page_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the individual home page associated with the user.

  • Viewed_Users.Home_Page_User_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was created.

  • Viewed_Users.Home_Page_User_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was last modified.

Roles Assigned to the User

Parameters in the Array

  • Roles.Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the role assigned to the user.

  • Roles.Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role assigned to the user.

User Metadata

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the user was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the user account.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of user.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the user.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the user account.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the user record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the user record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the user data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the user data originates.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user record has been deleted. If Deleted_Indicator is set to false, it means the user record is not deleted and should be included in all views. Used as a filter to exclude deleted user records from all views.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the user data.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

User Session Metadata

Parameters in the Table

  • Session_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each session in the system.

  • JVM_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the Java Virtual Machine (JVM) associated with the session.

  • Session_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the session.

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session started.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session ended.

  • End_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type indicating how the session ended, such as logout or timeout.

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user associated with the session.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session record was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the session was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the session.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the session record has been deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the session.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the session.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the session record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the session record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the session record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the session data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating when the session data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the session data originates.

User Dataset Specification

Overview

The User Dataset Specification provides detailed information about user-related data within the Care Intelligence system. It includes schema definitions, user profiles, roles, permissions, and raw data for sessions and interactions. This specification is critical for understanding user management and operational monitoring.

User Data Components

User Profiles

  • Stores detailed information about each user, including:

  • Personal details

  • Contact information

  • Organizational affiliations

  • Enables identification of users and customization of their experience based on profile attributes.

User Roles

  • Contains data on the roles assigned to each user.

  • Defines access levels and permissions within the system.

  • Ensures users have appropriate access to resources pertinent to their roles.

Assigned Pages

  • Tracks which parts of the system each user can access.

  • Aligns access with user roles and responsibilities.

  • Helps manage user navigation and usability within the system.

Login Sessions

  • Captures details about each user's login sessions, including:

  • Session duration

  • Login times

  • Activity logs

  • Vital for security audits and operational monitoring.

Logs

  • Provides a record of user actions and changes within the system.

  • Offers an audit trail that enhances security and compliance.

Raw Data for Users and Their Sessions

  • Contains unprocessed, detailed data related to users and their interactions with the system.

  • Crucial for:

  • Deep analysis

  • Troubleshooting

  • Refining user management strategies

Table Definitions

User Table

Table Name

Column Name

Is Nullable

Data Type

Description

User

User_ID

YES

STRING

Unique identifier for each user in the system.

User

User_Name

YES

STRING

Name of the user.

User

System_User

YES

BOOL

Indicator specifying whether the user is a system user.

User

Time_Zone_Code

YES

STRING

Code representing the time zone associated with the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

User

Time_Zone_Abbreviation

YES

STRING

Abbreviation for the time zone associated with the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

User

Time_Zone_System_Code

YES

STRING

Code representing the time zone system used by the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

User

Time_Zone_Name

YES

STRING

Name of the time zone associated with the user. See Dictionary Timezone table in the Dictionary Dataset Specification.

User

Active

YES

BOOL

Indicator specifying whether the user account is active.

User

Initials

YES

STRING

Initials of the user.

User

Title

YES

STRING

Title or designation of the user.

User

Phone_Number

YES

STRING

Phone number associated with the user.

User

Mobile_Number

YES

STRING

Mobile number associated with the user.

User

Email_Address

YES

STRING

Email address of the user.

User

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user account was created.

User

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user account was last modified.

User

Owner_Key

YES

INT64

Key identifying the owner of the user account.

User

Owner_Type

YES

STRING

The type of owner associated with the user account is determined as follows: If the User_Owner_ID is not null, the owner type is 'INDV', which corresponds to individual users. This mapping is defined in the 'APPL_USER_TYPE_DIM' table, where 'APPL_USER_TYPE_CODE = 'I'', indicating individual user ownership in ACM reporting.

User

Owner_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the owner of the user account was created.

User

Owner_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the owner of the user account was last modified.

User

Transaction_User_ID

YES

STRING

Unique identifier for the user who performed the transaction related to the user account.

User

Transaction_User_Name

YES

STRING

Name of the user who performed the transaction related to the user account.

User

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record associated with the user account was last modified.

User Assigned Department Home Pages Table

Table Name

Column Name

Is Nullable

Data Type

Description

User_Assigned_Department_Home_Pages

User_ID

YES

STRING

Unique identifier for each user in the system.

User_Assigned_Department_Home_Pages

User_Name

YES

STRING

Name of the user.

User_Assigned_Department_Home_Pages

Active_User

YES

BOOL

Indicator specifying whether the user account is active.

User_Assigned_Department_Home_Pages

Department_Owner_Key

YES

INT64

Key identifying the owner of the department.

User_Assigned_Department_Home_Pages

Department_ID

YES

STRING

Identifier for the department associated with the user's assigned home page.

User_Assigned_Department_Home_Pages

Department_Name

YES

STRING

Name of the department associated with the user's assigned home page. This value is derived from the Department_Name field in the Department table.

User_Assigned_Department_Home_Pages

Active_Department

YES

BOOL

Indicator specifying whether the department associated with the user's assigned home page is active. This value is derived from the Active field in the Department table.

User_Assigned_Department_Home_Pages

Department_Member

YES

BOOL

Indicator specifying whether the user is a department member.

User_Assigned_Department_Home_Pages

Department_Manager

YES

BOOL

Indicator specifying whether the user is a department manager.

User_Assigned_Department_Home_Pages

Department_Member_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's membership in the department was created.

User_Assigned_Department_Home_Pages

Department_Manager_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's role as a department manager was created.

User Dataset Specification

User Assigned Department Home Pages

Columns

Column Name

Is Nullable

Data Type

Description

Department_Member_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's membership in the department was last modified.

Department_Manager_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's role as a department manager was last modified.

Department_Member_Relationship_Key

YES

INT64

Unique identifier for the relationship between a user and a department as a member.

Department_Manager_Relationship_Key

YES

INT64

Unique identifier for the relationship between a user and a department as a manager.

Transaction_User_ID

YES

STRING

Unique identifier for the user who performed the transaction related to the department home page assignment.

Transaction_User_Name

YES

STRING

Name of the user who performed the transaction related to the department home page assignment.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record associated with the user's assigned department home page was last modified.

User Assigned Individual Home Pages

Columns

Column Name

Is Nullable

Data Type

Description

User_ID

YES

STRING

Unique identifier for each user in the system.

User_Name

YES

STRING

Name of the user.

Active_User

YES

BOOL

Indicator specifying whether the user account is active.

Home_Page_User_Relationship_Key

YES

INT64

Unique identifier for the relationship between a user and their assigned individual home page.

Home_Page_User_Owner_Key

YES

INT64

Key identifying the owner of the individual home page.

Home_Page_User_ID

YES

STRING

Identifier for the individual home page associated with the user.

Home_Page_User_Name

YES

STRING

Name or title of the individual home page associated with the user.

Home_Page_Active_User

YES

BOOL

Indicator specifying whether the individual home page associated with the user is active.

Home_Page_User_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the relationship between the user and their assigned individual home page was created.

Home_Page_User_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the relationship between the user and their assigned individual home page was last modified.

Transaction_User_ID

YES

STRING

Unique identifier for the user who performed the transaction related to the assignment of the individual home page.

Transaction_User_Name

YES

STRING

Name of the user who performed the transaction related to the assignment of the individual home page.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record associated with the user's assigned individual home page was last modified.

User Roles

Columns

Column Name

Is Nullable

Data Type

Description

User_ID

YES

STRING

Unique identifier for each user in the system.

User_Name

YES

STRING

Name of the user.

Active_User

YES

BOOL

Indicator specifying whether the user account is active.

Role_Code

YES

STRING

Code representing the role assigned to the user.

Role_Description

YES

STRING

Description of the role assigned to the user.

Transaction_User_ID

YES

STRING

Unique identifier for the user who performed the transaction related to the assignment of roles to the user.

Transaction_User_Name

YES

STRING

Name of the user who performed the transaction related to the assignment of roles to the user.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record associated with the user roles was last modified.

User Role Permission Criteria

Columns

Column Name

Is Nullable

Data Type

Description

Permission_Key

YES

INT64

Unique identifier for each permission or authorization associated with a role or user.

Criteria_Assignment_Key

YES

INT64

Key associated with the assignment of criteria to a specific role or user.

Criteria_Assignment_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the criteria assignment was created.

Criteria_Assignment_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last modification of the criteria assignment.

Criteria_Key

YES

INT64

Unique identifier for each specific criteria or condition.

Criteria_Group_Code

YES

STRING

Code representing a group or category of related criteria.

Criteria_Group_Description

YES

STRING

Description of the criteria group (e.g., purpose, context, or usage).

Criteria_Group_Indicator

YES

BOOL

Indicator (e.g., Yes/No) whether the criteria group is active or relevant.

Criteria_Transaction_User_ID

YES

STRING

User ID associated with the transaction or action related to the criteria.

User Dataset Specification

User Role Permission Criteria

Columns

  • a_Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who performed the transaction related to the criteria.

  • Criteria_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria was created.

  • Criteria_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria.

  • Criteria_Operator_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the operator used in the criteria (e.g., equal, greater than, contains).

  • Criteria_Operator_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value associated with the operator in the criteria (e.g., specific role name, numeric threshold).

  • Criteria_Operator_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria operator was created.

  • Criteria_Operator_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria operator.

  • Criteria_Element_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific element or attribute within the criteria.

  • Criteria_Element_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the criteria element (e.g., role, user, permission).

  • Criteria_Element_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the criteria element class (e.g., role, user, permission).

  • Criteria_Element_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label of the specific criteria element (e.g., role name, user ID).

  • Criteria_Element_Display_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display name or user-friendly label for the criteria element.

  • Criteria_Element_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria element was created.

  • Criteria_Element_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria element.

User Role Permission Criteria Values

Columns

  • Criteria_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific criteria or condition.

  • Criteria_Value_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key associated with a specific value or setting related to the criteria.

  • Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The actual value or setting associated with the criteria (e.g., role name, numeric threshold).

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description or details related to the criteria value.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the criteria value was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the criteria value.

User Role Permissions

Columns

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific user role within the system.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description or name of the user role (e.g., “Administrator,” “Analyst,” etc.).

  • Permission_Grant_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key associated with the grant of permissions to a specific role.

  • Permission_Grant_Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who granted the permissions.

  • Permission_Grant_Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who granted the permissions.

  • Permission_Grant_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission grant was created.

  • Permission_Grant_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the permission grant.

  • Permission_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific permission or authorization.

  • Permission_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label of the specific permission (e.g., “Read,” “Write,” “Execute”).

  • Permission_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the purpose or scope of the permission (e.g., “Access patient records”).

  • Permission_Active_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission became active.

  • Permission_Inactive_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission was deactivated or revoked.

  • Permission_Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator (e.g., Yes/No) whether the permission is currently active.

  • Permission_Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who modified the permission.

  • Permission_Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who modified the permission.

  • Permission_View_Only

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator (e.g., Yes/No) whether the permission allows view-only access.

  • Permission_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the permission was created.

  • Permission_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the permission.

  • Permission_Resource_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each specific resource associated with the permission.

  • Permission_Resource_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the resource (e.g., “Patient Records,” “Billing Data”).

  • Permission_Resource_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the resource class associated with the permission.

User Dataset Specification

User Role Permissions

Permission Resource Details

  • Permission_Resource_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label of the specific resource (e.g., “Patient Record Access,” “Billing Report”).

  • Permission_Resource_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional details or context related to the resource (e.g., “View patient history”).

  • Permission_Resource_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the resource was created.

  • Permission_Resource_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the resource.

User Role Log

Role Details

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the role.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was last modified.

Permissions

  • Permissions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Permissions associated with the role.

Permissions Attributes

  • Permissions.Grant_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the permission grant.

  • Permissions.Grant_Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who granted the permission.

  • Permissions.Grant_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was granted.

  • Permissions.Grant_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission grant was last modified.

  • Permissions.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the permission.

  • Permissions.Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the permission.

  • Permissions.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the permission.

  • Permissions.Active_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission became active.

  • Permissions.Inactive_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission became inactive.

  • Permissions.Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Permissions.View_Only

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates if the permission is view-only.

  • Permissions.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was created.

  • Permissions.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was last modified.

Permissions Resource

  • Permissions.Resource

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Resource associated with the permission.

Resource Attributes

  • Permissions.Resource.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the resource.

  • Permissions.Resource.Class

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Class of the resource.

  • Permissions.Resource.Class_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the resource class.

  • Permissions.Resource.Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the resource.

  • Permissions.Resource.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the resource.

  • Permissions.Resource.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the resource was created.

  • Permissions.Resource.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the resource was last modified.

Permissions Criteria

  • Permissions.Criteria

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Criteria associated with the permission.

Criteria Attributes

  • Permissions.Criteria.Assignment_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the criteria assignment.

  • Permissions.Criteria.Assignment_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria assignment was created.

  • Permissions.Criteria.Assignment_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria assignment was last modified.

  • Permissions.Criteria.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the criteria.

  • Permissions.Criteria.Group_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the criteria group.

  • Permissions.Criteria.Group_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the criteria group.

  • Permissions.Criteria.Group_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator for the criteria group.

  • Permissions.Criteria.Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Permissions.Criteria.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria was created.

  • Permissions.Criteria.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria was last modified.

Permissions Criteria Operator

  • Permissions.Criteria.Operator

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Operator for the criteria.

Operator Attributes

  • Permissions.Criteria.Operator.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the operator.

  • Permissions.Criteria.Operator.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Value for the operator.

  • Permissions.Criteria.Operator.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the operator was created.

  • Permissions.Criteria.Operator.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the operator was last modified.

Permissions Criteria Element

  • Permissions.Criteria.Element

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Element associated with the criteria.

Element Attributes

  • Permissions.Criteria.Element.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the element.

  • Permissions.Criteria.Element.Class

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Class of the element.

  • Permissions.Criteria.Element.Class_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the element class.

  • Permissions.Criteria.Element.Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the element.

  • Permissions.Criteria.Element.Display_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Display name of the element.

  • Permissions.Criteria.Element.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the element was created.

User Dataset Specification

User_Role_log Table

General Information

  • Table Name: User_Role_log

  • Description: Contains information related to user roles, permissions, and associated metadata.

Columns

Metadata

  • Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the element was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was last modified.

User Role Information

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the role.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the user role.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or client.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the active version of the record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the user role log entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the user role log entry.

Source Information

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

Transaction Information

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Action Information

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed in the user role log entry.

Deletion Information

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the record is deleted.

Permissions

General Information

  • Permissions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Permissions associated with the role.

Permission Details

  • Permissions.Grant_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the permission grant.

  • Permissions.Grant_Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who granted the permission.

  • Permissions.Grant_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was granted.

  • Permissions.Grant_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission grant was last modified.

  • Permissions.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the permission.

  • Permissions.Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the permission.

  • Permissions.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the permission.

  • Permissions.Active_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission became active.

  • Permissions.Inactive_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission became inactive.

  • Permissions.Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Permissions.View_Only

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates if the permission is view-only.

  • Permissions.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was created.

  • Permissions.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the permission was last modified.

Resource Information

  • Permissions.Resource

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Resource associated with the permission.

  • Permissions.Resource.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the resource.

  • Permissions.Resource.Class

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Class of the resource.

  • Permissions.Resource.Class_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the resource class.

  • Permissions.Resource.Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the resource.

  • Permissions.Resource.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the resource.

  • Permissions.Resource.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the resource was created.

  • Permissions.Resource.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the resource was last modified.

Criteria Information

  • Permissions.Criteria

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Criteria associated with the permission.

  • Permissions.Criteria.Assignment_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the criteria assignment.

  • Permissions.Criteria.Assignment_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria assignment was created.

  • Permissions.Criteria.Assignment_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria assignment was last modified.

  • Permissions.Criteria.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the criteria.

  • Permissions.Criteria.Group_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the criteria group.

  • Permissions.Criteria.Group_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the criteria group.

  • Permissions.Criteria.Group_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator for the criteria group.

  • Permissions.Criteria.Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Permissions.Criteria.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria was created.

  • Permissions.Criteria.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the criteria was last modified.

Criteria Values

  • Permissions.Criteria.Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Values associated with the criteria.

  • Permissions.Criteria.Values.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Key for the value.

  • Permissions.Criteria.Values.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Value for the criteria.

  • Permissions.Criteria.Values.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the value.

  • Permissions.Criteria.Values.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the value was created.

  • Permissions.Criteria.Values.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the value was last modified.

User Dataset Specification

User Role Log

Permissions.Criteria.Operator

  • Code: STRING (Required)\ Code for the operator.

  • Value: STRING (Required)\ Value for the operator.

  • Created_Timestamp: TIMESTAMP (Required)\ Timestamp when the operator was created.

  • Last_Modified_Timestamp: TIMESTAMP (Required)\ Timestamp when the operator was last modified.

Permissions.Criteria.Element

  • Key: INT64 (Required)\ Key for the element.

  • Class: STRING (Required)\ Class of the element.

  • Class_Description: STRING (Required)\ Description of the element class.

  • Name: STRING (Required)\ Name of the element.

  • Display_Name: STRING (Required)\ Display name of the element.

  • Created_Timestamp: TIMESTAMP (Required)\ Timestamp when the element was created.

  • Last_Modified_Timestamp: TIMESTAMP (Required)\ Timestamp when the element was last modified.

Permissions.Criteria.Values

  • Key: INT64 (Required)\ Key for the value.

  • Value: STRING (Required)\ Value for the criteria.

  • Description: STRING (Required)\ Description of the value.

  • Created_Timestamp: TIMESTAMP (Required)\ Timestamp when the value was created.

  • Last_Modified_Timestamp: TIMESTAMP (Required)\ Timestamp when the value was last modified.

General Attributes

  • Record_Last_Modified_Timestamp: TIMESTAMP (Optional)\ Timestamp when the record was last modified in the system.

  • Transaction_User_ID: STRING (Optional)\ Identifier for the user who performed the transaction.

  • Deleted_Indicator: BOOL (Optional)\ Indicator if the record is deleted.

  • Type: STRING (Optional)\ Type of the user role.

  • Tenant: STRING (Optional)\ Identifier for the tenant or client.

  • Active_Version: BOOL (Optional)\ Indicates the active version of the record.

  • Date: DATE (Optional)\ Date of the user role log entry.

  • Sequence: INT64 (Optional)\ Sequence number of the user role log entry.

  • Source_System_Name: STRING (Optional)\ Name of the source system.

  • Source_Timestamp: STRING (Optional)\ Timestamp from the source system.

  • Source_File_Name: STRING (Optional)\ Name of the source file.

  • Schema_Version: FLOAT64 (Optional)\ Version of the schema.

  • Transaction_Actor_Type: STRING (Optional)\ Type of the actor performing the transaction.

User Session Last Login

Attributes

  • User_ID: STRING (Optional)\ Unique identifier for each user in the system.

  • User_Name: STRING (Optional)\ Name of the user.

  • User_Status: BOOL (Optional)\ Status of the user session.

  • System_User: BOOL (Optional)\ Indicator specifying whether the user is a system user.

  • User_Status_Description: STRING (Optional)\ Description of the user session status.

  • User_Last_Login_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the user last logged in to the system.

  • User_Last_Logout_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the user last logged out of the system.

  • User_Session_End_Type: STRING (Optional)\ Type indicating how the user session ended, such as logout or timeout.

User Session Log

Attributes

  • Session_Key: INT64 (Optional)\ Unique identifier for each session in the system.

  • JVM_ID: STRING (Optional)\ Identifier for the Java Virtual Machine (JVM) associated with the session.

  • Session_ID: STRING (Optional)\ Unique identifier for the session.

  • Start_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the session started.

  • End_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the session ended.

  • End_Type: STRING (Optional)\ Type indicating how the session ended, such as logout or timeout.

  • User_ID: STRING (Optional)\ Unique identifier for the user associated with the session.

  • Created_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the session record was created.

  • Last_Modified_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the session record was last modified.

  • Record_Last_Modified_Timestamp: TIMESTAMP (Optional)\ Timestamp indicating when the record associated with the session was last modified.

  • Transaction_User_ID: STRING (Optional)\ Unique identifier for the user who performed the transaction related to the session.

  • Deleted_Indicator: BOOL (Optional)\ Indicator specifying whether the session record has been deleted.

  • Type: STRING (Optional)\ Type of the session.

  • Tenant: STRING (Optional)\ Tenant associated with the session.

  • Active_Version: BOOL (Optional)\ Active version of the session record.

  • Date: DATE (Optional)\ Date associated with the session.

User Dataset Specification

User Session Log

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

User_Session_log

Sequence

YES

INT64

Sequence number associated with the session record.

User_Session_log

Source_System_Name

YES

STRING

Name of the source system from which the session data originates.

User_Session_log

Source_Timestamp

YES

STRING

Timestamp indicating when the session data was sourced.

User_Session_log

Source_File_Name

YES

STRING

Name of the source file from which the session data originates.

User_Session_log

Schema_Version

YES

FLOAT64

Version of the schema used for the session data.

User_Session_log

Action

YES

STRING

Action performed on the session record.

User_Session_log

Transaction_Actor_Type

YES

STRING

Type of the actor performing the transaction.

User Log

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

User_log

User_ID

YES

STRING

Unique identifier for each user in the system.

User_log

Full_Name

YES

STRING

Full name of the user.

User_log

System_User

YES

BOOL

Indicator specifying whether the user is a system user.

User_log

Time_Zone

YES

STRUCT

Time zone associated with the user. See below for detailed information.

User_log

Active

YES

BOOL

Indicator specifying whether the user account is active.

User_log

Initials

YES

STRING

Initials of the user.

User_log

Title

YES

STRING

Title or designation of the user.

User_log

Phone_Number

YES

STRING

Phone number associated with the user.

User_log

Mobile_Number

YES

STRING

Mobile number associated with the user.

User_log

Email_Address

YES

STRING

Email address of the user.

User_log

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user account was created.

User_log

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user account was last modified.

User_log

Owner

YES

STRUCT

Owner of the user account. See below for detailed information.

User_log

Viewed_Departments

NO

ARRAY

Departments viewed by the user. See below for detailed information.

User_log

Managed_Departments

NO

ARRAY

Departments managed by the user. See below for detailed information.

User_log

Viewed_Users

NO

ARRAY

Users viewed by the user. See below for detailed information.

User_log

Roles

NO

ARRAY

Roles assigned to the user. See below for detailed information.

Time Zone Structure

Parameter Name

Is Nullable

Data Type

Description

Time_Zone.Time_Zone_Code

YES

STRING

Code representing the time zone associated with the user.

Time_Zone.Time_Zone_Abbreviation

YES

STRING

Abbreviation for the time zone associated with the user.

Time_Zone.Time_Zone_System_Code

YES

STRING

Code representing the time zone system used by the user.

Time_Zone.Time_Zone_Name

YES

STRING

Name of the time zone associated with the user.

Owner Structure

Parameter Name

Is Nullable

Data Type

Description

Owner.Owner_Key

YES

INT64

Key identifying the owner of the user account.

Owner.Owner_Type

YES

STRING

Type of owner of the user account. The value 'INDV' corresponds to individual users and maps to 'APPL_USER_TYPE_DIM.APPL_USER_TYPE_CODE = 'I' in ACM reporting, indicating individual user ownership.

Owner.Owner_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the owner of the user account was created.

Owner.Owner_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the owner of the user account was last modified.

Viewed Departments Array

Parameter Name

Is Nullable

Data Type

Description

Viewed_Departments.Department_Member_Relationship_Key

YES

INT64

Unique identifier for the relationship between a user and a department as a member.

Viewed_Departments.Department_Owner_Key

YES

INT64

Key identifying the owner of the department.

Viewed_Departments.Department_ID

YES

STRING

Identifier for the department associated with the user's assigned home page.

Viewed_Departments.Department_Member_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's membership in the department was created.

Viewed_Departments.Department_Member_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's membership in the department was last modified.

Managed Departments Array

Parameter Name

Is Nullable

Data Type

Description

Managed_Departments.Department_Member_Relationship_Key

YES

INT64

Unique identifier for the relationship between a user and a department as a member.

Managed_Departments.Department_Owner_Key

YES

INT64

Key identifying the owner of the department.

Managed_Departments.Department_ID

YES

STRING

Identifier for the department associated with the user's assigned home page.

Managed_Departments.Department_Member_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's membership in the department was created.

Managed_Departments.Department_Member_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the user's membership in the department was last modified.

Viewed Users Array

Parameter Name

Is Nullable

Data Type

Description

Viewed_Users.Department_Member_Relationship_Key

YES

INT64

Unique identifier for the relationship between a user and a department as a member.

Viewed_Users.Home_Page_User_Owner_Key

YES

INT64

Key identifying the owner of the individual home page.

Viewed_Users.Home_Page_User_ID

YES

STRING

Identifier for the individual home page associated with the user.

Viewed_Users.Home_Page_User_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the relationship between the user and their assigned individual home page was created.

Viewed_Users.Home_Page_User_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the relationship between the user and their assigned individual home page was last modified.

Roles Array

Parameter Name

Is Nullable

Data Type

Description

Roles.Role_Code

YES

STRING

Code representing the role assigned to the user.

Roles.Role_Description

YES

STRING

Description of the role assigned to the user.

User Dataset Specification

User Log Table

Columns

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the user was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the user account.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of user.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the user.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the user account.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the user record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the user record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the user data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the user data originates.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user record has been deleted. If Deleted_Indicator is set to false, it means the user record is not deleted and should be included in all views. Used as a filter to exclude deleted user records from all views.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the user data.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the user record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

User Raw Table

Columns

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each user in the system.

  • Full_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user.

  • System_User

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user is a system user.

  • Time_Zone

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Time zone associated with the user. See below for detailed information on each parameter in the structure.

Time Zone Structure

  • Time_Zone_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the time zone associated with the user.

  • Time_Zone_Abbreviation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Abbreviation for the time zone associated with the user.

  • Time_Zone_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the time zone system used by the user.

  • Time_Zone_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the time zone associated with the user.

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the user account is active.

  • Initials

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Initials of the user.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title or designation of the user.

  • Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Phone number associated with the user.

  • Mobile_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Mobile number associated with the user.

  • Email_Address

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Email address of the user.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user account was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user account was last modified.

  • Owner

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Owner of the user account. See below for detailed information on each parameter in the structure.

Owner Structure

  • Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the user account.

  • Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of owner of the user account. The value 'INDV' corresponds to individual users and maps to 'APPL_USER_TYPE_DIM.APPL_USER_TYPE_CODE = 'I' in ACM reporting, indicating individual user ownership.

  • Owner_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the owner of the user account was created.

  • Owner_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the owner of the user account was last modified.

  • Viewed_Departments

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Departments viewed by the user. See below for detailed information on each parameter in the array.

Viewed Departments Array

  • Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Department_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the department.

  • Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the user's assigned home page.

  • Department_Member_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was created.

  • Department_Member_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was last modified.

  • Managed_Departments

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Departments managed by the user. See below for detailed information on each parameter in the array.

Managed Departments Array

  • Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Department_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the department.

  • Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the user's assigned home page.

  • Department_Member_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was created.

  • Department_Member_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the user's membership in the department was last modified.

  • Viewed_Users

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Users viewed by the user. See below for detailed information on each parameter in the array.

Viewed Users Array

  • Department_Member_Relationship_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the relationship between a user and a department as a member.

  • Home_Page_User_Owner_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the owner of the user's home page.

User Dataset Specification

Viewed Users

Columns

  • Home_Page_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the individual home page associated with the user.

  • Home_Page_User_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was created.

  • Home_Page_User_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the relationship between the user and their assigned individual home page was last modified.

User Raw

Columns

  • Roles

    • Is Nullable: NO

    • Data Type: ARRAY

    • Description: Roles assigned to the user. See below for detailed information on each parameter in the array.

    Roles Subfields

    • Role_Code

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Code representing the role assigned to the user.

    • Role_Description

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Description of the role assigned to the user.

    • Record_Last_Modified_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the record associated with the user was last modified.

    • Transaction_User_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Unique identifier for the user who performed the transaction related to the user account.

    • Type

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Type of user.

    • Tenant

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Tenant associated with the user.

    • Active_Version

    • Is Nullable: YES

    • Data Type: BOOL

    • Description: Active version of the user account.

    • Date

    • Is Nullable: YES

    • Data Type: DATE

    • Description: Date associated with the user record.

    • Sequence

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Sequence number associated with the user record.

    • Source_System_Name

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Name of the source system from which the user data originates.

    • Source_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the user data was sourced.

    • Source_File_Name

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Name of the source file from which the user data originates.

    • Deleted_Indicator

    • Is Nullable: YES

    • Data Type: BOOL

    • Description: Indicator specifying whether the user record has been deleted. If Deleted_Indicator is set to false, it means the user record is not deleted and should be included in all views. Used as a filter to exclude deleted user records from all views.

    • Schema_Version

    • Is Nullable: YES

    • Data Type: FLOAT64

    • Description: Version of the schema used for the user data.

    • Transaction_Actor_Type

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Type of the actor performing the transaction.

User Session Raw

Columns

  • Session_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each session in the system.

  • JVM_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the Java Virtual Machine (JVM) associated with the session.

  • Session_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the session.

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session started.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session ended.

  • End_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type indicating how the session ended, such as logout or timeout.

  • User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user associated with the session.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the session record was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record associated with the session was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction related to the session.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the session record has been deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the session.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the session.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the session record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the session record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the session record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the session data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating when the session data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the session data originates.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the session data.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Related Articles
Assessment Dataset Specification
Questionnaire Dataset Specification
Notification Dataset Specification
Custom Field Metadata Dataset Specification
Calendar Dataset Specification
Did this answer your question?