1. Def b/w temporary tables and
derived work?
a.
Temporary
tables needs to be build and derived need not to be build
2. What is the diff b/w standard and
non-standard SQL?
a.
While
creating new table by default it is standard SQL, which will give PS_xxxxx
while building the table
b.
If
non-standard SQL u can give the name and in that name record will be created in
the backend anyhow check with this...
3. How to create component without a
search dbox?
a.
Don’t
give the search keys and list box item should not be given in search record for
that component.
4. What is the purpose of File
layout?
a.
It
is used to map the legacy file to the PS table structure. For importing purpose
thru AE, Ci we use this.
5. If there is more than one table
involved in a grid, how does one access the values using scroll or Rowset
methods?
a.
6. If a field’s processing mode is
set to Deferred or Interactive which one will take precedence?
a.
Field, page, component
7. What is the use of 'Set control
Field' in Record field properties?
a.
.
8. What difference does it make when
a component is saved/built at the client level or Application level?
a.
None
9. What is the difference between
search record and Add search record?
a. Specify the search record for this
component
b. Specify if you want a different search
record specifically for add actions. For example, if you selected the
auto-numbering option for employee IDs (EMPLID), don’t include EMPLID in the
search record. Likewise, you might want to create special security views for
add actions that limit the rows that users can add, based on specific search
criteria. The system default is the standard search record if you don’t specify
an add search record.
10.
How to use a Dynamic prompt table?
What we need to...
a.
In order to use a dynamic prompt
table; the field that is going to have the dynamic prompt must point to a field
in the DERIVED record. The prompt table can be dynamically assigned with the
following code.
b.
If(condition)
%derivedrecordfield.value=promttable1 else derivedrecordfield.value=promttable2
end-if;
11.
What are the think-time functions?
a.
Think time functions are DoModal,
WinMessage, messagebox, DoCancel and Exec.... think time function are cannot
write following events save prechange, rowselect, savepostchange, workflow.
12.
What happens if you don't specify a
Search Record for a Component?
a.
The search record has to be specified
else component definition cannot be saved. If the component design is such that
no search record is needed to be specified then give the search record as
"INSTALLATION". It directly loads the actual page without going to
the search page with the information on the page referring to the user who is
currently logged in to the Peoplesoft portal
13.
DDDAudit what is it?
a.
DDD Audit is a SQR used to find the
inconsistencies between the data structures defined in Peopletools table
against the underlying database.
b.
SYS Audit is an SQR used to compare
the different people tools tables and find inconsistencies like orphaned
objects ex. Peoplecode not attached to any record etc.,
14.
Prompt table with no edit to no edit?
a.
User can enter values from prompt table b) user can
enter values from prompt table and default value will be populated
15.
Changing Prompt Table with NO Edit to
Prompt Table with Edit?
a.
Only selection of existing data is
possible.
16.
Which one of the following tree types
is NOT supported in the PeopleSoft tree manager?
a.
Combination trees
17.
What is the minimum number of objects
an object group can consist of?
a) 19
18.
Which of the following menu options
allows you to modify the Last Process Instance Number used within the system?
a) Process
Scheduler, Use, Process System
19.
Which one of the following PeopleCode
debugging tools automatically converts values of any data type other than
object into string values for viewing during debugging
a) ExpandBindVar
20.
Which one of the following PeopleSoft
Objects CANNOT be locked by developers as part of Change Control Locking as
displayed above?
a) Process
Definitions
21.
What application server service
initiates a COBOL program to run a transaction?
a) Remote
call
22.
Which one of the following files is
NOT stored in the process scheduler-logging directory?
a) Application
server log
23.
Different
types of Edits?
a) 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. Selecting this option
makes the Prompt Table field available.
b) Prompt Table Edit: Edits the
contents of the field against the values that are maintained in the specified
prompt table. Selecting this option activates the Prompt Table field. When you
enter a prompt table name and exit the field by pressing TAB, Set Control Field
becomes activated.
c) Translate Table Edit: Edits the contents
of the field against the translate table. The translate table stores values for
fields that must be validated but don’t need individual tables of their own. If
you select this option, Prompt Table and Set Control Field become unavailable.
d) Yes/No Table Edit: Makes the values
for this field Y (yes) and N (no) only. If you select this option, Prompt Table
and Set Control Field become unavailable. 1/0 Table Edit (1-True,0-False)
24.
The major types of Trees that can be
created using the Tree Manager?
a.
Detail Trees, Summary Trees, Node
Oriented Trees, Reporting Trees
25.
The major types of Trees that can be
created using the Tree Manager?
a.
Detail Trees, Summary Trees, Node
Oriented Trees, Reporting Trees
|
Key
|
Select to identify the field as the
search criteria that uniquely identify each row. You cannot have duplicate
values for primary keys. For example, EMPLID is the only key to the
PERSONAL_DATA record definition. Therefore, EMPLID must be a unique value for
each employee and there can be only one PERSONAL_DATA row per employee.
|
|
Duplicate Order Key
|
Select to indicate that duplicate values
can occur. The order in which you place duplicate order keys in a field list
determines the order in which duplicate keys are retrieved.
|
|
Alternate Search Key
|
Select to identify the field as a key that
provides an alternate path into the table data. Duplicate values are allowed
in an alternate search key field. If you define a field as an alternate
search key in a search record, when you bring up a page, the system prompts
you to enter a key or alternate search key values.
|
|
Descending Key
|
Select to identify the field as descending
if you want rows of data to be retrieved in reverse alphanumeric order (for
example, 3, 2, and 1). If you clear this check box, the key is ascending,
meaning that rows are stored and retrieved in alphanumeric order (for
example, 1, 2, and 3). This option applies only to a field that is specified
as a key, duplicate order key, or alternate search key. PeopleSoft uses
descending order primarily for effective date fields; most character keys are
ascending.
|
|
Search Key
|
Select to make the field available on the
basic and advanced search or lookup pages. A search key is valid only for
keys and should be used only in search and prompt records. If you select this
check box, the system automatically selects List Box Item.
|
|
Search Edit
|
Enabled only if Search Key is selected.
Selecting this option enforces the required property and table edits on the
search page. It will also enforce these edits under circumstances where the
search page would normally be bypassed. With this option, the user will no
longer have the ability to perform partial searches on this field.
|
|
List Box Item
|
Select if you want the field to appear in
the list box preceding a page. If a field has values in the translate table
and you designate it as a list box item, the list box automatically shows the
translated value instead of the code.
|
|
From Search Field and Through Search Field
|
Select for fields that are used as search
records. If you select From Search Field, the displayed list contains rows in
which the field value is greater than or equal to a value that the user
enters. If you select Through Search Field, the displayed list contains rows
in which the field value is less than or equal to a value that the user
enters.
If you do not want these fields to be in a
search list box, clear the List Box Item check box, even if the field is an
alternate search key.
|
|
Default Search Field
|
Select to control which field name appears
in the Search By drop-down list box on the basic search page.
|
|
Disable Advanced Search Options
|
Select to prevent run-time search pages
from displaying advanced search features for this field.
|
Audit
The audit options apply only
to data that is manipulated on a normal PeopleSoft application page through
component processing. These options do not apply
to data that is added using SQLExec in PeopleCode or by some other means.
PSAUDIT logs the user ID, the date and time the field was modified, and the old
and new values. If you want to audit certain fields, regardless of the record definitions in which they’re included, you want to control when the fields are audited. If you want to audit several fields in a record definition, you might want to consider specifying audits at the record definition level.
|
Field Add
|
Audits this field whenever a new row of
data is added.
|
|
Field Change
|
Audits this field whenever the contents
are changed.
|
|
Field Delete
|
Audits this field whenever a row of data
is deleted.
|
0 comments:
Post a Comment
Phaniraavi@gmail.com