Posts

Showing posts with the label Learn PeopleSoft Coding

PeopleSoft - PeopleTools Configurations Records or Meta Tables

-
PeopleSoft - PeopleTools Configurations Records or Meta Tables PeopleSoft records/metadata tables, often referred to as "meta tables," store information about various PeopleSoft objects and configurations.  1. Object Definition Tables: PSRECDEFN : Contains definitions of records (tables) used in the application, including details like record type and description. PSDBFIELD : Stores field definitions, detailing the attributes of each field such as data type and length. PSPNLGROUP : Holds information about components, which are collections of pages that function together. PSPNLDEFN : Contains definitions of pages (interfaces) within the application. PSMENUDEFN : Stores menu definitions, organizing how components are presented to users. 2. Security Tables: PSOPRDEFN : Maintains user profile information, including user IDs and associated roles. PSROLEDEFN : Defines roles that group together permissions for easier security management. PSCLASSDEFN : Holds permission li...
Post a Comment
Read more

Best PeopleCode Examples | PeopleCode Hacks | Learn PeopleSoft Coding | How to PeopleCode | PeopleSoft Appdesigner Coding

-
Best PeopleCode Examples | PeopleCode Hacks | Learn PeopleSoft Coding | How to PeopleCode | PeopleSoft Appdesigner Coding Creating MSExcel with new sheets through peoplecode: Local object &oWorkApp, &oWorkBook; &sFilePath = "C:\temp\TEST_FL.xlsx"; &sFileDestPath = "C:\temp\Test.xlsx"; &oWorkApp = CreateObject("COM", "Excel.Application"); &oWorkApp.DisplayAlerts = "False"; ObjectSetProperty(&oWorkApp, "Visible", True); &oWorkBook = ObjectGetProperty(&oWorkApp, "Workbooks"); &oWorkBook.Open(&sFilePath); &oWorkSheet = &oWorkApp.Worksheets("Sheet1"); &oWorkSheet.Range("A1:C5").Font.Bold = True; &oWorkApp.WorkSheets.Add().Name = "Test"; &oWorkSheet = &oWorkApp.Worksheets("Test"); &oWorkSheet.Range("A1:C5").Font.Bold = True; &oWorkSheet.Cells(1, 1).Value = "I'm a...
Post a Comment
Read more