Table Detail Report

ORG_ORG_RELTN_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization Organization Relationship Information
Definition: Stores auxiliary information related to an organization-organization relationship.
Table Type: REFERENCE





Column Detail - ORG_ORG_RELTN_INFO


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.
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.
ORG_ORG_RELTN_ID DOUBLE N Uniquely identifies the related org_org_reltn record.
ORG_ORG_RELTN_INFO_ID DOUBLE N Unique generated number that identifies a single row on the org_org_reltn_info table.
ORG_ORG_RELTN_INFO_TYPE_CD DOUBLE N Code value representing organization-organization relation info type.
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_NUMERIC DOUBLE Y Information stored in a numeric format.



Relationship Detail - ORG_ORG_RELTN_INFO


Child Column in ORG_ORG_RELTN_INFO(FK) Parent Table Name Parent Column Name
Parents: ORG_ORG_RELTN_ID ORG_ORG_RELTN ORG_ORG_RELTN_ID


ORG_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization set table
Definition: The ORG_SET table holds information about org sets which represent a group of orgs
Table Type: REFERENCE





Column Detail - ORG_SET


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.
DESCRIPTION VARCHAR(250) N A description of the org set
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.
NAME VARCHAR(50) N The name of the org set
ORG_SET_ATTR_BIT DOUBLE Y Specific indicator(s) set for the organization, i.e., sharing privileges: Allergies, Problems, Procedures, Medication Orders, Diagnosis, Health Maintenance Manual Satisfiers
ORG_SET_ID DOUBLE N Unique identifier for each org set
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 - ORG_SET




Parent Column in ORG_SET (PK) Child Table Name Child Column Name
Children: ORG_SET_ID ORG_SET_ORG_R ORG_SET_ID
ORG_SET_TYPE_R ORG_SET_ID


ORG_SET_ORG_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization Set Organization Relation Table
Definition: The ORG_SET_ORG_R table is used to store relationships between org sets and the orgs that belong to the org sets.
Table Type: REFERENCE





Column Detail - ORG_SET_ORG_R


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.
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.
ORGANIZATION_ID DOUBLE N Unique identifier for an organization
ORG_SET_ID DOUBLE N Unique identifier for the org set
ORG_SET_ORG_R_ID DOUBLE N Unique identifier for the organization that belongs to the particular org set.
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 - ORG_SET_ORG_R


Child Column in ORG_SET_ORG_R(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
ORG_SET_ID ORG_SET ORG_SET_ID


ORG_SET_PRSNL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Org Set Personnel Relation
Definition: This table holds information about org sets and what personnel are associated to the org sets
Table Type: REFERENCE





Column Detail - ORG_SET_PRSNL_R


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.
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.
ORG_SET_ID DOUBLE N Unique identifier for the org set
ORG_SET_PRSNL_R_ID DOUBLE N Unique identifier for the org set prsnl row, represents a unique association between an org set and a person.
ORG_SET_TYPE_CD DOUBLE N The type for the organization set, for example, the org set could be a security level org set or an emergency level org set etc.
PRSNL_ID DOUBLE N Unique identifier for the prsnl associated to the org set
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 - ORG_SET_PRSNL_R


Child Column in ORG_SET_PRSNL_R(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


ORG_SET_TYPE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Org Set Type Relation
Definition: The ORG_SET_TYPE_R table holds information about org sets and their corresponding types.
Table Type: REFERENCE





Column Detail - ORG_SET_TYPE_R


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.
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.
ORG_SET_ID DOUBLE N Unique identifier for the org set
ORG_SET_TYPE_CD DOUBLE N The org set type, ex. Security, Emergency etc.
ORG_SET_TYPE_R_ID DOUBLE N Unique identifier that represents the relationship between the org set and the type of org set.
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 - ORG_SET_TYPE_R


Child Column in ORG_SET_TYPE_R(FK) Parent Table Name Parent Column Name
Parents: ORG_SET_ID ORG_SET ORG_SET_ID