Tuesday, August 4, 2015

How to Remove mystartsearch.com Homepage (Removal Help)


Question.


I have something called mystartsearch.com that keeps coming on my screen when on Internet Explorer and even when I am in my bank Online it closes my bank page and takes its place. Could you do something with that? Please help me How to remove mystartsearch.com?  I shall send you a generous donation because then you will deserve it in my case. I sent you an attachment of this.
How to remove mystartsearch.com from Internet Explorer, Google Chrome, Mozilla Firefox.

                                                                                                                                                          

Explanation & solution

Sure, we’ll help you to remove mystartsearch.com  from your computer permanently. First, we would like to explain about mystartsearch.com so that everybody can know that process what is mystartsearch.com? And how and why it enters into the computer and what would be the its removal steps.
Mystartsearch.com is a browser hijacker. It works in your computer as a browser’s search engine and displays lots of advertisements and sponsored links while using its search engine. Mystartsearch.com set as homepage on your browsers so users forced to use the mystartsearch.com  search engine.
mystartsearch.com-removal-help
Now we are explaining here to let you know how it to come into the computer. It usually comes into the computer through 3rd party downloading websites or unwanted free softwares. Actually these types of Adware companies added their installer embedded with these type third party websites’s installers. So eventually, it’ll be automatically installed on your computer while downloading and installing  any software from 3rd party downloading websites.
We are giving you an example: Suppose, you want to download a flash player into your computer to play the games online. You go to online search engine like “yahoo search” and search there “download flash player” and click on search button then you get results and choose one result and click on them and download flash player and installed it. But you know where you did mistake? You did a mistake while clicking on found results. You clicked on the wrong website (3rd party downloading website). Actually, these types of websites’s installers are embedded with Adwares.
Once mystartsearch.com got installed into your computer, you’ll also get lots of other changes to your computer like: default search engine, default browser, default homepage, default URL search and DNS settings are redirected tohttp://mystartsearch.com.
It’s technically installs on your all the browsers as an extension and take over all the settings rights. After it installed on your computer you can’t be change most of settings of the browser because mystartsearch.com has changed all the setting of a browser.
Mystartsearch.com leaves lots of traces of files, folders and registry traces which had been created while installing it on your computer. Even, its own uninstall utility won’t be uninstalled. Intentionally it won’t uninstall adware exactly so that can come again through these remain traces.

Removal Instructions

Automatic Fixit

Download Adware Remover Tool v3.9 to remove Mystartsearch.com Automatically, It’s aFreeware utility specially designed for Adware Removal. This tool can remove most of the Adwares from Internet Explorer, Google Chrome and Mozilla Firefox. It can remove all the traces of Mystartsearch.com from registry as well.
TSA_Fixit
                                                                                                                                                  

Manual Steps

Step 1: To Uninstall Mystartsearch.com from computer

  • Click on Start button and then click on Control Panel.
  • Now click on Programs –> Uninstall a program or Program and Features(Windows-7, 8, Vista). You also may click on “Uninstall a program”
Uninstall a program image 1
Uninstall a program for Vista, 7, 8
  • For Windows XP users click on Add/Remove Programs.
Uninstall a program image 2
Uninstall a program for Windows xp
  • You’ll get a window which has listed all the installed programs.
  • Uninstall “Mystartsearch.com” from there.
    (Note: If you face any type of problem while uninstalling Mystartsearch.com” then you can use Revo uninstaller tool, it can it remove forcefully. Click here to download Revo Uninstaller Tool).
  • Also do uninstall all the unwanted & unknown programs which are listed in “Suspicious Programs list”(See below for the list). You should uninstall them immediately if you found any into your computer.
    (Note: If you face any type of problem while uninstalling anything from control panel then you can use Revo uninstaller tool, it can remove any software forcefully. Click here to download Revo Uninstaller Tool).
  • Uninstall all unwanted programs
  • Uninstall all unwanted programs

