BAS_EVT_EMPLID

(SQL View)
 Index Back

Prompt Table for EMPLID

This view serves as the prompt table for the EMPLID field while creating manual BAS_ACTIVITY rows.

SELECT N.EMPLID ,N.NAME FROM PS_PERSON_NAME N WHERE EXISTS ( SELECT 'X' FROM PS_JOB J WHERE J.EMPLID=N.EMPLID AND J.BENEFIT_SYSTEM<>'OT')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name