| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 4 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 5 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 6 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
Prompt Table:
HRS_JOB_OPENING
|
| 7 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
Prompt Table:
JOB_FAMILY_TBL
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
HRS_BS_UNT_HR_I
|
| 9 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 10 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 11 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 12 |
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 Applicable
7=Native Hawaiian/Oth Pac Island
A=American Indian/Alaskan Native
B=Asian or Pacific Islander
C=Black, not of Hispanic origin
D=Hispanic
E=White, not of Hispanic origin
F=Asian Indian
G=Chinese
H=Filipino
J=Guamanian
K=Hawaiian
L=Japanese
M=Korean
N=Samoan
P=Vietnamese
Q=All Other Asian o Pacific Is
Y=Not Hispanic in Puerto Rico
|