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 |