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