Add a Column in Country country_core Table

Ajay Singh2
Tera Contributor

The Table: Country [core_country] are we able to add a column ‘Blocked Country’ as a true/false field to identify what countries are blocked. If the blocked country status changes, we won’t need to update the form. The workflow will be off of Blocked Country = True.

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@Ajay Singh2 

you need to be careful in creating custom fields on OOB tables.

Country is a table which comes as part of foundation data and won't frequently change.

What should happen if the field changes to false? which form won't be allowed to update?

Please explain your business requirement in detail.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Below should be the three tasking scenarios.

Scenario 1: Do you intend on logging in or working from the listed country(ies) = NO

·         Task 1 - US-IT-SRM-SecOps-DR, Notification of International Travel - <Requested For>

Scenario 2: Do you intend on logging in or working from the listed country(ies) = YES and Blocked Country = False

·         Task 1 - US-IT-SRM-SecOps-DR, Notification of International Travel - <Requested For>

·         Task 2 - US-IT-SRM-SecOps-Tier1, Notification of International Travel - <Requested For>

·         Task 3 - US-IT-SRM-IAM, Notification of International Travel – Add Okta Groups

**Return Date Selected**

·         Task 4 - US-IT-SRM-IAM, Notification of International Travel – Remove Okta Groups

Scenario 3: Do you intend on logging in or working from the listed country(ies) = YES and Blocked Country = True

·         Task 1 - US-IT-SRM-SecOps-DR, Notification of International Travel - <Requested For>

·         Task 2 - US-IT-SRM-SecOps-Tier1, Notification of International Travel - <Requested For>

·         Task 3 - US-IT-SRM-IAM, Notification of International Travel – Add Okta Groups

**Return Date Selected**

·         Task 4 - US-IT-SRM-IAM, Notification of International Travel – Remove Okta Groups

·         Task 5 - US-IT-SRM-SecOps-Tier1, Change Password - International Travel to Blocked Country

 

 

And True/false will be done by client. I need to create only Column in Core_country Table.