TEST_CASE_PRCS

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active
Default Value: Y

4 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
Prompt Table: TEST_PRCS_TBL

5 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
Prompt Table: PRCSDEFN

6 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

7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Prompt Table: PRCSRUNCNTL

8 COMPARE_RESULT Character(1) VARCHAR2(1) NOT NULL Compare Result
Y/N Table Edit
Default Value: N

9 MAX_WAIT_TIME Number(9,0) DECIMAL(9) NOT NULL Maximum Wait Time (Minutes)
Default Value: 5

10 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
Prompt Table: ACTIVE_SERVERS

11 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

12 PARM_STRING Character(254) VARCHAR2(254) NOT NULL Parameter String

13 RECNAME_SEQ Character(15) VARCHAR2(15) NOT NULL Sequence Record Name
Prompt Table: RECDEFN_VW

14 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: RECFLD_SEQ_VW

15 FIELDSEQVAL Character(40) VARCHAR2(40) NOT NULL Field Sequence Value

16 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active Default Value: Y
4	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type Prompt Table: TEST_PRCS_TBL
5	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name Prompt Table: PRCSDEFN
6	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
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Prompt Table: PRCSRUNCNTL
8	COMPARE_RESULT	Character(1)	VARCHAR2(1) NOT NULL	Compare Result Y/N Table Edit Default Value: N
9	MAX_WAIT_TIME	Number(9,0)	DECIMAL(9) NOT NULL	Maximum Wait Time (Minutes) Default Value: 5
10	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name Prompt Table: ACTIVE_SERVERS
11	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
12	PARM_STRING	Character(254)	VARCHAR2(254) NOT NULL	Parameter String
13	RECNAME_SEQ	Character(15)	VARCHAR2(15) NOT NULL	Sequence Record Name Prompt Table: RECDEFN_VW
14	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: RECFLD_SEQ_VW
15	FIELDSEQVAL	Character(40)	VARCHAR2(40) NOT NULL	Field Sequence Value
16	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.