The Auxillary model and their associated tables are used
to design reports.
BOOLEAN
This table depicts the list of data
types that indicates a Yes or No value.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
boolean_id |
NUMBER(19,0) |
N |
The boolean values are used extensively across the application
to answer the questions such as Is it primary party? Is the term used
in language? |
| 2 |
ecm_boolean_ value |
VARCHAR2(10) |
Y |
Unique identification in the contracts database. |
BOOLEAN_i18n
This table depicts translations
for the words Yes and No.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
boolean_id |
NUMBER(19,0) |
N |
|
| 2 |
locale |
VARCHAR2(32) |
N |
This column identifies the specific language in which the data
is presented. For example: English, Japanese, and so forth. |
| 3 |
local_ boolean_text |
VARCHAR2(40) |
Y |
This column is the translated value of the words, Yes, and
No. |
APP_VARIABLES
This table contains configuration
information from the contract applications.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
var_name |
VARCHAR2 (800) |
N |
|
| 2 |
var_value |
VARCHAR2 (800) |
Y |
|