HRS_STG_JOBCTNT (SQL Table)	Index Back
Searchable job contents This staging table is populated by AE HRS_STG_JCNT which is called from the pre-processing step of search index schedule.

HRS_STG_JOBCTNT

(SQL Table)

Searchable job contents

This staging table is populated by AE HRS_STG_JCNT which is called from the pre-processing step of search index schedule.

# 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 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

3 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

4 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

5 PROPERTYNAME Character(30) VARCHAR2(30) NOT NULL Property Name

6 HRS_JOB_REQMT Character(30) VARCHAR2(30) NOT NULL Job requirement

#	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	HRS_JO_RQMT_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening requirement sequence
3	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile.
4	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
5	PROPERTYNAME	Character(30)	VARCHAR2(30) NOT NULL	Property Name
6	HRS_JOB_REQMT	Character(30)	VARCHAR2(30) NOT NULL	Job requirement