>> PER_ADDRESSES
Holds address
information for current and ex–employees, current and ex–applicants and
employee contacts. Addresses have a specific address STYLE that identifies the
address format for a specific country, or territory. A person may have more
than one address at any one time, and each address can be in a different style.
The PRIMARY_FLAG
identifies the primary address. Primary addresses are not DateTracked, but they
are contiguous and cannot overlap. From the first date a person has an address
to the last date they have an address, a person must have one primary address.
Any secondary address can be disabled by entering a value in DATE_TO.
>> PER_PHONES
Holds phone numbers
for current and ex–employees, current and ex–applicants and employee contacts
>> PER_CONTACT_RELATIONSHIPS
Holds information
about employee contacts such as dependents, beneficiaries, emergency contacts
or parents. An employee may have an unlimited number of contacts, but only one
may be designated the primary contact at any time. Contacts for a person may
also be employees or applicants in the system
>> PER_PEOPLE_INFO_TYPES
Definitions of extra
information types (EITs) that may be held against a person
>>
PER_PEOPLE_EXTRA_INFO
This table holds
details of extra information for a person, an intersection between PER_PEOPLE_INFO_TYPES
and PER_ALL_PEOPLE_F.
>> PER_ESTABLISHMENTS
This table is used
to maintain a list of educational establishments e.g. schools, colleges,
universities, etc.
>> PER_QUALIFICATION_TYPES
Maintains the list of
qualification types that can be attained like B.Tech, M.Sc., etc..
>> PER_QUALIFICATIONS
A record of
educational qualification, certificates, licenses, etc that a person holds or
is acquiring is stored in this table.
No comments:
Post a Comment