APPLIDAPP_DTJOB_REQ_NBROFFER_DTSEQNUMB=Benefits
J=Another Job
N=Not Specified
P=Personal
S=Salary
A=Accepted
N=No Response
R=Rejected
U=Under Negotiation
W=Withdrawn
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
UPG_OFF_TAO(SQL Table) |
Index Back |
|---|---|
Employmt Offers to ApplicantsUse OFFER to record details about job offers made to applicants for employment. This data is used in the Recruitment module. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPLID |
Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 2 | APP_DT |
Date(10) | DATE | Date an application was submitted |
| 3 | JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 4 | OFFER_DT |
Date(10) | DATE | Offer Date |
| 5 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL | Letter code |
| 8 | LETTER_PRINTED_DT | Date(10) | DATE | Date letter was printed |
| 9 | PROCESS_PREHIRE | Character(1) | VARCHAR2(1) NOT NULL | Prehire Processing Requested |
| 10 | RESPONSE_DT | Date(10) | DATE | Response Date |
| 11 | OFFER_REJECT_RSN | Character(1) | VARCHAR2(1) NOT NULL |
Reject Reason
B=Benefits J=Another Job N=Not Specified P=Personal S=Salary |
| 12 | AUTHORIZATION_ID | Character(11) | VARCHAR2(11) NOT NULL | Authorization ID |
| 13 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
| 14 | RESPONSE_OFFER | Character(1) | VARCHAR2(1) NOT NULL |
Response to Offer
A=Accepted N=No Response R=Rejected U=Under Negotiation W=Withdrawn |
| 15 | OFFER_AMT | Number(19,6) | DECIMAL(18,6) NOT NULL | Offer Amount |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | PAY_FREQ_ABBRV | Character(1) | VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual B=Bi-weeky H=Hour M=Month Y=Year |