What is the difference between the development view and upgrade view?

The Development view allows you to open and modify or create new object definitions while the Upgrade view only displays a list of object types with in a project to facilitate migration to another database.

Read More»

What is the difference between Prompt table Edit and Prompt Table with no Edit?

Prompt Table Edit - Edits the contents of the field against the values maintained in the specified Prompt Table.

Prompt Table with no Edit - Provides users with a list of suggested values, but does not edit the contents of the field against the Prompt Table.  Users can enter any value.  

Read More»

How to Skip a Search Record Prompt When You Know the keys

You have two settings to choose from: skip if possible (0) and force display (1).

If you use the skip if possible setting, then you need to have the keys. Assume your

keys are EMPLID, EMPL_RCD, and EFFDT. Here is what the SearchInit PeopleCode

would look like:

SetSearchDialogBehavior(0);

EMPLID = %EmployeeID;

EMPL_RCD = 0;

EFFDT = &DateVariable;

Read More»

Creating a new instance in Component Interface

The first job is to get a Component interface(CI) ,using GetCompIntfcfunction. This CI definition has already been created in the application designer.
Then the "Create Keys" are set,these are values which uniquely identifies each row of data.If any duplicate set of create key values occur,a runtime error occurs. After keying in the key values,the create method is used to populate the CI with the key values.This creates an instance of data.
Next the remaining fields of the row are entered.
Once all the values have been entered the new instance of data is saved.

Local ApiObject &MYSESSION;
Local ApiObject &CR;

&MYSESSION= %Session;
&CR=&MYSESSION.GetCompIntfc(CompIntfc.CR_EMP_CI);
&CR.CR_EMP_ID = "101";

&CR.Create();
&CR.CR_FIRSTNAME="Chinnu";
&CR.CR_LASTNAME="Raavi";
&CR.CR_MARITAL_STATUS = "M";
&CR.CR_PHONE_NO = "1234567890";

&CR.save();

Read More»

How to implement Record Level Audit in PeopleSoft

How to implement Record Level Audit in PeopleSoft .

Following are the steps for record level auditing .

1) Clone the record you wish to edit.

2) Add the audit fields: (Key Fields).
AUDIT_OPRID
AUDIT_STAMP
AUDIT_ACTN
Check off the "system maintained" check mark on the record field properties.

3) Delete fields that won'™t be audited.

4) Remove all key structures.

5) Save and build the record.

6) Link the base record to the audit record.

Read More»