| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Format for Country
|
| 4 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 5 |
NAME_INITIALS |
Character(6) |
VARCHAR2(6) NOT NULL |
Name Initials
|
| 6 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
1=Mr.
2=Mrs.
3=Ms.
|
| 7 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 8 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 9 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Suffix
|
| 10 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Title
|
| 11 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 12 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 13 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 14 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 15 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Middle Name
|
| 16 |
SECOND_LAST_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Name
|
| 17 |
SECOND_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 18 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 19 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 20 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 21 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 22 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 23 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 24 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 25 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 26 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 27 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 28 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 29 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 30 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 31 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 32 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 33 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 34 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 35 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 36 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 37 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table:
COUNTRY_TBL
|
| 38 |
ADDRESS1_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1 Other
|
| 39 |
ADDRESS2_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2 Other
|
| 40 |
ADDRESS3_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3 Other
|
| 41 |
ADDRESS4_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4 Other
|
| 42 |
CITY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
City Other
|
| 43 |
COUNTY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
County Other
|
| 44 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
Prompt Table:
%EDIT_STATE_OTH
|
| 45 |
POSTAL_OTHER |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Other
|
| 46 |
NUM1_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1 Other
|
| 47 |
NUM2_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2 Other
|
| 48 |
HOUSE_TYPE_OTHER |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type Other
AB=House Boat Reference
WW=House Trailer Reference
|
| 49 |
ADDR_FIELD1_OTHER |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1 Other
|
| 50 |
ADDR_FIELD2_OTHER |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2 Other
|
| 51 |
ADDR_FIELD3_OTHER |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3 Other
|
| 52 |
IN_CITY_LMT_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit Other
|
| 53 |
GEO_CODE_OTHER |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code Other
|
| 54 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 55 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 56 |
PER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee
N=Non-Employee
Default Value: E
|
| 57 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Hire Date
|
| 58 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
Default Value: U
|
| 59 |
AGE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Age 18 or Older
Y/N Table Edit
Default Value: Y
|
| 60 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
M=Married
S=Single
U=Unknown
W=Widowed
Default Value: S
|
| 61 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 62 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 63 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 64 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Birth State
Prompt Table:
STATE_TBL
|
| 65 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 66 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
Default Value: A
|
| 67 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
Y/N Table Edit
Default Value: N
|
| 68 |
REFERRAL_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Referral Source
AD=Advertisement
AG=Agency
CL=Client Referral
CO=College Recruiting
EE=Employee
FE=Former Employee
JF=Job Fair
JP=Job Posting
OH=Open House
OT=Other Source
PI=Phone Inquiry
UK=Unknown
US=Unsolicited
WI=Walk-In
XR=Executive Referral
XS=Executive Search
Default Value: UK
|
| 69 |
EMPL_REFERRAL_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPL_REFERRAL_ID
Prompt Table:
PERSONAL_DATA
|
| 70 |
SPECIFIC_REFER_SRC |
Character(30) |
VARCHAR2(30) NOT NULL |
Specific Referral Source
|
| 71 |
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
Default Value: N
|
| 72 |
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
Default Value: N
|
| 73 |
RESUME_TEXT_FILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Resume Text File
|
| 74 |
QDRO_IND_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Empl has QDRO indicator (Y/N)
|
| 75 |
PER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Person Type
A=Applicant
C=Cobra Participant
D=GP Dependent/Beneficiary
E=Leased Worker
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
|
| 76 |
US_WORK_ELIGIBILTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible to Work in U.S.
Y/N Table Edit
Default Value: Y
|
| 77 |
MILITARY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Status
1=Not Indicated
2=No Military Service
3=Veteran of the Vietnam Era
4=Other Protected Veteran
5=Active Reserve
6=Inactive Reserve
7=Retired Military
8=Veteran (VA Ineligible)
9=Vietnam & Other Protected Vet
B=Pre-Vietnam-Era Veteran
N=Not a Vietnam-Era Veteran
P=Post-Vietnam-Era Veteran
V=Vietnam-Era Veteran
X=Not a Veteran
Default Value: 1
|
| 78 |
CITIZEN_PROOF1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 1)
|
| 79 |
CITIZEN_PROOF2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Citizenship (Proof 2)
|
| 80 |
SMOKER |
Character(1) |
VARCHAR2(1) NOT NULL |
Smoker
Y/N Table Edit
Default Value: N
|
| 81 |
MEDICARE_ENTLD_DT |
Date(10) |
DATE |
Date Entitled to Medicare
|
| 82 |
BILINGUALISM_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bilingualism Code
1=Not Bilingual
2=Bilingual
3=Receptive Skills Only
9=Unknown
|
| 83 |
HEALTH_CARE_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Health Care Number
|
| 84 |
HEALTH_CARE_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Health Care Province
|
| 85 |
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
|
| 86 |
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
|
| 87 |
EXPCTD_MILITARY_DT |
Date(10) |
DATE |
Expected Military Date
|
| 88 |
HR_RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
HR Responsible ID
Prompt Table:
PERSONAL_DATA
|
| 89 |
ENTRY_DT_FRA |
Date(10) |
DATE |
Date of First Entry in France
|
| 90 |
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
|
| 91 |
CPAMID |
Character(6) |
VARCHAR2(6) NOT NULL |
CPAM ID
|
| 92 |
HONSEKI_JPN |
Character(2) |
VARCHAR2(2) NOT NULL |
Honseki Prefecture
|
| 93 |
TAX_CODE_UK |
Character(5) |
VARCHAR2(5) NOT NULL |
Tax Code
|
| 94 |
TAX_BASIS_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Basis
0=Cumalative
1=Week 1/Month 1
|
| 95 |
MILITARY_STAT_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Status Italy
|
| 96 |
MILITARY_TYPE_ITA |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Service
|
| 97 |
MILITARY_RANK_ITA |
Character(50) |
VARCHAR2(50) NOT NULL |
Function or Rank
|
| 98 |
MILITARY_END_ITA |
Date(10) |
DATE |
Military End Date
|
| 99 |
MILIT_SITUATN_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Status
|
| 100 |
SOC_SEC_AFF_DT |
Date(10) |
DATE |
Social Security Affilation Dt
|
| 101 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 1
|
| 102 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 2
|
| 103 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 3
|
| 104 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 105 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character City
|
| 106 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 107 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 108 |
APP_DT |
Date(10) |
DATE |
Application Date
|
| 109 |
ON_DM_EM_DOSAVENOW |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used for internal processing (PeopleCode). Do not populate.
|
| 110 |
GVT_CRED_MIL_SVCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Creditable Military Service
|
| 111 |
GVT_MILITARY_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Uniformed Service
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
|
| 112 |
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
|
| 113 |
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
|
| 114 |
GVT_MIL_SEP_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
|
| 115 |
GVT_MIL_SVCE_END |
Date(10) |
DATE |
Military Service End Date
|
| 116 |
GVT_MIL_SVCE_START |
Date(10) |
DATE |
Military Service Start Date
|
| 117 |
GVT_MIL_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Service Verified
|
| 118 |
GVT_PAR_NBR_LAST |
Number(6,0) |
INTEGER NOT NULL |
Last Personnel Action Reqst #
|
| 119 |
GVT_UNIF_SVC_CTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Military Pay Center
|
| 120 |
GVT_VET_PREF_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference
|
| 121 |
GVT_VET_PREF_RIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference RIF
Default Value: N
|
| 122 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
|
| 123 |
GVT_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
|
| 124 |
GVT_YR_ATTAINED |
Date(10) |
DATE |
Year Attained
|
| 125 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
|
| 126 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
N=No
Y=Yes
Default Value: N
|
| 127 |
MAR_STATUS_DT |
Date(10) |
DATE |
Marital Status Date
|
| 128 |
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 Specified
7=Native Hawaiian/Oth Pac Island
|
| 129 |
GVT_DISABILITY_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Code
Default Value: 05
|
| 130 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 131 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Default Value: 0000
|
| 132 |
GVT_CURR_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Agency Employee
Y/N Table Edit
Default Value: N
|
| 133 |
GVT_CURR_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Federal Employee
Y/N Table Edit
Default Value: N
|
| 134 |
GVT_HIGH_PAY_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Pay Plan
|
| 135 |
GVT_HIGH_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Grade
|
| 136 |
GVT_PREV_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Agency Employee
Y/N Table Edit
Default Value: N
|
| 137 |
GVT_PREV_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Federal Employee
Y/N Table Edit
Default Value: N
|
| 138 |
GVT_SEP_INCENTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive
|
| 139 |
GVT_SEP_INCENT_DT |
Date(10) |
DATE |
Separation Incentive Date
|
| 140 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 141 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 142 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 143 |
ALTER_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Alternate Employee ID
|
| 144 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 145 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|