TekiWiki - New pages [en]

Micro Entrepreneur Tax Breaks

2016-03-18T18:56:44Z

WikiSysop: /* Micro Entrepreneur Tax Breaks - A Good Idea? */

=Micro Entrepreneurs and the New Tax Breaks=

There will be a new tax break of £1,000 of income for micro-entrepreneurs earning from the new "sharing" economy.

This probably started as a suggestion to remove a large number of minor eBay traders from needing to complete an income tax return for £2.25. The cost to process these forms would be comparable to the revenue and so it is more efficient for everyone not to bother.

Whilst the details of this tax break have yet to filter through, the signal it sends to the new business models is very clear - everybody get disrupting! Will this have the effects that the Chancellor expects?

==Fast Forward 5 Years==

Dave started his AirBnB business just after the new UK tax regime became law. There had been news articles and documentaries about people giving up their jobs and becoming overnight millionaires only working twelve minutes per day. He had made a some money from the Bed and Breakfasts, but, five years on, he was still a long way from the digital dream and writing his letter of resignation. As a hobby that paid him, he enjoyed it, he liked cooking, he had a spare room and he met some interesting characters.

Tom and Barbara have been running the eBay good life for at least ten years. At first, the new tax break seemed great - they were getting money back from the tax man! When they gave up their jobs to concentrate on building the eBay business, they had gone "legit" as they would not be able to explain their income.

However, since the announcement, everyone was starting their own online business. The competition had ramped up, but these were evening eBayers just earning a few extra quid, not having to make this month's mortgage. They flooded the market at margins that could not be sustained. It looked likely that they would need to go back to full time employment and make the eBay a sideline - just like everyone else.

After doing the school run, Laura checked her emails. Yesterday's campaign went well, she had sold her entire consignment! Now her twin boys were at school full time, she would be able to spend more time running her business and the extra time available was paying off. She had started the business on maternity leave from her marketing job. Although it did not pay anywhere near her full time salary, it did allow her to take time off after the maternity leave to look after her baby sons - having twins was certainly double trouble!

Alex, HR director of a large office based company, was reviewing a report on the company's car pooling scheme. Using a new web based application, employees driving to work can offer lifts to other employees for a contribution towards their petrol and maintenance. On the face of it, this seemed like a great scheme - spaces were freed up in the overburdened car park, car drivers in the scheme got some compensation, passengers saved on train fares. However, one or two drivers bought larger cars and decided to become Uber drivers at the weekend. Now these drivers were taking more sick leave than before, perhaps to fund their new cars? Was the reduction in car parking demand worth the change in a handful of employee's behavior?

Chris started her own software development company three years ago. From the start, Chris had encouraged her engaged and media savvy staff to join the company's affiliate scheme - including the sales team. Each employee could earn from new customers downloading their mobile apps. Not only had she turned her entire team into ambassadors, her employees had a stream of income with its own separate tax allowance - the equivalent of a free pay rise.

Each staff member was allowed an organized half hour slot each day when they could utilize social media, build web sites and write articles. As the company was very small and had a "family" feel the policy worked well with few rules. Chris wondered if that would change as they grew.

Two staff had left Chris's company and had asked if they could stay on the scheme. Chris had agreed readily - after all the affiliate scheme was generally available to members of the public and that included ex-staff members.

==Micro Entrepreneur Tax Breaks - A Good Idea?==

I think this policy will work well in the short term. There may need to be some revisions of the legislation if the tax break gets used for tax avoidance or has more side effects than were originally anticipated, but it will encourage a new way of thinking, which could benefit all.

==See Also==

[[HR and the UK EU Referendum]]

PeopleSoft Nationality Data

2016-03-16T19:32:17Z

WikiSysop:

[[PeopleSoft]] maintains a range of data about nationality:

CITIZENSHIP record contains the nationality (or nationalities) of an employee.

PeopleSoft can also hold the current visas held by an employee too.

As a general rule, to determine who pays an employee, check the PAYGROUP field of the JOB record.

{| class="wikitable"
|-
|[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg|90px|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]]

|
[http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]

[[PeopleSoft Query]]

|[[File:PeopleSoftUserCompanion.jpg|90px|link=http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24]]

|
[http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion]

HR and the UK EU Referendum

2016-03-12T09:55:22Z

WikiSysop: /* Further Reading */

=The Effects of Brexit on Human Resources=

The UK Referendum (23rd June 2016) on whether to stay in or leave the European Union can potentially have many effects. By starting the preparation, the issues will be easier to deal with when the decision is imminent or has happened.

I will keep this page updated as we go through the process and plans become clearer about the legislative ramifications of a vote either way. Currently the events of the vote are uncertain and preparation would mainly be gathering the right information ready for swift movement at the right time.

I am building a list of potential impact areas and trying to gauge their urgency as well as what measures may or may not be needed.

==Visas==
If the UK does leave the EU, visas are likely to be the most immediate issue.

===Visas for EU Nationals in the UK===
It is likely that after a leave vote, the UK Government would want to keep the status quo, and so there is likely to be a period where the current arrangements would stay in place while the details of any changes would be hammered out.

===Visas for UK Citizens Working within the EU===
However, the same would not necessarily be true of EU member states who may apply non-EU visa rules almost immediately.

===Effects on Non-EU Citizens Working in UK===
The UK government will want to provide stability and so the most probable scenario, at least in the short term, is maintaining the current arrangements.

===Effects on UK Citizens Working in Non-EU Countries===
Where a country has specific agreements with the EU rather than the UK, the visa arrangements may change depending upon the relationship of the U.K. With that country.

===Longer Term Effects===
Immigration is one of the main factors in the referendum. This implies that a government post-Brexit would have pressures to curb immigration. A points system, such as the Australian one, could provide a more sound and stable footing for immigration policy.

Staying in may also have some long term effects. Non-EU countries that thought they may get preferential treatment after Brexit may be disappointed and look elsewhere for strategic alliances.

==Data Protection==
There are a few Acts of Parliament that cover data protection. Some parts of these acts have been European and internationally inspired. In the interests of stability, changes to these acts would be widely discussed and consulted prior to being changed. However, the status of the UK will have changed overnight and so mitigations such as safe harbour etc. may well need to be considered.

It is a good idea to do some leg work prior to the vote to ensure you are ready to act.

===Where is Your Data Stored?===
I have to state up front that I am not a lawyer and for the issues covered here, you may need to seek legal advice. In general, the data covered by these Acts is personally identifiable information - people data. There are three regions you data could be stored in:

* Within the UK
* Within the EU
* Outside the EU

The UK could change from being inside the EU, to being outside the EU. This could have effects on Safe Harbour agreements written to cover EU countries and may require new Safe Harbour agreements and processes for data held within the UK.

===Where is Your Data Processed?===
The UK Data Protection Act covers both where data is held and who processes the data, so the places where the data are being accessed also needs to be considered.

===Who do You Hold Data About?===
Which nationalities and territories data are being held? This may imply that further Safe Harbour measures are required if data held or processed in the UK.

==Currency==
Particularly in the time prior to the referendum, the currency markets will be fluctuating wildly. Great for speculators, not so great if you are managing the costs of a multi-currency payroll and multi-currency contracts.

===Effects of Uncertainty===
During the run up to the referendum, each opinion poll is likely to have an effect on the currency markets. The level of the pound is already depressed and may remain so.

Even after the referendum, there is likely to be a period of instability in the money markets whilst the implications of the result are digested.

===Will the UK be Coerced into Joining the EuroZone?===
If the vote is to stay in, there may be pressure to join the EuroZone. This pressure would not be explicit, it would be by increasing the decisions made by EuroZone countries only, and the forming of an "inner circle" within the union.

==Health and Safety Legislation==
One of the key #Brexit advantages would be that the UK can start to undo the EU imposed health and safety legislation. However, unpicking the good from the bad would take time and would not give any short term results.

However, if you are considering a new health and safety module of your HR system, it might be wise to prioritise another issue currently.

==EU Subsidies==
If your company currently gains EU subsidies or benefits from European schemes then you may need to start planning what to do without the subsidy.

For instance, if you have French VIE interns, it may be worth considering alternatives for new hires and plan what to do with your current intake.

==Scotland==
Should the UK vote for #Brexit, the SNP have requested a re-run of the Scottish Independence referendum, so that Scotland would be free to rejoin the EU.

Multinationals that hold their European headquarters in the UK may start to build up their presence in Scotland or Ireland for an English speaking EU alternative.

==Government Contracts==
EU governments are currently obliged to consider all EU based tenders for contracts. If the UK leaves, these contracts are in jeopardy as the EU government would no longer be obliged to choose a UK supplier in preference to their own supplier. Replacing leavers with temporary staff would be prudent at this time.

On the flip side, the UK government would no longer need to consider EU contractors above homegrown talent any more. Although the UK government would be looking for stability, there may be one or two contracts that will be decided after June 23rd.

==Conclusion==
There are many impacts of #Brexit and some planning to mitigate the more immediate issues could help an organisation take advantage of the huge opportunities that an independent Britain may have.

=Further Reading=

[[PeopleSoft Nationality Data]]

UKOUG15

2015-12-19T23:29:23Z

WikiSysop:

=UK Oracle User Group 2015=

The Oracle User Group in the UK was split into three streams - TECH15, APPS15 and JDE15. As a PeopleSofter, I was there for the APPS15 stream.

[[File:APPS15.jpeg|200px|thumb|left|APPS15]]

There were many opportunities to mix in the social and exhibition portions of the day to talk to many different Oraclysers.

==Jeremy Ashley==
Jeremy Ashley, Oracle's guru on use ability, gave an inspiring talk on Oracle's view of applications of current mobile technology - such as the use of GPS combined with time and knowledge of habits to badge into work and warn when you are moving towards a safety restricted area.

He also introduced the concept of glance, scan and commit.

==PeopleSoft==

From a [[PeopleSoft]] point of view, the highlight of the UK OUG 15 was the introduction of [[PeopleTools 8.55]]. Jeff Robbins talked through the new features, going into some detail of the new Cloud architecture that allows [[PeopleTools]] to be installed, deployed or changed.

There were also presentations covering test automation, a roadmap for HCM 9.2 updates, and a taster of my hints and tips on [[PeopleSoft Query]].

PeopleTools 8.55

2015-12-18T18:34:23Z

WikiSysop:

[[PeopleTools]] 8.55 was released in December 2015.

The release has several new features - the following being the main ones:

* Improvements to Fluid
** Fluid tiles can now do most things a pagelet can do.
** Fluid pages and components can have left and right swipe in pages.
** Fluid menu is more useable and performs better

* Pivot charts and grids improved
** More chart types
** Compatible with Fluid now

* Composite Query coming of age

* Deployment Packages making installs and infrastructure changes easier

* Application Designer "Find in" Searches (much) Faster and Improved

[[UKOUG15]]

Getting More Out of PeopleSoft Query

2015-12-14T08:16:18Z

WikiSysop:

==Getting More Out of PeopleSoft Query==

This is a copy of my PowerPoint presentation to the UK Oracle User Group 2015.

