SCC_STG_LOG

(SQL Table)
Index Back

Const Stg Log msgs

Message Logging table for Constituent Transaction Manager

# 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 MESSAGE_SEVERITY Number(5,0) INTEGER NOT NULL Message Severity
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 DTTM_STAMP 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.
9 SCC_STG_MSG_CONTXT Character(1) VARCHAR2(1) NOT NULL Transaction Manager Log Context
B=Both
C=Constituent
O=Other
T=Transaction