BCT_CTL_CTX

(SQL Table)
Index Back

EOEN context record

EOEN context record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 EOEN_EMAIL_GROUP Number(10,0) DECIMAL(10) NOT NULL Email group id
5 EOEN_NOTIFY_TO Character(30) VARCHAR2(30) NOT NULL Notification receiver
6 EMAIL_ADDRESS Long Character CLOB Email Addresses
7 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 EOEN_LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
10 EOEN_EMAIL_SUBJECT Character(100) VARCHAR2(100) NOT NULL EOEN Email subject field
11 EOEC_UL_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
12 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
13 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
14 TRANS_PROGRAM Character(3) VARCHAR2(3) NOT NULL Transaction Program
15 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
16 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
17 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).