PSWEBBROWCKVW(SQL View) |
Index Back |
|---|
| SELECT WEBPROFILENAME , COOKIEPATTERN , FORWARDDOMAIN , BLOCKDOMAIN , DELETEONLOGOUT , PROXIED , HTTPONLY , SECURE , ISBROWSERCOOKIE , BROWSERSECURE , PT_SAMESITE , PT_BCRPROP1 , PT_BCRPROP2 , PT_BCRPROP3 , PT_BCRPROP4 , PT_BCRPROP5 , PT_BCRPROP6 FROM PSWEBPROFCOOK WHERE ISBROWSERCOOKIE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  WEBPROFILENAME |
Character(30) | VARCHAR2(30) NOT NULL | Profile Name |
| 2 | COOKIEPATTERN |
Character(100) | VARCHAR2(100) NOT NULL | Cookie Pattern |
| 3 | FORWARDDOMAIN | Character(254) | VARCHAR2(254) NOT NULL | Cookies Passed to Server |
| 4 | BLOCKDOMAIN | Character(254) | VARCHAR2(254) NOT NULL | Cookies Not Passed to Server |
| 5 | DELETEONLOGOUT | Character(1) | VARCHAR2(1) NOT NULL |
Delete Cookie on Logout
Y/N Table Edit Default Value: N |
| 6 | PROXIED | Character(1) | VARCHAR2(1) NOT NULL |
Proxied
Y/N Table Edit Default Value: N |
| 7 | HTTPONLY | Character(1) | VARCHAR2(1) NOT NULL |
HttpOnly
Y/N Table Edit Default Value: N |
| 8 | SECURE | Character(1) | VARCHAR2(1) NOT NULL |
Secure
Y/N Table Edit Default Value: N |
| 9 | ISBROWSERCOOKIE | Character(1) | VARCHAR2(1) NOT NULL |
IsBrowserCookie
Y/N Table Edit Default Value: Y |
| 10 | BROWSERSECURE | Character(1) | VARCHAR2(1) NOT NULL |
browser secure
Y/N Table Edit Default Value: N |
| 11 | PT_SAMESITE | Character(1) | VARCHAR2(1) NOT NULL |
SameSite value
L=Lax N=None S=Strict Default Value: S |
| 12 | PT_BCRPROP1 | Character(1) | VARCHAR2(1) NOT NULL |
Property1
Y/N Table Edit Default Value: Y |
| 13 | PT_BCRPROP2 | Character(1) | VARCHAR2(1) NOT NULL |
Property2
Y/N Table Edit Default Value: Y |
| 14 | PT_BCRPROP3 | Character(1) | VARCHAR2(1) NOT NULL |
Property3
Y/N Table Edit Default Value: Y |
| 15 | PT_BCRPROP4 | Character(1) | VARCHAR2(1) NOT NULL |
Property4
Y/N Table Edit Default Value: Y |
| 16 | PT_BCRPROP5 | Long Character(10) | VARCHAR2(10) | Property5 |
| 17 | PT_BCRPROP6 | DateTime(26) | TIMESTAMP | Property6 |