IT_IP_ADDR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IP_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | IP Physical Location |
| 2 | IP_ADDRESS_FROM | Character(39) | VARCHAR2(39) NOT NULL | IP Address From |
| 3 | IP_ADDR_FORMAT1 | Character(39) | VARCHAR2(39) NOT NULL | Used in formatting an IP Address entered online or received from a 3rd party integration source. Format is: xxx.xxx.xxx.xxx |
| 4 | IP_ADDRESS_TO | Character(39) | VARCHAR2(39) NOT NULL | IP Address To |
| 5 | IP_ADDR_FORMAT2 | Character(39) | VARCHAR2(39) NOT NULL | Used in formatting an IP Address entered online. Used in Component IP_ADDR_MAP as the Range To field. Format is: xxx.xxx.xxx.xxx |
| 6 | VPN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
IP Address for VPN
Default Value: N |