Subject Area : 320 - Report |
Subject Area Name | Definition | |||||
---|---|---|---|---|---|---|
320 - Report | Tables that define the existence and configuration of Reports in the UI. | |||||
ER Diagram Name | Physical Display Level | |||||
Logical | Column | |||||
Physical | Column | |||||
Physical Name | Entity/Table Name | Logical Only | Do Not Generate | Definition | ||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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 | |||
rpt_cfg | Report Configuration | false | Configuration data values associated with a dashboard report. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
rpt_format | Report Format | false | Report Format such as PDF, EXCEL. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
rpt_visibility_type | Report Visibility Type | false | A lookup table for report visibility type. Values include: Private, Shared. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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 | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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 | ||||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
schdd_task_status | Scheduled Task Status | false | The run status enumeration. Choices include Scheduled, In Progress, Completed, Completed with Errors. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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. | |||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) | |||
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 |
|||
Physical Name | Attribute/Column Name | Definition | Physical Data Type | |||
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) |