AV_ATTR_TYP_LNG (SQL Table)	Index Back
Attribute Type Table This table stores the Attribute Type and Prompt / Process table information used in creating Membership Organizations

AV_ATTR_TYP_LNG

(SQL Table)

Attribute Type Table

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

Related Language Record for AV_ATTR_TYP_TBL

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %DATE

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description