HRS_STG_APPCTNT (SQL Table)	Index Back
Searchable application content This staging table is populated by AE HRS_STG_ACNT which is called from the pre-processing step of search index schedule.

HRS_STG_APPCTNT

(SQL Table)

Searchable application content

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

# 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description