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. |