AV_RECOGNITION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: AV_SESSION_TBL.BUSINESS_UNIT Prompt Table: AV_INST_BU_VW
2	SESSION_NO	Character(11)	VARCHAR2(11) NOT NULL	Session Nbr Prompt Table: AV_SESSION_TBL
3	GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Gift Nbr Prompt Table: AV_GIFT_DTL
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
5	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: AV_EXT_ORG_SRCH
6	RECOGNITION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Recognition Type Default Value: H Prompt Table: AV_RCG_TYPE_TBL
7	RECOGNITION_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Recognition Pct Default Value: 100
8	RCG_PCT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount
9	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
10	RCG_APPLIED	Number(16,2)	DECIMAL(15,2) NOT NULL	Recognition Applied
11	PEOPLE_RELATION	Character(2)	VARCHAR2(2) NOT NULL	Relationship
12	ORG_RELATION	Character(2)	VARCHAR2(2) NOT NULL	Relationship BR=Branch CF=Corporate Foundation PC=Parent Company SS=Subsidiary
13	PE_RELATION	Character(2)	VARCHAR2(2) NOT NULL	Relationship
14	CNST_TYPE	Number(3,0)	SMALLINT NOT NULL	Constituent Type
15	ALUMNUS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Alumnus Type G=Graduate N=Non-Degree U=Undergraduate
16	ANONYMOUS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Anonymous Y/N Table Edit Default Value: N
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD
18	CURRENCY_CD_ENTRY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY
19	RCG_PCT_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount
20	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_SESSION_TBL.INSTITUTION