Fields in PeopleSoft

Fields are the basic building blocks of records in PeopleSoft. A field in PeopleSoft can be of the following types:

Field Type Field Length / Feature
Character 254
Long Character
Number Has integer part and decimal part
Signed Number Has integer part and decimal part
Date Default to 2000 if year less than __
Time HH:MI, HH:MI:SS, HH:MI:SS:999999
Date Time Has features of both date and time
Image Max Length in K bytes and Image format
Image Reference
Attachment Max Length in K bytes

Unlike in conventional RDBS, a field in PeopleSoft is reusable and can be used across many records. PeopleSoft allow users to drag and drop fields into a record definition.

Leave a Reply

Your email address will not be published. Required fields are marked *


Read previous post:
PeopleSoft Journal Uploader
PeopleSoft Journal Import Error – User-defined type not defined