Relevant fieldnames for a test case, test object and record.

TESTI_DFLD

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case

Prompt Table: TEST_CASE

2 RECNAME_COMPARE Character(15) VARCHAR2(15) NOT NULL Compare Difference Record

Prompt Table: RECDEFN_VW

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
5 LABEL_VALUE Character(30) VARCHAR2(30) NOT NULL Value
6 DISPLAY_WIDTH Number(5,0) INTEGER NOT NULL Display Width
7 KEY_FLG Character(1) VARCHAR2(1) NOT NULL Key Field

Y/N Table Edit

8 VISIBLE_FLAG Character(1) VARCHAR2(1) NOT NULL Visible

Y/N Table Edit

Default Value: Y