FO_JOBOPEN_DTL (SQL Table)	Index Back
Staffing Job Opening Detail Staffing Job Opening Detail

FO_JOBOPEN_DTL

(SQL Table)

Staffing Job Opening Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

4 FO_JOBOPEN_LINE Number(3,0) SMALLINT NOT NULL Job Opening Line

5 RECRUIT_CAT Character(6) VARCHAR2(6) NOT NULL Recruit Source Category

6 RECRUIT_SRC Character(6) VARCHAR2(6) NOT NULL Recruiting Source

7 FO_JOBOPEN_STATUS Character(3) VARCHAR2(3) NOT NULL Job Opening Status
NEW=Draft
PUB=Published
REM=Removed
UPD=Re-published

8 FO_JOBBOARD_STATUS Character(3) VARCHAR2(3) NOT NULL Job Board Status
NEW=Draft
PUB=Published
REM=Removed

9 POSTED_DATE Date(10) DATE Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.

10 EXPIRATION_DT Date(10) DATE Expiration Date

11 REMOVED_DT Date(10) DATE Removed Date

12 FO_NUM_VIEWS Number(10,0) DECIMAL(10) NOT NULL Number of Views

13 FO_NUM_CLICKS Number(10,0) DECIMAL(10) NOT NULL Number of Clicks

14 URL_JOB Character(254) VARCHAR2(254) NOT NULL URL_JOB

15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

16 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	FO_JOBOPEN_LINE	Number(3,0)	SMALLINT NOT NULL	Job Opening Line
5	RECRUIT_CAT	Character(6)	VARCHAR2(6) NOT NULL	Recruit Source Category
6	RECRUIT_SRC	Character(6)	VARCHAR2(6) NOT NULL	Recruiting Source
7	FO_JOBOPEN_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Job Opening Status NEW=Draft PUB=Published REM=Removed UPD=Re-published
8	FO_JOBBOARD_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Job Board Status NEW=Draft PUB=Published REM=Removed
9	POSTED_DATE	Date(10)	DATE	Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
10	EXPIRATION_DT	Date(10)	DATE	Expiration Date
11	REMOVED_DT	Date(10)	DATE	Removed Date
12	FO_NUM_VIEWS	Number(10,0)	DECIMAL(10) NOT NULL	Number of Views
13	FO_NUM_CLICKS	Number(10,0)	DECIMAL(10) NOT NULL	Number of Clicks
14	URL_JOB	Character(254)	VARCHAR2(254) NOT NULL	URL_JOB
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.