Subject Area : 320 - Report
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 320 - Report Tables that define the existence and configuration of Reports in the UI. Details.. Details..
ER Diagram(s) of Subject Area "320 - Report"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "320 - Report"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 18
. 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..
. defn_ver Definition Version false A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. recur_period_type Recur Period Type false The recurrence type. Choices include No Recurrance, Daily, Weekly, Monthly. This is an enum table that must be kept in sync with the application code. It explains the values for database queries only, and is not mapped for application access. Details..
. recur_schd_type Recur Schedule Type false The Schedule type. Choices include IMMEDIATELY/SCHEDULED_ONCE/MANUAL_ONLY. This is an enum table that must be kept in sync with the application code. It explains the values for database queries only, and is not mapped for application access. Details..
. rpt Report false A dashboard report definition. The report information is used with the Logi Analytics embedded reporting engine to render reports in the UI. Details..
. rpt_cfg Report Configuration false Configuration data values associated with a dashboard report. Details..
. rpt_format Report Format false Report Format such as PDF, EXCEL. Details..
. rpt_schdd_task Report Scheduled Task false The report schedule is association between a report and the scheduled task. Report schedule specific information can also be placed here. Details..
. rpt_visibility_type Report Visibility Type false A lookup table for report visibility type. Values include: Private, Shared. Details..
. schd_task_run_stat Schedule Task Run Statistic false An individual statistic item for a run. This has a compound key so it can be mapped as a simple key value map. 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..
. schdd_task_run Scheduled Task Run false An instance of a run for a schedule task used for last run and previous run information. The run date and the status of the run are kept here. There is only one row per run, so the time of each status change is not known. Details..
. schdd_task_stat Scheduled Task Statistic false A named statistic that can be associated with a run. This allows free form name value statistics to be dynamically associated with the run. Details..
. schdd_task_status Scheduled Task Status false The run status enumeration. Choices include Scheduled, In Progress, Completed, Completed with Errors. Details..
. schdd_task_type Scheduled Task Type false A lookup table for the Scheduled Task Type that must be kept in sync with an enumeration in the Java. Values include: IMPORT_USER, MASSS_EMAIL, REPORT_SCHEDULE etc. Details..
. val_type_cd Value Type Code false A lookup table for the data value type discriminator. Many tables share this discriminator for name value pair datatypes. Values include:
B Boolean
D Timestamp - Date + Time
I Integer
L Long
R Real Number
S String
T Text - long string
Details..
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 "Definition Version"
# Physical Name Name Definition Physical Data Type
Total 5
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. defn_ver_id Definition Version Id The automatically generated primary key of the defn_ver table. bigint
. defn_ver_name Definition Version Name The name of the Definition Version. nvarchar(4000)
. defn_ver_status_id Definition Version Status Id A Foreign Key to the Definition Version Status table. int
. defn_ver_guid Definition Version GUID A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
Attribute/Column(s) of Entity/Table "Recur Period Type"
# Physical Name Name Definition Physical Data Type
Total 2
. 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_period_type_name Recur Period Type Name The unique string identifier for an instance of Recur Period 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)
Attribute/Column(s) of Entity/Table "Recur Schedule Type"
# Physical Name Name Definition Physical Data Type
Total 2
. 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
. recur_schd_type_name Recur Schedule Type Name The unique string identifier for an instance of Recur Schedule 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)
Attribute/Column(s) of Entity/Table "Report"
# Physical Name Name Definition Physical Data Type
Total 15
. rpt_id Report Id The automatically generated primary key of the rpt table. bigint
. rpt_name Report Name The name of the Report. varchar(255)
. created_by Created By A Foreign Key to the Application User table. bigint
. created_on Created On The value of a Report, stored as a date. datetime
. mod_by Modified By A Foreign Key to the Application User table. bigint
. mod_on Modified On The value of a Report, stored as a date. datetime
. rpt_visibility_type_id Report Visibility Type Id A Foreign Key to the Report Visibility Type table. int
. next_schdd_run_date Next Scheduled Run Date Next run date datetime
. rpt_comment Report Comment The value of a Report, stored as a string. varchar(255)
. item_defn_id Item Definition Id A Foreign Key to the Definition Version table. bigint
. rpt_descr Report Description A descriptive name of the Report. This descriptive name may be localized. varchar(512)
. rpt_title Report Title The name of the Report. varchar(255)
. rpt_grp_id Report Group Id A Foreign Key to the Definition Version table. bigint
. deleted_on Deleted On The value of a Report, stored as a date. datetime
. rpt_type_id Report Type Id A Foreign Key to the Definition table. bigint
Attribute/Column(s) of Entity/Table "Report Configuration"
# Physical Name Name Definition Physical Data Type
Total 11
. rpt_cfg_id Report Configuration Id The automatically generated primary key of the rpt_cfg table. bigint
. rpt_id Report Id A Foreign Key to the Report table. bigint
. rpt_cfg_name Report Configuration Name The name of the Report Configuration. varchar(255)
. string_val String Value The value of a Report Configuration, stored as a string. varchar(255)
. text_val Text Value The value of a Report Configuration, stored as a long text object. varchar(max)
. date_val Date Value The value of a Report Configuration, stored as a date. datetime
. real_val Real Value The value of a Report Configuration stored as real. numeric(38,20)
. int_val Int Value The value of a Report Configuration stored as boolean. int
. long_val Long Value The value of a Report Configuration stored as Long. bigint
. boolean_val Boolean Value The Boolean Value. bit
. val_type_cd Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. char(1)
Attribute/Column(s) of Entity/Table "Report Format"
# Physical Name Name Definition Physical Data Type
Total 2
. rpt_format_name Report Format Name The unique string identifier for an instance of Report Format. 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)
. rpt_format_descr Report Format Description A descriptive name of the Report Format. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Report Scheduled Task"
# Physical Name Name Definition Physical Data Type
Total 5
. rpt_id Report Id A Foreign Key to the Report table. bigint
. schdd_task_id Scheduled Task Id A Foreign Key to the Scheduled Task table. bigint
. mail_empty_rpt_flag Mail Empty Report Flag A boolean flag for xxx numeric(1)
. rpt_folder_name Report Folder Name A search key for the Report Scheduled Task, composed of letters and numbers. varchar(255)
. rpt_format_name Report Format Name The unique string identifier for an instance of Report Format. 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)
Attribute/Column(s) of Entity/Table "Report Visibility Type"
# Physical Name Name Definition Physical Data Type
Total 3
. rpt_visibility_type_id Report Visibility Type Id The automatically generated primary key of the rpt_visibility_type table. int
. rpt_visibility_type_name Report Visibility Type Name The name of the Report Visibility Type. varchar(255)
. rpt_visibility_type_descr Report Visibility Type Description A descriptive name of the Report Visibility Type. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Schedule Task Run Statistic"
# Physical Name Name Definition Physical Data Type
Total 3
. schdd_task_run_id Scheduled Task Run Id A Foreign Key to the Scheduled Task Run table. bigint
. schdd_task_stat_id Scheduled Task Statistic Id The unique identifier for an instance of Scheduled Task Statistic. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
. int_val Int Value The value of a Schedule Task Run Statistic stored as boolean. integer
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 "Scheduled Task Run"
# Physical Name Name Definition Physical Data Type
Total 6
. schdd_task_run_id Scheduled Task Run Id The automatically generated primary key of the scheduled_task_run table. bigint
. schdd_task_id Scheduled Task Id A Foreign Key to the Scheduled Task table. bigint
. schdd_task_status_id Scheduled Task Status Id The unique identifier for an instance of Scheduled Task Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
. status_chg_date Status Change Date The date that the Scheduled Task Run was created. datetime
. dtl_status Detail Status The name of the Scheduled Task Run. varchar(255)
. schdd_run_date Scheduled Run Date datetime
Attribute/Column(s) of Entity/Table "Scheduled Task Statistic"
# Physical Name Name Definition Physical Data Type
Total 2
. schdd_task_stat_id Scheduled Task Statistic Id The unique identifier for an instance of Scheduled Task Statistic. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
. schdd_task_stat_name Scheduled Task Statistic Name The unique string identifier for an instance of Scheduled Task Statistic. 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)
Attribute/Column(s) of Entity/Table "Scheduled Task Status"
# Physical Name Name Definition Physical Data Type
Total 2
. schdd_task_status_id Scheduled Task Status Id The unique identifier for an instance of Scheduled Task Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
. schdd_task_status_name Scheduled Task Status Name The unique string identifier for an instance of Scheduled Task Status. 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)
Attribute/Column(s) of Entity/Table "Scheduled Task Type"
# Physical Name Name Definition Physical Data Type
Total 2
. 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_type_name Scheduled Task Type Name The unique string identifier for an instance of Scheduled Task 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)
Attribute/Column(s) of Entity/Table "Value Type Code"
# Physical Name Name Definition Physical Data Type
Total 2
. val_type_cd Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. char(1)
. val_type_name Value Type Name The name of the Value Type Code. varchar(255)