EDIT_SHTFR_SRCH (SQL View)	Index Back
Employee Survey Table "Employee Survey is a mandatory report in France. It gathers statistics for a company on salaries, training, headcount...The information on this report is classified into indicators and groups. This table stores the value of all the indicators/groups."

EDIT_SHTFR_SRCH

(SQL View)

Employee Survey Table

"Employee Survey is a mandatory report in France. It gathers statistics for a company on salaries, training, headcount...The information on this report is classified into indicators and groups. This table stores the value of all the indicators/groups."

SELECT OPRID ,RUN_CNTL_ID ,TYPE_SHEET_CD_FRA FROM PS_EDIT_SHEET_FRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 TYPE_SHEET_CD_FRA Character(2) VARCHAR2(2) NOT NULL Used to regroup Employee Survey groups of indicators, based on legal requirement.
CT=Trade & Services Company
ET=Trade & Services Establishment
Default Value: ET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	TYPE_SHEET_CD_FRA	Character(2)	VARCHAR2(2) NOT NULL	Used to regroup Employee Survey groups of indicators, based on legal requirement. CT=Trade & Services Company ET=Trade & Services Establishment Default Value: ET