Table Detail Report

EA_DIGITAL_KEYSTORE



Column Section Top of Page


Table-level Detail

Description: EA_DIGITAL_KEYSTORE
Definition: To store the certificates and keystores required as a part of the Swden Newborn workflow
Table Type: REFERENCE





Column Detail - EA_DIGITAL_KEYSTORE


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_TXT VARCHAR(250) N Arbitrary Identifier for stored KeyStore
CERT_DATA VARCHAR(4000) N Encoded string representation of Certificate in private Keystore
EA_DIGITAL_KEYSTORE_ID DOUBLE N PRIMARY KEY
NOT_AFTER_DT_TM DATETIME Y Certificate's Not After value. Issuing the certificate is not valid after this date
NOT_BEFORE_DT_TM DATETIME Y Certificate's Not Before value. Certificate isn't valid before this date
PK_DATA VARCHAR(4000) N private key on private Keystore file
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.


EA_PASSWORD_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Password History
Definition: Tracks historical changes to a user's password with the intent of preventing users from re-using passwords too frequently.
Table Type: ACTIVITY





Column Detail - EA_PASSWORD_HISTORY


Column Name Type Null? Definition
EA_PASSWORD_HISTORY_ID DOUBLE N Generated unique identifier for a historical password record.
EA_USER_ID DOUBLE N Generated unique identifier for a user record.
PASSWORD_CHANGE_DT_TM DATETIME Y The date/time at which the password last changed.
PASSWORD_HASH VARCHAR(1000) N Password hash value
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_PASSWORD_HISTORY


Child Column in EA_PASSWORD_HISTORY(FK) Parent Table Name Parent Column Name
Parents: EA_USER_ID EA_USER EA_USER_ID


EA_SERVICE_KEY



Column Section Top of Page


Table-level Detail

Description: Service Key
Definition: Represents the keys used by authenticating services.
Table Type: REFERENCE





Column Detail - EA_SERVICE_KEY


Column Name Type Null? Definition
EA_SERVICE_KEY_ID DOUBLE N Generated Unique Identifier for Service Key.
KEY_VALUE VARCHAR(200) N The key value.
REALM VARCHAR(100) N The realm or domain with which the service key is associated.
SERVICE_NAME VARCHAR(100) N Name of the service for which the key exists.
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_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: EA Status
Definition: This table will store the status reference data.
Table Type: REFERENCE





Column Detail - EA_STATUS


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.
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_STATUS_ID DOUBLE N Primary Key. Database generated sequence number
STATUS_DESC VARCHAR(200) N Description of the status
STATUS_NAME VARCHAR(12) N Unique name for the status
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_STATUS




Parent Column in EA_STATUS (PK) Child Table Name Child Column Name
Children: EA_STATUS_ID EA_TRANSACTION_HIST EA_STATUS_ID
EA_TRANSACTION_MAIN EA_STATUS_ID


EA_TRANSACTION_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: EA Historic Transaction
Definition: This table will store historic transaction information for Millennium. This data will be used to drive a historic transaction reporting.
Table Type: ACTIVITY





Column Detail - EA_TRANSACTION_HIST


Column Name Type Null? Definition
APPLICATION_NAME VARCHAR(100) N Name of the solution
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.
DEVICE_ADDRESS VARCHAR(50) N Device identification being used
DOMAIN_NAME VARCHAR(50) N Name of the Millennium domain
EA_APPLICATION_TYPE_ID DOUBLE N APPLICATION TYPE VALUE. Foreign key from EA_APPLICATION_TYPE
EA_STATUS_ID DOUBLE N EA STATUS ID. Foreign Key value from EA_STATUS
EA_TRANSACTION_ID DOUBLE N PRIMARY KEY. Database generated sequence number
EA_TRANSACTION_TYPE_ID DOUBLE N TRANSACTION TYPE ID. Foreign Key value from EA_TRANSACTION_TYPE
LAST_ACTIVITY_DT_TM DATETIME Y Timestamp of the last recorded activity for the user.
NODE_NAME VARCHAR(50) N Name of the Millennium node
TRANSACTION_COMMENT VARCHAR(255) N Comment field to be used for extra remarks required for certain transactions.
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.
USER_NAME VARCHAR(50) N Username of the requesting user



Relationship Detail - EA_TRANSACTION_HIST


Child Column in EA_TRANSACTION_HIST(FK) Parent Table Name Parent Column Name
Parents: EA_APPLICATION_TYPE_ID EA_APPLICATION_TYPE EA_APPLICATION_TYPE_ID
EA_STATUS_ID EA_STATUS EA_STATUS_ID
EA_TRANSACTION_TYPE_ID EA_TRANSACTION_TYPE EA_TRANSACTION_TYPE_ID