OPRIDOPRALIASTYPEPrompt Table: PSUSERTYPEVW
PSOPRALIAS(SQL Table) |
Index Back |
|---|---|
Peoplesoft ID ValuesUsed to store ID values corresponding to various ID types. For example, stores EMPLID for Employee type. The field OPRALIASVALUE is retained for backward compatibility. New development should not use this field. And where practical, existing references to this field should be replaced with one of the other appropriate fields. Backward compatibility with opraliasvalue is achieved by updating this field with the value in the last (but not greater than 2nd) field in the definition of the ID type. So if one field in ID type definition (eg EMPLID), value of that field is stored in opraliasvalue as well. If two fields in ID type definition (eg, setid & cust_id), value of second field (cust_id) is stored in opraliasvalue as well. If three fields in ID type definition (eg, setid, cust_id, cntct_seq_num), value of second field (cust_id) is stored in opraliasvalue as well. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | OPRALIASTYPE |
Character(3) | VARCHAR2(3) NOT NULL |
User ID Type
Prompt Table: PSUSERTYPEVW |
| 3 | OPRALIASVALUE | Character(30) | VARCHAR2(30) NOT NULL | User ID Attribute Value |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | APPLID | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 9 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 10 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 11 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 12 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 13 | EOTP_PARTNERID | Number(15,0) | DECIMAL(15) NOT NULL | Partner ID |