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