Suspicious Programs list

  • Browser defender
  • HD-Plus 1.8
  • Vplay
  • Browser protect
  • Browser protected by conduit
  • Delta search, Babylon
  • LessTabs
  • WebCake 3.0
  • Yealt
  • LyricsContainer
  • VideoSaver
  • AddLyrics
  • privacy safe guard
  • unfriend checker
  • Price peep today
  • Coupon amazine
  • TidyNetwork.com
  • DownloadTerms 1.0
  • Yontoo
  • Also uninstall all the unwanted & unknown programs which are not listed here.
__________________________________________________________________________________________

Step 2 : To Remove Mystartsearch.com from Internet Explorer.

Step 2.1: Remove Mystartsearch.com from homepage
  • Open Internet Explorer then go to Tools menu (Press “F10” key once to active the menu bar) and then click on Internet Option a configuration page will be opened, then click on General tab. Now look into under HOME PAGE Edit Box you gotwww.Mystartsearch.com, replace it to www.google.com, then click on apply andclose.
Step 2.2: Remove Mystartsearch.com add-ons from Internet Explorer.
  • Open Internet Explorer then go to Tools menu (press “F10″ key once to active menu bar) and then click on Internet Option a configuration page will be opened
  • Click on Programs tab then click on Manage Add-ons, now you’ll get a window which have listed all the installed add-ons.
  • Now disable the Mystartsearch.com add-on, also disable all the unknown / unwanted add-ons from this list. (As per below screenshot).
disable-add-ons-from-ie
Step 2.3: Reset Internet Explorer
  • Open Internet Explorer. Click on Tools menu (Press “F10” key once to active the menu bar), click on Internet Option. A internet option window will open.
  • For IE9, IE10 users may click on Gear icon IE Gear Icon. Then click on tools.
  • Click on Advanced tab then click on RESET button.
  • Now you will get a new popup for confirmation, tick mark on Delete personal setting then click on RESET button on that. (As shown on below screenshot)
  • Now your Internet Explorer has been Restored to default settings.
Internet Explorer Reset2
  • Now you will appear a popup stated “complete all the tasks”. After completion click on close button.
__________________________________________________________________________________________

Step 3 : To Remove Mystartsearch.com from Mozilla Firefox

Step 3.1 : Remove Mystartsearch.com from Mozilla Hompeage
  • Open Mozilla Firefox, Click on Tools menu (If tools menu doesn’t appear then press “F10″ key once to active the menu bar) then go to Options, after that a configuration page will be openedthen click on General tab and then look on the very first section named as Startup. Under start-up you will see a HOME PAGE Edit Box, under this edit box you will see www.Mystartsearch.com, please replace it towww.google.com, then click on apply and close.
  • Restart Firefox Browser
Step 3.2 : Remove Mystartsearch.com from add-ons
  • Open Firefox and then go the Tools menu (Press “F10” key once to active Menu bar) click on Add-ons, you’ll get a page click on extensions from the left side pane. now look on right side pane you’ll get all the installed add-ons listed on there. Disable or Remove Mystartsearch.com add-on, also disable all the unknown / unwanted add-ons from there. (As per below screen shot)
remove-unwanted-addons-from-firefox
Step 3.3: Reset Mozilla Firefox
  • Open Firefox and then go the Help menu (Press “F10” key once to active Menu bar)
  • Go to Help menu then click on “Troubleshooting information”
    Note: you can also open this page in this ways, open Firefox then type this command in the address bar “about:support” (without quote) and then hit enter or OK.
  • You will get a page “Troubleshooting information” page, here you will get “Reset Firefox” option in the right side of the page.
  • Click on Reset Firefox option and then follow their instructions to reset firefox.
  • Mozilla Firefox should be Restored.
Firefox Reset1
Firefox Reset2                                                                                                                                                  

Step 4 : To Remove Mystartsearch.com from Google Chrome

Step 4.1: Remove unwanted homepage & search engine from Google Chrome
  • Start Google Chrome, click on options iconGoogle Chrome Options Icon (Located in very top right side of the browser), click on Settings. You will get a configuration page.
  • Under configuration page find a option named as “Open a specific page or set of pages” click on its Set Pages. Another window will come up. Here you will appear the bunch of URL’s under “Set pages”. Delete all them and then enter only one which you want to use as your home page.
Google Chrome Homepage step1
Google Chrome Homepage Reset step1
Google Chrome Homepage2
Google Chrome Homepage reset step 2
  • In the same configuration page click on Manage search engines button. Delete allthe search engines from there, just keep only www.goole.com as your default search Engine.
