SF_BCT_CTL_VW

(SQL View)
 Index Back

BCTP Control Log

07/20/99 SSN Added fields 'cip_src_ref', 'cip_subscriber_id' 03/21/03 MDS Added fields 'msgname' , 'subname'. 05/08/03 PWF Added fields 'errors_flg', 'partial_flg'

SELECT business_unit , eip_ctl_id , trans_program , transaction_code , dt_timestamp , bct_status , bct_source , process_instance , oprid , device_id , device_last_seq , device_dttime , eip_trans_src , eip_trans_src_ref , pubnode , chnlname , pubid , msgname , subname , errors_flg , partial_flg FROM PS_BCT_CTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 TRANS_PROGRAM Character(3) VARCHAR2(3) NOT NULL Transaction Program
4 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
5 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp
6 BCT_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction status in the stage table
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Confirmed
7 BCT_SOURCE Character(1) VARCHAR2(1) NOT NULL Indicates the source where the transaction was created
1=Msg Agent
2=Page
3=Batch
4=Auto Gen
5=Message
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID
11 DEVICE_LAST_SEQ Number(5,0) INTEGER NOT NULL Device Last Sequence Number
12 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
13 EIP_TRANS_SRC Character(30) VARCHAR2(30) NOT NULL 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
14 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference
15 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
16 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
17 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier
18 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
19 SUBNAME Character(30) VARCHAR2(30) NOT NULL Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
20 ERRORS_FLG Character(1) VARCHAR2(1) NOT NULL Indicates errors were found
N=No
Y=Yes
21 PARTIAL_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate only part of a request was completed.