Subject Area Name
|
Definition
|
900 To Be Deleted
|
A list of tables that can be deleted because they are not used. Others are referenced in Java code that must be removed before table deletion.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
cal_ticket_privilege
|
Calendar Ticket Privilege
|
|
false
|
(Not used, but referenced in Java code that must be removed before table deletion.) A permission granted via a calendar ticket. May not be used in the FootPrints integration of calendaring code.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
cal_ticket_id
|
Calendar Ticket Id
|
A Foreign Key to the Calendar Ticket table.
|
bigint
|
|
|
privilege
|
Privilege
|
The value of a Calendar Ticket Privilege, stored as a string.
|
varchar(255)
|
|
local_col
|
Localized Column
|
|
false
|
(Not used, but referenced in Java code that must be removed before table deletion.) (Not currently used. Data localization is implemented in Configuration Setting Value. May be retired in the future). A Database Column name used in the Transparent Database Localization pattern. The data in the column is the original data for which a translated value can exist. In the case of English, this is a little strange because the English translation can be different than the original data.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
app_ele_id
|
Application Element Id
|
A Foreign Key to the Application Element table.
|
bigint
|
|
|
schema_name
|
Schema Name
|
The name of the Schema containing the Localized table. In Internal systems and in Definition level systems, this will be the logical name "FP", " FP Workspace", but in the Runtime system, this will be "FP 01" , "FP 01 Workspace 001" for example.
|
varchar(30)
|
|
|
table_name
|
Table Name
|
The name of the Localized Table.
|
varchar(30)
|
|
|
col_name
|
Column Name
|
The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length.
|
varchar(30)
|
|
local_col_val
|
Localized Column Value
|
|
false
|
(Not used, but referenced in Java code that must be removed before table deletion.) (Not currently used. Data localization is implemented in Configuration Setting Value. May be retired in the future). A data value from a column and row in a Localized table. The initial english value is obtained from the table, but may be modified for visual display purposes. The Primary Key identifier of the source table is used along with the table name to establish the row identity.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
app_ele_id
|
Application Element Id
|
A Foreign Key to the Application Element table.
|
bigint
|
|
|
local_col_id
|
Localized Column Id
|
A Foreign Key to the Application Element table.
|
bigint
|
|
|
initl_col_string_val
|
Initial Column String Value
|
Initial Column String Value.
|
varchar(255)
|
|
|
prmry_key_id
|
Primary Key Id
|
The integer primary key value of the row in the named Table that is being localized.
|
bigint
|
|
role_grp
|
Role Group
|
|
false
|
(Not used, but referenced in Java code that must be removed before table deletion.) The role group will contain the roles that the user has for each of the workspaces that the user has access. The user will always have a role group even if the administrator chooses the Perl Footprints functionality.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
role_grp_id
|
Role Group Id
|
The automatically generated primary key of the role_grp table.
|
bigint
|
|
|
role_grp_name
|
Role Group Name
|
The name of the Role Group.
|
varchar(255)
|
|
|
role_grp_descr
|
Role Group Description
|
A descriptive name of the Role Group. This descriptive name may be localized.
|
varchar(512)
|
|
role_grp_role
|
Role Group Role
|
|
false
|
(Not used, but referenced in Java code that must be removed before table deletion.) an association table that resolves the many to many relationship between the Role Group and the Role entities.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
app_role_id
|
Application Role Id
|
A Foreign Key to the Application Role table.
|
bigint
|
|
|
role_grp_role_id
|
Role Group Role Id
|
The automatically generated primary key of the role_grp_role table.
|
bigint
|
|
|
role_grp_id
|
Role Group Id
|
A Foreign Key to the Role Group table.
|
bigint
|
|
vt$item_fld_defn_networkadapte
|
vt$item_fld_defn_NetworkAdapter
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
field_extlname_en_us
|
field_externalName_en_US
|
field_externalName_en_US.
|
varchar(255)
|
|
|
fieldrole
|
fieldRole
|
fieldRole.
|
varchar(255)
|
|
|
fieldlogicaldtype
|
fieldLogicalDataType
|
fieldLogicalDataType.
|
varchar(255)
|
|
|
fld_defn_id
|
fld_defn_id
|
|
bigint
|
|
|
fld_defn_ver_id
|
fld_defn_ver_id
|
|
bigint
|
|
vt$item_fld_networkadapter$chg
|
vt$item_fld_NetworkAdapter$changes
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
field_extlname_en_us
|
field_externalName_en_US
|
field_externalName_en_US.
|
varchar(255)
|
|
|
fieldrole
|
fieldRole
|
fieldRole.
|
varchar(255)
|
|
|
fieldlogicaldtype
|
fieldLogicalDataType
|
fieldLogicalDataType.
|
varchar(255)
|
|
|
fld_defn_id
|
fld_defn_id
|
|
bigint
|
|
|
fld_defn_ver_id
|
fld_defn_ver_id
|
|
bigint
|
|
|
draft_fld_defn_ver_id
|
draft_fld_defn_ver_id
|
|
bigint
|
|
|
active_cfg_setting_val_id
|
active_cfg_setting_val_id
|
|
bigint
|
|
|
active_string_val
|
active_string_val
|
active_string_val.
|
varchar(255)
|
|
|
draft_cfg_setting_val_id
|
draft_cfg_setting_val_id
|
|
bigint
|
|
|
draft_string_val
|
draft_string_val
|
draft_string_val.
|
varchar(255)
|
|
|
dyn_col_spec_id
|
dyn_col_spec_id
|
|
bigint
|
|
|
logical_data_type_id
|
logical_data_type_id
|
|
int
|
|
|
logical_data_type_name
|
logical_data_type_name
|
logical_data_type_name.
|
varchar(255)
|
|
|
text_logical_data_type_id
|
TEXT_logical_data_type_id
|
|
int
|
|
|
schema_name
|
schema_name
|
schema_name.
|
varchar(30)
|
|
|
table_name
|
table_name
|
table_name.
|
varchar(30)
|
|
|
col_name
|
col_name
|
col_name.
|
varchar(255)
|