Google Chrome Homepage3
Google Chrome search engine step 3
Google Chrome Homepage4
Google Chrome search engine step 4
Google Chrome Homepage5
Google Chrome search engine Step5
Step 4.2 : Remove unwanted extensions from Google Chrome
  • Start Google Chrome, click on options iconGoogle Chrome Options Icon (Located in very top right side of the browser), then click on Tools then, click on Extensions. (As shown on below screenshot)
Google Chrome remove extensions1
  • You will get a configuration page which have listed all the installed extensions, remove Mystartsearch.com extension. Also remove all the unknown / unwanted extensions from there. To remove them, click on remove (recycle bin) icon Google Chrome remove extensions button(as shown on screenshot)
Google Chrome remove extensions2
Step 4.3 : Reset Google Chrome – Restore to default setting.
  • Open Google Chrome, click on menu icon Google Chrome Options Icon and then click on settings (Note:menu icon is located right side top corner it is look like this: Google Chrome Options Icon ). (See the below screenshot for better understand)
  • Scroll down and click on “Show advanced settings…”option, after click on that you’ll appear some more options in bottom of the page. Now scroll down more and click on “Reset Browser setting” option. (See the below screenshot for better understand)
  • Now, Close all Google Chrome browser’s window and reopen it again.
google-chrome-reset-method1
google-chrome-reset-method2

________________________________________________________________________                 _

Step 5 : Remove Mystartsearch.com infection from Windows shortcuts.

Follow the following steps for all browser’s shortcuts like: Internet Explorer, Firefox, Internet Explorer and Safari as well.
  • Right click on the shortcut of Internet Explorer and then do left click on theproperties option. You’ll get a shortcut’s properties.
  • Click on shortcut tab and then delete the “www.Mystartsearch.com/?utm” string from target field.
  • Need to delete this URL:
shortcut-clean1
shortcut-cleaning-help1
Repeat the above steps on all browser’s shortcuts like: Internet Explorer, Firefox, Internet Explorer, Safari in all location Desktop / Taskbar / Startmenu.
  • Remove Mystartsearch.com infection from startmenu’s shortcuts.
shortcut-clean3
  • Remove Mystartsearch.com infection from taskbar’s shortcuts.
shortcut-clean4
___________________________________________________________________________________________

Step 6 : To Remove Mystartsearch.com from Registry

  • Press “window key + R” (Flag sign key + R) you will get Run box then type “REGEDIT” into the run box then click on OK. You’ll get a registry editor window.
  • In the registry editor, click on Edit menu and then click on find option, you’ll get edit box to search any string into registry editor
  • Type “Mystartsearch.com” into the find box and then click on Find Next.
  • The search result will highlight the key or value which have contains theMystartsearch.com string.
  • Now delete the Registry Key/Value/Value-Data if any one contains “Mystartsearch.com” string (must see the example screenshot below)
    Note:- Do not delete the complete value data, just delete the Mystartsearch.com path only (for example see screenshot3 below)
  • Use F3 key to find Next. and do the last step to all results.
  • We are giving you the example on “Conduit” Adware.
Screenshot 1
Registry-cleaning-guide1
Screenshot 2
Registry-cleaning-guide2
Screenshot 3
Registry-cleaning-guide3
__________________________________________________________________________________________

Step 7 : To Remove Mystartsearch.com from Autorun Tasks

  • Click on Start button and then do Right-Click on the computer and then do left-click on Manage. A manage window will appear.
  • In the manage window click on Tasks Scheduler from right side pane, then click on “Task Scheduler Library“, Now look on left side pane and Remove all the Tasks which have contains Mystartsearch.com string and also remove all the unknown / unwanted tasks from there (As per the screenshot below).
scheduled-tasks-removal
__________________________________________________________________________________________

Step 8 : To Remove Mystartsearch.com from Startup

  • Press “window key + R” (Flag sign key + R) you will get Run box then type “MSCONFIG into the run box then click on OK. You’ll get a msconfig window.
  • In the msconfig window click on Startup tab, here you’ll get all the startup entries, so look on the list and then do Un-check the entries which is containsMystartsearch.com. Also Un-check all the others entries which you found unwanted. then click on OK to apply all the changes.
