Department Dataset Specification
Department Dataset Specification
The "Department Dataset Specification" is designed to manage and track healthcare departments within an organization, ensuring efficient operations and alignment with healthcare industry standards. This dataset supports the management of departmental structures, activities, and changes, which are critical for maintaining clear organizational hierarchy, accountability, and transparency in healthcare settings.
This dataset plays a crucial role in ensuring that healthcare organizations maintain clear and efficient departmental structures. It supports streamlined management of department-related operations, accountability for department-level decisions, and compliance with healthcare standards related to organizational transparency and governance.
Key Tables
Department
Stores detailed information about each department within the healthcare organization, including department names, functions, leadership, and operational roles. This table is essential for defining the structure of the organization, facilitating effective coordination between clinical, administrative, and support departments.
Columns
Department_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the department.
Department_Name
Is Nullable: YES
Data Type: STRING
Description: Name or title of the department.
Active
Is Nullable: YES
Data Type: BOOL
Description: Indicator specifying if the department is active or inactive.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the department was created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the department was last modified.
Owner_Key
Is Nullable: YES
Data Type: INT64
Description: Key identifying the owner of the department.
Owner_Type
Is Nullable: YES
Data Type: STRING
Description: The type of owner linked to a department is designated as DEPT in the system and D in Business Objects reporting. This corresponds to the APPL_USER_TYPE_CODE = D within ACM reporting frameworks.
Owner_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the owner was created.
Owner_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the owner was last modified.
Department Log
Maintains a historical record of changes and updates to departmental data, such as leadership changes, restructuring, or role adjustments. This log provides a comprehensive audit trail, ensuring transparency and compliance with organizational policies and healthcare regulations.
Columns
Department_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the department.
Department_Name
Is Nullable: YES
Data Type: STRING
Description: Name or title of the department.
Active
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the department is active or inactive.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the department record was created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last modification date of the department record.
Owner
Is Nullable: YES
Data Type: ARRAY
Description: Owner or responsible entity associated with the department.
Subfields:
Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for the ownership record within the department log, ensuring distinct traceability and management.
Type
Is Nullable: YES
Data Type: STRING
Description: The type of ownership or departmental classification, used to specify the department's function or role within the healthcare system.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the ownership record was first created, marking the establishment or reassignment of departmental ownership.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the ownership record was last updated, useful for tracking changes and maintaining current departmental data.
Record_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last modification date of the department record in the log table.
Transaction_User_ID
Is Nullable: YES
Data Type: STRING
Description: ID of the user who performed the transaction or modification related to the department.
Type
Is Nullable: YES
Data Type: STRING
Description: Type of department or category it belongs to.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Identifier for the tenant or organization to which the department belongs.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Version number or identifier indicating the active version of the department record.
Date
Is Nullable: YES
Data Type: DATE
Description: Date when the department information was logged or recorded.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number or order of the department record in the log.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the system or source from which the department information was sourced or logged.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the department information was sourced or logged.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the file or data source from which the department information was sourced.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator showing whether the department record has been deleted or not.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data model used for the department dataset.
Action
Is Nullable: YES
Data Type: STRING
Description: Action or operation performed on the department record (e.g., create, update, delete).
Transaction_Actor_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
Department Raw
Contains unprocessed, detailed data related to the departments. This raw data is vital for in-depth analysis and auditing, providing a complete view of the departmental structure and activities before any transformations or updates.
Columns
Department_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the department.
Department_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the department.
Active
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the department is active or not.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the department record was created.
Department Dataset Specification
Overview
The Department Dataset Specification provides detailed information about the structure, attributes, and operational data related to departments within the healthcare organization. This dataset is essential for defining organizational structure, facilitating coordination between clinical, administrative, and support departments, and ensuring compliance with healthcare regulations.
Key Components
Department: Stores detailed information about each department, including department names, functions, leadership, and operational roles.
Department Log: Maintains a historical record of changes and updates to departmental data, such as leadership changes, restructuring, or role adjustments. Provides a comprehensive audit trail for transparency and compliance.
Department Raw: Contains unprocessed, detailed data related to departments. This raw data is vital for in-depth analysis and auditing, offering a complete view of departmental structure and activities before transformations or updates.
Department Raw
Columns
Column Name | Is Nullable | Data Type | Description |
Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp when the department record was last modified. |
Owner | YES | ARRAY | Owner of the department. |
Owner.Key | YES | INT64 | Unique identifier for the ownership record within the department dataset. |
Owner.Type | YES | STRING | Type of ownership or departmental classification. |
Owner.Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the ownership record was first created. |
Owner.Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating when the ownership record was last updated. |
Record_Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp of the last modification to the department record. |
Transaction_User_ID | YES | STRING | Identifier of the user who performed the transaction. |
Type | YES | STRING | Type of the department. |
Tenant | YES | STRING | Tenant information related to the department. |
Active_Version | YES | BOOL | Version number indicating the active state of the department. |
Date | YES | DATE | Date associated with the department. |
Sequence | YES | INT64 | Sequence number for the department record. |
Source_System_Name | YES | STRING | Name of the source system for department data. |
Source_Timestamp | YES | TIMESTAMP | Timestamp indicating the source of department data. |
Source_File_Name | YES | STRING | Name of the source file containing department data. |
Deleted_Indicator | YES | BOOL | Indicator showing if the department record is deleted. |
Schema_Version | YES | FLOAT64 | Version of the schema for the department dataset. |
Transaction_Actor_Type | YES | STRING | Type of the actor performing the transaction. |
Department
Columns
Column Name | Is Nullable | Data Type | Description |
Department_ID | YES | STRING | Unique identifier for the department. |
Department_Name | YES | STRING | Name or title of the department. |
Active | YES | BOOL | Indicator specifying if the department is active or inactive. |
Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the department was created. |
Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating when the department was last modified. |
Owner_Key | YES | INT64 | Key identifying the owner of the department. |
Owner_Type | YES | STRING | Type of owner linked to a department. |
Owner_Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the owner was created. |
Owner_Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating when the owner was last modified. |
Department Log
Columns
Column Name | Is Nullable | Data Type | Description |
Department_ID | YES | STRING | Unique identifier for the department. |
Department_Name | YES | STRING | Name or title of the department. |
Active | YES | BOOL | Indicates whether the department is active or inactive. |
Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the department record was created. |
Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating the last modification date of the department record. |
Owner | YES | ARRAY | Owner or responsible entity associated with the department. |
Owner.Key | YES | INT64 | Unique identifier for the ownership record within the department log. |
Owner.Type | YES | STRING | Type of ownership or departmental classification. |
Owner.Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the ownership record was first created. |
Owner.Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating when the ownership record was last updated. |
Record_Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating the last modification date of the department record. |
Transaction_User_ID | YES | STRING | ID of the user who performed the transaction or modification. |
Type | YES | STRING | Type of department or category it belongs to. |
Tenant | YES | STRING | Identifier for the tenant or organization to which the department belongs. |
Active_Version | YES | BOOL | Version number indicating the active state of the department. |
Department Dataset Specification
.
Department Log
Columns
Column Name | Is Nullable | Data Type | Description |
Version | YES | STRING | Version number or identifier indicating the active version of the department record. |
Date | YES | DATE | Date when the department information was logged or recorded. |
Sequence | YES | INT64 | Sequence number or order of the department record in the log. |
Source_System_Name | YES | STRING | Name of the system or source from which the department information was sourced or logged. |
Source_Timestamp | YES | TIMESTAMP | Timestamp indicating when the department information was sourced or logged. |
Source_File_Name | YES | STRING | Name of the file or data source from which the department information was sourced. |
Deleted_Indicator | YES | BOOL | Indicator showing whether the department record has been deleted or not. |
Schema_Version | YES | FLOAT64 | Version of the schema or data model used for the department dataset. |
Action | YES | STRING | Action or operation performed on the department record (e.g., create, update, delete). |
Transaction_Actor_Type | YES | STRING | Type of the actor performing the transaction. |
Department Raw
Columns
Column Name | Is Nullable | Data Type | Description |
Department_ID | YES | STRING | Unique identifier for the department. |
Department_Name | YES | STRING | Name of the department. |
Active | YES | BOOL | Indicates whether the department is active or not. |
Created_Timestamp | YES | TIMESTAMP | Timestamp when the department record was created. |
Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp when the department record was last modified. |
Owner | YES | ARRAY | Owner of the department. |
Record_Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp of the last modification to the department record. |
Transaction_User_ID | YES | STRING | Identifier of the user who performed the transaction. |
Type | YES | STRING | Type of the department. |
Tenant | YES | STRING | Tenant information related to the department. |
Active_Version | YES | BOOL | Version number indicating the active state of the department. |
Date | YES | DATE | Date associated with the department. |
Sequence | YES | INT64 | Sequence number for the department record. |
Source_System_Name | YES | STRING | Name of the source system for department data. |
Source_Timestamp | YES | TIMESTAMP | Timestamp indicating the source of department data. |
Source_File_Name | YES | STRING | Name of the source file containing department data. |
Deleted_Indicator | YES | BOOL | Indicator showing if the department record is deleted. |
Schema_Version | YES | FLOAT64 | Version of the schema for the department dataset. |
Transaction_Actor_Type | YES | STRING | Type of the actor performing the transaction. |
Owner Subfields
Subfield Name | Is Nullable | Data Type | Description |
Key | YES | INT64 | A unique identifier for the ownership record within the department dataset, ensuring distinct traceability and management. |
Type | YES | STRING | The type of ownership or departmental classification, used to specify the department's function or role within the healthcare system. |
Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the ownership record was first created, marking the establishment or reassignment of departmental ownership. |
Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp indicating when the ownership record was last updated, useful for tracking changes and maintaining current departmental data. |