DM_CB_ANSWERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM Conditional Build Answers
Definition: Hold answers and actions for the customized object drop/build process.
Table Type: REFERENCE





Column Detail - DM_CB_ANSWERS


Column Name Type Null? Definition
ACTION VARCHAR(255) Y ACTION FOR THE ANSWER, USUALLY WILL BE THE NAME OF A PROGRAM TO EXECUTE
ACTION_STATUS VARCHAR(30) Y STATUS FOR THE PERFORMED ACTIONS 'COMPLETE','EXECUTE','ERROR'
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.
ANSWER VARCHAR(255) N HOLDS THE ANSWER THE USER CAN SELECT 'Y','N'
ANSWER_NBR DOUBLE N PRIMARY KEY FOR THE DM_CB_ANSWERS TABLE NUMBER
ANSWER_STATUS VARCHAR(10) Y STATUS FOR THE PERFORMED ACTIONS 'COMPLETE','EXECUTE','ERROR'
IGNORE_FIRST_IND DOUBLE N IF SET TO 1, WILL IGNORE THE ACTION THE FIRST TIME THE ANSWER IS SELECTED.
QUESTION_NBR DOUBLE N Question that this row is an answer to.
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 - DM_CB_ANSWERS


Child Column in DM_CB_ANSWERS(FK) Parent Table Name Parent Column Name
Parents: QUESTION_NBR DM_CB_QUESTIONS QUESTION_NBR




Parent Column in DM_CB_ANSWERS (PK) Child Table Name Child Column Name
Children: ANSWER_NBR DM_CB_HISTORY ANSWER_NBR


DM_CB_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM Conditional Build History.
Definition: Holds the history of the actions performed on dm_cb_answers, dm_cb_objects, dm_cb_request_processing, dm_cb_questions.
Table Type: ACTIVITY





Column Detail - DM_CB_HISTORY


Column Name Type Null? Definition
ANSWER_NBR DOUBLE Y ANSWER_NBR FOR ANSWER THAT WAS UPDATED
CHANGE_DT_TM DATETIME N TIME THE ROW WAS INSERTED
CHANGE_PROCESS VARCHAR(30) Y THE PROCESS THAT CHANGED THE ROW.
CHANGE_REASON VARCHAR(30) Y WHY THE ROW WAS CHANGED
COLUMN_NAME VARCHAR(30) N COLUMN_NAME LOGGING HISTORY FOR.
HISTORY_ID DOUBLE N PRIMARY KEY OF DM_CB_HISTORY
NEW_VALUE_DT_TM DATETIME Y New value date/time.
NEW_VALUE_NUM DOUBLE Y New value number.
NEW_VALUE_TXT VARCHAR(255) Y New value text.
OLD_VALUE_DT_TM DATETIME Y Old value date/time.
OLD_VALUE_NUM DOUBLE Y Old value number.
OLD_VALUE_TXT VARCHAR(255) Y Old value text.
QUESTION_NBR DOUBLE Y QUESTION_NUMBER FOR QUESTION THAT WAS UPDATED
REQUEST_NUMBER DOUBLE Y REQUEST NUMBER FOR REQUEST THAT WAS UPDATED
TABLE_NAME VARCHAR(30) N TABLE NAME LOGGING HISTORY FOR.
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 - DM_CB_HISTORY


Child Column in DM_CB_HISTORY(FK) Parent Table Name Parent Column Name
Parents: ANSWER_NBR DM_CB_ANSWERS ANSWER_NBR
QUESTION_NBR DM_CB_QUESTIONS QUESTION_NBR


DM_CB_OBJECTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CM conditional build objects.
Definition: Holds objects to be built or dropped for the customized object drop/build process.
Table Type: REFERENCE





Column Detail - DM_CB_OBJECTS


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.
OBJECT_NAME VARCHAR(30) N Object name.
OBJECT_STATUS VARCHAR(30) Y STATUS OF THE OBJECT 'BUILD','DROP','ERROR'
OBJECT_TYPE VARCHAR(20) N TYPE OF OBJECT (INDEX,TRIGGER,TABLE)
QUESTION_NBR DOUBLE N QUESTION THE OBJECTS REFER TO.
TABLE_NAME VARCHAR(30) N TABLE NAME THE OBJECT RESIDES ON
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 - DM_CB_OBJECTS


Child Column in DM_CB_OBJECTS(FK) Parent Table Name Parent Column Name
Parents: QUESTION_NBR DM_CB_QUESTIONS QUESTION_NBR


DM_CB_QUESTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM conditional build questions.
Definition: Holds questions for the customized object drop/build process.
Table Type: REFERENCE





Column Detail - DM_CB_QUESTIONS


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.
ASK_FLAG DOUBLE N Ask flag
QUESTION VARCHAR(255) N QUESTION TO BE ASKED
QUESTION_NBR DOUBLE N PRIMARY KEY FOR DM_CB_QUESTIONS
QUESTION_ORDER_SEQ DOUBLE N SEQUENCE THE QUESTIONS ARE ASKED IN.
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 - DM_CB_QUESTIONS




Parent Column in DM_CB_QUESTIONS (PK) Child Table Name Child Column Name
Children: QUESTION_NBR DM_CB_ANSWERS QUESTION_NBR
DM_CB_HISTORY QUESTION_NBR
DM_CB_OBJECTS QUESTION_NBR
DM_CB_REQUEST_PROCESSING QUESTION_NBR


DM_CB_REQUEST_PROCESSING



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM conditional build request processing.
Definition: Holds requests to be activated or inactivated for the customized object drop/build process.
Table Type: REFERENCE





Column Detail - DM_CB_REQUEST_PROCESSING


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.
FORMAT_SCRIPT VARCHAR(30) N SCRIPT THE REQUEST WILL EXECUTE
QUESTION_NBR DOUBLE N QUESTION NUMBER THE REQUEST BELONGS TO
REQUEST_NUMBER DOUBLE N NUMBER OF THE REQUEST
REQUEST_STATUS VARCHAR(30) Y STATUS OF THE REQUEST. (ACTIVE,INACTIVE)
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 - DM_CB_REQUEST_PROCESSING


Child Column in DM_CB_REQUEST_PROCESSING(FK) Parent Table Name Parent Column Name
Parents: QUESTION_NBR DM_CB_QUESTIONS QUESTION_NBR