A subrecord in PeopleSoft is a way to group fields together and place them on a record, view, or a temp table. Here is a query you can use to identify records that have a specific subrecord.
When you modify a subrecord in Peopltools as for example adding a field to it. Make sure you modify (re-build, or alter) all the tables that the subrecord touches. You can use the SQL above to track down all the affected record but you really only want actual physical tables, views and temp tables. So, we will add rectype criteria to filter our results.
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|