CAN_CIS_LNG_LAN

(SQL Table)
 Index Back

CAN_CIS_LANG Related Language

Related language record for CAN_CIS_LANG

  • Related Language Record for CAN_CIS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAN_CIS_LANGUAGE Character(1) VARCHAR2(1) NOT NULL CIS - Language First Spoken
    1=English
    2=French
    3=German
    4=Ukrainian
    5=North, South American Native
    6=Dutch/Scandinavian
    7=Oriental
    8=Other
    9=Not Reported/Unknown
    A=Northern Africa/Middle Eastern
    B=Italian, Portuguese, Spanish
    C=Japanese, Korean
    D=S.E. Asian
    E=Indo-Iranian
    F=Indonesian
    G=Other African
    H=Northern European, Asian
    I=Other Indo-European
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CAN_CIS_LANG.DESCR