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