User Defined Fields

User Defined Fields

User Defined Fields (UDFs) allow an Admin to add fields to a large number of the forms available in PCR-360 if there are fields that are desired that PCR does not already provide. To access UDFs, navigate to Admin > User Defined Fields > User Defined Fields to open the User Defined Fields grid as seen below.

Adding UDFs

To add a new User Defined Field (UDF), click the 'Add' button. This opens the 'Add New User Defined Field' form.

On this form, there are three Required fields:

UDF Identifier - This is the Identifier that PCR-360 uses for the UDF being defined. This label MUST be unique or it cannot be saved.
- This field is set to read-only and cannot be changed once the User clicks the 'Save New' button.
Label - This is the label for the defined UDF.
Field Type - This determines the type of input associated with the UDF.
- This field is set to read-only and cannot be changed once the User clicks the 'Save New' button.
- There are a number of different Types that can be selected. See the Type Definitions section for complete descriptions of the types.
Required - Requires that the UDF has data before the form can be saved.
Verify Field Data - Creates a blue tool-tip for the UDF when the User attempts to Save the record, This helps to encourage the User to verify the record is valid.

UDF Associations

Once a UDF has been defined, add associations to the sections of PCR-360 where the UDF should appear. These associations allow a single UDF to be associated with multiple sections of the application for greater ease of management.

To add a UDF Association, follow these steps:

Click the 'Add' button.
The 'Add New Field Association' form opens.
The input here is kept relatively simple. Select an Item from the 'Association Table' drop down.
Some inputs open additional drop downs. Those additional drop downs are listed here:

Cables - UDF applies to all Cables.
- Cable Type - UDF ONLY applies to selected Cable Type.
GLA - UDF applies to all GLAs.
- Format - UDF ONLY applies to selected GLA Format.
Location - UDF applies to all Locations.
- Location Type - UDF ONLY applies to selected Location Type.
Service Desk - UDF applies to all Service Desk items.
- SD Type - UDF ONLY applies to selected SD Type.
Service Desk Quick Ticks - UDF applies to all Quick Ticks.
- Tick Type - UDF ONLY applies to selected Tick Type.
Equipment - UDF applies to all Equipment.
- Equipment Catalog - The UDF is associated with the specific Equipment selected from the Catalog.
Service - UDF applies to all Services.
- Service Catalog - The UDF is associated with the specific Service selected from the Catalog.

Cust Center - This flag allows the UDF for the Service to appear on the CustomerCenter.
Aging Persist - This flag allows the UDF to remain through the Aging process if it is set.

Service Catalog and Equipment Catalog, when defined as the 'Association Table', saves the UDF ONLY to the Catalog itself. Note that this is separate from the Service/Equipment 'Association Table(s)' having a specific Service/Equipment Catalog defined.

There is no inheritance of UDFs on 'Association Tables'. A given UDF MUST be added to the UDF Association grid for the UDF to appear on a given item. Default Values can be added to the Association once the User has saved the Association record. Check out the Default Values section for more information on adding Default Values for UDFs.

Type Definitions

Amount of Time - The UDF is formatted as a Time tracking field which records time in hours by default.
Checkbox - The UDF is a simple checkbox that can be selected or not.
Currency - The UDF text box is formatted as money in USD $ and only accepts numbers to two decimals.
Date - The UDF is a Date field with a calendar selector button.
Decimal Number - The UDF allows only whole numbers or decimal numbers to five decimal places.
Dropdown - This creates a drop down UDF. When a UDF is a drop-down, a tab is added with a label of Drop down Options. Click Here for more detail on 'Drop down' types.
Number - The UDF only allows whole numbers.
Picker - The UDF is a Picker that ties into any of the existing Pickers in PCR-360. Click Here for a full listing of available pickers.
Table - Creates editable table of information as a UDF. Click Here for a complete description of using Table UDFs.
Text - A text box that limits the number of Characters a given User can enter based on the Admin's setting.
Textarea - A large text area for larger text inputs than the smaller text type allows for. Can be vertically and horizontally sized.

Dropdown

There are two Lists that a User can select from a drop down. A 'System Defined List' or a 'User Defined List'.

System Defined List - If the drop-down options are 'System Defined', the drop-down values are populated from the List Values grid. The Admin only needs to use the provided 'List Type' Picker to select the list.
User Defined List - If the drop-down options are 'User Defined', the Admin needs to define each drop-down option individually. This is done through the following steps:

Click the 'Add' button.
The 'Add New Lists' form opens.
Enter a 'Value' into the form. Enter a description if one is desired.
Click the 'Save New' button.
Continue by clicking the 'Clear' button and entering any additional values for the drop-down that are desired.
Close the form when all the needed options have been added. These should be reflected in the grid.

All the drop-down options are added.

Toggle Status

The 'Toggle Status' button sets the status of an individual drop down value to 'Inactive', removes it from the displayed drop downs, and does not remove it from PCR-360. This is useful for disabling the use of a retired option that cannot be deleted because it still exists on older records.

