Subject Area : 262 - Import Items and Users
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