Table Detail Report

PHONE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PHONE HIST
Definition: Tracks modifications to history elements for a given phone table.
Table Type: ACTIVITY





Column Detail - PHONE_HIST


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.
CALL_INSTRUCTION VARCHAR(300) Y This is a text field to be used to indicate any specific protocol or instructions to be followed when calling this phone number
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CONTACT VARCHAR(100) Y The primary person or contacted for this phone number.
CONTACT_METHOD_CD DOUBLE N The intended method of contact to be used for phone entry.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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 Y 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.
DESCRIPTION VARCHAR(100) Y This is a text description for identifying who or where this phone number is associated with.
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.
EXTENSION VARCHAR(100) Y This is the local phone extension of a person or place as in a business office environment.
OPERATION_HOURS VARCHAR(255) Y Free-text entry detailing the days and hours this phone number is valid
PAGING_CODE VARCHAR(100) Y This is the specific pager number to be used after dialing a main or central pager number.
PARENT_BEG_EFFECTIVE_DT_TM DATETIME N This is the historical record of column BEG_EFFECTIVE_DT_TM in table PHONE.
PARENT_END_EFFECTIVE_DT_TM DATETIME N This is the historical record of column END_EFFECTIVE_DT_TM in table PHONE.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the phone row is related (i.e., person_id, organization_id, etc.)
PARENT_ENTITY_NAME VARCHAR(30) Y The upper case name of the table to which this phone row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
PHONE_FORMAT_CD DOUBLE N Phone Number Format Code Value (future use)
PHONE_HIST_ID DOUBLE N This is the value of the unique primary identifier of the phone_hist table. It is an internal system assigned number.
PHONE_ID DOUBLE N Phone ID is the primary unique identification number of the phone table. It is an internal system assigned sequence number.
PHONE_NUM VARCHAR(100) Y This is the actual phone number.
PHONE_NUM_KEY VARCHAR(100) Y The phone_num attribute converted to a string with spaces and special characters removed.
PHONE_TYPE_CD DOUBLE N The phone type is the code set value which identifies the type of phone for the phone row (i.e., home, business, fax, etc.)
PHONE_TYPE_SEQ DOUBLE N This is the numeric sequence that determines the priority or precedence that one phone row has over another when both phone rows contain the same parent_entity_name, parent_entity_id, and phone_type_cd with the same meaning.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support the uk's pds allocated object identifier. Used to help keep the uk master in sync with millennnium.
TEXTING_PERMISSION_CD DOUBLE N Denotes if the owner of the phone has granted permission to be contacted by text message.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row.
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 - PHONE_HIST


Child Column in PHONE_HIST(FK) Parent Table Name Parent Column Name
Parents: PHONE_ID PHONE PHONE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PM_BBL_ACTION



Column Section Top of Page


Table-level Detail

Description: Bed borrowing and lending action table.
Definition: This table contains information pertaining to when bed are borrowed from a service for anothers service's use.
Table Type: ACTIVITY





Column Detail - PM_BBL_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Date and time of action.
ACTION_FLAG DOUBLE N Flag used to determine type of action.
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.
BEDS DOUBLE N Number of beds in the action.
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.
FROM_SERVICE_CD DOUBLE N Service that lent the beds.
PM_BBL_ACTION_ID DOUBLE N Unique identifier.
RETURNED_BEDS DOUBLE Y Number of returned beds.
TO_SERVICE_CD DOUBLE N Service receiving the beds.
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.
USER_ID DOUBLE N User who performed the action.


PM_BBL_SERVICE



Column Section Top of Page


Table-level Detail

Description: Bed borrowing and lending service table.
Definition: This table contains information pertaining to bed status for services.
Table Type: ACTIVITY





Column Detail - PM_BBL_SERVICE


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.
BEDS_ALLOWED DOUBLE Y Number of beds allowed in the service.
BEDS_BORROWED DOUBLE Y Number of beds currently borrowed from another service.
BEDS_LENT DOUBLE Y Number of beds currently lent to another service.
BEDS_REMOVED DOUBLE Y Number of removed beds from the service.
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.
OPTIONS VARCHAR(100) Y Miscellaneous options (for future use).
SERVICE_CD DOUBLE N Medical service category.
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_CONSUMER_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Consumer Activity
Definition: Stores activity data for various Person Management consumer activities and transactions.
Table Type: ACTIVITY





Column Detail - PM_CONSUMER_ACTIVITY


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.
CONSUMER_ACTIVITY_TYPE_CD DOUBLE N The consumer activity type indicates the type of activity that is being recorded.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME N The date and time that indicates when the pm_consumer_activity row was created.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the pm_consumer_acitvity row is related (i.e., person_id, encounter_id, etc.)
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this pm_consumer_activity row is related (i.e., person)
PM_CONSUMER_ACTIVITY_ID DOUBLE N The primary key for the pm_consumer_activity table. It is an internally 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_CONSUMER_ACTIVITY


Child Column in PM_CONSUMER_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


PM_DOC_DIST_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM DOC DIST FILTER
Definition: Defines the filters for a PM document distribution
Table Type: REFERENCE





Column Detail - PM_DOC_DIST_FILTER


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
DISTRIBUTION_ID DOUBLE N Foreign key attribute associating the filter with a specific distribution on the pm_doc_distribution table
DIST_FILTER_ID DOUBLE N Primary Key identifier
END_EFFECTIVE_DT_TM DATETIME Y 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.
EXCLUDE_IND DOUBLE Y Used to determine if the value of this filter should be included or excluded in the qualification process
FILTER_TYPE CHAR(3) Y Defines the type of filter (et = encntr_type_cd, srv = service)
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 CHAR(100) Y Value used for tying strings to filters
VALUE_CD DOUBLE N Value used for tying code values to filters. Can be multiple Code Sets.
VALUE_DT_TM DATETIME Y Value used for tying date/time values to filters
VALUE_IND DOUBLE Y Values for indicator filters



Relationship Detail - PM_DOC_DIST_FILTER


Child Column in PM_DOC_DIST_FILTER(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID PM_DOC_DISTRIBUTION DISTRIBUTION_ID