TEST_CASE

(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 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

3 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

4 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

5 COMPARE_STATUS Character(1) VARCHAR2(1) NOT NULL Compare Status
E=Compare Differences Exist
F=Test Case Failed
N=No Results Compared
V=No Compare Differences
Default Value: N

6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

7 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
3	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	COMPARE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Compare Status E=Compare Differences Exist F=Test Case Failed N=No Results Compared V=No Compare Differences Default Value: N
6	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
7	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.