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 allows users to drag and drop fields into a record definition.
