BCT_ERR_HIST

(SQL Table)
Index Back

BCT Error Msg History

Stage history record containing errors reported while processing transactions.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
5 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
6 LLS_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.
7 HIST_DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date/Time Purged
8 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
9 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID
10 TSE_SET_NBR Number(6,0) INTEGER NOT NULL TSE Set Number
11 TSE_EDIT_TYPE Character(1) VARCHAR2(1) NOT NULL TSE Edit Type
A=Application Edit
D=Date Range Edit
P=Prompt Table Edit
R=Required Field Edit
X=Translate Table Edit
Y=Yes/No Edit
12 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name
13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
14 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
15 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
16 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
17 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
18 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp