AUC_OPRALIAS (SQL Table)	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.

AUC_OPRALIAS

(SQL Table)

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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

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 Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
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	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
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