PeopleSoft Project
The following table describes all the items in the TIB_PEOPLESOFT_PLUGIN project.
| Type of Item | Name | Description |
|---|---|---|
| Component Interface | TIB_CI_COMPINTFC |
Used by the plug-in to retrieve the list of Component Interfaces in the database. |
| TIB_MQUEUE_DATA_CI |
Used by the plug-in to retrieve queue records. |
|
| TIB_MQUEUE_SRCH_CI |
Used by the plug-in to retrieve queue records. |
|
| TIB_PUB_COMPINTFC |
Used by the plug-in to store data back into PeopleSoft. Applicable only to integration scenarios. |
|
| TIB_MSGVER_CI |
Used by the plug-in to retrieve names and versions of messages. |
|
| TIB_MSGREC_CI |
Used by the plug-in to retrieve the details of a particular message. |
|
| TIB_MSGDET_CI |
Used by the plug-in to retrieve the details of a particular message. |
|
| Component | TIB_CI_GROUP |
Used by TIB_CI_COMPINTFC. |
| TIB_MQUEUE_DATA_COMP |
Used by TIB_MQUEUE_DATA_CI. |
|
| TIB_MQUEUE_SRCH_COMP |
Used by TIB_MQUEUE_SRCH_CI. |
|
| TIB_PUB_COMP |
Used by TIB_PUB_COMPINTFC. |
|
| TIB_MSGVER_COMP |
Used by TIB_MSGVER_CI. |
|
| TIB_MSGREC_COMP |
Used by TIB_MSGREC_CI. |
|
| TIB_MSGDET_COMP |
Used by TIB_MSGDET_CI. |
|
| Field | TIB_ATTRIBUTE_NAME |
Name of the field. |
| TIB_BCITEMPARENT |
Name of the parent field. |
|
| TIB_BCNAME |
Name of the Business Event |
|
| TIB_DESCRIPTION |
Description of the field. |
|
| TIB_EVENT_NAME |
Stores name of the event. |
|
| TIB_FIELDNAME |
Name of the field. |
|
| TIB_FIELDTYPE |
Type of the field. |
|
| TIB_GUID |
Stores GUID - Unique identifier for the message. |
|
| TIB_IS_MSG_TRIGGER | Stores TRUE or FALSE. Purpose is to determine whether to trigger the publisher if this field changes. | |
| TIB_ISKEY | Key field. | |
| TIB_ISKEY_FLAG | Stores TRUE or FALSE key field. | |
| TIB_LENGTH | Length of the field. | |
| TIB_LEVELNUM | ||
| TIB_MENUACTION | ||
| TIB_MODE | TIB_MODE has the following values:
A - Add. U - Update. L - Update All. C - Correction. |
|
| TIB_MSG_DATA | Content of this field. | |
| TIB_MSG_FIELDID | ||
| TIB_MSG_ORIGIN | ||
| TIB_MSG_TIMESTAMP | Stores Timestamp corresponding to the message. | |
| TIB_MSG_TYPE | ||
| TIB_OBJECT_NAME | ||
| TIB_OPERATION | ||
| TIB_PARENT_RECNAME | Field Parent Record Name. | |
| TIB_PARENTRECNAME | Field Parent Record Name. | |
| TIB_PNLGRPNAME | ||
| TIB_RECNAME | ||
| TIB_SEQUENCE_NO | Stores Sequence number of message. | |
| TIB_SERIALIZEDATA | ||
| TIB_STATUS | TIB_STATUS can have any of the following values:
N - Not processed. I - Intermediate stage. P - Processed successfully. E - Error. |
|
| TIB_MSGNAME |
Name of the Application Messaging component. |
|
| TIB_APMSGVER | Version of Application Messaging. | |
| TIB_RECDNAME | Name of the Record. | |
| TIB_FLDNAME | Name of the Field. | |
| TIB_FLDTYPE | Type of the Field. | |
| TIB_PRNTRECNAME | Name of the parent record name. | |
| TIB_RECALIAS | Name of the record alias name. | |
| TIB_FLDALIAS | Name of the field alias. | |
| Menu | TIBCO_MAINT_MENU | |
| Page | TIB_CI_ADAPTER_WRK | Page that has all the PeopleCode used to capture data from PeopleSoft and store it in the MQUEUE table. |
| TIB_CI_MQUEUE_PGE | ||
| TIB_CI_PUBLISHER | ||
| TIB_COMP_INTERFACE | ||
| TIB_MQUE_DATA_PGE | ||
| TIB_MQUE_SRCH_PGE | ||
| TIB_MSGVER_PG | ||
| TIB_MSGREC_PG | ||
| TIB_MSGDET_PG | ||
| Record | TIB_BCITEM_VW | |
| TIB_CI_BUS_DTL | Stores the details of the component to be captured. | |
| TIB_CI_BUS_HDR | Stores the events to be published and in what mode. | |
| TIB_CI_DTLWRK | ||
| TIB_CI_GET_VW | ||
| TIB_CI_MQUEUE | Stores the data to be published. | |
| TIB_CI_MSG_VW | ||
| TIB_CI_PARNT_VW | ||
| TIB_CI_SEQUENCE | Stores the sequence number of the published event. | |
| TIB_CI_TIDLOG | Has the PeopleCode required for capturing data to be published. | |
| TIB_MQUEUE_SRCH | ||
| TIB_PUB_WRK | ||
| TIB_MSGVER_VW | ||
| TIB_MSGREC_VW | ||
| TIB_MSG_VW_TBL | ||
| SQL | TIB_BCITEM_VW | |
| TIB_CI_GET_VW | Captures the GETKEYS for a particular Component Interface. | |
| TIB_CI_MSG_VW | Captures the details of the fields and records to be published. | |
| TIB_CI_PARNT_VW | Captures the parent-child relationship for Component Interfaces. | |
| TIB_MQUEUE_SRCH | Captures the range of sequence numbers for TIB Events and groups them by the status (processed/ unprocessed). | |
| TIB_MSGVER_VW | ||
| TIB_MSGREC_VW | ||
| TIB_MSG_VW_TBL | ||
| PeopleCode | TIB_CI_TIDLOG.RowInit | This event is fired for all the records the first time a row of data is encountered. This is usually used to set the initial state of a component or a page. The plug-in uses this particular record's RowInit event to host the PeopleCode to perform the following:
Check if the panel is invoked online. Call a function to get the data to be captured from the TIB tables, only if the panel is invoked online and not via the Component Interface. |
| TIB_CI_TIDLOG.SavePreChange | This event is fired just before the data is updated in the database by the PeopleSoft component processor. It gives you one last chance to manipulate the data before it is saved to the database. The plug-in uses this particular record's SavePreChange event to host the PeopleCode to perform the following:
Set the various global variables. Calls a function to start the processing of an event. Calls a function to write the message to the MQUEUE table after an event has been processed. |
|
| TIB_CI_TIDLOG.FieldFormula | This event is fired in more than one context but primarily it is used to declare and store functions to be used by PeopleCode of other events. Hence the plug-in uses this particular record's FieldFormula event to host the PeopleCode defining various functions, which do the processing required to capture and write the data to the MQUEUE table. |