Coverage Formula for PS-Benefits from HCM9.x and insight on how it is created by the data conversion process
After upgrade to PeopleSoft 9.1\9.0 from prior 8.x releases noticed that in PS_BN_FORMULA table the description is also populated with ...
Formerly Shyam's PeopleSoft Blog
After upgrade to PeopleSoft 9.1\9.0 from prior 8.x releases noticed that in PS_BN_FORMULA table the description is also populated with ...
After every user initiated save, PeopleSoft delivered "Saved" image(yes it is not a text and the image name is SAVE_CONFIRM) that...
The below SQL will give all the records of a component along with its corresponding occurs levels: SELECT DISTINCT D . recname ...
The below specified queries are no big deal as we can retrieve the information by viewing the respective definition in Application Designer...
SQL query to get all the child records for a parent record: select recname from psrecdefn CONNECT BY PRIOR RECNAME=PARENTRECNAME START...