| Name |
Type
|
Description |
| personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
| encounterid |
VARCHAR(38) GUID |
Internal identifier assigned to the encounter by HIEBus.
|
| identifier |
VARCHAR |
External identifier used by the source system to uniquely identify the encounter.
|
| datasource |
VARCHAR |
The name of the data source. Commonly determined from the namespace of the source terminology.
|
| class |
VARCHAR |
Mapped by Rosetta. Patient class concept, used as a primary indicator of the care setting in which the encounter took place. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| classcode |
VARCHAR |
Mapped by Rosetta. Coded Value. Patient class concept, used as a primary indicator of the care setting in which the encounter took place. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| classtermid |
INTEGER |
Reference to HIEBus terminology properties for the claim.
|
| type |
VARCHAR |
Mapped by Rosetta. Department or service. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| typecode |
VARCHAR |
Mapped by Rosetta. Coded Value. Department or service. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| typetermid |
INTEGER |
Reference to HIEBus terminology properties for the claim.
|
| admitsource |
VARCHAR |
Mapped by Rosetta. For bed-assigned encounters, the disposition of the patient prior to admission. Useful to determine admission via ED or transfer. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| admitsourcecode |
VARCHAR |
Mapped by Rosetta. Coded Value. For bed-assigned encounters, the disposition of the patient prior to admission. Useful to determine admission via ED or transfer. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| admitsourcetermid |
INTEGER |
Reference to HIEBus terminology properties for the claim.
|
| dischargedisposition |
VARCHAR |
Mapped by Rosetta. For bed-assigned encounters, the disposition of patient after discharge. Useful to determine transfers to another facility. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| dischargedispositioncode |
VARCHAR |
Mapped by Rosetta. Coded Value. For bed-assigned encounters, the disposition of patient after discharge. Useful to determine transfers to another facility. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| dischargedispositiontermid |
INTEGER |
Reference to HIEBus terminology properties for the claim.
|
| admitdate |
TIMESTAMP |
If the encounter is related to a bed-assigned inpatient encounter, the admit date of the encounter. Otherwise, the date of service.
|
| dischargedate |
TIMESTAMP |
If the encounter is related to a bed-assigned inpatient encounter, the discharge date of the encounter. Otherwise, the date of service.
|
| provideridentifier |
VARCHAR |
The identifier assigned to the primary provider associated with the encounter.
|
| providername |
VARCHAR |
The name of the primary provider associated with the encounter.
|
| primarycaresetting |
VARCHAR |
Computed. A normalized description of the primary place of service for the encounter.
|
| primarycaresettingreason |
VARCHAR |
Computed. For traceability, an explanation for the primarycaresetting assignment.
|
| secondarycaresettings |
VARCHAR |
Computed. A comma delimited string of other care settings (for example ED or observation activity on an inpatient claim) determined for the encounter.
|
| annotations |
VARCHAR |
Computed. A comma delimited set of strings that represent computed features of the encounter.
|
| lastupdated |
TIMESTAMP |
System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.
|
