AM_IOT_INSTANCE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |