Table Detail Report

SCH_REF_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Refernence Comments
Definition: Scheduling Refernence Comments
Table Type: REFERENCE





Column Detail - SCH_REF_COMMENT


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.
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.
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(32) N The parent table corresponding to the PARENT_ID
SUB_TEXT_CD DOUBLE N The coded identifier for the scheduling sub text type. The sub text types allow for multiple set of text within a text type (prep, post, guidelines, etc.)
SUB_TEXT_MEANING VARCHAR(12) Y The 12-character string corresponding to the scheduling text sub-type.
TEXT_ID DOUBLE N The unique identifier used to store the actual test on the LONG_TEXT table.
TEXT_TYPE_CD DOUBLE N The coded identifier for the scheduling text type.
TEXT_TYPE_MEANING VARCHAR(12) Y The 12-character string corresponding to the scheduling text 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_REF_COMMENT


Child Column in SCH_REF_COMMENT(FK) Parent Table Name Parent Column Name
Parents: SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


SCH_REF_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Reference Detail
Definition: Scheduling Reference Detail
Table Type: REFERENCE





Column Detail - SCH_REF_DETAIL


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.
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.
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y An accept format alphanumeric value.
OE_FIELD_DT_TM_VALUE DATETIME Y An accept format date and time value.
OE_FIELD_ID DOUBLE N The unique identifier for the order entry field.
OE_FIELD_MEANING VARCHAR(25) Y Defined the piece of information represented.
OE_FIELD_MEANING_ID DOUBLE N Defines the piece of information represented by the field.
OE_FIELD_VALUE DOUBLE Y An accept format numeric value.
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(32) N The parent table corresponding to the PARENT_ID
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_REF_DETAIL


Child Column in SCH_REF_DETAIL(FK) Parent Table Name Parent Column Name
Parents: OE_FIELD_MEANING_ID OE_FIELD_MEANING OE_FIELD_MEANING_ID
OE_FIELD_ID ORDER_ENTRY_FIELDS OE_FIELD_ID


SCH_REF_FREQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Reference Frequencies
Definition: Scheduling Reference Ferquencies
Table Type: REFERENCE





Column Detail - SCH_REF_FREQ


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.
DAYS_OF_WEEK VARCHAR(10) N A character string used to store the valid days of the week.
DAY_STRING VARCHAR(31) N A character string used to store the valid days of the month.
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.
FREQ_PATTERN_CD DOUBLE N A coded identifier for the frequency pattern.
FREQ_PATTERN_MEANING VARCHAR(12) Y A 12-character description corresponding to the frequency pattern.
INFO_SCH_TEXT_ID DOUBLE N The identifier of the information-only text associated with the record.
INTERVAL DOUBLE N Defines the time interval in minutes.
MNEMONIC VARCHAR(100) N 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.
MONTH_STRING VARCHAR(12) N A string used to denote the valid months in a frequency.
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.
PATTERN_OPTION DOUBLE N This field is used to store the frequency option chosen by the user.
REF_FREQ_ID DOUBLE N The unique identifier for the scheduling reference frequency.
UNITS DOUBLE N Units
UNITS_CD DOUBLE N The coded identifier of the units of measure.
UNITS_MEANING VARCHAR(12) Y A 12-character description corresponding to the units of measure.
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.
WEEK_STRING VARCHAR(6) N A character string used to denote the valid weeks within the month.



Relationship Detail - SCH_REF_FREQ


Child Column in SCH_REF_FREQ(FK) Parent Table Name Parent Column Name
Parents: FREQ_PATTERN_CD CODE_VALUE CODE_VALUE
UNITS_CD CODE_VALUE CODE_VALUE
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in SCH_REF_FREQ (PK) Child Table Name Child Column Name
Children: REF_FREQ_ID SCH_FREQ REF_FREQ_ID


SCH_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Report
Definition: Scheduling Report
Table Type: REFERENCE





