PLACORIG_CHE_CV (SQL View)	Index Back
EmployeePlace of OriginClairvi Clone of PLACE_ORIG_CHE record for Clairvia Fullsync message

PLACORIG_CHE_CV

(SQL View)

EmployeePlace of OriginClairvi

Clone of PLACE_ORIG_CHE record for Clairvia Fullsync message

SELECT CHE.EMPLID , CHE.SEQ_NUM , CHE.ORIGIN_CHE , CHE.MAIN_ORIG_CHE FROM PS_PLACE_ORIG_CHE CHE , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = CHE.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

# 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