| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
Default Value: OPR_DEF_TBL_HR.COUNTRY_NM_FORMAT
Prompt Table:
NAME_FORMAT_TBL
|
| 6 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 7 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 8 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 9 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table:
NAME_SUFFIX_TBL
|
| 10 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
Prompt Table:
NM_ROYPREF_GBL
|
| 11 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name - Royal Suffix
Prompt Table:
NM_ROYSUFF_GBL
|
| 12 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Name Title
Prompt Table:
TITLE_TBL
|
| 13 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 14 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 15 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 16 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 17 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 18 |
SECOND_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 19 |
SECOND_LAST_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 20 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 21 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 22 |
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.
|
| 23 |
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
|
| 24 |
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
|
| 25 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 26 |
NAME_FORMAL |
Character(60) |
VARCHAR2(60) NOT NULL |
Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
|
| 27 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 28 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 29 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 30 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 31 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 32 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 33 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 34 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 35 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 36 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 37 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 38 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 39 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 40 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 41 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 42 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 43 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 44 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table:
COUNTRY_TBL
|
| 45 |
ADDRESS1_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1 Other
|
| 46 |
ADDRESS2_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2 Other
|
| 47 |
ADDRESS3_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3 Other
|
| 48 |
ADDRESS4_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4 Other
|
| 49 |
CITY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
City Other
|
| 50 |
COUNTY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
County Other
|
| 51 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
Prompt Table:
STATE_OTH
|
| 52 |
POSTAL_OTHER |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Other
|
| 53 |
NUM1_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1 Other
|
| 54 |
NUM2_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2 Other
|
| 55 |
HOUSE_TYPE_OTHER |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type Other
AB=House Boat Reference
WW=House Trailer Reference
|
| 56 |
ADDR_FIELD1_OTHER |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1 Other
|
| 57 |
ADDR_FIELD2_OTHER |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2 Other
|
| 58 |
ADDR_FIELD3_OTHER |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3 Other
|
| 59 |
IN_CITY_LMT_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit Other
Y/N Table Edit
|
| 60 |
GEO_CODE_OTHER |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code Other
|
| 61 |
GVT_STATE_CNTRY_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
State Country Code
|
| 62 |
GVT_CITY_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
City Code
|
| 63 |
GVT_COUNTY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
County Code Name
|
| 64 |
GVT_STATE_CTRY_CD2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Federal NFC Field
|
| 65 |
GVT_CITY_CODE2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Federal NFC Field
|
| 66 |
GVT_DESIG_AGENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Designated Agent Code
Prompt Table:
GVT_DESIG_AGENT
|
| 67 |
PER_ORG |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
Default Value: EMP
|
| 68 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 69 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
Default Value: F
|
| 70 |
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: U
|
| 71 |
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. */
|
| 72 |
BIRTHDATE |
Date(10) |
DATE NOT NULL |
Date of Birth
|
| 73 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 74 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Default Value: USA
Prompt Table:
COUNTRY_TBL
|
| 75 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Birth State
Prompt Table:
BIRTHSTATE_VW
|
| 76 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 77 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
Default Value: 01
|
| 78 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
Y/N Table Edit
Default Value: N
|
| 79 |
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
|
| 80 |
MILITARY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Status / Military Status
Default Value: 1
|
| 81 |
CITIZEN_PROOF1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 1)
|
| 82 |
CITIZEN_PROOF2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 2)
|
| 83 |
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
|
| 84 |
MEDICARE_ENTLD_DT |
Date(10) |
DATE |
Date Entitled to Medicare
|
| 85 |
SMOKER_DT |
Date(10) |
DATE |
Smoker Status Date
|
| 86 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 1
|
| 87 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 2
|
| 88 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 3
|
| 89 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character City
|
| 90 |
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
|
| 91 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 92 |
GVT_CRED_MIL_SVCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Creditable Military Service
|
| 93 |
GVT_MILITARY_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_MILITARY_COMP
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
|
| 94 |
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
|
| 95 |
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
|
| 96 |
GVT_MIL_SEP_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
|
| 97 |
GVT_MIL_SVCE_END |
Date(10) |
DATE |
Military Service End Date
|
| 98 |
GVT_MIL_SVCE_START |
Date(10) |
DATE |
Military Service Start Date
|
| 99 |
GVT_MIL_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Service Verified
Y/N Table Edit
|
| 100 |
GVT_PAR_NBR_LAST |
Number(6,0) |
INTEGER NOT NULL |
Last Personnel Action Reqst #
|
| 101 |
GVT_UNIF_SVC_CTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Military Pay Center
Y/N Table Edit
|
| 102 |
GVT_VET_PREF_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference
Default Value: 1
Prompt Table:
GVT_VETPREF_TBL
|
| 103 |
GVT_VET_PREF_RIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference RIF
Y/N Table Edit
Default Value: N
|
| 104 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
|
| 105 |
GVT_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
|
| 106 |
GVT_YR_ATTAINED |
Date(10) |
DATE |
Year Attained
|
| 107 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
|
| 108 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Default Value: N
Prompt Table:
GVT_HANDICP_TBL
|
| 109 |
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
Prompt Table:
ETHNIC_GRP_TBL
|
| 110 |
GVT_DISABILITY_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Code
Default Value: 05
Prompt Table:
GVT_HANDICP_TBL
|
| 111 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%SAL_GRD_PRMPT1
|
| 112 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Default Value: 0000
Prompt Table:
SAL_PLAN_TBL
|
| 113 |
GVT_CURR_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 114 |
GVT_CURR_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 115 |
GVT_HIGH_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 116 |
GVT_HIGH_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Grade
Prompt Table:
%SAL_GRD_PRMPT3
|
| 117 |
GVT_PREV_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 118 |
GVT_PREV_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 119 |
GVT_SEP_INCENTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive
|
| 120 |
GVT_SEP_INCENT_DT |
Date(10) |
DATE |
Separation Incentive Date
|
| 121 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 122 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 123 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 124 |
ALTER_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Alternate Employee ID
|
| 125 |
UPDATE_PERS_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Personal Data
Y/N Table Edit
Default Value: N
|