| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 4 |
WAIVE_DATA_PROTECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Protecting Employee Personal Data Privacy
European Community employment and personal privacy legislation specifies that personnel information cannot be passed across countries in the European Union without authorization from the employee. If you have obtained the employee's consent in compliance with this EU legislation, check Waive Data Protection to indicate that the employee's personal data can be shared with users in other European Union member nations.
Y/N Table Edit
Default Value: N
|
| 5 |
CAN_ABORIGINAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Aboriginal Person
Y/N Table Edit
Default Value: N
|
| 6 |
CAN_VISBL_MINORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Visible Minority
B=Black
C=Chinese
F=Filipino
I=Indo-Pakistani
J=Japanese
K=Korean
N=Not a Visible Minority
O=Other
S=Southeast Asian
W=West Asian, Arab
Default Value: N
|
| 7 |
BIRTHCNTRY_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field holds the birth country of the employee, tracked as part of the employee diversity data.
Prompt Table:
COUNTRY_TBL
|
| 8 |
BIRTHCNTRYMOT_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field holds the birth country of the employees mother, tracked as part of the employee diversity data.
Default Value: NLD
Prompt Table:
COUNTRY_TBL
|
| 9 |
BIRTHCNTRYFAT_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field holds the birth country of the employees father, tracked as part of the employee diversity data.
Default Value: NLD
Prompt Table:
COUNTRY_TBL
|
| 10 |
SAMEN_OBJECT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether the employee objects to the registration of the birth country information as part of the diversity data.
Y/N Table Edit
Default Value: N
|
| 11 |
SAMEN_CATEGORY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field can be used to track a specific category in case a person was born in Indonesia.
1=Former Netherlands East Indies
2=Indonesia (after 27-12-1949)
3=Incl. Law Rietkerk-uitkering
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 12 |
SAMEN_CAT_MOT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field can be used to track a specific category in case a person was born in Indonesia.
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 13 |
SAMEN_CAT_FAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field can be used to track a specific category in case a person was born in Indonesia.
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 14 |
SAMEN_IDENT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates whether the employee belongs to a minority group based on the birthcountry.
Y/N Table Edit
Default Value: N
|
| 15 |
ETHNIC_GRP_CD_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
ETHNIC_GRP_CD_UK
0=Not Specified
1=White
2=Irish
3=African
4=Afro-Caribbean
5=Indian
6=Pakistani
7=Bangladeshi
8=Chinese
9=Other
|
| 16 |
NI_COMMUNITY_BG |
Character(2) |
VARCHAR2(2) NOT NULL |
Community Background
CA=Catholic
PR=Protestant
UD=Undetermined/Other
|
| 17 |
NI_CB_DET_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Determination Method
DQ=Direct Question
R1=Residual
R2=Residual 2nd School
RO=Residual Other
|
| 18 |
NI_CB_DET_DATE |
Date(10) |
DATE |
Determination Date
|
| 19 |
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
Default Value: 6
|
| 20 |
INFO_RCVD_DT |
Date(10) |
DATE |
Information Recieved Date
|
| 21 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 22 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 23 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 24 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|