INDIC_SHT_LANG

(SQL Table)
Index Back

Indicator Language 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 is used to setup the various groups and indicators.

  • Related Language Record for INDIC_SHEET_FRA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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

    2 GROUP_SHEET_CD_FRA Character(1) VARCHAR2(1) NOT NULL Indicator Group

    Prompt Table: GROUP_SHEET_FRA

    3 INDIC_SHEET_CD_FRA Character(5) VARCHAR2(5) NOT NULL Indicator
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR1_FRA Character(10) VARCHAR2(10) NOT NULL Column 1 Description
    8 DESCR2_FRA Character(10) VARCHAR2(10) NOT NULL Column 2 Description
    9 DESCR3_FRA Character(10) VARCHAR2(10) NOT NULL Column 3 Description
    10 DESCR4_FRA Character(10) VARCHAR2(10) NOT NULL Column 4 Description
    11 DESCR5_FRA Character(10) VARCHAR2(10) NOT NULL Column 5 Description
    12 DESCR6_FRA Character(10) VARCHAR2(10) NOT NULL Column 6 Description
    13 COMMENTS Long Character CLOB Comment