LM_REGPERFLG_VW (SQL View)	Index Back
Registration person view Registration person view

LM_REGPERFLG_VW

(SQL View)

Registration person view

SELECT A.LM_PRG_REG_ID , B.LM_EXT_PERSON_FLG FROM PS_LM_PRG_REG A , PS_LM_PERSON B WHERE A.LM_PERSON_ID = B.LM_PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

2 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
2	LM_EXT_PERSON_FLG	Character(1)	VARCHAR2(1) NOT NULL	External Person Flag