sysapproval_approver
The table below describes the sysapproval_approver table.
This table contains the following foldable columns:
- sys_id_value
- approver_value
- group_value
- process_step_value
- state_binding_value
- sysapproval_value
- approval_column_display_value
- approval_column_value
- approval_journal_column_display_value
- approval_journal_column_value
- approval_source_display_value
- approval_source_value
- approver_display_value
- comments_display_value
- comments_value
- document_id_display_value
- document_id_value
- due_date_display_value
- due_date_value
- expected_start_display_value
- expected_start_value
- group_display_value
- iteration_display_value
- iteration_value
- order_display_value
- order_value
- process_step_display_value
- source_table_display_value
- source_table_value
- state_binding_display_value
- state_display_value
- state_value
- sys_created_by_display_value
- sys_created_by_value
- sys_created_on_display_value
- sys_created_on_value
- sys_id_display_value
- sys_mod_count_display_value
- sys_mod_count_value
- sys_tags_display_value
- sys_tags_value
- sys_updated_by_display_value
- sys_updated_by_value
- sys_updated_on_display_value
- sys_updated_on_value
- sysapproval_display_value
The primary key columns in this table are returnable.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
approver_value Foreign Key linked to column sys_id_value in sys_user table |
SQL_VARCHAR(64) | True | True |
|
group_value Foreign Key linked to column sys_id_value in sysapproval_group table |
SQL_VARCHAR(64) | True | True |
|
process_step_value Foreign Key linked to column sys_id_value in process_step table |
SQL_VARCHAR(64) | True | True |
|
state_binding_value Foreign Key linked to column sys_id_value in state_binding table |
SQL_VARCHAR(64) | True | True |
|
sysapproval_value Foreign Key linked to column sys_id_value in task table |
SQL_VARCHAR(64) | True | True |
|
approval_column_display_value |
SQL_VARCHAR(500) | True | True |
|
approval_column_value |
SQL_VARCHAR(256) | True | True |
|
approval_journal_column_display_value |
SQL_VARCHAR(500) | True | True |
|
approval_journal_column_value |
SQL_VARCHAR(256) | True | True |
|
approval_source_display_value |
SQL_VARCHAR(500) | True | True |
|
approval_source_value |
SQL_VARCHAR(80) | True | True |
|
approver_display_value |
SQL_VARCHAR(500) | True | True |
|
comments_display_value |
SQL_VARCHAR(8000) | True | True |
|
comments_value |
SQL_VARCHAR(8000) | True | True |
|
document_id_display_value |
SQL_VARCHAR(500) | True | True |
|
document_id_value |
SQL_VARCHAR(256) | True | True |
|
due_date_display_value |
SQL_VARCHAR(500) | True | True |
|
due_date_value |
SQL_TIMESTAMP | True | True |
|
expected_start_display_value |
SQL_VARCHAR(500) | True | True |
|
expected_start_value |
SQL_TIMESTAMP | True | True |
|
group_display_value |
SQL_VARCHAR(500) | True | True |
|
iteration_display_value |
SQL_VARCHAR(500) | True | True |
|
iteration_value |
SQL_INTEGER(signed) | True | True |
|
order_display_value |
SQL_VARCHAR(500) | True | True |
|
order_value |
SQL_INTEGER(signed) | True | True |
|
process_step_display_value |
SQL_VARCHAR(500) | True | True |
|
source_table_display_value |
SQL_VARCHAR(500) | True | True |
|
source_table_value |
SQL_VARCHAR(256) | True | True |
|
state_binding_display_value |
SQL_VARCHAR(500) | True | True |
|
state_display_value |
SQL_VARCHAR(500) | True | True |
|
state_value |
SQL_VARCHAR(80) | True | True |
|
sys_created_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_created_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_on_value |
SQL_TIMESTAMP | False | True |
|
sys_id_display_value |
SQL_VARCHAR(500) | False | False |
|
sys_mod_count_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_mod_count_value |
SQL_INTEGER(signed) | False | True |
|
sys_tags_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_tags_value |
SQL_VARCHAR(256) | False | True |
|
sys_updated_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_updated_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_on_value |
SQL_TIMESTAMP | False | True |
|
sysapproval_display_value |
SQL_VARCHAR(500) | True | True |