Table Detail Report
SCH_CAB_RES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling CAB resources |
Definition: | This table is used for defining resources for choose and book services |
Table Type: | REFERENCE |
Column Detail - SCH_CAB_RES
Column Name | Type | Null? | Definition |
---|---|---|---|
CAB_SERVICE_ID | DOUBLE | N | The unique identifier of the scheduling Choose and Book Service. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DISPLAY_SEQ | DOUBLE | N | The display order of the object within the collection. |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
ROLE_PROFILE | VARCHAR(255) | N | the role profile |
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 - SCH_CAB_RES
Child Column in SCH_CAB_RES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CAB_SERVICE_ID | SCH_CAB_SERVICE | CAB_SERVICE_ID |
SCH_CAB_SERVICE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Choose and Book services |
Definition: | This table is used for defining Choose and Book services |
Table Type: | REFERENCE |
Column Detail - SCH_CAB_SERVICE
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. |
APPT_SYNONYM_CD | DOUBLE | N | The unique identifier for the scheduling appointment type. |
CAB_SERVICE_ALIAS | VARCHAR(100) | N | NHS's unique identifier for this service |
CAB_SERVICE_ID | DOUBLE | N | The unique identifier of the scheduling Choose and Book Service. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DESCRIPTION | VARCHAR(255) | Y | A long description used for documentation. |
ENCNTR_TYPE_CD | DOUBLE | N | The encounter type code |
INFO_SCH_TEXT_ID | DOUBLE | N | The identifier of the information-only text associated with the record. |
LOCATION_CD | DOUBLE | N | The location the service will be booked into. |
MED_SERVICE_CD | DOUBLE | N | The treatment function code |
MNEMONIC | VARCHAR(100) | Y | A 100-character string used for identification and selection. |
MNEMONIC_KEY | VARCHAR(100) | N | 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. |
SERVICE_CATEGORY_CD | DOUBLE | N | The DOH specialty 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. |
Relationship Detail - SCH_CAB_SERVICE
Child Column in SCH_CAB_SERVICE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
APPT_SYNONYM_CD | SCH_APPT_SYN | APPT_SYNONYM_CD |
Parent Column in SCH_CAB_SERVICE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CAB_SERVICE_ID | SCH_CAB_RES | CAB_SERVICE_ID |
SCH_CAB_SLOT | CAB_SERVICE_ID | ||
SCH_SLOT_ALIAS | CAB_SERVICE_ID |
SCH_CAB_SLOT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling choose and book slots |
Definition: | This table is used for defining slots for choose and book services |
Table Type: | REFERENCE |
Column Detail - SCH_CAB_SLOT
Column Name | Type | Null? | Definition |
---|---|---|---|
ALLOCATED_IND | DOUBLE | N | Allocated Clinician Indicator |
CAB_SERVICE_ID | DOUBLE | N | The unique identifier of the scheduling Choose and Book Service. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DEF_APPT_DUR | DOUBLE | N | The default duration (in minutes) for this CAB slot. |
DISPLAY_SEQ | DOUBLE | N | The sequence of the display. |
LOCATION_CD | DOUBLE | N | Location of the Slot within a Service. |
PRIORITY_CD | DOUBLE | N | slot priority code |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
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. |
Relationship Detail - SCH_CAB_SLOT
Child Column in SCH_CAB_SLOT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CAB_SERVICE_ID | SCH_CAB_SERVICE | CAB_SERVICE_ID |
SLOT_TYPE_ID | SCH_SLOT_TYPE | SLOT_TYPE_ID |
SCH_CAB_WORKGROUP_RES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Choose and Book Workgroup Resources |
Definition: | Stores a list of resources working under the same team. |
Table Type: | REFERENCE |
Column Detail - SCH_CAB_WORKGROUP_RES
Column Name | Type | Null? | Definition |
---|---|---|---|
CAB_SERVICE_ID | DOUBLE | N | The unique identifier of the scheduling Choose and Book Service. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
SCH_CAB_WORKGROUP_RES_ID | DOUBLE | N | Unique, generated number that identifies a single row on the SCH_CAB_WORKGROUP_RES table. |
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. |
WORKGROUP_RESOURCE_CD | DOUBLE | N | The identifier for the resource in the cab work group. A resource is an item of limited availability. |
Relationship Detail - SCH_CAB_WORKGROUP_RES
Child Column in SCH_CAB_WORKGROUP_RES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RESOURCE_CD | SCH_RESOURCE | RESOURCE_CD |
SCH_CODE_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Code Group |
Definition: | This table is used to create groups of CODE_VALUES from the CODE_VALUE table. |
Table Type: | REFERENCE |
Column Detail - SCH_CODE_GROUP
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. |
CDF_MEANING | VARCHAR(12) | Y | The actual string value for the cdf meaning. |
CODE_GROUP_ID | DOUBLE | N | The numeric identifier for the code value group. |
CODE_GROUP_MEANING | VARCHAR(30) | N | A 12-character description corresponding to the code value group. |
CODE_VALUE | DOUBLE | N | This is the code value for certain code sets that allow multiple selects. |
DISPLAY | VARCHAR(40) | Y | Display Value |
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. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00 |
SEQ_NBR | DOUBLE | Y | Determines the order among the children of a group. |
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_CODE_GROUP
Child Column in SCH_CODE_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODE_VALUE | CODE_VALUE | CODE_VALUE |