HRS_HIRE_ORG_CH (SQL View)	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.

HRS_HIRE_ORG_CH

(SQL View)

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.

SELECT A.HRS_PERSON_ID , A.HRS_SEQ_NUM , A.ORIGIN_CHE , A.MAIN_ORIG_CHE FROM PS_HRS_APP_ORIG_CH A

Parent record: HRS_APPLICANT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

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	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
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