PPK_OWNER_IDPPK_OWNER_ID_VW(SQL View) |
Index Back |
|---|---|
PPK_OWNER_ID prompt viewPrompt view for field PPK_OWNER_ID |
| SELECT B.NAME , A.EMPLID , A.OPRID FROM %Table(PSOPRDEFN) A , %Table(PERSONAL_DATA) B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PPK_OWNER_ID |
Character(50) | VARCHAR2(50) NOT NULL | Operator ID for the approver |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | BC_PROJ_OWNER_ID | Character(30) | VARCHAR2(30) NOT NULL | Project Owner ID |