MFA_ACTIVITY



Column Section Top of Page


Table-level Detail

Description: MULTI FACTOR AUTHENTICATION ACTIVITY
Definition: Holds evidence used to verify that a multi-factor authentication was successfully performed.
Table Type: ACTIVITY





Column Detail - MFA_ACTIVITY


Column Name Type Null? Definition
MFA_ACTIVITY_ID DOUBLE N Unique generated number that identifies a single row on this table. Primary Key.
RECEIPT LONGTEXT Y Evidence used to verify that a multi--factor authentication was successfully performed.
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.


MFA_IDENTITY_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MFA Identity Type
Definition: Stores information about the defined Identity Types, and the Method implementations which are configured to support them.
Table Type: REFERENCE





Column Detail - MFA_IDENTITY_TYPE


Column Name Type Null? Definition
CLASS_NAME VARCHAR(260) Y FQN of the Java class which supports this identity type
IDENTITY_TYPE_NAME VARCHAR(45) N UNIQUE NAME FOR AN IDENTITY TYPE
IDENTITY_TYPE_VAL DOUBLE N A Unique Value (Enumeration) created by the application which identifies an Identity Type.
LIBRARY_NAME VARCHAR(260) Y Name of the DLL which supports this identity type
MFA_IDENTITY_TYPE_ID DOUBLE N Primary Key
MFA_METHOD_ID DOUBLE N Foreign Key to the METHOD table
TIMEOUT_AMT DOUBLE Y Amount of time framework will allow for Method to perform its authentication before cancelling the attempt and continuing.
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 - MFA_IDENTITY_TYPE


Child Column in MFA_IDENTITY_TYPE(FK) Parent Table Name Parent Column Name
Parents: MFA_METHOD_ID MFA_METHOD MFA_METHOD_ID


MFA_IDENTITY_TYPE_PROPERTY



Column Section Top of Page


Table-level Detail

Description: MFA Identity Type Property
Definition: Associates Identity Types eith Identity Type Properties - Defines Identity Type Attribute Names
Table Type: REFERENCE





Column Detail - MFA_IDENTITY_TYPE_PROPERTY


Column Name Type Null? Definition
IDENTITY_TYPE_PROPERTY_NAME VARCHAR(45) Y THE NAME OF THE PROPERTY. MUST BE UNIQUE PER IDENTITY TYPE.
MFA_IDENTITY_TYPE_ID DOUBLE N Foreign Key to the IDENTITY_TYPE table
MFA_IDENTITY_TYPE_PROPERTY_ID DOUBLE N Primary Key
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.


MFA_METHOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: MFA Method
Definition: Stores defined MFA Methods
Table Type: REFERENCE





Column Detail - MFA_METHOD


Column Name Type Null? Definition
METHOD_DESCRIPTION VARCHAR(200) Y Free-text description of the Method
METHOD_NAME VARCHAR(45) N Free-text Name for the Method. Uniquely identifies a Method in the table.
MFA_METHOD_ID DOUBLE N Primary Key
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 - MFA_METHOD




Parent Column in MFA_METHOD (PK) Child Table Name Child Column Name
Children: MFA_METHOD_ID MFA_IDENTITY_TYPE MFA_METHOD_ID
MFA_METHOD_CHAIN MFA_METHOD_ID


MFA_METHOD_CHAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: MFA Method Chain
Definition: Stores the Methods associated with a Mode, and the sequence in which the Mode Methods will be processed
Table Type: REFERENCE





Column Detail - MFA_METHOD_CHAIN


Column Name Type Null? Definition
CHAIN_SEQUENCE DOUBLE N Position of this entry in the mode's list of methods
MFA_METHOD_CHAIN_ID DOUBLE N Primary Key
MFA_METHOD_ID DOUBLE N Foreign Key to the Method table.
MFA_MODE_ID DOUBLE N Foreign Key to the MODE table
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 - MFA_METHOD_CHAIN


Child Column in MFA_METHOD_CHAIN(FK) Parent Table Name Parent Column Name
Parents: MFA_METHOD_ID MFA_METHOD MFA_METHOD_ID
MFA_MODE_ID MFA_MODE MFA_MODE_ID