HRS_OFF_DTL_I

(SQL View)
 Index Back

Offer Details

Offer Details - Components

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_OFF_ID , A.OFFER_COMPONENT , A.OFFER_AMT , A.SEQUENCE_NUMBER , A.CURRENCY_CD , A.OFFER_FREQUENCY , A.ERNCD , A.EARNS_AMT , A.LOCATION FROM PS_HRS_OFF_DTL A

# 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

Prompt Table: HRS_OFF_CMPNT_I

5 OFFER_AMT Number(19,6) DECIMAL(18,6) NOT NULL Offer Amount
6 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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
9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
10 EARNS_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Earnings Amount
11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code