BCT_CTL

(SQL Table)
 Index Back

BCTP Control Log

Transaction header table

  • Parent Record Of BCT_DTL BCT_D_MG_PRD_VW BCT_D_MG_USG_VW BCT_HIST_DTL BCT_HIST_FULGRP INV_FUL_GRP_EC INV_FUL_GRP_VW INV_GRP_OVR_VW INV_RSV_GRP_VW IN_FL_PARSE_GRP IN_FW_BCT_2_VW IN_TR_BC_TAO IN_TR_BS_TAO SF_BCT_DTL_VW

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

    Default Value: OPR_DEF_TBL_FS.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

    Default Value: NEXT

    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

    Default Value: %Datetime

    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

    Default Value: 0

    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_REF Character(30) VARCHAR2(30) NOT NULL Source Reference
    14 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 :-)
    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

    Y/N Table Edit

    Default Value: N

    21 PARTIAL_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate only part of a request was completed.

    Y/N Table Edit

    Default Value: N