CAN_CIS_LANG

(SQL Table)
 Index Back

Can CIS Language

  • Related Language Record: CAN_CIS_LNG_LAN

    • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    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