EOTP_PARTNERIDOPRIDEOTP_PARTNERUSR(SQL View) |
Index Back |
|---|---|
Partner User ViewPartner Users |
| SELECT DISTINCT A.EOTP_PARTNERID , B.OPRID , C.OPRDEFNDESC , C.OPERPSWD , ' ' ,' ' ,' ' FROM PS_EOTP_PARTNER A , PSOPRALIAS B , PSOPRDEFN C WHERE A.EOTP_PARTNERID = B.EOTP_PARTNERID AND C.OPRID = B.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOTP_PARTNERID |
Number(15,0) | DECIMAL(15) NOT NULL | Partner ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 4 | OPERPSWD | Character(32) | VARCHAR2(32) NOT NULL | An user's password |
| 5 | OPERPSWDCONF | Character(32) | VARCHAR2(32) NOT NULL | Confirm Password |
| 6 | EOTP_ADMIN | Character(1) | VARCHAR2(1) NOT NULL | Field determins if partner is Administrator or not |
| 7 | EOTP_EMAILADDR | Character(70) | VARCHAR2(70) NOT NULL | Partner Contact Email Address |