| JournalNote_ID |
Primary key for the table |
| Cosmic_ID |
COSMICs unique ID for the |
| SOC_ID |
Reference to the patient |
| SOC_C |
SOC_C for the object in F_JOURNALNOTE |
| Secretary_ID |
Reference to Secretary who first created medical note |
| CounterSigner_Resource_ID |
Reference to counter signer |
| CounterSigner_Signer_ID |
User_ID for countersigner |
| CounterSigner_Timestamp |
Timestamp for countersigning |
| Attester_Resource_ID |
Reference to attester |
| Attester_Signer_ID |
User_ID for attester |
| Attester_Signer_Timestamp |
Timestamp for attesting |
| CareProvider_ID |
Reference to careprovider |
| CareProvider_Initials |
Initials for careprovider |
| CareProvider_Name |
Name for careprovider |
| CareProvider_Role |
Profession of the careprovider |
| CareProvider_Role_Key |
Reference to the profession of the careprovider |
| Contact_ID |
Reference to the Contact |
| Commitment_ID |
Reference to the Commitment |
| Contact_Datetime |
Contact start if note is connected to a contact |
| Unit_ID |
Reference to the unit registered on the note |
| Unit_Name |
Name of the unit registered on the note |
| InvalidateReason |
InvalidateReason |
| Status |
Name for the status of the medical note |
| UserStatus_ID |
User_ID for who signed the medical note |
| Signer_Timestamp |
Timestamp for when medical note was signed |
| Journal_Datetime |
Journal datetime |
| Created_Datetime |
Timestamp for when medical not was created or latest change |
| NoteType |
Notetype |
| Type |
Name for systemtype of medical note |
| Form_ID |
Reference to journalform |
| Form_Key |
Form_Key for the object in F_JOURNALNOTE |
| Active |
Indicates with Ja/Nej if medical note is active. Nej=deleted |
| Modified |
Modified for the object in F_JOURNALNOTE |
| Observation |
On notes of type MeasureType or ResultType: Reference to not of type Observation |
| Measure |
On notes of type ResultType: Reference to note of type MeasureType |
| Dictate |
Reference to dictate |
| PdfFormID |
Reference to Pdf-form |
| FdfFormID |
Reference to Fdf-form |
| f_Domain |
f_Domain for the object in F_JOURNALNOTE |
| Sex |
Sex |
| Age |
Age at journaldatetime |
| Geo_ID |
Reference to the geographical instance |
| Sysdate |
Date when record got loaded/updated in CI |
| Journal_Datetime_Period |
Reference to the periodical instance |
| Signer_Timestamp_Period |
Reference to the periodical instance |