UPG_OFF_HIS_AET(SQL Table) |
Index Back |
---|---|
Temp Table for 7.5x UpgradesTemporary 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 |