JOB_REQ_LANG (SQL Table)	Index Back
Job Requisition Codes Use JOB_REQUISITION to record information for job requisitons such as job code, department, position ID, authorization data, status, and status dates. This data is used primarily in Recruitment. You can create only one JOB_REQUISITION record per requisition.

JOB_REQ_LANG

(SQL Table)

Job Requisition Codes

Use JOB_REQUISITION to record information for job requisitons such as job code, department, position ID, authorization data, status, and status dates. This data is used primarily in Recruitment. You can create only one JOB_REQUISITION record per requisition.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number

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

3 RECRUITER_NAME Character(50) VARCHAR2(50) NOT NULL Recruiter Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOB_REQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	Job requisition number
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	RECRUITER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Recruiter Name