Users Data Element
The Users Data Element manages the system users, their authentication details, and profile information.
USERS
| Field | Type | Comment |
|---|---|---|
| USER_ID | Number | Unique identifier for the User |
| String | User's email address (UNIQUE, NOT NULL) | |
| FIRST_NAME | String | First Name |
| LAST_NAME | String | Last Name |
| IS_ACTIVE | Boolean | Indicator if the user is active (default: true) |
| CAN_APPROVE_WORKSHEETS | Boolean | Indicator if the user can approve worksheets (default: false) |
| CREATED_BY | String | User who created the record |
| CREATED_DT | Timestamp | Timestamp when the record was created |
| UPDATED_BY | String | User who last updated the record |
| UPDATED_DT | Timestamp | Timestamp when the record was last updated |