Table Detail Report

PM_LOC_ATTRIB_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM LOC ATTRIB HIST
Definition: Person Mgmt: History of attributes related to locations
Table Type: REFERENCE





Column Detail - PM_LOC_ATTRIB_HIST


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.
ATTRIB_TYPE_CD DOUBLE N Type of attribute that is related to a location (e.g. Motor Vehicle, Fire/Explosion)
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.
DESCRIPTION VARCHAR(40) Y Free-text description of the attribute
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.
HIST_ACTION VARCHAR(3) N Indicates what type of action occurred (add, update, delete, etc.)
LOCATION_CD DOUBLE N Code value describing the location related to the attribute
LOC_TEMPLATE_STRING VARCHAR(20) Y Column is not used
PARENT_ENTITY_ID DOUBLE N When a location is closed, this column gets stamped with the location_cd of the parent location that was closed. (e.g. if a Room gets closed, the bed locations belonging in that room will have a parent_entity_id equal to the location_cd for the Room)
PARENT_ENTITY_NAME VARCHAR(60) Y CDF meaning from code set 17649 describing the type of attribute
PM_LOC_ATTRIB_HIST_ID DOUBLE N Primary key
PM_LOC_ATTRIB_ID DOUBLE N Foreign key attribute associating the history row with a certain row on the pm_loc_attrib 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.
VALUE_CD DOUBLE N Value used for tying code values to attributes
VALUE_DT_TM DATETIME Y Value used for tying date/time to attributes
VALUE_ID DOUBLE N Value used for tying id's to attributes
VALUE_NUM DOUBLE Y Value used for tying integers to attributes
VALUE_STRING VARCHAR(40) Y Value used for tying strings to attributes
VALUE_TIME_NUM DOUBLE Y Value used for tying times to attributes
VALUE_TYPE VARCHAR(1) Y Indicates which value type is filled out (date, string, etc.)



Relationship Detail - PM_LOC_ATTRIB_HIST


Child Column in PM_LOC_ATTRIB_HIST(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD


PM_LOC_SVC_RELTN



Column Section Top of Page


Table-level Detail

Description: Person Management Location Service Relation
Definition: Audit table for facility/program service/specialty unit relationships
Table Type: REFERENCE





Column Detail - PM_LOC_SVC_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.
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.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME N The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
LOC_FACILITY_CD DOUBLE N Patient Location with a location type of facility
LOC_NURSE_UNIT_CD DOUBLE N Patient location with a location type of nurse unit
PM_LOC_SVC_RELTN_ID DOUBLE N Unique identifier for each location service relation
PROGRAM_SERVICE_CD DOUBLE N Represents the program service the patient was registered under
SPECIALTY_UNIT_CD DOUBLE N Represents the specialty associated with the program of which the patient was registered
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.


PM_PREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Enterprise Registration Preferences table.
Definition: PM_PREF
Table Type: REFERENCE





Column Detail - PM_PREF


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.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME N The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DETAILS_LONG_TEXT_ID DOUBLE N Long text string representing additional details about a preference. Mainly used to store XML strings.
DISPLAY_FLAG DOUBLE N Flags used to represent display infomation about a preference. Values are Application/Task specific.
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.
ICON_LONG_BLOB_ID DOUBLE N Used to store a Icon to the data base on the long_blob_reference table.
LABEL VARCHAR(100) Y Preference Label.
OPTIONS VARCHAR(200) Y Additional Preference Options encoded into a string.
OPTIONS_NBR DOUBLE N Additional preference options encoded into a number. Usually used as a bitmap.
PM_PREF_ID DOUBLE N Primary key for the PM Preferences table.
PM_PREF_SETUP_ID DOUBLE N Foreign key to pm_pref_setup table.
PREF_TYPE_FLAG DOUBLE N Preference Type Flag, used to determine type of preference for a given application/task.
PRIORITY_SEQ DOUBLE N Sequence that determines the order of the preference types for a given application/task.
PUBLISH_PREF_ID DOUBLE N Original preference id from the pm_pref table. The original preference_id may be deleted from this table but it is still used here to group preferences.
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_PREF


Child Column in PM_PREF(FK) Parent Table Name Parent Column Name
Parents: PM_PREF_SETUP_ID PM_PREF_SETUP PM_PREF_SETUP_ID


PM_PREF_SETUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Enterprise Registration Preference Setup Table.
Definition: PM Preference Setup
Table Type: REFERENCE





Column Detail - PM_PREF_SETUP


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.
APPLICATION_NUMBER DOUBLE N Application Number.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME N The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
LOCKED_IND DOUBLE N Determines if preferences is locked.
PERSON_PRSNL_ID DOUBLE N Personnel ID for person whom preferences are tied to.
PM_PREF_SETUP_ID DOUBLE N Primary key for the pm_pref_setup table.
POSITION_CD DOUBLE N Position Code.
TASK_NUMBER DOUBLE N Task 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_PREF_SETUP


Child Column in PM_PREF_SETUP(FK) Parent Table Name Parent Column Name
Parents: PERSON_PRSNL_ID PRSNL PERSON_ID




Parent Column in PM_PREF_SETUP (PK) Child Table Name Child Column Name
Children: PM_PREF_SETUP_ID PM_PREF PM_PREF_SETUP_ID


PM_QST_CHOICE



Column Section Top of Page


Table-level Detail

Description: PM QST CHOICE
Definition: Person Mgmt: Table to store choices for flexibly defined questionnaire questions
Table Type: REFERENCE





Column Detail - PM_QST_CHOICE


Column Name Type Null? Definition
CHOICE_ID DOUBLE N This is the value of the unique primary identifier of the pm_qst_choice table. It is an internal system assigned number.
CHOICE_NBR DOUBLE Y Number of the given choice for the question.
CHOICE_TEXT VARCHAR(255) Y Text describing the choice.
CHOICE_VALUE VARCHAR(255) Y Value of the choice.
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.
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.