RGM_BSE_ESP_LNG

(SQL Table)
 Index Back

Work Group Rel.Lang. - ESP

Work Group Related Language Table - ESP

  • Related Language Record for RGM_BSE_ESP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP
    2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SOC_SEC_WRK_GRP_CD Character(2) VARCHAR2(2) NOT NULL Social Security Work Group
    01=01-Engineers
    02=02-Technicals
    03=03-Administrative
    04=04-Assistants
    05=05-White Collar
    06=06-Subordinates
    07=07-Administrative assistants
    08=08-1st and 2nd degree
    09=09-3rd degree
    10=10-Over 18 years
    11=11-Under 18 years
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50