CREDENTIAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel credentials.
Definition: This table contains credential records for personnel.
Table Type: REFERENCE





Column Detail - CREDENTIAL


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.
CREDENTIAL_CD DOUBLE N Personnel credential such as MD, RN, CMT, RPh, etc.
CREDENTIAL_ID DOUBLE N The primary key of the Credential table
CREDENTIAL_TYPE_CD DOUBLE N Type of personnel credential such as certification, degree, education, and license.
DISPLAY_SEQ DOUBLE N The display sequence number of the credential in the personnel name full formatted
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.
ID_NUMBER VARCHAR(50) Y The ID Number of the credential
NOTIFIED_DT_TM DATETIME Y The date when notification was sent to personnel
NOTIFY_PRSNL_ID DOUBLE N The person id of the notification personnel
NOTIFY_TYPE_CD DOUBLE N Determines the means of communicating with the notification personnel - e.g. e-mail, pager, etc.
PARENT_ENTITY_ID DOUBLE N The id of the address or demographic relationship associated with an address that is used to notify the notification personnel
PARENT_ENTITY_NAME VARCHAR(30) Y The upper case name of the table from where the parent entity id is used
PRSNL_ID DOUBLE N The prsnl id of the prsnl who has the credential
RENEWAL_DT_TM DATETIME N The renewal date of the credential
STATE_CD DOUBLE N The state/province associated to the credential
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.
VALID_FOR_CD DOUBLE N The amount of time that the credential remains effective.



Relationship Detail - CREDENTIAL


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


CRED_LICENSE_RESTRICTIONS



Column Section Top of Page


Table-level Detail

Description: Credential License Restrictions
Definition: Future use.
Table Type: ACTIVITY





Column Detail - CRED_LICENSE_RESTRICTIONS


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.
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.
CREDENTIAL_ID DOUBLE N A unique identifier of a credential. This is a key field from the Credential table.
CRED_LIC_RESTRICT_ID DOUBLE N Unique Identifier for a Credential License Restriction.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
LICENSE_RESTRICTION_CD DOUBLE N Future Use
RESTRICTION_DESC VARCHAR(100) Y Text description of the restriction.
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.


POSITION_ROLE_TYPE



Column Section Top of Page


Table-level Detail

Description: POSITION ROLE TYPE
Definition: Table to store the position assigned to a role type.
Table Type: REFERENCE





Column Detail - POSITION_ROLE_TYPE


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 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.
CREATE_DT_TM DATETIME Y The date/time this entry was created.
CREATE_PRSNL_ID DOUBLE N The id of the person who created the request.
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.
POSITION_CD DOUBLE N position code
POSITION_ROLE_TYPE_ID DOUBLE N position role type identifier
ROLE_TYPE_CD DOUBLE N role type code
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.


PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel
Definition: The personnel table is a logical extension of the person table, but only includes the subset of persons who are classified as personnel. A single row in the personnel table is related to a single row in the person table.
Table Type: REFERENCE





Column Detail - PRSNL


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 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.
CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the personnel table.
CREATE_PRSNL_ID DOUBLE N This is the person responsible for creating a row in the personnel table.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DEPARTMENT_CD DOUBLE N not used, to be deleted!
EMAIL VARCHAR(100) Y Cerner system E-MAIL identifier for the personnel.
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.
EXTERNAL_IND DOUBLE N Set to true (1), if the personnel is external to the hospital network. Otherwise, set to false (0).
FREE_TEXT_IND DOUBLE Y not used at this time!
FT_ENTITY_ID DOUBLE N Primary key of the table row associated with a free text row.
FT_ENTITY_NAME VARCHAR(32) Y Name of the table associated with a free text row.
LOGICAL_DOMAIN_GRP_ID DOUBLE N The ID of the logical domain group that the person is assigned to.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
LOG_ACCESS_IND DOUBLE Y Log Access Ind (Not Used)
LOG_LEVEL DOUBLE Y Log Level (Not Used)
NAME_FIRST VARCHAR(200) Y This is the person's first given name.
NAME_FIRST_KEY VARCHAR(100) Y This is the person's first given name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_FIRST_KEY_A_NLS VARCHAR(400) Y NAME_FIRST_KEY_A_NLS column
NAME_FIRST_KEY_NLS VARCHAR(202) Y First Name Key field converted to NLS format for internationalization requirements
NAME_FULL_FORMATTED VARCHAR(100) Y This is the complete person name including punctuation and formatting.
NAME_LAST VARCHAR(200) Y This is the person's family name.
NAME_LAST_KEY VARCHAR(100) Y This is the person's family name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_LAST_KEY_A_NLS VARCHAR(400) Y NAME_LAST_KEY_A_NLS column
NAME_LAST_KEY_NLS VARCHAR(202) Y Last Name Key field converted to NLS format for internationalization requirements
PASSWORD VARCHAR(100) Y Encrypted form of the data store password used to authorize Millennium users access to Millennium Mobile devices.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PHYSICIAN_IND DOUBLE Y Set to TRUE, if the personnel is a physician. Otherwise, set to FALSE.
PHYSICIAN_STATUS_CD DOUBLE N Physician status code identifies the status of the physician. (For Example: In, In Surgery, Out, etc.)
POSITION_CD DOUBLE N The position is used to determine the applications and tasks the personnel is authorized to use.
PRIM_ASSIGN_LOC_CD DOUBLE N Primary Assigned Location Code identifies the primary location to which a personnel will be assigned.
PRSNL_TYPE_CD DOUBLE N The personnel type is used to group personnel with common characteristics (I.e., user, non-user, template user)
SECTION_CD DOUBLE N not used, to be deleted!
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.
USERNAME VARCHAR(50) Y The system user name for the personnel used to gain primary access to the computer system.



Relationship Detail - PRSNL


Child Column in PRSNL(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
LOGICAL_DOMAIN_GRP_ID LOGICAL_DOMAIN_GRP LOGICAL_DOMAIN_GRP_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PRSNL (PK) Child Table Name Child Column Name
Children: PERSON_ID ACCOUNT CREATED_PRSNL_ID
ACTIVITY_LOG CREATED_PRSNL_ID
ACT_PW_COMP_G_ACTION PRSNL_ID
ACUTE_CARE_AUDIT_INFO AUDIT_PRSNL_ID
ALERT_AUDIT_TRANSACTION PRSNL_ID
ALLERGY_EXT_DATA ACTION_PRSNL_ID
ALLERGY_EXT_DATA CMB_PRSNL_ID
AP_APP_FOLDERS USER_ID
AP_CASE_QUERY STARTED_PRSNL_ID
AP_DC_EVENT CANCEL_PRSNL_ID
AP_DC_EVENT COMPLETE_PRSNL_ID
AP_DC_EVENT INITIATED_PRSNL_ID
AP_DC_EVENT REPORT_ISSUED_BY_PRSNL_ID
AP_DC_EVENT_PRSNL PRSNL_ID
AP_DIAG_RPT_REVIEW VERIFIED_PRSNL_ID
AP_EXT_DATA ACTION_PRSNL_ID
AP_EXT_DATA ISSUE_PRSNL_ID
AP_FAVORITE PRSNL_ID
AP_FOLDER CREATE_PRSNL_ID
AP_FOLDER_ENTITY CREATE_PRSNL_ID
AP_FT_EVENT ORIGIN_PRSNL_ID
AP_FT_EVENT TERM_ID
AP_IMAGE_GROUP_INI PERSON_ID
AP_IMAGE_ITEM_INI PERSON_ID
AP_PRSNL_PRIV PRSNL_ID
AP_QA_INFO ACTIVATED_ID
AP_QA_INFO COMPLETE_ID
AP_QA_INFO SUSPEND_ID
AP_SPECIMEN_PROTOCOL PATHOLOGIST_ID
AP_SYS_CORR ASSIGN_TO_PRSNL_ID
AP_TRANS_STAT PATHOLOGIST_ID
AP_TRANS_STAT TRANSCRIPTIONIST_ID
ASSIGN_RELEASE RELEASE_PRSNL_ID
AT_ACCT_RELTN CREATED_PRSNL_ID
AUTHORIZATION PROVIDER_PRSNL_ID
AUTHORIZATION_PROFILE PROFILE_PRSNL_ID
AUTH_DETAIL PRSNL_ID
AUTH_ERROR PERSON_ID
AUTH_ITEM_ORDER_R_HIST CREATE_PRSNL_ID
BATCH_TRANS CREATED_PRSNL_ID
BATCH_TRANS POSTED_BY_USER_ID
BATCH_TRANS_FILE CREATED_PRSNL_ID
BBHIST_PRODUCT_EVENT PRSNL_ID
BB_EDN_PRODUCT EVENT_PRSNL_ID
BB_LABEL_VERIFY PERSONNEL_ID
BB_QC_GROUP_ACTIVITY LOCK_PRSNL_ID
BB_QC_GRP_REAGENT_ACTIVITY ACTIVITY_PRSNL_ID
BB_QC_RESULT ACTION_PRSNL_ID
BB_QC_RESULT PRIMARY_REVIEW_PRSNL_ID
BB_QC_RESULT RESULT_PRSNL_ID
BB_QC_RESULT SECONDARY_REVIEW_PRSNL_ID
BB_REVIEW_QUEUE REVIEW_PRSNL_ID
BB_WORKLIST CREATE_PRSNL_ID
BH_GROUP_DOC CREATED_BY_ID
BH_GROUP_DOC PRI_FCLTR_PRSNL_ID
BH_GROUP_DOC VERIFIED_BY_ID
BH_GROUP_DOC_PRSNL ASSOC_PRSNL_ID
BLOB_REFERENCE CREATE_PRSNL_ID
BLOOD_BANK_COMMENT COMMENT_ADDED_PRSNL_ID
BMDI_ACQUIRED_DATA_TRACK ASSOC_PRSNL_ID
BMDI_ACQUIRED_DATA_TRACK DISSOC_PRSNL_ID
BMDI_ADT_PERSON_R ASSOCIATION_PRSNL_ID
BMDI_ADT_PERSON_R DIS_ASSOCIATION_PRSNL_ID
BMDI_ASSOCIATION_HINTS UPD_PRSNL_ID
BR_ELIGIBLE_PROVIDER PROVIDER_ID
BR_WIZARD_HIST PRSNL_ID
BT_COND_CRIT_GRP_RELTN PRSNL_ID
BT_PRSNL_GRP_RELTN PRSNL_ID
CAC_NOMENCLATURE PHYSICIAN_ID
CASE_ATTENDANCE CASE_ATTENDEE_ID
CASE_CART VERIFIED_BY_ID
CASE_PROVIDER PHYSICIAN_ID
CCR_USER_FILTER PRSNL_ID
CDI_CLIPBOARD COPY_USER_ID
CDI_DOCUMENT_CHECKOUT PERSON_ID
CDI_DOCUMENT_TYPE_LIST PRSNL_ID
CDI_PENDING_DOCUMENT PERFORMING_PROVIDER_ID
CDI_REJECT_LOG REJECT_USER_ID
CDI_TRANS_LOG PERF_PRSNL_ID
CDI_USER_FILTER PERSON_ID
CDI_WORK_ITEM ORDERING_PROVIDER_ID
CDI_WORK_ITEM OWNER_PRSNL_ID
CDI_WORK_ITEM_ACTION ACTION_PRSNL_ID
CDI_WORK_ITEM_VIEW PRSNL_ID
CDI_WORK_QUEUE_PRSNL_RELTN PERSON_ID
CE_AUDIT_LOG OPERATION_PRSNL_ID
CE_DYNAMIC_LABEL LABEL_PRSNL_ID
CE_EVENT_ACTION ACTION_PRSNL_ID
CE_EVENT_ACTION ASSIGN_PRSNL_ID
CE_EVENT_ACTION LAST_SAVED_PRSNL_ID
CE_EVENT_ACTION ORIGINATING_PROVIDER_ID
CE_EVENT_NOTE NOTE_PRSNL_ID
CE_EVENT_PRSNL ACTION_PRSNL_ID
CE_EVENT_PRSNL PROXY_PRSNL_ID
CE_EVENT_PRSNL REQUEST_PRSNL_ID
CE_RTE_PRSNL_RELTN ACTION_PRSNL_ID
CE_SPECIMEN_COLL COLLECT_PRSNL_ID
CE_SUSCEPTIBILITY RESULT_PRSNL_ID
CHARGE POSTED_ID
CHARGE_BATCH ASSIGNED_PRSNL_ID
CHARGE_BATCH CREATED_PRSNL_ID
CHARGE_BATCH_DETAIL ORDERING_PHYS_ID
CHARGE_BATCH_DETAIL RENDERING_PHYS_ID
CHARGE_BATCH_DETAIL_FIELD FIELD_VALUE_PRSNL_ID
CHARGE_EVENT_ACT CEA_PRSNL_ID
CHARTING_OPERATIONS_PRSNL PRSNL_ID
CHART_REQUEST PRSNL_PERSON_ID
CHART_REQUEST REQUEST_PRSNL_ID
CHART_SEQ_GROUP_RELTN PRSNL_ID
CLINICAL_EVENT PERFORMED_PRSNL_ID
CLINICAL_EVENT VERIFIED_PRSNL_ID
CLINICAL_EVENT_SEC_LBL CREATED_BY_PRSNL_ID
CLRFCTN_ACTION ACTION_PRSNL_ID
CMN_IMPORT_ACTIVITY PERFORMING_PRSNL_ID
CMN_NAME_SWAP_ACTIVITY PERFORMING_PRSNL_ID
CNT_CODE_VALUE_KEY IGNORE_USER_ID
CN_DCP_SHIFT_ASSIGNMENT_ST PRSNL_ID
CODING CODING_PRSNL_ID
CODING CREATE_PRSNL_ID
CODING_AUDIT AUDIT_PRSNL_ID
CODING_AUDIT CODING_PRSNL_ID
CODING_HIST CODING_PRSNL_ID
CODING_HIST CREATE_PRSNL_ID
CODING_LOCK LOCK_PRSNL_ID
CODING_SPECIALTY CODING_PRSNL_ID
CODING_SPECIALTY CREATE_PRSNL_ID
COMMITTEE_MEMBER PERSON_ID
COMPLETION_HOLD PROVIDER_ID
COMP_FILTER_GROUP PERSON_ID
CONCEPT_PRSNL_CROSSMAP PRSNL_ID
CONDITION_SUMMARY RECORDED_BY_PRSNL_ID
CONSENT PRSNL_ID
CONSENT_PROVISION PRSNL_ID
CONTAINER DRAWN_ID
CONTAINER RECEIVED_ID
CONTRIBUTOR_SYSTEM PRSNL_PERSON_ID
CONVERT_AUDIT_TRANSACTION PRSNL_ID
CORRECTED_PRODUCT ORIG_DISP_PROV_ID
CORRECTED_PRODUCT ORIG_UPDT_ID
CORSP_LOG CREATED_PRSNL_ID
CP_PATHWAY OWNER_PRSNL_ID
CP_PATHWAY_ACTION PRSNL_ID
CP_PATHWAY_ACTIVITY PRSNL_ID
CREDENTIAL NOTIFY_PRSNL_ID
CREDENTIAL PRSNL_ID
CRITIQUE_PRSNL CRITIQUED_ID
CROSSMATCH RELEASE_PRSNL_ID
CR_REPORT_REQUEST PROVIDER_PRSNL_ID
CR_REPORT_REQUEST REQUEST_PRSNL_ID
CSM_LST_CONTACT PERSON_ID
CSM_QUEUE_PERS_XREF PERSON_ID
CT_PRESCREEN_JOB PRSNL_ID
CT_PROT_REASON_DELETED DELETION_PRSNL_ID
CT_REASON_DELETED DELETION_PRSNL_ID
CT_USER_PREFERENCE PRSNL_ID
CUSTOM_PT_LIST PERSON_ID
CV_ACRONYM PROVIDER_ID
CV_DEVICE_LOCATION_R USER_ID
CV_ED_REVIEW REQUESTOR_PRSNL_ID
CV_ED_REVIEW REVIEWER_PRSNL_ID
CV_PROC ORDER_PHYSICIAN_ID
CV_PROC PRIM_PHYSICIAN_ID
CV_PROC REFER_PHYSICIAN_ID
CV_STEP LOCK_PRSNL_ID
CV_STEP PERF_PROVIDER_ID
CV_STEP PRELIMINARY_AUTHOR_ID
CV_STEP_PRSNL STEP_PRSNL_ID
CV_STEP_SCHED SCHED_PHYS_ID
CYTO_SCREENING_LIMITS PRSNL_ID
CYTO_SCREENING_SECURITY PRSNL_ID
DAILY_CYTOLOGY_COUNTS PRSNL_ID
DASH_BREAK PROVIDER_ID
DASH_BREAK_HIST PROVIDER_ID
DASH_COMPONENT LAST_UPDT_PRSNL_ID
DASH_DASHBOARD LAST_UPDT_PRSNL_ID
DASH_FILTER LAST_UPDT_PRSNL_ID
DASH_ITEM_GROUP LAST_UPDT_PRSNL_ID
DA_BATCH_COLLECTION CREATE_PRSNL_ID
DA_BATCH_QUERY CREATED_BY_PRSNL_ID
DA_BATCH_REPORT CREATED_BY_PRSNL_ID
DA_BATCH_SCHED CREATED_BY_PRSNL_ID
DA_DOCUMENT CREATED_BY_PRSNL_ID
DA_DOCUMENT_PRSNL_RELTN PRSNL_ID
DA_DOCUMENT_PRSNL_RELTN REQUESTED_BY_PRSNL_ID
DA_FOLDER CREATE_PRSNL_ID
DA_GROUP_USER_RELTN PRSNL_ID
DA_QUERY OWNER_PRSNL_ID
DA_QUERY_DEFAULT_PROMPTS USER_PRSNL_ID
DA_REPORT OWNER_PRSNL_ID
DA_REPORT_DEFAULT_PROMPTS USER_PRSNL_ID
DA_USER_SECURITY PRSNL_ID
DCP_CUSTOM_COLS_SORT PRSNL_ID
DCP_CUSTOM_COLUMNS PRSNL_ID
DCP_FORMS_ACTIVITY_PRSNL PROXY_ID
DCP_FORMS_ACTIVITY_PRSNL PRSNL_ID
DCP_MP_PATIENT_LIST OWNER_PRSNL_ID
DCP_PATIENT_LIST OWNER_PRSNL_ID
DCP_PL_QUERY_TEMP_ACCESS PROVIDER_ID
DCP_PL_RELTN PRSNL_ID
DCP_PRSNL_LOC_R PERSON_ID
DD_CONTRIBUTION AUTHOR_ID
DD_REF_LABEL USER_ID
DD_REF_TEMPLATE AUTHOR_ID
DD_SDOC_SECTION AUTHOR_ID
DD_SESSION SESSION_USER_ID
DIAGNOSIS_ACTION PRSNL_ID
DIAGNOSIS_SEC_LBL CREATED_BY_PRSNL_ID
DISPENSE_HX DISPENSE_PRSNL_ID
DISPENSE_HX RUN_USER_ID
DISPENSE_HX WITNS_PRSNL_ID
DISPENSE_REPLACE PRSNL_ID
DISPENSE_RETURN RETURN_COURIER_ID
DISPENSE_RETURN RETURN_PRSNL_ID
DMS_EVENT CREATED_BY_ID
DMS_MEDIA_INSTANCE CONTRIBUTOR_ID
DMS_MEDIA_INSTANCE CREATED_BY_ID
DM_DCM_UOW PRSNL_ID
DM_DCM_WP_PRSNL_R PRSNL_ID
DM_PREFS PERSON_ID
DM_REFCHG_PRSNL_CTX_R PRSNL_ID
DM_TEXT_FIND_COMMENT COMMENT_PRSNL_ID
DM_TEXT_FIND_STRUCT_CMNT COMMENT_PRSNL_ID
DOCUMENT_QUALITY_REVIEW PRSNL_ID
DOC_TRANSCRIPTION_QUEUE AUTHOR_ID
DSI_FEEDBACK PRSNL_ID
DTS_TRANS_STATS AUTHOR_PRSNL_ID
DTS_TRANS_STATS TRANS_PRSNL_ID
EEM_ABN_ACTION ACTION_PRSNL_ID
EEM_ABN_FORM TO_PRSNL_ID
EEM_ACTION ACTION_PRSNL_ID
EEM_ADDRESS_DETAIL SENDER_PRSNL_ID
EEM_AUTH_DETAIL SENDER_PRSNL_ID
EEM_BENEFIT_ALLOC MADE_BY_ID
EEM_COVERAGE_DETAIL SENDER_PRSNL_ID
EEM_DEMOG_DETAIL SENDER_PRSNL_ID
EEM_ELIG_DETAIL SENDER_PRSNL_ID
EEM_FILE_ACTION ACTION_PRSNL_ID
EEM_MOH_DETAIL SENDER_PRSNL_ID
EEM_NEWBORN_DETAIL SENDER_PRSNL_ID
EEM_NTWK_PRSNL_RELTN PRSNL_ID
EEM_PROFILE_PRSNL PRSNL_ID
EEM_PRSNL_LOC_RELTN PRSNL_ID
EEM_RX_ELIG_DETAIL PRESCRIBER_PRSNL_ID
EEM_RX_ELIG_DETAIL SENDER_PRSNL_ID
EHI_QUEUE PRSNL_ID
EKS_ALERT_ESC_HIST ACK_BY_ID
EKS_DLG_EVENT DLG_PRSNL_ID
EKS_NOTIFY_PERSN_R PERSON_ID
ENCNTR_APPEAL ADVISOR_PRSNL_ID
ENCNTR_APPEAL APPEAL_PRSNL_ID
ENCNTR_AVOIDABLE_DAYS RESP_PARTY_PRSNL_ID
ENCNTR_CARE_MGMT_COMM SENDER_PRSNL_ID
ENCNTR_CATCHMENT_RELTN LIAISON_PRSNL_ID
ENCNTR_CATCHMENT_R_HIST LIAISON_PRSNL_ID
ENCNTR_CLIN_SEC_REVIEW SEC_REVIEW_RESP_PARTY_ID
ENCNTR_DENIED_DAYS DENIAL_PRSNL_ID
ENCNTR_DENIED_DAYS RESP_PARTY_PRSNL_ID
ENCNTR_FLEX_HIST COMPLETE_REG_PRSNL_ID
ENCNTR_FLEX_HIST DISCH_PRSNL_ID
ENCNTR_LEAVE END_LEAVE_USER_ID
ENCNTR_LEAVE_HISTORY END_LEAVE_USER_ID
ENCNTR_LOC_HIST ARRIVE_PRSNL_ID
ENCNTR_LOC_HIST DEPART_PRSNL_ID
ENCNTR_LOC_HIST PLACEMENT_AUTH_PRSNL_ID
ENCNTR_ORG_SERVICE_RELTN REFERRING_PRSNL_ID
ENCNTR_PENDING ATTENDDOC_ID
ENCNTR_PENDING_HIST ATTENDDOC_ID
ENCNTR_PLAN_RELTN NOTIFY_PRSNL_ID
ENCNTR_PLAN_RELTN_HIST NOTIFY_PRSNL_ID
ENCNTR_PROCEDURE SCHED_PRIMARY_SURGEON_ID
ENCNTR_PRSNL_RELTN PRSNL_PERSON_ID
ENCNTR_PRSNL_RELTN_HISTORY PRSNL_PERSON_ID
ENCNTR_SOCIAL_HEALTHCARE VERIFY_PRSNL_ID
ENCNTR_SOCIAL_HEALTH_HIST VERIFY_PRSNL_ID
ENCOUNTER COMPLETE_REG_PRSNL_ID
ENCOUNTER DISCH_PRSNL_ID
ENTITY_ACCESS PERSON_ID
EPA_RECORD DATA_ENTERER_PRSNL_ID
EPA_RECORD PRSNL_ID
EPISODE_PRSNL_RELTN PRSNL_PERSON_ID
EPISODE_PRSNL_RELTN_HIST PRSNL_PERSON_ID
EPRESCRIBE_DETAIL CS_NOMINATOR_ID
ERX_EXT_MED_LIST_ACCESS USER_ID
EXAM_CRITIQUE_INFO CREATED_BY_ID
EXPEDITE_MANUAL PROVIDER_ID
EXPEDITE_TRIGGER PROVIDER_ID
EXPIRE_RULE PRSNL_ID
EXT_DATA_INFO ACTION_PRSNL_ID
FHX_ACTION PRSNL_ID
FHX_LONG_TEXT_R COMMENT_PRSNL_ID
FHX_SECTION_DEF PRSNL_ID
FILL_PRINT_ORD_HX VERIFY_PRSNL_ID
FN_EV_SURVEY_ACT PERFORMED_PRSNL_ID
FN_OMF_ENCNTR PRIMARY_CARE_PHYSICIAN_ID
FN_OMF_ENCNTR PRIMARY_DOC_ID
FN_OMF_ENCNTR PRIMARY_NURSE_ID
FN_OMF_ENCNTR SECONDARY_DOC_ID
FN_OMF_ENCNTR SECONDARY_NURSE_ID
FREQUENCY_SCHEDULE CRITICAL_UPD_ID
GEL_BATCH PREPARED_PRSNL_ID
GEN_LAB_EXT_DATA ACTION_PRSNL_ID
GL_ALIAS CREATED_PRSNL_ID
GL_ALIAS_FIELD_RELTN CREATED_PRSNL_ID
GL_ALIAS_FIELD_RESULT CREATED_PRSNL_ID
GL_FIELD_MASTER CREATED_PRSNL_ID
GL_TRANS_LOG CREATED_PRSNL_ID
GL_TRANS_QUALIFIER ATTENDING_PHYS_ID
GL_TRANS_QUALIFIER ORDERING_PHYS_ID
GL_TRANS_QUALIFIER PERFORMING_PHYS_ID
GL_TRANS_QUALIFIER SUPERVISING_PHYS_ID
GL_TRANS_QUALIFIER VERIFY_PHYS_ID
GS_MED_CLAIM PRESCRIBER_ID
HANDHELD_DETAIL COLLECTION_PRSNL_ID
HANDHELD_DETAIL RECEIVED_PRSNL_ID
HCM_COMM_EVENT CONTACTED_PRSNL_ID
HCM_COMM_EVENT CREATED_BY_ID
HCM_COMM_EVENT MODIFIED_BY_ID
HCM_COMM_EVENT_H CONTACTED_PRSNL_ID
HCM_COMM_EVENT_H CREATED_BY_ID
HCM_COMM_EVENT_H MODIFIED_BY_ID
HEALTH_CONCERN LAST_UPDT_ID
HEALTH_CONCERN RECORDED_PRSNL_ID
HEALTH_CONCERN RESOLVED_PRSNL_ID
HIM_CONFIG LAST_MODIFIED_PRSNL_ID
HIM_EVENT_ALLOCATION PRSNL_ID
HIM_LETTERS_TEMP PRSNL_ID
HIM_PV_DOCUMENT REQUEST_PRSNL_ID
HIM_PV_PHYSICIAN PERSON_ID
HIM_REQUEST_PATIENT CANCEL_PRSNL_ID
HIM_REQUEST_PATIENT CREATE_PRSNL_ID
HIM_REQUEST_PATIENT LAST_UPDATE_PRSNL_ID
HIM_REQUEST_PATIENT REQUEST_STATUS_PRSNL_ID
HIM_RESTRICT_VIEW_HIST OVERRIDE_PRSNL_ID
HIM_RESTRICT_VIEW_HIST VIEW_PRSNL_ID
HIM_UNSIGNED_ORDERS ACTION_PERSONNEL_ID
HIM_UNSIGNED_ORDERS TO_PRSNL_ID
HISTORY_ACTION PRSNL_ID
HIS_OBS_ACTIVITY LAST_UPDT_PRSNL_ID
HIS_OBS_ACTIVITY_H LAST_UPDT_PRSNL_ID
HLA_AB_SCREEN_RESULT PLATED_PRSNL_ID
HLA_AB_SCREEN_RESULT READ_PRSNL_ID
HLA_ORDER_LOCK TECH_LOCK_ID
HLA_TYP_RES_TRAY PLATED_PRSNL_ID
HLA_TYP_RES_TRAY READ_PRSNL_ID
HLA_TYP_RES_TRAY SEPARATED_PRSNL_ID
HLA_XM_RES_TRAY PLATED_PRSNL_ID
HLA_XM_RES_TRAY READ_PRSNL_ID
HLA_XM_RES_TRAY SEPARATED_PRSNL_ID
HM_RECOMMENDATION ASSIGNED_BY_PRSNL_ID
HM_RECOMMENDATION LAST_SATISFIED_BY_ID
HM_RECOMMENDATION_ACTION ON_BEHALF_OF_PRSNL_ID
HPD_PROVIDER INTERNAL_PRSNL_ID
IB_RX_REQ TO_PRSNL_ID
IB_RX_REQ_ACTION ACTION_PRSNL_ID
IDENTITY_ASSERTION PRSNL_ID
IMAGE_HISTORY TRANSACTION_ID
IMMUNIZATION_EXT_DATA ACTION_PRSNL_ID
IMPLANT_HISTORY IMPLANTED_PRSNL_ID
IMPLANT_HISTORY_REVIEW PRSNL_ID
IND_IDE_OWNERSHIP PERSON_ID
INFUSION_BILLING_EVENT CREATE_PRSNL_ID
INFUSION_BILL_RPT PERFORMED_PRSNL_ID
INSTRUMENT_ASSIGNMENT PRSNL_ID
INSTR_ACCN_QUEUE IN_PROCESS_PRSNL_ID
INTERFACE_TRANSACTION CREATED_PRSNL_ID
INVOICE APPROVED_PRSNL_ID
INVTN_PROGRAM_GROUP SENDER_PRSNL_ID
JOB_EXECUTION CREATE_ID
LH_ABS_LOG PRSNL_ID
LH_CNT_IC_ADV_SURG_DATA SURGEON_PRSNL_ID
LH_CNT_IC_PATIENT_POP PERFORMED_BY_PRSNL_ID
LH_CNT_IC_PATIENT_POP_TAGS BEG_EFFECTIVE_PRSNL_ID
LH_CNT_IC_PATIENT_POP_TAGS END_EFFECTIVE_PRSNL_ID
LH_CNT_IC_VAE_HIST PERFORMED_BY_PRSNL_ID
LH_CNT_READMIT_USER_LIST PRSNL_ID
LH_CNT_REHAB_EVENT PERFORM_PRSNL_ID
LH_CNT_WL_FLTR_LIST PRSNL_ID
LINE_ITEM LOCKED_BY_PRSNL_ID
LOGICAL_DOMAIN SYSTEM_USER_ID
MAMMO_ASSESSMENT_SERIES RAD_ID
MAMMO_STUDY_PRSNL PRSNL_ID
MEDIA_MASTER CREATE_PRSNL_ID
MED_ADMIN_ALERT PRSNL_ID
MED_ADMIN_EVENT PRSNL_ID
MED_ADMIN_EXT_MAP EXT_MAP_PRSNL_ID
MED_ADMIN_IDENT_ERROR PRSNL_ID
MED_HISTORY_AUDIT PRESCRIBER_PRSNL_ID
MED_HISTORY_AUDIT PRSNL_ID
MESSAGING_FAVORITES PRSNL_ID
MESSAGING_NOTIFY ASSIGN_PRSNL_ID
MESSAGING_NOTIFY NOTIFY_PRSNL_ID
MESSAGING_OUT_OF_OFFICE PRSNL_ID
MIC_BPA_SUS_RESULT RESULT_PRSNL_ID
MIC_EXT_DATA ACTION_PRSNL_ID
MIC_EXT_DATA ACTIVE_STATUS_PRSNL_ID
MIC_IC_ORDERS ORDER_PROVIDER_ID
MIC_QC_RESULT PRIMARY_REVIEW_PRSNL_ID
MIC_QC_RESULT RESULT_PERSONNEL_ID
MIC_QC_RESULT SECONDARY_REVIEW_PRSNL_ID
MIC_QC_RESULT SETUP_PERSONNEL_ID
MIC_QC_RESULT_SCHEDULE LOCK_PERSONNEL_ID
MIC_SCRIPT_TECH TECH_PRSNL_ID
MIC_STAT_BIOCHEMICAL RESULT_PRSNL_ID
MIC_STAT_ORDER COLLECT_PRSNL_ID
MIC_STAT_ORDER COMPLETE_PRSNL_ID
MIC_STAT_ORDER ORDER_PROVIDER_ID
MIC_STAT_ORDER ORDER_PRSNL_ID
MIC_STAT_ORDER RECEIVE_PRSNL_ID
MIC_STAT_PROCESS PROCESS_TECH_ID
MIC_STAT_SUSCEPTIBILITY RESULT_PRSNL_ID
MIC_STAT_TASK ORDER_PRSNL_ID
MIC_STAT_TASK RESULT_PRSNL_ID
MIC_TASK_LOG ACTION_TECH_ID
MM_APPROVAL PRSNL_ID
MM_APPROVAL_LOG PRSNL_ID
MM_APPROVAL_QUEUE PRSNL_ID
MM_BUYER_ROUTING BUYER_ID
MM_CNTRCT_ACTION PRSNL_ID
MM_DISCREPANCY RESOLVED_PRSNL_ID
MM_DISCREPANCY WITNESS_PRSNL_ID
MM_ITEM_ORG_COST_HIST LAST_UPDT_PRSNL_ID
MM_MP_WORKLIST_FILTER CREATE_PRSNL_ID
MM_PRICE_FORMULA_RANGE LAST_UPDT_PRSNL_ID
MM_RANGE_DETAIL LAST_UPDT_PRSNL_ID
MM_SUPPLY_CABINET PRSNL_ID
MM_XFI_ASN_HEADER CREATE_ID
MM_XFI_CNTRCT_ACTION ACTION_USER_ID
MM_XFI_CNTRCT_HDR CNTRCT_MGR_ID
MM_XFI_CNTRCT_HDR HOSPITAL_CONTACT_ID
MM_XFI_CNTRCT_LINE CNTRCT_MGR_ID
MONTHLY_CYTOLOGY_COUNTS PRSNL_ID
MP_AMB_ORG_SAT SATISFIED_PRSNL_ID
MP_MPAGE_DEF PRSNL_ID
MP_NOTIFICATION PRSNL_ID
MP_NOTIFICATION_ACTION ACTION_PRSNL_ID
MP_PRIMED_VIEW_REF PROXY_PRSNL_ID
MSG_CONFIG_PUB_ASNMNT PRSNL_ID
MSG_DOC_FAVORITES PRSNL_ID
MSG_LETTER_TEMPLATE PRSNL_ID
NC_CHARTED_SECTION CREATE_PRSNL_ID
NC_CHARTED_SECTION LAST_UPDT_PRSNL_ID
NC_CHARTED_VIEW CREATE_PRSNL_ID
NC_CHARTED_VIEW LAST_UPDT_PRSNL_ID
NC_CHARTING_SECTION CREATE_PRSNL_ID
NC_CHARTING_VIEW CREATE_PRSNL_ID
NOTE_PHRASE PRSNL_ID
NOTE_PHRASE_FAVORITE PRSNL_ID
NOTE_PHRASE_LABEL USER_ID
NOTE_TYPE_LIST PRSNL_ID
NURSING_ENCNTR_SCRATCHPAD PRSNL_ID
NURSING_USER_ACCESS USER_ID
OMF_RADMGMT_ORDER_ST CANCEL_BY_ID
OMF_RADMGMT_ORDER_ST ORDER_PHYS_ID
OMF_RADMGMT_ORDER_ST ORDER_PRSNL_ID
OMF_RADMGMT_ORDER_ST RADIOLOGIST_ID
OMF_RADMGMT_ORDER_ST TRANSCRIPTIONIST_ID
OMF_RADPROC_CLASS_ST CLASSIFICATION_PRSNL_ID
OMF_RADREPEAT_ORDER_ST TECHNOLOGIST_ID
OMF_RADREPORT_ST PROXY_ID
OMF_RADREPORT_ST RADIOLOGIST_ID
OMF_RADREPORT_ST RESIDENT_ID
OMF_RADREPORT_ST TRANSCRIPTIONIST_ID
OMF_RADTECH_ORDER_ST TECHNOLOGIST_ID
OMF_RADTRANS_ORDER_ST RADIOLOGIST_ID
OMF_RADTRANS_ORDER_ST TRANSCRIPTIONIST_ID
OMF_SVC_CAT_HIST_ST ANESTHESIOLOGIST_ID
OMF_SVC_CAT_HIST_ST ATT_PRSNL_ID
OMF_SVC_CAT_HIST_ST SURGEON_ID
OMF_WL_PRODUCTIVITY_ST ORD_PHYS_ID
OMF_WL_PRODUCTIVITY_ST PRSNL_ID
ONC_CHEMO_VERIFY ACTION_PRSNL_ID
ONC_TC_CAL_ITEMS UPDT_ID
ORDERS LAST_UPDATE_PROVIDER_ID
ORDERS STATUS_PRSNL_ID
ORDER_ACTION ACTION_PERSONNEL_ID
ORDER_ACTION ORDER_PROVIDER_ID
ORDER_ACTION SUPERVISING_PROVIDER_ID
ORDER_COMPLIANCE PERFORMED_PRSNL_ID
ORDER_CONFID_LBL ACTION_PRSNL_ID
ORDER_CONFID_LBL CREATED_BY_PRSNL_ID
ORDER_CONTAINER_R REASON_MISSED_ID
ORDER_DAILY_REVIEW_DEFER DEFER_BY_PRSNL_ID
ORDER_DAILY_REVIEW_HISTORY REVIEWED_PRSNL_ID
ORDER_DAILY_REVIEW_RSPNL ASSIGNED_PRSNL_ID
ORDER_DAILY_REVIEW_RSPNL RSPNL_PRSNL_ID
ORDER_NOTIFICATION ASSIGNED_PRSNL_ID
ORDER_NOTIFICATION FROM_PRSNL_ID
ORDER_NOTIFICATION TO_PRSNL_ID
ORDER_ORDER_RELTN ENTERED_BY_PRSNL_ID
ORDER_PROPOSAL ENTERED_BY_PRSNL_ID
ORDER_PROPOSAL RESOLVED_BY_PRSNL_ID
ORDER_PROPOSAL RESPONSIBLE_PRSNL_ID
ORDER_PROPOSAL SUPERVISING_PROVIDER_ID
ORDER_PROPOSAL_NOTIF ASSIGNED_PRSNL_ID
ORDER_PROPOSAL_NOTIF FROM_PRSNL_ID
ORDER_PROPOSAL_NOTIF TO_PRSNL_ID
ORDER_RADIOLOGY CANCEL_BY_ID
ORDER_RADIOLOGY ORDER_PHYSICIAN_ID
ORDER_RADIOLOGY REMOVED_BY_ID
ORDER_RADIOLOGY VETTING_PRSNL_ID
ORDER_RECON PERFORMED_PRSNL_ID
ORDER_REVIEW PROVIDER_ID
ORDER_REVIEW REVIEW_PERSONNEL_ID
ORDER_REVIEW_DECISION DECIDING_PRSNL_ID
ORDER_RX_SCRATCHPAD ORDER_ENTRY_PRSNL_ID
ORDER_RX_SCRATCHPAD RESPONSIBLE_PROVIDER_ID
ORDER_RX_SCRATCHPAD SUPERVISING_PROVIDER_ID
ORDER_TRACKING_WORKLIST ORDER_PROVIDER_ID
ORD_FAVORITE_DEST PRSNL_ID
ORG_SET_PRSNL_R PRSNL_ID
ORG_TRANS_URL_RELTN CREATE_PRSNL_ID
ORM_ERROR_LOG ORDER_PROVIDER_ID
ORM_ERROR_LOG PRSNL_ID
ORM_ORD_HIST_SNAPSHOT PERFORMED_PERSON_ID
OSM_CLIENT_DEFAULTS ADMITTING_PHYS_ID
OSM_CLIENT_DEFAULTS COLLECT_BY_PERSON_ID
PASSIVE_ALERT_ACTION PRSNL_ID
PATHOLOGY_CASE ACCESSION_PRSNL_ID
PATHOLOGY_CASE CANCEL_ID
PATHOLOGY_CASE REQUESTING_PHYSICIAN_ID
PATHOLOGY_CASE RESPONSIBLE_PATHOLOGIST_ID
PATHOLOGY_CASE RESPONSIBLE_RESIDENT_ID
PATHWAY_ACTION ACTION_PRSNL_ID
PATHWAY_ACTION PROVIDER_ID
PATHWAY_CUSTOMIZED_PLAN PRSNL_ID
PATHWAY_NOTIFICATION FORWARDING_PRSNL_ID
PATIENT_CASE_OUT_PMT_AGMT APPROVING_PRSNL_ID
PATIENT_CASE_OUT_PMT_AGMT REFERRING_PROVIDER_PRSNL_ID
PAT_ED_DOC_ACTIVITY INSTRUCTION_USER_ID
PAT_ED_DOC_LEAFLET_ACTIVITY INSTRUCTION_PRSNL_ID
PAT_ED_FAVORITES PERSON_ID
PAT_ED_FOLLOWUP_FAVORITES PRSNL_ID
PAT_ED_RELTN PRSNL_ID
PAYMENT_DETAIL CREATED_PRSNL_ID
PCS_LOT_INFORMATION RECEIVED_PERSONNEL_ID
PCS_PRSNL_FILTER PRSNL_ID
PCS_QUEUE_ASSIGNMENT FROM_PRSNL_ID
PCS_QUEUE_PRSNL_RELTN PRSNL_ID
PCS_REVIEW_HISTORY PRSNL_ID
PCS_REVIEW_HISTORY STATUS_PRSNL_ID
PCT_CARE_TEAM PRSNL_ID
PCT_IPASS LAST_UPDT_PRSNL_ID
PDOC_AUTOSAVE AUTHOR_ID
PDOC_TAG TAG_USER_ID
PDOC_TAG_TEXT TAG_USER_ID
PERIOPERATIVE_DOCUMENT DOC_TERM_BY_ID
PERIOPERATIVE_DOCUMENT LAST_VER_ID
PERIOPERATIVE_DOCUMENT REC_VER_ID
PERSON_ANTIBODY REMOVED_PRSNL_ID
PERSON_ANTIGEN REMOVED_PRSNL_ID
PERSON_COMBINE_BATCH CREATE_PRSNL_ID
PERSON_DISMISSAL PRSNL_PERSON_ID
PERSON_HLA_AB_SCN_AUDIT PRSNL_ID
PERSON_HLA_EVENT PRSNL_ID
PERSON_HLA_EVENT_AUDIT PRSNL_ID
PERSON_HLA_XM PRSNL_ID
PERSON_HLA_XM_AUDIT PRSNL_ID
PERSON_PLAN_RELTN ARCHIVE_PRSNL_ID
PERSON_PLAN_RELTN VERIFY_PRSNL_ID
PERSON_PRSNL_ORG_OVERRIDE PRSNL_ID
PERSON_PRSNL_RELTN PRSNL_PERSON_ID
PERSON_PRSNL_RELTN_HISTORY PRSNL_PERSON_ID
PERSON_RX_PLAN_RELTN VERIFIED_BY_ID
PERSON_SOCIAL_HEALTHCARE VERIFY_PRSNL_ID
PERSON_SOCIAL_HEALTH_HIST VERIFY_PRSNL_ID
PERSON_TRANS_REQ ADDED_PRSNL_ID
PERSON_TRANS_REQ REMOVED_PRSNL_ID
PFT_ACCT_RELTN CREATED_PRSNL_ID
PFT_AP_REFUND RESPONSIBLE_PRSNL_ID
PFT_AP_REFUND_HIST PRSNL_ID
PFT_BALANCE ADMIT_PRSNL_ID
PFT_BALANCE PERFORM_PRSNL_ID
PFT_BR_EDIT_FAILURE PRSNL_ID
PFT_BR_EDIT_FAILURE_DETAIL RESOLUTION_ACTION_PRSNL_ID
PFT_CHARGE_GLOBAL_DAYS VERIFY_PHYS_ID
PFT_CHRG_GRP_RPRCS CREATED_ID
PFT_CHRG_GRP_RPRCS_HIST CREATED_ID
PFT_MLP ACTIVE_STATUS_PRSNL_ID
PFT_MLP PRSNL_ID
PFT_PAYMENT_PLAN OVERRIDE_PRSNL_ID
PFT_PRSNL_GROUP_R PRSNL_ID
PFT_PRSNL_RELTN RELATED_PRSNL_ID
PFT_PRSNL_RELTN SUPERVISING_PRSNL_ID
PFT_QUEUE_ASSIGNMENT ASSIGNED_PRSNL_ID
PFT_QUEUE_ITEM RESPONSIBLE_PRSNL_ID
PFT_QUEUE_ITEM REVIEWING_PRSNL_ID
PFT_QUEUE_ITEM SECONDARY_PRSNL_ID
PFT_REPORT_INSTANCE PRSNL_ID
PFT_REVENUE_SUMMARY ATTEND_PHYS_ID
PFT_RULE CREATE_PRSNL_ID
PFT_RULE_ACTION CREATE_PRSNL_ID
PFT_RULE_QUALIFICATION CREATE_PRSNL_ID
PFT_SURCHARGE_CONFIG CREATE_PRSNL_ID
PFT_SURCHARGE_RATE_CONFIG CREATE_PRSNL_ID
PFT_TRANS_DIST_CONFIG CREATE_PRSNL_ID
PFT_TRANS_RELTN CREATED_PRSNL_ID
PFT_UMDAP_HIST PRSNL_ID
PFT_WF_DEPARTMENT_RELTN DEPARTMENT_OWNER_ID
PFT_WF_HIST_REMINDER_RELTN PRSNL_ID
PHA_BATCH_REPORT CREATE_PRSNL_ID
PHA_BATCH_REPORT_ACT RUN_USER_ID
PHA_DISP_OBS_ST PROD_VLDTN_PRSNL_ID
PHA_PROD_DISP_OBS_ST PROD_VLDTN_PRSNL_ID
PHYS_COUNT COUNT_COMMIT_PRSNL_ID
PIE_DWL_LIST USER_PRSNL_ID
PIE_RECORD_COMPLIANCE PERFORMED_PRSNL_ID
PIP PRSNL_ID
PIP_COLUMN PRSNL_ID
PL_CLIENT_DEFAULTS COLLECT_BY_PERSON_ID
PM_DOC_PRINT_HIST PRINTED_BY_PRSNL_ID
PM_PREF_SETUP PERSON_PRSNL_ID
PM_QST_QUESTIONNAIRE_ACT COMPLETED_PRSNL_ID
PM_QST_QUESTIONNAIRE_ACT REVIEWED_PRSNL_ID
PM_RBC_PARM_SET_R CREATE_PRSNL_ID
PM_TRANSFER_ENCNTR_RELTN PRSNL_PERSON_ID
PM_TRANSFER_ENCNTR_RELTN TRANSFER_PRSNL_PERSON_ID
PP_AUDIT_EVENT USER_ID
PRACTICE_SITE_MSG_ROUTING INTENDED_RECIPIENT_PRSNL_ID
PRACTICE_SITE_MSG_ROUTING ROUTED_RECIPIENT_PRSNL_ID
PREFERENCE_CARD PRSNL_ID
PREGNANCY_ESTIMATE AUTHOR_ID
PREGNANCY_INFORMATION PRSNL_ID
PREGNANCY_SEC_LBL ACTION_PRSNL_ID
PREGNANCY_SEC_LBL CREATED_BY_PRSNL_ID
PRICE_SCHED WARNING_PRSNL_ID
PRIV_LOC_RELTN PERSON_ID
PROBLEM_ACTION PRSNL_ID
PROBLEM_COMMENT COMMENT_PRSNL_ID
PROBLEM_EXT_DATA ACTION_PRSNL_ID
PROBLEM_SEC_LBL CREATED_BY_PRSNL_ID
PROCEDURE_ACTION PRSNL_ID
PROCEDURE_EXT_DATA ACTION_PRSNL_ID
PROCESSING_TASK CANCEL_PRSNL_ID
PROCESSING_TASK HOLD_PRSNL_ID
PROCESSING_TASK REQUEST_PRSNL_ID
PROCESSING_TASK STATUS_PRSNL_ID
PROC_CLASSIFICATION CLASSIFICATION_PRSNL_ID
PROC_PRSNL_RELTN PRSNL_PERSON_ID
PRODUCT_EVENT EVENT_PRSNL_ID
PROFICIENCY_EVENT PRSNL_ID
PROFICIENCY_EVENT REVIEWER_ID
PROT_ROLE PERSON_ID
PROVIDER_ENROLLMENT PRSNL_ID
PROXY_EXEMPTIONS PERSON_ID
PROXY_GROUP PERSON_ID
PROXY_GROUP PROXY_ID
PRSNL_ALIAS PERSON_ID
PRSNL_CLASS_NODE_R PERSON_ID
PRSNL_CODE_VALUE_R PRSNL_ID
PRSNL_COMMENT PRSNL_ID
PRSNL_CURRENT_LOC PERSON_ID
PRSNL_GROUP_POOL_ROUTING_R PRSNL_ID
PRSNL_GROUP_RELTN PERSON_ID
PRSNL_INFO PERSON_ID
PRSNL_LOCATION_R PERSON_ID
PRSNL_LOC_TEMPLATE_RELTN PRSNL_ID
PRSNL_NOTIFY PERSON_ID
PRSNL_ORG_RELTN PERSON_ID
PRSNL_ORG_RELTN_TYPE PRSNL_ID
PRSNL_OUT_OF_OFFICE PRSNL_ID
PRSNL_OUT_OF_OFFICE_DIST DISTRIBUTE_TO_PRSNL_ID
PRSNL_PRIV PRSNL_ID
PRSNL_PRSNL_RELTN PERSON_ID
PRSNL_PRSNL_RELTN RELATED_PERSON_ID
PRSNL_RELTN PERSON_ID
PRSNL_RELTN_ACTIVITY PRSNL_ID
PRSNL_ROLE_PROFILE PRSNL_ID
PRSNL_SERVICE_RESOURCE_RELTN PRSNL_ID
PRSNL_SPECIALTY_RELTN PRSNL_ID
PRSNL_SUSPENSION PRSNL_ID
PT_ELIG_RESULT ELIG_VALUE_PROVIDER_PERSON_ID
PT_ELIG_TRACKING ELIG_REQUEST_PERSON_ID
PT_ELIG_TRACKING ELIG_REVIEW_PERSON_ID
PT_INTEREST_COMMENT COMMENT_ADDED_PRSNL_ID
PT_PROT_PRESCREEN REFERRED_PERSON_ID
PT_PROT_PRESCREEN SCREENER_PERSON_ID
PT_PROT_PRESCREEN_TEST SCREENER_PRSNL_ID
PT_PROT_REG OFF_TX_REMOVAL_PERSON_ID
PT_PROT_REG ON_TX_ASSIGN_PRSNL_ID
PT_PROT_REG REMOVAL_PERSON_ID
PULSE_GEN ASSOC_PRSNL_ID
PULSE_GEN_ASSOC_HIST ASSOC_PRSNL_ID
PULSE_GEN_ASSOC_HIST DISASSOC_PRSNL_ID
QC_COMMENT PERFORM_PRSNL_ID
QC_RESULT_EVENT EVENT_PERSONNEL_ID
QUARANTINE_RELEASE RELEASE_PRSNL_ID
RAD_CRITICAL_RESOLVE RESOLUTION_PRSNL_ID
RAD_DOSE_FACET_R_SET LAST_UPDT_PRSNL_ID
RAD_DOSE_FACET_R_SET_HIST LAST_UPDT_PRSNL_ID
RAD_DOSE_SCAN LAST_UPDT_PRSNL_ID
RAD_DOSE_SCAN_FACET_R LAST_UPDT_PRSNL_ID
RAD_DOSE_SCAN_FACET_R_HIST LAST_UPDT_PRSNL_ID
RAD_DOSE_SCAN_HIST LAST_UPDT_PRSNL_ID
RAD_EXAM_PRSNL EXAM_PRSNL_ID
RAD_EXAM_PRSNL_HIST EXAM_PRSNL_ID
RAD_FILM_ADJUST RESPONSIBLE_ID
RAD_INIT_READ READ_BY_ID
RAD_INT_CASE PERSON_ID
RAD_INT_CASE_R RADIOLOGIST_ID
RAD_MAMMO_STUDY_ASSESS_MGMT_R RADIOLOGIST_ID
RAD_MEDS MODIFIED_PRSNL_ID
RAD_MED_DETAILS_HIST MODIFIED_PRSNL_ID
RAD_PEER_REVIEW ARBITER_ID
RAD_PEER_REVIEW REVIEWER_ID
RAD_PRIOR_PREFS PRSNL_ID
RAD_PROTOCOL_ACT APPROVED_BY_PRSNL_ID
RAD_PROTOCOL_ACT LAST_UPDT_PRSNL_ID
RAD_PROTOCOL_ACT_HIST APPROVED_BY_PRSNL_ID
RAD_PROTOCOL_ACT_HIST LAST_UPDT_PRSNL_ID
RAD_REPORT DICTATED_BY_ID
RAD_REPORT PREV_OWNER_ID
RAD_REPORT_PRSNL PROXIED_FOR_ID
RAD_REPORT_PRSNL REPORT_PRSNL_ID
RAD_RES_INFO ASSIGNED_RAD_ID
RAD_RES_INFO PERSON_ID
RAD_RES_INFO QUE_LOCK_ID
RAD_RPT_LOCK RPT_LOCK_ID
RAD_RPT_PRSNL_HIST PROXIED_FOR_ID
RAD_RPT_PRSNL_HIST REPORT_PRSNL_ID
RAD_TECH_CMT_DATA PRSNL_UPDT_ID
RAD_TECH_CMT_DATA_HIST PRSNL_UPDT_ID
RAD_TEMPLATE_GROUP PERSON_ID
RAD_TRANS_ROOM_REL PERSON_ID
RAD_TRANS_STATS TRANS_PRSNL_ID
RAD_VETTING_HOLD_DETAIL LAST_UPDT_PRSNL_ID
RAD_VETTING_HOLD_DETAIL ORIG_HOLD_PRSNL_ID
RAD_VETTING_HOLD_DETAIL PROXY_HOLD_PRSNL_ID
RAD_VETTING_HOLD_LOCK HOLD_LOCK_PRSNL_ID
RAD_WORKLIST PERSON_ID
RAD_WORKLIST_FAVORITES PERSON_ID
RAD_WRKLST_COL_CHOICE PRSNL_ID
RAD_WRKLST_DEF PRSNL_ID
RAD_WRKLST_PRSNL_PREF PRSNL_ID
RCM_CLARIFICATION PRSNL_ID
RCM_DIRECT_COMM SENDER_PRSNL_ID
RCM_DOC_REVIEW_FOLLOWUP FOLLOWUP_PRSNL_ID
RCM_MSG_CENTER_COMM SENDER_PRSNL_ID
RCM_MSG_CENTER_COMM_RELTN RECIPIENT_PRSNL_ID
RCM_NOTE CREATE_PRSNL_ID
RCM_NOTE LAST_UPDT_PRSNL_ID
RCM_POST_ACUTE_EVENT DISCHARGE_PRSNL_ID
RCM_TLC_PLACEMENT_FAC_R DISCHARGE_PRSNL_ID
RCM_TLC_SERVICE_FAC_R DISCHARGE_PRSNL_ID
RCR_TRANS_DIST ORDERING_PHYSICIAN_ID
RCR_TRANS_DIST POSTED_BY_ID
RCR_TRANS_DIST RENDERING_PHYSICIAN_ID
RC_CLOUD_SYNC PRSNL_ID
RC_CONFIG_DOCUMENT LAST_UPDT_PRSNL_ID
RC_PARAMETER_SET CREATE_PRSNL_ID
RC_PRSNL_GROUP_EXCLUSION PRSNL_ID
RC_PRSNL_GROUP_INCLUSION PRSNL_ID
RC_TIMELINE ACTIVITY_CREATED_PRSNL_ID
REFERRAL INBOUND_ASSIGNED_PRSNL_ID
REFERRAL OUTBOUND_ASSIGNED_PRSNL_ID
REFERRAL REFER_FROM_PROVIDER_ID
REFERRAL REFER_TO_PROVIDER_ID
REFERRAL_CONTACT CONTACT_PRSNL_ID
REFERRAL_HIST INBOUND_ASSIGNED_PRSNL_ID
REFERRAL_HIST OUTBOUND_ASSIGNED_PRSNL_ID
REFERRAL_HIST REFER_FROM_PROVIDER_ID
REFERRAL_HIST REFER_TO_PROVIDER_ID
REFERRAL_HIST RESPONSIBLE_PROVIDER_ID
REGIMEN_DETAIL_ACTION ACTION_PRSNL_ID
REPORT_TASK EDITING_PRSNL_ID
REPORT_TASK HOLD_PRSNL_ID
REPORT_TASK RESPONSIBLE_PATHOLOGIST_ID
REPORT_TASK RESPONSIBLE_RESIDENT_ID
REPRINT_HX PRSNL_ID
RESIDENT_SUPERVISOR RES_PERSON_ID
RESULT_COMMENT COMMENT_PRSNL_ID
RESULT_EVENT EVENT_PERSONNEL_ID
RES_REVIEWER PRSNL_ID
RES_SIGN_ACT_SUBTYPE PERSON_ID
REVIEW_QUEUE_ACCESS GRANT_TO_PRSNL_ID
REVIEW_QUEUE_ACCESS PRSNL_ID
REVIEW_QUEUE_FILTER_CRITERIA PRSNL_ID
ROLE_STATUS_OVRD_LOG PRSNL_ID
ROP_ECL DEFAULT_OPERATOR_ID
RRD_SECURE_EMAIL_DETAIL SENDER_ID
RR_PERFORM_RESULT PERFORM_PERSONNEL_ID
RR_RESULT_EVENT EVENT_PERSONNEL_ID
RULE_AUDIT RUN_PRSNL_ID
RVC_COMMENT CREATE_PRSNL_ID
RVC_COMMENT_HIST CREATE_PRSNL_ID
RXA_WORK_LOAD_OBS_ST WORK_USER_ID
RXS_ACTIVITY_INDEX PRSNL_ID
RXS_ALERT CREATE_PRSNL_ID
RXS_ALERT STATE_PRSNL_ID
RXS_ALERT_AUDIT_HX CREATE_PRSNL_ID
RXS_FOREIGN_DEVICE_ALERT CREATE_PRSNL_ID
RXS_GROUP CREATE_PRSNL_ID
RXS_ITEM_COUNTBACK PRSNL_ID
RXS_ITEM_COUNTBACK WITNS_PRSNL_ID
RXS_ITEM_GROUP_ACT ACTIVITY_PRSNL_ID
RXS_LOCATION_TASK CREATE_PRSNL_ID
RXS_LOCATION_TASK FILL_WITNESS_PRSNL_ID
RXS_LOCATION_TASK STATUS_PRSNL_ID
RXS_LOCATION_TASK TRANSFER_PRSNL_ID
RXS_LOCATION_TASK WITNESS_PRSNL_ID
RXS_LOC_ACCESS_CONFIG CREATE_PRSNL_ID
RXS_LOC_ACCESS_CONFIG LAST_UPDT_PRSNL_ID
RXS_LOC_ACCESS_CONFIG PRSNL_ID
RXS_MED_REQUEST REQUEST_PRSNL_ID
RXS_MED_REQUEST RX_ACTION_PRSNL_ID
RXS_ORDER_TASK_QUEUE ASSIGNED_PRSNL_ID
RXS_VERIFICATION VERIFIED_BY_PRSNL_ID
RXS_WORKLIST_EVENT EVENT_PRSNL_ID
RX_AUTO_VERIFY_AUDIT ACTION_PERSONNEL_ID
RX_AUTO_VERIFY_AUDIT ORDER_PROVIDER_ID
RX_IMAGE LAST_ACCESS_PRSNL_ID
RX_IMAGE_QUEUE_PRSNL_RELTN PERSON_ID
RX_IMG_IMGQUE_RELTN ROUTE_BY_PRSNL_ID
RX_IMG_IMGQUE_RELTN_HX ROUTE_BY_PRSNL_ID
RX_MED_REQUEST REQUEST_PRSNL_ID
RX_MED_REQUEST RX_ACTION_PRSNL_ID
RX_ORDER_REVIEW REVIEWED_BY_PRSNL_ID
RX_PENDING_CHARGE PRSNL_ID
RX_PENDING_CHARGE_DELETED PRSNL_ID
RX_PRODUCT_CHANGE_NOTE CREATE_PRSNL_ID
RX_PROD_VLDTN_EVENT VLDTN_PRSNL_ID
RX_REFILL_TRACK_HX CREATED_BY_PRSNL_ID
RX_SCRIPT_TRANSFER_HX PHARMACIST_ID
RX_SCRIPT_TRANSFER_HX XFER_PHARMACIST_ID
RX_VIEW_CONFIG PRSNL_ID
RX_WF_WS ASSEMBLE_PRSNL_ID
RX_WF_WS CHECKED_PRSNL_ID
RX_WF_WS FINAL_CHK_PRSNL_ID
RX_WF_WS FINAL_PROD_CHK_PRSNL_ID
RX_WF_WS MANF_PRSNL_ID
RX_WF_WS QC_APPROVED_PRSNL_ID
RX_WF_WS QC_RECONCILE_PRSNL_ID
RX_WORK_ITEM_QUEUE_HX DELETE_PRSNL_ID
RX_WS_FAC_RELTN_HX APPROVED_PRSNL_ID
SAFETY_COMMITTEE PERSON_ID
SA_ACTION PRSNL_ID
SA_ACTION_ITEM PRSNL_ID
SA_ACTION_SIGNATURE SIGNED_BY_PRSNL_ID
SA_ANESTHESIA_RECORD CREATED_BY_PRSNL_ID
SA_ANESTHESIA_REC_FIELD_VALUES ANESTHESIOLOGIST_ID
SA_ANESTHESIA_REC_FIELD_VALUES CARDIOLOGIST_ID
SA_ANESTHESIA_REC_FIELD_VALUES PHYSICIAN_ID
SA_DISPLAY_RESULT VIEWED_PRSNL_ID
SA_FLUID PRSNL_ID
SA_FLUID_ADMIN PRSNL_ID
SA_ITEM PRSNL_ID
SA_ITEM_USAGE PRSNL_ID
SA_LINKED_RESULT PRSNL_ID
SA_MACRO PRSNL_ID
SA_MEDICATION PRSNL_ID
SA_MEDICATION_ADMIN PRSNL_ID
SA_MEDICATION_SIGNOFF PRSNL_ID
SA_MED_SIGNOFF_SIGNATURE SIGNED_BY_PRSNL_ID
SA_PARAMETER PRSNL_ID
SA_PARAMETER_MONITOR PRSNL_ID
SA_PARAMETER_VALUE PRSNL_ID
SA_PREFERENCE PRSNL_ID
SA_PRSNL_ACTIVITY CREATED_ID
SA_PRSNL_ACTIVITY PRSNL_ID
SA_REF_EXCLUDE_PROVIDER PRSNL_ID
SA_REF_MACRO PRSNL_ID
SA_REMINDER COMPLETE_PRSNL_ID
SCD_SENTENCE AUTHOR_PERSNL_ID
SCD_STORY AUTHOR_ID
SCD_STORY UPDATE_LOCK_USER_ID
SCH_ACTION ACTION_PRSNL_ID
SCH_ACTION_NOTIFY TO_PRSNL_ID
SCH_APPT ALLOCATED_PRSNL_ID
SCH_CLINIC_PRSNL_RELTN PRSNL_ID
SCH_DATE_COMMENT ACTION_PRSNL_ID
SCH_DEF_APPLY APPLY_PRSNL_ID
SCH_EVENT REQ_PRSNL_ID
SCH_EVENT_ACTION ACTION_PRSNL_ID
SCH_EVENT_ACTION PROXY_ID
SCH_EVENT_RECUR_ORDER ORDER_PROVIDER_ID
SCH_LOCK GRANTED_PRSNL_ID
SCH_LOCK RELEASE_PRSNL_ID
SCH_LOG PRSNL_ID
SCH_NOTIFY TO_PRSNL_ID
SCH_OPTION WARN_PRSNL_ID
SCH_PEND_ENCNTR_DETAIL ATTENDING_PRSNL_ID
SCH_PEND_ENCNTR_DETAIL REFERRING_PRSNL_ID
SCH_PEND_WARNING WARN_PRSNL_ID
SCH_RESOURCE PERSON_ID
SCH_ROUTE_LIST TO_PRSNL_ID
SCH_WARNING AUTHORIZED_PRSNL_ID
SCH_WARNING WARN_PRSNL_ID
SCRATCHPAD_SESSION PRSNL_ID
SEARCH_SESSION USER_ID
SHX_ACTION PRSNL_ID
SHX_COMMENT COMMENT_PRSNL_ID
SI_CODE_SET_INTERFACE_HIST MODIFY_PRSNL_ID
SI_CODE_SET_INTERFACE_HIST ORIG_PRSNL_ID
SI_CONTRIBUTOR_SYSTEM_HIST MODIFY_PRSNL_ID
SI_CONTRIBUTOR_SYSTEM_HIST ORG_PRSNL_ID
SI_CONTRIBUTOR_SYSTEM_HIST PRSNL_PERSON_ID
SI_DIRECT_MESSAGE REQUESTER_ID
SI_ERX_DIGITAL_SIG_LOG PRSNL_ID
SI_ESI_ALIAS_TRANS_HIST MODIFY_PRSNL_ID
SI_ESI_ALIAS_TRANS_HIST ORG_PRSNL_ID
SI_ESI_ENSURE_PARMS_HIST MODIFY_PRSNL_ID
SI_ESI_ENSURE_PARMS_HIST ORIG_PRSNL_ID
SI_HIST_ALIAS_FLD_CONTR_SRC_R MODIFY_PRSNL_ID
SI_HIST_ALIAS_FLD_CONTR_SRC_R ORIG_PRSNL_ID
SI_INTEROP_AUTHOR PRSNL_ID
SI_INTEROP_METADATA LGL_AUTHENT_PRSNL_ID
SI_MATCH_TAG_PARMS_HIST MODIFY_PRSNL_ID
SI_MATCH_TAG_PARMS_HIST ORIG_PRSNL_ID
SI_OEN_SKIPPED_MSGS STATUS_PRSNL_ID
SI_OUTBOUND_FIELD_PROCESS_HIST MODIFY_PRSNL_ID
SI_OUTBOUND_FIELD_PROCESS_HIST ORIG_PRSNL_ID
SI_UNMTCHD_PRSN_QUE ASSIGNING_PRSNL_ID
SI_XDOC_QUERY_PERSON_RELTN USER_ID
SN_APP_PREFS PERSON_ID
SN_CASE_LONG_TEXT PERSON_ID
SN_CHARGE_DETAIL RECHARGE_PRSNL_ID
SN_PICKLIST OPTIMIZED_PRSNL_ID
SN_PICKLIST_LOCK LOCK_PRSNL_ID
SN_PICKLIST_LOC_STATUS PRSNL_ID
SN_PICKLIST_MESSAGE RESOLVED_PRSNL_ID
SN_PICKLIST_MESSAGE_TEXT CREATE_PRSNL_ID
SN_PICKLIST_MESSAGE_TEXT LAST_MODIFIED_PRSNL_ID
SN_PICKLIST_PREF_CARD_R SURGEON_ID
SN_PICKLIST_STATUS PRSNL_ID
SN_PREFCARD_MPAGE_SNOOZE USER_ID
SN_PREF_CARD ARCHIVED_PRSNL_ID
SN_PREF_CARD CREATE_PRSNL_ID
SN_PREF_CARD_COMMENT ACTIVE_PRSNL_ID
SN_PREF_CARD_COMMENT CREATE_PRSNL_ID
SN_PREF_CARD_EXCEPTION ACTIVE_PRSNL_ID
SN_PREF_CARD_EXCEPTION CREATE_PRSNL_ID
SN_PREF_CARD_EXCEPT_ADD ACTIVE_PRSNL_ID
SN_PREF_CARD_EXCEPT_ADD CREATE_PRSNL_ID
SN_PREF_CARD_EXCEPT_COMMENT ACTIVE_PRSNL_ID
SN_PREF_CARD_EXCEPT_COMMENT CREATE_PRSNL_ID
SN_PREF_CARD_EXCEPT_REMOVE ACTIVE_PRSNL_ID
SN_PREF_CARD_EXCEPT_REMOVE CREATE_PRSNL_ID
SN_PREF_CARD_ITEM ACTIVE_PRSNL_ID
SN_PREF_CARD_ITEM CREATE_PRSNL_ID
SN_PREF_CARD_LOCK LOCK_PRSNL_ID
SN_PREF_CARD_MODIFY_HIST MODIFY_PRSNL_ID
SN_PREF_CARD_PROCEDURE ACTIVE_PRSNL_ID
SN_PREF_CARD_PROCEDURE CREATE_PRSNL_ID
SN_PRIV PERSON_ID
SN_RPT CREATE_PRSNL_ID
SN_RPT OWNER_ID
SN_RPT_FILTER_GRP CREATE_PRSNL_ID
SN_RPT_FILTER_GRP OWNER_ID
SN_SIGNATURE PERSONNEL_ID
SN_SURG_PROFILE ACTIVE_PRSNL_ID
SN_SURG_PROFILE CREATE_PRSNL_ID
SN_SURG_PROFILE PRSNL_ID
SN_SURG_PROFILE_COMMENT ACTIVE_PRSNL_ID
SN_SURG_PROFILE_COMMENT CREATE_PRSNL_ID
SN_SURG_PROFILE_LOCK LOCK_PRSNL_ID
SN_SURG_PROFILE_MOD_HIST MODIFY_PRSNL_ID
SN_TEMPERATURE_HIST PRSNL_ID
SN_TISSUE_WORKFLOW CREATE_PRSNL_ID
SN_UNFINALIZE_REASON PRSNL_ID
SPECIMEN_USAGE USAGE_PRSNL_ID
STAFF_ACTIVITY PRSNL_ID
SURGICAL_CASE ANESTH_PRSNL_ID
SURGICAL_CASE CANCEL_REQ_BY_ID
SURGICAL_CASE CHECKIN_BY_ID
SURGICAL_CASE SCHED_ANESTH_PRSNL_ID
SURGICAL_CASE SURGEON_PRSNL_ID
SURGICAL_DELAY DELAY_DOC_BY_ID
SURGICAL_DELAY DELAY_OBSERVE_BY_ID
SURGICAL_DELAY DELAY_REPORT_TO_ID
SURGICAL_STAFF PERSON_ID
SURGICAL_STAFF_AVAILABILITY PRSNL_ID
SURGICAL_TEAM PERSON_ID
SURG_CASE_PROCEDURE PRIMARY_SURGEON_ID
SURG_CASE_PROCEDURE SCHED_PRIMARY_SURGEON_ID
SURG_PROC_DURATION PRSNL_ID
SURG_REQ PRSNL_ID
SURG_REQ_FAVORITE PRSNL_ID
SURG_REQ_STAFF PRSNL_ID
TASK_ACTIVITY RESPONSIBLE_PRSNL_ID
TASK_ACTIVITY_ASSIGNMENT ASSIGN_PRSNL_ID
TASK_ACTIVITY_ASSIGN_MSG_H ASSIGN_PRSNL_ID
TASK_ACTIVITY_MSG_H RESPONSIBLE_PRSNL_ID
TASK_INTENDED_RECIPIENT PRSNL_ID
TEST_REVIEWER QUEUED_TO_PRSNL_ID
TEST_REVIEWER REVIEWED_BY_PRSNL_ID
TEST_REVIEWER ROUTED_FROM_PRSNL_ID
TL_USER_PREFERENCE PERSON_ID
TOC_DEFAULT_VIEW PRSNL_ID
TRACKABLE_OBJECT TRK_PT_ARRIVE_ID
TRACKING_CHECKIN CHECKIN_ID
TRACKING_CHECKIN CHECKOUT_ID
TRACKING_CHECKIN PAT_ED_ACKNOWLEDGED_USER_ID
TRACKING_CHECKIN PRIMARY_DOC_ID
TRACKING_CHECKIN PRIMARY_NURSE_ID
TRACKING_CHECKIN SECONDARY_DOC_ID
TRACKING_CHECKIN SECONDARY_NURSE_ID
TRACKING_ENCNTR_EXTENSION DC_SIGNED_USER_ID
TRACKING_ENCNTR_EXTENSION PAT_ED_ACKNOWLEDGED_USER_ID
TRACKING_EVENT_HISTORY NEW_USER_ID
TRACKING_EVENT_HISTORY OLD_USER_ID
TRACKING_HOLD HOLD_ID
TRACKING_ITEM PRSNL_PERSON_ID
TRACKING_LOCATOR ARRIVE_ID
TRACKING_LOCATOR DEPART_ID
TRACKING_PREARRIVAL PCP_PROVIDER_ID
TRACKING_PREARRIVAL REG_PRSNL_ID
TRACKING_PRSNL PERSON_ID
TRACK_LIST_PRSNL_RELTN PRSNL_ID
TRANSACTION_ADDRESS_VERIFY SUBMITTER_PRSNL_ID
TRANSACTION_ADMIT_NOTIFY SUBMITTER_PRSNL_ID
TRANSACTION_ELIGIBILITY REVIEWER_PRSNL_ID
TRANSACTION_ELIGIBILITY SUBMITTER_PRSNL_ID
TRANSFER LOGIN_PRSNL_ID
TRANSFER RETURN_PRSNL_ID
TRANS_LOG CREATED_PRSNL_ID
UCM_CHARGE_ORDER_R RENDERING_PHYS_ID
UCM_FAMILY_HISTORY_REVIEW REVIEWER_ID
UCM_PRSNL_ASSIGNMENT PRSNL_ID
UCM_PTL_RESULT RESULT_PRSNL_ID
V500_SPECIMEN CREATION_PRSNL_ID
V500_SPECIMEN DRAWN_ID
VISITCODE_INI PRSNL_ID
VISITCODING_AUDIT CODER_PRSNL_ID
VISITCODING_AUDIT PROVIDER_PRSNL_ID
VISITCODING_PROVIDER PROVIDER_ID
WF_SHIFT_SCHED PRSNL_ID
WF_STFG_HDR SUBMITTED_PRSNL_ID
WF_XFI_SHIFT_SCHED PRSNL_ID
WKF_WORKFLOW PRSNL_ID
WORKLIST WORKLIST_PRSNL_ID
WORKLIST_EVENT EVENT_PRSNL_ID
WP_TEMPLATE PERSON_ID


PRSNL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Alias
Definition: The person alias table contains information used identify a person (i.e., physician hospital number, UPIN number, etc.). There can be many rows in the personnel alias table that are related to a single row in the personnel table.
Table Type: REFERENCE





Column Detail - PRSNL_ALIAS


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.
ALIAS VARCHAR(200) Y The alias is an identifier (I.e., doctor number, UPIN, etc.) for a personnel. The alias may be unique or non-unique depending on the type of alias.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of personnel identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
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.
CHECK_DIGIT DOUBLE Y This is the value of the check digit calculated according to the check_digit_method_cd. If the check digit is stored as part of the alias number, which is typical, then the check digit field may be NULL.
CHECK_DIGIT_METHOD_CD DOUBLE N The check digit method code identifies a specific routine, using the alias field, to calculate a check digit.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the person alias table. It is an internal system assigned number.
PRSNL_ALIAS_SUB_TYPE_CD DOUBLE N Not Used
PRSNL_ALIAS_TYPE_CD DOUBLE N Personnel alias type code identifies a kind or type of alias (i.e., doctor number, UPIN, etc.). They have Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias.
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 - PRSNL_ALIAS


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