FIX_IB_DATA_AET

(SQL Table)
Index Back

State record for FIX_IB_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
3 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
4 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
5 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
6 SQL_ROW_COUNT Number(8,0) INTEGER NOT NULL Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 DESCRLONG Long Character CLOB Long Description
9 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
10 IB_NAMESPACE Character(254) VARCHAR2(254) NOT NULL Service Namespace
11 IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
12 IB_PSOFTSERVICE Character(1) VARCHAR2(1) NOT NULL Restricted Service
13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.