PER_ORG_ASG_NLD (SQL Table)	Index Back
PER_ORG- Exts for Netherlands Contains fields for the country NLD This record will be a child to PER_ORG_ASGN in the Component Processor - but the real relationship to PER_ORG_ASGN is Zero to One.

PER_ORG_ASG_NLD

(SQL Table)

PER_ORG- Exts for Netherlands

Contains fields for the country NLD This record will be a child to PER_ORG_ASGN in the Component Processor - but the real relationship to PER_ORG_ASGN is Zero to One.

Parent record: PER_ORG_ASGN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PER_ORG_ASGN

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN

3 RELAT_TO_OWNER_NLD Character(1) VARCHAR2(1) NOT NULL Relation to Owner is used by the Netherlands to track whether an employee is either family of the owner or whether the employee was the last owner. This information is used for the Insurance Board Notification "Melding Bedrijfsvereniging".
F=Family of Owner
L=Last Owner

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PER_ORG_ASGN
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN
3	RELAT_TO_OWNER_NLD	Character(1)	VARCHAR2(1) NOT NULL	Relation to Owner is used by the Netherlands to track whether an employee is either family of the owner or whether the employee was the last owner. This information is used for the Insurance Board Notification "Melding Bedrijfsvereniging". F=Family of Owner L=Last Owner