Column Detail - SCH_REPORT


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.
ADVANCED_IND DOUBLE Y Determines if the inquiry/report is using the advanged inquiry/reporting logic.
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.
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.
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) N 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.
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.
OE_FORMAT_ID DOUBLE N The identifier of the accept format.
POSTSCRIPT_IND DOUBLE N This field is used to determine if the scheduling report is a ASCII or POSTSCRIPT.
PROGRAM_NAME VARCHAR(30) Y The CCL program name to execute.
REPORT_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling report type.
REPORT_RETEN_DAY_CNT DOUBLE N The number of days that a report job is to remain in a completed state before being archived.
REPORT_TYPE_CD DOUBLE N The coded identifier for the scheduling report type.
SCH_REPORT_ID DOUBLE N The unique identifier for the scheduling report.
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_REPORT


Child Column in SCH_REPORT(FK) Parent Table Name Parent Column Name
Parents: REPORT_TYPE_CD CODE_VALUE CODE_VALUE
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
OE_FORMAT_ID ORDER_ENTRY_FORMAT_PARENT OE_FORMAT_ID




Parent Column in SCH_REPORT (PK) Child Table Name Child Column Name
Children: SCH_REPORT_ID EEM_ABN_FORM EEM_REPORT_ID
EEM_PROFILE_REPORT SCH_REPORT_ID
SCH_ACTION_NOTIFY SCH_REPORT_ID
SCH_NOTIFY SCH_REPORT_ID
SCH_ROUTE_LIST SCH_REPORT_ID


SCH_RESOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Resource
Definition: A resource is an item of limited availability whose usage is managed.
Table Type: REFERENCE





Column Detail - SCH_RESOURCE


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.
DESCRIPTION VARCHAR(255) 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.
ITEM_ID DOUBLE N The unique identifier for the inventory item.
ITEM_LOCATION_CD DOUBLE N The location identifier associated with the inventory item type.
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) N 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 A native sort version of the MNEMONIC_KEY FIELD.
MNEMONIC_KEY_NLS VARCHAR(202) Y A native sort version of the MNEMONIC_KEY FIELD. Obsolete column, replaced by MNEMONIC_KEY_A_NLS.
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.
OWNER_ORG_ID DOUBLE N ID of the organization that owns this resource, used to determine unique service names per service providing organization
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the prsnl table. It is an internal system assigned number.
QUOTA DOUBLE N The booking limit.
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
RES_TYPE_FLAG DOUBLE N Determines if the resource is associated external objects (i.e. person, service_resource, etc.) 1 - General Resource, 2 - Personnel Resource, 3- Service Resource
SCH_SERVICE_ID DOUBLE N ** OBSOLETE COLUMN (Parent table is obsolete) ** Foreign key to table SCH_Service (Parent table)
SERVICE_RESOURCE_CD DOUBLE N The generic term used to denote a physical place in the Health Care Organization.
SURGICAL_TYPE_FLAG DOUBLE N The type of surgical resource. 0 - Not a surgeon. 1 indicates the resource is a SURGEON.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_RESOURCE


Child Column in SCH_RESOURCE(FK) Parent Table Name Parent Column Name
Parents: RESOURCE_CD CODE_VALUE CODE_VALUE
ITEM_ID ITEM_DEFINITION ITEM_ID
ITEM_LOCATION_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
OWNER_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PRSNL PERSON_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in SCH_RESOURCE (PK) Child Table Name Child Column Name
Children: RESOURCE_CD MP_AMB_ORG_SAT RESOURCE_CD
SCH_APPT_TYPE GRP_RESOURCE_CD
SCH_CAB_WORKGROUP_RES RESOURCE_CD
SCH_DATE_APPLY RESOURCE_CD
SCH_EVENT_RECUR_ROLE RESOURCE_CD
SCH_EVENT_RECUR_ROLE SERVICE_RESOURCE_CD
SCH_RESOURCE_LOCK RESOURCE_CD