FC_Contact_ID |
Primary key for the table |
Cosmic_ID |
Reference to the contact |
Child |
COSMICs unique ID for the action |
Child_Key |
COSMICs unique version ID for the action |
Offer_ID |
Reference to the offer version ID |
Offer_Key |
Reference to the offer ID |
SOC_ID |
Reference to the patient |
SOC_C |
SOC_C for the object in FC_CONTACT |
SOC_G |
Reference to the group which this contact is a part of |
Type |
Name for type of action |
SubType |
Name for subtype of action |
Active |
Indicates with true/false if action is active |
Description |
Description/Comment on action |
Creator |
User_ID for who created/changed action |
Created |
Timestamp for creatation/latest change |
Reason |
Reason for the object in FC_CONTACT |
Commitment_ID |
Reference to the Commitment |
Responsible_Unit |
Responsible_Unit |
Responsible_Staff |
Responsible_Staff |
Performing_Unit |
Performing_Unit |
Performing_Staff |
Performing_Staff |
StatusName |
Name for the status of the action |
Status |
ID for the status of |
BeginDateTime |
Start date for current status |
EndDateTime |
End date for current status |
Priority |
Priority |
VisitType |
Visittype |
Category |
Category |
ShortNotice |
Short notice |
RP_careReason |
Care reason |
RP_careDays |
Planned number of care days |
RP_careInDate |
Planned admission date |
RP_careOutDate |
Planned dischare date |
RP_calldate |
Callindate |
RP_regdate |
Registrationdate |
RP_team |
Team |
RP_deflectionReason |
Deflection reason |
RP_mainAction |
Indicates with true/false if action is a main action. Is set to NULL if action is created when a direct contact is created. |
Sysdate |
Date when record got loaded/updated in CI |
Staff_Role |
Profession for planned careprovider (planningform) |
Category_2 |
Category 2 |