SFTWR_TITLEPrompt Table: VENDOR_NS
I=Installation
U=User
Default Value: 1
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
IT_SFTWR(SQL Table) |
Index Back |
|---|---|
Software Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFTWR_TITLE |
Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 2 | SFTWR_PUBLISHER | Character(30) | VARCHAR2(30) NOT NULL |
Software Publisher
Prompt Table: VENDOR_NS |
| 3 | LICENSE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
License Type
I=Installation U=User |
| 4 | INSTALL_PER_USER | Number(3,0) | SMALLINT NOT NULL |
Installations Per User
Default Value: 1 |
| 5 | PERMISSION_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Permission Required
Y/N Table Edit Default Value: Y |
| 6 | TRACK_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Track Requisition
Y/N Table Edit Default Value: N |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 8 | DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Delete Loaded Items |