EXT_REQ_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: External Request Status
Definition: Table to store the third party request for ENT project.
Table Type: ACTIVITY





Column Detail - EXT_REQ_STATUS


Column Name Type Null? Definition
ACCOUNT_ID DOUBLE N Uniquely identifies the related row on the ACCOUNT table.a
BEG_EFFECTIVE_DT_TM DATETIME N 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.
BILL_VRSN_NBR DOUBLE N The version number identifying which bill
BO_HP_RELTN_ID DOUBLE N Uniquely identifies the related row on the BO_HP_RELTN table.
CORSP_ACTIVITY_ID DOUBLE N Combined with the BILL_VRSN_NBR column uniquely identifies a related row on the BILL_REC table.
ENCNTR_ID DOUBLE N Uniquely identifies the related row on the Encounter table.
END_EFFECTIVE_DT_TM DATETIME N 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.
EVENT_CD DOUBLE N Contains the event code that will be published through the request.;
EVENT_DT_TM DATETIME Y Event date when requested action was created.
EVENT_NAME VARCHAR(252) N Name used by the system to identify a specific event.
EVENT_TITLE_TXT VARCHAR(252) N Name used to display the name of the identified event.
EVENT_URL VARCHAR(252) N URL associated to the requested event occurrence.
EXT_REQ_CLOB LONGTEXT Y External request payload data from the third party request coming from HDX
EXT_REQ_IDENT VARCHAR(250) Y External request identifier from the third party request coming from HDX
EXT_REQ_STATUS_CD DOUBLE N External request status code to indicate the status of the request.
EXT_REQ_STATUS_ID DOUBLE N External request identifier from the third party request coming from HDX
EXT_REQ_STATUS_REASON_TXT VARCHAR(250) Y External request status reason to indicate the reason of the request status
PERSON_ID DOUBLE N Uniquely identifies the Person_ID on the Person table to which the requested event is associated.;
PUBLISHER_CONTACT_INFO_TXT VARCHAR(255) Y Contains the Publishers contact information
PUBLISHER_IDENT DOUBLE N ** OBSOLETE ** This column is no longer being used. It has been replaced by Publisher_txt_ident. External Unique Identifier of the Publisher Organization. ** OBSOLETE **
PUBLISHER_NAME VARCHAR(252) N Name of the publisher (organization or potentially an individual)
PUBLISHER_TXT_IDENT VARCHAR(255) Y Unique Identifier of the publisher of the request, its ALPHA numeric value from 3rd part application.
TASK_TYPE_TXT VARCHAR(252) N Contains the type of the task that is requested for processing.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - EXT_REQ_STATUS


Child Column in EXT_REQ_STATUS(FK) Parent Table Name Parent Column Name
Parents: ACCOUNT_ID ACCOUNT ACCT_ID
BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID
BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


PFT_ASSIGNMENT_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Assignment Criteria
Definition: Stores the criterias built for each of the advanced assignment rules.
Table Type: REFERENCE





Column Detail - PFT_ASSIGNMENT_CRITERIA


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.
CRITERIA_ENTITY_ID DOUBLE N Uniquely identifies the row related to the entity
CRITERIA_ENTITY_NAME VARCHAR(30) N Identifies the parent entity to which this criteria is related.
CRITERIA_NAME VARCHAR(50) N Defines the criteria token which is represented by this row.
GROUP_NBR DOUBLE N This will represtne to which row the criteria belongs, so the individual rows can be grouped within a rule.
PFT_ASSIGNMENT_CRITERIA_ID DOUBLE N Uniquely identifies criteria built for each of the advanced assignment rules.
PFT_ASSIGNMENT_RULE_ID DOUBLE N Uniquely identifies the related assignment rule.
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.
VALUE_TXT VARCHAR(50) N Contains the text value for the criteria.



Relationship Detail - PFT_ASSIGNMENT_CRITERIA


Child Column in PFT_ASSIGNMENT_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: PFT_ASSIGNMENT_RULE_ID PFT_ASSIGNMENT_RULE PFT_ASSIGNMENT_RULE_ID


PFT_ASSIGNMENT_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Assignment Rule
Definition: Stores the advanced assignment rule names created for the work item assignments.
Table Type: REFERENCE





Column Detail - PFT_ASSIGNMENT_RULE


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.
ASSIGNMENT_RULE_NAME VARCHAR(255) N The name of the advanced assignment rule.
ASSIGNMENT_RULE_NAME_KEY VARCHAR(255) N The searchable key value of the name column. The column will contain all caps and no special characters.
ENTITY_TYPE_CD DOUBLE N Identies the entity type to which the rule belongs.
LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which this row is related.
PFT_ASSIGNMENT_RULE_ID DOUBLE N Uniquely identifies an advanced assignment rule created for the work item assignments.
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 - PFT_ASSIGNMENT_RULE




Parent Column in PFT_ASSIGNMENT_RULE (PK) Child Table Name Child Column Name
Children: PFT_ASSIGNMENT_RULE_ID PFT_ASSIGNMENT_CRITERIA PFT_ASSIGNMENT_RULE_ID


PFT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds user defined events
Definition: ProFit's events
Table Type: REFERENCE





Column Detail - PFT_EVENT


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.
CURRENT_OCCURRANCE DOUBLE Y Obsolete, No longer used. - Current Occurrance
END_DT_TM DATETIME Y 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.
LAST_OPS_PING_DT_TM DATETIME Y Obsolete, no longer being used. Last operations ping date time
LAST_PING_STATUS_CD DOUBLE N - last ping stats code
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, if you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PFT_EVENT_DESC VARCHAR(250) Y Description of what event will occur
PFT_EVENT_DESC_KEY VARCHAR(250) Y Description of what event will occur, formatted to aid in performance when searching.
PFT_EVENT_ID DOUBLE N Unique Key
PFT_EVENT_NAME VARCHAR(50) Y Name of the event
PFT_EVENT_NAME_KEY VARCHAR(50) Y Event Name Key
PFT_EVENT_SUB_TYPE_CD DOUBLE N Event sub type - Claim generation, Claim Print, etc.
PFT_EVENT_TYPE_CD DOUBLE N Event Type - automated process, business process, etc.
RECURRING_IND DOUBLE Y Flag whether this is a recurring event or not.
START_DT_TM DATETIME Y Start date / time of the event
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 - PFT_EVENT


Child Column in PFT_EVENT(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in PFT_EVENT (PK) Child Table Name Child Column Name
Children: PFT_EVENT_ID PFT_DATE PFT_EVENT_ID
PFT_EVENT_PARAMS PFT_EVENT_ID
PFT_EVENT_PATTERN PFT_EVENT_ID
PFT_REPORT_INSTANCE PFT_EVENT_ID


PFT_EVENT_OCCUR_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: pft event occur log
Definition: Contains the log entries of events that are run as part of the daily jobs.
Table Type: ACTIVITY





Column Detail - PFT_EVENT_OCCUR_LOG


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_DT_TM DATETIME Y End date / time that the event occurred
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.
LOG_FILE_PRODUCED_IND DOUBLE Y log file produced indicator
OCCURANCE_SEQ DOUBLE Y The sequence this event occurred
PARENT_ENTITY_ID DOUBLE N This field will currently hold the batch_id from the si_batch table for claim resubmission. It will potentially be used for other purposes at a later date.
PARENT_ENTITY_NAME VARCHAR(60) Y This field holds the name of the entity ID stored in the parent_entity_id field. Currently, this is SI_BATCH for claim resubmission.
PFT_EVENT_ID DOUBLE N pft event id
PFT_EVENT_OCCUR_LOG_ID DOUBLE N Unique Id
PFT_EVENT_REASON_CD DOUBLE N Reason for the event
PFT_EVENT_STATUS_CD DOUBLE N The status of the event
START_DT_TM DATETIME Y Start date / time of the event
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PFT_EVENT_OCCUR_LOG




Parent Column in PFT_EVENT_OCCUR_LOG (PK) Child Table Name Child Column Name
Children: PFT_EVENT_OCCUR_LOG_ID BR_GEN_EVENT_LOG PFT_EVENT_OCCUR_LOG_ID
PFT_EVENT_OCCUR_PARAM PFT_EVENT_OCCUR_LOG_ID
PFT_QUEUE_ITEM PFT_EVENT_OCCUR_LOG_ID
PFT_SYSTEM_ACTIVITY_LOG PFT_EVENT_OCCUR_LOG_ID
RC_CONT_PROCESS_GROUP PFT_EVENT_OCCUR_LOG_ID