OPRIDRUN_CNTL_IDASOFDATETYPE_SHEET_CD_FRACT=Trade & Services Company
ET=Trade & Services Establishment
Default Value: ET
GROUP_SHEET_CD_FRAPrompt Table: GROUP_SHEET_FRA
INDIC_SHEET_CD_FRAPrompt Table: INDIC_SHEET_FRA
EDIT_SHEET_FRA(SQL Table) |
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." |
| # | 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 | ASOFDATE |
Date(10) | DATE NOT NULL | As of Date |
| 4 | 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 |
| 5 | GROUP_SHEET_CD_FRA |
Character(1) | VARCHAR2(1) NOT NULL |
Indicator Group
Prompt Table: GROUP_SHEET_FRA |
| 6 | INDIC_SHEET_CD_FRA |
Character(5) | VARCHAR2(5) NOT NULL |
Indicator
Prompt Table: INDIC_SHEET_FRA |
| 7 | NVALUE_SHEET_1_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 1 |
| 8 | NVALUE_SHEET_2_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 2 |
| 9 | NVALUE_SHEET_3_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 3 |
| 10 | NVALUE_SHEET_4_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 4 |
| 11 | NVALUE_SHEET_5_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 5 |
| 12 | NVALUE_SHEET_6_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 6 |