FO_EMP_OWNERS(SQL Table) |
Index Back |
---|---|
Staffing Employee OwnersStaffing Front Office Employee Owners |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
3 | PRIMARY_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Primary User ID
Y/N Table Edit |
4 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |