RY_BAS_IDENA_VW

(SQL View)
Index Back

Basics Identity

Basics Identity Required attributes

SELECT ry_min_set_id , ry_identific_id , ry_md_elem_id , ry_is_in_matchrule FROM PS_RY_BAS_IDENT WHERE ry_is_in_matchrule = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_MIN_SET_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.

Default Value: RY_BAS_MINSET.RY_MIN_SET_ID

2 RY_IDENTIFIC_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
3 RY_MD_ELEM_ID Number(18,0) DECIMAL(18) NOT NULL Metadata Element ID - Dialog Document
4 RY_IS_IN_MATCHRULE Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.

Y/N Table Edit

Default Value: N