Table Detail Report

EA_TRANSACTION_MAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: EA Main Transaction
Definition: This table will store transaction information for Millennium. This data will be used to drive a Java User Management GUI, CCL reports and the Lights on Network.
Table Type: ACTIVITY





Column Detail - EA_TRANSACTION_MAIN


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 table
EA_STATUS_ID DOUBLE N Status. Foreign Key value from EA_STATUS table.
EA_TRANSACTION_ID DOUBLE N PRIMARY KEY. Database generated sequence number
EA_TRANSACTION_TYPE_ID DOUBLE N Transaction Type. Foreign key value from EA_TRANSACTION_TYPE table.
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_MAIN


Child Column in EA_TRANSACTION_MAIN(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


EA_TRANSACTION_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - EA_TRANSACTION_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.
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_TRANSACTION_TYPE_ID DOUBLE N PRIMARY KEY. Database generated sequence number
TRANSACTION_TYPE_DESC VARCHAR(200) N Description of the transaction type
TRANSACTION_TYPE_NAME VARCHAR(50) N Unique name for the transaction type
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_TRANSACTION_TYPE




Parent Column in EA_TRANSACTION_TYPE (PK) Child Table Name Child Column Name
Children: EA_TRANSACTION_TYPE_ID EA_TRANSACTION_HIST EA_TRANSACTION_TYPE_ID
EA_TRANSACTION_MAIN EA_TRANSACTION_TYPE_ID


EA_USER



Column Section Relationship Section Top of Page


Table-level Detail

Description: USER
Definition: Represents a USER in the system
Table Type: REFERENCE





Column Detail - EA_USER


Column Name Type Null? Definition
ACCOUNT_OWNER_NAME VARCHAR(100) Y The name of the entity that possesses the user account.
DIRECTORY_IND DOUBLE N Indicates WHERE the user's password is maintained -1 Not a directory user0 Use Authview default (show -defaults)1 Is a directory user
EA_USER_ID DOUBLE N Generated unique identifier for a user record.
LOGIN_FAILURE_CNT DOUBLE N The number of login failures incurred by this user since its last successful login.
MIN_PASSWORD_LENGTH DOUBLE N Minimum length required of the user's password (when set).
PASSWORD_CHANGE_DT_TM DATETIME Y The date/time at which the password last changed.
PASSWORD_HASH VARCHAR(200) Y Password hash value
PASSWORD_LIFETIME DOUBLE N The total number of days that passwords for this user are to remain valid, after which they expire.
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.
USERNAME VARCHAR(100) N Textual identifier for a user record.



Relationship Detail - EA_USER




Parent Column in EA_USER (PK) Child Table Name Child Column Name
Children: EA_USER_ID EA_PASSWORD_HISTORY EA_USER_ID
EA_USER_ATTRIBUTE_RELTN EA_USER_ID


EA_USER_ATTRIBUTE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: User-Attribute Relationship
Definition: Represents the attributes assigned to a user account.
Table Type: REFERENCE





Column Detail - EA_USER_ATTRIBUTE_RELTN


Column Name Type Null? Definition
EA_ATTRIBUTE_ID DOUBLE N Generated unique identifier for attribute.
EA_USER_ATTRIBUTE_RELTN_ID DOUBLE N Generated unique identifier for user-attribute relationships.
EA_USER_ID DOUBLE N Generated unique identifier for user 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_USER_ATTRIBUTE_RELTN


Child Column in EA_USER_ATTRIBUTE_RELTN(FK) Parent Table Name Parent Column Name
Parents: EA_ATTRIBUTE_ID EA_ATTRIBUTE EA_ATTRIBUTE_ID
EA_USER_ID EA_USER EA_USER_ID