RY_SVY_SCR_LNG (SQL Table)	Index Back
Employee Engagement Fact Table Fact table for capturing Employee Survey Score Information. ACE reporting is performed based on this table.

RY_SVY_SCR_LNG

(SQL Table)

Employee Engagement Fact Table

Fact table for capturing Employee Survey Score Information. ACE reporting is performed based on this table.

Related Language Record for RY_SVY_SCORES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
Prompt Table: RYEDIALOG_VW

2 SCORE_RG_ID Number(3,0) SMALLINT NOT NULL Workforce Connect - Score Range

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

4 SCORE_RG_DESCR Character(10) VARCHAR2(10) NOT NULL Workforce Connec - Years of service description.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog. Prompt Table: RYEDIALOG_VW
2	SCORE_RG_ID	Number(3,0)	SMALLINT NOT NULL	Workforce Connect - Score Range
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	SCORE_RG_DESCR	Character(10)	VARCHAR2(10) NOT NULL	Workforce Connec - Years of service description.