Difference between revisions of "PeopleSoft Nationality Data"

From TekiWiki
Jump to: navigation, search
m (1 revision imported)
 
Line 1: Line 1:
[[PeopleSoft]] maintains a range of data about nationality:
+
There are several [[PeopleSoft]] records that contain information about nationality.
  
CITIZENSHIP record contains the nationality (or nationalities) of an employee.
+
==CITIZENSHIP record==
  
PeopleSoft can also hold the current visas held by an employee too.
+
This record holds the the countries and citizenship status of both employees and dependents.
 +
 
 +
The citizenship status can be set for each country, but generally is:
 +
 
 +
T - Native
 +
A - Naturalised
 +
D - Dual
 +
 
 +
==CITIZEN_PSSPRT Record==
 +
 
 +
This holds s history of employees and their dependents' passports. The data can include the passport number, date issued and by whom and also the expiry date.
 +
 
 +
==VISA_PMT_DATA Record==
 +
 
 +
This record holds visa permit information for each employee and their dependents. Again, this can hold the start date, the visa number, the status, who issued the visa and the expiration date.
  
As a general rule, to determine who pays an employee, check the PAYGROUP field of the JOB record.
 
  
  

Latest revision as of 17:22, 29 March 2016

There are several PeopleSoft records that contain information about nationality.

CITIZENSHIP record

This record holds the the countries and citizenship status of both employees and dependents.

The citizenship status can be set for each country, but generally is:

T - Native A - Naturalised D - Dual

CITIZEN_PSSPRT Record

This holds s history of employees and their dependents' passports. The data can include the passport number, date issued and by whom and also the expiry date.

VISA_PMT_DATA Record

This record holds visa permit information for each employee and their dependents. Again, this can hold the start date, the visa number, the status, who issued the visa and the expiration date.


UsingFunctionsInPeopleSoftQuerySmall.jpg

Using Functions in PeopleSoft Query

PeopleSoft Query

PeopleSoftUserCompanion.jpg

PeopleSoft Users Companion