BAS_ENR_EMPL_V2

(SQL View)
Index Back

BAS Enr RunCtl-Sch Empl EmplID

BAS_ENR_EMPL_V1 is a view used by the Benefits Administration Run Control panel to return employee IDs for list shedule processing.

SELECT A.EMPLID ,O.OPRID ,A.NAME FROM PS_PERSON_NAME A , PSOPRDEFN O WHERE A.EMPLID = O.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 NAME Character(50) VARCHAR2(50) NOT NULL Name