DFW_ACESLOG_LNG (SQL View)	Index Back
View Record For Base Language

DFW_ACESLOG_LNG

(SQL View)

View Record For Base Language

SELECT O.LANGUAGE_CD , COUNT(*) FROM PSACCESSLOG A , PSOPRDEFN O WHERE A.OPRID = O.OPRID GROUP BY O.LANGUAGE_CD ORDER BY COUNT(*) DESC, LANGUAGE_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

2 DFW_LANG_COUNT Number(9,0) DECIMAL(9) NOT NULL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
2	DFW_LANG_COUNT	Number(9,0)	DECIMAL(9) NOT NULL