| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 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 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 6 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 7 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 8 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business Phone
CAMP=Campus Phone
CELL=Cellular Phone
DORM=Dormitory Phone
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
|
| 9 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 10 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 11 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 12 |
END_DT |
Date(10) |
DATE |
End Date
|
| 13 |
ENDING_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Ending Job Title
|
| 14 |
ENDING_RATE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Ending Pay Rate
|
| 15 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
B=Bi-weeky
H=Hour
M=Month
Y=Year
Default Value: M
|
| 16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
US_SOC_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Standard Occupational Classif
Prompt Table:
US_SOC_TBL
|
| 18 |
CAN_NOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
National Occupational Classif
|
| 19 |
REL_WRK_EXPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Relevant Work Experience
Y/N Table Edit
Default Value: N
|
| 20 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 21 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
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
|
| 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
|
| 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
|
| 30 |
PCMP_PREV_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in the Professional Compliance module.
Determines whether the RI's previous company was regulated.
Default Value: N
|
| 31 |
PCMP_PREV_CLASS |
Character(20) |
VARCHAR2(20) NOT NULL |
Used i n the Professional Compliance module.
Previous classification level of a RI
|
| 32 |
PCMP_PREV_LEAVE |
Character(30) |
VARCHAR2(30) NOT NULL |
Used in the Professional Compliance module.
Reason why RI left previous job.
|
| 33 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|