PSCOLLATIONS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COLLATION_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Collation Type Information 000=Binary Sorting B00=Latin1 (Default) B01=Canadian French (General) B02=Danish (General) B03=Dutch (General) B04=Spanish (General) B05=French (General) B06=German (General) B07=Italian (General) B08=Japanese (General) B09=Portuguese (General) B10=Swedish (General) B11=Simplified Chinese (General) B12=Traditional Chinese (General) B13=Danish (Linguistic) B14=Dutch (Linguistic) B15=Spanish (Linguistic) B16=French (Linguistic) B17=German (Linguistic) B18=Italian (Linguistic) B19=Portuguese (Linguistic) B20=Swedish (Linguistic) B21=Japanese (Linguistic) B22=English
2	COLLATION_NAME	Character(40)	VARCHAR2(40) NOT NULL	Physical name of collations