UPG_OFF_HIS_AET

(SQL Table)
Index Back

Temp Table for 7.5x Upgrades

Temporary Table used for Upgrades from 7.5x

# 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