AM_IOT_INSTANCE

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Instance Name
2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

3 OFFSET Number(6,0) INTEGER NOT NULL Offset
4 LIMIT Number(6,0) INTEGER NOT NULL Limit
5 DEFAULT_ORG Character(254) VARCHAR2(254) NOT NULL Default Org
6 HOSTNAME Character(254) VARCHAR2(254) NOT NULL Host
7 PORT_NUM Number(5,0) INTEGER NOT NULL Port Number
8 PASSWORD Character(254) VARCHAR2(254) NOT NULL Password
9 USERNAME Character(30) VARCHAR2(30) NOT NULL UserName
10 DEFAULT_INSTANCE Character(1) VARCHAR2(1) NOT NULL DEFAULT_INSTANCE
N=NO
Y=YES

Default Value: N

11 PING Character(1) VARCHAR2(1) NOT NULL Ping the cluster