remove-unwanted-startup
__________________________________________________________________________________________

Step 9 : To Remove Mystartsearch.com from Services

  • Press “window key + R” (Flag sign key + R) you will get Run box then type “MSCONFIG” into the run box then click on OK. You’ll get a msconfig window.
  • In the msconfig window click on Services tab, here you’ll get all the start-up services list, click on “Hide Windows Services” all the windows related services will be hidden. now it’s only display the 3rd party installed services, now look on the list and then do Un-check the service which have contains Mystartsearch.com. Also Un-check all the unknown / unwanted services. then click on OK to apply all the changes.
remove-unwanted-services
__________________________________________________________________________________________

Step 10 : To remove Mystartsearch.com registry entries withAdwcleaner.exe

10.1 : Download AdwCleaner from the below link.

Click Here to Download: Adwcleaner.exe

10.2 : Run that downloaded file (Adwcleaner.exe).
10.3 : When you get it started, click on scan button to search the Mystartsearch.com files and registry entries (As shown below screenshot).
adwcleaner-scanning-process
10.5 : When scanning process will be finished, click on Clean button to delete all the Mystartsearch.com files and registry entries (as shown on below screenshot)
adwcleaner-cleanup-process

                                                                                                                                                                   

Step 11 : To remove Mystartsearch.com with Hitman-Pro

Click here to Download Hitmanpro_x32bit.exe

Click here to Download Hitmanpro_x64bit.exe

Hitmanpro-found-adware                                                                                                                                                                   

Step 12 : To remove Mystartsearch.com with Malwarebytes.

12.1 : Download Malwarebytes Anti-Malware Free, then double click on it to install it.

Click Here to Download Malwarebytes.exe

How to use malwarebytes
How to use malwarebytes
12.2 : Update online Virus Definition
How to use malwarebytesHow to use malwarebytes
12.3 : Tick mark on “Perform quick scan” then click on Scan
12.4 : When the scan done click on “Show results”How to use malwarebytes
12.5 : After clicking on Show result it will you a another window where you will get thefound threats. Click on “Remove Selected”
How to use malwarebytes
                                                                                                                                                          

Tuesday, July 28, 2015

PeopleSoft Fluid User Interface

With the latest release of PeopleTools 8.54  , Oracle has introduced  the Fluid User  Interface experience.
The Fluid UI provides the users with the ability to access PeopleSoft applications across a variety of form factors from smart phones to tablets to desktops/laptops. Fluid also provides a common user experience on variety of devices regardless of the screen size. Through this responsive design, browser will resize itself depending on device size.

Lets have  a look at the home page that is rendered after the latest peopletools has been used.



The important features of home pages are as below:
  •  Home Pages
  •  Tiles
  • PeopleSoft Search widget
  •   Notifications widget
  • Actions widget
  • Navigation Bar widget.
The fundamental feature of the Fluid Model is the Home Page which provides the base for the users or the customers to navigate and carry out the respective works.
In a way Fluid home pages are similar to the current home pages but  fluid model provides the end user with the new User experience that renders well on the dashboard or the home pages.

Tiles/Grouplets are lifeline of Fluid UI page. Tiles help the user to navigate to a fluid page or classic PIA page.

Business Benefits

  •  Device independent
  • Gives the response based on user device
  • Can be personalized based on needs e.g. Tiles can be added or deleted from homepage based on personal needs

      Development Steps 

Let us design a simple fluid UI page for following requirement..
  • To create a fluid homepage for Recruiter
  • To add a tile for Applicant search
      1) Development of Fluid Home Page


Developing a fluid home page is fairly easy and is done through PIA.
Navigation:  Peopletools> Structure and Content>Fluid Structure and Content>Fluid Homepages.

Add a new homepage. Usage Type should be Landing Page as shown in figure below.


       2)      Development of a Fluid Component

Development of a fluid component goes in the same traditional PeopleSoft way- creation of fields, record, page, component, menu and finally creating the content reference. Fluid properties are defined at page and component level.

Step1: Create a new fluid page



