HRS_SCT_PROPS_I (SQL View)	Index Back
Content Section Properties Defines the properties in a content section that are available for configuration in Recruiting Solutions.

HRS_SCT_PROPS_I

(SQL View)

Content Section Properties

Defines the properties in a content section that are available for configuration in Recruiting Solutions.

SELECT HRSP.JPM_JP_TYPE , HRSP.JPM_CAT_TYPE , HRSP.FIELDNAME , JPMP.FIELDNUM , JPMP.JPM_LABEL_TEXT , JPMP.JPM_KEY_FLG , JPMP.JPM_CAT_MIN_VALUE , JPMP.JPM_CAT_MAX_VALUE , JPMP.JPM_CAT_MAX_LENGTH , JPMP.JPM_CAT_REQUIRED , HRSP.HRS_DTL_DISPLAY , HRSP.HRS_SUMM_DISPLAY , JPMP.JPM_JP_DISPLAY , JPMP.JPM_JP_DISP_SUMM , JPMC.JPM_ADHOC_FLG , JPMP.JPM_PRP_DEFAULT , JPMP.JPM_PRP_DISPLAY , HRSP.HRS_JO_SCR_USE FROM PS_JPM_PRI_P_CAT_I JPMC , PS_JPM_PRI_P_PRP_I JPMP , PS_HRS_SCT_PROPS HRSP WHERE HRSP.JPM_JP_TYPE = JPMC.JPM_JP_TYPE AND HRSP.JPM_CAT_TYPE = JPMC.JPM_CAT_TYPE AND HRSP.JPM_JP_TYPE = JPMP.JPM_JP_TYPE AND HRSP.JPM_CAT_TYPE = JPMP.JPM_CAT_TYPE AND HRSP.FIELDNAME = JPMP.FIELDNAME

Related Language Record: HRS_SCT_PROPS_L

Parent record: HRS_SCT_CFG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

2 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.

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: JPM_PRI_P_PRP_I

4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

5 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.

6 JPM_KEY_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if this JPM Profile or Catalog property is to be considered a key on the Profile or Catalog Item.

7 JPM_CAT_MIN_VALUE Number(10,2) DECIMAL(9,2) NOT NULL Specifies the minimum value a property in a Catalog Item or Profile Item may be.

8 JPM_CAT_MAX_VALUE Number(10,2) DECIMAL(9,2) NOT NULL Specifies the maximum value a property in a Catalog Item or Profile Item may be.

9 JPM_CAT_MAX_LENGTH Number(4,0) SMALLINT NOT NULL Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.

10 JPM_CAT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Used to indicate that the property, item or relationship must be used.

11 HRS_DTL_DISPLAY Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether a JPM profile item field should be displayed on the RS JO or Resume detail page
Y/N Table Edit
Default Value: N

12 HRS_SUMM_DISPLAY Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether a JPM profile item field should be displayed on the RS JO or Resume Summary page (grid)
Y/N Table Edit
Default Value: N

13 JPM_JP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether a JPM profile item field should be displayed on the profile item detail page

14 JPM_JP_DISP_SUMM Character(1) VARCHAR2(1) NOT NULL Flag to indicate if field is to be shown on the JPM Profile content summary grid

15 JPM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Indicates that the Catalog Type is Adhoc or FreeForm.

16 JPM_PRP_DEFAULT Character(10) VARCHAR2(10) NOT NULL Property Default
Prompt Table: %EDITTABLE

17 JPM_PRP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Property Display Options
D=Display Only
E=Editable
H=Hidden

18 HRS_JO_SCR_USE Character(1) VARCHAR2(1) NOT NULL Flag to mark usage in screening
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
2	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.
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: JPM_PRI_P_PRP_I
4	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
5	JPM_LABEL_TEXT	Character(30)	VARCHAR2(30) NOT NULL	User defined text to be displayed as a label for a field or property within JPM User Interfaces.
6	JPM_KEY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if this JPM Profile or Catalog property is to be considered a key on the Profile or Catalog Item.
7	JPM_CAT_MIN_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	Specifies the minimum value a property in a Catalog Item or Profile Item may be.
8	JPM_CAT_MAX_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	Specifies the maximum value a property in a Catalog Item or Profile Item may be.
9	JPM_CAT_MAX_LENGTH	Number(4,0)	SMALLINT NOT NULL	Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.
10	JPM_CAT_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate that the property, item or relationship must be used.
11	HRS_DTL_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether a JPM profile item field should be displayed on the RS JO or Resume detail page Y/N Table Edit Default Value: N
12	HRS_SUMM_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether a JPM profile item field should be displayed on the RS JO or Resume Summary page (grid) Y/N Table Edit Default Value: N
13	JPM_JP_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether a JPM profile item field should be displayed on the profile item detail page
14	JPM_JP_DISP_SUMM	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if field is to be shown on the JPM Profile content summary grid
15	JPM_ADHOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the Catalog Type is Adhoc or FreeForm.
16	JPM_PRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Property Default Prompt Table: %EDITTABLE
17	JPM_PRP_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Property Display Options D=Display Only E=Editable H=Hidden
18	HRS_JO_SCR_USE	Character(1)	VARCHAR2(1) NOT NULL	Flag to mark usage in screening Y/N Table Edit Default Value: N