Alias:LUC#
(P2K_LR_UNIT_CONTACTS)Unique Keys: none
Parent Table: P2K_CM_UNIT_DETAILS
ERD: ERD-LR01
This table contains date sensitive information pertinent to the association of contacts for a unit.
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| DUD_ID | Number(10) | ID | Y | For P2K_CM_UNIT_DETAILS |
| ECT_ID | Number(10) | ID | [ARC] | For P2K_HR_CONTACTS |
| EID_ID | Number(10) | ID | [ARC] | For P2K_HR_IDENTITIES |
| UNIT_CONTACT_TYPE | Varchar2(2) | X_UNIT_CONTACT_TYPE | Y | |
| UNIT_CONTACT_TITLE | Varchar2(50) | DESCRIPTION | Y | |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION |
Derived Fields#
| Column Name |
|---|
| DRV_UNIT_CONTACT_ADDRESS |
| DRV_UNIT_CONTACT_LOCALITY |
| DRV_UNIT_CONTACT_PHONE |
| DRV_UNIT_CONTACT_TYPE |
User Fields: Allowed
Audit Logging: Allowed
- Notes
- [ARC]You may only choose one of ECT_ID or EID_ID to indicate who the contact is.
Notes #
Click to create a new notes pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation