LM_GRD_SCH_VW (SQL View)	Index Back
Grade Schemes Grade Scheme Values. This view will have all the User Labels / Grade values.

LM_GRD_SCH_VW

(SQL View)

Grade Schemes

Grade Scheme Values. This view will have all the User Labels / Grade values.

SELECT LM_GRADE_VAL_ID , LM_GRADE_LABEL FROM PS_LM_GRD_SCH_VAL

Related Language Record: LM_GRD_VW_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.

2 LM_GRADE_LABEL Character(30) VARCHAR2(30) NOT NULL Grade

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_GRADE_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	This will uniquely identify the combination of User Label / Grade value.
2	LM_GRADE_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Grade