HRS_JO_EXP_LNI (SQL View)	Index Back
Job Opening Expenses Intfc Job opening expenses interface

HRS_JO_EXP_LNI

(SQL View)

Job Opening Expenses Intfc

Job opening expenses interface

SELECT A.HRS_JOB_OPENING_ID , A.CHARGE_DT , A.SEQ_NBR , A.LANGUAGE_CD , A.DESCR50 FROM PS_HRS_JO_EXP_LNG A

Related Language Record for HRS_JO_EXP_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

2 CHARGE_DT Date(10) DATE NOT NULL Charge Date
Default Value: %date

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
2	CHARGE_DT	Date(10)	DATE NOT NULL	Charge Date Default Value: %date
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50