PERS_REG_BEL_CV (SQL View)	Index Back
PERS_REGIST_BEL MSG Clairvia Clone of PERS_REGIST_BEL record for Clairvia Fullsync message

PERS_REG_BEL_CV

(SQL View)

PERS_REGIST_BEL MSG Clairvia

Clone of PERS_REGIST_BEL record for Clairvia Fullsync message

SELECT BEL.EMPLID , BEL.EMPL_RCD , BEL.PERS_REG_NBR_BEL , BEL.PERS_REG_DT_BEL FROM PS_PERS_REGIST_BEL BEL , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = BEL.EMPLID AND ASG.EMPL_RCD = BEL.EMPL_RCD 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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 PERS_REG_NBR_BEL Number(7,0) INTEGER NOT NULL Personnel Registry Nbr

4 PERS_REG_DT_BEL Date(10) DATE NOT NULL Registration Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	PERS_REG_NBR_BEL	Number(7,0)	INTEGER NOT NULL	Personnel Registry Nbr
4	PERS_REG_DT_BEL	Date(10)	DATE NOT NULL	Registration Date Default Value: %date