Table Detail Report
AUTH_SCH_EVENT_RELTN_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Authorization Schedule Event Relationship History |
Definition: | Stores information about the history of an authorization/schedule event relationship. |
Table Type: | ACTIVITY |
Column Detail - AUTH_SCH_EVENT_RELTN_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. |
AUTHORIZATION_ID | DOUBLE | Y | Unique system generated number that identifies a single row on the AUTHORIZATION table to which the schedule event is related. |
AUTH_SCH_EVENT_RELTN_HIST_ID | DOUBLE | N | Unique system generated number that identifies a single row on the AUTH_SCH_EVENT_RELTN_HIST table.. |
AUTH_SCH_EVENT_RELTN_ID | DOUBLE | Y | Unique system generated number that identifies a single row on the AUTH_SCH_EVENT_RELTN table. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
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. |
SCH_EVENT_ID | DOUBLE | Y | Unique system generated number that identifies a single row on the SCH_EVENT table. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
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 - AUTH_SCH_EVENT_RELTN_HIST
Child Column in AUTH_SCH_EVENT_RELTN_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHORIZATION_ID | AUTHORIZATION | AUTHORIZATION_ID |
AUTH_SCH_EVENT_RELTN_ID | AUTH_SCH_EVENT_RELTN | AUTH_SCH_EVENT_RELTN_ID | |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID | |
SCH_EVENT_ID | SCH_EVENT | SCH_EVENT_ID |
ENCNTR_PLAN_AUTH_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Authorization Relation |
Definition: | Relates Encounter/Plan relationships to cooresponding Authorization information sets. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_AUTH_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. |
AUTHORIZATION_ID | DOUBLE | N | Authorization Row Identifier |
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. |
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. |
ENCNTR_PLAN_AUTH_R_ID | DOUBLE | N | Encounter Plan Authorization Relation Identifier |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Encounter Plan Relation 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. |
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 - ENCNTR_PLAN_AUTH_R
Child Column in ENCNTR_PLAN_AUTH_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHORIZATION_ID | AUTHORIZATION | AUTHORIZATION_ID |
ENCNTR_PLAN_RELTN_ID | ENCNTR_PLAN_RELTN | ENCNTR_PLAN_RELTN_ID |
Parent Column in ENCNTR_PLAN_AUTH_R (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_PLAN_AUTH_R_ID | ENCNTR_PLAN_AUTH_R_HIST | ENCNTR_PLAN_AUTH_R_ID |
ENCNTR_PLAN_AUTH_R_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Plan Authorization Relationship History |
Definition: | Stores information about the history of an encounter plan relationship associated to an authorization . |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_PLAN_AUTH_R_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. |
AUTHORIZATION_ID | DOUBLE | N | Unique system generated number that identifies the related row on the Authorization table. |
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. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | Y | 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. |
ENCNTR_PLAN_AUTH_R_HIST_ID | DOUBLE | N | Unique system generated number that identifies a specific row on the ENCNTR_PLAN_AUTH_R_HIST table. |
ENCNTR_PLAN_AUTH_R_ID | DOUBLE | N | Uniquely identifies the related row on the ENCNTR_PLAN_AUTH_R table. |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Uniquely identifies the related row on the ENCNTR_PLAN_RELTN table. |
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. |
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. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
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 - ENCNTR_PLAN_AUTH_R_HIST
Child Column in ENCNTR_PLAN_AUTH_R_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHORIZATION_ID | AUTHORIZATION | AUTHORIZATION_ID |
ENCNTR_PLAN_AUTH_R_ID | ENCNTR_PLAN_AUTH_R | ENCNTR_PLAN_AUTH_R_ID | |
ENCNTR_PLAN_RELTN_ID | ENCNTR_PLAN_RELTN | ENCNTR_PLAN_RELTN_ID | |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
PERSON_PLAN_AUTH_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Plan Authorization Relationship |
Definition: | Defines a relationship between the PERSON_PLAN_RELTN and AUTHORIZATION tables. |
Table Type: | ACTIVITY |
Column Detail - PERSON_PLAN_AUTH_R
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. |
AUTHORIZATION_ID | DOUBLE | N | Uniquely identifies a related Authorization. |
PERSON_PLAN_AUTH_R_ID | DOUBLE | N | Uniquely identifies a relationship between the Person_Plan_Reltn and the Authorization tables. |
PERSON_PLAN_RELTN_ID | DOUBLE | N | Uniquely identifies the related Persion Plan Relationship. |
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 - PERSON_PLAN_AUTH_R
Child Column in PERSON_PLAN_AUTH_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHORIZATION_ID | AUTHORIZATION | AUTHORIZATION_ID |
PERSON_PLAN_RELTN_ID | PERSON_PLAN_RELTN | PERSON_PLAN_RELTN_ID |
Parent Column in PERSON_PLAN_AUTH_R (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PERSON_PLAN_AUTH_R_ID | PERSON_PLAN_AUTH_R_HIST | PERSON_PLAN_AUTH_R_ID |
PERSON_PLAN_AUTH_R_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Plan Authorization Relationship History |
Definition: | Stores information about the history of a person plan relationship associated to an authorization |
Table Type: | ACTIVITY |
Column Detail - PERSON_PLAN_AUTH_R_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. |
AUTHORIZATION_ID | DOUBLE | N | Uniquely identifies the related row on the Authorization table. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
PERSON_PLAN_AUTH_R_HIST_ID | DOUBLE | N | Unique generated number that identifies a single row on the PERSON_PLAN_AUTH_R_HIST table. |
PERSON_PLAN_AUTH_R_ID | DOUBLE | N | Uniquely identifies the related row on the PERSON_PLAN_AUTH_R table. |
PERSON_PLAN_RELTN_ID | DOUBLE | N | Uniquely identifies the related row on the PERSON_PLAN_RELTN table. |
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. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
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 - PERSON_PLAN_AUTH_R_HIST
Child Column in PERSON_PLAN_AUTH_R_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHORIZATION_ID | AUTHORIZATION | AUTHORIZATION_ID |
PERSON_PLAN_AUTH_R_ID | PERSON_PLAN_AUTH_R | PERSON_PLAN_AUTH_R_ID | |
PERSON_PLAN_RELTN_ID | PERSON_PLAN_RELTN | PERSON_PLAN_RELTN_ID | |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |