PSIOSETTINGS_VW(SQL View) |
Index Back |
|---|
| SELECT IONAME , IOLINENUM , IOSETTINGNAME , IODATATYPE , IOVALUE , REQUIRED FROM PSIOSETTINGS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IONAME | Character(30) | VARCHAR2(30) NOT NULL | Interface Object Name (see PSIODEFN). |
| 2 | IOLINENUM | Number(4,0) | SMALLINT NOT NULL | Interface Object Line Number |
| 3 | IOSETTINGNAME | Character(254) | VARCHAR2(254) NOT NULL | Interface Object Setting Name |
| 4 | IODATATYPE | Character(254) | VARCHAR2(254) NOT NULL | Interface Object Data Type |
| 5 | IOVALUE | Character(128) | VARCHAR2(128) NOT NULL | Interface Object Value |
| 6 | REQUIRED | Character(8) | VARCHAR2(8) NOT NULL | Required |