Table Detail Report

EEM_SIMPLE_ASSOC



Column Section Top of Page


Table-level Detail

Description: This table is used to hold simple associations between objects.
Definition: EEM Simple Association
Table Type: REFERENCE





Column Detail - EEM_SIMPLE_ASSOC


Column Name Type Null? Definition
ASSOC_TYPE_CD DOUBLE N A coded identifier for the Scheduling Association Type
CHILD_ENTITY_ID DOUBLE N Primary Key of the Child Entity
CHILD_ENTITY_NAME VARCHAR(32) N Name of the Child Entity
PARENT_ENTITY_ID DOUBLE N Primary Key of the Parent Row
PARENT_ENTITY_NAME VARCHAR(32) N Name of the Parent Entity
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.


OAF_FLX_DATA_SOURCE



Column Section Top of Page


Table-level Detail

Description: data_sources
Definition: This table contains all the data sources
Table Type: ACTIVITY





Column Detail - OAF_FLX_DATA_SOURCE


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.
DATA_SOURCE_ID DOUBLE N This is the value of the unique primary identifier of the oaf_flx_data_source table. It is an internal system assigned number.
DESCRIPTION VARCHAR(255) Y This describes the data source and usually displayed in the front end
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.
FIELD VARCHAR(255) Y Field displays the mapping sequence of each data source
INFO_LONG_TEXT_ID DOUBLE N key to long text table for documents and attachments
PARENT_ENTITY_ID DOUBLE N Parent_id
PARENT_ENTITY_NAME CHAR(32) Y Parent_name
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.


OAF_FLX_PROMPT



Column Section Top of Page


Table-level Detail

Description: prompts
Definition: This table contains all the prompts used to make a profile
Table Type: ACTIVITY





Column Detail - OAF_FLX_PROMPT


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.
CODESET DOUBLE Y Code Set
DESCRIPTION VARCHAR(100) Y This is the description of prompt that is displayed in the front end
DISPLAY_ONLY_IND DOUBLE Y Display only indicator
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.
FIELD VARCHAR(255) Y Field displays the data mapping of the prompt
FORMAT VARCHAR(100) Y Formatting to apply to this column.
HL7_DESCRIPTION VARCHAR(80) Y HL7_Description
INFO_LONG_TEXT_ID DOUBLE N key to long text table for documents and attachments
LABEL VARCHAR(255) Y The displayed text of the prompt
LENGTH DOUBLE Y Length
MESSAGE VARCHAR(255) Y Message
OPTIONS VARCHAR(100) Y Options
PARENT_DATA_SOURCE_NBR DOUBLE Y This column is for import purpose mainly. The importer can read the csv and keep track of that row it should map to.Thus allowing us to not overlay clients changes with a new import.
PARENT_ENTITY_ID DOUBLE N Parent id
PARENT_ENTITY_NAME CHAR(32) Y Parent name
PROMPT_ID DOUBLE N This is the value of the unique primary identifier of the oaf_flx_prompt table. It is an internal system assigned number.
PROMPT_TYPE CHAR(12) Y Prompt_type indicates the type of prompt. (text, number etc.)
REQUIRED_IND DOUBLE Y Required_id
RULE_LONG_TEXT_ID DOUBLE N Long_text_id
SEQUENCE DOUBLE Y Sequence of the prompts
STATIC_IND DOUBLE Y Static_id
STYLE DOUBLE Y Style
SUB_TYPE_CD DOUBLE N Esi user defined code_value
TAB DOUBLE Y Tab
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_DEFINED_IND DOUBLE Y User_defined_ind
VALUE_CD DOUBLE N Code value
VALUE_DT_TM DATETIME Y Date/time of the value
VALUE_IND DOUBLE Y Value_ind
VALUE_NBR DOUBLE Y Value_nbr
VALUE_STRING VARCHAR(255) Y Value String
VALUE_TYPE CHAR(1) Y Value_type
VERIFY_IND DOUBLE Y Verify_ind


OAF_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: profile
Definition: The profile table contains profiles required by an insurance company which are used to contact the third party to obtain information regarding ones insurance coverage.
Table Type: ACTIVITY





Column Detail - OAF_PROFILE


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 DATETIME Y Date the profile was created
CONTACT_NAME VARCHAR(50) Y Contact name
END_EFFECTIVE_DT DATETIME Y Date the profile expires
LOGON_ID VARCHAR(8) Y Logon id
NEW_PASSWORD VARCHAR(10) Y New password
OLD_PASSWORD VARCHAR(10) Y Old password
PROFILE_ID DOUBLE N This is the value of the unique primary identifier of the oaf_profile table. It is an internal system assigned number.
PROFILE_NAME VARCHAR(20) Y Profile name
PROFILE_TYPE_CD DOUBLE N Profile_type_cd (whether request or reply)
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 - OAF_PROFILE




Parent Column in OAF_PROFILE (PK) Child Table Name Child Column Name
Children: PROFILE_ID OAF_PROFILE_DETAIL PROFILE_ID


OAF_PROFILE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: profile detail
Definition: The profile detail table contains detail information (fields) of each profile.
Table Type: ACTIVITY





Column Detail - OAF_PROFILE_DETAIL


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.
PRIORITY_SEQ DOUBLE Y Priority sequence indicates the order, the profile detail has been added
PROFILE_DETAIL_ID DOUBLE N This is the value of the unique primary identifier of the oaf_profile table. It is an internal system assigned number.
PROFILE_ID DOUBLE N Profile_id to which profile_detail belongs
PROMPT_ID DOUBLE N Prompt_id
REQUIRED_IND DOUBLE N Required_ind
UPDATE_IND DOUBLE N update_ind
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 - OAF_PROFILE_DETAIL


Child Column in OAF_PROFILE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PROFILE_ID OAF_PROFILE PROFILE_ID