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 |