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