S_NM_USR_ASSIGNMENTS_C (ver 15.9.0)
This is a child table of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 15.9.0 | Number(10,0) | Primary Key |
AssignmentNumber | 15.9.0 | Number(10,0) | The number for this assignment |
PositionCode | 15.9.0 | Varchar2(10) | The position code value of this assignment |
StartDate | 15.9.0 | Date | The date this assignment became active |
EndDate | 15.9.0 | Date | The date this assignment ended |
FTE | 15.9.0 | Number(25,10) | The FTE percentage of this assignment |
Location | 15.9.0 | Number(10,0) | The location the assignment is to be reported under |