UPG_OFF_HIS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
3	APP_DT	Date(10)	DATE	Date an application was submitted
4	JOB_REQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	Job requisition number
5	OFFER_DT	Date(10)	DATE	Offer Date
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	REQUEST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Accepted P=Pending U=Undue Hardship
8	EFFDT	Date(10)	DATE	Effective Date
9	LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter code
10	LETTER_PRINTED_DT	Date(10)	DATE	Date letter was printed
11	AUTHORIZATION_DT	Date(10)	DATE	Date Authorized
12	AUTHORIZATION_ID	Character(11)	VARCHAR2(11) NOT NULL	Authorization ID
13	APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status A=All Approved D=Denied P=In Approval Process U=Needs Approval
14	STATUS_DT	Date(10)	DATE	Status Date
15	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
16	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status.
17	PROCESS_PREHIRE	Character(1)	VARCHAR2(1) NOT NULL	Prehire Processing Requested
18	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
19	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
20	STEP	Number(2,0)	SMALLINT NOT NULL	Step
21	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
22	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
23	OFFER_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Offer Amount
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	PAY_FREQ_ABBRV	Character(1)	VARCHAR2(1) NOT NULL	Pay Frequency A=Annual B=Bi-weeky H=Hour M=Month Y=Year
26	RESPONSE_OFFER	Character(1)	VARCHAR2(1) NOT NULL	Response to Offer A=Accepted N=No Response R=Rejected U=Under Negotiation W=Withdrawn
27	RESPONSE_DT	Date(10)	DATE	Response Date
28	OFFER_REJECT_RSN	Character(1)	VARCHAR2(1) NOT NULL	Reject Reason B=Benefits J=Another Job N=Not Specified P=Personal S=Salary
29	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
30	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
31	COMMENTS	Long Character	CLOB	Comment