PSOPRALIAS_VW

index back

Peoplesoft ID Values

Used 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.
SELECT OPRID , OPRALIASTYPE , OPRALIASVALUE , SETID , EMPLID , CUST_ID , VENDOR_ID , APPLID , CONTACT_ID FROM PSOPRALIAS

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
OPRALIASTYPECharacter(3)VARCHAR2(3) NOT NULLUser ID Type

Prompt Table: PSUSERTYPEVW

OPRALIASVALUECharacter(30)VARCHAR2(30) NOT NULLUser ID Attribute Value
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
CUST_IDCharacter(15)VARCHAR2(15) NOT NULLCustomer ID
VENDOR_IDCharacter(10)VARCHAR2(10) NOT NULLVendor Identifier
APPLIDCharacter(11)VARCHAR2(11) NOT NULLExternal Job Applicant ID
CONTACT_IDCharacter(15)VARCHAR2(15) NOT NULLContact Identifier for Treasury Contacts
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19