PA_AA_SRCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ALIAS_NAME	Character(10)	VARCHAR2(10) NOT NULL	Alias Name
2	ALIAS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Alias type AA=Auto Assigned (Lim/Unlim Vals) CS=Custom Statement DB=Data Base Field DT=Date Field DU=Duration (Age) Field FR=Function Result TL=Table Lookup
3	ALIAS_TBL_NAME	Character(18)	VARCHAR2(18) NOT NULL	Alias Table Name
4	ALIAS_FLD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Alias Field Name
5	ALIAS_FLD_PIC	Character(10)	VARCHAR2(10) NOT NULL	Alias Field Picture
6	WHERE_CLAUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Where clause type ED=Employee Id & Effective Date EE=Employee Id FD=EE, Function Result, Date PD=Empl Id, Plan, & Effective Dt PE=Employee Id & Benefit Plan
7	DURR_XREF_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Duration x-ref alias name
8	AUTO_ASSOC_PLAN_NM	Character(6)	VARCHAR2(6) NOT NULL	Auto assignment assoc plan
9	AUTO_ASSOC_FR_NM	Character(10)	VARCHAR2(10) NOT NULL	Auto asgnmt assoc func rslt nm
10	AUTO_CONCEPT_CD	Character(2)	VARCHAR2(2) NOT NULL	Auto assignment concept LA=Limited Average Earnings LB=Limited Cash Balance @ BCD LL=Lim Cash Bal @ Lump Sum Date LN=Limited Cash Balance @ NRD PD=Participation Date UA=Unlimited Average Earnings UB=Unlimited Cash Balance @ BCD UL=Unlim Cash Bal @ Lump Sum Date UN=Unlimited Cash Balance @ NRD
11	TBL_STRT_EFF_CD	Character(1)	VARCHAR2(1) NOT NULL	Start/Effdt use indicator
12	PA_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	ALIAS_PROMPT	Character(40)	VARCHAR2(40) NOT NULL	Alias Prompt Field
15	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50