PSOPRALIASTYPE (SQL Table)	Index Back
Peoplesoft ID Types Used to define various Peoplesoft IDs. Eg: employee, customer, vendor.

PSOPRALIASTYPE

(SQL Table)

Peoplesoft ID Types

Used to define various Peoplesoft IDs. Eg: employee, customer, vendor.

Related Language Record: PSOPRALSTYPLANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRALIASTYPE	Character(3)	VARCHAR2(3) NOT NULL	User ID Type
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	DESCRLONG	Long Character	CLOB	Long Description