Subject Area Name
|
Definition
|
262 - Import Items and Users
|
Tables for importing data to dynamic items.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Logical
|
Column
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
app_role
|
Application Role
|
|
false
|
A User Security Role within Footprints. This includes Agent Users and Customer Users, and includes Role settings at the Instance and Container level. Workspace Role and CMDB Role may both be implemented as Container Role. The Role has associated Rights and Permissions, and is a way of granting Roles and Permissions to a User. There is some conceptual overlap between the User Profile and the Role. The User is assigned a single Role as part of the User Profile, and a User can only have one System Role and one Workspace Role. The User Profile can have property settings that override the Role Settings.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
app_role_id
|
Application Role Id
|
The automatically generated primary key of the app_role table.
|
bigint
|
|
|
tmpl_app_role_id
|
Template Application Role Id
|
A Foreign Key to the Application Role table. This indicates which Template Role was used to create a built-in role in case some features concerning new properties added to later release of the system will need to be added to existing templates.
|
bigint
|
|
|
app_role_name
|
Application Role Name
|
The name of the Application Role.
|
varchar(255)
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
admin_type_id
|
Administrator Type Id
|
A Foreign Key to the Administrator Type table.
|
int
|
|
|
is_built_in
|
Is Built In
|
Indicates that this instance of Application Role is a built-in instance that cannot be changed by the end user.
|
bit
|
|
|
app_role_descr
|
Application Role Description
|
A descriptive name of the Application Role. This descriptive name may be localized.
|
varchar(1024)
|
|
|
user_type_id
|
User Type Id
|
A Foreign Key to the User Type table.
|
int
|
|
|
defn_subtype_id
|
Definition Subtype Id
|
A Foreign Key to the Definition Subtype table.
|
int
|
|
|
tmpl_app_role_id
|
Template Application Role Id
|
A Foreign Key to the Application Role table.
|
bigint
|
|
|
tmpl_level_name
|
tmpl_level_name
|
The value of a Built_in_level, stored as a string.
|
varchar(255)
|
|
app_user
|
Application User
|
|
false
|
A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
pwd
|
Password
|
This space intentionally left blank.
|
varchar(255)
|
|
|
user_name
|
User Name
|
The name of the Application User.
|
nvarchar(4000)
|
|
|
cust_login_type_id
|
Customer Login Type Id
|
A Foreign Key to the Customer Login Type table.
|
int
|
|
|
app_user_id
|
Application User Id
|
The automatically generated primary key of the app_user table.
|
bigint
|
|
|
lic_type_id
|
License Type Id
|
A Foreign Key to the License Type table.
|
bigint
|
|
|
user_login
|
User Login
|
The login name used to access the Application. This may not be filled in if external application security is used.
|
nvarchar(4000)
|
|
|
email_addr
|
Email Address
|
An email address for the Application User.
|
nvarchar(4000)
|
|
|
delete_date
|
Delete Date
|
The value of a Application User, stored as a date.
|
datetime
|
|
defn
|
Definition
|
|
false
|
A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_id
|
Definition Id
|
The automatically generated primary key of the defn table.
|
bigint
|
|
|
defn_name
|
Definition Name
|
The name of the Definition.
|
nvarchar(4000)
|
|
|
dsble_date
|
Disabled Date
|
The date that this instance of Definition is logically deleted and disabled.
|
datetime
|
|
|
defn_guid
|
Definition GUID
|
A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data.
|
varchar(50)
|
|
|
defn_type_name
|
Definition Type Name
|
The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|
|
|
defn_subtype_id
|
Definition Subtype Id
|
A Foreign Key to the Definition Subtype table.
|
int
|
|
|
tmpl_export_guid
|
Template Export GUID
|
The value of a Definition, stored as a string.
|
VARCHAR(50)
|
|
imp
|
Import
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
imp_id
|
Import Id
|
The automatically generated primary key of the imp table.
|
bigint
|
|
|
imp_status
|
Import Status
|
Import Status
|
int
|
|
|
imp_type
|
Import Type
|
Import Type
|
varchar(255)
|
|
|
imp_user_sys_level_role
|
Import User System Level Role
|
A Foreign Key to the Application Role table.
|
bigint
|
|
|
imp_item_defn_id
|
Import Item Definition ID
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
imp_defn_id
|
Import Definition ID
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
imp_date
|
Import Date
|
Import Date
|
datetime
|
|
|
imp_create_date
|
Import Create Date
|
Import Create Date
|
datetime
|
|
|
imp_record_addr_book_id
|
Import Record Address Book Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
imp_total_created
|
Import Total Created
|
Total Rows Created
|
int
|
|
|
imp_total_updated
|
Import Total Updated
|
Total Rows updated
|
int
|
|
|
imp_total_failures
|
Import Total Failures
|
Failure count.
|
int
|
|
|
imp_error_cd
|
Import Error Code
|
Import Error Code
|
varchar(255)
|
|
|
imp_create_user
|
Import Create User
|
Import Create User
|
int
|
|
|
imp_ext_db_defn_id
|
Import Ext DB Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
imp_ci_addr_book_id
|
Import CI Address Book Id
|
Import CI Address Book Id
|
bigint
|
|
|
imp_last_exec_date
|
Import Last Exec Date
|
Import Last Exec Date
|
datetime
|
|
|
imp_ci_rel_from_defn_id
|
Import CI Rel from Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
imp_ci_rel_to_defn_id
|
Import CI Rel to Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
imp_time_zone
|
Import Time Zone
|
Time zone of the import.
|
varchar(255)
|
|
imp_asgnmt
|
Import Assignment
|
|
false
|
The default assignment details for an Import Job.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
imp_asgnmt_id
|
Import Assignment Id
|
The automatically generated primary key of the imp_asgnmt table.
|
bigint
|
|
|
team_id
|
Team Id
|
A Foreign Key to the Team table.
|
bigint
|
|
|
app_user_id
|
Application User Id
|
A Foreign Key to the Application User table.
|
bigint
|
|
|
imp_id
|
Import Id
|
A Foreign Key to the Import table.
|
bigint
|
|
imp_defn_rule
|
Import Definition Rule
|
|
false
|
This table contains the information necessary for the application
to do a conditional flow in the processing based on a text string (defn value).
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
imp_defn_rule_id
|
Import Definition Rule Id
|
The automatically generated primary key of the imp_defn_rule table.
|
bigint
|
|
|
imp_defn_rule_col_index
|
Import Definition Rule Column Index
|
stores the index of the column (i.e in a csv file) or the name of the column (i.e database table)
|
varchar(255)
|
|
|
imp_defn_rule_text_to_contain
|
Import Definition Rule Text To Contain
|
The text that will cause the rule to trigger a branch.
|
varchar(255)
|
|
|
imp_defn_rule_defn_id
|
Import Definition Rule Definition Id
|
The reference for the item definition (currently for the CI type but want to be more general).
|
bigint
|
|
|
imp_id
|
Import Id
|
FK to the import operation record in the existing import operation table.
|
bigint
|
|
|
imp_defn_rule_status
|
Import Definition Rule Status
|
Status can be different based on the CI type, but will be a fk to the allowed values inside the defn table.
|
bigint
|
|
imp_error_result
|
Import Error Result
|
|
false
|
A list of errors that occured during the execution of the import.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
imp_error_result_id
|
Import Error Result Id
|
The automatically generated primary key of the imp_error_result table.
|
bigint
|
|
|
imp_error_result_string_inheri
|
Import Error Result String Inherited
|
Import Error Result String Inherited.
|
varchar(255)
|
|
|
imp_error_row
|
Import Error Row
|
The value of a Import Error Result, stored as a string.
|
varchar(max)
|
|
|
imp_error_line
|
Import Error Line
|
The value of a Import Error Result stored as boolean.
|
int
|
|
|
imp_error_parms
|
Import Error Parameters
|
The value of a Import Error Result, stored as a string.
|
varchar(255)
|
|
|
imp_execn_record_id
|
Import Execution Record Id
|
A Foreign Key to the Import Execution Record table.
|
bigint
|
|
imp_execn_record
|
Import Execution Record
|
|
false
|
A log of the execution of an import.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
imp_execn_record_id
|
Import Execution Record Id
|
The automatically generated primary key of the imp_execn_record table.
|
bigint
|
|
|
imp_id
|
Import Id
|
A Foreign Key to the Import table.
|
bigint
|
|
|
execn_date
|
Execution Date
|
Execution Date
|
datetime
|
|
|
created_ct
|
Created Count
|
Created Count
|
int
|
|
|
rejected_ct
|
Rejected Count
|
Rejected Count
|
int
|
|
|
updated_ct
|
Updated Count
|
Updated Count
|
int
|
|
|
unchgd_ct
|
Unchanged Count
|
Unchanged Count
|
int
|
|
|
imp_status
|
Import Status
|
Import Status
|
int
|
|
|
validated_ct
|
Validated Count
|
Validated Count
|
int
|
|
imp_schdd_task
|
Import Scheduled Task
|
|
false
|
The import scheduled task is an association between the import and the scheduled task. Import specific information can be placed here. This was added when the scheduled task service was refactored to treat different schedule types with the same core code.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
schdd_task_id
|
Scheduled Task Id
|
A Foreign Key to the Scheduled Task table. It also serves as the Primary Key here.
|
bigint
|
|
|
imp_id
|
Import Id
|
A Foreign Key to the Import table.
|
bigint
|
|
|
time_zone
|
Time Zone
|
Time zone of the import.
|
varchar(255)
|
|
imp_user_wksp_role
|
Import User Workspace Role
|
|
false
|
An association between an Import and a role.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
imp_id
|
Import Id
|
A Foreign Key to the Import table.
|
bigint
|
|
|
app_role_id
|
Application Role Id
|
A Foreign Key to the Application Role table.
|
bigint
|
|
|
imp_user_wksp_role_id
|
Import User Workspace Role Id
|
The automatically generated primary key of the imp_user_wksp_role table.
|
bigint
|
|
schdd_task
|
Scheduled Task
|
|
false
|
A scheduled task that may include recurrence. This is all of the information needed to provide the scheduler with data to execute a task. It is used for Reports, but is intended to be generic for other scheduled tasks. This is the root object. Report specific information will go in an association table.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
schdd_task_name
|
Scheduled Task Name
|
The name of the Scheduled Task.
|
varchar(255)
|
|
|
schdd_task_id
|
Scheduled Task Id
|
The automatically generated primary key of the scheduled_task table.
|
bigint
|
|
|
schdd_task_descr
|
Scheduled Task Description
|
A descriptive name of the Scheduled Task. This descriptive name may be localized.
|
varchar(512)
|
|
|
recur_schd_type_id
|
Recur Schedule Type Id
|
The unique identifier for an instance of Recur Schedule Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
integer
|
|
|
begin_date
|
Begin Date
|
Begin Date.
|
datetime
|
|
|
recur_period_type_id
|
Recur Period Type Id
|
The unique identifier for an instance of Recur Period Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
integer
|
|
|
recur_hour
|
Recur Hour
|
The Hours portion of a time of day
|
integer
|
|
|
recur_minute
|
Recur Minute
|
The minutes portion of a time of day
|
integer
|
|
|
recur_days_of_week
|
Recur Days of Week
|
Recur Days of Week.
|
varchar(255)
|
|
|
recur_days_of_month
|
Recur Days of Month
|
Recur Days of Month.
|
varchar(255)
|
|
|
create_date
|
Create Date
|
The date that the Scheduled Task was created.
|
datetime
|
|
|
create_app_user_id
|
Create Application User Id
|
A Foreign Key to the Application User table.
|
bigint
|
|
|
schdd_task_type_id
|
Scheduled Task Type Id
|
The unique identifier for an instance of Scheduled Task Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
integer
|
|
schdd_task_notifn
|
Scheduled Task Notification
|
|
false
|
The collection of notification recipients for the Scheduled Task. Having true references here will make it easier to maintain changes to user's information such as LDAP lookup, name changes, and user deletion or replacement use cases.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
schdd_task_id
|
Scheduled Task Id
|
A Foreign Key to the Scheduled Task table.
|
bigint
|
|
|
app_user_id
|
Application User Id
|
A Foreign Key to the Application User table.
|
bigint
|
|
|
team_id
|
Team Id
|
A Foreign Key to the Team table.
|
bigint
|
|
|
cntc_defn_id
|
Contact Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
email_addr
|
Email Address
|
An email address for the Scheduled Task Notification.
|
nvarchar(4000)
|
|
|
schdd_task_notifn_id
|
Scheduled Task Notification Id
|
The automatically generated primary key of the scheduled_task_notification table.
|
bigint
|
|
|
cntc_item_id
|
Contact Item Id
|
A Foreign Key to the Item table.
|
bigint
|
|
|
all_cntcs_flag
|
All_Contacts_Flag
|
A boolean flag for xxx
|
numeric(1)
|
|
|
cntc_email
|
Contact Email
|
An email address for the Scheduled Task Notification.
|
nvarchar(4000)
|
|
team
|
Team
|
|
false
|
A team is a group of application users that can be used in Team level assignments.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
team_id
|
Team Id
|
The automatically generated primary key of the team table.
|
bigint
|
|
|
team_name
|
Team Name
|
The name of the Team.
|
nvarchar(4000)
|
|
|
wksp_defn_id
|
Workspace Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
team_email_notifn_type_id
|
Team Email Notification Type Id
|
A Foreign Key to the Team Email Notification Type table.
|
int
|
|
|
team_lead_app_user_id
|
Team Lead Application User Id
|
A Foreign Key to the Application User table.
|
bigint
|