Change Option Order

Clicking the 'Change Option Order' button allows the User to set the order of the options in the drop-down. The 'List Value Order' form opens:

By selecting an item, the User can simply drag and drop the values to order them as desired. Once the values are in the chosen order, click the 'Save' button.

Picker

Picker Name	Reference Key	Notes
Address	addressPicker
Backbone Service	backboneServicePicker
Billing Group	billingGroupPicker
Cable	cablePicker
Cabling Equipment	cablingEquipmentPicker
Call Type	callTypePicker
Charge Catalog	chrgCatalogPicker
Contact	contactPicker
Crystal Report	crystalPicker
Dept. Hierarchy	deptHierarchyPicker
Equipment	equipmentPicker
Equipment Catalog	eqpCatalogPicker
GLA	glaPicker
Import Format	importFormatPicker
Location	locationPicker
Notification	notificationPicker
Object Code	objectCodePicker
Pair/Strand	pairStrandPicker
Port/Pin/Len	portPinsLensPicker
SLA Catalog	slaCatalogPicker
Service Catalog	servCatalogPicker
Service Desk ID	serviceDeskPicker
Service Host	serviceHostPicker
Services	servicesPicker
User	userPicker
VLAN	vlanPicker
Vendor	vendorPicker
Warehouse	warehousePicker	Subset of Locations: this displays only Locations flagged as a Warehouse
Workflow	workflowPicker
Workgroup	workgroupPicker

Table

When the Table Field Type is selected, the 'Fit Width' checkbox will appear.

Fit Width - Set whether or not this table will fill the width of the form.

Name - Required; Defines the column name / identifier used.
Type - Required; Defines the type of data stored in this column.
- Standard Types include:
  - autoincrement: Will increment by one from the previous row.
  - select: A drop down box filled with values from the options field (Defined Below).
  - text: A simple text field.
  - checkbox: A toggle-able checkbox.
  - date: Brings up a calendar view for date selection.
  - _formattedtext_: This is text but with limited formatting options. Use 'a' for alpha, '9' for number, and '*' for alpha or number. For a sample usage see Format .
  - number: The field will only accept digits.
  - rownumber: The current row's position in the table. Setting a default value will alter the "rownumber" value.
Width - Required; Defines the column width (pixels).
Label - Defines the label for the column displayed in the header row. If left blank, the Column Name will be used instead.
Options -

A column delimited string for the select data type.
A string to be appended to the input html tag.
A formatted text mask.

Default Value - Default value for this column when a new row is added.
Description - Defines the tooltip/description to be shown when hovering over the header row.
Required - Defines if this is a required column.
Unique - Defines if this column must have unique values. Does nothing for the auto-increment field type or if a default value is set.

Required state

When creating or editing a UDF sometimes an Administrator wants to make the UDF required or not. This can be set for the UDF as a whole with the Required flag. UDF's are incomplete without a UDF Association record(s) assigned as a child record to the UDF.

On UDF Association records there is an additional Required state drop-down. There are three possible states that a UDF Association can have with regards to 'Required':

Inherited Value - Whatever the parent UDF is set to, whether Required or Not Required determines if the child UDF Association is Required or not.
Required - Requires the child UDF Association regardless of the parent UDF's Required state.
Not Required - Makes the child UDF Association not required regardless of the parent UDF's Required state.

This allows any given UDF Association more granular controll by the Administrator. For example, Users may wish to make a UDF required on some Services but not others.

Toggle Required

From the main User Defined Fields grid, the User can toggle the 'Required' flag for a given UDF. Simply select the UDF to toggle from the grid and click the 'Toggle Required' button. Note that this ONLY sets the Required flag of the UDF and only affects the Required state on any given UDF Association when the Association's Required state is set to Inherited Value.

Default UDF Values

This is the default value for all new records that the UDF is associated with. Any existing record will not have its current UDF value updated to the default UDF value.

In previous versions (2.1.4.4 and older) of PCR-360 UDF values were always NULL when the record was added. Moving forward Users can specify a Default Value that the UDF will be set to when the associated record is created and saved for the first time. Default Values are controlled from the User Defined Field Association record.

Default Values MUST be added after the UDF Association record is created, otherwise, the Default Value cannot be created in the database. What this means in practice is that when a User is creating a new association, they must first save the UDF Association, then close the UDF Association form, and finally reopen it before the User can set the Default Value.

On the Manage Field Association form, simply enter the value you want and save the record. The Default Value field will dynamically alter to match the field type of the parent UDF. When a new record is added which matches the User Defined Field Association and Type, the UDF will pre-populate with the assigned value.

UDF Order

All of the UDFs that are created can be searched and sorted here. To alter the order in which they appear on their respective tabs, the User only needs to locate the appropriate UDF in the grid and click the 'Change Field Order' button. The 'User Defined Fields Order' form opens.

From here, the User can reorder the fields by using the drag and drop functionality. When the fields are ordered as desired, click the 'Save and Close' button.