Table Detail Report
PM_POST_DOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Misc Post Document |
Definition: | Stores the ERM post process document activity data for a person or encounter. |
Table Type: | ACTIVITY |
Column Detail - PM_POST_DOC
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | N | The date and time that this row became active, usually the date and time that it was inserted. |
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. |
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 | N | 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. |
CREATE_DT_TM | DATETIME | N | The date and time the record was created |
CREATE_PRSNL_ID | DOUBLE | N | The personnel ID of the person who created the row in the table |
DOCUMENT_OBJECT_NAME | VARCHAR(30) | Y | Custom script object name for client defined document. Script object is executed when the associated rule returns true. |
DOCUMENT_TYPE_CD | DOUBLE | N | Post document type code used to identify the type of document that was generated. |
MANUAL_CREATE_IND | DOUBLE | Y | Indicator used to determine if the document was manually generated by a user. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the address row is related (i.e., person_id, encounter_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | The upper case name of the table to which this address row is related (i.e., PERSON, ENCOUNTER, etc.) |
PM_POST_DOC_ID | DOUBLE | N | Uniquely identifies each person management post document. |
PM_POST_DOC_REF_ID | DOUBLE | N | Identifies the Post Document Reference record related to this document. |
PRIMARY_CARE_ORGANIZATION_ID | DOUBLE | N | Contains the unique Id of the related primary care organization on the organization table |
PRINT_DT_TM | DATETIME | Y | Date and time when the associated document was printed. |
REFERRING_ORGANIZATION_ID | DOUBLE | N | The value of the primary identifier of the organization table to which this row is related. |
RELATED_PERSON_ID | DOUBLE | N | Contains the the value of the primary identifier of the person table to which this row is related. |
SCHEDULE_ID | DOUBLE | N | Uniquely identifies the related schedule. |
SCH_ACTION_ID | DOUBLE | N | The identifier to uniquely identify the action being performed. |
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 - PM_POST_DOC
Child Column in PM_POST_DOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRIMARY_CARE_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
REFERRING_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
RELATED_PERSON_ID | PERSON | PERSON_ID | |
PM_POST_DOC_REF_ID | PM_POST_DOC_REF | PM_POST_DOC_REF_ID | |
SCH_ACTION_ID | SCH_EVENT_ACTION | SCH_ACTION_ID | |
SCHEDULE_ID | SCH_SCHEDULE | SCHEDULE_ID |
Parent Column in PM_POST_DOC (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PM_POST_DOC_ID | TRANS_ADMIT_NOTIFY_ALT | PM_POST_DOC_ID |
PM_POST_DOC_ORG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Management Post Document Organization Relation |
Definition: | Stores the relationships between post documents records and organizations to limit which organizations a particular post document is created for. |
Table Type: | REFERENCE |
Column Detail - PM_POST_DOC_ORG_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ORGANIZATION_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. |
PM_POST_DOC_ORG_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of this table. It is an internal system assigned number. |
PM_POST_DOC_REF_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_post_doc_ref table. It is an internal system assigned number. |
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 - PM_POST_DOC_ORG_RELTN
Child Column in PM_POST_DOC_ORG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
PM_POST_DOC_REF_ID | PM_POST_DOC_REF | PM_POST_DOC_REF_ID |
PM_POST_DOC_REF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Misc Post Doc Reference |
Definition: | Stores the reference data of ERM post document actions. |
Table Type: | REFERENCE |
Column Detail - PM_POST_DOC_REF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_OBJECT_NAME | VARCHAR(30) | Y | Custom script object name for updating values for client defined workflows. Script object is executed when the associated rule returns true. |
ACTIVE_DT_TM | DATETIME | N | The date and time that this row became active, usually the date and time that it was inserted. |
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. |
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 | N | 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. |
BATCH_PRINT_IND | DOUBLE | N | Indicator to determine if a generated document is printed in batch out of an ops job or printed real time. |
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. |
COPIES_NBR | DOUBLE | N | Number of document copies to be printed when the associated document is generated. |
DOCUMENT_OBJECT_NAME | VARCHAR(30) | Y | Custom script object name for client defined document. Script object is executed when the associated rule returns true. |
DOCUMENT_TYPE_CD | DOUBLE | N | Post document type code used to identify the type of document that was generated. |
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. |
OUTPUT_DEST_CD | DOUBLE | N | Output destination code for the generated document. |
PM_POST_DOC_REF_ID | DOUBLE | N | Uniquely identifies a row on the PM_POST_DOC_REF table. |
PREV_PM_POST_DOC_REF_ID | DOUBLE | N | This field is used to track versions of the post documents. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times. |
PRIMARY_CARE_DOC_OBJ_NAME | VARCHAR(30) | Y | Primary care physician organization custom script object name for client defined document. script object is executed when the associated rule returns true. |
PRIMARY_CARE_DOC_TYPE_CD | DOUBLE | Y | primary care physician organization post document type code used to identify the type of document that was generated. |
PROCESS_NAME | VARCHAR(250) | Y | Contains the name of the post process. |
REF_ORG_DOC_OBJ_NAME | VARCHAR(30) | Y | Referring organization custom script object name for client defined document. script object is executed when the associated rule returns true. |
REF_ORG_DOC_TYPE_CD | DOUBLE | N | Referring organization post document type code used to identify the type of document that was generated. |
RELATED_PERSON_DOC_OBJ_NAME | VARCHAR(30) | Y | Related person custom script object name for client defined document. script object is executed when the associated rule returns true. |
RELATED_PERSON_DOC_TYPE_CD | DOUBLE | N | Related person post document type code used to identify the type of document that was generated. |
REQUEST_NUMBER_CD | DOUBLE | N | Request processing number to identify request number from which the rule should be executed from. A NULL value indicates that the rule should be execute from all valid requests. |
SCH_FLEX_ID | DOUBLE | N | This column relates the post document to a specific entry on the sch_flex_list table |
TIME_BASED_OBJECT_NAME | VARCHAR(30) | Y | Custom script object name for client defined select statements. Script object is executed through an ops job to qualify persons/encounters for the associated document. |
TIME_BASED_OPS_IND | DOUBLE | N | Time Based Operations job Indicator for identifying which rules are time based. |
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 - PM_POST_DOC_REF
Child Column in PM_POST_DOC_REF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OUTPUT_DEST_CD | OUTPUT_DEST | OUTPUT_DEST_CD |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID |
Parent Column in PM_POST_DOC_REF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PM_POST_DOC_REF_ID | CR_REPORT_TEMPLATE | FACESHEET_ID |
PM_POST_DOC | PM_POST_DOC_REF_ID | ||
PM_POST_DOC_ORG_RELTN | PM_POST_DOC_REF_ID |
PM_POST_PROCESS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Management Post Process |
Definition: | Person or Encounters to be processed in off-peak hours. |
Table Type: | ACTIVITY |
Column Detail - PM_POST_PROCESS
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. |
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 | N | 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. |
BATCH_SEQ | DOUBLE | N | Contains the batch number that was sent out. |
COMPARISON_PERSON_ID | DOUBLE | N | The person ID of the comparison person data to be compared during off-peak hours. |
ENCNTR_ID | DOUBLE | N | Encounter to be processed during off-peak hours. |
ENCNTR_SLICE_ID | DOUBLE | N | The encounter slice ID to be processed during off-peak hours. This is a foreign key back to the encntr_slice table. |
ORGANIZATION_ID | DOUBLE | N | This is a foreign key to the Organization table. |
PERSON_ID | DOUBLE | N | Person to be processed during off-peak hours. |
PM_POST_PROCESS_DT_TM | DATETIME | N | Shows the date and time the status changed |
PM_POST_PROCESS_ID | DOUBLE | N | Person Management Post Process Unique Identifier |
PM_POST_PROCESS_TYPE_CD | DOUBLE | N | Type of off-peak processing to be done. |
PROCESS_RESULT_CD | DOUBLE | N | Contains a code to represent the result message returned after processing is attempted. |
PROCESS_STATUS_CD | DOUBLE | N | Contains the status of the row |
SOURCE_VERSION_NUMBER | VARCHAR(255) | Y | Version number assigned from a master system to this record. Added to support the UK's PDS serial change number. |
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 - PM_POST_PROCESS
Child Column in PM_POST_PROCESS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
COMPARISON_PERSON_ID | PERSON | PERSON_ID | |
PERSON_ID | PERSON | PERSON_ID |
PM_QST_ANSWER
Column Section | Top of Page |
Table-level Detail
Description: | Person Mgmt: Flexible Questionnaire Answer table |
Definition: | Holds the answers to questions from a Person Mgmt flexible questionnaire |
Table Type: | ACTIVITY |
Column Detail - PM_QST_ANSWER
Column Name | Type | Null? | Definition |
---|---|---|---|
ANSWER_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_qst_answer table. It is an internal system assigned number. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.) |
QUESTION_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_qst_question table. It is an internal system assigned number. |
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. |
VALUE_CD | DOUBLE | Y | The value of the answer if it is a coded type. |
VALUE_CHC | DOUBLE | Y | The value of the answer if it is a choice from the pm_qst_choice table. |
VALUE_DT_TM | DATETIME | Y | The value of the answer if it is a datetime type. |
VALUE_IND | DOUBLE | Y | The value of the answer if it is a Boolean type. |
VALUE_NBR | DOUBLE | Y | The value of the answer if it is a numeric type. |
VALUE_TEXT | VARCHAR(255) | Y | The value of the answer if it is a text type. |
VALUE_TYPE | VARCHAR(1) | Y | The type of the value that represents the answer. |