[http://www.springboardsolutions.com/peoplesoft/Getting_More_Out_Of_PeopleSoft_Query.pptx UKOUG15 Presentation: Getting More Out of PeopleSoft Query]

[[PeopleSoft Query]]

CSV Merge Tool

2015-11-20T23:15:43Z

WikiSysop:

==[http://www.homemarketeer.com/tools/csv_merge CSV Merge Tool]==

The Online CSV Merger allows you to merge your own CSV file with your template. You can use the test text supplied, or use your own - either typed in or pasted in.

* Copy and paste or type in your CSV data into the Source CSV box.
* Add in your template text to be merged in the Template box.
* Press the "Merge CSV" button to put the results into the result box at the bottom of the page.

For each line of the source data, the template is repeated with the placeholders [1], [2], [3] etc. replaced by the respective fields from the template.

If your data is separated by different characters - other than comma (,) - you can supply the separator.

Note that if you copy cells from a spreadsheet such as Microsoft Excel or Apple Numbers, using TAB as the separator, you can divide using the individual cells.

[[Tools]]

Java

2015-08-17T20:52:32Z

WikiSysop:

Java is an object orientated, compiled language currently produced by Oracle and is available as a free download from [http://www.oracle.com/technetwork/indexes/downloads/index.html their website].

The Java compiler (javac) compiles the object orientated source code into "byte code" - this is then "interpreted" by the the Java Runtime Engine (JRE). This enables the same byte code to be run across all the platforms that the JRE has been ported to (and that is a lot).

Tools

2015-06-02T21:17:43Z

WikiSysop: /* Merge Tool */

Spring Board Tools - mini data tools for everyday. These tools are entirely free to use with no account to set up, no emails jamming your inbox.

Just simple tools, no strings.

==[http://www.homemarketeer.com/tools/csv_merge Merge Tool]==

Merge data from a spreadsheet or a list into your own template.

With a CSV file, copy and paste the file into the source text field.

Copy and paste source data straight from spreadsheet cells (Microsoft Excel, Google Sheets or Apple Numbers)- press the "Use Tab" button.

More on how to use [[CSV Merge Tool]].

==[http://www.springboardsolutions.com/regular_expression.html Regular Expression Calculator]==

Create your own regular expressions using a set of prompt buttons and see the results on your own data. Change the data or the regular expressions to get the results you need.

==[http://www.homemarketeer.com/tools/text_processor Regular Expression Text Processor]==

Process your text through a series of Regular Expressions. Particularly useful if you want to perfect a set of expressions and text to achieve a desired outcome.

An example: you could extract the right parts of a trace file by applying several regular expressions that delete those parts you do not want. These same expressions could be applied to many trace files.

Laws of Data

2015-05-21T17:15:36Z

WikiSysop:

As the capacity of disks increase to astronomical proportions, it is easy to lose sight of the wood due to the enormous number forests suddenly springing up. In our haste to store every last piece of data, it is worth thinking about those ancient principles of data management.

=Bowden's Laws of Data=

==Law 1: The Accuracy of the Data is Directly Proportional to the Exposure it gets==

The more eyes on the data, the more likely someone will spot it is wrong. The more a data item is used, the more probable it will be accurate. If data is never seen, it will be wrong.

==Law 2: With No External Forces, Data at Rest will Become Useless==

Data without a maintenance plan is data not worth the electricity to power the hard disks. If no one is responsible for the data, even the most static information will moulder until it is useless.

==Law 3: The Law of Conservation of Data: Data is Neither Deleted nor Destroyed, It Can Only Grow or be Archived==

The law of Conservation of Data - data is neither deleted nor destroyed, so only collect what you will be able to use and maintain. Decide how long you need to keep the data for, otherwise you will be backing up terabytes of data that you have no idea if anyone is using. But Western Digital are happy.

==Law 4: The Law of Feedback : Source of the Error Should Fix the Error==

Errors in data should be fed back to the source for correction. The organization learns about the value of the information and concentrates on getting it right earlier.

So for each category of data, make it clear how to report issues back to the source.

[[Oracle Database]]

[[Microsoft SQL Server]]

PS Query Lists

2015-02-20T07:40:13Z

WikiSysop:

[[PeopleSoft Query]] has a way of comparing a list of values in the criteria to a particular column (or expression). You have to add each value individually - this is a bit of fun for a handful of values, but when the number of values in the list hit serious double figures, it becomes a bit tedious.

The list of values makes use of the "in" operator in SQL. If we already have the list in an email or spreadsheet, we can edit the list into the SQL format without having to rete the actual values, but then we need to get it into PS Query:

1: Create a new criterion - and make the left hand side an expression.

2: Leave the expression settings as their defaults - a character expression with a length of 1.

3: As an example, to make a list of Departments containing Sales, Marketing, Operations put the following into the expression list:
<pre>
A.DEPTID in ('SALES','MARKETING','OPERATIONS') and 'a'
</pre>
4: Click OK and save the expression and return to your new criterion.

5: Add the right hand side of the criterion as the constant value "a" (without the quotes)

==Creating the List==

Creating a quoted, comma separated list can be done in a text editor, in a spreadsheet or in an online tool such as [http://www.springboardsolutions.com/regular_expression.html Regular Expression Calculator].

To convert a list of items, one to a line into a SQL "in" list:

1: Put the raw list in the left hand "source" box.

2: Depending on your platform, input the following into the "Regular Expression" box:

*Windows
<pre>
<nowiki>([^\r]*)</nowiki>
</pre>
* Mobile Devices
<pre>
<nowiki>(.+)</nowiki>
</pre>
3: In the "Replacement Text" box, type in:
<pre>
<nowiki>'$&',</nowiki>
</pre>
4: Click "Replace" and your comma separated list appears in the right hand box.

[[File:RegularExpressionList.jpg|link=http://www.springboardsolutions.com/regular_expression.html]]

''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is a Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''

Make Your Reports More Active

2015-02-10T08:16:13Z

WikiSysop:

This page is additional information for readers of the [[PeopleSoft Users Companion]]

=Make Your Reports More Active=

When asked for a new report, I often ask the question, "what will you do with the information?". The answer can often lead to an interesting discussion and explores what is really required.

With operational reports and exception reports, the answer is typically, "I take a look at the records and then decide on what needs to be done".

PeopleSoft Query has a great piece of functionality that can accelerate this process for the report recipient - drilling links (or Drilling URLs). A simple device - the ability to put a link straight to a page with all the relevant details. No more copy and paste, no more using a ruler to remember which lines have been checked. These links will also appear in the Excel output.

==How do you add links to a Query?==

Open your query, click on the "Expressions" tab, add a new expression.
You should now see the new expressions dialog. Select "Drilling URL" from the "Type" drop down (that normally starts with "Character").

The screen will change, and you will get a screen with a set of links describing the different types of links you can use:

* Component URL - a link to a particular page - with keys supplied from the Query.
* Query URL - a link to another Query - if that query has prompts, you can supply those from the parent query.
* Attachment URL - a link to an attachment held within the PeopleSoft system.
* External URL, Free Form URL - for connecting to external systems.

==Adding a Link to a Page==

If you click on the Component URL, you get a page which presents you with the following options:

* Portal Name - leave blank to use the one in use by the system or find this in the URL - normally "EMPLOYEE" for HRMS.

* Node Name - leave blank or, in most cases, set to the local default node - click the search button and sort the results by default local node (double click the "Default Local Node" heading). There will be one node with the value "1" in this column - that's our man!

* Psc and content reference - at first leave these blank.

* The Menu Name, Market, Component and Page can be obtained navigating to the page in question and pressing Cntrl-Shift-J.

Once these items have been entered, you can then set up the connection between fields in the query and the fields that you would enter on the component search page. Without these values, the link simply sends you to that search page.

==Connecting Query Data to the Page==
To really get the most out of this feature, you will want each link to connect to something on that row. Time to use the buttons at the bottom of the page.

The first of these is "Search Keys". This button produces a grid of the search keys for the page in question, you can then enter the fields or expressions from your query that you want to use to complete the search dialog. Just as when you complete a search page by typing in the values, you can leave some of the fields blank. If the keys are not complete, then the link will show the half completed search page, rather than taking you directly to the targeted page.

Note: in some versions of PeopleTools, you need to check the "Selection Flag" for the row of the grid you want to complete, otherwise the "Field Name" and "Key Values" get muddled.

The other button to use is the "Map Columns" button. This allows you to associate the link with particular columns in the output. You could have different links for different columns, but too many and confuse poor Yuri the User as to which link does what (was it Employee ID that took me to the Job page or was it Department ID?). If you do want to have many links from one query, you could add columns that describe where the link would take the user. You can also add the Drilling URL expression as a field, but they have a tendency to be very long and unwieldy.

Another way around this is to establish a mini convention - Employee ID always takes you to the Biographical Details, Employee Record Number takes you to Job page etc.

As seen before, you can also run another Query, show an attachment, or connect to another system. All this from the results which could be in HTML format, PDF or Excel. The Query could be scheduled and the Excel results emailed to the user - and so the spreadsheet reconnects the recipient with PeopleSoft - enabling them to continue the next step in the process seamlessly. Wow.

Try it - I'll bet you will always want to make your reports more active.

Return to [[PeopleSoft Users Companion Extras]]

''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is a Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''

PeopleSoft Users Companion

2015-02-08T22:53:57Z

WikiSysop:

{| class="wikitable"
|-
|[[File:PeopleSoftUserCompanion.jpg|190px|link=http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24]]

|Amazon Kindle: [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion]

This book is packed full of hints and tips for users of the Oracle PeopleSoft applications. The hints and tips can be applied to HR, Campus, Financials and CRM.

The Oracle PeopleSoft applications are very versatile and powerful. A little knowledge of tricks and techniques can help you make more of the system, and get your tasks completed faster.

These tricks will save you time - some every day, some occasionally. Some ideas you may have been vaguely aware of, but not seen how they can be used.

Plus - you can read it for free on [http://www.amazon.co.uk/tryprimefree?tag=springboardsolutions-21 Amazon Prime]
|}

More About Browsers

2015-01-23T21:41:48Z

WikiSysop:

[[PeopleSoft Users Companion Extras]] - More About Browsers

To download any of the supported browsers on a [[Windows]] machine:

[http://windows.microsoft.com/en-gb/internet-explorer/download-ie Internet Explorer]

[https://www.mozilla.org/en-GB/firefox/new/ FireFox]

[https://www.google.com/chrome/browser/desktop/ Google Chrome]

Some of the most useful browser additions for the PeopleSoft user:

[https://chrome.google.com/webstore/detail/ps-utilities/jajoopnifcliapcngocgiidifkmboemc?utm_source=gmail PS Utilities] - Chrome add on specific for PeopleSoft

[http://getfirebug.com FireBug] - FireFox Web Development Tool

[https://addons.mozilla.org/en-US/firefox/addon/greasemonkey/ GreaseMonkey] - FireFox scripting

''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is a Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''

Cross Database Bookmarks

2015-01-18T21:54:23Z

WikiSysop:

[[PeopleSoft Users Companion Extras]] - Cross Database Bookmarks

This is additional information for readers of the [http://www.amazon.co.uk/PeopleSoft-Users-Companion-effective-applications-ebook/dp/B00S74S9MM/ref=sr_1_1?ie=UTF8&qid=1421272256&sr=8-1&keywords=Graham+Bowden PeopleSoft Users Companion]

Here is the Cross Database Bookmarks code (makes it easier to copy and edit):

<pre>
javascript:(function(){
var loc=location.href;
var parts=loc.split("/",9);
var newParts="https://server.domain.com:8000/psp/HRDEV/EMPLOYEE/HRMS/c/UTILITIES.PTPERF_TEST.GBL".split("/",9);
newParts[0]=parts[0];
newParts[2]=parts[2];
newParts[4]=parts[4];
location=newParts.join("/");
})()
</pre>

Note that this script has been updated to allow the script to switch between databases using http and databases using https.

''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is a Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''

PeopleSoft Users Companion Extras

2015-01-18T21:30:24Z

WikiSysop:

Here are extras and additional supporting info for readers of [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion]

[[Cross Database Bookmarks]] - the code from this section for copying (updated)

[[More About Browsers]] - links and useful stuff around browsers

[[Make Your Reports More Active]] - make good use of the arcane PS Query Drilling URL

[[PS Query Lists]] - Use lists from spreadsheets and emails in your PS Query quickly and easily

{| class="wikitable"
|-
|[[File:PeopleSoftUserCompanion.jpg|90px|link=http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24]]

|Make better use of the PeopleSoft web with the [[PeopleSoft Users Companion]].

|}

Fields

2014-12-17T23:10:03Z

WikiSysop:

[[PeopleTools]] Fields are created in [[Application Designer]].

Character fields are translated to Varchar (or Varchar2 in Oracle). The length of the fields is in characters. In earlier PeopleTools versions the Unicode database column length was 3 times the length stated in the field definition.

Regular Expression Examples

2014-06-10T07:14:39Z

WikiSysop:

[[Regular Expressions]] are very powerful and quite complex tasks can be achieved with just a few characters. The following example Regular Expressions are simple, frequently used expressions that can be adapted for your own purposes:

==Finding Blank Lines==
This finds lines that only have spaces! tabs or nothing at all in them:

<pre>
^[\t ]*$
</pre>

==Finding Trailing Spaces==
This finds spaces at the end of the line (note that there is a space at the beginning of the expression):

<pre>
+$
</pre>

==Lines that Contain Only Digits==
This finds lines that have at least one digit and the whole line contains nothing but digits:

<pre>
^[0-9]+$
</pre>

Detecting PeopleTools Changes

2014-04-24T17:38:56Z

WikiSysop:

<pre>
@setup

@filesuffix

undefine days

prompt Please enter Number of Days to Go Back:

Prompt Number of days reported: &&days

set echo off
set verify off

spool changes&&filesuffix.txt

prompt ******************************************************************
prompt P R O J E C T C H A N G E S
prompt ******************************************************************

select pd.projectname,pd.lastupdoprid
,(CASE p.ObjectType
WHEN 0 THEN 'Record'
WHEN 1 THEN 'Index'
WHEN 2 THEN 'Field'
WHEN 3 THEN 'Field Format'
WHEN 4 THEN 'Translate Value'
WHEN 5 THEN 'Pages'
WHEN 6 THEN 'Menus'
WHEN 7 THEN 'Components'
WHEN 8 THEN 'Record PeopleCode'
WHEN 9 THEN 'Menu PeopleCode'
WHEN 10 THEN 'Query'
WHEN 11 THEN 'Tree Structures'
WHEN 12 THEN 'Trees'
WHEN 13 THEN 'Access group'
WHEN 14 THEN 'Color'
WHEN 15 THEN 'Style'
WHEN 16 THEN 'N/A'
WHEN 17 THEN 'Business process'
WHEN 18 THEN 'Activity'
WHEN 19 THEN 'Role'
WHEN 20 THEN 'Process Definition'
WHEN 21 THEN 'Server Definition'
WHEN 22 THEN 'Process Type Definition'
WHEN 23 THEN 'Job Definitions'
WHEN 24 THEN 'Recurrence Definition'
WHEN 25 THEN 'Message Catalog'
WHEN 26 THEN 'Dimension'
WHEN 27 THEN 'Cube Definitions'
WHEN 28 THEN 'Cube Instance Definitions'
WHEN 29 THEN 'Business Interlink'
WHEN 30 THEN 'SQL'
WHEN 31 THEN 'File Layout Definition'
WHEN 32 THEN 'Component Interfaces'
WHEN 33 THEN 'AE program'
WHEN 34 THEN 'AE section'
WHEN 35 THEN 'Message Node'
WHEN 36 THEN 'Message Channel'
WHEN 37 THEN 'Message'
WHEN 38 THEN 'Approval rule set'
WHEN 39 THEN 'Message PeopleCode'
WHEN 40 THEN 'Subscription PeopleCode'
WHEN 41 THEN 'N/A'
WHEN 42 THEN 'Component Interface PeopleCode'
WHEN 43 THEN 'AE PeopleCode'
WHEN 44 THEN 'Page PeopleCode'
WHEN 45 THEN 'Page Field PeopleCode'
WHEN 46 THEN 'Component PeopleCode'
WHEN 47 THEN 'Component Record PeopleCode'
WHEN 48 THEN 'Component Rec Fld PeopleCode'
WHEN 49 THEN 'Image'
WHEN 50 THEN 'Style sheet'
WHEN 51 THEN 'HTML'
WHEN 52 THEN 'Not used'
WHEN 53 THEN 'Permission List'
WHEN 54 THEN 'Portal Registry Definitions'
WHEN 55 THEN 'Portal Registry Structures'
WHEN 56 THEN 'URL Definitions'
WHEN 57 THEN 'Application Packages'
WHEN 58 THEN 'Application Package Peoplecode'
WHEN 59 THEN 'Portal Registry User Homepage'
WHEN 60 THEN 'Problem Type'
WHEN 61 THEN 'Archive Templates'
WHEN 62 THEN 'XSLT'
WHEN 63 THEN 'Portal Registry User Favorite'
WHEN 64 THEN 'Mobile Page'
WHEN 65 THEN 'Relationships'
WHEN 66 THEN 'Component Interface Property Peoplecode'
WHEN 67 THEN 'Optimization Models'
WHEN 68 THEN 'File References'
WHEN 69 THEN 'File Type Codes'
WHEN 70 THEN 'Archive Object Definitions'
WHEN 71 THEN 'Archive Templates (Type 2)'
WHEN 72 THEN 'Diagnostic Plug In'
WHEN 73 THEN 'Analytic Model'
WHEN 79 THEN 'Service'
WHEN 80 THEN 'Service Operation'
WHEN 81 THEN 'Service Operation Handler'
WHEN 82 THEN 'Service Operation Version'
WHEN 83 THEN 'Service Operation Routing'
WHEN 84 THEN 'IB Queue'
WHEN 85 THEN 'XMLP Template Defn'
WHEN 86 THEN 'XMLP Report Defn'
WHEN 87 THEN 'XMLP File Defn'
WHEN 88 THEN 'XMLP Data Source Definition'
ELSE 'UNKNOWN:'||p.ObjectType END) AS OBJECTTYPE
,pd.lastupddttm,p.*
from psprojectitem p,psprojectdefn pd
where
pd.lastupddttm>sysdate-&&days
and p.projectname=pd.projectname
order by 1,2,3,4,5
;

set feedback off

prompt ******************************************************************
prompt O B J E C T C H A N G E S
prompt ******************************************************************

select rpad('PSACEMDLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSACEMDLDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSACTIVITYDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSACTIVITYDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSAEAPPLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSAEAPPLDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSAESECTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSAESECTDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSARCHOBJDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSARCHOBJDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSARCHTEMPLATE',30),lastupdoprid who,lastupddttm when
,t.* from PSARCHTEMPLATE t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSBCDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSBCDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSBUSPROCDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSBUSPROCDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSCHNLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCHNLDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSCOLORDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCOLORDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSCONTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCONTDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSDBFIELD',30),lastupdoprid who,lastupddttm when
,t.* from PSDBFIELD t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSDIAGREG',30),lastupdoprid who,lastupddttm when
,t.* from PSDIAGREG t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSDSSCHEMA',30),lastupdoprid who,lastupddttm when
,t.* from PSDSSCHEMA t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSFILEREDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSFILEREDEFN t where lastupddttm>sysdate-&&days and lastupddttm<sysdate+1 order by lastupdoprid,lastupddttm;

select rpad('PSFLDDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSFLDDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSFMTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSFMTDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBMSGFILE_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSIBMSGFILE_ATT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBSCHEMAS_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSIBSCHEMAS_ATT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBWNODETRXVW',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWNODETRXVW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBWNODTRXVW0',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWNODTRXVW0 t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBWNODTRXVW1',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWNODTRXVW1 t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBWRELATRXVW',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWRELATRXVW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBWRELAVW',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWRELAVW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIBXML_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSIBXML_ATT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIMPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSIMPDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSIODEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSIODEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSJPUPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSJPUPDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSMENUDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMENUDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSMPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMPDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSMSGDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMSGDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSMSGNODEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMSGNODEDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSNODETRX',30),lastupdoprid who,lastupddttm when
,t.* from PSNODETRX t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSNODETRXVW2',30),lastupdoprid who,lastupddttm when
,t.* from PSNODETRXVW2 t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSNODETRX_CVW',30),lastupdoprid who,lastupddttm when
,t.* from PSNODETRX_CVW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSNODEVW',30),lastupdoprid who,lastupddttm when
,t.* from PSNODEVW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSOPTMODEL',30),lastupdoprid who,lastupddttm when
,t.* from PSOPTMODEL t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSOPTPRBTYPE',30),lastupdoprid who,lastupddttm when
,t.* from PSOPTPRBTYPE t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPACKAGEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPACKAGEDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPCMPROG',30),lastupdoprid who,lastupddttm when
,t.* from PSPCMPROG t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPERMLIST_RMT',30),lastupdoprid who,lastupddttm when
,t.* from PSPERMLIST_RMT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPMAGENTFILTER',30),lastupdoprid who,lastupddttm when
,t.* from PSPMAGENTFILTER t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPMMONITORGBL',30),lastupdoprid who,lastupddttm when
,t.* from PSPMMONITORGBL t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPMSYSDEFAULTS',30),lastupdoprid who,lastupddttm when
,t.* from PSPMSYSDEFAULTS t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPMSYSDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPMSYSDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPNLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPNLDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPNLGRPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPNLGRPDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPRDMDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPRDMDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPROJECTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPROJECTDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPRSMDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPRSMDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPSWDHINT',30),lastupdoprid who,lastupddttm when
,t.* from PSPSWDHINT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSPURGEPERMLIST',30),lastupdoprid who,lastupddttm when
,t.* from PSPURGEPERMLIST t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRECDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSRECDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRECFIELD',30),lastupdoprid who,lastupddttm when
,t.* from PSRECFIELD t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRECFIELDDB',30),lastupdoprid who,lastupddttm when
,t.* from PSRECFIELDDB t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRECFIELD_TMP',30),lastupdoprid who,lastupddttm when
,t.* from PSRECFIELD_TMP t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELATCNTCT_VW',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATCNTCT_VW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELATCONTACT',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATCONTACT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELATIONPROP',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATIONPROP t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELATIONSHIP',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATIONSHIP t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELATIONTRX',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATIONTRX t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELTRX_CVW',30),lastupdoprid who,lastupddttm when
,t.* from PSRELTRX_CVW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSRELTRX_SRCH',30),lastupdoprid who,lastupddttm when
,t.* from PSRELTRX_SRCH t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSROLEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSROLEDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSROLEDEFN_RMT',30),lastupdoprid who,lastupddttm when
,t.* from PSROLEDEFN_RMT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSSQLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSQLDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSSTYLEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSTYLEDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSSTYLESHEET_VW',30),lastupdoprid who,lastupddttm when
,t.* from PSSTYLESHEET_VW t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSSTYLSHEETDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSTYLSHEETDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSSUBDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSUBDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSTOOLBARDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSTOOLBARDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSTYPECODEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSTYPECODEDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSURLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSURLDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSWSDLFILE_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSWSDLFILE_ATT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSWSRPCPHDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSWSRPCPHDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSWSRPPLTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSWSRPPLTDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSWSRPPRDDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSWSRPPRDDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSXLATITEM',30),lastupdoprid who,lastupddttm when,t.* from PSXLATITEM t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

prompt ******************************************************************
prompt S E C U R I T Y C H A N G E S
prompt ******************************************************************

select rpad('PSCLASSDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCLASSDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSOPRDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSOPRDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

prompt ******************************************************************
prompt E X P E C T E D C H A N G E S
prompt ******************************************************************

select rpad('PSQRYDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSQRYDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSTREEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSTREEDEFN t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

select rpad('PSTREESTRCT',30),lastupdoprid who,lastupddttm when
,t.* from PSTREESTRCT t where lastupddttm>sysdate-&&days order by lastupdoprid,lastupddttm;

spool off
</pre>