PS Technical: Field Definitions (Summary)

1. Creating New Field Definitions

• Create a new field definition.
• Character (Char)
• Long Character (Long)
• Number (Nbr)
• Signed Number (Sign)
• Date (Date)
• Time (Time)
• DateTime (DtTm)
• Image (Img)
• ImageReference (Iref)
• Attachment (Att)

• Specify attributes for a new field definition.
• Label ID
• Long Name
• Short Name
• Def (default)
• Not Used
• Chart Field

• Specify character field attributes.
• Field Length
• Format Type : Uppercase, Mixedcase, Numbers Only, SSN, SIN, Raw Binary, Name, Postal Code North America, Postal Code International, Phone Num North America, Phone Number International, and Custom
  

• Specify long character field attributes.
• Maximum Length
• Raw Binary
  

• Specify number field attributes.
• Integer Positions
• Decimal Positions
• Signed
  

• Specify date field attributes.
• Default to 2000 if year less than or equal to (Default is 50)
  

• Specify time field attributes.
• Time Formatting
  

• Specify DateTime field attributes.
• Time Formatting
  

• Specify image field attributes.
• Maximum Length
• Image Format
  

• Specify ImageReference field attributes

• Note: PeopleSoft supports BMP, DIB, GIF, CUT, EPS, JPG, PCX, PCT, RLE, and TGA image types. At runtime, the user can upload BMP, DIB, GIF, and JPG images to the database.

2. Using Multiple Labels

• Add a new label.
• Delete a label.
• Select record field labels.

3. Opening an Existing Field Definition

4. Viewing Field Properties

5. Changing Field Definitions

• Change field types.
• Rename field definitions.
• Delete field definitions.
• Print field definitions.
  

6. Setting Custom Field Formats

• Understanding Format Notation
• Lexical characters delimit character expressions and designate interpretation rules.
• Literal characters represent only themselves.
• Meta characters represent a class of characters.
• Meta Symbols: #; 0; .; 9; A; Z; @
• Lexical Symbols: *; +; []; {}; ?; !; ~; \; ()
  

• Changing format families. Max Display Length

• Editing formats.
• Add, update, and delete stored and display formats.
• Enter a description for the family.
• Specify options, such as uppercase and smart punctuation, for the family.
  

• Using family options.
• Smart Punctuation
• Make uppercase
  

• Test formats.
• Stored Format Name
• Display Format Name
• DB->Display
• Display->DB
  

7. Using the Translate Table

• Understanding the Translate Table
• Field type is Character.
• Field length is 1 to 4 characters.
• Field values consist of a relatively small, static set of values that are not maintained by the user.
• No other fields relate to this field.

• Add values to the Translate table.
• Field Value
• Effective Date
• Inactive
• Long Name
• Short Name
  

• Change translate values.
• Delete translate values.
• Save the Translate table.

• Note 1: When you select the Yes/No Table Edit, the system automatically points to the PSYESNO field in the Translate table

• Note 2: Translate Table Attributes are: FIELDNAME, LANGUAGE_CD, FIELDVALUE, EFFDT, VERSION, EFF_STATUS, XLATLONGNAME, XLATSHORTNAME, LASTUPDDTTM and LASTUPDOPRID

• Note 3: To save the Translate table, you must be authorized to modify field definitions. There is a special Translates Only security access level for fields that allows translate values to be updated, but not other field attributes.