Søgning » Cambio Cosmic » F_COMMITMENT
Tabel

F_COMMITMENT


Beskrivelse ?

F_COMMITMENT - Facttable for commitments

Størrelse (Antal rækker) ?

45539

Indhold (Kolonner/variable) ?

Navn Indhold
Commitment_ID Primary key for the table
Cosmic_ID COSMICs unique ID for the commitment
SOC_ID Reference to the patient
SOC_C SOC_C for the object in F_COMMITMENT
SOC_G SOC_G for the object in F_COMMITMENT
Creator_ID User_ID for who created/changed the commitment
Unit_ID Reference to responsible unit
CareProvider_ID Reference to responsible staff
Active Indicates with true/false if commitment is active
Status Name for the status of
Created_Datetime Timestamp for when commitment was created/changed
Classification Commitent classification
Priority Given priority for the commitment
Type Name for type of commitment
Start_Date Commitments start
Stop_Date Commitments end
Sex Patients sex
Age Patients age when commitment started
Geo_ID Reference to the geographical instance
Sysdate Date when record got loaded/updated in CI