OPR_ASSGNTO_VW(SQL View) |
Index Back |
---|---|
View of Assign To Operators |
select a.oprid, a.name1 from ps_opr_def_tbl_fs a, PS_OPR_DEF_TBL_AP b where a.oprid = b.oprid |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Assigned to |
2 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |