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! |
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 |
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 |