While creating a new fluid page, choose Layout Page. Layout page is the template page for a fluid UI page.

Step2: Select Fluid UI Page Properties

After page is created, fluid UI properties can be set in Page properties.



In Page properties, user should focus more on Form Factor Override and Suppress Form Factor.
Form Factor Override: Overrides the style of page based on device size.
Suppress Form Factor: Suppresses the page from displaying based on device size. E.g.  If Small is checked, page will not appear on most smart phones.

Step 3: Create a new component.

Creating a new fluid component works in the same traditional PIA way. But the search pages are not displayed for fluid applications.

Step 4: Set component fluid properties



As shown in above figure, there are two main checkboxes, Fluid mode and Small Form Factor Optimized


Step6: Add the Tile in home page

Navigation: Main Menu>Fluid Home>Homepage 
  1. Click on Action Widget
  2. Click on Personalize
  3. Click on Add Tile
  4. Select the content reference which has to be added as a tile.
  Fluid UI is ready for test.








Clicking on tile 'Applicant List' will open  the designed Fluid UI page.






















Best Practices:
 Always check Display on Small form Factor Homepage while creating the content reference. This will show the tile on small devices
.
Limitations:
  • Classic PIA search for a component does not work in Fluid. User should create a separate search by selecting the correct layout.
  • Currently, only light weighted applications can be deployed in fluid mode e.g. components like add a person, job data which demands heavy data entry are not suited for fluid mode.
  • Currently, some features, like spell check, rich text editor, Find In for grids, Download to Excel, modal movement or re-sizing, are not available in fluid.

PeopleSoft Pivot Grid

The PeopleSoft Pivot Grid is a reporting tool used to provide a pivot table and  chart representation of live data using PS Query data source. This enables users to visually display data in a dashboard. Data can be displayed in different views by performing operations such as pivoting and filtering, which enables business analysts to interpret data in a variety of ways.


Business Benefits:         
  1. Pivot grids can be published as pagelets, so can be published on home page or any other navigation.
E.g.: Managers can use this pivot grid on their Dashboard to track the Employees Report, Direct Line Reports, Employees Head count etc…

  1. Users can take action directly from the chart/report. - Related Content can be configured in Pivot grid.


  1. Drilling Down on the Aggregate Values
                  
The detailed view displays the complete data of the grid and Actions dropdown helps navigate to related links or action can be taken.
  1. Inter Window Communication: Pivot Grid Pagelets can interact with each other and with the transaction pages. Configure Publication and Subscription with all the intersecting Prompt and Filter values between Pivot grids. We get the consistent behavior with progressive filtering in the publisher and subscriber.

  1. Pivot grids can be published as Related Content on any of the components, so that the user can refer them easily.

  1. Displaying Grid from Chart-only view -  Display the grid from a chart-only view and then perform various actions—such as pivoting data, dragging and dropping, and slicing and filtering data—to change the grid layout. After the layout is satisfactory, you can synchronize the chart with the grid view.

  1. View grid option allows user to display the results of the query in grid format and filters can be applied.

  1. PeopleSoft Pivot Grids allow the user to analyze data within the PeopleSoft application.  The advantage here is that, as we all know, initial data analysis often leads to more questions and a need for deeper analysis. PeopleSoft Pivot Grids allow the user to dive deeper, all the way down to the transactional level into the system to grab more data for the desktop spreadsheet. It is cleaner, easier and more efficient.
  2. Pivot Grids allow the user in a specific job role to focus on the activities that are most important to their specific job requirements.  The user is able to immediately access the most Relevant information for their role. Information is easily prioritized and action lists can be created.

Development Process
Pivot grid can be developed in five easy steps:
Navigation: Main Menu -> Reporting Tools -> Pivot Grid -> Pivot Grid Wizard.

Step1: Provide pivot grid basic details - grid name, title and type.

Step 2: Provide data source type and PS Query name.
Step 3: Provide data model values. At least one value and axis for the column should be specified.
Along with at least one value and axis specifying for the columns.

Step 4: Provide X and Y axis and filters.
Specify data model options providing X and Y Axis and specify filtering in fourth step.

Step 5: Verify the pivot grid, publish it as pagelets or related content.
      


Limitations on Pivot Grid:
  • Supports only PS Query as data source.
  • Pivot Grid Does not have a Vertical Scroll bar for viewing data, but it displays all possible rows based on the current layout.

Wednesday, July 22, 2015

PeopleSoft Enterprise Software & Documentation

Sending email through SQR is a common requirement. The command should be used for sending emails depends on which Environment your SQR is going to run. In Windows, you can use BLAT.exe, PSMAIL.exe. In UNIX, you can do by calling command “Mailx” or “mail”.
In Windows Environment:
PSMAIL.exe is a PeopleSoft delivered program.
PSMAIL.EXE looks for the environment variable PS_SERVER_CFG to retrieve its SMTP Settings. That variable is usually set on the Application Server and Process Scheduler on boot up. On the Application Server, it usually is set to %PS_HOME%\appserv\\psappsrv.cfg. On Process Scheduler, it usually points to %PS_HOME%\appserv\prcs\\psprcs.cfg.
Following are the possible command line arguments:
TO = the recipients of the email
CC = carbon copy list of recipients
BCC = blind carbon copy list of recipients
FROM = the sender of the email
SUBJECT = the subject heading of the email
BODY = the email body
FILE = list of file attachments to send with email. File location is relative to where PSMAIL.EXE is run from.
ALIAS = Used to create a short name for the file being attached, otherwise the receiver gets the complete path/filename
INPUT =points to a config file that contains the above seven arguments. This was to bypass the maximum number of characters allowable on a command line and carriage return/line feeds.
The tokens – or / can be used in front of the above arguments. The values for each argument must be encapsulated in double quotes. Look at the following examples.
Sample usage:
PSMAIL -TO”rob_smith@abct.com” -FROM”SystemTest_InvRpts@abc.com”
-SUBJECT”Daily Inventory Report(s)”
PSMAIL /TO”edward_jones@abc.com” /FROM”HR@abc.com” /SUBJECT”Time Out
Reporting” /BODY”Please report any PTO for the month of March.”
PSMAIL /INPUT”demo1.txt”
The content of the file, “demo1.txt” is as below:
-TO”lisa_harper@abc.com;Robert_thomas@abc.com”
-FROM”SystemTest_InvRpts@abc.com”
-SUBJECT”System Test Daily Inventory Report(s)”
-BODY”Here is the report(s) you requested. (Both A & B Databases)”
-FILE”d:\temp\ps\e800r20\in_bu_bal_A.out;d:\temp\ps\e800r20\in_bu_bal_B.out”
If you are using -INPUT or /INPUT then you need to have the input file in UNICODE format. (On NT, you can do this by saving the file in notepad as “Unicode format” & on Unix you can run the following PeopleSoft binary file: PSUNICONV ASCII UCS-2 )
BEGIN-PROCEDURE sendmail
let $subject = ‘Subject of the Email Here’
let $to_list = ’email@email.com’
let $ReportID = ‘File name along with path’
let $alias =’Attachment File Name Alias including the file extension’
let $enter = chr(10)chr(13)
let $body_txt = ‘Hi,’$enter$enter’Please Find the Report attached with this email.’$enter$enter’Regards,’$enter ‘Peoplesoft Application Support’$enter$enter’PS: We request you not to reply to this automated mail trigger.’
let $mail-cmd = ‘ \\HHOT3Q7CPSH02\psoft\HR880DEV\bin\client\winx86\psmail -TO”‘$to_list'” -SUBJECT”‘$subject'” -BODY”‘$body_txt'” -FILE”‘ $ReportID ‘” -ALIAS”‘$alias'”‘
CALL SYSTEM USING $mail-cmd #Status
if #status <> 0
show ‘ERROR: Could not send email!’
end-if
end-procedure sendmail
In UNIX Environment:
Below is the sample code to send mail from UNIX Environment.
Mail without Body text with attachment:
let $mail-cmd = ‘(uuencode Filename_with_fullpath.extension Filename_to_be_displayed_in_mail.extension)’ | mail –s “Mail Subject” –c “cc Mail Address” to-Mail Address’
call system using $mail-cmd #Status
if #status <> 0
show ‘ERROR: Could not send email!’
end-if
Mail with Body text without attachment:
let $mail-cmd = ‘mail –s “Mail Subject” –c “cc Mail Address” to-Mail Address’
call system using $mail-cmd #Status
if #status <> 0
show ‘ERROR: Could not send email!’
Mail with Body along with Attachment:
Here no need to generate temporary file for mail body.
let $mail-cmd = ‘(echo “hi all “; uuencode ObjectChecker.sqr Object.sqr)’ | ‘mail -s “hi” nadarajvenkadesh.krishnan@aig.com’
call system using $mail-cmd #Status
if #status <> 0
show ‘ERROR: Could not send email!’
end-if
Note: if subject has spaces, then it should be enclosed with double quotes.

