Name |
Datatype |
Comment |
Is PK |
Is FK |
imp_id |
bigint |
The automatically generated primary key of the imp table. |
Yes |
No |
imp_status |
int |
Import Status |
No |
No |
imp_type |
varchar(255) |
Import Type |
No |
No |
imp_user_sys_level_role |
bigint |
A Foreign Key to the Application Role table. |
No |
Yes |
imp_item_defn_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
imp_defn_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
imp_ci_rel_from_defn_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
imp_ci_rel_to_defn_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
imp_ext_db_defn_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
imp_date |
datetime |
Import Date |
No |
No |
imp_last_exec_date |
datetime |
Import Last Exec Date |
No |
No |
imp_create_date |
datetime |
Import Create Date |
No |
No |
imp_record_addr_book_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
imp_ci_addr_book_id |
bigint |
Import CI Address Book Id |
No |
No |
imp_total_created |
int |
Total Rows Created |
No |
No |
imp_total_updated |
int |
Total Rows updated |
No |
No |
imp_total_failures |
int |
Failure count. |
No |
No |
imp_error_cd |
varchar(255) |
Import Error Code |
No |
No |
imp_create_user |
bigint |
Import Create User |
No |
No |
imp_time_zone |
varchar(255) |
Time zone of the import. |
No |
No |