| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW
|
| 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 |
Name 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 Last 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 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 25 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 26 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 27 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 28 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 29 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 30 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 31 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 32 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 33 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 34 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 35 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 36 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 37 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 38 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 39 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 40 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 41 |
PER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee
N=Non-Employee
|
| 42 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 43 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 44 |
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
|
| 45 |
MAR_STATUS_DT |
Date(10) |
DATE |
This is the date that the employee's Marital status is/was effective.
/* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons.
1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user.
2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
|
| 46 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 47 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 48 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 49 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Birth State
Prompt Table:
BIRTHSTATE_VW
|
| 50 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 51 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
|
| 52 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
Y/N Table Edit
|
| 53 |
HIGHLY_COMP_EMPL_P |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the year prior to the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
E=Eligible non-Officer, non 5%
H=Highly Compensated Employee
N=Not Eligible for the Plan
O=Eligible Officer, not HCE
|
| 54 |
HIGHLY_COMP_EMPL_C |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
E=Eligile non-Officer, non 5%
H=Highly Compensated Employee
N=Not Eligible for the Plan
O=Eligible Officer, not HCE
|
| 55 |
PER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Person Type
C=Cobra Participant
D=GP Dependent/Beneficiary
E=Leased Worker
H=Prehire
I=Independent Contractor
L=Time & Labor Contractor
M=Temporary Worker
N=Non HR Administered Employee
O=Other Non-Employee
P=Pension Payee
S=Stock Non-Employee
T=Training Non-Employee
U=Succession Candidate Non-Emplo
|
| 56 |
US_WORK_ELIGIBILTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible to Work in U.S.
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 57 |
MILITARY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Status / Military Status
Default Value: 1
|
| 58 |
CITIZEN_PROOF1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 1)
|
| 59 |
CITIZEN_PROOF2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 2)
|
| 60 |
SMOKER |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
N=Non Smoker
Y=Smoker
Y/N Table Edit
Default Value: N
|
| 61 |
MEDICARE_ENTLD_DT |
Date(10) |
DATE |
Date Entitled to Medicare
|
| 62 |
SMOKER_DT |
Date(10) |
DATE |
Smoker Status Date
|
| 63 |
BILINGUALISM_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bilingualism Code
1=Not Bilingual
2=Bilingual
3=Receptive Skills Only
9=Unknown
|
| 64 |
HEALTH_CARE_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Health Care Number
|
| 65 |
HEALTH_CARE_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Health Care Province
Prompt Table:
PROVINCE_NM_VW
|
| 66 |
GUARDIAN_CHE |
Character(40) |
VARCHAR2(40) NOT NULL |
In Switzerland, it is a requirement for an employee who is 18 years of age or younger to have a guardian on record
|
| 67 |
MILITARY_STAT_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Status
1=Service Completed
2=Exempt from Service
3=Not Applicable
4=Mandatory
5=No Information
|
| 68 |
EXPCTD_MILITARY_DT |
Date(10) |
DATE |
Expected Military Date
|
| 69 |
HR_RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
HR Responsible ID
Prompt Table:
PERSON_NAME
|
| 70 |
ENTRY_DT_FRA |
Date(10) |
DATE |
Date of First Entry in France
|
| 71 |
MILIT_SITUATN_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Status
APA=No Country Person
BEN=Asile Right
DEG=Military Service Done
ETR=Alien
REF=Reformed (don't do milit serv)
SER=Military Service to Come
SUR=Military Service Delayed
|
| 72 |
CPAMID |
Character(6) |
VARCHAR2(6) NOT NULL |
CPAM ID
Prompt Table:
CPAM_TBL
|
| 73 |
HONSEKI_JPN |
Character(2) |
VARCHAR2(2) NOT NULL |
Honseki Prefecture
Prompt Table:
STATE_MC_JPN_VW
|
| 74 |
MILITARY_STAT_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Status Italy
C=Completed
E=Exempt
M=Mandatory
R=Revisited
|
| 75 |
MILITARY_TYPE_ITA |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Service
AE=Airforce
CA=Carabinieri
CI=Civil Service
M=Military
MA=Navy
|
| 76 |
MILITARY_RANK_ITA |
Character(50) |
VARCHAR2(50) NOT NULL |
Function or Rank
|
| 77 |
MILITARY_END_ITA |
Date(10) |
DATE |
Military End Date
|
| 78 |
MILIT_SITUATN_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Status
0=Not Applicable
1=Service Done
2=Exempt from Service
3=Service
4=Conscientious Objector
9=No Information
|
| 79 |
SOC_SEC_AFF_DT |
Date(10) |
DATE |
Social Security Affiliation Dt
|
| 80 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 81 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 82 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 83 |
APP_DT |
Date(10) |
DATE |
Date an application was submitted
|
| 84 |
GVT_CRED_MIL_SVCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Creditable Military Service
|
| 85 |
GVT_MILITARY_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_MILITARY_COMP
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
|
| 86 |
GVT_MIL_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Grade
E1=E1
E2=E2
E3=E3
E4=E4
E5=E5
E6=E6
E7=E7
E8=E8
E9=E9
O1=O1
O10=O10
O2=O2
O3=O3
O4=O4
O5=O5
O6=O6
O7=O7
O8=O8
O9=O9
W1=W1
W2=W2
W3=W3
W4=W4
|
| 87 |
GVT_MIL_RESRVE_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserve Category
A=IMA - Air Force
B=IMA - Army
C=IMA - Coast Guard
D=IMA - Marines
E=IMA - Navy
F=Selected Reserve - Air Force
G=Selected Reserve - Army
H=Selected Reserve - Coast Guard
I=Selected Reserve - Marine Corp
J=Selected Reserves - Navy
K=Air National Guard
L=Army National Guard
M=IRR - Air Force
N=IRR - Army
O=IRR - Coast Guard
P=IRR - Marine Corps
Q=IRR - Navy
S=Standby Reserve - Air Force
T=Standby Reserve - Army
U=Standby Reserve - Coast Guard
V=Standby Reserve - Marine Corps
W=Standby Reserve - Navy
X=Navy Reserve - Merchant Marine
Y=Draft Eligible
Z=Not Applicable
|
| 88 |
GVT_MIL_SEP_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
|
| 89 |
GVT_MIL_SVCE_END |
Date(10) |
DATE |
Military Service End Date
|
| 90 |
GVT_MIL_SVCE_START |
Date(10) |
DATE |
Military Service Start Date
|
| 91 |
GVT_MIL_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Service Verified
|
| 92 |
GVT_PAR_NBR_LAST |
Number(6,0) |
INTEGER NOT NULL |
Last Personnel Action Reqst #
|
| 93 |
GVT_UNIF_SVC_CTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Military Pay Center
|
| 94 |
GVT_VET_PREF_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference
Prompt Table:
GVT_VETPREF_TBL
|
| 95 |
GVT_VET_PREF_RIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference RIF
Default Value: N
|
| 96 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
|
| 97 |
GVT_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
|
| 98 |
GVT_YR_ATTAINED |
Date(10) |
DATE |
Year Attained
|
| 99 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
|
| 100 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Y/N Table Edit
Default Value: N
|
| 101 |
ETHNIC_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Applicable
7=Native Hawaiian/Oth Pac Island
A=American Indian/Alaskan Native
B=Asian or Pacific Islander
C=Black, not of Hispanic origin
D=Hispanic
E=White, not of Hispanic origin
F=Asian Indian
G=Chinese
H=Filipino
J=Guamanian
K=Hawaiian
L=Japanese
M=Korean
N=Samoan
P=Vietnamese
Q=All Other Asian o Pacific Is
Y=Not Hispanic in Puerto Rico
|
| 102 |
GVT_DISABILITY_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Code
Default Value: 05
Prompt Table:
GVT_HANDICP_TBL
|
| 103 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%SAL_GRD_PRMPT1
|
| 104 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Default Value: 0000
Prompt Table:
SAL_PLAN_TBL
|
| 105 |
GVT_CURR_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 106 |
GVT_CURR_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 107 |
GVT_HIGH_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 108 |
GVT_HIGH_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Grade
Prompt Table:
GVT_RCR_SLGR_VW
|
| 109 |
GVT_PREV_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 110 |
GVT_PREV_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 111 |
GVT_SEP_INCENTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive
|
| 112 |
GVT_SEP_INCENT_DT |
Date(10) |
DATE |
Separation Incentive Date
|
| 113 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 114 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 115 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 116 |
ALTER_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Alternate Employee ID
|
| 117 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 1
|
| 118 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 2
|
| 119 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 3
|
| 120 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character City
|
| 121 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 122 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 123 |
RUNDATE |
Date(10) |
DATE |
Process Scheduler Run Date
|