EA_APPLICATION_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: EA Application Type
Definition: This table will store the application type reference data.
Table Type: REFERENCE





Column Detail - EA_APPLICATION_TYPE


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.
APPLICATION_TYPE_DESC VARCHAR(200) N Description of the application type
APPLICATION_TYPE_NAME VARCHAR(50) N Unique name for the application type
CREATE_DT_TM DATETIME N Timestamp when the record was created.
CREATE_USER_NAME VARCHAR(50) N Identifier of the user or system which created the record.
EA_APPLICATION_TYPE_ID DOUBLE N PRIMARY KEY. Database generated sequence number
UPDATE_USER_NAME VARCHAR(50) N Identifier of the user or system which updated the record.
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 - EA_APPLICATION_TYPE




Parent Column in EA_APPLICATION_TYPE (PK) Child Table Name Child Column Name
Children: EA_APPLICATION_TYPE_ID EA_TRANSACTION_HIST EA_APPLICATION_TYPE_ID
EA_TRANSACTION_MAIN EA_APPLICATION_TYPE_ID


EA_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Attribute
Definition: Represents a security "attribute", be it a privilege or account restriction, that may be assigned to a user account.
Table Type: REFERENCE





Column Detail - EA_ATTRIBUTE


Column Name Type Null? Definition
ATTRIBUTE_NAME VARCHAR(100) N Name of the attribute
EA_ATTRIBUTE_ID DOUBLE N Generated unique identifier for an attribute.
NAMESPACE VARCHAR(200) N The namespace (e.g., privilege or restriction) with which this attribute is associated.
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 - EA_ATTRIBUTE




Parent Column in EA_ATTRIBUTE (PK) Child Table Name Child Column Name
Children: EA_ATTRIBUTE_ID EA_USER_ATTRIBUTE_RELTN EA_ATTRIBUTE_ID


EA_CONFIG



Column Section Top of Page


Table-level Detail

Description: Enterprise (Security Service) Configuration
Definition: Name-Value pairs representing Security Service configuration setting.
Table Type: REFERENCE





Column Detail - EA_CONFIG


Column Name Type Null? Definition
CONFIG_NAME VARCHAR(100) N Name of the configuration setting.
CONFIG_VALUE VARCHAR(1000) Y The value of the configuration setting.
EA_CONFIG_ID DOUBLE N Generated unique identifier for a configuration setting.
REALM VARCHAR(100) N The realm or domain with which the user account is associated.
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.


EA_DIGITAL_CERT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DIGITAL CERTIFICATES
Definition: Represents digital certificates available to tye system
Table Type: REFERENCE





Column Detail - EA_DIGITAL_CERT


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.
ALIAS VARCHAR(250) N ALIAS TEXT
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMPROMISED_DT_TM DATETIME Y Timestamp indicating when the key pair was flagged as having been compromised
EA_DIGITAL_CERT_ID DOUBLE N Unique generated number that identifies a single row on the DIGITAL_CERT table
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FINGERPRINT VARCHAR(1000) N Base 64 encoded hash of the certificate
NOT_AFTER_DT_TM DATETIME Y Certificate's Not After value. The certificate is not valid after this date/time.
NOT_BEFORE_DT_TM DATETIME Y Certificate's Not Before value. The certificate is not valid before this date/time.
SUBJECT VARCHAR(4000) N SUBJECT MATTER
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 - EA_DIGITAL_CERT




Parent Column in EA_DIGITAL_CERT (PK) Child Table Name Child Column Name
Children: EA_DIGITAL_CERT_ID EA_DIGITAL_CERT_KEYS EA_DIGITAL_CERT_ID


EA_DIGITAL_CERT_KEYS



Column Section Relationship Section Top of Page


Table-level Detail

Description: EA_DIGITAL_CERT_KEYS
Definition: Holds cryptographic keys used by Certificate Management service.
Table Type: REFERENCE





Column Detail - EA_DIGITAL_CERT_KEYS


Column Name Type Null? Definition
EA_DIGITAL_CERT_ID DOUBLE N FK value from the EA_DIGITAL_CERT table.
EA_DIGITAL_CERT_KEYS_ID DOUBLE N Unique generated number that identifies a single row on the EA_DIGITAL_CERT_KEYS table.
KEY_DATA LONGTEXT Y Cryptographic data.
KEY_TYPE_FLAG DOUBLE N Indicates the type of cryptographic data (private key, digital certificate, etc.).
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 - EA_DIGITAL_CERT_KEYS


Child Column in EA_DIGITAL_CERT_KEYS(FK) Parent Table Name Parent Column Name
Parents: EA_DIGITAL_CERT_ID EA_DIGITAL_CERT EA_DIGITAL_CERT_ID