You are here:

Peoplesoft/Application Designer

Advertisement


Question
Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?

Answer
Translate tables (XLAT table) used for drop down of short values on the page ex: Status - A/I (Active/Inactive)
Condition for translate filed should be Character of lenght of 4
Prompt tables are used on the page for more number of values ex: STATE field on the page (more than 30)
No limitation on the field length.useful to validate values from other tables
Both are advantages and it depends on the requirement.
Please refer peoplebooks for more information
http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tapd/book.htm?File=tap

Peoplesoft

All Answers


Answers by Expert:


Ask Experts

Volunteer


kumar

Expertise

PeopleSoft Technical/SQR/PeopleCode/AE/CI/Webservices/Upgrade/Data Conversion related questions

Experience

9+ Years experience. 2 implementations & 2 upgrades Data Conversion Enhancements & Production Support projects

Education/Credentials
PeopleSoft Certified Professional

©2016 About.com. All rights reserved.