I am trying to create a SQL query between policyperiod and effectDatedFields to get the effectedDatedFields record for a specific policyperiod. I am not sure how to do this. I cannot find any foreign key in either table pointing to the other. Any help would be greatly appreciated.
I have looked at every column in both tables for something to join on. I have looked at the data dictionary for both entities for the same. I have even went on guidewire education and look at some of the data model sections to try and figure out how to model a one-to-one relationship in the database.
The pc_effectivedatedfields table contains a field called BranchID. This field can be used to join this table with pc_policyperiod table using ID column. However, it's important to note that the PolicyPeriod entity is of type effdatedbranch, while the pc_effectivedatedfields table belongs to the effdated type. Consequently, if there have been policy changes to the policy during its term and any of the fields in the pc_effectivedatedfields table have been modified, you will encounter multiple entries in the pc_effectivedatedfields table for a single pc_policyperiod entry.
If you'd like to gain a better understanding of how slicing works in PolicyCenter, I would suggest taking some time to experiment in PolicyCenter and observe the results directly within the database. It can be a valuable hands-on experience to enhance your comprehension of this concept.