| 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 |