RTM_SRC_CHKPRCS

(SQL Table)
 Index Back

Real-Time Process Condition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RTM_SOURCE_TXN Character(10) VARCHAR2(10) NOT NULL Source Transaction

Default Value: RTM_SOURCE.RTM_SOURCE_TXN

2 RTM_PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL On-Demand Process

Prompt Table: RTM_PROCESS

3 RTM_PRCS_CHECK Character(1) VARCHAR2(1) NOT NULL Check Process Result

Y/N Table Edit

Default Value: N

4 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: SQLID_VW

    • 5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN