Pages, 30 (ver3.6.1)
This table stores security settings for every page that has been modified from default. In addition, it stores references to pages that need to inherit security settings from another page, such as dialogs and pop-up pages.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DefaultPath | 11.0.3 | Varchar(1000) | The value of the related Pages.path value. Ignored if related path record does not exist. Otherwise the related record security settings are used for the path. |
Directory | 3.6.1 | CLOB | The network path to the file starting with the admin folder. |
Filename | 3.6.1 | Varchar(60) | The actual name of the page including extension. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ModDate | 3.6.1 | Date | The last date this page had a security setting changed on it. |
ModSecs | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ModTime | 3.6.1 | Number(10,0) | The time the security setting was changed. |
ModifyCode | 3.6.1 | Number(10,0) | UserID of the person changing the security setting on this page. |
Path | 3.6.1 | Varchar(1000) | The path and file name combined. |
Security | 3.6.1 | Varchar(500) | The security setting for all the groups in PS each character is a group starting with 1 and ending with 500. Asterisk and blank are default settings (0=no access, 1=view, 2=full). |