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 |