PSIBNWSTATUS(SQL Table) |
Index Back |
|---|---|
Integration Broker Status |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(64) | VARCHAR2(64) NOT NULL | Application Server Path | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Machine Name | |
| 3 | IB_NWSTATUS_FLAG | Number(1,0) | SMALLINT NOT NULL | NetWork Status Flag |
| 4 | IB_NWSTATUS_OPTION | Number(1,0) | SMALLINT NOT NULL | Optional Information |
| 5 | IB_NWSTATUS_OPT_ST | Number(1,0) | SMALLINT NOT NULL | Optional Status |
| 6 | IB_NWSTATUS_DIAG | Number(1,0) | SMALLINT NOT NULL | Include Diagnostic Information |
| 7 | IB_NWSTATUS_TIME | Number(7,0) | INTEGER NOT NULL |
NetWork Status Time
Default Value: 5 |
| 8 | IB_NWSTATUS_DAYS | Number(5,0) | INTEGER NOT NULL |
Last Number of Days
Default Value: 30 |
| 9 | IB_NWSTATUS_DTTM | DateTime(26) | TIMESTAMP | NetWork Status Dttm |
| 10 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 11 | EMAIL_CC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_CC |
| 12 | EMAIL_TO | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_TO |