On 2012-06-07 16:26:01 +0000, kclubok said:

> I know this is an old thread, but I am interested in the same question.
> I have a bit of additional information to share, but still face some
> unknowns.
>
> Reading the PeopleSoft driver documentation, it appears that these
> fields correspond to documented parameters in the DirXMLTrans PeopleCode
> call that is used to populate the transaction table. The first two
> appear to be relevant only if the event is Row Delete. It looks like
> they help identify which row in the PeopleSoft scroll was deleted:
>
> DIRXML_FIELDKEY = Collection Row Delete Field Key: The key field value
> of the deleted data row
>
> DIRXML_FIELDNAME = Collection Row Delete Field Name: The field name of
> the scroll level attribute in the application record.
>
> The last one looks more interesting:
>
> DIRXML_VALUE = Transaction Miscellaneous Info: The parameter contains
> 1...n values that the developer wants to pass to the driver during
> processing. This value might not be available via the Schema object when
> a transaction is processed by the driver. (Example: ASSOC_ID | "| |
> LAST_NAME)
>
> This could have a lot of benefit. It would provide a convenient way to
> include event-specific information, as opposed to CIs, which are better
> for state-based information. Unfortunately, this is where the
> documentation stops being useful. There is no explanation of how to
> access the information that is passed to the driver. I suppose it might
> be stored in an operation attribute, but that's just a guess. Does
> anybody know the answer to this?
>
>
> crisdiaz;2002153 Wrote:
>> Hello,
>>
>> Can anyone help me understand the purpose and use of the fields:
>> DIRXML_FIELDKEY, DIRXML_FIELDNAME, and DIRXML_VALUE in the PS
>> transaction table. I dont see any sort of description listed about
>> these fields in the documentation.
>>
>> Im trying to figure out if these fields, in combination with the
>> DIRXML_CURRDTTM, can be used to create a future dated transaction and
>> somehow tell the PS driver exactly which field was modified in the
>> SCHEMA CI (So it doesn't process the entire SCHEMA row).
>>
>> Thanks,
>> Cristian


Where are these documented? I have been unable to find them in the
documentation of the driver.

Why we are at it, where can we find useful the definitions for all of
the DIRXML_TRANSXX Properties:
DIRXML_ASSOC_ID
DIRXML_CURRDTTM
DIRXML_DESCR
DIRXML_DRIVER
DIRXML_DTTM
DIRXML_EVENT
DIRXML_FIELDKEY
DIRXML_FIELDNAME
DIRXML_INST
DIRXML_PROCESSED
DIRXML_SCHEMA
DIRXML_STATUS
DIRXML_VALUE

--

Thank You for your help!

-jim
Jim Willeke