| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
Default Value: 1
|
| 3 |
EMPLOYMENT_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Employer Name
|
| 4 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 5 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 6 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: HCR_OPRDEF_HR_I.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 7 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 8 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 9 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 10 |
END_DT |
Date(10) |
DATE |
end date
|
| 11 |
TITLE_LONG |
Character(50) |
VARCHAR2(50) NOT NULL |
Title Long
|
| 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: HCR_OPRDEF_HR_I.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
US_SOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Occupational Classif
Prompt Table:
HCR_US_SOC_I
|
| 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 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_SRCH
|
| 19 |
US_SIC_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
US Standard Industrial Classif
Prompt Table:
US_SIC_TBL
|
| 20 |
RETIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Retired (Y/N)
Y/N Table Edit
Default Value: N
|
| 21 |
RETIREMENT_DT |
Date(10) |
DATE |
Projected Retirement Date
|
| 22 |
SCC_EXPER_ADDR_TYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Work Experience Address Type
ADDR=Address Type
LOCN=Location
NONE=None
Default Value: NONE
|
| 23 |
ORG_LOCATION |
Number(3,0) |
SMALLINT NOT NULL |
Location Nbr
Prompt Table:
ORG_LOCATION
|
| 24 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
HCR_PER_ADDR_I
|
| 25 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
Prompt Table:
HCR_PER_PHONE_I
|
| 26 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 27 |
SCC_EMPLOY_FRAC |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Employment fraction
|
| 28 |
SCC_HRS_PER_WEEK |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Hours Per Week
|
| 29 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 30 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 31 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 32 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|