pa_job_logs

The table below describes the pa_job_logs table.

This table contains the following foldable columns:

  • sys_id_value
  • completed_display_value
  • completed_value
  • deletes_display_value
  • deletes_value
  • errors_display_value
  • errors_value
  • inserts_display_value
  • inserts_value
  • job_display_value
  • job_settings_display_value
  • job_settings_value
  • job_value
  • run_time_display_value
  • run_time_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_domain_display_value
  • sys_domain_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
  • updates_display_value
  • updates_value
  • warnings_display_value
  • warnings_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

completed_display_value

SQL_VARCHAR(500) True True

completed_value

SQL_TIMESTAMP True True

deletes_display_value

SQL_VARCHAR(500) True True

deletes_value

SQL_INTEGER(signed) True True

errors_display_value

SQL_VARCHAR(500) True True

errors_value

SQL_INTEGER(signed) True True

inserts_display_value

SQL_VARCHAR(500) True True

inserts_value

SQL_INTEGER(signed) True True

job_display_value

SQL_VARCHAR(500) True True

job_settings_display_value

SQL_VARCHAR(2000) True True

job_settings_value

SQL_VARCHAR(2000) True True

job_value

SQL_VARCHAR(64) True True

run_time_display_value

SQL_VARCHAR(500) True True

run_time_value

SQL_TIMESTAMP 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_domain_display_value

SQL_VARCHAR(500) False True

sys_domain_value

SQL_VARCHAR(64) 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

updates_display_value

SQL_VARCHAR(500) True True

updates_value

SQL_INTEGER(signed) True True

warnings_display_value

SQL_VARCHAR(500) True True

warnings_value

SQL_INTEGER(signed) True True