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 |