| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
|
| 3 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
Default Value: 1
|
| 4 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 5 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 6 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 7 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 8 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 9 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 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
Default Value: M
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 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
Y/N Table Edit
Default Value: N
|
| 18 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%SAL_GRD_PRMPT1
|
| 19 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 20 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 21 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 22 |
GVT_OCC_SERIES |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Series
Prompt Table:
GVT_OCCUPATION
|
| 23 |
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)
|
| 24 |
GVT_HOURS_PER_WEEK |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Hours Per Week
|
| 25 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 26 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 27 |
GVT_TYPE_OF_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Experience Type
F=Federal Civilian Sector
O=Other
P=Private Sector
|
| 28 |
PCMP_PREV_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in the Professional Compliance module.
Determines whether the RI's previous company was regulated.
N=No
Y=Yes
Default Value: N
|
| 29 |
PCMP_PREV_CLASS |
Character(20) |
VARCHAR2(20) NOT NULL |
Used i n the Professional Compliance module.
Previous classification level of a RI
|
| 30 |
PCMP_PREV_LEAVE |
Character(30) |
VARCHAR2(30) NOT NULL |
Used in the Professional Compliance module.
Reason why RI left previous job.
|
| 31 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|