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. |
BEGIN_EFFECTIVE_DT_TM |
DATETIME |
N |
The date/time after which the row is considered valid as active current data. This may be valued with the date that the row became active. |
ENCNTR_ID |
DOUBLE |
N |
identifies the patient's encounter for which the IPASS data is related to. |
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. |
GLOBAL_IND |
DOUBLE |
N |
Indicates whether or not the IPASS item should be visible to all providers outside of the care team noted. |
IPASS_DATA_TYPE_CD |
DOUBLE |
N |
describes the type of IPASS data contained on that row such as, but not limited to, an action, comment or patient summary |
LAST_UPDT_PRSNL_ID |
DOUBLE |
N |
The person that last updated this row. |
ORIG_PCT_IPASS_ID |
DOUBLE |
N |
Used to track versions of the Ipass information. This field will always point back to the original value created. This may be used to find the correct version when combined with the begin and end effective dates and times |
PARENT_ENTITY_ID |
DOUBLE |
N |
The primary key for the row on the table identified by the parent entity name which contains the detailed information for the PCT_IPASS row |
PARENT_ENTITY_NAME |
VARCHAR(32) |
N |
The name of the table where the detailed data can be found. |
PCT_CARE_TEAM_ID |
DOUBLE |
N |
The Physician Care Team that this Ipass data pertains to. |
PCT_IPASS_ID |
DOUBLE |
N |
Unique, generated number that identifies a single row on the PCT_IPASS table. |
PCT_SEQ |
DOUBLE |
N |
Sequence of row in relation to PCT_TEAM_ID. Only valid when PCT_TEAM_ID > 0. |
PERSON_ID |
DOUBLE |
N |
Identifies the patient for whom the IPASS data is written. |
POSITION_CD |
DOUBLE |
N |
Indicates the role of the user adding or modifying the data. |
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. |