The Contract Templates model and their associated tables
are used to design reports.
CONTRACT_TEMPLATE
This table depicts the list
of contracts for each template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19,0) |
N |
|
| 2 |
ecm_contract_id |
VARCHAR2(128) |
Y |
|
| 3 |
contract_ template_revision |
NUMBER(19,0) |
Y |
|
| 4 |
contract_ template_name |
VARCHAR2(1600) |
Y |
|
| 5 |
contract_ template_title |
VARCHAR2(1600) |
Y |
|
| 6 |
contract_ template_url |
VARCHAR2(1024) |
Y |
|
| 7 |
template_ guideline_text |
VARCHAR2(1600) |
Y |
|
| 8 |
notes |
VARCHAR2(1600) |
Y |
|
CONTRACT_TEMPLATE_STATUS
This table depicts
the list of status for each contract template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_ status_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ template_ status_name |
VARCHAR2(32) |
Y |
|
CONTRACT_TEMPLATE_STATUS_i18n
This table depicts
the translations for the list of status for each contract template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_ status_id |
NUMBER(19,0) |
N |
|
| 2 |
locale |
VARCHAR2(32) |
N |
|
| 3 |
local_cont_ tmplt_ status_name |
VARCHAR2(100) |
Y |
|
CONTRACT_TEMPLATE_FACT
This table contains
the facts about the contract templates such as category, class, creator,
dates, status.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19,0) |
N |
|
| 2 |
contract_ category_id |
NUMBER(19,0) |
N |
|
| 3 |
contract_class_id |
NUMBER(19,0) |
Y |
|
| 4 |
eff_start_ date_time_id |
NUMBER(19,0) |
N |
|
| 5 |
eff_end_ date_time_id |
NUMBER(19,0) |
N |
|
| 6 |
created_on_ date_time_id |
NUMBER(19,0) |
N |
|
| 7 |
last_modified_ on_date_time_id |
NUMBER(19,0) |
N |
|
| 8 |
created_by_ indv_id |
NUMBER(19,0) |
N |
|
| 9 |
last_modified_ by_indv_id |
NUMBER(19,0) |
N |
|
| 10 |
contract_ template_ status_id |
NUMBER(19,0) |
N |
|
| 11 |
num_templates |
NUMBER(19,0) |
N |
|
| 12 |
delete_offset_ unit_id |
NUMBER(19,0) |
Y |
|
| 13 |
delete_offset_ value |
VARCHAR2(400) |
Y |
|
| 14 |
default_ negotiability |
VARCHAR2(128) |
Y |
|
| 15 |
content_ language_id |
VARCHAR2(20) |
Y |
|
CONTRACT_TEMPLATE_TERM
This table depicts
the terms included in each contract template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19) |
N |
|
| 2 |
term_ mandatory_for_id |
NUMBER(19) |
Y |
|
| 3 |
term_id |
NUMBER(19) |
N |
|
| 4 |
is_system_ term_boolean_id |
NUMBER(19) |
Y |
|
| 5 |
is_currency_ boolean_id |
NUMBER(19) |
Y |
|
| 6 |
exists_inlang_ boolean_id |
NUMBER(19) |
Y |
|
| 7 |
term_group_name |
VARCHAR2(960) |
Y |
|
CONTRACT_TEMPLATE_SECURITY
This table depicts
the security that is defined at the contract template level.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19) |
N |
|
| 2 |
permission_id |
NUMBER(19) |
N |
|
| 3 |
suite_user_id |
NUMBER(19) |
N |
|
| 4 |
is_from_ind_ boolean_id |
NUMBER(19) |
Y |
|
| 5 |
is_from_grp_ boolean_id |
NUMBER(19) |
Y |
|
| 6 |
num_users_ with_access |
NUMBER(19) |
Y |
|
| 7 |
user_group_id |
NUMBER(19) |
Y |
|
CONTRACT_TEMPLATE_ORG
This table depicts the
list of organizations that are associated with each contract template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19) |
N |
|
| 2 |
organization_id |
NUMBER(19) |
N |
|
CONTRACT_TEMPLATE_FOLDERS
This table depicts
the folders that are associated with each contract template.
| Cel No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19) |
N |
|
| 2 |
folder_id |
NUMBER(19) |
N |
|
CONTRACT_TEMPLATE_CLAUSE
This table depicts
the clauses and their sequence that is associated with each contract
template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19) |
N |
|
| 2 |
clause_ template_id |
NUMBER(19) |
N |
|
| 3 |
sequence |
NUMBER(10) |
Y |
|
CONTRACT_TEMPLATE_APPROVAL
This table depicts
the list of users or groups that are defined in the approval chain
for each contract template.
| Cel No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_id |
NUMBER(19) |
N |
|
| 2 |
suite_user_id |
NUMBER(19) |
Y |
|
| 3 |
user_group_id |
NUMBER(19) |
Y |
|
| 4 |
approval_ sequence |
NUMBER(19) |
Y |
|
| 5 |
contract_ organization_type |
VARCHAR2(20) |
Y |
|
| 6 |
include_parent_ organization |
NUMBER(19) |
Y |
|
| 7 |
num_approvals |
NUMBER(19,0) |
Y |
|
CONTRACT_TEMPLATE_EVENT
This table depicts
the events that are defined for each contract template.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_ event_id |
NUMBER(19) |
N |
Unique identification number in the transactional contracts
database to identify each contract template event. |
| 2 |
ecm_contract_ templ_event_id |
CHAR(18) |
Y |
|
| 3 |
description |
VARCHAR2(1600) |
Y |
|
| 4 |
event_name |
VARCHAR2(600) |
Y |
|
| 5 |
review_task_ comment |
VARCHAR2(4000) |
Y |
|
| 6 |
related_contract_ comment |
VARCHAR2(4000) |
Y |
|
| 7 |
notification_offset |
NUMBER(10) |
Y |
|
| 8 |
notification_ offset_unit |
VARCHAR2(40) |
Y |
|
| 9 |
notification_ offset_type |
VARCHAR2(40) |
Y |
|
| 10 |
notification_send_ date_time_id |
NUMBER(19) |
Y |
|
| 11 |
pattern_offset |
NUMBER(10) |
Y |
|
| 12 |
pattern_ offset_unit |
VARCHAR2(30) |
Y |
|
| 13 |
recurrence_ end_offset |
NUMBER(10) |
Y |
|
| 14 |
recurrence_ end_offset_unit |
NUMBER(10) |
Y |
|
| 15 |
recurrence_ end_date_time_id |
NUMBER(19) |
Y |
|
CONTRACT_TEMPLATE_EV_REVTASK
This table depicts
the user groups, associated users, and clause templates that are defined
for each event of contract templates.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
contract_ template_ event_id |
NUMBER(19) |
N |
|
| 2 |
clause_ template_id |
NUMBER(19) |
Y |
|
| 3 |
suite_user_id |
NUMBER(19) |
Y |
|
| 4 |
user_group_id |
NUMBER(19) |
Y |
|
CONTRACT_TEMPLATE_EV_FACT
This table contains
the facts about the contract template events, including the type of
event, the creator, dates, and so forth.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
event_offset_ type_id |
NUMBER(19) |
Y |
|
| 2 |
event_offset_ unit_id |
NUMBER(19) |
Y |
|
| 3 |
event_offset |
NUMBER(19) |
Y |
|
| 4 |
event_type_id |
NUMBER(19) |
Y |
|
| 5 |
is_recurrence_ enabled |
NUMBER(19) |
Y |
|
| 6 |
is_notification_ enabled |
NUMBER(19) |
Y |
|
| 7 |
event_date_ property_id |
NUMBER(19) |
Y |
|
| 8 |
term_id |
NUMBER(19) |
Y |
|
| 9 |
is_request_ review_enabled |
NUMBER(19) |
Y |
|
| 10 |
is_create_ contract_enabled |
NUMBER(19) |
Y |
|
| 11 |
contract_ template_ event_id |
NUMBER(19) |
N |
|
| 12 |
contract_ template_id |
NUMBER(19) |
Y |
|
CONTRACT_TEMPLATE_APP
This table depicts the
list of suitable values for a contract template such as authored contract,
received contract, or filed contract.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
APPLICABILITY_ ID |
NUMBER(19) |
N |
|
| 2 |
APPLICABILITY_ NAME |
VARCHAR2 (20) |
Y |
|
CONTRACT_TEMPLATE_APP_I18N
This table depicts
translations for the list of options for contract template suitability.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
APPLICABILITY_ ID |
NUMBER(19) |
N |
|
| 2 |
LOCALE |
VARCHAR2 (32) |
N |
|
| 3 |
LOCAL_ APPLICABILITY_ NAME |
VARCHAR2 (100) |
Y |
|
CONTRACT_TEMPLATE_APPLIC_FACT
This table depicts
the list of contracts and the list of contract creation options.
| Col No |
Column Name |
Data Type |
Null |
Comments |
|---|
| 1 |
CONTRACT_ TEMPLATE_ID |
NUMBER(19) |
N |
|
| 2 |
APPLICABILITY_ ID |
NUMBER(19) |
N |
|