PROCESS_INSTANCEINSTITUTIONGCLUB_CDEMPLIDEXT_ORG_IDFISCAL_YEARGCLUB_LVLGCLUB_AMTA=Accruing
D=Removed - Donor request
M=Member
R=Removed - Manually
X=Managed Member
AV_AVPGCLUB_TMP(SQL Table) |
Index Back |
|---|---|
Processed Giving Club MemberProcessed Giving Club Member - Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | GCLUB_CD |
Character(9) | VARCHAR2(9) NOT NULL | Giving Club Code |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 6 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 7 | GCLUB_LVL |
Character(9) | VARCHAR2(9) NOT NULL | Giving Club Level |
| 8 | GCLUB_AMT |
Number(16,2) | DECIMAL(15,2) NOT NULL | Giving Club Amount |
| 9 | GCLUB_MBR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Giving Club Status
A=Accruing D=Removed - Donor request M=Member R=Removed - Manually X=Managed Member |
| 10 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |