HCR_SM_RCRT_VW

(SQL View)
 Index Back

Search Match Rslt Criteria VW

Search Match Result Criteria View. This view pulls together the result criteria and record.table relationships.

SELECT A.SM_TYPE , A.SM_RSLT_CD , A.SM_RSLT_FLD , A.SEQNO , A.SM_RSLT_DSPLY , A.SM_LENGTH , A.SM_DAY_FLG , A.SM_MONTH_FLG , A.SM_YEAR_FLG , B.SM_RECORD , B.SM_FIELD , B.SM_EFFDT_FLG , C.FIELDTYPE , B.DESCR FROM PS_HCR_SM_RSLT_CRT A , PS_HCR_SM_RFLD_TBL B , PSDBFIELD C WHERE A.SM_TYPE = B.SM_TYPE AND A.SM_RSLT_FLD = B.SM_RSLT_FLD AND B.SM_FIELD = C.FIELDNAME

  • Related Language Record: HCR_SM_RCRT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
    A=Applicant
    O=Organization
    P=Person
    2 SM_RSLT_CD Character(15) VARCHAR2(15) NOT NULL Search Match Result Code.
    3 SM_RSLT_FLD Character(30) VARCHAR2(30) NOT NULL Search Match Result Field. This field relates the search result record.field relationships.

    Prompt Table: HCR_SM_RFLD_TBL

    4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    5 SM_RSLT_DSPLY Character(2) VARCHAR2(2) NOT NULL Search/Match Result Display options
    DE=Display Entire Field
    DF=Display First
    DL=Display Last
    DP=Display Partial Date
    ME=Mask Entire Field

    Default Value: DE

    6 SM_LENGTH Number(3,0) SMALLINT NOT NULL Search Match Length field. This field identifies the length of a substring search.
    7 SM_DAY_FLG Character(1) VARCHAR2(1) NOT NULL Search Match Result Day of Month display flag.

    Y/N Table Edit

    Default Value: N

    8 SM_MONTH_FLG Character(1) VARCHAR2(1) NOT NULL Search Match Result Calendar Month display flag.

    Y/N Table Edit

    Default Value: N

    9 SM_YEAR_FLG Character(1) VARCHAR2(1) NOT NULL Search Match Result - Calander Year display flag.

    Y/N Table Edit

    Default Value: N

    10 SM_RECORD Character(15) VARCHAR2(15) NOT NULL Search Match Record. This field holds the search result database record name for the Search Match Rules definitions.
    11 SM_FIELD Character(18) VARCHAR2(18) NOT NULL Search Match Field. This field holds the search property database field name for the Search Match Rules definitions.
    12 SM_EFFDT_FLG Character(1) VARCHAR2(1) NOT NULL Search/Match Effective Dated
    13 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description