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)