People Tools Tables

The People Tools Tables are the PS tables which store your Application designer object definition’s
For RECORDS AND INDEXES
PSRECDEFN; PSRECDEFNLANG; PSRECFIELD; PSINDEXDEFN;
For  PEOPLETOOLS PROJECTS
PSPROJECTDEFN;PSPROJECTITEM;PSPROJDEFNLANG;PSPROJECTDEP;PSPROJECTINC;PSPROJECTMSG ;PSPROJECTSEC
For FIELDS
PSDBFIELD;PSDBFIELDLANG;PSDBFLDLABL;PSDBFLDLABLLANG;
For TRANSLATES
PSXLATDEFN;PSXLATITEM;PSXLATITEMLANG;
For PANEL GROUPS
PSPNLGRPDEFN;PSPNLGDEFNLANG;PSPNLGROUP;PSPNLGROUPLANG;
For QUERIES
PSQRYDEFN;PSQRYDEFNLANG;PSQRYBIND;PSQRYBINDLANG;PSQRYCRITERIA;PSQRYEXPR;PSQRYFIELD;
PSQRYFIELDLANG;PSQRYFLAGS;PSQRYLINK;PSQRYRECORD;PSQRYSELECT;
For PROCESS DEFINITIONS
PRCSDEFN;PRCSDEFNLANG;PRCSDEFNGRP;PRCSDEFNPNL;PRCSDEFNXFER;PRCSDEFNNOTIFY;PRCSDEFNCNTDIST;PRCSDEFNMESSAGE;PRCSDEFNMETA;
PS_PRCSDEFNURL;PS_PRCSDEFNURL_LNG;PS_PRCSDEFNURLKEY;
For SQL
PSSQLDEFN;PSSQLDESCR;PSSQLLANG;PSSQLTEXTDEFN;
For APP ENGINE PROGRAMS
PSAEAPPLDEFN;PSAEAPPLLANG;PSAEAPPLSTATE;PSAEAPPLTEMPTBL;
For APP ENGINE SECTIONS
PSAESECTDEFN;PSAESECTDTLDEFN;PSAESTEPDEFN;PSAESTEPMSGDEFN;PSAESTMTDEFN;
PS_AEINSTANCENBR;PS_AELOCKMGR;
For URL DEFINITIONS
PSURLDEFN;.
PSURLDEFNLANG;
For USERS
PSOPRALIAS;PSOPRDEFN ;PSROLEUSER;PSUSERATTR;PSUSEREMAIL;PSUSERPRSNLOPTN;
PS_ROLEXLATOPR;PS_ROLEXLATOPR_LNG;PS_RTE_CNTL_RUSER;
For ROLES
PSROLEDEFN;PSROLEDEFNLANG;PSROLECANGRANT;PSROLECLASS;
For PERMISSION LISTS
PSCLASSDEFN;PSAUTHBUSCOMP;PSAUTHCHNLMON;PSAUTHCUBE;PSAUTHITEM;PSAUTHOPTN;
PSAUTHQUEUEMON;PSAUTHPRCS;PSAUTHSIGNON;PSAUTHWS;PSPRCSPRFL;PS_MC_OPR_SECURITY;
PS_MC_OPRID;PS_SCRTY_ACC_GRP;PS_SCRTY_QUERY;
 For SIGNON PEOPLECODE
PSSIGNONPPC;
For Integration Broker Queues
PSIBQUEUEINST;PSQUEUEDEFN;PSQUEUEDEFNLANG;PSQUEUEPART;