WCS_SO_REL_LVW (SQL View)	Index Back
Related Data Tables Related language view for WCS_SO_REL_VW. This view presents the tables that can be reached through relationships from the core employee data tables. The classes listed in the WHERE clause represent the classes that are used and supported by the configurable matrix functions.

WCS_SO_REL_LVW

(SQL View)

Related Data Tables

Related language view for WCS_SO_REL_VW. This view presents the tables that can be reached through relationships from the core employee data tables. The classes listed in the WHERE clause represent the classes that are used and supported by the configurable matrix functions.

SELECT A.HCMD_CLASSID , A.LANGUAGE_CD , A.DESCR FROM PS_HCMD_META_LNG A , PS_HCMD_META_TBL B WHERE A.HCMD_CLASSID = B.HCMD_CLASSID AND B.HCMD_CLASSID IN ('COMPANY', 'DEPARTMENTS', 'ESTABLSHMENT', 'JOB_CODE', 'LOCATION', 'PAYGROUP', 'SAL_GRADE', 'SAL_PLAN', 'SAL_STEP', 'UNIONS')

Related Language Record for WCS_SO_REL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HCMD_CLASSID	Character(12)	VARCHAR2(12) NOT NULL	EI_CLASSID
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description