OPR_ASSGNBY_VW(SQL View) |
Index Back |
---|---|
View of Assign by 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_BY_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Group Assigned by |
2 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |