Table Detail Report

RC_TIMELINE_MIGRATION_LEVEL



Column Section Top of Page


Table-level Detail

Description: Revenue Cycle Timeline Migration Level
Definition: The table stores reference information about the migration level.
Table Type: REFERENCE





Column Detail - RC_TIMELINE_MIGRATION_LEVEL


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N This will be used to identify the type of activity. for example, statement cycle changes, balance status changes, move charges, workflow, etc.
COMPLETE_IND DOUBLE N Indicates if the migration has been completed for the solution_cd and activity_type_cd combination. Defaults to 0 and must be set to 1 to indicate completion.
CREATED_DT_TM DATETIME Y The date and time this row was created.
MIGRATION_LEVEL_NBR DOUBLE N This column indicates the migration level for solution_cd and activity_type_cd that were migrated together.
RC_TIMELINE_MIGRATION_LEVEL_ID DOUBLE N Unique generated number that identifies a single row on the rc_timeline_migration_level table.
SOLUTION_CD DOUBLE N This will carry solution names like registration, scheduling, HIM, care management, CPA.
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.


SELECTED_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Selected Criteria
Definition: Selected Criteria
Table Type: REFERENCE





Column Detail - SELECTED_CRITERIA


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.
EVALUATOR_TXT VARCHAR(250) Y Evaluator Text
EVALUATOR_TYPE DOUBLE Y Evaluator Text
ORDER_SEQ DOUBLE Y Sequence Criteria that was originally entered
PFT_TASK_CRITERIA_ID DOUBLE N ProFit Task Criteria Identifier
SELECTED_CRITERIA_ID DOUBLE N Selected Criteria
SELECTED_TASK_ID DOUBLE N Foreign key to the selected task 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 - SELECTED_CRITERIA


Child Column in SELECTED_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: SELECTED_TASK_ID SELECTED_TASK SELECTED_TASK_ID
PFT_TASK_CRITERIA_ID TASK_CRITERIA PFT_TASK_CRITERIA_ID


SELECTED_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Selected Task
Definition: Selected Task
Table Type: REFERENCE





Column Detail - SELECTED_TASK


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.
MAX_ITEMS DOUBLE Y The maximum number of items to return back for workflow
PFT_TASK_ID DOUBLE N ProFit Task ID
PUSH_PULL_IND DOUBLE Y Indicates whether this task is pull(1) or push(0)
SELECTED_TASK_ID DOUBLE N Foreign key to the selected task table
SELECTED_TASK_NAME VARCHAR(250) Y Selected Task Name
TASK_OWNER_CD DOUBLE N Defines who owns this task
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 - SELECTED_TASK


Child Column in SELECTED_TASK(FK) Parent Table Name Parent Column Name
Parents: PFT_TASK_ID TASK_AVAILABLE PFT_TASK_ID




Parent Column in SELECTED_TASK (PK) Child Table Name Child Column Name
Children: SELECTED_TASK_ID PFT_SEL_TASK_R SELECTED_TASK_ID
PFT_SUB_TYPE_SECURITY SELECTED_TASK_ID
SELECTED_CRITERIA SELECTED_TASK_ID


SOLUTION_CAPABILITY



Column Section Top of Page


Table-level Detail

Description: Solution Capability
Definition: Each row represents a logged capability (capability_ident) for a given user (updt_user_id) for a given time (updt_dt_tm). It has optional fields (parent_entity_name and parentity_id) which relate to a specific entity.
Table Type: ACTIVITY





Column Detail - SOLUTION_CAPABILITY


Column Name Type Null? Definition
CAPABILITY_IDENT VARCHAR(100) Y Capability's identifier is a capability name usually in a form of alpha_number key.
PARENT_ENTITY_ID DOUBLE N Field used to store the foreign key for a related parent table.
PARENT_ENTITY_NAME VARCHAR(100) Y The name of the related parent table.
SOLUTION_CAPABILITY_ID DOUBLE N Uniquely identifies a logged capability for a given user for a given time.
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.


TASK_AVAILABLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Available
Definition: Task Available table
Table Type: REFERENCE





Column Detail - TASK_AVAILABLE


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.
PFT_TASK_ID DOUBLE N ProFit Task ID
PFT_TASK_INFO VARCHAR(250) Y ProFit Task Info
PFT_TASK_OBJECT DOUBLE Y ProFit Task Object
PFT_TASK_REQUEST DOUBLE Y ProFit Task Request
PFT_TASK_SUB_TYPE DOUBLE Y ProFit Task Sub Type
PFT_TASK_SUB_TYPE_NAME VARCHAR(250) Y ProFit Task Sub Type Name
PFT_TASK_TYPE DOUBLE Y ProFit Task Type
PFT_TASK_TYPE_NAME VARCHAR(250) Y ProFit Task Type Name
PUSH_ONLY_IND DOUBLE N Indicates if push queue only. Default 0. If field is 1 then this record can only be used for Push Queue's.
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 - TASK_AVAILABLE




Parent Column in TASK_AVAILABLE (PK) Child Table Name Child Column Name
Children: PFT_TASK_ID SELECTED_TASK PFT_TASK_ID