DAC_CCL_SCRIPT_TEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Access CCL Script Test
Definition: Storage of the test scripts associated with the automated testing harness framework.
Table Type: REFERENCE





Column Detail - DAC_CCL_SCRIPT_TEST


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.
CCL_SCRIPT_NAME VARCHAR(31) N The script to be tested by the testing architecture
CCL_SCRIPT_TEST_ID DOUBLE N The primary key of the table
CCL_TEST_SCRIPT_NAME VARCHAR(31) N The name of the test script that tests the script specified in CCL_SCRIPT_NAME
PARENT_TEST_ID DOUBLE N The ID of the test that should precede this test, if any.
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 - DAC_CCL_SCRIPT_TEST


Child Column in DAC_CCL_SCRIPT_TEST(FK) Parent Table Name Parent Column Name
Parents: PARENT_TEST_ID DAC_CCL_SCRIPT_TEST CCL_SCRIPT_TEST_ID




Parent Column in DAC_CCL_SCRIPT_TEST (PK) Child Table Name Child Column Name
Children: CCL_SCRIPT_TEST_ID DAC_CCL_SCRIPT_TEST PARENT_TEST_ID
DAC_CCL_SCRIPT_TEST_STATUS CCL_SCRIPT_TEST_ID


DAC_CCL_SCRIPT_TEST_RUN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DAC_CCL_SCRIPT_TEST_RUN
Definition: Storage of a run of a specific test set
Table Type: ACTIVITY





Column Detail - DAC_CCL_SCRIPT_TEST_RUN


Column Name Type Null? Definition
CCL_SCRIPT_TEST_RUN_ID DOUBLE N The primary key of the table
END_DT_TM DATETIME N The date and time at which the test run ended
START_DT_TM DATETIME N The date and time at which the test run started
TESTER_USERNAME VARCHAR(31) N The username of the user who ran the test
TEST_RUN_MESSAGE VARCHAR(500) Y The message, if any, that was reported by the test run
TEST_RUN_SCRIPT VARCHAR(31) Y The name of the script, as specified by the user, that was tested. This will be NULL if nothing was specified.
TEST_RUN_STATUS VARCHAR(10) N The status of the entire test set.
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 - DAC_CCL_SCRIPT_TEST_RUN




Parent Column in DAC_CCL_SCRIPT_TEST_RUN (PK) Child Table Name Child Column Name
Children: CCL_SCRIPT_TEST_RUN_ID DAC_CCL_SCRIPT_TEST_STATUS CCL_SCRIPT_TEST_RUN_ID


DAC_CCL_SCRIPT_TEST_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DAC_CCL_SCRIPT_TEST_STATUS
Definition: Storage of the status of a specific test within a specific run
Table Type: ACTIVITY





Column Detail - DAC_CCL_SCRIPT_TEST_STATUS


Column Name Type Null? Definition
CCL_SCRIPT_TEST_ID DOUBLE N A reference to the test for which this is a run
CCL_SCRIPT_TEST_RUN_ID DOUBLE N A reference to the record of which run this test is associated with
CCL_SCRIPT_TEST_STATUS_ID DOUBLE N Primary key of the table
END_DT_TM DATETIME N The date and time at which the test ended
START_DT_TM DATETIME N The date and time at which the test started
TEST_MESSAGE VARCHAR(500) Y The message (if any) recorded at the conclusion or mid-execution of a test
TEST_STATUS VARCHAR(10) N The status of the specific test
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 - DAC_CCL_SCRIPT_TEST_STATUS


Child Column in DAC_CCL_SCRIPT_TEST_STATUS(FK) Parent Table Name Parent Column Name
Parents: CCL_SCRIPT_TEST_ID DAC_CCL_SCRIPT_TEST CCL_SCRIPT_TEST_ID
CCL_SCRIPT_TEST_RUN_ID DAC_CCL_SCRIPT_TEST_RUN CCL_SCRIPT_TEST_RUN_ID


DAC_INDEX_COALESCE_LOG



Column Section Top of Page


Table-level Detail

Description: DAC_INDEX_COALESCE_LOG
Definition: Logging table for DM2_ROUTINE_TASKS Index Coalesce Operations
Table Type: ACTIVITY





Column Detail - DAC_INDEX_COALESCE_LOG


Column Name Type Null? Definition
COALESCE_LOG_ID DOUBLE N Primary Key Column for the table, populated by DAC_LOGGING_SEQ.
END_DT_TM DATETIME Y Ending time of the coalesce task.
INDEX_NAME VARCHAR(50) N Name of the Index which was coalesced.
START_DT_TM DATETIME Y Starting time of the coalesce task.
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.


DM_CORE_EOD_SI



Column Section Top of Page


Table-level Detail

Description: DM_CORE_EOD_SI
Definition: Store the disassembled versions of the End of Downtime Special Instructions text.
Table Type: REFERENCE





Column Detail - DM_CORE_EOD_SI


Column Name Type Null? Definition
CORE_EOD_SI_ID DOUBLE N Primary Key for the table
INSTRUCTION_TXT VARCHAR(255) N The text containing a single line of Special Instructions
LINE_NUMBER DOUBLE N Identifies the Line Number in the Special Instructions file for ordering
OS_VERSION_NAME VARCHAR(10) N Name of the OS Version for the files
SI_RELEASE_IDENT DOUBLE N Identifier for a set of Special Instructions. Internally generated number (not from a sequence)
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_NUMBER DOUBLE N Track versions of a given set of special instructions