PS Technical: Record Definitions (Summary)

1. Viewing Record Definitions

• View basic field definitions.
• View key-related characteristics and default values.
• View editing options.
• View PeopleCode program types.
• Reorder fields.
• Size and sort columns.

2. Saving Record Definitions

3. Naming Record Definitions

• The name length can be up to 15 characters, with the exception of the Temporary Table type, which has a maximum length of 13.
• The name must begin with a letter and can contain underscores to make it more readable.
  
• Avoid special characters, such as # or $, which can cause problems in some database environments.
• Record Naming Conventions: _TBL, _VW, _DVW, _WRK, _SBR, _QVW, _WL, R_, AUDIT_, WEBLIB_, FUNCLIB_, and DERIVED_

4. Creating a New Record

• SQL Table; SQL View; Dynamic View; Derived/Work; SubRecord; Query View; Temporary Table; and Non Standard SQL Table Name
  
• Keys for dynamic views should not be effective date fields.

5. Opening an Existing Record

6. Manipulating Fields in Record Definitions

• Insert fields into records.
• Insert subrecords into records.

6. Set record properties.

• Set general properties.
• Set use properties.
• Create user-defined audit record definitions.
• Tools Table: Identifies SQL tables owned by Enterprise PeopleTools development, which is typically the same ownership as indicated by the PPLTOOLS project.
• Managed: Identifies SQL tables owned by Enterprise PeopleTools development that
  contain information which is used by managed (cached) objects.
• Upgrade Job Not Needed: Identifies SQL tables that do not require an upgrade job to be defined. This option applies only to “A to B” upgrades.
• The Append ALL (Dynamic Views) option applies to dynamic views. If it is set, at runtime the system appends the WHERE clause generated at runtime to all the SELECT statements in a dynamic view with a UNION. Also, if it is set, at runtime the system generates FILL as the table alias in the WHERE clause condition. For example, FILL. LIKE ’%O%’. You need to specify which table corresponds to the FILL in the dynamic view definition. For example, FROM tableA FILL. This is because the same record field name may exist in two different records.
  

7. Setting record field properties.

• Set record field use properties.
• Add from and through logic to the search page.
• Set record field edit properties.
• Move fields in the same record.
• Move fields to another record definition.
• Delete a field from a record definition.
• Rename record definitions.
• Delete record definitions.
• Print record definitions.
• Create SQL view and dynamic view Select statements.

• Note: Time Zone and Related Date Fields