The Contracts model and their associated tables are used
to design reports.
CONTRACT
This table depicts contract instances,
including some of their properties.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_id |
NUMBER(19,0) |
N |
|
| 2 |
ecm_contract_id |
VARCHAR2(128) |
Y |
Unique identification number in the transactional contracts
database to identify each contract. |
| 3 |
contract_revision |
INTEGER |
Y |
|
| 4 |
contract_name |
VARCHAR2(1600) |
Y |
Name of a contract. |
| 5 |
contract_title |
VARCHAR2(4000) |
Y |
|
| 6 |
contract_number |
DECIMAL(31,10) |
Y |
|
| 7 |
contract_version |
DECIMAL(31,3) |
Y |
|
| 8 |
contract_url |
VARCHAR2(2000) |
Y |
|
| 9 |
notes |
VARCHAR2(1000) |
Y |
|
CONTRACT_CLASS
This table depicts the list
of contract classes that are defined in the system.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_class_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ class_name |
VARCHAR2(600) |
N |
|
CONTRACT_ORIGIN_VARIANT
This table depicts
the list of contract origins.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_origin_ variant_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_origin_ variant_name |
VARCHAR2(200) |
Y |
|
CONTRACT_ORIGIN
This table depicts the list
of the contracts by their origin.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ origin_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ origin_text |
VARCHAR2(128) |
Y |
|
CONTRACT_ORIGIN_I18N
This table depicts the
translations for the contracts by their origin.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
CONTRACT_ ORIGIN_ID |
NUMBER(19) |
N |
|
| 2 |
LOCALE |
VARCHAR2 (32) |
N |
|
| 3 |
LOCAL_ CONTRACT_ ORIGIN_TEXT |
VARCHAR2 (2000) |
Y |
|
CONTRACT_CATEGORY_i18n
This table depicts the translations for the contract
categories that are defined in the system.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ category_id |
NUMBER(19,0) |
N |
|
| 2 |
locale |
VARCHAR2(32) |
N |
|
| 3 |
local_ category_name |
VARCHAR2(4000) |
Y |
|
CONTRACT_STATUS_i18n
This table depicts translations
for contract status.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ status_id |
NUMBER(19,0) |
N |
|
| 2 |
locale |
VARCHAR2(32) |
N |
|
| 3 |
local_status_ name |
VARCHAR2(2000) |
Y |
|
CONTRACT_CATEGORY
This table depicts the list
of contract categories that are defined in the system.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ category_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ category_name |
VARCHAR2(32) |
Y |
|
CONTRACT_STATUS
This table depicts the list
of status for contract.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ status_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ status_name |
VARCHAR2(32) |
N |
|
CONTRACT_STATE
This table depicts the list
of states that are associated with contracts.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ state_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ state_name |
VARCHAR2(32) |
Y |
|
EXECUTION_TYPE
This table depicts the list
of contract execution types such as E-signed, Ink-singed, or Record-signed
contract.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
execution_ type_id |
NUMBER(19,0) |
N |
|
| 2 |
execution_ type_name |
VARCHAR2(4000) |
Y |
|
TERMINATION_REASON
This table depicts the
list of contract termination reason codes.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
termination_ reason_id |
NUMBER(19,0) |
N |
|
| 2 |
termination_ reason_code |
VARCHAR2(450) |
Y |
|
NEGOTIATION_STATUS
This table depicts the
list of status of an Authored Contract or Authored Amendment Contract
after it is presented to the External Party, before it is Executed.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
negotiation_ status_id |
NUMBER(19,0) |
N |
|
| 2 |
negotiation_ status_text |
VARCHAR2(64) |
Y |
|
APPROVAL_STATUS
This table depicts the list
of approval status at the clause or contract level.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
approval_ status_id |
NUMBER(19,0) |
N |
|
| 2 |
approval_ status_text |
VARCHAR2(64) |
Y |
|
INTERVIEW
This table depicts the list of interview
forms to create contracts.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
interview_id |
NUMBER(19,0) |
N |
|
| 2 |
interview_name |
VARCHAR2(1200) |
Y |
|
INTERVIEW_TEMPLATE
This table depicts the list
of interview templates that can be used to create contracts.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
interview_ template_id |
NUMBER(19,0) |
N |
|
| 2 |
interview_ template_name |
VARCHAR2(1200) |
Y |
|
REGION
This table depicts the list of geographical
regions available.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
region_id |
NUMBER(19,0) |
N |
|
| 2 |
region_name |
VARCHAR2(600) |
Y |
|
CURRENCY
This table depicts the list of currencies.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
currency_id |
NUMBER(19,0) |
N |
|
| 2 |
currency_code |
VARCHAR2(3) |
Y |
|
| 3 |
currency_name |
VARCHAR2(600) |
Y |
|
| 4 |
currency_symbol |
VARCHAR2(30) |
Y |
|
| 5 |
precision |
NUMBER(38,0) |
Y |
|
CONTRACT_NATURE
This table depicts the list
of the contracts by its nature. You can choose the contract nature
from the list - Null, Local, or Global.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ nature_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ nature_name |
VARCHAR2(160) |
Y |
|
CONTRACT_FACT
This table contains the facts
about the contracts such as class, status, dates, origin, creator.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ template_id |
NUMBER(19,0) |
N |
|
| 3 |
created_from_ contract_id |
NUMBER(19,0) |
Y |
|
| 4 |
contract_class_id |
NUMBER(19,0) |
N |
|
| 5 |
contract_ category_id |
NUMBER(19,0) |
N |
|
| 6 |
contract_status_id |
NUMBER(19,0) |
N |
|
| 7 |
contract_ substatus_id |
NUMBER(19,0) |
N |
|
| 8 |
contract_ nature_id |
NUMBER(19,0) |
N |
|
| 9 |
currency_id |
NUMBER(19,0) |
N |
|
| 10 |
contract_ origin_id |
NUMBER(19,0) |
N |
|
| 11 |
contract_state_id |
NUMBER(19,0) |
N |
|
| 12 |
region_id |
NUMBER(19,0) |
N |
|
| 13 |
contract_ origin_variant_id |
NUMBER(19,0) |
N |
|
| 14 |
contract_ timezone_id |
NUMBER(19,0) |
N |
|
| 15 |
execution_ type_id |
NUMBER(19,0) |
N |
|
| 16 |
termination_ reason_id |
NUMBER(19,0) |
N |
|
| 17 |
created_on_ date_time_id |
NUMBER(19,0) |
N |
|
| 18 |
last_modified_ on_date_id |
NUMBER(19,0) |
N |
|
| 19 |
eff_start_ date_time_id |
NUMBER(19,0) |
N |
|
| 20 |
eff_end_ date_time_id |
NUMBER(19,0) |
N |
|
| 21 |
converted_on_ date_time_i |
NUMBER(19,0) |
N |
|
| 22 |
execution_ date_time_id |
NUMBER(19,0) |
N |
|
| 23 |
termination_ date_time_id |
NUMBER(19,0) |
N |
|
| 24 |
deletion_date_ time_id |
NUMBER(19,0) |
N |
|
| 25 |
internal_ primary_org_id |
NUMBER(19,0) |
N |
|
| 26 |
internal_primary_ contr_org_id |
NUMBER(19,0) |
N |
|
| 27 |
external_ primary_org_id |
NUMBER(19,0) |
N |
|
| 28 |
external_primary_ contr_org_id |
NUMBER(19,0) |
N |
|
| 29 |
owning_ organization_id |
NUMBER(19,0) |
N |
|
| 30 |
contracting_ org_id |
NUMBER(19,0) |
N |
|
| 31 |
internal_primary_ indv_id |
NUMBER(19,0) |
N |
|
| 32 |
external_primary_ indv_id |
NUMBER(19,0) |
N |
|
| 33 |
negotiation_ status_id |
NUMBER(19,0) |
N |
|
| 34 |
approval_ status_id |
NUMBER(19,0) |
N |
|
| 35 |
is_amended_ boolean_id |
NUMBER(19,0) |
N |
|
| 36 |
created_by_ indv_id |
NUMBER(19,0) |
N |
|
| 37 |
last_modified_ by_indv_id |
NUMBER(19,0) |
N |
|
| 38 |
interview_id |
NUMBER(19,0) |
N |
|
| 39 |
interview_ template_id |
NUMBER(19,0) |
N |
|
| 40 |
converted_ by_indv_id |
NUMBER(19,0) |
N |
|
| 41 |
contract_ approval_ compl_boolid |
NUMBER(19,0) |
N |
|
| 42 |
total_cost |
DECIMAL(31,10) |
N |
|
| 43 |
num_contracts |
SMALLINT |
N |
|
| 44 |
draft_duration |
NUMBER(19,0) |
N |
|
| 45 |
approval_ duration |
NUMBER(19,0) |
N |
|
| 46 |
clause_approval_ duration |
NUMBER(19,0) |
N |
|
| 47 |
contract_ approval_ duration |
NUMBER(19,0) |
N |
|
| 48 |
internal_ negotiation_ duration |
NUMBER(19,0) |
N |
|
| 49 |
external_ negotiation_ duration |
NUMBER(19,0) |
N |
|
| 50 |
creation_to_ exec_duration |
NUMBER(19,0) |
N |
|
| 51 |
num_contract_ apprv_processes |
NUMBER(19,0) |
N |
|
| 52 |
num_clause_ apprv_processes |
NUMBER(19,0) |
N |
|
| 53 |
num_external_ negotiations |
NUMBER(19,0) |
N |
|
| 54 |
is_created_ from_template |
NUMBER(19,3) |
N |
|