SCC_STG_LOG_VW (SQL View)	Index Back
Const Stg Log msgs Message Logging table for Constituent Transaction Manager

SCC_STG_LOG_VW

(SQL View)

Const Stg Log msgs

Message Logging table for Constituent Transaction Manager

SELECT SCC_TEMP_ID , SCC_TRANSAC_CD , MESSAGE_SEQ , MESSAGE_SET_NBR ,MESSAGE_NBR , %Substring(%Cast(MESSAGE_SEVERITY ,Number,Character),1,1) , PROCESS_INSTANCE FROM PS_SCC_STG_LOG WHERE SCC_STG_MSG_CONTXT='C' OR SCC_STG_MSG_CONTXT='B'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID

2 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

3 MESSAGE_SEQ Number(9,0) DECIMAL(9) NOT NULL Message Sequence

4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

6 SCC_MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
0=Information
1=Warning
2=Error
3=Reconcile Error

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
2	SCC_TRANSAC_CD	Character(25)	VARCHAR2(25) NOT NULL	Transaction
3	MESSAGE_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	Message Sequence
4	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
5	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
6	SCC_MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity 0=Information 1=Warning 2=Error 3=Reconcile Error
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance