The complete name of the person, including first name, middle name or initial, and surname.
A resource address usually consisting of the access protocol, the domain name, and optionally, the path to a file or location. Report Email.
| Name | EDMS_USER |
| Comment | User table |
| Column |
| Name | Is PK | Is FK | UDP | Datatype | Null Option | Comment |
| USER_ID | Yes | No |
|
VARCHAR2(20) | NOT NULL | User ID |
| USER_NAME | No | No |
|
VARCHAR2(70) | NULL |
The complete name of the person, including first name, middle name or initial, and surname. |
| USER_PHONE_NUMBER | No | No |
|
VARCHAR2(10) | NULL | The phone number for the person. |
| USER_FAX_NUMBER | No | No |
|
VARCHAR2(10) | NULL | The phone number for the person. |
| USER_EMAIL_ADDRESS | No | No |
|
VARCHAR2(100) | NULL |
A resource address usually consisting of the access protocol, the domain name, and optionally, the path to a file or location. Report Email. |
| USER_ADDRESS | No | No |
|
VARCHAR2(50) | NULL | Physical location of the front door / main entrance of the facility site |
| USER_CITY | No | No |
|
VARCHAR2(60) | NULL | The name of the city. |
| USER_STATE | No | No |
|
VARCHAR2(2) | NULL | State abbreviation. |
| USER_ZIPCODE | No | No |
|
VARCHAR2(14) | NULL | The U.S. Postal Service zip code. |
| CREATED_BY | No | No |
|
VARCHAR2(20) | NULL | Created by User ID |
| CREATED_DATE | No | No |
|
DATE | NULL | Created Date |
| MODIFIED_BY | No | No |
|
VARCHAR2(20) | NULL | Modified by User ID |
| MODIFIED_DATE | No | No |
|
DATE | NULL | Modified date |
| UDP(s) of "USER_ID" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_NAME" Column |
| Range Check | Null Check | Valid Table/Values |
| None | Mandatory | None |
| UDP(s) of "USER_PHONE_NUMBER" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_FAX_NUMBER" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_EMAIL_ADDRESS" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_ADDRESS" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_CITY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_STATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "USER_ZIPCODE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "CREATED_BY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "CREATED_DATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "MODIFIED_BY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "MODIFIED_DATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| Index |
| Name | Member |
| XPKEDMS_USER |
|
| Member(s) of "XPKEDMS_USER" Index |
| Column |
| Name |
| USER_ID |
| Child Relationship |
| Child Table |
| Name |
| TRANSFER_FILE |
| Child Table |
| Name |
| NOTE |
| Child Table |
| Name |
| USER_SECURITY |
| Child Table |
| Name |
| USER_ORGANIZATION |
| Parent Relationship |
| Script |
| Name | Code |
| BU |
create or replace trigger %TableOwner.%Substr(%TableName,1,21)_BU
before update on %TableOwner.%TableName for each row
begin
:new.modified_by := user;
:new.modified_date :=sysdate;
end ;
/
|
| BI |
create or replace trigger %TableOwner.%Substr(%TableName,1,21)_BI
before insert on %TableOwner.%TableName for each row
begin
:new.created_by := user;
:new.created_date := sysdate;
:new.modified_by := user;
:new.modified_date :=sysdate;
end ;
/
|