AVATTRPERSVWLNG

(SQL View)
 Index Back

Attribute Type Table-PERS

This prompts for the Attribute Type and Prompt / Process table information used in creating Membership Organizations for Persons.

SELECT AV_ATTR_CD , EFFDT , LANGUAGE_CD , DESCRSHORT , DESCR FROM PS_AV_ATTR_TYP_LNG WHERE AV_MBR_CRIT_TYP='P'

  • Related Language Record for AV_ATTR_PERS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AV_ATTR_CD Character(6) VARCHAR2(6) NOT NULL Attribute Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %DATE

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description