Creating a New Field Definition

To create a new field definition:

1. Click the New button on the PeopleSoft Application Designer toolbar.

   The New dialog box appears.

2. Select Field.

3. Click OK.

   A new character field opens in the definition workspace area.

4. Select one of the following field types from the Field Type drop-down list box.

   Note:

   Make sure you name your fields according to accepted naming conventions.

   See Saving Definitions.

   Field or Control	Description
   Character (Char)	Alphanumeric field of fixed length.
   Long Character (Long)	Alphanumeric field of variable length used for textual entries, such as comments or descriptions.
   Number (Nbr)	Positive numeric field of fixed length for which decimals are allowed.
   Signed Number (Sign)	Positive or negative numeric field of fixed length for which decimals are allowed.
   Date (Date)	Date field of constant length. The system edits dates and prohibits incorrect ones, such as day 42 or month 20. Date fields always store a four-digit year.
   Time (Time)	Time field of a constant length. Built-in edits prohibit impossible times, such as hour 26, minute 70, or second 94.
   Datetime (DtTm)	Date and time field of constant length. Built-in edits prohibit impossible dates and times, as defined in the individual date and time fields. Datetime fields always store a four-digit year.
   Image (Img)	Image field to store images in a user-defined format, such as JPG or GIF.
   ImageReference (Iref)	Field in which to change an image dynamically at runtime using PeopleCode.
   Attachment (Att)	Field that maps to a BLOB database type to hold the contents of a file attachment. However, you should use the existing field, FILE_DATA, if you need a BLOB column. For attachments, use the subrecord ATTACH_DETAIL, which contains FILE_DATA.

   After you select a field type, a field definition window appears in the definition workspace. Use the field definition window to specify attributes to complete your new field definition.