HRS_PORIG_CHE_I (SQL View)	Index Back
Employee Place of Origin Interface view on place of origin.

HRS_PORIG_CHE_I

(SQL View)

Employee Place of Origin

Interface view on place of origin.

SELECT A.EMPLID , A.SEQ_NUM , A.ORIGIN_CHE , A.MAIN_ORIG_CHE FROM PS_PLACE_ORIG_CHE A

# 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