PSRECFIELDALL

The table stores all the fields that are part of a record. A subrecord is decomposed into its fields and show up as fields rather than subrecord.

The PSRECFIELD table contains the subrecord as added to a record without decomposing it into fields.

USEEDIT in RECFIELD

The value is really a sum of certain values based on the edits checked by the user when the record field is created:

The values added up based on how the record field is configured are:


Value
== ================
1 Key
2 Duplicate Order Key
4 System Maintained
8 Audit Field Add
16 Alternate Search Key
32 List Box Item
64 Descending Key
128 Audit Field Change
256 Required
512 Translate Table Edit
1024 Audit Field Delete
2048 Search Key
4096 Reasonable Date
8192 Yes/No Table Edit
16384 Prompt Table Edit
32768 Auto-Update
65536 Identifies field as Field in SubRecord
131072 (Reserved / Not Used)
262144 From Search Field
524288 Through Search Field

Inactivating Work Flows

Recently, I was required to inactivate workflow that were delivered ACTIVE.Since we are not using workflow, we will eventually have to inactivate all the events.

While I got to manually inactivate a few that were causing errors, I identified a peopletools table that could potentially be used for the purpose.

PSEVENTDEFN stored this information.

Instead of manually opening up each workflow, you could update the ACTIVE field to 0. But be sure that you are not really using thr work flow.

If you have a better way of doing it, please share with me and I will thank you for it!

Till next time.

How to determine whether a component interface exists for a component ?

Given a component , how do you determine whether a component interface has been created ? While there may be other methods to query the component interface.
The answer is simple.

Simply query the peopletools table.
PSBCDEFN The field BCPNAME contains the component name.