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
2	APP_FOR_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Applied for Status A=Posted B=Screened - Preliminary C=Screened - Final D=Routing E=Interview F=Offer G=Offer Accepted H=Other Offer Accepted J=Offer Rejected K=Withdrawn L=Hired M=Rejected N=Requisition Closed P=On Hold Q=Preliminary Offer Decided R=Preliminary Offer Notified S=Preliminary Offer Accepted T=Preliminary Offer Rejected U=Hire Decided
3	JOB_REQ_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Job Requisition Status C=Closed F=Filled H=Hold N=Cancelled O=Open R=Re-Opened
4	APP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Application Status 1=Hired 2=Active 3=Inactive
5	RESPONSE_CD	Character(3)	VARCHAR2(3) NOT NULL	Response Code HOL=Hold on File INV=Invite for Interview NOR=No Response RIE=Reject-Insufficent Experience RIS=Reject-Insufficent Skills RNO=Reject-No Opening ROR=Reject-Other
6	RECOMMENDATION	Character(3)	VARCHAR2(3) NOT NULL	Recommendation F=Hold on File I=Interview Further O=Make Offer R=Reject
7	RESPONSE_OFFER	Character(1)	VARCHAR2(1) NOT NULL	Response to Offer A=Accepted N=No Response R=Rejected U=Under Negotiation W=Withdrawn
8	UPG_STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
9	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status.