RY_SVY_SURVEY_V (SQL View)	Index Back
EE Workforce score brackets Table for setting min/max scores for dialogs Surveys. ACE reporting uses this information.

RY_SVY_SURVEY_V

(SQL View)

EE Workforce score brackets

Table for setting min/max scores for dialogs Surveys. ACE reporting uses this information.

SELECT A.DIALOG_ID , B.RY_DIALOG_NAME , A.RY_SVY_MIN_SCORE , A.RY_SVY_MAX_SCORE , B.RY_DIALOG_STATUS , B.DESCR254 FROM PS_RY_SVY_SURVEY A , PS_RYEDIALOG B WHERE A.DIALOG_ID = B.DIALOG_ID

# 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.

2 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.

3 RY_SVY_MIN_SCORE Signed Number(5,0) DECIMAL(4) NOT NULL Minimum Score field to keep track the lowest score.

4 RY_SVY_MAX_SCORE Signed Number(5,0) DECIMAL(4) NOT NULL Maximum Score field to keep track the highest score.

5 RY_DIALOG_STATUS Character(1) VARCHAR2(1) NOT NULL Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

#	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.
2	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.
3	RY_SVY_MIN_SCORE	Signed Number(5,0)	DECIMAL(4) NOT NULL	Minimum Score field to keep track the lowest score.
4	RY_SVY_MAX_SCORE	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum Score field to keep track the highest score.
5	RY_DIALOG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.
6	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254