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.