IT_MSG_CNT (SQL Table)	Index Back
IT - XML Message Counter ITAM - table used to count the number of XML Response messages processed/received for the PROCESS_INSTANCE value of our XML Request AppEngine.

IT_MSG_CNT

(SQL Table)

IT - XML Message Counter

ITAM - table used to count the number of XML Response messages processed/received for the PROCESS_INSTANCE value of our XML Request AppEngine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

5 TASK_ID Character(18) VARCHAR2(18) NOT NULL Task Identification

6 FILE_CNT Number(10,0) DECIMAL(10) NOT NULL Count of XML Files Processed

7 IT_DISCO_STATUS Character(2) VARCHAR2(2) NOT NULL Dscovery Request Status
01=Request Sent
02=Request Received
03=Receiving
04=Success
05=Third Party Error
06=Error in Transmission

8 IT_DISCO_ERROR_CD Character(2) VARCHAR2(2) NOT NULL Third Party Error
01=XML has Invalid DATA_TYPE
02=XML has Unknown Operator
03=XML has DATA_TYPE Mismatch
97=3rd Party License Expired
98=3rd Party Received Invalid XML
99=Other

9 LAST_DTTM_UPDATE 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	TASK_ID	Character(18)	VARCHAR2(18) NOT NULL	Task Identification
6	FILE_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of XML Files Processed
7	IT_DISCO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Dscovery Request Status 01=Request Sent 02=Request Received 03=Receiving 04=Success 05=Third Party Error 06=Error in Transmission
8	IT_DISCO_ERROR_CD	Character(2)	VARCHAR2(2) NOT NULL	Third Party Error 01=XML has Invalid DATA_TYPE 02=XML has Unknown Operator 03=XML has DATA_TYPE Mismatch 97=3rd Party License Expired 98=3rd Party Received Invalid XML 99=Other
9	LAST_DTTM_UPDATE	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.