SCH_APPT_FREE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SCH_APPT_FREE |
Definition: | Scheduling Freetext Associations |
Table Type: | REFERENCE |
Column Detail - SCH_APPT_FREE
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_TYPE_CD | DOUBLE | N | The identifier for an 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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
CHILD_CD | DOUBLE | N | The coded identifier for the child object. |
CHILD_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the CHILD_ID. |
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. |
FREE_TYPE_CD | DOUBLE | N | A coded identifier for the free texttype. |
FREE_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the free texttype. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00 |
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_APPT_FREE
Child Column in SCH_APPT_FREE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | APPT_TYPE_CD | CODE_VALUE | CODE_VALUE |
CHILD_CD | CODE_VALUE | CODE_VALUE | |
FREE_TYPE_CD | CODE_VALUE | CODE_VALUE |
SCH_APPT_ORD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Appointment Order |
Definition: | Scheduling Appointment Orders |
Table Type: | REFERENCE |
Column Detail - SCH_APPT_ORD
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. |
ALT_SEL_CATEGORY_ID | DOUBLE | N | Foreign Key to the ALT_SEL_CAT table. |
APPT_TYPE_CD | DOUBLE | N | The identifier for an 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. |
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. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00 |
REQUIRED_IND | DOUBLE | N | Determines if the component is a required member. |
SEQ_NBR | DOUBLE | N | Determines the order among the children of a group. |
SYNONYM_ID | DOUBLE | N | The unique identifier of the order catalog synonym. |
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_APPT_ORD
Child Column in SCH_APPT_ORD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALT_SEL_CATEGORY_ID | ALT_SEL_CAT | ALT_SEL_CATEGORY_ID |
APPT_TYPE_CD | CODE_VALUE | CODE_VALUE | |
SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
SCH_BOOKING_ORD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SCH_BOOKING_ORD |
Definition: | Scheduling Pending Orders |
Table Type: | ACTIVITY |
Column Detail - SCH_BOOKING_ORD
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. |
BOOKING_ID | DOUBLE | N | The unique identifier for a resource availability lock. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
CATALOG_CD | DOUBLE | N | Order Catalog Code |
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 |
ORDER_MNEMONIC | VARCHAR(100) | Y | Order Mnemonic |
ORDER_STATUS_CD | DOUBLE | N | Order status code. |
ORDER_STATUS_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the ORDER_STATUS_CD |
SEQ_NBR | DOUBLE | N | Determines the order among the children of a group. |
SYNONYM_ID | DOUBLE | N | Id of the synonym for this order. |
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_BOOKING_ORD
Child Column in SCH_BOOKING_ORD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_STATUS_CD | CODE_VALUE | CODE_VALUE |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID | |
BOOKING_ID | SCH_BOOKING | BOOKING_ID |
SCH_ORDER_APPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Order Appointment |
Definition: | Scheduling Order Appointment |
Table Type: | REFERENCE |
Column Detail - SCH_ORDER_APPT
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_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. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
CATALOG_CD | DOUBLE | N | The unique identifier for the order catalog entry. |
CHILD_APPT_TYPE_CD | DOUBLE | N | The unique identifier for the child appointment type. |
DEL_APPT_CD | DOUBLE | N | The coded identifier for the delete appointment action. |
DEL_APPT_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the delete appointment action. |
DISPLAY_SEQ_NBR | DOUBLE | N | The display order of the valid appointment types within the order tool. |
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. |
EVENT_CONCURRENT_IND | DOUBLE | N | Determintes if the order is concurrent to the entire event. |
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. |
PROC_SPEC_CD | DOUBLE | N | A coded identifier for the procedure specific status. This field is used to determine if the order is required for the appointment type. |
PROC_SPEC_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the procedure specific status. |
SCH_FLEX_ID | DOUBLE | N | The unique identifier for the scheduling flex string. |
SEQ_NBR | DOUBLE | N | Determines the order of the object within a collection. |
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_ORDER_APPT
Child Column in SCH_ORDER_APPT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | APPT_TYPE_CD | CODE_VALUE | CODE_VALUE |
CATALOG_CD | CODE_VALUE | CODE_VALUE | |
CHILD_APPT_TYPE_CD | CODE_VALUE | CODE_VALUE | |
DEL_APPT_CD | CODE_VALUE | CODE_VALUE | |
PROC_SPEC_CD | CODE_VALUE | CODE_VALUE | |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID |
SCH_ORDER_DURATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Order Duration |
Definition: | Scheduling Order Duration |
Table Type: | REFERENCE |
Column Detail - SCH_ORDER_DURATION
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. |
ARRIVAL_UNITS | DOUBLE | N | The arrival units. This provides a quantity (1,2,3?) |
ARRIVAL_UNITS_CD | DOUBLE | N | The unique identifier for the units used in ARRIVAL_UNITS. (minutes, hours, etc.) |
ARRIVAL_UNITS_MEANING | VARCHAR(12) | Y | A 12 character description corresponding to ARRIVAL_UNITS_CD. |
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. |
CATALOG_CD | DOUBLE | N | The unique identifier for the order catalog entry. |
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. |
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. |
LOCATION_CD | DOUBLE | N | The field identifies the current permanent location of the patient. |
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_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. |
RECOVERY_UNITS | DOUBLE | N | Recovery Duration |
RECOVERY_UNITS_CD | DOUBLE | N | The unique identifier for the recovery duration units of measure. |
RECOVERY_UNITS_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the recovery duration units of measure. |
SCH_FLEX_ID | DOUBLE | N | The unique identifier for the scheduling flex string. |
SEQ_NBR | DOUBLE | N | Determines the order of the object within a collection. |
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. |
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_ORDER_DURATION
Child Column in SCH_ORDER_DURATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ARRIVAL_UNITS_CD | CODE_VALUE | CODE_VALUE |
CATALOG_CD | CODE_VALUE | CODE_VALUE | |
CLEANUP_UNITS_CD | CODE_VALUE | CODE_VALUE | |
DURATION_UNITS_CD | CODE_VALUE | CODE_VALUE | |
LOCATION_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 | |
RECOVERY_UNITS_CD | CODE_VALUE | CODE_VALUE | |
SETUP_UNITS_CD | CODE_VALUE | CODE_VALUE | |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID |