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