| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table:
NAME_FORMAT_TBL
|
| 3 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 4 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 5 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 6 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table:
NAME_SUFFIX_TBL
|
| 7 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
Prompt Table:
NM_ROYPREF_GBL
|
| 8 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Suffix
Prompt Table:
NM_ROYSUFF_GBL
|
| 9 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Title
Prompt Table:
TITLE_TBL
|
| 10 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 11 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 12 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 13 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 14 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 15 |
SECOND_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 16 |
SECOND_LAST_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Name
|
| 17 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 18 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 19 |
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.
|
| 20 |
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.
Prompt Table:
NM_ROYPREF_GBL
|
| 21 |
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
Default Value: 1
|
| 22 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 23 |
NAME_FORMAL |
Character(60) |
VARCHAR2(60) NOT NULL |
Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
|
| 24 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 25 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 26 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 27 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 28 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 29 |
GPNL_SOC_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security Number
|
| 30 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_SEC_VW
|
| 31 |
GB_EFFDT |
Date(10) |
DATE |
Group As Of Date
|
| 32 |
GB_REFINE_DATE |
Date(10) |
DATE |
Refinement Date
|
| 33 |
GPNL_BLD_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Rebuild Group
Y/N Table Edit
|
| 34 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 35 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 36 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 37 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 38 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 39 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 40 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 41 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 42 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 43 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 44 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 45 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 46 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 47 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 48 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 49 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
|
| 50 |
REGISTR_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Registration No.
|
| 51 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 52 |
END_DT |
Date(10) |
DATE |
end date
|
| 53 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 54 |
GPNL_SENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sender information
Y/N Table Edit
|
| 55 |
GPNL_COLUMN_10 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 10
|
| 56 |
GPNL_COLUMN_11 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 11
|
| 57 |
GPNL_COLUMN_14 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 14
|
| 58 |
GPNL_COLUMN_15 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 15
|
| 59 |
GPNL_COLUMN_16 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 16
|
| 60 |
GPNL_COLUMN_2 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 2
|
| 61 |
GPNL_COLUMN_3 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 3
|
| 62 |
GPNL_COLUMN_4 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 4
|
| 63 |
GPNL_COLUMN_5 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 5
|
| 64 |
GPNL_COLUMN_7 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 7
|
| 65 |
GPNL_COLUMN_9 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Personal Report Column 9
|
| 66 |
GPNL_BSREG |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Regular
|
| 67 |
GPNL_BSNRG |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Non Regular
|
| 68 |
GPNL_SALARY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Salary
|
| 69 |
GPNL_CBS_SAVE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Field for storing the Save as you Earn (Spaarloon) amount while processing the payroll data for reporting to the Central Bureau of Statistics in the Netherlands
|
| 70 |
GPNL_CBS_OVERWRK_L |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Overtime Loon
|
| 71 |
GPNL_CBS_OVERWRK_U |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Overtime Hours
|
| 72 |
GPNL_NBR_HOURS |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Number of Hours
|
| 73 |
GPNL_RED_HRS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
This field is used for the Netherlands to track Reduced Hours, known as 'ADV' hours.
|
| 74 |
GPNL_VAC_DAYS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
GPNL_VAC_DAYS
|
| 75 |
GPNL_WAIT_DAYS |
Number(2,0) |
SMALLINT NOT NULL |
Waiting Days
|
| 76 |
EMPLR_TAX_NUM_NLD |
Number(9,0) |
DECIMAL(9) NOT NULL |
Federal Employer Tax ID
|
| 77 |
GPNL_TAX_NUM_SUF |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Number Suffix
|
| 78 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 79 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 80 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 81 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 82 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 83 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 84 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 85 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 86 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 87 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 88 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 89 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 90 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 91 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 92 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 93 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 94 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 95 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 1
|
| 96 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 2
|
| 97 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 3
|
| 98 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character City
|
| 99 |
POSTAL2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 100 |
CONTACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact - Vacancy Announcement
Prompt Table:
PERS_SRCH_GBL
|
| 101 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 102 |
CONTACT_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Contact Phone
|
| 103 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 104 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 105 |
GPNL_CBS_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
GPNL_CBS_FREQ
M=Monthly
P=Period
Q=Quartely
W=Weekly
|
| 106 |
GPNL_CBS_IDENT |
Character(12) |
VARCHAR2(12) NOT NULL |
CBS Identification Number.
Identification/Registration Code, delivred by a given administration services.
|
| 107 |
GPNL_CBS_CAO_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
CBS CAO Code.
Labour Agreement Code, delivered by a given administration services.
|
| 108 |
ADDRESS1_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1 Other
|
| 109 |
ADDRESS2_2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 2
|
| 110 |
ADDRESS3_2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 111 |
POSTAL_OTHER |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Other
|
| 112 |
CITY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
City Other
|
| 113 |
PER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee
N=Non-Employee
|
| 114 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 115 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 116 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 117 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Birth State
Prompt Table:
BIRTHSTATE_VW
|
| 118 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 119 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 120 |
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
Default Value: S
|
| 121 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Default Value: U
|
| 122 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 123 |
DESCR_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Char Description
|
| 124 |
GPNL_FILE_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
File Name
|
| 125 |
GPNL_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
File Path
|