WEBSERVERNAMEPORTALHTTPPORTWEBSITENAMEPSWEBPRFHS_SRCH(SQL View) |
Index Back |
|---|---|
Web Profile History Search |
| SELECT A.WEBSERVERNAME ,A.PORTALHTTPPORT ,A.WEBSITENAME ,A.WEBPROFILENAME ,A.DELIVEREDLAST FROM PSWEBPROFHIST A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WEBSERVERNAME |
Character(150) | VARCHAR2(150) NOT NULL | Web Server Name |
| 2 | PORTALHTTPPORT |
Number(7,0) | INTEGER NOT NULL | HTTP Listen Port |
| 3 | WEBSITENAME |
Character(30) | VARCHAR2(30) NOT NULL | Web Site Name |
| 4 | WEBPROFILENAME | Character(30) | VARCHAR2(30) NOT NULL | Profile Name |
| 5 | DELIVEREDLAST | DateTime(26) | TIMESTAMP | Profile was Loaded |