RB_THSRS_OPRID(SQL View) |
Index Back |
---|---|
Thesaurus OpridManage Thesaurus for Verify - Table to hold the last Thesaurus Oprid |
SELECT DISTINCT A.ROW_ADDED_OPRID ,B.OPRDEFNDESC FROM PS_RB_THESAURUS_BS A , PSOPRDEFN B WHERE B.OPRID=A.ROW_ADDED_OPRID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |