Insert Delete Order

cBizOne

1. Link a Company to Contact
Insert Links
UPDATE Contacts

FromID ToID Type SubType
CN00000178 CM00000024 1 1

2. Link a Company to Consultant
Insert Links
UPDATE Consultants

FromID ToID Type SubType
CS00000108 CM00000020 1 1

3. Link a Contact to Requirement
Insert Links
Insert Requirements

FromID ToID Type SubType
RQ00000038 CN00000024 1 1

4. Link Received a candidate to requirement
Insert Links
Update Counters
Insert MLinkInfo

FromID ToID Type SubType
CS00000105 RQ00000038 2 1

MLinkIntID FromID ToID Type SubType MLinkType MLinkSubType
ML00000032 CS00000105 RQ00000038 2 1 Manual Manual

DELETC Received a candidate to requirement
Deletion Links
Deletion MLinkInfo

5. Link a potential to requirement
Insert Links
Update Counters
Insert MLinkInfo

FromID ToID Type SubType
CS00000105 RQ00000038 101 1

MLinkIntID FromID ToID Type SubType MLinkType MLinkSubType
ML00000033 CS00000105 RQ00000038 101 1 Manual Manual

DELETE a potential to requirement
Deletion Links
Deletion MLinkInfo

6. Link Manual Submission to a Requirement
Insert Links
Update Counters
Insert MLinkInfo

FromID ToID Type SubType
CS00000105 RQ00000038 1 1

DELETE Manual Submission to a Requirement
Deletion Links
Deletion MLinkInfo

7. Email Submissions
Update Counters
Insert EMailsSent
Insert Links
Insert Links

EMSentIntID SentFromName SentFromEMail SentToIntID SentToDisplayName MailType
ES00000099 Sangem Vishnu Murthy vishnus@cbizsoftindia.com RQ00000038 Adam Douglas Resume

FromID ToID Type SubType
CS00000105 ES00000099 1 1
ES00000099 RQ00000038 1 1

DELETE Email Submissions
Deletion Links

8.Status on a Candidate from Requirement xTabs
Update Counters
Insert Links
Insert Links
Insert Links
Insert Reminders

FromID ToID Type SubType
RM00000111 RQ00000038 1 1
RM00000111 CN00000024 1 1
RM00000111 CS00000105 1 1

RemIntID RemType ApptType ApptSubType Priority ItemIntID
RM00000111 Status Status 1st Interview CS00000105

DELETE Status on a Candidate from Requirement xTabs
Deletion Links
Deletion Links
Deletion Links
Deletion Reminders

9. Note on a requirement
Update Counters
Insert Links
Insert Links
Insert Reminders

FromID ToID Type SubType
RM00000112 CN00000024 1 1
RM00000112 RQ00000038 1 1

DELETE Note on a requirement
Deletion Links
Deletion Links
Deletion Reminders

10. Appointment on Requirement
Update Counters
Insert Links
Insert Links
Insert Reminders

FromID ToID Type SubType
RM00000113 CN00000024 1 1
RM00000113 RQ00000038 1 1

RemIntID RemType ApptType ApptSubType Priority ItemIntID
RM00000113 Appointment Meeting Normal RQ00000038

DELETE Appointment on Requirement
Deletion Links
Deletion Links
Deletion Reminders

11. Email Send to a Contact
Update Counters
Insert EMailsSent
Insert Links

EMSentIntID SentFromName SentFromEMail SentToIntID
ES00000100 Sangem Vishnu Murthy support@cbizsoft.com CN00000175

FromID ToID Type SubType
ES00000100 CN00000175 1 1

DELETE Email Send to a Contact
Deletion Links
Deletion EMailsSent

12. Email Linked to a Contact
Insert EMailsLinked
Insert Links

EMLinkIntID SentFromName SentFromEMail SentToIntID SentToDisplayName SentToEMail MailType
EL00000001 Sarvar Abdullaev sarrtv@gmail.com CN00000175 Srini Karlapudi srini.k@cbizsoft.com Received

FromID ToID Type SubType
EL00000001 CN00000175 1 1

DELETE Email Linked to a Contact
Deletion Links
Deletion EMailsLinked