UPG_ER_STS_AREA

(SQL View)
Index Back

Upgrade Status Area

Retrieves distinct status area.

SELECT DISTINCT UPG_STATUS_AREA FROM PS_UPG_ER_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 UPG_STATUS_AREA Character(1) VARCHAR2(1) NOT NULL Defines an area in the system that track statuses.
1=1-Job Opening
2=2-Applicant
3=3-Recruitment Summary
4=4-Route
5=5-Interview
6=6-Offer