AV_PG_DETAIL

(SQL Table)
Index Back

Planned Giving Detail

Planned Giving Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 PG_REQUEST_DT Date(10) DATE Initial Request Date
4 PG_RESPONSE_DT Date(10) DATE Initial Response Date
5 PG_STATUS Character(1) VARCHAR2(1) NOT NULL PG Status
D=Donor
I=In Discussion
P=Prospect
R=Proposal Pending
S=Suspect
6 PG_MAILING_LIST Character(1) VARCHAR2(1) NOT NULL Include on PG Mailing List
N=No
Y=Yes

Default Value: N