NATION_CDPrompt Table: COUNTRY_TBL
Y/N Table Edit
Y/N Table Edit
NATIONS_DUEVO(SQL Table) |
Index Back |
|---|---|
GER - Nations Duevo TableThe Nation Duvo Table is maintained by PeopleSoft and stores Nationality codes specified by the German Duvo Directive that regulates how data is to be provided by companies doing business in Germany to the German social insurance administration. Using these codes is required for compliance with the German Duvo (Data Transmission/Transfer) Directive. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NATION_CD |
Character(3) | VARCHAR2(3) NOT NULL | Nationality Key |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | NATIONALITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Nationality Code |
| 5 | NATIONALITY | Character(30) | VARCHAR2(30) NOT NULL | Nationality |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 7 | OECD_COUNTRY | Character(1) | VARCHAR2(1) NOT NULL |
OECD Country
Y/N Table Edit |
| 8 | EU_LAND | Character(1) | VARCHAR2(1) NOT NULL |
EU-Land
Y/N Table Edit |