S_MD_USR_X (ver 16.12.3)
This table is an extension of the [Users] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| UsersDCID | 16.12.3 | Number (10,0) | Primary Key |
| State_ExcludeFromReporting | 16.12.3 | Number (1,0) | Exclude Staff From State Reporting |
| Local_Empoloyee_Number | 16.12.3 | Varchar2(30) | Local Employee Number |
| Maiden_Name | 16.12.3 | Varchar2(50) | Maiden Last Name |
| State_Identifier | 16.12.3 | Varchar2(30) | Unique State Identifier |
| Generational_Suffix | 16.12.3 | Varchar2(10) | Generational Suffix |
| Hispan_Lat_TF | 17.2.0 | Number (1,0) | Hispanic/Latino (True/False) |
| Race_Amer_Ind_TF | 17.2.0 | Number (1,0) | Race: American Indian (True/False) |
| Race_Asian_TF | 17.2.0 | Number (1,0) | Race: Asian (True/False) |
| Race_Black_TF | 17.2.0 | Number (1,0) | Race: Black (True/False) |
| Race_Hawaiian_TF | 17.2.0 | Number (1,0) | Race: Hawaiian/Pacific Islander (True/False) |
| Race_White_TF | 17.2.0 | Number (1,0) | Race: White (True/False) |