Table Detail Report
ENCNTR_DENIAL_APPEAL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Denied Days to Appeal Relationship |
Definition: | The denied days related to an appeal for an encounter. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_DENIAL_APPEAL_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ENCNTR_APPEAL_ID | DOUBLE | N | The ID of the appeal related to the denial. |
ENCNTR_DENIAL_APPEAL_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the Encntr_denial_appeal_reltn table. |
ENCNTR_DENIED_DAYS_ID | DOUBLE | N | Unique generated number that identifies a single row on the Encntr_denied_days table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ENCNTR_DENIAL_APPEAL_RELTN
Child Column in ENCNTR_DENIAL_APPEAL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_APPEAL_ID | ENCNTR_APPEAL | ENCNTR_APPEAL_ID |
ENCNTR_DENIED_DAYS_ID | ENCNTR_DENIED_DAYS | ENCNTR_DENIED_DAYS_ID |
ENCNTR_DENIED_DAYS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Denied Days |
Definition: | The denied day periods for an encounter. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_DENIED_DAYS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
APPEAL_BY_DT_TM | DATETIME | Y | The date to appeal the denied day period. |
BEG_DT_TM | DATETIME | Y | The begin date for the denied day period. |
CLAIM_NUMBER_TXT | VARCHAR(40) | N | Contains the patient account display claim number. |
CLOSED_DT_TM | DATETIME | Y | The date and time the denied day period was closed. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Unique generated number that identifies a single row on the Long_text table that represents a comment for this relationship. |
DENIAL_CATEGORY_CD | DOUBLE | N | The category of the denial period. |
DENIAL_PRSNL_ID | DOUBLE | N | Unique generated number that identifies a single row on the Prsnl table for the personnel in charge of the denied day period. |
DENIAL_REASON_CD | DOUBLE | N | The denial reason for the denied day period. |
DENIAL_RISK_AMOUNT | DOUBLE | N | The dollar amount that is at risk for loss from the denied day period. |
DENIAL_TYPE_CD | DOUBLE | N | The denial type for the denied day period. |
ENCNTR_DENIED_DAYS_ID | DOUBLE | N | Unique generated number that identifies a single row on the Encntr_denied_days table. |
ENCNTR_ID | DOUBLE | N | Unique generated number that identifies a single row on the Encounter table. The encounter associated with the denied days. |
END_DT_TM | DATETIME | Y | The end date for the denied day period. |
LETTER_DT_TM | DATETIME | Y | The date and time the letter was received for the denied day period. |
NOTICE_RECEIVED_DT_TM | DATETIME | Y | The date and time the noticed was received for the denied day period. |
PAYER_ORG_ID | DOUBLE | N | Unique generated number that identifies a single row on the Organization table for the payer of the denied day period. |
PFT_QUEUE_ITEM_ID | DOUBLE | Y | Uniquely identifies the related ProFit queue item. |
REMARK_CD | DOUBLE | N | The patient account remark code which can come from code set 26399, 26398 or 24730. |
RESP_PARTY_NURSE_UNIT_CD | DOUBLE | N | The nurse unit that is responsible for the avoidable days period. |
RESP_PARTY_OTHER_CD | DOUBLE | N | The entity that is responsible for the avoidable days period. |
RESP_PARTY_PRSNL_ID | DOUBLE | N | The personnel that is responsible for the avoidable days period. |
RESP_PARTY_SELF_IND | DOUBLE | N | Indicator for whether the patient or their family are responsible for the avoidable days period. |
RESP_PARTY_SERVICE_TYPE_CD | DOUBLE | N | The Service that is responsible for the avoidable days period. |
SERVICE_BEG_DT_TM | DATETIME | Y | The patient account service begin date time. |
SERVICE_END_DT_TM | DATETIME | Y | The patient account service end date time. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ENCNTR_DENIED_DAYS
Child Column in ENCNTR_DENIED_DAYS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
PAYER_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
DENIAL_PRSNL_ID | PRSNL | PERSON_ID | |
RESP_PARTY_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in ENCNTR_DENIED_DAYS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_DENIED_DAYS_ID | ENCNTR_DENIAL_APPEAL_RELTN | ENCNTR_DENIED_DAYS_ID |
ENCNTR_DOMAIN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Domain |
Definition: | The encounter domain table contains key information used to provide a specific domain view of a setof encounters (i.e., hospital census). A row in the encounter domain table will generally get created or deleted as the result of an ADT related event. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_DOMAIN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
ENCNTR_DOMAIN_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter domain table. It is an internal system assigned number. |
ENCNTR_DOMAIN_TYPE_CD | DOUBLE | N | Identifies the access path or index (I.e., nurse unit/room/bed) for a set or list of encounters in the encounter table. The set of encounters is determined by adding or deleting rows in this table when events (I.e., ATDs, etc.) occur in the system. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
LOC_BED_CD | DOUBLE | N | This field is the current patient location with a location type of bed. |
LOC_BUILDING_CD | DOUBLE | N | This field is the current patient location with a location type of building. |
LOC_FACILITY_CD | DOUBLE | N | This field is the current patient location with a location type of facility. |
LOC_NURSE_UNIT_CD | DOUBLE | N | This field is the current patient location with a location type of nurse unit. |
LOC_ROOM_CD | DOUBLE | N | This field is the current patient location with a location type of room. |
MED_SERVICE_CD | DOUBLE | N | The category of treatment, surgery, or general resources. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ENCNTR_DOMAIN
Child Column in ENCNTR_DOMAIN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
LOC_BED_CD | LOCATION | LOCATION_CD | |
LOC_BUILDING_CD | LOCATION | LOCATION_CD | |
LOC_FACILITY_CD | LOCATION | LOCATION_CD | |
LOC_NURSE_UNIT_CD | LOCATION | LOCATION_CD | |
LOC_ROOM_CD | LOCATION | LOCATION_CD | |
PERSON_ID | PERSON | PERSON_ID |
ENCNTR_ENCNTR_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Encounter Relation |
Definition: | Encounter to Encounter relationships |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_ENCNTR_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ENCNTR_ENCNTR_RELTN_ID | DOUBLE | N | Identifies a Encounter Encounter relationship |
ENCNTR_ID | DOUBLE | N | Encounter to whom an Encounter relationship exists. |
ENCNTR_RELTN_TYPE_CD | DOUBLE | N | Type of Encounter Relationship |
RELATED_ENCNTR_ID | DOUBLE | N | The "Related" Encounter to the relationship |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ENCNTR_ENCNTR_RELTN
Child Column in ENCNTR_ENCNTR_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
RELATED_ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
ENCNTR_FINANCIAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Financial |
Definition: | The encounter financial table is used to group separate clinical encounters under one financial number for billing purposes. A single financial encounter can have one or more clinical encounters on the encounter table. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_FINANCIAL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BILL_TYPE_CD | DOUBLE | Y | The type of bill used for this encounter financial row. (e.g. Patient vs. client invoice, etc.) |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
ENCNTR_FINANCIAL_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter financial table. It is an internal system assigned number. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
RESEARCH_ACCOUNT | VARCHAR(100) | Y | Textual name of the client-defined research account used for this encounter (or set of encounters). |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ENCNTR_FINANCIAL
Child Column in ENCNTR_FINANCIAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
Parent Column in ENCNTR_FINANCIAL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_FINANCIAL_ID | ENCOUNTER | ENCNTR_FINANCIAL_ID |
ORDERS | ENCNTR_FINANCIAL_ID | ||
PM_TRANSACTION | O_ENCNTR_FIN_ID |