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 |