AV_ACK_PROCESS

(SQL Table)
 Index Back

Acknowledgement Process

This record records general Acknowledgement rules processing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: AV_OPR_DEF_TBL.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

2 DECEASED_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW

3 DEC_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

4 ANONYMOUS_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW

5 ADJ_GIFT_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

6 ADJ_GIFT_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW

7 ADJ_PLDG_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

8 ADJ_PLDG_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW

9 ADJ_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt

Y/N Table Edit

10 HNR_GIFT_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

11 HNR_GIFT_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW

12 HNR_PLDG_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

13 HNR_PLDG_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Purpose Code

Prompt Table: AV_PRPS_VW

14 HNR_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt

Y/N Table Edit

15 MEM_GIFT_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

16 MEM_GIFT_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW

17 MEM_PLDG_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: EVNT_3CS_TBL

18 MEM_PLDG_PRPS_CD Character(3) VARCHAR2(3) NOT NULL Purpose Code

Prompt Table: AV_PRPS_VW

19 MEM_RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt

Y/N Table Edit