OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDASOFDATETYPE_SHEET_CD_FRACT=Trade & Services Company
ET=Trade & Services Establishment
Default Value: ET
GROUP_SHEET_CD_FRAPrompt Table: GROUP_SHEET_FRA
EDIT_GRPSHT_VW(SQL View) |
Index Back |
|---|---|
Social Situation as of dt ViewThis view returns the As of Date Groups of indicators for Employee Survey report. |
| SELECT DISTINCT OPRID , RUN_CNTL_ID , ASOFDATE , TYPE_SHEET_CD_FRA , GROUP_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).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | ASOFDATE |
Date(10) | DATE | 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 |