FO_APPL_OVW_SR

(SQL View)
Index Back

Staffing Candidate View

View Definition: SELECT CANDIDATE_ID ,NAME FROM %Table(FO_CANDIDATE_W) WHERE CANDIDATE_TYPE ='A'

SELECT CANDIDATE_ID ,NAME FROM %Table(FO_CANDIDATE_W) WHERE CANDIDATE_TYPE ='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name