Table Detail Report
INVTN_PROGRAM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Includes all programs that have been built for invitations. |
Definition: | Programs provide a defined scope for a group of invitations. All invitations belong to exactly one program. |
Table Type: | REFERENCE |
Column Detail - INVTN_PROGRAM
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. |
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. |
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. |
PREV_PROGRAM_ID | DOUBLE | N | Programs are grouped by this identifier so that all versions of a program have the same prev_program_id. Type 2 versioning. |
PROGRAM_GROUP_ID | DOUBLE | N | The foreign key to the INVTN_PROGRAM_GROUP table to identify which group the program belongs to. |
PROGRAM_ID | DOUBLE | N | The unique primary key that identifies the program. |
PROGRAM_MEANING | VARCHAR(100) | N | Represents the unique meaning for the program. |
PROGRAM_NAME | VARCHAR(250) | N | The display name of the program. This is typically unique within a program group. |
PROGRAM_TYPE | VARCHAR(100) | N | Represents the type of program that contains the invitation. |
SOURCE_MEANING | VARCHAR(250) | N | The meaning of the SOURCE of the program. This must be unique per program_group_id and source_type. |
SOURCE_TYPE | VARCHAR(100) | N | The type of the SOURCE of the program |
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. |
WORKFLOW_ID | DOUBLE | N | The foreign key to the INVTN_WORKFLOW table to identify which workflow is associated to the program. |
Relationship Detail - INVTN_PROGRAM
Child Column in INVTN_PROGRAM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREV_PROGRAM_ID | INVTN_PROGRAM | PROGRAM_ID |
PROGRAM_GROUP_ID | INVTN_PROGRAM_GROUP | PROGRAM_GROUP_ID | |
WORKFLOW_ID | INVTN_WORKFLOW | WORKFLOW_ID |
Parent Column in INVTN_PROGRAM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROGRAM_ID | INVTN_COMMUNICATION | PROGRAM_ID |
INVTN_FRAGMENT | PROGRAM_ID | ||
INVTN_INVITATION | PROGRAM_ID | ||
INVTN_INVITATION_ACTION | PROGRAM_ID | ||
INVTN_PROGRAM | PREV_PROGRAM_ID |
INVTN_PROGRAM_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | INVITATION PROGRAM GROUP |
Definition: | Reference Data. A logical collection of programs and the attributes that exist for the grouping. |
Table Type: | REFERENCE |
Column Detail - INVTN_PROGRAM_GROUP
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. |
AUTO_GENERATE_IND | DOUBLE | N | Determines if the program group should have communications generated automatically according to AUTO_GEN_SCHEDULE. |
AUTO_GEN_CRITERIA_TEXT_ID | DOUBLE | N | The identifier of the LONG_TEXT_REFERENCE table storing the parameters for automatically generating communications for this group. The parameters consist of the invitation list(s) to generate and any filters to apply. The parameters are serialized with JSON. |
AUTO_GEN_DESTINATION | VARCHAR(50) | Y | The destination for the communications that are generated automatically. This is likely a back end print queue. |
AUTO_GEN_LAST_SUCCESS_DT_TM | DATETIME | Y | The last time communications were successfully generated automatically for this group. |
AUTO_GEN_NEXT_SCHEDULED_DT_TM | DATETIME | Y | The next time that communications will automatically be generated for this group. |
AUTO_GEN_SCHEDULE | VARCHAR(255) | Y | The schedule determining when to generate communications automatically for this group. Represents the RRule portion of the rfc2445 specification. |
AUTO_GEN_START_DT_TM | DATETIME | Y | The first point in time to use the AUTO_GEN_SCHEDULE to generate communications automatically for this group. |
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. |
COMMUNICATION_TEMPLATE | VARCHAR(50) | Y | The template to use when generating the communication. This is a discern layout program that is client created. |
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. |
INVITATION_TYPE | VARCHAR(50) | N | The type of invitation that the program group is for. |
LOOK_BACK_UNIT_CD | DOUBLE | N | The unit of time for the look back range. For example: "an encounter within the last 6 months" would be a look back unit of 'months'. |
LOOK_BACK_VALUE | DOUBLE | N | A person only qualifies for an invitation for a certain amount of time after a qualifying event. The amount of time that the invitation should exist for this program group is the look_back_value. For example: "an encounter within the last 6 months" would be a look back value of '6'. |
NOTE_TYPE_ID | DOUBLE | N | The note type that all communications generated for this group will use when they are saved to the patient's chart. Foreign Key to NOTE_TYPE table. |
PREV_PROGRAM_GROUP_ID | DOUBLE | N | Program groups are grouped by this identifier so that all versions of a program group have the same prev_program_group_id. Type 2 versioning. |
PROGRAM_GROUP_ID | DOUBLE | N | The unique identifier of the program group |
PROGRAM_GROUP_NAME | VARCHAR(250) | N | The name of the program group. |
RELEASE_FLAG | DOUBLE | N | Identifies the version of the Code Release / RevisionValue 0 - "original" code release.Value 1 - "first" code revision releaseValue 2 - "second" code revision releaseEtc. |
SENDER_PRSNL_ID | DOUBLE | N | Personnel identifier of the user that will be marked as the sender of any invitations sent for this program 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 - INVTN_PROGRAM_GROUP
Child Column in INVTN_PROGRAM_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREV_PROGRAM_GROUP_ID | INVTN_PROGRAM_GROUP | PROGRAM_GROUP_ID |
AUTO_GEN_CRITERIA_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
NOTE_TYPE_ID | NOTE_TYPE | NOTE_TYPE_ID | |
SENDER_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in INVTN_PROGRAM_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROGRAM_GROUP_ID | INVTN_FRAGMENT | PROGRAM_GROUP_ID |
INVTN_PROGRAM | PROGRAM_GROUP_ID | ||
INVTN_PROGRAM_GROUP | PREV_PROGRAM_GROUP_ID | ||
INVTN_PROGRAM_GROUP_RELTN | PROGRAM_GROUP_ID |
INVTN_PROGRAM_GROUP_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | INVITATION PROGRAM GROUP RELATION |
Definition: | Reference Data. Definition of entities or criteria which make up a program group. This could be a group of locations, patient-provider relationships, etc. |
Table Type: | REFERENCE |
Column Detail - INVTN_PROGRAM_GROUP_RELTN
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. |
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. |
CRITERIA_ID | DOUBLE | N | The id of the criteria. A foreign key to the table specified in column CRITERIA_NAME |
CRITERIA_NAME | VARCHAR(30) | N | The name of the table the criteria belongs to. Functionally, it specifies the type of the criteria |
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. |
INVTN_VERSION | DOUBLE | N | The version of invitation build that this group relation belongs to. |
PREV_PROGRAM_GROUP_RELTN_ID | DOUBLE | N | Program group relations are grouped by this identifier so that all versions of a program group relation have the same prev_program_group_reltn_id. Type 2 versioning. |
PROGRAM_GROUP_ID | DOUBLE | N | The program group that this relationship belongs to. |
PROGRAM_GROUP_RELTN_ID | DOUBLE | N | The unique identifier of the program group relation |
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 - INVTN_PROGRAM_GROUP_RELTN
Child Column in INVTN_PROGRAM_GROUP_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROGRAM_GROUP_ID | INVTN_PROGRAM_GROUP | PROGRAM_GROUP_ID |
PREV_PROGRAM_GROUP_RELTN_ID | INVTN_PROGRAM_GROUP_RELTN | PROGRAM_GROUP_RELTN_ID |
Parent Column in INVTN_PROGRAM_GROUP_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROGRAM_GROUP_RELTN_ID | INVTN_PROGRAM_GROUP_RELTN | PREV_PROGRAM_GROUP_RELTN_ID |
INVTN_WORKFLOW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | INVITATION WORKFLOW |
Definition: | Reference Data. Definition of invitation workflows which can be assigned to multiple programs. Workflows are used to define what tracking statuses and communication scheduling parameters should be used for a program. |
Table Type: | REFERENCE |
Column Detail - INVTN_WORKFLOW
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. |
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. |
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. |
PREV_WORKFLOW_ID | DOUBLE | N | Workflows are grouped by this identifier so that all versions of a workflow have the same prev_workflow_id. Type 2 versioning. |
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. |
WORKFLOW_ID | DOUBLE | N | The unique identifier of the workflow |
WORKFLOW_NAME | VARCHAR(250) | N | The unique name of the workflow. |
Relationship Detail - INVTN_WORKFLOW
Child Column in INVTN_WORKFLOW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREV_WORKFLOW_ID | INVTN_WORKFLOW | WORKFLOW_ID |
Parent Column in INVTN_WORKFLOW (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WORKFLOW_ID | INVTN_PROGRAM | WORKFLOW_ID |
INVTN_WORKFLOW | PREV_WORKFLOW_ID | ||
INVTN_WORKFLOW_STATUS | WORKFLOW_ID |
INVTN_WORKFLOW_STATUS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | INVITATION WORKFLOW_STATUS |
Definition: | Reference Data. Statuses and communication scheduling parameters for workflows |
Table Type: | REFERENCE |
Column Detail - INVTN_WORKFLOW_STATUS
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. |
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. |
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. |
GENERATED_TRACKING_STATUS_CD | DOUBLE | N | The tracking status that the invitation should change to after the scheduled communication is generated. |
PREV_WORKFLOW_STATUS_ID | DOUBLE | N | Workflow statuses are grouped by this identifier so that all versions of a workflow status have the same prev_workflow_status_id. Type 2 versioning. |
SCHEDULE_COMMUNICATION_IND | DOUBLE | N | Determines whether a communication should be scheduled for this workflow status. If '1', schedule information should be populated. |
SCHEDULE_START_FLAG | DOUBLE | N | Determines what to use as the starting date for scheduling the communication. The schedule value and unit will be added to this date. |
SCHEDULE_UNIT_CD | DOUBLE | N | The unit of the amount of time to use when scheduling a communication for the workflow status |
SCHEDULE_VALUE | DOUBLE | N | The value of the amount of time to use when scheduling a communication for this workflow status. |
TRACKING_STATUS_CD | DOUBLE | N | The tracking status for this workflow status. |
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. |
WORKFLOW_ID | DOUBLE | N | The foreign key to the INVTN_WORKFLOW table to identify the workflow this status belongs to. |
WORKFLOW_STATUS_ID | DOUBLE | N | The unique identifier of the workflow status. |
WORKFLOW_STATUS_SEQUENCE | DOUBLE | N | The sequence of this status among other statuses in the workflow |
Relationship Detail - INVTN_WORKFLOW_STATUS
Child Column in INVTN_WORKFLOW_STATUS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WORKFLOW_ID | INVTN_WORKFLOW | WORKFLOW_ID |
PREV_WORKFLOW_STATUS_ID | INVTN_WORKFLOW_STATUS | WORKFLOW_STATUS_ID |
Parent Column in INVTN_WORKFLOW_STATUS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WORKFLOW_STATUS_ID | INVTN_WORKFLOW_STATUS | PREV_WORKFLOW_STATUS_ID |