| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
ASOFDATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 5 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 6 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 7 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 8 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 9 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 10 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 11 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 12 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 13 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 14 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 15 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 16 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 17 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 18 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 19 |
COUNTRY_DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Country Description
|
| 20 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 21 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 22 |
POSTAL2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 23 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 24 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 25 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 26 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 27 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 28 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 29 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
|
| 30 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 31 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
Default Value: N
|
| 32 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 33 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 34 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 35 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 36 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 37 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 38 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 39 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 40 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 41 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Suffix
|
| 42 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 43 |
REGISTR_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Registration No.
|
| 44 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 45 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 46 |
RSZ_EMPLR_BEL |
Character(20) |
VARCHAR2(20) NOT NULL |
NOSS - National Office for Social Security
The Dutch acronym is RSZ (Rijksdienst voor Sociale Zekerheid)
The French acronym is ONSS ('l Office National de Securite de Sociale)
|
| 47 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 48 |
IND_COMMITTEE_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level,
|
| 49 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 50 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 51 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 52 |
NOTIFIED_DT |
Date(10) |
DATE |
Date First Notified
|
| 53 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 54 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 55 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 56 |
NOTIFIED_TM |
Time(15) |
TIMESTAMP |
Time First Notified
Default Value: %time
|
| 57 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
Default Value: %datetime
|
| 58 |
DIMONA_ACTION_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Sort Notifications.
1=DIMONA Hire Notification
2=DIMONA Termination Notif.
3=DIMONA Update Notification
4=DIMONA Cancel Notification
|
| 59 |
DIMONA_ADDR_BEL |
Character(45) |
VARCHAR2(45) NOT NULL |
DIMONA Address...
|
| 60 |
DIMONA_BIRTHPL_BEL |
Character(40) |
VARCHAR2(40) NOT NULL |
Birth Place
|
| 61 |
DIMONA_BLK_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Belgium Functionality:
DIMONA SQUARE
|
| 62 |
DIMONA_BUS_NR_BEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Bus Number
|
| 63 |
DIMONA_COMMENT_BEL |
Character(20) |
VARCHAR2(20) NOT NULL |
DIMONA User Comment
|
| 64 |
DIMONA_COMP_NR_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
DIMONA Company Registration Nr
|
| 65 |
DIMONA_COUNCIL_BEL |
Character(35) |
VARCHAR2(35) NOT NULL |
Council
|
| 66 |
DIMONA_CTCT_BEL |
Character(32) |
VARCHAR2(32) NOT NULL |
DIMONA Contact Person.
|
| 67 |
DIMONA_EE_SIS_BEL |
Character(10) |
VARCHAR2(10) NOT NULL |
DIMONA Employee SIS Nummer
|
| 68 |
DIMONA_EE_TYP_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
DIMONA Employee Type.
000=EE's in Building Industry
035=DIMONA Standby EE
STU=DIMONA Student Notification.
XXX=DIMONA All Employees
|
| 69 |
DIMONA_FIL_SRT_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA File Sort
|
| 70 |
DIMONA_FRSTNM_BEL |
Character(24) |
VARCHAR2(24) NOT NULL |
DIMONA First Name
|
| 71 |
DIMONA_FUNC_BEL |
Character(30) |
VARCHAR2(30) NOT NULL |
DIMONA Contact Function...
|
| 72 |
DIMONA_HOUSE_BEL |
Character(5) |
VARCHAR2(5) NOT NULL |
DIMONA House Number
|
| 73 |
DIMONA_IDENT_BEL |
Character(10) |
VARCHAR2(10) NOT NULL |
DIMONA Identification
|
| 74 |
DIMONA_INITIAL_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Initiale
|
| 75 |
DIMONA_INSZ_BEL |
Character(11) |
VARCHAR2(11) NOT NULL |
DIMONA INSZ Identification
|
| 76 |
DIMONA_LAND_CD_BEL |
Character(5) |
VARCHAR2(5) NOT NULL |
DIMONA Country Code
|
| 77 |
POSTAL_NLD |
Character(7) |
VARCHAR2(7) NOT NULL |
Postal Code
|
| 78 |
DIMONA_LANG_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Language
1=Dimona Notification in French
2=DIMONA Notification in German
3=DIMONA Notification in Dutch
|
| 79 |
DIMONA_NAME_BEL |
Character(48) |
VARCHAR2(48) NOT NULL |
DIMONA Name
|
| 80 |
DIMONA_NIV_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Data Level.
|
| 81 |
DIMONA_NOTIF_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
DIMONA Notification Number
|
| 82 |
DIMONA_NR_1_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
DIMONA Sequence Number 1.
|
| 83 |
DIMONA_NR_2_BEL |
Character(5) |
VARCHAR2(5) NOT NULL |
DIMONA Sequence Number 2.
|
| 84 |
DIMONA_NR_BEL |
Character(12) |
VARCHAR2(12) NOT NULL |
DIMONA Nr
|
| 85 |
DIMONA_PARIT_BEL |
Character(7) |
VARCHAR2(7) NOT NULL |
Industrial Committe
|
| 86 |
DIMONA_SEG_NR_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
DIMONA Segment.
|
| 87 |
DIMONA_SENDER_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
Belgium Functionality:
DIMONA (RSZ) Sender Identification
|
| 88 |
DIMONA_SIGN_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Signature
|
| 89 |
DIMONA_SIS_TYP_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA SIS Card.
|
| 90 |
DIMONA_STATUS_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Notification Status
1=DIMONA Notification Done
2=DIMONA Notification cancelled
3=DIMONA Notification Re-done
4=DIMONA Notification Delete
|
| 91 |
DIMONA_STREET_BEL |
Character(35) |
VARCHAR2(35) NOT NULL |
Street Label
|
| 92 |
DIMONA_TEL_BEL |
Character(20) |
VARCHAR2(20) NOT NULL |
DIMONA Tel.
|
| 93 |
DIMONA_TEST_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Test Indicator.
|
| 94 |
DIMONA_VERS_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
DIMONA Version
|
| 95 |
DIMONA_ZONE_1_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 1
|
| 96 |
DIMONA_ZONE_2_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 2
|
| 97 |
DIMONA_ZONE_3_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 3
|
| 98 |
DIMONA_ZONE_4_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 4
|
| 99 |
DIMONA_ZONE_5_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 5
|
| 100 |
DIMONA_ZONE_6_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 6
|
| 101 |
DIMONA_ZONE_7_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 7
|
| 102 |
DIMONA_ZONE_8_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
DIMONA Square 8
|
| 103 |
DIMONA_RESTART_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Restart DIMONA Notification.
Y/N Table Edit
Default Value: N
|
| 104 |
PARTNER_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
|
| 105 |
PARTNER_ROY_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
|
| 106 |
LAST_NAME_PREF_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner
|
| 107 |
DIMONA_START_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DIMONA Start File
|
| 108 |
DIMONA_SEND_NM_BEL |
Character(60) |
VARCHAR2(60) NOT NULL |
DIMONA Sender name.
|
| 109 |
NIS_CNTRY_NR_BEL |
Character(5) |
VARCHAR2(5) NOT NULL |
NIS Country Number.
Used by DIMONA Belgium Feature.
|
| 110 |
NSZ_DUMMY1_1_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy
|
| 111 |
NSZ_DUMMY1_2_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Used By Illness Interface...
Netherlands Social Insurance.
|
| 112 |
NSZ_DUMMY1_3_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Used By Illness Interface...
Netherlands Social Insurance.
|
| 113 |
OFFICIAL_LANG |
Character(3) |
VARCHAR2(3) NOT NULL |
The Official Language is used by Belgium to track the official language for the company and employees. This language code indicates in which language the official reports and communication between company and employees should occur.
Prompt Table:
LANGUAGE_CD_VW
|
| 114 |
COMPANY_FILTR |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|