Table Detail Report
SCH_LIST_LOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Resource List Location |
Definition: | Scheduling Resource List Location |
Table Type: | REFERENCE |
Column Detail - SCH_LIST_LOC
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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
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. |
LIST_ROLE_ID | DOUBLE | N | The unique identifier for the scheduling role. |
LOCATION_CD | DOUBLE | N | The field identifies the current permanent location of the patient. |
LOCATION_TYPE_CD | DOUBLE | N | Defines the locations meaning to scheduling. |
LOCATION_TYPE_MEANING | VARCHAR(12) | Y | A 12-char description of the location association type. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
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. |
VERSION_DT_TM | DATETIME | N | The version date and time marks the date the record became historical. |
Relationship Detail - SCH_LIST_LOC
Child Column in SCH_LIST_LOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_TYPE_CD | CODE_VALUE | CODE_VALUE |
LOCATION_CD | LOCATION | LOCATION_CD | |
LIST_ROLE_ID | SCH_LIST_RES | LIST_ROLE_ID | |
RESOURCE_CD | SCH_LIST_RES | RESOURCE_CD |
SCH_LIST_RES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling List Resource |
Definition: | Scheduling List Resource |
Table Type: | REFERENCE |
Column Detail - SCH_LIST_RES
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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DISPLAY_SEQ | DOUBLE | Y | The display order of the object within the collection. |
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. |
LIST_ROLE_ID | DOUBLE | N | The unique identifier for the scheduling role. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
PREF_IND | DOUBLE | Y | Determines if the resource had a preferred resource list. |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
RES_SCH_CD | DOUBLE | N | The coded identifier for the schedulable status of the resource (schedulable, overflow). |
RES_SCH_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the resource schedulable code. |
SCH_FLEX_ID | DOUBLE | N | The unique identifier for the scheduling flex string. |
SEARCH_SEQ | DOUBLE | Y | Determines the manual search order for the resources. |
SELECTED_IND | DOUBLE | Y | Determines if the object is (by default) selected or not. |
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. |
VERSION_DT_TM | DATETIME | N | The version date and time marks the date the record became historical. |
Relationship Detail - SCH_LIST_RES
Child Column in SCH_LIST_RES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RESOURCE_CD | CODE_VALUE | CODE_VALUE |
RES_SCH_CD | CODE_VALUE | CODE_VALUE | |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID | |
LIST_ROLE_ID | SCH_LIST_ROLE | LIST_ROLE_ID |
Parent Column in SCH_LIST_RES (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LIST_ROLE_ID | SCH_LIST_LOC | LIST_ROLE_ID |
RESOURCE_CD | SCH_LIST_LOC | RESOURCE_CD | |
LIST_ROLE_ID | SCH_LIST_SLOT | LIST_ROLE_ID | |
RESOURCE_CD | SCH_LIST_SLOT | RESOURCE_CD |
SCH_LIST_ROLE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling List Role |
Definition: | Scheduling List Role |
Table Type: | REFERENCE |
Column Detail - SCH_LIST_ROLE
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. |
ALGORITHM_CD | DOUBLE | N | The coded identifier for the scheduling algorithm. The scheduling algorithm detemines how resources are scheduled. |
ALGORITHM_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the scheduling algorithm. |
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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
CONCURRENT_IND | DOUBLE | N | an indicator to allow current role to book into the same resource as primary role in a concurrent slot |
DEFINING_IND | DOUBLE | Y | Determines if the role is the defining role. |
DEP_LIST_ROLE_ID | DOUBLE | N | The identifier of the dependent list role. |
DEP_RESOURCE_CD | DOUBLE | N | The coded identifier for the dependent resource. |
DESCRIPTION | VARCHAR(200) | Y | A long description used for documentation. |
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. |
INFO_SCH_TEXT_ID | DOUBLE | N | The identifier of the information-only text associated with the record. |
LIST_ROLE_ID | DOUBLE | N | The unique identifier for the scheduling role. |
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. |
MNEMONIC | VARCHAR(100) | Y | A 100-character string used for identification and selection. |
MNEMONIC_KEY | VARCHAR(100) | Y | The MNEMONIC in uppercase with the non-alphanumeric characters removed. |
MNEMONIC_KEY_A_NLS | VARCHAR(400) | Y | MNEMONIC_KEY_A_NLS column |
MNEMONIC_KEY_NLS | VARCHAR(202) | Y | A native sort version of the MNEMONIC_KEY FIELD. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
OPTIONAL_IND | DOUBLE | Y | Determines if the scheduling relationship is required or optional. |
PRIMARY_IND | DOUBLE | Y | Mark the appointment synonym as the primary synonym for the appointment type. |
PROMPT_ACCEPT_CD | DOUBLE | N | The coded identifier for the prompt accept option. This field determines if the resource role should prompt the user for the valid resources. |
PROMPT_ACCEPT_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the prompt accept option. |
RESCH_PREV_RES_IND | DOUBLE | N | An indicator to show whether we will reschedule the appointment back the original scheduled resource. |
RES_LIST_ID | DOUBLE | N | The unique identifier of the scheduling resource list. |
ROLE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling role. |
ROLE_SEQ | DOUBLE | Y | The order of the role on the resource list. |
ROLE_TYPE_CD | DOUBLE | N | A internal identifier for the scheduling role type. |
ROLE_TYPE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the Scheduling Role Type. |
SCH_FLEX_ID | DOUBLE | N | The unique identifier for the scheduling flex string. |
SCH_ROLE_CD | DOUBLE | N | The coded identifier for the scheduling role. |
SELECTED_IND | DOUBLE | Y | Determines if the object is (by default) selected or not. |
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. |
VERSION_DT_TM | DATETIME | N | The version date and time marks the date the record became historical. |
Relationship Detail - SCH_LIST_ROLE
Child Column in SCH_LIST_ROLE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALGORITHM_CD | CODE_VALUE | CODE_VALUE |
PROMPT_ACCEPT_CD | CODE_VALUE | CODE_VALUE | |
ROLE_TYPE_CD | CODE_VALUE | CODE_VALUE | |
SCH_ROLE_CD | CODE_VALUE | CODE_VALUE | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID | |
RES_LIST_ID | SCH_RESOURCE_LIST | RES_LIST_ID |
Parent Column in SCH_LIST_ROLE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LIST_ROLE_ID | ITEM_CONTROL_INFO | LIST_ROLE_ID |
SCH_ACTION_ROLE | LIST_ROLE_ID | ||
SCH_EVENT_RECUR_ROLE | LIST_ROLE_ID | ||
SCH_EVENT_ROLE | LIST_ROLE_ID | ||
SCH_LIST_RES | LIST_ROLE_ID | ||
SCH_LIST_SLOT | CLEANUP_ROLE_ID | ||
SCH_LIST_SLOT | DURATION_ROLE_ID | ||
SCH_LIST_SLOT | OFFSET_ROLE_ID | ||
SCH_LIST_SLOT | SETUP_ROLE_ID | ||
SCH_ORDER_ROLE | LIST_ROLE_ID | ||
SCH_PEND_APPT | LIST_ROLE_ID | ||
SCH_PEND_SURG_ITEM | LIST_ROLE_ID |
SCH_LIST_SLOT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling List Slot |
Definition: | Scheduling List Slot |
Table Type: | REFERENCE |
Column Detail - SCH_LIST_SLOT
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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
CLEANUP_ROLE_ID | DOUBLE | N | The identifier of the list role from which the cleanup duration is inherited. |
CLEANUP_UNITS | DOUBLE | N | Cleanup Duration Units |
CLEANUP_UNITS_CD | DOUBLE | N | The coded identifier for the cleanup duration units of measure. |
CLEANUP_UNITS_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the cleanup duration units of measure. |
DISPLAY_SEQ | DOUBLE | Y | The display order of the object within the collection. |
DURATION_ROLE_ID | DOUBLE | N | The identifier of the list role from which the duration is inherited. |
DURATION_UNITS | DOUBLE | N | Duration Units |
DURATION_UNITS_CD | DOUBLE | N | The coded identifier for the duration units of measure. |
DURATION_UNITS_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the duration units of measure. |
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. |
LIST_ROLE_ID | DOUBLE | N | The unique identifier for the scheduling role. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
OFFSET_BEG_UNITS | DOUBLE | N | Scheduling Offset Beg Units |
OFFSET_BEG_UNITS_CD | DOUBLE | N | The coded identifier for the beg units of measure. |
OFFSET_BEG_UNITS_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the beg units of measure. |
OFFSET_END_UNITS | DOUBLE | N | Scheduling Offset End Units |
OFFSET_END_UNITS_CD | DOUBLE | N | The coded identifier for the end units of measure. |
OFFSET_END_UNITS_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the end offset units of measure. |
OFFSET_ROLE_ID | DOUBLE | N | The identifier of the list role from which to offset the duration. |
OFFSET_TYPE_CD | DOUBLE | N | The coded identifier for the offset type. |
OFFSET_TYPE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the offset type. |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
SCH_FLEX_ID | DOUBLE | N | The unique identifier for the scheduling flex string. |
SEARCH_SEQ | DOUBLE | Y | Determines the manual search order for the resources. |
SELECTED_IND | DOUBLE | Y | Determines if the object is (by default) selected or not. |
SETUP_ROLE_ID | DOUBLE | N | The unique identifier of the list role from which the setup duration is inherited. |
SETUP_UNITS | DOUBLE | N | Setup Duration Units |
SETUP_UNITS_CD | DOUBLE | N | The coded identifier of the setup duration units (minutes, hours, etc.) |
SETUP_UNITS_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the setup duration units. |
SLOT_TYPE_ID | DOUBLE | N | The unique identifier for the slot type. |
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. |
VERSION_DT_TM | DATETIME | N | The version date and time marks the date the record became historical. |
Relationship Detail - SCH_LIST_SLOT
Child Column in SCH_LIST_SLOT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLEANUP_UNITS_CD | CODE_VALUE | CODE_VALUE |
DURATION_UNITS_CD | CODE_VALUE | CODE_VALUE | |
OFFSET_BEG_UNITS_CD | CODE_VALUE | CODE_VALUE | |
OFFSET_END_UNITS_CD | CODE_VALUE | CODE_VALUE | |
OFFSET_TYPE_CD | CODE_VALUE | CODE_VALUE | |
SETUP_UNITS_CD | CODE_VALUE | CODE_VALUE | |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID | |
LIST_ROLE_ID | SCH_LIST_RES | LIST_ROLE_ID | |
RESOURCE_CD | SCH_LIST_RES | RESOURCE_CD | |
CLEANUP_ROLE_ID | SCH_LIST_ROLE | LIST_ROLE_ID | |
DURATION_ROLE_ID | SCH_LIST_ROLE | LIST_ROLE_ID | |
OFFSET_ROLE_ID | SCH_LIST_ROLE | LIST_ROLE_ID | |
SETUP_ROLE_ID | SCH_LIST_ROLE | LIST_ROLE_ID | |
SLOT_TYPE_ID | SCH_SLOT_TYPE | SLOT_TYPE_ID |
SCH_NOMEN_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Nomenclature List |
Definition: | Scheduling Nomenclature List |
Table Type: | REFERENCE |
Column Detail - SCH_NOMEN_LIST
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. |
APPT_NOMEN_CD | DOUBLE | N | A coded identifier corresponding to a appointment nomenclature type. |
APPT_NOMEN_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the appointment nomenclature code. |
APPT_TYPE_CD | DOUBLE | N | The unique identifier for the scheduling appointment type. |
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. |
BEG_IDENT | VARCHAR(50) | N | begin identifier |
BEG_NOMENCLATURE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
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. |
END_IDENT | VARCHAR(50) | N | end identifier |
END_NOMENCLATURE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
SEQ_NBR | DOUBLE | N | Determines the order of the object within a collection. |
SOURCE_VOCABULARY_CD | DOUBLE | N | source vocabulary 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. |
VERSION_DT_TM | DATETIME | N | The version date and time marks the date the record became historical. |
Relationship Detail - SCH_NOMEN_LIST
Child Column in SCH_NOMEN_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BEG_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
END_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
APPT_NOMEN_CD | SCH_APPT_NOMEN | APPT_NOMEN_CD | |
APPT_TYPE_CD | SCH_APPT_NOMEN | APPT_TYPE_CD |