AV_ATTR_TYP_TBL

(SQL Table)
 Index Back

Attribute Type Table

This table stores the Attribute Type and Prompt / Process table information used in creating Membership Organizations

  • Related Language Record: AV_ATTR_TYP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AV_ATTR_CD Character(6) VARCHAR2(6) NOT NULL Attribute Code
    2 AV_MBR_CRIT_TYP Character(1) VARCHAR2(1) NOT NULL This field is used to capture the type of Membership Criteria the user is setting up. It will identify whether to search for Person (people) or Organization (businesses).
    B=Both
    O=Organization
    P=Person
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %DATE

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 AV_ATTR_PRMPT_NM Character(15) VARCHAR2(15) NOT NULL Attribute Prompt Table

    Prompt Table: PSRECDEFNPVW

    6 AV_ATTR_PRCESS_TBL Character(15) VARCHAR2(15) NOT NULL Attribute Process Table

    Prompt Table: PSRECDEFNPVW

    7 AV_ATTR_PRCESS_FLD Character(18) VARCHAR2(18) NOT NULL Attribute Process Field

    Prompt Table: AV_PRCS_FLD_VW

    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description