Explore topic-wise InterviewSolutions in .

WHENEVER we WANT to enter more than one transaction on the same day for an employee like PROMOTION and salary hike we will use effective SEQUENCE. Effseq NUMBER starts with 0

Whenever we want to enter more than one transaction on the same day for an employee like promotion and salary hike we will use effective sequence. Effseq number starts with 0

EFF_STATUS usually accompanies EFFDT. For example in Department table suppose we inactivated one dept from so and so future effdt, from that future date ONWARDS this dept is GOING to be inactivated, after that whenever we click the link prompt button of dept id FIELD we can SEE only active departments.

EFF_STATUS usually accompanies EFFDT. For example in Department table suppose we inactivated one dept from so and so future effdt, from that future date onwards this dept is going to be inactivated, after that whenever we click the link prompt button of dept id field we can see only active departments.

PROMPT Table No Edit:  Provides List of SUGGESTED values, which users cannot edit.

Prompt Table With Edit: Users can edit the CONTENTS of the FIELD against the values that are maintained in the SPECIFIED prompt Table.

Prompt Table No Edit:  Provides List of Suggested values, which users cannot edit.

Prompt Table With Edit: Users can edit the contents of the field against the values that are maintained in the specified prompt Table.

• Prompt Table With Edit
• Prompt Table No Edit
• Translate Table
• Yes/No Table Edit

Prompt Table No Edit:  Provides List of Suggested VALUES, which users cannot edit.

Prompt Table With Edit: Users can edit the contents of the field against the values that are MAINTAINED in the specified prompt Table.

Translate Table Edit: Which is nothing but a translate table created by developer.

Yes/No Table:In some situations we want the user to enter only BOOLEAN values like yes or no true or false in this SITUATION we will USE yes no table. The Translate Table for ex: PSYESNO. When you select the Yes/No Table Edit, the system automatically points to the PSYESNO field in the Translate Table

Prompt Table No Edit:  Provides List of Suggested values, which users cannot edit.

Prompt Table With Edit: Users can edit the contents of the field against the values that are maintained in the specified prompt Table.

Translate Table Edit: Which is nothing but a translate table created by developer.

Yes/No Table:In some situations we want the user to enter only Boolean values like yes or no true or false in this situation we will use yes no table. The Translate Table for ex: PSYESNO. When you select the Yes/No Table Edit, the system automatically points to the PSYESNO field in the Translate Table

It will store values for fields that don't require an individual PROMPT table, It is also known as xlat table. The DATA we store in the translate table does not change often. Each database contains ONE translate table. (BLOOD types, days of the WEEK)

It will store values for fields that don't require an individual prompt table, It is also known as xlat table. The data we store in the translate table does not change often. Each database contains one translate table. (blood types, days of the week)

Prompt tables are the most COMMON methods for validating data entry in peoplesoft APPLICATIONS. This is like APPLICATION data table the only difference is that it stores values that other tables can VALIDATE against. Prompt table is a control table. (Country table and COMPANY table)

Prompt tables are the most common methods for validating data entry in peoplesoft applications. This is like application data table the only difference is that it stores values that other tables can validate against. Prompt table is a control table. (Country table and Company table)

• System CATALOG TABLES
• People Tools Tables
• Application Data Tables 

System Catalog Tables: System Catalog Tables stores physical attributes of the tables and VIEWS. Naming convention for these tables is SYS.

PeopleTools Tables: The OBJECTS that we develop using the People Tool Objects are saved in PeopleTools Tables. Naming convention for these tables prefixed with PS_. Once a field is created it would be stored in psfield definition table, once a record is created it would be stored in psrecdef. (Only definition/structure is stored)

Application Data Tables: stores the data, which is entered by the user through PeopleSoft application windows and pages. Naming convention for these tables is PS_.

Application Data Tables are divided into 2 types:

• Control Tables
• Transaction Tables

Control Tables: Define the company structure and processing rules.

Transaction Tables: These are tables used to record our day-to-day transactions, such as personal data about employees.

System Catalog Tables: System Catalog Tables stores physical attributes of the tables and views. Naming convention for these tables is SYS.

PeopleTools Tables: The objects that we develop using the People Tool Objects are saved in PeopleTools Tables. Naming convention for these tables prefixed with PS_. Once a field is created it would be stored in psfield definition table, once a record is created it would be stored in psrecdef. (Only definition/structure is stored)

Application Data Tables: stores the data, which is entered by the user through PeopleSoft application windows and pages. Naming convention for these tables is PS_.

Application Data Tables are divided into 2 types:

Control Tables: Define the company structure and processing rules.

Transaction Tables: These are tables used to record our day-to-day transactions, such as personal data about employees.

Application Designer is an integrated DEVELOPMENT and upgrade tool that contains collection of related object definitions, these objects are useful for SPECIFIC purpose means using this objects we can develop PROJECTS ACCORDING to the user REQUIREMENTS.

Application Designer is an integrated development and upgrade tool that contains collection of related object definitions, these objects are useful for specific purpose means using this objects we can develop projects according to the user requirements.