FS_BTF_PRCS_AET

(SQL Table)
 Index Back

BTF Test Case Processes AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Default Value: Y

5 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
6 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PRCSDEFN

7 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

    • 8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    9 COMPARE_RESULT Character(1) VARCHAR2(1) NOT NULL Compare Result
    10 MAX_WAIT_TIME Number(9,0) DECIMAL(9) NOT NULL Maximum Wait Time (Minutes)

    Default Value: 5

    11 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

    Prompt Table: ACTIVE_SERVERS

    12 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    13 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    14 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    15 RECNAME_SEQ Character(15) VARCHAR2(15) NOT NULL Sequence Record Name
    16 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    17 FIELDSEQVAL Character(40) VARCHAR2(40) NOT NULL Field Sequence Value
    18 FIELDSEQNBR Number(30,0) DECIMAL(30) NOT NULL Field Sequence Value
    19 PARM_STRING Character(254) VARCHAR2(254) NOT NULL Parameter String