PER_ORG_ASG_BEL (SQL Table)	Index Back
PER_ORG_ASG - Exts for Belgium Fields were originally on EMPLOYMENT Contains fields for the country BEL 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_BEL

(SQL Table)

PER_ORG_ASG - Exts for Belgium

Fields were originally on EMPLOYMENT Contains fields for the country BEL 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 OFFICIAL_LANG Character(3) VARCHAR2(3) NOT NULL The Official Language is used by Belgium to track the official language for the company and employees. This language code indicates in which language the official reports and communication between company and employees should occur.
Prompt Table: LANGUAGE_CD_VW

#	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	OFFICIAL_LANG	Character(3)	VARCHAR2(3) NOT NULL	The Official Language is used by Belgium to track the official language for the company and employees. This language code indicates in which language the official reports and communication between company and employees should occur. Prompt Table: LANGUAGE_CD_VW