HRS_OFFDTLMAX_I(SQL View) |
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. |
| SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_OFF_ID , A.OFFER_COMPONENT , A.SEQUENCE_NUMBER , A.OFFER_AMT , A.CURRENCY_CD , A.OFFER_FREQUENCY FROM PS_HRS_OFF_DTL A WHERE A.HRS_OFF_ID = ( SELECT MAX(B.HRS_OFF_ID) FROM PS_HRS_OFF_DTL B WHERE %Join(COMMON_KEYS, HRS_OFF_DTL A, HRS_OFF_DTL B,HRS_OFF_ID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 3 | HRS_OFF_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Offer ID |
| 4 | OFFER_COMPONENT |
Character(7) | VARCHAR2(7) NOT NULL | Offer Component |
| 5 | SEQUENCE_NUMBER | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | OFFER_AMT | Number(19,6) | DECIMAL(18,6) NOT NULL | Offer Amount |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 8 | OFFER_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the offer amount frequency.
A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly O=One-Time Q=Quarterly S=Semimonthly W=Weekly |