PLACE_ORIG_CHE (SQL Table)	Index Back
Employee Place of Origin This table tracks the Employee Place of Origin. An employee can have multiples places of origin, however an employee can have only one main place of origin.

PLACE_ORIG_CHE

(SQL Table)

Employee Place of Origin

This table tracks the Employee Place of Origin. An employee can have multiples places of origin, however an employee can have only one main place of origin.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 ORIGIN_CHE Character(40) VARCHAR2(40) NOT NULL This field represents a person's place of origin. This is the place of origin of a person's father or husband. It is a free format field.

4 MAIN_ORIG_CHE Character(1) VARCHAR2(1) NOT NULL This Flag determines if the employee's Place of Origin is the main one or not. An employee can have one and only one main place of origin.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	ORIGIN_CHE	Character(40)	VARCHAR2(40) NOT NULL	This field represents a person's place of origin. This is the place of origin of a person's father or husband. It is a free format field.
4	MAIN_ORIG_CHE	Character(1)	VARCHAR2(1) NOT NULL	This Flag determines if the employee's Place of Origin is the main one or not. An employee can have one and only one main place of origin. Y/N Table Edit Default Value: N