Table Detail Report

SCH_ORG_SECURITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Organization Security
Definition: Sch_org_security is used to store the associations between scheduling objects such as scheduling slot type, schedule resource, scheduling default template and organizations so that we can build the organization security around these scheduling objects.
Table Type: REFERENCE





Column Detail - SCH_ORG_SECURITY


Column Name Type Null? Definition
ORGANIZATION_ID DOUBLE N Identifier of organization which is used to associated to the scheduling objects.
PARENT1_ID DOUBLE N Identifier of parent 1 table.
PARENT1_TABLE VARCHAR(30) N The scheduling table name which we can use to build organization security, currently we are going to support only "SCH_SLOT_TYPE", "SCH_DEF_SCHED", "SCH_RESOURCE", we will expand it to several other tables in our future iterations.
SCH_ORG_SECURITY_ID DOUBLE N The unique primary key of this table. It is internally assigned.
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_ORG_SECURITY


Child Column in SCH_ORG_SECURITY(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


SCH_PREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Preference
Definition: Scheduling Preferences
Table Type: REFERENCE





Column Detail - SCH_PREF


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.
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.
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) Y The parent table corresponding to the PARENT_ID
PREF_DT_TM DATETIME Y A date and time value for the scheduling preference.
PREF_ID DOUBLE N The unique identifier for the scheduling preference.
PREF_STRING VARCHAR(255) Y A string value for a scheduling preference.
PREF_TYPE_CD DOUBLE N The unique identifier for the scheduling preference type.
PREF_TYPE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling preference type.
PREF_UNITS DOUBLE N Units
PREF_UNITS_CD DOUBLE N The unique identifier for the preference units of measure.
PREF_UNITS_MEANING VARCHAR(12) Y A 12-character description corresponding to the preference units of measure.
PREF_VALUE DOUBLE Y A numeric value for a scheduling preference.
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_PREF


Child Column in SCH_PREF(FK) Parent Table Name Parent Column Name
Parents: DATA_TYPE_CD CODE_VALUE CODE_VALUE
PREF_TYPE_CD CODE_VALUE CODE_VALUE
PREF_UNITS_CD CODE_VALUE CODE_VALUE


SCH_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Schedule Queries
Definition: The schedule queries are used to create flexible resource and person inquiries.
Table Type: REFERENCE





Column Detail - SCH_QUERY


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.
DEBUG_IND DOUBLE Y Determines if the scripts should print a debug log.
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.
PROGRAM_NAME VARCHAR(30) Y The CCL program name to execute.
QUERY_MEANING VARCHAR(12) Y A 12-character description corresponding to the inquiry type code.
QUERY_TYPE_CD DOUBLE N A coded identifier for the inquiry type.
SCH_QUERY_ID DOUBLE N The unique identifier for the scheduling inquiry.
TEMPLATE_IND DOUBLE Y Determines if the text template is used solely as a template.
TEXT_ID DOUBLE N The unique identifier used to store the actual test on the LONG_TEXT 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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_QUERY


Child Column in SCH_QUERY(FK) Parent Table Name Parent Column Name
Parents: QUERY_TYPE_CD CODE_VALUE CODE_VALUE
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


SCH_QUOTA



Column Section Top of Page


Table-level Detail

Description: Scheduling quota
Definition: Scheduling quota data
Table Type: REFERENCE





Column Detail - SCH_QUOTA


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.
BEG_TM DOUBLE N Defines the standard start time.
DATA1_SOURCE_CD DOUBLE N A coded identifier for the scheduling data source.
DATA1_SOURCE_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling data source.
DATA2_SOURCE_CD DOUBLE N A coded identifier for the scheduling data source.
DATA2_SOURCE_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling data source.
DATA3_SOURCE_CD DOUBLE N A coded identifier for the scheduling data source.
DATA3_SOURCE_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling data source.
DAYS_OF_WEEK VARCHAR(7) Y A character string used to store the valid days of the week.
DISPLAY1_ID DOUBLE N The unique identifier of the display object.
DISPLAY1_MEANING VARCHAR(12) Y A 12-character description corresponding to the DISPLAY_ID1
DISPLAY1_TABLE VARCHAR(32) Y The parent table corresponding to the DISPLAY_ID1
DISPLAY2_ID DOUBLE N The unique identifier of the display object.
DISPLAY2_MEANING VARCHAR(12) Y A 12-character description corresponding to the DISPLAY_ID2
DISPLAY2_TABLE VARCHAR(32) Y The parent table corresponding to the DISPLAY_ID2
DISPLAY3_ID DOUBLE N The unique identifier of the display object.
DISPLAY3_MEANING VARCHAR(12) Y A 12-character description corresponding to the DISPLAY_ID3
DISPLAY3_TABLE VARCHAR(32) Y The parent table corresponding to the DISPLAY_ID3
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.
END_TM DOUBLE N Defines the standard ending time.
OVERBOOK_LIMIT DOUBLE N Overbook limit
PARENT1_ID DOUBLE N The unique identifier of the parent object.
PARENT1_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT1_ID
PARENT1_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT1_ID
PARENT2_ID DOUBLE N The unique identifier of the parent object.
PARENT2_MEANING VARCHAR(12) Y Parent2 Meaning
PARENT2_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT2_ID
PARENT3_ID DOUBLE N The unique identifier of the parent object.
PARENT3_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT3_ID
PARENT3_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT3_ID
QUOTA_LIMIT DOUBLE N quota limit
QUOTA_TYPE_CD DOUBLE N quota type code
QUOTA_TYPE_MEANING VARCHAR(12) N quota type meaning
QUOTA_TZ DOUBLE N quota time zone
SCH_QUOTA_ID DOUBLE N Scheduling quota identifier
TIME_RESTR_CD DOUBLE N Time restriction code - AM, PM only etc, from code set 16153
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.


SCH_QUOTA_DATA



Column Section Top of Page


Table-level Detail

Description: Scheduling quota data
Definition: Scheduling quota data
Table Type: REFERENCE





Column Detail - SCH_QUOTA_DATA


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.
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 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.
EXPLODE_SCRIPT_NAME VARCHAR(30) Y The CCL program name to execute to explode a group.
QUOTA_TYPE_CD DOUBLE N quota type code
QUOTA_TYPE_MEANING VARCHAR(12) Y quota type meaning
SCRIPT_NAME VARCHAR(30) Y The CCL name of the program to execute.
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.
VIEW_SEQ_NBR DOUBLE N Determines the order of the data source within the security tool.
VIEW_SOURCE_CD DOUBLE N A coded identifier for the view data source.
VIEW_SOURCE_MEANING VARCHAR(12) Y A 12-character description corresponding to the view data source.
VIEW_TYPE_CD DOUBLE N A coded identifier for the view type.
VIEW_TYPE_MEANING VARCHAR(12) Y A 12-character description corresponding to the view type.