IT_SFTWR_S

(SQL Table)
Index Back

Software Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
2 SFTWR_TITLE Character(50) VARCHAR2(50) NOT NULL Software Title
3 SFTWR_PUBLISHER Character(30) VARCHAR2(30) NOT NULL Software Publisher

Prompt Table: VENDOR_NS

4 LICENSE_TYPE Character(1) VARCHAR2(1) NOT NULL License Type
I=Installation
U=User
5 INSTALL_PER_USER Number(3,0) SMALLINT NOT NULL Installations Per User

Default Value: 1

6 PERMISSION_REQD Character(1) VARCHAR2(1) NOT NULL Permission Required

Y/N Table Edit

Default Value: Y

7 TRACK_REQ Character(1) VARCHAR2(1) NOT NULL Track Requisition

Y/N Table Edit

Default Value: N

8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 DELETE_FLG Character(1) VARCHAR2(1) NOT NULL Delete Loaded Items