| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 3 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 4 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 5 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 7 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 8 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 9 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 10 |
END_DT |
Date(10) |
DATE |
end date
|
| 11 |
ENDING_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Ending Job Title
|
| 12 |
ENDING_RATE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Ending Pay Rate
|
| 13 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 15 |
US_SOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Occupational Classif
|
| 16 |
CAN_NOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
National Occupational Classif
|
| 17 |
REL_WRK_EXPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Relevant Work Experience
|
| 18 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 19 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 20 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 21 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 22 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 23 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 24 |
GVT_OCC_SERIES |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Series
|
| 25 |
GVT_TYPE_OF_APPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm)
15=Career-Conditional (Comp Perm)
20=Nonpermanent (Comp NonPerm)
30=Schedule A (Except Svc Perm)
32=Schedule B (Except Svc Perm)
34=Schedule C (Except Svc Perm)
36=Executive (Except Svc Perm)
38=Other (Except Svc Perm)
40=Schedule A (Except NonPerm)
42=Schedule B (Except NonPerm)
44=Schedule C (Except NonPerm)
46=Executive (Except NonPerm)
48=Other (Except NonPerm)
50=Career (Senior Exec Perm)
55=Noncareer (Senior Exec Perm)
60=Limited Term (Senior Exec NPrm
65=Limited Emergency (SES NPerm)
|
| 26 |
GVT_HOURS_PER_WEEK |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Hours Per Week
|
| 27 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 28 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 29 |
GVT_TYPE_OF_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Experience Type
F=Federal Civilian Sector
O=Other
P=Private Sector
|
| 30 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|