
Portal (Structure and Content): Tables holding portal content references and permission lists authorized. PeopleCode Meta Data: Tables holding PeopleCode Meta Data.

Page Meta Data: Tables holding Page Meta Data. Message Catalog: Tables holding Message Catalog Entries. Menu Meta Data: Tables holding Menu Meta Data. HTML & Image Meta Data: Tables holding HTML and Image Meta Data. PSRECDEFN.RECTYPE, PSDBFIELD.FIELDTYPE, PSPNLFIELD.FIELDTYPE, PSSQLDEFN.SQLTYPEįile Layout Definitions: Tables holding File Layout Segment and Field definitions. PSPROJECTITEM.OBJECTTYPE, PSPROJECTITEM.UPGRADEACTION, PSPROJECTITEM.SOURCESTATUS, Here’s a list of ones that I have used in some fashion or another…Īlso see the SQL Project Items List via SQL which utilizes many of these tables to pull all objects and details about the objects included in your PeopleSoft project.Īpplication Engine Meta Data: Tables holding Application Engine Meta Data for the AE, Section, Steps and SQL.Ĭhange Control: Tables holding PeopleTools project change history and current locks on Tools objects.Ĭomponent Interface Meta Data: Tables holding Component Interface Meta Data.Ĭomponent Meta Data: Tables holding Component Meta Data.įield Meta Data: Tables holding PeopleTools Field information.įield Values for Tools Tables: Find field values for the following RECORD.FIELDNAME: I heavily utilize the Tools tables for reporting, object-oriented programming, and speeding up development tasks. &eMail.ErrorDescription &eMail.ErrorDetails) MessageBox(0, "", 0, 0, "Email Failed Before Sending" * &email.ErrorDescription, email.ErrorDetails */ * Or just get the formatted messages from */ * Get the Message Set Number, message number */ MessageBox(0, "", 0, 0, "Email Partially delivered" &eMail.InvalidAddresses &eMail.ValidSentAddresses MessageBox(0, "", 0, 0, "Email Not delivered" * Check &email.InvalidAddresses, &email.ValidSentAddresses */ MessageBox(0, "", 0, 0, "Email Sent Successfully") * Invoke the method to generate the email */ * Could be "text/plain", "text/html", or */ &email = create PT_MCF_MAIL:MCFOutboundEmail() * &Email_Address_From takes standard email format: */

* &Email_Address_To takes standard email format: */ &BodyText_or_HTML as string, &ContentType as string) Local PT_MCF_MAIL:MCFOutboundEmail &email įunction Email_Example(&Email_Address_To As string, &Email_Address_From As string, &Subject As string,

The Application Package is easier to use, and in my opinion more reliable with HTML text than the function SendMail() which has been traditionally used.Import PT_MCF_MAIL:*
