This page (revision-8) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
8 26-Nov-2021 10:22 1000 bytes JEscott to previous
7 26-Nov-2021 10:22 803 bytes RForbes to previous | to last
6 26-Nov-2021 10:22 788 bytes Administrator to previous | to last
5 26-Nov-2021 10:22 803 bytes Administrator to previous | to last
4 26-Nov-2021 10:22 811 bytes Administrator to previous | to last
3 26-Nov-2021 10:22 801 bytes Administrator to previous | to last
2 26-Nov-2021 10:22 819 bytes Administrator to previous | to last
1 26-Nov-2021 10:22 829 bytes Administrator to last

Page References

Incoming links Outgoing links
P 2 K_LR_UNIT_ELEMENTS
P2K_LR_UNIT_ELEMENTS

Version management

Difference between version and

At line 2 changed 2 lines
Unique Keys: [UNIT_CODE] ([DUN_ID]) + [EFFECTIVE]\\
Child Table: [P2K_LR_UNIT_CONTACTS], [P2K_LR_UNIT_ELEMENTS]\\
(P2K_LR_UNIT_ELEMENTS)
Unique Keys: [DUD_ID] (Unit + Effective) + [PEL_ID] (Element) + [UNIT_ELEMENT_TYPE]\\
Parent Table: [P2K_CM_UNIT_DETAILS] [P2K_PR_ELEMENTS]\\
ERD: [ERD-LR01]
\\
This table contains [date sensitive|DATE SENSITIVE] information relating elements to a unit.\\
At line 5 changed 3 lines
This table contains [date sensitive] information pertinent to the definition of a [unit]. The unit must already be defined on [P2K_CM_UNITS].
!Table Columns
!!Table Columns
At line 10 changed 3 lines
|[DUD_ID]|Number(10)|[ID]|Y|Link to [P2K_CM_UNIT_DETAILS]
|[PEL_ID]|Number(10)|[ID]|Y|Link to [P2K_PR_ELEMENTS]
|[UNIT_ELEMENT_TYPE]|Varchar2(2)|[(Lexicon)]|Y|
|[DUD_ID]|Number(10)|[ID]|Y|For [P2K_CM_UNIT_DETAILS]
|[PEL_ID]|Number(10)|[ID]|Y|For [P2K_PR_ELEMENTS]
|[UNIT_ELEMENT_TYPE]|Varchar2(2)|[X_UNIT_ELEMENT_TYPE]|Y|
At line 25 added 5 lines
----
![Notes|Edit:Internal.P2K_LR_UNIT_ELEMENTS]
[{InsertPage page='Internal.P2K_LR_UNIT_ELEMENTS' default='Click to create a new notes page'}]
This page (revision-8) was last changed on 26-Nov-2021 10:22 by JEscottTop