ORG_SECURITY_POLICY_DEFN
Column Section | Top of Page |
Table-level Detail
Description: | Organization Security Policy Definition |
Definition: | Stores the policy definition defining organization access control for different concepts. |
Table Type: | REFERENCE |
Column Detail - ORG_SECURITY_POLICY_DEFN
Column Name | Type | Null? | Definition |
---|---|---|---|
CONCEPT_IDENT | VARCHAR(100) | N | Indentifier used to uniquely identify the concept. |
HONOR_SECURITY_IND | DOUBLE | N | Determines whether the policy definition should be honored or not. If it is set to 1, the policies within the definition will be honored. If it is set to 0, the policies within the definition will not be honored. |
ORG_SECURITY_POLICY_DEFN_ID | DOUBLE | N | A system generated number used to uniquely identify a row on the ORG_SECURITY_POLICY_DEFN table. |
POLICY_DEFINITION_TXT | VARCHAR(4000) | N | The policy definition for the concept defining organization access control. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
ORG_SEC_DOMAIN_POLICY
Column Section | Top of Page |
Table-level Detail
Description: | Organization Security Domain Policy |
Definition: | Stores the policies defining organization access control for the domain. |
Table Type: | REFERENCE |
Column Detail - ORG_SEC_DOMAIN_POLICY
Column Name | Type | Null? | Definition |
---|---|---|---|
ORG_SEC_DOMAIN_POLICY_ID | DOUBLE | N | System Genertated number to uniquely identify a row on the ORG_SEC_DOMAIN_POLICY table. |
POLICY_ACTIVE_IND | DOUBLE | N | Defines if the policy is active/turned on (1) or inactive/turned off (0) |
POLICY_DISPLAY | VARCHAR(40) | N | The display value for the poliscy enum/ |
POLICY_ENUM | DOUBLE | N | The enum value defining which policy the row represents. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |