Tag: packaged enterprise solutions

Questions Related to packaged enterprise solutions

EFFDT cannot occur at what occurs levels?
technology packaged enterprise solutions

  1. 0

  2. 1

  3. 2

  4. 3

Show answer
Correct Option: A
Explanation:

To solve this question, the user needs to have knowledge about the PeopleSoft HR system and the different occurrence levels.

Each record in PeopleSoft HR system has an occurrence level, which determines how many effective-dated records a single employee can have for that record. The EFFDT field is a key field that determines the effective date of the record.

Now, let's go through each option and explain why it is right or wrong:

A. 0: This option is correct. Occurrence level 0 is a special level used for control tables that cannot have effective-dated records. Therefore, the EFFDT field cannot occur at level 0.

B. 1: This option is incorrect. Occurrence level 1 is used for records that can have only one effective-dated record per employee. The EFFDT field can occur at level 1.

C. 2: This option is incorrect. Occurrence level 2 is used for records that can have multiple effective-dated records per employee but are not related to job data. The EFFDT field can occur at level 2.

D. 3: This option is incorrect. Occurrence level 3 is used for records that can have multiple, related effective-dated records per employee. The EFFDT field can occur at level 3.

Therefore, the correct answer is:

The Answer is: A. 0

Audits can be implemented at the following levels

technology packaged enterprise solutions

  1. FIELD

  2. PAGE

  3. RECORD

  4. FIELD & RECORD

Show answer
Correct Option: D

What type of a field can have Auto Update?
technology packaged enterprise solutions

  1. CHAR

  2. LONG CHAR

  3. DATE

  4. NUMBER

Show answer
Correct Option: C

PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

technology packaged enterprise solutions

  1. SYSRELEASE

  2. SYSOBJECTS

  3. PSRELEASE

  4. PSOBJECTS

Show answer
Correct Option: C

AI Explanation

To answer this question, we need to understand the concept of PeopleSoft system tables and how they are used to track object changes.

Option A) SYSRELEASE - This option is incorrect because the SYSRELEASE table is not used to track object changes. It is a system table that stores information about the release version of PeopleTools.

Option B) SYSOBJECTS - This option is incorrect because the SYSOBJECTS table is not used to track object changes. It is a system table that stores metadata information about PeopleSoft objects.

Option C) PSRELEASE - This option is incorrect because the PSRELEASE table is not used to track object changes. It is a system table that stores information about the release version of the PeopleSoft application.

Option D) PSOBJECTS - This option is correct because the PSOBJECTS table is used to track object changes in PeopleSoft. It is a system table that stores metadata information about PeopleSoft objects and tracks changes made to those objects.

Therefore, the correct answer is D) PSOBJECTS. This option is correct because the PSOBJECTS table is specifically designed to track object changes in PeopleSoft.

When can a value be added in the underlying table?

technology packaged enterprise solutions

  1. Prompt Table with Edit

  2. Translate Table Edit

  3. Yes/No Edit

  4. Prompt Table with No Edit

Show answer
Correct Option: D

Which of the following record definitions is NOT stored on the database and is therefore NOT required to be built?

technology packaged enterprise solutions

  1. View

  2. SQL Table

  3. Derived/Work Record

  4. Sub Record

Show answer
Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) View - This option is incorrect because a view is a virtual table that is stored in the database. It is created using a SQL query and does not require physical storage of data.

Option B) SQL Table - This option is incorrect because an SQL table is a physical table that is stored in the database. It contains rows and columns to store data.

Option C) Derived/Work Record - This option is incorrect because a derived/work record is a temporary record that is created during the processing of a PeopleSoft program. It is used for calculations, intermediate data storage, or temporary data manipulation. It is not stored on the database and is created dynamically as needed.

Option D) Sub Record - This option is correct because a sub record is a reusable component that is used to define the structure and behavior of a field or a group of fields within a record. It is not stored on the database and is not required to be built separately.

The correct answer is D) Sub Record. This option is correct because a sub record is not stored on the database and is not required to be built separately.

Where are definitions used to create fields on a page in the user interface and columns in application data tables stored?
technology packaged enterprise solutions

  1. PSFIELD

  2. PSRECFIELD

  3. PS_DBFIELD

  4. PSDBFIELD

Show answer
Correct Option: D

Where are the definitions that make up a PeopleSoft Application stored?

technology packaged enterprise solutions

  1. SYSTEM CATALOG

  2. PEOPLETOOLS TABLES

  3. APPLICATION TABLES

  4. PEOPLETOOLS CATALOG

Show answer
Correct Option: B

Where is the Application Data Cached?
technology packaged enterprise solutions

  1. Application server

  2. Web server

  3. Batch server

  4. None

Show answer
Correct Option: D

What is the record field property that should be set to validate dates for <> 30 days?

technology packaged enterprise solutions

  1. Setting %Date as constant

  2. Required

  3. Specifying Default using Record and Field values

  4. Reasonable date

Show answer
Correct Option: D