CAN_RPT_TONGUE(SQL Table) |
Index Back |
---|---|
Language Mapping* Sac-r75-19990831 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Prompt Table: LANGUAGE_VW |
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 | CAN_RPT_TONGUE | Character(1) | VARCHAR2(1) NOT NULL |
Language First Spoken
1=English 2=French 3=Other |
5 | 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 Prompt Table: CAN_CIS_LANG |
6 | CAN_GOV_LANG | Character(3) | VARCHAR2(3) NOT NULL |
ESIS Language Code
* Sac-r75-19990831
Prompt Table: CAN_GOV_LANG |