Subject Area : 262 - Import Items and Users
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 262 - Import Items and Users Tables for importing data to dynamic items. Details.. Details..
ER Diagram(s) of Subject Area "262 - Import Items and Users"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "262 - Import Items and Users"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 13
. 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. Details..
. 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. Details..
. 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. Details..
. imp Import false Details..
. imp_asgnmt Import Assignment false The default assignment details for an Import Job. Details..
. 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).
Details..
. imp_error_result Import Error Result false A list of errors that occured during the execution of the import. Details..
. imp_execn_record Import Execution Record false A log of the execution of an import. Details..
. 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. Details..
. imp_user_wksp_role Import User Workspace Role false An association between an Import and a role. Details..
. 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. Details..
. 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. Details..
. team Team false A team is a group of application users that can be used in Team level assignments. Details..
Attribute/Column(s) of Entity/Table "Application Role"
# Physical Name Name Definition Physical Data Type
Total 11
. 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)
Attribute/Column(s) of Entity/Table "Application User"
# Physical Name Name Definition Physical Data Type
Total 8
. 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
Attribute/Column(s) of Entity/Table "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. 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)
Attribute/Column(s) of Entity/Table "Import"
# Physical Name Name Definition Physical Data Type
Total 20
. 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)
Attribute/Column(s) of Entity/Table "Import Assignment"
# Physical Name Name Definition Physical Data Type
Total 4
. 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
Attribute/Column(s) of Entity/Table "Import Definition Rule"
# Physical Name Name Definition Physical Data Type
Total 6
. 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
Attribute/Column(s) of Entity/Table "Import Error Result"
# Physical Name Name Definition Physical Data Type
Total 6
. 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
Attribute/Column(s) of Entity/Table "Import Execution Record"
# Physical Name Name Definition Physical Data Type
Total 9
. 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
Attribute/Column(s) of Entity/Table "Import Scheduled Task"
# Physical Name Name Definition Physical Data Type
Total 3
. 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)
Attribute/Column(s) of Entity/Table "Import User Workspace Role"
# Physical Name Name Definition Physical Data Type
Total 3
. 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
Attribute/Column(s) of Entity/Table "Scheduled Task"
# Physical Name Name Definition Physical Data Type
Total 13
. 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
Attribute/Column(s) of Entity/Table "Scheduled Task Notification"
# Physical Name Name Definition Physical Data Type
Total 9
. 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)
Attribute/Column(s) of Entity/Table "Team"
# Physical Name Name Definition Physical Data Type
Total 5
. 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