HRS_SCT_PROPS

(SQL Table)
Index Back

Content Section Properties

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

  • 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 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

    5 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

    6 HRS_JO_SCR_USE Character(1) VARCHAR2(1) NOT NULL Flag to mark usage in screening

    Y/N Table Edit

    Default Value: N

    7 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    9 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    10 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id