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 |