HSP_ACCT_CA_FLG_HX
Description:
This table stores the coding and abstracting flags that have been added to or removed from the hospital accounts.

Primary Key
Column Name Ordinal Position
ACCT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCT_ID NUMERIC No
The unique ID of the hospital account record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CA_FLAG_HX_C_NAME VARCHAR No
This item lists the C&A Flags that have been added to or removed from the hospital account.
May contain organization-specific values: Yes
Category Entries:
Coding interface record lookup error
Coding filed after billing
ADT Synchronization error
Coding Query outstanding
Pull Info executed by Nightly Processing
CDI Query outstanding
Needs recoding
Account combine error
ADT synchronization skipped
Coding info copy error
Review needed - episode merged
Review needed - episode consultant/TFC changed
Review needed - episode start updated
Review needed - episode end updated
Review needed - episode reopened
Review needed - episode converted
Review needed - late procedure modification
Review needed - account pathway changed
Review needed - linked problem changed in another encounter
Review needed - some diagnoses added directly on the source account were not merged
Review needed - merge from outpatient source hospital account
Review needed - linked clinical problem failed to update
Extract to Sundhedsdatabank
4 CA_FLAG_HX_A_USR_YN VARCHAR No
This item indicates whether the C&A Flag was added by a user or by the system.
May contain organization-specific values: No
Category Entries:
No
Yes
5 CA_FLAG_HX_A_INST DATETIME (Local) No
This item indicates when the Coding and Abstracting (C&A) Flag was added.
6 CA_FLAG_HX_A_EMP_ID VARCHAR No
The user who added this C&A flag
7 CA_FLAG_HX_A_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 CA_FLAG_HX_A_CMT VARCHAR No
A comment specified when the C&A Flag was added.
9 CA_FLAG_HX_R_USR_YN VARCHAR No
This item indicates whether the C&A Flag was removed by a user or by the system.
The category values for this column were already listed for column: CA_FLAG_HX_A_USR_YN
10 CA_FLAG_HX_R_INST DATETIME (Local) No
This item indicates when the Coding and Abstracting (C&A) Flag was removed.
11 CA_FLAG_HX_R_EMP_ID VARCHAR No
The user who removed this C&A flag
12 CA_FLAG_HX_R_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 CA_FLAG_HX_R_CMT VARCHAR No
A comment specified when the C&A Flag was removed.