Table Detail Report
SCH_FLEX_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Flex String List |
Definition: | Scheduling Flex String List |
Table Type: | REFERENCE |
Column Detail - SCH_FLEX_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. |
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. |
BOLD | DOUBLE | N | The numeric equivilent of the bold value. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DATA_SOURCE_CD | DOUBLE | N | A coded identifier for the scheduling data source. |
DATA_SOURCE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling data source. |
DATA_TYPE_CD | DOUBLE | N | A coded identifier for the scheduling date type. |
DATA_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling data type. |
DISPLAY_ID | DOUBLE | N | The unique identifier of the display object. |
DISPLAY_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the DISPLAY_ID |
DISPLAY_TABLE | VARCHAR(32) | Y | The parent table corresponding to the DISPLAY_ID |
DOUBLE_VALUE | DOUBLE | Y | Numeric Value |
DT_TM_VALUE | DATETIME | Y | Date and Time Value |
DYNAMIC_TEXT | VARCHAR(255) | Y | Dynamic Text |
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. |
FILTER_ID | DOUBLE | N | Contains the unique identifier to the qualifier from the FILTER table. |
FILTER_TABLE | VARCHAR(30) | Y | This field hold the table name of the qualifying attribute |
FLEX_EVAL_CD | DOUBLE | N | A coded identifier for the flexing evaluation. |
FLEX_EVAL_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the flexing evaluation. |
FLEX_ORIENT_CD | DOUBLE | N | A coded identifier for the flexing orientation type. (INFIX and POSTFIX). |
FLEX_ORIENT_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the flexing orientation type. |
FLEX_TOKEN_CD | DOUBLE | N | A coded identifier for the flexing token. |
FLEX_TOKEN_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the flexing token. |
FONT_NAME | VARCHAR(32) | Y | A string used to represent the font name. |
FONT_SIZE | DOUBLE | N | The numeric equilivant of the font size. |
ITALIC | DOUBLE | N | A numeric equivilent of the italic value. |
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_ID | DOUBLE | N | The unique identifier for the order entry field. |
OFFSET_UNITS | DOUBLE | N | Scheduling Offset Units |
OFFSET_UNITS_CD | DOUBLE | N | The coded identifier for the offset units of measure. |
OFFSET_UNITS_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the offset units of measure |
PARENT_ID | DOUBLE | N | The unique identifier of the parent object. |
PARENT_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the PARENT_ID |
PARENT_TABLE | VARCHAR(30) | Y | The parent table corresponding to the PARENT_ID |
PRECEDENCE | DOUBLE | N | Determines the order of the token within the evaluation process. |
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. |
STRIKETHRU | DOUBLE | N | The numeric equilivant of the strikethru value. |
STRING_VALUE | VARCHAR(255) | Y | Alphanumeric Value. |
TOKEN_TYPE_CD | DOUBLE | N | A coded identifier for the type of scheduling token (operator, operand, etc.) |
TOKEN_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling token type. |
UNDERLINE | DOUBLE | N | The numeric equilivant of the underline value. |
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_FLEX_LIST
Child Column in SCH_FLEX_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DATA_SOURCE_CD | CODE_VALUE | CODE_VALUE |
DATA_TYPE_CD | CODE_VALUE | CODE_VALUE | |
FLEX_EVAL_CD | CODE_VALUE | CODE_VALUE | |
FLEX_ORIENT_CD | CODE_VALUE | CODE_VALUE | |
FLEX_TOKEN_CD | CODE_VALUE | CODE_VALUE | |
OFFSET_UNITS_CD | CODE_VALUE | CODE_VALUE | |
TOKEN_TYPE_CD | CODE_VALUE | CODE_VALUE | |
OE_FIELD_ID | ORDER_ENTRY_FIELDS | OE_FIELD_ID | |
SCH_FLEX_ID | SCH_FLEX_STRING | SCH_FLEX_ID |
SCH_FLEX_STRING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Flex String |
Definition: | Scheduling Flex String |
Table Type: | REFERENCE |
Column Detail - SCH_FLEX_STRING
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(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. |
FLEX_TYPE_CD | DOUBLE | N | A coded identifier for the flexing type. |
FLEX_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the flexing type. |
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. |
SCH_FLEX_ID | DOUBLE | N | The unique identifier for the scheduling flex string. |
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_FLEX_STRING
Child Column in SCH_FLEX_STRING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FLEX_TYPE_CD | CODE_VALUE | CODE_VALUE |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
Parent Column in SCH_FLEX_STRING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCH_FLEX_ID | ENCNTR_SLICE_REFERENCE | SCH_FLEX_ID |
PFT_RULESET_FLEX_RELTN | SCH_FLEX_ID | ||
PM_POST_DOC_REF | SCH_FLEX_ID | ||
PRSNL_GROUP_POOL | SCH_FLEX_ID | ||
PRSNL_GROUP_POOL_ROUTING_R | SCH_FLEX_ID | ||
SCH_ACTION_NOTIFY | SCH_FLEX_ID | ||
SCH_APPT_ACTION | SCH_FLEX_ID | ||
SCH_APPT_DEF | SCH_FLEX_ID | ||
SCH_APPT_LOC | SCH_FLEX_ID | ||
SCH_APPT_NOTIFY | SCH_FLEX_ID | ||
SCH_APPT_ROUTING | SCH_FLEX_ID | ||
SCH_DEF_SLOT | SCH_FLEX_ID | ||
SCH_FLEX_LIST | SCH_FLEX_ID | ||
SCH_LIST_RES | SCH_FLEX_ID | ||
SCH_LIST_ROLE | SCH_FLEX_ID | ||
SCH_LIST_SLOT | SCH_FLEX_ID | ||
SCH_ORDER_APPT | SCH_FLEX_ID | ||
SCH_ORDER_DURATION | SCH_FLEX_ID | ||
SCH_ORDER_ROLE | SCH_FLEX_ID | ||
SCH_SLOT_TYPE | SCH_FLEX_ID | ||
SCH_SUB_LIST | SCH_FLEX_ID | ||
SN_SURG_CASE_ST | SCH_FLEX_ID |
SCH_FLEX_TOKEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Flexing Tokens |
Definition: | Scheduling Flexing Token |
Table Type: | REFERENCE |
Column Detail - SCH_FLEX_TOKEN
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. |
BOLD | DOUBLE | N | The numeric equivilent of the bold value. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DATA_SOURCE_CD | DOUBLE | N | A coded identifier for the scheduling data source. |
DATA_SOURCE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling data source. |
DATA_TYPE_CD | DOUBLE | N | A coded identifier for the scheduling date type. |
DATA_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling data type. |
DESCRIPTION | VARCHAR(200) | Y | A long description used for documentation. |
DYNAMIC_TEXT | VARCHAR(255) | Y | Dynamic Text |
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. |
FLEX_EVAL_CD | DOUBLE | N | A coded identifier for the flexing evaluation. |
FLEX_EVAL_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the flexing evaluation. |
FLEX_TOKEN_CD | DOUBLE | N | A coded identifier for the flexing token. |
FLEX_TOKEN_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the flexing token. |
FONT_NAME | VARCHAR(32) | Y | A string used to represent the font name. |
FONT_SIZE | DOUBLE | N | The numeric equilivant of the font size. |
INFO_SCH_TEXT_ID | DOUBLE | N | The identifier of the information-only text associated with the record. |
ITALIC | DOUBLE | N | A numeric equivilent of the italic value. |
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. |
PRECEDENCE | DOUBLE | N | Determines the order of the token within the evaluation process. |
STRIKETHRU | DOUBLE | N | The numeric equilivant of the strikethru value. |
TOKEN_TYPE_CD | DOUBLE | N | A coded identifier for the type of scheduling token (operator, operand, etc.) |
TOKEN_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling token type. |
UNDERLINE | DOUBLE | N | The numeric equilivant of the underline value. |
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_FLEX_TOKEN
Child Column in SCH_FLEX_TOKEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DATA_SOURCE_CD | CODE_VALUE | CODE_VALUE |
DATA_TYPE_CD | CODE_VALUE | CODE_VALUE | |
FLEX_EVAL_CD | CODE_VALUE | CODE_VALUE | |
TOKEN_TYPE_CD | CODE_VALUE | CODE_VALUE | |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
SCH_INSTR_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduoling Instruction List |
Definition: | Scheduling Instruction List |
Table Type: | REFERENCE |
Column Detail - SCH_INSTR_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. |
BEG_DT_TM | VARCHAR(20) | Y | Begin Date and Time value |
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. |
BOOK_INSTR_ID | DOUBLE | N | The unique identifier for the scheduling instruction. |
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. |
FUTURE_IND | DOUBLE | Y | Denotes if the order's future indicator should be set to yes or no. |
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. |
PRIORITY_CD | DOUBLE | N | The coded identifier for the order priority code. |
PRIORITY_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the order priority 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_INSTR_LIST
Child Column in SCH_INSTR_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRIORITY_CD | CODE_VALUE | CODE_VALUE |
BOOK_INSTR_ID | SCH_BOOK_INSTR | BOOK_INSTR_ID |
SCH_JAVA_CONV
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Java Conversation |
Definition: | Table used to store information regarding the Java conversations configured in SchTools. |
Table Type: | REFERENCE |
Column Detail - SCH_JAVA_CONV
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. |
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. |
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. |
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. |
SCH_CONV_ACTION_TYPE_CD | DOUBLE | N | Unique number that identifies the Java conversation action type. |
SCH_JAVA_CONV_ID | DOUBLE | N | Unique generated number that identifies a single row on the SCH_JAVA_CONV table. |
SCH_JAVA_CONV_IDENT | VARCHAR(255) | N | Unique identifier that is mapped to a Java conversation. It is created using the "Conversations & Rules" segment in Revenue Cycle Maintanence tool. |
SCH_JAVA_CONV_NAME | VARCHAR(500) | N | Name of the Java conversation mapped to an identifier. It is created using the "Conversations & Rules" segment in Revenue Cycle Maintanence tool. |
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.. Version Date time defaulted to 12/31/2100. |
Relationship Detail - SCH_JAVA_CONV
Child Column in SCH_JAVA_CONV(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |