1

BUSINESS_UNIT

Char

KEY

5

This is the business unit for the session.

PSUNV

PSUNV

2

SEQ_NBR

decimal

KEY

9

15

0

A unique, consecutive number that identifies a row of data to be processed in the AVPGPLOA process.

1

2

3

AV_SESS_TYPE

char

KEY

2

The type of session to be created. Valid values are:

G = Gift session

PL = Pledge session.

Note. Gift sessions can handle only outright gifts with no links to an existing pledge. Pledge sessions only process new pledges. Pledge payments should not be entered through this process, but must be entered through the online process to ensure update of the pledge records and pledge schedules.

G

PL

4

EMPLID

char

11

The ID number of the person who is making the gift or pledge.

Note. If this field is entered, the EXT_ORG_ID field (Line 5) must be blank.

AV0027

Leave blank

5

EXT_ORG_ID

char

11

The ID number of the organization who is making the gift or pledge.

Note. If this field is entered, the EMPLID field (Line 4) must be blank.

Leave blank

AV1019

6

GIFT_AMT

decimal

9

15

2

The monetary amount of the gift or pledge.

1000.00

12000.00

7

GIFT_TYPE

char

6

For Gift Session (AV_SESS_TYPE = ‘G’), enter ‘GIFT’ only. No other gift types are valid. Otherwise, leave blank.

GIFT

Leave blank

8

PLEDGE_GIFT_NO

char

11

This field exists for future development and is not used in the current process.

9

FISCAL_YEAR

smallint

2

5

0

The financial year during which the gift or pledge is to be counted.

2003

2003

10

GIFT_DT

PSDATE

8

The date of record for the gift or pledge.

01-01-2003

01-01-2003

11

TENDER_TYPE

char

6

The payment method for the gift. Must be a valid value from the AV_TENDER_TBL.

Note. The tender type must be valid for the session business unit. A tender type is valid only if it is current and has a setID that correlates to the corresponding set control value for record group AV02_GIFT for BUSINESS_UNIT (Line1).

CHK

Leave blank

12

CURRENCY_CD

char

3

The type of money being used to pay the gift, for example U.S. Dollars or Euros.

Note. Pledges are always entered in the base currency of the institution.

USD

Leave blank

13

CHECK_NO

char

10

For Gift Session (AV_SESS_TYPE = ‘G’), the number of the donor’s check if the tender is a check.

Note. If a check number is entered, the credit card fields (Lines 14-17) must be blank since a gift has only one tender type.

Leave blank

Leave blank

Important! The following four fields do not feed into the automated credit card process. If you want to have your credit card transactions put through that process, do not complete these four fields. Enter the credit card information online into the sessions created after the Gift/Pledge Load process has been run.

14

CREDIT_CARD_NO

char

20

The credit card number to which the donor is charging the gift.

Note. This field is not secured and can be queried using a database query tool. Also, this field should be empty if CHECK_NO (Line13) has data.

4111111111111111

Leave blank

15

CREDIT_CARD_HOLDER

char

30

The exact name on the credit card entered in CREDIT_CARD_NO (Line 14).

Note. This field is not secured and can be queried using a database query tool. Also, this field should be empty if CHECK_NO (Line13) has data.

Lisele Boudreaux

Leave blank

16

CREDIT_CARD_TYPE

char

2

The type of credit card being used to charge the gift. Must be a valid value from the CREDIT_CARD_TYPE xlat values. Delivered values include:

• AE = American Express

• DC = Diners’ Club

• DI = Diners’ Club

• MC = Master Card

• VI = Visa

Note. This field is not secured and can be queried using a database query tool. Also, this field should be empty if CHECK_NO (Line13) has data.

VI

Leave blank

17

CREDIT_CARD_EXP_DT

PSDATE

8

The date on which the credit card is no longer valid. Must be entered in the format required by the database platform.

Note. This field is not secured and can be queried using a database query tool. Also, this field should be empty if CHECK_NO (Line13) has data.

09-01-2006

Leave blank

18

TENDER_TYPE_NOTE

char

50

Short comment related to the gift tender.

Leave blank

19

CAE_GIFT_TYPE

char

1

Used only when AV_SESS_TYPE (line 3) = ‘G’. Must be the CAE Type for the GIFT_TYPE (Line 7). Delivered value = ‘G’.

G

Leave blank

20

PLDG_EFFDT

PSDATE

8

The date that the pledge is considered active. Can be in the future.

Leave blank

01-15-2003

21

PLEDGE_DT

PSDATE

8

The date that the first pledge payment is expected. The date must be on or after the PLDG_EFFDT (Line 20).

Leave blank

02-01-2003

22

FULF_DT

PSDATE

8

The date on which the entire commitment amount for a pledge is expected to be fulfilled.

Leave blank

12-31-2003

23

PLEDGE_PMT_RCVD

decimal

9

15

2

This field exists for future development and is not used in the current process.

24

LAST_PMT_DT

PSDATE

8

This field exists for future development and is not used in the current process.

25

CP_PLEDGE_NO

char

11

This field exists for future development and is not used in the current process.

26

FEED_FLG

char

1

Only used when AV_SESS_TYPE (Line 3) = ‘PL’. Indicates whether a pledge should be sent to the GL Interface to be tracked as an account receivable.

Leave blank

Y

27

AV_PLDG_STATUS

char

1

This field exists for future development and is not used in the current process.

28

PLEDGE_PG_TYPE

char

2

This field exists for future development and is not used in the current process.

29

RCG_EMPLID1

char

11

These four fields identify up to four persons who are to receive credit for the gift or pledge. The EMPLID (Line 4) is not required to be one of these four IDs if he/she is not receiving direct credit for the gift (for example a third-party agent representing these RCG_EMPLIDs would not be entered).

Note. If an entry has data in this field, it cannot have an entry in its corresponding RCG_EXT_ORG_ID field, that is if RCG_EMPLID1 (Line 29) has a value, RCG_EXT_ORG_ID1 (line 33) cannot and vice versa.

AV0027

30

RCG_EMPLID2

char

11

AV0026

AV0023

31

RCG_EMPLID3

char

11

AV0025

32

RCG_EMPLID4

char

11

AV0024

33

RCG_EXT_ORG_ID1

char

11

These four fields identify up to four organizations that are to receive credit for the gift or pledge. The EXT_ORG_ID (Line 5) is not required to be one of these four IDs if it is not receiving direct credit for the gift (for example a third-party agent representing these RCG_EXT_ORG_IDs would not be entered).

Note. If an entry has data in this field, it cannot have an entry in its corresponding RCG_EMPLID field, that is if RCG_EXT_ORG_ID (Line 33) has a value, RCG_EMPL_ID1 (Line 29) cannot and vice versa.

AV1019

34

RCG_EXT_ORG_ID2

char

11

35

RCG_EXT_ORG_ID3

char

11

36

RCG_EXT_ORG_ID4

char

11

37

RECOGNITION_TYPE1

char

1

The type of credit (recognition) that the donor in RCG_EMPLID1 (Line 29) or RCG_EXT_ORG_ID1 (Line 33) is receiving for the gift or pledge. Must have a valid value from the AV_RCG_TYPE_TBL and the total of all Recognition Types 1-4 (Lines 37-40) that are given a value of ‘H” for hard credit must equal 100% of the GIFT_AMT (Line 6).

H

H

38

RECOGNITION_TYPE2

char

1

The type of credit (recognition) that the donor in RCG_EMPLID2 (Line 30) or RCG_EXT_ORG_ID2 (Line 34) is receiving for the gift or pledge. Must have a valid value from the AV_RCG_TYPE_TBL and the total of all Recognition Types 1-4 (Lines 37-40) that are given a value of ‘H” for hard credit must equal 100% of the GIFT_AMT (Line 6).

H

S

39

RECOGNITION_TYPE3

char

1

The type of credit (recognition) that the donor in RCG_EMPLID3 (Line 31) or RCG_EXT_ORG_ID3 (Line 35) is receiving for the gift or pledge. Must have a valid value from the AV_RCG_TYPE_TBL and the total of all Recognition Types 1-4 (Lines 37-40) that are given a value of ‘H” for hard credit must equal 100% of the GIFT_AMT (Line 6).

S

40

RECOGNITION_TYPE4

char

1

The type of credit (recognition) that the donor RCG_EMPLID4 (Line 32) or RCG_EXT_ORG_ID4 (Line 36) is receiving for the gift or pledge. Must have a valid value from the AV_RCG_TYPE_TBL and the total of all RECOGNITION_TYPEs 1-4 (Lines 37-40) that are given a value of ‘H” for hard credit must equal 100% of the GIFT_AMT (Line 6).

S

41

RCG_PCT_AMT1

decimal

9

15

2

The amount of the gift that is to be recognized as coming from each of the Recognition IDs (Lines 29-36). The sum of the amounts entered in these four fields must equal the total gift amount (Line 6) for all IDs receiving recognition types equal to ‘H’ (hard credit). Soft credit (any that are not equal to ‘H’) can total any amount up to the gift amount (Line 6).

500.00

12000.00

42

RCG_PCT_AMT2

decimal

9

15

2

500.00

12000.00

43

RCG_PCT_AMT3

decimal

9

15

2

1000.00

44

RCG_PCT_AMT4

decimal

9

15

2

1000.00

45

ANONYMOUS_FLG1

char

1

Enter ‘Y” if the donor in RCG_EMPLID1 (Line 29) or RCG_EXT_ORG_ID1 (Line 33) desires no public acknowledgement of the gift or pledge.

Y

46

ANONYMOUS_FLG2

char

1

Enter ‘Y” if the donor in RCG_EMPLID2 (Line 30) or RCG_EXT_ORG_ID2 (Line 34) desires no public acknowledgement of the gift or pledge.

47

ANONYMOUS_FLG3

char

1

Enter ‘Y” if the donor in RCG_EMPLID3 (Line 31) or RCG_EXT_ORG_ID3 (Line 35) desires no public acknowledgement of the gift or pledge.

48

ANONYMOUS_FLG4

char

1

Enter ‘Y” if the donor in RCG_EMPLID4 (Line 32) or RCG_EXT_ORG_ID4 (Line 36) desires no public acknowledgement of the gift or pledge.

49

DESIGNATION1

char

11

The account or fund code to which the donor is giving the gift or making the pledge. A gift or pledge can be split across 1-4 accounts when processed through AVPGPLOA.

Note. A designation is valid only if it is current and has a setID that correlates to the corresponding set control value for record group AV02_GIFT for AV_DES_BU 1-4 (Lines 53-56).

MEDBLDG

MEDBLDG

50

DESIGNATION2

char

11

LIBRARY

51

DESIGNATION3

char

11

52

DESIGNATION4

char

11

53

AV_DES_BU1

char

5

The business unit that owns DESIGNATION1.

MEDBU

MEDBU

54

AV_DES_BU2

char

5

The business unit that owns DESIGNATION2.

PSUNV

55

AV_DES_BU3

char

5

The business unit that owns DESIGNATION3.

56

AV_DES_BU4

char

5

The business unit that owns DESIGNATION4.

57

INTV_CD1

char

10

The campaign that generated the gift or pledge to DESIGNATION1 (Line 49).

CMPGN2003

CMPGN2003

58

INTV_CD2

char

10

The campaign that generated the gift or pledge to DESIGNATION2 (Line 50).

CMPGN2003

59

INTV_CD3

char

10

The campaign that generated the gift or pledge to DESIGNATION3 (Line 51).

60

INTV_CD4

char

10

The campaign that generated the gift or pledge to DESIGNATION4 (Line 52).

61

DES_PCT_AMT1

decimal

9

15

2

The amount of the gift that is being distributed to each designation (Lines 49-52) The total of the amounts entered in these four fields must equal the total gift amount (Line 6).

500

12000

62

DES_PCT_AMT2

decimal

9

15

2

500

63

DES_PCT_AMT3

decimal

9

15

2

64

DES_PCT_AMT4

decimal

9

15

2

65

MOTIVATION_CD1

char

9

The appeal that generated the gift or pledge given to DESIGNATION1 (Line 49).

Note. An appeal is valid only if it is current and has a setID that correlates to the corresponding set control value for record group AV02_GIFT for AV_DES_BU 1-4 (Lines 53-56).

MEDICINE

MEDICINE

66

MOTIVATION_CD2

char

9

The appeal that generated the gift or pledge given to DESIGNATION2 (Line 50).

Note. An appeal is valid only if it is current and has a setID that correlates to the corresponding set control value for record group AV02_GIFT for AV_DES_BU 1-4 (Lines 53-56).

LIBRARY

67

MOTIVATION_CD3

char

9

The appeal that generated the gift or pledge given to DESIGNATION3 (Line 51).

Note. An appeal is valid only if it is current and has a setID that correlates to the corresponding set control value for record group AV02_GIFT for AV_DES_BU 1-4 (Lines 53-56).

68

MOTIVATION_CD4

char

9

The appeal that generated the gift or pledge given to DESIGNATION4 (Line 52).

Note. An appeal is valid only if it is current and has a setID that correlates to the corresponding set control value for record group AV02_GIFT for AV_DES_BU 1-4 (Lines 53-56).

69

CHARITABLE_AMT1

decimal

9

15

2

The amount of the gift to DESIGNATION 1-4 (Lines 49-52) that is considered charitable for tax purposes. This can be different than the GIFT_AMT, but a value must be entered here even if it is equal to the GIFT_AMT. The total of the amounts entered in these four fields cannot exceed the total gift amount (Line 6).

500

12000

70

CHARITABLE_AMT2

decimal

9

15

2

500

71

CHARITABLE_AMT3

decimal

9

15

2

72

CHARITABLE_AMT4

decimal

9

15

2

73

DESCR254

char

254

PROCESS GENERATED − Do not enter any values. Suspense Reason created by AVPGPLOA.

Leave blank

74

COMPLETE_FLAG

char

1

PROCESS GENERATED − Do not enter any values. Indicates if session has been processed by AVPGPLOA.

Leave blank

75

GP_LOAD_STATUS

char

1

PROCESS GENERATED − Do not enter any values. Indicates whether the gift or pledge was processed or suspended by AVPGPLOA.

Leave blank

76

SESSION_NO

char

11

PROCESS GENERATED − Do not enter any values. Session Number created by AVPGPLOA.

Leave blank

77

GIFT_NO

char

11

PROCESS GENERATED − Do not enter any values. Gift Number created by AVPGPLOA.

Leave blank