| # |
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 |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 8 |
BIRTHCNTRYMOT_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Mother's Birth Country
Default Value: NLD
Prompt Table:
COUNTRY_TBL
|
| 9 |
BIRTHCNTRYFAT_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Father's Birth Country
Default Value: NLD
Prompt Table:
COUNTRY_TBL
|
| 10 |
SAMEN_OBJECT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Objection Registration
Y/N Table Edit
Default Value: N
|
| 11 |
SAMEN_CATEGORY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Birth Category
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 |
Mothers Birth Category
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 13 |
SAMEN_CAT_FAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Fathers Birth Category
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 14 |
SAMEN_IDENT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Included in Target Group
Y/N Table Edit
Default Value: N
|
| 15 |
ETHNIC_GRP_CD_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnic Group
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 (NI)
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 Specified
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 |
Date Received
|
| 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
|