Søgning » Cambio Cosmic » FC_CONTACT
Tabel

FC_CONTACT


Beskrivelse ?

FC_CONTACT - Fact child table for actions

Størrelse (Antal rækker) ?

76806

Indhold (Kolonner/variable) ?

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