Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EMPL_ID |
|
VARCHAR(20) |
NO |
Name: Employee ID. Description: The unique identifier of the employee whose delegations it is. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR(10) |
NO |
Name: Functional Role. Description: The functional role that they are delegating. |
S_UDT_CD |
|
VARCHAR(5) |
NO |
Name: UDT Indictator. Description: Indicates the type of UDT that is being delegated. The valid values are:UDT01. UDT02. |
UDT_ID_S |
|
VARCHAR(30) |
NO |
Name: UDT Value. Description: The string that identifies the UDT. Wildcard values are allowed. |
DELEGATE_EMPL_ID |
|
VARCHAR(20) |
NO |
Name: Delegate Employee ID. Description: The employee who is being delegated the authority. |
ACTIVE_FL |
|
VARCHAR(1) |
NO |
Name: Active Flag. Description: Logical as to whether delegation is active. |
START_DT |
|
DATE |
NO |
Name: Start Date. Description: The starting date of the delegation. |
END_DT |
|
DATE |
NO |
Name: End Date. Description: The ending date of the delegation. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |