| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SCC_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence ID
|
| 3 |
SCC_SEQ_ID3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Nbr
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
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
|
| 6 |
CAN_ABORIGINAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Aboriginal Person
Y/N Table Edit
Default Value: N
|
| 7 |
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
|
| 8 |
BIRTHCNTRY_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 9 |
BIRTHCNTRYMOT_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Mother's Birth Country
Default Value: NLD
Prompt Table:
COUNTRY_TBL
|
| 10 |
BIRTHCNTRYFAT_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Father's Birth Country
Default Value: NLD
Prompt Table:
COUNTRY_TBL
|
| 11 |
SAMEN_OBJECT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Objection Registration
Y/N Table Edit
Default Value: N
|
| 12 |
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
|
| 13 |
SAMEN_CAT_MOT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mothers Birth Category
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 14 |
SAMEN_CAT_FAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Fathers Birth Category
Default Value: 1
Prompt Table:
SAMEN_CATNLD_VW
|
| 15 |
SAMEN_IDENT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Included in Target Group
Y/N Table Edit
Default Value: N
|
| 16 |
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
|
| 17 |
NI_COMMUNITY_BG |
Character(2) |
VARCHAR2(2) NOT NULL |
Community Background (NI)
CA=Catholic
PR=Protestant
UD=Undetermined/Other
|
| 18 |
NI_CB_DET_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Determination Method
DQ=Direct Question
R1=Residual
R2=Residual 2nd School
RO=Residual Other
|
| 19 |
NI_CB_DET_DATE |
Date(10) |
DATE |
Determination Date
|
| 20 |
EXP_RETIRE_DT |
Date(10) |
DATE |
Expected Retirement Date
|
| 21 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|