1758810 - Add Parent ID fields and batch job to update them

Status: RESOLVED FIXED

(CA Program :: Common CA Database, task)

Description

[Kathleen Wilson]

Add new field to intermediate certificate records called "Parent ID for Audits" and "Parent ID for Policies". These fields will be used for displaying audit and policy information that is inherited from further up the CA hierarchy when the "Same as Parent" boxes are checked.

Have an hourly process check for changes that cause updates to these fields.

Comment 1

[Poonam Bhargava]

A new method has been added in Account Trigger to populate key fields. This method is invoked when a new intermediate cert is added OR
when Parent Id/Audit Same As Parent/CPCPS Same as Parent is updated. Below field values are recalculated for the entire CA hierarchy of the updated intermediate cert. The trigger launches future method to recalculate the fields and they are populated almost instantly. There could be a delay of few seconds.

Root_Cert_Id
Parent_ID_for_Audits
Parent_ID_for_Policies
Mozilla_CA_Owner_Status*
Mozilla_Root_Status*
Microsoft_CA_Owner_Status*
Microsoft_Root_Status*
Apple_CA_Owner_Status*
Apple_Root_Status*

The asterisk fields are not needed any more as we have new lookup fields. But they are currently being used in many programs and reports. We will need to replace those fields so that we can discontinue the hourly batch job.

The changes are are ready for testing in sandbox. Once the changes are confirmed, I will move the them to production org.

Comment 2

[Kathleen Wilson]

Tested in Sandbox, and it looks good. I also verified that the new "Parent ID" fields get updated when I change the parent of the certificate.

Please proceed with moving the changes to Production.

Comment 3

[Poonam Bhargava]

The above changes have been deployed in production. Also ran one-time script to populate Parent Id fields.

Comment 4

[Kathleen Wilson]

Thanks!