The PLL module uses the following database tables:
-
M_PLL_UNITS - Stores the process line units.
-
M_PLL_UNIT_NLS - Stores the language dependent description of the process line list unit.
-
M_PLL_UNIT_SETS - Stores the sets of units in order to form the template system of default attributes.
-
M_PLL_UNITS_TO_SET - Stores the reference of process units to unit sets.
-
M_PLL_UNIT_ATTRS - Stores the default attributes for unit sets.
-
M_PLL_STATUS - Stores the status for process lines.
-
M_PLL_LINES - Stores the process lines.
-
M_PLL_LINE_NLS - Stores the language dependent description of the process line.
-
M_PLL_DNS - Stores the diameter nominals for the process line.
-
M_PLL_DN_ATTRS - Stores the attributes for dns.
-
M_PLL_BRANCH_TYPES - Stores the branch types for process lines.
-
M_PLL_BRANCH_TYPE_NLS - Stores the language dependent description of the branch types.
-
M_PLL_REINFORCEMENT - Stores the reinforcement codes for the branches.
-
M_PLL_REINFORCEMENT_NLS - Stores the language dependent description of the reinforcement codes.
-
M_PLL_SHORT_CODE_M - Stores the short Smart Materials codes mapping to the branch types.
-
M_PLL_BRANCHES - Stores the process line branches.
-
M_PLL_CHECKS - Stores all predefined (FIX) and custom (PRC) verification functions.
-
M_PLL_CHECK_NLS - Stores the language dependent description of the verification functions.
-
M_PLL_VER_JOB_CHECKS - Stores the reference of verification functions to verification jobs.
-
M_PLL_VER_JOB_UNITS - Stores the reference of the process units to verification jobs.
-
M_PLL_IMPORT_JOBS - Stores the import job definitions and job options.
-
M_PLL_IMPORT_DATA - This table will store the data loaded with PLL import and verifications jobs. It is an intermediate storage, which will then be processed by the PLL import job; the main program analyzes and validates the import data and creates PLL data items in the central Smart Materials PLL tables for valid input records.
-
M_PLL_EXPORT_JOBS - Stores the export job definitions and job options.
-
M_PLL_EXP_LINE_ATTRS - Stores user defined attributes for export job for lines.
-
M_PLL_EXP_DN_ATTRS - Stores user defined attributes for export job for dns.