Table Detail Report

EEM_FILE_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table is used to store the actions performed on a ABN content file.
Definition: EEM ABN Content File Actions
Table Type: REFERENCE





Column Detail - EEM_FILE_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N The date and time the action was performed
ACTION_PRSNL_ID DOUBLE N Action Personnel Identifier
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
EEM_FILE_ID DOUBLE N EEM Content File Identifier value
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.
FILE_ACTION_CD DOUBLE N File Action Code
FILE_ACTION_ID DOUBLE N File Action Identifier
FILE_ACTION_MEANING VARCHAR(12) N File Action Meaning
FILE_STATE_CD DOUBLE N File State Code
FILE_STATE_MEANING VARCHAR(12) N File State Meaning
IMPORT_SEQ DOUBLE N Import Sequence
LAST_DT_TM DATETIME Y The date and time the action was complete
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 - EEM_FILE_ACTION


Child Column in EEM_FILE_ACTION(FK) Parent Table Name Parent Column Name
Parents: FILE_ACTION_CD CODE_VALUE CODE_VALUE
FILE_STATE_CD CODE_VALUE CODE_VALUE
EEM_FILE_ID EEM_FILE EEM_FILE_ID
ACTION_PRSNL_ID PRSNL PERSON_ID




Parent Column in EEM_FILE_ACTION (PK) Child Table Name Child Column Name
Children: FILE_ACTION_ID EEM_IMPORT_DATA FILE_ACTION_ID


EEM_FILE_CHECK



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contain content version check sequences over time
Definition: EEM ABN File Checks
Table Type: REFERENCE





Column Detail - EEM_FILE_CHECK


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_DT_TM DATETIME N Begin Date and Time value
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.
CHECK_SEQ DOUBLE N Check Sequence
EEM_FILE_ID DOUBLE N EEM Content File Identifier value
END_DT_TM DATETIME N End Date and Time value
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.
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 - EEM_FILE_CHECK


Child Column in EEM_FILE_CHECK(FK) Parent Table Name Parent Column Name
Parents: EEM_FILE_ID EEM_FILE EEM_FILE_ID


EEM_FILE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds the relationships between payers, plans, sponsors and ABN content files.
Definition: EEM ABN File Relationship
Table Type: REFERENCE





Column Detail - EEM_FILE_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
EEM_FILE_ID DOUBLE N EEM Content File Identifier value
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.
FILE_RELTN_ID DOUBLE N c
PARENT1_CD DOUBLE N Parent1 Code
PARENT1_ID DOUBLE N Parent1 Identifier
PARENT1_MEANING VARCHAR(12) Y Parent1 Meaning
PARENT1_TABLE VARCHAR(30) Y Parent1 Table
PARENT2_CD DOUBLE N Parent1 Code
PARENT2_ID DOUBLE N Parent2 Identifier
PARENT2_MEANING VARCHAR(12) Y Parent2 Meaning
PARENT2_TABLE VARCHAR(30) Y Parent2 Table
PARENT3_CD DOUBLE N Parent3 Code
PARENT3_ID DOUBLE N Parent3 Identifier
PARENT3_MEANING VARCHAR(12) Y Parent3 Meaning
PARENT3_TABLE VARCHAR(30) Y Parent3 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 - EEM_FILE_RELTN


Child Column in EEM_FILE_RELTN(FK) Parent Table Name Parent Column Name
Parents: PARENT1_CD CODE_VALUE CODE_VALUE
PARENT2_CD CODE_VALUE CODE_VALUE
PARENT3_CD CODE_VALUE CODE_VALUE
EEM_FILE_ID EEM_FILE EEM_FILE_ID


EEM_IMPORT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table is used to track informatino about an import actions ABN content file
Definition: EEM ABN Import Data
Table Type: REFERENCE





Column Detail - EEM_IMPORT_DATA


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
EEM_FILE_ID DOUBLE N EEM Content File Identifier value
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.
FILE_ACTION_ID DOUBLE N EEM File Action Identifier
FILE_NAME VARCHAR(255) N The directory and name of the content file
FILE_SEQ DOUBLE N Starts at 1, then incremented by 1.
FIRST_DT_TM DATETIME Y Date and Time of the first iteration on the file.
IMPORT_DATA_ID DOUBLE N Import Data Identifier
ITERATION DOUBLE N Denotes the number of iterations used to import the content for this file
LAST_DT_TM DATETIME Y Date and Time of the last iteration on the file.
RECORDS_ADDED DOUBLE N Denotes the number of records added during the import.
RECORDS_ERROR DOUBLE N Denotes the number of records that caused an error during the import.
RECORDS_TOTAL DOUBLE N Denotes the total number of records processed during the import.
RECORDS_UPDATED DOUBLE N Denotes the number of records updated during the import.
SLICE_SIZE DOUBLE N Denotes the number of records processed in each iteration.
TIMER_SECONDS DOUBLE N Denotes the number of second the corresponding import script spent processing the records.
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 - EEM_IMPORT_DATA


Child Column in EEM_IMPORT_DATA(FK) Parent Table Name Parent Column Name
Parents: EEM_FILE_ID EEM_FILE EEM_FILE_ID
FILE_ACTION_ID EEM_FILE_ACTION FILE_ACTION_ID




Parent Column in EEM_IMPORT_DATA (PK) Child Table Name Child Column Name
Children: IMPORT_DATA_ID EEM_IMPORT_ERROR IMPORT_DATA_ID


EEM_IMPORT_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table tracks errors generated from an import action on an ABN content file.
Definition: EEM ABN Import Errors
Table Type: REFERENCE





Column Detail - EEM_IMPORT_ERROR


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
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.
IMPORT_DATA_ID DOUBLE N Import Data Identifier
IMPORT_ERROR_ID DOUBLE N Import Error Identifier
ITERATION DOUBLE N Denote the import iteration that caused the error
LONG_TEXT_ID DOUBLE N Primary Key to LONG_TEXT_REFERENCE table
SEQ_NBR DOUBLE N Determines the order among the children of a group.
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 - EEM_IMPORT_ERROR


Child Column in EEM_IMPORT_ERROR(FK) Parent Table Name Parent Column Name
Parents: IMPORT_DATA_ID EEM_IMPORT_DATA IMPORT_DATA_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID