INSTALLATION_AV(SQL Table) |
Index Back |
|---|---|
Advancement Installation Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASGN_PRPS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Assigned Purpose Flag
A=All C=Class D=Defined Responsibilities Default Value: D |
| 2 | ASSET_NO | Number(10,0) | DECIMAL(10) NOT NULL |
Asset Nbr
Default Value: 0 |
| 3 | LAST_ACTN_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Action Nbr
Default Value: 0 |
| 4 | LAST_STRATEGY_NO | Number(10,0) | DECIMAL(10) NOT NULL |
Last Strategy Nbr
Default Value: 0 |
| 5 | RATING_NO | Number(10,0) | DECIMAL(10) NOT NULL |
Rating Nbr
Default Value: 0 |
| 6 | RQD_CNTC_RPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Contact Report Flag
Y/N Table Edit Default Value: Y |
| 7 | LAST_GIFT_NO | Number(11,0) | DECIMAL(11) NOT NULL |
Last Gift Nbr
Default Value: 0 |
| 8 | LAST_RELATE_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Relation Nbr
Default Value: 0 |
| 9 | LAST_SESS_NO | Number(11,0) | DECIMAL(11) NOT NULL |
Last Session Nbr
Default Value: 0 |
| 10 | DONOR_CRDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Donor Record |
| 11 | DONOR_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Donor's Percentage |
| 12 | DONOR2_CRDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Donor Record 2 |
| 13 | DONOR2_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Donor's Percentage 2 |
| 14 | SPOUSE_CRDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Spouse Record |
| 15 | SPOUSE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Spouse's Percentage |
| 16 | SPOUSE2_CRDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Spouse Record 2 |
| 17 | SPOUSE2_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Spouse's Percentage 2 |
| 18 | DEF_SOFT_CRDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Default Soft Credit Type |
| 19 | PMT_SCHD | Character(2) | VARCHAR2(2) NOT NULL |
Payment Schedule
A=Annual BM=Bi-Monthly I=Irregular M=Monthly Q=Quarterly SA=Semi-Annually W=Weekly |
| 20 | FEED_GIFT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Feed Gift
N=No Y=Yes Default Value: Y |
| 21 | FEED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Feed Pledge
N=No Y=Yes |
| 22 | ALLOW_PP_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Pldg Pmt Detail Override
Y/N Table Edit |
| 23 | LAST_PG_NBR | Number(9,0) | DECIMAL(9) NOT NULL | PGiving Nbr |
| 24 | VOL_GRP_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Group |
| 25 | VOL_STRCT_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Structure Nbr |
| 26 | LAST_INTV_ACTN_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Intv Action Nbr
Default Value: 0 |
| 27 | LAST_MBR_NBR | Number(11,0) | DECIMAL(11) NOT NULL | Membership Nbr |
| 28 | LAST_MBR_PMT_NO | Number(11,0) | DECIMAL(11) NOT NULL | Member Pmt Nbr |
| 29 | SECURITY_RUN | Character(1) | VARCHAR2(1) NOT NULL | Security Run |
| 30 | LAST_RECEIPT_NO | Number(12,0) | DECIMAL(12) NOT NULL | Last Receipt Number |
| 31 | AV_LAST_REF_NO | Number(12,0) | DECIMAL(12) NOT NULL | Last Reference Number |
| 32 | AV_PUB_SEC_FIN_REL | Character(3) | VARCHAR2(3) NOT NULL |
E&G Financials Release
1=Release 7.5 2=Release 8.4 or later 3=External System |