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 |