Table Detail Report

SEC_POLICY



Column Section Relationship Section Top of Page


Table-level Detail

Description: security policy
Definition: security policy
Table Type: REFERENCE





Column Detail - SEC_POLICY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
SEC_POLICY_ID DOUBLE N security policy identifier
SEC_POLICY_MEAN VARCHAR(50) N security policy meaning
SEC_POLICY_NAME VARCHAR(50) N security policy name
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SEC_POLICY




Parent Column in SEC_POLICY (PK) Child Table Name Child Column Name
Children: SEC_POLICY_ID SEC_RES_OPERATIONS SEC_POLICY_ID


SEC_PRINCIPAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Security principals.
Definition: This table will hold the attributes for the PRINCIPALS to be secured.
Table Type: REFERENCE





Column Detail - SEC_PRINCIPAL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
PARENT_ENTITY_ID DOUBLE N The id of the row containing the principal in the parent_entity_table
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table containing the principal
SEC_PRINCIPAL_ID DOUBLE N The primary key identifying the principal
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SEC_PRINCIPAL




Parent Column in SEC_PRINCIPAL (PK) Child Table Name Child Column Name
Children: SEC_PRINCIPAL_ID SEC_RES_OPER_PRIN_R SEC_PRINCIPAL_ID


SEC_RESOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Security resource.
Definition: This table will hold the attributes for the resources to be secured. The data for this table will be shipped and is not modifiable at the client site
Table Type: REFERENCE





Column Detail - SEC_RESOURCE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
DOMAIN VARCHAR(100) N The domain that the resource is associated to.
RESOURCE_NAME VARCHAR(100) N The name for the resource being secured.
SEC_RESOURCE_ID DOUBLE N The primary key identifying the resource
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SEC_RESOURCE




Parent Column in SEC_RESOURCE (PK) Child Table Name Child Column Name
Children: SEC_RESOURCE_ID SEC_RES_OPERATIONS SEC_RESOURCE_ID


SEC_RES_OPERATIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Security Resource Operations
Definition: This table will hold the operations that can be performed on the resources from the sec_resource table. The data for this table will be shipped and is not modifiable at the client site
Table Type: REFERENCE





Column Detail - SEC_RES_OPERATIONS


Column Name Type Null? Definition
ACCESS_CONTROL_CHECK_BIT DOUBLE N Bit map of binary data representing the checks required for the resource operation (For example, a CDAC check is 1, anLR check is 2, etc.)
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AUDIT_ADAPTER_TEXT VARCHAR(255) N The audit adapter class that will be applied to the operation resource for assembling the audit event participants. This will be the fully qualified name of the java class implementing the audit adapter.
OPER_NAME VARCHAR(50) N The name of the operation.
RULE_TEXT VARCHAR(255) N The rule class that will be applied to the operation resource. This will be the fully qualified name of the java class implementing the rule.
SEC_POLICY_ID DOUBLE N The identifier of the security policy associated with this res operation.
SEC_RESOURCE_ID DOUBLE N The resource that defines the resource operation
SEC_RES_OPERATIONS_ID DOUBLE N The primary key identifying the resource operation
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SEC_RES_OPERATIONS


Child Column in SEC_RES_OPERATIONS(FK) Parent Table Name Parent Column Name
Parents: SEC_POLICY_ID SEC_POLICY SEC_POLICY_ID
SEC_RESOURCE_ID SEC_RESOURCE SEC_RESOURCE_ID




Parent Column in SEC_RES_OPERATIONS (PK) Child Table Name Child Column Name
Children: SEC_RES_OPERATIONS_ID SEC_RES_OPER_PRIN_R SEC_RES_OPERATIONS_ID


SEC_RES_OPER_PRIN_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Security resource operations principal relationships
Definition: This table will principals associated to the SEC_RESOURCE_OPER
Table Type: REFERENCE





Column Detail - SEC_RES_OPER_PRIN_R


Column Name Type Null? Definition
ACCESS_TYPE_NBR DOUBLE N The access specifier for the row. Current values are 1 - allow, 2 - disallow. In the future other access types may be possible.
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
SEC_PRINCIPAL_ID DOUBLE N The primary key of the principal that this row specifies the resource operations.
SEC_RES_OPERATIONS_ID DOUBLE N The primary key of the resource operation
SEC_RES_OPER_PRIN_R_ID DOUBLE N The primary key identifying the resource Operations for the principal.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SEC_RES_OPER_PRIN_R


Child Column in SEC_RES_OPER_PRIN_R(FK) Parent Table Name Parent Column Name
Parents: SEC_PRINCIPAL_ID SEC_PRINCIPAL SEC_PRINCIPAL_ID
SEC_RES_OPERATIONS_ID SEC_RES_OPERATIONS SEC_RES_OPERATIONS_ID