S_AL_USR_X ver 20.5.2.0
This table is an extension of the User table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 20.5.2.0 | Number(19,0) | The primary key. |
| UserDCID | 20.5.2.0 | Number(19,0) | The primary key that relates the extended table back to the User table. |
| BackgroundComp | 20.10.2.0 | Number(1,0) | |
| BGDateComp | 20.10.2.0 | Date | |
| BGExpDate | 20.10.2.0 | Date | |
| BGStatus | 20.10.2.0 | Varchar2(50) | |
| DegreeEqDate | 20.10.2.0 | Date | |
| DegreeEqEarned | 20.10.2.0 | Varchar2(50) | |
| DegreeMajor | 20.10.2.0 | Varchar2(50) | |
| AltEmail | 20.10.2.0 | Varchar2(50) | Alternate email address. |
| AltPhoneNum | 20.10.2.0 | Varchar2(12) | Alternate phone number. |
| Exit_Date | 20.5.2.0 | Date | The staff member's exit date. |
| DeviceAccess1 | 22.8.2.0 | Varchar2(3) | |
| DeviceType1 | 22.8.2.0 | Varchar2(3) | |
| DeviceSN1 | 22.8.2.0 | Varchar2(100) | |
| DeviceAccess2 | 22.8.2.0 | Varchar2(3) | |
| DeviceType2 | 22.8.2.0 | Varchar2(3) | |
| DeviceSN2 | 22.8.2.0 | Varchar2(100) | |
| DeviceAccess3 | 22.8.2.0 | Varchar2(3) | |
| DeviceType3 | 22.8.2.0 | Varchar2(3) | |
| DeviceSN3 | 22.8.2.0 | Varchar2(100) | |
| DeviceAccess4 | 22.8.2.0 | Varchar2(3) | |
| DeviceType4 | 22.8.2.0 | Varchar2(3) | |
| DeviceSN4 | 22.8.2.0 | Varchar2(100) |