WCS_SO_REL_VW (SQL View)	Index Back
Related Data Tables 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_VW

(SQL View)

Related Data Tables

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 HCMD_CLASSID , DESCR FROM PS_HCMD_META_TBL WHERE HCMD_CLASSID IN ('COMPANY', 'DEPARTMENTS', 'ESTABLSHMENT', 'JOB_CODE', 'LOCATION', 'PAYGROUP', 'SAL_GRADE', 'SAL_PLAN', 'SAL_STEP', 'UNIONS')

Related Language Record: WCS_SO_REL_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description